| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPPatient Management |
| 1 | N1ANF | IS-H*MED: Request | 38 | DILTX | Indicator that Long Text Exists | nvarchar | 1 | 0 | | |
| 2 | N1VKG | IS-H: Item of Clinical Order (Preregistration) | 14 | DILTX | Indicator that Long Text Exists | nvarchar | 1 | 0 | | |
| 3 | NDIA | IS-H: Diagnoses | 14 | DILTX | Indicator that Long Text Exists | nvarchar | 1 | 0 | | |
| 4 | NDIP | IS-H: Diagnoses for Preregistered Patient | 16 | DILTX | Indicator that Long Text Exists | nvarchar | 1 | 0 | | |
| TOPSAP Ambulatory Care Management |
| 5 | NREDOMA_DIAG | IS-H: Renewable Documents - Diagnoses | 12 | DILTX | Language Key | nvarchar | 1 | 0 | | |
