NSLDS Data Map

NSLDS Production Physical Data Model
PREF_SCH
STU_SEQ_NO
STU_DEM_CALNDR_YR
SCH_CODE
STU_NO
SCH_BR_CODE
NO

STU_NO
STU_SEQ_NO
ATT_SCH_CODE
ATT_SCH_BR_CODE
TYPE
AWARD_YR

SCH_CODE
SCH_BR_CODE
CLOS_DT
SYS_CR_DT

TM_INFRM_RUN_ERR

TM_INFRM_RUN_HIS

SCH_CODE
SCH_BR_CODE
TM_EVT_BEG_TSTAMP
OPEID
SSN
FST_NM
LST_NM
DOB
ENRL_BEG_DT
TM_BEG_DT
FLD_IN_ERR_CD
ERR_CD

SCH_CODE
SCH_BR_CODE
TM_EVT_BEG_TSTAMP
END_TSTAMP
SBMTL_DT
SBMTL_SEQ_NO
REC_CNT
ERR_CNT
ERR_REC_CNT
WRN_CNT
WRN_REC_CNT

APPL_FST_NM
APPL_CURR_SSN
APPL_LST_NM
APPL_CPS_DOB
APPL_CPS_AWARD_YR
RSLT_SEQ_NO
SEQ_NO

PRSCRN_RSLT
APPL_LST_NM
APPL_FST_NM
APPL_CPS_DOB
APPL_CPS_AWARD_YR
APPL_CURR_SSN
SEQ_NO

OPE_ID
SCHED_AMT
AMT_PAID_TO_DT
REMN_AMT_TO_PAY
PCT_ELIG_USED_DECM
TRAN_NO
LST_DIS_DT_TEXT
STU_NO
STU_SEQ_NO
SCH_CD
SCH_BR_CD
PELL_GRT_TYPE
PELL_GRT_AWARD_YR
ACCPT_VRFY_STAT
EXP_FAM_CONTRIB
PELL_AWARD_AMT
PELL_POST_DT_TEXT

SCH_BR_CODE_XREF
CODE
MNG_PROG_TYPE
SCH_CODE
SCH_BR_CODE

SCH_BR_OTH_ADD
SCH_CODE
SCH_BR_CODE
ADD_TYPE
SYS_CR_DT
SEQ_NO

SCH_CODE
CODE
PRSCRN_APPL
CURR_SSN
FST_NM
LST_NM
CPS_DOB
CPS_AWARD_YR

SSCR_CYCLE
SCH_CODE
SCH_BR_CODE
CYCLE_NO

SCH_BR_DUNS_NO
SCH_BR_DLOAN_ORIGN

SCH_CODE
SCH_BR_CODE
SYS_BEG_DT
TYPE
NO

RQRD_IND
DT_LST_GEN

SCH_CODE
SCH_BR_CODE
AWARD_YR
SYS_CR_DT

SCH_CODE
SCH_BR_CODE
EXPR_TYPE_CODE
SYS_BEG_DT
SEQ_NO

SCH_BR_PROG
SCH_CODE
SCH_BR_CODE
PROG_CODE
START_DT
APPR_IND
SYS_BEG_DT

EXPR_TYPE_START_DT
EXPR_TYPE_END_DT
VAL_IND

RUN_DT_CR
LST_SEQ_NO_USED
LST_MTCH_RSLT_IND

START_DT
END_DT
ORIGN_LVL
ORIGN_END_RSN
PROG_END_RSN
VAL_IND

SYS_END_DT

SCH_BR_EXPR

END_DT
SYS_END_DT

TM_EVT
BEG_TSTAMP
METHOD
TYPE
AGT

SCH_BR_ADMIN_CON
SSCR_WAIV

SCH_CODE
SCH_BR_CODE
TYPE
SYS_BEG_DT
SEQ_NO

SCH_CODE
SCH_BR_CODE
UPDT_USER_ID
APPR_BY
APPR_DT
BEG_DT
END_DT

SYS_END_DT
FST_NM
LST_NM
INT_ADD

ANTIC_COMPL
CERT

TM_ALRT_RUN_HIS
SCH_CODE
SCH_BR_CODE
TM_EVT_BEG_TSTAMP

STU_NO
STU_SEQ_NO
SCH_CODE
SCH_BR_CODE
BEG_TSTAMP
SRC_TYPE
SRC_CODE
SRC_BR_CODE

STU_NO
STU_SEQ_NO
SCH_CODE
SCH_BR_CODE
BEG_TSTAMP

RUN_DT
RUN_TM
CPS_SBMT_DT
CPS_CMPT_NO
CPS_ORIG_SSN
CPS_NM_ID
CPS_TRAN
CPS_BAT_NO
CPS_SER_NO
ADDL_LOAN_FLAG
ADDL_PELL_FLAG
MTCH_RSLT_IND
DCSD_FLAG
DEF_LOAN_FLAG
ACT_BNKRPT_FLAG
DSCHG_LOAN_CODE
SAT_ARRNG_FLAG
AGG_SUB_OPB
AGG_UNSUB_PRIN_BAL
AGG_CONSL_PRIN_BAL
AGG_SUB_PEND_DIS
AGG_UNSUB_PEND_DIS
AGG_SUB_TOT
AGG_UNSUB_TOT
AGG_CONSL_TOT
PERK_TOT_DIS
PERK_CURR_YR_DIS
PERK_EXP_LEN_FLAG
PERK_DIS_PRIOR_FLG
PELL_OVRPMT_IND
PELL_OVRPMT_CON_CD
SEOG_OVRPMT_IND
SEOG_OVRPMT_CON_CD
PERK_OVRPMT_IND
PERK_OVRPMT_CON_CD
DEF_LOAN_CHG_FLAG
DSCHG_LOAN_CHG_FLG
SAT_ARRNG_CHG_FLAG
ACT_BNKRPT_CHG_FLG
OVRPMT_CHG_FLAG
AGG_CHG_FLAG
PERK_CHG_FLAG
PELL_CHG_FLAG
PTSCRN_REQ_DT
PTSCRN_REQ_RSN_CD
PTSCRN_CPS_RJCT_CD
STU_NO
STU_SEQ_NO
PLUS_BOR_NO
PLUS_BOR_SEQ_NO
AGG_CMBN_TOT
AGG_CMBN_PND_DIS
AGG_CMBN_OUT_PRIN
DL_STFRD_MPN_CODE
FFEL_MPN_FLAG
FFEL_MPN_LEN_CODE
ACAD_LVL
CPS_RCD_TYPE
CPS_SEQ_NO

SCH_BR

NM
STR_ADD
CITY
ST
CNTRY
ZIP_CODE
SCH_NM
ELIG_STAT_IND
APPR_IND
CONG_DIS
SIC_CODE
FAADS_CODE
CNTY_CODE
FORN_PROV_NM
ACAD_CALNDR
SRTY
ED_REG_CODE
LOC_RSN
CURR_PELL_ID
CURR_FFEL_ID
CURR_FDSLP_ID
CURR_CMPS_BASED_ID
CURR_FED_SCH_CODE
CURR_TIN
COA_ACTN_CODE
SCH_PROG_LGTH
CLOSE_DT
DSPR_DT
PPA_EXEC_DT
PPA_SENT_DT
PPA_EXPR_DT
INIT_APPR_DT

STAT_DT
STAT_IND
BILL_GP_ID
DISK_FMT
TAPE_FMT
FST_NM
LST_NM
USER_ORG
USER_ADD_LINE_1
USER_ADD_LINE_2
CITY
ST
ZIP_CODE
GES_USER_ID
PH_NO
GES_ACCT
LOC_GP_SYS_TSTAMP
USER_TYPE
GES_MODE
USER_TITL
NSLDS_SVR_ID
CNTRY_CODE

PRSCRN_RSLT_PELL

FLD_IN_ERR_VAL

ACTN_CODE
ACTN_RSN_CODE
VAL_IND

DT
METHOD
END_TSTAMP

DT
END_TSTAMP

AID_OVRPMT
STU_NO
STU_SEQ_NO
SCH_CODE
SCH_BR_CODE
AID_TYPE
DIS_DT
OVRPMT_IND
RPMT_DT
UPDT_USER_ID
SYS_CR_DT
UPDT_DT
SRC
REG_CODE
INACT_IND

STU_NO
STU_SEQ_NO
SCH_CODE
SCH_BR_CODE
EFF_DT
SRC

STU_NO
STU_SEQ_NO
SCH_CODE
SCH_BR_CODE
BEG_TSTAMP
SRC_TYPE
SRC_CODE
SRC_BR_CODE

NSLDS_ID

TM_SCH_XFER_PROF
LEN_BR_TRAN_HIS

SCH_BR_WEB_ADD

SCH_CODE
SCH_BR_CODE
JOB_TSTAMP

WEB_PG_ADD
VAL_IND

STU_NM
STU_NO
STU_SEQ_NO
FST
LST

SCH_CODE
SCH_BR_CODE
DESC_ID
DESC_DET_ID
RPT_BEG_DT
RPT_END_DT

NSLDS_ID
TRAN_LOG_CODE
TRAN_LOG_TSTAMP
CODE

LOAN_VOL
DOL_VOL
SYS_CR_DT

RPT_PARM

RMDS_FORM_ID
UID
RPT_TYPE
RPT_NM
FUT
OPUT_CLASS
SORT_CNTL_MEM
JCL_MEM
PROC_IND
BAT_TSTAMP
END_TSTAMP
LOC_GP_SYS_TSTAMP
DEST_ID
PRT_NM
NODE_NM

NM
WEB_RPT_DEST
DEST_ID

WEB_USER_DEST
LOC_GP_SYS_TSTAMP
WEB_RPT_DEST_ID
USER_TYPE

AVAIL
OPUT_CLASS
PRT_NM
NODE_NM
DESCN

ACC_CNT

INSUR_CL_PMT

ATTR
ENT_NM
NM

SCHED_AMT
AMT_PAID_TO_DT
REMN_AMT_TO_PAY
AWARD_YR
PCT_ELIG_USED
TRAN_NO
LST_DIS_DT_TEXT
ACCPT_VRFY_STAT
EXP_FAM_CONTRIB
AWARD_AMT
OPEID
PELL_CHG_FLAG
REV_BY_NM
REV_DT
STU_NO
STU_SEQ_NO
PELL_SCH_CODE
PELL_SCH_BR_CODE
PELL_GRT_TYPE
PELL_GRT_AWARD_YR
PELL_POST_DT_TEXT

USER_RPT_PREF
RPT_ID
NSLDS_ID
SEQ_NO
DEST_ID
SORT_SEQ
CR_DT
SPLIT_IND

TM_STU_ALRT_NM
TM_STU_ALRT_OVRPMT
TM_STU_SSN
TM_STU_SSN
SCH_CODE
SCH_CODE
SCH_BR_CODE
TM_EVT_BEG_TSTAMP SCH_BR_CODE
TM_STU_BEG_TSTAMP TM_EVT_BEG_TSTAMP
TM_STU_BEG_TSTAMP
TM_STU_FST_NM
TM_STU_FST_NM
TM_STU_LST_NM
TM_STU_LST_NM
TM_STU_DOB
TM_STU_DOB
TM_STU_ALRT_CR_TS
TM_STU_ALRT_CR_TS
SEQ_NO
SEQ_NO
FST_NM
OVRPMT_TYPE
MID_INIT
OVRPMT_IND
LST_NM
AWARD_YR
OVRPMT_CON

RPT_FORM

RPT_PARM_RPT_ID
RPT_PARM_TSTAMP
SEQ

LOC_GP_SYS_TSTAMP
RPT_PROF_RPT_ID
RMDS_RPT_FORM_ID

TYPE
SHIFT
GES_PROD_ID
GES_PROD_DESCN
SERV_UNIT
UNIT_PRICE
END_EFF_DT

LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
LEN_CODE
LEN_BR_CODE
LEN_HOL_SYS_CR_DT
LEN_HOL_SEQ_NO
SYS_CR_DT
SEQ_NO

SCH
CODE
SYS_CR_DT
PROG_LGTH
SCH_TYPE
NM
ETNC_CODE
TYPE_AND_CNTL
CERT_TYPE
DEG_GRT_IND
ST
MO_RES_USAGE
BILL_USER_ID
CAPT_IN_CALNDR_MO
CAPT_IN_CALNDR_YR
RES_SHIFT
RES_TYPE

RPT_PARM_PROF_VAL
RPT_PARM_PROF_SEQ
RPT_PROF_RPT_ID
PARM_VAL_CODE
VAL

NUM_VAL
CHAR_VAL
DT_VAL

ORIG_USER_ID
QTY
EXT_COST
INV_IND
INV_CALNDR_YR
INV_CALNDR_MO
BILL_GP_ID

DSPL_TEXT

LOAN_GUA

DEG_TYPE_CNTL_HIS
SCH_CODE
SYS_CR_DT

SCH_ORIGN_HIS

TYPE
CNTL
DEG_GRT_IND

SCH_CODE
ORIGN_EFF_DT

LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
SEQ_NO
GA_CODE
RESP_BEG_DT

RPT_PROF
RPT_ID
RPT_DESCN
RPT_TYPE
JCL_MEM
STAT
RPT_TEXT
COLL

SYS_CR_DT
CUM_PRIN_AMT
CUM_INT_AMT
PRIN_AMT_DIFF
INT_AMT_DIFF

SPA_PMT
LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
LOAN_GUA_SEQ_NO
GA_CODE
GA_RESP_BEG_DT
DT
CUM_AMT
AMT_DIFF

LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
LOAN_GUA_SEQ_NO
GA_CODE
GA_RESP_BEG_DT
DT

ID

TRAN_CODE
MENU_ID

SUPP_REINSUR_PMT
LOAN_NO
ID_STU_SEQ_ID
LOAN_SEQ_NO
LOAN_GUA_SEQ_NO
GA_CODE
GA_RESP_BEG_DT
SEQ_NO
SYS_CR_DT

AGG_DESC_DET
DESC_ID
ID

MENU_DESCN
SUB_MENU_ID
SUB_MENU_TRAN_CODE

AGG_DESC

DEST_NM
STR_ADD
CITY
ST
ZIP_CODE_5
ZIP_CODE_4
CON_FST_NM
CON_MID_INIT
CON_LST_NM
INV_IND
EXEC_THRSH
STAT_IND
STAT_DT

ID
AGGR_NM
FREQ

RSN_CODE
REQ_DT
CUM_REQ_AMT
OTH_FEES_END_BAL
REQ_AMT_DIFF

RPT_SECUR

USER_FUNC
FUNC_GP_SYS_TSTAMP FUNC_GP_SYS_TSTAMP
RPT_PROF_RPT_ID
NSLDS_USER_ID
FUT

GA_CODE
AGG_DESC_ID
AGG_DESC_DET_ID
RPT_BEG_DT
RPT_END_DT
SYS_CR_DT
SYS_CR_TM
SRC
FEE_RT

DESC_ID
ITEM_NM
VAL
DESC_DET_ID
SYS_CR_DT

RPT_PROF_ID
SEQ
SORT_DESCN
SORT_CNTL_MEM

AGG_PURP

AGG_DESCN

DESC_ID
ID

WEB_LNK_NM
FUNC_GP_SYS_TSTAMP

DESC_ID
ID

DESCN_LINE

DESCN_LINE

FUT

AGG_MENU_DESC

DSPL_ORD

AGG_MENU_TRAN_CODE
DESC_ID
MENU_ID
SYS_CR_DT

SVR_CODE
DESC_ID
DESC_DET_ID
RPT_BEG_DT
RPT_END_DT

NO
AMT
CMPT_TYPE

GA
CODE
NM
STR_ADD
CITY
ST
ZIP_CODE
ACT_CODE
NM_ABBR

SCH_BR_SVR

NM

SYS_CR_DT

FUT
REINSUR_CL_PMT

REINSUR_CL_RFD
LOAN_NO
LOAN_NO
ID_STU_SEQ_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
LOAN_SEQ_NO
LOAN_GUA_SEQ_NO LOAN_GUA_SEQ_NO
GA_CODE
GA_CODE
GA_RESP_BEG_DT GA_RESP_BEG_DT
FILE_DT
DT

