Staff Data for Telework Data Collection
- Claire Miller
- Sarah Miles
- Shylo S
Title | Staff Data for Telework Data Collection |
|---|---|
Description | Provides employee data in support of the telework agreement data collection process. |
Data Product Type | Report |
Product Active Date | July 2021 |
Variables / Column Headers | Parameters: Report Date, Organization, Program FIRST NAME, LAST NAME, EMPLID EMPL RCD, DEPTID, DEPTID DESCR, Latest application Status, Telework City, Days In Office, Days Teleworking, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Data Collection Date, Telework Agreement Active, CHIPS Work Address1, CHIPS Work Address2, CHIPS Work Address3, CHIPS Work Postal, CHIPS Work City, EMAILID, Empl Status, Layoff Leave Stop Pay Start Date, Layoff Leave Stop Pay Reason, Future Return Date, Appt Status, Jobcode, Jobcode DESCR, Salary Admin Plan, Job Func, Public Service Act, Position, Position Title, Base Position, Reports To, SUPERVISOR, SUPERV EMAIL, Organization, Program, Program Division, Program Branch, Business Unit Description, As Of Date, Telework Start Date, Expired, Number of Months Old |
User Access Route | HR Analytics |
Data Product Link (for approved users) | |
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: user’s own program area |
Access Authorization From Role(s) | Ministry HR Executive Director BCPSA staff: user’s Executive Director and Chief Data Officer approval |
Data Access Agreement Required? | yes |
Keywords / Tags | telework |
Notes for Product Users | A telework agreement is valid for one year, meaning the employee may work from home under a telework agreement for one year. The “Telework Start Date” of the agreement should be used as the anniversary date. |
Change Log for Product Users | February 25, 2025: Report logic updated so if a report is run for an Report Date in the past, the it will reflect the telework status information as of that date. Prior to this change, the report displayed telework status information as of the current date, regardless of what Report Date was selected. New column “Expired” added to flag if an agreement is more than 12 months old. When implemented, this column calculated the 12 month period based on the Data Collection Date field. March 25, 2025: The “Expired” column was updated to calculate the 12 month period based on the “Telework Start Date” field, rather than the “Data Collection Date” field. “Telework Start Date” and “Number of Months Old” columns added to provide additional information on telework agreement expiration. |