| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBasic Data |
1 | NC00 | IS-HCM Dispatch Log File | 11 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
2 | NC01 | IS-HCM Dispatch Orders to HCM | 9 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
3 | NC02 | IS-HCM Messages Ready-to-Send | 10 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
4 | NC301 | IS-HCM: Order Table Data Transmission for EDI | 10 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
5 | NC301A | IS-HCM: EDI - Obsolete! (Documentation Archive Transfers) | 17 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
6 | NC301B | IS-H: EDI - Agreements with Data Collection Points | 16 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
7 | NC301D | IS-HCM: EDI - Documentation Archive Transfers | 19 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
8 | NC301S | IS-HCM: EDI Status Management | 10 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
9 | NC301T | IS-H EDI Temporary Storage for Old EDI Msg. Status Records | 10 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
10 | NCI0 | IS-HCM Receipt Log File | 7 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
11 | NCIF | IS-HCM: Errored Inbound Messages in Original Format | 7 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
12 | TN02S | IS-H: Systems and System Attributes | 7 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
13 | TNC301EE | IS-H: EDI Error Messages (External) | 3 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
14 | TNC301EI | IS-H: EDI Error Messages (Internal, Asgmt to Ext. Errors) | 2 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
15 | TNC301VER | IS-H: EDI - Version Validity Period | 8 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
16 | TNCDF0 | IS-H: DRG Coding and Grouping System Master Data Table | 4 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
17 | TNCF0 | IS-HCM Message Fields | 2 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
18 | TNCF1 | IS-HCM Message Fields - Texts | 3 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
19 | TNCI0 | IS-HCM Receipt: Event - General Message Type - Assignment | 4 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
20 | TNCI1 | IS-HCM Receipt Parameters for Partner Systems | 6 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
21 | TNCMAPP | IS-H Mapping Table, Assignment to External Codes | 3 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
22 | TNCO0 | IS-HCM Dispatch: Event - General Message Type - Assignment | 4 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
23 | TNCO1 | IS-HCM Dispatch Control Without Dependencies | 7 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
24 | TNCO2 | IS-HCM Dispatch Control with Org. Unit Dependency | 8 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
25 | TNCS0 | IS-HCM Message Segments | 2 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
26 | TNCS1 | IS-HCM Message Segments - Texts | 3 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
27 | TNCS2 | IS-HCM Message Segment - Field Assignment | 2 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
28 | TNCS3 | IS-HCM: Segment-to-Group Segment Assignment | 2 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
29 | TNCST | IS-HCM Communication Standards | 2 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
30 | TNCSU | IS-HCM Communication Standards - Texts | 3 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
31 | TNCT0 | IS-HCM Message Types | 2 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
32 | TNCT1 | IS-HCM Message Types - Texts | 3 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
33 | TNCT2 | IS-HCM Message Type-Segment Assignment | 2 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
34 | TNHL7 | IS-HCM HL7 Conversions | 1 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
TOPClinical System |
35 | NC321 | IS-H: Table for data exchange of §321 | 10 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
TOPPatient Accounting |
36 | TNM02 | IS-H MM: Material Requisition Parameters | 11 | STVER | IS-H MM: Start Screen in Material Requisition Function | nvarchar | 1 | 0 | | |
TOPPublic Sector |
37 | PDPBSZV363 | Estimated Tax-Free Contributions (Acc. to Sec.3 No.63) | 11 | STVER | Tax Indicator | nvarchar | 1 | 0 | | |
38 | T5D5B | Supplementary Pension Public Sector: Employer Table | 21 | STVER | Tax Indicator | nvarchar | 1 | 0 | | |
39 | T5D5H | Supplementary Pension Public Sector: Taxing Features | 5 | STVER | Tax Indicator | nvarchar | 1 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
40 | NCSSN | Communication Table (Item) to SSN | 7 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | | |
41 | TNCDALE | DALE-UV: Einstellungen | 3 | STVER | IS-HCM Version des Kommunikationsstandards | nvarchar | 3 | 0 | | |
42 | TNWAT_EDI_CODES | IS-H AT: EDIVKA EDI Verfahren Codelisten | 3 | STVER | IS-HCM Version des Kommunikationsstandards | nvarchar | 3 | 0 | | |
TOPSwitzerland |
43 | T5C2D | Withholding Tax Calculation | 4 | STVER | WhT tax table version | nvarchar | 1 | 0 | | |
44 | T5C2E | Special Table 13th Monthly Wages | 3 | STVER | WhT tax table version | nvarchar | 1 | 0 | | |