WEB_LNK
NM
DESCN
TRAN_CODE_XREF

SYS_CR_DT
CUM_AMT
AMT_DIFF

WEB_GP_LNK
WEB_PG_GP_NM
WEB_LNK_NM
ACC_TYPE

WEB_PG_GP
NM
DESCN

IRS_OFF
LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
LOAN_GUA_SEQ_NO
GA_CODE
GA_RESP_BEG_DT
SEQ_NO
SYS_CR_DT

MSG_FUNC_GP
MSG_ID
MSG_LINE_NO
FG_SYS_CR_TSTAMP
CMD_CMD
CMD_TRAN

LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
D_SYS_CR_DT
USAGE_IND

GA_AGG

AGG_ORG
NM
TYPE

LOAN_VOL
DOL_VOL
SYS_CR_DT

ED_REG_CODE
DESC_ID
DESC_DET_ID
RPT_BEG_DT
RPT_END_DT
LOAN_VOL
DOL_VOL
SYS_CR_DT

APPEAL_REQ

CON_TYPE
FUNC_GP_SYS_TSTAMP
LOC_GP_SYS_TSTAMP

PRIO
FROM_DT
TO_DT
TEXT0

AUTH_ID
CARE_OF_LST_NM
ORIG_DT
MEDIA_TYPE
SCO
DT_FUFILLD
EXEC_PRIO
CARE_OF_FST_NM
MEDIA_FMT
REQ_TYPE

STR_ADD
CITY
ST
ZIP_CODE
CNTRY

TYPE_DESCN

LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
LEN_CODE
LEN_BR_CODE
LEN_HOL_SYS_CR_DT
LEN_HOL_SEQ_NO
RESP_BEG_DT
SVR_CODE

ST
DESC_ID
DESC_DET_ID
RPT_BEG_DT
RPT_END_DT
SUBST_EFF_RNG
DEF_RT_RUN_TSTAMP
BEG_DT
END_DT

SUSP_HIS

LOAN_VOL
DOL_VOL
SYS_CR_DT

HIS_RUN_TSTAMP
SYS_CR_TSTAMP
CODE
EXTR_DT
AUTH_ID
USER_LST_NM
USER_FST_NM

LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
NSLDS_USER_ID

STAT
STAT_DT

THRSH_USAGE
EXCEPT_BILL_UID
EXCEPT_START_TM
EXCEPT_START_DT
EXCEPT_JOB_NM
RES_SHIFT
RES_TYPE

RUN_TSTAMP
RT_TYPE
CAL_REQ_SYS_TSTAMP
ORG_SYS_TSTAMP
COH_YR
OFFC_RT_IND
FORM_ID
DEF_HIS_RUN_TSTAMP
RT_SUB_TYPE
FFEL_NUM
FFEL_DENOM
FFEL_DOL_IN_RPMT
FFEL_DOL_IN_DEF
FFEL_TOT_CL_AMT
DIR_NUM
DIR_DENOM
DIR_DOL_IN_RPMT
DIR_DOL_IN_DEF
DUAL_NUM

BILL_USER_ID
JOB_NM
START_DT
START_TM

PEPS_CR_DT
SEQ_NO
TOT_RCD_PROC
RUN_ERR_TOT
STAT
SYS_CR_TSTAMP

DESC_ID
DESC_DET_ID
RPT_BEG_DT
RPT_END_DT

ACCT_CALNDR_YR
ACCT_CALNDR_MO
ORIG_USER_ID
STOP_DT
STOP_TM
BILL_GP_ID

LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
LOAN_STAT_BEG_DT
LOAN_STAT_SEQ_NO

QTY
OPER_ID
ACCT_CALNDR_YR
ACCT_CALNDR_MO
STAT
RPT_ID

PROV_CODE
SOFT_VER
STAT
RCD_CNT
ERR_CNT
ACCT
USER_ID
MSG_KEY
MSG_LGTH
RCD_LGTH
TRANS_MODE
OPER_ID
UPDT_DT
UPDT_TM
LST_SEQ_USED
REC_DT

CODE
ID_STU_SEQ_NO
SEQ_NO
EVT_DT
NEW_NUM
OLD_NUM
NEW_CHAR
OLD_CHAR

NSLDS_ID
SRC

LOAN_AUD_SUPP
ONLN_LA_TRAN_CODE
ONLN_LA_TSTAMP
ONLN_LA_FIELD_CODE
NEW_LNG_CHAR

GA_ERR_NOTIF_HIS
ID
LTR_TYPE
FST_LTR_SENT_IND
FST_LTR_SENT_DT
FST_LTR_SBMTL_DT
SEC_LTR_SENT_IND
SEC_LTR_SENT_DT
SEC_LTR_SBMTL_DT
THIRD_LTR_SENT_IND
THIRD_LTR_SENT_DT
THIRD_LTR_SBMTL_DT

LTR_RECP
LTR_REQ_FUNC_ID
LTR_REQ_TYPE
ID
JOB_TITL
COPY_CNT
DEST_ID

LTR_TEXT
LTR_REQ_FUNC_ID
LTR_REQ_TYPE
LTR_RECP_ID
LINE_NO
NON_COLL_LOAN

LINE_TEXT

NO
ID_STU_SEQ_NO
SEQ_NO

LTR_TEXT_PARM
GA_SBMTL_HIS

LTR_REQ_FUNC_ID
LTR_REQ_TYPE
LTR_RECP_ID
LTR_TEXT_LINE_NO
TEXT_PARM_SEQ_NO

CURR_LOAN_STAT
ACAD_LVL
OUT_PRIN_BAL
OUT_PRIN_BAL_DT
ED_REG_CODE
STU_NO
SCH_CODE
SCH_BR_CODE
GA_CODE
LOAN_TYPE
STU_SEQ_NO

SCHED_SBMTL_DT
CODE
ACT_SBMTL_DT
ALL_ERR_RESLV_DT
STAT
LVL_THREE_ERR_TOT
LVL_TWO_ERR_TOT
LVL_ONE_ERR_TOT
TOT_RCD_PROC
CUM_RUN_TOT
CUM_ERR_CNT
NOTIF_HIS_ID
ERR_RT
DAY_LT
JOB_COMPL_DT
JOB_COMPL_TM
FREQ_IND
RECD_DT
INIT_IND

SYS_CR_DT
TEXT_PARM
SEQ_NO
TYPE
PARM_VAL
PARM_LGTH

PERK_ARCH_SUM
LOAN_TYPE
STU_NO
STU_SEQ_NO

STU_CURR_SSN
STU_CUR_PSEUDO_IND
STU_CURR_FST
STU_CURR_LST
STU_MID_INIT
STU_DOB
STU_BR_ID_CODE
ENRL_CODE
ENRL_EFF_DT
ANTIC_COMPL_DT
CERT_DT

ACAD_LVL
TOT_DIS

LOAN_SUPP

STU_NO
STU_SEQ_NO
PORT_PROV_CODE
PORT_PROV_BR_CODE
PORT_TYPE
PORT_FUNC
SSCR_EVT_TSTAMP

FORM_INSUR_CL_CODE

LOAN_RPMT_PLAN

FORM_ID
VAL_TRSL_LKUP_NM
VAL_TRSL_LKUP_ID

LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
DT_ENTR_RPMT

PORT_PARTIC_FCD

PORT_PARTIC

END_EVT_TSTAMP
RSN

SYS_CR_DT

PORT_UNRL_STU

STU_NO
STU_SEQ_NO
PRTN_PROV_CODE
PRTN_PROV_BR_CODE
PRTN_TYPE
PRTN_FUNC
SSCR_EVT_TSTAMP
PORT_PROV_CODE
PORT_PROV_BR_CODE
PORT_TYPE
PORT_FUNC

LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO

LMT

PORT_PROV_CODE
PORT_PROV_BR_CODE
PORT_TYPE
PORT_FUNC
SSCR_EVT_TSTAMP
SSN

SSCR_EVT_TSTAMP
TYPE

