HRS_SRCH_SAVED

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_OWNER_ID	Character(11)	VARCHAR2(11) NOT NULL	Owner ID
2	SEARCH_NAME	Character(20)	VARCHAR2(20) NOT NULL	Stored Search Name
3	HRS_SEARCH_ID	Number(15,0)	DECIMAL(15) NOT NULL	Search Id counter
4	HRS_SCH_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Search Type A=Advanced B=Basic D=Database
5	VISIBLE_PROPERTY	Character(1)	VARCHAR2(1) NOT NULL	Used in SS Framework
6	HRS_SCH_ACTIVE	Character(1)	VARCHAR2(1) NOT NULL	Active Indicator N=Inactive Y=Active Default Value: Y
7	HRS_SCH_ACCESS	Character(1)	VARCHAR2(1) NOT NULL	Access P=Public V=Private
8	AUTOMATCH_IND	Character(1)	VARCHAR2(1) NOT NULL	Search Automatch Search agent indicator Y/N Table Edit Default Value: N
9	HRS_AM_END_DT	Date(10)	DATE	Automatch End Date
10	END_DT_IND	Character(1)	VARCHAR2(1) NOT NULL	End Date indicator C=End on Requisition Close Date P=End on Max Posting Close Date S=End on Specified Date Default Value: C
11	RESTART_IND	Character(1)	VARCHAR2(1) NOT NULL	Restart indicator Default Value: N
12	CREATED_DTTM	DateTime(26)	TIMESTAMP	Created Datetime
13	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
14	LAST_RUN_DTM	DateTime(26)	TIMESTAMP	Last Run On
15	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
16	EXTERNAL_APPL_IND	Character(1)	VARCHAR2(1) NOT NULL	External applicant indicator. Y/N Table Edit
17	APP_PER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Identifies the type of applicant - External Applicant, Employee or Non-Employee A=External Applicant E=Employee N=Non-Employee
18	FIRST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	First Name
19	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
20	STATUS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Identifies a status.
21	EMPLOYEE_IND	Character(1)	VARCHAR2(1) NOT NULL	Employee indicator. Y/N Table Edit
22	NON_EMPLOYEE_IND	Character(1)	VARCHAR2(1) NOT NULL	Non-employee indicator. Y/N Table Edit
23	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
24	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID
25	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
26	JOB_FAMILY	Character(6)	VARCHAR2(6) NOT NULL	Job Family
27	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
28	COUNTRY_DESCR1	Character(30)	VARCHAR2(30) NOT NULL	Country Description Prompt Table: HRS_COUNTRY_VW
29	STATE_DESCR1	Character(30)	VARCHAR2(30) NOT NULL	State Description Prompt Table: HRS_STATE_I
30	START_DT	Date(10)	DATE	Start Date
31	END_DT	Date(10)	DATE	end date
32	HRS_APPRCV_WTN	Character(3)	VARCHAR2(3) NOT NULL	Application Received within specified timframe A=Anytime... D=Within Last Day M=Within Last Month W=Within Last Week Y=Within Last Year
33	HRS_SOURCE_ID	Number(15,0)	DECIMAL(15) NOT NULL	Source ID
34	HRS_SUBSOURCE_ID	Number(15,0)	DECIMAL(15) NOT NULL	SubSource ID
35	RESUME_TEXT_100	Character(100)	VARCHAR2(100) NOT NULL	Resume Text
36	SRCH_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Search Category A=All Fields Selected N=Any Field Selected
37	ZONE_ACCOMP	Character(100)	VARCHAR2(100) NOT NULL	Accomplishments
38	ZONE_COMPETENCIES	Character(100)	VARCHAR2(100) NOT NULL	Competencies
39	ZONE_EDUCATION	Character(100)	VARCHAR2(100) NOT NULL	Education
40	ZONE_WORK_EXP	Character(100)	VARCHAR2(100) NOT NULL	Work Experience
41	LAST_ACTIVITY_TIME	DateTime(26)	TIMESTAMP	Last Activity Time
42	HRS_LST_FREEZE	Character(1)	VARCHAR2(1) NOT NULL	Freeze List Y/N Table Edit Default Value: N
43	HRS_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Row Added DateTime
44	HRS_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Added Operator Id
45	HRS_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Row Updated DateTime
46	HRS_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Updated Operator Id
47	DESCRLONG	Long Character	CLOB	Long Description