SGFILE: LOAN FILE

ElementElement NameTable or FileSQL or Focus
SGA05AWD YRSGETTSAWD_YR_CCYY
SGA15STU IDSGETTSSTU_ID
SGS02EFT LOAN NUMSGETTSLOAN_NUM
SGS03ET SUB SEQ NOSGETTSSUB_SEQ_NO
SGS04ET SUB GUAR AMTSGETTSSUB_GUAR_AMT
SGS05ET SUB NET TOTALSGETTSSUB_NET_TOT
SGS06ET SUB ANT GROSS1SGETTSSUB_ANT_GROSS1
SGS07ET SUB REC DT1SGETTSSUB_REC_DT1
SGS08ET SUB GROSS AMT1SGETTSSUB_GROSS_AMT1
SGS09ET SUB STAT1SGETTSSUB_STAT1
SGS10ET SUB NET AMT1SGETTSSUB_NET_AMT1
SGS11ET SUB RET AMT1SGETTSSUB_RET_AMT1
SGS12ET SUB ANT GROSS2SGETTSSUB_ANT_GROSS2
SGS13ET SUB REC DT2SGETTSSUB_REC_DT2
SGS14ET SUB GROSS AMT2SGETTSSUB_GROSS_AMT2
SGS15ET SUB STAT2SGETTSSUB_STAT2
SGS16ET SUB NET AMT2SGETTSSUB_NET_AMT2
SGS17ET SUB RET AMT2SGETTSSUB_RET_AMT2
SGS18ET SUB ANT GROSS3SGETTSSUB_ANT_GROSS3
SGS19ET SUB REC DT3SGETTSSUB_REC_DT3
SGS20ET SUB GROSS AMT3SGETTSSUB_GROSS_AMT3
SGS21ET SUB STAT3SGETTSSUB_STAT3
SGS22ET SUB NET AMT3SGETTSSUB_NET_AMT3
SGS23ET SUB RET AMT3SGETTSSUB_RET_AMT3
SGS24ET SUB ANT GROSS4SGETTSSUB_ANT_GROSS4
SGS25ET SUB REC DT4SGETTSSUB_REC_DT4
SGS26ET SUB GROSS AMT4SGETTSSUB_GROSS_AMT4
SGS27ET SUB STAT4SGETTSSUB_STAT4
SGS28ET SUB NET AMT4SGETTSSUB_NET_AMT4
SGS29ET SUB RET AMT4SGETTSSUB_RET_AMT4
SGS30ET SUB DISB STAT1SGETTSSUB_DISB_STAT1
SGS31ET SUB DISB STAT2SGETTSSUB_DISB_STAT2
SGS32ET SUB DISB STAT3SGETTSSUB_DISB_STAT3
SGS33ET SUB DISB STAT4SGETTSSUB_DISB_STAT4
SGS50ET OTH SEQ NOSGETTSOTH_SEQ_NO
SGS51ET OTH GUAR AMTSGETTSOTH_GUAR_AMT
SGS52ET OTH NET TOTALSGETTSOTH_NET_TOT
SGS53ET OTH ANT GROSS1SGETTSOTH_ANT_GROSS1
SGS54ET OTH REC DT1SGETTSOTH_REC_DT1
SGS55ET OTH GROSS AMT1SGETTSOTH_GROSS_AMT1
SGS56ET OTH STAT1SGETTSOTH_STAT1
SGS57ET OTH NET AMT1SGETTSOTH_NET_AMT1
SGS58ET OTH RET AMT1SGETTSOTH_RET_AMT1
SGS59ET OTH ANT GROSS2SGETTSOTH_ANT_GROSS2
SGS60ET OTH REC DT2SGETTSOTH_REC_DT2
SGS61ET OTH GROSS AMT2SGETTSOTH_GROSS_AMT2
SGS62ET OTH STAT2SGETTSOTH_STAT2
SGS63ET OTH NET AMT2SGETTSOTH_NET_AMT2
SGS64ET OTH RET AMT2SGETTSOTH_RET_AMT2
SGS65ET OTH ANT GROSS3SGETTSOTH_ANT_GROSS3
SGS66ET OTH REC DT3SGETTSOTH_REC_DT3
SGS67ET OTH GROSS AMT3SGETTSOTH_GROSS_AMT3
SGS68ET OTH STAT3SGETTSOTH_STAT3
SGS69ET OTH NET AMT3SGETTSOTH_NET_AMT3
SGS70ET OTH RET AMT3SGETTSOTH_RET_AMT3
SGS71ET OTH ANT GROSS4SGETTSOTH_ANT_GROSS4
SGS72ET OTH REC DT4SGETTSOTH_REC_DT4
SGS73ET OTH GROSS AMT4SGETTSOTH_GROSS_AMT4
SGS74ET OTH STAT4SGETTSOTH_STAT4
SGS75ET OTH NET AMT4SGETTSOTH_NET_AMT4
SGS76ET OTH RET AMT4SGETTSOTH_RET_AMT4
SGS77ET OTH DISB STAT1SGETTSOTH_DISB_STAT1
SGS78ET OTH DISB STAT2SGETTSOTH_DISB_STAT2
SGS79ET OTH DISB STAT3SGETTSOTH_DISB_STAT3
SGS80ET OTH DISB STAT4SGETTSOTH_DISB_STAT4

©2004 All Rights Reserved