CURR_RFD_REC_DT
TOT_RFD_REC
CURR_PCA_REQ_DT
CURR_PCA_SENT_DT
CURR_PCA_SPA_TYPE
CURR_INT_COLL_DT
CURR_PRIN_COLL_DT
TOT_PRIN_COLL
TOT_INT_COLL
CURR_INSUR_PMT_DT
TOT_INSUR_PMT
CURR_INSUR_CL_RSN
CURR_INSUR_RFD_DT
TOT_INSUR_RFD
CURR_REINSUR_FILDT
TOT_REINSUR_PMT
CURR_REINSUR_PD_DT
CURR_REINSUR_RSN
CURR_REINSUR_RT
CURR_REINSUR_RFDDT
TOT_REINSUR_RFD
CURR_OFF_INT_DT
CURR_OFF_PRIN_DT
TOT_OFF_PRIN
TOT_OFF_INT
CURR_RPCH_LOAN_DT
TOT_RPCH_LOAN
CURR_REHAB_IND
CURR_SUPP_REQ_DT
TOT_SUPP_REINSUR
CURR_SUPP_FEE_BAL
CURR_SUPP_RSN_CODE
CURR_SPA_PMT_DT
TOT_SPA_PMT

LMT_1
LMT_2
LMT_3
LMT_4
LMT_5
END_EVT_TSTAMP

END_EVT_TSTAMP
FST_NM
LST_NM
DOB
STAT

END_EVT_TSTAMP
RSN

TYPE
TERM_IN_MO

LOAN_OPB_HIS
LOAN_SEQ_NO
ID_STU_SEQ_NO
DT
LOAN_NO

LOAN_TYPE
CODE
SYS_CR_DT
NM
NEW_LOAN_TYPE
LOAN_TYPE_GP_CODE

SSCR_ERR_DET
DFR_TYPE_USAGE

PORT_PROV_CODE
PORT_PROV_BR_CODE
PORT_TYPE
PORT_FUNC
SSCR_EVT_TSTAMP
RTN_SUM_RTN_TYPE
RTN_SUM_CERT_DT
STU_SSN
STU_FST_NM
STU_DOB
STU_BR_ID_CODE
CODE

DFR_TYPE
CODE
DESCN

EXPL
STAT
END_EVT_TSTAMP

FORM
FORM_PARM
FORM_ID
SEQ_NO
TYPE
NM
FROM_RNG
TO_RNG

LCK_TSTAMP

LOAN_CPTL_INT

DIR_INCM_CONTG_HIS

LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
DT

LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
SYS_BEG_DT

CUM_AMT
AMT_DIFF
SYS_CR_DT

DT
VAL_IND
SYS_END_DT

LOAN_DEF_RT_DEF

BAT_LCK

LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
DT
SYS_BEG_DT
SYS_END_DT

LOAN_CAN

ID
ORG_TYPE
LOAN_TYPE_GP_CODE
SYS_CR_DT
FISC_YR
ONE_YR_DEF_THRSH
THREE_YR_AVG_DEF

LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
NSLDS_USER_ID
BEG_DT
END_DT
LST_BAT_DT
BAT_HIT_CNT
LCK_SRC

RPCH_LOAN

LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
DT

LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
DT

SYS_CR_DT
CUM_AMT
AMT_DIFF
TYPE
CURR_LEN_CODE

SYS_CR_DT
AMT
REHAB_IND

LOAN_TYPE
FORM_ID

PCA_SPA_NOTIF
LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
REQ_DT

SYS_CR_DT

RT
TYPE
CODE
BEG_DT
VAL_IND
LOAN_TYPE_CODE
SPCL_ALLOW_CATG_CD

NOTIF_SENT_DT
CL_ASS_TYPE

FDSLP_SVR

FDSLP_SVR_BR_HOL

CODE

LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
FDSLP_SVR_CODE
FDSLP_SVR_BR_CODE
RESP_BEG_DT

FDSLP_SVR_BR
FDSLP_SVR_CODE
CODE

RESP_END_DT
CLOSD_SCH_FALSE_CR

NM
STR_ADD
CITY
ST
ZIP_CODE
PH

SSCR_RQTD_RTN_SUM
PORT_PROV_CODE
PORT_PROV_BR_CODE
PORT_TYPE
PORT_FUNC
SSCR_EVT_TSTAMP
RTN_BY_UID
LOAN_TYPE_GP

INSUR_FEE_RT

DESCN

END_DT
RT

LEN_LST_RST_HIS
LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
SYS_CR_DT
SEQ_NO
LEN_LST_RST_IND

LOAN_FRGV
LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
DT
TYPE
CUM_AMT
AMT_DIFF
SYS_CR_DT

LOAN_ORIGN_SUPP
LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
MST_PRM_NT_CODE
MST_PRM_NT_STAT
MST_PRM_NT_EXPR_DT
ADD_PLUS_DEN_IND
ADD_HEAL_IND
ACAD_YR_BEG_DT
ACAD_YR_END_DT
STU_DEP_STAT
LT_DIS_IND
SYS_CR_DT

LOAN_DFR
LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
START_DT
STOP_DT
SYS_CR_DT
TYPE

SYS_CR_DT
NM
STR_ADD
CITY
ST
ZIP_CODE
PH_NO

LOAN_CNSL_APP
LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
CODE
SYS_CR_DT

ID
SPCL_ALLOW_CODE

CODE

LOAN_UNPD_RFD_DCHG
LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
SYS_CR_DT
LOAN_TYPE

LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
DT
CUM_AMT
AMT_DIFF
SYS_CR_DT

TSTAMP
METHOD
TYPE
AGT

SSCR_RTN_SUM
PORT_PROV_CODE
PORT_PROV_BR_CODE
PORT_TYPE
PORT_FUNC
SSCR_EVT_TSTAMP
RTN_TYPE
CERT_DT
RTN_BY_UID
ACK_WAN_ID
TOT_RCD_RECD
VAL_RCD_RECD
RCD_IN_ERR_RTN
SCH_EDT_PROG
SYS_LST_UPDT_TSTMP
XFER_RECD

STU_CERT_LMT1
STU_CERT_LMT2
STU_CERT_LMT3
STU_CERT_LMT4
STU_CERT_LMT5
STU_PORT_CERT_LMT1
STU_PORT_CERT_LMT2
STU_PORT_CERT_LMT3
STU_PORT_CERT_LMT4
STU_PORT_CERT_LMT5
STU_IN_PORT_UNCT
MOST_RCT_SSCR_RPT
TOT_STU_IN_PORT

LOAN_STAT_CODE
LOAN_BEG_DT
LOAN_END_DT
FLAG

LOAN_TYPE_ERR_HIS

SSCR_EVT

PORT_PROV_CODE
PORT_PROV_BR_CODE
PORT_TYPE
PORT_FUNC
SSCR_EVT_TSTAMP

SPCL_ALLOW_CATG

SPCL_ALLOW_DEF

TOT_SCH
TOT_STU_RCD

CODE

LOAN_TYPE
BEG_DT

SSCR_PERF

SYS_CR_DT
AMT
END_DT
SYS_CURR_END_DT

CODE

SBMTL_CNTL_DET

TRAN_LOG_TRAN_CODE
TRAN_LOG_TSTAMP
FLD_CODE

TRAN_CODE
SYS_CR_TSTAMP

PORT
PROV_CODE
PROV_BR_CODE
TYPE
FUNC
CURR_STAT
SCHED_START_DT
SCHED_FREQ
SSCR_LTR_GEN

PORT_STAT

PORT_PROV_CODE
PORT_PROV_BR_CODE
PORT_TYPE
PORT_FUNC
SSCR_EVT_TSTAMP

PORT_PROV_CODE
PORT_PROV_BR_CODE
PORT_TYPE
PORT_FUNC
SSCR_EVT_TSTAMP

CODE

END_EVT_TSTAMP
CODE

SSCR_SCHED_DISTR
PORT_PROV_CODE
PORT_PROV_BR_CODE
PORT_TYPE
PORT_FUNC
SSCR_EVT_TSTAMP
SCHED_DT
END_EVT_TSTAMP
DISTR_NSLDS_ID
DISTR_WAN_ID
TYPE
VAL_IND
NO_OF_RCD_DISTR
ORIG_CR_DT
ORIG_CR_UID

