ST_PE_OPTN_PREF(SQL Table) |
Index Back |
|---|
| # | 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 | STOCK_ID | Character(10) | VARCHAR2(10) NOT NULL |
Stock ID
Prompt Table: ST_PE_OPTN_VW |
| 3 | ST_PE_MAX_ROWS | Character(1) | VARCHAR2(1) NOT NULL |
Max Number of Displayed Rows
1=One 2=Two 3=Three 4=Four 5=Five A=All Default Value: 5 |
| 4 | ST_PE_SORT_BY | Character(1) | VARCHAR2(1) NOT NULL |
Sort By
D=Grant Date G=Grant Number O=Option Type P=Grant Price Default Value: G |
| 5 | ST_SHOW_GRANT_NBR | Character(1) | VARCHAR2(1) NOT NULL |
Grant Number
Y/N Table Edit Default Value: Y |
| 6 | ST_SHOW_GRANT_DT | Character(1) | VARCHAR2(1) NOT NULL |
Grant Date
Y/N Table Edit Default Value: Y |
| 7 | ST_SHOW_OPTN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Option Type
Y/N Table Edit Default Value: Y |
| 8 | ST_SHOW_GRANT_PRC | Character(1) | VARCHAR2(1) NOT NULL |
Grant Price
Y/N Table Edit Default Value: Y |
| 9 | ST_SHOW_GRANTED | Character(1) | VARCHAR2(1) NOT NULL |
Shares Granted
Y/N Table Edit Default Value: N |
| 10 | ST_SHOW_EXERCISE | Character(1) | VARCHAR2(1) NOT NULL |
Shares Exercisable
Y/N Table Edit Default Value: N |
| 11 | ST_SHOW_LAST_VEST | Character(1) | VARCHAR2(1) NOT NULL |
Last Vesting Date
Y/N Table Edit Default Value: N |