HRS_AGN_PRO_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
4	SEARCH_NAME	Character(20)	VARCHAR2(20) NOT NULL	Stored Search Name
5	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
6	LAST_UPDATE_DATE	Date(10)	DATE	Date of last update
7	LANG_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code CFR=Canadian French DAN=Danish DUT=Dutch ENG=English ESP=Spanish FRA=French GER=German GRK=Greek INE=International English ITA=Italian JPN=Japanese KOR=Korean POR=Portuguese SVE=Swedish THA=Thai ZHS=Simplified Chinese ZHT=Traditional Chinese
8	HRS_JOBAGENT_IND	Character(1)	VARCHAR2(1) NOT NULL	Job Agent Indicator Y/N Table Edit
9	HRS_SEARCH_ID	Number(15,0)	DECIMAL(15) NOT NULL	Search Id counter
10	HRS_SCH_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Search Type A=Advanced B=Basic D=Database K=Keyword P=Profile Match
11	HRS_ROWS_PERPAGE	Character(3)	VARCHAR2(3) NOT NULL	Rows Per Page 10=10 100=100 25=25 50=50
12	HRS_SORT_BY	Character(1)	VARCHAR2(1) NOT NULL	Sort By D=Date Posted L=Location
13	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
14	HRS_POSTED_WTN	Character(1)	VARCHAR2(1) NOT NULL	Time period A=Anytime M=Last Month Q=Last Three Months W=Last Week Y=Last Year
15	SAL_RANGE_MIN_RATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Salary Range Minimum Rate
16	SAL_RANGE_MAX_RATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Salary Range Maximum Rate
17	SAL_RANGE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Salary Range Currency
18	SAL_RANGE_FREQ	Character(5)	VARCHAR2(5) NOT NULL	Salary Range Frequency
19	SHIFT	Character(1)	VARCHAR2(1) NOT NULL	Regular Shift 1=Day 2=Evening 3=Night A=Any C=Compressed N=Not Applicable R=Rotating
20	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
21	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
22	REG_TEMP	Character(1)	VARCHAR2(1) NOT NULL	Regular/Temporary R=Regular T=Temporary
23	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time D=On Demand F=Full-Time P=Part-Time
24	HRS_SITE_ID	Number(15,0)	DECIMAL(15) NOT NULL	Site ID
25	HRS_JOB_OPENING_ID	Number(15,0)	DECIMAL(15) NOT NULL	Job Opening Clone
26	HRS_RECR_NAME	Character(50)	VARCHAR2(50) NOT NULL	Recruiter
27	HRS_MGR_NAME	Character(50)	VARCHAR2(50) NOT NULL	Hiring Manager
28	FACETED_SRCH_IND	Character(1)	VARCHAR2(1) NOT NULL	Faceted search indicator
29	HRS_SORT_ORDER_BY	Character(1)	VARCHAR2(1) NOT NULL	Sort Order A=Ascending D=Descending
30	HRS_SORT_RSLTS_BY	Character(2)	VARCHAR2(2) NOT NULL	sort by dropdown field for job search page search results scroll area 01=Job Title 02=Job ID 03=Department 04=Location 06=Job Family 07=Job Function 08=Business Unit 09=Posted Date 10=Hot Jobs 11=Favorites 12=Profile Score
31	HRS_JOBAG_TXT_IND	Character(1)	VARCHAR2(1) NOT NULL	Text me when new Jobs
32	HRS_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Row Added DateTime
33	HRS_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Added Operator Id
34	HRS_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Row Updated DateTime
35	HRS_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Updated Operator Id