| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | P2KZ_KZGRP | Groupings and statuses of PERNR | 10 | RESID | Tax Residence Status | nvarchar | 1 | 0 | | |
| 2 | P2RK_GRDBT | Payroll results Canada: Garnishment debt | 45 | RESID | Indicator on how debt is sorted in relation to other debts | nvarchar | 1 | 0 | | |
| 3 | P2RP_TX | HR-PT: Payroll Results: Tax | 17 | RESID | Indication of residence | nvarchar | 1 | 0 | | |
| 4 | T7RUR3 | Residence Type Identifier | 4 | RESID | Residence Status | nvarchar | 1 | 0 | | |
| 5 | T7RUR3T | Residence Type Identifier Text | 5 | RESID | Residence Status | nvarchar | 1 | 0 | | |
| 6 | ZPPMC_CPL_C_RES | CO resources for cProjects Cost Planning | 2 | RESID | CO Resource | nvarchar | 10 | 0 | | |
| 7 | ZPPMC_CPL_C_RESP | Price table for CO resources | 2 | RESID | CO Resource | nvarchar | 10 | 0 | | |
| 8 | ZPPMC_CPL_C_REST | text table for zppmc_cpl_c_res | 2 | RESID | CO Resource | nvarchar | 10 | 0 | | |
| TOPAustralia |
| 9 | PA0188 | Tax (Australia) | 28 | RESID | Resident ID | nvarchar | 1 | 0 | | |
| TOPCanada |
| 10 | PA0095 | HR Master Record: Infotype 0095 (Tax Canada) | 49 | RESID | Residence indicator | nvarchar | 1 | 0 | | |
| 11 | T5KG5 | Relationship to other debts model characteristics | 5 | RESID | Indicator on how debt is sorted in relation to other debts | nvarchar | 1 | 0 | | |
| TOPClinical System |
| 12 | N1PRPAT | IS-H*MED: PATREG: Patientenstammdatentabelle | 81 | RESID | IS-H: Gösterge: Hasta ülke vatandasi degil | nvarchar | 1 | 0 | | |
| 13 | N1PRTMPPAT | IS-H*MED: PATREG: Temporäre Patientenstammdatentabelle | 82 | RESID | IS-H: Gösterge: Hasta ülke vatandasi degil | nvarchar | 1 | 0 | | |
| 14 | N1PRTMPPATLOC | IS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal | 82 | RESID | IS-H: Gösterge: Hasta ülke vatandasi degil | nvarchar | 1 | 0 | | |
| 15 | N2DOCFAL | IS-H*MED: Case Data for Archived Documents | 44 | RESID | Indicator That Patient Is Non-Resident | nvarchar | 1 | 0 | | |
| TOPGreat Britain |
| 16 | PA0570 | HR Master Record: Infotype 0570 | 39 | RESID | HR-GB: Isle of Man Residence Status | nvarchar | 1 | 0 | | |
| TOPliveCache Applications |
| 17 | MMRP_DATEVECS | Key: Date Vector (Only in the liveCache) | 4 | RESID | Internal APO Number (UID) for Resource | nvarchar | 22 | 0 | | |
| TOPPatient Accounting |
| 18 | NVBRK | IS-H: Billing document header data | 73 | RESID | Indicator That Patient Is Non-Resident | nvarchar | 1 | 0 | | |
| 19 | TNIEBILL | IS-H: Internet-Enabled Estimated Invoice - Not Supported Now | 24 | RESID | Indicator That Patient Is Non-Resident | nvarchar | 1 | 0 | | |
| TOPPatient Management |
| 20 | NFAL | IS-H: Cases | 44 | RESID | Indicator That Patient Is Non-Resident | nvarchar | 1 | 0 | | |
| 21 | NPAT | IS-H: Patient Master Data (General) | 94 | RESID | Indicator That Patient Is Non-Resident | nvarchar | 1 | 0 | | |
| TOPPayroll General Parts |
| 22 | T53G4 | Debt Types for Garnishments | 11 | RESID | Indicator on how debt is sorted in relation to other debts | nvarchar | 1 | 0 | | |
| 23 | T53GT | Priority of debts | 8 | RESID | Indicator on how debt is sorted in relation to other debts | nvarchar | 1 | 0 | | |
| TOPPerformance Assessment Workbench |
| 24 | SLS_PET | PAW - Person/Event/Test Relationship Table | 13 | RESID | PAW - Reserve Id | nvarchar | 15 | 0 | | |
| TOPPersonnel Administration |
| 25 | T752E | SAP Resumix: Transferred Applicants | 2 | RESID | Internal Resumix ID | nvarchar | 11 | 0 | | |
| TOPPlanning |
| 26 | RN1SCHED_APPOINT | IS-H*MED Appointment Table | 2 | RESID | Resource ID | nvarchar | 30 | 0 | | |
| 27 | RN1SCHED_AVAILAB | IS-H*MED Planning Authority Table | 2 | RESID | Resource ID | nvarchar | 30 | 0 | | |
| 28 | RN1SCHED_COMMNT | IS-H*MED: Comment Table | 1 | RESID | Resource ID | nvarchar | 30 | 0 | | |
| 29 | RN1SCHED_FOCAREA | IS-H*MED: Time Areas for Planning Grid (Do not Use!!!) | 1 | RESID | Resource ID | nvarchar | 30 | 0 | | |
| 30 | RN1SCHED_PATT_AS | IS-H*MED: Resource-Planning Grid Pattern Assignment (No Use) | 2 | RESID | Resource ID | nvarchar | 30 | 0 | | |
| 31 | RN1SCHED_RESOURC | IS-H*MED Resource Table | 2 | RESID | Resource ID | nvarchar | 30 | 0 | | |
| 32 | RN1SCHED_SPECTIM | IS-H*MED Special Time Table | 2 | RESID | Resource ID | nvarchar | 30 | 0 | | |
| TOPPortugal |
| 33 | PA0331 | HR Master Record: Infotype 0331 (Tax - PT) | 34 | RESID | Indication of residence | nvarchar | 1 | 0 | | |
| 34 | T5P1S | HR-PT: Tax status table | 7 | RESID | Indication of residence | nvarchar | 1 | 0 | | |
| TOPSAP Healthcare - Industry-Specific Components for Hospitals |
| 35 | NPSPAT | IS-H: Pseudonymized Patient Master Data (General) | 16 | RESID | Indicator That Patient Is Non-Resident | nvarchar | 1 | 0 | | |
| TOPSocial Insurance |
| 36 | P01SV_B2ATRNS | Status Table Transfer to Social Insurance Agency | 21 | RESID | SI: Response ID | nvarchar | 50 | 0 | | |
| TOPSpain |
| 37 | T5EG5 | Features of relationship with other debts model | 5 | RESID | Classification indicator of a debt related to other debts | nvarchar | 1 | 0 | | |
| TOPUSA |
| 38 | PA0096 | HR Master Record: Infotype 0096 (Tax - USA) | 31 | RESID | Residence indicator | nvarchar | 1 | 0 | | |
