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.

GPES_MULT_EMP

(SQL Table)

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 Rcd Nbr

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_SS_AUTH_NBR Character(17) VARCHAR2(17) NOT NULL Social Security authorization number

11 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	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 Rcd Nbr
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_SS_AUTH_NBR	Character(17)	VARCHAR2(17) NOT NULL	Social Security authorization number
11	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50