| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClaims Management |
1 | ICLDAMOBJ | Damaged Object | 10 | DAMAGECAT | Damage Category | nvarchar | 2 | 0 | | |
2 | ICLNOLDO | Notice of Loss: Damaged Object | 8 | DAMAGECAT | Damage Category | nvarchar | 2 | 0 | | |
3 | ICLNPROPMA | Make of Insurable Object | 2 | DAMAGECAT | Damage Category | nvarchar | 2 | 0 | | |
4 | ICLNPROPMO | Insurable Object Model | 2 | DAMAGECAT | Damage Category | nvarchar | 2 | 0 | | |
5 | ICSDAMOBJ | Damaged Object | 10 | DAMAGECAT | Damage Category | nvarchar | 2 | 0 | | |
6 | TICL006 | Damage Category | 2 | DAMAGECAT | Damage Category | nvarchar | 2 | 0 | | |
7 | TICL006T | Damage Category Text | 3 | DAMAGECAT | Damage Category | nvarchar | 2 | 0 | | |
8 | TICL016 | Damage Descriptor | 2 | DAMAGECAT | Damage Category | nvarchar | 2 | 0 | | |
9 | TICL016T | Damage Descriptor Text | 3 | DAMAGECAT | Damage Category | nvarchar | 2 | 0 | | |
10 | TICL023 | Damage Severity | 2 | DAMAGECAT | Damage Category | nvarchar | 2 | 0 | | |
11 | TICL023T | Damage Severity Text | 3 | DAMAGECAT | Damage Category | nvarchar | 2 | 0 | | |
12 | TICL040 | Damaged Object-Screen Sequence Determination | 5 | DAMAGECAT | Damage Category | nvarchar | 2 | 0 | | |
13 | TICL049 | Internal Claim Type: Permitted Damage Category | 6 | DAMAGECAT | Damage Category | nvarchar | 2 | 0 | | |
14 | TICL050 | Internal Claim Type: Permitted Damage Descriptor | 6 | DAMAGECAT | Damage Category | nvarchar | 2 | 0 | | |
15 | TICL051 | Internal Claim Type: Permitted Damage Severity | 5 | DAMAGECAT | Damage Category | nvarchar | 2 | 0 | | |
16 | TICL204 | Degree of Damage per Damage Category | 2 | DAMAGECAT | Damage Category | nvarchar | 2 | 0 | | |
17 | TICL206 | Damage Category | 2 | DAMAGECAT | Damage Category | nvarchar | 2 | 0 | | |
18 | TICL206T | Damage Category Text | 3 | DAMAGECAT | Damage Category | nvarchar | 2 | 0 | | |
19 | TICL254 | Assignment Damage Category Object Category | 2 | DAMAGECAT | Damage Category | nvarchar | 2 | 0 | | |
20 | TICL271 | Assignment Object Category to Damage Descriptor | 2 | DAMAGECAT | Damage Category | nvarchar | 2 | 0 | | |
21 | TICL271T | Description Damage Descriptor per Object Category | 3 | DAMAGECAT | Damage Category | nvarchar | 2 | 0 | | |