PGM_CHC_SRCH

(SQL View)
 Index Back

Change Request Project Prompt

This view is used as the project prompt record for Change Requests. It only returns those projects which have change control turned on, and the change control template indicates change request is required.

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.DESCR , A.PC_CHC_TEMPLATE FROM PS_PROJECT A , PS_PC_CHC_CFG B WHERE A.PC_CHC_SW = 'Y' AND A.EFF_STATUS <> 'T' AND A.PC_CHC_TEMPLATE = B.PC_CHC_TEMPLATE AND (B.PC_CHC_CFG_ACT = 'CRR' OR B.PC_CHC_CFG_ACT_DT = 'CRR' OR B.PC_CHC_CFG_ACT_MIL = 'CRR' OR B.PC_CHC_CFG_ACT_ST = 'CRR' OR B.PC_CHC_CFG_PRJ_DT = 'CRR' OR B.PC_CHC_CFG_PRJ_ST = 'CRR' OR B.PC_CHC_CFG_RES = 'CRR' OR B.PC_CHC_CFG_RES_DT = 'CRR' OR B.PC_CHC_ADDL_RES = 'CRR' OR B.PC_CHC_UPD_RES_UNT = 'CRR')

  • Related Language Record: PGM_CHC_SRCH_LG

    • # 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
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 PC_CHC_TEMPLATE Character(30) VARCHAR2(30) NOT NULL Change Control Template