GPES_MULT_EMP

(SQL Table)
Index Back

SS Multiple Employment

This table houses the employee that has multiple jobs in different companies and the percentages to be used in Social Security calculations. When a payee has multiple jobs in different companies, Social Security stablishes a percentage to be apply on Social Security bases for reduccing the contribution amount.

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

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 GPES_MULT_EMP_SCTR Character(2) VARCHAR2(2) NOT NULL This field houses the sector
    10=Public
    20=Private
    6 GPES_MULT_EMP_BSMN Signed Number(7,2) DECIMAL(5,2) NOT NULL Reduction Percentage. This field houses the percentage that has to be aplied to a particular base for Social Security Reduction..

    Default Value: 0

    7 GPES_MULT_EMP_BSMX Signed Number(7,2) DECIMAL(5,2) NOT NULL Reduction Percentage. This field houses the percentage that has to be aplied to a particular base for Social Security Reduction.

    Default Value: 0

    8 GPES_MUL_EMP_MN_CP Signed Number(7,2) DECIMAL(5,2) NOT NULL Minimum CP Base Percentage for Multiple Employment

    Default Value: 0

    9 GPES_MUL_EMP_MX_CP Signed Number(7,2) DECIMAL(5,2) NOT NULL Maximum CP Base Percentage for Multiple Employment

    Default Value: 0

    10 GPES_MUL_EMP_PEC45 Character(1) VARCHAR2(1) NOT NULL Peculiarity 54xx exclusion option to point out what base CP part (IT, IMS, FOGASA, Umemployment or Professional Training) is excluded for contribution in another company.

    Y/N Table Edit

    Default Value: N

    11 GPES_MUL_EMP_MN_FG Signed Number(7,2) DECIMAL(5,2) NOT NULL Minimum FOGASA Base Percentage for Multiple Employment

    Default Value: 0

    12 GPES_MUL_EMP_MX_FG Signed Number(7,2) DECIMAL(5,2) NOT NULL Maximum FOGASA Base Percentage for Multiple Employment

    Default Value: 0

    13 GPES_MUL_EMP_MN_DS Signed Number(7,2) DECIMAL(5,2) NOT NULL Minimum Unemployment Base Percentage for Multiple Employment

    Default Value: 0

    14 GPES_MUL_EMP_MX_DS Signed Number(7,2) DECIMAL(5,2) NOT NULL Maximum Unemployment Base Percentage for Multiple Employment

    Default Value: 0

    15 GPES_MUL_EMP_MN_FP Signed Number(7,2) DECIMAL(5,2) NOT NULL Minimum Professional Training Base Percentage for Multiple Employment

    Default Value: 0

    16 GPES_MUL_EMP_MX_FP Signed Number(7,2) DECIMAL(5,2) NOT NULL Maximum Professional Training Base Percentage for Multiple Employment

    Default Value: 0

    17 GPES_SS_AUTH_NBR Character(17) VARCHAR2(17) NOT NULL Social Security authorization number
    18 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50