INT_PI_MOTOR_CLAIM_ESTIMATES

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 TRAN_FIN_YEAR CHARACTER VARYING(7) 7
2 TRANSACTION_MONTH TIMESTAMP 8
3 BRAND CHARACTER VARYING(256) 256
4 RISK_REGION CHARACTER VARYING(256) 256
5 RISK_STATE_NAME CHARACTER VARYING(256) 256
6 LOSSCAUSE_MGMT CHARACTER VARYING(256) 256
7 LOSS_GROUP CHARACTER VARYING(15) 15
8 SUBLOSS_GROUP CHARACTER VARYING(18) 18
9 ASSESS_FLAG CHARACTER VARYING(50) 50
10 EXPOSURE_TYPE CHARACTER VARYING(19) 19
11 FIN_EXPOSURE_TYPE CHARACTER VARYING(256) 256
12 GIC_BAND CHARACTER VARYING(13) 13
13 GIC_BUILDING CHARACTER VARYING(13) 13
14 GIC_CONTENTS CHARACTER VARYING(13) 13
15 BUILDING_ESTIMATES NUMERIC(38,2) 19
16 CONTENTS_ESTIMATES NUMERIC(38,2) 19
17 MANAGEMENT_ESTIMATES NUMERIC(38,2) 19
18 ESTIMATES_RECOVERY NUMERIC(38,2) 19
19 TOTAL_ESTIMATES NUMERIC(38,2) 19