FCT_PI_HOME_CLAIM_STOCK_MOVEMENT_INSIGHT

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 REPORT_MONTH TIMESTAMP 8
2 CLAIM_ID BIGINT 8
3 CLAIM_NUMBER CHARACTER VARYING(40) 40
4 LOSS_GROUP CHARACTER VARYING(15) 15
5 RISK_REGION CHARACTER VARYING(8) 8
6 BRAND CHARACTER VARYING(256) 256
7 OP_LOB CHARACTER VARYING(16) 16
8 RISK_STATE_NAME CHARACTER VARYING(256) 256
9 PRODUCT_NAME CHARACTER VARYING(256) 256
10 ACTIVE_START_COUNT NUMERIC(38,0) 19
11 NEW_CLAIM_COUNT NUMERIC(38,0) 19
12 REOPEN_COUNT NUMERIC(38,0) 19
13 CLOSED_COUNT NUMERIC(38,0) 19
14 ACTIVE_END_COUNT NUMERIC(38,0) 19