FCT_CI_CLAIM_CONTACT_DRILLTHRU

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BRAND BIGINT 8
2 BRAND_NAME CHARACTER VARYING(256) 256
3 CLAIM_CREATED_DATE TIMESTAMP 8
4 CLAIM_CREATED_DATE_LBL CHARACTER VARYING(30) 30
5 CLAIM_CREATED_DATE_ID INTEGER 4
6 CLAIM_CREATE_DATE_CAL_YEAR INTEGER 4
7 CLAIM_CREATE_DATE_CAL_QUARTER INTEGER 4
8 CLAIM_CREATE_DATE_CAL_MONTH INTEGER 4
9 CLAIM_CREATE_DATE_CAL_DAY INTEGER 4
10 CLAIM_CREATE_DATE_DAY_TYPE_ID INTEGER 4
11 CLAIM_CREATE_DATE_WEEK_TYPE_ID INTEGER 4
12 CLAIM_CREATE_DATE_MONTH_TYPE_ID INTEGER 4
13 CLAIM_CREATE_DATE_QUARTER_TYPE_ID INTEGER 4
14 CLAIM_CREATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
15 CLAIM_CREATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
16 CLAIM_CREATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
17 CLAIM_CREATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
18 CLAIM_CREATE_DATE_HALF_TYPE_ID INTEGER 4
19 CLAIM_NUMBER CHARACTER VARYING(40) 40
20 VERIFIED_POLICY_FLAG INTEGER 4
21 VERIFIED_POLICY CHARACTER VARYING(256) 256
22 CLAIM_DURATION_ID INTEGER 4
23 CLAIM_DURATION_BAND_ID INTEGER 4
24 CLAIM_DURATION_BAND_NAME CHARACTER VARYING(14) 14
25 CLAIM_LATEST_REOPENED_DATE TIMESTAMP 8
26 CLAIM_LATEST_REOPENED_DATE_ID INTEGER 4
27 CLAIM_INITIAL_FINALISED_DATE TIMESTAMP 8
28 CLAIM_REOPENED_REASON_ID BIGINT 8
29 CLAIM_REOPENED_REASON CHARACTER VARYING(256) 256
30 CLAIM_SEGMENT_ID BIGINT 8
31 CLAIM_SEGMENT CHARACTER VARYING(256) 256
32 LOSS_CAUSE_ID BIGINT 8
33 LOSS_CAUSE_NAME CHARACTER VARYING(256) 256
34 CLAIM_STATE_ID BIGINT 8
35 CLAIM_STATE CHARACTER VARYING(256) 256
36 CLAIM_DECISION_ID BIGINT 8
37 CLAIM_DECISION_NAME CHARACTER VARYING(256) 256
38 POLICY_NUMBER CHARACTER VARYING(40) 40
39 CLAIM_LOSS_DATE TIMESTAMP 8
40 CLAIM_LOSS_DATE_ID INTEGER 4
41 CLAIM_LOSS_DATE_CAL_YEAR INTEGER 4
42 CLAIM_LOSS_DATE_CAL_QUARTER INTEGER 4
43 CLAIM_LOSS_DATE_CAL_MONTH INTEGER 4
44 CLAIM_LOSS_DATE_CAL_DAY INTEGER 4
45 CLAIM_LOSS_DATE_DAY_TYPE_ID INTEGER 4
46 CLAIM_LOSS_DATE_WEEK_TYPE_ID INTEGER 4
47 CLAIM_LOSS_DATE_MONTH_TYPE_ID INTEGER 4
48 CLAIM_LOSS_DATE_QUARTER_TYPE_ID INTEGER 4
49 CLAIM_LOSS_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
50 CLAIM_LOSS_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
51 CLAIM_LOSS_DATE_R12_MONTH_TYPE_ID INTEGER 4
52 CLAIM_LOSS_DATE_R13_MONTH_TYPE_ID INTEGER 4
53 CLAIM_LOSS_DATE_HALF_TYPE_ID INTEGER 4
54 CLAIM_EVENT_ID BIGINT 8
55 CLAIM_EVENT_CODE CHARACTER VARYING(60) 60
56 CLAIM_EVENT_NAME CHARACTER VARYING(60) 60
57 CLAIM_CONTACT_CLAIM_ID BIGINT 8
58 CLAIM_CONTACT_ABN_NUMBER CHARACTER VARYING(30) 30
59 PROVIDER_NUMBER CHARACTER VARYING(30) 30
60 DEPENDENT_UNIQUE_NUMBER BIGINT 8
61 CLAIMANT_FLAG INTEGER 4
62 CLAIMANT_FLAG_NAME CHARACTER VARYING(256) 256
63 CONTACT_PROHIBITED_FLAG INTEGER 4
64 CONTACT_PROHIBITED_FLAG_NAME CHARACTER VARYING(256) 256
65 DEPENDENT_COUNT NUMERIC(38,0) 19
66 DEPENDENT_TYPE_FLAG INTEGER 4
67 DEPENDENT_TYPE_FLAG_NAME CHARACTER VARYING(256) 256
68 CHILD_DEPENDENT_COUNT NUMERIC(38,0) 19
69 ADULT_DEPENDENT_COUNT NUMERIC(38,0) 19
70 PREFERRED_CONTACT_FLAG INTEGER 4
71 PREFERRED_CONTACT_FLAG_NAME CHARACTER VARYING(256) 256
72 AUTHORISED_PARTY_FLAG INTEGER 4
73 AUTHORISED_PARTY_FLAG_NAME CHARACTER VARYING(256) 256
74 VENDORS_SMS_SEND_FLAG INTEGER 4
75 VENDORS_SMS_SEND_FLAG_NAME CHARACTER VARYING(256) 256
76 CONTACT_BIRTH_DATE TIMESTAMP 8
77 CLAIM_CONTACT_UPDATE_TIME TIMESTAMP 8
78 CLAIM_CONTACT_CREATE_TIME TIMESTAMP 8
79 CLAIM_CONTACT_UPDATE_USER_ID BIGINT 8
80 CLAIM_CONTACT_CREATE_USER_ID BIGINT 8
81 CONTACT_UPDATE_TIME TIMESTAMP 8
82 CONTACT_CREATE_TIME TIMESTAMP 8
83 CONTACT_UPDATE_USER_ID BIGINT 8
84 CONTACT_CREATE_USER_ID BIGINT 8
85 GENDER_ID BIGINT 8
86 GENDER_NAME CHARACTER VARYING(256) 256
87 CONTACT_ROLE_ID BIGINT 8
88 CONTACT_ROLE_NAME CHARACTER VARYING(256) 256
89 BIRTH_COUNTRY_ID BIGINT 8
90 BIRTH_COUNTRY_NAME CHARACTER VARYING(256) 256
91 MARITAL_STATUS_ID BIGINT 8
92 MARITAL_STATUS_NAME CHARACTER VARYING(256) 256
93 DEPENDENT_FULL_TIME_STUDENT_TYPE_ID BIGINT 8
94 DEPENDENT_FULL_TIME_STUDENT_TYPE_NAME CHARACTER VARYING(256) 256
95 DEPENDENT_TYPE_ID BIGINT 8
96 DEPENDENT_TYPE_NAME CHARACTER VARYING(256) 256
97 DEPENDENT_RESIDING_AT_HOME_TYPE_ID BIGINT 8
98 DEPENDENT_RESIDING_AT_HOME_TYPE_NAME CHARACTER VARYING(256) 256
99 DEPENDENT_WORKING_SPOUSE_TYPE_ID BIGINT 8
100 DEPENDENT_WORKING_SPOUSE_TYPE_NAME CHARACTER VARYING(256) 256
101 CONTACT_PAYMENT_METHOD_ID BIGINT 8
102 CONTACT_PAYMENT_METHOD_NAME CHARACTER VARYING(256) 256
103 CONTACT_PAYMENT_TERMS_ID BIGINT 8
104 CONTACT_PAYMENT_TERMS_NAME CHARACTER VARYING(256) 256
105 CLAIM_CONTACT_CONTACT_ID BIGINT 8
106 CONTACT_HOME_PHONE CHARACTER VARYING(30) 30
107 CONTACT_FIRST_NAME CHARACTER VARYING(90) 90
108 CONTACT_LAST_NAME CHARACTER VARYING(90) 90
109 CONTACT_PREFIX BIGINT 8
110 CLAIM_CONTACT_ORGANISATION_FLAG INTEGER 4
111 CLAIM_CONTACT_ORGANISATION_FLAG_NAME CHARACTER VARYING(256) 256
112 CLAIM_CONTACT_NAME CHARACTER VARYING(181) 181
113 DEPENDENCY_PERCENT BIGINT 8
114 CLAIM_CONTACT_AGE NUMERIC(9,0) 19
115 CLAIM_CONTACT_AGE_BAND CHARACTER VARYING(12) 12
116 CLAIM_CONTACT_MATTER_ID BIGINT 8
117 CLAIM_CONTACT_NEGOTIATION_ID BIGINT 8
118 CLAIM_CONTACT_EXPOSURE_ID BIGINT 8
119 CLAIM_CONTACT_POLICY_ID BIGINT 8
120 CLAIM_CONTACT_INCIDENT_ID BIGINT 8
121 BRANDMARKER_LOB CHARACTER VARYING(10) 10
122 CC_CLAIMCONTACT_ID BIGINT 8
123 CLAIMCONTACTID BIGINT 8
124 ROLE BIGINT 8
125 POLICY_VERIFIED_ID CHARACTER VARYING(1) 1
126 CLAIM_POLICY_VERIFICATION_STATUS_ID BIGINT 8
127 VERIFIED_POLICY_STATUS_ID INTEGER 4
128 VERIFIED_POLICY_STATUS CHARACTER VARYING(17) 17