EMPLIDA=Active
D=Deceased
I=Inactive
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration
GM_PPLNR_VW(SQL View) |
Index Back |
|---|
| SELECT A.EMPLID , A.NAME , A.LAST_NAME_SRCH , A.LAST_NAME , C.EMPL_RCD , C.JOBCODE , C.EMPL_STATUS FROM PS_PERSONAL_DATA A , PS_JOB C WHERE A.EMPLID = C.EMPLID AND C.EMPL_STATUS = 'A' AND C.EMPL_RCD = ( SELECT MIN (C3.EMPL_RCD) FROM PS_JOB C3 WHERE C3.EMPLID = C.EMPLID AND C3.EFFDT = ( SELECT MAX(C31.EFFDT) FROM PS_JOB C31 WHERE C31.EMPLID = C3.EMPLID AND C31.EMPL_RCD = C3.EMPL_RCD AND C31.EFFDT <= %CurrentDateIn) AND C3.EFFSEQ = ( SELECT MAX(C32.EFFSEQ) FROM PS_JOB C32 WHERE C32.EMPLID = C3.EMPLID AND C32.EMPL_RCD = C3.EMPL_RCD AND C32.EFFDT = C3.EFFDT)) AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_JOB C1 WHERE C1.EMPLID = C.EMPLID AND C1.EMPL_RCD = C.EMPL_RCD AND C1.EFFDT <= %CurrentDateIn) AND C.EFFSEQ = ( SELECT MAX(C2.EFFSEQ) FROM PS_JOB C2 WHERE C2.EMPLID = C.EMPLID AND C2.EMPL_RCD = C.EMPL_RCD AND C2.EFFDT = C.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 3 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 4 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 5 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 6 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 7 | EMPL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Employee Status
A=Active D=Deceased I=Inactive L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration |