EMPLIDPrompt Table: PERSON_NAME
EMPL_RCDEFFDTEFFSEQN=Not Applicable
P=Primary Job
S=Secondary Job
HR_OBD_JOBS_VW(SQL View) |
Index Back |
|---|---|
OnBoarding Active JobsReturns all active jobs with an OnBoarding trigger |
| SELECT J.EMPLID , J.EMPL_RCD , J.EFFDT , J.EFFSEQ , J.JOB_INDICATOR , J.SETID_JOBCODE , J.JOBCODE , J.LAST_HIRE_DT , T.AGC_LIST_ID FROM PS_JOB J , PS_HR_OBD_TRIGGER T WHERE T.EMPLID = J.EMPLID AND T.EMPL_RCD = J.EMPL_RCD AND J.HR_STATUS = 'A' AND J.EFFDT = ( SELECT MAX (J1.EFFDT) FROM PS_JOB J1 WHERE J1.EMPLID = J.EMPLID AND J1.EMPL_RCD = J.EMPL_RCD AND J1.ACTION IN ('HIR','ADL','REH','ADD','RNW') ) AND J.EFFSEQ = ( SELECT MAX(J2.EFFSEQ) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT = J.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON_NAME |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | JOB_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee.
In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned.
N=Not Applicable P=Primary Job S=Secondary Job |
| 6 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL | Job Code Set ID |
| 7 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 8 | LAST_HIRE_DT | Date(10) | DATE | Latest Start Date - The latest time that an Employee or a Contingent Worker has started - based on EMPLID/EMPL_RCD. |
| 9 | AGC_LIST_ID | Character(31) | VARCHAR2(31) NOT NULL | Activity Guide Composer List Id |