GM_AWD_DEPT_VW

(SQL View)
 Index Back

Grants Project Department Cont

This record stores grants project contact data

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.MAJOR_SUBDIVISION , B.EMPLID , B.BUSINESS_UNIT , B.CONTRACT_NUM , C.AWARD_FLAG , C.PERSONNEL_FLG FROM PS_GM_PRJ_DEPT A , PS_GM_PT_ACC_LVL3 B , PS_GM_PT_ACC_LVL2 C WHERE A.MAJOR_SUBDIVISION <> ' ' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT_PC AND A.PROJECT_ID = B.PROJECT_ID AND C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.CONTRACT_NUM = B.CONTRACT_NUM AND C.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Default Value: PROJECT_VW.PROJECT_ID

3 MAJOR_SUBDIVISION Character(10) VARCHAR2(10) NOT NULL Major Subdivision ID

Prompt Table: GM_DEPT_TBL_VW

4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 BUSINESS_UNIT_CA Character(5) VARCHAR2(5) NOT NULL Contracts Business Unit
6 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
7 AWARD_FLAG Character(1) VARCHAR2(1) NOT NULL Award Location
8 PERSONNEL_FLG Character(1) VARCHAR2(1) NOT NULL Personnel Page