ST_ACTN_PRC_AET (SQL Table)	Index Back
Stock Action Process AE Record This record is for the Application Engine program that processes Stock Actions.

ST_ACTN_PRC_AET

(SQL Table)

Stock Action Process AE Record

This record is for the Application Engine program that processes Stock Actions.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

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

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

6 GRANT_DT Date(10) DATE NOT NULL Grant Date

7 STOCK_PLAN Character(10) VARCHAR2(10) NOT NULL Stock Plan

8 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

9 VEST_DEFER_DT Date(10) DATE The date the employee must return from leave to avoid vesting deferral.

10 PRIOR_STOCK_ACTION Character(3) VARCHAR2(3) NOT NULL Stock Action

11 PRIOR_STCK_ACTN_DT Date(10) DATE Date the stock action WAS effective.

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

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

14 VEST_IMMEDIATE Character(1) VARCHAR2(1) NOT NULL Vest Immediate
Y/N Table Edit

15 EXPIRE_GRACE_PD_MM Number(3,0) SMALLINT NOT NULL Expire Grace Period

16 EXPIRE_GRACE_PD_DD Number(2,0) SMALLINT NOT NULL Expire Grace Period: Days

17 ISO_GRACE_PD_TYPE Character(3) VARCHAR2(3) NOT NULL ISO Grace Period Type
D=Disability
N=None
T=Termination

18 EXER_SUSPEND_TYPE Character(3) VARCHAR2(3) NOT NULL Suspend Exercise Rule
D=Defined Period
N=None
R=Until Return from Leave

19 EXER_SUSPEND_PD_MM Number(3,0) SMALLINT NOT NULL Exersise Suspend Months

20 EXER_SUSPEND_PD_DD Number(2,0) SMALLINT NOT NULL Exercise Suspend: Days

21 VEST_SUSPEND Character(1) VARCHAR2(1) NOT NULL Suspend Vesting
Y/N Table Edit

22 VEST_DEFR_GRACE_MM Number(3,0) SMALLINT NOT NULL Vest Defer Grace Months

23 VEST_DEFR_GRACE_DD Number(2,0) SMALLINT NOT NULL Vest Defer Grace Days

24 VEST_DEFER_SVC_MM Number(3,0) SMALLINT NOT NULL Vest Defer Service: Months

25 VEST_DEFER_SVC_DD Number(2,0) SMALLINT NOT NULL Vest Defer Service: Days

26 DAYS_DIFF Number(4,0) SMALLINT NOT NULL Days Difference

27 EXER_SUSPND_BGN_DT Date(10) DATE No exercises will be allowed on or after this date.

28 EXER_SUSPND_END_DT Date(10) DATE Used in conjunction with Exer_Suspnd_Bgn_Dt.

29 EXPIRATN_DT Date(10) DATE Expiration Date

30 IF_FLAG Character(1) VARCHAR2(1) NOT NULL If flag

31 ISO_EXER_AS_NQ_DT Date(10) DATE Excercises on or after this date must be treated as NQ

32 LAST_EMPLID Character(11) VARCHAR2(11) NOT NULL Last EmplID

33 OK_TO_PROCESS Character(1) VARCHAR2(1) NOT NULL OK To Process

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

35 STOCK_ACTION_TYPE Character(1) VARCHAR2(1) NOT NULL Stock Action Type
L=Leave of Absence
R=Return from Leave
T=Termination

36 TEMPDATE Date(10) DATE TempDate

37 TERM_EXPIRATN_DT Date(10) DATE Expiration date of unexercised shares when emplyee terminates.

38 VEST_DT Date(10) DATE Vesting Date

39 VEST_EFFDT Date(10) DATE Vesting effective date.

40 VEST_REASON Character(4) VARCHAR2(4) NOT NULL Vesting reason code.
CORR=Correction
INIT=Initial Vesting
MERG=Merger/Acquisition
PERF=Performance Vesting
RFL=Return from Leave
RPRC=Reprice
TER=Termination

41 VEST_SCHED_ID Character(10) VARCHAR2(10) NOT NULL The ID that identifies this vesting schedule.

42 VEST_SUSPEND_DT Date(10) DATE The date vesting is suspended when an employee is on leave.

43 SHARES_VESTED Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of shares that vest on VEST_DT.

44 ACTION Character(3) VARCHAR2(3) NOT NULL Action
Prompt Table: ACTION_TBL

45 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

46 UPDATE_FLAG Character(1) VARCHAR2(1) NOT NULL Update Flag

47 DONE_FLAG Character(1) VARCHAR2(1) NOT NULL Done Flag

48 REVERSALS Character(1) VARCHAR2(1) NOT NULL All Reversals/Adjustments
Y/N Table Edit

49 DELETE_FLAG Character(1) VARCHAR2(1) NOT NULL Deletion Flag
N=No
Y=Yes

50 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

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

52 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
Prompt Table: PSBUSPROCDEFN

53 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
Prompt Table: ACTIVITY_PROMPT

54 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow
Prompt Table: PSEVENTDEFN

55 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name
Prompt Table: WORKLIST_PRMPT

56 INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST

57 TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier

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

59 UPDATE_SW Character(1) VARCHAR2(1) NOT NULL Update Switch

60 ST_LOA_TER_SW Character(1) VARCHAR2(1) NOT NULL This switch is for HR Intergration to identify the special LOA/TER process.

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

62 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	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Stock ID
5	GRANT_NBR	Character(10)	VARCHAR2(10) NOT NULL	System assigned grant number used to uniquely identify the grant record.
6	GRANT_DT	Date(10)	DATE NOT NULL	Grant Date
7	STOCK_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Stock Plan
8	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
9	VEST_DEFER_DT	Date(10)	DATE	The date the employee must return from leave to avoid vesting deferral.
10	PRIOR_STOCK_ACTION	Character(3)	VARCHAR2(3) NOT NULL	Stock Action
11	PRIOR_STCK_ACTN_DT	Date(10)	DATE	Date the stock action WAS effective.
12	STOCK_ACTION	Character(3)	VARCHAR2(3) NOT NULL	Stock Action
13	STOCK_ACTION_DT	Date(10)	DATE	Date the stock action is effective.
14	VEST_IMMEDIATE	Character(1)	VARCHAR2(1) NOT NULL	Vest Immediate Y/N Table Edit
15	EXPIRE_GRACE_PD_MM	Number(3,0)	SMALLINT NOT NULL	Expire Grace Period
16	EXPIRE_GRACE_PD_DD	Number(2,0)	SMALLINT NOT NULL	Expire Grace Period: Days
17	ISO_GRACE_PD_TYPE	Character(3)	VARCHAR2(3) NOT NULL	ISO Grace Period Type D=Disability N=None T=Termination
18	EXER_SUSPEND_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Suspend Exercise Rule D=Defined Period N=None R=Until Return from Leave
19	EXER_SUSPEND_PD_MM	Number(3,0)	SMALLINT NOT NULL	Exersise Suspend Months
20	EXER_SUSPEND_PD_DD	Number(2,0)	SMALLINT NOT NULL	Exercise Suspend: Days
21	VEST_SUSPEND	Character(1)	VARCHAR2(1) NOT NULL	Suspend Vesting Y/N Table Edit
22	VEST_DEFR_GRACE_MM	Number(3,0)	SMALLINT NOT NULL	Vest Defer Grace Months
23	VEST_DEFR_GRACE_DD	Number(2,0)	SMALLINT NOT NULL	Vest Defer Grace Days
24	VEST_DEFER_SVC_MM	Number(3,0)	SMALLINT NOT NULL	Vest Defer Service: Months
25	VEST_DEFER_SVC_DD	Number(2,0)	SMALLINT NOT NULL	Vest Defer Service: Days
26	DAYS_DIFF	Number(4,0)	SMALLINT NOT NULL	Days Difference
27	EXER_SUSPND_BGN_DT	Date(10)	DATE	No exercises will be allowed on or after this date.
28	EXER_SUSPND_END_DT	Date(10)	DATE	Used in conjunction with Exer_Suspnd_Bgn_Dt.
29	EXPIRATN_DT	Date(10)	DATE	Expiration Date
30	IF_FLAG	Character(1)	VARCHAR2(1) NOT NULL	If flag
31	ISO_EXER_AS_NQ_DT	Date(10)	DATE	Excercises on or after this date must be treated as NQ
32	LAST_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Last EmplID
33	OK_TO_PROCESS	Character(1)	VARCHAR2(1) NOT NULL	OK To Process
34	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
35	STOCK_ACTION_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Stock Action Type L=Leave of Absence R=Return from Leave T=Termination
36	TEMPDATE	Date(10)	DATE	TempDate
37	TERM_EXPIRATN_DT	Date(10)	DATE	Expiration date of unexercised shares when emplyee terminates.
38	VEST_DT	Date(10)	DATE	Vesting Date
39	VEST_EFFDT	Date(10)	DATE	Vesting effective date.
40	VEST_REASON	Character(4)	VARCHAR2(4) NOT NULL	Vesting reason code. CORR=Correction INIT=Initial Vesting MERG=Merger/Acquisition PERF=Performance Vesting RFL=Return from Leave RPRC=Reprice TER=Termination
41	VEST_SCHED_ID	Character(10)	VARCHAR2(10) NOT NULL	The ID that identifies this vesting schedule.
42	VEST_SUSPEND_DT	Date(10)	DATE	The date vesting is suspended when an employee is on leave.
43	SHARES_VESTED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Number of shares that vest on VEST_DT.
44	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
45	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
46	UPDATE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Update Flag
47	DONE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Done Flag
48	REVERSALS	Character(1)	VARCHAR2(1) NOT NULL	All Reversals/Adjustments Y/N Table Edit
49	DELETE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Deletion Flag N=No Y=Yes
50	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
51	SHARES_REPURCHABLE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Shares Repurchasable
52	BUSPROCNAME	Character(30)	VARCHAR2(30) NOT NULL	Business Process Name (see PSBUSPROCDEFN). Prompt Table: PSBUSPROCDEFN
53	ACTIVITYNAME	Character(30)	VARCHAR2(30) NOT NULL	Name of a Business Process Activity (see PSACTIVITYDEFN). Prompt Table: ACTIVITY_PROMPT
54	EVENTNAME	Character(30)	VARCHAR2(30) NOT NULL	Defines a routing event for PS Workflow Prompt Table: PSEVENTDEFN
55	WORKLISTNAME	Character(30)	VARCHAR2(30) NOT NULL	Worklist Name Prompt Table: WORKLIST_PRMPT
56	INSTANCEID	Number(10,0)	DECIMAL(10) NOT NULL	For a given worklist the unique number of rows in PSWORKLIST
57	TRANSACTIONID	Number(10,0)	DECIMAL(10) NOT NULL	Transaction Identifier
58	PROCESS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Process Flag C=Complete V=Void X=W-2c Issued Y/N Table Edit
59	UPDATE_SW	Character(1)	VARCHAR2(1) NOT NULL	Update Switch
60	ST_LOA_TER_SW	Character(1)	VARCHAR2(1) NOT NULL	This switch is for HR Intergration to identify the special LOA/TER process.
61	MESSAGE_TEXT40	Character(40)	VARCHAR2(40) NOT NULL	Message Text
62	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.