HR_MGR_LOCH_VW2(SQL View) |
Index Back |
---|---|
WF SS Transaction ViewRecord 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 |