| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP05: Time Accounting and HRM Base |
1 | F054101 | Employee Personal Profile Information History Table | 32 | EH | UPID | Updated By | String | Generic Edit | 10 | 0 |
2 | F054101W | Employee Personal Profile Information Work Table | 28 | EP | UPID | Updated By | String | Generic Edit | 10 | 0 |
3 | F054111 | Employee Emergency Contact History Table | 25 | CH | UPID | Updated By | String | Generic Edit | 10 | 0 |
4 | F054111W | Employee Emergency Contact Work Table | 26 | EC | UPID | Updated By | String | Generic Edit | 10 | 0 |
TOP08: Human Resources |
5 | F05410 | Employee E-Signature | 5 | ES | UPID | Updated By | String | Generic Edit | 10 | 0 |
6 | F054115 | Employee Phone Number History Table | 15 | HP | UPID | Updated By | String | Generic Edit | 10 | 0 |
7 | F054115W | Employee Phone Number Work Table | 16 | PN | UPID | Updated By | String | Generic Edit | 10 | 0 |
8 | F085520 | Available Plans and Plan Options by Employee History Table | 29 | PH | UPID | Updated By | String | Generic Edit | 10 | 0 |
9 | F085520W | Available Plans and Plan Options by Employee Work Table | 41 | AP | UPID | Updated By | String | Generic Edit | 10 | 0 |
10 | F085536 | Dependent/Beneficiary X-Reference History Table | 28 | DH | UPID | Updated By | String | Generic Edit | 10 | 0 |
11 | F085536W | Dependent/Beneficiary X-Reference Work Table | 28 | DB | UPID | Updated By | String | Generic Edit | 10 | 0 |
TOP08B: Benefits Administration |
12 | F085303W | IRS W-4 Form Work File | 22 | W4 | UPID | Updated By | String | Generic Edit | 10 | 0 |
TOP41: Inventory Management |
13 | F4160 | Tag Inventory File | 14 | IT | UPID | Updated By | String | Generic Edit | 10 | 0 |