TL_JOB_VW

(SQL View)
 Index Back

TL EE Job History View

JOB is one of the core records in the database. Use it to record an employee's job history data such as actions taken, department, job code, location, and salary history. You can create multiple JOB records for an employee.

SELECT A.EMPLID ,A.EMPL_RCD ,A.EFFDT ,A.EFFSEQ ,A.DEPTID ,A.JOBCODE ,A.POSITION_NBR ,A.POSITION_OVERRIDE ,A.POSN_CHANGE_RECORD ,A.EMPL_STATUS ,A.ACTION ,A.ACTION_DT ,A.ACTION_REASON ,A.LOCATION ,A.JOB_ENTRY_DT ,A.DEPT_ENTRY_DT ,A.POSITION_ENTRY_DT ,A.SHIFT ,A.REG_TEMP ,A.FULL_PART_TIME ,A.FLSA_STATUS ,A.OFFICER_CD ,A.COMPANY ,A.PAYGROUP ,A.BAS_GROUP_ID ,A.ELIG_CONFIG1 ,A.ELIG_CONFIG2 ,A.ELIG_CONFIG3 ,A.EMPL_TYPE ,A.HOLIDAY_SCHEDULE ,A.STD_HOURS ,A.EEO_CLASS ,A.EMPL_CLASS ,A.SAL_ADMIN_PLAN ,A.GRADE ,A.GRADE_ENTRY_DT ,A.STEP ,A.STEP_ENTRY_DT ,A.GL_PAY_TYPE ,A.ACCT_CD ,A.EARNS_DIST_TYPE ,A.COMP_FREQUENCY ,A.COMPRATE ,A.CHANGE_AMT ,A.CHANGE_PCT ,A.ANNUAL_RT ,A.MONTHLY_RT ,A.HOURLY_RT ,A.ANNL_BENEF_BASE_RT ,A.SHIFT_RT ,A.SHIFT_FACTOR ,A.CURRENCY_CD ,A.SETID_JOBCODE FROM PS_JOB A

  • Parent record: PER_ORG_ASGN_VW

    • # 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 DUR Date(10) DATE Date Under Report associates time being reported, scheduled or paid, to a specific date.
    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    5 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

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

    Prompt Table: JOBCODE_TBL

    7 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: POSITION_DATA

    8 POSITION_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Override Position Data

    Y/N Table Edit

    9 POSN_CHANGE_RECORD Character(1) VARCHAR2(1) NOT NULL Position Management Record

    Y/N Table Edit

    10 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
    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 JOB_ENTRY_DT Date(10) DATE Job Entry Date
    16 DEPT_ENTRY_DT Date(10) DATE Department Entry Date
    17 POSITION_ENTRY_DT Date(10) DATE Position Entry Date
    18 SHIFT Character(1) VARCHAR2(1) NOT NULL Regular Shift
    1=Day
    2=Evening
    3=Night
    A=Any
    C=Compressed
    N=Not Applicable
    R=Rotating
    19 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
    R=Regular
    T=Temporary
    20 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
    D=On Demand
    F=Full-Time
    P=Part-Time
    21 FLSA_STATUS Character(1) VARCHAR2(1) NOT NULL FLSA Status
    A=Administrative
    C=Computer Employee
    E=Executive
    H=Highly Compensated Employees
    M=Management
    N=Nonexempt
    O=Outside Salesperson
    P=Professional
    V=Nonexempt Alt Overtime
    X=No FLSA Required
    22 OFFICER_CD Character(1) VARCHAR2(1) NOT NULL Officer Code
    C=Chairman
    D=Director
    N=None
    O=Officer
    P=President
    S=Secretary
    T=Treasurer
    V=Vice President
    23 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    24 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

    Prompt Table: PAYGROUP_TBL

    25 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.

    Prompt Table: BAS_GROUP_TBL

    26 ELIG_CONFIG1 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
    27 ELIG_CONFIG2 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
    28 ELIG_CONFIG3 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
    29 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
    E=Exception Hourly
    H=Hourly
    N=Not Applicable
    S=Salaried

    Prompt Table: PAYGRP_EMPLTYPE

    30 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL Holiday Schedule

    Prompt Table: HOLIDAY_TBL

    31 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
    32 EEO_CLASS Character(1) VARCHAR2(1) NOT NULL EEO Classification
    E=Exclude from Count
    N=None of the Above
    P=Production Trainee
    W=White-Collar Trainee
    33 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification
    34 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

    Prompt Table: SAL_PLAN_TBL

    35 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

    Prompt Table: SAL_GRADE_TBL

    36 GRADE_ENTRY_DT Date(10) DATE Grade Entry Date
    37 STEP Number(2,0) SMALLINT NOT NULL Step

    Prompt Table: SAL_STEP_TBL

    38 STEP_ENTRY_DT Date(10) DATE Step Entry Date
    39 GL_PAY_TYPE Character(6) VARCHAR2(6) NOT NULL General Ledger Pay Type
    40 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

    Prompt Table: ACCT_CD_TBL

    41 EARNS_DIST_TYPE Character(1) VARCHAR2(1) NOT NULL Earnings Distribution Type
    A=By Amount
    H=By Hours
    N=None
    P=By Percent
    42 COMP_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Compensation Frequency
    A=Annual
    B=Biweekly
    C=Contract
    D=Daily
    H=Hourly
    M=Monthly
    S=Semimonthly
    W=Weekly

    Prompt Table: COMP_FREQ_VW

    43 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    44 CHANGE_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Change Amount
    45 CHANGE_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL Change Percent
    46 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate
    47 MONTHLY_RT Number(19,3) DECIMAL(18,3) NOT NULL Monthly Rate
    48 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate
    49 ANNL_BENEF_BASE_RT Number(19,3) DECIMAL(18,3) NOT NULL Specifies a compensation amount used to calculate benefits and benefit deductions for an employee. The base compensation amount may include commissions and bonuses in addition to regular compensation. If no Annual Benefits Base Rate is entered, then benefits calculations are based on an employee's regular compensation.
    50 SHIFT_RT Number(19,6) DECIMAL(18,6) NOT NULL Shift Differential Rate
    51 SHIFT_FACTOR Number(5,3) DECIMAL(4,3) NOT NULL Shift Differential Factor
    52 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    53 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID