INT_PI_MOTOR_CLAIM_CATEGORY

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(8) 8
5 RISK_STATE_NAME CHARACTER VARYING(256) 256
6 LOSSCAUSE_MGMT CHARACTER VARYING(40) 40
7 LOSS_GROUP CHARACTER VARYING(15) 15
8 SUBLOSS_GROUP CHARACTER VARYING(18) 18
9 ASSESS_FLAG CHARACTER VARYING(12) 12
10 EXPOSURE_TYPE CHARACTER VARYING(19) 19
11 FIN_EXPOSURE_TYPE CHARACTER VARYING(10) 10
12 CATEGORY CHARACTER VARYING(40) 40
13 SUBCATEGORY CHARACTER VARYING(7) 7
14 GROSS_INCURRED_BAND CHARACTER VARYING(13) 13
15 GIC_BUILDING CHARACTER VARYING(13) 13
16 GIC_CONTENTS CHARACTER VARYING(13) 13
17 COST NUMERIC(38,8) 19