ISIR_SAR_XREF

(SQL Table)
 Index Back

ISIR/SAR Question # XREF

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.

  • Related Language Record: ISIRSARXREFLNG

  • Parent record: FED_AID_YR_TBL

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

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: FED_AID_YR_TBL

    2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    4 ISIR_FIELD_NUM Character(4) VARCHAR2(4) NOT NULL ISIR Field Num
    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    6 FAFSA_QUESTION_NUM Character(4) VARCHAR2(4) NOT NULL FAFSA Question Number
    7 ISIR_START_POS Number(4,0) SMALLINT NOT NULL ISIR Record Displacement
    8 ISIR_FIELD_LENGTH Number(4,0) SMALLINT NOT NULL ISIR Field Length
    9 ISIR_FIELD_TYPE Character(1) VARCHAR2(1) NOT NULL ISIR Field Type
    A=Alpha Numeric
    D=Date (MMDDYY)
    M=Date (MMYY)
    N=Numeric
    S=Signed Numeric
    X=Mixed Case
    Y=Date (Batch Year)
    10 ISIR_CORR_TO_BLANK Character(1) VARCHAR2(1) NOT NULL Correctable to Blank

    Y/N Table Edit

    11 DESCR Character(30) VARCHAR2(30) NOT NULL Description

    Default Value: PSDBFIELD.FIELDNAME