ST_ACTN_PRC_MSG (SQL Table)	Index Back
Stock Action Process Messages This table holds the results from the Stock Action Process.

ST_ACTN_PRC_MSG

(SQL Table)

Stock Action Process Messages

This table holds the results from the Stock Action Process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERS_SRCH_GBL

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

3 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Stock ID
Prompt Table: STOCK_TBL

4 STOCK_ACTION Character(3) VARCHAR2(3) NOT NULL Stock Action

5 STOCK_ACTION_DT Date(10) DATE Date the stock action is effective.

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

7 VEST_EFFDT Date(10) DATE Vesting effective date.

8 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

9 ST_OPTION_TYPE Character(4) VARCHAR2(4) NOT NULL Option Type
ISAR=ISO-Stock Appreciation Right
ISO=Incentive Stock Option
NQ=Non-Qualified
NSAR=NQ-Stock Appreciation Right
RSA=Restricted Stock Award

10 REVERSALS Character(1) VARCHAR2(1) NOT NULL All Reversals/Adjustments
Y/N Table Edit
Default Value: N

11 SHARES_REPURCHABLE Signed Number(20,6) DECIMAL(18,6) NOT NULL Shares Repurchasable

12 PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Process Flag
C=Complete
V=Void
X=W-2c Issued
Y/N Table Edit
Default Value: N

13 ST_PROCESS_ORIGIN Character(1) VARCHAR2(1) NOT NULL Indicates where the Stock Action process was originated, that being HRMS or by Stock Administration
M=Manually
W=Worklist

14 MESSAGE_TEXT40 Character(40) VARCHAR2(40) NOT NULL Message Text

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERS_SRCH_GBL
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Stock ID Prompt Table: STOCK_TBL
4	STOCK_ACTION	Character(3)	VARCHAR2(3) NOT NULL	Stock Action
5	STOCK_ACTION_DT	Date(10)	DATE	Date the stock action is effective.
6	GRANT_NBR	Character(10)	VARCHAR2(10) NOT NULL	System assigned grant number used to uniquely identify the grant record.
7	VEST_EFFDT	Date(10)	DATE	Vesting effective date.
8	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
9	ST_OPTION_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Option Type ISAR=ISO-Stock Appreciation Right ISO=Incentive Stock Option NQ=Non-Qualified NSAR=NQ-Stock Appreciation Right RSA=Restricted Stock Award
10	REVERSALS	Character(1)	VARCHAR2(1) NOT NULL	All Reversals/Adjustments Y/N Table Edit Default Value: N
11	SHARES_REPURCHABLE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Shares Repurchasable
12	PROCESS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Process Flag C=Complete V=Void X=W-2c Issued Y/N Table Edit Default Value: N
13	ST_PROCESS_ORIGIN	Character(1)	VARCHAR2(1) NOT NULL	Indicates where the Stock Action process was originated, that being HRMS or by Stock Administration M=Manually W=Worklist
14	MESSAGE_TEXT40	Character(40)	VARCHAR2(40) NOT NULL	Message Text
15	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.