HRS_OVR_SCH_VW

(SQL View)
 Index Back

Override Search View

Eligibility and Award Override search view.

SELECT A.HRS_PERSON_ID , A.EMPLID , B.NAME , C.NAME_DISPLAY , D.OPRID FROM PS_HRS_EE_REFERRAL A , PS_HRS_APP_NAME_I B , PS_HRS_PERSON_NM_I C , PS_HRS_APP_SEC_VW D WHERE A.EMPLID <> ' ' AND A.HRS_PERSON_ID = D.HRS_PERSON_ID AND A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.EMPLID = C.EMPLID AND EXISTS ( SELECT 'X' FROM PSAUDIT WHERE KEY1 = %NumToChar(A.HRS_PERSON_ID) AND KEY2 = A.EMPLID AND RECNAME IN ('HRS_EE_REF_ELIG', 'HRS_EE_REF_AWD'))

  • Related Language Record: HRS_OVR_SCH_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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 NAME Character(50) VARCHAR2(50) NOT NULL Name
    4 EMPL_NAME Character(50) VARCHAR2(50) NOT NULL Employee Name
    5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).