GPES_MULT_VW (SQL View)	Index Back
SS Multiple Employment View 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_VW

(SQL View)

SS Multiple Employment View

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.

SELECT EMPLID ,EMPL_RCD ,EFFDT ,EFF_STATUS ,GPES_MULT_EMP_SCTR ,GPES_MULT_EMP_BSMN ,GPES_MULT_EMP_BSMX FROM PS_GPES_MULT_EMP

# 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

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..

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.

#	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
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..
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.