|
|
|
|
|
|
|
Contents
|
|
Data Category |
Description |
|
NALPHAKEY |
Employee name key. |
|
Name |
Employee name. |
|
Federal ID |
Employee Social Security Number. |
|
Hours |
This is based upon the check date between the selection criteria from and to dates. The total number of work hours: Table: HPAHDP-HIST-PAY Field: WA-HPAHDP-WORK-HOURS Minus Total sick leave hours used: Table: HTOTRN-TRANS Field: HOTTRN-HRS Only those sick leave records where group code of 1, LTD type is N, and time off transaction type is U (used) are selected. Minus Total unpaid leave hours: Table: HTOTRN-TRANS Field: HOTTRN-HRS Only those unpaid leave records where LTD type is N and time off transaction type is L (unpaid) are selected. Example 1: Sum of Work Hours = 160 Sum of Sick Leave Hours Used = 24 Sum of Unpaid Leave Hours = 8 (160 &endash; 24 &endash; 8) = 128 Example 2: Sum of Work Hours = 60.5 Sum of Sick Leave Hours Used = 3 Sum of Unpaid Leave Hours = 0 (60.5 &endash; 3) = 57.5 Rounded to 58 |
|
Wages |
Total gross wages between from and to dates in the selection criteria. Table: HPAHDC-HIST-CHK Field: HPAHDC-GRS-GRS |
|
(-) Sick Pay |
Sick pay is calculated. Hourly Wage: Table: WA001Profile Field: HourlyWage Multiplied By: Total Sick Leave Hours Used See information listed above in Hours description. Example: Hourly Wage = 26.75 Sum of Sick Leave Hours Used = 9 Sick Pay = 240.75 |
|
(+) Taxable Benefits |
This is based upon the check date between the selection criteria from and to dates. The value in this field can be negative. Benefit Codes that have the Include in UC Wages box checked are used in this calculation. The TaxB+ benefit code is one example. The sum of the applicable benefit amounts is compared to the sum of gross wages. Benefit Amounts: Table: HPAHDF-HIST-BEN Field: HPADCF-NET-DED-BEN Gross Wages: See information listed above in Wages description. If the sum of Other Taxable Benefits is greater than or equal to 25% of the sum of gross wages for the selected date range, then the value in this field is the sum of Other Taxable Benefits. The value in this field is typically zero. |
|
(=) Reportable Wages |
This is based upon the check date between the selection criteria from and to dates. Sum of gross wages minus sick pay plus taxable benefits. |
|
(-) Excess Wages |
This is based upon the check date between the selection criteria from and to dates. Amount of Reportable Wages over the Unemployment Maximum Wage for the reporting calendar year. The sum of reportable wages minus the sum of unemployment gross. Reportable Wages: See information listed above in Reportable Wages description. Unemployment Gross: Table: HPAHDC-HIST-CHK Field: HPAHDC-UC-GRS |
|
(=) Taxable Wages |
This is based upon the check date between the selection criteria from and to dates. Taxable Wages equals Reportable Wages minus Excess Wages. See information listed above in Reportable Wages and Excess Wages description. |
Page Updated 3/08