FCT_CI_EXPOSURE_BODYPART_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 CLAIM_NUMBER CHARACTER VARYING(40) 40
4 EXPOSURE_NUMBER CHARACTER VARYING(40) 40
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_CREATE_DATE TIMESTAMP 8
34 EXPOSURE_CREATE_DATE_YEAR INTEGER 4
35 EXPOSURE_CREATE_DATE_QUARTER INTEGER 4
36 EXPOSURE_CREATE_DATE_MONTH INTEGER 4
37 EXPOSURE_CREATE_DATE_DAY INTEGER 4
38 EXPOSURE_CREATE_DATE_DAY_TYPE_ID INTEGER 4
39 EXPOSURE_CREATE_DATE_WEEK_TYPE_ID INTEGER 4
40 EXPOSURE_CREATE_DATE_MONTH_TYPE_ID INTEGER 4
41 EXPOSURE_CREATE_DATE_QUARTER_TYPE_ID INTEGER 4
42 EXPOSURE_CREATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
43 EXPOSURE_CREATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
44 EXPOSURE_CREATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
45 EXPOSURE_CREATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
46 EXPOSURE_CREATE_DATE_HALF_TYPE_ID INTEGER 4
47 POLICY_NUMBER CHARACTER VARYING(40) 40
48 EXPOSURE_INCIDENT_LOSS_CAUSE_ID BIGINT 8
49 EXPOSURE_INCIDENT_LOSS_CAUSE CHARACTER VARYING(256) 256
50 EXPOSURE_INCIDENT_SUB_TYPE_ID BIGINT 8
51 EXPOSURE_INCIDENT_SUB_TYPE CHARACTER VARYING(256) 256
52 EXPOSURE_INCIDENT_NATURE_OF_INJURY_ID BIGINT 8
53 EXPOSURE_INCIDENT_NATURE_OF_INJURY_NAME CHARACTER VARYING(256) 256
54 EXPOSURE_INCIDENT_DETAILED_INJURY_TYPE_ID BIGINT 8
55 EXPOSURE_INCIDENT_DETAILED_INJURY_TYPE_NAME CHARACTER VARYING(256) 256
56 EXPOSURE_CLAIMANT_ID BIGINT 8
57 EXPOSURE_CLAIMANT CHARACTER VARYING(181) 181
58 EXPOSURE_COVERAGE_ID BIGINT 8
59 EXPOSURE_COVERAGE_SUBTYPE_ID BIGINT 8
60 EXPOSURE_COVERAGE_SUBTYPE CHARACTER VARYING(256) 256
61 EXPOSURE_TYPE_ID BIGINT 8
62 EXPOSURE_TYPE CHARACTER VARYING(256) 256
63 EXPOSURE_INCIDENT_ID BIGINT 8
64 EXPOSURE_STATE_ID BIGINT 8
65 EXPOSURE_STATE CHARACTER VARYING(256) 256
66 EXPOSURE_INITAL_CLOSED_DATE TIMESTAMP 8
67 EXPOSURE_INITAL_CLOSED_DATE_YEAR INTEGER 4
68 EXPOSURE_INITAL_CLOSED_DATE_QUARTER INTEGER 4
69 EXPOSURE_INITAL_CLOSED_DATE_MONTH INTEGER 4
70 EXPOSURE_INITAL_CLOSED_DATE_DAY INTEGER 4
71 EXPOSURE_INITAL_CLOSED_DATE_DAY_TYPE_ID INTEGER 4
72 EXPOSURE_INITAL_CLOSED_DATE_WEEK_TYPE_ID INTEGER 4
73 EXPOSURE_INITAL_CLOSED_DATE_MONTH_TYPE_ID INTEGER 4
74 EXPOSURE_INITAL_CLOSED_DATE_QUARTER_TYPE_ID INTEGER 4
75 EXPOSURE_INITAL_CLOSED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
76 EXPOSURE_INITAL_CLOSED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
77 EXPOSURE_INITAL_CLOSED_DATE_R12_MONTH_TYPE_ID INTEGER 4
78 EXPOSURE_INITAL_CLOSED_DATE_R13_MONTH_TYPE_ID INTEGER 4
79 EXPOSURE_INITAL_CLOSED_DATE_HALF_TYPE_ID INTEGER 4
80 BODYPART_INCIDENT_ID BIGINT 8
81 BODY_PART_TYPE_ID BIGINT 8
82 BODY_PART_TYPE_NAME CHARACTER VARYING(256) 256
83 DETAILED_BODY_PART_TYPE_ID BIGINT 8
84 DETAILED_BODY_PART_TYPE_NAME CHARACTER VARYING(256) 256
85 BODY_PART_CREATE_USER_ID BIGINT 8
86 BODY_PART_CREATE_USER_NAME CHARACTER VARYING(181) 181
87 BODY_PART_UPDATE_USER_ID BIGINT 8
88 BODY_PART_UPDATE_USER_NAME CHARACTER VARYING(181) 181
89 BODY_PART_CREATE_DATE_ID INTEGER 4
90 BODY_PART_CREATE_DATE TIMESTAMP 8
91 BODY_PART_UPDATE_DATE_ID INTEGER 4
92 BODY_PART_UPDATE_DATE TIMESTAMP 8
93 BODY_PART_ID BIGINT 8
94 BODY_PART_ORDERING_ID BIGINT 8
95 EXPOSURE_CLAIM_ID BIGINT 8
96 VERIFIED_POLICY_FLAG INTEGER 4
97 VERIFIED_POLICY CHARACTER VARYING(256) 256
98 EXPOSURE_LITIGATION_FLAG_ID INTEGER 4
99 EXPOSURE_LITIGATION_FLAG_NAME CHARACTER VARYING(256) 256
100 EXPOSURE_SEGMENT_ID BIGINT 8
101 EXPOSURE_SEGMENT CHARACTER VARYING(256) 256
102 EXPOSURE_DECISION_ID BIGINT 8
103 EXPOSURE_DECISION CHARACTER VARYING(256) 256
104 EXPOSURE_DURATION_ID INTERVAL 12
105 EXPOSURE_DURATION_BAND_ID INTEGER 4
106 EXPOSURE_DURATION_BAND CHARACTER VARYING(14) 14
107 POLICY_VERIFIED_ID CHARACTER VARYING(1) 1
108 CLAIM_POLICY_VERIFICATION_STATUS_ID BIGINT 8
109 VERIFIED_POLICY_STATUS_ID INTEGER 4
110 VERIFIED_POLICY_STATUS CHARACTER VARYING(17) 17