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

SGHE Banner Operational Data Store
Reporting View Target: LOAN_DISBURSEMENT

Description The Loan Disbursement by aid enrollment period contains detail data for loan disbursements that were made within the aid enrollment period. Details may include person and person address; loan fund code and description; loan period and description; loan application number; aid enrollment period, accounts receivable term recommended, student academic period, 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 aid enrollment period per fund per application number per disbursement date per disbursement.
Recommended Search Columns PERSON_UID, FUND, APPLICATION_NUMBER, AID_ENROLLMENT_PERIOD, SCHEDULED_DATE, DISBURSEMENT_SEQUENCE_NUMBER
PERSON_UID, AID_ENROLLMENT_PERIOD, FUND, APPLICATION_NUMBER
PERSON_UID, FUND, APPLICATION_NUMBER, ACADEMIC_PERIOD, SCHEDULED_DATE, DISBURSEMENT_SEQUENCE_NUMBER
AID_YEAR, FUND

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

RLRDLDD

RPRLADB

RLRDLDD_AR_TERM_CODE

RPRLADB_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

ACTIVITY_DATE Date record was inserted or updated. DATE

RLRDLDD

RPRLADB

RLRDLDD_ACTIVITY_DATE

RPRLADB_ACTIVITY_DATE

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 associated with the award schedule. This period can span multiple student terms. VARCHAR2(63)

RLRDLDD

RPRLADB

RLRDLDD_PERIOD

RPRLADB_PERIOD

AID_ENROLLMENT_PERIOD_DESC Aid enrollment period description. VARCHAR2(255)

ROBPRDS

ROBPRDS_DESC

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

FUNCTION

RLRDLDD

RPRLADB

ROKODSF.F_GET_FINAID_PROC_YEAR

RLRDLDD_AIDY_CODE

RPRLADB_AIDY_CODE

AID_YEAR_DESC Aid year description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

RLRDLDD

RPRLADB

RLRDLDD_LOAN_NO

RPRLADB_APPL_NO

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

RPRDLPS

RPRLATR

RPRDLPS_LOAN_AMT

RPRLATR_APPROVE_AMT

AUTHORIZED_IND Indicates whether disbursement is authorized for payment by the disbursement process. VARCHAR2(1)

RLRDLDD

RPRLADB

RLRDLDD_AUTHORIZED_IND

RPRLADB_DL_AUTHORIZED_IND

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

NA

RPRLADB

NULL

RPRLADB_EL_DIRECT_CHECK_AMT

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)

NA

RPRLADB

NULL

RPRLADB_EL_BOR_DIRECT_DISB_IND

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

RLRDLDD

ROKODSF.F_GET_CALC_DISBURSE_AMT

RLRDLDD_NET_AMOUNT

CANCEL_DATE Displays the date the cancel indicator field was checked to cancel a pending disbursement. No longer used after Financial Aid release 8.22.1. DATE

NA

RPRLADB

NULL

RPRLADB_CANCEL_DATE

CANCEL_IND Check to cancel a pending disbursement or uncheck to reinstate the disbursement amount. No longer used after Financial Aid release 8.22.1. VARCHAR2(1)

RPRLADB

RPRLADB_CANCEL_IND

CERTIFIED_CREDIT_HOURS Displays the loan application credit hours for loan eligibility. No longer used. NUMBER

NA

RPRLATR

NULL

RPRLATR_CERT_HR

CHECK_DATE_RECEIVED Indicates the date the check amount was received. No longer used after Financial Aid release 8.22.1. DATE

RPRLADB

RPRLADB_CHECK_DATE

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

NA

RPRLADB

NULL

RPRLADB_RET_LNDR_DATE

CHECK_RETURN_AMOUNT Amount of the loan that was returned during an adjustment. No longer used after Financial Aid release 8.22.1. NUMBER

RPRLADB

RPRLADB_CHECK_RETURN_AMT

CHECK_RETURN_DATE The date that the adjusted loan amount was returned. No longer used after Financial Aid release 8.22.1. DATE

RPRLADB

RPRLADB_CHECK_RETURN_DATE

CITY Address city, town or municipality. VARCHAR2(63)

RERCODA

RPRLAPP

RERCODA_CITY

RPRLAPP_CITY

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

RLRDDAS

RPRLADB

RLRDDAS_SCHOOL_CODE

