LNDLCHGFLDVWLNG

(SQL View)
 Index Back

Dir Ln Chg # XREF Vw

LNDLCHGFLDVWLNG is the related language recordfor the record LN_DL_CHGFLD_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 A.AID_YEAR , A. DL_CHG_FIELD_NBR ,B.LANGUAGE_CD , B.DESCR FROM PS_LN_DL_CHG_XREF A , PS_LNDLCHGXREFLNG B WHERE A.AID_YEAR= B.AID_YEAR AND A.DL_CHG_FIELD_NBR =B.DL_CHG_FIELD_NBR AND A.CHG_FLD_STATUS='A' AND A.DL_CHG_TYPE='D'

  • Related Language Record for LN_DL_CHGFLD_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description