Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_YEAR_END_DATE	The date on which the student's academic year ends for this origination.	DATE	RLRDLOR	RLRDLOR_ACAD_YR_END_DATE
ACADEMIC_YEAR_START_DATE	The date on which the student's academic year starts for this origination.	DATE	RLRDLOR	RLRDLOR_ACAD_YR_START_DATE
ACTIVITY_DATE	The date that information in this record was entered or last updated.	DATE	RLRDLOR	RLRDLOR_ACTIVITY_DATE
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
AID_YEAR	The aid year to be associated with the information in this record.	VARCHAR2(4)	RLRDLOR	RLRDLOR_AIDY_CODE
AID_YEAR_DESC	The description of the valid aid year.	VARCHAR2(4)	ROBINST	ROBINST_AIDY_DESC
BORROWER_BASED_ACADEMIC_YEAR	The Borrower-Based Academic Year associated with this record.	VARCHAR2(15)	RLRDLOR	RLRDLOR_BBAY_CODE
BORROWER_BASED_ACAD_YEAR_DESC	Borrower-Based Academic Year type description.	VARCHAR2(30)	ROBBBAY	ROBBBAY_DESC
CREATE_DATE	The date the loan application was created.	DATE	RLRDLOR	RLRDLOR_CREATE_DATE
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	NA
DEFAULT_DESC	Description of the default code.	VARCHAR2(240)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
DEFAULT_IND	Indicates whether the student is in default on a Title IV loan as reported by NSLDS.	VARCHAR2(1)	RLRDLOR	RLRDLOR_IN_DEFAULT
DEPENDENCY_STATUS	Indicates if the student is (I)ndependent or (D)ependent.	VARCHAR2(1)	RLRDLOR	RLRDLOR_DEPENDENCY_STATUS
DEPENDENCY_STATUS_DESC	Dependency status description.	VARCHAR2(240)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
DIRECT_LOAN_COD_ADJUSTED_NET	Actual net adjustment amount for this disbursement as calculated by COD.	NUMBER	RLRDDAS	RLRDDAS_NET_ADJ_AMT
DIRECT_LOAN_COD_BOOK_DATE	The date the loan was booked at COD.	DATE	RLRDDAS	RLRDDAS_DISB_BOOKED_DATE
DIRECT_LOAN_COD_GROSS_AMOUNT	Actual gross amount for this disbursement as calculated by COD.	NUMBER	RLRDDAS	RLRDDAS_GROSS_AMT
DIRECT_LOAN_COD_NET_AMOUNT	Actual net amount for this disbursement as calculated by COD.	NUMBER	RLRDDAS	RLRDDAS_NET_AMT
DIRECT_LOAN_COD_REBATE_AMOUNT	Actual rebate amount for this disbursement as calculated by COD.	NUMBER	RLRDDAS	RLRDDAS_REBATE_AMT
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
DIRECT_LOAN_MONTH_END_DATE	The end date for this statement of account.	DATE	RLRDDAS	RLRDDAS_SAS_END_DATE
DIRECT_LOAN_MONTH_PROCESS_DATE	The date this SAS report was processed by COD.	DATE	RLRDDAS	RLRDDAS_SAS_PROCESS_DATE
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
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
DIRECT_LOAN_SERVICE_FEE_AMOUNT	Actual fee amount for this disbursement as calculated by COD.	NUMBER	RLRDDAS	RLRDDAS_FEE_AMT
DISBURSEMENT_DATA_ORIGIN	Source system that created or updated the data.	VARCHAR2(30)	RLRDLOR	RLRDLOR_DATA_ORIGIN
DISBURSEMENT_NUMBER	The Direct Loan Disbursement Number for the disbursement.	NUMBER	RLRDDAS	RLRDDAS_DISB_NO
DISBURSEMENT_SEQUENCE_NUMBER	The sequence for the disbursement record.	NUMBER	RLRDDAS	RLRDDAS_DISB_SEQ_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
DISCLOSURE_REQUIRED_IND_DESC	Disclosure required indicator description.	VARCHAR2(120)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
DL_SENT_DATE	The date that the Direct Loan origination record was sent to COD.	DATE	RLRDLOR	RLRDLOR_DATE_SENT
DOMAIN_VALUE	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA
ENTRANCE_COUNSELING_IND	Indicates whether the borrower has completed entrance counseling for this loan type.	VARCHAR2(1)	RLRDLOR	RLRDLOR_ENTRANCE_IND
FUND	The fund code associated with the loan application.	VARCHAR2(6)	RLRDLOR	RLRDLOR_FUND_CODE
FUND_TITLE	This field identifies the full title of the fund code.	VARCHAR2(30)	RFRBASE	RFRBASE_FUND_TITLE
HPPA_IND	Indicates whether this student qualifies for additional Unsubsidized loans up to the HPPA limits.	VARCHAR2(1)	RLRDLOR	RLRDLOR_HPPA_IND
LOAN_AMOUNT	The loan amount for the origination.	NUMBER	RLRDLOR	RLRDLOR_LOAN_AMT
LOAN_APPLICATION_NUMBER	A system generated loan number for the student.	NUMBER	RLRDLOR	RLRDLOR_LOAN_NO
LOAN_BOOK_DATE	The date the disbursement booked at COD.	DATE	RLRDDAS	RLRDDAS_LOAN_BOOKED_DATE
LOAN_FEE_PERCENT	The percentage of the loan that will be subtracted from the loan proceed for origination fees.	NUMBER	RLRDLOR	RLRDLOR_FEE_PCT
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
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
LOAN_SERVICER	Name of the Direct Loan servicer for this loan.	VARCHAR2(30)	RLRDDAS	RLRDDAS_SERVICER
LOAN_STATUS	The code used to identify the current status of the loan in processing.	VARCHAR2(4)	RLRDLOR	RLRDLOR_LNST_CODE
LOAN_STATUS_DESC	The description of the loan status.	VARCHAR2(30)	RTVLNST	RTVLNST_DESC
LOAN_TYPE	The loan type for the record.	VARCHAR2(1)	RLRDLOR	RLRDLOR_LOAN_TYPE
LOAN_TYPE_DESC	Loan type description.	VARCHAR2(4000)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
LOCK_INDICATOR	Indicates whether the loan has been locked.	VARCHAR2(1)	RLRDLOR	RLRDLOR_LOCK_IND
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
MPN_ID	The ID printed on the Master Promissory Note associated with this loan.	VARCHAR2(21)	RLRDLOR	RLRDLOR_MPN_ID
MPN_LINKED_IND	COD's acknowledgement that this origination is linked to the MPN ID at COD	VARCHAR2(1)	RLRDLOR	RLRDLOR_MPN_LINKED_IND
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
ORIGINATION_STATUS	The current status of the origination.	VARCHAR2(1)	RLRDLOR	RLRDLOR_STATUS
ORIGINATION_STATUS_DESC	Origination status description.	VARCHAR2(120)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RLRDLOR	RLRDLOR_PIDM
PREP_TEACH_CERTIFICATION_DESC	Preparation or teacher certification coursework description.	VARCHAR2(120)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
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
PROCESS_DATE	The date that the origination was processed by COD and the response returned to the school.	DATE	RLRDLOR	RLRDLOR_PROCESS_DATE
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
PROGRAM_SEQUENCE_NUMBER	Sequence of the program information record used on this origination.	NUMBER	RLRDLOR	RLRDLOR_SPGM_SEQ_NO
REBATE_FEE_PERCENT	Rebate fee percent.	NUMBER	RLRDLOR	RLRDLOR_REBATE_PCT
RECONCILIATION_BATCH_NUMBER	The batch number for the statement of account in which this record was received.	VARCHAR2(23)	RLRDDAS	RLRDDAS_SAS_BATCH_NO
RECORD_COUNT_SEQUENCE	The record number assigned in the School Account Statement for this record.	NUMBER	RLRDDAS	RLRDDAS_SAS_RECORD_COUNT_SEQ
RECORD_SOURCE	Indicates if record is sourced from Banner or COD	VARCHAR2(6)	CALCULATION	CASE WHEN RLRDDAS_DISB_SEQ_NO
SAR_TRANSACTION_NUMBER	The eligible SAR transaction number that was reported with the origination record.	VARCHAR2(2)	RLRDLOR	RLRDLOR_SAR_TRAN_NO
SAS_REGION	The two digit region code of the school received in the statement of account file.	VARCHAR2(2)	RLRDDAS	RLRDDAS_REGION_CDE
SAS_STATE_PROVINCE	Two character state code of the school received in the statement of account file.	VARCHAR2(2)	RLRDDAS	RLRDDAS_SCHOOL_STAT_CODE
SAS_STATE_PROVINCE_DESC	State or province name.	VARCHAR2(30)	STVSTAT	STVSTAT_DESC
SCHEDULED_ACADEMIC_YEAR	The Scheduled Academic Year associated with this record.	VARCHAR2(15)	RLRDLOR	RLRDLOR_SAYR_CODE
SCHEDULED_ACADEMIC_YEAR_DESC	Scheduled Academic Year description.	VARCHAR2(30)	RTVSAYR	RTVSAYR_DESC
SURROGATE_ID	The surrogate id for this record.	NUMBER	RLRDLOR	RLRDLOR_SURROGATE_ID
TOTAL_FEE_AMOUNT	The sum of actual fee amounts for the loan as calculated by COD.	NUMBER	RLRDDAS	RLRDDAS_TOTAL_FEE_AMT
TOTAL_GROSS_AMOUNT	The sum of actual gross amounts for the loan as calculated by COD.	NUMBER	RLRDDAS	RLRDDAS_TOTAL_GROSS_AMT
TOTAL_NET_AMOUNT	The sum of actual net amounts for the loan as calculated by COD.	NUMBER	RLRDDAS	RLRDDAS_TOTAL_NET_AMT
TOTAL_REBATE_AMOUNT	The sum of actual rebate amounts for the loan as calculated by COD.	NUMBER	RLRDDAS	RLRDDAS_TOTAL_REBATE_AMT
TRANSACTION_DATE	The date disbursement activity occurred at the school.	DATE	RLRDDAS	RLRDDAS_TRANSACTION_DATE
TRANSACTION_TYPE	Disbursement activity type recorded at COD.	VARCHAR2(1)	RLRDDAS	RLRDDAS_TRANS_TYPE
TRANSACTION_TYPE_DESC	Transaction record description.	VARCHAR2(120)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
USER_ID	The user ID of the person who inserted or last updated this record.	VARCHAR2(30)	RLRDLOR	RLRDLOR_USER_ID
YEAR_IN_COLLEGE	The student's year in college for this origination record.	VARCHAR2(1)	RLRDLOR	RLRDLOR_YR_IN_COLL
YEAR_IN_COLLEGE_DESC	The student's year in college for this origination record.	VARCHAR2(120)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: