EMPLIDEMPL_RCDACTION_DT_SSEFFSEQA=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
N=No
Y=Yes
HR_LOC_APVL_VW(SQL View) |
Index Back |
|---|---|
Location Staged Approval DataStaging data records for location change workflow |
| SELECT NEW.EMPLID , NEW.EMPL_RCD , NEW.ACTION_DT_SS , NEW.EFFSEQ , NEW.WF_STATUS , NEW.ACTION , NEW.ACTION_REASON , NEW.LOCATION , NEW.JOB_DESCR_SS , NEW.POSITION_FLAG , EMP.NAME , EMP.NAME_DISPLAY , ' ' FROM PS_HR_LOC_TRANS NEW , PS_PERSON_NAME EMP WHERE NEW.EMPLID = EMP.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | ACTION_DT_SS |
Date(10) | DATE | Termination Date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | 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 |
| 6 | ACTION | Character(3) | VARCHAR2(3) NOT NULL | Action |
| 7 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL | Reason Code |
| 8 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 9 | JOB_DESCR_SS | Character(30) | VARCHAR2(30) NOT NULL | Job Title |
| 10 | POSITION_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Position Flag
N=No Y=Yes |
| 11 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 12 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 13 | DESCR15 | Character(15) | VARCHAR2(15) NOT NULL | Short Description |