INT_CI_WEEKLY_SNAPSHOT_REPORT

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 DOW_SEQ BIGINT 8
2 DAY_NAME CHARACTER VARYING(9) 9
3 NEW_CLAIM_COUNT BIGINT 8
4 REOPEN_CLAIM_COUNT BIGINT 8
5 CLOSED_CLAIM_COUNT BIGINT 8
6 ACTIVE_CLAIM_COUNT INTEGER 4
7 ASSIGNEDGROUPID BIGINT 8
8 POLICYTYPE_ID BIGINT 8
9 BRAND_ID BIGINT 8
10 SIESCALATESIU BIGINT 8
11 CATASTROPHE_ID BIGINT 8
12 LITIGATION_MATTER CHARACTER VARYING(6) 6
13 RECOVERY_STATUS CHARACTER VARYING(14) 14
14 SETTLEMENT_FLAG CHARACTER VARYING(3) 3