Business Glossary

BANKPADM

VIEW

#	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