| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | P2RR_NRIC | Payroll Singapore: NRIC | 17 | EXPDT | Expiry date of work permit | nvarchar | 8 | 0 | | |
| 2 | PA3338 | HR Master Record: Infotype 3338 | 31 | EXPDT | Sanction Expiry Date | nvarchar | 8 | 0 | | |
| 3 | T7OM10 | Visa Block Request Information | 10 | EXPDT | Expiry Date | nvarchar | 8 | 0 | | |
| 4 | T7QA61 | Visa Block Request Information | 10 | EXPDT | Expiry Date | nvarchar | 8 | 0 | | |
| 5 | T7SA45 | Visa Block Request Information | 10 | EXPDT | Expiry Date | nvarchar | 8 | 0 | | |
| TOPAuto-ID Backend Integration |
| 6 | AIDARCH | Obsolete: Auto-ID Infrastructure Archiving | 6 | EXPDT | Document Expiration Time | decimal | 15 | 0 | | |
| TOPPatient Accounting |
| 7 | NEHC_E111 | IS-H: European Health Insurance Card | 11 | EXPDT | IS-H: EHIC - Validity End | nvarchar | 8 | 0 | | |
| 8 | NEHC_PAT | IS-H: Health Insurance Card (Patient Data) | 8 | EXPDT | IS-H: EHIC - Validity End | nvarchar | 8 | 0 | | |
| TOPRemote Logistics Management |
| 9 | OIO_MX_INDEX | RLM material tracking extract index | 8 | EXPDT | Tracking extract expiry date | nvarchar | 8 | 0 | | |
| TOPSAP Healthcare - Industry-Specific Components for Hospitals |
| 10 | NEHIC | IS-H: European Health Insurance Card | 12 | EXPDT | IS-H: EHIC - Validity End | nvarchar | 8 | 0 | | |
| TOPUSA |
| 11 | PA0094 | HR Master Record: Infotype 0094 (Residence Status - NA) | 33 | EXPDT | Expiry date of work permit | nvarchar | 8 | 0 | | |
