HRS_APPLCANT_LN

(SQL View)
 Index Back

Related Language Record

Related Language Record for HRS_APPLCANT_VW

SELECT A.HRS_PERSON_ID , B.HRS_PROFILE_SEQ , C.LANGUAGE_CD , C.NAME_DISPLAY FROM PS_HRS_APPLICANT A , PS_HRS_APP_PROFILE B LEFT OUTER JOIN PS_HRS_APPINDX_CTL IDX ON (B.HRS_PERSON_ID = IDX.HRS_PERSON_ID AND B.HRS_PROFILE_SEQ = IDX.HRS_PROFILE_SEQ) , PS_HRS_APP_NM_LNG C , PS_HRS_RCMNT D WHERE A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.HRS_PERSON_ID = C.HRS_PERSON_ID AND (EXISTS ( SELECT 1 FROM PS_HRS_SRCHIDX_CTL CTL WHERE CTL.HRS_SRCH_INDEX_CD = 'A' AND %DatePart(B.HRS_SUBMITTED_DTTM) >= CTL.HRS_FROM_DATE) OR NOT EXISTS ( SELECT 1 FROM PS_HRS_SRCHIDX_CTL CTL WHERE CTL.HRS_SRCH_INDEX_CD = 'A')) AND (A.STATUS_CODE IN ( SELECT STATUS_CODE FROM PS_HRS_SRCHIDX_APS APS WHERE APS.HRS_SRCH_INDEX_CD = 'A') OR NOT EXISTS ( SELECT 1 FROM PS_HRS_SRCHIDX_APS APS WHERE APS.HRS_SRCH_INDEX_CD = 'A')) AND A.HRS_PERSON_ID = D.HRS_PERSON_ID AND D.HRS_RCMNT_ID = ( SELECT MAX(D2.HRS_RCMNT_ID) FROM PS_HRS_RCMNT D2 WHERE D2.HRS_PERSON_ID = D.HRS_PERSON_ID) AND D.HRS_LOGICAL_DELETE = 'N'

  • Related Language Record for HRS_APPLCANT_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country