FCT_CI_CLAIM_PAYMENTS_DRILLTHRU

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 BRAND_ID BIGINT 8
2 BRAND_NAME CHARACTER VARYING(256) 256
3 CLAIM_CREATED_DATE TIMESTAMP 8
4 CLAIM_CREATED_DATE_LBL CHARACTER VARYING(30) 30
5 CLAIM_CREATED_DATE_ID INTEGER 4
6 CLAIM_NUMBER CHARACTER VARYING(40) 40
7 CLAIM_LATEST_FINALISED_DATE TIMESTAMP 8
8 CLAIM_LATEST_FINALISED_DATE_ID INTEGER 4
9 CLAIM_LATEST_REOPENED_DATE TIMESTAMP 8
10 CLAIM_LATEST_REOPENED_DATE_ID INTEGER 4
11 CLAIM_SEGMENT_ID BIGINT 8
12 CLAIM_SEGMENT_NAME CHARACTER VARYING(256) 256
13 CLAIM_STATE_ID BIGINT 8
14 CLAIM_STATE_NAME CHARACTER VARYING(256) 256
15 CLAIM_CREATE_DATE_DATE_KEY INTEGER 4
16 CLAIM_CREATE_DATE_CAL_YEAR INTEGER 4
17 CLAIM_CREATE_DATE_CAL_QUARTER INTEGER 4
18 CLAIM_CREATE_DATE_CAL_MONTH INTEGER 4
19 CLAIM_CREATE_DATE_CAL_DAY INTEGER 4
20 CLAIM_CREATE_DATE_DAY_TYPE_ID INTEGER 4
21 CLAIM_CREATE_DATE_WEEK_TYPE_ID INTEGER 4
22 CLAIM_CREATE_DATE_MONTH_TYPE_ID INTEGER 4
23 CLAIM_CREATE_DATE_QUARTER_TYPE_ID INTEGER 4
24 CLAIM_CREATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
25 CLAIM_CREATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
26 CLAIM_CREATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
27 CLAIM_CREATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
28 CLAIM_CREATE_DATE_HALF_TYPE_ID INTEGER 4
29 CLAIM_LATEST_REOPENED_DATE_KEY INTEGER 4
30 CLAIM_LATEST_REOPENED_DATE_CAL_YEAR INTEGER 4
31 CLAIM_LATEST_REOPENED_DATE_CAL_QUARTER INTEGER 4
32 CLAIM_LATEST_REOPENED_DATE_CAL_MONTH INTEGER 4
33 CLAIM_LATEST_REOPENED_DATE_CAL_DAY INTEGER 4
34 CLAIM_LATEST_REOPENED_DATE_DAY_TYPE_ID INTEGER 4
35 CLAIM_LATEST_REOPENED_DATE_WEEK_TYPE_ID INTEGER 4
36 CLAIM_LATEST_REOPENED_DATE_MONTH_TYPE_ID INTEGER 4
37 CLAIM_LATEST_REOPENED_DATE_QUARTER_TYPE_ID INTEGER 4
38 CLAIM_LATEST_REOPENED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
39 CLAIM_LATEST_REOPENED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
40 CLAIM_LATEST_REOPENED_DATE_R12_MONTH_TYPE_ID INTEGER 4
41 CLAIM_LATEST_REOPENED_DATE_R13_MONTH_TYPE_ID INTEGER 4
42 CLAIM_LATEST_REOPENED_DATE_HALF_TYPE_ID INTEGER 4
43 CLAIM_LATEST_FINALISED_DATE_KEY INTEGER 4
44 CLAIM_LATEST_FINALISED_DATE_CAL_YEAR INTEGER 4
45 CLAIM_LATEST_FINALISED_DATE_CAL_QUARTER INTEGER 4
46 CLAIM_LATEST_FINALISED_DATE_CAL_MONTH INTEGER 4
47 CLAIM_LATEST_FINALISED_DATE_CAL_DAY INTEGER 4
48 CLAIM_LATEST_FINALISED_DATE_DAY_TYPE_ID INTEGER 4
49 CLAIM_LATEST_FINALISED_DATE_WEEK_TYPE_ID INTEGER 4
50 CLAIM_LATEST_FINALISED_DATE_MONTH_TYPE_ID INTEGER 4
51 CLAIM_LATEST_FINALISED_DATE_QUARTER_TYPE_ID INTEGER 4
52 CLAIM_LATEST_FINALISED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
53 CLAIM_LATEST_FINALISED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
54 CLAIM_LATEST_FINALISED_DATE_R12_MONTH_TYPE_ID INTEGER 4
55 CLAIM_LATEST_FINALISED_DATE_R13_MONTH_TYPE_ID INTEGER 4
56 CLAIM_LATEST_FINALISED_DATE_HALF_TYPE_ID INTEGER 4