EMPLIDEMPL_RCDDefault Value: %date
A=Active
I=Inactive
JPM_CUR_JOB_VW(SQL View) |
Index Back |
|---|---|
Current JobReturns Keys and HR Status of current JOB row. |
| SELECT J.EMPLID , J.EMPL_RCD , J.EFFDT , J.EFFSEQ , J.HR_STATUS FROM PS_JOB J WHERE J.EFFDT = ( SELECT MAX(EFFDT) FROM PS_JOB J1 WHERE J1.EMPLID=J.EMPLID AND J1.EMPL_RCD=J.EMPL_RCD AND EFFDT <= %CurrentDateIn ) AND J.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_JOB J1 WHERE J1.EMPLID=J.EMPLID AND J1.EMPL_RCD=J.EMPL_RCD AND J1.EFFDT=J.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 | HR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
HR Status
A=Active I=Inactive |