RETURN TO REPORTING VIEW REPORTS LIST
Financial Aid Reporting View Reports

SGHE 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 academic period. Details will include 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,┐ACADEMIC_PERIOD

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic period associated with the disbursement information in this record. VARCHAR2(63)

RPRADSB

RPRADSB_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

AID_PERIOD Identifies parts of a year that students may be enrolled and receive financial assistance. For example, full year, academic period, etc. VARCHAR2(63)

NA

NA

AID_PERIOD_DESC Financial Aid period description. VARCHAR2(255)

NA

NA

AID_YEAR Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005). VARCHAR2(63)

RPRADSB

RPRADSB_AIDY_CODE

AID_YEAR_DESC Financial aid year name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DEBIT_CREDIT_IND Determines a debit or credit effect on the ledgers; plus or minus, debit or credit. VARCHAR2(1)

RPRADSB

RPRADSB_DEBIT_CR_IND

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

FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

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

RPRADSB

RPRADSB_DISBURSE_DATE

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

RPRADSB

RPRADSB_DISBURSE_PCT

DISBURSEMENT_ID Disbursement identification number. VARCHAR2(255)

NA

NA

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

RPRADSB

RPRADSB_DISBURSE_LOAD

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

RPRADSB

RPRADSB_DISBURSE_LOAD_OPT

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

RPRADSB

RPRADSB_DISB_SEQ_NO

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

RPRADSB

RPRADSB_DOCUMENT_ID

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

RPRADSB

RPRADSB_FUND_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

ID Person's or organization's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

NA

NA

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

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

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

RPRADSB

RPRADSB_DISB_BATCH_NO

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

RPRADSB

RPRADSB_PIDM

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

NA

NA

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

RPRADSB

RPRADSB_DISB_REF_NO

RFMS_DEBIT_CREDIT_IND Debit/credit indicator for this disbursement, as acknowledged by RFMS. Indicates if the disbursement is positive (P) or negative (N). VARCHAR2(1)

RPRADSB

RPRADSB_DISB_ACPT_DEBIT_CR_IND

RFMS_DISBURSED_DATE Date this disbursement is made as acknowledged by RFMS. DATE

RPRADSB

RPRADSB_DISB_ACPT_DATE

RFMS_DISBURSEMENT_ACTION RFMS processing status of the disbursement. A=accepted disbursement amount, C=corrected disbursement amount, E=rejected disbursement amount. VARCHAR2(1)

RPRADSB

RPRADSB_DISB_ACTION_CODE

RFMS_DISBURSEMENT_NUMBER Sequence number associated with the disbursement. Valid values are 01 - 99. NUMBER

RPRADSB

RPRADSB_ACPT_DISB_SEQ_NO

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

RPRADSB

RPRADSB_DISB_ACK_REF_NO

RFMS_UNSIGNED_DISBURSED_AMOUNT Amount of the disbursement, as acknowledged by 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_ACPT_AMT

RFMS_YTD_AMOUNT_PAID Year-to-date amount that has been disbursed to the student for this award year, as reported by RFMS. NUMBER

RPRADSB

RPRADSB_YTD_AMT_PAID

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

RPRADSB

RPRADSB_SCHEDULE_AMT

SCHEDULED_DATE Date the disbursement was scheduled. DATE

RPRADSB

RPRADSB_SCHEDULE_DATE

SUB_ACADEMIC_PERIOD A session, portion or part of the academic period. VARCHAR2(63)

NA

NA

SUB_ACADEMIC_PERIOD_DESC Sub academic period description. VARCHAR2(255)

NA

NA

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

RPRADSB

RPRADSB_TRAN_NUMBER

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



Ver: 3.1