GM_PRJ_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 ,B.PROJECT_FLG ,B.PERSONNEL_FLG FROM PS_GM_PRJ_DEPT A , PS_GM_PT_ACC_LVL3 B WHERE A.MAJOR_SUBDIVISION <> ' ' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT_PC AND A.PROJECT_ID = B.PROJECT_ID

# 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 PROJECT_FLG Character(1) VARCHAR2(1) NOT NULL Assign To Project
N=No
Y=Yes
8 PERSONNEL_FLG Character(1) VARCHAR2(1) NOT NULL Personnel Page