Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Financial Aid Reporting View Reports

Banner Operational Data Store
Reporting View Target: AWARD_DISBURSEMENT

Description Contains data regarding the award disbursements scheduled or posted for a person by financial aid fund and aid enrollment period. Details will include aid enrollment period, student academic period, accounts receivable academic period, disbursement ID, disbursed date, scheduled date, disbursed amount, scheduled amount, disbursed percentage and disbursement load. NOTE: the disbursement details do not currently include Loan Disbursement information.
Key & Frequency One row per person per aid year per disbursement ID or transaction number.
Recommended Search Columns PERSON_UID, AID_YEAR, FUND, AID_ENROLLMENT_PERIOD
AID_YEAR, FUND, AID_ENROLLMENT_PERIOD
PERSON_UID, AID_YEAR, FUND, ACADEMIC_PERIOD
AID_YEAR, FUND, ACADEMIC_PERIOD

Target Column Business Name Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic Period Academic period representing the accounts receivable term for disbursement. VARCHAR2(63)

RPRADSB

RPRADSB_TERM_CODE

ACADEMIC_PERIOD_DESC Academic Period Description Academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

ACCEPTED_PAY_PERIOD_START_DATE Accepted Pay Period Start Date Start date of the payment period the record is referencing, as acknowledged by COD. DATE

RPRADSB

RPRADSB_ACPT_PAY_PD_START_DATE

ACTIVITY_DATE Activity Date Date that information in this record was entered or last updated. DATE

RPRADSB

RPRADSB_ACTIVITY_DATE

ADMINISTRATIVE_GROUP Administrative Group Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

AID_ENROLLMENT_PERIOD Aid Enrollment Period Aid enrollment period associated with the award schedule. This period can span multiple student terms. VARCHAR2(63)

RPRADSB

RPRADSB_PERIOD

AID_ENROLLMENT_PERIOD_DESC Aid Enrollment Period Description Aid enrollment period description. VARCHAR2(255)

ROBPRDS

ROBPRDS_DESC

AID_PERIOD Aid Period Represents a financial aid period or portion of an aid year associated. Aid periods can be a single academic period or set of them as appropriate for tracking the aid awarded, accepted, paid, etc. VARCHAR2(63)

FUNCTION

MRKFUNC.F_GET_AID_PERIOD

AID_PERIOD_DESC Aid Period Description Financial Aid period description. VARCHAR2(255)

FUNCTION

MRKFUNC.F_GET_AID_PERIOD

AID_YEAR Aid Year Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation. VARCHAR2(63)

RPRADSB

RPRADSB_AIDY_CODE

AID_YEAR_DESC Aid Year Description Financial aid year name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ALTERNATE_PELL_PAY_SCHED_IND Alternate Pell Pay Sched Indicator Indicates whether Alternate Federal Pell Grant Schedules were used to calculate the disbursement amount on this record. Otherwise, Federal Pell Grant Program Regular Payment Schedules were used to calculate the disbursement amount. After the 2007-2008 aid year alternate pell is no longer used. VARCHAR2(1)

CALCULATION

DECODE(RPRADSB_ALTERNATE_PELL_IND,'N')

COD_CONCURRENT_ENROLLMENT_IND Cod Concurrent Enrollment Indicator Indicates that applicant has concurrent enrollment, and may require correction. VARCHAR2(1)

CALCULATION

DECODE(RPRADSB_CONCUR_ENROLL_FLAG)

COD_DEBIT_CREDIT Cod Debit Credit Debit/credit indicator for this disbursement, as acknowledged by COD. Indicates if the disbursement is positive (P) or negative (N). VARCHAR2(63)

RPRADSB

RPRADSB_DISB_ACPT_DEBIT_CR_IND

COD_DEBIT_CREDIT_DESC COD Debit Credit Description Description of the debit/credit indicators. VARCHAR2(255)

CALCULATION

DECODE(RPRADSB_DISB_ACPT_DEBIT_CR_IND)

COD_DISBURSED_DATE Cod Disbursed Date Date this disbursement is made as acknowledged by COD. DATE

RPRADSB

RPRADSB_DISB_ACPT_DATE

COD_DISBURSEMENT_ACTION Cod Disbursement Action COD processing status of the disbursement. A=accepted disbursement amount, C=corrected disbursement amount, E=rejected disbursement amount. VARCHAR2(63)

RPRADSB

RPRADSB_DISB_ACTION_CODE

COD_DISBURSEMENT_ACTION_DESC COD Disbursement Action Description Description of the COD processing status. VARCHAR2(255)

CALCULATION

DECODE(RPRADSB_DISB_ACTION_CODE)

COD_DISBURSEMENT_CROSS_REF Cod Disbursement Cross Reference Institution defined identifier used to identify student records internally. VARCHAR2(63)

RPRADSB

RPRADSB_INST_XREF

COD_DISBURSEMENT_DATE Cod Disbursement Date Actual date of disbursement of the payment or if not yet disbursed, the scheduled disbursement date. DATE

RPRADSB

RPRADSB_DISB_DATE

COD_DISBURSEMENT_LOCK_IND Cod Disbursement Lock Indicator Indicates that the disbursement record should not be resubmitted to COD. VARCHAR2(1)

CALCULATION

NVL(RPRADSB_DISB_LOCK_IND,'N')

COD_DISBURSEMENT_NUMBER Cod Disbursement Number Sequence number associated with the disbursement. Valid values are 01 - 99. NUMBER

RPRADSB

RPRADSB_ACPT_DISB_SEQ_NO

COD_DISBURSEMENT_SENT_DATE Cod Disbursement Sent Date Date the disbursement record was extracted for submission to COD. DATE

RPRADSB

RPRADSB_DISB_DATE_SENT

COD_DISB_EDIT_FIELD1 Cod Disb Edit Field 1 Field (XML tag) associated with edit 1. VARCHAR2(255)

RPRADSB

RPRADSB_EDIT_FIELD_1

COD_DISB_EDIT_FIELD2 Cod Disb Edit Field 2 Field (XML tag) associated with edit 2. VARCHAR2(255)

RPRADSB

RPRADSB_EDIT_FIELD_2

COD_DISB_EDIT_FIELD3 Cod Disb Edit Field 3 Field (XML tag) associated with edit 3. VARCHAR2(255)

RPRADSB

RPRADSB_EDIT_FIELD_3

COD_DISB_EDIT_FIELD4 Cod Disb Edit Field 4 Field (XML tag) associated with edit 4. VARCHAR2(255)

RPRADSB

RPRADSB_EDIT_FIELD_4

COD_DISB_EDIT_FIELD5 Cod Disb Edit Field 5 Field (XML tag) associated with edit 5. VARCHAR2(255)

RPRADSB

RPRADSB_EDIT_FIELD_5

COD_DISB_EDIT_REJECT_CODE1 Cod Disb Edit Rejection Code 1 Disbursement Edit/Reject/Comment code 1. VARCHAR2(63)

RPRADSB

RPRADSB_EDIT_REJ_01

COD_DISB_EDIT_REJECT_CODE10 Cod Disb Edit Rejection Code 10 Disbursement Edit/Reject/Comment code 10. VARCHAR2(63)

RPRADSB

RPRADSB_EDIT_REJ_10

COD_DISB_EDIT_REJECT_CODE2 Cod Disb Edit Rejection Code 2 Disbursement Edit/Reject/Comment code 2. VARCHAR2(63)

RPRADSB

RPRADSB_EDIT_REJ_02

COD_DISB_EDIT_REJECT_CODE3 Cod Disb Edit Rejection Code 3 Disbursement Edit/Reject/Comment code 3. VARCHAR2(63)

RPRADSB

RPRADSB_EDIT_REJ_03

COD_DISB_EDIT_REJECT_CODE4 Cod Disb Edit Rejection Code 4 Disbursement Edit/Reject/Comment code 4. VARCHAR2(63)

RPRADSB

RPRADSB_EDIT_REJ_04

COD_DISB_EDIT_REJECT_CODE5 Cod Disb Edit Rejection Code 5 Disbursement Edit/Reject/Comment code 5. VARCHAR2(63)

RPRADSB

RPRADSB_EDIT_REJ_05

COD_DISB_EDIT_REJECT_CODE6 Cod Disb Edit Rejection Code 6 Disbursement Edit/Reject/Comment code 6. VARCHAR2(63)

RPRADSB

RPRADSB_EDIT_REJ_06

COD_DISB_EDIT_REJECT_CODE7 Cod Disb Edit Rejection Code 7 Disbursement Edit/Reject/Comment code 7. VARCHAR2(63)

RPRADSB

RPRADSB_EDIT_REJ_07

COD_DISB_EDIT_REJECT_CODE8 Cod Disb Edit Rejection Code 8 Disbursement Edit/Reject/Comment code 8. VARCHAR2(63)

RPRADSB

RPRADSB_EDIT_REJ_08

COD_DISB_EDIT_REJECT_CODE9 Cod Disb Edit Rejection Code 9 Disbursement Edit/Reject/Comment code 9. VARCHAR2(63)

RPRADSB

RPRADSB_EDIT_REJ_09

COD_DISB_EDIT_REJECT_DESC1 Cod Disb Edit Rejection Description 1 Disbursement Edit Reject Code Description 1. VARCHAR2(255)

RTVRJCT

RTVRJCT_DESC

COD_DISB_EDIT_REJECT_DESC10 Cod Disb Edit Rejection Description 10 Disbursement Edit Reject Code Description 10. VARCHAR2(255)

RTVRJCT

RTVRJCT_DESC

COD_DISB_EDIT_REJECT_DESC2 Cod Disb Edit Rejection Description 2 Disbursement Edit Reject Code Description 2. VARCHAR2(255)

RTVRJCT

RTVRJCT_DESC

COD_DISB_EDIT_REJECT_DESC3 Cod Disb Edit Rejection Description 3 Disbursement Edit Reject Code Description 3. VARCHAR2(255)

RTVRJCT

RTVRJCT_DESC

COD_DISB_EDIT_REJECT_DESC4 Cod Disb Edit Rejection Description 4 Disbursement Edit Reject Code Description 4. VARCHAR2(255)

RTVRJCT

RTVRJCT_DESC

COD_DISB_EDIT_REJECT_DESC5 Cod Disb Edit Rejection Description 5 Disbursement Edit Reject Code Description 5. VARCHAR2(255)

RTVRJCT

RTVRJCT_DESC

COD_DISB_EDIT_REJECT_DESC6 Cod Disb Edit Rejection Description 6 Disbursement Edit Reject Code Description t 6. VARCHAR2(255)

RTVRJCT

RTVRJCT_DESC

COD_DISB_EDIT_REJECT_DESC7 Cod Disb Edit Rejection Description 7 Disbursement Edit Reject Code Description 7. VARCHAR2(255)

RTVRJCT

RTVRJCT_DESC

COD_DISB_EDIT_REJECT_DESC8 Cod Disb Edit Rejection Description 8 Disbursement Edit Reject Code Description 8. VARCHAR2(255)

RTVRJCT

RTVRJCT_DESC

COD_DISB_EDIT_REJECT_DESC9 Cod Disb Edit Rejection Description 9 Disbursement Edit Reject Code Description 9. VARCHAR2(255)

RTVRJCT

RTVRJCT_DESC

COD_DISB_EDIT_VALUE1 Cod Disb Edit Value 1 New value applied to response edit field 1 if a correction is applied. VARCHAR2(255)

RPRADSB

RPRADSB_EDIT_VALUE_1

COD_DISB_EDIT_VALUE2 Cod Disb Edit Value 2 New value applied to response edit field 2 if a correction is applied. VARCHAR2(255)

RPRADSB

