Business Glossary

BANKPADM

VIEW

MERGED extract used by the Cost centre Sales Summary to provide reporting for front line staff, contains growth calc per account

#	Name	Data Type	Length
1	BUSINESS_PERIOD_DIM_ID	BIGINT	8
2	START_PERIOD_DIM_ID	NUMERIC(38,0)	19
3	END_PERIOD_DIM_ID	NUMERIC(38,0)	19
4	PERIOD_TYPE_DIM_ID	BIGINT	8
5	REPORTING_PERIOD_DIM_ID	BIGINT	8
6	ACCOUNT_DIM_ID	BIGINT	8
7	SOURCE_PRODUCT_DIM_ID	BIGINT	8
8	SOURCE_PRODUCT_CODE	CHARACTER VARYING(104)	104
9	BALANCE_SHEET_INDICATOR	CHARACTER VARYING(20)	20
10	COST_CENTRE_DIM_ID	BIGINT	8
11	GL_PRODUCT_DIM_ID	BIGINT	8
12	BDM_DIM_ID	BIGINT	8
13	PERS_INV_USAGE_TYPE_DIM_ID	BIGINT	8
14	SEGMENT_START_PERIOD_DIM_ID	NUMERIC(38,0)	19
15	SEGMENT_END_PERIOD_DIM_ID	NUMERIC(38,0)	19
16	SEGMENT_OPENING_BALANCE	DOUBLE PRECISION	8
17	SEGMENT_CLOSING_BALANCE	DOUBLE PRECISION	8
18	SEGMENT_GROWTH	DOUBLE PRECISION	8
19	SEGMENT_TRANSFER	DOUBLE PRECISION	8
20	SEGMENT_ACTIVE	INTEGER	4
21	OPENED_CLOSED_IMPACT	INTEGER	4
22	SEGMENT_IMPACT_OA	INTEGER	4
23	SEGMENT_IMPACT_PERS_INV	INTEGER	4
24	SEGMENT_IMPACT_SP	INTEGER	4
25	SEGMENT_IMPACT_BAL_SHT_IND	INTEGER	4
26	SEGMENT_IMPACT_GL_PROD	INTEGER	4
27	SEGMENT_IMPACT_COST_CENTRE	INTEGER	4
28	SEGMENT_IMPACT_BDM	BIGINT	8
29	SALES_SEGMENT_TRANSFER_CC	DOUBLE PRECISION	8
30	SALES_SEGMENT_TRANSFER_NON_CC	DOUBLE PRECISION	8
31	SALES_GROWTH	DOUBLE PRECISION	8
32	GL_ACCOUNT_DIM_ID	BIGINT	8
33	GL_BUSINESS_UNIT_DIM_ID	BIGINT	8
34	SDW_IGNITE_SOURCE	CHARACTER(1)	1
35	CDC_SOURCE_SYSTEM_CODE	CHARACTER VARYING(4)	4
36	CDC_RECORD_TYPE	CHARACTER VARYING(16)	16
37	CDC_COMMIT_TIMESTAMP	TIMESTAMP	8
38	CDC_EXTRACT_TIMESTAMP	TIMESTAMP	8