TL_MSG_SET_VW

(SQL View)
 Index Back

T&L Message Set Vw-Lng

Contains the Set Numbers and Descriptions for all Time & Labor Message Sets (13500 through 13508), for each Operator in the Operator's base language. View is used as a prompt view to assign Messages to Time & Labor exceptions; messages sets in prompt are displayed in the Operator's base language.

SELECT B.OPRID , A.MESSAGE_SET_NBR , A.DESCR FROM PSMSGSETDEFN A , PSOPRDEFN B WHERE ( (A.MESSAGE_SET_NBR >= 13500 AND A.MESSAGE_SET_NBR <= 13510) OR A.MESSAGE_SET_NBR >20000)

  • Related Language Record: TL_MSGSETVW_LNG

  • Parent Record Of TL_MSGCATVW_LNG TL_MSG_CATLG_VW

    • # 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 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description