Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Academic period code to be associated with information in this record.	VARCHAR2(6)	RPRLADB	RPRLADB_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(30)	STVTERM	STVTERM_DESC
ACTIVITY_DATE	Date record was inserted or updated.	DATE	RPRLADB	RPRLADB_ACTIVITY_DATE
AID_YEAR	Aid year associated with this record. For example 0607 (2006 to 2007).	VARCHAR2(4)	RPRLADB	RPRLADB_AIDY_CODE
AID_YEAR_DESC	Description of the aid year.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
APPLICATION_NUMBER	System assigned number is assigned when the application is added.	NUMBER(3)	RPRLADB	RPRLADB_APPL_NO
APPROVED_AMOUNT	The approved loan amount for this particular academic period.	NUMBER(11, 2)	RPRLATR	RPRLATR_APPROVE_AMT
BORROWER_DIRECT_CHECK_AMOUNT	Direct disbursement amount received by borrower enrolled in a study-abroad program.	NUMBER(7, 2)	RPRLADB	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)	RPRLADB	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	ROKODSF.F_GET_CALC_DISBURSE_AMT
CANCEL_DATE	Displays the date the cancel indicator field was checked to cancel a pending disbursement.	DATE	RPRLADB	RPRLADB_CANCEL_DATE
CANCEL_IND	Check to cancel a pending disbursement or uncheck to reinstate the disbursement amount.	VARCHAR2(1)	RPRLADB	RPRLADB_CANCEL_IND
CERTIFIED_CREDIT_HOURS	Displays the loan application credit hours for loan eligibility.	NUMBER(9, 3)	RPRLATR	RPRLATR_CERT_HR
CHECK_DATE_RECEIVED	Indicates the date the check amount was received.	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	RPRLADB	RPRLADB_RET_LNDR_DATE
CHECK_RETURN_AMOUNT	Amount of the loan that was returned during an adjustment.	NUMBER(11, 2)	RPRLADB	RPRLADB_CHECK_RETURN_AMT
CHECK_RETURN_DATE	The date that the adjusted loan amount was returned.	DATE	RPRLADB	RPRLADB_CHECK_RETURN_DATE
COLLEGE	Direct lending school code for this loan detail record, returned on the School Account Statement.	VARCHAR2(6)	RPRLADB	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.	VARCHAR2(1)	RPRLADB	RPRLADB_AFFIRM_FLAG
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DIRECT_DISBURSEMENT_NUMBER	Direct loan disbursement number.	NUMBER(2)	RPRLADB	RPRLADB_DL_DISB_NO
DIRECT_LOAN_BATCH_NUMBER	Batch number related to the disbursement acknowledgement file for this individual disbursement.	VARCHAR2(23)	RPRLADB	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(6)	RPRLADB	RPRLADB_SERV_NET_ADJ_AMT
DIRECT_LOAN_COD_BOOK_DATE	Date the individual disbursement is booked at COD.	DATE	RPRLADB	RPRLADB_SERV_BOOKED_DATE
DIRECT_LOAN_COD_GROSS_AMOUNT	The gross amount recorded in the Account Statement with COD.	NUMBER(5)	RPRLADB	RPRLADB_SERV_GROSS_AMT
DIRECT_LOAN_COD_NET_AMOUNT	The net disbursement amount recorded in the Account Statement with COD.	NUMBER(5)	RPRLADB	RPRLADB_SERV_NET_AMT
DIRECT_LOAN_COD_REBATE_AMOUNT	The rebate Amount recorded in the Account Statement with COD.	NUMBER(5)	RPRLADB	RPRLADB_SERV_REBATE_AMT
DIRECT_LOAN_COD_RECEIPT_DATE	The actual date COD acknowledged receipt of this disbursement record.	DATE	RPRLADB	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(30)	RPRLADB	RPRLADB_DOCUMENT_ID
DIRECT_LOAN_FEE_AMOUNT	Amount of Direct Loan fees.	NUMBER(5)	RPRLADB	RPRLADB_DL_FEE_AMT
DIRECT_LOAN_GROSS_AMOUNT	Gross Amount of Direct Loan disbursement .	NUMBER(5)	RPRLADB	RPRLADB_DL_GROSS_AMT
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	RPRLADB	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	RPRLADB	RPRLADB_SAS_PROCESS_DATE
DIRECT_LOAN_REBATE_AMOUNT	The Direct Loan interest rebate amount calculated for this disbursement.	NUMBER(5)	RPRLADB	RPRLADB_DL_REBATE_AMT
DIRECT_LOAN_RECORD_COUNT_NO	The record number assigned in the School Account Statement with COD for this loan detail record.	NUMBER(6)	RPRLADB	RPRLADB_SAS_RECORD_COUNT_SEQ
DIRECT_LOAN_REJECT_CODE1	The first reject code sent from LOC / COD for this loan disbursement.	VARCHAR2(3)	RPRLADB	RPRLADB_DL_REJECT_CODE_1
DIRECT_LOAN_REJECT_CODE1_DESC	Description for the first reject code sent from LOC / COD.	VARCHAR2(65)	RTVRJCT	RTVRJCT_DESC
DIRECT_LOAN_REJECT_CODE2	The second reject code sent from LOC / COD for this loan disbursement.	VARCHAR2(3)	RPRLADB	RPRLADB_DL_REJECT_CODE_2
DIRECT_LOAN_REJECT_CODE2_DESC	Description for the second reject code sent from LOC / COD.	VARCHAR2(65)	RTVRJCT	RTVRJCT_DESC
DIRECT_LOAN_REJECT_CODE3	The third reject code sent from LOC / COD for this loan disbursement.	VARCHAR2(3)	RPRLADB	RPRLADB_DL_REJECT_CODE_3
DIRECT_LOAN_REJECT_CODE3_DESC	Description for the third reject code sent from LOC / COD.	VARCHAR2(65)	RTVRJCT	RTVRJCT_DESC
DIRECT_LOAN_REJECT_CODE4	The fourth reject code sent from LOC / COD for this loan disbursement.	VARCHAR2(3)	RPRLADB	RPRLADB_DL_REJECT_CODE_4
DIRECT_LOAN_REJECT_CODE4_DESC	Description for the fourth reject code sent from LOC / COD.	VARCHAR2(65)	RTVRJCT	RTVRJCT_DESC
DIRECT_LOAN_REJECT_CODE5	The fifth reject code sent from LOC / COD for this loan disbursement.	VARCHAR2(3)	RPRLADB	RPRLADB_DL_REJECT_CODE_5
DIRECT_LOAN_REJECT_CODE5_DESC	Description for the fifth reject code sent from LOC / COD.	VARCHAR2(65)	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.	NUMBER(2)	RPRLADB	RPRLADB_DL_SEQ_NO
DIRECT_LOAN_SERVICE_FEE_AMOUNT	The fees amount recorded in the Account Statement with COD.	NUMBER(5)	RPRLADB	RPRLADB_SERV_FEE_AMT
DISBURSEMENT_BYPASS_IND	Indicates lender transactions are to be bypassed for a payment during disbursement.	VARCHAR2(1)	RPRLADB	RPRLADB_DISB_BYPASS
DISBURSEMENT_COMMENT	Contains any special processing comments or instructions entered by the user.	VARCHAR2(60)	RPRLADB	RPRLADB_COMMENT
DISBURSEMENT_FEED	Displays whether disbursement should be fed to accounts receivable.	VARCHAR2(1)	RPRLADB	RPRLADB_FEED_IND
DISBURSEMENT_FEED_DATE	Indicates the date the disbursement was fed to the student's account's receivable account.	DATE	RPRLADB	RPRLADB_FEED_DATE
DISBURSEMENT_FEED_DESC	Indicates whether disbursement should be fed to accounts receivable.	VARCHAR2(10)	CALCULATION	DECODE(RPRLADB_FEED_IND)
DISBURSEMENT_PROCESSING_STATUS	The processing status of the disbursement.	VARCHAR2(1)	RPRLADB	RPRLADB_DISB_STATUS
DISBURSEMENT_PROC_STATUS_DESC	Disbursement processing status description.	VARCHAR2(25)	CALCULATION	DECODE(RPRLADB_DISB_STATUS)
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(2)	RPRLADB	RPRLADB_SEQ_NO
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA
ELECTRONIC_DISBURSEMENT_NUMBER	Disbursement number associated with this electronic loan disbursement record.	NUMBER(2)	RPRLADB	RPRLADB_EL_DISB_NO
ELECTRONIC_REFERENCE_ID	The check number or electronic batch number of the financial aid payment.	VARCHAR2(15)	RPRLADB	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(7, 2)	RPRLADB	RPRLADB_EL_SERV_NET_AMT
ELECTRONIC_TRANSFER_IND	Indicates when an electronic disbursement is received, rather than a paper check.	VARCHAR2(1)	RPRLADB	RPRLADB_EFT_IND
ENROLLMENT_LOAD	Displays the student's enrollment load calculated at the time of disbursement.	VARCHAR2(1)	RPRLADB	RPRLADB_DISBURSE_LOAD
ENROLLMENT_LOAD_DESC	Enrollment Load Description.	VARCHAR2(20)	CALCULATION	DECODE(RPRLADB_DISBURSE_LOAD)
ENROLLMENT_LOAD_OPTION	Financial Aid calculates a student's enrollment option used for the disbursement load.	VARCHAR2(1)	RPRLADB	RPRLADB_DISBURSE_LOAD_OPT
ENROLLMENT_LOAD_OPTION_DESC	Displays the enrollment load option used for the disbursement.	VARCHAR2(15)	CALCULATION	DECODE(RPRLADB_DISBURSE_LOAD_OPT)
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.	VARCHAR2(1)	CALCULATION	NVL(RPRLATR_EXCLUDE_LNEX_FLAG,'N')
EXPECTED_LOAN_AMOUNT	Expected loan amount associated with the application scheduled by academic periods.	NUMBER(11, 2)	RPRLATR	RPRLATR_EXPECT_AMT
FUND	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(6)	RPRLADB	RPRLADB_FUND_CODE
FUND_TITLE	Full title of the financial aid fund code.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
GUARANTEE_FEE_AMOUNT	Amount of the guarantee fee charged for this disbursement.	NUMBER(7, 2)	RPRLADB	RPRLADB_EL_SERV_GUAR_FEE
HOLD_RELEASE_DATE	The most recent date the Hold / Release status was sent or acknowledged.	DATE	RPRLADB	RPRLADB_EL_HOLD_REL_DATE
HOLD_RELEASE_STATUS	A code indicating the status of the school's requested disbursement hold or release.	VARCHAR2(2)	RPRLADB	RPRLADB_HOLD_REL_STATUS
HOLD_RELEASE_STATUS_DESC	Hold / Release status description.	VARCHAR2(20)	CALCULATION	DECODE(RPRLADB_HOLD_REL_STATUS)
LOAN_PERCENTAGE_ACAD_PERIOD	Represents the percentage of the loan that is scheduled for the associated academic period.	NUMBER(6, 3)	RPRLATR	RPRLATR_LOAN_PCT
LOAN_PERCENTAGE_DISBURSEMENT	The percentage of total loan that this disbursement represents.	NUMBER(6, 3)	RPRLADB	RPRLADB_LOAN_PCT
MEMO_EXPIRATION_DAYS	The number of days until the memo expires.	NUMBER(3)	RPRLADB	RPRLADB_MEMO_EXP_DAYS
MIF_DESC	The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(30)	NA	NA
MIF_VALUE	The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(6)	NA	NA
MPN_DISBURSEMENT_DATE	Disbursement Date printed on the Promissory Note. No longer required for MPN processing.	DATE	RPRLADB	RPRLADB_PN_DISB_DATE
NET_CHECK_AMOUNT	The net amount of this particular disbursement.	NUMBER(11, 2)	RPRLADB	RPRLADB_CHECK_AMT
ORIGINATION_FEE_AMOUNT	Amount of the origination fee charged for this disbursement.	NUMBER(7, 2)	RPRLADB	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.	VARCHAR2(1)	RPRLADB	RPRLADB_DISB_OVERRIDE_IND
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER(8)	RPRLADB	RPRLADB_PIDM
PREVIOUS_DISBURSEMENT_NUMBER	The previous disbursement sequence number on the COD database for the disbursement number.	NUMBER(2)	RPRLADB	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	RPRLADB	RPRLADB_PRIOR_DISB_DATE
RECOMMENDED_AMOUNT	Recommended amount of the loan associated with the loan application scheduled by academic period.	NUMBER(11, 2)	RPRLATR	RPRLATR_RECOMMEND_AMT
RECONCILIATION_BATCH_NUMBER	Cash reconciliation batch number in which this direct loan disbursement was included.	VARCHAR2(23)	RPRLADB	RPRLADB_RECON_BATCH_NO
REQUESTED_AMOUNT	Amount of requested loan for this particular academic period.	NUMBER(11, 2)	RPRLATR	RPRLATR_REQUEST_AMT
REVISED_GROSS_AMOUNT	The revised gross disbursement amount for this EL disbursement record.	NUMBER(11, 2)	RPRLADB	RPRLADB_EL_REV_GROSS_AMT
REVISED_NET_AMOUNT	The revised disbursement amount excluding all fees retained by the lender (i.e. net amount).	NUMBER(8, 2)	RPRLADB	RPRLADB_REV_DISB_AMT
SCHEDULED_DATE	Used by the disbursement process as the first date on which this disbursement may occur.	DATE	RPRLADB	RPRLADB_DISBURSE_DATE
SERVICER_DISBURSEMENT_DATE	The disbursement date scheduled by the guarantor/servicer for this disbursement.	DATE	RPRLADB	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(7, 2)	RPRLADB	RPRLADB_EL_SERV_GROSS_AMT
STUDENT_RECEIVE_DATE	The date the loan proceeds were delivered to the student.	DATE	RPRLADB	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(7, 2)	RPRLADB	RPRLADB_FEES_PAID
TRANSACTION_NUMBER	Displays the number on the student's account's receivable account where the disbursement was applied.	NUMBER(8)	RPRLADB	RPRLADB_TRAN_NUMBER
TRANSACTION_TYPE	This is the type of transaction record found for the disbursement.	VARCHAR2(1)	RPRLADB	RPRLADB_SERV_TRANS_TYPE
TRANSACTION_TYPE_DESC	Transaction record description.	VARCHAR2(25)	CALCULATION	DECODE(RPRLADB_SERV_TRANS_TYPE)
USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	RPRLADB	RPRLADB_USER_ID
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA

Ver: 8.1