MSGHLD_SEC_LANG

(SQL View)
 Index Back

Message Security Related Lang

This view should not be used except for as a prompt.

SELECT A.SETID , A.MESSAGE_CD , O.OPRID , A.LANGUAGE_CD , A.DESCR , A.DESCR254 FROM PS_MESSAGE_TBL_LG A , PS_MESSAGE_TBL B , PSOPRDEFN O WHERE %Join(COMMON_KEYS, MESSAGE_TBL_LG A, MESSAGE_TBL B) AND %EffdtCheck(MESSAGE_TBL C, B, %CurrentDateIn) AND B.EFF_STATUS <> 'I' AND (B.HOLD_CD = ' ' OR (B.HOLD_CD <> ' ' AND EXISTS ( SELECT 'X' FROM PS_SET_CNTRL_REC S , PS_HOLD_OPR_ADD_VW H WHERE B.SETID = S.SETCNTRLVALUE AND S.REC_GROUP_ID = 'FS_32' AND S.RECNAME = 'HOLD_CD' AND S.SETID = H.SETID AND B.HOLD_CD = H.HOLD_CD AND O.OPRID = H.OPRID)))

  • Related Language Record for MSGHOLD_SEC_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 MESSAGE_CD Character(6) VARCHAR2(6) NOT NULL Message Code
    3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254