| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClaims Management |
1 | ICLDRGITEM | DRG Item | 16 | SCPOSID_EXT | Item in Catalog of Diagnosis Related Group (DRG) | nvarchar | 20 | 0 | | |
2 | ICLITEM | Claim Item | 19 | SCPOSID_EXT | ID of a Benefits Catalog Item | nvarchar | 20 | 0 | | |
3 | ICLPROCEDURES | Procedures | 10 | SCPOSID_EXT | ID of a Benefits Catalog Item | nvarchar | 20 | 0 | | |
4 | ICLSERVCAT | FS-CM: Benefits/Services/Fees Catalogs | 16 | SCPOSID_EXT | ID of a Benefits Catalog Item | nvarchar | 20 | 0 | | |
5 | ICL_WCMPD_SCH | FS-CM: Item Data Workers Compensation | 18 | SCPOSID_EXT | ID of a Benefits Catalog Item | nvarchar | 20 | 0 | | |
6 | ICSDRGITEM | DRG Item | 16 | SCPOSID_EXT | Item in Catalog of Diagnosis Related Group (DRG) | nvarchar | 20 | 0 | | |
7 | ICSITEM | Claim Item | 19 | SCPOSID_EXT | ID of a Benefits Catalog Item | nvarchar | 20 | 0 | | |
8 | ICSPROCEDURES | Procedures | 10 | SCPOSID_EXT | ID of a Benefits Catalog Item | nvarchar | 20 | 0 | | |
9 | ICS_WCMPD_SCH | FS-CM: Scheduled Workers Compensation | 18 | SCPOSID_EXT | ID of a Benefits Catalog Item | nvarchar | 20 | 0 | | |