Data Element Summary for PAYROLL-SUMMARY (U-103)
Type Level Field Name Format Length Compression
Option
Index
Primary identification data
  1 EMP-ID P 6.0 F  
  1 BASE27-EMP-NAME B 10.0 F  
  1 DATE-PAYROLL D   F  
  1 DATE-PAYROLL-INV P 5.0 F  
  1 PAYROLL-TYPE A 2.0 F  
  1 PAYROLL-CALENDAR-YR N 4.0    
  1 PAYROLL-ADJ-SEQ-NO N 1.0    
  1 PAYROLL-ADJ-NO P 7.0 N  
Gross, Net & payment data
PE 1 PAY-CATEGORY-GROUP        
  2 PAY-CATEGORY-CD A 1.0 N  
  2 CATEGORIZED-PAY-AMT P 6.2 N  
  1 NET-AMT P 6.2 F  
  1 YTD-GROSS-AMT P 7.2 N  
  1 CHECK-DISTRIBUTION-BU-NO N 4.0 N  
MU 1 PAYMENT-ID P 9.0 N U
Voucher data
PE 1 VOUCHER-GROUP        
  2 PAYROLL-VOUCHER-TYPE A 1.0 N  
  2 EMP-PAYROLL-VOUCHER-AMT P 6.2 N  
Benefit, Deduction, Other
taxable wage, Exempt wage & EIC
PE 1 BDOE-GROUP        
  2 BDOE-CD A 4.0 N  
  2 SHORT-COMMENT A 15.0 N  
  2 BDOE-SOURCE-CD A 1.0 N  
  2 BDOE-AMT P 6.2 N  
  2 DEDUCTION-NOT-TAKEN-AMT P 6.2 N  
  2 YTD-BDOE-AMT P 7.2 N  
Hours data
PE 1 HOURS-GROUP        
  2 PAYROLL-SUMMARY-HRS P 4.2 N  
Other descriptive data
  1 STUDENT-EMP-CD A 1.0 N  
  1 FEDERAL-EMP-CD A 1.0 N  
  1 ALIEN-EMP-CD A 4.0 N  
  1 CHECK-DISTRIBUTION-OVERRIDE-CD N 1.0 N  
  1 EMP-BENEFITS-12-OVER-9-CD A 1.0 N  
  1 EMP-PAY-FREQUENCY-CD A 1.0 N  
  1 EMP-BENEFITS-APPT-PCT P 3.0 N  
  1 EMP-BENEFITS-AGE P 3.0 N  
  1 EMP-BENEFITS-ANNUAL-SALARY P 6.0 N  
MU 1 PAYROLL-SUMMARY-ATTR A 4.0 N  
  1 PS-TEXT-ID A 16.0 N  
PE 1 BANK-ACCT-GROUP        
  2 BANK-CD A 4.0 N  
  2 ACCT-NO A 20.0 N  
  2 ACH-AMOUNT N 5.2 N  
  2 ACCT-TYPE A 1.0 N  
MU 1 COMMENT A 72.0 N  
Audit and control data
  1 TIME-STAMP B 8.0 N  
PE 1 AUDIT-LOG-GROUP        
  2 TIME-OF-UPDATE T   N  
  2 UPDATED-BY-USER A 8.0 N  
Access keys
SP 1 EMP-CY-DATE-TYPE-SEQ-KEY A 13.0   U
SP 1 ATTR-DATE-INV-B27-KEY A 17.0 N D
SP 1 CY-DATE-TYPE-B27-KEY A 18.0   D
SP 1 DATE-TYPE-BU-B27-KEY A 20.0 N D

Generated 12/17/21 16:50:10