Available Columns |
Description |
Date Range Available |
Chartable |
Can Edit |
Links to Page |
General Information
|
Company Name |
The name of the company |
|
|
|
Company |
Department |
The name of the department |
|
|
|
Department |
Employee Status |
The status of the employee
Examples: Active, inactive
|
|
|
|
|
Employee Title |
The job title of the employee |
|
|
|
|
Employee Type |
The employee type associated with the employee |
|
|
|
Employee Type |
Notes |
Any notes associated with the accrual |
|
|
X |
|
Pay Description |
The description of the accrual pay.
Examples: Vacation, sick, other, accrual
|
|
|
|
|
Pay Reduce At Year End |
Indicates the accrual pay reduces at the end of the year |
|
|
|
|
Pay Status |
The status of the pay |
|
|
|
|
People
|
Employee First Name |
The first name of the employee |
|
|
|
Employee |
Employee Last Name |
The last name of the employee |
|
|
|
Employee |
Employee Middle Name |
The middle name of the employee |
|
|
|
Employee |
Employee Name |
The full name of the employee |
|
|
|
Employee |
Supervisor |
The name of the supervisor of the employee |
|
|
|
Employee |
Dates
|
Accrual Start Date |
The date the accrual starts |
|
|
|
|
Pay Date |
The pay date associated with the accrual |
X |
|
|
|
Pay Reduce Date |
The date (m/d) the accrual pay is set to reduce |
X |
|
|
|
Transaction Date |
The date of the transaction associated with the accrual |
X |
|
|
|
Vendor Invoice End Date |
The end date used on the vendor invoice |
|
|
|
|
Vendor Invoice Start Date |
the start date used on the vendor invoice |
|
|
|
|
Hours/Units
|
Accrued |
The number of accrued hours for the pay date |
|
|
|
|
Available |
The number of available accrual hours |
|
|
X |
|
Pay Amount |
The amount the employee is paid |
|
|
|
|
Pay Limit |
The maximum number of accrual hours per year. |
|
|
|
|
Pay Reduce To |
The maximum number of accrued hours to carry over |
|
|
|
|
Total Accrued |
The total number of hours accrued for the employee |
|
|
|
|
Total Used |
The total number of used accrual hours for the employee
These hours are entered on the timesheet
|
|
|
|
|
Used |
The number of accrued hours for the pay date
These hours are entered on the timesheet
|
|
|
|
|
Keys
|
*Company Key |
The database identifier of the company associated with the employee |
|
|
|
|
Department Key |
The database identifier of the department associated with the employee |
|
|
|
|
Employee Key |
The database identifier of the employee |
|
|
|
|
Employee Type Key |
The database identifier of the employee type |
|
|
|
|
Pay Key |
The database identifier of the pay |
|
|
|
|
*Payroll Service Accruals Key |
The database identifier of the payroll service accrual |
|
|
|
|
Supervisor Key |
The database identifier of the supervisor associated with the employee |
|
|
|
|
*Vendor Invoice Key |
The database identifier of the vendor invoice |
|
|
|
|