PGM_CHC_SRCH_LG

(SQL View)
 Index Back

Change Request Project Lang

Language view for PGM_CHC_SRCH and PGM_CHC_BUD_SRH.

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , L.LANGUAGE_CD , L.DESCR FROM PS_PROJECT A , PS_PC_CHC_CFG B , PS_PROJECT_LANG L WHERE A.PC_CHC_SW = 'Y' AND A.EFF_STATUS <> 'T' AND A.PC_CHC_TEMPLATE = B.PC_CHC_TEMPLATE AND A.BUSINESS_UNIT = L.BUSINESS_UNIT AND A.PROJECT_ID = L.PROJECT_ID 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_FIN_BUD_PLN = 'CRR' OR B.PC_CHC_ADDL_RES = 'CRR' OR B.PC_CHC_UPD_RES_UNT = 'CRR' OR B.PC_CHC_UPD_ETC = 'CRR')

  • Related Language Record for PGM_CHC_BUD_SRH PGM_CHC_SRCH SP_PRJCHC_CLSVW SP_PRJCHC_NONVW SP_PRJCHC_OPRVW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description