KK_OLAP_BD_PD

(SQL View)

SELECT DISTINCT A.BUDGET_PERIOD , B.OPRID , B.RUN_CNTL_ID FROM PS_LEDGER_KK A , PS_KK_OLAP_LED_REQ B , PS_LED_GRP_LED_TBL C , PS_SET_CNTRL_REC D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUDGET_PERIOD >= B.BUDGET_PERIOD_FROM AND A.BUDGET_PERIOD <= B.BUDGET_PERIOD_TO AND C.LEDGER_GROUP = B.LEDGER_GROUP AND D.SETCNTRLVALUE=A.BUSINESS_UNIT AND D.REC_GROUP_ID = 'FS_04' AND D.RECNAME = 'LED_GRP_LED_TBL' AND D.SETID = C.SETID AND C.LEDGER = A.LEDGER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUDGET_PERIOD Character(8) VARCHAR2(8) NOT NULL Budget Period

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUDGET_PERIOD	Character(8)	VARCHAR2(8) NOT NULL	Budget Period
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID