PROCESS_INSTANCEA=Annually
M=Monthly
Q=Quarterly
S=Semi-Annual
V=Vesting Date
ST_VEST_DFN_AET(SQL Table) |
Index Back |
|---|---|
Vest Definition State RecordST_VEST_DFN_AET is a state record for the Vest AE Process. It is used to store the current vesting definition. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 3 | VEST_MONTHS | Number(3,0) | SMALLINT NOT NULL | The number of months in one vesting period. |
| 4 | VEST_PERCENT | Number(7,3) | DECIMAL(6,3) NOT NULL | This field is used to contain the number which represents a percentage of the total stock to vest. |
| 5 | VEST_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Vesting Frequency
A=Annually M=Monthly Q=Quarterly S=Semi-Annual V=Vesting Date |
| 6 | ST_VEST_PERIOD_CNT | Number(2,0) | SMALLINT NOT NULL | Period Count |
| 7 | VEST_INTERVAL | Number(3,0) | SMALLINT NOT NULL | Intervals in Each Period |
| 8 | MONTH_FACTOR | Number(3,0) | SMALLINT NOT NULL | Period length in Months |