| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClaims Management |
1 | ICLDRGITEM | DRG Item | 23 | DIAGID | Catalog Item of Major Diagnostic Category (MDC) | nvarchar | 10 | 0 | | |
2 | ICLSERVCAT | FS-CM: Benefits/Services/Fees Catalogs | 41 | DIAGID | Code of an MDC Item | nvarchar | 10 | 0 | | |
3 | ICSDRGITEM | DRG Item | 23 | DIAGID | Catalog Item of Major Diagnostic Category (MDC) | nvarchar | 10 | 0 | | |
4 | TICL351 | Diagnosis catalog | 3 | DIAGID | Diagnosis Code | nvarchar | 10 | 0 | | |
5 | TICL351T | Texts for Diagnosis Catalog | 4 | DIAGID | Diagnosis Code | nvarchar | 10 | 0 | | |
6 | TICL353 | Diagnosis: Permitted Localization | 3 | DIAGID | Diagnosis Code | nvarchar | 10 | 0 | | |
7 | TICL355 | Diagnosis: Permitted Severity | 3 | DIAGID | Diagnosis Code | nvarchar | 10 | 0 | | |
8 | TICL357 | Permitted Morphology | 3 | DIAGID | Diagnosis Code | nvarchar | 10 | 0 | | |
9 | TICL359 | Diagnosis: Permitted Excoriation | 3 | DIAGID | Diagnosis Code | nvarchar | 10 | 0 | | |
10 | TICL370 | Diagnosis-Specific Attributes | 3 | DIAGID | Diagnosis Code | nvarchar | 10 | 0 | | |