STOCK_IDSTOCK_PLAN_TYPEE=Purchase Plan
O=Option Plan
Default Value: E
STOCK_PLANOFFERING_IDPERIOD_END_DTGRANT_DTST_VAL_PUR_VW1(SQL View) |
Index Back |
|---|---|
Offering Valuation Purch View1This view is used in the FAS 123 valuation process when valuing stock offerings. |
| SELECT A.STOCK_ID , A.STOCK_PLAN_TYPE , A.STOCK_PLAN , A.OFFERING_ID , B.PERIOD_END_DT , A.GRANT_DT FROM PS_ST_OFFER_GRANT A , PS_ST_PURCHASE_PD B WHERE A.STOCK_ID = B.STOCK_ID AND A.STOCK_PLAN_TYPE = B.STOCK_PLAN_TYPE AND A.STOCK_PLAN = B.STOCK_PLAN AND A.OFFERING_ID = B.OFFERING_ID AND A.GRANT_DT <= PERIOD_END_DT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STOCK_ID |
Character(10) | VARCHAR2(10) NOT NULL | Stock ID |
| 2 | STOCK_PLAN_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Stock Plan Type
E=Purchase Plan O=Option Plan Default Value: E |
| 3 | STOCK_PLAN |
Character(10) | VARCHAR2(10) NOT NULL | Stock Plan |
| 4 | OFFERING_ID |
Character(10) | VARCHAR2(10) NOT NULL | Offering ID |
| 5 | PERIOD_END_DT |
Date(10) | DATE | Period End Date |
| 6 | GRANT_DT |
Date(10) | DATE | Grant Date |