RPRLADB_SCHOOL_CODE

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. No longer used after Financial Aid release 8.22.1. VARCHAR2(1)

RPRLADB

RPRLADB_AFFIRM_FLAG

DEFAULT_IND Loan default status. VARCHAR2(63)

RLRDLOR

RPRLAPP

RLRDLOR_IN_DEFAULT

RPRLAPP_IN_DEFAULT

DEFAULT_IND_DESC Description of the loan default status. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

DIRECT_DISBURSEMENT_NUMBER Direct loan disbursement number. NUMBER

RLRDLDD

RPRLADB

RLRDLDD_DISB_NO

RPRLADB_DL_DISB_NO

DIRECT_LOAN_BATCH_NUMBER Batch number related to the disbursement acknowledgement file for this individual disbursement. No longer used after Financial Aid release 8.22.1. VARCHAR2(63)

NA

RPRLADB

NULL

RPRLADB_BATCH_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

RLRDDAS

RPRLADB

RLRDDAS_NET_ADJ_AMT

RPRLADB_SERV_NET_ADJ_AMT

DIRECT_LOAN_COD_BOOK_DATE Date the individual disbursement is booked at COD. DATE

RLRDDAS

RPRLADB

RLRDDAS_DISB_BOOKED_DATE

RPRLADB_SERV_BOOKED_DATE

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

RLRDDAS

RPRLADB

RLRDDAS_GROSS_AMT

RPRLADB_SERV_GROSS_AMT

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

RLRDDAS

RPRLADB

RLRDDAS_NET_AMT

RPRLADB_SERV_NET_AMT

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

RLRDDAS

RPRLADB

RLRDDAS_REBATE_AMT

RPRLADB_SERV_REBATE_AMT

DIRECT_LOAN_COD_RECEIPT_DATE The actual date COD acknowledged receipt of this disbursement record. No longer used after Financial Aid release 8.22.1. DATE

NA

RPRLADB

NULL

RPRLADB_DL_ACKN_DATE

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

RLRDLDD

RPRLADB

RLRDLDD_DOCUMENT_ID

RPRLADB_DOCUMENT_ID

DIRECT_LOAN_FEE_AMOUNT Amount of Direct Loan fees. NUMBER

RLRDLDD

RPRLADB

RLRDLDD_FEE_AMT

RPRLADB_DL_FEE_AMT

DIRECT_LOAN_GROSS_AMOUNT Gross Amount of Direct Loan disbursement . NUMBER

RLRDLDD

RPRLADB

RLRDLDD_GROSS_AMT

RPRLADB_DL_GROSS_AMT

DIRECT_LOAN_ID Identifies a specific loan application. VARCHAR2(63)

RLRDLOR

RPRLAPP

RLRDLOR_LOAN_ID

RPRLAPP_DL_LOAN_ID

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

RLRDDAS

RPRLADB

RLRDDAS_SAS_END_DATE

RPRLADB_SAS_END_DATE

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

RLRDDAS

RPRLADB

RLRDDAS_SAS_PROCESS_DATE

RPRLADB_SAS_PROCESS_DATE

DIRECT_LOAN_MONTH_START_DATE Start date of the school account statement for which this loan disbursement booked. DATE

RLRDDAS

RPRLADB

RLRDDAS_SAS_START_DATE

RPRLADB_SAS_START_DATE

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

RLRDLDD

RPRLADB

RLRDLDD_REBATE_AMT

RPRLADB_DL_REBATE_AMT

DIRECT_LOAN_RECORD_COUNT_NO Record number assigned in the School Account Statement with COD for this loan detail record. No longer used after Financial Aid release 8.22.1. NUMBER

RPRLADB

RPRLADB_SAS_RECORD_COUNT_SEQ

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

RERCDED

RPRLADB

RERCDED_RJCT_CODE

RPRLADB_DL_REJECT_CODE_1

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

RTVRJCT

RTVRJCT_DESC

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

RERCDED

RPRLADB

RERCDED_RJCT_CODE

RPRLADB_DL_REJECT_CODE_2

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

RTVRJCT

RTVRJCT_DESC

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

RERCDED

RPRLADB

RERCDED_RJCT_CODE

RPRLADB_DL_REJECT_CODE_3

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

RTVRJCT

RTVRJCT_DESC

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

RERCDED

RPRLADB

RERCDED_RJCT_CODE

RPRLADB_DL_REJECT_CODE_4

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

RTVRJCT

RTVRJCT_DESC

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

RERCDED

RPRLADB

RERCDED_RJCT_CODE

RPRLADB_DL_REJECT_CODE_5

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

RTVRJCT

RTVRJCT_DESC

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. No longer used after Financial Aid release 8.22.1. NUMBER

NA

RPRLADB

NULL

RPRLADB_DL_SEQ_NO

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

RLRDDAS

RPRLADB

RLRDDAS_FEE_AMT

RPRLADB_SERV_FEE_AMT

DISBURSEMENT_BYPASS_IND Indicates lender transactions are to be bypassed for a payment during disbursement. No longer used after Financial Aid release 8.22.1. VARCHAR2(1)

RPRLADB

RPRLADB_DISB_BYPASS

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

RLRDLDD

RPRLADB

RLRDLDD_COMMENT

RPRLADB_COMMENT

DISBURSEMENT_DATA_ORIGIN Source system that last created or updated the data. VARCHAR2(63)

RLRDLDD

RPRLADB

RLRDLDD_DATA_ORIGIN

RPRLADB_DATA_ORIGIN

DISBURSEMENT_DAYS_OFFSET Number of days prior to or after the first class start date of the student to schedule the disbursement. NUMBER

NA

RLRDLDD

NULL

RLRDLDD_DISB_SCHED_NO_DAYS

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

RLRDLDD

RPRLADB

RLRDLDD_FEED_IND

RPRLADB_FEED_IND

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

RLRDLDD

RPRLADB

RLRDLDD_FEED_DATE

RPRLADB_FEED_DATE

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

CALCULATION

CALCULATION

DECODE(RLRDLDD_FEED_IND)

DECODE(RPRLADB_FEED_IND)

DISBURSEMENT_PROCESSING_STATUS The processing status of the disbursement. VARCHAR2(63)

RLRDLDD

RPRLADB

RLRDLDD_DISB_STATUS

RPRLADB_DISB_STATUS

DISBURSEMENT_PROC_STATUS_DESC Disbursement processing status description. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

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

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

NA

RPRLADB

NULL

RPRLADB_EL_DISB_NO

ELECTRONIC_REFERENCE_ID The check number or electronic batch number of the financial aid payment. No longer used after Financial Aid release 8.22.1. VARCHAR2(63)

NA

RPRLADB

NULL

RPRLADB_REF_ID

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

NA

RPRLADB

NULL

RPRLADB_EL_SERV_NET_AMT

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

NA

RPRLADB

NULL

RPRLADB_EFT_IND

EL_LOAN_ID Loan identification number used by electronic loan processing (common line). VARCHAR2(63)

NA

RPRLAPP

NULL

RPRLAPP_EL_LOAN_ID

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

RLRDLDD

RPRLADB

RLRDLDD_LOAD

RPRLADB_DISBURSE_LOAD

ENROLLMENT_LOAD_DESC Enrollment Load Description. VARCHAR2(255)

CALCULATION

CALCULATION

DECODE(RLRDLDD_LOAD)

DECODE(RPRLADB_DISBURSE_LOAD)

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

RLRDLDD

RPRLADB

RLRDLDD_LOAD_OPT

RPRLADB_DISBURSE_LOAD_OPT

ENROLLMENT_LOAD_OPTION_DESC Displays the enrollment load option used for the disbursement. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

ENROLLMENT_SCHOOL_CODE 8 digit OPEID and Branch Code where the student is physically enrolled for this loan disbursement. VARCHAR2(63)

RLRDLDD

RPRLADB

RLRDLDD_ENROLLMENT_SCHOOL_CDE

RPRLADB_ENROLLMENT_SCHOOL_CDE

ENROLLMENT_STATUS Student's enrollment status. VARCHAR2(63)

RLRDLDD

RPRLADB

RLRDLDD_ENROLLMENT_STATUS

RPRLADB_ENROLLMENT_STATUS

ENROLLMENT_STATUS_DESC Enrollment status description. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

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. No longer used after Financial Aid release 8.22.1. VARCHAR2(1)

RPRLATR

RPRLATR_EXCLUDE_LNEX_FLAG

EXPECTED_LOAN_AMOUNT Expected loan amount associated with the application scheduled by academic periods. No longer used after Financial Aid release 8.22.1. NUMBER

