ST_REPRC_TAO(SQL Table) |
Index Back |
|---|---|
Defines the stock grants.Used to define the grants within the stock admin system. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | REPRICE_GRANT_NBR |
Character(10) | VARCHAR2(10) NOT NULL | Number of the replacing grant due to reprice. |
| 3 | GRANT_NBR | Character(10) | VARCHAR2(10) NOT NULL | System assigned grant number used to uniquely identify the grant record. |
| 4 | STOCK_PLAN | Character(10) | VARCHAR2(10) NOT NULL |
Stock Plan
Prompt Table: ST_OPT_PLAN_VW2 |
| 5 | VC_PLAN_ID | Character(10) | VARCHAR2(10) NOT NULL | VC Plan ID |
| 6 | VC_PAYOUT_PRD_ID | Character(10) | VARCHAR2(10) NOT NULL | Payout Period ID |
| 7 | GB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |
| 8 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 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 | SHARES_GRANTED | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Number of shares granted. |
| 11 | GRANT_PRICE | Number(19,6) | DECIMAL(18,6) NOT NULL | Price an employee pays to exercise the option. |
| 12 | GRANT_REASON | Character(4) | VARCHAR2(4) NOT NULL |
Grant Reason
Prompt Table: ST_GRNT_RSN_TBL |
| 13 | EXER_BFR_VEST | Character(1) | VARCHAR2(1) NOT NULL |
This field indicates that exercise is allowed before vesting. Typically used with RSA's.
N=No Y=Yes Y/N Table Edit |
| 14 | TRANSFER_ALLOW | Character(1) | VARCHAR2(1) NOT NULL |
Transferable Options
N=No Y=Yes Y/N Table Edit |
| 15 | AGREEMENT_ID | Character(10) | VARCHAR2(10) NOT NULL |
Agreement ID
Prompt Table: STOCK_AGREEMENT |
| 16 | ISO_LIM_GRANT_NBR | Character(10) | VARCHAR2(10) NOT NULL | Number of grant which is created due to an over limit ISO condition. |
| 17 | STOCK_ACTION | Character(3) | VARCHAR2(3) NOT NULL | Stock Action |
| 18 | EXERCISE_HOLD_DT | Date(10) | DATE | Exercise Hold Date |
| 19 | ISO_EXER_AS_NQ_DT | Date(10) | DATE | Excercises on or after this date must be treated as NQ |
| 20 | ST_CANCEL_DT | Date(10) | DATE | Cancellation Date |
| 21 | RET_ELIG | Character(1) | VARCHAR2(1) NOT NULL | Retirement Eligible |
| 22 | RET_ELIG_DT | Date(10) | DATE | Retire Eligible Dt |
| 23 | FORECAST_RET_ELIG | Character(1) | VARCHAR2(1) NOT NULL | Forecast Retirement Eligible |