SNFILE: PROMISSORY NOTE FILE

ElementElement NameTableSQL Name
SNAACMPN SIDSNRTTSSID
SNAAEMPN LOAN TYPESNRTTSLOAN_TYPE
SNAAGMPN YEARSNRTTSYEAR
SNAAIMPN SCHL CODESNRTTSSCHL_CODE
SNAAKMPN ID SEQ NUMSNRTTSID_SEQ_NUM
SNAAMMPN PN SEQ NUMSNRTTSPN_SEQ_NUM
SNAAPPNOTE STATSNRTTSSTAT
SNAARPNOTE ACCEPT LN AMTSNRTTSACCEPT_LOAN_AMT
SNAATPNOTE REQ LOAN AMTSNRTTSREQ_LOAN_AMT
SNAAVPNOTE PRINT INDSNRTTSPRINT_INDICATOR
SNAAWPNOTE PRINT DATESNRTTSPRINT_DATE
SNAAXPNOTE RECEIVE DATESNRTTSRECEIVE_DATE
SNAAYPNOTE ACTIVITYSNRTTSACTIVITY
SNAAZPNOTE SHIP DATESNRTTSSHIP_DATE
SNAA5PROM NOTE SIDSNRTTSSTU_ID
SNAA6PROM NOTE SEQ NUMSNRTTSSEQ_NUM
SNABAPNOTE REJ REASON 2SNRTTSREJECT_REASON2
SNABBPNOTE REJ REASON 3SNRTTSREJECT_REASON3
SNABCPNOTE REJ REASON 4SNRTTSREJECT_REASON4
SNABDPNOTE REJ REASON 5SNRTTSREJECT_REASON5
SNABESTU SIGN DATESNRTTSSTU_SIGNED_DATE
SNABFPLUS BRWR SSNSNRTTSBORROWER_SSN
SNABGPPROM NOTE EDIT1SNRTTSPN_EDIT1
SNABHPPROM NOTE EDIT2SNRTTSPN_EDIT2
SNABIPPROM NOTE EDIT3SNRTTSPN_EDIT3
SNABJPPROM NOTE EDIT4SNRTTSPN_EDIT4
SNABKPPROM NOTE EDIT5SNRTTSPN_EDIT5
SNAB0PNOTE REJ REASON 1SNRTTSREJECT_REASON1
SNAB2PNOTE BATCH TYPESNRTTSBATCH_TYPE
SNAB3PNOTE CYCLE INDSNRTTSCYCLE_IND
SNAB4PNOTE SCHOOL CODESNRTTSSCHOOL_CODE
SNAB5PNOTE BATCH DATESNRTTSBATCH_DATE
SNAB6PNOTE BATCH TIMESNRTTSBATCH_TIME
SNAB7PNOTE ACK DATESNRTTSACK_DATE
SNAB8PNOTE LAST TRAN DATESNRTTSLAST_TRANS_DATE
SNC00SN PN CTRSNRTTSLOAN_ID_CNTR
SNC10SN PN MNTDTSNRTTSMNTDT

©1999 All Rights Reserved