HRS_AM_RSLT

#	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_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
4	HRS_PROFILE_SEQ	Number(3,0)	SMALLINT NOT NULL	Profile sequece
5	SRCH_SCORE	Number(4,0)	SMALLINT NOT NULL	Search Score
6	HRS_JOB_OPENING_ID	Number(15,0)	DECIMAL(15) NOT NULL	Job Opening Clone
7	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
8	HRS_SUBMITTED_DTTM	DateTime(26)	TIMESTAMP	Submitted Date Time
9	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
10	RUNDTTM	DateTime(26)	TIMESTAMP	Run Date/Time
11	HRS_SCH_LOCDSC	Character(50)	VARCHAR2(50) NOT NULL	Location
12	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
13	DELETE_IND	Character(1)	VARCHAR2(1) NOT NULL	Delete Indicator is used to indicate whether a row has been logically deleted. Y/N Table Edit Default Value: N
14	PREV_EMPL_BY_COMPY	Character(1)	VARCHAR2(1) NOT NULL	Previously Employed by Company N=No Y=Yes Default Value: N
15	HRS_SCORE	Number(8,4)	DECIMAL(7,4) NOT NULL	Field to display search score in 4.4 format
16	HRS_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Row Added DateTime
17	HRS_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Added Operator Id
18	HRS_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Row Updated DateTime
19	HRS_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Updated Operator Id