INT_CI_EXPOSURE_MOTOR

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 EXPOSURE_ID BIGINT 8
2 TEMP_LOCATION_ID BIGINT 8
3 PTD_BENEFITS_ID BIGINT 8
4 STAT_LINE_ID BIGINT 8
5 DIS_BENEFITS_ID BIGINT 8
6 WC_BENEFITS_ID BIGINT 8
7 ASSIGNED_BY_USER_ID BIGINT 8
8 PIPVOC_BENEFITS_ID BIGINT 8
9 SSDI_BENEFITS_ID BIGINT 8
10 UPDATE_USER_ID BIGINT 8
11 PREVIOUS_QUEUE_ID BIGINT 8
12 ASSIGNED_QUEUE_ID BIGINT 8
13 DEATH_BENEFITS_ID BIGINT 8
14 TTD_BENEFITS_ID BIGINT 8
15 LIFE_PENSION_BENEFITS_ID BIGINT 8
16 EXPOSURE_ADJUSTER_ID BIGINT 8
17 NEW_EMP_DATA_ID BIGINT 8
18 PPD_BENEFITS_ID BIGINT 8
19 PREVIOUS_GROUP_ID BIGINT 8
20 ASSIGNED_GROUP_ID BIGINT 8
21 VOC_BENEFITS_ID BIGINT 8
22 CLAIM_ID BIGINT 8
23 COMP_BENEFITS_ID BIGINT 8
24 PIP_DEATH_BENEFITS_ID BIGINT 8
25 CLAIMANT_DENORM_ID BIGINT 8
26 PREVIOUS_USER_ID BIGINT 8
27 CREATE_USER_ID BIGINT 8
28 COVERAGE_ID BIGINT 8
29 TPD_BENEFITS_ID BIGINT 8
30 RS_BENEFITS_ID BIGINT 8
31 PRIOR_EMP_DATA_ID BIGINT 8
32 LOAD_COMMAND_ID BIGINT 8
33 RI_AGREEMENT_GROUP_ID BIGINT 8
34 EXPOSURE_INCIDENT_ID BIGINT 8
35 EXPOSURE_REJECT_REASON_ID BIGINT 8
36 EXPOSURE_NUMBER CHARACTER VARYING(40) 40
37 EXPOSURE_TYPE BIGINT 8
38 COVERAGE_SUBTYPE BIGINT 8
39 CLAIMANT_TYPE BIGINT 8
40 UPDATE_TIME TIMESTAMP 8
41 UPDATE_TIME_LBL CHARACTER VARYING(30) 30
42 UPDATE_DATE_ID INTEGER 4
43 CREATE_DATE TIMESTAMP 8
44 CREATE_DATE_LBL CHARACTER VARYING(30) 30
45 CREATE_DATE_ID INTEGER 4
46 EXPOSURE_CREATE_DATE TIMESTAMP 8
47 EXPOSURE_CREATE_DATE_LBL CHARACTER VARYING(30) 30
48 EXPOSURE_CREATE_DATE_ID INTEGER 4
49 SETTLE_DATE TIMESTAMP 8
50 SETTLE_DATE_ID INTEGER 4
51 COMMIT_TIMESTAMP TIMESTAMP 8
52 COMMIT_TIMESTAMP_LBL CHARACTER VARYING(30) 30
53 COMMIT_TIMESTAMP_ID INTEGER 4
54 EXTRACT_TIMESTAMP TIMESTAMP 8
55 EXTRACT_TIMESTAMP_LBL CHARACTER VARYING(30) 30
56 EXTRACT_TIMESTAMP_ID INTEGER 4
57 EXAMINATION_DATE TIMESTAMP 8
58 EXPOSURE_STATE_ID BIGINT 8
59 EXPOSURE_DECISION_ID BIGINT 8
60 EXPOSURE_ASSIGNMENT_DATE TIMESTAMP 8
61 EXPOSURE_ASSIGNMENT_DATE_ID INTEGER 4
62 FINALISED_DATE TIMESTAMP 8
63 FINALISED_DATE_ID INTEGER 4
64 ISO_RECEIVE_DATE TIMESTAMP 8
65 ISO_RECEIVE_DATE_ID INTEGER 4
66 ISO_SEND_DATE TIMESTAMP 8
67 ISO_SEND_DATE_ID INTEGER 4
68 LAST_REOPENED_DATE TIMESTAMP 8
69 LAST_REOPENED_DATE_ID INTEGER 4
70 HOSPITAL_DATE TIMESTAMP 8
71 LAST_DAY_WORKED TIMESTAMP 8
72 EXPOSURE_DURATION INTERVAL 12
73 EXPOSURE_DURATION_BAND_ID INTEGER 4
74 EXPOSURE_ASSIGNED_TEAM_ID BIGINT 8
75 EXPOSURE_ASSIGNED_BY_USER_ID BIGINT 8
76 EXPOSURE_ASSIGNMENT_STATUS_ID BIGINT 8
77 EXPOSURE_CREATE_USER_ID BIGINT 8
78 EXPOSURE_LOSS_PARTY_ID BIGINT 8
79 EXPOSURE_PRIMARY_COVERAGE_ID BIGINT 8
80 EXPOSURE_REOPENED_REASON_ID BIGINT 8
81 EXPOSURE_SEGMENT_ID BIGINT 8
82 EXPOSURE_CLOSED_OUTCOME_ID BIGINT 8
83 EXPOSURE_SETTLEMENT_DURATION INTEGER 4
84 EXPOSURE_SETTLEMENT_DURATION_BAND_ID INTEGER 4
85 EXPOSURE_LITIGATION_FLAG_ID INTEGER 4
86 EXPOSURE_INSURED_OCCOUPATION_CODE CHARACTER VARYING(10) 10
87 EXPOSURE_INSURED_OCCOUPATION_DESCRIPTION CHARACTER VARYING(100) 100
88 EXPOSURE_COVERAGE_PRODUCT_CODE CHARACTER VARYING(20) 20
89 EXPOSURE_COVERAGE_PRODUCT_CLASS_CODE CHARACTER VARYING(20) 20
90 EXPOSURE_COVERAGE_PRODUCT_SUBCLASS_CODE CHARACTER VARYING(20) 20
91 EXPOSURE_COVERAGE_BRAND_MARKER_COVERAGE_CODE CHARACTER VARYING(10) 10