ISIRFLDSRCHLNG

(SQL View)
 Index Back

ISIR Fields & Descrs

isir_sar_xref is used as a cross reference between the SAR (Student Aid Report) question numbers and the ISIR tables that store the information. This cross reference is used when making electronic corrections to the ISIR data, and the SAR field number is required for those changes. An updated version of this table is delivered by PeopleSoft as part of the Financial Aid Regulatory Release every year.

SELECT a.aid_year ,b.isir_field_num ,a.language_cd ,a.descr FROM PS_ISIRSARXREFLNG a ,PS_ISIR_SAR_XREF b WHERE a.aid_year = b.aid_year AND a.recname = b.recname AND a.fieldname = b.fieldname

  • Related Language Record for ISIR_FLD_SRCH

  • Parent record: AID_YEAR_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Prompt Table: AID_YEAR_TBL

    2 ISIR_FIELD_NUM Character(4) VARCHAR2(4) NOT NULL ISIR Field Num
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description