HRS_MASS_VW

(SQL View)
 Index Back

Mass Approve Awds Search


SELECT A.REFERRAL_PGM_ID , A.DESCR FROM PS_HRS_REF_PGM A WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_HRS_REF_PGM WHERE REFERRAL_PGM_ID = A.REFERRAL_PGM_ID AND EFFDT <= %CurrentDateIn) AND EXISTS ( SELECT 'X' FROM PS_HRS_EE_REF_AWD WHERE REFERRAL_PGM_ID = A.REFERRAL_PGM_ID AND PAYMENT_STAT_ER = 'NA')

  • Related Language Record: HRS_MAS_SCH_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REFERRAL_PGM_ID Character(12) VARCHAR2(12) NOT NULL Employee referral program ID
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description