GPS_STDHRS_RUN

#	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	FROMDATE	Date(10)	DATE	From Date
4	THRUDATE	Date(10)	DATE	End Date
5	ASOFDATE	Date(10)	DATE	As of Date
6	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
7	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPARTMENT_SRCH
8	REPORT_CHOICE	Character(1)	VARCHAR2(1) NOT NULL	Output Report Choice 1=Applicants 2=Current Employees 3=Both Applicants and Employees
9	POPULATION	Character(1)	VARCHAR2(1) NOT NULL	Search Population-Skill Match 1=All 2=Internal Applicants 3=External Applicants 4=Candidates for Specific Positn
10	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Default Value: OPR_DEF_TBL_HR.COMPANY Prompt Table: COMPANY_TBL
11	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_HR
12	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
13	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan Prompt Table: SAL_PLAN_TBL
14	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code Prompt Table: ACTN_REASON_TBL
15	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
16	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERS_SRCH_GBL
17	PURGE_PRCS_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Purge Process Option 1=Print and Process 2=Process Only 3=Print Only Default Value: 3
18	COMPANY_INFO_LBL	Character(1)	VARCHAR2(1) NOT NULL	Company Information Y/N Table Edit
19	EMPLOYEE_INFO_LBL	Character(1)	VARCHAR2(1) NOT NULL	Employee Information Y/N Table Edit Default Value: N
20	PANEL_NAME	Character(18)	VARCHAR2(18) NOT NULL	Panel name
21	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone