| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | YDPAYD | Payroll ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 2 | YDPATY | Payroll Type | Character | UDC (07 PZ) | 1 | 0 | Allow NULL? |
| 3 | YDDEFINT | Default Interim ID | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 4 | YDPIPF | Interim Payments Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 5 | YDCHKDTOFF | Check Date Offset | Numeric | Generic Edit | 11 | 0 | Allow NULL? |
| 6 | YDPPST | Status - Pre payroll Processing | Character | UDC (07 PP) | 1 | 0 | Allow NULL? |
| 7 | YDCHKS | Status - Check | Character | UDC (07 CK) | 1 | 0 | Allow NULL? |
| 8 | YDCKAS | Check Attachment Status | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 9 | YDADEF | Status - Auto Deposit Processing | Character | UDC | 1 | 0 | Allow NULL? |
| 10 | YDADAS | Status - Auto Deposit Advice | Character | UDC (07 CK) | 1 | 0 | Allow NULL? |
| 11 | YDAATS | Auto Deposit Attachment Status | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 12 | YDJEST | Status - Payroll Journal Entries | Character | UDC (07 JE) | 1 | 0 | Allow NULL? |
| 13 | YDROST | Status - Reports Only | Character | UDC | 1 | 0 | Allow NULL? |
| 14 | YDFUST | Status - Final Update | Character | UDC (07 FV) | 1 | 0 | Allow NULL? |
| 15 | YDASF | Accelerated Submission Flag | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 16 | YDYST1 | Status- Payroll 01 | Character | UDC (07 YS) | 1 | 0 | Allow NULL? |
| 17 | YDTTGR | Total Gross | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 18 | YDTTNT | Total Net | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 19 | YDTTDE | Total Deductions | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 20 | YDTTHS | Total Hours | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 21 | YDNPYM | Number of Payments | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 22 | YDNCKS | Number of Checks | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 23 | YDNCIC | Number of Computer Interim Checks | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 24 | YDNMIC | Number of Manual Interim Checks | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 25 | YDNAUD | Number of Auto Deposits | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 26 | YDNVOI | Number of Voids | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 27 | YDTNEP | Total Number of Employees Paid | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 28 | YDPCCT | Pay Cycle Count | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 29 | YDVERS | Version History | String | Generic Edit | 10 | 0 | Allow NULL? |
| 30 | YDPCCD | Pay Cycle Code | String | UDC (06 PY) | 5 | 0 | Allow NULL? |
| 31 | YDDTEY | Date - YR | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 32 | YDPPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 | |
| 33 | YDEFTB | Date - Beginning Effective | Date | Generic Edit | 6 | 0 | |
| 34 | YDEFTE | Date - Ending Effective | Date | Generic Edit | 6 | 0 | |
| 35 | YDPPNB | Pay Period Number | String | Generic Edit | 3 | 0 | Allow NULL? |
| 36 | YDNMAX | Amount - Maximum Net Pay | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 37 | YDDNMN | Denomination Minimum | Numeric | Generic Edit | 7 | 2 | Allow NULL? |
| 38 | YDPPMB | Pay Period Number | Character | UDC (05 YB) | 1 | 0 | Allow NULL? |
| 39 | YDCCPR | Country Code | String | UDC (00 CN) | 3 | 0 | Allow NULL? |
| 40 | YDCCUF | Step Progression Automation | Character | UDC (07 JP) | 1 | 0 | Allow NULL? |
| 41 | YDWCUF | Workers Comp. Update Flag | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 42 | YDGPOR | Code - Group Plan Override | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 43 | YDODBA | Optional DBA Processing Flag | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 44 | YDPYMH | Method - Employee Payment | Character | UDC | 1 | 0 | Allow NULL? |
| 45 | YDADOF | Auto Deposit Override Flag | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 46 | YDADRF | Auto Deposit Reconcilation Flag | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 47 | YDWHRW | Standard Hours-Weekly | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 48 | YDBHRW | Standard Hours-Biweekly | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 49 | YDSHRW | Standard Hours-Semi | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 50 | YDMHRW | Standard Hours-Monthly | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 51 | YDOHRW | Standard Hours-Other | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 52 | YDPPM1 | Pay Period Number - Weekly | Character | UDC (05 PN) | 1 | 0 | Allow NULL? |
| 53 | YDPPM2 | Pay Period Number - Biweekly | Character | UDC (05 PN) | 1 | 0 | Allow NULL? |
| 54 | YDPPM3 | Pay Period Number - Semimonthly | Character | UDC (05 PN) | 1 | 0 | Allow NULL? |
| 55 | YDPPM4 | Pay Period Number - Monthly | Character | UDC (05 PN) | 1 | 0 | Allow NULL? |
| 56 | YDPPM5 | Pay Period Number - Annually | Character | UDC (05 PN) | 1 | 0 | Allow NULL? |
| 57 | YDPPM6 | Pay Period Number - Other | Character | UDC (05 PN) | 1 | 0 | Allow NULL? |
| 58 | YDCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 59 | YDCYGR | Pay Cycle Group Code | String | UDC (06 PG) | 2 | 0 | Allow NULL? |
| 60 | YDPCGT | Pay Cycle Group Type | Character | UDC (07 PH) | 1 | 0 | Allow NULL? |
| 61 | YDGLBA | G/L Bank Account | String | Generic Edit | 8 | 0 | Allow NULL? |
| 62 | YDJCTY | Payroll Expense Type | Character | UDC (07 PJ) | 1 | 0 | Allow NULL? |
| 63 | YDAGDT | Date - Payroll Journals | Date | Generic Edit | 6 | 0 | |
| 64 | YDACCF | Rate - Accrual Factor | Numeric | Generic Edit | 9 | 4 | Allow NULL? |
| 65 | YDVER9 | Payroll Voucher Batch 2 | String | Generic Edit | 10 | 0 | Allow NULL? |
| 66 | YDSEQC | Sequence Code | Character | UDC (07 SR) | 1 | 0 | Allow NULL? |
| 67 | YDICU | Batch Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 68 | YDPEF1 | Execution Flag 1 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 69 | YDADDT | Date - Auto Deposit | Date | Generic Edit | 6 | 0 | |
| 70 | YDCKDT | Date - Pay Check | Date | Generic Edit | 6 | 0 | |
| 71 | YDBCHK | Check Number - Beginning | String | Generic Edit | 8 | 0 | Allow NULL? |
| 72 | YDBADV | Beginning Advice Number | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 73 | YDMIPA | Merge Interim Payments | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 74 | YDCAUT | Create Auto Pay | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 75 | YDOVBA | Override Bank Account | String | Generic Edit | 8 | 0 | Allow NULL? |
| 76 | YDVICU | Payroll Voucher Batch Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 77 | YDARST | Wage Attachment Invoice Date | Character | UDC (07 WI) | 1 | 0 | Allow NULL? |
| 78 | YDCKPG | Check Program | String | Generic Edit | 10 | 0 | Allow NULL? |
| 79 | YDCKVE | Check Version | String | Generic Edit | 10 | 0 | Allow NULL? |
| 80 | YDCAPG | Check Attachment Program | String | Generic Edit | 10 | 0 | Allow NULL? |
| 81 | YDCAVE | Check Attachment Version | String | Generic Edit | 10 | 0 | Allow NULL? |
| 82 | YDCSNL | Check Stub Lines | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 83 | YDADPG | Auto Deposit Program | String | Generic Edit | 10 | 0 | Allow NULL? |
| 84 | YDADVE | Auto Deposit Version | String | Generic Edit | 10 | 0 | Allow NULL? |
| 85 | YDAAPG | Auto Deposit Advice Program | String | Generic Edit | 10 | 0 | Allow NULL? |
| 86 | YDAAVE | Auto Deposit Advice Version | String | Generic Edit | 10 | 0 | Allow NULL? |
| 87 | YDADNL | Auto Deposit Lines | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 88 | YDDAPG | Auto Deposit Attachment Program | String | Generic Edit | 10 | 0 | Allow NULL? |
| 89 | YDDAVE | Auto Deposit Attachment Version | String | Generic Edit | 10 | 0 | Allow NULL? |
| 90 | YDCTRY | Century | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 91 | YDLVBL | Leave Balance Rollover Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 92 | YDADPT | ADP Tax Service Status | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 93 | YDADPK | ADP Check Print Status | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 94 | YDPJVC | Payroll Journal Version Count | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 95 | YDUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 96 | YDUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 97 | YDPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 98 | YDJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 99 | YDUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
