ST_REPRC_PR_MSG

(SQL Table)
Index Back

Stock Grant Message Table

ST_GRNT_MESSAGE stores messages during grant batch processing.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_NAME Character(12) VARCHAR2(12) NOT NULL Process Name
2 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Company's Stock Identification Symbol
3 REPRICE_ID Character(10) VARCHAR2(10) NOT NULL Stock Reprice ID
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 GRANT_NBR Character(10) VARCHAR2(10) NOT NULL System assigned grant number used to uniquely identify the grant record.
6 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
7 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
8 MSG_DATA1 Character(100) VARCHAR2(100) NOT NULL Message Data Text 1
9 MSG_DATA2 Character(100) VARCHAR2(100) NOT NULL Message Data Text 2
10 MSG_DATA3 Character(100) VARCHAR2(100) NOT NULL Message Data Text 3
11 DTTM_STAMP 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.