| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBasic Data |
1 | NC301R | IS-H: EDI Other Inbound Data for Misc. Evaluation/Display | 8 | APSTATE | IS-H: Application Status | nvarchar | 2 | 0 | | |
2 | NC301S | IS-HCM: EDI Status Management | 39 | APSTATE | IS-H: Application Status | nvarchar | 2 | 0 | | |
3 | NC301T | IS-H EDI Temporary Storage for Old EDI Msg. Status Records | 39 | APSTATE | IS-H: Application Status | nvarchar | 2 | 0 | | |
4 | TNC301SA | IS-H EDI: Application Status for Communication | 2 | APSTATE | IS-H: Application Status | nvarchar | 2 | 0 | | |
5 | TNC301T1 | IS-H EDI: Application Status Text for Communication | 3 | APSTATE | IS-H: Application Status | nvarchar | 2 | 0 | | |
TOPClinical System |
6 | N2DOCFAL | IS-H*MED: Case Data for Archived Documents | 58 | APSTATE | IS-H: Application Status | nvarchar | 2 | 0 | | |
TOPPatient Accounting |
7 | NCIR | IS-H: Insurance Relationships of a Case | 95 | APSTATE | IS-H: Application Status | nvarchar | 2 | 0 | | |
TOPPatient Management |
8 | NFAL | IS-H: Cases | 58 | APSTATE | IS-H: Application Status | nvarchar | 2 | 0 | | |
9 | NKSD | IS-H: Treatment Certificate Details | 116 | APSTATE | IS-H: Application Status | nvarchar | 2 | 0 | | |
10 | NVVF | IS-H: Case-Related Insurance Relationships | 44 | APSTATE | IS-H: Application Status | nvarchar | 2 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
11 | NVVN | IS-H: Guarantors | 23 | APSTATE | IS-H: Application Status | nvarchar | 2 | 0 | | |