PR5 P/R Check History File (PR5_CheckHistory) Level: 4.40 Record Type: 1 P/R Employee Quarterly Check History 08/28/2009 File Type: Direct Key Size: 23 Rec Len: 186 Min Len: 23 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Department Number . . . . . . . . . . . Department. . . . . . . . . . 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. . . . . . . . . NonprintedCheckBlankMD. . . . String *(22,1) Sequence Number (Blank,0-9) . . . . . . SeqNumber . . . . . . . . . . String *(23,1) 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, & Employee Sui Withheld . . SDILocalEmplSuiWH . . . . . . 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 Direct Deposit Amount . . . . . . . . . DirectDepAmount . . . . . . . Number [10] 7.2 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [11] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [12] 0. ________ Total Bytes 155