Adjusted LOS |
Employee's Length of Service Based on their Adjusted Start Date for the selected snapshot month. |
By SnapShot_Month |
LOS |
Employee's length of service in years, based on the difference between the employee's start date and the snapshot month or effective from. Length of service is the number of years an employee has been working for an organization. |
By SnapShot_Month |
Seniority LOS |
Employee's length of lervice based on the difference between their seniority date and the snapshot month seniority LOS is the length of time an employee has been employed, starting from their most recent date of hire. |
By SnapShot_Month |
Time in Job |
Time in years since assigned job code. |
By SnapShot_Month |
Annual Rate Base - Avg |
Average annual base rate of employee's work assignment for selected period. |
By SnapShot_Month |
Annual Rate Base - Max |
Maximum annual rate base of the employee's work assignment for selected period. |
By SnapShot_Month |
Annual Rate Base - Sum |
Sum annual rate base of the employee's work assignment for selected period. |
By SnapShot_Month |
Annual Rate Base - Min |
Minimum annual rate base of the employee's work assignment for selected period. |
By SnapShot_Month |
Annual Rate Base Change |
A 1 for every change done to annual rate base of employee's work assignment for selected period. |
By Effective From |
From Annual Rate Base - Avg |
Prior average annual rate base of employee's work assignment for selected period. |
By Effective From |
From Annual Rate Base - Max |
Prior maximum annual rate base of employee's work assignment for selected period. |
By Effective From |
From Annual Rate Base - Min |
Prior minimum annual rate base of employee's work assignment for selected period. |
By Effective From |
From Annual Rate Base - Sum |
Prior sum annual rate base of employee's work assignment for selected period. |
By Effective From |
To Annual Rate Base - Avg |
Current or updated average annual rate base of employee's work assignment for selected period. |
By Effective From |
To Annual Rate Base - Max |
Current or updated maximum annual rate base of employee's work assignment for selected period. |
By Effective From |
To Annual Rate Base - Min |
Current or updated minimum annual rate base of employee's work assignment for selected period. |
By Effective From |
To Annual Rate Base - Sum |
Current/updated minimum annual rate base of employee's work assignment for selected period. |
By Effective From |
Annual Rate - Avg |
Average annual rate of employee's work assignment for selected period. |
By SnapShot_Month |
Annual Rate - Max |
Maximum annual rate of the employee's work assignment for selected period. |
By SnapShot_Month |
Annual Rate - Sum |
Sum annual rate of the employee's work assignment for selected period. |
By SnapShot_Month |
Annual Rate - Min |
Minimum annual rate of the employee's work assignment for selected period. |
By SnapShot_Month |
Annual Rate Change |
A 1 for every change done to annual rate of employee's work assignment for selected period. |
By Effective From |
From Annual Rate - Avg |
Prior average annual rate of employee's work assignment for selected period. |
By Effective From |
From Annual Rate - Max |
Prior maximum annual rate of employee's work assignment for selected period. |
By Effective From |
From Annual Rate - Min |
Prior minimum annual rate of employee's work assignment for selected period. |
By Effective From |
From Annual Rate - Sum |
Prior sum annual rate of employee's work assignment for selected period. |
By Effective From |
To Annual Rate - Avg |
Current or updated average annual rate of employee's work assignment for selected period. |
By Effective From |
To Annual Rate - Max |
Current or updated maximum annual rate of employee's work assignment for selected period |
By Effective From |
To Annual Rate - Min |
Current or updated minimum annual rate of employee's work assignment for selected period. |
By Effective From |
To Annual Rate - Sum |
Current or updated sum annual rate of employee's work assignment for selected period |
By Effective From |
Count distinct |
|
By Load Date |
Count |
|
By Load Date |
Count distinct |
|
By Effective From |
Count |
|
By Effective From |
Count distinct |
|
By Employee Effective From |
Count |
|
By Employee Effective From |
Count distinct |
|
By WA Effective From |
Count |
|
By WA Effective From |
Count distinct |
|
By Complete Date |
Count |
|
By Complete Date |
Count distinct |
|
By Employee Effective To |
Count |
|
By Employee Effective To |
Count distinct |
|
By Effective To |
Count |
|
By Effective To |
Count distinct |
|
By Candidate Create Stamp |
Count |
|
By Candidate Create Stamp |
Count distinct |
|
By Assigned Date |
|
|
By Assigned Date |
Count distinct |
|
By SnapShot_Month |
|
|
By SnapShot_Month |
Count distinct |
|
By Pay Period Date Range End |
Count |
|
By Pay Period Date Range End |
Count distinct |
|
By Time Record Date |
Count |
|
By Time Record Date |
Count distinct |
|
By Check Date |
Count |
|
By Check Date |
Count distinct |
|
By Pay Period End Date |
Count |
|
By Pay Period End Date |
Full Time Annual Rate - Avg |
Average full time annual rate of employee's work assignment for selected period. |
By Effective From |
Full Time Annual Rate - Max |
Maximum full time annual rate of employee's work assignment for selected period. |
By Effective From |
Full Time Annual Rate - Min |
Minimum full time annual rate of employee's work assignment for selected period. |
By Effective From |
Full Time Annual Rate - Sum |
Minimum full time annual rate of employee's work assignment for selected period. |
By Effective From |
Full Time Annual Rate Base - Avg |
Average full time annual rate base of employee's work assignment for selected period. |
By Effective From |
Full Time Annual Rate Base - Max |
Maximum full time annual rate base of employee's work assignment for selected period. |
By Effective From |
Full Time Annual Rate Base - Min |
Minimum full time annual rate base of employee's work assignment for selected period. |
By Effective From |
Full Time Annual Rate Base - Sum |
Sum of the full-time annual rate base of employee's work assignment for selected period. |
By Effective From |
Count Distinct |
|
By SnapShot_Month |
Count |
|
By SnapShot_Month |
Sum |
|
By SnapShot_Month |
Avg |
|
By SnapShot_Month |
Hourly Rate - Avg |
Average hourly rate base of employee's work assignment for selected period. |
By SnapShot_Month |
Hourly Rate - Max |
Maximum hourly rate base of employee's work assignment for selected period. |
By SnapShot_Month |
Hourly Rate - Min |
Minimum hourly rate base of employee's work assignment for selected period. |
By SnapShot_Month |
Hourly Rate - Sum |
Sum of the hourly rate base of employee's work assignment for selected period. |
By SnapShot_Month |
Hourly Rate Change - Sum |
Number of changes in hourly rate base of employee's work assignment for selected period. |
By Effective From |
From Hourly Rate - Avg |
Prior average hourly rate base of employee's work assignment for selected period. |
By Effective From |
From Hourly Rate - Max |
Prior maximum hourly rate base of employee's work assignment for selected period. |
By Effective From |
From Hourly Rate - Min |
Prior minimum hourly rate base of employee's work assignment for selected period. |
By Effective From |
From Hourly Rate - Sum |
Prior sum hourly rate base of employee's work assignment for selected period. |
By Effective From |
To Hourly Rate - Avg |
Current/updated average hourly rate base of employee's work assignment for selected period. |
By Effective From |
To Hourly Rate - Max |
Current/updated maximum hourly rate base of employee's work assignment for selected period. |
By Effective From |
To Hourly Rate - Min |
Current/updated minimum hourly rate base of employee's work assignment for selected period. |
By Effective From |
To Hourly Rate - Sum |
Current/updated sum hourly rate base of employee's work assignment for selected period. |
By Effective From |
Monthly Rate - Avg |
Average monthly rate base of employee's work assignment for selected period. |
By SnapShot_Month |
Monthly Rate - Min |
Minimum monthly rate base of employee's work assignment for selected period. |
By SnapShot_Month |
Monthly Rate - Max |
Maximum monthly rate base of employee's work assignment for selected period. |
By SnapShot_Month |
Monthly Rate - Sum |
Sum of the monthly rate base of employee's work assignment for selected period. |
By SnapShot_Month |
Monthly Rate Change - Sum |
Number of changes in monthly rate base of employee's work assignment for selected period. |
By Effective From |
From Monthly Rate - Avg |
Prior average monthly rate base of employee's work assignment for selected period. |
By Effective From |
From Monthly Rate - Max |
Prior maximum monthly rate base of employee's work assignment for selected period. |
By Effective From |
From Monthly Rate - Min |
Prior minimum monthly rate base of employee's work assignment for selected period. |
By Effective From |
From Monthly Rate - Sum |
Prior sum monthly rate base of employee's work assignment for selected period. |
By Effective From |
To Monthly Rate - Avg |
Current/updated average monthly rate base of employee's work assignment for selected period. |
By Effective From |
To Monthly Rate - Max |
Current/updated maximum monthly rate base of employee's work assignment for selected period. |
By Effective From |
To Monthly Rate - Min |
Current/updated minimum monthly rate base of employee's work assignment for selected period. |
By Effective From |
To Monthly Rate - Sum |
Current/updated sum monthly rate base of employee's work assignment for selected period. |
By Effective From |
Weekly Rate - Avg |
Average weekly rate of employee's work assignment for selected period. |
By SnapShot_Month |
Weekly Rate - Max |
Maximum weekly rate of employee's work assignment for selected period. |
By SnapShot_Month |
Weekly Rate - Min |
Minimum weekly rate of employee's work assignment for selected period. |
By SnapShot_Month |
Weekly Rate Change - Sum |
Number of changes in weekly pay rate of employee's work assignment for selected period. |
By Effective From |
From Weekly Rate - Avg |
Prior average weekly rate base of employee's work assignment for selected period. |
By Effective From |
From Weekly Rate - Max |
Prior maximum weekly rate base of employee's work assignment for selected period. |
By Effective From |
From Weekly Rate - Min |
Prior minimum weekly rate base of employee's work assignment for selected period. |
By Effective From` |
From Weekly Rate - Sum |
Prior sum weekly rate base of employee's work assignment for selected period. |
By Effective From |
To Weekly Rate - Avg |
Current/updated average weekly rate base of employee's work assignment for selected period. |
By Effective From |
To Weekly Rate - Max |
Current/updated maximum weekly rate base of employee's work assignment for selected period. |
By Effective From |
To Weekly Rate - Min |
Current/updated minimum weekly rate base of employee's work assignment for selected period. |
By Effective From |
To Weekly Rate - Sum |
Current/updated sum weekly rate base of employee's work assignment for selected period. |
By Effective From |
Pay Rate - Avg |
Average pay rate of the employee of employee's work assignment for selected period. |
By Effective From |
Pay Rate - Max |
Maximum pay rate of the employee of employee's work assignment for selected period. |
By Effective From |
Pay Rate - Min |
Minimum pay rate of the employee of employee's work assignment for selected period. |
By Effective From |
Pay Rate - Sum |
Sum of the pay rate of the employee of employee's work assignment for selected period. |
By Effective From |
Total Pay Rate - Avg |
Average total pay rate of employee's work assignment for selected period. |
By Effective From |
Total Pay Rate - Max |
Maximum total pay rate of employee's work assignment for selected period. |
By Effective From |
Total Pay Rate - Min |
Minimum total pay rate of employee's work assignment for selected period. |
By Effective From |
Total Pay Rate - Sum |
Sum total pay rate of employee's work assignment for selected period. |
By Effective From |
Total Annual Pay Rate - Avg |
Average of the total annual pay rate of employee's work assignment for selected period. |
By Effective From |
Total Annual Pay Rate - Max |
Maximum of the total annual pay rate of employee's work assignment for selected period. |
By Effective From |
Total Annual Pay Rate - Min |
Minimum of the total annual pay rate of employee's work assignment for selected period. |
By Effective From |
Total Annual Pay Rate - Sum |
Sum of the total annual pay rate of employee's work assignment for selected period. |
By Effective From |
Pay Period Rate Avg |
Average period pay rate of the employee of employee's work assignment for a selected period. |
By SnapShot_Month |
Pay Period Rate - Max |
Maximum pay period rate of the employee of employee's work assignment for selected period. |
By SnapShot_Month |
Pay Period Rate - Min |
Minimum pay period rate of the employee of employee's work assignment for selected period. |
By SnapShot_Month |
Pay Period Rate - Sum |
Sum of the pay period rate of the employee of employee's work assignment for selected period. |
By SnapShot_Month |
Pay Zone - Sum |
Sum of pay zone of the employee of salary structure. |
By Salary Structure Version Date |
Max Pay Zone - Sum |
Sum of the max pay zone of salary structure. |
By Salary Structure Version Date |
Min Pay Zone - Sum |
Sum of minimum pay zone of salary structure. |
By Salary Structure Version Date |