PROJ_NOSUMM_VW

(SQL View)
Index Back

Exclude Summary Projects

Exclude Summary Projects

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.EFF_STATUS , A.DESCR , A.PROJECT_TYPE , A.ENFORCE , A.ENFORCE_TYPE FROM PS_PROJECT A WHERE A.EFF_STATUS = 'A' AND A.SUMMARY_PRJ = 'N'

  • Related Language Record: PROJECT_LANG
  • # 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 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

    Default Value: OPR_DEF_TBL_PC.PROJECT_ID

    Prompt Table: SP_PROJ_NONVW

    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
    5 PROJECT_TYPE Character(5) VARCHAR2(5) NOT NULL Project Type
    A=Activity
    G=Grant
    H=Phase
    P=Project
    S=Segment

    Prompt Table: PROJ_TYPE_TBL

    6 ENFORCE Character(1) VARCHAR2(1) NOT NULL Enforce project team based prompt. Besides the defined translate values, this field is updated with a value of 'N' when team is not enforced in any of the products.
    E=Expenses
    N=No
    T=Time&Labor
    Y=Exp and TL

    Default Value: BUS_UNIT_OPT_PC.ENFORCE

    7 ENFORCE_TYPE Character(1) VARCHAR2(1) NOT NULL Enforce project and activity team based prompt.
    B=Project and Activity Team
    N=Do Not Enforce
    P=Project Team Only
    R=Project Resource Pools Only
    S=Project Activity Resource Pool
    X=Decide at the Project Level

    Default Value: BUS_UNIT_OPT_PC.ENFORCE_TYPE