ASGN_EARNINGS

(SQL Table)
 Index Back

EE Assgn Compensatn-Earnings

ASGN_EARNINGS is one of a group of records used to record information about an employee's job assignments away from home base. Use ASGN_EARNINGS to record payroll earnings types for an employee on international assignment. An earnings record can be tagged as either 'home' or 'host'. This data is part of the International Assignment application. You can create multiple ASGN_EARNINGS records for an employee.

  • Parent record: ASGN_CMP_HOMHST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 PAY_INSTR_TYPE Character(1) VARCHAR2(1) NOT NULL Payment Instruction Type
    I=International Compensation
    O=Onetime payment

    Default Value: I

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    Prompt Table: ASGN_CMP_EFFDT

    4 HOME_HOST Character(1) VARCHAR2(1) NOT NULL Home or Host
    0=Home
    1=Host 1
    2=Host 2

    Default Value: 0

    Prompt Table: ASGN_CMP_HOMHST

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

    Prompt Table: EARNINGS_TBL

    6 BASE_COMP Character(1) VARCHAR2(1) NOT NULL Base Compensation

    Y/N Table Edit

    Default Value: N

    7 HOME_AMT Number(13,2) DECIMAL(12,2) NOT NULL Home Amount
    8 HOST_AMT Number(13,2) DECIMAL(12,2) NOT NULL Host Amount