FCT_MOTOR_HOME_PAYMENT_INSIGHT

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CCR_CC_TRANSACTION_CLAIMID BIGINT 8
2 CCR_CC_CLAIM_CLAIMNUMBER CHARACTER VARYING(40) 40
3 CCR_CC_TRANSACTIONLINEITEM_ID BIGINT 8
4 CCR_CC_TRANSACTIONLINEITEM_LINECATEGORY_ID BIGINT 8
5 CCR_CC_TRANSACTIONLINEITEM_LINECATEGORY_LABEL CHARACTER VARYING(20) 20
6 CCR_CC_CLAIM_CLAIMNUMBER_GROUP CHARACTER VARYING(1) 1
7 CCR_CC_TRANSACTION_ID BIGINT 8
8 CCR_CC_TRANSACTION_PAYMENTTYPE_ID BIGINT 8
9 CCR_CC_TRANSACTION_COSTCATEGORY_ID BIGINT 8
10 CCR_CC_TRANSACTION_COSTTYPE_ID BIGINT 8
11 CCR_CC_TRANSACTION_STATUS_ID BIGINT 8
12 CCR_CC_TRANSACTION_CHECKID BIGINT 8
13 CCR_CC_CHECK_STATUS_ID BIGINT 8
14 CCR_CC_CLAIM_LOSSTYPE BIGINT 8
15 CCR_CC_CLAIM_LOSSCAUSE BIGINT 8
16 DIM_LOSSCAUSE_NAME CHARACTER VARYING(256) 256
17 LOSSCAUSESUBTYPE_ID BIGINT 8
18 DIM_LOSSCAUSESUBTYPE_NAME CHARACTER VARYING(256) 256
19 CCR_CC_POLICY_SC_BRAND BIGINT 8
20 RISK_CCR_CC_ADDRESS_STATE BIGINT 8
21 CCR_CC_POLICY_POLICYTYPE BIGINT 8
22 CCR_CC_POLICY_SC_LINEOFBUSINESS BIGINT 8
23 INSURED_CCR_CC_VEHICLE_STYLE BIGINT 8
24 CCR_CC_TRANSACTION_CREATEUSERID BIGINT 8
25 CCR_HST_CC_GROUPUSER_GROUPID BIGINT 8
26 CCR_CC_TRANSACTION_CREATETIME TIMESTAMP 8
27 CCR_CC_TRANSACTION_CREATEDATE DATE 4
28 CCR_CC_TRANSACTIONLINEITEM_TRANSACTIONAMOUNT NUMERIC(18,1) 19
29 TRANSACTIONLINEITEM_TRANSACTIONAMOUNT_POSITIVE_ONLY NUMERIC(18,1) 19
30 NUMBER_OF_PAYMENT_LINES INTEGER 4
31 CCR_CC_CHECK_CHECKNUMBER CHARACTER VARYING(255) 255
32 CCR_CC_CHECK_PAYTO CHARACTER VARYING(255) 255
33 CCR_CC_CHECK_MAILTO CHARACTER VARYING(255) 255
34 CCR_CC_CHECK_REPORTABLEAMOUNT NUMERIC(18,1) 19
35 CCR_CC_CHECK_ISSUEDATE TIMESTAMP 8
36 CCR_CC_CHECK_SC_PRESENTEDCLEAREDDATE TIMESTAMP 8
37 CCR_CC_CHECK_SC_DATEOFINVOICE TIMESTAMP 8
38 CCR_CCTL_SC_PAYMENTMETHOD_ID BIGINT 8
39 CCR_CCTL_CHECKBATCHING_ID BIGINT 8
40 CCR_CCTL_DELIVERYMETHOD_ID BIGINT 8
41 CCR_CCTL_SC_CHECKPAYAPPLICATION_ID BIGINT 8
42 LOSS_CCR_CC_ADDRESS_STATE_ID BIGINT 8
43 LOSS_CCR_CC_ADDRESS_POSTALCODE CHARACTER VARYING(60) 60
44 LOSS_POSTCODE_KEY CHARACTER VARYING(110) 110
45 LOSS_REGION_NAME CHARACTER VARYING(15) 15
46 LOSS_STATE_NAME CHARACTER VARYING(256) 256
47 EVENT_NAME CHARACTER VARYING(256) 256
48 AGE_OF_PAYMENT INTEGER 4
49 DOCUMENT_CREATE_DATE DATE 4
50 POLICY_INTERMEDIARY_CC_CONTACT_ID BIGINT 8
51 POLICY_INTERMEDIARY_REFERENCE_CODE CHARACTER VARYING(40) 40
52 POLICY_INTERMEDIARY_NAME CHARACTER VARYING(120) 120
53 CLAIM_PROCESS_TYPE_ID BIGINT 8
54 CCR_CC_CLAIM_LOSSDATE TIMESTAMP 8
55 FLEET_IND CHARACTER VARYING(9) 9
56 CAS_IND CHARACTER VARYING(9) 9
57 PROFIT_CENTRE CHARACTER VARYING(60) 60
58 COST_CENTRE CHARACTER VARYING(15) 15
59 COST_CENTRE_REFERENCE CHARACTER VARYING(15) 15
60 POLICYNUMBER CHARACTER VARYING(40) 40
61 CCR_CCTL_FAULTRATING_ID BIGINT 8
62 CCR_CCTL_FAULTRATING_NAME CHARACTER VARYING(256) 256
63 CCR_CC_TRANSACTIONLINEITEM_LINECATEGORY_NAME CHARACTER VARYING(256) 256
64 CCR_CC_TRANSACTION_COSTCATEGORY_NAME CHARACTER VARYING(256) 256
65 CCR_CC_TRANSACTION_STATUS_NAME CHARACTER VARYING(256) 256
66 CCR_CC_CLAIM_LOSSTYPE_NAME CHARACTER VARYING(256) 256
67 CCR_CC_POLICY_SC_BRAND_NAME CHARACTER VARYING(256) 256
68 RISK_CCR_CC_ADDRESS_STATE_NAME CHARACTER VARYING(256) 256
69 RISK_CCR_CC_ADDRESS_REGION CHARACTER VARYING(15) 15
70 CCR_CC_POLICY_POLICYTYPE_NAME CHARACTER VARYING(256) 256
71 CCR_CC_POLICY_SC_LINEOFBUSINESS_NAME CHARACTER VARYING(256) 256
72 CCR_CC_TRANSACTION_COSTTYPE_NAME CHARACTER VARYING(256) 256
73 INSURED_CCR_CC_VEHICLE_STYLE_NAME CHARACTER VARYING(256) 256
74 CCR_CCTL_SC_PAYMENTMETHOD_NAME CHARACTER VARYING(256) 256
75 CCR_CCTL_CHECKBATCHING_NAME CHARACTER VARYING(256) 256
76 CCR_CCTL_SC_CHECKPAYAPPLICATION_NAME CHARACTER VARYING(256) 256
77 CCR_CCTL_DELIVERYMETHOD_NAME CHARACTER VARYING(256) 256
78 CCR_CC_CHECK_STATUS_NAME CHARACTER VARYING(256) 256
79 CLAIM_PROCESS_TYPE_NAME CHARACTER VARYING(256) 256
80 CCR_CC_TRANSACTION_CREATEUSERID_AUT_USER_NAME CHARACTER VARYING(181) 181
81 CCR_CC_TRANSACTION_CREATEUSERID_AUT_TEAM_NAME CHARACTER VARYING(100) 100
82 CCR_CC_TRANSACTION_CREATEUSERID_AUT_GROUP_TYPE_NAME CHARACTER VARYING(256) 256
83 CCR_CC_TRANSACTION_CREATEUSERID_AU_USER_NAME CHARACTER VARYING(181) 181
84 CCR_CC_TRANSACTION_CREATEUSERID_AU_TEAM_NAME CHARACTER VARYING(100) 100
85 CCR_CC_TRANSACTION_CREATEUSERID_AU_GROUP_TYPE_NAME CHARACTER VARYING(256) 256
86 CCR_CC_TRANSACTION_CREATEUSERID_AU_PAYMENTS_GROUP_1 CHARACTER VARYING(256) 256
87 CCR_HST_CC_GROUPUSER_GROUPID_AT_NAME CHARACTER VARYING(100) 100
88 CCR_HST_CC_GROUPUSER_GROUPID_AT_TEAM_TYPE CHARACTER VARYING(256) 256
89 CCR_HST_CC_GROUPUSER_GROUPID_AT_PAYMENTS_GROUP_1 CHARACTER VARYING(256) 256
90 CCR_CC_CHECK_PAYTO_PAYEE_NAME_SPLIT CHARACTER VARYING(9) 9
91 LEGACY_CLAIMNO CHARACTER VARYING(255) 255
92 LEGACYCLAIM_FLAG CHARACTER VARYING(3) 3
93 LEGACYCLAIM_CATEGORY CHARACTER VARYING(256) 256
94 CCR_CC_CHECK_INVOICENUMBER CHARACTER VARYING(255) 255