| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClaims Management |
1 | ICLDRGITEM | DRG Item | 22 | CATAID | Catalog of Major Diagnostic Category (MDC) | nvarchar | 4 | 0 | | |
2 | ICLSERVCAT | FS-CM: Benefits/Services/Fees Catalogs | 40 | CATAID | Catalog for Major Diagnostic Categories (MDC) | nvarchar | 4 | 0 | | |
3 | ICSDRGITEM | DRG Item | 22 | CATAID | Catalog of Major Diagnostic Category (MDC) | nvarchar | 4 | 0 | | |
4 | TICL350 | Name of Diagnosis Catalog | 2 | CATAID | Catalog Code | nvarchar | 4 | 0 | | |
5 | TICL350T | Texts for Diagnosis Catalog Name | 3 | CATAID | Catalog Code | nvarchar | 4 | 0 | | |
6 | TICL351 | Diagnosis catalog | 2 | CATAID | Catalog Code | nvarchar | 4 | 0 | | |
7 | TICL351T | Texts for Diagnosis Catalog | 3 | CATAID | Catalog Code | nvarchar | 4 | 0 | | |
8 | TICL353 | Diagnosis: Permitted Localization | 2 | CATAID | Catalog Code | nvarchar | 4 | 0 | | |
9 | TICL355 | Diagnosis: Permitted Severity | 2 | CATAID | Catalog Code | nvarchar | 4 | 0 | | |
10 | TICL357 | Permitted Morphology | 2 | CATAID | Catalog Code | nvarchar | 4 | 0 | | |
11 | TICL359 | Diagnosis: Permitted Excoriation | 2 | CATAID | Catalog Code | nvarchar | 4 | 0 | | |
12 | TICL362 | Diagnosis Group | 2 | CATAID | Catalog Code | nvarchar | 4 | 0 | | |
13 | TICL362T | Texts for Diagnosis Group | 3 | CATAID | Catalog Code | nvarchar | 4 | 0 | | |
14 | TICL370 | Diagnosis-Specific Attributes | 2 | CATAID | Catalog Code | nvarchar | 4 | 0 | | |
15 | TICL371 | Internal Claim Type: Permitted Diagnosis Catalogs | 6 | CATAID | Catalog Code | nvarchar | 4 | 0 | | |