HR_PSEL_CURJOBV

(SQL View)
 Index Back

Current Job for EMPs -

Lists the current active job for the employee

SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.EFFSEQ , A.PER_ORG , A.DEPTID , A.JOBCODE , A.POSITION_NBR , A.EMPL_STATUS , A.HR_STATUS , A.ACTION , A.ACTION_DT , A.ACTION_REASON , A.LOCATION , A.COMPANY , A.EMPL_TYPE , A.SETID_DEPT , A.SETID_JOBCODE , A.SETID_LOCATION , A.SETID_SALARY , A.REG_REGION , A.JOB_INDICATOR , A.CONTRACT_NUM , A.SUPV_LVL_ID , A.SETID_SUPV_LVL FROM PS_JOB A WHERE A.EffSeq = ( SELECT MAX(D.EffSeq) FROM PS_JOB D WHERE D.EmplID = A.EmplID AND D.EMPL_RCD = A.EMPL_RCD AND D.EffDt = A.EffDt) AND HR_STATUS = 'A'

  • Parent record: PER_ORG_ASGN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 EFFDT Date(10) DATE NOT NULL Effective Date
    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    5 PER_ORG Character(3) VARCHAR2(3) NOT NULL Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
    CWR=Contingent Worker
    EMP=Employee
    POI=Person of Interest
    6 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

    7 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: JOBCODE_TBL

    8 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
    9 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
    10 HR_STATUS Character(1) VARCHAR2(1) NOT NULL HR Status
    A=Active
    I=Inactive
    11 ACTION Character(3) VARCHAR2(3) NOT NULL Action

    Prompt Table: ACTION_TBL

    12 ACTION_DT Date(10) DATE Action Date
    13 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

    Prompt Table: ACTN_REASON_TBL

    14 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_TBL

    15 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    16 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
    E=Exception Hourly
    H=Hourly
    N=Not Applicable
    S=Salaried

    Prompt Table: PAYGRP_EMPLTYPE

    17 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
    18 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
    19 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID
    20 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary Set ID
    21 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
    22 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
    23 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
    24 SUPV_LVL_ID Character(8) VARCHAR2(8) NOT NULL Supervisor Level ID for use in capability grade system
    25 SETID_SUPV_LVL Character(5) VARCHAR2(5) NOT NULL Stored setid for the Supervisor Level.