HRS_RC_PKG

#	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	PKG_PROCESSTYPE	Character(1)	VARCHAR2(1) NOT NULL	Sal package - Process Type C=By Company D=By Department E=By Employee ID P=By Company, Pay Group
4	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
5	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PAYGROUP_TBL
6	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group Prompt Table: GP_PYGRP
7	PKG_PROCESSTP_GP	Character(1)	VARCHAR2(1) NOT NULL	Process Typer - Salary Packaging D=By Department E=By Employee ID P=By Pay Group
8	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PKG_MDL_EMPL_VW
9	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr Prompt Table: PKG_MDL_TBL
10	EXP_DEL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Sal Package - Expense DeletionFlag Y/N Table Edit Default Value: N
11	DEPARTMENT	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPARTMENT_SRCH
12	FROM_DT	Date(10)	DATE	From Date
13	THRU_DT	Date(10)	DATE	Sal Package - Thru Date
14	PKG_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Sal Package - Package Status C=Current H=History P=Proposed Default Value: P
15	YEARCD	Character(4)	VARCHAR2(4) NOT NULL	Calendar Year
16	ASOFDATE	Date(10)	DATE	As of Date Default Value: %DATE
17	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
18	APPLID	Character(11)	VARCHAR2(11) NOT NULL	External Job Applicant ID Prompt Table: HRS_PKMDL_APP_V
19	EMPLID_OLD	Character(11)	VARCHAR2(11) NOT NULL	Previous Employee ID