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
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	REG_TEMP	Character(1)	VARCHAR2(1) NOT NULL	Regular/Temporary R=Regular T=Temporary
20	HRS_SITE_ID	Number(15,0)	DECIMAL(15) NOT NULL	Site ID
21	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time D=On Demand F=Full-Time P=Part-Time
22	HRS_JOB_OPENING_ID	Number(15,0)	DECIMAL(15) NOT NULL	Job Opening Clone
23	HRS_RECR_NAME	Character(50)	VARCHAR2(50) NOT NULL	Recruiter
24	HRS_MGR_NAME	Character(50)	VARCHAR2(50) NOT NULL	Hiring Manager
25	HRS_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Row Added DateTime
26	HRS_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Added Operator Id
27	HRS_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Row Updated DateTime
28	HRS_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Updated Operator Id