Temporary Assignments Historical and Current

Description

Lists all temporary assignments started between two selected dates and determines the number of extensions as well as the overall length of the temporary assignment in months.

Data Product Type

Report

Product Active Date

August 2018

Variables / Column Headers

Parameters: Business Unit, TA’s That Start Between [dates] And [dates]

Name, EMPLID, EMPL RCD, TA Start Date, Seq, Action, TA Reason Code, TA Reason Descr, Staffing Type, Extension Count, TA Return of End Date, TA Return or End Seq, TA Return or End Action, TA Return of End Reason, TA Months, Current or Historical, New Business Unit, New Business Unit Core or Non Core, New Business Unit Public Service, New Dept ID, New Dept ID Desc, New Job Code, New Job Code Desc, New Func Code, New Position, New Position Title, New Reports To, New Sal Admin Plan, New Grade, New Step, New Std Hours, New Hrly Rate, New Bi Weekly Rate, New Annual Rate, New Max Hrly Rate, Prior Business Unit, Prior Business Unit Core or Non Core, Prior Business Unit Public Service, Prior Dept ID, Prior Dept ID Desc, Prior Job Code, Prior Job Code Desc, Prior Func Code, Prior Position, Prior Position Title, Prior Reports To, Prior Sal Admin Plan, Prior Grade, Prior Step, Prior Std Hours, Prior Bi Weekly Rate, Prior Annual Rate, Prior Max Hrly Rate

Parameters: TAs That Start Between [date] and [date], Organization, Program

Name, EMPLID EMPL RCD, TA Start Date, Seq, Action, Reason Code, Reason Descr, Staffing Type, Extension Count, TA Return or End Date, TA Return of End Seq, TA Return or End Reason, TA Months, Current or Historical, New Business Unit, New Business Unit Core or Non Core, New Business Unit Public Service, New Organization, New Program, New Program Branch, New Dept ID, New Dept ID Desc, New Job Code, New Job Code Desc, New Func Code, New Position, New Position Title, New Reports To, New Sal Admin Plan, New Grade, New Step, New Std Hours, New Hrly Rate, New Bi Weekly Rate, New Annual Rate, New Max Hrly Rate, Prior Business Unit, Prior Business Unit Core or Non Core, Prior Business Unit Public Service, Prior Organization, Prior Program, Prior Program Branch, Prior Dept ID, Prior Dept ID Desc, Prior Job Code, Prior Job Code Desc, Prior Func Code, Prior Position, Prior Position Title, Prior Reports To, Prior Sal Admin Plan, Prior Grade, Prior Step, Prior Std Hours, Prior Hrly Rate, Prior Bi Weekly Rate, Prior Annual Rate, Prior Max Hrly Rate

User Access Route

HR Analytics

Data Product Link (for approved users)

Reporting Services - HistoricTAs Business Unit

Reporting Services - HistoricTAs_ORG Organization

HR Analytics Quick Access Group

Strategic HR

Intended Users

Ministry HR

Select BCPSA staff where required by role

Program Area Authorization For User Access

Ministry HR

BCPSA staff: user’s own program area

Access Authorization From Role(s)

Ministry HR Executive Director

BCPSA staff require user’s own Executive Director sign off and Chief Data Officer approval

Data Access Agreement Required?

yes

Keywords / Tags

temporary assignment, TA, historic

Notes for Product Users

Change Log for Product Users

Updated May 11, 2021 to include temporary assignments out of selected organization/programs.