| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClaims Management |
1 | ICLDRGITEM | DRG Item | 15 | SERVCAT | Catalog of Diagnosis Related Group (DRG) | nvarchar | 10 | 0 | | |
2 | ICLITEM | Claim Item | 18 | SERVCAT | ID of a Benefits, Services and Fees Catalog | nvarchar | 10 | 0 | | |
3 | ICLPROCEDURES | Procedures | 9 | SERVCAT | ID of a Benefits, Services and Fees Catalog | nvarchar | 10 | 0 | | |
4 | ICL_WCMPH | Workers Comp - Header Data | 22 | SERVCAT | Internal ID of Benefits Catalog Item | nvarchar | 32 | 0 | | |
5 | ICSDRGITEM | DRG Item | 15 | SERVCAT | Catalog of Diagnosis Related Group (DRG) | nvarchar | 10 | 0 | | |
6 | ICSITEM | Claim Item | 18 | SERVCAT | ID of a Benefits, Services and Fees Catalog | nvarchar | 10 | 0 | | |
7 | ICSPROCEDURES | Procedures | 9 | SERVCAT | ID of a Benefits, Services and Fees Catalog | nvarchar | 10 | 0 | | |
8 | ICS_WCMPH | Workers Comp - Header Data | 22 | SERVCAT | Internal ID of Benefits Catalog Item | nvarchar | 32 | 0 | | |