HRS_APPI_ALL_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.

SELECT A.HRS_PERSON_ID , B.HRS_PROFILE_SEQ , B.HRS_SUBMITTED_DTTM , B.HRS_RESUME_ID , B.LANG_CD , A.APP_PER_STATUS , A.STATUS_CODE , B.BUSINESS_UNIT , NM.NAME_DISPLAY , B.HRS_AL_LOG_ID FROM PS_HRS_APPLICANT A , PS_HRS_APP_PROFILE B , PS_HRS_APP_NAMES NM WHERE A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.HRS_PERSON_ID = NM.HRS_PERSON_ID

# 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
9 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
10 HRS_AL_LOG_ID Number(15,0) DECIMAL(15) NOT NULL Resume Extraction Queue ID