ST_GRNT_MESSAGE (SQL Table)	Index Back
Stock Grant Message Table ST_GRNT_MESSAGE stores messages during grant batch processing.

ST_GRNT_MESSAGE

(SQL Table)

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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Stock ID

4 GRANT_NBR Character(10) VARCHAR2(10) NOT NULL System assigned grant number used to uniquely identify the grant record.

5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

6 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID
Prompt Table: VC_PLAN_TBL

7 VC_PAYOUT_PRD_ID Character(10) VARCHAR2(10) NOT NULL Payout Period ID
Prompt Table: VC_PAYPRD_TBL

8 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
Prompt Table: GB_GROUP_TBL

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

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

11 MSGDATA1 Character(30) VARCHAR2(30) NOT NULL Message Data

12 MSGDATA2 Character(30) VARCHAR2(30) NOT NULL Message Data

13 MSGDATA3 Character(30) VARCHAR2(30) NOT NULL Message Data

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_NAME	Character(12)	VARCHAR2(12) NOT NULL	Process Name
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Stock ID
4	GRANT_NBR	Character(10)	VARCHAR2(10) NOT NULL	System assigned grant number used to uniquely identify the grant record.
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
6	VC_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	VC Plan ID Prompt Table: VC_PLAN_TBL
7	VC_PAYOUT_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Payout Period ID Prompt Table: VC_PAYPRD_TBL
8	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID. Prompt Table: GB_GROUP_TBL
9	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
10	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
11	MSGDATA1	Character(30)	VARCHAR2(30) NOT NULL	Message Data
12	MSGDATA2	Character(30)	VARCHAR2(30) NOT NULL	Message Data
13	MSGDATA3	Character(30)	VARCHAR2(30) NOT NULL	Message Data
14	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.