GPES_PP_EMP (SQL Table)	Index Back
Employee Pensions Plan Assign Pensions Plan to Pensions Plan

GPES_PP_EMP

(SQL Table)

Employee Pensions Plan

Assign Pensions Plan to Pensions Plan

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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 GPES_PP_ID Character(10) VARCHAR2(10) NOT NULL Pension Plan Identifier
Prompt Table: GPES_PP_DEFN

5 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
Default Value: A

6 GPES_DISAB_MORE_65 Character(1) VARCHAR2(1) NOT NULL Employee Disability >=65%
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
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	GPES_PP_ID	Character(10)	VARCHAR2(10) NOT NULL	Pension Plan Identifier Prompt Table: GPES_PP_DEFN
5	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive Default Value: A
6	GPES_DISAB_MORE_65	Character(1)	VARCHAR2(1) NOT NULL	Employee Disability >=65% Y/N Table Edit Default Value: N