RPRADSB_EDIT_VALUE_2

COD_DISB_EDIT_VALUE3 Cod Disb Edit Value 3 New value applied to response edit field 3 if a correction is applied. VARCHAR2(255)

RPRADSB

RPRADSB_EDIT_VALUE_3

COD_DISB_EDIT_VALUE4 Cod Disb Edit Value 4 New value applied to response edit field 4 if a correction is applied. VARCHAR2(255)

RPRADSB

RPRADSB_EDIT_VALUE_4

COD_DISB_EDIT_VALUE5 Cod Disb Edit Value 5 New value applied to response edit field 5 if a correction is applied. VARCHAR2(255)

RPRADSB

RPRADSB_EDIT_VALUE_5

COD_NET_AMOUNT_EXCLUSION_IND Cod Net Amount Exclusion Indicator Indicates that this locked record should not be included in the calculation of net amount for the disbursement. VARCHAR2(1)

CALCULATION

NVL(RPRADSB_EXCL_FROM_NET_AMT,'N')

COD_ORIGINATION_IDENTIFIER Cod Origination Identifier Origination ID from the origination process used to match data from the origination to acknowledgement and disbursement records. VARCHAR2(63)

RPRADSB

RPRADSB_ORIG_ID

COD_POTENTIAL_OVERPAYMENT_IND Cod Potential Overpayment Indicator Indicates that applicant has a potential overpayment, and may require correction. VARCHAR2(1)

CALCULATION

DECODE(RPRADSB_POTENTIAL_OVERPMT_FLAG)

COD_PREVIOUS_DISB_SEQUENCE_NO Cod Previous Disb Sequence Number Previous disbursement sequence number on the COD database for the disbursement number. NUMBER

RPRADSB

RPRADSB_ACPT_PREV_DISB_SEQ_NO

COD_REFERENCE_NUMBER Cod Reference Number Reference number (sequence number) of this disbursement sent back on acknowledgement from COD. If COD is generating the disbursement, 91 through 99 is used. NUMBER

RPRADSB

RPRADSB_DISB_ACK_REF_NO

COD_SHARED_SAR_IDENTIFIER_IND Cod Shared SAR Identifier Indicator Indicates that this student shares a SAR ID with another student, and requires correction. VARCHAR2(1)

CALCULATION

DECODE(RPRADSB_SHARED_SAR_ID_FLAG)

COD_UNSIGNED_DISBURSED_AMOUNT Cod Unsigned Disbursed Amount Amount of the disbursement, as acknowledged by COD. This always a positive amount. Negative payments will be sent as a positive amount with a debit/credit indicator of n. NUMBER

RPRADSB

RPRADSB_DISB_ACPT_AMT

COD_YTD_AMOUNT_PAID Cod Year to Date Amount Paid Year-to-date amount that has been disbursed to the student for this award year, as reported by COD. NUMBER

RPRADSB

RPRADSB_YTD_AMT_PAID

CPS_VERIFICATION_IND Cps Verification Indicator Indicates that the student was selected for verification but the school has not reported a valid verification status. VARCHAR2(1)

CALCULATION

NVL(RPRADSB_CPS_VER_IND,'N')

DEBIT_CREDIT Debit Credit Determines a debit or credit effect on the ledgers; plus or minus, debit or credit. VARCHAR2(63)

RPRADSB

RPRADSB_DEBIT_CR_IND

DEBIT_CREDIT_DESC Debit Credit Description Description of the debit/credit indicators. VARCHAR2(255)

CALCULATION

DECODE(RPRADSB_DEBIT_CREDIT_IND)

DISBURSED_AMOUNT Disbursed Amount Financial aid award sum disbursed for the time frame with a fund source type indicator equal to federal, and a fund type indicator equal to grant. NUMBER

RPRADSB

RPRADSB_DISBURSE_AMT

DISBURSED_DATE Disbursed Date Date the disbursed amount was taken from the financial aid fund indicated. DATE

RPRADSB

RPRADSB_DISBURSE_DATE

