GPS_WFS_MAP_EDU (SQL Table)	Index Back
Mapping Table for Education

GPS_WFS_MAP_EDU

(SQL Table)

Mapping Table for Education

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HIGHEST_EDUC_LVL Character(2) VARCHAR2(2) NOT NULL Highest Education Level

2 GPS_WFS_RPT_FLD Character(10) VARCHAR2(10) NOT NULL GPS WFS Report Field
Default Value: EF41U1
Prompt Table: GPS_WFS_MAP_DTL

3 GPS_WFS_MAP_RS_EDU Character(1) VARCHAR2(1) NOT NULL The mapping result field for reports field.

4 GPS_WFS_MAP_EXC Character(1) VARCHAR2(1) NOT NULL The Exclude flag indicates whether the emplids with matching exclude on any of the mappings will be excluded from the report / file.
N=N
Y=Y
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HIGHEST_EDUC_LVL	Character(2)	VARCHAR2(2) NOT NULL	Highest Education Level
2	GPS_WFS_RPT_FLD	Character(10)	VARCHAR2(10) NOT NULL	GPS WFS Report Field Default Value: EF41U1 Prompt Table: GPS_WFS_MAP_DTL
3	GPS_WFS_MAP_RS_EDU	Character(1)	VARCHAR2(1) NOT NULL	The mapping result field for reports field.
4	GPS_WFS_MAP_EXC	Character(1)	VARCHAR2(1) NOT NULL	The Exclude flag indicates whether the emplids with matching exclude on any of the mappings will be excluded from the report / file. N=N Y=Y Default Value: N