NA

RPRLATR

NULL

RPRLATR_EXPECT_AMT

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

RLRDLDD

RPRLADB

RLRDLDD_FUND_CODE

RPRLADB_FUND_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

NA

RPRLADB

NULL

RPRLADB_EL_SERV_GUAR_FEE

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

NA

RPRLADB

NULL

RPRLADB_EL_HOLD_REL_DATE

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

NA

RPRLADB

NULL

RPRLADB_HOLD_REL_STATUS

HOLD_RELEASE_STATUS_DESC Hold / Release status description. VARCHAR2(255)

CALCULATION

NA

DECODE(RPRLADB_HOLD_REL_STATUS)

NULL

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

LOAN_BOOK_DATE Date the loan is booked at COD. DATE

NA

RLRDDAS

NULL

RLRDDAS_LOAN_BOOKED_DATE

LOAN_NUMBER System generated loan number for the student. NUMBER

RLRDLDD

RPRLADB

RLRDLDD_LOAN_NO

RPRLADB_APPL_NO

LOAN_PERCENTAGE_ACAD_PERIOD Represents the percentage of the loan that is scheduled for the associated academic period. No longer used after Financial Aid release 8.22.1. NUMBER

RPRLATR

RPRLATR_LOAN_PCT

LOAN_PERCENTAGE_DISBURSEMENT The percentage of total loan that this disbursement represents. No longer used after Financial Aid release 8.22.1. NUMBER

RPRLADB

RPRLADB_LOAN_PCT

LOAN_PERIOD Period covered by the loan. No longer used after Financial Aid release 8.22.1. VARCHAR2(63)

NA

RPRLAPP

NULL

RPRLAPP_LOAN_PERIOD

LOAN_PERIOD_DESC Loan period description. No longer used after Financial Aid release 8.22.1. VARCHAR2(255)

NA

RPBLPRD

NULL

RPBLPRD_DESC

LOAN_SERVICER Loan servicer name. VARCHAR2(255)

RLRDDAS

RPRLADB

RLRDDAS_SERVICER

RPRLADB_SERVICER

LOAN_SOURCE Identifies the fund's packaging rule source as either a direct loan, electronic loan, manual loan or other type of loan. VARCHAR2(63)

CALCULATION

CASE WHEN RFRASPC_DIRECT_LOAN_IND

LOAN_SOURCE_DESC Loan source description. VARCHAR2(255)

CALCULATION

CASE WHEN RFRASPC_DIRECT_LOAN_IND

LOAN_STATUS Status of the common line application process for this record. VARCHAR2(63)

RLRDLOR

RPRLAPP

RLRDLOR_LNST_CODE

RPRLAPP_LNST_CODE

LOAN_STATUS_DESC Common line process status description. VARCHAR2(255)

RTVLNST

RTVLNST_DESC

MEMO_EXPIRATION_DAYS The number of days until the memo expires. No longer used after Financial Aid release 8.22.1. NUMBER

RPRLADB

RPRLADB_MEMO_EXP_DAYS

MPN_DISBURSEMENT_DATE Disbursement Date printed on the Promissory Note. No longer required for MPN processing. No longer used after Financial Aid release 8.22.1. DATE

NA

RPRLADB

NULL

RPRLADB_PN_DISB_DATE

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

NA

NA

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

NA

NA

NAME Name of the person (LFMI). VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NET_CHECK_AMOUNT The net amount of this particular disbursement. NUMBER

RLRDLDD

RPRLADB

RLRDLDD_NET_AMT

RPRLADB_CHECK_AMT

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

NA

RPRLADB

NULL

RPRLADB_EL_SERV_ORIG_FEE

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. No longer used after Financial Aid release 8.22.1. VARCHAR2(1)

RPRLADB

RPRLADB_DISB_OVERRIDE_IND

PARENT_CITY City of the parent when a direct loan is of a parent type. VARCHAR2(63)

RLRDBOR

RPRLAPP

RLRDBOR_PERM_CITY

RPRLAPP_PAR_CITY

PARENT_PHONE_NUMBER_COMBINED Phone number of the parent when a direct loan is of a parent type. VARCHAR2(63)

RLRDBOR

RPRLAPP

RLRDBOR_PHONE_NO

RPRLAPP_PAR_PHONE_NO

PARENT_POSTAL_CODE Postal code of the parent when a direct loan is of a parent type. VARCHAR2(63)

RLRDBOR

RPRLAPP

RLRDBOR_PERM_ZIP

RPRLAPP_PAR_ZIP

PARENT_STATE_PROVINCE State/province of the parent when a direct loan is of a parent type. VARCHAR2(63)

RLRDBOR

RPRLAPP

RLRDBOR_PERM_CDST_CODE

RPRLAPP_PAR_STATE

PARENT_STATE_PROVINCE_DESC Name of the state/province of the parent when a direct loan is of a parent type. VARCHAR2(255)

FUNCTION

STVSTAT

GOKODSF.F_GET_DESC

STVSTAT_DESC

PARENT_STREET_LINE1 Address of the parent when a direct loan is of a parent type. VARCHAR2(255)

RLRDBOR

RPRLAPP

RLRDBOR_PERM_ADDRESS

RPRLAPP_PAR_ADDRESS

PARENT_STREET_LINE2 Second line of parent's permanent street address. VARCHAR2(255)

RLRDBOR

RPRLAPP

RLRDBOR_PERM_ADDR_LINE2

RPRLAPP_PAR_ADDR_LINE2

PARENT_STREET_LINE3 Third line of parent's permanent street address. VARCHAR2(255)

RLRDBOR

RPRLAPP

RLRDBOR_PERM_ADDR_LINE3

RPRLAPP_PAR_ADDR_LINE3

PARENT_STREET_LINE4 Fourth line of parent's permanent street address. VARCHAR2(255)

NA

NULL

PAYMENT_PERIOD_START_DATE Disbursement payment period start date. DATE

RLRDLDD

RPRLADB

RLRDLDD_PAY_PD_START_DATE

RPRLADB_PAY_PD_START_DATE

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

RLRDLDD

RPRLADB

RLRDLDD_PIDM

RPRLADB_PIDM

PHONE_NUMBER_COMBINED All recorded pieces of the telephone number combined in a single field. International code, area code, number, extension. VARCHAR2(63)

RERCODS

RPRLAPP

RERCODS_PHONE_NO

RPRLAPP_PHONE_NO

POSTAL_CODE Postal code in the address of the borrower of a direct loan. VARCHAR2(63)

RERCODA

RPRLAPP

RERCODA_ZIP

RPRLAPP_ZIP

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

RLRDLDD

RPRLADB

RLRDLDD_PREV_DISB_SEQ_NO

RPRLADB_PREV_DISB_SEQ_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

NA

RPRLADB

NULL

RPRLADB_PRIOR_DISB_DATE

PROCESS_GROUP The institution value of the process-oriented identifier for the record used to determine access authorization to this record. VARCHAR2(255)

NA

NA

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

RLRDBOR

RPRLADB

RLRDLDD_CIP_CODE

RPRLADB_CIP_CODE

PROGRAM_CLASSIFICATION_DESC Program classification description. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_CIPC_DESC

RECOMMENDED_AMOUNT Recommended amount of the loan associated with the loan application scheduled by academic period. No longer used after Financial Aid release 8.22.1. NUMBER

NA

RPRLATR

NULL

RPRLATR_RECOMMEND_AMT

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

RLRDDAS

RPRLADB

RLRDDAS_SAS_BATCH_NO

RPRLADB_RECON_BATCH_NO

REPORTED_DATE Disbursement date reported to COD as of this sequence. DATE

RLRDLDD

RPRLADB

RLRDLDD_REPORTED_DATE

RPRLADB_REPT_DISB_DATE

REQUESTED_AMOUNT Amount of requested loan for this particular academic period. No longer used after Financial Aid release 8.22.1. NUMBER

NA

RPRLATR

NULL

RPRLATR_REQUEST_AMT

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

FUNCTION

NA

MGKFUNC.F_GET_PERSON_INFO

NULL

RETURN_NAME Name of the person (LFMI) or organization. VARCHAR2(255)

FUNCTION

NA

MGKFUNC.F_GET_PERSON_INFO

NULL

RETURN_UID Loan ID of the Guarantor or Lender. NUMBER

NA

RPRLAPP

NULL

RPRLAPP_RETURN_PIDM

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

NA

RPRLADB

NULL

RPRLADB_EL_REV_GROSS_AMT

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

NA

RPRLADB

NULL

RPRLADB_REV_DISB_AMT

SAS_REGION Region code of the school received in the statement of account. VARCHAR2(63)

RLRDDAS

RPRLADB

RLRDDAS_REGION_CDE

RPRLADB_REGION_CD

SAS_STATE_PROVINCE State or province associated with this institution. VARCHAR2(63)

RLRDDAS

RPRLADB

RLRDDAS_SCHOOL_STAT_CODE

RPRLADB_SCHOOL_STAT_CODE

SAS_STATE_PROVINCE_DESC State or province name. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

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

RLRDLDD

RPRLADB

RLRDLDD_SCHED_DATE

RPRLADB_DISBURSE_DATE

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

NA

RPRLADB

NULL

RPRLADB_EL_SERV_DISB_DATE

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

NA

RPRLADB

NULL

RPRLADB_EL_SERV_GROSS_AMT

STATE_PROVINCE State or province associated with this address. VARCHAR2(63)

RERCODA

RPRLAPP

RERCODA_CDST_CODE

RPRLAPP_STATE

STATE_PROVINCE_DESC State/province name. VARCHAR2(255)

FUNCTION

STVSTAT

GOKODSF.F_GET_DESC

STVSTAT_DESC

STREET_LINE1 First line of the address. VARCHAR2(255)

RERCODA

RPRLAPP

RERCODA_ADDR_LINE1

RPRLAPP_ADDRESS

STREET_LINE2 Second line of the address. VARCHAR2(255)

RERCODA

RPRLAPP

RERCODA_ADDR_LINE2

RPRLAPP_ADDR_LINE2

STREET_LINE3 Third line of the address. VARCHAR2(255)

RERCODA

RPRLAPP

RERCODA_ADDR_LINE3

RPRLAPP_ADDR_LINE3

STREET_LINE4 Fourth line of the address. VARCHAR2(255)

NA

NULL

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. VARCHAR2(255)

STVTERM

STVTERM_DESC

STUDENT_RECEIVE_DATE The date the loan proceeds were delivered to the student. No longer used after Financial Aid release 8.22.1. DATE

NA

RPRLADB

NULL

RPRLADB_STU_RECEIVE_DATE

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

NA

RPRLADB

NULL

RPRLADB_FEES_PAID

TOTAL_FEE_AMOUNT Sum of actual fee amounts for the loan as calculated by COD. NUMBER

NA

RLRDDAS

NULL

RLRDDAS_TOTAL_FEE_AMT

TOTAL_GROSS_AMOUNT Sum of actual gross amounts for the loan as calculated by COD. NUMBER

NA

RLRDDAS

NULL

RLRDDAS_TOTAL_GROSS_AMT

TOTAL_NET_AMOUNT Sum of actual net amounts for the loan as calculated by COD. NUMBER

NA

RLRDDAS

NULL

RLRDDAS_TOTAL_NET_AMT

TOTAL_NET_CHECK_AMOUNT Summary of all disbursement net check amounts for the loan. NUMBER

NA

RLRDLDB

NULL

RLRDLDB_TOTAL_NET_AMOUNT

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

NA

RLRDDAS

NULL

RLRDDAS_TOTAL_REBATE_AMT

TRANSACTION_DATE Transaction date. DATE

NA

RLRDDAS

NULL

RLRDDAS_TRANSACTION_DATE

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

RLRDLDD

RPRLADB

RLRDLDD_AR_TRAN_NUMBER

RPRLADB_TRAN_NUMBER

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

RLRDDAS

RPRLADB

RLRDDAS_TRANS_TYPE

RPRLADB_SERV_TRANS_TYPE

TRANSACTION_TYPE_DESC Transaction record description. VARCHAR2(255)

CALCULATION

CALCULATION

DECODE(RLRDDAS_TRANS_TYPE)

DECODE(RPRLADB_SERV_TRANS_TYPE)

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

RLRDLDD

RPRLADB

RLRDLDD_USER_ID

RPRLADB_USER_ID

XREF_LOAN_ID Identification number of the loan with which this loan was combined when producing an electronic loan extract file or direct loan promissory note. No longer used after Financial Aid release 8.22.1. VARCHAR2(63)

NA

RPRLAPP

NULL

RPRLAPP_XREF_LOAN_ID



Ver: 8.5