FCT_CI_CLAIM

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 CLAIM_ID BIGINT 8
2 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
3 CLAIM_NUMBER CHARACTER VARYING(40) 40
4 CLAIM_STR CHARACTER VARYING(20) 20
5 POLICY_ID BIGINT 8
6 CLAIMANT_DENORM_ID CHARACTER VARYING(20) 20
7 EMPLOYMENT_DATA_ID BIGINT 8
8 ALTERNATE_CLAIM_NUMBER CHARACTER VARYING(40) 40
9 LINE_OF_BUSINESS_CODE BIGINT 8
10 TRANSITION_STATUS_ID BIGINT 8
11 REPORT_ONLY_FLAG CHARACTER VARYING(3) 3
12 REPORT_ONLY_FLAG_ID BIGINT 8
13 ASSIGNED_DATE TIMESTAMP 8
14 ASSIGNED_DATE_ID INTEGER 4
15 DEATH_DATE TIMESTAMP 8
16 DEATH_DATE_ID INTEGER 4
17 FINALISED_DATE TIMESTAMP 8
18 FINALISED_DATE_ID INTEGER 4
19 LAST_REOPENED_DATE TIMESTAMP 8
20 LAST_REOPENED_DATE_ID INTEGER 4
21 LIABILITY_EFFECTIVE_DATE TIMESTAMP 8
22 LIABILITY_EFFECTIVE_DATE_ID INTEGER 4
23 CREATE_DATE TIMESTAMP 8
24 CREATE_DATE_LBL CHARACTER VARYING(30) 30
25 CREATE_DATE_ID INTEGER 4
26 LOSS_DATE TIMESTAMP 8
27 LOSS_DATE_ID INTEGER 4
28 REPORTED_DATE TIMESTAMP 8
29 REPORTED_DATE_ID INTEGER 4
30 UPDATE_TIME TIMESTAMP 8
31 UPDATE_TIME_LBL CHARACTER VARYING(30) 30
32 UPDATE_DATE_ID INTEGER 4
33 ASSIGNED_BY_USER_ID BIGINT 8
34 CLAIM_PRIMARY_ADJUSTER_ID BIGINT 8
35 CREATE_USER_ID BIGINT 8
36 PREVIOUS_ASSIGNED_USER_ID BIGINT 8
37 UPDATE_USER_ID BIGINT 8
38 ASSIGNED_GROUP_ID BIGINT 8
39 PREVIOUS_ASSIGNED_GROUP_ID BIGINT 8
40 ASSIGNMENT_STATUS_ID BIGINT 8
41 CLAIM_SEGMENT_ID BIGINT 8
42 CLAIM_STATE_ID BIGINT 8
43 CLAIM_STRATEGY_ID BIGINT 8
44 LIABILITY_STATUS_ID BIGINT 8
45 LOSS_LOCATION_ID BIGINT 8
46 REPORTED_BY_TYPE_ID BIGINT 8
47 SUBROGATION_STATUS_ID BIGINT 8
48 CLAIM_DURATION CHARACTER VARYING(17) 17
49 CLAIM_DURATION_ID INTEGER 4
50 CLAIM_DURATION_BAND_ID INTEGER 4
51 REJECTREASON BIGINT 8
52 REOPENED_REASON_ID BIGINT 8
53 LOSS_CAUSE_ID BIGINT 8
54 CLAIM_DECISION_ID BIGINT 8
55 CLAIM_SIU_REFERRAL_ID BIGINT 8
56 CLAIM_SIU_STATUS_ID BIGINT 8
57 CLAIM_EVENT_ID BIGINT 8
58 CLAIM_LITIGATION_FLAG_ID INTEGER 4
59 POLICY_VERIFICATION_STATUS_ID BIGINT 8
60 CLAIM_COMPLAINT_FLAG INTEGER 4
61 CLAIM_EXTERNAL_REFERENCE_NUMBER CHARACTER VARYING(40) 40
62 CLAIM_DESCRIPTION CHARACTER VARYING(2000) 2000
63 CLAIM_PERMISSION_SECURITY_TYPE BIGINT 8
64 CLAIM_SIU_REFERRAL_REASON_COMMENT CHARACTER VARYING(2000) 2000