ST_GRANT_RET_VW

(SQL View)
 Index Back

Stock Grants Retirement View

Optionee Grants Retirement Eligible view used to process the eligibility.

SELECT A.EMPLID , A.STOCK_ID , A.GRANT_NBR , A.GRANT_DT , A.STOCK_PLAN , A.EMPL_RCD , A.RET_ELIG , A.RET_ELIG_DT , A.FORECAST_RET_ELIG FROM PS_ST_GRANT A WHERE A.GRANT_STATUS = 'A' AND A.RET_ELIG <> 'Y' AND A.ST_CANCEL_DT IS NULL AND %CurrentDateIn <( SELECT MAX(Z.EXPIRATN_DT) FROM PS_ST_GRNT_VST_DTL Z WHERE Z.EMPLID = A.EMPLID AND Z.STOCK_ID = A.STOCK_ID AND Z.GRANT_NBR = A.GRANT_NBR AND Z.VEST_EFFDT = ( SELECT MAX(ZZ.VEST_EFFDT) FROM PS_ST_GRNT_VST_DTL ZZ WHERE ZZ.EMPLID = Z.EMPLID AND ZZ.STOCK_ID = Z.STOCK_ID AND ZZ.GRANT_NBR = Z.GRANT_NBR) AND Z.SEQ_NUM = ( SELECT MAX(ZZZ.SEQ_NUM) FROM PS_ST_GRNT_VST_DTL ZZZ WHERE ZZZ.EMPLID = Z.EMPLID AND ZZZ.STOCK_ID = Z.STOCK_ID AND ZZZ.GRANT_NBR = Z.GRANT_NBR AND ZZZ.VEST_EFFDT = Z.VEST_EFFDT))

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

Prompt Table: PERS_SRCH_ST_GT

2 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Company's Stock Identification Symbol

Prompt Table: STOCK_TBL

3 GRANT_NBR Character(10) VARCHAR2(10) NOT NULL System assigned grant number used to uniquely identify the grant record.
4 GRANT_DT Date(10) DATE NOT NULL Grant Date
5 STOCK_PLAN Character(10) VARCHAR2(10) NOT NULL Stock Plan

Prompt Table: ST_OPT_PLAN_VW

6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
7 RET_ELIG Character(1) VARCHAR2(1) NOT NULL Retirement Eligible
8 RET_ELIG_DT Date(10) DATE Retire Eligible Dt
9 FORECAST_RET_ELIG Character(1) VARCHAR2(1) NOT NULL Forecast Retirement Eligible