EG_PROJECT2_VW

(SQL View)
 Index Back

E&G Operational Projects

This is the prompt record used by Student Admin for the Project chartfield. This version is in synch with the E&G version of the record.

SELECT SETID , PROJECT_ID , EFF_STATUS , DESCR FROM PS_EG_PROJECT

  • Related Language Record: EGPROJECT2VWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project/Grant

    Prompt Table: PROJECT_VW

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description