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_DETAIL

Description Source composite view contains loan disbursement details

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ACADEMIC_YEAR_END_DATE The date on which the student's academic year ends for this origination. DATE

RLRDLOR

RLRDLOR_ACAD_YR_END_DATE

NO

NO
ACADEMIC_YEAR_START_DATE The date on which the student's academic year starts for this origination. DATE

RLRDLOR

RLRDLOR_ACAD_YR_START_DATE

NO

NO
ACTIVITY_DATE The date that information in this record was entered or last updated. DATE

RLRDLOR

RLRDLOR_ACTIVITY_DATE

NO

NO
ADDL_UNSUBSIDIZED_ELIG_IND Indicates whether this dependent student is eligible for additional unsubsidized loan due to a Parent PLUS denial. VARCHAR2(1)

RLRDLOR

RLRDLOR_ADDL_UNSUB_ELIG_IND

NO

NO
AID_YEAR The aid year to be associated with the information in this record. VARCHAR2(4)

RLRDLOR

RLRDLOR_AIDY_CODE

NO

NO
AID_YEAR_DESC The description of the valid aid year. VARCHAR2(4)

ROBINST

ROBINST_AIDY_DESC

NO

NO
BORROWER_BASED_ACADEMIC_YEAR The Borrower-Based Academic Year associated with this record. VARCHAR2(15)

RLRDLOR

RLRDLOR_BBAY_CODE

NO

NO
BORROWER_BASED_ACAD_YEAR_DESC Borrower-Based Academic Year type description. VARCHAR2(30)

ROBBBAY

ROBBBAY_DESC

NO

NO
CREATE_DATE The date the loan application was created. DATE

RLRDLOR

RLRDLOR_CREATE_DATE

NO

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

NA

NA

NO

NO
DEFAULT_DESC Description of the default code. VARCHAR2(240)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
DEFAULT_IND Indicates whether the student is in default on a Title IV loan as reported by NSLDS. VARCHAR2(1)

RLRDLOR

RLRDLOR_IN_DEFAULT

NO

NO
DEPENDENCY_STATUS Indicates if the student is (I)ndependent or (D)ependent. VARCHAR2(1)

RLRDLOR

RLRDLOR_DEPENDENCY_STATUS

NO

NO
DEPENDENCY_STATUS_DESC Dependency status description. VARCHAR2(240)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
DIRECT_LOAN_COD_ADJUSTED_NET Actual net adjustment amount for this disbursement as calculated by COD. NUMBER

RLRDDAS

RLRDDAS_NET_ADJ_AMT

NO

NO
DIRECT_LOAN_COD_BOOK_DATE The date the loan was booked at COD. DATE

RLRDDAS

RLRDDAS_DISB_BOOKED_DATE

NO

NO
DIRECT_LOAN_COD_GROSS_AMOUNT Actual gross amount for this disbursement as calculated by COD. NUMBER

RLRDDAS

RLRDDAS_GROSS_AMT

NO

NO
DIRECT_LOAN_COD_NET_AMOUNT Actual net amount for this disbursement as calculated by COD. NUMBER

RLRDDAS

RLRDDAS_NET_AMT

NO

NO
DIRECT_LOAN_COD_REBATE_AMOUNT Actual rebate amount for this disbursement as calculated by COD. NUMBER

RLRDDAS

RLRDDAS_REBATE_AMT

NO

NO
DIRECT_LOAN_ID A system generated field constructed from the SSN, loan type, loan year, Direct Loan school code, and loan sequence number. VARCHAR2(21)

RLRDLOR

RLRDLOR_LOAN_ID

NO

NO
DIRECT_LOAN_MONTH_END_DATE The end date for this statement of account. DATE

RLRDDAS

RLRDDAS_SAS_END_DATE

NO

NO
DIRECT_LOAN_MONTH_PROCESS_DATE The date this SAS report was processed by COD. DATE

RLRDDAS

RLRDDAS_SAS_PROCESS_DATE

NO

NO
DIRECT_LOAN_MONTH_START_DATE The start date for this statement of account. Only received in On-Demand requested SAS files. DATE

RLRDDAS

RLRDDAS_SAS_START_DATE

NO

NO
DIRECT_LOAN_SCHOOL_CODE The Department of Education's Direct Loan school code to be used for loan processing for the attending institution. VARCHAR2(6)

RLRDLOR

RLRDLOR_SCHOOL_CODE

NO

NO
DIRECT_LOAN_SERVICE_FEE_AMOUNT Actual fee amount for this disbursement as calculated by COD. NUMBER

RLRDDAS

RLRDDAS_FEE_AMT

NO

NO
DISBURSEMENT_DATA_ORIGIN Source system that created or updated the data. VARCHAR2(30)

RLRDLOR

RLRDLOR_DATA_ORIGIN

NO

NO
DISBURSEMENT_NUMBER The Direct Loan Disbursement Number for the disbursement. NUMBER

RLRDDAS

RLRDDAS_DISB_NO

NO

NO
DISBURSEMENT_SEQUENCE_NUMBER The sequence for the disbursement record. NUMBER

RLRDDAS

RLRDDAS_DISB_SEQ_NO

NO

NO
DISCLOSURE_NEED_PRINT_FLAG This field indicates a request to have COD print or reprint the disclosure statement. VARCHAR2(1)

RLRDLOR

RLRDLOR_DISC_PRINT_FLAG

NO

NO
DISCLOSURE_REQUIRED_IND_DESC Disclosure required indicator description. VARCHAR2(120)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
DL_SENT_DATE The date that the Direct Loan origination record was sent to COD. DATE

RLRDLOR

RLRDLOR_DATE_SENT

NO

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

NA

NA

NO

NO
ENTRANCE_COUNSELING_IND Indicates whether the borrower has completed entrance counseling for this loan type. VARCHAR2(1)

RLRDLOR

RLRDLOR_ENTRANCE_IND

NO

NO
FUND The fund code associated with the loan application. VARCHAR2(6)

RLRDLOR

RLRDLOR_FUND_CODE

NO

NO
FUND_TITLE This field identifies the full title of the fund code. VARCHAR2(30)

RFRBASE

RFRBASE_FUND_TITLE

NO

NO
HPPA_IND Indicates whether this student qualifies for additional Unsubsidized loans up to the HPPA limits. VARCHAR2(1)

RLRDLOR

RLRDLOR_HPPA_IND

NO

NO
LOAN_AMOUNT The loan amount for the origination. NUMBER

RLRDLOR

RLRDLOR_LOAN_AMT

NO

NO
LOAN_APPLICATION_NUMBER A system generated loan number for the student. NUMBER

RLRDLOR

RLRDLOR_LOAN_NO

NO

NO
LOAN_BOOK_DATE The date the disbursement booked at COD. DATE

RLRDDAS

RLRDDAS_LOAN_BOOKED_DATE

NO

NO
LOAN_FEE_PERCENT The percentage of the loan that will be subtracted from the loan proceed for origination fees. NUMBER

RLRDLOR

RLRDLOR_FEE_PCT

NO

NO
LOAN_PERIOD_END_DATE The end date of the loan award based on the period awards contained within the loan. DATE

RLRDLOR

RLRDLOR_AWARD_END_DATE

NO

NO
LOAN_PERIOD_START_DATE The start date of the loan award based on the period awards contained within the loan. DATE

RLRDLOR

RLRDLOR_AWARD_START_DATE

NO

NO
LOAN_SERVICER Name of the Direct Loan servicer for this loan. VARCHAR2(30)

RLRDDAS

RLRDDAS_SERVICER

NO

NO
LOAN_STATUS The code used to identify the current status of the loan in processing. VARCHAR2(4)

RLRDLOR

RLRDLOR_LNST_CODE

NO

NO
LOAN_STATUS_DESC The description of the loan status. VARCHAR2(30)

RTVLNST

RTVLNST_DESC

NO

NO
LOAN_TYPE The loan type for the record. VARCHAR2(1)

RLRDLOR

RLRDLOR_LOAN_TYPE

NO

NO
LOAN_TYPE_DESC Loan type description. VARCHAR2(4000)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
LOCK_INDICATOR Indicates whether the loan has been locked. VARCHAR2(1)

RLRDLOR

RLRDLOR_LOCK_IND

NO

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

NA

NA

NO

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

NA

NA

NO

NO
MPN_ID The ID printed on the Master Promissory Note associated with this loan. VARCHAR2(21)

RLRDLOR

RLRDLOR_MPN_ID

NO

NO
MPN_LINKED_IND COD's acknowledgement that this origination is linked to the MPN ID at COD VARCHAR2(1)

RLRDLOR

RLRDLOR_MPN_LINKED_IND

NO

NO
ORIGINATION_DOCUMENT_ID The document identification number for the document in which the loan's initial origination was sent to COD. VARCHAR2(30)

RLRDLOR

RLRDLOR_DOCUMENT_ID

NO

NO
ORIGINATION_STATUS The current status of the origination. VARCHAR2(1)

RLRDLOR

RLRDLOR_STATUS

NO

NO
ORIGINATION_STATUS_DESC Origination status description. VARCHAR2(120)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

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

RLRDLOR

RLRDLOR_PIDM

NO

NO
PREP_TEACH_CERTIFICATION_DESC Preparation or teacher certification coursework description. VARCHAR2(120)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
PREP_TEACH_CERTIFICATION_IND 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 professional program, or due to coursework necessary for teacher certification. VARCHAR2(1)

RLRDLOR

RLRDLOR_PREP_OR_TEACH_IND

NO

NO
PROCESS_DATE The date that the origination was processed by COD and the response returned to the school. DATE

RLRDLOR

RLRDLOR_PROCESS_DATE

NO

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

RLRDLOR

RLRDLOR_SPGM_LOCK_IND

NO

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

RLRDLOR

RLRDLOR_SPGM_SEQ_NO

NO

NO
REBATE_FEE_PERCENT Rebate fee percent. NUMBER

RLRDLOR

RLRDLOR_REBATE_PCT

NO

NO
RECONCILIATION_BATCH_NUMBER The batch number for the statement of account in which this record was received. VARCHAR2(23)

RLRDDAS

RLRDDAS_SAS_BATCH_NO

NO

NO
RECORD_COUNT_SEQUENCE The record number assigned in the School Account Statement for this record. NUMBER

RLRDDAS

RLRDDAS_SAS_RECORD_COUNT_SEQ

NO

NO
RECORD_SOURCE Indicates if record is sourced from Banner or COD VARCHAR2(6)

CALCULATION

CASE WHEN RLRDDAS_DISB_SEQ_NO

NO

NO
SAR_TRANSACTION_NUMBER The eligible SAR transaction number that was reported with the origination record. VARCHAR2(2)

RLRDLOR

RLRDLOR_SAR_TRAN_NO

NO

NO
SAS_REGION The two digit region code of the school received in the statement of account file. VARCHAR2(2)

RLRDDAS

RLRDDAS_REGION_CDE

NO

NO
SAS_STATE_PROVINCE Two character state code of the school received in the statement of account file. VARCHAR2(2)

RLRDDAS

RLRDDAS_SCHOOL_STAT_CODE

NO

NO
SAS_STATE_PROVINCE_DESC State or province name. VARCHAR2(30)

STVSTAT

STVSTAT_DESC

NO

NO
SCHEDULED_ACADEMIC_YEAR The Scheduled Academic Year associated with this record. VARCHAR2(15)

RLRDLOR

RLRDLOR_SAYR_CODE

NO

NO
SCHEDULED_ACADEMIC_YEAR_DESC Scheduled Academic Year description. VARCHAR2(30)

RTVSAYR

RTVSAYR_DESC

NO

NO
SURROGATE_ID The surrogate id for this record. NUMBER

RLRDLOR

RLRDLOR_SURROGATE_ID

NO

NO
TOTAL_FEE_AMOUNT The sum of actual fee amounts for the loan as calculated by COD. NUMBER

RLRDDAS

RLRDDAS_TOTAL_FEE_AMT

NO

NO
TOTAL_GROSS_AMOUNT The sum of actual gross amounts for the loan as calculated by COD. NUMBER

RLRDDAS

RLRDDAS_TOTAL_GROSS_AMT

NO

NO
TOTAL_NET_AMOUNT The sum of actual net amounts for the loan as calculated by COD. NUMBER

RLRDDAS

RLRDDAS_TOTAL_NET_AMT

NO

NO
TOTAL_REBATE_AMOUNT The sum of actual rebate amounts for the loan as calculated by COD. NUMBER

RLRDDAS

RLRDDAS_TOTAL_REBATE_AMT

NO

NO
TRANSACTION_DATE The date disbursement activity occurred at the school. DATE

RLRDDAS

RLRDDAS_TRANSACTION_DATE

NO

NO
TRANSACTION_TYPE Disbursement activity type recorded at COD. VARCHAR2(1)

RLRDDAS

RLRDDAS_TRANS_TYPE

NO

NO
TRANSACTION_TYPE_DESC Transaction record description. VARCHAR2(120)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
USER_ID The user ID of the person who inserted or last updated this record. VARCHAR2(30)

RLRDLOR

RLRDLOR_USER_ID

NO

NO
YEAR_IN_COLLEGE The student's year in college for this origination record. VARCHAR2(1)

RLRDLOR

RLRDLOR_YR_IN_COLL

NO

NO
YEAR_IN_COLLEGE_DESC The student's year in college for this origination record. VARCHAR2(120)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

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

NA

NA

NO

NO


Ver: