| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | P2RR_NRIC | Payroll Singapore: NRIC | 12 | EXPID | ID expiry date | nvarchar | 8 | 0 | | |
| 2 | T7SA17H | Sponsor ID Entity Table | 8 | EXPID | expiry date | nvarchar | 8 | 0 | | |
| TOPActual Revenues and Forecast |
| 3 | EBII | CO/SD document flow: billed portions of expense items | 2 | EXPID | Resource Item ID | nvarchar | 22 | 0 | | |
| TOPPatient Management |
| 4 | NKSD | IS-H: Treatment Certificate Details | 115 | EXPID | Identifier for Referring Physician | nvarchar | 16 | 0 | | |
| TOPSingapore |
| 5 | PA0185 | HR Master Record: Infotype 0185 [Identification] (SG) | 30 | EXPID | ID expiry date | nvarchar | 8 | 0 | | |
| 6 | PB0185 | HR Master Record: Infotype 0185 (Personal ID) | 30 | EXPID | ID expiry date | nvarchar | 8 | 0 | | |
| TOPTraining Management |
| 7 | HRPAD614 | Additional Data PAD614 | 25 | EXPID | WebService: Participation ID in External LMS | nvarchar | 32 | 0 | | |
| TOPUSA |
| 8 | PA0094 | HR Master Record: Infotype 0094 (Residence Status - NA) | 36 | EXPID | ID expiry date | nvarchar | 8 | 0 | | |
