ASGN_DEDUCTIONS

(SQL Table)
 Index Back

EE Assgn Compensatn-Deductions

ASGN_DEDUCTIONS is one of a group of records used to record information about an employee's job assignments away from home base. Use ASGN_DEDUCTIONS to record payroll deductions for an employee on international assignment. A deduction can be tagged as either 'home' or 'host'. This data is part of the International Assignment application. You can create multiple ASGN_DEDUCTION 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 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code

    Prompt Table: DED_TBL_GNL_VW2

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