ST_REPRC_TBL(SQL Table) |
Index Back |
---|---|
Stock RepriceThe Stock Reprice record defines business rules for a stock option repricing process. The Stock Reprice record is a child record of STOCK_TBL. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | STOCK_ID | Character(10) | VARCHAR2(10) NOT NULL |
Company's Stock Identification Symbol
Prompt Table: STOCK_TBL |
2 | REPRICE_ID | Character(10) | VARCHAR2(10) NOT NULL | Stock Reprice ID |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: ST_REPRC_TBL.DESCR |
5 | RECORD_DT | Date(10) | DATE NOT NULL |
Record Date
Default Value: %date |
6 | BREAK_PRICE | Number(16,6) | DECIMAL(15,6) NOT NULL | Reprice Break Price |
7 | GRANT_DT | Date(10) | DATE NOT NULL | Grant Date |
8 | GRANT_REASON | Character(4) | VARCHAR2(4) NOT NULL |
Grant Reason
Prompt Table: ST_GRNT_RSN_TBL |
9 | AGREEMENT_ID | Character(10) | VARCHAR2(10) NOT NULL |
Agreement ID
Prompt Table: ST_AGREEMENT_VW |
10 | COMPANY_INSIDER | Character(1) | VARCHAR2(1) NOT NULL |
Company Insider
Y/N Table Edit Default Value: N |
11 | REPORTING_PERSON | Character(1) | VARCHAR2(1) NOT NULL |
Reporting Person
Y/N Table Edit Default Value: N |
12 | ST_DIRECTOR | Character(1) | VARCHAR2(1) NOT NULL |
Section 16 Director
Y/N Table Edit Default Value: N |
13 | ST_OFFICER | Character(1) | VARCHAR2(1) NOT NULL |
Section 16 Officer
Y/N Table Edit Default Value: N |
14 | ST_BEN_OWNER | Character(1) | VARCHAR2(1) NOT NULL |
Section 16 Beneficial Owner
Y/N Table Edit Default Value: N |
15 | REPRICE_PLAN_RULE | Character(1) | VARCHAR2(1) NOT NULL |
Stock Plan Rule
K=Keep Original Stock Plan N=Apply New Stock Plan Default Value: K |
16 | STOCK_PLAN | Character(10) | VARCHAR2(10) NOT NULL |
Stock Plan
Prompt Table: ST_OPT_PLAN_VW |
17 | REPRICE_VEST_RULE | Character(1) | VARCHAR2(1) NOT NULL |
Vesting Schedule Rule
D=Defer Original Vesting K=Keep Original Vesting N=New Vesting Default Value: K |
18 | VEST_SCHED_ID | Character(10) | VARCHAR2(10) NOT NULL |
The ID that identifies this vesting schedule.
Prompt Table: ST_VEST_SCHED |
19 | EXERCISE_HOLD_DT | Date(10) | DATE | Exercise Hold Date |
20 | VEST_DEFER_MM | Number(3,0) | SMALLINT NOT NULL | Vesting Deferral: Months |
21 | VEST_DEFER_DD | Number(2,0) | SMALLINT NOT NULL | Vesting Deferral Period Days |
22 | EXPIRE_BASIS_CD | Character(1) | VARCHAR2(1) NOT NULL |
This field indicates which date is used as the base to calculate the length of time before an option expires.
G=Grant Date H=Grant Date + 1 V=Vest Date W=Vest Date + 1 |
23 | OPTION_LIFE_MM | Number(4,0) | SMALLINT NOT NULL | This field indicates the life of the option in numbers of months. |
24 | REPRICE_EXER_RULE | Character(1) | VARCHAR2(1) NOT NULL |
Exercise Before Vest Rule
K=Keep Original O=Override Default Value: K |
25 | 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 Default Value: N |
26 | REPRICE_XFER_RULE | Character(1) | VARCHAR2(1) NOT NULL |
Transferable Options Rule
K=Keep Original O=Override Default Value: K |
27 | TRANSFER_ALLOW | Character(1) | VARCHAR2(1) NOT NULL |
Transferable Options
N=No Y=Yes Y/N Table Edit Default Value: N |
28 | ST_OPTN_CNV_NQ | Character(4) | VARCHAR2(4) NOT NULL |
Stock Option Conversion - NQ
ISAR=Incentive Stock Option SAR ISO=Incentive Stock Option NQ=Non-Qualified Stock Option NSAR=Non-Qualified SAR Default Value: NQ |
29 | ST_OPTN_CNV_ISO | Character(4) | VARCHAR2(4) NOT NULL |
Stock Option Conversion - ISO
ISAR=Incentive Stock Option SAR ISO=Incentive Stock Option NQ=Non-Qualified Stock Option NSAR=Non-Qualified SAR Default Value: ISO |
30 | ST_OPTN_CNV_NSAR | Character(4) | VARCHAR2(4) NOT NULL |
Stock Option Conversion - NSAR
ISAR=Incentive Stock Option SAR ISO=Incentive Stock Option NQ=Non-Qualified Stock Option NSAR=Non-Qualified SAR Default Value: NSAR |
31 | ST_OPTN_CNV_ISAR | Character(4) | VARCHAR2(4) NOT NULL |
Stock Option Conversion - ISAR
ISAR=Incentive Stock Option SAR ISO=Incentive Stock Option NQ=Non-Qualified Stock Option NSAR=Non-Qualified SAR Default Value: ISAR |
32 | REPRICE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Reprice Eligibility Status
P=Processed U=Unprocessed Default Value: U |
33 | STATUS_DT | Date(10) | DATE |
Status Date
Default Value: %date |