| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP05: Time Accounting and HRM Base |
| 1 | F0618 | Employee Transaction History | 117 | YT | LTTP | Leave Type | String | UDC | 2 | 0 |
| 2 | F073111 | Pay Type to Activity Type Association | 3 | AA | LTTP | Leave Type | String | UDC | 2 | 0 |
| TOP05T: Time Entry |
| 3 | F06116 | Employee Transaction Detail File | 168 | YT | LTTP | Leave Type | String | UDC | 2 | 0 |
| 4 | F06116Z1 | Employee Transactions - Batch File | 182 | VL | LTTP | Leave Type | String | UDC | 2 | 0 |
| 5 | F06116Z2 | ESS Timecard History | 182 | VM | LTTP | Leave Type | String | UDC | 2 | 0 |
| TOP07: Payroll |
| 6 | F07601 | Leave Type Setup | 1 | LS | LTTP | Leave Type | String | UDC | 2 | 0 |
| 7 | F07602 | Leave Verification Rules | 4 | LR | LTTP | Leave Type | String | UDC | 2 | 0 |
| 8 | F07603 | FMLA Leave Substitution Rules | 4 | FV | LTTP | Leave Type | String | UDC | 2 | 0 |
| 9 | F07620 | Leave Transactions | 7 | LV | LTTP | Leave Type | String | UDC | 2 | 0 |
| 10 | F07623 | Employee FMLA Request Header | 7 | L3 | LTTP | Leave Type | String | UDC | 2 | 0 |
| TOP18: Timecard Automation |
| 11 | F186602 | Labor Rules Tag File | 174 | TF | LTTP | Leave Type | String | UDC | 2 | 0 |
| TOP48S: Service Billing |
| 12 | F48S0618 | Payroll Reclassification Workfile | 117 | YT | LTTP | Leave Type | String | UDC | 2 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 07 / LV (Leave Type) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | Blank | | Y |
| 2 | A | Continuous Service | | Y |
| 3 | B | Bereavement | | Y |
| 4 | C | Comp Time | | Y |
| 5 | D | Disability | | Y |
| 6 | F | FMLA | | Y |
| 7 | FO | FMLA Substituted Other | | Y |
| 8 | FS | FMLA Substituted Sick | | Y |
| 9 | FV | FMLA Substituted Vacation | | Y |
| 10 | H | Holiday | | Y |
| 11 | J | Jury Duty | | Y |
| 12 | L | Longevity | | Y |
| 13 | M | Maternity Leave | | Y |
| 14 | N | National Service | | Y |
| 15 | O | Moving | | Y |
| 16 | S | Sick | | Y |
| 17 | T | Training | | Y |
| 18 | V | Vacation | | Y |
| 19 | W | Wedding / Marriage | | Y |
| 20 | X | Company Shutdown | | Y |
| 21 | Y | Moving | | Y |
