Business Glossary

BANKPADM

TABLE

#	Name	Data Type	Length
1	PERIOD_DIM_ID	BIGINT	8
2	WEEK_START_ID	BIGINT	8
3	WEEK_END_ID	BIGINT	8
4	FINANCIAL_START_ID	BIGINT	8
5	FINANCIAL_END_ID	BIGINT	8
6	DAY_OF_CALENDAR_YEAR	INTEGER	4
7	DAY_OF_FINANCIAL_YEAR	INTEGER	4
8	DAYS_IN_CALENDAR_YEAR	INTEGER	4
9	DAYS_IN_FINANCIAL_YEAR	INTEGER	4
10	CALENDAR_WEEK_NUMBER	INTEGER	4
11	FINANCIAL_WEEK_NUMBER	INTEGER	4
12	CALENDAR_YEAR_NUMBER	INTEGER	4
13	FINANCIAL_YEAR_NUMBER	INTEGER	4
14	DAY_NAME	CHARACTER VARYING(9)	9
15	MONTH_NAME	CHARACTER VARYING(9)	9
16	MONTH_END_FLAG	CHARACTER VARYING(1)	1
17	WEEK_START_DT	TIMESTAMP	8
18	WEEK_END_DT	TIMESTAMP	8
19	FINANCIAL_START_DT	TIMESTAMP	8
20	FINANCIAL_END_DT	TIMESTAMP	8
21	FINANCIAL_YEAR_END_FLAG	CHARACTER VARYING(1)	1
22	QUARTER_END_FLAG	CHARACTER VARYING(1)	1
23	FINANCIAL_YEAR_SPAN	CHARACTER VARYING(7)	7
24	FINANCIAL_WEEK_YEAR	CHARACTER VARYING(6)	6
25	CURRENT_WEEK_INDICATOR	CHARACTER VARYING(1)	1
26	PREVIOUS_WEEK_INDICATOR	CHARACTER VARYING(1)	1
27	CDC_SOURCE_SYSTEM_CODE	CHARACTER VARYING(4)	4
28	CDC_RECORD_TYPE	CHARACTER VARYING(16)	16
29	CDC_COMMIT_TIMESTAMP	TIMESTAMP	8
30	CDC_EXTRACT_TIMESTAMP	TIMESTAMP	8