|
|
|
|
|
|
|
Contents |
The following fields are used in this report:
|
Field Name |
Description or path to data field |
Table/ field ID |
|
Name Key |
Assigned by the system and not updateable. The system assigns a new Nalphakey if an employee's name is updated/changed: Human Resources / Profile / Personnel tab / Edit |
Name.Nalphakey |
|
Name |
Human Resources / Profile / + Add or Edit |
Name.Last-Name Name.First-Name Name.Middle-Name |
|
Check Location |
Check location for employee: Human Resources / Profile / General tab / Add or Edit |
HAAPRO-PROFILE.HPADCL-CHK-LOC-CODE |
|
Check Location Description |
Description of the employee's check location: Human Resources / Profile / General tab / Add or Edit |
HPADCL-LOC-CODES. HPADCL-SDESC of the hpadcl-chk-loc-code of the HAAPRO-PROFILE |
|
Group Number (of the Group Setup) |
Time off Group Code of the groups set up for the employee: Human Resources / Profile / Timeoff tab / Group |
HTODGR-GROUP-SETUP. HTODGR-GRP-CODE of the htoemg-group-setup |
|
Group Description |
The description of the employee's Time Off Group Code: Human Resources / Profile / Timeoff tab / Group |
HTODGR-GROUP-CODES. HTODGR-DESC of the HTOEMG-GROUP-SETUP of the haapro-profile |
|
Time Off Code Description |
The description of the employee's Time Off Code: Human Resources / Profile / Timeoff tab / Group |
HTODCD-TOF-CODES.HTODCD-DESC of HTOEMP-SETUP.HTODCD-TOF-CODE of HAAPRO-PROFILE |
|
Current Amount Left |
Current balance of the Time Off Code for the employee as of the date and time the report is created. |
Calculated |
|
Calendar Year |
The year value selected on the Leave Sale Report Parameters screen is displayed in the calendar year column heading. |
Selected |
|
Calendar Year Amount Left |
Same as Current Amount Left, but calculated as of 12/31 of the year value selected on the Leave Sale Report Parameters screen. |
Current Amount Left, calculated as of 12/31. |
|
Calendar Year Allocated |
Example: If the year 2004 is selected, then the calculation looks at transactions for the entire year between 01/01 and 12/31.
|
Calculated |
|
Calendar Year Used |
Example: If the year 2004 is selected, then the calculation looks at transactions for the entire year between 01/01 and 12/31.
|
Calculated |
|
Calendar Year Un-Used |
The difference between Calendar Year Allocated and Calendar Year used. |
Calendar Year Allocated - Calendar Year Used. |
|
Minimum Required |
The minimum required hours for a leave sale. |
HTODCD-TOF-CODES. HTODCD-TOF-MINIMUM-BALANCE |
|
Sale Ratio |
The ratio of sick leave hours to pay. |
N/A |
|
Primary Hourly Rate |
-- Or--
|
Calculated |
|
Annual Buyback Hours |
Eligible Buyback hours for the employee for the Time off code. |
Calculated |
|
Annual Buyback $$ |
Annual Buyback Hours x Primary Rate = Dollar value of leave sale for the Time Off code for the employee. |
Calculated |
|
Cashout Hours |
Current Amount Left x Sale Ratio = Eligible Cashout hours for the Time Off code for the employee. |
Calculated |
|
Cashout $$ |
Cashout Hours x Primary Rate = Dollar value of leave sale for the Time Off code for the employee. |
Calculated |
|
Group Recalculation |
An hours and dollar cost across all Time Off Codes in the Group. The recalculation adds all allocations, less amounts used. |
Calculated |
|
Employee Group Total |
The sum of Employee Group Totals. |
Calculated |
|
Total Annual Buyback Contingency |
The sum of all Group Recalculate Annual Buyback dollar amounts. |
Calculated |
|
Total Cashout Contingency |
The sum of all Group Recalculate Cashout dollar amounts. |
Calculated |
Page Updated 10/05
1,274 total annual hours = 28.26 primary hourly rate).