Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
Broadcast Messaging | ||||||||||
1 | CRMD_BM_MESADD | broadcast messaging table for additional fields | 3 | ADDITION | CRM Broadcast Messaging string | ntext | 1073741823 | 0 | ||
Claims Management | ||||||||||
2 | ICLVISION | Vision Findings | 18 | ADDITION | Addition | decimal | 5 | 2 | ||
3 | ICSVISION | Eyeglass Prescription | 18 | ADDITION | Addition | decimal | 5 | 2 | ||
Incentive and Commission Management ICM | ||||||||||
4 | CACS_CTCOREX | Correspondence Enhancement | 17 | ADDITION | Additional Indicator | nvarchar | 2 | 0 | ||
5 | TCACS_ADD | Additional Indicator | 3 | ADDITION | Additional Indicator | nvarchar | 2 | 0 | ||
6 | TCACS_ADDT | Additional Indicator Text | 4 | ADDITION | Additional Indicator | nvarchar | 2 | 0 | ||
7 | TCACS_KOART | Correspondence Type | 11 | ADDITION | Additional Indicator | nvarchar | 2 | 0 |