GM_CONT_PRD_VW

(SQL View)
 Index Back

Grants Proposal Period


SELECT A.BUSINESS_UNIT , A.CONTRACT_NUM , B.BUDGET_PERIOD_GM , A.PROPOSAL_ID , A.VERSION_ID , B.CURRENCY_CD , B.BEGIN_DT , B.END_DT , B.TARGET_BUDGET_AMT , B.DESCRLONG FROM PS_GM_AWARD A , PS_GM_PROP_PERIOD B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.PROPOSAL_ID = A.PROPOSAL_ID AND B.VERSION_ID = A.VERSION_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT

Prompt Table: SP_BU_PC_NONVW

2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
3 BUDGET_PERIOD_GM Number(3,0) SMALLINT NOT NULL BUDGET_PERIOD_GM

Default Value: 1

4 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID

Prompt Table: GM_PROP_ID_VW

5 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID

Prompt Table: GM_PROPOSAL

6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
7 BEGIN_DT Date(10) DATE NOT NULL Begin Date
8 END_DT Date(10) DATE NOT NULL End Date
9 TARGET_BUDGET_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Target Sponsor Budget
10 DESCRLONG Long Character CLOB Long Description