ST_DISPOSN_SRCH

(SQL View)
 Index Back

Stock Purch Disposition Search

This view will only retrieve records from Stock Purchases that have been confirmed.

SELECT A.EMPLID ,A.STOCK_ID ,A.STOCK_PLAN_TYPE ,A.STOCK_PLAN ,A.OFFERING_ID ,A.PERIOD_END_DT ,A.PROCESS_GROUP ,B.NAME ,A.GRANT_DT ,A.SHARES_PURCHASED FROM PS_ST_ESPP_PURCH A , PS_PERSON_NAME B WHERE A.EMPLID = B.EMPLID AND A.CONFIRMED = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERS_SRCH_GBL

2 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Stock ID

Prompt Table: STOCK_TBL

3 STOCK_PLAN_TYPE Character(1) VARCHAR2(1) NOT NULL Stock Plan Type
E=Purchase Plan
O=Option Plan
4 STOCK_PLAN Character(10) VARCHAR2(10) NOT NULL Stock Plan

Prompt Table: STOCK_PLAN_TBL

5 OFFERING_ID Character(10) VARCHAR2(10) NOT NULL Offering ID
6 PERIOD_END_DT Date(10) DATE Period End Date
7 PROCESS_GROUP Character(10) VARCHAR2(10) NOT NULL Process Group
8 NAME Character(50) VARCHAR2(50) NOT NULL Name
9 GRANT_DT Date(10) DATE Grant Date
10 SHARES_PURCHASED Signed Number(20,6) DECIMAL(18,6) NOT NULL Shares Purchased