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