Model Loan Processing

Model Label : Banner Financial Aid Loan Processing Module

List of Objects

Object Name	Object Type	Layer Name
RFRASPC	SQL Table	Default
RFRBASE	SQL Table	Default
RORDATA	SQL Table	Default
RPBLOPT	SQL Table	Default
RPBLPRD	SQL Table	Default
RPRASTD	SQL Table	Default
RPRLADB	SQL Table	Default
RPRLAPP	SQL Table	Default
RPRLATR	SQL Table	Default
RPRLCRT	SQL Table	Default
RPRLTRM	SQL Table	Default
RPRRFND	SQL Table	Default
RTVCDNT	SQL Table	Default
RTVCDST	SQL Table	Default
RTVCINT	SQL Table	Default
RTVDLBT	SQL Table	Default
RTVINFC	SQL Table	Default
RTVLNST	SQL Table	Default
RTVPRCD	SQL Table	Default
RTVRJCT	SQL Table	Default
RTVRPSR	SQL Table	Default

Model View

Table RFRASPC

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RFRASPC_AIDY_CODE	VARCHAR2(4)	No	*	*
RFRASPC_FUND_CODE	VARCHAR2(6)	No	*	*
RFRASPC_BUDG_ALLOC_AMT	NUMBER(11,2)	No
RFRASPC_AVAIL_OFFER_AMT	NUMBER(11,2)	No
RFRASPC_AVAIL_OFFER_PCT	NUMBER(6,3)	No
RFRASPC_AUTO_PACK_IND	VARCHAR2(1)	No
RFRASPC_AUTO_SCHED_IND	VARCHAR2(1)	No
RFRASPC_AUTO_ACCEPT_IND	VARCHAR2(1)	No
RFRASPC_DISBURSE_IND	VARCHAR2(1)	No
RFRASPC_APPL_MEMO_IND	VARCHAR2(1)	No
RFRASPC_REPLACE_TFC_IND	VARCHAR2(1)	No
RFRASPC_REDUCE_NEED_IND	VARCHAR2(1)	No
RFRASPC_OVERRIDE_IND	VARCHAR2(1)	No
RFRASPC_ROUND_SCHED_IND	VARCHAR2(2)	No
RFRASPC_EQUITY_IND	VARCHAR2(1)	No
RFRASPC_OFFER_AWST_CODE	VARCHAR2(4)	No		*
RFRASPC_ACCEPT_AWST_CODE	VARCHAR2(4)	No		*
RFRASPC_DECLINE_AWST_CODE	VARCHAR2(4)	No		*
RFRASPC_INEL_BEF_CUT_DATE_IND	VARCHAR2(1)	No
RFRASPC_INEL_AFT_CUT_DATE_IND	VARCHAR2(1)	No
RFRASPC_CHANGE_LOAD_IND	VARCHAR2(1)	No
RFRASPC_RECOUP_IND	VARCHAR2(1)	No
RFRASPC_LOAN_PROCESS_IND	VARCHAR2(1)	No
RFRASPC_NA_REQD_IND	VARCHAR2(1)	No
RFRASPC_SEL_VER_INC_IND	VARCHAR2(1)	No
RFRASPC_ACTIVITY_DATE	DATE	No
RFRASPC_TRANSFER_AMT	NUMBER(11,2)	Yes
RFRASPC_PRIOR_BAL_AMT	NUMBER(11,2)	Yes
RFRASPC_TOTAL_ALLOC_AMT	NUMBER(11,2)	Yes
RFRASPC_ORIG_OFFER_NO	NUMBER(9,0)	Yes
RFRASPC_ORIG_OFFER_AMT	NUMBER(11,2)	Yes
RFRASPC_OFFER_NO	NUMBER(9,0)	Yes
RFRASPC_OFFER_AMT	NUMBER(11,2)	Yes
RFRASPC_ACCEPT_NO	NUMBER(9,0)	Yes
RFRASPC_ACCEPT_AMT	NUMBER(11,2)	Yes
RFRASPC_DECLINE_NO	NUMBER(9,0)	Yes
RFRASPC_DECLINE_AMT	NUMBER(11,2)	Yes
RFRASPC_CANCEL_NO	NUMBER(9,0)	Yes
RFRASPC_CANCEL_AMT	NUMBER(11,2)	Yes
RFRASPC_AUTHORIZE_NO	NUMBER(9,0)	Yes
RFRASPC_AUTHORIZE_AMT	NUMBER(11,2)	Yes
RFRASPC_MEMO_NO	NUMBER(9,0)	Yes
RFRASPC_MEMO_AMT	NUMBER(11,2)	Yes
RFRASPC_PAID_NO	NUMBER(9,0)	Yes
RFRASPC_PAID_AMT	NUMBER(11,2)	Yes
RFRASPC_MAX_AWARD_AMT	NUMBER(11,2)	Yes
RFRASPC_MIN_AWARD_AMT	NUMBER(11,2)	Yes
RFRASPC_3QUARTER_LOAD_PCT	NUMBER(6,3)	Yes
RFRASPC_HALF_LOAD_PCT	NUMBER(6,3)	Yes
RFRASPC_LESS_HALF_LOAD_PCT	NUMBER(6,3)	Yes
RFRASPC_SELF_HELP_RED_PCT	NUMBER(6,3)	Yes
RFRASPC_LOAN_FEE_PCT	NUMBER(6,3)	Yes
RFRASPC_PRORATION_IND	VARCHAR2(1)	No
RFRASPC_AWD_CHG_LTR_IND	VARCHAR2(1)	Yes
RFRASPC_PROM_REQ_IND	VARCHAR2(1)	Yes
RFRASPC_OVERRIDE_NEED_IND	VARCHAR2(1)	No
RFRASPC_OVERRIDE_TREQ_IND	VARCHAR2(1)	No
RFRASPC_OVERRIDE_SAPR_IND	VARCHAR2(1)	Yes
RFRASPC_NCAA_IND	VARCHAR2(1)	Yes
RFRASPC_LMS_FUND	VARCHAR2(6)	Yes
RFRASPC_INTEREST_RATE	NUMBER(6,3)	Yes
RFRASPC_DIRECT_LOAN_IND	VARCHAR2(1)	Yes
RFRASPC_USE_DISB_ENRL_MEMO_IND	VARCHAR2(1)	Yes
RFRASPC_ALT_LOAN_PROG_TYPE_CDE	VARCHAR2(3)	Yes
RFRASPC_REBATE_PERCENT	NUMBER(6,3)	Yes
RFRASPC_WEB_ACCEPT_FLAG	VARCHAR2(1)	No
RFRASPC_OVERRIDE_NEED_TO_COA	VARCHAR2(1)	Yes
RFRASPC_ATTENDING_HR_IND	VARCHAR2(1)	Yes
RFRASPC_EL_IND	VARCHAR2(1)	Yes
RFRASPC_MANUAL_LOAN_IND	VARCHAR2(1)	Yes
RFRASPC_ACG_YEAR	VARCHAR2(1)	Yes
RFRASPC_SMART_YEAR	VARCHAR2(1)	Yes
RFRASPC_AWRD_USING_EST_EFC_IND	VARCHAR2(1)	No
RFRASPC_ROLL_IND	VARCHAR2(1)	No
RFRASPC_ROUND_AWARD_AMT	NUMBER(5,0)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
RFRASPC_FUND_CODE	RFRBASE_FUND_CODE	RFRBASE
RFRASPC_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RFRASPC_DECLINE_AWST_CODE	RTVAWST_CODE	RTVAWST
RFRASPC_ACCEPT_AWST_CODE	RTVAWST_CODE	RTVAWST
RFRASPC_OFFER_AWST_CODE	RTVAWST_CODE	RTVAWST
RFRASPC_AIDY_CODE	RPRAWRD_AIDY_CODE	RPRAWRD
RFRASPC_FUND_CODE	RPRAWRD_FUND_CODE	RPRAWRD
RFRASPC_FUND_CODE	RPTAWRD_FUND_CODE	RPTAWRD
RFRASPC_AIDY_CODE	RPTAWRD_AIDY_CODE	RPTAWRD

Index

Index Name	Index Type	Column Name
PK_RFRASPC	Unique	RFRASPC_AIDY_CODE
PK_RFRASPC	Unique	RFRASPC_FUND_CODE
RFRASPC_FUND_INDEX		RFRASPC_FUND_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RFRBCMP	SQL Table	S10B80.FAISMGR	Refer (no action)
RFRCOMM	SQL Table	S10B80.FAISMGR	Refer (no action)
RFRDETC	SQL Table	S10B80.FAISMGR	Refer (no action)
RFRDLCK	SQL Table	S10B80.FAISMGR	Refer (no action)
RFRMESG	SQL Table	S10B80.FAISMGR	Refer (no action)
RFRTREQ	SQL Table	S10B80.FAISMGR	Refer (no action)
RPRBAKO	SQL Table	S10B80.FAISMGR	Join
RPRLAPP	SQL Table	S10B80.FAISMGR	Join
F_EST_LOAN	SQL Function	S10B80.BANINST1	Use (select)
FUND_REC	Oracle Package Type	S10B80.BANINST1.RPKAWRD	Rely On
LOAN_TYPE	Oracle Package Type	S10B80.BANINST1.BWRKLHST	Rely On
FUND_REC	Oracle Package Type	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
FUND_REC	Oracle Package Type	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
FUND_REC	Oracle Package Type	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
FUND_REC	Oracle Package Type	S10B80.BANINST1.RPK_DISB_VALIDATION	Rely On
GETROUNDINDC	Oracle Package Cursor	S10B80.BANINST1.BWRKPAYS	Use (select)
P_ACG_SMART_EXCEEDS_LIMIT	Oracle Package Procedure	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
P_ACG_SMART_EXCEEDS_LIMIT	Oracle Package Procedure	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Use (select)
P_AWARD_EXCEEDS_ANN_LIMIT	Oracle Package Procedure	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
P_AWARD_EXCEEDS_ANN_LIMIT	Oracle Package Procedure	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Use (select)
P_AWARD_EXCEEDS_CUM_LIMIT	Oracle Package Procedure	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
P_AWARD_EXCEEDS_MAX	Oracle Package Procedure	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
P_AWARD_EXCEEDS_NEED	Oracle Package Procedure	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
P_CALC_GRANT_DATA	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_CALC_GRANT_DATA	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Use (select)
P_GET_FUND_DATA	Oracle Package Procedure	S10B80.BANINST1.REKORIG	Rely On
P_GET_FUND_DATA	Oracle Package Procedure	S10B80.BANINST1.REKORIG	Use (select)
P_NSLDS_CUM_TEST_AS_IND	Oracle Package Procedure	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Use (select)
F_AWARD_EXCEEDS_CONTRIBUTION	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
F_AWARD_EXCEEDS_FUNDS_AVAIL	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
F_AWARD_EXCEEDS_FUNDS_AVAIL	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Use (select)
F_COUNT_ACG_NSLDS	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
F_FUND_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_REQUIREMENT_RULES	Use (select)
F_FUND_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE_RULES	Use (select)
F_FUND_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_AWARD_RULES	Use (select)
F_FUND_CODE_VALID	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION_RULES	Rely On
F_FUND_CODE_VALID	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION_RULES	Use (select)
F_GETACCEPTAWST	Oracle Package Function	S10B80.BANINST1.XCHAPERS	Rely On
F_GETACCEPTAWST	Oracle Package Function	S10B80.BANINST1.XCHAPERS	Use (select)
F_GETMINAMT	Oracle Package Function	S10B80.BANINST1.BWRKACPT	Rely On
F_GETMINAMT	Oracle Package Function	S10B80.BANINST1.BWRKACPT	Use (select)
F_GET_AWST_CODE	Oracle Package Function	S10B80.BANINST1.RB_AWARD	Rely On
F_GET_AWST_CODE	Oracle Package Function	S10B80.BANINST1.RB_AWARD	Use (select)
F_GET_FEDERAL_RULES	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
F_GET_FUND_DATA	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Use (select)
F_GET_FUND_DATA	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Use (select)
F_GET_FUND_DATA	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Use (select)
F_GET_FUND_DATA	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION	Use (select)
F_GRANT_YEAR_VALID	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Rely On
F_GRANT_YEAR_VALID	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Use (select)
F_IS_LOAN_PROCESS	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Use (select)
F_LOAN_PERIOD_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_AWARD	Use (select)
F_MISSING_SCHEDULE	Oracle Package Function	S10B80.BANINST1.RB_APPLICANT_STATUS_RULES	Use (select)
F_NA_EXISTS	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
F_NON_OVERRIDE_NEED_EXISTS	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Use (select)
F_NSLDS_CALC_BANNER_PAID	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
F_NSLDS_CALC_BANNER_PAID	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Use (select)
F_NSLDS_CALC_PRIOR_COLL_PAID	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
F_NSLDS_INCLUDES_AID_YEAR	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
F_OVRD_TO_COA_EXISTS	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Use (select)
F_PELL_EFC_IS_DETERMINED	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_REQUIREMENTS_EXIST	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Use (select)
F_TITLE_IV_EFC_ELIGIBLE	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_VALID_AGS_YR_IN_COLL	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
F_VALID_HS_GRAD_DATE	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
F_VALID_SMRT_YR_IN_COLL	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
F_VAL_EFC	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
F_VAL_FEDERAL_FUND	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Use (select)
F_VAL_FED_LIMITS	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_VAL_FED_LIMITS	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Use (select)
F_VAL_FUND_LIMITS	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
F_VAL_LOAD	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_VAL_OFFICIAL	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_VAL_PRIOR_LOAN_PN	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Use (select)
F_VAL_REDUCE_NEED	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
GETLOANTYPEC	Oracle Package Cursor	S10B80.BANINST1.BWRKLHST	Use (select)
P_ADD_LOAN_PROCESS	Oracle Package Procedure	S10B80.BANINST1.RPKLOAN	Rely On
P_ADD_LOAN_PROCESS	Oracle Package Procedure	S10B80.BANINST1.RPKLOAN	Use (select)
P_CALCULATE_LOAD	Oracle Package Procedure	S10B80.BANINST1.RPKLOAD	Rely On
P_CALC_PELL_DATA	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_CALC_PELL_DATA	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Use (select)
P_CHK_ACTIVE_FUND_CODE	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Rely On
P_CHK_ACTIVE_FUND_CODE	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_CHK_INVALID_FUND_CODE	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Rely On
P_CHK_INVALID_FUND_CODE	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.RB_TEMP_AWARD	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.RB_TEMP_AWARD	Use (select)
P_CREATE_FUND	Oracle Package Procedure	S10B80.BANINST1.RPK_DEBS_DISPLAYS	Rely On
P_CREATE_FUND	Oracle Package Procedure	S10B80.BANINST1.RPK_DEBS_DISPLAYS	Use (Insert)
P_CREATE_FUND_TOTAL_TABLE	Oracle Package Procedure	S10B80.BANINST1.RPKPCKG	Use (select)
P_CREATE_TEMP_FUND_TABLE	Oracle Package Procedure	S10B80.BANINST1.RPKPCKG	Use (select)
P_DISPLAY_RFRASPC	Oracle Package Procedure	S10B80.BANINST1.RPK_DEBS_DISPLAYS	Rely On
P_DISPLAY_RFRASPC	Oracle Package Procedure	S10B80.BANINST1.RPK_DEBS_DISPLAYS	Use (select)Rely On
P_DISPPAYSCHED	Oracle Package Procedure	S10B80.BANINST1.BWRKPAYS	Rely On
P_GET_GRANT_DEFAULTS	Oracle Package Procedure	S10B80.BANINST1.REKORIG	Rely On
P_GET_PELL_DEFAULTS	Oracle Package Procedure	S10B80.BANINST1.REKORIG	Rely On
P_PA_RFRBASE_EQUAL_2	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_PROCESS_ONLINE_AWARDS	Oracle Package Procedure	S10B80.BANINST1.RPKAFRM	Use (select)
P_PROCESS_ONLINE_TERMS	Oracle Package Procedure	S10B80.BANINST1.RPKAFRM	Rely On
P_PROCESS_ONLINE_TERMS	Oracle Package Procedure	S10B80.BANINST1.RPKAFRM	Use (select)
P_PR_REREXXX_VALIDATION	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_SELECT_DL_PNOTE_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Rely On
P_SELECT_DL_PNOTE_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Use (select)
P_SELECT_DL_PNOTE_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Rely On
P_SELECT_DL_PNOTE_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Use (select)
P_SELECT_DL_PNOTE_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_SELECT_DL_PNOTE_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Use (select)
P_SELECT_DL_PNOTE_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_SELECT_DL_PNOTE_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Use (select)
P_SELECT_DL_PNOTE_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_SELECT_DL_PNOTE_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Use (select)
P_UPDATE_RFRASPC	Oracle Package Procedure	S10B80.BANINST1.RPKAWRD	Use (update)
P_UPDATE_YEAR_SPEC	Oracle Package Procedure	S10B80.BANINST1.RPKLOAN	Use (update)
P_VALIDATE_DISBURSEMENT	Oracle Package Procedure	S10B80.BANINST1.RPK_DISB_VALIDATION	Rely On
P_VALIDATE_DISBURSEMENT_US	Oracle Package Procedure	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_AWARD_DISBURSEMENT	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_REQUIREMENT	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_APPLICANT_STATUS	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_TEMP_AWARD	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_AWARD_SCHEDULE	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_AWARD_SCHEDULE	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_AWARD	Use (Insert)
F_ALLOWWEBUPDATE	Oracle Package Function	S10B80.BANINST1.BWRKACPT	Use (select)
F_CALC_ACT_REDUCE_NEED_AMT	Oracle Package Function	S10B80.BANINST1.RNKNEED	Use (select)
F_CALC_ACT_REPLACE_EFC_AMT	Oracle Package Function	S10B80.BANINST1.RNKNEED	Use (select)
F_GETACCEPTAWST	Oracle Package Function	S10B80.BANINST1.BWRKACPT	Rely On
F_GETACCEPTAWST	Oracle Package Function	S10B80.BANINST1.BWRKACPT	Use (select)
F_GETDECLINEAWST	Oracle Package Function	S10B80.BANINST1.BWRKACPT	Rely On
F_GETDECLINEAWST	Oracle Package Function	S10B80.BANINST1.BWRKACPT	Use (select)
F_GET_ENROLLMENT_DATE	Oracle Package Function	S10B80.BANINST1.REKORIG	Rely On
F_GET_FUND_DATA	Oracle Package Function	S10B80.BANINST1.RPKAWRD	Use (select)
F_GET_GRANT_TYPE	Oracle Package Function	S10B80.BANINST1.REKORIG	Rely On
F_GET_GRANT_TYPE	Oracle Package Function	S10B80.BANINST1.REKORIG	Use (select)
F_VAL_PRIOR_ACG_SMART	Oracle Package Function	S10B80.BANINST1.RPK_COMMON_VALIDATION_US	Rely On
F_VAL_PRIOR_ACG_SMART	Oracle Package Function	S10B80.BANINST1.RPK_COMMON_VALIDATION_US	Use (select)
RFRASPC	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RFRASPC	SQL Index	S10B80.FAISMGR	Rely On
RFRASPC_FUND_INDEX	SQL Index	S10B80.FAISMGR	Rely On
RFRBASE	SQL Table	S10B80.FAISMGR	Refer (no action)
ROBINST	SQL Table	S10B80.FAISMGR	Refer (no action)
RPRAWRD	SQL Table	S10B80.FAISMGR	Join
RPTAWRD	SQL Table	S10B80.FAISMGR	Join
RTVAWST	SQL Table	S10B80.FAISMGR	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RFRASPC

Object Dates

Creation Date	Analysis Date
04/02/2008 10:24:06:000	04/02/2008 10:35:18:000

Source Code Comments

Fund Aid Year Specific Data

