HRS_APPI_UPD_VW

(SQL View)
 Index Back

Internal Search Indexing View

This record is used in the internal search indexing process to collect information for the Verity Index for inserts and updates.

SELECT APPIDX.HRS_PERSON_ID , APPIDX.HRS_PROFILE_SEQ , PROF.HRS_SUBMITTED_DTTM , PROF.HRS_RESUME_ID , PROF.LANG_CD , APP.APP_PER_STATUS , APP.STATUS_CODE , ADDR.CITY , ADDR.COUNTRY , ADDR.STATE , PROF.BUSINESS_UNIT , NM.NAME_DISPLAY , PROF.HRS_AL_LOG_ID , PROF.PREV_EMPL_BY_COMPY FROM PS_HRS_APPLICANT APP , PS_HRS_APP_PROFILE PROF , PS_HRS_APP_ADDRESS ADDR , PS_HRS_APPINDX_CTL APPIDX , PS_HRS_APP_NAMES NM , PS_HRS_STS_REC_I ST WHERE APPIDX.INDEX_ACTION = 'U' AND APP.HRS_PERSON_ID = PROF.HRS_PERSON_ID AND APPIDX.HRS_PROFILE_SEQ = PROF.HRS_PROFILE_SEQ AND APP.HRS_PERSON_ID = ADDR.HRS_PERSON_ID AND APP.HRS_PERSON_ID = APPIDX.HRS_PERSON_ID AND APP.HRS_PERSON_ID = NM.HRS_PERSON_ID AND APP.STATUS_CODE = ST.STATUS_CODE AND ST.HRS_DRFT_STS_IND <> 'Y'

  • Related Language Record: HRS_APPI_UPD_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
    3 HRS_SUBMITTED_DTTM DateTime(26) TIMESTAMP Submitted Date Time
    4 HRS_RESUME_ID Number(15,0) DECIMAL(15) NOT NULL Resume id
    5 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
    6 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
    7 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.
    8 CITY Character(30) VARCHAR2(30) NOT NULL City
    9 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    10 STATE Character(6) VARCHAR2(6) NOT NULL State
    11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    12 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    13 HRS_AL_LOG_ID Number(15,0) DECIMAL(15) NOT NULL Resume Extraction Queue ID
    14 PREV_EMPL_BY_COMPY Character(1) VARCHAR2(1) NOT NULL Previously Employed by Company
    N=No
    Y=Yes