ST_VAL_PUR_VW1 (SQL View)	Index Back
Offering Valuation Purch View1 This view is used in the FAS 123 valuation process when valuing stock offerings.

ST_VAL_PUR_VW1

(SQL View)

Offering Valuation Purch View1

This 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 Company's Stock Identification Symbol

2 STOCK_PLAN_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Stock Plan
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

#	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	STOCK_PLAN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type of Stock Plan 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