SSR_RS_MSGS_VW

(SQL View)
 Index Back

Research Edit Messages

Store edit messages from the message catalog.

SELECT A.EMPLID ,A.INSTITUTION ,A.SSR_RS_CANDIT_NBR ,A.SEQNUM ,A.MESSAGE_SET_NBR ,A.MESSAGE_NBR ,A.SCC_ROW_ADD_OPRID ,A.SCC_ROW_ADD_DTTM ,A.SCC_ROW_UPD_OPRID ,A.SCC_ROW_UPD_DTTM ,B.MSG_SEVERITY ,C.XLATLONGNAME ,B.MESSAGE_TEXT ,B.DESCRLONG FROM PS_SSR_RS_MSGS A , PSMSGCATDEFN B , PSXLATITEM C WHERE A.MESSAGE_SET_NBR = B.MESSAGE_SET_NBR AND A.MESSAGE_NBR = B.MESSAGE_NBR AND C.FIELDNAME = 'MSG_SEVERITY' AND C.FIELDVALUE = B.MSG_SEVERITY AND %EffdtCheck(PSXLATITEM D,C,%currentdatein)

  • Parent record: SSR_RS_CAND_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    3 SSR_RS_CANDIT_NBR Character(12) VARCHAR2(12) NOT NULL Last Candidate Number
    4 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    5 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
    6 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    7 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    8 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    9 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    10 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time
    11 MSG_SEVERITY Character(1) VARCHAR2(1) NOT NULL Message Severity
    C=Cancel
    E=Error
    M=Message
    W=Warning

    Default Value: M

    12 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    13 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
    14 DESCRLONG Long Character CLOB Long Description