MSGHOLD_SEC_VW

(SQL View)
 Index Back

Message Security Prompt

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

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

  • Related Language Record: MSGHLD_SEC_LANG

    • # 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 MESSAGE_CD_TYPE Character(4) VARCHAR2(4) NOT NULL Message Type
    01=Credit Related Message
    02=Product Related Message
    03=Promotion Related Message
    04=Internal Warning Message
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    7 HOLD_CD Character(6) VARCHAR2(6) NOT NULL Hold Code

    Prompt Table: HOLD_OPR_SEC_VW