Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Financial Aid Composite View Reports

Banner Operational Data Store
Composite View Target: AR_LOAN_DISBURSEMENT

Description The Loan Disbursement by Academic Period contains detail data for loan disbursements that were made within the term. Details may include person and person address; loan fund code and description; loan period and description; loan application number; term recommended, expected and approved loan amount; loan status code; term disbursement date, sequence number, reference number, check number and amount; feed indicator; disbursement load; loan fee amounts; and disbursement rejects and edit fields.
Key & Frequency One row per person per academic period per fund per application number per disbursement date per disbursement.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ACADEMIC_PERIOD Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year. VARCHAR2(6)

RPRLADB

RPRLADB_TERM_CODE

NO

NO
ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(30)

STVTERM

STVTERM_DESC

NO

NO
ACTIVITY_DATE Date record was inserted or updated. DATE

RPRLADB

RPRLADB_ACTIVITY_DATE

NO

NO
AID_ENROLLMENT_PERIOD   VARCHAR2(15)       NO
AID_YEAR Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation. VARCHAR2(6)

RPRLADB

RPRLADB_AIDY_CODE

NO

NO
AID_YEAR_DESC Description of the aid year. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
APPLICATION_NUMBER System assigned number is assigned when the application is added. NUMBER

RPRLADB

RPRLADB_APPL_NO

NO

NO
APPROVED_AMOUNT The approved loan amount for this particular academic period. NUMBER

RPRLATR

RPRLATR_APPROVE_AMT

NO

NO
BORROWER_DIRECT_CHECK_AMOUNT Direct disbursement amount received by borrower enrolled in a study-abroad program. NUMBER

RPRLADB

RPRLADB_EL_DIRECT_CHECK_AMT

NO

NO
BORROWER_DIRECT_DISBURSE_IND Requests the direct disbursement of funds to borrower or to indicate receipt of funds for borrowers enrolled in a study-abroad program. VARCHAR2(1)

RPRLADB

RPRLADB_EL_BOR_DIRECT_DISB_IND

NO

NO
CALC_EXPECTED_DISBURSEMENT_AMT For Electronic and Manual Loans, the calculated net amount of the disbursement using the Round Schedule indicator from the Fund Management form and is based on the approved amount if it exists, else the certified (expected) amount if it exists, else the requested amount. The last disbursement of the loan is adjusted so the sum of all the disbursements equals the total amount for the loan. For Direct Loans, the net amount of the disbursement based on the gross disbursement amount, the fee and rebate percent for the loan. NUMBER

FUNCTION

ROKODSF.F_GET_CALC_DISBURSE_AMT

NO

NO
CANCEL_DATE Displays the date the cancel indicator field was checked to cancel a pending disbursement. DATE

RPRLADB

RPRLADB_CANCEL_DATE

NO

NO
CANCEL_IND Check to cancel a pending disbursement or uncheck to reinstate the disbursement amount. VARCHAR2(1)

RPRLADB

RPRLADB_CANCEL_IND

NO

NO
CERTIFIED_CREDIT_HOURS Displays the loan application credit hours for loan eligibility. NUMBER

RPRLATR

RPRLATR_CERT_HR

NO

NO
CHECK_DATE_RECEIVED Indicates the date the check amount was received. DATE

RPRLADB

RPRLADB_CHECK_DATE

NO

NO
CHECK_RETURNED_LENDER_DATE The date that the original unsigned/unprocessed loan check was returned to the lender by the school. DATE

RPRLADB

RPRLADB_RET_LNDR_DATE

NO

NO
CHECK_RETURN_AMOUNT Amount of the loan that was returned during an adjustment. NUMBER

RPRLADB

RPRLADB_CHECK_RETURN_AMT

NO

NO
CHECK_RETURN_DATE The date that the adjusted loan amount was returned. DATE

RPRLADB

RPRLADB_CHECK_RETURN_DATE

NO

NO
COLLEGE First level of the institution organization structure that owns the student or the academic instruction for a student course. VARCHAR2(6)

RPRLADB

RPRLADB_SCHOOL_CODE

NO

NO
CONFIRMATION_IND 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. VARCHAR2(1)

RPRLADB

RPRLADB_AFFIRM_FLAG

