ENRL_MSG_LOG (SQL Table)	Index Back
Enrollment Message Log The Enrollment Message Log Table is used by the Enrollment Engine to return informational and error messages pertaining to an enrollment request.

ENRL_MSG_LOG

(SQL Table)

Enrollment Message Log

The Enrollment Message Log Table is used by the Enrollment Engine to return informational and error messages pertaining to an enrollment request.

Parent record: ENRL_REQ_DETAIL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ENRL_REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Enrollment Request ID

2 ENRL_REQ_DETL_SEQ Number(6,0) INTEGER NOT NULL Enrollment Req Detail Sequence

3 MESSAGE_SEQ Number(9,0) DECIMAL(9) NOT NULL Message Sequence

4 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

5 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

6 MSG_SEVERITY Character(1) VARCHAR2(1) NOT NULL Message Severity
C=Cancel
E=Error
M=Message
W=Warning

7 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ENRL_REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Enrollment Request ID
2	ENRL_REQ_DETL_SEQ	Number(6,0)	INTEGER NOT NULL	Enrollment Req Detail Sequence
3	MESSAGE_SEQ	Number(9,0)	DECIMAL(9) NOT NULL	Message Sequence
4	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
5	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
6	MSG_SEVERITY	Character(1)	VARCHAR2(1) NOT NULL	Message Severity C=Cancel E=Error M=Message W=Warning
7	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.