PA_JOB_VW2

(SQL View)
Index Back

All Job Info for Pension

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. This view is a snapshot of certain fields within the JOB record at today's date.

SELECT emplid , EMPL_RCD , effdt , effseq , empl_status , ACTION , action_dt , action_reason , reg_temp , full_part_time , company , paygroup , empl_type , std_hours , std_hrs_frequency , hourly_rt , monthly_rt , annual_rt , sal_admin_plan , jobcode , position_nbr , deptid , location , business_unit FROM PS_JOB

  • 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

    Default Value: NEW

    Prompt Table: PERSON

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

    Default Value: A

    6 ACTION Character(3) VARCHAR2(3) NOT NULL Action

    Prompt Table: ACTION_TBL

    7 ACTION_DT Date(10) DATE Action Date

    Default Value: %date

    8 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

    Prompt Table: ACTN_REASON_TBL

    9 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
    R=Regular
    T=Temporary

    Default Value: R

    10 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
    D=On Demand
    F=Full-Time
    P=Part-Time

    Default Value: F

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

    Prompt Table: COMPANY_TBL

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

    Prompt Table: PAYGROUP_TBL

    13 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
    E=Exception Hourly
    H=Hourly
    N=Not Applicable
    S=Salaried
    14 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
    15 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period

    Prompt Table: STDHRS_FREQ_VW

    16 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate
    17 MONTHLY_RT Number(19,3) DECIMAL(18,3) NOT NULL Monthly Rate
    18 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate
    19 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
    20 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    21 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
    22 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    23 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    24 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit