FCT_CI_EXPOSURE_RECOVERY_DRILLTHRU

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BRAND_ID BIGINT 8
2 BRAND_NAME CHARACTER VARYING(256) 256
3 CREATE_DATE TIMESTAMP 8
4 CREATE_DATE_YEAR INTEGER 4
5 CREATE_DATE_QUARTER INTEGER 4
6 CREATE_DATE_MONTH INTEGER 4
7 CREATE_DATE_DAY INTEGER 4
8 CREATE_DATE_DAY_TYPE_ID INTEGER 4
9 CREATE_DATE_WEEK_TYPE_ID INTEGER 4
10 CREATE_DATE_MONTH_TYPE_ID INTEGER 4
11 CREATE_DATE_QUARTER_TYPE_ID INTEGER 4
12 CREATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
13 CREATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
14 CREATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
15 CREATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
16 CREATE_DATE_HALF_TYPE_ID INTEGER 4
17 CLAIM_NUMBER CHARACTER VARYING(40) 40
18 VERIFIED_POLICY_STATUS_ID INTEGER 4
19 VERIFIED_POLICY_STATUS CHARACTER VARYING(17) 17
20 CLAIM_DURATION_ID INTEGER 4
21 CLAIM_DURATION_BAND_ID INTEGER 4
22 CLAIM_DURATION_BAND CHARACTER VARYING(14) 14
23 CLAIM_LATEST_FINALISED_DATE TIMESTAMP 8
24 CLAIM_LATEST_REOPENED_DATE TIMESTAMP 8
25 CLAIM_INITIAL_FINALISED_DATE TIMESTAMP 8
26 CLAIM_INITIAL_FINALISED_DATE_YEAR INTEGER 4
27 CLAIM_INITIAL_FINALISED_DATE_QUARTER INTEGER 4
28 CLAIM_INITIAL_FINALISED_DATE_MONTH INTEGER 4
29 CLAIM_INITIAL_FINALISED_DATE_DAY INTEGER 4
30 CLAIM_INITIAL_FINALISED_DATE_DAY_TYPE_ID INTEGER 4
31 CLAIM_INITIAL_FINALISED_DATE_WEEK_TYPE_ID INTEGER 4
32 CLAIM_INITIAL_FINALISED_DATE_MONTH_TYPE_ID INTEGER 4
33 CLAIM_INITIAL_FINALISED_DATE_QUARTER_TYPE_ID INTEGER 4
34 CLAIM_INITIAL_FINALISED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
35 CLAIM_INITIAL_FINALISED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
36 CLAIM_INITIAL_FINALISED_DATE_R12_MONTH_TYPE_ID INTEGER 4
37 CLAIM_INITIAL_FINALISED_DATE_R13_MONTH_TYPE_ID INTEGER 4
38 CLAIM_INITIAL_FINALISED_DATE_HALF_TYPE_ID INTEGER 4
39 EXPOSURE_SETTLEMENT_FLAG_ID INTEGER 4
40 EXPOSURE_SETTLEMENT_FLAG_NAME CHARACTER VARYING(256) 256
41 CLAIM_SEGMENT_ID BIGINT 8
42 CLAIM_SEGMENT CHARACTER VARYING(256) 256
43 EXPOSURE_INCIDENT_FAULT_RATING_ID BIGINT 8
44 EXPOSURE_INCIDENT_FAULT_RATING_NAME CHARACTER VARYING(256) 256
45 CLAIM_STATE_ID BIGINT 8
46 CLAIM_STATE CHARACTER VARYING(256) 256
47 POLICY_NUMBER CHARACTER VARYING(40) 40
48 RECOVERY_OWNER_ID BIGINT 8
49 RECOVERY_OWNER_NAME CHARACTER VARYING(181) 181
50 RECOVERY_OWNER_GROUP BIGINT 8
51 RECOVERY_OWNER_GROUP_NAME CHARACTER VARYING(100) 100
52 RECOVERY_MANAGEMENT_STATUS_ID BIGINT 8
53 RECOVERY_MANAGEMENT_STATUS_NAME CHARACTER VARYING(256) 256
54 RECOVERY_LIABILITY_PERCENTAGE NUMERIC(4,1) 19
55 RECOVERY_PARTY_RECOVERY_STATUS_ID BIGINT 8
56 RECOVERY_PARTY_RECOVERY_STATUS_NAME CHARACTER VARYING(256) 256
57 RECOVERY_PARTY_NAME_ID BIGINT 8
58 RECOVERY_PARTY_NAME CHARACTER VARYING(181) 181
59 RECOVERY_PARTY_PRIMARY_PHONE CHARACTER VARYING(255) 255
60 RESPONSIBLE_PARTY_ADDRESS CHARACTER VARYING(434) 434
61 RECOVERY_PARTY_ADDRESS CHARACTER VARYING(434) 434
62 RECOVERY_PARTY_EXPOSURE_ID BIGINT 8
63 RECOVERY_PARTY_RECOVERY_TYPE_ID BIGINT 8
64 RECOVERY_PARTY_RECOVERY_TYPE_NAME CHARACTER VARYING(256) 256
65 RECOVERY_PARTY_EXPECTED_RECOVERY_PERCENTAGE NUMERIC(4,1) 19
66 RECOVERY_PARTY_SCHEDULED_PAYMENTS_FLAG INTEGER 4
67 RECOVERY_PARTY_SCHEDULED_PAYMENTS_FLAG_NAME CHARACTER VARYING(256) 256
68 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_SENT_DATE TIMESTAMP 8
69 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_SENT_DATE_ID INTEGER 4
70 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_SENT_DATE_YEAR INTEGER 4
71 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_SENT_DATE_QUARTER INTEGER 4
72 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_SENT_DATE_MONTH INTEGER 4
73 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_SENT_DATE_DAY INTEGER 4
74 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_SENT_DATE_DAY_TYPE_ID INTEGER 4
75 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_SENT_DATE_WEEK_TYPE_ID INTEGER 4
76 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_SENT_DATE_MONTH_TYPE_ID INTEGER 4
77 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_SENT_DATE_QUARTER_TYPE_ID INTEGER 4
78 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_SENT_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
79 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_SENT_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
80 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_SENT_DATE_R12_MONTH_TYPE_ID INTEGER 4
81 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_SENT_DATE_R13_MONTH_TYPE_ID INTEGER 4
82 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_SENT_DATE_HALF_TYPE_ID INTEGER 4
83 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_RECEIVED_DATE TIMESTAMP 8
84 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_RECEIVED_DATE_ID INTEGER 4
85 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_RECEIVED_DATE_YEAR INTEGER 4
86 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_RECEIVED_DATE_QUARTER INTEGER 4
87 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_RECEIVED_DATE_MONTH INTEGER 4
88 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_RECEIVED_DATE_DAY INTEGER 4
89 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_RECEIVED_DATE_DAY_TYPE_ID INTEGER 4
90 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_RECEIVED_DATE_WEEK_TYPE_ID INTEGER 4
91 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_RECEIVED_DATE_MONTH_TYPE_ID INTEGER 4
92 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_RECEIVED_DATE_QUARTER_TYPE_ID INTEGER 4
93 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_RECEIVED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
94 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_RECEIVED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
95 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_RECEIVED_DATE_R12_MONTH_TYPE_ID INTEGER 4
96 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_RECEIVED_DATE_R13_MONTH_TYPE_ID INTEGER 4
97 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_RECEIVED_DATE_HALF_TYPE_ID INTEGER 4
98 RECOVERY_PARTY_SCHEDULED_PAYMENTS_TYPE_ID BIGINT 8
99 RECOVERY_PARTY_SCHEDULED_PAYMENTS_TYPE_NAME CHARACTER VARYING(256) 256
100 RECOVERY_PARTY_INSURANCE_STATUS_ID BIGINT 8
101 RECOVERY_PARTY_INSURANCE_STATUS_NAME CHARACTER VARYING(256) 256
102 PAYMENTREFNUMBER CHARACTER VARYING(19) 19
103 RECOVERY_PARTY_RECOVERY_AMOUNT NUMERIC(18,2) 19
104 RECOVERY_PARTY_RECOVERD_TRANSACTION_AMOUNT NUMERIC(38,2) 19
105 RECOVERY_DURATION INTEGER 4
106 RECOVERY_PARTY_INSURER_ID BIGINT 8
107 RECOVERY_PARTY_INSURER_NAME CHARACTER VARYING(181) 181
108 RECOVERY_COUNT BIGINT 8
109 RECOVERYSTATUS_NAME CHARACTER VARYING(256) 256
110 RECOVERY_PARTY_CREATE_DATE DATE 4
111 RECOVERY_PARTY_CREATE_DATE_YEAR INTEGER 4
112 RECOVERY_PARTY_CREATE_DATE_QUARTER INTEGER 4
113 RECOVERY_PARTY_CREATE_DATE_MONTH INTEGER 4
114 RECOVERY_PARTY_CREATE_DATE_DAY INTEGER 4
115 RECOVERY_PARTY_CREATE_DATE_DAY_TYPE_ID INTEGER 4
116 RECOVERY_PARTY_CREATE_DATE_WEEK_TYPE_ID INTEGER 4
117 RECOVERY_PARTY_CREATE_DATE_MONTH_TYPE_ID INTEGER 4
118 RECOVERY_PARTY_CREATE_DATE_QUARTER_TYPE_ID INTEGER 4
119 RECOVERY_PARTY_CREATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
120 RECOVERY_PARTY_CREATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
121 RECOVERY_PARTY_CREATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
122 RECOVERY_PARTY_CREATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
123 RECOVERY_PARTY_CREATE_DATE_HALF_TYPE_ID INTEGER 4
124 RECOVERY_PARTY_UPDATE_DATE DATE 4
125 RECOVERY_PARTY_UPDATE_DATE_YEAR INTEGER 4
126 RECOVERY_PARTY_UPDATE_DATE_QUARTER INTEGER 4
127 RECOVERY_PARTY_UPDATE_DATE_MONTH INTEGER 4
128 RECOVERY_PARTY_UPDATE_DATE_DAY INTEGER 4
129 RECOVERY_PARTY_UPDATE_DATE_DAY_TYPE_ID INTEGER 4
130 RECOVERY_PARTY_UPDATE_DATE_WEEK_TYPE_ID INTEGER 4
131 RECOVERY_PARTY_UPDATE_DATE_MONTH_TYPE_ID INTEGER 4
132 RECOVERY_PARTY_UPDATE_DATE_QUARTER_TYPE_ID INTEGER 4
133 RECOVERY_PARTY_UPDATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
134 RECOVERY_PARTY_UPDATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
135 RECOVERY_PARTY_UPDATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
136 RECOVERY_PARTY_UPDATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
137 RECOVERY_PARTY_UPDATE_DATE_HALF_TYPE_ID INTEGER 4
138 RECOVERY_PARTY_FINALISED_DATE DATE 4
139 RECOVERY_PARTY_FINALISED_DATE_YEAR INTEGER 4
140 RECOVERY_PARTY_FINALISED_DATE_QUARTER INTEGER 4
141 RECOVERY_PARTY_FINALISED_DATE_MONTH INTEGER 4
142 RECOVERY_PARTY_FINALISED_DATE_DAY INTEGER 4
143 RECOVERY_PARTY_FINALISED_DATE_DAY_TYPE_ID INTEGER 4
144 RECOVERY_PARTY_FINALISED_DATE_WEEK_TYPE_ID INTEGER 4
145 RECOVERY_PARTY_FINALISED_DATE_MONTH_TYPE_ID INTEGER 4
146 RECOVERY_PARTY_FINALISED_DATE_QUARTER_TYPE_ID INTEGER 4
147 RECOVERY_PARTY_FINALISED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
148 RECOVERY_PARTY_FINALISED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
149 RECOVERY_PARTY_FINALISED_DATE_R12_MONTH_TYPE_ID INTEGER 4
150 RECOVERY_PARTY_FINALISED_DATE_R13_MONTH_TYPE_ID INTEGER 4
151 RECOVERY_PARTY_FINALISED_DATE_HALF_TYPE_ID INTEGER 4
152 RECOVERY_PARTY_CREATE_USER_ID BIGINT 8
153 RECOVERY_PARTY_CREATE_USER_NAME CHARACTER VARYING(181) 181
154 RECOVERY_PARTY_UPDATE_USER_ID BIGINT 8
155 RECOVERY_PARTY_UPDATE_USER_NAME CHARACTER VARYING(181) 181
156 RECOVERY_CLOSE_DATE TIMESTAMP 8
157 RECOVERY_CLOSE_DATE_DATE_YEAR INTEGER 4
158 RECOVERY_CLOSE_DATE_DATE_QUARTER INTEGER 4
159 RECOVERY_CLOSE_DATE_DATE_MONTH INTEGER 4
160 RECOVERY_CLOSE_DATE_DATE_DAY INTEGER 4
161 RECOVERY_CLOSE_DATE_DATE_DAY_TYPE_ID INTEGER 4
162 RECOVERY_CLOSE_DATE_DATE_WEEK_TYPE_ID INTEGER 4
163 RECOVERY_CLOSE_DATE_DATE_MONTH_TYPE_ID INTEGER 4
164 RECOVERY_CLOSE_DATE_DATE_QUARTER_TYPE_ID INTEGER 4
165 RECOVERY_CLOSE_DATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
166 RECOVERY_CLOSE_DATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
167 RECOVERY_CLOSE_DATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
168 RECOVERY_CLOSE_DATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
169 RECOVERY_CLOSE_DATE_DATE_HALF_TYPE_ID INTEGER 4
170 RECOVERY_CLOSE_COMMENT CHARACTER VARYING(255) 255
171 CLAIM_GROSS_RECOVERED_AMOUNT NUMERIC(38,2) 19
172 CLAIM_GROSS_RECOVERED_AMOUNT_BAND_ID INTEGER 4
173 CLAIM_GROSS_RECOVERED_AMOUNT_BAND_NAME CHARACTER VARYING(15) 15
174 CLAIM_NET_RECOVERED_AMOUNT NUMERIC(38,2) 19
175 CLAIM_NET_RECOVERED_AMOUNT_BAND_ID INTEGER 4
176 CLAIM_NET_RECOVERED_AMOUNT_BAND_NAME CHARACTER VARYING(15) 15
177 RECOVERY_PARTY_INITIAL_RECOVERY_AMOUNT NUMERIC(38,2) 19
178 RECOVERY_PARTY_RECOVERY_FILE_STATUS CHARACTER VARYING(5) 5