LN_DL_CHGFLD_VW

(SQL View)
 Index Back

Dir Ln Chg # XREF Vw

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.

SELECT AID_YEAR, DL_CHG_FIELD_NBR, RECNAME, FIELDNAME, DESCR FROM PS_LN_DL_CHG_XREF WHERE CHG_FLD_STATUS='A' AND DL_CHG_TYPE='D'

  • Related Language Record: LNDLCHGFLDVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
    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