| 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 | 29 | EH | ESIGN | E-Signature ID | String | Generic Edit | 16 | 0 |
2 | F054101W | Employee Personal Profile Information Work Table | 25 | EP | ESIGN | E-Signature ID | String | Generic Edit | 16 | 0 |
3 | F054111 | Employee Emergency Contact History Table | 22 | CH | ESIGN | E-Signature ID | String | Generic Edit | 16 | 0 |
4 | F054111W | Employee Emergency Contact Work Table | 23 | EC | ESIGN | E-Signature ID | String | Generic Edit | 16 | 0 |
5 | F05420 | Workflow Approval Table | 5 | WA | ESIGN | E-Signature ID | String | Generic Edit | 16 | 0 |
6 | F085590 | Disability and Veteran Status History Table | 15 | DS | ESIGN | E-Signature ID | String | Generic Edit | 16 | 0 |
7 | F085590W | Disability Status Work Table | 10 | DS | ESIGN | E-Signature ID | String | Generic Edit | 16 | 0 |
8 | F085605W | Veteran Status Work Table | 12 | VS | ESIGN | E-Signature ID | String | Generic Edit | 16 | 0 |
TOP08: Human Resources |
9 | F05410 | Employee E-Signature | 2 | ES | ESIGN | E-Signature ID | String | Generic Edit | 16 | 0 |
10 | F054115 | Employee Phone Number History Table | 12 | HP | ESIGN | E-Signature ID | String | Generic Edit | 16 | 0 |
11 | F054115W | Employee Phone Number Work Table | 13 | PN | ESIGN | E-Signature ID | String | Generic Edit | 16 | 0 |
12 | F085520 | Available Plans and Plan Options by Employee History Table | 26 | PH | ESIGN | E-Signature ID | String | Generic Edit | 16 | 0 |
13 | F085520W | Available Plans and Plan Options by Employee Work Table | 38 | AP | ESIGN | E-Signature ID | String | Generic Edit | 16 | 0 |
14 | F085528 | ESS History Table Cross Reference | 2 | ES | ESIGN | E-Signature ID | String | Generic Edit | 16 | 0 |
15 | F085536 | Dependent/Beneficiary X-Reference History Table | 25 | DH | ESIGN | E-Signature ID | String | Generic Edit | 16 | 0 |
16 | F085536W | Dependent/Beneficiary X-Reference Work Table | 25 | DB | ESIGN | E-Signature ID | String | Generic Edit | 16 | 0 |
TOP08B: Benefits Administration |
17 | F085303W | IRS W-4 Form Work File | 21 | W4 | ESIGN | E-Signature ID | String | Generic Edit | 16 | 0 |