NO

NO
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

NO
DIRECT_DISBURSEMENT_NUMBER Direct loan disbursement number. NUMBER

RPRLADB

RPRLADB_DL_DISB_NO

NO

NO
DIRECT_LOAN_BATCH_NUMBER Batch number related to the disbursement acknowledgement file for this individual disbursement. VARCHAR2(23)

RPRLADB

RPRLADB_BATCH_NO

NO

NO
DIRECT_LOAN_COD_ADJUSTED_NET The net disbursement adjustment amount recorded in the Account Statement with COD. The value in this field may be either positive or negative reflecting the net amount of the adjustment processed for this individual disbursement. NUMBER

RPRLADB

RPRLADB_SERV_NET_ADJ_AMT

NO

NO
DIRECT_LOAN_COD_BOOK_DATE Date the individual disbursement is booked at COD. DATE

RPRLADB

RPRLADB_SERV_BOOKED_DATE

NO

NO
DIRECT_LOAN_COD_GROSS_AMOUNT The gross amount recorded in the Account Statement with COD. NUMBER

RPRLADB

RPRLADB_SERV_GROSS_AMT

NO

NO
DIRECT_LOAN_COD_NET_AMOUNT The net disbursement amount recorded in the Account Statement with COD. NUMBER

RPRLADB

RPRLADB_SERV_NET_AMT

NO

NO
DIRECT_LOAN_COD_REBATE_AMOUNT The rebate Amount recorded in the Account Statement with COD. NUMBER

RPRLADB

RPRLADB_SERV_REBATE_AMT

NO

NO
DIRECT_LOAN_COD_RECEIPT_DATE The actual date COD acknowledged receipt of this disbursement record. DATE

RPRLADB

RPRLADB_DL_ACKN_DATE

NO

NO
DIRECT_LOAN_DOCUMENT_ID Associated with the student's Direct Loan award record and indicates the document in which the origination record was initially extracted and sent to COD. VARCHAR2(30)

RPRLADB

RPRLADB_DOCUMENT_ID

NO

NO
DIRECT_LOAN_FEE_AMOUNT Amount of Direct Loan fees. NUMBER

RPRLADB

RPRLADB_DL_FEE_AMT

NO

NO
DIRECT_LOAN_GROSS_AMOUNT Gross Amount of Direct Loan disbursement . NUMBER

RPRLADB

RPRLADB_DL_GROSS_AMT

NO

NO
DIRECT_LOAN_MONTH_END_DATE The month end date of the Direct Loan School Account Statement for the month in which this loan disbursement booked. DATE

RPRLADB

RPRLADB_SAS_END_DATE

NO

NO
DIRECT_LOAN_MONTH_PROCESS_DATE The month process date of the Direct Loan School Account Statement for the month in which this loan disbursement booked. DATE

RPRLADB

RPRLADB_SAS_PROCESS_DATE

NO

NO
DIRECT_LOAN_REBATE_AMOUNT The Direct Loan interest rebate amount calculated for this disbursement. NUMBER

RPRLADB

RPRLADB_DL_REBATE_AMT

NO

NO
DIRECT_LOAN_RECORD_COUNT_NO The record number assigned in the School Account Statement with COD for this loan detail record. NUMBER

RPRLADB

RPRLADB_SAS_RECORD_COUNT_SEQ

NO

NO
DIRECT_LOAN_REJECT_CODE1 The first reject code sent from LOC / COD for this loan disbursement. VARCHAR2(3)

RPRLADB

RPRLADB_DL_REJECT_CODE_1

NO

NO
DIRECT_LOAN_REJECT_CODE1_DESC Description for the first reject code sent from LOC / COD. VARCHAR2(65)

RTVRJCT

RTVRJCT_DESC

NO

NO
DIRECT_LOAN_REJECT_CODE2 The second reject code sent from LOC / COD for this loan disbursement. VARCHAR2(3)

RPRLADB

RPRLADB_DL_REJECT_CODE_2

NO

NO
DIRECT_LOAN_REJECT_CODE2_DESC Description for the second reject code sent from LOC / COD. VARCHAR2(65)

RTVRJCT

RTVRJCT_DESC

NO