DISBURSED_PERCENTAGE Disbursed Percentage Percentage of the financial aid fund that has been disbursed. NUMBER

RPRADSB

RPRADSB_DISBURSE_PCT

DISBURSEMENT_CHANGE_DATE_IND Disbursement Change Date Ind Indicates whether this disbursement sequence is changing the Pell Advance Pay Reported Disbursement Date at COD to reflect the date paid in Banner. VARCHAR2(1)

RPRADSB

RPRADSB_DATE_CHANGE_IND

DISBURSEMENT_LOAD Disbursement Load Displays the enrollment credits of the student at the time of the disbursement. VARCHAR2(63)

RPRADSB

RPRADSB_DISBURSE_LOAD

DISBURSEMENT_LOAD_DESC Disbursement Load Description Disbursement load description. VARCHAR2(255)

CALCULATION

DECODE(RPRADSB_DISBURSE_LOAD)

DISBURSEMENT_LOAD_OPT Disbursement Load Opt Column to track disbursement enrollment option. VARCHAR2(63)

RPRADSB

RPRADSB_DISBURSE_LOAD_OPT

DISBURSEMENT_LOAD_OPT_DESC Disbursement Load Option Description Description of the disbursement enrollment option. VARCHAR2(255)

CALCULATION

DECODE(RPRADSB_DISBURSE_LOAD_OPT)

DISBURSEMENT_NUMBER Disbursement Number Reference number (sequence number) of this disbursement. NUMBER

RPRADSB

RPRADSB_DISB_SEQ_NO

DOCUMENT_ID Document ID Document number associated with the student's Pell disbursement record. VARCHAR2(63)

RPRADSB

RPRADSB_DOCUMENT_ID

ELIG_SCHEDULE_USED_PERCENT Eligible Schedule Used Percent Percent of student's eligibility used by the institution for the scheduled award in the aid year. NUMBER

RPRADSB

RPRADSB_PERCENT_ELIG_USED

ENROLLMENT_INSTITUTION Enrollment Institution Government code (OPEID and Branch Code) representing the institution where the student is physically enrolled for this disbursement. VARCHAR2(63)

RPRADSB

RPRADSB_ENROLLMENT_SCHOOL_CDE

ENROLLMENT_STATUS Enrollment Status The student's enrollment status for this disbursement. VARCHAR2(63)

RPRADSB

RPRADSB_ENROLLMENT_STATUS

ENROLLMENT_STATUS_DESC Enrollment Status Description Description of the student's enrollment status for this disbursement. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

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

RPRADSB

RPRADSB_FUND_CODE

FUND_TITLE Fund Title Full title of the financial aid fund code. VARCHAR2(255)

RFRBASE

RFRBASE_FUND_TITLE

HIGHEST_CPS_TRANSACTION_NO Highest Cps Transaction Number Returned in disbursement response files if CPS has a transaction number higher than the one reported by the school. VARCHAR2(2)

RPRADSB

RPRADSB_HIGHEST_CPS_TRAN_NO

ID ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

INSTITUTIONAL_LOAN_FEED_IND Institutional Loan Feed Indicator Represents that a Loan Management System feed transaction has been created for an institutional loan disbursement. VARCHAR2(1)

RPRADSB

RPRADSB_LMS_FEED_IND

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NAME Name Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NET_AMOUNT_DISBURSED Net Amount Disbursed Net amount of a particular disbursement as of the most recent extraction for reporting to cod. NUMBER

RPRADSB

RPRADSB_DISB_NET_AMT

PAYMENT_PERIOD_START_DATE Payment Period Start Date Start date of the payment period the record is referencing. DATE

RPRADSB

RPRADSB_PAY_PD_START_DATE

PELL_BATCH_NUMBER Pell Batch Number Batch number associated with the student's Pell disbursement record. VARCHAR2(63)

RPRADSB

RPRADSB_DISB_BATCH_NO

