SGFILE: LOAN FILE

ElementElement NameTableSQL Name
SGAY0AWD YYSGLNTSAWD_YR
SGA05AWD YRSGLNTSAWD_YR_CCYY
SGA15STU IDSGLNTSSTU_ID
SGN02LOAN NUMSGLNTSLOAN_NUM
SGN04APP RCVDSGLNTSAPP_RCVD
SGN07APP RCVD DTSGLNTSAPP_RCVD_DT
SGN08LENDRSGLNTSLENDR
SGN11GUARANTORSGLNTSGUARANTOR
SGN13CNSLRSGLNTSCNSLR
SGN16APP STATSGLNTSAPP_STAT
SGN19APP STAT DTSGLNTSAPP_STAT_DT
SGN22LN BEGIN DTSGLNTSBEGIN_DT
SGN25LN END DTSGLNTSEND_DT
SGN28ENTR STATSGLNTSENTR_STAT
SGN31EXIT STATSGLNTSEXIT_STAT
SGN34DISB DT 1SGLNTSDISB_DT_1
SGN35DISB DT 2SGLNTSDISB_DT_2
SGN36DISB DT 3SGLNTSDISB_DT_3
SGN37DISB DT 4SGLNTSDISB_DT_4
SGN42CMLN PROCESS TYPESGLNTSCMLN_PROCESS_TYPE
SGN43CMLN TYPE INDICATORSGLNTSCMLN_TYPE_INDICATR
SGN44CMLN STATUSSGLNTSCMLN_STATUS
SGN46RQST LOAN TYP 1SGLNTSRQST_LOAN_TYP_1
SGN47RQST LOAN TYP 2SGLNTSRQST_LOAN_TYP_2
SGN48RQST LOAN TYP 3SGLNTSRQST_LOAN_TYP_3
SGN49RQST LOAN TYP 4SGLNTSRQST_LOAN_TYP_4
SGN51BEGIN RQST DTSGLNTSBEGIN_RQST_DT
SGN54END RQST DTSGLNTSEND_RQST_DT
SGN56LOAN PREV RCVDSGLNTSLOAN_PREV_RCVD
SGN58DEFER OPTSGLNTSDEFER_OPT
SGN60CAP BII OPTSGLNTSCAP_OPT
SGN62LICENSE STSGLNTSLICENSE_ST
SGN64LICENSE NUMSGLNTSLICENSE_NUM
SGN66VET BENSGLNTSVET_BEN
SGN68LN OTHER AIDSGLNTSLN_OTHER_AID
SGN70SUB FSL AMTSGLNTSSUB_FSL_AMT
SGN72UNSUB FSL AMTSGLNTSUNSUB_FSL_AMT
SGN74SLS PLUS AMTSGLNTSSLS_PLUS_AMT
SGN76U S P OFFSET AIDSGLNTSU_S_P_OFFSET_AID
SGN78U S P DIFFSGLNTSU_S_P_DIFF
SGN80SUB FSL GAMTSGLNTSSUB_FSL_GAMT
SGN82UNSUB FSL GAMTSGLNTSUNSUB_FSL_GAMT
SGN84SLS PLUS GAMTSGLNTSSLS_PLUS_GAMT
SGN86GUARANTEE DTSGLNTSGUARANTEE_DT
SGN88FRST TIME BORRSGLNTSFRST_TIME_BORR
SGN90SUPL IDSGLNTSSUPL_ID
SGO01STU STATSGLNTSSTU_STAT
SGO04RAP CDSGLNTSRAP_CD
SGO07ACCUM HOURSSGLNTSACCUM_HOURS
SGO10LN CUM GPASGLNTSCUM_GPA
SGO13LN DEPEN STATSGLNTSDEPEN_STAT
SGO16ADJ GROSS INCOMESGLNTSADJ_GROSS_INCOME
SGO19EXPCT GRAD DTSGLNTSEXPCT_GRAD_DT
SGO22SG LN DEGSGLNTSDEGREE
SGO23MAJORSGLNTSMAJOR
SGO25CLASS LEVELSGLNTSCLASS_LEVEL
SGO28COLLEGESGLNTSCOLLEGE
SGO31ENRL STATSGLNTSENRL_STAT
SGO34LOAN OPT 1SGLNTSLOAN_OPT_1
SGO37LOAN OPT 2SGLNTSLOAN_OPT_2
SGO40NUM IN COLLSGLNTSNUM_IN_COLL
SGO43LOAN BDGTSGLNTSLOAN_BDGT
SGO47FSL OFFSET AIDSGLNTSFSL_OFFSET_AID
SGO49LOAN TFCSGLNTSLOAN_TFC
SGO53FSL LOAN DIFFSGLNTSFSL_LOAN_DIFF
SGO55NON NEED AIDSGLNTSNON_NEED_AID
SGO56LOAN PERSGLNTSLOAN_PER
SGO57LN GSL RQSTSGLNTSLN_GSL_RQST
SGO58LN GSL UNPD TOTSGLNTSLN_GSL_UNPD_TOT
SGO59LN GSL UNPD LSTSGLNTSLN_GSL_UNPD_LST
SGO60LN GSL INT RATESGLNTSLN_GSL_INT_RATE
SGO61LN GSL LST BGN DTSGLNTSLN_GSL_LST_BGN_DT
SGO62LN GSL LST END DTSGLNTSLN_GSL_LST_END_DT
SGO63LN GSL LST CLASSSGLNTSLN_GSL_LST_CLASS
SGO65LN RQST AMTSGLNTSLN_RQST_AMT
SGO66CURRENT PLUSSGLNTSCURRENT_PLUS
SGO67CURRENT CONSOLSGLNTSCURRENT_CONSOL
SGO68TRANSMIT DATESGLNTSTRANSMIT_DT
SGO69EFT RELEASESGLNTSEFT_RELEASE
SGO70CMLN STATUS DATESGLNTSCMLN_STATUS_DATE
SGO71CMLN ERROR 1SGLNTSCMLN_ERROR_1
SGO72CMLN ERROR 2SGLNTSCMLN_ERROR_2
SGO73CMLN ERROR 3SGLNTSCMLN_ERROR_3
SGO74CMLN ERROR 4SGLNTSCMLN_ERROR_4
SGO76CMLN INCR CODESGLNTSCMLN_INCR_CODE
SGO77CMLN RECIP XREFSGLNTSCMLN_RECIP_XREF
SGQ01CMLN ERROR 5SGLNTSCMLN_ERROR_5
SGQ02FED APP FORM CDSGLNTSCMLN_FED_APP_FORM
SGQ03CMLN CHG FLAGSGLNTSCMLN_CHG_FLAG
SGQ04CMLN CHG DATE SENTSGLNTSCHG_DATE_SENT
SGQ05CMLN HLD RLSE IND1SGLNTSHLD_RLSE_IND_1
SGQ06CMLN HLD RLSE IND2SGLNTSHLD_RLSE_IND_2
SGQ07CMLN HLD RLSE IND3SGLNTSHLD_RLSE_IND_3
SGQ08CMLN HLD RLSE IND4SGLNTSHLD_RLSE_IND_4
SGQ09HLD RLSE IND STAT1SGLNTSHLD_RLSE_IND_STAT1
SGQ10HLD RLSE IND STAT2SGLNTSHLD_RLSE_IND_STAT2
SGQ11HLD RLSE IND STAT3SGLNTSHLD_RLSE_IND_STAT3
SGQ12HLD RLSE IND STAT4SGLNTSHLD_RLSE_IND_STAT4
SGQ13CMLN SERIAL LN CDSGLNTSSERIAL_LOAN_CD
SGQ14CMLN MPN CONFIRM CDSGLNTSMPN_CONFIRM_CD
SGQ15CMLN INCREMENT CDSGLNTSINCR_CD
SGQ16CMLN UNIQUE IDSGLNTSCLUID_1_11
SGQ17ALT LN PRG TY CDSGLNTSALT_PROG_TYP_CD
SGQ18ALT BORR IND CDSGLNTSALT_STU_BRWR_IND
SGQ19ALT AMTSGLNTSALT_AMT
SGQ20ALT GAMTSGLNTSALT_GAMT
SGQ21GAMTSGLNTSGAMT
SGQ22REC TYPE CDSGLNTSREC_TYPE_CD
SGQ23BRWR SIGNATURE CODESGLNTSBRWR_SIGN_CD
SGQ24STU SIGNATURE CODESGLNTSSTU_SIGN_CD
SGQ25BORROWER CRED AUTHSGLNTSBRWR_CRED_AUTH
SGQ26PROM NOTE DELIVERYSGLNTSPROM_NOTE_DELV
SGQ27GUARANTOR STATSGLNTSGUARANTOR_STAT
SGQ28LENDER SRVCR STATSGLNTSLENDER_SRVCR_STAT
SGQ29PROM NOTE STATSGLNTSPROMNOTE_STAT
SGQ30CREDIT STATSGLNTSCREDIT_STAT
SGQ31LENDER USESGLNTSLENDER_USE
SGQ32GUARANTOR USESGLNTSGUARANTOR_USE
SGQ33ESIG SOURCESGLNTSESIG_SOURCE

©1999 All Rights Reserved