ST_ACTN_RULE

(SQL Table)
Index Back

Stock Action Rules Record

Setup Record for Stock Action Rules which maps the HR Action Reason to the Stock Reason and establishes Processing Rules.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Company's Stock Identification Symbol
2 STOCK_PLAN_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Stock Plan
E=Purchase Plan
O=Option Plan

Default Value: O

3 STOCK_PLAN Character(10) VARCHAR2(10) NOT NULL Stock Plan
4 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

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

Prompt Table: STOCK_ACTN_TBL

6 VEST_IMMEDIATE Character(1) VARCHAR2(1) NOT NULL Vest Immediate

Y/N Table Edit

Default Value: N

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

Default Value: 0

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

Default Value: 0

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

Default Value: N

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

Default Value: N

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

Default Value: 0

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

Default Value: 0

13 VEST_SUSPEND Character(1) VARCHAR2(1) NOT NULL Suspend Vesting

Y/N Table Edit

Default Value: N

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

Default Value: 0

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

Default Value: 0

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

Default Value: 0

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

Default Value: 0