PC_WC_PROJ_TYPE

(SQL View)
 Index Back

No Project Types in Projects

This view has been created to fetch Projects having Blank Project Type for WorkCenter exception.

SELECT P.BUSINESS_UNIT , P.PROJECT_ID , P.DESCR , P.EFF_STATUS , P.START_DT , P.END_DT , P.PROJECT_TYPE , MP.OPRID FROM PS_PC_OPRID_PRJACT MP , PS_PROJECT P WHERE MP.BUSINESS_UNIT = P.BUSINESS_UNIT AND MP.PROJECT_ID = P.PROJECT_ID AND P.PROJECT_TYPE= ' ' AND P.EFF_STATUS='A'

  • Parent record: PROJECT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 PROCESSING_STATUS Character(1) VARCHAR2(1) NOT NULL Processing status
    A=Active
    I=Inactive
    P=Pending
    5 START_DT Date(10) DATE Start Date
    6 END_DT Date(10) DATE End Date
    7 PROJECT_TYPE Character(5) VARCHAR2(5) NOT NULL Project Type
    A=Activity
    G=Grant
    H=Phase
    P=Project
    S=Segment
    8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).