INT_MOTOR_RECOVERY

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 CCR_CC_POLICY_SC_LINEOFBUSINESS BIGINT 8
9 CCR_CC_POLICY_SC_BRAND BIGINT 8
10 LODGEMENT_DATE DATE 4
11 FINALISED_DATE DATE 4
12 MOTOR_AGE_OF_CLAIM_1 INTEGER 4
13 AGE_OF_CLAIM INTEGER 4
14 AGE_OF_CLAIM_BAND_ID INTEGER 4
15 XREF_TYPE_ID INTEGER 4
16 INSURED_CCR_CC_VEHICLE_STYLE BIGINT 8
17 CCR_CC_CLAIM_ASSIGNEDUSERID BIGINT 8
18 CCR_CC_CLAIM_ASSIGNEDGROUPID BIGINT 8
19 LOSS_CCR_CC_ADDRESS_STATE BIGINT 8
20 CCR_CC_CLAIM_SC_INCIDENTREPORT BIGINT 8
21 RECOVERY_SOURCE BIGINT 8
22 CCR_CC_NEGOTIATIONLINE_ID BIGINT 8
23 CC_SUBROADVERSEPARTY_CLASSIFICATION BIGINT 8
24 DEMAND_SENT_TPI_STATUS BIGINT 8
25 SUBROSTRATEGY_ID BIGINT 8
26 DEMAND_SENT_COUNT BIGINT 8
27 CCR_CC_NEGOTIATIONLINE_AMOUNT NUMERIC(18,2) 19
28 DEMAND_SENT_AMOUNT NUMERIC(18,2) 19
29 DEMAND_SENT_DATE TIMESTAMP 8
30 CCR_CC_TRANSACTION_SC_GLSERVICEACKTIME TIMESTAMP 8
31 CCR_CC_SUBROADVERSEPARTY_SC_EXPECTEDRECOVERYAMT NUMERIC(18,2) 19
32 EXPECTED_RECOVERY_AMOUNT NUMERIC(18,2) 19
33 UNDEMANDED_AMOUNT NUMERIC(19,2) 19
34 CCR_CC_TRANSACTION_SC_GLSERVICEACKDATE DATE 4
35 RECOVERY_COUNT NUMERIC(38,0) 19
36 CCR_CC_NEGOTIATION_ID BIGINT 8
37 CCR_CC_TRANSACTION_TRANSACTIONAMOUNT NUMERIC(38,2) 19
38 RECOVERY_AMOUNT NUMERIC(38,2) 19
39 UNRECOVERED_AMOUNT NUMERIC(38,2) 19
40 CC_SUBROADVERSEPARTY_SC_RECOVERYSTATUS BIGINT 8
41 CCR_CCX_SC_RECOVERIESCALDATA_SD_ADJUSTMENTREASON BIGINT 8
42 CCR_CCX_SC_RECOVERIESCALDATA_SN_ADJUSTMENTREASON BIGINT 8
43 CCR_CC_SUBROADVERSEPARTY_ADVERSEPARTYID BIGINT 8
44 AGE_OF_DEMAND BIGINT 8
45 AGE_OF_DEMAND_BAND_ID INTEGER 4
46 CURRENT_RECOVERY_AGENT CHARACTER VARYING(120) 120
47 TIER CHARACTER VARYING(256) 256
48 FINAL_RECALLED_AGENT CHARACTER VARYING(120) 120
49 DATE_OUTSOURCED TIMESTAMP 8
50 DATE_RETURNED TIMESTAMP 8
51 DAYS_OUTSOURCED INTEGER 4
52 RECALL_OUTSOURCED_DAYS INTEGER 4
53 CCR_CC_ASSESSMENTSOURCE_ASSESSORID BIGINT 8
54 DEMAND_RECEIVED_COUNT BIGINT 8
55 CCR_CC_EVALUATION_SC_SETTLINGTPINSURANCE CHARACTER VARYING(1) 1
56 DEMAND_RECEIVED_TPI_STATUS BIGINT 8
57 DEMAND_RECEIVED_AMOUNT NUMERIC(38,2) 19
58 DEMAND_RECEIVED_DATE TIMESTAMP 8
59 SETTLEMENT_COUNT BIGINT 8
60 SETTLEMENT_AMOUNT NUMERIC(38,2) 19
61 SETTLEMENT_DATE TIMESTAMP 8
62 CCR_CCX_SC_EVALUATIONCALDATA_RN_ADJUSTMENTREASON BIGINT 8
63 AGE_OF_SETTLEMENT BIGINT 8
64 AGE_OF_SETTLEMENT_BAND_ID INTEGER 4
65 CCR_CC_CLAIM_FAULTRATING BIGINT 8
66 CCR_CCX_SC_CLAIMAUTO_SC_RESPONSIBLEPARTYIDENTIFIED INTEGER 4
67 CCR_CC_CLAIM_SC_CLOSEDOUTCOME BIGINT 8
68 CLAIMEVENTQUESTIONS_DANGEROUSHAZARDOUSGOODS BIGINT 8
69 POLICY_INTERMEDIARY_CC_CONTACT_ID BIGINT 8
70 POLICY_INTERMEDIARY_NAME CHARACTER VARYING(120) 120
71 CLAIM_PROCESS_TYPE_ID BIGINT 8
72 FLEET_MANAGER_IND CHARACTER VARYING(22) 22
73 CCR_CC_POLICY_POLICYTYPE BIGINT 8
74 POLICY_TYPE_ID BIGINT 8
75 CCR_CC_CLAIM_LOSSDATE TIMESTAMP 8
76 OWNING_AGENCY_IND CHARACTER VARYING(16) 16
77 OWNING_AGENCY_NAME CHARACTER VARYING(120) 120
78 FLEET_IND CHARACTER VARYING(9) 9
79 CAS_IND CHARACTER VARYING(9) 9
80 POLICYNUMBER CHARACTER VARYING(40) 40
81 SC_ASSIGNEDUSERID BIGINT 8
82 RECOVERY_OWNER_ID BIGINT 8
83 SC_SETTLEMENTASSIGNEDUSERID BIGINT 8
84 SETTLEMENTASSIGNEDUSERID BIGINT 8
85 SUBROCLOSEDATE DATE 4
86 RECOVERY_CLOSED_DATE TIMESTAMP 8
87 SC_LEGACYCLAIMNO CHARACTER VARYING(255) 255