INT_PI_CLAIM_INSURED

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
2 CCR_CC_CLAIM_ID BIGINT 8
3 CCR_CC_CLAIM_CLAIMNUMBER CHARACTER VARYING(40) 40
4 CCR_CC_CLAIM_LOSSTYPE BIGINT 8
5 CCR_CC_CLAIM_LOSSCAUSE BIGINT 8
6 LOSSCAUSESUBTYPE_ID BIGINT 8
7 CCR_CC_CLAIM_STATE BIGINT 8
8 REPORT_ONLY_FLAG CHARACTER VARYING(1) 1
9 CCR_CC_POLICY_SC_LINEOFBUSINESS BIGINT 8
10 CCR_CC_POLICY_SC_BRAND BIGINT 8
11 CCR_CC_POLICY_SC_INTERMEDTYPE BIGINT 8
12 RISK_CCR_CC_ADDRESS_STATE BIGINT 8
13 LODGEMENT_DATE DATE 4
14 LODGEMENT_TIME TIMESTAMP 8
15 CCR_CC_CLAIM_SC_INCIDENTREPORT BIGINT 8
16 CCR_CC_CLAIM_CATASTROPHEID BIGINT 8
17 CLOSED_DATE DATE 4
18 CCR_CC_CLAIM_CLOSEDATE TIMESTAMP 8
19 ASIS_REOPENED_DATE DATE 4
20 CCR_CC_CLAIM_REOPENDATE TIMESTAMP 8
21 ASIS_REOPENED_FLAG CHARACTER VARYING(1) 1
22 CCR_CC_POLICY_POLICYTYPE BIGINT 8
23 CCR_CC_CLAIM_INSUREDDENORMID BIGINT 8
24 CCR_CC_CLAIM_SC_CLOSEDOUTCOME BIGINT 8
25 CCR_CC_CLAIM_SC_CLAIMDECISION BIGINT 8
26 CCR_CC_CLAIM_SIUSTATUS BIGINT 8
27 CCR_CCX_SC_CLAIMAUTO_REFERINVESTIGATION CHARACTER VARYING(1) 1
28 SPECIALNEED_FLAG CHARACTER VARYING(3) 3
29 POLICYNUMBER CHARACTER VARYING(40) 40
30 EXCESS_AMT NUMERIC(18,2) 19
31 CLAIM_SELF_SERVICE_FLAG CHARACTER VARYING(1) 1
32 REPAIRER_ID BIGINT 8
33 REPAIRER_NAME CHARACTER VARYING(120) 120
34 QUALITYISSUE_FLAG CHARACTER VARYING(1) 1
35 POLICY_PAYMENT_MODE BIGINT 8
36 ACTIVITY_OVERDUE_FLAG CHARACTER VARYING(1) 1
37 TOTAL_PAYMENTS NUMERIC(18,2) 19
38 INCIDENTID BIGINT 8
39 HOWREPORTED BIGINT 8
40 POLICYID BIGINT 8
41 HOWREPORTED_DESC CHARACTER VARYING(256) 256
42 POLICYTYPE_DESC CHARACTER VARYING(256) 256
43 SC_ASSESSMENTTOTALLOSS BIGINT 8
44 VEHICLE_DRIVABLE_FLAG CHARACTER(1) 1