| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | P2BR_BRTAX | Withholding Income Tax | 15 | INSID | Indicator for payroll result | nvarchar | 1 | 0 | | |
| 2 | P2BR_GRDBT | Alimony debits | 10 | INSID | Garnishment: Insert indicator for payroll result of debt | nvarchar | 1 | 0 | | |
| 3 | P2KR_KRTAX | Payroll Result Korea : Tax | 32 | INSID | Indicator for insurance | nvarchar | 1 | 0 | | |
| 4 | P2MX_GRDBT | Maintenance Payment Debit | 12 | INSID | Garnishment: Insert indicator for payroll result of debt | nvarchar | 1 | 0 | | |
| 5 | P2RK_GRDBT | Payroll results Canada: Garnishment debt | 13 | INSID | Garnishment: Insert indicator for payroll result of debt | nvarchar | 1 | 0 | | |
| 6 | T7INPEL2 | P2E: Policy Log table | 12 | INSID | Work item ID | nvarchar | 12 | 0 | | |
| TOPBusiness Partners |
| 7 | NPNT | Patient Master Data | 53 | INSID | | nvarchar | 10 | 0 | | |
| TOPContract Accounts Receivable and Payable |
| 8 | DFKKCFNR | Clarification Cases from NOC Returns Lot | 5 | INSID | ID of Sender Institute (Example: House Bank) | nvarchar | 5 | 0 | | |
| 9 | DFKKNRK | NOC Returns Lot: Header Data | 19 | INSID | ID of Sender Institute (Example: House Bank) | nvarchar | 5 | 0 | | |
| 10 | TFK054A | Incorrect Bank Data Lot: Error Reasons per Sender | 2 | INSID | ID of Sender Institute (Example: House Bank) | nvarchar | 5 | 0 | | |
| 11 | TFK054AT | NOC Returns: Texts for Error Reasons per Institution | 2 | INSID | ID of Sender Institute (Example: House Bank) | nvarchar | 5 | 0 | | |
| 12 | TFK054B | Assignment of Sender Institution Error Reason -> Internal | 3 | INSID | ID of Sender Institute (Example: House Bank) | nvarchar | 5 | 0 | | |
| 13 | TFK054C | NOC Returns: Activities per OPBUK and INSID | 3 | INSID | ID of Sender Institute (Example: House Bank) | nvarchar | 5 | 0 | | |
| 14 | TFK054CT | NOC Returns: Activity Texts | 3 | INSID | ID of Sender Institute (Example: House Bank) | nvarchar | 5 | 0 | | |
| TOPJapan |
| 15 | PA0143 | HR Master Record: Infotype 0143 (Life Insurance JP) | 24 | INSID | Insurance Type Indicator | nvarchar | 4 | 0 | | |
| 16 | PA0162 | HR Master Record: Infotype 0162 (Ins. Y.E.T.A Data JP) | 24 | INSID | Insurance Type Indicator | nvarchar | 4 | 0 | | |
| TOPKorea |
| 17 | PA0540 | Family KOR | 35 | INSID | Indicator for insurance | nvarchar | 1 | 0 | | |
| TOPPatient Accounting |
| 18 | NEHC_PAT | IS-H: Health Insurance Card (Patient Data) | 9 | INSID | | nvarchar | 10 | 0 | | |
| TOPPatient Management |
| 19 | NIPP | IS-H: Provisional Insurance Relationship of Preregistration | 36 | INSID | | nvarchar | 10 | 0 | | |
| 20 | NPAT | IS-H: Patient Master Data (General) | 121 | INSID | | nvarchar | 10 | 0 | | |
