| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP05: Time Accounting and HRM Base |
1 | F0609 | Deduction/Benefit/Accrual Ledger File | 11 | Y$ | DEDM | Method of Calculation | Character | UDC | 1 | 0 |
2 | F0618 | Employee Transaction History | 62 | YT | DEDM | Method of Calculation | Character | UDC | 1 | 0 |
3 | F0619 | Benefit/Accrual Detail File | 11 | Y$ | DEDM | Method of Calculation | Character | UDC | 1 | 0 |
4 | F069116 | Payroll Transaction Constants | 15 | YC | DEDM | Method of Calculation | Character | UDC | 1 | 0 |
5 | F069216 | Workers Compensation Insurance Rates | 6 | YB | DEDM | Method of Calculation | Character | UDC | 1 | 0 |
6 | F06936 | Retro Pay Types Rate | 12 | JA | DEDM | Method of Calculation | Character | UDC | 1 | 0 |
7 | F0709 | Deduction/Benefit/Accrual Ledger File | 13 | Y$ | DEDM | Method of Calculation | Character | UDC | 1 | 0 |
TOP05T: Time Entry |
8 | F06116 | Employee Transaction Detail File | 62 | YT | DEDM | Method of Calculation | Character | UDC | 1 | 0 |
9 | F06116Z1 | Employee Transactions - Batch File | 73 | VL | DEDM | Method of Calculation | Character | UDC | 1 | 0 |
10 | F06116Z2 | ESS Timecard History | 73 | VM | DEDM | Method of Calculation | Character | UDC | 1 | 0 |
11 | F0624 | Burden Distribution File | 16 | J# | DEDM | Method of Calculation | Character | UDC | 1 | 0 |
12 | F06241 | Burden Distribution File | 16 | J# | DEDM | Method of Calculation | Character | UDC | 1 | 0 |
13 | F06278 | Retro Timecard Detail File | 59 | YT | DEDM | Method of Calculation | Character | UDC | 1 | 0 |
TOP07: Payroll |
14 | F063106 | Deduction/Benefit Work File | 21 | Y7 | DEDM | Method of Calculation | Character | UDC | 1 | 0 |
15 | F06490 | Payroll/Accounts Payable Ledger Detail | 16 | JR | DEDM | Method of Calculation | Character | UDC | 1 | 0 |
16 | F071072 | Employee Level Multi Child Support Overrides | 3 | JX | DEDM | Method of Calculation | Character | UDC | 1 | 0 |
17 | F0719 | DBA Transaction Detail History | 13 | Y$ | DEDM | Method of Calculation | Character | UDC | 1 | 0 |
18 | F0724 | Burden Distribution File | 19 | YS | DEDM | Method of Calculation | Character | UDC | 1 | 0 |
19 | F07241 | Burden Distribution File | 19 | YS | DEDM | Method of Calculation | Character | UDC | 1 | 0 |
20 | F0729 | Employee DBA Override Instructions | 10 | Y9 | DEDM | Method of Calculation | Character | UDC | 1 | 0 |
21 | F07490 | Payroll - Accounts Payable Detail (One World) | 16 | JR | DEDM | Method of Calculation | Character | UDC | 1 | 0 |
22 | F07901 | Pre-Payroll DBA Calculation Control Table | 1 | Y5 | DEDM | Method of Calculation | Character | UDC | 1 | 0 |
23 | F07UI200 | Timecard History Work File | 65 | TH | DEDM | Method of Calculation | Character | UDC | 1 | 0 |
TOP08AD: ADP Integration |
24 | F051375 | ADP Payroll DBA Transaction Constants | 17 | AD | DEDM | Method of Calculation | Character | UDC | 1 | 0 |
TOP18: Resource Scheduling |
25 | F186602 | Labor Rules Tag File | 72 | TF | DEDM | Method of Calculation | Character | UDC | 1 | 0 |
TOP48S: Service Billing |
26 | F48S0618 | Payroll Reclassification Workfile | 62 | YT | DEDM | Method of Calculation | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.