| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPClinical System |
| 1 | N1BCP | Basic Cat.: Catalog Item | 11 | VTDAT | Basic Cat.: Validity End Date of an Item | nvarchar | 8 | 0 | | |
| 2 | N1BCSMC | Basic Catalog Set: Main Catalog | 9 | VTDAT | Basic Cat.: Validity End Date of a Catalog in the Set | nvarchar | 8 | 0 | | |
| 3 | N1BCSPC | Basic Catalog Set: Property Catalog | 8 | VTDAT | Basic Cat.: Validity End Date of a Catalog in the Set | nvarchar | 8 | 0 | | |
| TOPNursing |
| 4 | N1SNP | OBSOLETE - Std.Nurs.Plan: Std.Nurs.Plan Header Data | 9 | VTDAT | OBSOLETE | nvarchar | 8 | 0 | | |
| 5 | N1SNPH | Std.Nurs.Plan: Header Data | 10 | VTDAT | Standard Plan: Validity End Date | nvarchar | 8 | 0 | | |
| TOPPatient Accounting |
| 6 | NCIR | IS-H: Insurance Relationships of a Case | 92 | VTDAT | IS-H: Date of Report on Paid Copayment Days | nvarchar | 8 | 0 | | |
| TOPPatient Management |
| 7 | NVVF | IS-H: Case-Related Insurance Relationships | 36 | VTDAT | IS-H: Date of Report on Paid Copayment Days | nvarchar | 8 | 0 | | |