NO
DIRECT_LOAN_REJECT_CODE3 The third reject code sent from LOC / COD for this loan disbursement. VARCHAR2(3)

RPRLADB

RPRLADB_DL_REJECT_CODE_3

NO

NO
DIRECT_LOAN_REJECT_CODE3_DESC Description for the third reject code sent from LOC / COD. VARCHAR2(65)

RTVRJCT

RTVRJCT_DESC

NO

NO
DIRECT_LOAN_REJECT_CODE4 The fourth reject code sent from LOC / COD for this loan disbursement. VARCHAR2(3)

RPRLADB

RPRLADB_DL_REJECT_CODE_4

NO

NO
DIRECT_LOAN_REJECT_CODE4_DESC Description for the fourth reject code sent from LOC / COD. VARCHAR2(65)

RTVRJCT

RTVRJCT_DESC

NO

NO
DIRECT_LOAN_REJECT_CODE5 The fifth reject code sent from LOC / COD for this loan disbursement. VARCHAR2(3)

RPRLADB

RPRLADB_DL_REJECT_CODE_5

NO

NO
DIRECT_LOAN_REJECT_CODE5_DESC Description for the fifth reject code sent from LOC / COD. VARCHAR2(65)

RTVRJCT

RTVRJCT_DESC

NO

NO
DIRECT_LOAN_SEQUENCE_NUMBER Starts at one for each scheduled loan disbursement, and is incremented by one each time an adjustment is made to the disbursement. NUMBER

RPRLADB

RPRLADB_DL_SEQ_NO

NO

NO
DIRECT_LOAN_SERVICE_FEE_AMOUNT The fees amount recorded in the Account Statement with COD. NUMBER

RPRLADB

RPRLADB_SERV_FEE_AMT

NO

NO
DISBURSEMENT_BYPASS_IND Indicates lender transactions are to be bypassed for a payment during disbursement. VARCHAR2(1)

RPRLADB

RPRLADB_DISB_BYPASS

NO

NO
DISBURSEMENT_COMMENT Contains any special processing comments or instructions entered by the user. VARCHAR2(60)

RPRLADB

RPRLADB_COMMENT

NO

NO
DISBURSEMENT_FEED Displays whether disbursement should be fed to accounts receivable. VARCHAR2(1)

RPRLADB

RPRLADB_FEED_IND

NO

NO
DISBURSEMENT_FEED_DATE Indicates the date the disbursement was fed to the student's account's receivable account. DATE

RPRLADB

RPRLADB_FEED_DATE

NO

NO
DISBURSEMENT_FEED_DESC Indicates whether disbursement should be fed to accounts receivable. VARCHAR2(10)

CALCULATION

DECODE(RPRLADB_FEED_IND)

NO

NO
DISBURSEMENT_PROCESSING_STATUS The processing status of the disbursement. VARCHAR2(1)

RPRLADB

RPRLADB_DISB_STATUS

NO

NO
DISBURSEMENT_PROC_STATUS_DESC Disbursement processing status description. VARCHAR2(25)       NO
DISBURSEMENT_SEQUENCE_NUMBER Starts at one for each scheduled loan disbursement, and is incremented by one each time an adjustment is made to the disbursement. NUMBER

RPRLADB

RPRLADB_SEQ_NO

NO

NO
DOMAIN_VALUE Domain column for future use, not currently populated. VARCHAR2(6)

NA

NA

NO

NO
ELECTRONIC_DISBURSEMENT_NUMBER Disbursement number associated with this electronic loan disbursement record. NUMBER

RPRLADB

RPRLADB_EL_DISB_NO

NO

NO
ELECTRONIC_REFERENCE_ID The check number or electronic batch number of the financial aid payment. VARCHAR2(15)

RPRLADB

RPRLADB_REF_ID

NO

NO
ELECTRONIC_SERVICE_NET_AMOUNT The net disbursement amount that has been scheduled by the lender-servicer at the time of guarantee for this disbursement. This amount is uploaded from the CommonLine Response File. NUMBER

RPRLADB

RPRLADB_EL_SERV_NET_AMT

NO

NO
ELECTRONIC_TRANSFER_IND Indicates when an electronic disbursement is received, rather than a paper check. VARCHAR2(1)

