GPCH_RP_LSECT (SQL Table)	Index Back
Setup Cross Refer. Contract This table stores the mapping between Peoplesoft Contract Type values and Swissdec Position Contract Type values.

GPCH_RP_LSECT

(SQL Table)

Setup Cross Refer. Contract

This table stores the mapping between Peoplesoft Contract Type values and Swissdec Position Contract Type 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 GPCH_RP_LSESVAL Character(8) VARCHAR2(8) NOT NULL Salary Type Value
Prompt Table: PERS_CNTRCT_TYP

3 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: CT

4 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	GPCH_RP_LSESVAL	Character(8)	VARCHAR2(8) NOT NULL	Salary Type Value Prompt Table: PERS_CNTRCT_TYP
3	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: CT
4	GPCH_RP_LSETVAL	Number(2,0)	SMALLINT NOT NULL	Activity Prompt Table: GPCH_SD_TAGS