JBCMP_TMP_MC_VW

(SQL View)
 Index Back

Temp Job for Mass Changes

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 distinct MC_DEFN_ID, MC_STATUS, SETID_DEPT, DEPTID, EMPLID, EMPL_RCD, EFFDT, EFFSEQ, MC_TEMPLATE_ID, POSITION_NBR, EMPL_STATUS, ACTION, ACTION_REASON, FULL_PART_TIME, COMPANY, PAYGROUP, EMPL_TYPE, BUSINESS_UNIT FROM PS_JOBCOMP_TMP_MC

  • Parent record: PER_ORG_ASGN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MC_DEFN_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Definition
    2 MC_STATUS Character(3) VARCHAR2(3) NOT NULL Mass Change Status
    APR=Approved Transaction
    CAN=Cancel Transaction
    ERR=Errored Transaction
    PND=Pending Transaction
    SCS=Successful Transaction
    3 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

    4 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

    5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    7 EFFDT Date(10) DATE Effective Date
    8 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    9 MC_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Template ID
    10 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: POSITION_DATA

    11 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
    12 ACTION Character(3) VARCHAR2(3) NOT NULL Action
    13 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

    Prompt Table: ACTN_REASON_TBL

    14 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
    D=On Demand
    F=Full-Time
    P=Part-Time
    15 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

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

    Prompt Table: PAYGROUP_TBL

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

    Prompt Table: PAYGRP_EMPLTYPE

    18 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT

    Prompt Table: BUS_UNIT_TBL_HR