HRS_AM_RSLT_I

(SQL View)
 Index Back

Auto-Match Search Results

Defines applicants that meet the search criteria during the auto-match search process.

SELECT AR.HRS_OWNER_ID , AR.SEARCH_NAME , AR.HRS_PERSON_ID , AR.HRS_PROFILE_SEQ , AR.SRCH_SCORE , AR.HRS_JOB_OPENING_ID , AR.HRS_SUBMITTED_DTTM , AR.NAME , AR.RUNDTTM , AR.HRS_SCH_LOCDSC , AR.APP_PER_STATUS , %subrec(HRS_AUDIT_SBR, AR) FROM PS_HRS_AM_RSLT AR

# 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 HRS_SUBMITTED_DTTM DateTime(26) TIMESTAMP Submitted Date Time
8 NAME Character(50) VARCHAR2(50) NOT NULL Name
9 RUNDTTM DateTime(26) TIMESTAMP Run Date/Time
10 HRS_SCH_LOCDSC Character(50) VARCHAR2(50) NOT NULL Location
11 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
12 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
13 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
14 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
15 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id