HRS_APPL_BIP_VW

(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 , A.APPLID , A.APP_PER_STATUS , A.SEX , A.BIRTHDATE , A.BIRTHPLACE , A.BIRTHCOUNTRY , A.BIRTHSTATE , A.EMPLID , A.HRS_APP_PREF_CONT , A.STATUS_CODE , STS.DESCR , A.STATUS_REASON , A.STATUS_DT , A.HRS_EXT_TRN , A.POI_TYPE , POI.DESCR , %subrec(HRS_AUDIT_SBR, A) FROM PS_HRS_APPLICANT A LEFT OUTER JOIN PS_POI_TYPE_TBL POI ON POI.POI_TYPE = A.POI_TYPE AND POI.EFF_STATUS = 'A' , PS_HRS_STS_TBL STS WHERE STS.STATUS_CODE = A.STATUS_CODE AND STS.STATUS_AREA = '2'

  • Related Language Record: HRS_APPL_BIPLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 APPLID Character(11) VARCHAR2(11) NOT NULL External Job Applicant ID
    3 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

    Default Value: A

    4 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown

    Default Value: U

    5 BIRTHDATE Date(10) DATE Date of Birth
    6 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location
    7 BIRTHCOUNTRY Character(3) VARCHAR2(3) NOT NULL Birth Country

    Prompt Table: BIRTHCOUNTRY_VW

    8 BIRTHSTATE Character(6) VARCHAR2(6) NOT NULL Birth State

    Prompt Table: BIRTHSTATE_VW

    9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: HRS_PERSON_NM_I

    10 HRS_APP_PREF_CONT Character(1) VARCHAR2(1) NOT NULL Preferred Method of Contact
    E=Email
    M=Mail
    N=Not Specified
    P=Phone

    Default Value: N

    11 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.

    Prompt Table: HRS_STS_APP_I

    12 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    13 STATUS_REASON Character(3) VARCHAR2(3) NOT NULL Identifies a reason associated with a particular status.

    Prompt Table: HRS_RSN_APP_I

    14 STATUS_DT Date(10) DATE Status Date

    Default Value: %date

    15 HRS_EXT_TRN Character(1) VARCHAR2(1) NOT NULL Applicant - External Trainee Flag

    Default Value: N

    16 POI_TYPE Character(5) VARCHAR2(5) NOT NULL Defines the Transactional usage of POIs in HRMS.

    Default Value: 00000

    Prompt Table: POI_TYPE_TBL

    17 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    18 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    19 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    20 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    21 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id