FCT_CI_CLAIM_RISK_INDICATOR_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_DATE_KEY INTEGER 4
7 CLAIM_CREATE_DATE_CAL_YEAR INTEGER 4
8 CLAIM_CREATE_DATE_CAL_QUARTER INTEGER 4
9 CLAIM_CREATE_DATE_CAL_MONTH INTEGER 4
10 CLAIM_CREATE_DATE_CAL_DAY INTEGER 4
11 CLAIM_CREATE_DATE_DAY_TYPE_ID INTEGER 4
12 CLAIM_CREATE_DATE_WEEK_TYPE_ID INTEGER 4
13 CLAIM_CREATE_DATE_MONTH_TYPE_ID INTEGER 4
14 CLAIM_CREATE_DATE_QUARTER_TYPE_ID INTEGER 4
15 CLAIM_CREATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
16 CLAIM_CREATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
17 CLAIM_CREATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
18 CLAIM_CREATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
19 CLAIM_CREATE_DATE_HALF_TYPE_ID INTEGER 4
20 CLAIM_REJECT_REASON BIGINT 8
21 CLAIM_REJECT_REASON_NAME CHARACTER VARYING(256) 256
22 CLAIM_NUMBER CHARACTER VARYING(40) 40
23 POLICY_NUMBER CHARACTER VARYING(40) 40
24 VERIFIED_POLICY_FLAG INTEGER 4
25 VERIFIED_POLICY CHARACTER VARYING(256) 256
26 CLAIM_DURATION CHARACTER VARYING(17) 17
27 CLAIM_DURATION_ID INTEGER 4
28 CLAIM_DURATION_BAND_ID INTEGER 4
29 CLAIM_DURATION_BAND_NAME CHARACTER VARYING(14) 14
30 CLAIM_INITIAL_FINALISED_DATE TIMESTAMP 8
31 CLAIM_REOPENED_REASON_ID BIGINT 8
32 CLAIM_REOPENED_REASON CHARACTER VARYING(256) 256
33 CLAIM_SEGMENT_ID BIGINT 8
34 CLAIM_SEGMENT CHARACTER VARYING(256) 256
35 LOSS_CAUSE_NAME CHARACTER VARYING(256) 256
36 LOSS_CAUSE_ID BIGINT 8
37 CLAIM_STATE_ID BIGINT 8
38 CLAIM_STATE CHARACTER VARYING(256) 256
39 CLAIM_SIU_REFERRAL_FLAG_ID BIGINT 8
40 CLAIM_SIU_REFERRAL_FLAG CHARACTER VARYING(256) 256
41 CLAIM_SIU_STATUS CHARACTER VARYING(256) 256
42 CLAIM_LOSS_DATE TIMESTAMP 8
43 CLAIM_LOSS_DATE_ID INTEGER 4
44 CLAIM_LOSS_DATE_CAL_YEAR INTEGER 4
45 CLAIM_LOSS_DATE_CAL_QUARTER INTEGER 4
46 CLAIM_LOSS_DATE_CAL_MONTH INTEGER 4
47 CLAIM_LOSS_DATE_CAL_DAY INTEGER 4
48 CLAIM_LOSS_DATE_DAY_TYPE_ID INTEGER 4
49 CLAIM_LOSS_DATE_WEEK_TYPE_ID INTEGER 4
50 CLAIM_LOSS_DATE_MONTH_TYPE_ID INTEGER 4
51 CLAIM_LOSS_DATE_QUARTER_TYPE_ID INTEGER 4
52 CLAIM_LOSS_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
53 CLAIM_LOSS_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
54 CLAIM_LOSS_DATE_R12_MONTH_TYPE_ID INTEGER 4
55 CLAIM_LOSS_DATE_R13_MONTH_TYPE_ID INTEGER 4
56 CLAIM_LOSS_DATE_HALF_TYPE_ID INTEGER 4
57 CLAIM_RISK_INDICATORS_FLAG_ID INTEGER 4
58 CLAIM_RISK_INDICATORS_FLAG_NAME CHARACTER VARYING(256) 256
59 RISK_INDICATOR_ID BIGINT 8
60 RISK_INDICATOR_NAME CHARACTER VARYING(256) 256
61 RISK_INDICATOR_CREATE_USER_ID BIGINT 8
62 RISK_INDICATOR_CREATE_USER_NAME CHARACTER VARYING(181) 181
63 RISK_INDICATOR_CREATE_DATE TIMESTAMP 8
64 RISK_INDICATOR_CREATE_DATE_ID INTEGER 4
65 RISK_INDICATOR_CREATE_DATE_CAL_YEAR INTEGER 4
66 RISK_INDICATOR_CREATE_DATE_CAL_QUARTER INTEGER 4
67 RISK_INDICATOR_CREATE_DATE_CAL_MONTH INTEGER 4
68 RISK_INDICATOR_CREATE_DATE_CAL_DAY INTEGER 4
69 RISK_INDICATOR_CREATE_DATE_DAY_TYPE_ID INTEGER 4
70 RISK_INDICATOR_CREATE_DATE_WEEK_TYPE_ID INTEGER 4
71 RISK_INDICATOR_CREATE_DATE_MONTH_TYPE_ID INTEGER 4
72 RISK_INDICATOR_CREATE_DATE_QUARTER_TYPE_ID INTEGER 4
73 RISK_INDICATOR_CREATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
74 RISK_INDICATOR_CREATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
75 RISK_INDICATOR_CREATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
76 RISK_INDICATOR_CREATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
77 RISK_INDICATOR_CREATE_DATE_HALF_TYPE_ID INTEGER 4
78 RISK_INDICATOR_CLAIM_ID BIGINT 8
79 RISK_INDICATOR_UPDATE_USER_ID BIGINT 8
80 RISK_INDICATOR_UPDATE_USER_NAME CHARACTER VARYING(181) 181
81 RISK_INDICATOR_UPDATE_DATE_ID INTEGER 4
82 RISK_INDICATOR_UPDATE_DATE TIMESTAMP 8
83 CLAIM_DECISION_ID BIGINT 8
84 CLAIM_DECISION_NAME CHARACTER VARYING(256) 256
85 CLAIM_EVENT_ID BIGINT 8
86 CLAIM_EVENT_CODE CHARACTER VARYING(60) 60
87 CLAIM_EVENT_NAME CHARACTER VARYING(60) 60
88 CLAIM_LITIGATION_FLAG_ID INTEGER 4
89 CLAIM_LITIGATION_FLAG_NAME CHARACTER VARYING(256) 256
90 CLAIM_LATEST_FINALISED_DATE TIMESTAMP 8
91 CLAIM_LATEST_FINALISED_DATE_ID INTEGER 4
92 CLAIM_LATEST_REOPENED_DATE TIMESTAMP 8
93 CLAIM_LATEST_REOPENED_DATE_ID INTEGER 4
94 CLAIM_ASSIGNMENT_DATE TIMESTAMP 8
95 CLAIM_ASSIGNMENT_DATE_ID INTEGER 4
96 CLAIM_ASSIGNED_DATE_CAL_YEAR INTEGER 4
97 CLAIM_ASSIGNED_DATE_CAL_QUARTER INTEGER 4
98 CLAIM_ASSIGNED_DATE_CAL_MONTH INTEGER 4
99 CLAIM_ASSIGNED_DATE_CAL_DAY INTEGER 4
100 CLAIM_ASSIGNED_DATE_DAY_TYPE_ID INTEGER 4
101 CLAIM_ASSIGNED_DATE_WEEK_TYPE_ID INTEGER 4
102 CLAIM_ASSIGNED_DATE_MONTH_TYPE_ID INTEGER 4
103 CLAIM_ASSIGNED_DATE_QUARTER_TYPE_ID INTEGER 4
104 CLAIM_ASSIGNED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
105 CLAIM_ASSIGNED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
106 CLAIM_ASSIGNED_DATE_R12_MONTH_TYPE_ID INTEGER 4
107 CLAIM_ASSIGNED_DATE_R13_MONTH_TYPE_ID INTEGER 4
108 CLAIM_ASSIGNED_DATE_HALF_TYPE_ID INTEGER 4
109 CLAIM_ADJUSTER_LOOKUP_USER_ID BIGINT 8
110 CLAIM_ADJUSTER CHARACTER VARYING(181) 181
111 EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
112 TEAM_ID BIGINT 8
113 TEAM_NAME CHARACTER VARYING(100) 100
114 GROUP_TYPE_ID BIGINT 8
115 GROUP_TYPE_NAME CHARACTER VARYING(256) 256
116 L1_TEAM_ID BIGINT 8
117 L1_TEAM_NAME CHARACTER VARYING(100) 100
118 L2_TEAM_ID BIGINT 8
119 L2_TEAM_NAME CHARACTER VARYING(100) 100
120 L3_TEAM_ID BIGINT 8
121 L3_TEAM_NAME CHARACTER VARYING(100) 100
122 L4_TEAM_ID BIGINT 8
123 L4_TEAM_NAME CHARACTER VARYING(100) 100
124 L5_TEAM_ID BIGINT 8
125 L5_TEAM_NAME CHARACTER VARYING(100) 100
126 L6_TEAM_ID BIGINT 8
127 L6_TEAM_NAME CHARACTER VARYING(100) 100
128 L7_TEAM_ID BIGINT 8
129 L7_TEAM_NAME CHARACTER VARYING(100) 100
130 L8_TEAM_ID BIGINT 8
131 L8_TEAM_NAME CHARACTER VARYING(100) 100
132 L9_TEAM_ID BIGINT 8
133 L9_TEAM_NAME CHARACTER VARYING(100) 100
134 L10_TEAM_ID BIGINT 8
135 L10_TEAM_NAME CHARACTER VARYING(100) 100
136 L11_TEAM_ID BIGINT 8
137 L11_TEAM_NAME CHARACTER VARYING(100) 100
138 POLICY_VERIFIED_ID CHARACTER VARYING(1) 1
139 CLAIM_POLICY_VERIFICATION_STATUS_ID BIGINT 8
140 VERIFIED_POLICY_STATUS_ID INTEGER 4
141 VERIFIED_POLICY_STATUS CHARACTER VARYING(17) 17