HRS_JOB_I2

(SQL View)
 Index Back

EE Job History - Interface

EE Job History - Interface

SELECT EMPLID ,EMPL_RCD ,EFFDT ,EFFSEQ ,DEPTID ,JOBCODE ,POSITION_NBR ,ACTION ,ACTION_REASON ,BAS_GROUP_ID ,BEN_STATUS ,BUSINESS_UNIT ,COMPANY ,EMPL_STATUS ,EMPL_CLASS ,EMPL_TYPE ,FTE ,FULL_PART_TIME ,GRADE ,SAL_ADMIN_PLAN ,LOCATION ,SETID_JOBCODE ,SETID_DEPT ,SUPERVISOR_ID ,REG_TEMP ,PAYGROUP ,REG_REGION ,STD_HOURS ,JOB_INDICATOR ,SETID_LOCATION ,SETID_SALARY FROM PS_JOB

  • 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

    Default Value: PER_ORG_ASGN.EMPLID

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    5 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    6 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    7 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
    8 ACTION Character(3) VARCHAR2(3) NOT NULL Action
    9 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
    10 BAS_GROUP_ID Character(3) VARCHAR2(3) NOT NULL Identifies a user-defined Benefits Administration group used to facilitate benefits processing. A group can represent the entire participant population of the enterprise, or a specific group of participants. It enables you to control processing by, for example, setting up separate Open Enrollment schedules for each group. If used, a BAS Group ID is assigned to each participant in a benefit program.
    11 BEN_STATUS Character(4) VARCHAR2(4) NOT NULL Specifies an employee's status relative to benefits, and is used to determine eligibility for benefits. Some examples of benefit status are Active, Suspended, Leave with Benefits, and Terminated.
    A=Active
    D=Deceased
    L=Leave of Absence
    P=Leave With Benefits
    Q=Retired With Benefits
    R=Retired
    S=Suspended
    T=Terminated
    U=Terminated With Benefits
    12 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT

    13 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    14 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
    15 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification
    16 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
    E=Exception Hourly
    H=Hourly
    N=Not Applicable
    S=Salaried
    17 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence
    18 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
    D=On Demand
    F=Full-Time
    P=Part-Time

    Default Value: F

    19 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
    20 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
    21 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    22 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
    23 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
    24 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID
    25 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
    R=Regular
    T=Temporary

    Default Value: R

    26 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
    27 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Default Value: OPR_DEF_TBL_HR.REG_REGION

    28 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
    29 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

    Default Value: P

    30 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID
    31 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary Set ID