Business Glossary

CDCPADM_BDW

TABLE

#	Name	Data Type	Length
1	PERIOD_DIM_ID	BIGINT	8
2	ACCOUNT_DIM_ID	BIGINT	8
3	SOURCE_PRODUCT_DIM_ID	BIGINT	8
4	SOURCE_PRODUCT_CODE	CHARACTER VARYING(24)	24
5	BALANCE_SHEET_INDICATOR	CHARACTER VARYING(20)	20
6	GL_ACCOUNT_DIM_ID	BIGINT	8
7	GL_PRODUCT_DIM_ID	BIGINT	8
8	GL_BUSINESS_UNIT_DIM_ID	BIGINT	8
9	COST_CENTRE_DIM_ID	BIGINT	8
10	RATE_TYPE_DIM_ID	BIGINT	8
11	BASE_CARDED_RATE_DIM_ID	BIGINT	8
12	MARGIN_DIM_ID	BIGINT	8
13	RATE	NUMERIC(8,5)	19
14	BALANCE	NUMERIC(14,2)	19
15	RATE_DOLLAR_VALUE	NUMERIC(14,2)	19
16	CDC_SOURCE_SYSTEM_CODE	CHARACTER VARYING(4)	4
17	CDC_RECORD_TYPE	CHARACTER VARYING(16)	16
18	CDC_COMMIT_TIMESTAMP	TIMESTAMP	8
19	CDC_EXTRACT_TIMESTAMP	TIMESTAMP	8