PR_22 P/R Perpetual History Header File (PR_22PerpetChkHistoryHeader) Level: 4.40 Record Type: 1 P/R Perpetual History Header Record 08/28/2009 File Type: Direct Key Size: 23 Rec Len: 394 Min Len: 125 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Department Number . . . . . . . . . . . Dept. . . . . . . . . . . . . Zero-Filled *(1,2) Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account *(3,7) Check Date. . . . . . . . . . . . . . . CheckDate . . . . . . . . . . Date *(10,6) Check Number. . . . . . . . . . . . . . CheckNumber . . . . . . . . . String *(16,6) M If Non-Printed Check. . . . . . . . . MIfNonprintedCheck. . . . . . String *(22,1) Sequence Number (blank,0 - 9) . . . . . SeqNumber . . . . . . . . . . String *(23,1) Bank Code . . . . . . . . . . . . . . . BankCode. . . . . . . . . . . String (24,1) Pay Cycle . . . . . . . . . . . . . . . PayCycle. . . . . . . . . . . String (25,1) Period End Date . . . . . . . . . . . . PeriodEndDate . . . . . . . . Date (26,6) Deduction Period. . . . . . . . . . . . DeductionPeriod . . . . . . . String (32,1) Batch Number. . . . . . . . . . . . . . BatchNumber . . . . . . . . . String (33,6) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (39,86) Gross Wages This Check. . . . . . . . . GrossWagesThisCheck . . . . . Number [0] 7.2 Federal Withholding Tax . . . . . . . . FederalWithholdingTax . . . . Number [1] 7.2 Fica Withheld . . . . . . . . . . . . . FicaWithheld. . . . . . . . . Number [2] 7.2 State Witholding. . . . . . . . . . . . StateWitholding . . . . . . . Number [3] 7.2 Sdi & Local Withholdings. . . . . . . . SDIAndLocalWithholdings . . . Number [4] 7.2 Other Deductions. . . . . . . . . . . . OtherDeductions . . . . . . . Number [5] 7.2 Check Amount. . . . . . . . . . . . . . CheckAmount . . . . . . . . . Number [6] 7.2 Regular Hours . . . . . . . . . . . . . RegularHours. . . . . . . . . Number [7] 5.2 Overtime Hours. . . . . . . . . . . . . OvertimeHours . . . . . . . . Number [8] 5.2 Medicare Withheld . . . . . . . . . . . MedicareWithheld. . . . . . . Number [9] 7.2 No Days Worked In Pay Period. . . . . . NumberDaysWorkedInPayPeriod . Number [10] 3.0 No Weeks Worked In Pay Period . . . . . NumberWeeksWorkedInPayPeriod. Number [11] 3.0 Total Earnings Hours. . . . . . . . . . TotalEarningsHours. . . . . . Number [12] 5.2 Total Taxes . . . . . . . . . . . . . . TotalTaxes. . . . . . . . . . Number [13] 8.2 Total Tips. . . . . . . . . . . . . . . TotalTips . . . . . . . . . . Number [14] 7.2 Exempt Tips . . . . . . . . . . . . . . ExemptTips. . . . . . . . . . Number [15] 7.2 "X" Wages . . . . . . . . . . . . . . . XWages. . . . . . . . . . . . Number [16] 8.2 "X" Hours . . . . . . . . . . . . . . . XHours. . . . . . . . . . . . Number [17] 8.2 Total Regular Earnings. . . . . . . . . TotalRegularEarnings. . . . . Number [18] 8.2 Total Net Deductions. . . . . . . . . . TotalNetDeductions. . . . . . Number [19] 8.2 Hours Accrued (Vacation). . . . . . . . HoursAccruedVacation. . . . . Number [20] 3.2 Hours Accrued (Sick). . . . . . . . . . HoursAccruedSick. . . . . . . Number [21] 3.2 Hours Accrued (Third Benefit Type). . . HoursAccruedBenefit3. . . . . Number [22] 3.2 Direct Deposit Amount . . . . . . . . . DirectDepAmount . . . . . . . Number [23] 8.2 ________ Total Bytes 390