Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	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	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
ACTIVITY_DATE	Activity Date	Date record was inserted or updated.	DATE	RLRDLDD RPRLADB	RLRDLDD_ACTIVITY_DATE RPRLADB_ACTIVITY_DATE
ADMINISTRATIVE_GROUP	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	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	Aid enrollment period description.	VARCHAR2(255)	ROBPRDS	ROBPRDS_DESC
AID_YEAR	Financial 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	Financial Aid Year Description	Aid year description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
APPLICATION_NUMBER	Application Number	System assigned number is assigned when the application is added.	NUMBER	RLRDLDD RPRLADB	RLRDLDD_LOAN_NO RPRLADB_APPL_NO
APPROVED_AMOUNT	Approved Amount	The approved loan amount for this particular academic period.	NUMBER	RPRDLPS RPRLATR	RPRDLPS_LOAN_AMT RPRLATR_APPROVE_AMT
AUTHORIZED_IND	Authorized Indicator	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	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	Borrower Direct Disbursement Indicator	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	Calculated Expected Disbursement Amount	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	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	Cancel Indicator	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	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	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	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	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	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	City	Address city, town or municipality.	VARCHAR2(63)	RERCODA RPRLAPP	RERCODA_CITY RPRLAPP_CITY
COLLEGE	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	Confirmation Indicator	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	Default Indicator	Loan default status.	VARCHAR2(63)	RLRDLOR RPRLAPP	RLRDLOR_IN_DEFAULT RPRLAPP_IN_DEFAULT
DEFAULT_IND_DESC	Default Indicator Description	Description of the loan default status.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
DIRECT_DISBURSEMENT_NUMBER	Direct Disbursement Number	Direct loan disbursement number.	NUMBER	RLRDLDD RPRLADB	RLRDLDD_DISB_NO RPRLADB_DL_DISB_NO
DIRECT_LOAN_BATCH_NUMBER	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	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	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	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	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	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	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	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	Direct Loan Fee Amount	Amount of Direct Loan fees.	NUMBER	RLRDLDD RPRLADB	RLRDLDD_FEE_AMT RPRLADB_DL_FEE_AMT
DIRECT_LOAN_GROSS_AMOUNT	Direct Loan Gross Amount	Gross Amount of Direct Loan disbursement .	NUMBER	RLRDLDD RPRLADB	RLRDLDD_GROSS_AMT RPRLADB_DL_GROSS_AMT
DIRECT_LOAN_ID	Direct Loan ID	Identifies a specific loan application.	VARCHAR2(63)	RLRDLOR RPRLAPP	RLRDLOR_LOAN_ID RPRLAPP_DL_LOAN_ID
DIRECT_LOAN_MONTH_END_DATE	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	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	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	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	Direct Loan Record Count Number	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	Direct Loan Rejection Code 1	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	Direct Loan Rejection Code 1 Description	Description for the first reject code sent from LOC / COD.	VARCHAR2(255)	RTVRJCT	RTVRJCT_DESC
DIRECT_LOAN_REJECT_CODE2	Direct Loan Rejection Code 2	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	Direct Loan Rejection Code 2 Description	Description for the second reject code sent from LOC / COD.	VARCHAR2(255)	RTVRJCT	RTVRJCT_DESC
DIRECT_LOAN_REJECT_CODE3	Direct Loan Rejection Code 3	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	Direct Loan Rejection Code 3 Description	Description for the third reject code sent from LOC / COD.	VARCHAR2(255)	RTVRJCT	RTVRJCT_DESC
DIRECT_LOAN_REJECT_CODE4	Direct Loan Rejection Code 4	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	Direct Loan Rejection Code 4 Description	Description for the fourth reject code sent from LOC / COD.	VARCHAR2(255)	RTVRJCT	RTVRJCT_DESC
DIRECT_LOAN_REJECT_CODE5	Direct Loan Rejection Code 5	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	Direct Loan Rejection Code 5 Description	Description for the fifth reject code sent from LOC / COD.	VARCHAR2(255)	RTVRJCT	RTVRJCT_DESC
DIRECT_LOAN_SEQUENCE_NUMBER	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	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	Disbursement Bypass Indicator	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	Disbursement Comment	Contains any special processing comments or instructions entered by the user.	VARCHAR2(4000)	RLRDLDD RPRLADB	RLRDLDD_COMMENT RPRLADB_COMMENT
DISBURSEMENT_DATA_ORIGIN	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	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	Disbursement Feed	Displays whether disbursement should be fed to accounts receivable.	VARCHAR2(63)	RLRDLDD RPRLADB	RLRDLDD_FEED_IND RPRLADB_FEED_IND
DISBURSEMENT_FEED_DATE	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	Disbursement Feed Description	Indicates whether disbursement should be fed to accounts receivable.	VARCHAR2(255)	CALCULATION CALCULATION	DECODE(RLRDLDD_FEED_IND) DECODE(RPRLADB_FEED_IND)
DISBURSEMENT_PROCESSING_STATUS	Disbursement Processing Status	The processing status of the disbursement.	VARCHAR2(63)	RLRDLDD RPRLADB	RLRDLDD_DISB_STATUS RPRLADB_DISB_STATUS
DISBURSEMENT_PROC_STATUS_DESC	Disbursement Proc Status Description	Disbursement processing status description.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
DISBURSEMENT_SEQUENCE_NUMBER	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	Electronic Disbursement Number	Disbursement number associated with this electronic loan disbursement record.	NUMBER	NA RPRLADB	NULL RPRLADB_EL_DISB_NO
ELECTRONIC_REFERENCE_ID	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	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	Electronic Transfer Indicator	Indicates when an electronic disbursement is received, rather than a paper check.	VARCHAR2(1)	NA RPRLADB	NULL RPRLADB_EFT_IND
EL_LOAN_ID	Electronic Loan Loan ID	Loan identification number used by electronic loan processing (common line).	VARCHAR2(63)	NA RPRLAPP	NULL RPRLAPP_EL_LOAN_ID
ENROLLMENT_LOAD	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	Enrollment Load Description.	VARCHAR2(255)	CALCULATION CALCULATION	DECODE(RLRDLDD_LOAD) DECODE(RPRLADB_DISBURSE_LOAD)
ENROLLMENT_LOAD_OPTION	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	Enrollment Load Option Description	Displays the enrollment load option used for the disbursement.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
ENROLLMENT_SCHOOL_CODE	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	Enrollment Status	Student's enrollment status.	VARCHAR2(63)	RLRDLDD RPRLADB	RLRDLDD_ENROLLMENT_STATUS RPRLADB_ENROLLMENT_STATUS
ENROLLMENT_STATUS_DESC	Enrollment Status Description	Enrollment status description.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
EXCLUDE_EXCEPTION_REPORT_IND	Exclude Exception Report Indicator	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	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	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	Fund Title	Full title of the financial aid fund code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
GUARANTEE_FEE_AMOUNT	Guarantee Fee Amount	Amount of the guarantee fee charged for this disbursement.	NUMBER	NA RPRLADB	NULL RPRLADB_EL_SERV_GUAR_FEE
HOLD_RELEASE_DATE	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	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	Hold / Release status description.	VARCHAR2(255)	CALCULATION NA	DECODE(RPRLADB_HOLD_REL_STATUS) NULL
ID	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	Loan Book Date	Date the loan is booked at COD.	DATE	NA RLRDDAS	NULL RLRDDAS_LOAN_BOOKED_DATE
LOAN_NUMBER	Loan Number	System generated loan number for the student.	NUMBER	RLRDLDD RPRLADB	RLRDLDD_LOAN_NO RPRLADB_APPL_NO
LOAN_PERCENTAGE_ACAD_PERIOD	Loan Percentage Academic 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	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	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	Loan period description. No longer used after Financial Aid release 8.22.1.	VARCHAR2(255)	NA RPBLPRD	NULL RPBLPRD_DESC
LOAN_SERVICER	Loan Servicer	Loan servicer name.	VARCHAR2(255)	RLRDDAS RPRLADB	RLRDDAS_SERVICER RPRLADB_SERVICER
LOAN_SOURCE	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	Loan source description.	VARCHAR2(255)	CALCULATION	CASE WHEN RFRASPC_DIRECT_LOAN_IND
LOAN_STATUS	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	Loan Status Description	Common line process status description.	VARCHAR2(255)	RTVLNST	RTVLNST_DESC
MEMO_EXPIRATION_DAYS	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	Master Promissory Note 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	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	Multi Source Description	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	Name of the person (LFMI).	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
NET_CHECK_AMOUNT	Net Check Amount	The net amount of this particular disbursement.	NUMBER	RLRDLDD RPRLADB	RLRDLDD_NET_AMT RPRLADB_CHECK_AMT
ORIGINATION_FEE_AMOUNT	Origination Fee Amount	Amount of the origination fee charged for this disbursement.	NUMBER	NA RPRLADB	NULL RPRLADB_EL_SERV_ORIG_FEE
OVERRIDE_IND	Override Indicator	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	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	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	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	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	Parent State Province Description	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	Parent Street Line 1	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	Parent Street Line 2	Second line of parent's permanent street address.	VARCHAR2(255)	RLRDBOR RPRLAPP	RLRDBOR_PERM_ADDR_LINE2 RPRLAPP_PAR_ADDR_LINE2
PARENT_STREET_LINE3	Parent Street Line 3	Third line of parent's permanent street address.	VARCHAR2(255)	RLRDBOR RPRLAPP	RLRDBOR_PERM_ADDR_LINE3 RPRLAPP_PAR_ADDR_LINE3
PARENT_STREET_LINE4	Parent Street Line 4	Fourth line of parent's permanent street address.	VARCHAR2(255)	NA	NULL
PAYMENT_PERIOD_START_DATE	Payment Period Start Date	Disbursement payment period start date.	DATE	RLRDLDD RPRLADB	RLRDLDD_PAY_PD_START_DATE RPRLADB_PAY_PD_START_DATE
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RLRDLDD RPRLADB	RLRDLDD_PIDM RPRLADB_PIDM
PHONE_NUMBER_COMBINED	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	Postal code in the address of the borrower of a direct loan.	VARCHAR2(63)	RERCODA RPRLAPP	RERCODA_ZIP RPRLAPP_ZIP
PREVIOUS_DISBURSEMENT_NUMBER	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	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	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	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	Program classification description.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_CIPC_DESC
PROGRAM_SEQUENCE_LOCK_IND	Program Sequence Lock Ind	Indicates if the student program information sequence is locked for the loan disbursement record.	VARCHAR2(1)	RLRDLDD	RLRDLDD_SPGM_LOCK_IND
PROGRAM_SEQUENCE_NUMBER	Program Sequence Number	Sequence of the program information record used on this disbursement.	NUMBER	RLRDLDD	RLRDLDD_SPGM_SEQ_NO
RECOMMENDED_AMOUNT	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	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	Reported Date	Disbursement date reported to COD as of this sequence.	DATE	RLRDLDD RPRLADB	RLRDLDD_REPORTED_DATE RPRLADB_REPT_DISB_DATE
REQUESTED_AMOUNT	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	Return ID	Person's or organization's current identification number.	VARCHAR2(63)	FUNCTION NA	MGKFUNC.F_GET_PERSON_INFO NULL
RETURN_NAME	Return Name	Name of the person (LFMI) or organization.	VARCHAR2(255)	FUNCTION NA	MGKFUNC.F_GET_PERSON_INFO NULL
RETURN_UID	Return UID	Loan ID of the Guarantor or Lender.	NUMBER	NA RPRLAPP	NULL RPRLAPP_RETURN_PIDM
REVISED_GROSS_AMOUNT	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	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	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	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	Sas State Province Description	State or province name.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
SCHEDULED_DATE	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	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	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 Province	State or province associated with this address.	VARCHAR2(63)	RERCODA RPRLAPP	RERCODA_CDST_CODE RPRLAPP_STATE
STATE_PROVINCE_DESC	State Province Description	State/province name.	VARCHAR2(255)	FUNCTION STVSTAT	GOKODSF.F_GET_DESC STVSTAT_DESC
STREET_LINE1	Street Line 1	First line of the address.	VARCHAR2(255)	RERCODA RPRLAPP	RERCODA_ADDR_LINE1 RPRLAPP_ADDRESS
STREET_LINE2	Street Line 2	Second line of the address.	VARCHAR2(255)	RERCODA RPRLAPP	RERCODA_ADDR_LINE2 RPRLAPP_ADDR_LINE2
STREET_LINE3	Street Line 3	Third line of the address.	VARCHAR2(255)	RERCODA RPRLAPP	RERCODA_ADDR_LINE3 RPRLAPP_ADDR_LINE3
STREET_LINE4	Street Line 4	Fourth line of the address.	VARCHAR2(255)	NA	NULL
STUDENT_ACADEMIC_PERIOD	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	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
STUDENT_RECEIVE_DATE	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	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	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	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	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	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	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	Transaction date.	DATE	NA RLRDDAS	NULL RLRDDAS_TRANSACTION_DATE
TRANSACTION_NUMBER	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	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 Type Description	Transaction record description.	VARCHAR2(255)	CALCULATION CALCULATION	DECODE(RLRDDAS_TRANS_TYPE) DECODE(RPRLADB_SERV_TRANS_TYPE)
USER_ID	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	Cross Reference 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: 9.2