| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TNWCH_CHOP_REL | Statistikrelevante CHOP-Codes | 4 | ICPML | IS-H: Identifikation eines Operationscodes (Leistung) | nvarchar | 10 | 0 | | |
TOPClinical System |
2 | N1POPAKTE | IS-H*Med: Patient Organizer - Redundant Structure | 38 | ICPML | IS-H: Surgical Procedure Code (Service) | nvarchar | 10 | 0 | | |
TOPPatient Accounting |
3 | NICP | IS-H: Surgical Procedure Codes Performed | 5 | ICPML | IS-H: Surgical Procedure Code (Service) | nvarchar | 10 | 0 | | |
4 | NICP2 | IS-H: INACTIVE since 4.71 - DO NOT USE ! | 5 | ICPML | IS-H: Surgical Procedure Code (Service) | nvarchar | 10 | 0 | | |
5 | NLOP | IS-H:INACTIVE Assignment Table Service - SP Code - Diagnosis | 6 | ICPML | IS-H: Surgical Procedure Code (Service) | nvarchar | 10 | 0 | | |
6 | TNIEBILL | IS-H: Internet-Enabled Estimated Invoice - Not Supported Now | 8 | ICPML | IS-H: Surgical Procedure Code (Service) | nvarchar | 10 | 0 | | |
7 | TNPROC_MAT_REL | Assignment of Single-Qty PrCd. to Material and Summary PrCd. | 4 | ICPML | Single-Quantity Procedure Code | nvarchar | 10 | 0 | | |
TOPPatient Management |
8 | N1VKG | IS-H: Item of Clinical Order (Preregistration) | 56 | ICPML | IS-H: Surgical Procedure Code (Service) | nvarchar | 10 | 0 | | |
9 | NLEI | IS-H: Services Performed | 54 | ICPML | IS-H: Surgical Procedure Code (Service) | nvarchar | 10 | 0 | | |
10 | NPCP | IS-H: Procedures for Preregistered Patient | 7 | ICPML | Localization for Surgical Procedure Code | nvarchar | 2 | 0 | | |
11 | NWLP | IS-H: Procedures for Waiting List (Internal Use Only) | 5 | ICPML | IS-H: Surgical Procedure Code (Service) | nvarchar | 10 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
12 | NWCHLS_RNLSR | IS-H CH: ALIS-Fehlerhandlung - Leistungen (RNLSR) | 67 | ICPML | IS-H: Identif. di un codice interv. chirur. (prestazione) | nvarchar | 10 | 0 | | |