Columns Comments for RFRASPC_AIDY_CODE (# 1)

Source Code Comments

AID YEAR CODE: The aid year to be associated with information in this record. EXAMPLES: 9091, 9192, 9293, etc.

Columns Comments for RFRASPC_FUND_CODE (# 2)

Source Code Comments

FUND CODE: This field identifies the fund associated with the information in this record.

Columns Comments for RFRASPC_BUDG_ALLOC_AMT (# 3)

Source Code Comments

BUDGET ALLOCATED AMOUNT: This field represents the actual allocated budget for a fund code within the given aid year. Optional field which defaults to 0.

Columns Comments for RFRASPC_AVAIL_OFFER_AMT (# 4)

Source Code Comments

AVAILABLE AMOUNT TO OFFER: This field represents the dollar amount of the fund that can be offered including any over-commitment amount. This field will be calculated if an Available to Offer Percent is entered.

Columns Comments for RFRASPC_AVAIL_OFFER_PCT (# 5)

Source Code Comments

PERCENTAGE AMOUNT AVAILABLE TO OFFER: This optional field represents the percentage of the total allocation that the institution wishes to offer including over-commitment.

Columns Comments for RFRASPC_AUTO_PACK_IND (# 6)

Source Code Comments

AUTOMATIC PACKAGE INDICATOR: This indicator is used to define whether this fund code should be included in automatic packaging.

Columns Comments for RFRASPC_AUTO_SCHED_IND (# 7)

Source Code Comments

AUTOMATIC SCHEDULING INDICATOR: This indicator is used to define if this fund code, once awarded should be automatically scheduled between terms.

Columns Comments for RFRASPC_AUTO_ACCEPT_IND (# 8)

Source Code Comments

AUTOMATIC ACCEPTANCE INDICATOR: This indicator is used to define if this fund should be automatically scheduled for disbursements.

Columns Comments for RFRASPC_DISBURSE_IND (# 9)

Source Code Comments

DISBURSE INDICATOR: This indicator defines how the disbursements can be made for each fund. Disbursements can be (S)ystem, (M)anual, or (N)either.

Columns Comments for RFRASPC_APPL_MEMO_IND (# 10)

Source Code Comments

APPLY FOR MEMO CREDIT: This field defines when and if the fund can be carried as a credit memo based on fund award status. Valid values include (N)one, (A)ccepted, (O)ffered.

Columns Comments for RFRASPC_REPLACE_TFC_IND (# 11)

Source Code Comments

REPLACE TOTAL FAMILY CONTRIBUTION INDICATOR: This indicator is used to define whether or not this fund should replace the total family contribution in the calculation of unmet need.

Columns Comments for RFRASPC_REDUCE_NEED_IND (# 12)

Source Code Comments

REDUCE NEED INDICATOR: This indicator is used to define whether or not this fund should reduce need in the calculation of unmet need. It is mutually exclusive from the Replace TFC indicator.

Columns Comments for RFRASPC_OVERRIDE_IND (# 13)

Source Code Comments

OVERRIDE INDICATOR: This field indicates whether general tracking requirements (those not associated with a fund) can be overridden for the particular fund in order for disbursements to be made.(See Field Usage Notes for all cases.)

Columns Comments for RFRASPC_ROUND_SCHED_IND (# 14)

Source Code Comments

ROUND SCHEDULE: This field defines the rounding rules used in scheduling the award by terms and for use in fund disbursement.

Columns Comments for RFRASPC_EQUITY_IND (# 15)

Source Code Comments

EQUITY INDICATOR: This field is used to define whether the fund should be considered in Equity packaging.

Columns Comments for RFRASPC_OFFER_AWST_CODE (# 16)

Source Code Comments

OFFER AWARD STATUS: This field defines the award status which this fund will be offered in an automated packaging environment.

Columns Comments for RFRASPC_ACCEPT_AWST_CODE (# 17)

Source Code Comments

ACCEPT AWARD STATUS CODE: This code defines the award status with which this fund will be accepted.

Columns Comments for RFRASPC_DECLINE_AWST_CODE (# 18)

Source Code Comments

DECLINE AWARD STATUS CODE: This field identifies the decline status that should be used to decline awards for this fund code.

Columns Comments for RFRASPC_INEL_BEF_CUT_DATE_IND (# 19)

Source Code Comments

IF INELIGIBLE BEFORE CUT-OFF: This field determines what action will take place in the disbursement process if the student becomes ineligible for the fund prior to the financial aid cut-off date.

Columns Comments for RFRASPC_INEL_AFT_CUT_DATE_IND (# 20)

Source Code Comments

IF INELIGIBLE AFTER CUT-OFF: This field determines what action will take place in the disbursement process if the student becomes ineligible for the funds after the institutions cut-off date.

Columns Comments for RFRASPC_CHANGE_LOAD_IND (# 21)

Source Code Comments

CHANGE LOAD IND: Field indicates whether the award should be prorated or the scheduled disbursement prorated if the enrollment changes.

Columns Comments for RFRASPC_RECOUP_IND (# 22)

Source Code Comments

RECOUP INDICATOR: This field indicates whether dollars should be recouped after disbursements for this fund if something changes in the students record.

Columns Comments for RFRASPC_LOAN_PROCESS_IND (# 23)

Source Code Comments

LOAN PROCESS INDICATOR: This field is used to determine whether this fund is to be included in the loan processing function.

Columns Comments for RFRASPC_NA_REQD_IND (# 24)

Source Code Comments

NEED ANALYSIS INDICATOR: This indicator defines whether this fund requires that a need analysis record be on file for this fund to be awarded or for loan processing to occur.

Columns Comments for RFRASPC_SEL_VER_INC_IND (# 25)

Source Code Comments

SELECTED FOR VERIFICATION INDICATOR: This field indicates whether disbursements can be made on the fund if the verification has not been completed.

Columns Comments for RFRASPC_ACTIVITY_DATE (# 26)

Source Code Comments

ACTIVITY DATE: The date that information for this record in the table was entered or last updated

Columns Comments for RFRASPC_TRANSFER_AMT (# 27)

Source Code Comments

TRANSFER AMOUNT: This field represents any dollar amount which should transfer in or transfer out of a fund which will affect the total allocation for the Aid Year. Optional with a default value of 0. This field can be negative.

Columns Comments for RFRASPC_PRIOR_BAL_AMT (# 28)

Source Code Comments

PRIOR BALANCE AMOUNT: This field represents any prior balance for the fund code from a previous aid year. Optional field with a default value of 0.

Columns Comments for RFRASPC_TOTAL_ALLOC_AMT (# 29)

Source Code Comments

TOTAL ALLOCATED: This calculated field displays the total available dollars for the fund for the aid year. It is the sum of the prior balance the transferred amount plus the budget allocated amount. Not user-enterable.

Columns Comments for RFRASPC_ORIG_OFFER_NO (# 30)

Source Code Comments

ORIGINAL OFFER NUMBER: This field maintains the number of original awards for the fund in the specified aid year.

Columns Comments for RFRASPC_ORIG_OFFER_AMT (# 31)

Source Code Comments

ORIGINAL OFFER AMOUNT: This field maintains the dollar amount of all original awards for the fund in the specified aid year.

Columns Comments for RFRASPC_OFFER_NO (# 32)

Source Code Comments

OFFER NUMBER: This field maintains the number of awards that are currently offered for the fund in the specified aid year.

Columns Comments for RFRASPC_OFFER_AMT (# 33)

Source Code Comments

OFFER AMOUNT: This field maintains the dollar amount of awards that have been offered for the fund in the specified aid year.

Columns Comments for RFRASPC_ACCEPT_NO (# 34)

Source Code Comments

NUMBER OF ACCEPTED: This field maintains the number of awards that have been accepted for this fund in the specified aid year.

Columns Comments for RFRASPC_ACCEPT_AMT (# 35)

Source Code Comments

ACCEPTED AMOUNT: This field maintains the dollar amount of the fund that has been accepted for the indicated aid year.

Columns Comments for RFRASPC_DECLINE_NO (# 36)

Source Code Comments

DECLINE NUMBER: This field maintains the number of awards that have been declined for this fund code in the specified aid year.

Columns Comments for RFRASPC_DECLINE_AMT (# 37)

Source Code Comments

DECLINE AMOUNTS: This field maintains the dollar amount of declined awards for the fund code in the specified year.

Columns Comments for RFRASPC_CANCEL_NO (# 38)

Source Code Comments

CANCELLED AWARDS: This field maintains the number of cancelled awards for the fund code in the specified aid year.

Columns Comments for RFRASPC_CANCEL_AMT (# 39)

Source Code Comments

CANCELLED AMOUNT: This field maintains the dollar amount of cancelled awards for the fund code in the specified aid year.

Columns Comments for RFRASPC_AUTHORIZE_NO (# 40)

Source Code Comments

AUTHORIZED AWARDS: This field maintains the number of awards that have been authorized for the fund in the specified aid year.

Columns Comments for RFRASPC_AUTHORIZE_AMT (# 41)

Source Code Comments

AUTHORIZED AMOUNT: This field maintains the dollar amount of awards that are authorized.

Columns Comments for RFRASPC_MEMO_NO (# 42)

Source Code Comments

MEMO AWARDS: This field maintains the number of memo'd awards for the fund code in the specified aid year.

Columns Comments for RFRASPC_MEMO_AMT (# 43)

Source Code Comments

MEMO AMOUNT: This field maintains the dollar amount of memo'd awards for the f und code in the specified aid year.

Columns Comments for RFRASPC_PAID_NO (# 44)

Source Code Comments

PAID NUMBER: This field maintains the number of awards that have been paid for the fund in the specified aid year.

Columns Comments for RFRASPC_PAID_AMT (# 45)

Source Code Comments

PAID AMOUNT: This field maintains the dollar amount of awards that have been paid for the fund in the specified aid year.

Columns Comments for RFRASPC_MAX_AWARD_AMT (# 46)

Source Code Comments

MAXIMUM DOLLAR AMOUNT AWARDED TO A STUDENT: This field represents the maximum award the institution wishes to offer to any one student from a specific fund. Cannot be negative and cannot be less than the award minimum.

Columns Comments for RFRASPC_MIN_AWARD_AMT (# 47)

Source Code Comments

MINIMUM DOLLAR AMOUNT AWARDED TO A STUDENT: This field represents the minimum award the institution wishes to offer to any one student from each specific fund.

Columns Comments for RFRASPC_3QUARTER_LOAD_PCT (# 48)

Source Code Comments

THREE QUARTER LOAD PCT: Represents the percentage of the students award which will be disbursed if the student is enrolled on a three-quarter time basis.

Columns Comments for RFRASPC_HALF_LOAD_PCT (# 49)

Source Code Comments

HALF LOAD PCT: This field represents the percentage of the students award that will be disbursed if the student is enrolled on a half-time basis.

Columns Comments for RFRASPC_LESS_HALF_LOAD_PCT (# 50)

Source Code Comments

LESS THAN HALF LOAD PCT: This field represents the percentage of the students award that will be disbursed if the student is enrolled on a less than half- time basis.

Columns Comments for RFRASPC_SELF_HELP_RED_PCT (# 51)

Source Code Comments

SELF-HELP REDUCTION PERCENTAGE: This field defines the percentage of this fund that can be used toward satisfying self-help requirements.

Columns Comments for RFRASPC_LOAN_FEE_PCT (# 52)

Source Code Comments

LOAN FEE PERCENTAGE: This field represents the loan fee percent for this fund if a "Y" was indicated in the Loan Process field.

Columns Comments for RFRASPC_PRORATION_IND (# 53)

Source Code Comments

PRORATION INDICATOR: Used by the Disbursement process to decide how to process disbursement when a students disbursement load > packaging load. Values are P = Prorate disbursement amount, D = Do not prorate, N = No disbursement.

Columns Comments for RFRASPC_AWD_CHG_LTR_IND (# 54)

Source Code Comments

AWARD LETTER CHANGE INDICATOR: Indicates whether a change to this funds offered amount should set the RORSTAT_AWD_LTR_IND to 'Y'. Valid values are Y (set the RORSTAT_AWD_LTR_IND = Y, N or blank = no change to RORSTAT indicator.

Columns Comments for RFRASPC_PROM_REQ_IND (# 55)

Source Code Comments

PROMISSORY NOTE REQUIRED INDICATOR: Indicates whether this fund requires that the student sign a promissory note.

Columns Comments for RFRASPC_OVERRIDE_NEED_IND (# 56)

Source Code Comments

OVERRIDE UNMET NEED: Override the validation of unmet need if this indicator is set.

Columns Comments for RFRASPC_OVERRIDE_TREQ_IND (# 57)

Source Code Comments

OVERRIDE TRACKING REQUIREMENTS: Override the test for outstanding tracking requirements needed for packaging if indicator is set.

Columns Comments for RFRASPC_OVERRIDE_SAPR_IND (# 58)

Source Code Comments

Indicator used to override the verification of satisfactory academic progress in the Packaging and Disbursement processes.

Columns Comments for RFRASPC_NCAA_IND (# 59)

Source Code Comments

Indicator to allow users to track which funds are "countable" for NCAA purposes.

Columns Comments for RFRASPC_LMS_FUND (# 60)

Source Code Comments

LMS (IA Plus) fund designation that indicates the fund-loan rules associated with an institutional based loan. This designation is carried on LMS feed transactions.

Columns Comments for RFRASPC_INTEREST_RATE (# 61)

Source Code Comments

The interest rate on the direct loan for this student.

Columns Comments for RFRASPC_DIRECT_LOAN_IND (# 62)

Source Code Comments

Indicates whether the loan is of a direct loan type.

Columns Comments for RFRASPC_USE_DISB_ENRL_MEMO_IND (# 63)

Source Code Comments

USE DISBURSEMENT EDITS FOR MEMO: Allows the application of the Disbursement Enrollment Edits to be applied to funds in memo status.

Columns Comments for RFRASPC_ALT_LOAN_PROG_TYPE_CDE (# 64)

Source Code Comments

ATERNATIVE LOAN PROGRAM TYPE CODE: 3-character code to indicate if the fund is an alternative loan fund as defined by NCHELP.

Columns Comments for RFRASPC_REBATE_PERCENT (# 65)

Source Code Comments

REBATE FEE PERCENT: Rebate fee percentage.

Columns Comments for RFRASPC_WEB_ACCEPT_FLAG (# 66)

Source Code Comments

WEB ACCEPT FLAG: This controls which funds can be accepted/declined via the web. The valid values are 'Y' (Checked) and 'N' (unchecked).

Columns Comments for RFRASPC_OVERRIDE_NEED_TO_COA (# 67)

Source Code Comments

OVERRIDE NEED TO COA: Fund level override indicator to allow need to be overridden up to the cost of attendance (budget) amount.

Columns Comments for RFRASPC_ATTENDING_HR_IND (# 68)

Source Code Comments

ATTENDING HOURS INDICATOR: Indicator when checked to calculate the enrollment load for disbursement based on hours which the student is attending and the course has begun. Valid values are Y and null. Default value is null.

Columns Comments for RFRASPC_EL_IND (# 69)

Source Code Comments

ELECTRONIC LOAN INDICATOR: The type of electronic loan assigned to the fund.

Columns Comments for RFRASPC_MANUAL_LOAN_IND (# 70)

Source Code Comments

MANUAL LOAN INDICATOR: The type of manual loan assigned to the fund.

Columns Comments for RFRASPC_ACG_YEAR (# 71)

Source Code Comments

ACG FUND YEAR LEVEL: Indicates the ACG Grant year funding level.

Columns Comments for RFRASPC_SMART_YEAR (# 72)

Source Code Comments

SMART FUND YEAR LEVEL: Indicates the SMART Grant year funding level.

Columns Comments for RFRASPC_AWRD_USING_EST_EFC_IND (# 73)

Source Code Comments

AWARD USING ESTIMATED EFC: Indicates if the fund can be awarded with an estimated EFC.

Columns Comments for RFRASPC_ROLL_IND (# 74)

Source Code Comments

ROLL AWARD INDICATOR: Indicates if the fund is eligible for the award roll process.

Columns Comments for RFRASPC_ROUND_AWARD_AMT (# 75)

Source Code Comments

ROUND AWARD: Specifies the nearest dollar amount to round down to during automatic packaging.

Table RFRBASE

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RFRBASE_FUND_CODE	VARCHAR2(6)	No	*	*
RFRBASE_FUND_TITLE	VARCHAR2(30)	No
RFRBASE_FSRC_CODE	VARCHAR2(4)	No		*
RFRBASE_FTYP_CODE	VARCHAR2(4)	No		*
RFRBASE_ACTIVITY_DATE	DATE	No
RFRBASE_DETAIL_CODE	VARCHAR2(4)	Yes		*
RFRBASE_FED_FUND_ID	VARCHAR2(4)	Yes		*
RFRBASE_PRINT_SEQ_NO	NUMBER(6,0)	Yes
RFRBASE_VR_MSG_NO	NUMBER(6,0)	Yes
RFRBASE_ACTIVE_IND	VARCHAR2(1)	No
RFRBASE_XREF_VALUE	VARCHAR2(10)	Yes
RFRBASE_FUND_TITLE_LONG	VARCHAR2(200)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
RFRBASE_FSRC_CODE	RTVFSRC_CODE	RTVFSRC
RFRBASE_FTYP_CODE	RTVFTYP_CODE	RTVFTYP
RFRBASE_FUND_CODE	RJRSEAR_FUND_CODE	RJRSEAR
RFRBASE_DETAIL_CODE	TBRMEMO_DETAIL_CODE	TBRMEMO
RFRBASE_DETAIL_CODE	TBRACCD_DETAIL_CODE	TBRACCD
RFRBASE_FED_FUND_ID	RFRFFID_FED_FUND_ID	RFRFFID
RFRBASE_FUND_CODE	RPTAWRD_FUND_CODE	RPTAWRD

Index

Index Name	Index Type	Column Name
PK_RFRBASE	Unique	RFRBASE_FUND_CODE
RFRBASE_DETAIL_INDEX		RFRBASE_DETAIL_CODE
RFRBASE_FED_INDEX		RFRBASE_FED_FUND_ID
RFRBASE_FED_INDEX		RFRBASE_FUND_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RFRASPC	SQL Table	S10B80.FAISMGR	Refer (no action)
RFRFCAT	SQL Table	S10B80.FAISMGR	Refer (no action)
RFRPROM	SQL Table	S10B80.FAISMGR	Join
RPRADSB	SQL Table	S10B80.FAISMGR	Join
RPRATRM	SQL Table	S10B80.FAISMGR	Join
RPRAWRD	SQL Table	S10B80.FAISMGR	Join
RPRBAKO	SQL Table	S10B80.FAISMGR	Join
RPRLAPP	SQL Table	S10B80.FAISMGR	Join
RPRTIIV	SQL Table	S10B80.FAISMGR	Join
AR_TRACKING_REQUIREMENTS	SQL View	S10B80.BANINST1	Join
RPVAWY2	SQL View	S10B80.BANINST1	Use (select)
F_FA_AMT_TERM_FNC	SQL Function	S10B80.BANINST1	Use (select)
F_FA_AMT_YEAR_FNC	SQL Function	S10B80.BANINST1	Use (select)
F_FINAID_GET_DESC	SQL Function	S10B80.BANINST1	Use (select)
F_INST_AID_FNC	SQL Function	S10B80.BANINST1	Use (select)
ADDLREQ_TYPE	Oracle Package Type	S10B80.BANINST1.BWRKTRKR	Rely On
AWARD_DTL_TYPE	Oracle Package Type	S10B80.BANINST1.BWRKACPT	Rely On
AWARD_DTL_TYPE	Oracle Package Type	S10B80.BANINST1.BWRKRHST	Rely On
AWARD_MSG_TYPE	Oracle Package Type	S10B80.BANINST1.BWRKRHST	Rely On
FUND_CODE_REC	Oracle Package Type	S10B80.BANINST1.BWRCBREF	Rely On
LOAN_DETAIL_TYPE	Oracle Package Type	S10B80.BANINST1.BWRKLHST	Rely On
PAYMENT_TYPE	Oracle Package Type	S10B80.BANINST1.BWRKPAYS	Rely On
RRRAREQ_TYPE	Oracle Package Type	S10B80.BANINST1.BWRKTRKR	Rely On
RRRTMSG_TYPE	Oracle Package Type	S10B80.BANINST1.BWRKTMSG	Rely On
WS_DATA_REC	Oracle Package Type	S10B80.BANINST1.BWRCBREF	Rely On
BASE_VRNO_TAB_TYPE	Oracle Package Type	S10B80.BANINST1.ROKTABS	Rely On
PROM_VRNO_TAB_TYPE	Oracle Package Type	S10B80.BANINST1.ROKTABS	Rely On
RFRBASE_TAB_TYPE	Oracle Package Type	S10B80.BANINST1.ROKTABS	Rely On
RFRBASE_VR_MSG_NO_TAB_TYPE	Oracle Package Type	S10B80.BANINST1.ROKTABS	Rely On
FUND_REC	Oracle Package Type	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
FUND_REC	Oracle Package Type	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
FUND_REC	Oracle Package Type	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
FUND_REC	Oracle Package Type	S10B80.BANINST1.RPK_DISB_VALIDATION	Rely On
CALC_RPRAWRD_OFFER_AMT	Oracle Package Cursor	S10B80.BANINST1.BWRKSUMM	Use (select)
RPRTIIVC	Oracle Package Cursor	S10B80.BANINST1.BWRKTIVW	Use (select)
P_ACG_SMART_EXCEEDS_LIMIT	Oracle Package Procedure	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
P_ACG_SMART_EXCEEDS_LIMIT	Oracle Package Procedure	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Use (select)
P_AWARD_EXCEEDS_ANN_LIMIT	Oracle Package Procedure	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
P_AWARD_EXCEEDS_ANN_LIMIT	Oracle Package Procedure	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Use (select)
P_AWARD_EXCEEDS_CUM_LIMIT	Oracle Package Procedure	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
P_AWARD_EXCEEDS_MAX	Oracle Package Procedure	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
P_AWARD_EXCEEDS_NEED	Oracle Package Procedure	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
P_BUILDROTWFAE	Oracle Package Procedure	S10B80.BANINST1.ROKWEXT	Use (select)
P_GET_FUND_DATA	Oracle Package Procedure	S10B80.BANINST1.REKORIG	Rely On
P_GET_FUND_DATA	Oracle Package Procedure	S10B80.BANINST1.REKORIG	Use (select)
P_GET_LOAD_FROM_HOURS	Oracle Package Procedure	S10B80.BANINST1.RPKLOAD	Rely On
P_NSLDS_CUM_TEST_AS_IND	Oracle Package Procedure	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Use (select)
P_SAR_DATE_PROCESSING	Oracle Package Procedure	S10B80.BANINST1.RP_APPLICANT_STATUS	Use (select)
RFRBASE_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI07	Rely On
RFRBASE_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI08	Rely On
RFRBASE_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI09	Rely On
F_ACCEPTED_ACG_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Use (select)
F_ACCEPTED_PELL_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Use (select)
F_ACCEPTED_SMART_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Use (select)
F_AMOUNT_VALID	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION_RULES	Rely On
F_COUNT_RFRDSCH	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Use (select)
F_COUNT_RFRDSCH	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Use (select)
F_COUNT_RPRADSB	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Use (select)
F_COUNT_RPRADSB	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Use (select)
F_DETAIL_CODE_ACTIVE	Oracle Package Function	S10B80.BANINST1.RB_AWARD	Use (select)
F_FUND_CODE_VALID	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION_RULES	Use (select)
F_FUND_ID_IS_SMRT	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE_RULES	Use (select)
F_GET_FEDERAL_RULES	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
F_GET_FED_FUND_ID	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Rely On
F_GET_FED_FUND_ID	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Use (select)
F_GET_FED_FUND_ID	Oracle Package Function	S10B80.BANINST1.RB_AWARD_RULES	Rely On
F_GET_FED_FUND_ID	Oracle Package Function	S10B80.BANINST1.RB_AWARD_RULES	Use (select)
F_GET_FUND_DATA	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Use (select)
F_GET_FUND_DATA	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Use (select)
F_GET_FUND_DATA	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Use (select)
F_GET_FUND_DATA	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION	Use (select)
F_GET_PELL_FUND	Oracle Package Function	S10B80.BANINST1.REKORIG	Use (select)
F_GET_PELL_OFRD_CNT	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Use (select)
F_GET_RFRFFID_DATA	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
F_GET_RFRFFID_DATA	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
F_GRANT_YEAR_VALID	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Use (select)
F_HAS_PELL	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Use (select)
F_IS_PELL	Oracle Package Function	S10B80.BANINST1.RB_AWARD	Rely On
F_IS_PELL	Oracle Package Function	S10B80.BANINST1.RB_AWARD	Use (select)
F_MAINTAIN_SAP_FED_AID	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
F_NON_OVERRIDE_NEED_EXISTS	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Use (select)
F_NSLDS_AGG_LIMITS_EXCEEDED	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
F_NSLDS_CALC_BANNER_PAID	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
F_NSLDS_CALC_BANNER_PAID	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Use (select)
F_NSLDS_CALC_PRIOR_COLL_PAID	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
F_NSLDS_INCLUDES_AID_YEAR	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
F_PACKAGE_LOCKED	Oracle Package Function	S10B80.BANINST1.RB_AWARD	Rely On
F_PACKAGE_LOCKED	Oracle Package Function	S10B80.BANINST1.RB_AWARD_DISBURSEMENT	Use (select)
F_PELL_EFC_ELIGIBLE	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
F_PELL_EFC_IS_DETERMINED	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_PELL_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Use (select)
F_PELL_GRAD	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
F_PLUS_AWARDED	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Use (select)
F_SELECT_DISB_FUND	Oracle Package Function	S10B80.BANINST1.REKCI07	Rely On
F_SELECT_DISB_FUND	Oracle Package Function	S10B80.BANINST1.REKCI07	Use (select)
F_SELECT_DISB_FUND	Oracle Package Function	S10B80.BANINST1.REKCI08	Rely On
F_SELECT_DISB_FUND	Oracle Package Function	S10B80.BANINST1.REKCI08	Use (select)
F_SELECT_DISB_FUND	Oracle Package Function	S10B80.BANINST1.REKCI09	Rely On
F_SELECT_DISB_FUND	Oracle Package Function	S10B80.BANINST1.REKCI09	Use (select)
F_SELECT_PELL_DISB_SUM	Oracle Package Function	S10B80.BANINST1.REKCI04	Use (select)
F_SELECT_PELL_DISB_SUM	Oracle Package Function	S10B80.BANINST1.REKCI05	Use (select)
F_SELECT_PELL_DISB_SUM	Oracle Package Function	S10B80.BANINST1.REKCI06	Use (select)
F_TITLE_IV_EFC_ELIGIBLE	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_VAL_DEGREE	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_VAL_FEDERAL_FUND	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
F_VAL_FED_LIMITS	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_VAL_FED_LIMITS	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Use (select)
F_VAL_LOAD	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_VAL_OFFICIAL	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_VAL_PELL_AUTHORIZATION	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Use (select)
F_VAL_PELL_DISBURSEMENT	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Use (select)
F_VAL_REDUCE_NEED	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Use (select)
C_GET_FUND_CODE	Oracle Package Cursor	S10B80.BANINST1.BWRCBREF	Use (select)
GETACTIVEAIDYEARC	Oracle Package Cursor	S10B80.BANINST1.BWRKLHST	Use (select)
GETAWDDTLC	Oracle Package Cursor	S10B80.BANINST1.BWRKRHST	Use (select)
GETAWDDTL_C	Oracle Package Cursor	S10B80.BANINST1.BWRKACPT	Use (select)
GETAWDMSGC	Oracle Package Cursor	S10B80.BANINST1.BWRKRHST	Use (select)
GETLOANDTLC	Oracle Package Cursor	S10B80.BANINST1.BWRKLHST	Use (select)
GETPAYITEMC	Oracle Package Cursor	S10B80.BANINST1.BWRKPAYS	Use (select)
GETPROMREQC	Oracle Package Cursor	S10B80.BANINST1.BWRKTRKR	Use (select)
GETTRKMSGC	Oracle Package Cursor	S10B80.BANINST1.BWRKTMSG	Use (select)
GETTRKREQC	Oracle Package Cursor	S10B80.BANINST1.BWRKTRKR	Use (select)
RFRBASE_ROW_BY_CODE_C	Oracle Package Cursor	S10B80.BANINST1.RFKSELS	Rely On
RFRBASE_ROW_BY_CODE_C	Oracle Package Cursor	S10B80.BANINST1.RFKSELS	Use (select)Rely On
P_CALCULATE_LOAD	Oracle Package Procedure	S10B80.BANINST1.RPKLOAD	Rely On
P_CALC_PELL_DATA	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Use (select)
P_CALC_PELL_DATA	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Use (select)
P_CALC_PELL_DATA	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Use (select)
P_CHK_ACTIVE_FUND_CODE	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_CREATE_FUND	Oracle Package Procedure	S10B80.BANINST1.RPK_DEBS_DISPLAYS	Rely On
P_CREATE_FUND	Oracle Package Procedure	S10B80.BANINST1.RPK_DEBS_DISPLAYS	Use (Insert)
P_GET_PELL_DEFAULTS	Oracle Package Procedure	S10B80.BANINST1.REKORIG	Rely On
P_GET_RFRBASE_ROW	Oracle Package Procedure	S10B80.BANINST1.RFKFUNC	Rely On
P_GET_RPRATRM_RTVAWST_ROWS	Oracle Package Procedure	S10B80.BANINST1.RPKFUNC	Rely On
P_GET_RPRAWRD_ROWS	Oracle Package Procedure	S10B80.BANINST1.RPKFUNC	Rely On
P_GET_RPRLAPP_ROWS	Oracle Package Procedure	S10B80.BANINST1.RPKFUNC	Rely On
P_OPEN_AWARDS_CV	Oracle Package Procedure	S10B80.BANINST1.RPKPCKG	Use (select)
P_PA_RFRBASE_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_PA_RFRBASE_EQUAL_2	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_PA_RFRBASE_EQUAL_N_NOT_PELL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_PROCESS_ONLINE_AWARDS	Oracle Package Procedure	S10B80.BANINST1.RPKAFRM	Use (select)
P_PR_REREXXX_VALIDATION	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_RFRBASE_AIR	Oracle Package Procedure	S10B80.BANINST1.EOKRRTS	Rely On
P_RFRBASE_AUR	Oracle Package Procedure	S10B80.BANINST1.EOKRRTS	Rely On
P_SELECT_RFRBASE_FUND	Oracle Package Procedure	S10B80.BANINST1.ROKPELL	Rely On
P_SELECT_RFRBASE_FUND	Oracle Package Procedure	S10B80.BANINST1.ROKPELL	Use (select)
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (select)
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (select)
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.RB_FUND_CATEGORY_RULES	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.RB_FUND_CATEGORY_RULES	Use (select)Rely On
P_VR_BUILD_AWARDS	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_GET_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.VRRKRPMT	Rely On
P_VR_GET_LOAN_INFO	Oracle Package Procedure	S10B80.BANINST1.VRRKRLAP	Rely On
P_VR_SPEAK_REQMNTS	Oracle Package Procedure	S10B80.BANINST1.VRRKRREQ	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_AWARD_DISBURSEMENT	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_REQUIREMENT	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_APPLICANT_STATUS	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_DL_REFUND	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_PELL_ORIGINATIONS	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_FUND_CATEGORY	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_TEMP_AWARD	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_AWARD_SCHEDULE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_AWARD	Use (Insert,select)
F_ALLOWWEBUPDATE	Oracle Package Function	S10B80.BANINST1.BWRKACPT	Use (select)
F_CALC_ALGORITHMIC_AMOUNT	Oracle Package Function	S10B80.BANINST1.RPKALGR	Rely On
F_CALC_PELL_AWARD	Oracle Package Function	S10B80.BANINST1.RNKNEED	Use (select)
F_CHECK_TITLEIV_LOANS	Oracle Package Function	S10B80.BANINST1.ROKWFLB	Use (select)
F_CHECK_WORKSTUDY	Oracle Package Function	S10B80.BANINST1.ROKWFLB	Use (select)
F_COUNT_RFRBASE_FUND_CODES	Oracle Package Function	S10B80.BANINST1.ROKPELL	Rely On
F_COUNT_RFRBASE_FUND_CODES	Oracle Package Function	S10B80.BANINST1.ROKPELL	Use (select)
F_FIRST_TIME_BORROWER	Oracle Package Function	S10B80.BANINST1.RPKLOAN	Use (select)
F_FUND_IS_PELL	Oracle Package Function	S10B80.BANINST1.RPKAWRD	Use (select)
F_GET_AMT_DUE	Oracle Package Function	S10B80.BANINST1.REKORIG	Use (select)
F_GET_AWARDS_XML	Oracle Package Function	S10B80.BANINST1.XCHAPERS	Use (select)
F_GET_FFID_OFFER	Oracle Package Function	S10B80.BANINST1.RPKALGR	Rely On
F_GET_FFID_OFFER	Oracle Package Function	S10B80.BANINST1.RPKALGR	Use (select)
F_GET_FSRC_EXISTING_AMT	Oracle Package Function	S10B80.BANINST1.RPKPCKG	Use (select)
F_GET_GRANT_TYPE	Oracle Package Function	S10B80.BANINST1.REKORIG	Use (select)
F_GET_MEMO_AMOUNT	Oracle Package Function	S10B80.BANINST1.RPKATRM	Use (select)
F_GET_MIN_TERM	Oracle Package Function	S10B80.BANINST1.REKORIG	Use (select)
F_GET_NOPAY_DATA	Oracle Package Function	S10B80.BANINST1.BWRCBREF	Use (select)
F_GET_PAID_AMOUNT	Oracle Package Function	S10B80.BANINST1.RPKATRM	Use (select)
F_GET_PRIOR_YEAR_FFID_OFFER	Oracle Package Function	S10B80.BANINST1.RPKALGR	Rely On
F_GET_PRIOR_YEAR_FFID_OFFER	Oracle Package Function	S10B80.BANINST1.RPKALGR	Use (select)
F_GET_TRKREQ	Oracle Package Function	S10B80.BANINST1.BWRCBREF	Use (select)
F_GET_WS_DISPLAY_DATA	Oracle Package Function	S10B80.BANINST1.BWRCBREF	Use (select)
F_IS_CITIZEN	Oracle Package Function	S10B80.BANINST1.RPK_COMMON_VALIDATION_US	Rely On
F_PARENT_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_FUND_CATEGORY_RULES	Use (select)
F_PELL_EFC_IS_DETERMINED	Oracle Package Function	S10B80.BANINST1.RPK_COMMON_VALIDATION_US	Rely On
F_SELECT_ACG_ORIGINATIONS	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_ACG_ORIGINATIONS	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_ACG_ORIGINATIONS	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
F_SELECT_PELL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE05	Use (select)
F_SELECT_PELL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE06	Use (select)
F_SELECT_PELL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_PELL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_PELL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
F_SELECT_PELL_DISBURSEMENTS	Oracle Package Function	S10B80.BANINST1.REKCE05	Use (select)
F_SELECT_PELL_DISBURSEMENTS	Oracle Package Function	S10B80.BANINST1.REKCE06	Use (select)
F_SELECT_PELL_DISBURSEMENTS	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_PELL_DISBURSEMENTS	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_PELL_DISBURSEMENTS	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
F_SELECT_SMART_ORIGINATIONS	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_SMART_ORIGINATIONS	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_SMART_ORIGINATIONS	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE05	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE06	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
F_VAL_DEGREE_BY_JULY	Oracle Package Function	S10B80.BANINST1.RPK_COMMON_VALIDATION_US	Rely On
F_VAL_DETAIL_CODE	Oracle Package Function	S10B80.BANINST1.RPK_COMMON_VALIDATION	Rely On
F_VAL_PRIOR_ACG_SMART	Oracle Package Function	S10B80.BANINST1.RPK_COMMON_VALIDATION_US	Use (select)
RFRBASE	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RFRBASE	SQL Index	S10B80.FAISMGR	Rely On
RFRBASE_DETAIL_INDEX	SQL Index	S10B80.FAISMGR	Rely On
RFRBASE_FED_INDEX	SQL Index	S10B80.FAISMGR	Rely On
RFRFFID	SQL Table	S10B80.FAISMGR	Join
RJRSEAR	SQL Table	S10B80.FAISMGR	Join
RPTAWRD	SQL Table	S10B80.FAISMGR	Join
RTVFSRC	SQL Table	S10B80.FAISMGR	Refer (no action)
RTVFTYP	SQL Table	S10B80.FAISMGR	Refer (no action)
ET_RFRBASE_AIR_EXTSOL	SQL Trigger	S10B80.BANIMGR	Fire (Insert,after,each row)
ET_RFRBASE_AUR_EXTSOL	SQL Trigger	S10B80.BANIMGR	Fire (update,after,each row)
TBRACCD	SQL Table	S10B80.TAISMGR	Join
TBRMEMO	SQL Table	S10B80.TAISMGR	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RFRBASE

Object Dates

Creation Date	Analysis Date
04/02/2008 10:24:46:000	04/02/2008 10:35:18:000

Source Code Comments

Fund Base Data Table

Columns Comments for RFRBASE_FUND_CODE (# 1)

Source Code Comments

FUND CODE: This field is used to establish and maintain valid fund codes used by the institution.

Columns Comments for RFRBASE_FUND_TITLE (# 2)

Source Code Comments

FUND SHORT TITLE: The short description of the fund code.

Columns Comments for RFRBASE_FSRC_CODE (# 3)

Source Code Comments

FUND SOURCE CODE: This field identifies the fund source code to be associated with the fund code.

Columns Comments for RFRBASE_FTYP_CODE (# 4)

Source Code Comments

FUND TYPE CODE: This field links the fund code to a specific fund type code.

Columns Comments for RFRBASE_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: The date that information for this record in the table was entered or last updated

Columns Comments for RFRBASE_DETAIL_CODE (# 6)

Source Code Comments

ACCOUNTS RECEIVABLE DETAIL CODE: This code is used to link a Financial Aid Fund Code to an AR detail code for crediting funds to student accounts.

Columns Comments for RFRBASE_FED_FUND_ID (# 7)

Source Code Comments

FEDERAL FUND ID: This code specifies the federal fund if appropriate associated with the fund code.

Columns Comments for RFRBASE_PRINT_SEQ_NO (# 8)

Source Code Comments

PRINT SEQUENCE NUMBER: Determines the relative order in which fund codes will print.

Columns Comments for RFRBASE_VR_MSG_NO (# 9)

Source Code Comments

The Voice Response message number assigned to the recorded message that describes the fund code

Columns Comments for RFRBASE_ACTIVE_IND (# 10)

Source Code Comments

ACTIVE INDICATOR: Indicates whether the fund code is active.

Columns Comments for RFRBASE_XREF_VALUE (# 11)

Source Code Comments

FUND CROSS REFERENCE: A user defined cross reference value.

Columns Comments for RFRBASE_FUND_TITLE_LONG (# 12)

Source Code Comments

FUND LONG TITLE: The full description of the fund code.

Table RORDATA

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RORDATA_AIDY_CODE	VARCHAR2(4)	No	*	*
RORDATA_CDE	VARCHAR2(30)	No	*
RORDATA_AUDIT_IND	VARCHAR2(1)	No
RORDATA_PELL_IND	VARCHAR2(1)	No
RORDATA_ACTIVITY_DATE	DATE	No
RORDATA_DESC	VARCHAR2(60)	Yes
RORDATA_INAS_FIELD_NO	VARCHAR2(4)	Yes
RORDATA_SAR_NO	VARCHAR2(3)	Yes
RORDATA_SAR_LENGTH	NUMBER(2,0)	Yes
RORDATA_SAR_TYPE	VARCHAR2(1)	Yes
RORDATA_SYSTEM_REQ_IND	VARCHAR2(1)	Yes
RORDATA_DL_IND	VARCHAR2(1)	Yes
RORDATA_DL_FIELD_NO	VARCHAR2(4)	Yes
RORDATA_DL_TYPE	VARCHAR2(1)	Yes
RORDATA_DL_LENGTH	NUMBER(3,0)	Yes
RORDATA_DL_PLUS_FIELD_NO	VARCHAR2(4)	Yes
RORDATA_EL_IND	VARCHAR2(1)	Yes
RORDATA_EL_CHANGE_TYPE	NUMBER(2,0)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RORDATA_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST

Index

Index Name	Index Type	Column Name
PK_RORDATA	Unique	RORDATA_AIDY_CODE
PK_RORDATA	Unique	RORDATA_CDE
RORDATA_CDE_INDEX		RORDATA_CDE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_LOG_DATA	Oracle Package Procedure	S10B80.BANINST1.RP_APPLICANT_STATUS	Use (select)
P_RESCHED_FUND_TERM_DISBURSE	Oracle Package Procedure	S10B80.BANINST1.ROKMISC	Rely On
P_RESCHED_FUND_TERM_DISBURSE	Oracle Package Procedure	S10B80.BANINST1.ROKMISC	Use (select)
P_RESCHED_TERM_DISBURSE	Oracle Package Procedure	S10B80.BANINST1.ROKMISC	Rely On
P_RESCHED_TERM_DISBURSE	Oracle Package Procedure	S10B80.BANINST1.ROKMISC	Use (select)
RORDATA	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RORDATA	SQL Index	S10B80.FAISMGR	Rely On
RORDATA_CDE_INDEX	SQL Index	S10B80.FAISMGR	Rely On
ROBINST	SQL Table	S10B80.FAISMGR	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RORDATA

Object Dates

Creation Date	Analysis Date
04/02/2008 10:28:22:000	04/02/2008 10:35:21:000

Source Code Comments

Data Dictionary Table

Columns Comments for RORDATA_AIDY_CODE (# 1)

Source Code Comments

AID YEAR CODE: The aid year to be associated with information in this record. EXAMPLES: 9091, 9192, 9293, etc.

Columns Comments for RORDATA_CDE (# 2)

Source Code Comments

DATA ELEMENT CODE: This code defines the data elements in the data base which the institution wishes to log changes.

Columns Comments for RORDATA_AUDIT_IND (# 3)

Source Code Comments

AUDIT TRAIL INDICATOR: This indicator is used to define whether a change to the specific data element should cause the change to be logged in the transaction log file.

Columns Comments for RORDATA_PELL_IND (# 4)

Source Code Comments

PELL CORRECTION INDICATOR: This indicator is used to define whether a change to that data element should log a change to the Pell correction file.

Columns Comments for RORDATA_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: The date that information for this record in the table was entered or last updated

Columns Comments for RORDATA_DESC (# 6)

Source Code Comments

DATA ELEMENT DESCRIPTION: The description of the database data element.

Columns Comments for RORDATA_INAS_FIELD_NO (# 7)

Source Code Comments

INAS FIELD NO: Identifies the corresponding field in INAS.

Columns Comments for RORDATA_SAR_NO (# 8)

Source Code Comments

SAR NUMBER: Defines the SAR field number in which corrections should be made.

Columns Comments for RORDATA_SAR_LENGTH (# 9)

Source Code Comments

SAR FIELD LENGTH: This field indicates the length of the data element field on the EDE Correction Record.

Columns Comments for RORDATA_SAR_TYPE (# 10)

Source Code Comments

SAR TYPE: This field indicates if the field is defined as (A)lpha, (N)umeric, or (B)oth.

Columns Comments for RORDATA_DL_IND (# 12)

Source Code Comments

A Direct Lending audit indicator, specifying whether this field is to be logged for Direct Lending.

Columns Comments for RORDATA_DL_FIELD_NO (# 13)

Source Code Comments

This is the field number assigned by Department of Education to fields loggable in Direct Lending.

Columns Comments for RORDATA_DL_TYPE (# 14)

Source Code Comments

Indicates whether a loggable field is numeric or alphanumeric.

Columns Comments for RORDATA_DL_LENGTH (# 15)

Source Code Comments

Indicates the length of the loggable field.

Columns Comments for RORDATA_EL_IND (# 17)

Source Code Comments

ELECTRONIC LOAN INDICATOR: Indicates this data code is logged for Electronic loan processing. Default value is null. Valid values: Y = yes, null = no.

Columns Comments for RORDATA_EL_CHANGE_TYPE (# 18)

Source Code Comments

CHANGE TRANSACTION RECORD TYPE: The Change Record Transaction type associated with this data code for Electronic loans.

Table RPBLOPT

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RPBLOPT_AIDY_CODE	VARCHAR2(4)	No	*	*
RPBLOPT_CREATE_APP_IND	VARCHAR2(1)	No
RPBLOPT_SAT_TREQ_IND	VARCHAR2(1)	No
RPBLOPT_MEMO_LOAN_AMT_IND	VARCHAR2(1)	No
RPBLOPT_CREATE_AWARD_IND	VARCHAR2(1)	No
RPBLOPT_USE_RQST_AMT_IND	VARCHAR2(1)	No
RPBLOPT_FUND_CODE	VARCHAR2(6)	No	*	*
RPBLOPT_ACTIVITY_DATE	DATE	No
RPBLOPT_LNST_CODE	VARCHAR2(4)	Yes		*
RPBLOPT_LENDER_ID	VARCHAR2(6)	Yes
RPBLOPT_TREQ_CODE	VARCHAR2(6)	Yes		*
RPBLOPT_TRST_CODE	VARCHAR2(1)	Yes		*
RPBLOPT_AWST_CODE	VARCHAR2(4)	Yes		*
RPBLOPT_CREATE_APP_TREQ_IND	VARCHAR2(1)	Yes
RPBLOPT_DL_PN_REQ_ORIG_IND	VARCHAR2(1)	Yes
RPBLOPT_DL_DISB_REQ_ORIG_IND	VARCHAR2(1)	Yes
RPBLOPT_DL_ORIG_REQ_DISB_IND	VARCHAR2(1)	Yes
RPBLOPT_DL_PN_REQ_DISB_IND	VARCHAR2(1)	Yes
RPBLOPT_RETURN_PIDM	NUMBER(8,0)	Yes
RPBLOPT_LENDER_PIDM	NUMBER(8,0)	Yes
RPBLOPT_GUAR_PIDM	NUMBER(8,0)	Yes
RPBLOPT_CERT_REQUEST_AMT_IND	VARCHAR2(1)	Yes
RPBLOPT_DETAIL_CODE_RET_STU	VARCHAR2(4)	Yes
RPBLOPT_DETAIL_CODE_LNDR_PMT	VARCHAR2(4)	Yes
RPBLOPT_DETAIL_CODE_LNDR_REF	VARCHAR2(4)	Yes
RPBLOPT_AUTHORIZE_IND	VARCHAR2(1)	Yes
RPBLOPT_DISB_AMT_IND	VARCHAR2(1)	Yes
RPBLOPT_EL_AUDIT_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RPBLOPT_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RPBLOPT_AWST_CODE	RTVAWST_CODE	RTVAWST
RPBLOPT_LNST_CODE	RTVLNST_CODE	RTVLNST
RPBLOPT_TREQ_CODE	RTVTREQ_CODE	RTVTREQ
RPBLOPT_TRST_CODE	RTVTRST_CODE	RTVTRST
RPBLOPT_FUND_CODE	RPRLATR_FUND_CODE	RPRLATR

Index

Index Name	Index Type	Column Name
PK_RPBLOPT	Unique	RPBLOPT_AIDY_CODE
PK_RPBLOPT	Unique	RPBLOPT_FUND_CODE
RPBLOPT_FUND_INDEX		RPBLOPT_FUND_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
STVTERM	SQL Table	S10B80.SATURN	Join
LOPT_REC	Oracle Package Type	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
LOPT_REC	Oracle Package Type	S10B80.BANINST1.RPK_DISB_VALIDATION	Rely On
P_SATISFY_REQUIREMENT	Oracle Package Procedure	S10B80.BANINST1.RPKAWRD	Rely On
F_GET_RPBLOPT_DATA	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Use (select)
F_GET_RPBLOPT_DATA	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION	Use (select)
F_LOAN_PERIOD_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_AWARD	Use (select)
P_ADD_AWARD_REC	Oracle Package Procedure	S10B80.BANINST1.RPKLOAN	Use (select)
P_ADD_AWARD_TERM_REC	Oracle Package Procedure	S10B80.BANINST1.RPKLOAN	Use (select)
P_ADD_LOAN_APPLICATION_RECORD	Oracle Package Procedure	S10B80.BANINST1.RPKAWRD	Rely On
P_ADD_LOAN_APPLICATION_RECORD	Oracle Package Procedure	S10B80.BANINST1.RPKAWRD	Use (select)
P_ADD_LOAN_PROCESS	Oracle Package Procedure	S10B80.BANINST1.RPKLOAN	Use (select)
P_CREATE_FUND	Oracle Package Procedure	S10B80.BANINST1.RPK_DEBS_DISPLAYS	Use (Insert)
P_DISPLAY_RPBLOPT	Oracle Package Procedure	S10B80.BANINST1.RPK_DEBS_DISPLAYS	Rely On
P_DISPLAY_RPBLOPT	Oracle Package Procedure	S10B80.BANINST1.RPK_DEBS_DISPLAYS	Use (select)Rely On
P_SELECT_DL_DISB_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Use (select)
P_SELECT_DL_DISB_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Use (select)
P_SELECT_DL_DISB_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Use (select)
P_SELECT_DL_DISB_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Use (select)
P_SELECT_DL_DISB_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Use (select)
P_SELECT_DL_PNOTE_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Rely On
P_SELECT_DL_PNOTE_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Use (select)
P_SELECT_DL_PNOTE_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Rely On
P_SELECT_DL_PNOTE_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Use (select)
P_SELECT_DL_PNOTE_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_SELECT_DL_PNOTE_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Use (select)
P_SELECT_DL_PNOTE_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_SELECT_DL_PNOTE_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Use (select)
P_SELECT_DL_PNOTE_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_SELECT_DL_PNOTE_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_TEMP_AWARD	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_AWARD	Use (Insert,select)
RPBLOPT	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RPBLOPT	SQL Index	S10B80.FAISMGR	Rely On
RPBLOPT_FUND_INDEX	SQL Index	S10B80.FAISMGR	Rely On
ROBINST	SQL Table	S10B80.FAISMGR	Refer (no action)
RPRLATR	SQL Table	S10B80.FAISMGR	Join
RTVAWST	SQL Table	S10B80.FAISMGR	Refer (no action)
RTVLNST	SQL Table	S10B80.FAISMGR	Refer (no action)
RTVTREQ	SQL Table	S10B80.FAISMGR	Refer (no action)
RTVTRST	SQL Table	S10B80.FAISMGR	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RPBLOPT

Object Dates

Creation Date	Analysis Date
04/02/2008 10:30:33:000	04/02/2008 10:35:22:000

Source Code Comments

Loan Options Table

Columns Comments for RPBLOPT_AIDY_CODE (# 1)

Source Code Comments

AID YEAR CODE: The aid year associated with the information contained in this record.

Columns Comments for RPBLOPT_CREATE_APP_IND (# 2)

Source Code Comments

CREATE APPLICATION INDICATOR: This indicator determines whether a loan accepted within the Packaging Module will automatically create a loan application. Valid values are (Y)es and (N)o which defaults to (N)o.

Columns Comments for RPBLOPT_SAT_TREQ_IND (# 3)

Source Code Comments

SATISFY LOAN APPLICATION REQUIREMENT INDICATOR: This field indicates whether a loan application requirement will should be satisfied by the entry of aa loan application. Valid values are (Y)es or (N)o with a default of (N)o.

Columns Comments for RPBLOPT_MEMO_LOAN_AMT_IND (# 4)

Source Code Comments

MEMO ACTUAL LOAN AMOUNT INDICATOR: This indicator determines whether the actual loan amounts on the Loan Term Schedule Table (RPRLATR) will be used during memo'ing. Valid values are (Y)es or (N)o, defaults to (N)o.

Columns Comments for RPBLOPT_CREATE_AWARD_IND (# 5)

Source Code Comments

CREATE AWARD INDICATOR: This indicator determines whether a loan application entered in the loan module should automatically create an award if one does not exist within the applicant's package. Valid values (Y)es and (N)o.

Columns Comments for RPBLOPT_USE_RQST_AMT_IND (# 6)

Source Code Comments

USE REQUESTED AMOUNT INDICATOR: This field determines whether the award amount when posted should be posted as the loan requested amount, or as a zero. (Y)es indicates to post the student's award with the requested loan amount.

Columns Comments for RPBLOPT_FUND_CODE (# 7)

Source Code Comments

FUND CODE: This field identifies the fund code that will be added to the students award record if the Create Award Indicator is set to (Y)es.

Columns Comments for RPBLOPT_ACTIVITY_DATE (# 8)

Source Code Comments

ACTIVITY DATE: This field maintains the date that information in this record was entered or last updated.

Columns Comments for RPBLOPT_LNST_CODE (# 9)

Source Code Comments

INITIAL LOAN STATUS: This field is used to identify the loan status to be used when the system creates a loan application. This can only be maintained when the loan accepted indicator is set to (Y)es.

Columns Comments for RPBLOPT_LENDER_ID (# 10)

Source Code Comments

DEFAULT LENDER ID: This code identifies the default lender ID to be used during loan processing.

Columns Comments for RPBLOPT_TREQ_CODE (# 11)

Source Code Comments

LOAN APPLICATION TRACKING REQUIREMENT CODE: This field identifies the tracking requirement code to be used when the system satisfies a loan application requirement. This can only be maintained when Satis.Loan Req. Indicator= (Y).

Columns Comments for RPBLOPT_TRST_CODE (# 12)

Source Code Comments

TRACKING REQUIREMENT STATUS CODE: This code identifies the requirement status code to be used when the system satisfies a loan application requirement. This can only be maintained when the Satisfy Loan Application Indicator is (Y)es.

Columns Comments for RPBLOPT_AWST_CODE (# 13)

Source Code Comments

AWARD STATUS CODE: This field identifies the award status code which a loan award will be added to the students award record if the Create Award indicator is set to (Y)es.

Columns Comments for RPBLOPT_CREATE_APP_TREQ_IND (# 14)

Source Code Comments

Indicator to be used for creation of a loan application when the loan application tracking requirement is satisfied

Columns Comments for RPBLOPT_RETURN_PIDM (# 19)

Source Code Comments

RETURN PIDM: The internal pidm for the default Agency/Lender to whom unused funds are to be returned for this loan code.

Columns Comments for RPBLOPT_LENDER_PIDM (# 20)

Source Code Comments

LENDER PIDM: The internal pidm for the default Lender associated with this loan code.

Columns Comments for RPBLOPT_GUAR_PIDM (# 21)

Source Code Comments

GUARANTOR PIDM: The internal pidm for the default Guarantee Agency associated with this loan code.

Columns Comments for RPBLOPT_CERT_REQUEST_AMT_IND (# 22)

Source Code Comments

CERTIFICATION REQUEST AMOUNT INDICATOR: If the loan requested amount is required for certification, this will be Y.

Columns Comments for RPBLOPT_DETAIL_CODE_RET_STU (# 23)

Source Code Comments

RETURNED CHECK STUDENT DETAIL CODE: The charge/payment detail code to be used on the student account when a returned check amount is processed by the disbursement process.

Columns Comments for RPBLOPT_DETAIL_CODE_LNDR_PMT (# 24)

Source Code Comments

RETURNED CHECK LENDER PAYMENT DETAIL CODE: The payment detail code to be used on the lender account when a returned check amount is processed on a student account by the disbursement process.

Columns Comments for RPBLOPT_DETAIL_CODE_LNDR_REF (# 25)

Source Code Comments

RETURNED CHECK LENDER REFUND DETAIL CODE: The charge detail code to be used on the lender account to allow a refund to the lender when a returned check amount is processed on a student account by
the disbursement process.

Columns Comments for RPBLOPT_AUTHORIZE_IND (# 26)

Source Code Comments

LOAN AUTHORIZATION INDICATOR: Indicates whether to create loan authorizations for this aid year and fund code when disbursing funds.

Columns Comments for RPBLOPT_DISB_AMT_IND (# 27)

Source Code Comments

LOAN DISBURSEMENT AMOUNT INDICATOR: This field indicates whether to prevent loan disbursement if Disbursement Amount > Award Amount.

Columns Comments for RPBLOPT_EL_AUDIT_IND (# 28)

Source Code Comments

CHANGE TRANSACTION INDICATOR: Flags whether or not the school will use CommonLine Change Transaction processing. Default value is Null. Valid values: Y yes, Null means No.

Table RPBLPRD

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
RPBLPRD_LOAN_PERIOD	VARCHAR2(6)	No	*
RPBLPRD_DESC	VARCHAR2(30)	No
RPBLPRD_START_DATE	DATE	No
RPBLPRD_END_DATE	DATE	No
RPBLPRD_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_RPBLPRD	Unique	RPBLPRD_LOAN_PERIOD

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RPRLAPP	SQL Table	S10B80.FAISMGR	Join
RPRLPAP	SQL Table	S10B80.FAISMGR	Refer (no action)
RPRLTRM	SQL Table	S10B80.FAISMGR	Refer (no action)
LOAN_DETAIL_TYPE	Oracle Package Type	S10B80.BANINST1.BWRKLHST	Rely On
GETLOANDTLC	Oracle Package Cursor	S10B80.BANINST1.BWRKLHST	Use (select)
P_CREATE_LOAN_PERIOD	Oracle Package Procedure	S10B80.BANINST1.RPK_DEBS_DISPLAYS	Use (Insert)
P_PA_RPBLPRD_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE05	Use (select)
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE06	Use (select)
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE05	Use (select)
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE06	Use (select)
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
RPBLPRD	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RPBLPRD	SQL Index	S10B80.FAISMGR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RPBLPRD

Object Dates

Creation Date	Analysis Date
04/02/2008 10:31:48:000	04/02/2008 10:35:24:000

Source Code Comments

Loan Period Base Data Table

Columns Comments for RPBLPRD_LOAN_PERIOD (# 1)

Source Code Comments

LOAN PERIOD: This field contains any possible loan periods for which a loan can be processed.

Columns Comments for RPBLPRD_DESC (# 2)

Source Code Comments

LOAN PERIOD DESCRIPTION: The description associated with the loan period.

Columns Comments for RPBLPRD_START_DATE (# 3)

Source Code Comments

LOAN PERIOD START DATE: The start date of the loan period.

Columns Comments for RPBLPRD_END_DATE (# 4)

Source Code Comments

LOAN PERIOD END DATE: The ending date of the loan period. This date is required and must be greater than the start date.

Columns Comments for RPBLPRD_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: This field maintains the date that the information in this record was entered or last updated.

Table RPRASTD

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RPRASTD_PIDM	NUMBER(8,0)	No	*
RPRASTD_SEQ_NO	NUMBER(3,0)	No	*
RPRASTD_CREDIT_ACCT	VARCHAR2(6)	No	*
RPRASTD_APPLIED_DATE	DATE	No
RPRASTD_REQUEST_AMT	NUMBER(11,2)	No
RPRASTD_DUE_DATE	DATE	No
RPRASTD_ACTIVITY_DATE	DATE	Yes
RPRASTD_APPROVE_DATE	DATE	Yes
RPRASTD_APPROVE_AMT	NUMBER(11,2)	Yes
RPRASTD_CINT_CODE	VARCHAR2(4)	Yes		*
RPRASTD_RPSR_CODE	VARCHAR2(4)	Yes		*
RPRASTD_RECEIVE_DATE	DATE	Yes
RPRASTD_REPAID_DATE	DATE	Yes
RPRASTD_REPAID_AMT	NUMBER(11,2)	Yes
RPRASTD_RECEIVE_AMT	NUMBER(11,2)	Yes
RPRASTD_COLLECT_AMT	NUMBER(11,2)	Yes
RPRASTD_BALANCE_DUE	NUMBER(11,2)	Yes
RPRASTD_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RPRASTD_CINT_CODE	RTVCINT_CODE	RTVCINT
RPRASTD_RPSR_CODE	RTVRPSR_CODE	RTVRPSR

Index

Index Name	Index Type	Column Name
PK_RPRASTD	Unique	RPRASTD_PIDM
PK_RPRASTD	Unique	RPRASTD_SEQ_NO
PK_RPRASTD	Unique	RPRASTD_CREDIT_ACCT

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RPRASTD	SQL Index	S10B80.FAISMGR	Rely On
RTVCINT	SQL Table	S10B80.FAISMGR	Refer (no action)
RTVRPSR	SQL Table	S10B80.FAISMGR	Refer (no action)
RT_RPRASTD_LOG_INSUPDDTL	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,delete,after,each row)
RT_RPRASTD_USERACTIVIT_INSUPD	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,before,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RPRASTD

Object Dates

Creation Date	Analysis Date
04/02/2008 10:28:57:000	04/02/2008 10:35:21:000

Source Code Comments

Applicant Short-Term Credit Table

Columns Comments for RPRASTD_PIDM (# 1)

Source Code Comments

PIDM: Internal system generated student identification number.

Columns Comments for RPRASTD_SEQ_NO (# 2)

Source Code Comments

SEQUENCE NUMBER: This field maintains the sequence number of the short-term credit application.

Columns Comments for RPRASTD_CREDIT_ACCT (# 3)

Source Code Comments

CREDIT ACCOUNT: This field identifies the funding source of the loan. Example: Emergency Loan Fund.

Columns Comments for RPRASTD_APPLIED_DATE (# 4)

Source Code Comments

APPLIED DATE: This field maintains the application date of the short-term loan.

Columns Comments for RPRASTD_REQUEST_AMT (# 5)

Source Code Comments

REQUESTED AMOUNT: This field maintains the amount of the short-term loan that was requested.

Columns Comments for RPRASTD_DUE_DATE (# 6)

Source Code Comments

DUE DATE: This field maintains the due date of the short-term loan.

Columns Comments for RPRASTD_ACTIVITY_DATE (# 7)

Source Code Comments

ACTIVITY DATE: This field maintains the date that information in this record was entered or last updated.

Columns Comments for RPRASTD_APPROVE_DATE (# 8)

Source Code Comments

APPROVED DATE: This field maintains the date that the short-term credit application was approved.

Columns Comments for RPRASTD_APPROVE_AMT (# 9)

Source Code Comments

APPROVED AMOUNT: This field maintains the approved amount of the short-term loan.

Columns Comments for RPRASTD_CINT_CODE (# 10)

Source Code Comments

CERTIFICATION INITIALS: This field maintains the initials of the person who approved the short-term credit application.

Columns Comments for RPRASTD_RPSR_CODE (# 11)

Source Code Comments

REPAYMENT SOURCE: This field maintains the source of repayment.

Columns Comments for RPRASTD_RECEIVE_DATE (# 12)

Source Code Comments

RECEIVED DATE: This field maintains the date that the student received the short-term loan.

Columns Comments for RPRASTD_REPAID_DATE (# 13)

Source Code Comments

REPAID DATE: This field maintains the most recent date that repayment was made.

Columns Comments for RPRASTD_REPAID_AMT (# 14)

Source Code Comments

REPAID AMOUNT: This field maintains the amount of the actual repayment.

Columns Comments for RPRASTD_RECEIVE_AMT (# 15)

Source Code Comments

AMOUNT RECEIVED: This is the amount of the short-term loan that was actually paid to the student.

Columns Comments for RPRASTD_COLLECT_AMT (# 16)

Source Code Comments

COLLECTION FEE: This is the amount of collection, penalty or interest charges on the short-term credit loan application of the student.

Columns Comments for RPRASTD_BALANCE_DUE (# 17)

Source Code Comments

BALANCE DUE: This is the current balance due on the loan record accounting for the amount actually paid, partial repayments, and extra fees charged for collection, interest, penalties, or processing fees.

Columns Comments for RPRASTD_USER_ID (# 18)

Source Code Comments

USER ID: The logon ID of the user who entered or last updated this row in this table.

Table RPRLADB

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
RPRLADB_PIDM	NUMBER(8,0)	No	*
RPRLADB_FUND_CODE	VARCHAR2(6)	No
RPRLADB_APPL_NO	NUMBER(3,0)	No	*
RPRLADB_DISBURSE_DATE	DATE	No
RPRLADB_TERM_CODE	VARCHAR2(6)	No
RPRLADB_SEQ_NO	NUMBER(2,0)	No
RPRLADB_LOAN_PCT	NUMBER(6,3)	No
RPRLADB_ACTIVITY_DATE	DATE	No
RPRLADB_FEED_IND	VARCHAR2(1)	No
RPRLADB_CHECK_AMT	NUMBER(11,2)	Yes
RPRLADB_CHECK_DATE	DATE	Yes
RPRLADB_STU_RECEIVE_DATE	DATE	Yes
RPRLADB_FEED_DATE	DATE	Yes
RPRLADB_CHECK_RETURN_AMT	NUMBER(11,2)	Yes
RPRLADB_CHECK_RETURN_DATE	DATE	Yes
RPRLADB_TRAN_NUMBER	NUMBER(8,0)	Yes
RPRLADB_MEMO_EXP_DAYS	NUMBER(3,0)	Yes
RPRLADB_DISBURSE_LOAD	VARCHAR2(1)	Yes
RPRLADB_DISBURSE_LOAD_OPT	VARCHAR2(1)	Yes
RPRLADB_AIDY_CODE	VARCHAR2(4)	Yes
RPRLADB_DL_SEQ_NO	NUMBER(2,0)	Yes
RPRLADB_USER_ID	VARCHAR2(30)	Yes
RPRLADB_DISB_STATUS	VARCHAR2(1)	Yes
RPRLADB_RECONCILE_IND	VARCHAR2(4)	Yes
RPRLADB_RECONCILE_DATE	DATE	Yes
RPRLADB_BATCH_NO	VARCHAR2(23)	Yes
RPRLADB_CANCEL_IND	VARCHAR2(1)	Yes
RPRLADB_CANCEL_DATE	DATE	Yes
RPRLADB_REFUND_AMT	NUMBER(5,0)	Yes
RPRLADB_REFUND_DATE	DATE	Yes
RPRLADB_DL_GROSS_AMT	NUMBER(5,0)	Yes
RPRLADB_DL_FEE_AMT	NUMBER(5,0)	Yes
RPRLADB_PN_DISB_DATE	DATE	Yes
RPRLADB_DL_DISB_NO	NUMBER(2,0)	Yes
RPRLADB_RECON_BATCH_NO	VARCHAR2(23)	Yes
RPRLADB_SERV_GROSS_AMT	NUMBER(5,0)	Yes
RPRLADB_SERV_FEE_AMT	NUMBER(5,0)	Yes
RPRLADB_SERV_NET_AMT	NUMBER(5,0)	Yes
RPRLADB_SERV_NET_ADJ_AMT	NUMBER(6,0)	Yes
RPRLADB_SERV_LOANID_ERR	VARCHAR2(1)	Yes
RPRLADB_SERV_DISBNO_ERR	VARCHAR2(1)	Yes
RPRLADB_SERV_ACTION_ERR	VARCHAR2(1)	Yes
RPRLADB_SERV_DATE_ERR	VARCHAR2(1)	Yes
RPRLADB_SERV_SEQNO_ERR	VARCHAR2(1)	Yes
RPRLADB_REF_ID	VARCHAR2(15)	Yes
RPRLADB_RET_LNDR_DATE	DATE	Yes
RPRLADB_EFT_IND	VARCHAR2(1)	Yes
RPRLADB_COMMENT	VARCHAR2(60)	Yes
RPRLADB_DISB_BYPASS	VARCHAR2(1)	Yes
RPRLADB_DL_REJECT_CODE_1	VARCHAR2(3)	Yes
RPRLADB_DL_REJECT_CODE_2	VARCHAR2(3)	Yes
RPRLADB_DL_REJECT_CODE_3	VARCHAR2(3)	Yes
RPRLADB_DL_REJECT_CODE_4	VARCHAR2(3)	Yes
RPRLADB_DL_REJECT_CODE_5	VARCHAR2(3)	Yes
RPRLADB_DL_RECON_REJECT_1	VARCHAR2(3)	Yes
RPRLADB_DL_RECON_REJECT_2	VARCHAR2(3)	Yes
RPRLADB_DL_RECON_REJECT_3	VARCHAR2(3)	Yes
RPRLADB_DL_RECON_REJECT_4	VARCHAR2(3)	Yes
RPRLADB_DL_RECON_REJECT_5	VARCHAR2(3)	Yes
RPRLADB_DL_ACKN_DATE	DATE	Yes
RPRLADB_SAS_END_DATE	DATE	Yes
RPRLADB_SAS_PROCESS_DATE	DATE	Yes
RPRLADB_SCHOOL_CODE	VARCHAR2(6)	Yes
RPRLADB_SAS_RECORD_COUNT_SEQ	NUMBER(6,0)	Yes
RPRLADB_FEES_PAID	NUMBER(7,2)	Yes
RPRLADB_AFFIRM_FLAG	VARCHAR2(1)	Yes
RPRLADB_HOLD_REL_STATUS	VARCHAR2(2)	Yes
RPRLADB_REV_DISB_AMT	NUMBER(8,2)	Yes
RPRLADB_PRIOR_DISB_DATE	DATE	Yes
RPRLADB_DISB_OVERRIDE_IND	VARCHAR2(1)	Yes
RPRLADB_DL_REBATE_AMT	NUMBER(5,0)	Yes
RPRLADB_SERV_REBATE_AMT	NUMBER(5,0)	Yes
RPRLADB_SERV_BOOKED_STATUS	VARCHAR2(1)	Yes
RPRLADB_SERV_BOOKED_DATE	DATE	Yes
RPRLADB_EL_HOLD_REL_DATE	DATE	Yes
RPRLADB_EL_REV_GROSS_AMT	NUMBER(11,2)	Yes
RPRLADB_EL_DISB_NO	NUMBER(2,0)	Yes
RPRLADB_SERV_TRANS_TYPE	VARCHAR2(1)	Yes
RPRLADB_REGION_CD	VARCHAR2(2)	Yes
RPRLADB_SCHOOL_STAT_CODE	VARCHAR2(2)	Yes
RPRLADB_EL_SERV_GROSS_AMT	NUMBER(7,2)	Yes
RPRLADB_EL_SERV_ORIG_FEE	NUMBER(7,2)	Yes
RPRLADB_EL_SERV_GUAR_FEE	NUMBER(7,2)	Yes
RPRLADB_EL_SERV_NET_AMT	NUMBER(7,2)	Yes
RPRLADB_EL_SERV_DISB_DATE	DATE	Yes
RPRLADB_EL_SERV_GUAR_FEE_PAID	NUMBER(7,2)	Yes
RPRLADB_EL_SERV_ORIG_FEE_PAID	NUMBER(7,2)	Yes
RPRLADB_DOCUMENT_ID	VARCHAR2(30)	Yes
RPRLADB_PREV_DISB_SEQ_NO	NUMBER(2,0)	Yes
RPRLADB_DATA_ORIGIN	VARCHAR2(30)	Yes
RPRLADB_DL_EDIT_FIELD_1	VARCHAR2(35)	Yes
RPRLADB_DL_EDIT_FIELD_2	VARCHAR2(35)	Yes
RPRLADB_DL_EDIT_FIELD_3	VARCHAR2(35)	Yes
RPRLADB_DL_EDIT_FIELD_4	VARCHAR2(35)	Yes
RPRLADB_DL_EDIT_FIELD_5	VARCHAR2(35)	Yes
RPRLADB_EL_BOR_DIRECT_DISB_IND	VARCHAR2(1)	No
RPRLADB_EL_DIRECT_CHECK_AMT	NUMBER(7,2)	Yes
RPRLADB_EXCLUDE_LNEX_FLAG	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RPRLADB_APPL_NO	RPRLAPP_APPL_NO	RPRLAPP
RPRLADB_PIDM	RPRLAPP_PIDM	RPRLAPP

Index

Index Name	Index Type	Column Name
RPRLADB_KEY_INDEX	Unique	RPRLADB_PIDM
RPRLADB_KEY_INDEX	Unique	RPRLADB_FUND_CODE
RPRLADB_KEY_INDEX	Unique	RPRLADB_APPL_NO
RPRLADB_KEY_INDEX	Unique	RPRLADB_TERM_CODE
RPRLADB_KEY_INDEX	Unique	RPRLADB_DISBURSE_DATE
RPRLADB_KEY_INDEX	Unique	RPRLADB_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
F_ALL_DISB	SQL Function	S10B80.BANINST1	Use (select)
F_DISB_TOT	SQL Function	S10B80.BANINST1	Use (select)
F_EST_LOAN	SQL Function	S10B80.BANINST1	Rely On
F_EST_LOAN	SQL Function	S10B80.BANINST1	Use (select)
F_PEND_TOT	SQL Function	S10B80.BANINST1	Use (select)
F_SERV_NET	SQL Function	S10B80.BANINST1	Use (select)
LOAN_AMOUNTS_TYPE	Oracle Package Type	S10B80.BANINST1.BWRKLHST	Rely On
LOAN_DISB_REC	Oracle Package Type	S10B80.BANINST1.RPK_DISB_VALIDATION	Rely On
P_ADD_LOAN_DISBURSE_REC	Oracle Package Procedure	S10B80.BANINST1.RPKAWRD	Rely On
P_ADD_LOAN_DISBURSE_REC	Oracle Package Procedure	S10B80.BANINST1.RPKAWRD	Use (Insert)
P_INSERT_SERVICER_REFUNDS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_INSERT_SERVICER_REFUNDS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_INSERT_SERVICER_REFUNDS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_INSERT_SERVICER_REFUNDS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_INSERT_SERVICER_REFUNDS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATEDLDISB	Oracle Package Procedure	S10B80.BANINST1.REKCI04	Rely On
P_UPDATEDLDISB	Oracle Package Procedure	S10B80.BANINST1.REKCI04	Use (update,select)Rely On
RPRLADB_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI04	Rely On
F_GET_LOAN_DISB_DATA	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION	Rely On
F_GET_LOAN_DISB_DATA	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION	Use (select)
F_VAL_DISB_DATE_ORDER	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_VAL_DISB_DATE_ORDER	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Use (select)
F_VAL_DISB_NO_ORDER	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_VAL_DISB_NO_ORDER	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Use (select)
F_VAL_ENDORSER_AMOUNT	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_VAL_ENDORSER_AMOUNT	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Use (select)
GETAMTSC	Oracle Package Cursor	S10B80.BANINST1.BWRKLHST	Use (select)
P_CALC_DL_DISBURSEMENT	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Rely On
P_CALC_DL_DISBURSEMENT	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Use (select)
P_CALC_DL_DISBURSEMENT	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Rely On
P_CALC_DL_DISBURSEMENT	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Use (select)
P_CALC_DL_DISBURSEMENT	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_CALC_DL_DISBURSEMENT	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Use (select)
P_CALC_DL_DISBURSEMENT	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_CALC_DL_DISBURSEMENT	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Use (select)
P_CALC_DL_DISBURSEMENT	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_CALC_DL_DISBURSEMENT	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Use (select)
P_CALC_DL_DISBURSEMENT	Oracle Package Procedure	S10B80.BANINST1.REKCEXX	Rely On
P_DISPLAY_RPRLADB	Oracle Package Procedure	S10B80.BANINST1.RPK_DEBS_DISPLAYS	Rely On
P_DISPLAY_RPRLADB	Oracle Package Procedure	S10B80.BANINST1.RPK_DEBS_DISPLAYS	Use (select)Rely On
P_SELECT_DL_DISB_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Rely On
P_SELECT_DL_DISB_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Use (select)
P_SELECT_DL_DISB_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Rely On
P_SELECT_DL_DISB_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Use (select)
P_SELECT_DL_DISB_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_SELECT_DL_DISB_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Use (select)
P_SELECT_DL_DISB_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_SELECT_DL_DISB_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Use (select)
P_SELECT_DL_DISB_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_SELECT_DL_DISB_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Use (select)
P_SELECT_DL_DISB_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCEXX	Rely On
P_UPDATE_DLPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_DLPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Use (update,select)Rely On
P_UPDATE_DLPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_DLPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Use (update,select)Rely On
P_UPDATE_DLPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_DLPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (update,select)Rely On
P_UPDATE_DLPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_DLPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (update,select)Rely On
P_UPDATE_DLPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_DLPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (update,select)Rely On
P_UPDATE_DLPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCIXX	Rely On
P_UPDATE_DLSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_DLSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Use (update,select)Rely On
P_UPDATE_DLSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_DLSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Use (update,select)Rely On
P_UPDATE_DLSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_DLSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (update,select)Rely On
P_UPDATE_DLSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_DLSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (update,select)Rely On
P_UPDATE_DLSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_DLSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (update,select)Rely On
P_UPDATE_DLSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCIXX	Rely On
P_UPDATE_DLUNSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_DLUNSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Use (update,select)Rely On
P_UPDATE_DLUNSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_DLUNSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Use (update,select)Rely On
P_UPDATE_DLUNSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_DLUNSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (update,select)Rely On
P_UPDATE_DLUNSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_DLUNSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (update,select)Rely On
P_UPDATE_DLUNSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_DLUNSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (update,select)Rely On
P_UPDATE_DLUNSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCIXX	Rely On
P_UPDATE_DL_DISBURSEMENT	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Rely On
P_UPDATE_DL_DISBURSEMENT	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Use (update)
P_UPDATE_DL_DISBURSEMENT	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Rely On
P_UPDATE_DL_DISBURSEMENT	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Use (update)
P_UPDATE_DL_DISBURSEMENT	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_UPDATE_DL_DISBURSEMENT	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Use (update)
P_UPDATE_DL_DISBURSEMENT	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_UPDATE_DL_DISBURSEMENT	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Use (update)
P_UPDATE_DL_DISBURSEMENT	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_UPDATE_DL_DISBURSEMENT	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Use (update)
P_UPDATE_DL_DISBURSEMENT	Oracle Package Procedure	S10B80.BANINST1.REKCEXX	Rely On
P_UPDATE_GPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_GPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Use (update,select)Rely On
P_UPDATE_GPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_GPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (update,select)Rely On
P_UPDATE_GPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_GPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (update,select)Rely On
P_UPDATE_GPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_GPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (update,select)Rely On
P_VALIDATE_DL_DISBURSEMENT	Oracle Package Procedure	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
P_VALIDATE_EL_DISBURSEMENT	Oracle Package Procedure	S10B80.BANINST1.RPK_DISB_VALIDATION	Rely On
F_FIRST_TIME_BORROWER	Oracle Package Function	S10B80.BANINST1.RPKLOAN	Rely On
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE05	Use (select)
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE06	Use (select)
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
F_SELECT_DL_DISBURSEMENTS	Oracle Package Function	S10B80.BANINST1.REKCE05	Rely On
F_SELECT_DL_DISBURSEMENTS	Oracle Package Function	S10B80.BANINST1.REKCE05	Use (select)
F_SELECT_DL_DISBURSEMENTS	Oracle Package Function	S10B80.BANINST1.REKCE06	Rely On
F_SELECT_DL_DISBURSEMENTS	Oracle Package Function	S10B80.BANINST1.REKCE06	Use (select)
F_SELECT_DL_DISBURSEMENTS	Oracle Package Function	S10B80.BANINST1.REKCE07	Rely On
F_SELECT_DL_DISBURSEMENTS	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_DL_DISBURSEMENTS	Oracle Package Function	S10B80.BANINST1.REKCE08	Rely On
F_SELECT_DL_DISBURSEMENTS	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_DL_DISBURSEMENTS	Oracle Package Function	S10B80.BANINST1.REKCE09	Rely On
F_SELECT_DL_DISBURSEMENTS	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
F_SELECT_DL_DISBURSEMENTS	Oracle Package Function	S10B80.BANINST1.REKCEXX	Rely On
F_SELECT_PELL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE05	Rely On
F_SELECT_PELL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE06	Rely On
F_SELECT_PELL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE07	Rely On
F_SELECT_PELL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE08	Rely On
F_SELECT_PELL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE09	Rely On
F_SELECT_PELL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCEXX	Rely On
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE05	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE06	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
RPRLADB	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RPRLADB_KEY_INDEX	SQL Index	S10B80.FAISMGR	Rely On
RPRLAPP	SQL Table	S10B80.FAISMGR	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RPRLADB

Object Dates

Creation Date	Analysis Date
04/02/2008 10:26:57:000	04/02/2008 10:35:20:000

Source Code Comments

Loan Disbursement Schedule

Columns Comments for RPRLADB_FUND_CODE (# 2)

Source Code Comments

FUND: The fund code associated with this loan application.

Columns Comments for RPRLADB_DISBURSE_DATE (# 4)

Source Code Comments

SCHEDULED DISBURSEMENT DATE: Used by the disbursement process as the first date on which this disbursement may occur.

Columns Comments for RPRLADB_TERM_CODE (# 5)

Source Code Comments

TERM CODE: The term associated with this individual disbursement.

Columns Comments for RPRLADB_SEQ_NO (# 6)

Source Code Comments

SEQUENCE NUMBER: This sequence number starts at one for each scheduled loan disbursement, and is incremented by one each time an adjustment is made to the disbursement.

Columns Comments for RPRLADB_LOAN_PCT (# 7)

Source Code Comments

DISBURSEMENT PERCENTAGE: The percentage of total loan that this disbursement represents.

Columns Comments for RPRLADB_FEED_IND (# 9)

Source Code Comments

FEED INDICATOR: Feed to Banner A/R - Valid Values are (Y)es, (N)o, or (F)ed. Fed is valid for display only to show that this disbursement has been fed to the student's account.

Columns Comments for RPRLADB_CHECK_AMT (# 10)

Source Code Comments

NET AMOUNT: This is the net amount of this particular disbursement.

Columns Comments for RPRLADB_FEED_DATE (# 13)

Source Code Comments

PAID DATE: Date that the disbursement was fed to the student's account in Banner A/R.

Columns Comments for RPRLADB_CHECK_RETURN_AMT (# 14)

Source Code Comments

RETURNED AMT: Amount of the loan that was returned during an adjustment.

Columns Comments for RPRLADB_CHECK_RETURN_DATE (# 15)

Source Code Comments

RETURNED DATE: The date that the adjusted loan amount was returned.

Columns Comments for RPRLADB_TRAN_NUMBER (# 16)

Source Code Comments

TRANSACTION NUMBER: The transaction number on student's account in Banner A/R where the disbursement was applied.

Columns Comments for RPRLADB_DISBURSE_LOAD (# 18)

Source Code Comments

DISBURSEMENT LOAD: This displays the student's enrollment load calculated at the time of disbursement.

Columns Comments for RPRLADB_DISBURSE_LOAD_OPT (# 19)

Source Code Comments

DISBURSEMENT OPTION: This displays the student's enrollment option used for the disbursement load.

Columns Comments for RPRLADB_DISB_STATUS (# 23)

Source Code Comments

DISBURSEMENT STATUS CODE: The processing status of the disbursement

Columns Comments for RPRLADB_BATCH_NO (# 26)

Source Code Comments

BATCH NO: This is the batch number related to the disbursement acknowledgement file for this individual disbursement.

Columns Comments for RPRLADB_DL_GROSS_AMT (# 31)

Source Code Comments

GROSS AMOUNT: Gross Amount of Loan.

Columns Comments for RPRLADB_DL_FEE_AMT (# 32)

Source Code Comments

FEE AMOUNT: Amount of DL Fees.

Columns Comments for RPRLADB_PN_DISB_DATE (# 33)

Source Code Comments

PROMISSORY NOTE DISBURSEMENT DATE: Disbursement Date printed on the Promissory Note. No longer required for MPN processing.

Columns Comments for RPRLADB_DL_DISB_NO (# 34)

Source Code Comments

DISBURSEMENT NUMBER: DL Disbursement Number.

Columns Comments for RPRLADB_RECON_BATCH_NO (# 35)

Source Code Comments

RECONCILIATION BATCH NUMBER: The batch number of the cash reconciliation in which this direct loan disbursement was included.

Columns Comments for RPRLADB_SERV_GROSS_AMT (# 36)

Source Code Comments

GROSS AMOUNT: The gross amount recorded in the Account Statement.

Columns Comments for RPRLADB_SERV_FEE_AMT (# 37)

Source Code Comments

FEES: The Fees amount recorded in the Account Statement.

Columns Comments for RPRLADB_SERV_NET_AMT (# 38)

Source Code Comments

NET DISBURSEMENT: The Net disbursement amount recorded in the Account Statement.

Columns Comments for RPRLADB_SERV_NET_ADJ_AMT (# 39)

Source Code Comments

NET ADJUSTMENT: The net disbursement adjustment amount recorded in the Account Statement. The value in this field may be either positive or negative reflecting the net amount of the adjustment processed for this individual disbursement.

Columns Comments for RPRLADB_SERV_LOANID_ERR (# 40)

Source Code Comments

SERVICER LOAN ID ERROR: This column will contain a Y if the LOAN ID reported to the servicer was invalid on the last reconciliation batch.

Columns Comments for RPRLADB_SERV_DISBNO_ERR (# 41)

Source Code Comments

SERVICER DISBURSEMENT NUMBER ERROR: This column will contain a Y if the disbursement number reported to the servicer was invalid on the last reconciliation batch.

Columns Comments for RPRLADB_SERV_ACTION_ERR (# 42)

Source Code Comments

SERVICER ACTION ERROR: This column will contain a Y if the action reported to the servicer was invalid on the last reconciliation batch.

Columns Comments for RPRLADB_SERV_DATE_ERR (# 43)

Source Code Comments

SERVICER DATE ERROR: This column will contain a Y if the date reported to the servicer was invalid on the last reconciliation batch.

Columns Comments for RPRLADB_SERV_SEQNO_ERR (# 44)

Source Code Comments

SERVICER SEQUENCE NUMBER ERROR: This column will contain a Y if the sequence number reported to the servicer was invalid on the last reconciliation batch.

Columns Comments for RPRLADB_REF_ID (# 45)

Source Code Comments

REFERENCE ID: The check number or electronic batch number of the financial aid payment. User enterable, no edit.

Columns Comments for RPRLADB_RET_LNDR_DATE (# 46)

Source Code Comments

RETURNED TO LENDER DATE: The date that the original unsigned/unprocessed loan check was returned to the lender by the school.

Columns Comments for RPRLADB_EFT_IND (# 47)

Source Code Comments

EFT INDICATOR: A Y in this column indicates that the payment was received electronically (via EFT), rather than via check.

Columns Comments for RPRLADB_COMMENT (# 48)

Source Code Comments

COMMENT: This column will contain any special processing comments or instructions entered by the user.

Columns Comments for RPRLADB_DISB_BYPASS (# 49)

Source Code Comments

BYPASS DISBURSEMENT: This column will contain a Y when the user wishes to bypass lender transactions for a payment during disbursement.

Columns Comments for RPRLADB_DL_REJECT_CODE_1 (# 50)

Source Code Comments

DISBURSEMENT REJECT CODE 1: The first reject code sent from LOC / COD for this loan disbursement.

Columns Comments for RPRLADB_DL_REJECT_CODE_2 (# 51)

Source Code Comments

DISBURSEMENT REJECT CODE 2: The second reject code sent from LOC / COD for this loan disbursement.

Columns Comments for RPRLADB_DL_REJECT_CODE_3 (# 52)

Source Code Comments

DISBURSEMENT REJECT CODE 3: The third reject code sent from LOC / COD for this loan disbursement.

Columns Comments for RPRLADB_DL_REJECT_CODE_4 (# 53)

Source Code Comments

DISBURSEMENT REJECT CODE 4: The fourth reject code sent from LOC / COD for this loan disbursement.

Columns Comments for RPRLADB_DL_REJECT_CODE_5 (# 54)

Source Code Comments

DISBURSEMENT REJECT CODE 5: The fifth reject code sent from LOC / COD for this loan disbursement.

Columns Comments for RPRLADB_DL_ACKN_DATE (# 60)

Source Code Comments

DIRECT LOAN ACKNOWLEDGEMENT DATE: The actual date the receipt of this disbursement record was acknowledged.

Columns Comments for RPRLADB_SAS_END_DATE (# 61)

Source Code Comments

SCHOOL ACCOUNT STATEMENT END DATE: The month end date of the Direct Loan School Account Statement for the month in which this loan disbursement booked.

Columns Comments for RPRLADB_SAS_PROCESS_DATE (# 62)

Source Code Comments

SCHOOL ACCOUNT STATEMENT PROCESS DATE: The date on which the Direct Loan School Account Statement was created for the month in which this loan disbursement booked.

Columns Comments for RPRLADB_SCHOOL_CODE (# 63)

Source Code Comments

SCHOOL CODE: The Direct Lending School Code for this loan detail record, returned on the School Account Statement.

Columns Comments for RPRLADB_SAS_RECORD_COUNT_SEQ (# 64)

Source Code Comments

RECORD COUNT SEQUENCE: The record number assigned in the School Account Statement for this loan detail record.

Columns Comments for RPRLADB_FEES_PAID (# 65)

Source Code Comments

FEES PAID: This is the total amount of fees subsidized by the guarantor or lender on behalf of the borrower for the disbursement.

Columns Comments for RPRLADB_AFFIRM_FLAG (# 66)

Source Code Comments

LOAN DISBURSEMENT AFFIRMATION FLAG: This field indicates that the student has authorized the disbursement of Direct Loan funds under the Master Promissory Note or the borrower has confirmed the loan disbursement for CommonLine processing.

Columns Comments for RPRLADB_HOLD_REL_STATUS (# 67)

Source Code Comments

HOLDRELEASE STATUS: A code indicating the status of the school's requested disbursement hold or release.

Columns Comments for RPRLADB_REV_DISB_AMT (# 68)

Source Code Comments

REVISED DISBURSEMENT AMOUNT: The revised disbursement amount excluding all fees retained by the lender (i.e. net amount).

Columns Comments for RPRLADB_PRIOR_DISB_DATE (# 69)

Source Code Comments

PRIOR DISBURSEMENT DATE: This field contains the prior Disbursement Date when the scheduled disbursement date is manually changed. After the change information is sent to the Lender or Lender's Agent, this date is set to null.

Columns Comments for RPRLADB_DISB_OVERRIDE_IND (# 70)

Source Code Comments

DISBURSEMENT OVERRIDE INDICATOR: Allows the override of the disbursement edit for loans that prevents disbursement when sum of the loan term disbursements is greater than the sum of the loan term expected amount.

Columns Comments for RPRLADB_DL_REBATE_AMT (# 71)

Source Code Comments

ACTUAL INTEREST REBATE AMOUNT: The interest rebate amount calculated for this disbursement.

Columns Comments for RPRLADB_SERV_REBATE_AMT (# 72)

Source Code Comments

REBATE: The Rebate Amount recorded in the Account Statement.

Columns Comments for RPRLADB_SERV_BOOKED_STATUS (# 73)

Source Code Comments

SERVICER BOOKED STATUS: Booked Status of Disbursement activity at the LOC. Valid Values are A = Booked, R = Unbooked. Default value is null.

Columns Comments for RPRLADB_SERV_BOOKED_DATE (# 74)

Source Code Comments

SERVICER BOOKED DATE: Date the individual disbursement activity booked at the LOC.

Columns Comments for RPRLADB_EL_HOLD_REL_DATE (# 75)

Source Code Comments

HOLD RELEASE STATUS DATE: The most recent date the Hold/Release status was sent (RPRHDRL) or acknowledged (RPRELRU).

Columns Comments for RPRLADB_EL_REV_GROSS_AMT (# 76)

Source Code Comments

REVISED GROSS DISBURSEMENT AMOUNT: The revised gross disbursement amount for this EL disbursement record.

Columns Comments for RPRLADB_EL_DISB_NO (# 77)

Source Code Comments

ELECTRONIC LOAN DISBURSMENT NUMBER: The disbursement number associated with this EL disbursement record.

Columns Comments for RPRLADB_SERV_TRANS_TYPE (# 78)

Source Code Comments

TRAN TYPE: This is the type of transaction record found for the disbursement. It may be a disbursement or an adjusted disbursement.

Columns Comments for RPRLADB_REGION_CD (# 79)

Source Code Comments

SCHOOL REGION CODE: Displays the 2 digit region code of the school.

Columns Comments for RPRLADB_SCHOOL_STAT_CODE (# 80)

Source Code Comments

SCHOOL STATE CODE: Displays the 2 digit State code of the school.

Columns Comments for RPRLADB_EL_SERV_GROSS_AMT (# 81)

Source Code Comments

EL GROSS DISBURSEMENT AMOUNT: The amount guaranteed by the guarantor/servicer for this disbursement including all applicable fees and minus any cancellations.

Columns Comments for RPRLADB_EL_SERV_ORIG_FEE (# 82)

Source Code Comments

EL ORIGINATION FEE AMOUNT: The amount of the origination fee charged for this disbursement.

Columns Comments for RPRLADB_EL_SERV_GUAR_FEE (# 83)

Source Code Comments

EL GUARANTEE FEE AMOUNT: The amount of the guarantee fee charged for this disbursement.

Columns Comments for RPRLADB_EL_SERV_NET_AMT (# 84)

Source Code Comments

EL NET DISBURSEMENT AMOUNT: The net amount to be issued to the borrower or school for this disbursement.

Columns Comments for RPRLADB_EL_SERV_DISB_DATE (# 85)

Source Code Comments

EL SCHEDULED DISBURSEMENT DATE: The disbursement date scheduled by the guarantor/servicer for this disbursement.

Columns Comments for RPRLADB_EL_SERV_GUAR_FEE_PAID (# 86)

Source Code Comments

EL GUARANTEE FEES PAID: The amount of the guarantee fee subsidized by the guarantor on behalf of the borrower for this disbursement.

Columns Comments for RPRLADB_EL_SERV_ORIG_FEE_PAID (# 87)

Source Code Comments

EL ORIGINATION FEES PAID: The amount of the origination fee subsidized by the lender on behalf of the borrower for this disbursement.

Columns Comments for RPRLADB_DOCUMENT_ID (# 88)

Source Code Comments

COD DOCUMENT ID FOR LOAN DISBURSEMENT RECORD: The document identification number associated with the student's loan disbursement record.

Columns Comments for RPRLADB_PREV_DISB_SEQ_NO (# 89)

Source Code Comments

PREVIOUS DISBURSEMENT SEQUENCE NUMBER: The previous disbursement sequence number on the COD database for the disbursement number.

Columns Comments for RPRLADB_DATA_ORIGIN (# 90)

Source Code Comments

DATA ORIGIN: The latest source for the data contained in this record.

Columns Comments for RPRLADB_DL_EDIT_FIELD_1 (# 91)

Source Code Comments

DL Disbursement Response Edit Field 1: The field (XML tag) associated with edit 1.

Columns Comments for RPRLADB_DL_EDIT_FIELD_2 (# 92)

Source Code Comments

DL Disbursement Response Edit Field 2: The field (XML tag) associated with edit 2.

Columns Comments for RPRLADB_DL_EDIT_FIELD_3 (# 93)

Source Code Comments

DL Disbursement Response Edit Field 3: The field (XML tag) associated with edit 3.

Columns Comments for RPRLADB_DL_EDIT_FIELD_4 (# 94)

Source Code Comments

DL Disbursement Response Edit Field 4: The field (XML tag) associated with edit 4.

Columns Comments for RPRLADB_DL_EDIT_FIELD_5 (# 95)

Source Code Comments

DL Disbursement Response Edit Field 5: The field (XML tag) associated with edit 5.

Columns Comments for RPRLADB_EL_BOR_DIRECT_DISB_IND (# 96)

Source Code Comments

DIRECT DISBURSEMENT TO BORROWER INDICATOR: An indicator to request the direct disbursement of funds or indicate receipt of funds for borrowers enrolled in a study-abroad program.

Columns Comments for RPRLADB_EL_DIRECT_CHECK_AMT (# 97)

Source Code Comments

DIRECT DISBURSEMENT TO BORROWER CHECK AMOUNT: Direct disbursement amount received by borrower enrolled in a study-abroad program.

Columns Comments for RPRLADB_EXCLUDE_LNEX_FLAG (# 98)

Source Code Comments

EXCLUDE FROM LOAN EXCEPTION FLAG: This field indicates that the loan exception report should not display a line for this loan and disbursement, even if there was a discrepancy in the amounts.

Table RPRLAPP

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RPRLAPP_PIDM	NUMBER(8,0)	No	*	*
RPRLAPP_FUND_CODE	VARCHAR2(6)	No	*	*
RPRLAPP_APPL_NO	NUMBER(3,0)	No	*	*
RPRLAPP_AIDY_CODE	VARCHAR2(4)	No		*
RPRLAPP_SYS_IND	VARCHAR2(1)	No
RPRLAPP_LOAN_PERIOD	VARCHAR2(6)	No		*
RPRLAPP_LNST_CODE	VARCHAR2(4)	No		*
RPRLAPP_RECEIVE_DATE	DATE	Yes
RPRLAPP_REQUEST_AMT	NUMBER(11,2)	Yes
RPRLAPP_ACTIVITY_DATE	DATE	No
RPRLAPP_CITZ_IND	VARCHAR2(1)	Yes
RPRLAPP_INFC_CODE	VARCHAR2(7)	Yes		*
RPRLAPP_LENDER_ID	VARCHAR2(6)	Yes
RPRLAPP_FEE_PCT	NUMBER(6,3)	Yes
RPRLAPP_RECOMMEND_AMT	NUMBER(11,2)	Yes
RPRLAPP_PROCESS_DATE	DATE	Yes
RPRLAPP_MAX_ELIG_AMT	NUMBER(11,2)	Yes
RPRLAPP_EXPECT_AMT	NUMBER(11,2)	Yes
RPRLAPP_CERT_DATE	DATE	Yes
RPRLAPP_SUB_DATE	DATE	Yes
RPRLAPP_APPROVE_DATE	DATE	Yes
RPRLAPP_APPROVE_AMT	NUMBER(11,2)	Yes
RPRLAPP_CSS_ID_NO	VARCHAR2(8)	Yes
RPRLAPP_SSN	VARCHAR2(15)	Yes
RPRLAPP_BIRTH_DATE	DATE	Yes
RPRLAPP_STAT_CODE_RES	VARCHAR2(3)	Yes		*
RPRLAPP_START_RES_MTH_YR	DATE	Yes
RPRLAPP_ALIEN_REG_NO	VARCHAR2(9)	Yes
RPRLAPP_DRIVER_LIC_NO	VARCHAR2(20)	Yes
RPRLAPP_STAT_CODE_LIC	VARCHAR2(3)	Yes		*
RPRLAPP_IN_DEFAULT	VARCHAR2(1)	Yes
RPRLAPP_OWES_REFUND	VARCHAR2(1)	Yes
RPRLAPP_BAL_ON_ALL_STAF	NUMBER(5,0)	Yes
RPRLAPP_RECENT_STAF_BAL	NUMBER(5,0)	Yes
RPRLAPP_RECENT_STAF_INT_RATE	VARCHAR2(1)	Yes
RPRLAPP_RECENT_STAF_CLASS	VARCHAR2(1)	Yes
RPRLAPP_ADJUST_BUDGET_AMT	NUMBER(9,2)	Yes
RPRLAPP_ADJUST_TOTAL_AID_AMT	NUMBER(9,2)	Yes
RPRLAPP_ADJUST_TFC_AMT	NUMBER(9,2)	Yes
RPRLAPP_ADJUST_MAX_ELIG_AMT	NUMBER(9,2)	Yes
RPRLAPP_ADJUST_AGI_AMT	NUMBER(9,2)	Yes
RPRLAPP_DL_LOAN_ID	VARCHAR2(21)	Yes
RPRLAPP_DL_SEQ_NO	NUMBER(2,0)	Yes
RPRLAPP_DL_STATUS	VARCHAR2(1)	Yes
RPRLAPP_DL_SENT_DATE	DATE	Yes
RPRLAPP_LAST_NAME	VARCHAR2(60)	Yes
RPRLAPP_FIRST_NAME	VARCHAR2(60)	Yes
RPRLAPP_MI	VARCHAR2(60)	Yes
RPRLAPP_ADDRESS	VARCHAR2(75)	Yes
RPRLAPP_CITY	VARCHAR2(50)	Yes
RPRLAPP_STATE	VARCHAR2(2)	Yes
RPRLAPP_ZIP	VARCHAR2(30)	Yes
RPRLAPP_PHONE_NO	VARCHAR2(18)	Yes
RPRLAPP_EXP_GRAD_DATE	DATE	Yes
RPRLAPP_YR_IN_COLL	VARCHAR2(1)	Yes
RPRLAPP_PAR_SSN	VARCHAR2(15)	Yes
RPRLAPP_PAR_LAST_NAME	VARCHAR2(60)	Yes
RPRLAPP_PAR_FIRST_NAME	VARCHAR2(60)	Yes
RPRLAPP_PAR_MI	VARCHAR2(60)	Yes
RPRLAPP_PAR_ADDRESS	VARCHAR2(75)	Yes
RPRLAPP_PAR_CITY	VARCHAR2(50)	Yes
RPRLAPP_PAR_STATE	VARCHAR2(2)	Yes
RPRLAPP_PAR_ZIP	VARCHAR2(30)	Yes
RPRLAPP_PAR_PHONE_NO	VARCHAR2(18)	Yes
RPRLAPP_PAR_DRIVER_LIC_NO	VARCHAR2(20)	Yes
RPRLAPP_PAR_STAT_CODE_LIC	VARCHAR2(2)	Yes
RPRLAPP_PAR_BIRTH_DATE	DATE	Yes
RPRLAPP_PAR_CITZ_IND	VARCHAR2(1)	Yes
RPRLAPP_PAR_ALIEN_REG_NO	VARCHAR2(9)	Yes
RPRLAPP_PAR_IN_DEFAULT	VARCHAR2(1)	Yes
RPRLAPP_USER_ID	VARCHAR2(30)	Yes
RPRLAPP_CANCEL_IND	VARCHAR2(1)	Yes
RPRLAPP_CANCEL_DATE	DATE	Yes
RPRLAPP_CREDIT_CHECK_IND	VARCHAR2(1)	Yes
RPRLAPP_CREDIT_CHECK_DATE	DATE	Yes
RPRLAPP_BATCH_NO	VARCHAR2(23)	Yes
RPRLAPP_LOCAL_ADDRESS	VARCHAR2(75)	Yes
RPRLAPP_LOCAL_CITY	VARCHAR2(50)	Yes
RPRLAPP_LOCAL_STAT_CODE	VARCHAR2(2)	Yes
RPRLAPP_LOCAL_ZIP	VARCHAR2(30)	Yes
RPRLAPP_PAR_LOCAL_ADDRESS	VARCHAR2(75)	Yes
RPRLAPP_PAR_LOCAL_CITY	VARCHAR2(50)	Yes
RPRLAPP_PAR_LOCAL_STAT_CODE	VARCHAR2(2)	Yes
RPRLAPP_PAR_LOCAL_ZIP	VARCHAR2(30)	Yes
RPRLAPP_HOLD_IND	VARCHAR2(1)	Yes
RPRLAPP_CONF_DATE	DATE	Yes
RPRLAPP_PLUS_TO_STUDENT	VARCHAR2(1)	Yes
RPRLAPP_GRADE_LEVEL	VARCHAR2(1)	Yes
RPRLAPP_ENROLL_START_DATE	DATE	Yes
RPRLAPP_MODEL_CDE	VARCHAR2(1)	Yes
RPRLAPP_CREATE_DATE	DATE	Yes
RPRLAPP_DL_REJECT_CODE_1	VARCHAR2(3)	Yes
RPRLAPP_DL_REJECT_CODE_2	VARCHAR2(3)	Yes
RPRLAPP_DL_REJECT_CODE_3	VARCHAR2(3)	Yes
RPRLAPP_RETURN_PIDM	NUMBER(8,0)	Yes
RPRLAPP_LENDER_PIDM	NUMBER(8,0)	Yes
RPRLAPP_GUAR_PIDM	NUMBER(8,0)	Yes
RPRLAPP_EL_LOAN_ID	VARCHAR2(17)	Yes
RPRLAPP_EL_SEQ_NO	NUMBER(2,0)	Yes
RPRLAPP_EL_STATUS	VARCHAR2(1)	Yes
RPRLAPP_EL_DATE_SENT	DATE	Yes
RPRLAPP_EL_PROCESS_TYPE	VARCHAR2(2)	Yes
RPRLAPP_RECORD_TYPE	VARCHAR2(1)	Yes
RPRLAPP_EFT_AUTH	VARCHAR2(1)	Yes
RPRLAPP_PN_DATE	DATE	Yes
RPRLAPP_REF_IND	VARCHAR2(1)	Yes
RPRLAPP_DL_REJECT_CODE_4	VARCHAR2(3)	Yes
RPRLAPP_DL_REJECT_CODE_5	VARCHAR2(3)	Yes
RPRLAPP_DL_RECON_STATUS	VARCHAR2(1)	Yes
RPRLAPP_DL_RECON_REJECT_1	VARCHAR2(3)	Yes
RPRLAPP_DL_RECON_REJECT_2	VARCHAR2(3)	Yes
RPRLAPP_DL_RECON_REJECT_3	VARCHAR2(3)	Yes
RPRLAPP_DL_RECON_REJECT_4	VARCHAR2(3)	Yes
RPRLAPP_DL_RECON_REJECT_5	VARCHAR2(3)	Yes
RPRLAPP_LOC_TOT_NET_LOAN_AMT	NUMBER(5,0)	Yes
RPRLAPP_XREF_LOAN_ID	VARCHAR2(21)	Yes
RPRLAPP_DEFER_REQ	VARCHAR2(1)	Yes
RPRLAPP_CAPITALIZE_INT	VARCHAR2(1)	Yes
RPRLAPP_FORMER_HEAL_IND	VARCHAR2(1)	Yes
RPRLAPP_APP_VER_NO	VARCHAR2(1)	Yes
RPRLAPP_APP_PHASE_CDE	VARCHAR2(4)	Yes
RPRLAPP_NATN_CODE	VARCHAR2(5)	Yes		*
RPRLAPP_LOCAL_NATN_CODE	VARCHAR2(5)	Yes		*
RPRLAPP_PAR_NATN_CODE	VARCHAR2(5)	Yes		*
RPRLAPP_PAR_LOCAL_NATN_CODE	VARCHAR2(5)	Yes		*
RPRLAPP_PAR_STAT_CODE_RES	VARCHAR2(3)	Yes		*
RPRLAPP_ADDL_STFD_ELIG_IND	VARCHAR2(1)	Yes
RPRLAPP_MPN_STATUS_IND	VARCHAR2(1)	Yes
RPRLAPP_ACAD_YR_START_DATE	DATE	Yes
RPRLAPP_ACAD_YR_END_DATE	DATE	Yes
RPRLAPP_PN_DELIVERY_CDE	VARCHAR2(1)	Yes
RPRLAPP_FED_APP_FORM_CDE	VARCHAR2(1)	Yes
RPRLAPP_SERIAL_LOAN_CDE	VARCHAR2(1)	Yes
RPRLAPP_MPN_CONF_CDE	VARCHAR2(1)	Yes
RPRLAPP_BORROWER_CONF_CDE	VARCHAR2(1)	Yes
RPRLAPP_ADDR_LINE2	VARCHAR2(75)	Yes
RPRLAPP_PAR_ADDR_LINE2	VARCHAR2(75)	Yes
RPRLAPP_LOCAL_ADDR_LINE2	VARCHAR2(75)	Yes
RPRLAPP_PAR_LOCAL_ADDR_LINE2	VARCHAR2(75)	Yes
RPRLAPP_DISC_PRINT_IND	VARCHAR2(1)	Yes
RPRLAPP_DISC_NEED_PRINT_FLAG	VARCHAR2(1)	Yes
RPRLAPP_DISC_PRINT_DATE	DATE	Yes
RPRLAPP_MPN_ID	VARCHAR2(21)	Yes
RPRLAPP_MPN_BATCH_ID	VARCHAR2(23)	Yes
RPRLAPP_ALT_LOAN_SB_IND	VARCHAR2(1)	Yes
RPRLAPP_ALT_LOAN_PROG_TYPE_CDE	VARCHAR2(3)	Yes
RPRLAPP_ALT_BOR_LOAN_DEBT	NUMBER(7,0)	Yes
RPRLAPP_STAF_LOAN_DEBT	NUMBER(5,0)	Yes
RPRLAPP_SLS_LOAN_DEBT	NUMBER(5,0)	Yes
RPRLAPP_HEAL_DEBT	NUMBER(6,0)	Yes
RPRLAPP_PERKINS_DEBT	NUMBER(5,0)	Yes
RPRLAPP_OTHER_DEBT	NUMBER(6,0)	Yes
RPRLAPP_OTH_LOANS_PERIOD	NUMBER(7,0)	Yes
RPRLAPP_CRED_DIF_NM_IND	VARCHAR2(1)	Yes
RPRLAPP_COSIGN1_LAST_NAME	VARCHAR2(60)	Yes
RPRLAPP_COSIGN1_FIRST_NAME	VARCHAR2(60)	Yes
RPRLAPP_COSIGN1_MI	VARCHAR2(60)	Yes
RPRLAPP_COSIGN1_SSN	VARCHAR2(15)	Yes
RPRLAPP_COSIGN1_CITZ_IND	VARCHAR2(1)	Yes
RPRLAPP_COSIGN1_ADDR_LINE1	VARCHAR2(75)	Yes
RPRLAPP_COSIGN1_ADDR_LINE2	VARCHAR2(75)	Yes
RPRLAPP_COSIGN1_CITY	VARCHAR2(50)	Yes
RPRLAPP_COSIGN1_STAT_CODE	VARCHAR2(2)	Yes
RPRLAPP_COSIGN1_ZIP	VARCHAR2(30)	Yes
RPRLAPP_COSIGN1_FOR_POST_CDE	VARCHAR2(14)	Yes
RPRLAPP_COSIGN1_PHONE_NO	VARCHAR2(18)	Yes
RPRLAPP_COSIGN1_SIGNED_IND	VARCHAR2(1)	Yes
RPRLAPP_COSIGN2_LAST_NAME	VARCHAR2(60)	Yes
RPRLAPP_COSIGN2_FIRST_NAME	VARCHAR2(60)	Yes
RPRLAPP_COSIGN2_MI	VARCHAR2(60)	Yes
RPRLAPP_COSIGN2_SSN	VARCHAR2(15)	Yes
RPRLAPP_COSIGN2_CITZ_IND	VARCHAR2(1)	Yes
RPRLAPP_COSIGN2_ADDR_LINE1	VARCHAR2(75)	Yes
RPRLAPP_COSIGN2_ADDR_LINE2	VARCHAR2(75)	Yes
RPRLAPP_COSIGN2_CITY	VARCHAR2(50)	Yes
RPRLAPP_COSIGN2_STAT_CODE	VARCHAR2(2)	Yes
RPRLAPP_COSIGN2_ZIP_CODE	VARCHAR2(30)	Yes
RPRLAPP_COSIGN2_FOR_POST_CDE	VARCHAR2(14)	Yes
RPRLAPP_COSIGN2_PHONE_NO	VARCHAR2(18)	Yes
RPRLAPP_COSIGN2_SIGNED_IND	VARCHAR2(1)	Yes
RPRLAPP_BOR_GROSS_YR_SAL	NUMBER(7,0)	Yes
RPRLAPP_BOR_OTH_INC	NUMBER(7,0)	Yes
RPRLAPP_COSIGN1_GROSS_YR_SAL	NUMBER(7,0)	Yes
RPRLAPP_COSIGN1_OTH_INC	NUMBER(7,0)	Yes
RPRLAPP_COSIGN2_GROSS_YR_SAL	NUMBER(7,0)	Yes
RPRLAPP_COSIGN2_OTH_INC	NUMBER(7,0)	Yes
RPRLAPP_STU_MAJOR	VARCHAR2(15)	Yes
RPRLAPP_COSIGN1_BIRTH_DATE	DATE	Yes
RPRLAPP_COSIGN1_STAT_CODE_LIC	VARCHAR2(2)	Yes
RPRLAPP_COSIGN1_DRIVER_LIC_NO	VARCHAR2(20)	Yes
RPRLAPP_COSIGN2_BIRTH_DATE	DATE	Yes
RPRLAPP_COSIGN2_STAT_CODE_LIC	VARCHAR2(2)	Yes
RPRLAPP_COSIGN2_DRIVER_LIC_NO	VARCHAR2(20)	Yes
RPRLAPP_COSIGN1_RELATION_IND	VARCHAR2(1)	Yes
RPRLAPP_COSIGN1_SUFFIX	VARCHAR2(3)	Yes
RPRLAPP_COSIGN1_YR_ADDRESS	NUMBER(2,0)	Yes
RPRLAPP_COSIGN2_RELATION_IND	VARCHAR2(1)	Yes
RPRLAPP_COSIGN2_SUFFIX	VARCHAR2(3)	Yes
RPRLAPP_COSIGN2_YR_ADDRESS	NUMBER(2,0)	Yes
RPRLAPP_INT_RATE_OPT_IND	VARCHAR2(1)	Yes
RPRLAPP_REPAY_OPT_IND	VARCHAR2(1)	Yes
RPRLAPP_LOCAL_PHONE_NO	VARCHAR2(18)	Yes
RPRLAPP_STU_EMAIL	VARCHAR2(128)	Yes
RPRLAPP_DL_REBATE_PERCENT	NUMBER(6,3)	Yes
RPRLAPP_EL_PREDISB_RECIP_PIDM	NUMBER(8,0)	Yes
RPRLAPP_EL_POSTDISB_RECIP_PIDM	NUMBER(8,0)	Yes
RPRLAPP_EL_REALLOCATE_IND	VARCHAR2(1)	Yes
RPRLAPP_EL_ERROR_CODE_1	VARCHAR2(3)	Yes
RPRLAPP_EL_ERROR_CODE_2	VARCHAR2(3)	Yes
RPRLAPP_EL_ERROR_CODE_3	VARCHAR2(3)	Yes
RPRLAPP_EL_ERROR_CODE_4	VARCHAR2(3)	Yes
RPRLAPP_EL_ERROR_CODE_5	VARCHAR2(3)	Yes
RPRLAPP_BOOK_BATCH_NO	VARCHAR2(23)	Yes
RPRLAPP_BOOK_DATE	DATE	Yes
RPRLAPP_EL_RESP_GUAR_STATUS	VARCHAR2(2)	Yes
RPRLAPP_EL_RESP_LENDER_STATUS	VARCHAR2(2)	Yes
RPRLAPP_EL_RESP_PN_STATUS	VARCHAR2(2)	Yes
RPRLAPP_EL_RESP_CREDIT_STATUS	VARCHAR2(2)	Yes
RPRLAPP_EL_REINSTATE_AMT	NUMBER(7,2)	Yes
RPRLAPP_EL_GUAR_USE_ONLY	VARCHAR2(23)	Yes
RPRLAPP_EL_LENDER_USE_ONLY	VARCHAR2(20)	Yes
RPRLAPP_EL_BOR_EPNOTE_IND	VARCHAR2(1)	Yes
RPRLAPP_EL_STU_CERT_ESIGN_IND	VARCHAR2(1)	Yes
RPRLAPP_EL_BOR_CREDIT_AUTH	VARCHAR2(1)	Yes
RPRLAPP_HOUSE_PMT	NUMBER(5,0)	Yes
RPRLAPP_CC_PMT	NUMBER(5,0)	Yes
RPRLAPP_CAR_PMT	NUMBER(5,0)	Yes
RPRLAPP_ED_LOAN_PMT	NUMBER(5,0)	Yes
RPRLAPP_OTH_PMT	NUMBER(5,0)	Yes
RPRLAPP_COSIGN1_HOUSE_PMT	NUMBER(5,0)	Yes
RPRLAPP_COSIGN1_CC_PMT	NUMBER(5,0)	Yes
RPRLAPP_COSIGN1_CAR_PMT	NUMBER(5,0)	Yes
RPRLAPP_COSIGN1_ED_LOAN_PMT	NUMBER(5,0)	Yes
RPRLAPP_COSIGN1_OTH_PMT	NUMBER(5,0)	Yes
RPRLAPP_COSIGN1_CREDIT_AUTH	VARCHAR2(1)	Yes
RPRLAPP_COSIGN2_HOUSE_PMT	NUMBER(5,0)	Yes
RPRLAPP_COSIGN2_CC_PMT	NUMBER(5,0)	Yes
RPRLAPP_COSIGN2_CAR_PMT	NUMBER(5,0)	Yes
RPRLAPP_COSIGN2_ED_LOAN_PMT	NUMBER(5,0)	Yes
RPRLAPP_COSIGN2_OTH_PMT	NUMBER(5,0)	Yes
RPRLAPP_COSIGN2_CREDIT_AUTH	VARCHAR2(1)	Yes
RPRLAPP_EL_COSIGN1_EPNOTE_IND	VARCHAR2(1)	Yes
RPRLAPP_EL_COSIGN2_EPNOTE_IND	VARCHAR2(1)	Yes
RPRLAPP_SAR_TRAN_NO	VARCHAR2(2)	Yes
RPRLAPP_DOCUMENT_ID	VARCHAR2(30)	Yes
RPRLAPP_BOOK_DOCUMENT_ID	VARCHAR2(30)	Yes
RPRLAPP_MPN_DOCUMENT_ID	VARCHAR2(30)	Yes
RPRLAPP_PAR_ENDORSER_AMT	NUMBER(5,0)	Yes
RPRLAPP_MPN_REPRINT	VARCHAR2(1)	Yes
RPRLAPP_EL_PLUS_REQ_AMT_IND	VARCHAR2(1)	Yes
RPRLAPP_ESIGN_SOURCE_TYPE	VARCHAR2(9)	Yes
RPRLAPP_SERV_FED_APP_FORM_CDE	VARCHAR2(1)	Yes
RPRLAPP_PLUS_BORROWER_ID_NO	VARCHAR2(2)	Yes
RPRLAPP_DATA_ORIGIN	VARCHAR2(30)	Yes
RPRLAPP_MPN_EXP_DATE	DATE	Yes
RPRLAPP_MPN_EXP_CODE	VARCHAR2(1)	Yes
RPRLAPP_MPN_EXP_DESC	VARCHAR2(70)	Yes
RPRLAPP_DL_EDIT_FIELD_1	VARCHAR2(35)	Yes
RPRLAPP_DL_EDIT_FIELD_2	VARCHAR2(35)	Yes
RPRLAPP_DL_EDIT_FIELD_3	VARCHAR2(35)	Yes
RPRLAPP_DL_EDIT_FIELD_4	VARCHAR2(35)	Yes
RPRLAPP_DL_EDIT_FIELD_5	VARCHAR2(35)	Yes
RPRLAPP_BORROWER_EMAIL	VARCHAR2(128)	Yes
RPRLAPP_SCHOOL_CODE	VARCHAR2(6)	Yes
RPRLAPP_LOAN_TYPE	VARCHAR2(1)	Yes
RPRLAPP_PREP_OR_TEACH_IND	VARCHAR2(1)	No
RPRLAPP_CREDIT_DOCUMENT_ID	VARCHAR2(30)	Yes
RPRLAPP_SURNAME_PREFIX	VARCHAR2(60)	Yes
RPRLAPP_ADDR_LINE3	VARCHAR2(75)	Yes
RPRLAPP_ADDR_LINE4	VARCHAR2(75)	Yes
RPRLAPP_HOUSE_NUMBER	VARCHAR2(10)	Yes
RPRLAPP_CTRY_CODE_PHONE	VARCHAR2(4)	Yes
RPRLAPP_LOCAL_ADDR_LINE3	VARCHAR2(75)	Yes
RPRLAPP_LOCAL_ADDR_LINE4	VARCHAR2(75)	Yes
RPRLAPP_LOCAL_HOUSE_NUMBER	VARCHAR2(10)	Yes
RPRLAPP_CTRY_CODE_LOCAL_PHONE	VARCHAR2(4)	Yes
RPRLAPP_PAR_SURNAME_PREFIX	VARCHAR2(60)	Yes
RPRLAPP_PAR_ADDR_LINE3	VARCHAR2(75)	Yes
RPRLAPP_PAR_ADDR_LINE4	VARCHAR2(75)	Yes
RPRLAPP_PAR_HOUSE_NUMBER	VARCHAR2(10)	Yes
RPRLAPP_CTRY_CODE_PAR_PHONE	VARCHAR2(4)	Yes
RPRLAPP_PAR_LOCAL_ADDR_LINE3	VARCHAR2(75)	Yes
RPRLAPP_PAR_LOCAL_ADDR_LINE4	VARCHAR2(75)	Yes
RPRLAPP_PAR_LOCAL_HOUSE_NUMBER	VARCHAR2(10)	Yes
RPRLAPP_COSIGN1_SURNAME_PREFIX	VARCHAR2(60)	Yes
RPRLAPP_COSIGN1_ADDR_LINE3	VARCHAR2(75)	Yes
RPRLAPP_COSIGN1_ADDR	VARCHAR2(75)	Yes
RPRLAPP_COSIGN1_HOUSE_NUMBER	VARCHAR2(10)	Yes
RPRLAPP_CTRY_CODE_COSIG1_PHONE	VARCHAR2(4)	Yes
RPRLAPP_COSIGN2_SURNAME_PREFIX	VARCHAR2(60)	Yes
RPRLAPP_COSIGN2_ADDR	VARCHAR2(75)	Yes
RPRLAPP_COSIGN2_HOUSE_NUMBER	VARCHAR2(10)	Yes
RPRLAPP_CTRY_CODE_COSIG2_PHONE	VARCHAR2(4)	Yes
RPRLAPP_COSIGN1_ADDR_LINE4	VARCHAR2(75)	Yes
RPRLAPP_COSIGN2_ADDR_LINE3	VARCHAR2(75)	Yes
RPRLAPP_COSIGN2_ADDR_LINE4	VARCHAR2(75)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RPRLAPP_INFC_CODE	RTVINFC_CODE	RTVINFC
RPRLAPP_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RPRLAPP_LNST_CODE	RTVLNST_CODE	RTVLNST
RPRLAPP_NATN_CODE	STVNATN_CODE	STVNATN
RPRLAPP_LOCAL_NATN_CODE	STVNATN_CODE	STVNATN
RPRLAPP_PAR_NATN_CODE	STVNATN_CODE	STVNATN
RPRLAPP_PAR_LOCAL_NATN_CODE	STVNATN_CODE	STVNATN
RPRLAPP_STAT_CODE_LIC	STVSTAT_CODE	STVSTAT
RPRLAPP_STAT_CODE_RES	STVSTAT_CODE	STVSTAT
RPRLAPP_PAR_STAT_CODE_RES	STVSTAT_CODE	STVSTAT
RPRLAPP_AIDY_CODE	RFRASPC_AIDY_CODE	RFRASPC
RPRLAPP_FUND_CODE	RFRASPC_FUND_CODE	RFRASPC
RPRLAPP_LOAN_PERIOD	RPBLPRD_LOAN_PERIOD	RPBLPRD
RPRLAPP_FUND_CODE	RFRBASE_FUND_CODE	RFRBASE
RPRLAPP_PIDM	RPRLATR_PIDM	RPRLATR
RPRLAPP_FUND_CODE	RPRLATR_FUND_CODE	RPRLATR
RPRLAPP_APPL_NO	RPRLATR_APPL_NO	RPRLATR

Index

Index Name	Index Type	Column Name
PK_RPRLAPP	Unique	RPRLAPP_PIDM
PK_RPRLAPP	Unique	RPRLAPP_FUND_CODE
PK_RPRLAPP	Unique	RPRLAPP_APPL_NO
RPRLAPP_DOCUMENT_ID_INDEX		RPRLAPP_DOCUMENT_ID
RPRLAPP_EL_LOANID_INDEX		RPRLAPP_EL_LOAN_ID
RPRLAPP_KEY_INDEX		RPRLAPP_SCHOOL_CODE
RPRLAPP_KEY_INDEX		RPRLAPP_AIDY_CODE
RPRLAPP_LOANID_INDEX		RPRLAPP_DL_LOAN_ID
RPRLAPP_MPN_ID_INDEX		RPRLAPP_MPN_ID
RPRLAPP_SSN_INDEX		RPRLAPP_SSN
RPRLAPP_SSN_INDEX		RPRLAPP_BIRTH_DATE
RPRLAPP_SSN_INDEX		RPRLAPP_EL_LOAN_ID
RPRLAPP_XREF_LOAN_ID_INDEX		RPRLAPP_XREF_LOAN_ID

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
ROBALOG	SQL Table	S10B80.FAISMGR	Join
RPRLADB	SQL Table	S10B80.FAISMGR	Join
RPRLCRT	SQL Table	S10B80.FAISMGR	Refer (no action)
SPRIDEN	SQL Table	S10B80.SATURN	Join
F_EST_LOAN	SQL Function	S10B80.BANINST1	Rely On
F_EST_LOAN	SQL Function	S10B80.BANINST1	Use (select)
LOAN_DETAIL_TYPE	Oracle Package Type	S10B80.BANINST1.BWRKLHST	Rely On
RPRLAPP_FUND_CD_TAB_TYPE	Oracle Package Type	S10B80.BANINST1.ROKTABS	Rely On
RPRLAPP_REC_DATE_TAB_TYPE	Oracle Package Type	S10B80.BANINST1.ROKTABS	Rely On
RPRLAPP_SUB_DATE_TAB_TYPE	Oracle Package Type	S10B80.BANINST1.ROKTABS	Rely On
RPRLAPP_TAB_TYPE	Oracle Package Type	S10B80.BANINST1.ROKTABS	Rely On
LOAN_DISB_REC	Oracle Package Type	S10B80.BANINST1.RPK_DISB_VALIDATION	Rely On
LOAN_REC	Oracle Package Type	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
P_ADD_LOAN_DISBURSE_REC	Oracle Package Procedure	S10B80.BANINST1.RPKAWRD	Rely On
P_ADD_LOAN_TERM_SCHED_REC	Oracle Package Procedure	S10B80.BANINST1.RPKAWRD	Rely On
P_GETRPRLAPP	Oracle Package Procedure	S10B80.BANINST1.REKCI04	Use (select)
P_GETXREFSEQNO	Oracle Package Procedure	S10B80.BANINST1.REKCI04	Use (select)
P_INSERT_CREATE_DATE	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Rely On
P_INSERT_CREATE_DATE	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Rely On
P_INSERT_CREATE_DATE	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_INSERT_CREATE_DATE	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_INSERT_CREATE_DATE	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_INSERT_SERVICER_REFUNDS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_INSERT_SERVICER_REFUNDS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Use (select)
P_INSERT_SERVICER_REFUNDS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_INSERT_SERVICER_REFUNDS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Use (select)
P_INSERT_SERVICER_REFUNDS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_INSERT_SERVICER_REFUNDS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (select)
P_INSERT_SERVICER_REFUNDS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_INSERT_SERVICER_REFUNDS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (select)
P_INSERT_SERVICER_REFUNDS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_INSERT_SERVICER_REFUNDS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (select)
P_SELECT_DL_LOAN_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Use (select)
P_SELECT_DL_LOAN_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Use (select)
P_SELECT_DL_LOAN_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (select)
P_SELECT_DL_LOAN_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (select)
P_SELECT_DL_LOAN_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (select)
P_SELECT_DL_XREF_LOAN_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Use (select)
P_SELECT_DL_XREF_LOAN_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Use (select)
P_SELECT_DL_XREF_LOAN_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (select)
P_SELECT_DL_XREF_LOAN_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (select)
P_SELECT_DL_XREF_LOAN_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (select)
P_UPDATEDLDISB	Oracle Package Procedure	S10B80.BANINST1.REKCI04	Use (select)
P_UPDATEDLORIG	Oracle Package Procedure	S10B80.BANINST1.REKCI04	Rely On
P_UPDATEDLORIG	Oracle Package Procedure	S10B80.BANINST1.REKCI04	Use (update,select)Rely On
P_UPDATEPARENTID	Oracle Package Procedure	S10B80.BANINST1.REKCI04	Use (select)
P_UPDATE_BOOKING_NOTIFICATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_BOOKING_NOTIFICATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Use (update,select)Rely On
P_UPDATE_BOOKING_NOTIFICATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_BOOKING_NOTIFICATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Use (update,select)Rely On
P_UPDATE_BOOKING_NOTIFICATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_BOOKING_NOTIFICATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (update,select)Rely On
P_UPDATE_BOOKING_NOTIFICATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_BOOKING_NOTIFICATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (update,select)Rely On
P_UPDATE_BOOKING_NOTIFICATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_BOOKING_NOTIFICATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (update,select)Rely On
P_UPDATE_CREDIT_DECISIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_CREDIT_DECISIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Use (update,select)Rely On
P_UPDATE_CREDIT_DECISIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_CREDIT_DECISIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Use (update,select)Rely On
P_UPDATE_CREDIT_DECISIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_CREDIT_DECISIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (update,select)Rely On
P_UPDATE_CREDIT_DECISIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_CREDIT_DECISIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (update,select)Rely On
P_UPDATE_CREDIT_DECISIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_CREDIT_DECISIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (update,select)Rely On
P_UPDATE_MPN	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_MPN	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Use (update,select)
P_UPDATE_MPN	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_MPN	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Use (update,select)
P_UPDATE_MPN	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_MPN	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (update,select)
P_UPDATE_MPN	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_MPN	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (update,select)
P_UPDATE_MPN	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_MPN	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (update,select)
P_UPDATE_PARENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_PARENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Use (select)
P_UPDATE_PARENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_PARENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Use (select)
P_UPDATE_PARENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_PARENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (select)
P_UPDATE_PARENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_PARENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (select)
P_UPDATE_PARENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_PARENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (select)
P_UPDATE_PROM_NOTES_PN	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_PROM_NOTES_PN	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Use (update,select)
P_UPDATE_PROM_NOTES_PN	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_PROM_NOTES_PN	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Use (update,select)
P_UPDATE_PROM_NOTES_PN	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_PROM_NOTES_PN	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (update,select)
P_UPDATE_PROM_NOTES_PN	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_PROM_NOTES_PN	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (update,select)
P_UPDATE_PROM_NOTES_PN	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_PROM_NOTES_PN	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (update,select)
P_UPDATE_PROM_NOTES_RS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_PROM_NOTES_RS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_PROM_NOTES_RS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_PROM_NOTES_RS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_PROM_NOTES_RS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_STUDENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_STUDENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_STUDENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_STUDENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_STUDENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
RPRLAPP_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI04	Rely On
RPRLAPP_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI05	Rely On
RPRLAPP_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI06	Rely On
RPRLAPP_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI07	Rely On
RPRLAPP_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI08	Rely On
RPRLAPP_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI09	Rely On
XREF_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI04	Rely On
XREF_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI05	Rely On
XREF_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI06	Rely On
XREF_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI07	Rely On
XREF_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI08	Rely On
XREF_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI09	Rely On
F_CURRENT_PIDM_BY_LOANID	Oracle Package Function	S10B80.BANINST1.REKCI06	Rely On
F_CURRENT_PIDM_BY_LOANID	Oracle Package Function	S10B80.BANINST1.REKCI06	Use (select)
F_CURRENT_PIDM_BY_LOANID	Oracle Package Function	S10B80.BANINST1.REKCI07	Rely On
F_CURRENT_PIDM_BY_LOANID	Oracle Package Function	S10B80.BANINST1.REKCI07	Use (select)
F_CURRENT_PIDM_BY_LOANID	Oracle Package Function	S10B80.BANINST1.REKCI08	Rely On
F_CURRENT_PIDM_BY_LOANID	Oracle Package Function	S10B80.BANINST1.REKCI08	Use (select)
F_CURRENT_PIDM_BY_LOANID	Oracle Package Function	S10B80.BANINST1.REKCI09	Rely On
F_CURRENT_PIDM_BY_LOANID	Oracle Package Function	S10B80.BANINST1.REKCI09	Use (select)
F_GET_LOAN_DATA	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_GET_LOAN_DATA	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Use (select)
F_GET_LOAN_DISB_DATA	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION	Rely On
F_GET_LOAN_DISB_DATA	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION	Use (select)
F_GET_NSLDS_DATA	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_GET_PROM_NOTE_DATA	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_GET_RPBLOPT_DATA	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_GET_RPBLOPT_DATA	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION	Rely On
F_VAL_CREDIT_CHECK	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_VAL_ENDORSER_AMOUNT	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_VAL_LOAN_ACTIVE	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION	Rely On
F_VAL_LOAN_ACTIVE	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION	Use (select)
GETACTIVEAIDYEARC	Oracle Package Cursor	S10B80.BANINST1.BWRKLHST	Use (select)
GETLOANDTLC	Oracle Package Cursor	S10B80.BANINST1.BWRKLHST	Use (select)
RPRLAPP_ROW_BY_PIDM_AIDY_C	Oracle Package Cursor	S10B80.BANINST1.RPKSELS	Rely On
RPRLAPP_ROW_BY_PIDM_AIDY_C	Oracle Package Cursor	S10B80.BANINST1.RPKSELS	Use (select)Rely On
RPRLAPP_ROW_BY_PIDM_C	Oracle Package Cursor	S10B80.BANINST1.RPKSELS	Rely On
RPRLAPP_ROW_BY_PIDM_C	Oracle Package Cursor	S10B80.BANINST1.RPKSELS	Use (select)Rely On
P_ADD_AWARD_REC	Oracle Package Procedure	S10B80.BANINST1.RPKLOAN	Use (select)
P_ADD_AWARD_TERM_REC	Oracle Package Procedure	S10B80.BANINST1.RPKLOAN	Use (select)
P_ADD_LOAN_APPLICATION_RECORD	Oracle Package Procedure	S10B80.BANINST1.RPKAWRD	Rely On
P_ADD_LOAN_APPLICATION_RECORD	Oracle Package Procedure	S10B80.BANINST1.RPKAWRD	Use (Insert,select)
P_DISPLAY_RPRLAPP	Oracle Package Procedure	S10B80.BANINST1.RPK_DEBS_DISPLAYS	Rely On
P_DISPLAY_RPRLAPP	Oracle Package Procedure	S10B80.BANINST1.RPK_DEBS_DISPLAYS	Use (select)Rely On
P_GET_RPRLAPP_ROWS	Oracle Package Procedure	S10B80.BANINST1.RPKFUNC	Rely On
P_PA_RPBLNDR_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_SELECT_DL_PNOTE_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Use (select)
P_SELECT_DL_PNOTE_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Use (select)
P_SELECT_DL_PNOTE_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Use (select)
P_SELECT_DL_PNOTE_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Use (select)
P_SELECT_DL_PNOTE_REQUIRED	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Use (select)
P_SELECT_IDENTIFIER_CHANGES	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Rely On
P_SELECT_IDENTIFIER_CHANGES	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Use (select)
P_SELECT_IDENTIFIER_CHANGES	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Rely On
P_SELECT_IDENTIFIER_CHANGES	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Use (select)
P_SELECT_IDENTIFIER_CHANGES	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_SELECT_IDENTIFIER_CHANGES	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Use (select)
P_SELECT_IDENTIFIER_CHANGES	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_SELECT_IDENTIFIER_CHANGES	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Use (select)
P_SELECT_IDENTIFIER_CHANGES	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_SELECT_IDENTIFIER_CHANGES	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Use (select)
P_SELECT_IDENTIFIER_CHANGES	Oracle Package Procedure	S10B80.BANINST1.REKCEXX	Rely On
P_SELECT_PERSON_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Rely On
P_SELECT_PERSON_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Use (select)
P_SELECT_PERSON_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Rely On
P_SELECT_PERSON_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Use (select)
P_SELECT_PERSON_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_SELECT_PERSON_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Use (select)
P_SELECT_PERSON_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_SELECT_PERSON_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Use (select)
P_SELECT_PERSON_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_SELECT_PERSON_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Use (select)
P_SELECT_PERSON_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCEXX	Rely On
P_UPDATE_BORROWER_ID_NO	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Rely On
P_UPDATE_BORROWER_ID_NO	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Use (update)
P_UPDATE_BORROWER_ID_NO	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Rely On
P_UPDATE_BORROWER_ID_NO	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Use (update)
P_UPDATE_BORROWER_ID_NO	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_UPDATE_BORROWER_ID_NO	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Use (update)
P_UPDATE_BORROWER_ID_NO	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_UPDATE_BORROWER_ID_NO	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Use (update)
P_UPDATE_BORROWER_ID_NO	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_UPDATE_BORROWER_ID_NO	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Use (update)
P_UPDATE_BORROWER_ID_NO	Oracle Package Procedure	S10B80.BANINST1.REKCEXX	Rely On
P_UPDATE_DISC_NEED_PRINT_FLAG	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Rely On
P_UPDATE_DISC_NEED_PRINT_FLAG	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Use (update)
P_UPDATE_DISC_NEED_PRINT_FLAG	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Rely On
P_UPDATE_DISC_NEED_PRINT_FLAG	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Use (update)
P_UPDATE_DISC_NEED_PRINT_FLAG	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_UPDATE_DISC_NEED_PRINT_FLAG	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Use (update)
P_UPDATE_DISC_NEED_PRINT_FLAG	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_UPDATE_DISC_NEED_PRINT_FLAG	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Use (update)
P_UPDATE_DISC_NEED_PRINT_FLAG	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_UPDATE_DISC_NEED_PRINT_FLAG	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Use (update)
P_UPDATE_DISC_NEED_PRINT_FLAG	Oracle Package Procedure	S10B80.BANINST1.REKCEXX	Rely On
P_UPDATE_DLPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_DLPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Use (select)
P_UPDATE_DLPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_DLPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Use (select)
P_UPDATE_DLPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_DLPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (select)
P_UPDATE_DLPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_DLPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (select)
P_UPDATE_DLPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_DLPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (select)
P_UPDATE_DLPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCIXX	Rely On
P_UPDATE_DLPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_DLPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Use (update,select)
P_UPDATE_DLPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_DLPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Use (update,select)
P_UPDATE_DLPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_DLPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (update,select)
P_UPDATE_DLPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_DLPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (update,select)
P_UPDATE_DLPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_DLPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (update,select)
P_UPDATE_DLPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCIXX	Rely On
P_UPDATE_DLSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_DLSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Use (select)
P_UPDATE_DLSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_DLSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Use (select)
P_UPDATE_DLSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_DLSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (select)
P_UPDATE_DLSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_DLSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (select)
P_UPDATE_DLSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_DLSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (select)
P_UPDATE_DLSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCIXX	Rely On
P_UPDATE_DLSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_DLSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Use (update,select)
P_UPDATE_DLSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_DLSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Use (update,select)
P_UPDATE_DLSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_DLSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (update,select)
P_UPDATE_DLSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_DLSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (update,select)
P_UPDATE_DLSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_DLSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (update,select)
P_UPDATE_DLSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCIXX	Rely On
P_UPDATE_DLUNSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_DLUNSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Use (select)
P_UPDATE_DLUNSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_DLUNSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Use (select)
P_UPDATE_DLUNSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_DLUNSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (select)
P_UPDATE_DLUNSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_DLUNSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (select)
P_UPDATE_DLUNSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_DLUNSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (select)
P_UPDATE_DLUNSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCIXX	Rely On
P_UPDATE_DLUNSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_DLUNSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Use (update,select)
P_UPDATE_DLUNSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_DLUNSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Use (update,select)
P_UPDATE_DLUNSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_DLUNSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (update,select)
P_UPDATE_DLUNSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_DLUNSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (update,select)
P_UPDATE_DLUNSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_DLUNSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (update,select)
P_UPDATE_DLUNSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCIXX	Rely On
P_UPDATE_DL_AWARD	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Rely On
P_UPDATE_DL_AWARD	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Use (update)
P_UPDATE_DL_AWARD	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Rely On
P_UPDATE_DL_AWARD	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Use (update)
P_UPDATE_DL_AWARD	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_UPDATE_DL_AWARD	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Use (update)
P_UPDATE_DL_AWARD	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_UPDATE_DL_AWARD	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Use (update)
P_UPDATE_DL_AWARD	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_UPDATE_DL_AWARD	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Use (update)
P_UPDATE_DL_AWARD	Oracle Package Procedure	S10B80.BANINST1.REKCEXX	Rely On
P_UPDATE_GPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_GPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Use (select)
P_UPDATE_GPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_GPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (select)
P_UPDATE_GPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_GPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (select)
P_UPDATE_GPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_GPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (select)
P_UPDATE_GPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_GPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Use (update,select)
P_UPDATE_GPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_GPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (update,select)
P_UPDATE_GPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_GPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (update,select)
P_UPDATE_GPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_GPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (update,select)
P_UPDATE_MPN_REPRINT	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Rely On
P_UPDATE_MPN_REPRINT	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Use (update)
P_UPDATE_MPN_REPRINT	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Rely On
P_UPDATE_MPN_REPRINT	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Use (update)
P_UPDATE_MPN_REPRINT	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_UPDATE_MPN_REPRINT	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Use (update)
P_UPDATE_MPN_REPRINT	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_UPDATE_MPN_REPRINT	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Use (update)
P_UPDATE_MPN_REPRINT	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_UPDATE_MPN_REPRINT	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Use (update)
P_UPDATE_MPN_REPRINT	Oracle Package Procedure	S10B80.BANINST1.REKCEXX	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.RB_DL_REFUND_RULES	Use (select)
P_VALIDATE_DL_DISBURSEMENT	Oracle Package Procedure	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
P_VALIDATE_EL_DISBURSEMENT	Oracle Package Procedure	S10B80.BANINST1.RPK_DISB_VALIDATION	Rely On
P_VALIDATE_PERSON_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Rely On
P_VALIDATE_PERSON_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Rely On
P_VALIDATE_PERSON_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_VALIDATE_PERSON_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_VALIDATE_PERSON_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_VALIDATE_PERSON_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCEXX	Rely On
P_VR_GET_LOAN_INFO	Oracle Package Procedure	S10B80.BANINST1.VRRKRLAP	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_DL_REFUND	Use (Insert)
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE05	Rely On
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE05	Use (select)
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE06	Rely On
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE06	Use (select)
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE07	Rely On
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE08	Rely On
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE09	Rely On
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCEXX	Rely On
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE05	Rely On
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE05	Use (select)
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE06	Rely On
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE06	Use (select)
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE07	Rely On
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE08	Rely On
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE09	Rely On
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCEXX	Rely On
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE05	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE06	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
RPRLAPP	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RPRLAPP	SQL Index	S10B80.FAISMGR	Rely On
RPRLAPP_DOCUMENT_ID_INDEX	SQL Index	S10B80.FAISMGR	Rely On
RPRLAPP_EL_LOANID_INDEX	SQL Index	S10B80.FAISMGR	Rely On
RPRLAPP_KEY_INDEX	SQL Index	S10B80.FAISMGR	Rely On
RPRLAPP_LOANID_INDEX	SQL Index	S10B80.FAISMGR	Rely On
RPRLAPP_MPN_ID_INDEX	SQL Index	S10B80.FAISMGR	Rely On
RPRLAPP_SSN_INDEX	SQL Index	S10B80.FAISMGR	Rely On
RPRLAPP_XREF_LOAN_ID_INDEX	SQL Index	S10B80.FAISMGR	Rely On
RFRASPC	SQL Table	S10B80.FAISMGR	Join
RFRBASE	SQL Table	S10B80.FAISMGR	Join
ROBINST	SQL Table	S10B80.FAISMGR	Refer (no action)
RPBLPRD	SQL Table	S10B80.FAISMGR	Join
RPRLATR	SQL Table	S10B80.FAISMGR	Join
RTVINFC	SQL Table	S10B80.FAISMGR	Refer (no action)
RTVLNST	SQL Table	S10B80.FAISMGR	Refer (no action)
STVNATN	SQL Table	S10B80.SATURN	Refer (no action)
STVSTAT	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RPRLAPP

Object Dates

Creation Date	Analysis Date
04/02/2008 10:27:53:000	04/02/2008 10:35:21:000

Source Code Comments

Loan Application Table

Columns Comments for RPRLAPP_PIDM (# 1)

Source Code Comments

PIDM: Internal system student identification number.

Columns Comments for RPRLAPP_FUND_CODE (# 2)

Source Code Comments

FUND CODE: The fund code associated with the loan application. Once the loan application is established, the fund code cannot be changed.

Columns Comments for RPRLAPP_APPL_NO (# 3)

Source Code Comments

APPLICATION NUMBER: This system assigned number is assigned when the application is added. This number cannot be maintained by the user.

Columns Comments for RPRLAPP_AIDY_CODE (# 4)

Source Code Comments

AID YEAR CODE: The aid year to be associated with the information in this record. Examples: 9091, 9192, 9293, etc. This code cannot be changed once the loan has been certified.

Columns Comments for RPRLAPP_SYS_IND (# 5)

Source Code Comments

SYSTEM INDICATOR: This field indicates how the loan application was added either by the system or manually.

Columns Comments for RPRLAPP_LOAN_PERIOD (# 6)

Source Code Comments

LOAN PERIOD: The period for which the loan covers.

Columns Comments for RPRLAPP_LNST_CODE (# 7)

Source Code Comments

LOAN STATUS CODE: The code used to identify the current status of the loan in processing.

Columns Comments for RPRLAPP_RECEIVE_DATE (# 8)

Source Code Comments

RECEIVED DATE: The date that the loan application was received. If not entered the system date will default.

Columns Comments for RPRLAPP_REQUEST_AMT (# 9)

Source Code Comments

REQUEST AMOUNT: The amount of loan that the applicant requests. This amount cannot be negative or zero.

Columns Comments for RPRLAPP_ACTIVITY_DATE (# 10)

Source Code Comments

ACTIVITY DATE: The date that information for this record in the table was entered or last updated.

Columns Comments for RPRLAPP_CITZ_IND (# 11)

Source Code Comments

CITIZENSHIP INDICATOR: This indicator defines the citizenship of the applicant as reported on the students Need Analysis document.

Columns Comments for RPRLAPP_INFC_CODE (# 12)

Source Code Comments

INTERFACE CODE: The code identifying the original source of this application.

Columns Comments for RPRLAPP_LENDER_ID (# 13)

Source Code Comments

LENDER ID: The lender code associated with the lending institution making the particular loan. If not entered, the Lender ID will default from RPBLOPT. The Lender ID cannot be changed once the loan has been certified.

Columns Comments for RPRLAPP_FEE_PCT (# 14)

Source Code Comments

LOAN FEE PERCENT: This field identifies the percentage of the loan that will be subtracted from the loan proceeds because of origination fees, etc. If the fee percent is not entered it will default from RFRASPC.

Columns Comments for RPRLAPP_RECOMMEND_AMT (# 15)

Source Code Comments

RECOMMENDED AMOUNT: The packaged loan recommendation from the students award record. This will default from the student's offered amount. If the fund has not been packaged for the aid year, the amount recommended will be blank.

Columns Comments for RPRLAPP_PROCESS_DATE (# 16)

Source Code Comments

PROCESS DATE: The date the loan application was processed.

Columns Comments for RPRLAPP_MAX_ELIG_AMT (# 17)

Source Code Comments

MAXIMUM ELIGIBLE AMOUNT: This field identifies the maximum loan amount that the student is eligible for. (The processed amount.)

Columns Comments for RPRLAPP_EXPECT_AMT (# 18)

Source Code Comments

EXPECTED AMOUNT: This field identifies the amount of the loan that the student is expected to receive. It is the lower of either the Maximum Eligible Amount or the Requested Amount.

Columns Comments for RPRLAPP_CERT_DATE (# 19)

Source Code Comments

CERTIFICATION DATE: The date that the loan application was certified.

Columns Comments for RPRLAPP_SUB_DATE (# 20)

Source Code Comments

SUBMISSION DATE: This optional field maintains the date in which the loan was submitted.

Columns Comments for RPRLAPP_APPROVE_DATE (# 21)

Source Code Comments

APPROVE DATE: This field maintains the date that the loan was approved by the approving agency.

Columns Comments for RPRLAPP_APPROVE_AMT (# 22)

Source Code Comments

APPROVE AMOUNT: This field maintains the loan amount that was approved by the approving agency.

Columns Comments for RPRLAPP_CSS_ID_NO (# 23)

Source Code Comments

CSS IDENTIFICATION NUMBER: This field carries the applicants unique CSS document identification number for use in loan transmissions to processing agencies.

Columns Comments for RPRLAPP_SSN (# 24)

Source Code Comments

SOCIAL SECURITY NUMBER: This field shows the student's social security number as reported on the applicant's need analysis document.

Columns Comments for RPRLAPP_BIRTH_DATE (# 25)

Source Code Comments

BIRTH DATE: This field maintains the applicants birth date.

Columns Comments for RPRLAPP_STAT_CODE_RES (# 26)

Source Code Comments

STATE CODE RESIDENCE: This field indicates the state abbreviation of the state in which the applicant is a resident.

Columns Comments for RPRLAPP_START_RES_MTH_YR (# 27)

Source Code Comments

START RESIDENCE MONTH/YEAR: This field identifies the start month and year of the student's residence.

Columns Comments for RPRLAPP_ALIEN_REG_NO (# 28)

Source Code Comments

ALIEN REGISTRATION NUMBER: This field identifies the student alien registration number if applicable.

Columns Comments for RPRLAPP_DRIVER_LIC_NO (# 29)

Source Code Comments

DRIVERS LICENSE NUMBER: This field shows the applicant's driver's license number as reported on the applicant's Need Analysis document.

Columns Comments for RPRLAPP_STAT_CODE_LIC (# 30)

Source Code Comments

STATE CODE LICENSE: This field identifies the state code abbreviation of the state in which the student holds a drivers license.

Columns Comments for RPRLAPP_IN_DEFAULT (# 31)

Source Code Comments

IN DEFAULT: This field identifies whether the student is in default on a Title IV loan as reported in the student's need analysis record.

Columns Comments for RPRLAPP_OWES_REFUND (# 32)

Source Code Comments

OWES REFUND: This field indicates whether the student owes a refund on a federal Title IV grant as reported in the student's need analysis record.

Columns Comments for RPRLAPP_BAL_ON_ALL_STAF (# 33)

Source Code Comments

BALANCE ON ALL STAFFORDS: This field shows the applicants balance on all Stafford Loans according to the students reported information on their Need Analysis document.

Columns Comments for RPRLAPP_RECENT_STAF_BAL (# 34)

Source Code Comments

RECENT STAFFORD BALANCE: This field indicates the balance on the most recent Stafford loan outstanding.

Columns Comments for RPRLAPP_RECENT_STAF_INT_RATE (# 35)

Source Code Comments

RECENT STAFFORD INTEREST RATE: This field indicates the interest rate on the most recent Stafford loan outstanding.

Columns Comments for RPRLAPP_RECENT_STAF_CLASS (# 36)

Source Code Comments

RECENT STAFFORD CLASS: This field identifies the students class level on the most recent Stafford Loan outstanding.

Columns Comments for RPRLAPP_ADJUST_BUDGET_AMT (# 37)

Source Code Comments

ADJUSTED BUDGET AMOUNT: This field gives the user the capability to use an adjusted budget different from that that the system calculates.

Columns Comments for RPRLAPP_ADJUST_TOTAL_AID_AMT (# 38)

Source Code Comments

ADJUST TOTAL AID AMOUNT: This field allows the user to adjust the total aid amount from what the system calculated.

Columns Comments for RPRLAPP_ADJUST_TFC_AMT (# 39)

Source Code Comments

ADJUSTED TFC AMOUNT: This field gives the user the capability to adjust the TFC amount as the system calculated.

Columns Comments for RPRLAPP_ADJUST_MAX_ELIG_AMT (# 40)

Source Code Comments

MAXIMUM ELIGIBLE AMOUNT: This field gives the user the capability to adjust the eligible amount of the loan if different from what the system calculated.

Columns Comments for RPRLAPP_ADJUST_AGI_AMT (# 41)

Source Code Comments

ADJUSTED AGI AMOUNT: This field gives the user the option to use an adjusted figure different from what the system calculated for the AGI.

Columns Comments for RPRLAPP_DL_LOAN_ID (# 42)

Source Code Comments

A system generated field constructed from SSN,loan type,loan year,FDSLP school code,loan seq.number and prom note transaction number.Created when loan origination records are created.

Columns Comments for RPRLAPP_DL_SEQ_NO (# 43)

Source Code Comments

A system generated sequence number to designate direct loan applications.

Columns Comments for RPRLAPP_DL_STATUS (# 44)

Source Code Comments

This field is the origination status code, typically system maintained for direct loan applications.

Columns Comments for RPRLAPP_DL_SENT_DATE (# 45)

Source Code Comments

DATE SENT: The date that a Direct Loan origination record was sent.

Columns Comments for RPRLAPP_LAST_NAME (# 46)

Source Code Comments

The last name of the borrower of a direct loan.

Columns Comments for RPRLAPP_FIRST_NAME (# 47)

Source Code Comments

The first name of the borrower of a direct loan.

Columns Comments for RPRLAPP_MI (# 48)

Source Code Comments

The middle initial of the borrower of a direct loan.

Columns Comments for RPRLAPP_ADDRESS (# 49)

Source Code Comments

The address of the borrower of a direct loan.

Columns Comments for RPRLAPP_CITY (# 50)

Source Code Comments

The city in the address of the borrower of a direct loan.

Columns Comments for RPRLAPP_STATE (# 51)

Source Code Comments

The state in the address of the borrower of a direct loan.

Columns Comments for RPRLAPP_ZIP (# 52)

Source Code Comments

The zip code in the address of the borrower of a direct loan.

Columns Comments for RPRLAPP_PHONE_NO (# 53)

Source Code Comments

The phone number of the borrower of a direct loan.

Columns Comments for RPRLAPP_EXP_GRAD_DATE (# 54)

Source Code Comments

Program competion date of a student in a direct loan application.

Columns Comments for RPRLAPP_YR_IN_COLL (# 55)

Source Code Comments

YEAR IN COLLEGE: For years prior to and including 2000-2001, valid values are 1-7. Starting in 2001-2002, valid values are 0-7.

Columns Comments for RPRLAPP_PAR_SSN (# 56)

Source Code Comments

The social security number of the parent when a direct loan is of a parent type.

Columns Comments for RPRLAPP_PAR_LAST_NAME (# 57)

Source Code Comments

The last name of the parent when a direct loan is of a parent type

Columns Comments for RPRLAPP_PAR_FIRST_NAME (# 58)

Source Code Comments

The first name of the parent when a direct loan is of a parent type

Columns Comments for RPRLAPP_PAR_MI (# 59)

Source Code Comments

The middle initial of the parent when a direct loan is of a parent type

Columns Comments for RPRLAPP_PAR_ADDRESS (# 60)

Source Code Comments

The address of the parent when a direct loan is of a parent type

Columns Comments for RPRLAPP_PAR_CITY (# 61)

Source Code Comments

The city of the parent when a direct loan is of a parent type

Columns Comments for RPRLAPP_PAR_STATE (# 62)

Source Code Comments

The state of the parent when a direct loan is of a parent type

Columns Comments for RPRLAPP_PAR_ZIP (# 63)

Source Code Comments

The zip code of the parent when a direct loan is of a parent type

Columns Comments for RPRLAPP_PAR_PHONE_NO (# 64)

Source Code Comments

The phone number of the parent when a direct loan is of a parent type

Columns Comments for RPRLAPP_PAR_DRIVER_LIC_NO (# 65)

Source Code Comments

The driver license number of the parent when a direct loan is of a parent type

Columns Comments for RPRLAPP_PAR_STAT_CODE_LIC (# 66)

Source Code Comments

The state license code of the parent when a direct loan is of a parent type

Columns Comments for RPRLAPP_PAR_BIRTH_DATE (# 67)

Source Code Comments

The birth date of the parent when a direct loan is of a parent type

Columns Comments for RPRLAPP_PAR_CITZ_IND (# 68)

Source Code Comments

The citizen indicator of the parent when a direct loan is of a parent type

Columns Comments for RPRLAPP_PAR_ALIEN_REG_NO (# 69)

Source Code Comments

The alien registration of the parent when a direct loan is of a parent type

Columns Comments for RPRLAPP_PAR_IN_DEFAULT (# 70)

Source Code Comments

Indicates whether the borrower of a direct loan is in default or owes a refund on a grant

Columns Comments for RPRLAPP_USER_ID (# 71)

Source Code Comments

The user id of the user updating a direct loan application for this student.

Columns Comments for RPRLAPP_CANCEL_IND (# 72)

Source Code Comments

CANCELED/INACTIVATED INDICATOR: Indicates whether a direct loan was canceled/inactivated for this student. Valid values are 'Y', 'N' or blank

Columns Comments for RPRLAPP_CANCEL_DATE (# 73)

Source Code Comments

CANCELED/INACTIVATED DATE: The date a direct loan cancel/inactive indicator changed for this student.

Columns Comments for RPRLAPP_CREDIT_CHECK_IND (# 74)

Source Code Comments

Indicates the status of the PLUS loan credit check on the parent. Valid values are A,N,C,E and D

Columns Comments for RPRLAPP_CREDIT_CHECK_DATE (# 75)

Source Code Comments

The date a date a credit check was performed for a direct loan for this student.

Columns Comments for RPRLAPP_BATCH_NO (# 76)

Source Code Comments

BATCH ID: The batch number for the file submitted for this loan record.

Columns Comments for RPRLAPP_LOCAL_ADDRESS (# 77)

Source Code Comments

LOCAL ADDRESS: Student's local street address.

Columns Comments for RPRLAPP_LOCAL_CITY (# 78)

Source Code Comments

LOCAL CITY: Student's local city.

Columns Comments for RPRLAPP_LOCAL_STAT_CODE (# 79)

Source Code Comments

LOCAL STATE: Student's local state.

Columns Comments for RPRLAPP_LOCAL_ZIP (# 80)

Source Code Comments

LOCAL ZIP: Student's local zip code.

Columns Comments for RPRLAPP_PAR_LOCAL_ADDRESS (# 81)

Source Code Comments

PARENT LOCAL ADDRESS: Parent's local street address.

Columns Comments for RPRLAPP_PAR_LOCAL_CITY (# 82)

Source Code Comments

PARENT LOCAL CITY: Parent's local city.

Columns Comments for RPRLAPP_PAR_LOCAL_STAT_CODE (# 83)

Source Code Comments

PARENT LOCAL STATE: Parent's local state.

Columns Comments for RPRLAPP_PAR_LOCAL_ZIP (# 84)

Source Code Comments

PARENT LOCAL ZIP: Parent's local zip code.

Columns Comments for RPRLAPP_GRADE_LEVEL (# 88)

Source Code Comments

This is student's grade level code for loan application record used by Fin Aid Transcript print process when no certification records associated with the loan application.

Columns Comments for RPRLAPP_CREATE_DATE (# 91)

Source Code Comments

CREATE DATE: The date the loan application was created. For DL loans initialized by the loan origination batch process.

Columns Comments for RPRLAPP_DL_REJECT_CODE_1 (# 92)

Source Code Comments

LOAN RECONCILIATION REJECT CODE 1: The first reconciliation reject code sent from LOC / COD for this loan disbursement.

Columns Comments for RPRLAPP_DL_REJECT_CODE_2 (# 93)

Source Code Comments

LOAN RECONCILIATION REJECT CODE 2: The second reconciliation reject code sent from LOC / COD for this loan disbursement.

Columns Comments for RPRLAPP_DL_REJECT_CODE_3 (# 94)

Source Code Comments

LOAN RECONCILIATION REJECT CODE 3: The third reconciliation reject code sent from LOC / COD for this loan disbursement.

Columns Comments for RPRLAPP_RETURN_PIDM (# 95)

Source Code Comments

RETURN PIDM: The internal pidm for the Agency/Lender to whom unused funds are to be returned.

Columns Comments for RPRLAPP_LENDER_PIDM (# 96)

Source Code Comments

LENDER PIDM: The internal pidm for the Lender which issued the loan.

Columns Comments for RPRLAPP_GUAR_PIDM (# 97)

Source Code Comments

GUARANTOR PIDM: The internal pidm for the Guarantee Agency which guaranteed the loan.

Columns Comments for RPRLAPP_EL_LOAN_ID (# 98)

Source Code Comments

EL LOAN ID: The Loan ID used by Electronic Loan processing (CommonLine).

Columns Comments for RPRLAPP_EL_SEQ_NO (# 99)

Source Code Comments

EL SEQUENCE NUMBER: The Sequence Number used by Electronic Loan processing (CommonLine) to further identify the loan.

Columns Comments for RPRLAPP_EL_STATUS (# 100)

Source Code Comments

EL STATUS: The Status of a loan processed via Electronic Loan processing (CommonLine).

Columns Comments for RPRLAPP_EL_DATE_SENT (# 101)

Source Code Comments

EL DATE SENT: The date the loan was sent to the loan servicer (CommonLine).

Columns Comments for RPRLAPP_EL_PROCESS_TYPE (# 102)

Source Code Comments

EL PROCESS TYPE: The type of processing for loan (GP - Guarantee and Print, PG - Print and Guarantee, GO - Guarantee only, PO - Print only, RP - Reprint, CR - Certification request, CO - Credit Only, CP - Credit and Print)

Columns Comments for RPRLAPP_RECORD_TYPE (# 103)

Source Code Comments

EL RECORD TYPE: The type of record for CommonLine processing

Columns Comments for RPRLAPP_EFT_AUTH (# 104)

Source Code Comments

EFT AUTHORIZATION: Indicates whether this loan has been authorized for Electronic processing

Columns Comments for RPRLAPP_PN_DATE (# 105)

Source Code Comments

PN SIGNED DATE: Indicates the date the borrower signed the promissory note for the loan

Columns Comments for RPRLAPP_REF_IND (# 106)

Source Code Comments

REFERENCES INDICATOR: Indicates that the borrower has supplied the necessary references for the loan

Columns Comments for RPRLAPP_DL_REJECT_CODE_4 (# 107)

Source Code Comments

LOAN RECONCILIATION REJECT CODE 4: The fourth reconciliation reject code sent from LOC / COD for this loan disbursement.

Columns Comments for RPRLAPP_DL_REJECT_CODE_5 (# 108)

Source Code Comments

LOAN RECONCILIATION REJECT CODE5: The fifth reconciliation reject code sent from LOC / COD for this loan disbursement.

Columns Comments for RPRLAPP_DL_RECON_STATUS (# 109)

Source Code Comments

LOAN RECONCILIATION STATUS: The overall reconciliation status from the servicer(Loan Origination Center) for this loan.

Columns Comments for RPRLAPP_DL_RECON_REJECT_1 (# 110)

Source Code Comments

LOAN RECONCILIATION REJECT CODE 1: The first reconciliation reject code sent from the servicer(Loan Origination Center) for this loan disbursement.

Columns Comments for RPRLAPP_DL_RECON_REJECT_2 (# 111)

Source Code Comments

LOAN RECONCILIATION REJECT CODE 2: The second reconciliation reject code sent from the servicer(Loan Origination Center) for this loan disbursement.

Columns Comments for RPRLAPP_DL_RECON_REJECT_3 (# 112)

Source Code Comments

LOAN RECONCILIATION REJECT CODE 3: The third reconciliation reject code sent from the servicer(Loan Origination Center) for this loan disbursement.

Columns Comments for RPRLAPP_DL_RECON_REJECT_4 (# 113)

Source Code Comments

LOAN RECONCILIATION REJECT CODE 4: The fourth reconciliation reject code sent from the servicer(Loan Origination Center) for this loan disbursement.

Columns Comments for RPRLAPP_DL_RECON_REJECT_5 (# 114)

Source Code Comments

LOAN RECONCILIATION REJECT CODE 5: The fifth reconciliation reject code sent from the servicer(Loan Origination Center) for this loan disbursement.

Columns Comments for RPRLAPP_LOC_TOT_NET_LOAN_AMT (# 115)

Source Code Comments

LOAN ORIGINATION CENTER TOTAL NET LOAN AMOUNT: The total net loan amount which the servicer(Loan Origination Center) has currently booked for this loan.

Columns Comments for RPRLAPP_XREF_LOAN_ID (# 116)

Source Code Comments

CROSS REFERENCE LOAN ID: This indicates the ID of the loan with which this loan was combined when producing an electronic loan extract file or Direct Loan Promissory Note.

Columns Comments for RPRLAPP_DEFER_REQ (# 117)

Source Code Comments

DEFERMENT REQUEST: A Y indicates that the borrower has requested immediate deferment of principal payments on the new loan and all outstanding Stafford and Plus loans while enrolled in school.

Columns Comments for RPRLAPP_CAPITALIZE_INT (# 118)

Source Code Comments

CAPITALIZE INTEREST: A Y indicates that the borrower wants to capitalize interest on the unsubsidized Stafford or PLUS loan while enrolled and when in grace or deferment periods.

Columns Comments for RPRLAPP_FORMER_HEAL_IND (# 119)

Source Code Comments

HEALTH PROFESSION PROGRAMS AMOUNT INDICATOR: Indicates whether this student qualifies for additional Stafford Unsubsidized loans up to the HPPA limits.

Columns Comments for RPRLAPP_APP_VER_NO (# 120)

Source Code Comments

APPLICATION VERSION NUMBER: This field indicates which version of the CommonLine Application file has been sent once the loan application has been extracted.

Columns Comments for RPRLAPP_APP_PHASE_CDE (# 121)

Source Code Comments

APPLICATION PHASE CODE: This field indicates the current processing phase for the application or loan.

Columns Comments for RPRLAPP_NATN_CODE (# 122)

Source Code Comments

NATION CODE: This field indicates the code for the nation/country associated with the address of the borrower.

Columns Comments for RPRLAPP_LOCAL_NATN_CODE (# 123)

Source Code Comments

NATION CODE: This field indicates the code for the nation/country associated with the local address of the borrower.

Columns Comments for RPRLAPP_PAR_NATN_CODE (# 124)

Source Code Comments

NATION CODE: This field indicates the code for the nation/country associated with the address of the parent of the borrower when the loan is of a parent type.

Columns Comments for RPRLAPP_PAR_LOCAL_NATN_CODE (# 125)

Source Code Comments

NATION CODE: This field indicates the code for the nation/country associated with the local address of the parent of the borrower when the loan is of a parent type.

Columns Comments for RPRLAPP_PAR_STAT_CODE_RES (# 126)

Source Code Comments

PARENT STATE CODE RESIDENCE: This field indicates the 2-letter abbreviation of the state in which the parent of the applicant is a legal resident.

Columns Comments for RPRLAPP_ADDL_STFD_ELIG_IND (# 127)

Source Code Comments

ADDITIONAL STAFFORD ELIGIBILITY INDICATOR: This field indicates that this dependent student is eligible for an additional unsubsidized loan amount.

Columns Comments for RPRLAPP_MPN_STATUS_IND (# 128)

Source Code Comments

MPN STATUS INDICATOR: This field indicates the status of the borrower's MPN.

Columns Comments for RPRLAPP_ACAD_YR_START_DATE (# 129)

Source Code Comments

ACADEMIC YEAR START DATE: This field indicates the date on which the student's academic year starts at the institution.

Columns Comments for RPRLAPP_ACAD_YR_END_DATE (# 130)

Source Code Comments

ACADEMIC YEAR END DATE: This field indicates the date on which the student's academic year ends at the institution.

Columns Comments for RPRLAPP_PN_DELIVERY_CDE (# 131)

Source Code Comments

PROMISSORY NOTE DELIVERY CODE: A one character code indicating the preferred method of delivering the promissory note to the borrower.

Columns Comments for RPRLAPP_FED_APP_FORM_CDE (# 132)

Source Code Comments

FEDERAL APPLICATION FORM CODE: A one character code indicating the version of the application and promissory note to be used by the borrower.

Columns Comments for RPRLAPP_SERIAL_LOAN_CDE (# 133)

Source Code Comments

SERIAL LOAN CODE: A one character code used to indicate how the school intends to use the Master Promissory Note.

Columns Comments for RPRLAPP_MPN_CONF_CDE (# 134)

Source Code Comments

MASTER PROMISSORY NOTE CONFIRMATION CODE: A one character code used to indicate if a service provider can confirm that a valid Master Promissory Note exists at the time of certification.

Columns Comments for RPRLAPP_BORROWER_CONF_CDE (# 135)

Source Code Comments

BORROWER CONFIRMATION CODE: A one character code indicating if the service provider has received borrower confirmation of the loan request.

Columns Comments for RPRLAPP_ADDR_LINE2 (# 136)

Source Code Comments

STREET ADDRESS LINE 2: Second line of student's permanent street address.

Columns Comments for RPRLAPP_PAR_ADDR_LINE2 (# 137)

Source Code Comments

PARENT STREET ADDRESS LINE 2: Second line of parent's permanent street address.

Columns Comments for RPRLAPP_LOCAL_ADDR_LINE2 (# 138)

Source Code Comments

LOCAL STREET ADDRESS LINE 2: Second line of student's local street address.

Columns Comments for RPRLAPP_PAR_LOCAL_ADDR_LINE2 (# 139)

Source Code Comments

PARENT LOCAL STREET ADDRESS LINE 2: Second line of parent's local street address.

Columns Comments for RPRLAPP_DISC_PRINT_IND (# 140)

Source Code Comments

DISCLOSURE STATEMENT PRINT INDICATOR: This field indicates who should print the Disclosure Statement; COD (Y) or the school (blank).

Columns Comments for RPRLAPP_DISC_NEED_PRINT_FLAG (# 141)

Source Code Comments

DISCLOSURE STATEMENT NEEDS PRINTING FLAG: This field indicates that a new or revised Disclosure Statement needs to be printed for this loan record.

Columns Comments for RPRLAPP_DISC_PRINT_DATE (# 142)

Source Code Comments

DISCLOSURE STATEMENT PRINT DATE: This field contains the last date that a Disclosure Statement was printed for this loan by the school.

Columns Comments for RPRLAPP_MPN_ID (# 143)

Source Code Comments

MASTER PROMISSORY NOTE ID: The ID printed on the Master Promissory Note associated with this loan.

Columns Comments for RPRLAPP_MPN_BATCH_ID (# 144)

Source Code Comments

MPN BATCH ID: The Batch ID used to report the Master Promissory Note status and ID.

Columns Comments for RPRLAPP_ALT_LOAN_SB_IND (# 145)

Source Code Comments

ALTERNATIVE LOAN STUDENT/BORROWER INDICATOR: A one character code to indicate if the alternative loan borrower is also the student indicated on the loan application.

Columns Comments for RPRLAPP_ALT_LOAN_PROG_TYPE_CDE (# 146)

Source Code Comments

ALTERNATIVE LOAN PROGRAM TYPE CODE: A three-character code assigned by NCHELP indicating the specific category of alternative loan. This is required for all processes.

Columns Comments for RPRLAPP_ALT_BOR_LOAN_DEBT (# 147)

Source Code Comments

ALTERNATIVE BOROWER LOAN DEBT: The total amount of outstanding education debt (undergrad. and graduate) for the alternative loan borrower prior to the application. The amount includes all fed. and alternative loans including Fed. Consolidation loans.

Columns Comments for RPRLAPP_STAF_LOAN_DEBT (# 148)

Source Code Comments

STAFFORD LOAN AMOUNT: The borrower's total Federal Stafford Loan Debt prior to the loan period and should include the Federal Stafford Loan portion of the borrower's Federal Consolidation Loan.

Columns Comments for RPRLAPP_SLS_LOAN_DEBT (# 149)

Source Code Comments

SLS LOAN DEBT: The borrower's total Federal SLS Loan Debt prior to the loan period and should include the Federal SLS Loan portion of the borrower's Federal Consolidation Loan.

Columns Comments for RPRLAPP_HEAL_DEBT (# 150)

Source Code Comments

HEAL DEBT: The borrower's total HEAL Loan debt prior to the loan period.

Columns Comments for RPRLAPP_PERKINS_DEBT (# 151)

Source Code Comments

PERKINS DEBT: The borrower's total Perkins Loan debt prior to the loan period.

Columns Comments for RPRLAPP_OTHER_DEBT (# 152)

Source Code Comments

OTHER DEBT: The borrower's total other student educational loan debt prior to the requested loan period.

Columns Comments for RPRLAPP_OTH_LOANS_PERIOD (# 153)

Source Code Comments

OTHER LOANS FOR THE PERIOD: The borrower's total other student educational loan debt for the requested loan period.

Columns Comments for RPRLAPP_CRED_DIF_NM_IND (# 154)

Source Code Comments

CREDIT IN DIFFERENT NAME CODE: A 1-character code indicating if the borrower has been granted credit under a different name. Valid Values are: 'Y'es ,'N'o, and Blank which equals No.

Columns Comments for RPRLAPP_COSIGN1_LAST_NAME (# 155)

Source Code Comments

COSIGNER 1 LAST NAME: The last name of the cosigner.

Columns Comments for RPRLAPP_COSIGN1_FIRST_NAME (# 156)

Source Code Comments

COSIGNER1 FIRST NAME: The first name of the cosigner.

Columns Comments for RPRLAPP_COSIGN1_MI (# 157)

Source Code Comments

COSIGNER 1 MIDDLE INITIAL: The middle initial of the cosigner.

Columns Comments for RPRLAPP_COSIGN1_SSN (# 158)

Source Code Comments

COSIGNER 1 SSN: The Social Security Number of the cosigner.

Columns Comments for RPRLAPP_COSIGN1_CITZ_IND (# 159)

Source Code Comments

COSIGNER 1 CITIZENSHIP CODE: A 1-digit code indicating the first cosigner's citizenship status.

Columns Comments for RPRLAPP_COSIGN1_ADDR_LINE1 (# 160)

Source Code Comments

COSIGNER 1 ADDRESS LINE 1: The first line of the first cosigner's last known address.

Columns Comments for RPRLAPP_COSIGN1_ADDR_LINE2 (# 161)

Source Code Comments

COSIGNER 1 ADDRESS LINE 2: The second line of the first cosigner's last known address.

Columns Comments for RPRLAPP_COSIGN1_CITY (# 162)

Source Code Comments

COSIGNER 1 CITY: The city of the cosigner's last know address.

Columns Comments for RPRLAPP_COSIGN1_STAT_CODE (# 163)

Source Code Comments

COSIGNER 1 STATE: The 2-character state abbreviation of the first cosigner's last known address. FC should be used for Foreign Country.

Columns Comments for RPRLAPP_COSIGN1_ZIP (# 164)

Source Code Comments

COSIGNER 1 ZIP CODE: The 5-digit zip code of the cosigner's last known address.

Columns Comments for RPRLAPP_COSIGN1_FOR_POST_CDE (# 165)

Source Code Comments

COSIGNER 1 FOREIGN POSTAL CODE: A 14-character field indicating the foreign postal code of the first cosigner's last known address.

Columns Comments for RPRLAPP_COSIGN1_PHONE_NO (# 166)

Source Code Comments

COSIGNER 1 PHONE NUMBER: The first cosigner's last known telephone home number. Includes the area code.

Columns Comments for RPRLAPP_COSIGN1_SIGNED_IND (# 167)

Source Code Comments

COSIGNER 1 SIGNATURE INDICATOR: A 1-character code indicating if the signature of the first cosigner is present. Valid Values: 'Y'es, signature is present, 'N'o, signature not present, or Blank, which equals No.

Columns Comments for RPRLAPP_COSIGN2_LAST_NAME (# 168)

Source Code Comments

COSIGNER 2 LAST NAME: The last name of the second cosigner.

Columns Comments for RPRLAPP_COSIGN2_FIRST_NAME (# 169)

Source Code Comments

COSIGNER 2 FIRST NAME: The first name of the second cosigner.

Columns Comments for RPRLAPP_COSIGN2_MI (# 170)

Source Code Comments

COSIGNER 2 MIDDLE INITIAL: The middle initial of the second cosigner.

Columns Comments for RPRLAPP_COSIGN2_SSN (# 171)

Source Code Comments

COSIGNER 2 SSN: The Social Security Number of the second cosigner.

Columns Comments for RPRLAPP_COSIGN2_CITZ_IND (# 172)

Source Code Comments

COSIGNER 2 CITIZENSHIP INDICATOR: A 1-digit code indicating the second cosigner's citizenship status.

Columns Comments for RPRLAPP_COSIGN2_ADDR_LINE1 (# 173)

Source Code Comments

COSIGNER 2 ADDRESS LINE 1: The first line of the second cosigner's last known address.

Columns Comments for RPRLAPP_COSIGN2_ADDR_LINE2 (# 174)

Source Code Comments

COSIGNER 2 ADDRESS LINE 2: The second line of the second cosigner's last known address.

Columns Comments for RPRLAPP_COSIGN2_CITY (# 175)

Source Code Comments

COSIGNER 2 City: The city of the second cosigner's last know address.

Columns Comments for RPRLAPP_COSIGN2_STAT_CODE (# 176)

Source Code Comments

COSIGNER 2 STATE: The 2-character state abbreviation of the second cosigner's last known address. FC should be use for Foreign Country.

Columns Comments for RPRLAPP_COSIGN2_ZIP_CODE (# 177)

Source Code Comments

COSIGNER 2 ZIP CODE: The 5-digit zip code of the second cosigner's last known address.

Columns Comments for RPRLAPP_COSIGN2_FOR_POST_CDE (# 178)

Source Code Comments

COSIGNER 2 FOREIGN POSTAL CODE: A 14-character field indicating the foreign postal code of the second cosigner's last known address.

Columns Comments for RPRLAPP_COSIGN2_PHONE_NO (# 179)

Source Code Comments

COSIGNER 2 PHONE NUMBER: The second cosigner's last known telephone home number. Includes the area code.

Columns Comments for RPRLAPP_COSIGN2_SIGNED_IND (# 180)

Source Code Comments

COSIGNER 2 SIGNATURE INDICATOR: A 1-character code indicating if the signature of the second cosigner is present. Valid Values: 'Y'es, signature is present, 'N'o, signature not present, or Blank, which equals No.

Columns Comments for RPRLAPP_BOR_GROSS_YR_SAL (# 181)

Source Code Comments

BORROWER ANNUAL INCOME: The total income earned by the borrower from his or her primary employment.

Columns Comments for RPRLAPP_BOR_OTH_INC (# 182)

Source Code Comments

BORROWER OTHER INCOME: The total income earned by the borrower from a source other than his or her primary employment.

Columns Comments for RPRLAPP_COSIGN1_GROSS_YR_SAL (# 183)

Source Code Comments

COSIGNER 1 GROSS YEARLY SALARY: The total income earned by cosigner 1 from his or her primary employment.

Columns Comments for RPRLAPP_COSIGN1_OTH_INC (# 184)

Source Code Comments

COSIGNER 1 OTHER INCOME: The total income earned by cosigner 1 from a source other than his or her primary employment.

Columns Comments for RPRLAPP_COSIGN2_GROSS_YR_SAL (# 185)

Source Code Comments

COSIGNER 2 GROSS YEARLY SALARY: The total income earned by cosigner 2 from his or her primary employment.

Columns Comments for RPRLAPP_COSIGN2_OTH_INC (# 186)

Source Code Comments

COSIGNER 2 OTHER INCOME: The total income earned by cosigner 2 from a source other than his or her primary employment.

Columns Comments for RPRLAPP_STU_MAJOR (# 187)

Source Code Comments

STUDENT'S MAJOR: The student's major field of study.

Columns Comments for RPRLAPP_COSIGN1_BIRTH_DATE (# 188)

Source Code Comments

COSIGNER 1 DATE OF BIRTH: The first cosigner's date of birth.

Columns Comments for RPRLAPP_COSIGN1_STAT_CODE_LIC (# 189)

Source Code Comments

COSIGNER 1 DL STATE: The 2-character abbreviation for the state that issued the first cosigner's driver's license.

Columns Comments for RPRLAPP_COSIGN1_DRIVER_LIC_NO (# 190)

Source Code Comments

COSIGNER 1 DL NUMBER: The first cosigner's driver's license number.

Columns Comments for RPRLAPP_COSIGN2_BIRTH_DATE (# 191)

Source Code Comments

COSIGNER 2 DATE OF BIRTH: The second cosigner's date of birth.

Columns Comments for RPRLAPP_COSIGN2_STAT_CODE_LIC (# 192)

Source Code Comments

COSIGNER 2 DL STATE: The 2-character abbreviation for the state that issued the second cosigner's driver's license.

Columns Comments for RPRLAPP_COSIGN2_DRIVER_LIC_NO (# 193)

Source Code Comments

COSIGNER 2 DL NUMBER: The second cosigner's driver's license number.

Columns Comments for RPRLAPP_COSIGN1_RELATION_IND (# 194)

Source Code Comments

COSIGNER 1 RELATIONSHIP TO STUDENT: The first cosigner's relationship to the student. Valid values: E=Employer, F=Friend, G=Guardian, O=Other, P=Parent, R=Relative, S=Sibling, or Blank.

Columns Comments for RPRLAPP_COSIGN1_SUFFIX (# 195)

Source Code Comments

COSIGNER 1 NAME SUFFIX: A 3-character field that identifies the suffix of the first cosigner's name.

Columns Comments for RPRLAPP_COSIGN1_YR_ADDRESS (# 196)

Source Code Comments

COSIGNER 1 YEARS AT ADDRESS: A 2-digit field that indicates the number of years the first cosigner has been at his/her address.

Columns Comments for RPRLAPP_COSIGN2_RELATION_IND (# 197)

Source Code Comments

COSIGNER 2 RELATIONSHIP TO STUDENT: The second cosigner's relationship to the student. Valid values: E=Employer, F=Friend, G=Guardian, O=Other, P=Parent, R=Relative, S=Sibling, or Blank

Columns Comments for RPRLAPP_COSIGN2_SUFFIX (# 198)

Source Code Comments

COSIGNER SUFFIX: A 3-character field that identifies the suffix of the second cosigner's name.

Columns Comments for RPRLAPP_COSIGN2_YR_ADDRESS (# 199)

Source Code Comments

COSIGNER 2 YEARS AT ADDRESS: A 2-digit field that indicates the number of years the second cosigner has been at his/her address.

Columns Comments for RPRLAPP_INT_RATE_OPT_IND (# 200)

Source Code Comments

INTEREST RATE OPTION CODE: A 1-character field that indicates the type of interest rate associated with the loan. Valid values: F=Fixed or V=Variable

Columns Comments for RPRLAPP_REPAY_OPT_IND (# 201)

Source Code Comments

REPAYMENT OPTION CODE: A 1-character field that indicates the type of repayment option requested by the borrower. Valid values: D=Deferment, I=Interest Only, or P=Principal and interest

Columns Comments for RPRLAPP_LOCAL_PHONE_NO (# 202)

Source Code Comments

LOCAL PHONE: The local telephone number for the student.

Columns Comments for RPRLAPP_STU_EMAIL (# 203)

Source Code Comments

EMAIL ADDRESS: Student's email address.

Columns Comments for RPRLAPP_DL_REBATE_PERCENT (# 204)

Source Code Comments

REBATE FEE PERCENT: Rebate fee percent.

Columns Comments for RPRLAPP_EL_PREDISB_RECIP_PIDM (# 205)

Source Code Comments

PREDISBURSEMENT RECIPIENT PIDM:The pidm associated with the lender or servicer for pre-disbursement change records. Pre-disbursement changes for this loan application will be sent to this recipient.

Columns Comments for RPRLAPP_EL_POSTDISB_RECIP_PIDM (# 206)

Source Code Comments

POSTDISBURSEMENT RECIPIENT PIDM: The pidm associated with the lender or servicer for post-disbursement change records. Post-disbursement changes will be sent to this recipient.

Columns Comments for RPRLAPP_EL_REALLOCATE_IND (# 207)

Source Code Comments

SUB/UNSUB REALLOCATION INDICATOR: Indicates the Subsidized and Unsubsidized loan amounts are being reallocated. Valid values: Y = yes, Null = no.

Columns Comments for RPRLAPP_EL_ERROR_CODE_1 (# 208)

Source Code Comments

ELECTRONIC LOAN ERROR CODE 1: The first error code for this Electronic loan application.

Columns Comments for RPRLAPP_EL_ERROR_CODE_2 (# 209)

Source Code Comments

ELECTRONIC LOAN ERROR CODE 2: The second error code for this Electronic loan application.

Columns Comments for RPRLAPP_EL_ERROR_CODE_3 (# 210)

Source Code Comments

ELECTRONIC LOAN ERROR CODE 3: The third error code for this Electronic loan application.

Columns Comments for RPRLAPP_EL_ERROR_CODE_4 (# 211)

Source Code Comments

ELECTRONIC LOAN ERROR CODE 4: The fourth error code for this Electronic loan application.

Columns Comments for RPRLAPP_EL_ERROR_CODE_5 (# 212)

Source Code Comments

ELECTRONIC LOAN ERROR CODE 5: The fifth error code for this Electronic loan application.

Columns Comments for RPRLAPP_BOOK_BATCH_NO (# 213)

Source Code Comments

BOOKING BATCH NUMBER: Displays the disbursement batch number associated with the Booking of the loan.

Columns Comments for RPRLAPP_BOOK_DATE (# 214)

Source Code Comments

BOOKING DATE: Displays the date from the batch associated with the Booking of the loan.

Columns Comments for RPRLAPP_EL_RESP_GUAR_STATUS (# 215)

Source Code Comments

EL GUARANTOR STATUS: The loan status reported by the guarantor from the CommonLine Application Response File.

Columns Comments for RPRLAPP_EL_RESP_LENDER_STATUS (# 216)

Source Code Comments

EL LENDER STATUS: The loan status reported by the lender-servicer from the CommonLine Application Response File.

Columns Comments for RPRLAPP_EL_RESP_PN_STATUS (# 217)

Source Code Comments

EL PROMISSORY NOTE STATUS: The promissory note status reported from the CommonLine Application Response File.

Columns Comments for RPRLAPP_EL_RESP_CREDIT_STATUS (# 218)

Source Code Comments

EL CREDIT STATUS: The credit status reported from the CommonLine Application Response File

Columns Comments for RPRLAPP_EL_REINSTATE_AMT (# 219)

Source Code Comments

EL REINSTATEMENT AMOUNT: The amount of previously cancelled pre- or post-disbursement changes that are available for reinstatement. This amount is uploaded from the Response File as a result of a Change Transaction.

Columns Comments for RPRLAPP_EL_GUAR_USE_ONLY (# 220)

Source Code Comments

EL GUARANTOR USE ONLY FIELD: A field reserved for guarantor information that must be maintained at the loan level.

Columns Comments for RPRLAPP_EL_LENDER_USE_ONLY (# 221)

Source Code Comments

EL LENDER USE ONLY FIELD: A field reserved for lender information that must be maintained at the loan level.

Columns Comments for RPRLAPP_EL_BOR_EPNOTE_IND (# 222)

Source Code Comments

EL BORROWER ELECTRONIC PROM NOTE: Indicator that the borrower for the loan has completed an Electronic Promissory Note for CommonLine processing. Valid values are Y and null.

Columns Comments for RPRLAPP_EL_STU_CERT_ESIGN_IND (# 223)

Source Code Comments

EL STUDENT CERTIFICATION ELECTRONIC SIGNATURE IND: Indicates that the PLUS/Alternative student electronically signed the Student certification and authorization of the promissory note. Valid values are Y and null.

Columns Comments for RPRLAPP_EL_BOR_CREDIT_AUTH (# 224)

Source Code Comments

EL BORROWER CREDIT AUTHORIZATION: A one-character code indicating the school has obtained the borrower's authorization for an Alternative loan to perform a credit check. Valid values are Y, N, and null.

Columns Comments for RPRLAPP_HOUSE_PMT (# 225)

Source Code Comments

STUDENT HOUSING PAYMENT: The total monthly housing payment paid by the student.

Columns Comments for RPRLAPP_CC_PMT (# 226)

Source Code Comments

STUDENT CREDIT CARD PAYMENT: The total monthly credit card payment paid by the student.

Columns Comments for RPRLAPP_CAR_PMT (# 227)

Source Code Comments

STUDENT CAR PAYMENT: The total monthly car payment paid by the student.

Columns Comments for RPRLAPP_ED_LOAN_PMT (# 228)

Source Code Comments

STUDENT EDUCATIONAL LOAN PAYMENT: The total monthly educational loan payment paid by the student.

Columns Comments for RPRLAPP_OTH_PMT (# 229)

Source Code Comments

STUDENT OTHER DEBT PAYMENT: The total monthly payment for other debts paid by the student.

Columns Comments for RPRLAPP_COSIGN1_HOUSE_PMT (# 230)

Source Code Comments

COSIGNER 1 HOUSING PAYMENT: The total monthly housing payment paid by cosigner 1.

Columns Comments for RPRLAPP_COSIGN1_CC_PMT (# 231)

Source Code Comments

COSIGNER 1 CREDIT CARD PAYMENT: The total monthly credit card payment paid by cosigner 1.

Columns Comments for RPRLAPP_COSIGN1_CAR_PMT (# 232)

Source Code Comments

COSIGNER1 CAR PAYMENT: The total monthly car payment paid by cosigner 1.

Columns Comments for RPRLAPP_COSIGN1_ED_LOAN_PMT (# 233)

Source Code Comments

COSIGNER 1 EDUCATIONAL LOAN PAYMENT: The total monthly educational loan payment paid by cosigner 1.

Columns Comments for RPRLAPP_COSIGN1_OTH_PMT (# 234)

Source Code Comments

COSIGNER 1 OTHER DEBT PAYMENT: The total monthly payment for other debts paid by cosigner 1.

Columns Comments for RPRLAPP_COSIGN1_CREDIT_AUTH (# 235)

Source Code Comments

COSIGNER 1 CREDIT AUTHORIZATION: A one-character code indicating the school has obtained cosigner 1's authorization to perform a credit check. Valid values are Y, N, and null.

Columns Comments for RPRLAPP_COSIGN2_HOUSE_PMT (# 236)

Source Code Comments

COSIGNER 2 HOUSING PAYMENT: The total monthly housing payment paid by cosigner 2.

Columns Comments for RPRLAPP_COSIGN2_CC_PMT (# 237)

Source Code Comments

COSIGNER 2 CREDIT CARD PAYMENT: The total monthly credit card payment paid by cosigner 2.

Columns Comments for RPRLAPP_COSIGN2_CAR_PMT (# 238)

Source Code Comments

COSIGNER 2 CAR PAYMENT: The total monthly car payment paid by cosigner 2.

Columns Comments for RPRLAPP_COSIGN2_ED_LOAN_PMT (# 239)

Source Code Comments

COSIGNER 2 EDUCATIONAL LOAN PAYMENT: The total monthly educational loan payment paid by cosigner 2.

Columns Comments for RPRLAPP_COSIGN2_OTH_PMT (# 240)

Source Code Comments

COSIGNER 2 OTHER DEBT PAYMENT: The total monthly payment for other debts paid by cosigner 2.

Columns Comments for RPRLAPP_COSIGN2_CREDIT_AUTH (# 241)

Source Code Comments

COSIGNER 2 CREDIT AUTHORIZATION: A one-character code indicating the school has obtained cosigner 2's authorization to perform a credit check. Valid values are Y, N, and null.

Columns Comments for RPRLAPP_EL_COSIGN1_EPNOTE_IND (# 242)

Source Code Comments

EL COSIGNER 1 ELECTRONIC PROM NOTE: Indicator that the cosigner 1 for this Alternative loan has completed an Electronic Promissory Note for CommonLine processing. Valid values are Y and null.

Columns Comments for RPRLAPP_EL_COSIGN2_EPNOTE_IND (# 243)

Source Code Comments

EL COSIGNER 2 ELECTRONIC PROM NOTE: Indicator that the cosigner 2 for this Alternative loan has completed an Electronic Promissory Note for CommonLine processing. Valid values are Y and null.

Columns Comments for RPRLAPP_SAR_TRAN_NO (# 244)

Source Code Comments

SAR TRANSACTION NUMBER: The eligible SAR transaction number that was reported with the Direct Loan origination record.

Columns Comments for RPRLAPP_DOCUMENT_ID (# 245)

Source Code Comments

COD DOCUMENT ID FOR THE DIRECT LOAN AWARD RECORD: The document identification number associated with the student's direct loan award record.

Columns Comments for RPRLAPP_BOOK_DOCUMENT_ID (# 246)

Source Code Comments

COD DOCUMENT ID FOR THE BOOKING NOTIFICATION RECORD: The document identification number associated with notification from COD of the student's loan being booked.

Columns Comments for RPRLAPP_MPN_DOCUMENT_ID (# 247)

Source Code Comments

COD DOCUMENT ID FOR THE MASTER PROM NOTE RECORD: The document identification number associated with notification from COD of the student's MPN status.

Columns Comments for RPRLAPP_PAR_ENDORSER_AMT (# 248)

Source Code Comments

ENDORSER AMOUNT: The loan amount signed for by the endorser on the Endorser Addendum

Columns Comments for RPRLAPP_MPN_REPRINT (# 249)

Source Code Comments

MPN REPRINTING REQUESTED: The value in this field will be submitted via a Change Request to have COD reprint and mail the MPN; or to allow the school to reprint the MPN.

Columns Comments for RPRLAPP_EL_PLUS_REQ_AMT_IND (# 250)

Source Code Comments

PLUS REQUESTED AMOUNT INDICATOR: Indicator that the school has collected the Federal Plus requested amount for this loan.

Columns Comments for RPRLAPP_ESIGN_SOURCE_TYPE (# 251)

Source Code Comments

E-SIGNATURE SOURCE TYPE CODE: Code that includes the type of organization that captured the electronic signature and the organization's OPE ID or NCHELP assigned ID

Columns Comments for RPRLAPP_SERV_FED_APP_FORM_CDE (# 252)

Source Code Comments

SERVICER FEDERAL APPLICATION FORM CODE: A one character code indicating the version of the application and promissory note processed by the lender/servicer for this loan.

Columns Comments for RPRLAPP_PLUS_BORROWER_ID_NO (# 253)

Source Code Comments

PLUS BORROWER IDENTIFIER NUMBER: The PLUS borrower identifier number for this loan.

Columns Comments for RPRLAPP_DATA_ORIGIN (# 254)

Source Code Comments

DATA ORIGIN: The latest source for the data contained in this record.

Columns Comments for RPRLAPP_MPN_EXP_DATE (# 255)

Source Code Comments

MPN Expiration Date: The date this MPN expired.

Columns Comments for RPRLAPP_MPN_EXP_CODE (# 256)

Source Code Comments

MPN Expiration Reason Code: The Reason Code for why the MPN expired.

Columns Comments for RPRLAPP_MPN_EXP_DESC (# 257)

Source Code Comments

MPN Expiration Reason Description: The Reason Description for why the MPN expired.

Columns Comments for RPRLAPP_DL_EDIT_FIELD_1 (# 258)

Source Code Comments

DL Disbursement Response Edit Field 1: The field (XML tag) associated with edit 1.

Columns Comments for RPRLAPP_DL_EDIT_FIELD_2 (# 259)

Source Code Comments

DL Disbursement Response Edit Field 2: The field (XML tag) associated with edit 2.

Columns Comments for RPRLAPP_DL_EDIT_FIELD_3 (# 260)

Source Code Comments

DL Disbursement Response Edit Field 3: The field (XML tag) associated with edit 3.

Columns Comments for RPRLAPP_DL_EDIT_FIELD_4 (# 261)

Source Code Comments

DL Disbursement Response Edit Field 4: The field (XML tag) associated with edit 4.

Columns Comments for RPRLAPP_DL_EDIT_FIELD_5 (# 262)

Source Code Comments

DL Disbursement Response Edit Field 5: The field (XML tag) associated with edit 5.

Columns Comments for RPRLAPP_BORROWER_EMAIL (# 263)

Source Code Comments

BORROWER'S E-MAIL ADDRESS: The borrower's e-mail address.

Columns Comments for RPRLAPP_SCHOOL_CODE (# 264)

Source Code Comments

SCHOOL CODE: The Department of Education's school code to be used for loan processing for a specific campus.

Columns Comments for RPRLAPP_LOAN_TYPE (# 265)

Source Code Comments

LOAN TYPE: The loan type for the record.

Columns Comments for RPRLAPP_PREP_OR_TEACH_IND (# 266)

Source Code Comments

PREPARATORY OR TEACHER CERTIFICATION COURSEWORK INDICATOR: Indicates if specific loan limits should be applied due to enrollment in preparatory coursework required prior to enrolling in an undergraduate degree or certificate program or a graduate or pro
fessional program, or due to coursework necessary for teacher certification.

Columns Comments for RPRLAPP_CREDIT_DOCUMENT_ID (# 267)

Source Code Comments

CREDIT STATUS DOCUMENT ID: The Document ID in which the credit check status was received.

Columns Comments for RPRLAPP_SURNAME_PREFIX (# 268)

Source Code Comments

SURNAME PREFIX: Name tag preceding the borrower's last name or surname. (Van, Von, Mac. etc.)

Columns Comments for RPRLAPP_ADDR_LINE3 (# 269)

Source Code Comments

ADDRESS LINE3: Third line of the student's permanent street address.

Columns Comments for RPRLAPP_ADDR_LINE4 (# 270)

Source Code Comments

ADDRESS LINE4: Fourth line of the student's permanent street address.

Columns Comments for RPRLAPP_HOUSE_NUMBER (# 271)

Source Code Comments

HOUSE NUMBER: Student's building or lot number on a street or in an area.

Columns Comments for RPRLAPP_CTRY_CODE_PHONE (# 272)

Source Code Comments

TELEPHONE COUNTRY CODE: Student's telephone code designating the region or country.

Columns Comments for RPRLAPP_LOCAL_ADDR_LINE3 (# 273)

Source Code Comments

ADDRESS LINE3: Third line of the student's local street address.

Columns Comments for RPRLAPP_LOCAL_ADDR_LINE4 (# 274)

Source Code Comments

ADDRESS LINE4: Fourth line of the student's local street address.

Columns Comments for RPRLAPP_LOCAL_HOUSE_NUMBER (# 275)

Source Code Comments

HOUSE NUMBER: Student's local building or lot number on a street or in an area.

Columns Comments for RPRLAPP_CTRY_CODE_LOCAL_PHONE (# 276)

Source Code Comments

TELEPHONE COUNTRY CODE: Student's local telephone code designating the region or country.

Columns Comments for RPRLAPP_PAR_SURNAME_PREFIX (# 277)

Source Code Comments

SURNAME PREFIX: Name tag preceding the parent's last name or surname. (Van, Von, Mac. etc.)

Columns Comments for RPRLAPP_PAR_ADDR_LINE3 (# 278)

Source Code Comments

ADDRESS LINE3: Third line of the parent's permanent street address.

Columns Comments for RPRLAPP_PAR_ADDR_LINE4 (# 279)

Source Code Comments

ADDRESS LINE4: Fourth line of the parent's permanent street address.

Columns Comments for RPRLAPP_PAR_HOUSE_NUMBER (# 280)

Source Code Comments

HOUSE NUMBER: Parent's permanent building or lot number on a street or in an area.

Columns Comments for RPRLAPP_CTRY_CODE_PAR_PHONE (# 281)

Source Code Comments

TELEPHONE COUNTRY CODE: Parent's telephone code designating the region or country.

Columns Comments for RPRLAPP_PAR_LOCAL_ADDR_LINE3 (# 282)

Source Code Comments

ADDRESS LINE3: Third line of the parent's local street address.

Columns Comments for RPRLAPP_PAR_LOCAL_ADDR_LINE4 (# 283)

Source Code Comments

ADDRESS LINE4: Fourth line of the parent's local street address.

Columns Comments for RPRLAPP_PAR_LOCAL_HOUSE_NUMBER (# 284)

Source Code Comments

HOUSE NUMBER: Parent's local building or lot number on a street or in an area.

Columns Comments for RPRLAPP_COSIGN1_SURNAME_PREFIX (# 285)

Source Code Comments

SURNAME PREFIX: Name tag preceding the first cosigner's last name or surname. (Van, Von, Mac. etc.)

Columns Comments for RPRLAPP_COSIGN1_ADDR_LINE3 (# 286)

Source Code Comments

ADDRESS LINE3: Third line of the first cosigner's last known address.

Columns Comments for RPRLAPP_COSIGN1_ADDR (# 287)

Source Code Comments

ADDRESS LINE4: Fourth line of the first cosigner's last known address.

Columns Comments for RPRLAPP_COSIGN1_HOUSE_NUMBER (# 288)

Source Code Comments

HOUSE NUMBER: First cosigner's building or lot number on a street or in an area.

Columns Comments for RPRLAPP_CTRY_CODE_COSIG1_PHONE (# 289)

Source Code Comments

TELEPHONE COUNTRY CODE: First cosigner's telephone code designating the region or country.

Columns Comments for RPRLAPP_COSIGN2_SURNAME_PREFIX (# 290)

Source Code Comments

SURNAME PREFIX: Name tag preceding the second cosigner's last name or surname. (Van, Von, Mac. etc.)

Columns Comments for RPRLAPP_COSIGN2_ADDR (# 291)

Source Code Comments

ADDRESS LINE4: Fourth line of the second cosigner's last known address.

Columns Comments for RPRLAPP_COSIGN2_HOUSE_NUMBER (# 292)

Source Code Comments

HOUSE NUMBER: Second cosigner's building or lot number on a street or in an area.

Columns Comments for RPRLAPP_CTRY_CODE_COSIG2_PHONE (# 293)

Source Code Comments

TELEPHONE COUNTRY CODE: Second cosigner's telephone code designating the region or country.

Columns Comments for RPRLAPP_COSIGN1_ADDR_LINE4 (# 294)

Source Code Comments

ADDRESS LINE4: Fourth line of the first cosigner's last known address.

Columns Comments for RPRLAPP_COSIGN2_ADDR_LINE3 (# 295)

Source Code Comments

ADDRESS LINE3: Third line of the second cosigner's last known address.

Columns Comments for RPRLAPP_COSIGN2_ADDR_LINE4 (# 296)

Source Code Comments

ADDRESS LINE4: Fourth line of the second cosigner's last known address.

Table RPRLATR

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RPRLATR_PIDM	NUMBER(8,0)	No	*
RPRLATR_FUND_CODE	VARCHAR2(6)	No	*
RPRLATR_APPL_NO	NUMBER(3,0)	No	*
RPRLATR_TERM_CODE	VARCHAR2(6)	No	*	*
RPRLATR_LOAN_PCT	NUMBER(6,3)	No
RPRLATR_ACTIVITY_DATE	DATE	No
RPRLATR_RECOMMEND_AMT	NUMBER(11,2)	Yes
RPRLATR_REQUEST_AMT	NUMBER(11,2)	Yes
RPRLATR_EXPECT_AMT	NUMBER(11,2)	Yes
RPRLATR_APPROVE_AMT	NUMBER(11,2)	Yes
RPRLATR_MEMO_EXP_DATE	DATE	Yes
RPRLATR_CERT_HR	NUMBER(9,3)	Yes
RPRLATR_AIDY_CODE	VARCHAR2(4)	Yes
RPRLATR_DL_SEQ_NO	NUMBER(2,0)	Yes
RPRLATR_USER_ID	VARCHAR2(30)	Yes
RPRLATR_EXCLUDE_LNEX_FLAG	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RPRLATR_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_RPRLATR	Unique	RPRLATR_PIDM
PK_RPRLATR	Unique	RPRLATR_FUND_CODE
PK_RPRLATR	Unique	RPRLATR_APPL_NO
PK_RPRLATR	Unique	RPRLATR_TERM_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RPBLOPT	SQL Table	S10B80.FAISMGR	Join
RPRLAPP	SQL Table	S10B80.FAISMGR	Join
F_EXP_LOAN	SQL Function	S10B80.BANINST1	Use (select)
LOANTERMSCHEDRECTYPE	Oracle Package Type	S10B80.BANINST1.RPKAWRD	Rely On
P_ADD_LOAN_TERM_SCHED_REC	Oracle Package Procedure	S10B80.BANINST1.RPKAWRD	Rely On
P_ADD_LOAN_TERM_SCHED_REC	Oracle Package Procedure	S10B80.BANINST1.RPKAWRD	Use (Insert)
P_CALC_LOAN_TERM_SCHED_AMTS	Oracle Package Procedure	S10B80.BANINST1.RPKAWRD	Rely On
P_ADD_AWARD_REC	Oracle Package Procedure	S10B80.BANINST1.RPKLOAN	Use (select)
P_ADD_AWARD_TERM_REC	Oracle Package Procedure	S10B80.BANINST1.RPKLOAN	Use (select)
P_ADD_LOAN_PROCESS	Oracle Package Procedure	S10B80.BANINST1.RPKLOAN	Use (select)
P_DISPLAY_RPRLATR	Oracle Package Procedure	S10B80.BANINST1.RPK_DEBS_DISPLAYS	Rely On
P_DISPLAY_RPRLATR	Oracle Package Procedure	S10B80.BANINST1.RPK_DEBS_DISPLAYS	Use (select)Rely On
RPRLATR	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RPRLATR	SQL Index	S10B80.FAISMGR	Rely On
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RPRLATR

Object Dates

Creation Date	Analysis Date
04/02/2008 10:28:07:000	04/02/2008 10:35:21:000

Source Code Comments

Loan Term Schedule Rules Table

Columns Comments for RPRLATR_PIDM (# 1)

Source Code Comments

PIDM: Internal system-generated student identification number.

Columns Comments for RPRLATR_FUND_CODE (# 2)

Source Code Comments

FUND CODE: This field identifies the fund associated with the loan application.

Columns Comments for RPRLATR_APPL_NO (# 3)

Source Code Comments

APPLICATION NUMBER: This field maintains the application number associated with the loan term schedule.

Columns Comments for RPRLATR_TERM_CODE (# 4)

Source Code Comments

TERM CODE: This field identifies the terms associated with the loan application.

Columns Comments for RPRLATR_LOAN_PCT (# 5)

Source Code Comments

LOAN PERCENT: This field represents the percentage of the loan that is scheduled by term.

Columns Comments for RPRLATR_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: This field maintains the date that information in this record was entered of last updated.

Columns Comments for RPRLATR_RECOMMEND_AMT (# 7)

Source Code Comments

RECOMMENDED AMOUNT: This field maintains the recommended amount of the loan associated with the loan application scheduled by term.

Columns Comments for RPRLATR_REQUEST_AMT (# 8)

Source Code Comments

REQUESTED AMOUNT: This field maintains the requested amount of the loan scheduled by term.

Columns Comments for RPRLATR_EXPECT_AMT (# 9)

Source Code Comments

EXPECTED AMOUNT: This field maintains the expected loan amount associated with the application scheduled by terms.

Columns Comments for RPRLATR_APPROVE_AMT (# 10)

Source Code Comments

APPROVE AMOUNT: This field maintains the approved loan amount for the application for each term.

Columns Comments for RPRLATR_MEMO_EXP_DATE (# 11)

Source Code Comments

MEMO EXPIRATION DATE: The date on which this memo is no longer effective.

Columns Comments for RPRLATR_CERT_HR (# 12)

Source Code Comments

CERTIFIED HOURS: Column to store the number of credit hours at the time the loan is certified.

Columns Comments for RPRLATR_AIDY_CODE (# 13)

Source Code Comments

The aid year code associated with this loan term schedule.

Columns Comments for RPRLATR_DL_SEQ_NO (# 14)

Source Code Comments

A system generated sequence number to designate direct loan applications.

Columns Comments for RPRLATR_USER_ID (# 15)

Source Code Comments

The user id of the person who last updated the loan term schedule record for this student.

Columns Comments for RPRLATR_EXCLUDE_LNEX_FLAG (# 16)

Source Code Comments

EXCLUDE FROM RPRLNEX FLAG: This field indicates that the RPRLNEX report should not display a line for this loan and term, even if there was a discrepancy in the amounts.

Table RPRLCRT

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RPRLCRT_PIDM	NUMBER(8,0)	No	*	*
RPRLCRT_FUND_CODE	VARCHAR2(6)	No	*	*
RPRLCRT_APPL_NO	NUMBER(3,0)	No	*	*
RPRLCRT_SEQ_NO	NUMBER(3,0)	No	*
RPRLCRT_BUDGET_AMT	NUMBER(11,2)	Yes
RPRLCRT_TOTAL_AID_AMT	NUMBER(11,2)	Yes
RPRLCRT_TFC_AMT	NUMBER(11,2)	Yes
RPRLCRT_MAX_ELIG_AMT	NUMBER(11,2)	Yes
RPRLCRT_AGI_AMT	NUMBER(11,2)	Yes
RPRLCRT_EXPECT_AMT	NUMBER(11,2)	No
RPRLCRT_ACTIVITY_DATE	DATE	No
RPRLCRT_CINT_CODE	VARCHAR2(4)	Yes		*
RPRLCRT_CERT_DATE	DATE	Yes
RPRLCRT_CLAS_CODE	VARCHAR2(1)	Yes
RPRLCRT_EXP_GRAD_MTH_YR	VARCHAR2(8)	Yes
RPRLCRT_DEPEND_STATUS	VARCHAR2(1)	Yes
RPRLCRT_HOUS_CDE	VARCHAR2(1)	Yes
RPRLCRT_ENROLL_STATUS	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RPRLCRT_PIDM	RPRLAPP_PIDM	RPRLAPP
RPRLCRT_FUND_CODE	RPRLAPP_FUND_CODE	RPRLAPP
RPRLCRT_APPL_NO	RPRLAPP_APPL_NO	RPRLAPP
RPRLCRT_CINT_CODE	RTVCINT_CODE	RTVCINT

Index

Index Name	Index Type	Column Name
PK_RPRLCRT	Unique	RPRLCRT_PIDM
PK_RPRLCRT	Unique	RPRLCRT_FUND_CODE
PK_RPRLCRT	Unique	RPRLCRT_APPL_NO
PK_RPRLCRT	Unique	RPRLCRT_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_CALC_LOAN_ENROLL_STATUS	Oracle Package Procedure	S10B80.BANINST1.RPKLOAN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RPRLCRT	SQL Index	S10B80.FAISMGR	Rely On
RPRLAPP	SQL Table	S10B80.FAISMGR	Refer (no action)
RTVCINT	SQL Table	S10B80.FAISMGR	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RPRLCRT

Object Dates

Creation Date	Analysis Date
04/02/2008 10:29:45:000	04/02/2008 10:35:22:000

Source Code Comments

Loan Certification Table

Columns Comments for RPRLCRT_PIDM (# 1)

Source Code Comments

PIDM: Internal system generated student identification number.

Columns Comments for RPRLCRT_FUND_CODE (# 2)

Source Code Comments

FUND CODE: This field represents the fund code associated with the loan being processed.

Columns Comments for RPRLCRT_APPL_NO (# 3)

Source Code Comments

APPLICATION NUMBER:

Columns Comments for RPRLCRT_SEQ_NO (# 4)

Source Code Comments

SEQUENCE NUMBER: This field represents the internal assigned sequence of the loan certification.

Columns Comments for RPRLCRT_BUDGET_AMT (# 5)

Source Code Comments

BUDGET AMOUNT: This field represents the student's budget for the loan period.

Columns Comments for RPRLCRT_TOTAL_AID_AMT (# 6)

Source Code Comments

TOTAL AID AMOUNT: This field represents the total aid and resources the student has during the specified loan period.

Columns Comments for RPRLCRT_TFC_AMT (# 7)

Source Code Comments

TOTAL FAMILY CONTRIBUTION AMOUNT: This field represents the TFC for the loan period.

Columns Comments for RPRLCRT_MAX_ELIG_AMT (# 8)

Source Code Comments

MAXIMUM ELIGIBLE AMOUNT: This field represents the maximum amount of the loan that the student is eligible to receive during the specified loan period.

Columns Comments for RPRLCRT_AGI_AMT (# 9)

Source Code Comments

ADJUSTED GROSS INCOME AMOUNT: This field represents the family AGI.

Columns Comments for RPRLCRT_EXPECT_AMT (# 10)

Source Code Comments

EXPECTED AMOUNT: This field maintains the expected amount of the loan. This will be the lesser of either the processed amount or the requested amount.

Columns Comments for RPRLCRT_ACTIVITY_DATE (# 11)

Source Code Comments

ACTIVITY DATE: This field maintains the date that information in this record was entered or last updated.

Columns Comments for RPRLCRT_CINT_CODE (# 12)

Source Code Comments

CERTIFICATION INITIALS: This field identifies the initials of the person certifying the loan.

Columns Comments for RPRLCRT_CERT_DATE (# 13)

Source Code Comments

CERTIFICATION DATE: This field maintains the date that the certification was signed.

Columns Comments for RPRLCRT_CLAS_CODE (# 14)

Source Code Comments

CLASS CODE: This field identifies the current class level of the student.

Columns Comments for RPRLCRT_EXP_GRAD_MTH_YR (# 15)

Source Code Comments

EXPECTED GRADUATION DATE: This field maintains the expected graduation date of the student in this record.

Columns Comments for RPRLCRT_DEPEND_STATUS (# 16)

Source Code Comments

DEPENDENCY STATUS: This field identifies the dependency status of the student in this record.

Columns Comments for RPRLCRT_HOUS_CDE (# 17)

Source Code Comments

HOUSING CODE: This field maintains the housing code representing where the student will be living during the loan period.

Columns Comments for RPRLCRT_ENROLL_STATUS (# 18)

Source Code Comments

ENROLLMENT STATUS: This field identifies the enrollment status of the student in this record during the intended loan period.

Table RPRLTRM

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RPRLTRM_LOAN_PERIOD	VARCHAR2(6)	No	*	*
RPRLTRM_TERM_CODE	VARCHAR2(6)	No	*	*
RPRLTRM_LOAN_PCT	NUMBER(6,3)	No
RPRLTRM_ACTIVITY_DATE	DATE	No
RPRLTRM_MEMO_EXP_DATE	DATE	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RPRLTRM_LOAN_PERIOD	RPBLPRD_LOAN_PERIOD	RPBLPRD
RPRLTRM_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_RPRLTRM	Unique	RPRLTRM_LOAN_PERIOD
PK_RPRLTRM	Unique	RPRLTRM_TERM_CODE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RPRLTRM	SQL Index	S10B80.FAISMGR	Rely On
RPBLPRD	SQL Table	S10B80.FAISMGR	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RPRLTRM

Object Dates

Creation Date	Analysis Date
04/02/2008 10:32:04:000	04/02/2008 10:35:24:000

Source Code Comments

Loan Period / Term Schedule Rules Table

Columns Comments for RPRLTRM_LOAN_PERIOD (# 1)

Source Code Comments

LOAN PERIOD: The period covering the loan.

Columns Comments for RPRLTRM_TERM_CODE (# 2)

Source Code Comments

TERM CODE: The term associated with the loan period.

Columns Comments for RPRLTRM_LOAN_PCT (# 3)

Source Code Comments

LOAN PERCENT: The percentage of the loan associated with the valid terms.

Columns Comments for RPRLTRM_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: This field maintains the date that information in this record was entered or last updated.

Columns Comments for RPRLTRM_MEMO_EXP_DATE (# 5)

Source Code Comments

MEMO EXPIRATION DATE: The date on which this memo is no longer effective.

Table RPRRFND

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
RPRRFND_PIDM	NUMBER(8,0)	No
RPRRFND_DL_LOAN_ID	VARCHAR2(21)	No
RPRRFND_SEQ_NO	NUMBER(2,0)	No
RPRRFND_ACTIVITY_DATE	DATE	No
RPRRFND_DL_DISB_NO	NUMBER(2,0)	Yes
RPRRFND_TRANS_DATE	DATE	Yes
RPRRFND_BATCH_NO	VARCHAR2(23)	Yes
RPRRFND_REFUND_AMT	NUMBER(5,0)	Yes
RPRRFND_ACK_DATE	DATE	Yes
RPRRFND_DOCUMENT_ID	VARCHAR2(30)	Yes
RPRRFND_USER_ID	VARCHAR2(30)	Yes
RPRRFND_DATA_ORIGIN	VARCHAR2(30)	Yes
RPRRFND_PREV_DISB_SEQ_NO	NUMBER(2,0)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
RPRRFND_DL_LOAN_ID_INDEX		RPRRFND_DL_LOAN_ID
RPRRFND_DL_LOAN_ID_INDEX		RPRRFND_PIDM
RPRRFND_DL_LOAN_ID_INDEX		RPRRFND_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
DL_REFUND_REC	Oracle Package Type	S10B80.BANINST1.RB_DL_REFUND	Rely On
P_INSERT_SERVICER_REFUNDS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_INSERT_SERVICER_REFUNDS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_INSERT_SERVICER_REFUNDS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_INSERT_SERVICER_REFUNDS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_INSERT_SERVICER_REFUNDS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.RB_DL_REFUND	Rely On
P_UPDATEDLORIG	Oracle Package Procedure	S10B80.BANINST1.REKCI04	Rely On
P_UPDATEDLORIG	Oracle Package Procedure	S10B80.BANINST1.REKCI04	Use (Insert)
RPRRFND_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI04	Rely On
F_BUILD_RPRRFND_REC	Oracle Package Function	S10B80.BANINST1.RB_DL_REFUND	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.RB_DL_REFUND	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_RPRRFND	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.RB_DL_REFUND	Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_RPRRFND	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.RB_DL_REFUND	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.RB_DL_REFUND_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_RPRRFND	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.RB_DL_REFUND	Rely On
P_UPDATE_DLPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_DLPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_DLPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_DLPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_DLPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_DLPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCIXX	Rely On
P_UPDATE_DLSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_DLSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_DLSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_DLSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_DLSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_DLSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCIXX	Rely On
P_UPDATE_DLUNSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_DLUNSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_DLUNSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_DLUNSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_DLUNSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_DLUNSUB_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCIXX	Rely On
P_UPDATE_GPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_GPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_GPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_GPLUS_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.RB_DL_REFUND_RULES	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_DL_REFUND	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.RB_DL_REFUND	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.RB_DL_REFUND	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.RB_DL_REFUND	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.RB_DL_REFUND	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.RB_DL_REFUND	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.RB_DL_REFUND	Use (select)
RPRRFND	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RPRRFND_DL_LOAN_ID_INDEX	SQL Index	S10B80.FAISMGR	Rely On
RT_RPRRFND_USER_INSUPD	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,before,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RPRRFND

Object Dates

Creation Date	Analysis Date
04/02/2008 10:27:12:000	04/02/2008 10:35:20:000

Source Code Comments

Direct Loan Refund Table

Columns Comments for RPRRFND_PIDM (# 1)

Source Code Comments

PIDM: Internal identification number identifying the student associated with this data.

Columns Comments for RPRRFND_DL_LOAN_ID (# 2)

Source Code Comments

DIRECT LOAN ID: Unique identifier created at the time of origination.

Columns Comments for RPRRFND_SEQ_NO (# 3)

Source Code Comments

DIRECT LOAN SEQUENCE NUMBER: One-up number used to uniquely identify the record in the table.

Columns Comments for RPRRFND_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: Date that this record was created or last updated.

Columns Comments for RPRRFND_DL_DISB_NO (# 5)

Source Code Comments

DIRECT LOAN DISBURSEMENT NUMBER: The disbursement number which the refund was applied to.

Columns Comments for RPRRFND_TRANS_DATE (# 6)

Source Code Comments

TRANSACTION DATE: The date that the COD posted the refund.

Columns Comments for RPRRFND_BATCH_NO (# 7)

Source Code Comments

BATCH NUMBER: The batch number used to report the refund.

Columns Comments for RPRRFND_REFUND_AMT (# 8)

Source Code Comments

REFUND AMOUNT: The amount refunded by the borrower to the COD. A negative amount indicates a refund. A positive amount indicates a reversal of the refund (e.g. bounced check).

Columns Comments for RPRRFND_ACK_DATE (# 9)

Source Code Comments

ACKNOWLEDGMENT DATE: Date that the COD acknowledged the refund.

Columns Comments for RPRRFND_DOCUMENT_ID (# 10)

Source Code Comments

COD DOCUMENT ID FOR COD REFUND RECORD: The document identification number associated with notification from COD of a refund for the student's loan.

Columns Comments for RPRRFND_USER_ID (# 11)

Source Code Comments

USER ID: The logon ID of the user who entered or last updated the record in this table.

Columns Comments for RPRRFND_DATA_ORIGIN (# 12)

Source Code Comments

DATA ORIGIN: The latest source for the data contained in this record.

Columns Comments for RPRRFND_PREV_DISB_SEQ_NO (# 13)

Source Code Comments

Previous Disbursement Sequence Number: The previous disbursement sequence number on the COD database for the disbursement number.

Table RTVCDNT

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
RTVCDNT_CODE	VARCHAR2(3)	No
RTVCDNT_DESC	VARCHAR2(35)	No
RTVCDNT_ACTIVITY_DATE	DATE	No
RTVCDNT_CROSSWALK_CODE	VARCHAR2(5)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
RTVCDNT_KEY_INDEX	Unique	RTVCDNT_CODE
RTVCDNT_KEY_INDEX	Unique	RTVCDNT_CROSSWALK_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
F_GET_COD_NATN_CODE	Oracle Package Function	S10B80.BANINST1.REKCE05	Rely On
F_GET_COD_NATN_CODE	Oracle Package Function	S10B80.BANINST1.REKCE05	Use (select)
F_GET_COD_NATN_CODE	Oracle Package Function	S10B80.BANINST1.REKCE06	Rely On
F_GET_COD_NATN_CODE	Oracle Package Function	S10B80.BANINST1.REKCE06	Use (select)
F_GET_COD_NATN_CODE	Oracle Package Function	S10B80.BANINST1.REKCE07	Rely On
F_GET_COD_NATN_CODE	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_GET_COD_NATN_CODE	Oracle Package Function	S10B80.BANINST1.REKCE08	Rely On
F_GET_COD_NATN_CODE	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_GET_COD_NATN_CODE	Oracle Package Function	S10B80.BANINST1.REKCE09	Rely On
F_GET_COD_NATN_CODE	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
F_GET_COD_NATN_CODE	Oracle Package Function	S10B80.BANINST1.REKCEXX	Rely On
RTVCDNT	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RTVCDNT_KEY_INDEX	SQL Index	S10B80.FAISMGR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RTVCDNT

Object Dates

Creation Date	Analysis Date
04/02/2008 10:31:45:000	04/02/2008 10:35:24:000

Source Code Comments

COD Nation Code Rules Table

Columns Comments for RTVCDNT_CODE (# 1)

Source Code Comments

COD NATION CODE: The nation code for COD Full Participants.

Columns Comments for RTVCDNT_DESC (# 2)

Source Code Comments

COD NATION DESCRIPTION: The nation code description for COD Full Participants.

Columns Comments for RTVCDNT_ACTIVITY_DATE (# 3)

Source Code Comments

ACTIVITY DATE: The date the record was created or last updated.

Columns Comments for RTVCDNT_CROSSWALK_CODE (# 4)

Source Code Comments

Crosswalk Nation Code: The crosswalk code from the student table that corresponds to the COD Nation Code.

Table RTVCDST

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
RTVCDST_CODE	VARCHAR2(3)	No
RTVCDST_DESC	VARCHAR2(35)	No
RTVCDST_ACTIVITY_DATE	DATE	No
RTVCDST_CROSSWALK_CODE	VARCHAR2(3)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
RTVCDST_KEY_INDEX	Unique	RTVCDST_CODE
RTVCDST_KEY_INDEX	Unique	RTVCDST_CROSSWALK_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
F_GET_COD_STATE_CODE	Oracle Package Function	S10B80.BANINST1.REKCE05	Rely On
F_GET_COD_STATE_CODE	Oracle Package Function	S10B80.BANINST1.REKCE05	Use (select)
F_GET_COD_STATE_CODE	Oracle Package Function	S10B80.BANINST1.REKCE06	Rely On
F_GET_COD_STATE_CODE	Oracle Package Function	S10B80.BANINST1.REKCE06	Use (select)
F_GET_COD_STATE_CODE	Oracle Package Function	S10B80.BANINST1.REKCE07	Rely On
F_GET_COD_STATE_CODE	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_GET_COD_STATE_CODE	Oracle Package Function	S10B80.BANINST1.REKCE08	Rely On
F_GET_COD_STATE_CODE	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_GET_COD_STATE_CODE	Oracle Package Function	S10B80.BANINST1.REKCE09	Rely On
F_GET_COD_STATE_CODE	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
F_GET_COD_STATE_CODE	Oracle Package Function	S10B80.BANINST1.REKCEXX	Rely On
RTVCDST	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RTVCDST_KEY_INDEX	SQL Index	S10B80.FAISMGR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RTVCDST

Object Dates

Creation Date	Analysis Date
04/02/2008 10:31:50:000	04/02/2008 10:35:24:000

Source Code Comments

COD State Code Rules Table

Columns Comments for RTVCDST_CODE (# 1)

Source Code Comments

COD STATE CODE: The state code for COD Full Participants.

Columns Comments for RTVCDST_DESC (# 2)

Source Code Comments

COD STATE DESCRIPTION: The state code description for COD Full Participants.

Columns Comments for RTVCDST_ACTIVITY_DATE (# 3)

Source Code Comments

ACTIVITY DATE: The date the record was created or last updated.

Columns Comments for RTVCDST_CROSSWALK_CODE (# 4)

Source Code Comments

Crosswalk State Code: The crosswalk code from the student table that corresponds to the COD State Code.

Table RTVCINT

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
RTVCINT_CODE	VARCHAR2(4)	No	*
RTVCINT_LAST_NAME	VARCHAR2(60)	No
RTVCINT_FIRST_NAME	VARCHAR2(60)	No
RTVCINT_MI	VARCHAR2(60)	Yes
RTVCINT_ACTIVITY_DATE	DATE	Yes
RTVCINT_SURNAME_PREFIX	VARCHAR2(60)	Yes
RTVCINT_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_RTVCINT	Unique	RTVCINT_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RPRASTD	SQL Table	S10B80.FAISMGR	Refer (no action)
RPRLCRT	SQL Table	S10B80.FAISMGR	Refer (no action)
RTVCINTC	Oracle Package Cursor	S10B80.BANINST1.RTKCINT	Use (select)Rely On
RTVCINT	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RTVCINT	SQL Index	S10B80.FAISMGR	Rely On
RT_RTVCINT_LOG_INSUPDDTL	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,delete,after,each row)
RT_RTVCINT_USERACTIVIT_INSUPD	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,before,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RTVCINT

Object Dates

Creation Date	Analysis Date
04/02/2008 10:28:36:000	04/02/2008 10:35:21:000

Source Code Comments

Certification Initials Validation Table

Columns Comments for RTVCINT_CODE (# 1)

Source Code Comments

CERTIFICATION INITIALS: This field is used to store valid initials of people who are eligible to certify a loan.

Columns Comments for RTVCINT_LAST_NAME (# 2)

Source Code Comments

LAST NAME: This field stores the last name associated with the last character of the certification initials.

Columns Comments for RTVCINT_FIRST_NAME (# 3)

Source Code Comments

FIRST NAME: This is the first name associated with the first character of the certification initials.

Columns Comments for RTVCINT_MI (# 4)

Source Code Comments

MIDDLE INITIAL: This field stores the middle initial associated with the middle character of the certification initials.

Columns Comments for RTVCINT_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: This field maintains the date that the record was entered or last updated.

Columns Comments for RTVCINT_SURNAME_PREFIX (# 6)

Source Code Comments

SURNAME PREFIX: Name tag preceding the last name or surname. (Van, Von, Mac. etc.)

Columns Comments for RTVCINT_USER_ID (# 7)

Source Code Comments

USER ID: The logon ID of the user who entered or last updated this row in this table.

Table RTVDLBT

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
RTVDLBT_CODE	VARCHAR2(1)	No
RTVDLBT_DESC	VARCHAR2(30)	No
RTVDLBT_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
RTVDLBT_KEY_INDEX	Unique	RTVDLBT_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RTVDLBTC	Oracle Package Cursor	S10B80.BANINST1.RTKDLBT	Use (select)Rely On
RTVDLBT	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RTVDLBT_KEY_INDEX	SQL Index	S10B80.FAISMGR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RTVDLBT

Object Dates

Creation Date	Analysis Date
04/02/2008 10:26:19:000	04/02/2008 10:35:19:000

Source Code Comments

Batch Type Validation Table defines the batch types that are available in Direct Lending, one type for each kind of record sent to or received by the servicer.

Table RTVINFC

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RTVINFC_CODE	VARCHAR2(7)	No	*
RTVINFC_DESC	VARCHAR2(30)	No
RTVINFC_ACTIVITY_DATE	DATE	No
RTVINFC_CTYP_CODE	VARCHAR2(3)	Yes
RTVINFC_SBGI_CODE	VARCHAR2(6)	Yes		*
RTVINFC_TREQ_CODE	VARCHAR2(6)	Yes		*
RTVINFC_TRST_CODE	VARCHAR2(1)	Yes		*
RTVINFC_SYSTEM_REQ_IND	VARCHAR2(1)	Yes
RTVINFC_TREQ_CODE_SUPP	VARCHAR2(6)	Yes		*
RTVINFC_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RTVINFC_TREQ_CODE	RTVTREQ_CODE	RTVTREQ
RTVINFC_TREQ_CODE_SUPP	RTVTREQ_CODE	RTVTREQ
RTVINFC_TRST_CODE	RTVTRST_CODE	RTVTRST
RTVINFC_SBGI_CODE	STVSBGI_CODE	STVSBGI

Index

Index Name	Index Type	Column Name
PK_RTVINFC	Unique	RTVINFC_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RCRAPP1	SQL Table	S10B80.FAISMGR	Refer (no action)
RCRAPP2	SQL Table	S10B80.FAISMGR	Refer (no action)
RCRAPP3	SQL Table	S10B80.FAISMGR	Refer (no action)
RCRAPP4	SQL Table	S10B80.FAISMGR	Refer (no action)
RCRESAR	SQL Table	S10B80.FAISMGR	Refer (no action)
RCRINFR	SQL Table	S10B80.FAISMGR	Refer (no action)
RCRTMP1	SQL Table	S10B80.FAISMGR	Refer (no action)
RCRTMP2	SQL Table	S10B80.FAISMGR	Refer (no action)
RCRTMP3	SQL Table	S10B80.FAISMGR	Refer (no action)
RCRTMP4	SQL Table	S10B80.FAISMGR	Refer (no action)
RCRTPTR	SQL Table	S10B80.FAISMGR	Refer (no action)
RLRAPP1	SQL Table	S10B80.FAISMGR	Refer (no action)
RLRAPP2	SQL Table	S10B80.FAISMGR	Refer (no action)
RLRAPP3	SQL Table	S10B80.FAISMGR	Refer (no action)
RLRAPP4	SQL Table	S10B80.FAISMGR	Refer (no action)
ROBINST	SQL Table	S10B80.FAISMGR	Refer (no action)
RPRLAPP	SQL Table	S10B80.FAISMGR	Refer (no action)
F_FINAID_GET_DESC	SQL Function	S10B80.BANINST1	Use (select)
F_INFC_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_USER_DEF_DATA_RULES	Rely On
F_INFC_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_USER_DEF_DATA_RULES	Use (select)
RTVINFCC	Oracle Package Cursor	S10B80.BANINST1.RTKINFC	Use (select)Rely On
RTVINFC_C	Oracle Package Cursor	S10B80.BANINST1.RB_RTVINFC	Rely On
RTVINFC_C	Oracle Package Cursor	S10B80.BANINST1.RB_RTVINFC	Use (select)Rely On
P_PA_RTVINFC_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_TEMP_APPL_STATUS	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_APPLICANT_STATUS	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_PGRP_CATEGORY	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_SIM_APPL_STATUS	Use (Insert,select)
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_RTVINFC	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.RB_RTVINFC	Rely On
RTVINFC	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RTVINFC	SQL Index	S10B80.FAISMGR	Rely On
RTVTREQ	SQL Table	S10B80.FAISMGR	Refer (no action)
RTVTRST	SQL Table	S10B80.FAISMGR	Refer (no action)
STVSBGI	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RTVINFC

Object Dates

Creation Date	Analysis Date
04/02/2008 10:28:24:000	04/02/2008 10:35:21:000

Source Code Comments

Source Code Validation Table

Columns Comments for RTVINFC_CODE (# 1)

Source Code Comments

INTERFACE CODE: The code identifying the source of the data.

Columns Comments for RTVINFC_DESC (# 2)

Source Code Comments

INTERFACE CODE DESCRIPTION: The description of the interface code.

Columns Comments for RTVINFC_ACTIVITY_DATE (# 3)

Source Code Comments

ACTIVITY DATE: The date that information for this record in the table was entered or last updated.

Columns Comments for RTVINFC_CTYP_CODE (# 4)

Source Code Comments

CONTACT TYPE CODE: Recruiting contact type code.

Columns Comments for RTVINFC_SBGI_CODE (# 5)

Source Code Comments

SOURCE/BACKGROUND INSTITUTION CODE: A code to identify the source of the recruitment contact.

Columns Comments for RTVINFC_TREQ_CODE (# 6)

Source Code Comments

TRACKING REQUIREMENT CODE: The tracking requirement code to be posted to the student's tracking record when a need analysis application is loaded.

Columns Comments for RTVINFC_TRST_CODE (# 7)

Source Code Comments

TRACKING REQUIREMENT STATUS CODE: The status code to be posted to the student's tracking record for the corresponding requirement code.

Columns Comments for RTVINFC_SYSTEM_REQ_IND (# 8)

Source Code Comments

SYSTEM REQUIRED INDICATOR: Y/N indicator. A (Y) in this field indicates that this is required data that was delivered by SCT and should not be removed or changed.

Columns Comments for RTVINFC_TREQ_CODE_SUPP (# 9)

Source Code Comments

SUPPLEMENTAL TRACKING REQUIREMENT CODE: Additional tracking requirement code to be posted to the student's tracking record when a record is loaded for this data source.

Columns Comments for RTVINFC_USER_ID (# 10)

Source Code Comments

USER ID: User ID of the User who created or last updated the record.

Table RTVLNST

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
RTVLNST_CODE	VARCHAR2(4)	No	*
RTVLNST_DESC	VARCHAR2(30)	No
RTVLNST_INACTIVE_IND	VARCHAR2(1)	No
RTVLNST_HOLD_IND	VARCHAR2(1)	No
RTVLNST_ACTIVITY_DATE	DATE	No
RTVLNST_VR_MSG_NO	NUMBER(6,0)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_RTVLNST	Unique	RTVLNST_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RPBLOPT	SQL Table	S10B80.FAISMGR	Refer (no action)
RPRLAPP	SQL Table	S10B80.FAISMGR	Refer (no action)
LOAN_DETAIL_TYPE	Oracle Package Type	S10B80.BANINST1.BWRKLHST	Rely On
RTVLNST_MSG_NO_TAB_TYPE	Oracle Package Type	S10B80.BANINST1.ROKTABS	Rely On
RTVLNST_TAB_TYPE	Oracle Package Type	S10B80.BANINST1.ROKTABS	Rely On
F_VAL_LOAN_ACTIVE	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION	Use (select)
GETLOANDTLC	Oracle Package Cursor	S10B80.BANINST1.BWRKLHST	Use (select)
RTVLNSTC	Oracle Package Cursor	S10B80.BANINST1.RTKLNST	Use (select)Rely On
RTVLNST_ROW_BY_CODE_C	Oracle Package Cursor	S10B80.BANINST1.RTKSELS	Rely On
RTVLNST_ROW_BY_CODE_C	Oracle Package Cursor	S10B80.BANINST1.RTKSELS	Use (select)Rely On
P_GET_RPRLAPP_ROWS	Oracle Package Procedure	S10B80.BANINST1.RPKFUNC	Rely On
P_PA_RTVLNST_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_VR_GET_LOAN_INFO	Oracle Package Procedure	S10B80.BANINST1.VRRKRLAP	Rely On
RTVLNST	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RTVLNST	SQL Index	S10B80.FAISMGR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RTVLNST

Object Dates

Creation Date	Analysis Date
04/02/2008 10:29:49:000	04/02/2008 10:35:22:000

Source Code Comments

Loan Status Validation Table

Columns Comments for RTVLNST_CODE (# 1)

Source Code Comments

LOAN STATUS CODE: This code identifies the various status that can be associated with a loan.

Columns Comments for RTVLNST_DESC (# 2)

Source Code Comments

LOAN STATUS DESCRIPTION: This field indicates the description of the loan status.

Columns Comments for RTVLNST_INACTIVE_IND (# 3)

Source Code Comments

INACTIVE INDICATOR: This field indicates whether the loan status means that the loan is inactive.

Columns Comments for RTVLNST_HOLD_IND (# 4)

Source Code Comments

HOLD INDICATOR: This indicator identifies whether the loan status means that the loan is being held for any reason.

Columns Comments for RTVLNST_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: This field maintains the date that the record was entered or last updated.

Columns Comments for RTVLNST_VR_MSG_NO (# 6)

Source Code Comments

The Voice Response message number assigned to the recorded message.

Table RTVPRCD

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
RTVPRCD_CODE	VARCHAR2(2)	No
RTVPRCD_DESC	VARCHAR2(30)	No
RTVPRCD_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

No Result

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RTVPRCDC	Oracle Package Cursor	S10B80.BANINST1.RTKPRCD	Use (select)Rely On
RTVPRCD	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RTVPRCD

Object Dates

Creation Date	Analysis Date
04/02/2008 10:29:56:000	04/02/2008 10:35:22:000

Source Code Comments

Program Code validation table for NSLDS

Table RTVRJCT

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
RTVRJCT_TYPE	VARCHAR2(1)	No	*
RTVRJCT_CODE	VARCHAR2(3)	No	*
RTVRJCT_ACTIVITY_DATE	DATE	No
RTVRJCT_DESC	VARCHAR2(65)	Yes
RTVRJCT_SYSTEM_REQ_IND	VARCHAR2(1)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_RTVRJCT	Unique	RTVRJCT_TYPE
PK_RTVRJCT	Unique	RTVRJCT_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RTVRJCTC	Oracle Package Cursor	S10B80.BANINST1.RTKRJCT	Use (select)Rely On
RTVRJCT_C	Oracle Package Cursor	S10B80.BANINST1.RB_RTVRJCT	Rely On
RTVRJCT_C	Oracle Package Cursor	S10B80.BANINST1.RB_RTVRJCT	Use (select)Rely On
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_RTVRJCT	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.RB_RTVRJCT	Rely On
RTVRJCT	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RTVRJCT	SQL Index	S10B80.FAISMGR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RTVRJCT

Object Dates

Creation Date	Analysis Date
04/02/2008 10:28:06:000	04/02/2008 10:35:21:000

Source Code Comments

Reject Validation Table

Columns Comments for RTVRJCT_TYPE (# 1)

Source Code Comments

REJECT CODE TYPE: The type associated with the reject. A (DL Pnote), B (DL Book), C (EL Appl/Chg), D (Disb), E(EDE), M (Memo), N (Pell), O (Pell Orig), P (Pell Disb), Q (Pell Batch), R(Pell Data Req), T(Transfer Monitor), X(DL Orig/Chg). Y(DL Disb).

Columns Comments for RTVRJCT_CODE (# 2)

Source Code Comments

REJECT CODE: This field maintains the Reject Code associated with the Reject Type.

Columns Comments for RTVRJCT_ACTIVITY_DATE (# 3)

Source Code Comments

ACTIVITY DATE: This field maintains the date that information in this record was entered or last updated.

Columns Comments for RTVRJCT_DESC (# 4)

Source Code Comments

REJECT CODE DESCRIPTION: This field maintains the description of the reject.

Table RTVRPSR

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
RTVRPSR_CODE	VARCHAR2(4)	No	*
RTVRPSR_DESC	VARCHAR2(30)	No
RTVRPSR_ACTIVITY_DATE	DATE	Yes
RTVRPSR_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_RTVRPSR	Unique	RTVRPSR_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RPRASTD	SQL Table	S10B80.FAISMGR	Refer (no action)
RTVRPSRC	Oracle Package Cursor	S10B80.BANINST1.RTKRPSR	Use (select)Rely On
RTVRPSR	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RTVRPSR	SQL Index	S10B80.FAISMGR	Rely On
RT_RTVRPSR_LOG_INSUPDDTL	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,delete,after,each row)
RT_RTVRPSR_USERACTIVIT_INSUPD	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,before,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RTVRPSR

Object Dates

Creation Date	Analysis Date
04/02/2008 10:26:26:000	04/02/2008 10:35:19:000

Source Code Comments

Repayment Source Validation Table

Columns Comments for RTVRPSR_CODE (# 1)

Source Code Comments

REPAYMENT SOURCE CODE: This field maintains the various source codes for repayment.

Columns Comments for RTVRPSR_DESC (# 2)

Source Code Comments

REPAYMENT SOURCE CODE DESCRIPTION: This field maintains the description of the repayment source code.

Columns Comments for RTVRPSR_ACTIVITY_DATE (# 3)

Source Code Comments

ACTIVITY DATE: This field maintains the date that information in this record was entered or last updated.

Columns Comments for RTVRPSR_USER_ID (# 4)

Source Code Comments

USER ID: The logon ID of the user who entered or last updated this row in this table.

Link between RPRLAPP and RTVINFC

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RPRLAPP and RTVINFC (FK1_RPRLAPP_INV_RTVINFC_CODE)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RPRLAPP	RPRLAPP_INFC_CODE	RTVINFC_CODE	RTVINFC	(0,1)-(0,n)

Link between RPRASTD and RTVCINT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RPRASTD and RTVCINT (FK1_RPRASTD_INV_RTVCINT_CODE)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RPRASTD	RPRASTD_CINT_CODE	RTVCINT_CODE	RTVCINT	(0,1)-(0,n)

Link between RPRASTD and RTVRPSR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RPRASTD and RTVRPSR (FK1_RPRASTD_INV_RTVRPSR_CODE)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RPRASTD	RPRASTD_RPSR_CODE	RTVRPSR_CODE	RTVRPSR	(0,1)-(0,n)

Link between RPRLCRT and RPRLAPP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RPRLCRT and RPRLAPP (FK1_RPRLCRT_INV_RPRLAPP_KEY)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RPRLCRT	RPRLCRT_PIDM	RPRLAPP_PIDM	RPRLAPP	(1,1)-(0,n)
RPRLCRT	RPRLCRT_FUND_CODE	RPRLAPP_FUND_CODE	RPRLAPP	(1,1)-(0,n)
RPRLCRT	RPRLCRT_APPL_NO	RPRLAPP_APPL_NO	RPRLAPP	(1,1)-(0,n)

Link between RPRLCRT and RTVCINT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RPRLCRT and RTVCINT (FK1_RPRLCRT_INV_RTVCINT_CODE)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RPRLCRT	RPRLCRT_CINT_CODE	RTVCINT_CODE	RTVCINT	(0,1)-(0,n)

Link between RPRLAPP and RTVLNST

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RPRLAPP and RTVLNST (FK1_RPRLAPP_INV_RTVLNST_CODE)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RPRLAPP	RPRLAPP_LNST_CODE	RTVLNST_CODE	RTVLNST	(1,1)-(0,n)

Link between RPBLOPT and RTVLNST

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RPBLOPT and RTVLNST (FK1_RPBLOPT_INV_RTVLNST_CODE)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RPBLOPT	RPBLOPT_LNST_CODE	RTVLNST_CODE	RTVLNST	(0,1)-(0,n)

Link between RPRLTRM and RPBLPRD

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RPRLTRM and RPBLPRD (FK1_RPRLTRM_INV_RPBLPRD_KEY)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RPRLTRM	RPRLTRM_LOAN_PERIOD	RPBLPRD_LOAN_PERIOD	RPBLPRD	(1,1)-(0,n)

Link between RPRLADB and RPRLAPP

Join Information

Objects list
schema-function : S10B80.BANINST1.F_EST_LOAN scope-function : S10B80.BANINST1.RPK_DISB_VALIDATION.F_GET_LOAN_DISB_DATA

Link List

Link Type	Link	Project
Join	Link Between RPRLADB and RPRLAPP	FAISMGR

List of Real links

Link type	Between	And
Join	RPRLADB	RPRLAPP

Link between RPRLAPP and RFRASPC

Join Information

Objects list
schema-function : S10B80.BANINST1.F_EST_LOAN

Link List

Link Type	Link	Project
Join	Link Between RPRLAPP and RFRASPC	FAISMGR

List of Real links

Link type	Between	And
Join	RPRLAPP	RFRASPC

Link between RPRLAPP and RPBLPRD

Join Information

Objects list

scope-cursor : S10B80.BANINST1.BWRKLHST.GETLOANDTLC
scope-function : S10B80.BANINST1.REKCE05.F_SELECT_DL_AWARDS
scope-function : S10B80.BANINST1.REKCE05.F_SELECT_DL_CHANGES
scope-function : S10B80.BANINST1.REKCE06.F_SELECT_DL_AWARDS
scope-function : S10B80.BANINST1.REKCE06.F_SELECT_DL_CHANGES
scope-function : S10B80.BANINST1.REKCE07.F_SELECT_DL_AWARDS
scope-function : S10B80.BANINST1.REKCE07.F_SELECT_DL_CHANGES
scope-function : S10B80.BANINST1.REKCE08.F_SELECT_DL_AWARDS
scope-function : S10B80.BANINST1.REKCE08.F_SELECT_DL_CHANGES
scope-function : S10B80.BANINST1.REKCE09.F_SELECT_DL_AWARDS
scope-function : S10B80.BANINST1.REKCE09.F_SELECT_DL_CHANGES

Link List

Link Type	Link	Project
Join	Link Between RPRLAPP and RPBLPRD	FAISMGR

List of Real links

Link type	Between	And
Join	RPRLAPP	RPBLPRD

Link between RPRLAPP and RFRBASE

Join Information

Objects list
scope-cursor : S10B80.BANINST1.BWRKLHST.GETLOANDTLC scope-cursor : S10B80.BANINST1.BWRKLHST.GETACTIVEAIDYEARC

Link List

Link Type	Link	Project
Join	Link Between RPRLAPP and RFRBASE	FAISMGR

List of Real links

Link type	Between	And
Join	RPRLAPP	RFRBASE

Link between RPRLAPP and RPRLATR

Join Information

Objects list
scope-procedure : S10B80.BANINST1.RPKLOAN.P_ADD_AWARD_REC scope-procedure : S10B80.BANINST1.RPKLOAN.P_ADD_AWARD_TERM_REC

Link List

Link Type	Link	Project
Join	Link Between RPRLAPP and RPRLATR	FAISMGR

List of Real links

Link type	Between	And
Join	RPRLAPP	RPRLATR

Link between RPBLOPT and RPRLATR

Join Information

Objects list
scope-procedure : S10B80.BANINST1.RPKLOAN.P_ADD_AWARD_REC scope-procedure : S10B80.BANINST1.RPKLOAN.P_ADD_AWARD_TERM_REC

Link List

Link Type	Link	Project
Join	Link Between RPBLOPT and RPRLATR	FAISMGR

List of Real links

Link type	Between	And
Join	RPBLOPT	RPRLATR

Link between RFRASPC and RFRBASE

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RFRASPC and RFRBASE (FK1_RFRASPC_INV_RFRBASE_KEY)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RFRASPC	RFRASPC_FUND_CODE	RFRBASE_FUND_CODE	RFRBASE	(1,1)-(0,n)