HP_ERN_ACCT_MAP

(SQL Table)
 Index Back

Earnings Account Detail

Specify ACCOUNT at the employee type, employee class, reg/temp, full/part time, paygroup, business unit, jobcode, salary admin plan and earnings code level.

  • Parent record: HP_ERN_ACCT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    2 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

    Prompt Table: GL_ACCOUNT_TBL

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
    E=Exception Hourly
    H=Hourly
    N=Not Applicable
    S=Salaried
    5 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification

    Prompt Table: EMPL_CL_STD_VW

    6 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
    R=Regular
    T=Temporary
    7 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
    D=On Demand
    F=Full-Time
    P=Part-Time
    8 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

    Prompt Table: PAYGROUP_MC_VW

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

    Prompt Table: BUSUNIT_HR_VW

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

    Prompt Table: HP_SET_JOBCD_VW

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

    Prompt Table: HP_JOBCODE_VW

    12 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary Set ID

    Prompt Table: HP_SET_SAL_VW

    13 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

    Prompt Table: HP_SAL_PLAN_VW

    14 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code

    Prompt Table: EARNINGS_TBL