ST_ACTN_RULE(SQL Table) |
Index Back |
---|---|
Stock Action Rules RecordSetup 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 |