EFFDTDefault Value: %date
A=Active
D=Deceased
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
TL_AUTO_JB_VW(SQL View) |
Index Back |
|---|---|
TL_AUTO_JB_VWMax effective sequence job view |
| SELECT A.EMPLID , A.EMPL_RCD ,A.EFFDT ,A.EFFSEQ ,A.EMPL_STATUS FROM PS_JOB A WHERE A.EFFSEQ =( SELECT MAX(B.EFFSEQ) FROM PS_JOB B WHERE B.EMPLID= A.EMPLID AND B.EMPL_RCD= A.EMPL_RCD AND B.EFFDT = A.EFFDT) |
| # | 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 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | EMPL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payroll Status
A=Active D=Deceased 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 |