GM_PT_AWD_PD_VW (SQL View)	Index Back
Award Funding by Period

GM_PT_AWD_PD_VW

(SQL View)

Award Funding by Period

SELECT DISTINCT B.BUSINESS_UNIT , B.CONTRACT_NUM , A.BUDGET_PERIOD_GM , MIN(A.START_DT) , MAX(A.END_DT) , A.CURRENCY_CD , A.PROCESS_INSTANCE FROM PS_GM_PT_PRJ_BUD A , PS_GM_PT_PROJECT B WHERE B.BUSINESS_UNIT_PC = A.BUSINESS_UNIT_PC AND B.PROJECT_ID = A.PROJECT_ID AND B.CONTRACT_NUM <> ' ' GROUP BY B.BUSINESS_UNIT , B.CONTRACT_NUM , A.BUDGET_PERIOD_GM, A.CURRENCY_CD, A.PROCESS_INSTANCE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: GM_AWARD.BUSINESS_UNIT
Prompt Table: SP_BU_CA_NONVW

2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
Prompt Table: CA_CNTR_SRCH_VW

3 BUDGET_PERIOD_GM Number(3,0) SMALLINT NOT NULL BUDGET_PERIOD_GM
Default Value: 1

4 BEGIN_DT Date(10) DATE Begin Date

5 END_DT Date(10) DATE End Date

6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

7 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: GM_AWARD.BUSINESS_UNIT Prompt Table: SP_BU_CA_NONVW
2	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Prompt Table: CA_CNTR_SRCH_VW
3	BUDGET_PERIOD_GM	Number(3,0)	SMALLINT NOT NULL	BUDGET_PERIOD_GM Default Value: 1
4	BEGIN_DT	Date(10)	DATE	Begin Date
5	END_DT	Date(10)	DATE	End Date
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
7	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance