HRS_LIST_APP_VW

(SQL View)
 Index Back

Applicant Lists

Applicant Lists History: 1. Added audit sub record for bug 28730582

SELECT B.HRS_PERSON_ID , B.HRS_LST_ID , C.NAME_DISPLAY , %DateNull , D.HRS_APP_PREF_CONT ,' ' ,' ' ,B.HRS_ROW_ADD_DTTM ,B.HRS_ROW_ADD_OPRID ,B.HRS_ROW_UPD_DTTM ,B.HRS_ROW_UPD_OPRID FROM PS_HRS_LIST A , PS_HRS_LIST_APPL B ,PS_HRS_APP_NAME_I C , PS_HRS_APPLICANT_I D WHERE A.HRS_LST_ID = B.HRS_LST_ID AND B.HRS_PERSON_ID = C.HRS_PERSON_ID AND B.HRS_PERSON_ID = D.HRS_PERSON_ID AND A.HRS_LST_TYPE IN ('APPL','SSRL') AND HRS_LST_FREEZE<>'Y' AND (A.HRS_SAVE_UNTIL IS NULL OR A.HRS_SAVE_UNTIL >=%CurrentDateIn)

  • Related Language Record: HRS_LIST_APP_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_LST_ID Number(15,0) DECIMAL(15) NOT NULL List ID
    3 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    4 HRS_CNTCT_DT Date(10) DATE Contact Date
    5 HRS_APP_PREF_CONT Character(1) VARCHAR2(1) NOT NULL Preferred Method of Contact
    E=Email
    M=Mail
    N=Not Specified
    P=Phone
    6 HRS_APP_PREF_CNTCT Character(70) VARCHAR2(70) NOT NULL Preferred Contact
    7 HRS_LAST_CNTCT_BY Character(11) VARCHAR2(11) NOT NULL Last Contacted By
    8 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    9 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    10 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    11 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id