ST_RUNCTL_UNVAL(SQL Table) |
Index Back |
---|---|
Unconfirm Grant ValuationThis run control record stories the information used to process the Unconfirm Grant Valuation (ST_UNVALUE) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | STOCK_ID | Character(10) | VARCHAR2(10) NOT NULL | Company's Stock Identification Symbol |
4 | FROMDATE | Date(10) | DATE | From Date |
5 | THRUDATE | Date(10) | DATE | End Date |
6 | ST_GROUP_ID | Character(5) | VARCHAR2(5) NOT NULL |
Option Group ID - group of stock options
Prompt Table: ST_GROUP_TBL |
7 | DONE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Done Flag |
8 | GRANT_NBR_FROM | Character(10) | VARCHAR2(10) NOT NULL | System assigned grant number used to uniquely identify the grant record. |
9 | GRANT_NBR_TO | Character(10) | VARCHAR2(10) NOT NULL | System assigned grant number used to uniquely identify the grant record. |