INT_CI_EXPOSURE_SUBJECT_AREA

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 EXPOSURE_REJECT_REASON_ID BIGINT 8
2 EXPOSURE_REJECT_REASON CHARACTER VARYING(256) 256
3 EXPOSURE_NUMBER CHARACTER VARYING(40) 40
4 EXPOSURE_ASSIGNMENT_DATE TIMESTAMP 8
5 LATEST_EXPOSURE_CLOSE_DATE TIMESTAMP 8
6 LATEST_EXPOSURE_CLOSE_DATE_YEAR INTEGER 4
7 LATEST_EXPOSURE_CLOSE_DATE_QUARTER INTEGER 4
8 LATEST_EXPOSURE_CLOSE_DATE_MONTH INTEGER 4
9 LATEST_EXPOSURE_CLOSE_DATE_DAY INTEGER 4
10 LATEST_EXPOSURE_CLOSE_DATE_DAY_TYPE_ID INTEGER 4
11 LATEST_EXPOSURE_CLOSE_DATE_WEEK_TYPE_ID INTEGER 4
12 LATEST_EXPOSURE_CLOSE_DATE_MONTH_TYPE_ID INTEGER 4
13 LATEST_EXPOSURE_CLOSE_DATE_QUARTER_TYPE_ID INTEGER 4
14 LATEST_EXPOSURE_CLOSE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
15 LATEST_EXPOSURE_CLOSE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
16 LATEST_EXPOSURE_CLOSE_DATE_R12_MONTH_TYPE_ID INTEGER 4
17 LATEST_EXPOSURE_CLOSE_DATE_R13_MONTH_TYPE_ID INTEGER 4
18 LATEST_EXPOSURE_CLOSE_DATE_HALF_TYPE_ID INTEGER 4
19 LATEST_EXPOSURE_REOPENED_DATE TIMESTAMP 8
20 LATEST_EXPOSURE_REOPENED_DATE_YEAR INTEGER 4
21 LATEST_EXPOSURE_REOPENED_DATE_QUARTER INTEGER 4
22 LATEST_EXPOSURE_REOPENED_DATE_MONTH INTEGER 4
23 LATEST_EXPOSURE_REOPENED_DATE_DAY INTEGER 4
24 LATEST_EXPOSURE_REOPENED_DATE_DAY_TYPE_ID INTEGER 4
25 LATEST_EXPOSURE_REOPENED_DATE_WEEK_TYPE_ID INTEGER 4
26 LATEST_EXPOSURE_REOPENED_DATE_MONTH_TYPE_ID INTEGER 4
27 LATEST_EXPOSURE_REOPENED_DATE_QUARTER_TYPE_ID INTEGER 4
28 LATEST_EXPOSURE_REOPENED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
29 LATEST_EXPOSURE_REOPENED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
30 LATEST_EXPOSURE_REOPENED_DATE_R12_MONTH_TYPE_ID INTEGER 4
31 LATEST_EXPOSURE_REOPENED_DATE_R13_MONTH_TYPE_ID INTEGER 4
32 LATEST_EXPOSURE_REOPENED_DATE_HALF_TYPE_ID INTEGER 4
33 EXPOSURE_INITAL_CLOSED_DATE TIMESTAMP 8
34 EXPOSURE_INITAL_CLOSED_DATE_YEAR INTEGER 4
35 EXPOSURE_INITAL_CLOSED_DATE_QUARTER INTEGER 4
36 EXPOSURE_INITAL_CLOSED_DATE_MONTH INTEGER 4
37 EXPOSURE_INITAL_CLOSED_DATE_DAY INTEGER 4
38 EXPOSURE_INITAL_CLOSED_DATE_DAY_TYPE_ID INTEGER 4
39 EXPOSURE_INITAL_CLOSED_DATE_WEEK_TYPE_ID INTEGER 4
40 EXPOSURE_INITAL_CLOSED_DATE_MONTH_TYPE_ID INTEGER 4
41 EXPOSURE_INITAL_CLOSED_DATE_QUARTER_TYPE_ID INTEGER 4
42 EXPOSURE_INITAL_CLOSED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
43 EXPOSURE_INITAL_CLOSED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
44 EXPOSURE_INITAL_CLOSED_DATE_R12_MONTH_TYPE_ID INTEGER 4
45 EXPOSURE_INITAL_CLOSED_DATE_R13_MONTH_TYPE_ID INTEGER 4
46 EXPOSURE_INITAL_CLOSED_DATE_HALF_TYPE_ID INTEGER 4
47 EXPOSURE_COUNT BIGINT 8
48 EXPOSURE_DURATION_ID INTERVAL 12
49 EXPOSURE_DURATION_BAND_ID INTEGER 4
50 EXPOSURE_DURATION_BAND CHARACTER VARYING(14) 14
51 EXPOSURE_STATE_ID BIGINT 8
52 EXPOSURE_STATE CHARACTER VARYING(256) 256
53 EXPOSURE_DECISION_ID BIGINT 8
54 EXPOSURE_DECISION CHARACTER VARYING(256) 256
55 EXPOSURE_CREATE_DATE TIMESTAMP 8
56 EXPOSURE_CREATE_DATE_YEAR INTEGER 4
57 EXPOSURE_CREATE_DATE_QUARTER INTEGER 4
58 EXPOSURE_CREATE_DATE_MONTH INTEGER 4
59 EXPOSURE_CREATE_DATE_DAY INTEGER 4
60 EXPOSURE_CREATE_DATE_DAY_TYPE_ID INTEGER 4
61 EXPOSURE_CREATE_DATE_WEEK_TYPE_ID INTEGER 4
62 EXPOSURE_CREATE_DATE_MONTH_TYPE_ID INTEGER 4
63 EXPOSURE_CREATE_DATE_QUARTER_TYPE_ID INTEGER 4
64 EXPOSURE_CREATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
65 EXPOSURE_CREATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
66 EXPOSURE_CREATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
67 EXPOSURE_CREATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
68 EXPOSURE_CREATE_DATE_HALF_TYPE_ID INTEGER 4
69 EXPOSURE_FIRST_CLOSURE_DURATION INTEGER 4
70 EXCESS_AMOUNT NUMERIC(38,2) 19
71 EXPOSURE_FIRST_CLOSURE_DURATION_BAND_ID INTEGER 4
72 EXPOSURE_FIRST_CLOSURE_DURATION_BAND_NAME CHARACTER VARYING(14) 14
73 EXPOSURE_ADJUSTER_ID BIGINT 8
74 EXPOSURE_ADJUSTER_LOOKUP_USER_ID BIGINT 8
75 EXPOSURE_ADJUSTER CHARACTER VARYING(181) 181
76 EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
77 TEAM_ID BIGINT 8
78 TEAM_NAME CHARACTER VARYING(100) 100
79 GROUP_TYPE_ID BIGINT 8
80 GROUP_TYPE_NAME CHARACTER VARYING(256) 256
81 L1_TEAM_ID BIGINT 8
82 L1_TEAM_NAME CHARACTER VARYING(100) 100
83 L2_TEAM_ID BIGINT 8
84 L2_TEAM_NAME CHARACTER VARYING(100) 100
85 L3_TEAM_ID BIGINT 8
86 L3_TEAM_NAME CHARACTER VARYING(100) 100
87 L4_TEAM_ID BIGINT 8
88 L4_TEAM_NAME CHARACTER VARYING(100) 100
89 L5_TEAM_ID BIGINT 8
90 L5_TEAM_NAME CHARACTER VARYING(100) 100
91 L6_TEAM_ID BIGINT 8
92 L6_TEAM_NAME CHARACTER VARYING(100) 100
93 L7_TEAM_ID BIGINT 8
94 L7_TEAM_NAME CHARACTER VARYING(100) 100
95 L8_TEAM_ID BIGINT 8
96 L8_TEAM_NAME CHARACTER VARYING(100) 100
97 L9_TEAM_ID BIGINT 8
98 L9_TEAM_NAME CHARACTER VARYING(100) 100
99 L10_TEAM_ID BIGINT 8
100 L10_TEAM_NAME CHARACTER VARYING(100) 100
101 L11_TEAM_ID BIGINT 8
102 L11_TEAM_NAME CHARACTER VARYING(100) 100
103 EXPOSURE_ASSIGNED_TEAM_ID BIGINT 8
104 EXPOSURE_ASSIGNED_TEAM CHARACTER VARYING(100) 100
105 EXPOSURE_ASSIGNED_BY_USER_ID BIGINT 8
106 EXPOSURE_ASSIGNED_BY_USER CHARACTER VARYING(181) 181
107 EXPOSURE_ASSIGNMENT_STATUS_ID BIGINT 8
108 EXPOSURE_ASSIGNMENT_STATUS CHARACTER VARYING(256) 256
109 EXPOSURE_CLAIMANT_ID BIGINT 8
110 EXPOSURE_CLAIMANT CHARACTER VARYING(181) 181
111 EXPOSURE_CLAIM_ID BIGINT 8
112 EXPOSURE_COVERAGE_ID BIGINT 8
113 EXPOSURE_COVERAGE_SUBTYPE_ID BIGINT 8
114 EXPOSURE_COVERAGE_SUBTYPE CHARACTER VARYING(256) 256
115 EXPOSURE_CREATE_USER_ID BIGINT 8
116 EXPOSURE_CREATE_USER CHARACTER VARYING(181) 181
117 EXPOSURE_TYPE_ID BIGINT 8
118 EXPOSURE_TYPE CHARACTER VARYING(256) 256
119 EXPOSURE_INCIDENT_ID BIGINT 8
120 EXPOSURE_LOSS_PARTY_ID BIGINT 8
121 EXPOSURE_LOSS_PARTY CHARACTER VARYING(256) 256
122 EXPOSURE_PRIMARY_COVERAGE_ID BIGINT 8
123 EXPOSURE_PRIMARY_COVERAGE CHARACTER VARYING(256) 256
124 EXPOSURE_REOPENED_REASON_ID BIGINT 8
125 EXPOSURE_REOPENED_REASON CHARACTER VARYING(256) 256
126 EXPOSURE_SEGMENT_ID BIGINT 8
127 EXPOSURE_CLOSED_OUTCOME_ID BIGINT 8
128 EXPOSURE_CLOSED_OUTCOME CHARACTER VARYING(256) 256
129 EXPOSURE_ID BIGINT 8
130 EXPOSURE_SETTLEMENT_FLAG_ID INTEGER 4
131 EXPOSURE_SETTLEMENT_FLAG_NAME CHARACTER VARYING(256) 256
132 EXPOSURE_SETTLEMENT_DATE TIMESTAMP 8
133 EXPOSURE_SETTLEMENT_DATE_ID INTEGER 4
134 EXPOSURE_SETTLEMENT_DATE_CAL_YEAR INTEGER 4
135 EXPOSURE_SETTLEMENT_DATE_CAL_QUARTER INTEGER 4
136 EXPOSURE_SETTLEMENT_DATE_CAL_MONTH INTEGER 4
137 EXPOSURE_SETTLEMENT_DATE_CAL_DAY INTEGER 4
138 EXPOSURE_SETTLEMENT_DATE_DAY_TYPE_ID INTEGER 4
139 EXPOSURE_SETTLEMENT_DATE_WEEK_TYPE_ID INTEGER 4
140 EXPOSURE_SETTLEMENT_DATE_MONTH_TYPE_ID INTEGER 4
141 EXPOSURE_SETTLEMENT_DATE_QUARTER_TYPE_ID INTEGER 4
142 EXPOSURE_SETTLEMENT_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
143 EXPOSURE_SETTLEMENT_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
144 EXPOSURE_SETTLEMENT_DATE_R12_MONTH_TYPE_ID INTEGER 4
145 EXPOSURE_SETTLEMENT_DATE_R13_MONTH_TYPE_ID INTEGER 4
146 EXPOSURE_SETTLEMENT_DATE_HALF_TYPE_ID INTEGER 4
147 EXPOSURE_SETTLEMENT_DURATION INTEGER 4
148 EXPOSURE_SETTLEMENT_DURATION_BAND_ID INTEGER 4
149 EXPOSURE_SETTLEMENT_DURATION_BAND_NAME CHARACTER VARYING(14) 14
150 EXPOSURE_ADJUSTER_USER_NAME CHARACTER VARYING(181) 181
151 EXPOSURE_ADJUSTER_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
152 EXPOSURE_ADJUSTER_TEAM_ID BIGINT 8
153 EXPOSURE_ADJUSTER_TEAM_NAME CHARACTER VARYING(100) 100
154 EXPOSURE_ADJUSTER_GROUP_TYPE_ID BIGINT 8
155 EXPOSURE_ADJUSTER_GROUP_TYPE_NAME CHARACTER VARYING(256) 256
156 EXPOSURE_ASSIGNED_TEAM_NAME CHARACTER VARYING(100) 100
157 EXPOSURE_UPDATE_DATE TIMESTAMP 8
158 EXPOSURE_UPDATE_DATE_YEAR INTEGER 4
159 EXPOSURE_UPDATE_DATE_QUARTER INTEGER 4
160 EXPOSURE_UPDATE_DATE_MONTH INTEGER 4
161 EXPOSURE_UPDATE_DATE_DAY INTEGER 4
162 EXPOSURE_UPDATE_DATE_DAY_TYPE_ID INTEGER 4
163 EXPOSURE_UPDATE_DATE_WEEK_TYPE_ID INTEGER 4
164 EXPOSURE_UPDATE_DATE_MONTH_TYPE_ID INTEGER 4
165 EXPOSURE_UPDATE_DATE_QUARTER_TYPE_ID INTEGER 4
166 EXPOSURE_UPDATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
167 EXPOSURE_UPDATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
168 EXPOSURE_UPDATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
169 EXPOSURE_UPDATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
170 EXPOSURE_UPDATE_DATE_HALF_TYPE_ID INTEGER 4
171 EXPOSURE_LITIGATION_FLAG_ID INTEGER 4
172 EXPOSURE_LITIGATION_FLAG_NAME CHARACTER VARYING(256) 256
173 EXPOSURE_EXCESS_RECOVERY_STATUS CHARACTER VARYING(14) 14
174 EXPOSURE_SALVAGE_RECOVERY_STATUS CHARACTER VARYING(14) 14
175 EXPOSURE_DEBT_RECOVERY_STATUS CHARACTER VARYING(14) 14
176 EXPOSURE_INSURED_OCCOUPATION_CODE CHARACTER VARYING(10) 10
177 EXPOSURE_INSURED_OCCOUPATION_DESCRIPTION CHARACTER VARYING(100) 100
178 EXPOSURE_LOSS_ADJUSTER_FLAG_ID INTEGER 4
179 EXPOSURE_COVERAGE_PRODUCT_CODE CHARACTER VARYING(20) 20
180 EXPOSURE_COVERAGE_PRODUCT_CLASS_CODE CHARACTER VARYING(20) 20
181 EXPOSURE_COVERAGE_PRODUCT_SUBCLASS_CODE CHARACTER VARYING(20) 20
182 EXPOSURE_COVERAGE_BRAND_MARKER_COVERAGE_CODE CHARACTER VARYING(10) 10
183 EXPOSURE_GROSS_PAID_AMOUNT NUMERIC(38,2) 19
184 EXPOSURE_GROSS_PAID_AMOUNT_BAND_ID INTEGER 4
185 EXPOSURE_GROSS_PAID_NAME CHARACTER VARYING(15) 15
186 EXPOSURE_GROSS_INCURRED_AMOUNT NUMERIC(38,2) 19
187 EXPOSURE_GROSS_INCURRED_AMOUNT_BAND_ID INTEGER 4
188 EXPOSURE_GROSS_INCURRED_NAME CHARACTER VARYING(15) 15
189 EXPOSURE_NET_INCURRED_AMOUNT NUMERIC(38,2) 19
190 EXPOSURE_NET_INCURRED_AMOUNT_BAND_ID INTEGER 4
191 EXPOSURE_NET_INCURRED_NAME CHARACTER VARYING(15) 15
192 EXPOSURE_GROSS_RECOVERED_AMOUNT NUMERIC(38,2) 19
193 EXPOSURE_GROSS_RECOVERED_AMOUNT_BAND_ID INTEGER 4
194 EXPOSURE_GROSS_RECOVERED_NAME CHARACTER VARYING(15) 15
195 EXPOSURE_NET_RECOVERED_AMOUNT NUMERIC(38,2) 19
196 EXPOSURE_NET_RECOVERED_AMOUNT_BAND_ID INTEGER 4
197 EXPOSURE_NET_RECOVERED_NAME CHARACTER VARYING(15) 15