SDFILE: DIRECT LOAN FILE

ElementElement NameTableSQL Name
SDAAFAWD PERSDRTTSAWD_PER_CYT
SDAARSTU IDSDRTTSSTU_ID
SDAASSD FUNDSDRTTSFUND
SDAATSEQ NUMSDRTTSSEQ_NUM
SDACELO ORIG CNTRSDRTTSLO_ORIG_CNTR
SDACJLO DISB CNTRSDRTTSLO_DISB_CNTR
SDACOPROM CNTRSDRTTSPROM_CNTR
SDACPPAR CNTRSDRTTSPAR_CNTR
SDACSDISD CNTRSDRTTSDISB_CTR
SDAY0AWD PERIODSDRTTSAWD_PER
SDBAIORIG SIDSDRTTSORIG_STU_ID
SDBAJLN TYPESDRTTSLOAN_TYPE
SDBAKAWD YRSDRTTSAWD_YR_CCYY
SDBALLO SCHOOL CDSDRTTSLO_SCHOOL_CODE
SDBAMID SEQ NUMSDRTTSID_SEQ_NUM
SDBANPN SEQ NUMSDRTTSPN_SEQ_NUM
SDBATLOAN PERIOD CODESDRTTSLOAN_PER
SDBHTSTU SIGN DATESDRTTSSIGN_DT
SDBHVLOAN FEE RATE CHGSDRTTSFEE_RATE_CHG
SDBJTLOAN AMT REQSDRTTSLOAN_AMT_RQST
SDBJYLOAN AMT REQ CHGSDRTTSLOAN_AMT_RQST_CHG
SDBKELOAN AMT ELIGSDRTTSLOAN_AMT_ELIG
SDBKJLOAN AMT ELIG CHGSDRTTSLOAN_AMT_ELIG_CHG
SDBKOTRANS SERV DATESDRTTSTRANS_SERV_DT
SDBKTLN PD START DATESDRTTSLN_PD_START_DT
SDBKYLN PD START DT CHGSDRTTSLN_PD_START_DT_CHG
SDBLELN PD END DATESDRTTSLN_PD_END_DT
SDBLJLN PD END DATE CHGSDRTTSLN_PD_END_DT_CHG
SDBLOLOAN BDGTSDRTTSLOAN_BDGT
SDBLTLO TFCSDRTTSTOT_FMLY_CNTRIB
SDBLYVET BENSDRTTSVET_BEN
SDBMEOTHER AIDSDRTTSOTHER_AID
SDBMILOAN OFFSETSDRTTSLOAN_OFFSET
SDBMYORIG STATUSSDRTTSORIG_STATUS
SDBNEORIG DATESDRTTSORIG_DT
SDBNJORIG BATCH NUMSDRTTSORIG_BATCH_NUM_00
SDBNKCHG STATUSSDRTTSCHANGE_STATUS
SDBNLACK DATESDRTTSACKNOWLEDGE_DT
SDBNNLOAN CANC CODESDRTTSLOAN_CANCEL_CD
SDBNPLOAN CANC CODE CHGSDRTTSLOAN_CANCEL_CD_CHG
SDBNRLOAN CANC DATESDRTTSLOAN_CANCEL_DT
SDBNUCRED OVERRIDESDRTTSCREDIT_OVRD
SDBNWCRED DECISION DATESDRTTSCREDIT_DECISION_DT
SDBOBDELETE FLAGSDRTTSDELETE_FLAG
SDBOECHG BATCH NUMSDRTTSCHG_BATCH_NUM_00
SDBOIFEE RATESDRTTSFEE_RATE_01
SDBONFIRST TIME BORSDRTTSFIRST_TIME_BORR
SDBOQLO MNTDTSDRTTSMNTDT
SDBOTSW STATSDRTTSSW_STATUS
SDBOVSTU DEFAULT OVERSDRTTSSTU_DFLT_OVRD
SDBOYSTU DEFAULT OVER CHGSDRTTSSTU_DFLT_OVRD_CHG
SDBPCANTIC GROSS TOTSDRTTSANTIC_GROSS_TOT
SDBPGANTIC FEE TOTSDRTTSANTIC_FEE_TOT
SDBPJANTIC NET TOTSDRTTSANTIC_NET_TOT
SDBPMACT GROSS TOTSDRTTSACTL_GROSS_TOT
SDBPPACT FEE TOTSDRTTSACTL_FEE_TOT
SDBPSACT NET TOTSDRTTSACTL_NET_TOT
SDBPVADJ NET TOTSDRTTSADJ_NET_TOT
SDBPXPENDING DTSDRTTSPENDING_DT
SDBPZACCEPT REQ DTSDRTTSACCPT_RQST_DT
SDBQATRANS STATSDRTTSTRANS_STAT
SDBQDDISB PROC TO STUSDRTTSDISB_PROC_TO_STU
SDBQFORIG REJ 1SDRTTSORIG_REJ_1
SDBQHORIG REJ 2SDRTTSORIG_REJ_2
SDBQJORIG REJ 3SDRTTSORIG_REJ_3
SDBQLORIG REJ 4SDRTTSORIG_REJ_4
SDBQNORIG REJ 5SDRTTSORIG_REJ_5
SDBQTSERVICER CODESDRTTSSERVICER_CODE_X
SDBQUBOOKED DATESDRTTSBOOKED_DATE
SDBQVBOOKED STATSDRTTSBOOKED_STAT
SDBRALO BOOK REJ 1SDRTTSLO_BOOK_REJ_1
SDBRBLO BOOK REJ 2SDRTTSLO_BOOK_REJ_2
SDBRCLO BOOK REJ 3SDRTTSLO_BOOK_REJ_3
SDBRDLO BOOK REJ 4SDRTTSLO_BOOK_REJ_4
SDBRELO BOOK REJ 5SDRTTSLO_BOOK_REJ_5
SDBRFLO DISCL PRNT INDSDRTTSDISCL_PRNT_IND
SDBRGLO DISCL PRNT CHGSDRTTSDISCL_PRNT_CHG
SDBRHLO NEEDS DISCL INDSDRTTSNEEDS_DISCL_IND
SDBRILO DISCL PRNT DTSDRTTSDISCL_PRNT_DATE
SDBRJLO LOC MPN STATUSSDRTTSLOC_MPN_STATUS
SDBRKLO MPN ID LINKSDRTTSMPN_ID_LINK
SDBRLACAD START DATESDRTTSACAD_START_DATE
SDBRMACAD END DATESDRTTSACAD_END_DATE
SDBRNACAD START DATE CHGSDRTTSACAD_START_DT_CHG
SDBROACAD END DATE CHGSDRTTSACAD_END_DT_CHG
SDBRPMPN INDSDRTTSMPN_INDICATOR
SDBRQANTIC REBATE TOTSDRTTSANTIC_REBATE_TOT
SDBRRACT REBATE TOTSDRTTSACT_REBATE_TOT
SDBRSREBATE RATESDRTTSREBATE_RATE
SDBRTINT REBATE RATE CHGSDRTTSREBATE_RATE_CHG
SDBRUENDORSER AMTSDRTTSCRED_ENDORSER_AMT
SDBRVCREDIT DECISION STATSDRTTSCRED_DSN_STAT
SDBRWCPS TRANS NUMSDRTTSCPS_TRANS_NUM
SDBRXORIG EDIT1SDRTTSORIGIN_EDIT1
SDBRYORIG EDIT2SDRTTSORIGIN_EDIT2
SDBRZORIG EDIT3SDRTTSORIGIN_EDIT3
SDBSAORIG EDIT4SDRTTSORIGIN_EDIT4
SDBSBORIG EDIT5SDRTTSORIGIN_EDIT5
SDBY0AWD YYSDRTTSAWD_YR
SDDCEPN STATUSSDRTTSPROM_NOTE_STATUS
SDDCJPN PRNT INDSDRTTSPRNT_IND
SDDCTPN PRNT DATESDRTTSPRNT_DT
SDDDEPN REC DATESDRTTSRCVD_DT
SDDDOPN SHIP DATESDRTTSSHIP_DT
SDDDUPN BATCH IDSDRTTSBATCH_ID
SDDDVPN SCH CDSDRTTSSCHOOL_CODE
SDDDWPN BATCH DATESDRTTSBATCH_DT
SDDDXPN BATCH SEQSDRTTSBATCH_SEQ
SDDDYPN SRVCR CONF DATESDRTTSSRVCR_CONF_DT
SDDHEPN LAST TRANS DATESDRTTSLAST_TRANS_DT
SDDHLPN REJECT REASON1SDRTTSREJECT_REASON_1
SDDHMPN REJECT REASON2SDRTTSREJECT_REASON_2
SDDHNPN REJECT REASON3SDRTTSREJECT_REASON_3
SDDHOPN REJECT REASON4SDRTTSREJECT_REASON_4
SDDHPPN REJECT REASON5SDRTTSREJECT_REASON_5
SDDHQPN MNTDTSDRTTSPN_MNTDT
SDDHRPN PR SEQ NUMSDRTTSPN_PR_SEQ_NUM
SDDHSPN SHIP NUM 00SDRTTSBATCH_TYPE_00
SDDHUPN BATCH TYPE 00SDRTTSCYCLE_IND_00
SDDHVPN CYCLE IND 00SDRTTSSCHOOL_CODE_00
SDDHXPN BATCH DATE 00SDRTTSBATCH_DATE_00
SDDHYPN BATCH TIME 00SDRTTSBATCH_TIME_00
SDDHZPN LOAN AMT REQSDRTTSLOAN_AMT_REQ

©1999 All Rights Reserved