STOCK_IDPrompt Table: STOCK_TBL
REPRICE_IDPrompt Table: ST_REPRC_TBL
EMPLIDPrompt Table: PERSON
EMPL_RCDGRANT_NBRY/N Table Edit
E=Eligible
F=Finalized - Repriced Grant
N=Notified - Elect Form Process
ST_REPRC_PARTIC(SQL Table) |
Index Back |
|---|---|
Stock Reprice Eligibility |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STOCK_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Stock ID
Prompt Table: STOCK_TBL |
| 2 | REPRICE_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Stock Reprice ID
Prompt Table: ST_REPRC_TBL |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 5 | GRANT_NBR |
Character(10) | VARCHAR2(10) NOT NULL | System assigned grant number used to uniquely identify the grant record. |
| 6 | REPRICE_ELECT | Character(1) | VARCHAR2(1) NOT NULL |
Reprice Election
Y/N Table Edit |
| 7 | REPRC_PART_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Reprice Participation Status
E=Eligible F=Finalized - Repriced Grant N=Notified - Elect Form Process |
| 8 | STATUS_DT | Date(10) | DATE | Status Date |