PROJID_ADPC_LVW

(SQL View)
 Index Back

PC Add Mode for PC Lang View

Used to display a prompt box that displays only projects that match the business_unit_pc found in the buffer.

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , L.LANGUAGE_CD , L.DESCR FROM PS_PROJECT_FS A , PS_PROJECT_LANG L WHERE %Join(COMMON_KEYS, PROJECT_FS A, PROJECT_LANG L)

  • Related Language Record for PROJID_ADDPC_VW SP_PROJ3_CLSVW SP_PROJ3_NONVW SP_PROJ3_OPRVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
    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