| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | P2RR_NRIC | Payroll Singapore: NRIC | 10 | DOCN1 | Document number for personal identification | nvarchar | 20 | 0 | | |
| 2 | PA3273 | HR Master Record: Infotype 3273 | 57 | DOCN1 | Document Number for Personal Identification | nvarchar | 15 | 0 | | |
| TOPBenefits |
| 3 | PA0171 | HR Master Record: Infotype 0171 (Gen. Benefits Information) | 27 | DOCN1 | Benefit Physician Name | nvarchar | 30 | 0 | | |
| 4 | PA0376 | HR Master Data Record: Infotype 0376 (Medical Benefits Info) | 24 | DOCN1 | Benefit Physician Name | nvarchar | 30 | 0 | | |
| TOPPersonnel Administration |
| 5 | PA0830 | HR master record for infotypes 0830 | 45 | DOCN1 | Payment statement number | nvarchar | 8 | 0 | | |
| TOPSingapore |
| 6 | PA0185 | HR Master Record: Infotype 0185 [Identification] (SG) | 28 | DOCN1 | Document issuing number | nvarchar | 20 | 0 | | |
| 7 | PB0185 | HR Master Record: Infotype 0185 (Personal ID) | 28 | DOCN1 | Document issuing number | nvarchar | 20 | 0 | | |
| TOPUSA |
| 8 | PA0094 | HR Master Record: Infotype 0094 (Residence Status - NA) | 28 | DOCN1 | Document number for personal identification | nvarchar | 20 | 0 | | |
