STOCK_IDST_VALUATION_IDST_VALUE_VW(SQL View) |
Index Back |
|---|---|
Valuation ViewView of all valuation ids that are confirmed. |
| SELECT DISTINCT A.STOCK_ID , A.ST_VALUATION_ID , A.ST_VALUE_DESCR FROM PS_ST_VALUE_TBL A , PS_ST_GRANT_VALUE B WHERE A.STOCK_ID = B.STOCK_ID AND A.ST_VALUATION_ID = B.ST_VALUATION_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STOCK_ID |
Character(10) | VARCHAR2(10) NOT NULL | Company's Stock Identification Symbol |
| 2 | ST_VALUATION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Valuation ID |
| 3 | ST_VALUE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |