RETRODEDMAS_DEF

(SQL Table)
 Index Back

Retro Deduction Mass Rqst Def

This is the table of mass request definitions that are defined with the corresponding, parent mass request table, for use in Retro Deductions processing.

  • Parent record: RETRODEDMAS_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MASS_RETRO_RQST_ID Character(5) VARCHAR2(5) NOT NULL Mass Retro Request ID

    Prompt Table: RETRODEDMAS_TBL

    2 MASS_RETRO_SEQ_NO Number(8,0) INTEGER NOT NULL Mass Retro Sequence Number
    3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

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

    Prompt Table: PAYGROUP_TBL

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

    Prompt Table: JOBCODE_TBL

    6 JOBCODE_ELIG_DAYS Number(4,0) SMALLINT NOT NULL Job Eligibility Days
    7 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_TBL

    8 LOCATION_ELIG_DAYS Number(4,0) SMALLINT NOT NULL Location Eligibility Days
    9 UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code

    Prompt Table: UNION_TBL

    10 UNION_CD_ELIG_DAYS Number(4,0) SMALLINT NOT NULL Union Code Eligibility Days
    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 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
    E=Exception Hourly
    H=Hourly
    N=Not Applicable
    S=Salaried
    13 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
    R=Regular
    T=Temporary
    14 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification

    Prompt Table: EMPL_CL_STD_VW

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

    Prompt Table: DEPT_TBL

    17 MASS_PRCS_FLAG Character(1) VARCHAR2(1) NOT NULL Mass Retro Pay Process Flag
    C=Calculated
    D=Request Deleted
    L=Loaded To Retro Pay Request
    N=Not Processed
    P=Loaded to Paysheets
    X=Extracted

    Default Value: N

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

    Prompt Table: BUS_UNIT_TBL_HR