SSCR_REGEN
PORT_PROV_CODE
PORT_PROV_BR_CODE
PORT_TYPE
PORT_FUNC
SSCR_EVT_TSTAMP
SSCR_DIST_SCHED_DT
REGEN_TSTAMP

1, 1 / 1, 1 -- 1:24:50 PM , 4/19/2006

SBMTL_ERR_DESCN
MSG_KEY
OPER_ID
CORRECT_IND
MSG

LST_NO_USED

ONLN_LOAN_AUD

TRAN_AUD_LOG

SYS_CR_DT
CR_USER_ID
LTR_TITL

CODE
LOAN_TYPE_CODE
SPCL_ALLOW_CATG_CD

LOAN_SEQ_NO
ID_STU_SEQ_NO
DT
LOAN_NO

LEN_BR_SVR

PROV_TYPE
PROV_SRC
PROV_NO
PROV_BR_CODE

TRAN_LOG_TRAN_CODE
TRAN_LOG_TSTAMP
SEQ_NO

PROV_CODE
PROV_TYPE
PROV_SRC
CURR_IND
ACTN
WEEK_OF_THE_SCHED

RT_CATG

LOAN_OIB_HIS

LOAN_VOL
DOL_VOL
SYS_CR_DT

SYS_CR_TSTAMP
TYPE
USER_ID

SBMTL_CNTL

TRAN_CMT

AID_OVRPMT_DEL_LOG

RESP_END_DT

OPUT_DISTR

NM
PRI_IND
ALIAS_ID

ORG_CODE
ID
ACT_FUNC_ID
TYPE

SBMTL_PROV_TYPE
SBMTL_PROV_SRC
SBMTL_PROV_NO
SBMTL_PROV_BR_CODE
SBMTL_DT
NO

LOAN_TYPE
DFR_TYPE_CODE
BEG_DT
END_DT

LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
SVR_CODE
RESP_BEG_DT

NATL_AGG

ID

ORG_CON

FST_NM
LST_NM
STR_ADD_LINE_1
STR_ADD_LINE_2
CITY
ST
ZIP_CODE
TITL
PH_NO
PH_EXT
FAX_NO
EMAIL_ADD
LST_UPDT_USER_ID
LST_UPDT_TSTAMP
URL

FUNC_ID
TYPE

SYS_CR_DT
END_DT
PCT
SPCL_ALLOW_RT

EXEC_THRSH_EXCEPT

NM
STR_ADD_LINE_1
STR_ADD_LINE_2
CITY
ST
ZIP_CODE
PH_NO
ALIAS

FORM_LOAN_TYPE
LOAN_STAT_AMT_HIS

LOAN_VOL
DOL_VOL
SYS_CR_DT

TRND

CODE
ACT

NM

SBMTL_HIS_CR_DT
SBMTL_HIS_SEQ_NO
SCH_CODE
SCH_BR_CODE
ERR_CODE
FLD_IN_ERR_CODE
REC_TYPE_IND

PEPS_SBMTL_HIS

STU_NO
STU_SEQ_NO
STU_DEM_CALNDR_YR
SCH_TERM_CODE

CODE
SYS_CR_DT

SCH_BR_HOL_SVR

QTY
EXT_COST
DEF_RT_HIS

SYS_CR_DT
CUM_LEN_RECD_AMT
LEN_RECD_AMT_DIFF

LST_ON_SYS_TSTAMP
SESN_ID

NSLDS_USER_ID
TYPE

ACT_SBMTL_DT
ALL_ERR_RESLV_DT
STAT
LVL_THREE_ERR_TOT
LVL_TWO_ERR_TOT
LVL_ONE_ERR_TOT
TOT_RCD_PROC
CUM_RUN_TOT
CUM_ERR_CNT
NOTIF_HIS_ID
ERR_RT
DAY_LT
JOB_COMPL_DT
JOB_COMPL_TM
FREQ_IND
RECD_DT
INIT_IND

STAT
RESLT_DT
ERR_SRC_IND
CFLCT_VAL
CURR_HOL_LEN_CODE
DATA_PROV_ID
ERR_VAL
LOAN_STAT_CODE
LOAN_STAT_DT
NEW_GUA_DT
NEW_LOAN_TYPE
NEW_ORIG_SCH_CODE
NEW_PLUS_BOR_SSN
NEW_SEP_LOAN_IND
NEW_STU_DOB
NEW_STU_FST_NM
NEW_STU_SSN
SVR_CODE
ADD_SUPT

ID

LTR_REQ

STU_NO
STU_SEQ_NO
PORT_PROV_CODE
PORT_PROV_BR_CODE
PORT_TYPE
PORT_FUNC

LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
REC_DT

NSLDS_USER_ID

RESP_END_DT
ST_AGG

AUTH_ID
ORIG_REQR_LST_NM
ORIG_DT
CAL_RSN
ST_CODE
REQ_TYPE
GA_OFFC_RT_IMP
SCH_OFFC_RT_IMP
LEN_OFFC_RT_IMP
ST_OFFC_RT_IMP
NATL_OFFC_RT_IMP
ORIG_REQR_FST_NM
VIEW_DT

BEG_DT
END_DT
GES_FILE_DUE_DT
DEST_PT_VAL_DT
PROC_DT

ONLN_LCK

D_SYS_END_DT
VAL_IND
GP_LOAN_NO
GP_ID_STU_SEQ_NO
GP_LOAN_SEQ_NO

SVR_CODE
DESC_ID
DESC_DET_ID
RPT_BEG_DT
RPT_END_DT

YR
MO

AMT_OF_PRIN
AMT_OF_INT

LEN_BR_HOL_SVR

SCHED_SBMTL_DT
CODE

SBMTL_HIS_CODE
STU_SSN
DOB
STU_FST
TYPE
GUA_DT
FFEL_DUP_ID
SCH_CODE
PLUS_BOR_SSN
RCD_TYPE_IND
FLD_IN_ERR_CODE
ERR_CODE
SBMTL_HIS_SBMTL_DT

ACT_FUNC

SSCR_ROS_CURR_VAL
LOAN_RFD

WEB_USER_SESN

HIS_RUN_TSTAMP
SYS_REQ_SYS_CR_DT

TYPE

SYS_CR_TSTAMP

DESCN
FLD_TYPE
FLD_LGTH
DSPL_FMT

VAL
END_TSTAMP

ALT_ADD

CON_TYPE

DEF_RT_CAL_REQ

CODE

STAT
RESLT_DT
ERR_SRC_IND
CFLCT_VAL
DATA_PROV_ID
ERR_VAL
LOAN_STAT_CODE
LOAN_STAT_DT
NEW_DIS_DT
NEW_LOAN_TYPE
NEW_ORIG_SCH_CODE
NEW_STU_DOB
NEW_STU_FST_NM
NEW_STU_SSN
SVR_CODE

SCH_SBMTL_HIS

STU_BR_ERR_HIS

DT
SCH_CODE
SCH_BR_CODE
LOAN_TYPE
STU_NO
STU_SEQ_NO
FFEL_DUP_ID
PER_BEG_DT
PER_END_DT
CURR_MAT_DT
ACAD_LVL
CURR_LOAN_STAT
CURR_LOAN_STAT_DT
OUT_PRIN_BAL
OUT_PRIN_BAL_DT
OUT_INT_BAL
OUT_INT_BAL_DT
AMT
TOT_DIS
CURR_DIS_DT
TOT_CAN
CURR_CAN_DT
CURR_DFR_START_DT
CURR_DFR_STOP_DT

HIS_RUN_TSTAMP
SYS_CR_DT

RERUN_FLAG
FFEL_NUM
FFEL_DENOM
FDSLP_NUM
FDSLP_DENOM
DUAL_NUM
DUAL_DENOM
ICR_CNT

LINE_NO
ID

NSLDS_EXTL_CON

NSLDS_USER_ID
CATG
TYPE
BEG_TSTAMP

LEN_BR_SVR_AGG
ACCT_CALNDR

SYS_REQ

HIS_RUN_TSTAMP
SYS_REQ_SYS_CR_DT
MSG

LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
LEN_CODE
LEN_BR_CODE
LEN_HOL_SYS_CR_DT
LEN_HOL_SEQ_NO
DT

PARM_VAL

SYS_CR_DT
CUM_AMT
AMT_DIFF

CMD
TRAN
CMD

USER_OPT

INSUR_CL_RFD

LTR_TYPE
FST_LTR_SENT_IND
FST_LTR_SENT_DT
FST_LTR_SBMTL_DT
SEC_LTR_SENT_IND
SEC_LTR_SENT_DT
SEC_LTR_SBMTL_DT
THIRD_LTR_SENT_IND
THIRD_LTR_SENT_DT
THIRD_LTR_SBMTL_DT

NO
ID_STU_SEQ_NO
SEQ_NO

LOAN_GP

REG_AGG

GA_CODE
DESC_ID
DESC_DET_ID
RPT_BEG_DT
RPT_END_DT

FUT

INT_COLL_DT
PRIN_COLL_DT
CUM_PRIN_COLL_AMT
CUM_INT_COLL_AMT
PRIN_COLL_DIFF
INT_COLL_DIFF

PERK_FLAG
SM_SCH_TEMP
POC_ORG_NM
POC_FST_NM
POC_LST_NM
POC_TITL
POC_ADD_1
POC_ADD_2
POC_CITY
POC_ST
POC_ZIP_CODE
POC_PH_NO
POC_PH_EXT
POC_FAX_NO
POC_FAX_EXT
POC_E_MAIL_ADD

SYS_CR_DT
NM
STR_ADD
CITY
ST
CNTRY
ZIP_CODE

SBMTL_HIS_CODE
STU_SSN
DOB
STU_FST
TYPE
SCH_DT
RCD_TYPE_IND
FLD_IN_ERR_CODE
ERR_CODE
SBMTL_HIS_SBMTL_DT

ID

TRAN_LOG_TRAN_CODE
TRAN_LOG_TSTAMP

LOAN

LOAN_VOL
DOL_VOL
SYS_CR_DT

AGG_ITEM

ORG_NM
DESC_ID

FUNC_GP_SYS_TSTAMP
CMD_TRAN
CMD

SCH_SBMTL_RUN_ERR
SCH_ERR_NOTIF_HIS

LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
SRC

SYS_CR_DT
CUM_AMT
AMT_DIFF
CURR_LEN_CODE

REPT_NM
YR
MO
ST
CNT
PT
SYS_CR_DT

JOB_DESCN
INV_IND

LOAN_EXTL_ID

SYS_END_DT
CODE
DT
VAL_IND
END_DT
SYS_CURR_END_DT

CODE
AGG_ORG_DESC
CMD_SECUR

MAT_DT

ID_STU_SEQ_NO
LOAN_SEQ_NO
SYS_BEG_DT
SEQ_NO
LOAN_NO

METRICS

JOB_ID

NM

ERR_PCT_THRSH1
ERR_PCT_THRSH2
ERR_PCT_THRSH3
DELINQ_LTR_THRSH1
DELINQ_LTR_THRSH2
DELINQ_LTR_THRSH3

AID_TYPE
DIS_DT
OVRPMT_IND
SRC
REG_CODE
RPMT_DT
UPDT_USER_ID
CURR_SSN

LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
DT

LOAN_STAT
GA_SUM

IETUID
IETAPPID
IETPSNUM
SEQNUM
CNTLOVHD
PSTEPDTA
KEYFILL
RPROF_DATE
RPROF_TIME

ACT_SBMTL_DT
ALL_ERR_RESLV_DT
STAT
LVL_THREE_ERR_TOT
LVL_TWO_ERR_TOT
LVL_ONE_ERR_TOT
TOT_RCD_PROC
CUM_RUN_TOT
CUM_ERR_CNT
ERR_RT
DAY_LT
JOB_COMPL_DT
JOB_COMPL_TM
FREQ_IND
RECD_DT
INIT_IND
INV_EXCEPT

LOAN_DIS

TGT
SYS_CLOS_DT
CLOS_RSN

FUT

SCH_BR_SVR_AGG
AGG_DESC_ITEM

SORT_CRIT

WEB_LNK_SECUR

LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
SEQ_NO
SYS_CR_DT

LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
SYS_CR_DT
SRC

BILL_GP
AGG_MENU

ENT

ACTIV_START_DT

TRAN_LOG_TRAN_CODE
TRAN_LOG_TSTAMP

SYS_CR_DT
AMT
END_DT
SYS_CURR_END_DT

LOAN_MAT_DT_HIS
LOAN_TRAN_LOG

RESP_END_DT
SYS_CR_DT
GA_NM
VAL_IND

SYS_CR_DT
RSN_CODE
CUM_REQ_AMT
DT
REIMB_RT_CODE
REQ_AMT_DIFF

LOAN_TYPE_CODE
CURR_STAT_CODE
CURR_STAT_DT
OUT_PRIN_BAL
OUT_PRIN_BAL_DT
PER_BEG_DT
PER_END_DT
CURR_GA_CODE
ACAD_LVL
CON_TYPE
NET_AMT
CON
OPEID
ADD_UNSUB_FLAG
CPTL_INT_FLAG
LOAN_DIS_DT
LOAN_DIS_AMT
LOAN_CHG_FLAG
CURR_LEN_CODE
CURR_LEN_SVR_CODE
REV_BY_NM
REV_DT
LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
CAL_CMBN_AMT
CAL_SUB_AMT
CAL_UNALLOC_AMT
CAL_UNSUB_AMT
LST_DIS_AMT_TEXT
LOAN_CAN_TYPE
LOAN_AMT_TEXT
LOAN_DT_TEXT

CURR_IND
ORIGN_TYPE
FDSLP_SVR_CODE
FDSLP_SVR_BR_CODE

FLD_IN_ERR_CODE
ERR_CODE
STAT
RESLT_DT
ERR_VAL

ERR_THRSH

GA_SBMTL_RUN_ERR

RPROF

SCHED_SBMTL_DT
CODE

PROV_SCHED_LOG_DET

SCH_BR_CODE
TM_EVT_BEG_TSTAMP
TM_STU_BEG_TSTAMP
TM_STU_FST_NM
SCH_CODE
TM_STU_LST_NM
TM_STU_DOB
TM_STU_ALRT_CR_TS
SEQ_NO

DEF_RCNT_IND
CURR_STAT_CODE
CURR_STAT_DT
NET_AMT
LOAN_TYPE_CODE
CURR_GA_CODE
OPE_ID
CNTCT
CNTCT_TYPE
OUT_PRIN_BAL_TEXT
OUT_PRIN_BAL_DT_TX
PER_BEG_DT_TEXT
PER_END_DT_TEXT
CHG_FLAG
ACAD_LVL
LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
ADDL_UNSUB_FLAG
CAP_INT_FLAG
LST_DIS_AMT_TEXT
LST_DIS_DT_TEXT
CAL_CMBN_AMT
CAL_SUB_AMT
CAL_UNALLOC_AMT
CAL_UNSUB_AMT

FS_SBMTL_HIS

STU_SSN
STU_FST
STU_DOB
ATT_SCH_CODE
ATT_SCH_BR_CODE
PELL_GRT_AWARD_YR
RPT_SCH_CODE
RPT_SCH_BR_CODE
SBMTL_DT
SEQ_NO

PROC_FLAG
START_DT
CNTR_1
CNTR_2
CNTR_3
CNTR_4
CNTR_5
CNTR_6
CHAR_SA_1
CHAR_SA_2
CHAR_SA_3
CHAR_SA_4
CHAR_SA_5
CHAR_SA_6
VARCHAR_SA

PEPS_SBMTL_RUN_ERR

EXP_STU_ENRL

FUT

LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
CURR_SSN
STU_NO
CURR_FST_NM
STU_SEQ_NO
CURR_LST_NM
SCH_CODE
PLUS_BOR_NM
CURR_DOB
SCH_BR_CODE
PLUS_BOR_NO
DEF_LOAN_FLAG
SYS_CR_DT
PLUS_BOR_SEQ_NO
DCHG_LOAN_CODE
FST
SAT_ARRNG_FLAG
LST
ACT_BKRPT_FLAG
SYS_CR_DT
AGG_SUB_OPB
CURR_NM_IND
AGG_UNSUB_OPB
AGG_COMB_OPB
PLUS_BOR_LOAN
AGG_CONSOL_OPB
LOAN_NO
AGG_SUB_PEND_DIS
ID_STU_SEQ_NO
AGG_UNSUB_PEND_DIS
LOAN_SEQ_NO
AGG_CMBN_PND_DIS
PLUS_BOR_NO
AGG_SUB_TOT
PLUS_BOR_SEQ_NO
AGG_UNSUB_TOT
SYS_CR_DT
AGG_CMBN_TOT
AGG_CNSL_TOT
PERK_TOT_DIS
PLUS_BOR_SSN
PERK_CURR_YR_DIS
PLUS_BOR_NO
DL_STFRD_MPN_CODE
PLUS_BOR_SEQ_NO
PELL_CHG_FLAG
NO
LOAN_CHG_FLAG
AGG_CHG_FLAG
SYS_CR_DT
PLUS_BOR_NO
PSEUDO_SSN_IND
PLUS_BOR_SEQ_NO
SRC
STU_NO
CURR_SSN_IND
STU_SEQ_NO
BOR_DOB
ACAD_LVL
DEP_IND
DL_PLUS_MPN_CODE
EXCD_AGG_CMBN_LMT
EXCD_AGG_SUB_LMT
HEAL_DEN_FLAG
PLUS_DEN_FLAG
AGG_CNSL_UNAL_OPB
AGG_CNSL_UNAL_TOT
AGG_PLUS_OPB
TM_STU_ALRT_LOAN
AGG_PLUS_TOT
TM_STU_SSN

APPL_CURR_SSN
APPL_FST_NM
APPL_LST_NM
APPL_CPS_DOB
APPL_CPS_AWARD_YR
RSLT_SEQ_NO
SEQ_NO

RES

DT
CUM_AMT
RSN_CODE
AMT_DIFF
VAL_IND

RPT_PARM_ATTR

REQ_TYPE
RCD_RTN_TOT
RCD_ADD_TOT
ERR_RCD_TOT
VAL_RCD_TOT
ERR_TRSMTL_DT

PELL_SBMTL_RUN_ERR

JOB_NM
IX_SUBPG_FILL

NON_COLL_LOAN_NO
NON_COLL_ID_SEQ_NO
NON_COLL_SEQ_NO
PLUS_BOR_NO
PLUS_BOR_SEQ_NO

TM_STU_SSN
SCH_CODE
SCH_BR_CODE
TM_EVT_BEG_TSTAMP
TM_STU_BEG_TSTAMP
TM_STU_FST_NM
TM_STU_LST_NM
TM_STU_DOB
CR_TSTAMP

SCH_CODE
TM_STU_SSN
SCH_BR_CODE
TM_EVT_BEG_TSTAMP
TM_STU_BEG_TSTAMP
TM_STU_FST_NM
TM_STU_LST_NM
TM_STU_DOB
TM_STU_ALRT_CR_TS
SEQ_NO

DSPL_NM
DEF_VAL
CRS_CK_SEQ
CRS_CK_RPT_PROF_ID
CRS_CK_VAL_CODE
CRS_VAL_SIGN
WLD_CD_FLAG
PRSNT_TYPE_CODE
ORG_TYPE_CODE
INCL_FILE_NM

LEN_BR_AGG

LOAN_VOL
DOL_VOL
SYS_CR_DT

SCH_CODE
SCH_BR_CODE
SSCR_TRSMTL_TSTAMP
RTN_DT

TM_STU_ALRT
TM_STU_ALRT_PELL

PRSCRN_RSLT_LOAN

NM

SSCR_RTN_HIS

TRAN_DET

SEQ
RPT_PROF_RPT_ID
PARM_VAL_CODE

LEN_CODE
LEN_BR_CODE
DESC_ID
DESC_DET_ID
RPT_BEG_DT
RPT_END_DT

DT

SYS_CR_DT
RETEN_CNT

RES_ST
FAM_MEM_CNT
FAM_MEM_COLLG_CNT
INCM_TAX_FORM_CODE
ADJ_GRS_INCM
INCM_TAX_PAID
STU_EARN_INCM
SPS_EARN_INCM
FATH_EARN_INCM
MOTH_EARN_INCM
SS_BEN_INCM
AFDC_ADC_INCM
CHILD_SUPRT_AMT
OTH_SRC_INCM
EXCL_INCM
TOT_CASH_AMT
REAL_EST_VAL_AMT
REAL_EST_DEBT_AMT
BUS_VAL_AMT
BUS_DEBT_AMT
FARM_VAL_AMT
FARM_DEBT_AMT
TAX_FILE_STAT_CODE
ELIG_1040A_EZ_CODE
WORKSHEET_A_TOT
WORKSHEET_B_TOT
INV_NET_WORTH_AMT
BUS_NET_WORTH_AMT
FARM_NET_WORTH_AMT
WORKSHEET_C_TOT
BUS_FARM_NET_WORTH
SUB_WRN_FLAG
CMBN_WRN_FLAG

CURR_SSN
CURR_PSEUDO_IND
CURR_FST
CURR_LST
MID_INIT
RES_ST
DOB

NM
STR_ADD
CITY
ST
ZIP_CODE
PH_NO
TYPE

FUNC_GP_SYS_TSTAMP
ATTR_NM
ENT_NM

SCH_CODE
SCH_BR_CODE
SSCR_TRSMTL_TSTAMP
CODE

VAL_TRSL_LKUP_NM
VAL_TRSL_LKUP_ID
FORM_ID

NO
SEQ_NO

LOAN_NO
ID_STU_SEQ_NO
LOAN_SEQ_NO
LEN_CODE
LEN_BR_CODE
SYS_CR_DT
SEQ_NO

COL_SECUR

SSCR_DELINQ_LTR

FORM_RT_TYPE_CNT

PLUS_BOR

SRCH_SSN
SRCH_FST_NM
SRCH_DOB
SRCH_RSLT

SCH_BR_AGG

CODE

PARM_TSTAMP
RPT_ID

CURR_FLAG
TYPE
SRC_CAT
SRC_CODE
EFF_DT
RECFM_DT
STR_ADD_LINE_1
STR_ADD_LINE_2
CITY
ST
CNTRY
ZIP_CODE

CURR_NM_IND
SYS_CR_DT

STU_NO
STU_SEQ_NO
STU_DEM_CALNDR_YR
CATG_CODE

CKPT_RSTART

PLUS_NON_COLL_LOAN

RESP_BEG_DT
RESP_END_DT
NM
ORIG_FEE_PAY_IND
ORIG_LEN_IND
VAL_IND

SYS_CR_TSTAMP

LKUP_RSLT

NSLDS_ID
CODE
SYS_CR_TSTAMP

LEN_NM

LOC_GP

STU_NO
STU_SEQ_NO
NO

TRAN_LOG

LEN

SYS_CR_TSTAMP

LKUP_ID
LKUP_TYPE_NM

STU_ADD

SSN
SCH_CODE
SCH_BR_CODE
TM_EVT_BEG_TSTAMP
BEG_TSTAMP
FST_NM
LST_NM
DOB

RPT_PARM_PROF

FUNC_GP

TYPE
RCD_SENT_TOT

VAL_TRSL_TAB
TM_STU

FAM_INCM
EXP_FAM_CONTRIB
DEP_IND
PAR_MAR_STAT_CODE
OLDEST_PAR_AGE
MOTH_GRD_LVL_CODE
FATH_GRD_LVL_CODE
GENDER
OVR_24_IND
CITZ
ALIEN_REGIS_NO
MAR_STAT_IND
MAR_STAT_CODE
GRAD_PROF_STU_IND
WARD_ORPHAN_IND
LEGL_DEP_IND
HAVE_DEP
HAVE_CHILD
DEP_PAID_CARE_CNT
VA_IND
VA_EDUC_BEN_AMT
VA_EDUC_BEN_MO_CNT
HS_GRAD_YR_MO
GED_YR_MO
COLLG_LVL_CODE
DEG_CODE
BACHLR_DEG_IND
EXP_GRAD_DT
CRS_OF_STUDY_CODE
SAME_COLLG_IND
DEP_OVRRD_CODE
APPL_COMPL_DT
SSN_IND
SSN_CITZ_IND
HS_DIPLM_GED_IND
STR_ADD
CITY
ST
ZIP_CODE
FATH_SSN
FATH_SSN_MTCH_IND
FATH_LST_NM
FATH_FST_INIT
FATH_DOB
MOTH_SSN
MOTH_SSN_MTCH_IND
MOTH_LST_NM
MOTH_FST_INIT
MOTH_DOB
SYS_CR_TSTAMP
CPS_TRAN_CODE
CPS_TRAN_SRC_CODE
CPS_TRAN_DATA_TYPE
CPS_SEQ_NO

