RETURN TO COMPOSITE VIEW REPORTS LIST
Financial Aid Composite View Reports

SGHE Operational Data Store
Composite View Target: AR_AWARD_DISBURSEMENT

Description Source composite view contains each disbursement for each applicant award for each fund for each 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(6)

RPRADSB

RPRADSB_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

AID_PERIOD_DESC Financial Aid period description. VARCHAR2(1)

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(4)

RPRADSB

RPRADSB_AIDY_CODE

AID_YEAR_DESC Financial aid year name. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

SYSDATE

DEBIT_CR_IND Debit/credit indicator for this disbursement. Indicates if the disbursement is positive or negative. VARCHAR2(1)

RPRADSB

RPRADSB_DEBIT_CR_IND

DISBURSED_AMT 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(11, 2)

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(6, 3)

RPRADSB

RPRADSB_DISBURSE_PCT

DISBURSEMENT_ID Disbursement identification number. VARCHAR2(1)

NA

NA

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

RPRADSB

RPRADSB_DISBURSE_LOAD

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

RPRADSB

RPRADSB_DISBURSE_LOAD_OPT

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

RPRADSB

RPRADSB_DISB_SEQ_NO

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

RPRADSB

RPRADSB_DOCUMENT_ID

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

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

RPRADSB

RPRADSB_FUND_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

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

NA

NA

NET_AMOUNT_DISBURSED Net amount of a particular disbursement as of the most recent extraction for reporting to cod. NUMBER(7, 2)

RPRADSB

RPRADSB_DISB_NET_AMT

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

RPRADSB

RPRADSB_DISB_BATCH_NO

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

RPRADSB

RPRADSB_PIDM

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

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 Name of the aid year associated with this record. 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(2)

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(2)

RPRADSB

RPRADSB_DISB_ACK_REF_NO

RFMS_UNSIGNED_DISBURSED_AMOUNT Amount of the disbursement, as acknowledged by RFMS. This will always be a positive amount. Negative payments are sent as a positive amount with a debit/credit indicator of n. NUMBER(7, 2)

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(7, 2)

RPRADSB

RPRADSB_YTD_AMT_PAID

SCHEDULED_AMT Scheduled amount of the disbursement associated with the fund. NUMBER(11, 2)

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(1)

NA

NA

SUB_ACADEMIC_PERIOD_DESC Sub academic period description. VARCHAR2(1)

NA

NA

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

RPRADSB

RPRADSB_TRAN_NUMBER

UNSIGNED_DISBURSED_AMOUNT Amount of the disbursement as sent to RFMS. This is always a positive amount. Negative payments are sent as a positive amount with a debit/credit indicator of n. NUMBER(7, 2)

RPRADSB

RPRADSB_DISB_AMT

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

NA

NA



Ver: 3.1