FCT_CI_CLAIM_MATTER_DRILLTHRU

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CLAIM_CREATED_DATE TIMESTAMP 8
2 CLAIM_CREATE_DATE_DATE_KEY INTEGER 4
3 CLAIM_CREATE_DATE_CAL_YEAR INTEGER 4
4 CLAIM_CREATE_DATE_CAL_QUARTER INTEGER 4
5 CLAIM_CREATE_DATE_CAL_MONTH INTEGER 4
6 CLAIM_CREATE_DATE_CAL_DAY INTEGER 4
7 CLAIM_CREATE_DATE_DAY_TYPE_ID INTEGER 4
8 CLAIM_CREATE_DATE_WEEK_TYPE_ID INTEGER 4
9 CLAIM_CREATE_DATE_MONTH_TYPE_ID INTEGER 4
10 CLAIM_CREATE_DATE_QUARTER_TYPE_ID INTEGER 4
11 CLAIM_CREATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
12 CLAIM_CREATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
13 CLAIM_CREATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
14 CLAIM_CREATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
15 CLAIM_CREATE_DATE_HALF_TYPE_ID INTEGER 4
16 CLAIM_REJECT_REASON BIGINT 8
17 CLAIM_REJECT_REASON_NAME CHARACTER VARYING(256) 256
18 CLAIM_NUMBER CHARACTER VARYING(40) 40
19 CLAIM_DURATION_ID INTEGER 4
20 CLAIM_DURATION_BAND_ID INTEGER 4
21 CLAIM_DURATION_BAND_NAME CHARACTER VARYING(14) 14
22 CLAIM_LATEST_FINALISED_DATE TIMESTAMP 8
23 CLAIM_LATEST_FINALISED_DATE_ID INTEGER 4
24 CLAIM_LATEST_REOPENED_DATE TIMESTAMP 8
25 CLAIM_LATEST_REOPENED_DATE_ID INTEGER 4
26 CLAIM_INITIAL_FINALISED_DATE TIMESTAMP 8
27 CLAIM_INITIAL_FINALISED_DATE_YEAR INTEGER 4
28 CLAIM_INITIAL_FINALISED_DATE_QUARTER INTEGER 4
29 CLAIM_INITIAL_FINALISED_DATE_MONTH INTEGER 4
30 CLAIM_INITIAL_FINALISED_DATE_DAY INTEGER 4
31 CLAIM_INITIAL_FINALISED_DATE_DAY_TYPE_ID INTEGER 4
32 CLAIM_INITIAL_FINALISED_DATE_WEEK_TYPE_ID INTEGER 4
33 CLAIM_INITIAL_FINALISED_DATE_MONTH_TYPE_ID INTEGER 4
34 CLAIM_INITIAL_FINALISED_DATE_QUARTER_TYPE_ID INTEGER 4
35 CLAIM_INITIAL_FINALISED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
36 CLAIM_INITIAL_FINALISED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
37 CLAIM_INITIAL_FINALISED_DATE_R12_MONTH_TYPE_ID INTEGER 4
38 CLAIM_INITIAL_FINALISED_DATE_R13_MONTH_TYPE_ID INTEGER 4
39 CLAIM_INITIAL_FINALISED_DATE_HALF_TYPE_ID INTEGER 4
40 CLAIM_REOPENED_REASON_ID BIGINT 8
41 CLAIM_REOPENED_REASON CHARACTER VARYING(256) 256
42 CLAIM_SEGMENT_ID BIGINT 8
43 CLAIM_SEGMENT CHARACTER VARYING(256) 256
44 LOSS_CAUSE_ID BIGINT 8
45 LOSS_CAUSE_NAME CHARACTER VARYING(256) 256
46 CLAIM_STATE_ID BIGINT 8
47 CLAIM_STATE CHARACTER VARYING(256) 256
48 POLICY_NUMBER CHARACTER VARYING(40) 40
49 CLAIM_PRIMARY_ADJUSTER_ID BIGINT 8
50 CLAIM_ADJUSTER_LOOKUP_USER_ID BIGINT 8
51 CLAIM_ADJUSTER CHARACTER VARYING(181) 181
52 EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
53 TEAM_ID BIGINT 8
54 TEAM_NAME CHARACTER VARYING(100) 100
55 GROUP_TYPE_ID BIGINT 8
56 GROUP_TYPE_NAME CHARACTER VARYING(256) 256
57 L1_TEAM_ID BIGINT 8
58 L1_TEAM_NAME CHARACTER VARYING(100) 100
59 L2_TEAM_ID BIGINT 8
60 L2_TEAM_NAME CHARACTER VARYING(100) 100
61 L3_TEAM_ID BIGINT 8
62 L3_TEAM_NAME CHARACTER VARYING(100) 100
63 L4_TEAM_ID BIGINT 8
64 L4_TEAM_NAME CHARACTER VARYING(100) 100
65 L5_TEAM_ID BIGINT 8
66 L5_TEAM_NAME CHARACTER VARYING(100) 100
67 L6_TEAM_ID BIGINT 8
68 L6_TEAM_NAME CHARACTER VARYING(100) 100
69 L7_TEAM_ID BIGINT 8
70 L7_TEAM_NAME CHARACTER VARYING(100) 100
71 L8_TEAM_ID BIGINT 8
72 L8_TEAM_NAME CHARACTER VARYING(100) 100
73 L9_TEAM_ID BIGINT 8
74 L9_TEAM_NAME CHARACTER VARYING(100) 100
75 L10_TEAM_ID BIGINT 8
76 L10_TEAM_NAME CHARACTER VARYING(100) 100
77 L11_TEAM_ID BIGINT 8
78 L11_TEAM_NAME CHARACTER VARYING(100) 100
79 CLAIM_SIU_REFERRAL_FLAG_ID BIGINT 8
80 CLAIM_SIU_REFERRAL_FLAG CHARACTER VARYING(256) 256
81 CLAIM_SIU_STATUS_ID BIGINT 8
82 CLAIM_SIU_STATUS CHARACTER VARYING(256) 256
83 CLAIM_LOSS_DATE TIMESTAMP 8
84 CLAIM_LOSS_DATE_ID INTEGER 4
85 CLAIM_LOSS_DATE_CAL_YEAR INTEGER 4
86 CLAIM_LOSS_DATE_CAL_QUARTER INTEGER 4
87 CLAIM_LOSS_DATE_CAL_MONTH INTEGER 4
88 CLAIM_LOSS_DATE_CAL_DAY INTEGER 4
89 CLAIM_LOSS_DATE_DAY_TYPE_ID INTEGER 4
90 CLAIM_LOSS_DATE_WEEK_TYPE_ID INTEGER 4
91 CLAIM_LOSS_DATE_MONTH_TYPE_ID INTEGER 4
92 CLAIM_LOSS_DATE_QUARTER_TYPE_ID INTEGER 4
93 CLAIM_LOSS_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
94 CLAIM_LOSS_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
95 CLAIM_LOSS_DATE_R12_MONTH_TYPE_ID INTEGER 4
96 CLAIM_LOSS_DATE_R13_MONTH_TYPE_ID INTEGER 4
97 CLAIM_LOSS_DATE_HALF_TYPE_ID INTEGER 4
98 CLAIM_RISK_INDICATORS_FLAG_ID INTEGER 4
99 CLAIM_RISK_INDICATORS_FLAG_NAME CHARACTER VARYING(256) 256
100 CLAIM_EVENT_ID BIGINT 8
101 CLAIM_EVENT_CODE CHARACTER VARYING(60) 60
102 CLAIM_EVENT_NAME CHARACTER VARYING(60) 60
103 CLAIM_LITIGATION_FLAG_ID INTEGER 4
104 CLAIM_LITIGATION_FLAG_NAME CHARACTER VARYING(256) 256
105 MATTER_CLAIM_ID BIGINT 8
106 MATTER_CREATE_DATE TIMESTAMP 8
107 MATTER_CREATE_DATE_ID INTEGER 4
108 MATTER_CREATE_DATE_CAL_YEAR INTEGER 4
109 MATTER_CREATE_DATE_CAL_QUARTER INTEGER 4
110 MATTER_CREATE_DATE_CAL_MONTH INTEGER 4
111 MATTER_CREATE_DATE_CAL_DAY INTEGER 4
112 MATTER_CREATE_DATE_DAY_TYPE_ID INTEGER 4
113 MATTER_CREATE_DATE_WEEK_TYPE_ID INTEGER 4
114 MATTER_CREATE_DATE_MONTH_TYPE_ID INTEGER 4
115 MATTER_CREATE_DATE_QUARTER_TYPE_ID INTEGER 4
116 MATTER_CREATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
117 MATTER_CREATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
118 MATTER_CREATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
119 MATTER_CREATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
120 MATTER_CREATE_DATE_HALF_TYPE_ID INTEGER 4
121 MATTER_CREATE_USER_ID BIGINT 8
122 MATTER_CREATE_USER_NAME CHARACTER VARYING(181) 181
123 MATTER_NAME CHARACTER VARYING(128) 128
124 MATTER_REOPENED_REASON_ID BIGINT 8
125 MATTER_REOPENED_REASON_NAME CHARACTER VARYING(256) 256
126 MATTER_ASSIGNMENT_DATE TIMESTAMP 8
127 MATTER_PRIMARY_CAUSE_ID BIGINT 8
128 MATTER_PRIMARY_CAUSE_NAME CHARACTER VARYING(256) 256
129 MATTER_CLOSE_DATE TIMESTAMP 8
130 MATTER_CLOSE_DATE_ID INTEGER 4
131 MATTER_CLOSE_DATE_CAL_YEAR INTEGER 4
132 MATTER_CLOSE_DATE_CAL_QUARTER INTEGER 4
133 MATTER_CLOSE_DATE_CAL_MONTH INTEGER 4
134 MATTER_CLOSE_DATE_CAL_DAY INTEGER 4
135 MATTER_CLOSE_DATE_DAY_TYPE_ID INTEGER 4
136 MATTER_CLOSE_DATE_WEEK_TYPE_ID INTEGER 4
137 MATTER_CLOSE_DATE_MONTH_TYPE_ID INTEGER 4
138 MATTER_CLOSE_DATE_QUARTER_TYPE_ID INTEGER 4
139 MATTER_CLOSE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
140 MATTER_CLOSE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
141 MATTER_CLOSE_DATE_R12_MONTH_TYPE_ID INTEGER 4
142 MATTER_CLOSE_DATE_R13_MONTH_TYPE_ID INTEGER 4
143 MATTER_CLOSE_DATE_HALF_TYPE_ID INTEGER 4
144 MATTER_STATUS CHARACTER VARYING(6) 6
145 MATTER_DURATION INTEGER 4
146 MATTER_DURATION_BAND_ID INTEGER 4
147 MATTER_DURATION_BAND_NAME CHARACTER VARYING(14) 14
148 MATTER_TOTAL_DURATION_DAYS INTEGER 4
149 MATTER_ASSIGNED_USER_ID BIGINT 8
150 MATTER_ASSIGNED_USER_NAME CHARACTER VARYING(181) 181
151 MATTER_ASSIGNED_GROUP_ID BIGINT 8
152 MATTER_ASSIGNED_GROUP_NAME CHARACTER VARYING(100) 100
153 MATTER_RECOVERY_FLAG_ID INTEGER 4
154 MATTER_RECOVERY_FLAG_NAME CHARACTER VARYING(256) 256
155 MATTER_LEGAL_SPECIALTY_ID BIGINT 8
156 MATTER_LEGAL_SPECIALTY_NAME CHARACTER VARYING(256) 256
157 IMATTER_REFERRED_FLAG_ID INTEGER 4
158 IMATTER_REFERRED_FLAG_NAME CHARACTER VARYING(256) 256
159 BRAND BIGINT 8
160 BRAND_NAME CHARACTER VARYING(256) 256
161 VERIFIED_POLICY_FLAG INTEGER 4
162 VERIFIED_POLICY CHARACTER VARYING(256) 256
163 CLAIM_DECISION_ID BIGINT 8
164 CLAIM_DECISION_NAME CHARACTER VARYING(256) 256
165 POLICY_VERIFIED_ID CHARACTER VARYING(1) 1
166 CLAIM_POLICY_VERIFICATION_STATUS_ID BIGINT 8
167 VERIFIED_POLICY_STATUS_ID INTEGER 4
168 VERIFIED_POLICY_STATUS CHARACTER VARYING(17) 17