SP_SURVLOAD_TBL (SQL Table)	Index Back
Market Pay Mapping Table This is the child table to HR_SURVLOAD_TBL, which will contain information to load external Markey Pay data into the database.

SP_SURVLOAD_TBL

(SQL Table)

Market Pay Mapping Table

This is the child table to HR_SURVLOAD_TBL, which will contain information to load external Markey Pay data into the database.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 FILE_NAME Character(80) VARCHAR2(80) NOT NULL File Name

4 FILE_LOCATION Character(100) VARCHAR2(100) NOT NULL File Location

5 MKT_UPDATE_PROP Character(4) VARCHAR2(4) NOT NULL Update Property
1=Append
2=Overwrite
Default Value: 1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	FILE_NAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
4	FILE_LOCATION	Character(100)	VARCHAR2(100) NOT NULL	File Location
5	MKT_UPDATE_PROP	Character(4)	VARCHAR2(4) NOT NULL	Update Property 1=Append 2=Overwrite Default Value: 1