PROJECT_TMPL_VW

(SQL View)
 Index Back

Operational Project Templates


SELECT BUSINESS_UNIT ,PROJECT_ID ,DESCR , EFF_STATUS FROM PS_PROJECT WHERE TEMPLATE_SW = 'Y'

  • Related Language Record: PROJ_TMPL_VW_LA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template
    3 PROJECT_NAME Character(30) VARCHAR2(30) NOT NULL Displays the Project names.
    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive