CHGRD_MSGLOG_VW

(SQL View)
 Index Back

Change Grade Message Log

The Enrollment Message Log table is used by the Enrollment Engine to return informational and error messages pertaining to an enrollment request. This view shows the applied messages for the self service change grade page.

SELECT A.EMPLID , A.ENRL_REQUEST_ID , A.ENRL_REQ_DETL_SEQ , A.INSTITUTION , A.STRM , A.CLASS_NBR , B.MESSAGE_SEQ , B.MESSAGE_SET_NBR , B.MESSAGE_NBR , B.MSG_SEVERITY , B.DTTM_STAMP_SEC , A.ENRL_REQ_DETL_STAT FROM PS_ENRL_REQ_DETAIL A , PS_ENRL_MSG_LOG B WHERE A.ENRL_REQUEST_ID = B.ENRL_REQUEST_ID AND A.ENRL_REQ_DETL_SEQ = B.ENRL_REQ_DETL_SEQ

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 ENRL_REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Enrollment Request ID
3 ENRL_REQ_DETL_SEQ Number(6,0) INTEGER NOT NULL Enrollment Req Detail Sequence
4 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

5 STRM Character(4) VARCHAR2(4) NOT NULL Term

Prompt Table: TERM_TBL

6 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
7 MESSAGE_SEQ Number(9,0) DECIMAL(9) NOT NULL Message Sequence
8 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
9 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
10 MSG_SEVERITY Character(1) VARCHAR2(1) NOT NULL Message Severity
C=Cancel
E=Error
M=Message
W=Warning
11 DTTM_STAMP_SEC DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
12 ENRL_REQ_DETL_STAT Character(1) VARCHAR2(1) NOT NULL Enrollment Req Detail Status
E=Errors found
M=Success/Messages
P=Pending
S=Success
X=Pending