INT_CLAIM_CI

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 CLAIM_STOCK_STATUS_ID INTEGER 4
9 REPORT_ONLY_FLAG CHARACTER VARYING(1) 1
10 CREATED_AS_REPORT_ONLY_FLAG CHARACTER VARYING(1) 1
11 CCR_CC_POLICY_SC_LINEOFBUSINESS BIGINT 8
12 CCR_CC_POLICY_SC_BRAND BIGINT 8
13 CCR_CC_POLICY_SC_INTERMEDTYPE BIGINT 8
14 RISK_CCR_CC_ADDRESS_STATE BIGINT 8
15 RISK_CCR_CC_ADDRESS_POSTALCODE CHARACTER VARYING(60) 60
16 RISK_CCR_CC_ADDRESS_COUNTRY BIGINT 8
17 LOSS_CCR_CC_ADDRESS_STATE BIGINT 8
18 LOSS_CCR_CC_ADDRESS_COUNTRY BIGINT 8
19 LOSS_CCR_CC_ADDRESS_POSTALCODE CHARACTER VARYING(60) 60
20 LODGEMENT_DATE DATE 4
21 LODGEMENT_TIME TIMESTAMP 8
22 INITIAL_FINALISED_DATE DATE 4
23 INITIAL_FINALISED_TIME TIMESTAMP 8
24 CCR_CC_CLAIM_SC_INCIDENTREPORT BIGINT 8
25 FINALISED_DATE DATE 4
26 FINALISED_TIME TIMESTAMP 8
27 MOTOR_AGE_OF_CLAIM_1 INTEGER 4
28 REOPENED_DATE DATE 4
29 REOPENED_TIME TIMESTAMP 8
30 CREATED_DATE DATE 4
31 CCR_CC_CLAIM_CREATETIME TIMESTAMP 8
32 CLAIM_ELAPSED_ACTIVE_AGE INTEGER 4
33 CCR_CC_CLAIM_UPDATEUSERID BIGINT 8
34 CCR_CC_CLAIM_ASSIGNEDGROUPID BIGINT 8
35 CCR_CC_CLAIM_ASSIGNEDUSERID BIGINT 8
36 CCR_CC_CLAIM_CATASTROPHEID BIGINT 8
37 CLOSED_DATE DATE 4
38 CCR_CC_CLAIM_CLOSEDATE TIMESTAMP 8
39 ASIS_REOPENED_DATE DATE 4
40 CCR_CC_CLAIM_REOPENDATE TIMESTAMP 8
41 ASIS_REOPENED_FLAG CHARACTER VARYING(1) 1
42 CCR_CC_POLICY_POLICYTYPE BIGINT 8
43 CCR_CC_CLAIM_INSUREDDENORMID BIGINT 8
44 CCR_CC_CLAIM_SC_CLOSEDOUTCOME BIGINT 8
45 CCR_CC_CLAIM_SC_CLAIMDECISION BIGINT 8
46 CCR_CC_CLAIM_SIUSTATUS BIGINT 8
47 CCR_CCX_SC_CLAIMAUTO_REFERINVESTIGATION CHARACTER VARYING(1) 1
48 SPECIALNEED_TYPE_CODE_NAME CHARACTER VARYING(50) 50
49 SPECIALNEED_TYPE_CODE BIGINT 8
50 CCR_CC_CLAIM_FAULTRATING BIGINT 8
51 CCR_CCX_SC_CLAIMAUTO_SC_RESPONSIBLEPARTYIDENTIFIED CHARACTER VARYING(1) 1
52 CLAIMEVENTQUESTIONS_DANGEROUSHAZARDOUSGOODS BIGINT 8
53 POLICY_INTERMEDIARY_CC_CONTACT_ID BIGINT 8
54 POLICY_INTERMEDIARY_NAME CHARACTER VARYING(120) 120
55 POLICY_INTERMEDIARY_REFERENCE_CODE CHARACTER VARYING(40) 40
56 CLAIM_PROCESS_TYPE_ID BIGINT 8
57 FLEET_MANAGER_IND CHARACTER VARYING(22) 22
58 FLEET_MANAGER_NAME CHARACTER VARYING(181) 181
59 PROFIT_CENTRE CHARACTER VARYING(60) 60
60 COST_CENTRE CHARACTER VARYING(15) 15
61 COST_CENTRE_REFERENCE CHARACTER VARYING(15) 15
62 CCR_CC_CLAIM_LOSSDATE TIMESTAMP 8
63 OWNING_AGENCY_IND CHARACTER VARYING(16) 16
64 OWNING_AGENCY_NAME CHARACTER VARYING(120) 120
65 FLEET_IND CHARACTER VARYING(9) 9
66 CAS_IND CHARACTER VARYING(7) 7
67 POLICYNUMBER CHARACTER VARYING(40) 40
68 SC_SETTLEMENTASSIGNEDUSERID BIGINT 8
69 INTERMEDIARY_TYPE_CODE CHARACTER VARYING(50) 50
70 SC_LEGACYCLAIMNO CHARACTER VARYING(255) 255
71 CCR_CC_USER_CONTACTID BIGINT 8