COST_CD_AIDY_VW

(SQL View)
Index Back

SELECT DISTINCT A.INSTITUTION, A.AID_YEAR, B.DESCR FROM PS_CAN_COST_CODE A, PS_AID_YEAR_TBL B WHERE A.AID_YEAR = B.AID_YEAR

  • Related Language Record: COSTCDAIDYVWLNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    2 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description