| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP01: Address Book |
1 | F0111 | Address Book - Who's Who | 11 | WW | MDNM | Name - Middle | String | Generic Edit | 25 | 0 |
2 | F0111Z1 | Batch Who's Who Information | 24 | BW | MDNM | Name - Middle | String | Generic Edit | 25 | 0 |
TOP05: Time Accounting and HRM Base |
3 | F054101 | Employee Personal Profile Information History Table | 5 | EH | MDNM | Name - Middle | String | Generic Edit | 25 | 0 |
4 | F054101W | Employee Personal Profile Information Work Table | 5 | EP | MDNM | Name - Middle | String | Generic Edit | 25 | 0 |
TOP07: Payroll |
5 | F074001 | New Hire Reporting Workfile - OneWorld Only | 10 | NH | MDNM | Name - Middle | String | Generic Edit | 25 | 0 |
6 | F8907427 | New Hire Detail File - Montana (27) | 33 | MT | MDNM | Name - Middle | String | Generic Edit | 25 | 0 |
7 | F8907428 | New Hire Detail File - Nebraska(28) | 8 | NE | MDNM | Name - Middle | String | Generic Edit | 25 | 0 |
8 | F8907444 | New Hire Detail File Transfer - Texas (44) | 6 | TX | MDNM | Name - Middle | String | Generic Edit | 25 | 0 |
TOP08: Human Resources |
9 | F081161 | ACA Employee Eligibility | 16 | AD | MDNM | Name - Middle | String | Generic Edit | 25 | 0 |
10 | F0811619 | ACA Employee Eligibility Archive | 16 | AD | MDNM | Name - Middle | String | Generic Edit | 25 | 0 |
TOP08AD: ADP Integration |
11 | F05137 | ADP Employee Master Information | 46 | AD | MDNM | Name - Middle | String | Generic Edit | 25 | 0 |
TOP75A: Australia |
12 | F75A0010 | Australian Employee Termination Details | 56 | A0 | MDNM | Name - Middle | String | Generic Edit | 25 | 0 |
TOP89: Conversion Programs |
13 | F01111Z1 | Batch - Contact Information | 26 | CB | MDNM | Name - Middle | String | Generic Edit | 25 | 0 |