PELL_CALCULATED_DISB_AMOUNT Pell Calculated Disb Amount Calculated amount of the Pell award for the student, as a result of the disbursement process, before the disbursement options are considered. NUMBER

RPRADSB

RPRADSB_PELL_CALC_DISB_AMT

PELL_CALCULATED_DISB_LOAD Pell Calculated Disb Load Calculated enrollment load for the applicant's Pell award, as a result of the disbursement process, before the disbursement options are considered. VARCHAR2(63)

RPRADSB

RPRADSB_PELLC_DISB_LOAD

PELL_CALCULATED_DISB_LOAD_DESC Pell Calculated Disb Load Description Pell calculated disbursement load description. VARCHAR2(255)

CALCULATION

DECODE(RPRADSB_PELLC_DISB_LOAD)

PELL_CALC_DISB_LOAD_OPTION Pell Calculated Disbursement Load Option Source of the calculated enrollment load for the applicant's Pell award, as a result of the disbursement process, before the disbursement options are considered. VARCHAR2(63)

RPRADSB

RPRADSB_PELLC_DISB_LOAD_OPT

PELL_CALC_DISB_LOAD_OPT_DESC Pell Calculated Disb Load Option Description Description of the calculated enrollment load for the applicant's Pell award, as a result of the disbursement process, before the disbursement options are considered. VARCHAR2(255)

CALCULATION

DECODE(RPRADSB_PELLC_DISB_LOAD_OPT)

PELL_LIFETIME_ELIGIBILITY_USED Pell Lifetime Eligibility Used Lifetime eligibility amount used for Pell grants. NUMBER

RPRADSB

RPRADSB_PELL_LEU

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

RPRADSB

RPRADSB_PIDM

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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

RPRADSB

RPRADSB_CIP_CODE

PROGRAM_CLASSIFICATION_DESC Program Classification Description Description of the classification of instructional program code associated with the student's major at the time of disbursement as is validated during disbursement for SMART Grants. VARCHAR2(255)

FUNCTION

F_GET_CIPC_DESC

REFERENCE_NUMBER Reference Number Reference number (sequence number) of this disbursement. NUMBER

RPRADSB

RPRADSB_DISB_REF_NO

SCHEDULED_AMOUNT Scheduled Amount Scheduled amount of the disbursement associated with the fund. NUMBER

FUNCTION

NVL(RPRADSB_SCHEDULE_AMT,ROKODSF.F_GET_RPRADSB_SCHEDULE_AMT

SCHEDULED_DATE Scheduled Date Date the disbursement was scheduled. DATE

RPRADSB

RPRADSB_SCHEDULE_DATE

STUDENT_ACADEMIC_PERIOD Student Academic Period Academic period representing the term to pull the student data used for the aid enrollment period. As an example, student classification, or student. VARCHAR2(63)

RORPRDS

RORPRDS_TERM_CODE

STUDENT_ACADEMIC_PERIOD_DESC Academic Period Description Academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

TOTAL_DISBURSED_AMOUNT Total Disbursed Amount Displays the amount actually disbursed for this fund. NUMBER

RPRADSB

RPRADSB_DISBURSE_AMT

TRANSACTION_NUMBER Transaction Number Transaction number on the student's account receivable detail. NUMBER

RPRADSB

RPRADSB_TRAN_NUMBER

UNSIGNED_DISBURSED_AMOUNT Unsigned Disbursed Amount Amount of the disbursement as sent to RFMS. This always a positive amount. Negative payments will be sent as a positive amount with a debit/credit indicator of n. NUMBER

RPRADSB

RPRADSB_DISB_AMT

USER_ID User ID Unique ID of the user who inserted or last updated this record. VARCHAR2(63)

RPRADSB

RPRADSB_USER_ID

VERIFICATION_CORRECTION_IND Verification Correction Indicator Indicates that this student has a verification W (Without Documentation) status, and requires correction and is for Pell only. VARCHAR2(1)

RPRADSB

RPRADSB_VERIF_W_STATUS_FLAG



Ver: 9.2