| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TNWCH_EDI_RETCD | EDI Antwortcodes | 2 | EDIPROC | ISHCM EDI Verfahren | nvarchar | 5 | 0 | | |
2 | TNWCH_EDI_RETCDT | EDI Antwortcodes - Texte | 2 | EDIPROC | ISHCM EDI Verfahren | nvarchar | 5 | 0 | | |
TOPBasic Data |
3 | NC301 | IS-HCM: Order Table Data Transmission for EDI | 24 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
4 | NC301B | IS-H: EDI - Agreements with Data Collection Points | 4 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
5 | NC301CEX | IS-H: EDI - Cases Excluded From Data Exchange Process | 3 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
6 | NC301D | IS-HCM: EDI - Documentation Archive Transfers | 28 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
7 | NC301KTR | IS-H EDI: Data Cllct. Point - Ins. Provider Asgmt | 3 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
8 | NC301R | IS-H: EDI Other Inbound Data for Misc. Evaluation/Display | 3 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
9 | NC301S | IS-HCM: EDI Status Management | 36 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
10 | NC301T | IS-H EDI Temporary Storage for Old EDI Msg. Status Records | 36 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
11 | NC301TX | IS-H: EDI: Temporary Transfer Table Ext. -> Int. Files | 3 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
12 | NCCHR | IS-H SG: Change Reasons for Modifications to Case Data | 3 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
13 | NCSTA | IS-H: EDI Communication Status for Specific Objects | 4 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
14 | TNC301AS | IS-H: EDI Assign Indicators to Service | 3 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
15 | TNC301C0 | IS-H: Control/Options Table for Specific EDI Procedures | 3 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
16 | TNC301EX | IS-H EDI: Msg Exclusions for IP - Obsolete => TNC301MX | 3 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
17 | TNC301F0 | IS-H EDI Table for File Name Composition | 3 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
18 | TNC301G0 | IS-HCM: EDI Procedures | 1 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
19 | TNC301GC | IS-H EDI Procedure Checks | 1 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
20 | TNC301GE | IS-HCM: EDI Procedure Events | 1 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
21 | TNC301GF | IS-HCM: EDI Procedure Function Calls | 1 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
22 | TNC301GI | IS-HCM: EDI Procedure in Institution | 3 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
23 | TNC301GS | IS-H EDI: Assign Standards to Procedures | 1 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
24 | TNC301GT | IS-HCM: Texts for EDI Procedures | 2 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
25 | TNC301MX | IS-H EDI: Message Exclusions for Insurance Providers | 3 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
26 | TNC301SA | IS-H EDI: Application Status for Communication | 1 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
27 | TNC301SC | IS-H EDI: Status Table for Detailed Communication Status | 1 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
28 | TNC301T1 | IS-H EDI: Application Status Text for Communication | 2 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
29 | TNC301T2 | IS-H EDI: Texts for Detailed Communication Status | 2 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
30 | TNC301VER | IS-H: EDI - Version Validity Period | 4 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
31 | TNC301X | IS-HCM: EDI - Connection Data Transfer System | 3 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
32 | TNC301XI | IS-H EDI: Sender Communication Specs (Institution-Specific) | 3 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
TOPPatient Accounting |
33 | NBRKS | IS-H: Collective Invoice Status | 7 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
TOPPatient Management |
34 | NKSD | IS-H: Treatment Certificate Details | 117 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
35 | NC302KTR | IS-H EDI Annahmestellen Kostenträger Zuordnung für §302 | 4 | EDIPROC | ISHCM EDI Verfahren | nvarchar | 5 | 0 | | |
36 | NCSSNID | Communication Table (Header) to SSN | 7 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | | |
37 | NWAT_EDI_KOM | IS-H AT: EDI Kommentar (K12) | 5 | EDIPROC | ISHCM EDI Verfahren | nvarchar | 5 | 0 | | |