RPRLADB

RPRLADB_EFT_IND

NO

NO
ENROLLMENT_LOAD Displays the student's enrollment load calculated at the time of disbursement. VARCHAR2(1)

RPRLADB

RPRLADB_DISBURSE_LOAD

NO

NO
ENROLLMENT_LOAD_DESC Enrollment Load Description. VARCHAR2(20)

CALCULATION

DECODE(RPRLADB_DISBURSE_LOAD)

NO

NO
ENROLLMENT_LOAD_OPTION Financial Aid calculates a student's enrollment option used for the disbursement load. VARCHAR2(1)

RPRLADB

RPRLADB_DISBURSE_LOAD_OPT

NO

NO
ENROLLMENT_LOAD_OPTION_DESC Displays the enrollment load option used for the disbursement. VARCHAR2(15)       NO
ENROLLMENT_STATUS Student's enrollment status. VARCHAR2(1)

RPRLADB

RPRLADB_ENROLLMENT_STATUS

NO

NO
ENROLLMENT_STATUS_DESC Enrollment status description. VARCHAR2(120)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
EXCLUDE_EXCEPTION_REPORT_IND Indicates that the exception report should not display a line for this loan and term, even if there was a discrepancy in the amounts. VARCHAR2(1)

CALCULATION

NVL(RPRLATR_EXCLUDE_LNEX_FLAG,'N')

NO

NO
EXPECTED_LOAN_AMOUNT Expected loan amount associated with the application scheduled by academic periods. NUMBER

RPRLATR

RPRLATR_EXPECT_AMT

NO

NO
FUND Financial Aid Fund code to be associated with information in this record. VARCHAR2(6)

RPRLADB

RPRLADB_FUND_CODE

NO

NO
FUND_TITLE Full title of the financial aid fund code. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
GUARANTEE_FEE_AMOUNT Amount of the guarantee fee charged for this disbursement. NUMBER

RPRLADB

RPRLADB_EL_SERV_GUAR_FEE

NO

NO
HOLD_RELEASE_DATE The most recent date the Hold / Release status was sent or acknowledged. DATE

RPRLADB

RPRLADB_EL_HOLD_REL_DATE

NO

NO
HOLD_RELEASE_STATUS A code indicating the status of the school's requested disbursement hold or release. VARCHAR2(2)

RPRLADB

RPRLADB_HOLD_REL_STATUS

NO

NO
HOLD_RELEASE_STATUS_DESC Hold / Release status description. VARCHAR2(20)

CALCULATION

DECODE(RPRLADB_HOLD_REL_STATUS)

NO

NO
LOAN_PERCENTAGE_ACAD_PERIOD Represents the percentage of the loan that is scheduled for the associated academic period. NUMBER

RPRLATR

RPRLATR_LOAN_PCT

NO

NO
LOAN_PERCENTAGE_DISBURSEMENT The percentage of total loan that this disbursement represents. NUMBER

RPRLADB

RPRLADB_LOAN_PCT

NO

NO
MEMO_EXPIRATION_DAYS The number of days until the memo expires. NUMBER

RPRLADB

RPRLADB_MEMO_EXP_DAYS

NO

NO
MIF_DESC The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(30)

NA

NA

NO

NO
MIF_VALUE The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(6)

NA

NA

NO

NO
MPN_DISBURSEMENT_DATE Disbursement Date printed on the Promissory Note. No longer required for MPN processing. DATE

RPRLADB

RPRLADB_PN_DISB_DATE

NO

NO
NET_CHECK_AMOUNT The net amount of this particular disbursement. NUMBER

RPRLADB

RPRLADB_CHECK_AMT

NO

NO
ORIGINATION_FEE_AMOUNT Amount of the origination fee charged for this disbursement. NUMBER

RPRLADB

RPRLADB_EL_SERV_ORIG_FEE

NO

NO
OVERRIDE_IND 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. VARCHAR2(1)

RPRLADB

RPRLADB_DISB_OVERRIDE_IND

NO

NO
PAYMENT_PERIOD_START_DATE Disbursement payment period start date. DATE

RPRLADB

RPRLADB_PAY_PD_START_DATE

NO

