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.SRCH_SCORE , AR.HRS_PERSON_ID , AR.HRS_PROFILE_SEQ , AR.HRS_JOB_OPENING_ID , 0 , ' ' , AR.HRS_SUBMITTED_DTTM , AR.NAME , AR.RUNDTTM , AR.HRS_SCH_LOCDSC , AR.APP_PER_STATUS , AR.PREV_EMPL_BY_COMPY , AR.HRS_SCORE , %subrec(HRS_AUDIT_SBR, AR) FROM PS_HRS_AM_RSLT AR

  • Related Language Record: HRS_AM_RSLT_LN

    • # 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 SRCH_SCORE Number(4,0) SMALLINT NOT NULL Search Score
    4 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    5 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
    6 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
    7 HRS_JO_PST_SEQ Number(3,0) SMALLINT NOT NULL Job opening posting sequence
    8 JPM_PROFILE_ID Character(12) VARCHAR2(12) NOT NULL The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile.
    9 HRS_SUBMITTED_DTTM DateTime(26) TIMESTAMP Submitted Date Time
    10 NAME Character(50) VARCHAR2(50) NOT NULL Name
    11 RUNDTTM DateTime(26) TIMESTAMP Run Date/Time
    12 HRS_SCH_LOCDSC Character(50) VARCHAR2(50) NOT NULL Location
    13 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
    14 PREV_EMPL_BY_COMPY Character(1) VARCHAR2(1) NOT NULL Previously Employed by Company
    N=No
    Y=Yes
    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