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: