Data Archive
- Data Archive 6.4.3
- All Products
Column | Description |
---|---|
POLICY_NO | Automobile insurance policy number (primary key column) |
TERM_DATE | Policy termination date |
LAST_TRANS | Date of last message for the policy |
... | … |
Column | Description |
---|---|
MSG_ID | Message ID (primary key column) |
POLICY_NO | Policy number related to the message (foreign key column) |
LAST_TRANS_DATE | Message date |
... | … |
Column | Description |
---|---|
CLAIM_NO | Claim number (primary key column) |
POLICY_NO | Policy number related to the claim (foreign key column) |
LAST_DATE | Date of last message for the claim |
RESOLVE_DATE | Claim resolution date |
CLAIM_TYPE | Claim type: property (1) or bodily injury (2) |
CLAIM_AMT | Claim damage amount |
... | … |