LN_DL_CHG_XREF

(SQL Table)
Index Back

Direct Loan Change # XREF

dl_chg_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.

  • Related Language Record: LNDLCHGXREFLNG
  • 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

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: FED_AID_YR_TBL

    2 DL_CHG_FIELD_NBR Character(4) VARCHAR2(4) NOT NULL Direct Loan Chg Field Number
    3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN

    4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: LN_TBL_VW

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: LN_DL_CHG_XREF.DESCR

    7 DL_CHG_FLD_LENGTH Number(2,0) SMALLINT NOT NULL Direct Loan Field Length
    8 DL_CHG_FLD_TYPE Character(2) VARCHAR2(2) NOT NULL Direct Loan Field Type
    A=Alpha
    AN=Alphanumeric
    D=Date
    N=Number
    SN=Signed Number
    9 CHG_FLD_STATUS Character(1) VARCHAR2(1) NOT NULL Change Field Status
    A=Active
    I=Inactive

    Default Value: A

    10 DL_CHG_TYPE Character(1) VARCHAR2(1) NOT NULL DL Change Type
    D=Demographic
    E=Eligibility
    F=Financial
    T=Date