DIM_BNK_PERIOD_MONTH_DEP_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 PERIOD_DIM_ID BIGINT 8
2 MONTH_START_ID BIGINT 8
3 MONTH_END_ID BIGINT 8
4 QUARTER_START_ID BIGINT 8
5 QUARTER_END_ID BIGINT 8
6 FINANCIAL_START_ID BIGINT 8
7 FINANCIAL_END_ID BIGINT 8
8 DAY_OF_CALENDAR_YEAR INTEGER 4
9 DAY_OF_FINANCIAL_YEAR INTEGER 4
10 DAYS_IN_MONTH INTEGER 4
11 DAYS_IN_QUARTER INTEGER 4
12 DAYS_IN_CALENDAR_YEAR INTEGER 4
13 DAYS_IN_FINANCIAL_YEAR INTEGER 4
14 CALENDAR_MONTH_NUMBER INTEGER 4
15 FINANCIAL_MONTH_NUMBER INTEGER 4
16 CALENDAR_QUARTER_NUMBER CHARACTER VARYING(18) 18
17 FINANCIAL_QUARTER_NUMBER INTEGER 4
18 CALENDAR_YEAR_NUMBER INTEGER 4
19 FINANCIAL_YEAR_NUMBER INTEGER 4
20 MONTH_NAME CHARACTER VARYING(9) 9
21 MONTH_START_DT TIMESTAMP 8
22 MONTH_END_DT TIMESTAMP 8
23 QUARTER_START_DT TIMESTAMP 8
24 QUARTER_END_DT TIMESTAMP 8
25 FINANCIAL_START_DT TIMESTAMP 8
26 FINANCIAL_END_DT TIMESTAMP 8
27 FINANCIAL_YEAR_END_FLAG CHARACTER VARYING(1) 1
28 QUARTER_END_FLAG CHARACTER VARYING(1) 1
29 FINANCIAL_YEAR_SPAN CHARACTER VARYING(7) 7
30 FINANCIAL_MONTH_YEAR CHARACTER VARYING(6) 6
31 CURRENT_MONTH_INDICATOR CHARACTER VARYING(1) 1
32 PREVIOUS_MONTH_INDICATOR CHARACTER VARYING(1) 1
33 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
34 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
35 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
36 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8