GPCH_RP_LSEPS (SQL Table)	Index Back
Setup Cross Reference Position This table stores the mapping between Peoplesoft Position values and Swissdec Position values

GPCH_RP_LSEPS

(SQL Table)

Setup Cross Reference Position

This table stores the mapping between Peoplesoft Position values and Swissdec Position values

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SETID_TBL

2 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
Prompt Table: SAL_PLAN_TBL

3 GPCH_RP_LSESVAL Character(8) VARCHAR2(8) NOT NULL Salary Type Value
Prompt Table: SAL_GRADE_TBL

4 GPCH_RP_LSETYPE Character(2) VARCHAR2(2) NOT NULL Salary Type
C=Contract
CF=Education
CT=Contract
E=Education
J=Job Code
M=Employment
MP=Employment
NM=Nationality
P=Position
PS=Position
S=Skill
Default Value: PS

5 GPCH_RP_LSETVAL Number(2,0) SMALLINT NOT NULL Activity
Prompt Table: GPCH_SD_TAGS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
2	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan Prompt Table: SAL_PLAN_TBL
3	GPCH_RP_LSESVAL	Character(8)	VARCHAR2(8) NOT NULL	Salary Type Value Prompt Table: SAL_GRADE_TBL
4	GPCH_RP_LSETYPE	Character(2)	VARCHAR2(2) NOT NULL	Salary Type C=Contract CF=Education CT=Contract E=Education J=Job Code M=Employment MP=Employment NM=Nationality P=Position PS=Position S=Skill Default Value: PS
5	GPCH_RP_LSETVAL	Number(2,0)	SMALLINT NOT NULL	Activity Prompt Table: GPCH_SD_TAGS