ST_ACTN_PRC_SRC

(SQL View)
 Index Back

Stock Action Work List Search

This search view lists individuals that have had a Stock Action determined for them and subsequently recorded in the Work List table for Stock Action.

SELECT A.EMPLID ,A.EMPL_RCD , A.STOCK_ACTION_DT , A.SEQ_NUM , B.STOCK_ACTION , A.NAME , A.ACTION , A.ACTION_REASON , C.STOCK_ACTION_TYPE FROM PS_ST_ACTN_PRC_WL A , PS_ST_ACTN_RSN_TBL B , PS_STOCK_ACTN_TBL C WHERE A.ACTION = B.ACTION AND A.ACTION_REASON = B.ACTION_REASON AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ST_ACTN_RSN_TBL WHERE ACTION = B.ACTION AND ACTION_REASON = B.ACTION_REASON AND EFFDT <= A.STOCK_ACTION_DT) AND C.STOCK_ACTION = B.STOCK_ACTION AND C.EFFDT = ( SELECT MAX(EFFDT) FROM PS_STOCK_ACTN_TBL WHERE STOCK_ACTION = C.STOCK_ACTION AND EFFDT <= A.STOCK_ACTION_DT)

# 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 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 STOCK_ACTION_DT Date(10) DATE Date the stock action is effective.
4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
5 STOCK_ACTION Character(3) VARCHAR2(3) NOT NULL Stock Action
6 NAME Character(50) VARCHAR2(50) NOT NULL Name
7 ACTION Character(3) VARCHAR2(3) NOT NULL Action

Prompt Table: ACTION_TBL

8 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
9 STOCK_ACTION_TYPE Character(1) VARCHAR2(1) NOT NULL Stock Action Type
L=Leave of Absence
R=Return from Leave
T=Termination