NO
PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

RPRLADB

RPRLADB_PIDM

NO

NO
PREVIOUS_DISBURSEMENT_NUMBER The previous disbursement sequence number on the COD database for the disbursement number. NUMBER

RPRLADB

RPRLADB_PREV_DISB_SEQ_NO

NO

NO
PRIOR_DISBURSEMENT_DATE 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. DATE

RPRLADB

RPRLADB_PRIOR_DISB_DATE

NO

NO
PROGRAM_CLASSIFICATION Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting. VARCHAR2(20)

RPRLADB

RPRLADB_CIP_CODE

NO

NO
PROGRAM_CLASSIFICATION_DESC Program classification description. VARCHAR2(260)

FUNCTION

ROKODSF.F_GET_CIPC_DESC

NO

NO
PROGRAM_SEQUENCE_LOCK_IND Indicates if the student program information sequence is locked for the loan disbursement record. VARCHAR2(1)

RLRDLDD

RLRDLDD_SPGM_LOCK_IND

NO

NO
PROGRAM_SEQUENCE_NUMBER Sequence of the program information record used on this disbursement. NUMBER

RLRDLDD

RLRDLDD_SPGM_SEQ_NO

NO

NO
RECOMMENDED_AMOUNT Recommended amount of the loan associated with the loan application scheduled by academic period. NUMBER

RPRLATR

RPRLATR_RECOMMEND_AMT

NO

NO
RECONCILIATION_BATCH_NUMBER Cash reconciliation batch number in which this direct loan disbursement was included. VARCHAR2(23)

RPRLADB

RPRLADB_RECON_BATCH_NO

NO

NO
REQUESTED_AMOUNT Amount of requested loan for this particular academic period. NUMBER

RPRLATR

RPRLATR_REQUEST_AMT

NO

NO
REVISED_GROSS_AMOUNT The revised gross disbursement amount for this EL disbursement record. NUMBER

RPRLADB

RPRLADB_EL_REV_GROSS_AMT

NO

NO
REVISED_NET_AMOUNT The revised disbursement amount excluding all fees retained by the lender (i.e. net amount). NUMBER

RPRLADB

RPRLADB_REV_DISB_AMT

NO

NO
SCHEDULED_DATE Used by the disbursement process as the first date on which this disbursement may occur. DATE

RPRLADB

RPRLADB_DISBURSE_DATE

NO

NO
SERVICER_DISBURSEMENT_DATE The disbursement date scheduled by the guarantor/servicer for this disbursement. DATE

RPRLADB

RPRLADB_EL_SERV_DISB_DATE

NO

NO
SERVICER_DISBURSEMENT_GROSS The amount guaranteed by the guarantor/servicer for this disbursement including all applicable fees and minus any cancellations. NUMBER

RPRLADB

RPRLADB_EL_SERV_GROSS_AMT

NO

NO
STUDENT_ACADEMIC_PERIOD   VARCHAR2(6)       NO
STUDENT_ACADEMIC_PERIOD_DESC   VARCHAR2(30)       NO
STUDENT_RECEIVE_DATE The date the loan proceeds were delivered to the student. DATE

RPRLADB

RPRLADB_STU_RECEIVE_DATE

NO

NO
SUBSIDIZED_FEES_PAID Total amount of fees subsidized by the guarantor or lender on behalf of the borrower for the disbursement. NUMBER

RPRLADB

RPRLADB_FEES_PAID

NO

NO
TRANSACTION_NUMBER Displays the number on the student's account's receivable account where the disbursement was applied. NUMBER

RPRLADB

RPRLADB_TRAN_NUMBER

NO

NO
TRANSACTION_TYPE This is the type of transaction record found for the disbursement. VARCHAR2(1)

RPRLADB

RPRLADB_SERV_TRANS_TYPE

NO

NO
TRANSACTION_TYPE_DESC Transaction record description. VARCHAR2(25)

CALCULATION

DECODE(RPRLADB_SERV_TRANS_TYPE)

NO

NO
USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(30)

RPRLADB

RPRLADB_USER_ID

NO

NO
ZONE_VALUE Zone column for future use, not currently populated. VARCHAR2(6)

NA

NA

NO

NO


Ver: