| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP05: Time Accounting and HRM Base |
1 | F06106 | Employee Pay Instructions | 92 | YM | RCCD | Record Type | Character | UDC | 1 | 0 |
2 | F0618 | Employee Transaction History | 4 | YT | RCCD | Record Type | Character | UDC | 1 | 0 |
TOP05A: OW HR & PR Foundation |
3 | F060116 | Employee Master Information | 119 | YA | RCCD | Record Type | Character | UDC | 1 | 0 |
4 | F0601161 | Point-In-Time Employee Master | 121 | PT | RCCD | Record Type | Character | UDC | 1 | 0 |
5 | F060116W | EE Master Request File | 119 | YA | RCCD | Record Type | Character | UDC | 1 | 0 |
6 | F060116Z | Unedited Quick Hire Transaction File | 51 | SZ | RCCD | Record Type | Character | UDC | 1 | 0 |
TOP05T: Time Entry |
7 | F06116 | Employee Transaction Detail File | 4 | YT | RCCD | Record Type | Character | UDC | 1 | 0 |
8 | F06116Z1 | Employee Transactions - Batch File | 21 | VL | RCCD | Record Type | Character | UDC | 1 | 0 |
9 | F06116Z2 | ESS Timecard History | 21 | VM | RCCD | Record Type | Character | UDC | 1 | 0 |
10 | F06278 | Retro Timecard Detail File | 7 | YT | RCCD | Record Type | Character | UDC | 1 | 0 |
TOP07: Payroll |
11 | F0716701 | Employee Assignment T/E Template Information | 32 | EA | RCCD | Record Type | Character | UDC | 1 | 0 |
12 | F0716709 | Employee Assignment T/E Template Info History | 32 | EA | RCCD | Record Type | Character | UDC | 1 | 0 |
13 | F07UI200 | Timecard History Work File | 7 | TH | RCCD | Record Type | Character | UDC | 1 | 0 |
TOP08AD: ADP Integration |
14 | F051371 | ADP Employee DBA Instructions | 98 | AD | RCCD | Record Type | Character | UDC | 1 | 0 |
TOP18: Resource Scheduling |
15 | F186301 | Timecard Templates | 32 | TT | RCCD | Record Type | Character | UDC | 1 | 0 |
16 | F186602 | Labor Rules Tag File | 18 | TF | RCCD | Record Type | Character | UDC | 1 | 0 |
TOP48S: Service Billing |
17 | F48S0618 | Payroll Reclassification Workfile | 4 | YT | RCCD | Record Type | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.