GPCH_RP_LSENM (SQL Table)	Index Back
Residence Category Reference This table stores the mapping between Peoplesoft Visa/Permit values and Swissdec Residence Category values

GPCH_RP_LSENM

(SQL Table)

Residence Category Reference

This table stores the mapping between Peoplesoft Visa/Permit values and Swissdec Residence Category values

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Default Value: CHE
Prompt Table: COUNTRY_TBL

2 VISA_PERMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Visa/Permit Type
Prompt Table: VISA_PERMIT_TBL

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: NM

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	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Default Value: CHE Prompt Table: COUNTRY_TBL
2	VISA_PERMIT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Visa/Permit Type Prompt Table: VISA_PERMIT_TBL
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: NM
4	GPCH_RP_LSETVAL	Number(2,0)	SMALLINT NOT NULL	Activity Prompt Table: GPCH_SD_TAGS