| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | YDPRID | Payroll ID | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 2 | YDVERS | Version History | String | Generic Edit | 10 | 0 | Allow NULL? |
| 3 | YDPCCD | Pay Cycle Code | String | UDC (06 PY) | 5 | 0 | Allow NULL? |
| 4 | YDDTEY | Date - YR | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 5 | YDCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 6 | YDPPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 | |
| 7 | YDPCTC | Pay Categories/DBA Print Group | Character | UDC (06 ST) | 1 | 0 | Allow NULL? |
| 8 | YDJCTY | Payroll Expense Type | Character | UDC (07 PJ) | 1 | 0 | Allow NULL? |
| 9 | YDEFTB | Date - Beginning Effective | Date | Generic Edit | 6 | 0 | |
| 10 | YDEFTE | Date - Ending Effective | Date | Generic Edit | 6 | 0 | |
| 11 | YDCKDT | Date - Pay Check | Date | Generic Edit | 6 | 0 | |
| 12 | YDAGDT | Date - Payroll Journals | Date | Generic Edit | 6 | 0 | |
| 13 | YDGLBA | G/L Bank Account | String | Generic Edit | 8 | 0 | Allow NULL? |
| 14 | YDCYGR | Pay Cycle Group Code | String | UDC (06 PG) | 2 | 0 | Allow NULL? |
| 15 | YDWHRW | Standard Hours-Weekly | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 16 | YDBHRW | Standard Hours-Biweekly | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 17 | YDSHRW | Standard Hours-Semi | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 18 | YDMHRW | Standard Hours-Monthly | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 19 | YDAHRW | Standard Hours-Annually | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 20 | YDOHRW | Standard Hours-Other | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 21 | YDPPM1 | Pay Period Number - Weekly | Character | UDC (05 PN) | 1 | 0 | Allow NULL? |
| 22 | YDPPM2 | Pay Period Number - Biweekly | Character | UDC (05 PN) | 1 | 0 | Allow NULL? |
| 23 | YDPPM3 | Pay Period Number - Semimonthly | Character | UDC (05 PN) | 1 | 0 | Allow NULL? |
| 24 | YDPPM4 | Pay Period Number - Monthly | Character | UDC (05 PN) | 1 | 0 | Allow NULL? |
| 25 | YDPPM5 | Pay Period Number - Annually | Character | UDC (05 PN) | 1 | 0 | Allow NULL? |
| 26 | YDPPM6 | Pay Period Number - Other | Character | UDC (05 PN) | 1 | 0 | Allow NULL? |
| 27 | YDACCF | Rate - Accrual Factor | Numeric | Generic Edit | 9 | 4 | Allow NULL? |
| 28 | YDVER1 | Version 1 | String | Generic Edit | 10 | 0 | Allow NULL? |
| 29 | YDVER2 | Version 2 | String | Generic Edit | 10 | 0 | Allow NULL? |
| 30 | YDVER3 | Version 3 | String | Generic Edit | 10 | 0 | Allow NULL? |
| 31 | YDVER4 | Version 4 | String | Generic Edit | 10 | 0 | Allow NULL? |
| 32 | YDVER5 | Version 5 | String | Generic Edit | 10 | 0 | Allow NULL? |
| 33 | YDVER6 | Fiscal & Anniv. Rollover | String | Generic Edit | 10 | 0 | Allow NULL? |
| 34 | YDVER7 | Version 7 | String | Generic Edit | 10 | 0 | Allow NULL? |
| 35 | YDVER8 | Version 8 | String | Generic Edit | 10 | 0 | Allow NULL? |
| 36 | YDVER9 | Payroll Voucher Batch 2 | String | Generic Edit | 10 | 0 | Allow NULL? |
| 37 | YDSEQC | Sequence Code | Character | UDC (07 SR) | 1 | 0 | Allow NULL? |
| 38 | YDNMAX | Amount - Maximum Net Pay | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 39 | YDPPST | Status - Pre payroll Processing | Character | UDC (07 PP) | 1 | 0 | Allow NULL? |
| 40 | YDCKST | Status - Print Payroll Checks | Character | UDC (07 CK) | 1 | 0 | Allow NULL? |
| 41 | YDJEST | Status - Payroll Journal Entries | Character | UDC (07 JE) | 1 | 0 | Allow NULL? |
| 42 | YDROST | Status - Reports Only | Character | UDC | 1 | 0 | Allow NULL? |
| 43 | YDFUST | Status - Final Update | Character | UDC (07 FV) | 1 | 0 | Allow NULL? |
| 44 | YDYST1 | Status- Payroll 01 | Character | UDC (07 YS) | 1 | 0 | Allow NULL? |
| 45 | YDYST2 | Status- Payroll 02 | Character | UDC | 1 | 0 | Allow NULL? |
| 46 | YDYST3 | Status- Payroll 03 | Character | UDC | 1 | 0 | Allow NULL? |
| 47 | YDICU | Batch Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 48 | YDDNMN | Denomination Minimum | Numeric | Generic Edit | 7 | 2 | Allow NULL? |
| 49 | YDPYDT | Date - Pay Cycle Processed | Date | Generic Edit | 6 | 0 | |
| 50 | YDPCCT | Pay Cycle Count | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 51 | YDPPMB | Pay Period Number | Character | UDC (05 YB) | 1 | 0 | Allow NULL? |
| 52 | YDRNUM | Number of Reports to Run | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 53 | YDPYMH | Method - Employee Payment | Character | UDC | 1 | 0 | Allow NULL? |
| 54 | YDMANB | Mandatory Benefit Flag | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 55 | YDCCPR | Country Code | String | UDC (00 CN) | 3 | 0 | Allow NULL? |
| 56 | YDDL02 | Description 02 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 57 | YDADOF | Auto Deposit Override Flag | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 58 | YDMNAF | Minimum Check Adjustment Flag | Character | UDC | 1 | 0 | Allow NULL? |
| 59 | YDADRF | Auto Deposit Reconcilation Flag | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 60 | YDARST | Wage Attachment Invoice Date | Character | UDC (07 WI) | 1 | 0 | Allow NULL? |
| 61 | YDPEF1 | Execution Flag 1 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 62 | YDPEF2 | Execution Flag 2 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 63 | YDPEF3 | Execution Flag 3 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 64 | YDPEF4 | Execution Flag 4 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 65 | YDPEF5 | Execution Flag 5 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 66 | YDPCGT | Pay Cycle Group Type | Character | UDC (07 PH) | 1 | 0 | Allow NULL? |
| 67 | YDCKPF | Check Stock Processing Flag | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 68 | YDASF | Accelerated Submission Flag | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 69 | YDCCUF | Step Progression Automation | Character | UDC (07 JP) | 1 | 0 | Allow NULL? |
| 70 | YDWCUF | Workers Comp. Update Flag | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 71 | YDADEF | Status - Auto Deposit Processing | Character | UDC | 1 | 0 | Allow NULL? |
| 72 | YDADDT | Date - Auto Deposit | Date | Generic Edit | 6 | 0 | |
| 73 | YDADPC | Type Process - Auto Deposit | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 74 | YDADPO | Pre-Note Option Code | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 75 | YDGPOR | Code - Group Plan Override | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 76 | YDELCT | Code - Employee Lockout Control | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 77 | YDACUS | Active Users | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 78 | YDODBA | Optional DBA Processing Flag | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 79 | YDVICU | Payroll Voucher Batch Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 80 | YDDTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 | Allow NULL? |
| 81 | YDUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
