GM_PROP_SCH_LVW

(SQL View)
 Index Back

Proposal ID Sec Search

Used for Proposal ID search record with PI and Department Level Security by Operator ID.

SELECT DISTINCT D.OPRID , A.BUSINESS_UNIT , A.PROPOSAL_ID , L.LANGUAGE_CD , L.DESCR20A , L.TITLE56 FROM PS_GM_PROPOSAL A , PSOPRDEFN D , PS_GM_PROPOSAL_LNG L WHERE %Join(COMMON_KEYS,GM_PROPOSAL A ,GM_PROPOSAL_LNG L ) AND D.EMPLID = A.EMPLID

  • Related Language Record for GM_PROP_ID_SRCH

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT

    Prompt Table: GM_PROP_BU_SRCH

    3 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR20A Character(20) VARCHAR2(20) NOT NULL Short Description
    6 TITLE56 Character(56) VARCHAR2(56) NOT NULL TITLE56