LN_SETID_VW

(SQL View)
 Index Back

Set ID Prompt for Loans

Set ID Prompt for Loans

select DISTINCT a.aid_year, a.setid from PS_ITEM_TYPE_FA a where a.fin_aid_type = 'L' and a.eff_status = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID