PR_99 P/R Employee Master Audit Detail File (PR_99EmployeeMasterAudit) Level: 4.40 Record Type: 1 Employee Master Audit Detail Record 08/28/2009 File Type: Direct Key Size: 14 Rec Len: 156 Min Len: 141 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
User Code . . . . . . . . . . . . . . . UserCode. . . . . . . . . . . Uppercase *(1,3) Date. . . . . . . . . . . . . . . . . . Date. . . . . . . . . . . . . Date *(4,6) Sequence. . . . . . . . . . . . . . . . Seq . . . . . . . . . . . . . String *(10,5) "PR". . . . . . . . . . . . . . . . . . Pr. . . . . . . . . . . . . . Uppercase (15,2) Department Number . . . . . . . . . . . Dept. . . . . . . . . . . . . Zero-Filled (17,2) Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account (19,7) Employee Last Name. . . . . . . . . . . EmployeeLastName. . . . . . . String (26,15) Employee First Name . . . . . . . . . . EmployeeFirstName . . . . . . String (41,15) Audit Transaction Type. . . . . . . . . AuditTransType. . . . . . . . Uppercase (56,7) Field Name. . . . . . . . . . . . . . . FieldName . . . . . . . . . . String (63,19) Original Field Value. . . . . . . . . . OriginalFieldValue. . . . . . String (82,30) New Field Value . . . . . . . . . . . . NewFieldValue . . . . . . . . String (112,30) ________ Total Bytes 143