| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | P2RR_NRIC | Payroll Singapore: NRIC | 8 | IDCOD | Personal ID and work permit (SG) | nvarchar | 2 | 0 | | |
| TOPUSA |
| 2 | PA0077 | HR Master Record: Infotype 0077 (Additional Personal Data) | 74 | IDCOD | Person Identification Number | nvarchar | 20 | 0 | | |
| 3 | PA0106 | HR Master Record: Infotype 0106 (Related Persons NA) | 62 | IDCOD | Person Identification Number | nvarchar | 20 | 0 | | |
| 4 | PB0077 | HR Master Record: Infotype 0077 | 74 | IDCOD | Person Identification Number | nvarchar | 20 | 0 | | |
| 5 | T509F | ID type | 3 | IDCOD | Personal ID and work permit (USA) | nvarchar | 2 | 0 | | |
| 6 | T509G | ID type text | 4 | IDCOD | Personal ID and work permit (USA) | nvarchar | 2 | 0 | | |
| 7 | T5U94 | Document ID - Personal ID and Work Permit (USA) | 3 | IDCOD | Personal ID and work permit (USA) | nvarchar | 2 | 0 | | |
