HRS_APPL_BIPLVW

(SQL View)
 Index Back

Applicant Data

This view is used to return applicant data for use in Application Details XMLP report.

SELECT A.HRS_PERSON_ID , STS.LANGUAGE_CD , STS.DESCR , POI.DESCR FROM PS_HRS_APPLICANT A , PS_HRS_STS_LNG STS , PS_POI_TYPE_LNG POI WHERE STS.STATUS_CODE = A.STATUS_CODE AND STS.STATUS_AREA = '2' AND POI.POI_TYPE = A.POI_TYPE AND POI.LANGUAGE_CD = STS.LANGUAGE_CD UNION SELECT A.HRS_PERSON_ID , STS.LANGUAGE_CD , STS.DESCR , ' ' FROM PS_HRS_APPLICANT A , PS_HRS_STS_LNG STS WHERE STS.STATUS_CODE = A.STATUS_CODE AND STS.STATUS_AREA = '2' AND NOT EXISTS( SELECT 'X' FROM PS_POI_TYPE_LNG POI WHERE POI.POI_TYPE = A.POI_TYPE AND POI.LANGUAGE_CD = STS.LANGUAGE_CD)

  • Related Language Record for HRS_APPL_BIP_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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr