HR_MGR_LOCH_VW2

(SQL View)
Index Back

WF SS Transaction View

Record used by inquiry page to select data about a particular Locaiton Change transaction

SELECT DISTINCT B.EMPLID , B.ACTION_DT_SS , B.EMPL_RCD , B.EFFSEQ ,A.NAME ,F.name , B.ACTION , B.ACTION_REASON , WF.ACTION_DESCR ,E.LOCATION , E.DESCR ,B.WF_STATUS , C.EOAWSTEP_STATUS , B.LOCATION ,L.DESCR FROM PS_HR_LOC_TRANS B , PS_PERSON_NAME A ,PS_PERSON_NAME F , PS_LOCATION_TBL L , PS_HR_MGR_LOC_STA STA , PS_ACTION_TBL_VW WF , PS_EMP_LOC_SETID E , PS_EOAW_STEPINST C , PS_HR_MGR_LOC_XREF D WHERE A.EMPLID=B.EMPLID AND F.EMPLID=STA.EMPLID_To AND L.LOCATION=B.LOCATION AND STA.EMPLID=B.EMPLID AND B.EMPL_RCD=STA.EMPL_RCD AND B.ACTION_DT_SS = STA.ACTION_DT_SS AND B.EFFSEQ = STA.EFFSEQ AND STA.SEQNO=1 AND WF.ACTION = B.ACTION AND E.EMPLID=B.EMPLID AND D.EMPLID = B.EMPLID AND D.EMPL_RCD = B.EMPL_RCD AND D.ACTION_DT_SS = B.ACTION_DT_SS AND D.EFFSEQ= B.EFFSEQ AND D.EOAWPRCS_ID = C.EOAWPRCS_ID AND D.EOAWDEFN_ID = C.EOAWDEFN_ID AND D.EOAWTHREAD_ID = C.EOAWTHREAD_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 ACTION_DT_SS Date(10) DATE Termination Date
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 NAME Character(50) VARCHAR2(50) NOT NULL Name
6 MANAGER_NAME Character(30) VARCHAR2(30) NOT NULL Manager Name
7 ACTION Character(3) VARCHAR2(3) NOT NULL Action

Prompt Table: ACTION_TBL

8 ACTION_REASON_SS Character(3) VARCHAR2(3) NOT NULL Action Reason field for use on Self Service panels.
9 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
10 LOCATION2 Character(10) VARCHAR2(10) NOT NULL Location 2
11 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
12 WF_STATUS Character(1) VARCHAR2(1) NOT NULL Workflow Status
A=Approved
C=Cancelled
D=Denied
E=Error. Contact Administrator.
F=Awaiting final approval
I=In Approval Process
M=Administrator is Processing
N=Not Available
P=Rework
S=Submitted
V=Data Saved
13 EOAWSTEP_STATUS Character(1) VARCHAR2(1) NOT NULL Step Instance Status
A=Approved
B=Pushed back
C=Auto Approved
D=Denied
E=Administrator denied
F=Deleted
G=Bypassed
H=On Hold
I=No Action Taken
K=Skipped
L=Terminated
M=Administrator approved
N=Not Active
P=Pending
R=No longer in role
T=Terminated
U=Auto approved
X=Deleted
Z=Pending Denial
14 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
15 DESCR Character(30) VARCHAR2(30) NOT NULL Description