CODE

LEN_CODE
CODE

OLD_LEN_BR_CODE
OLD_LEN_CODE
NEW_LEN_BR_CODE
NEW_LEN_CODE
SYS_CR_DT

SCH_BR_CODE
SCH_CODE
SYS_CR_DT

END_TSTAMP
FST_NM
LST_NM
TITL
INFRM_DEST_ID
ALRT_DEST_ID
BAT_ALRT_METHOD
EMAIL_ADD
PH_NO
PH_EXT
CR_BY_USER_NM
INFRM_IND
ALRT_IND

FST
LST
MID_INIT
SSN
DOB
STU_ADD_NO
STAT_IND
SSCR_RTN_TO_SCH_DT

END_TSTAMP
ENRL_BEG_DT
MNTR_BEG_DT
PLUS_BOR_NO
PLUS_BOR_SEQ_NO
STU_NO
STU_SEQ_NO

LEN_BR

SCH_CODE
SCH_BR_CODE
BEG_TSTAMP

SCH_CODE
SCH_BR_CODE
JOB_TSTAMP
SSCR_SEQ_NO

STU_NO
STU_SEQ_NO
SSCR_STAT_NO
SSCR_STAT_FLAG
DATA_PROV_FRWD_DT
RTN_DT
COMPLD_ONLN_USER

SSCR_TRSMTL_HIS

LEN_BR_HOL

GA_CODE
LEN_CODE
LEN_BR_CODE
VAL_TRSL_LKUP_ID
VAL_TRSL_LKUP_NM
LEN_TYPE
SCH_CODE
SCH_BR_CODE

SCH_CODE
SCH_BR_CODE
SSCR_TRSMTL_TSTAMP
SSCR_SEQ_NO

ENRL_CODE
CNSTNCY_IND
PRMTN_IND
SYS_CR_DT

CODE
EFF_DT
VAL_IND
END_TSTAMP

END_TSTAMP
SEQ_NO

SYS_CR_TSTAMP

SSCR_TRSMTL_INFO

SSCR_TRSMTL_DET

CURR_SSN
CURR_PSEUDO_IND
CURR_FST
CURR_LST
MID_INIT
DOB
CITZ
ST
DRIV_LIC_ST
DRIV_LIC_NO
DEM_REQ_YR
STAT
LST_LOAN_SEQ_NO

STU_STAT_UNRESLV

ENRL
NSLDS_USER

CODE

VAL_IND
ADD_LINE_1
ADD_LINE_2
CITY
STATE
ZIP
CNTRY

ORG

STU_NO
STU_SEQ_NO
CALNDR_YR

PSEUDO_SSN_IND
CURR_SSN_IND
SYS_CR_DT
SRC
STU_DOB

NO
SEQ_NO

STU_NO
STU_SEQ_NO
SCH_CODE
SCH_BR_CODE

STAT
ERR_SRC_IND
CFLCT_VAL
DATA_PROV_ID
ERR_VAL
LOAN_STAT_CODE
LOAN_STAT_DT
NEW_LOAN_DT
NEW_LOAN_TYPE
NEW_ORIG_SCH_CODE
NEW_PLUS_BOR_SSN
NEW_SEP_LOAN_IND
NEW_STU_DOB
NEW_STU_FST_NM
NEW_STU_SSN
RESLT_DT
FINANC_PROF

STU_DEM

STU_NO
STU_SEQ_NO
NO

STU

SYS_END_DT
HIS_CODE
UNAUTH_LOC_IND
PERK_PORT_CLOS_IND

SYS_END_DT
COA_ACTN_CODE
COA_EFF_DT
COA_CDR_ACTN_CODE

SRC_TYPE
STU_SSN

METHOD
CERT_DT
EFF_DT
ENRL_CODE
ANTIC_COMPL_DT

CODE
END_TSTAMP

STU_BR_DESG

SCH_CODE
SCH_BR_CODE
DT
SYS_CR_DT

OLD_SCH_CODE
NEW_SCH_BR_CODE
NEW_SCH_CODE
OLD_SCH_BR_CODE
SYS_CR_DT

ENRL_CODE
EFF_DT
STU_ADD_NO
VAL_IND
ANTIC_COMPL_DT
SYS_CR_DT
CURR_CERT_DT

ENRL_CODE
CERT_DT
SRC

STU_NO
STU_SEQ_NO
SCH_CODE
SCH_BR_CODE
SYS_CR_TSTAMP

STU_NO
STU_SEQ_NO
SCH_CODE
SCH_BR_CODE
BEG_TSTAMP

STU_NO
STU_SEQ_NO
SCH_CODE
SCH_BR_CODE

STU_NO
STU_SEQ_NO
SCH_CODE
SCH_BR_CODE
EFF_DT

STU_NO
STU_SEQ_NO
SCH_CODE
SCH_BR_CODE
EVAL_DT

SSCR_RPTD_ENRL

STU_BR_ID

STU_BR

STU_STAT

SCH_BR_STAT_HIS

SCH_BR_CLOS_STAT

SBMTL_HIS_CODE
STU_SSN
DOB
STU_FST
TYPE
LOAN_DT
FFEL_DUP_ID
SCH_CODE
PLUS_BOR_SSN
RCD_TYPE_IND
FLD_IN_ERR_CODE
ERR_CODE
SBMTL_HIS_SBMTL_DT

SSCR_FUT_EVAL

RPT_SCH_CODE
RPT_SCH_BR_CODE
SCHED_AMT
AMT_PAID_TO_DT
REMN_AMT_TO_PAY
ENRL_DT
STU_ORG_SSN
STU_ORG_NM_CODE
SEG_NO
SEG_STAT
SEG_CR_DT
SEG_LST_UPD_DT
SEG_SCH_AS_OF_DT
SEG_BAT_NO
TRAN_NO
EXP_FAM_CONTRIB
SEC_FAM_CONTRIB
ACTD_SEC_EFF_CODE
ACTD_COST_OF_ATT
HIGH_COST_OF_ATT
ACTD_ACAD_CALNDR
ACTD_VERIF_STAT
ACTD_PMT_METHOD
ACTD_ENRL_CODE
HIGH_ACTD_ENRL_COD
ACTD_HRS_IN_SCH_YR
ACTD_INCARC_IND
ACTD_INCARC_ST
PCT_ELIG_USED_DECM
SEG_ELIG_USED
SEG_POTEN_OVRAWARD
SEG_OVRAWRD_DIS

SCH_BR_TRAN_HIS

FS_SBMTL_RUN_ERR

HOUSG_CODE
FAA_PROF_JUDG_IND
PELL_INSTIT_IND
CPS_TRAN_CODE
SYS_CR_TSTAMP

PELL_GRT

SSCR_PROC_WAIV
PORT_PROV_CODE
PORT_PROV_BR_CODE
PORT_TYPE
PORT_FUNC
SSCR_EVT_TSTAMP
APPR_DT
BEG_DT
END_DT
RSN
VAL_IND
END_EVT_TSTAMP

SBMTL_ERR_HIS
SBMTL_PROV_TYPE
SBMTL_PROV_SRC
SBMTL_PROV_NO
SBMTL_PROV_BR_CODE
SBMTL_NOTIF_DT
SEQ_NO
PROV_CODE
WAN_ID
ERR_DESCN_MSG_KEY
ERR_DESCN_OPER_ID
SBMTL_DT
TRANS_MODE
UPDT_DT
UPDT_TM
REC_DT