Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_YEAR_END_DATE	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	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	Activity Date	The date that information in this record was entered or last updated.	DATE	RLRDLOR	RLRDLOR_ACTIVITY_DATE
ADDL_UNSUBSIDIZED_ELIG_IND	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
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_YEAR	Aid Year	The aid year to be associated with the information in this record.	VARCHAR2(63)	RLRDLOR	RLRDLOR_AIDY_CODE
AID_YEAR_DESC	Aid Year Desc	The description of the valid aid year.	VARCHAR2(255)	ROBINST	ROBINST_AIDY_DESC
BORROWER_BASED_ACADEMIC_YEAR	Borrower Based Academic Year	The Borrower-Based Academic Year associated with this record.	VARCHAR2(63)	RLRDLOR	RLRDLOR_BBAY_CODE
BORROWER_BASED_ACAD_YEAR_DESC	Borrower Based Acad Year Desc	Borrower-Based Academic Year type description.	VARCHAR2(255)	ROBBBAY	ROBBBAY_DESC
CREATE_DATE	Create Date	The date the loan application was created.	DATE	RLRDLOR	RLRDLOR_CREATE_DATE
DEFAULT_DESC	Default Desc	Description of the default code.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
DEFAULT_IND	Default Ind	Indicates whether the student is in default on a Title IV loan as reported by NSLDS.	VARCHAR2(63)	RLRDLOR	RLRDLOR_IN_DEFAULT
DEPENDENCY_STATUS	Dependency Status	Indicates if the student is (I)ndependent or (D)ependent.	VARCHAR2(63)	RLRDLOR	RLRDLOR_DEPENDENCY_STATUS
DEPENDENCY_STATUS_DESC	Dependency Status Desc	Dependency status description.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
DIRECT_LOAN_COD_ADJUSTED_NET	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	Direct Loan Cod Book Date	The date the loan was booked at COD.	DATE	RLRDDAS	RLRDDAS_DISB_BOOKED_DATE
DIRECT_LOAN_COD_GROSS_AMOUNT	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	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	Direct Loan Cod Rebate Amount	Actual rebate amount for this disbursement as calculated by COD.	NUMBER	RLRDDAS	RLRDDAS_REBATE_AMT
DIRECT_LOAN_ID	Direct Loan Id	A system generated field constructed from the SSN, loan type, loan year, Direct Loan school code, and loan sequence number.	VARCHAR2(63)	RLRDLOR	RLRDLOR_LOAN_ID
DIRECT_LOAN_MONTH_END_DATE	Direct Loan Month End Date	The end date for this statement of account.	DATE	RLRDDAS	RLRDDAS_SAS_END_DATE
DIRECT_LOAN_MONTH_PROCESS_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	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	Direct Loan School Code	The Department of Education's Direct Loan school code to be used for loan processing for the attending institution.	VARCHAR2(63)	RLRDLOR	RLRDLOR_SCHOOL_CODE
DIRECT_LOAN_SERVICE_FEE_AMOUNT	Direct Loan Service Fee Amount	Actual fee amount for this disbursement as calculated by COD.	NUMBER	RLRDDAS	RLRDDAS_FEE_AMT
DISBURSEMENT_DATA_ORIGIN	Disbursement Data Origin	Source system that created or updated the data.	VARCHAR2(63)	RLRDLOR	RLRDLOR_DATA_ORIGIN
DISBURSEMENT_NUMBER	Disbursement Number	The Direct Loan Disbursement Number for the disbursement.	NUMBER	RLRDDAS	RLRDDAS_DISB_NO
DISBURSEMENT_SEQUENCE_NUMBER	Disbursement sequence Number	The sequence for the disbursement record.	NUMBER	RLRDDAS	RLRDDAS_DISB_SEQ_NO
DISCLOSURE_NEED_PRINT_FLAG	Disclosure Need Print Flag	This field indicates a request to have COD print or reprint the disclosure statement.	VARCHAR2(63)	RLRDLOR	RLRDLOR_DISC_PRINT_FLAG
DISCLOSURE_REQUIRED_IND_DESC	Disclosure Required Ind Desc	Disclosure required indicator description.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
DL_SENT_DATE	Dl Sent Date	The date that the Direct Loan origination record was sent to COD.	DATE	RLRDLOR	RLRDLOR_DATE_SENT
ENTRANCE_COUNSELING_IND	Entrance Counseling Ind	Indicates whether the borrower has completed entrance counseling for this loan type.	VARCHAR2(1)	RLRDLOR	RLRDLOR_ENTRANCE_IND
FUND	Fund	The fund code associated with the loan application.	VARCHAR2(63)	RLRDLOR	RLRDLOR_FUND_CODE
FUND_TITLE	Fund Title	This field identifies the full title of the fund code.	VARCHAR2(63)	RFRBASE	RFRBASE_FUND_TITLE
HPPA_IND	Hppa Ind	Indicates whether this student qualifies for additional Unsubsidized loans up to the HPPA limits.	VARCHAR2(63)	RLRDLOR	RLRDLOR_HPPA_IND
LOAN_AMOUNT	Loan Amount	The loan amount for the origination.	NUMBER	RLRDLOR	RLRDLOR_LOAN_AMT
LOAN_APPLICATION_NUMBER	Loan Application Number	A system generated loan number for the student.	NUMBER	RLRDLOR	RLRDLOR_LOAN_NO
LOAN_BOOK_DATE	Loan Book Date	The date the disbursement booked at COD.	DATE	RLRDDAS	RLRDDAS_LOAN_BOOKED_DATE
LOAN_FEE_PERCENT	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	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	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	Loan Servicer	Name of the Direct Loan servicer for this loan.	VARCHAR2(255)	RLRDDAS	RLRDDAS_SERVICER
LOAN_STATUS	Loan Status	The code used to identify the current status of the loan in processing.	VARCHAR2(63)	RLRDLOR	RLRDLOR_LNST_CODE
LOAN_STATUS_DESC	Loan Status Desc	The description of the loan status.	VARCHAR2(255)	RTVLNST	RTVLNST_DESC
LOAN_TYPE	Loan Type	The loan type for the record.	VARCHAR2(63)	RLRDLOR	RLRDLOR_LOAN_TYPE
LOAN_TYPE_DESC	Loan Type Desc	Loan type description.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
LOCK_INDICATOR	Lock Indicator	Indicates whether the loan has been locked.	VARCHAR2(1)	RLRDLOR	RLRDLOR_LOCK_IND
MPN_ID	Mpn Id	The ID printed on the Master Promissory Note associated with this loan.	VARCHAR2(63)	RLRDLOR	RLRDLOR_MPN_ID
MPN_LINKED_IND	Mpn Linked Ind	COD's acknowledgement that this origination is linked to the MPN ID at COD	VARCHAR2(1)	RLRDLOR	RLRDLOR_MPN_LINKED_IND
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
ORIGINATION_DOCUMENT_ID	Origination Document Id	The document identification number for the document in which the loan's initial origination was sent to COD.	VARCHAR2(63)	RLRDLOR	RLRDLOR_DOCUMENT_ID
ORIGINATION_STATUS	Origination Status	The current status of the origination.	VARCHAR2(63)	RLRDLOR	RLRDLOR_STATUS
ORIGINATION_STATUS_DESC	Origination Status Desc	Origination status description.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RLRDLOR	RLRDLOR_PIDM
PREP_TEACH_CERTIFICATION_DESC	Prep Teach Certification Desc	Preparation or teacher certification coursework description.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
PREP_TEACH_CERTIFICATION_IND	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(63)	RLRDLOR	RLRDLOR_PREP_OR_TEACH_IND
PROCESS_DATE	Process Date	The date that the origination was processed by COD and the response returned to the school.	DATE	RLRDLOR	RLRDLOR_PROCESS_DATE
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROGRAM_SEQUENCE_LOCK_IND	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	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	Rebate fee percent.	NUMBER	RLRDLOR	RLRDLOR_REBATE_PCT
RECONCILIATION_BATCH_NUMBER	Reconciliation Batch Number	The batch number for the statement of account in which this record was received.	VARCHAR2(63)	RLRDDAS	RLRDDAS_SAS_BATCH_NO
RECORD_COUNT_SEQUENCE	Record Count Sequence	The record number assigned in the School Account Statement for this record.	NUMBER	RLRDDAS	RLRDDAS_SAS_RECORD_COUNT_SEQ
RECORD_SOURCE	Record Source	Indicates if record is sourced from Banner or COD	VARCHAR2(63)	CALCULATION	CASE WHEN RLRDDAS_DISB_SEQ_NO
SAR_TRANSACTION_NUMBER	Sar Transaction Number	The eligible SAR transaction number that was reported with the origination record.	VARCHAR2(63)	RLRDLOR	RLRDLOR_SAR_TRAN_NO
SAS_REGION	Sas Region	The two digit region code of the school received in the statement of account file.	VARCHAR2(63)	RLRDDAS	RLRDDAS_REGION_CDE
SAS_STATE_PROVINCE	Sas State Province	Two character state code of the school received in the statement of account file.	VARCHAR2(63)	RLRDDAS	RLRDDAS_SCHOOL_STAT_CODE
SAS_STATE_PROVINCE_DESC	Sas State Province Desc	State or province name.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
SCHEDULED_ACADEMIC_YEAR	Scheduled Academic Year	The Scheduled Academic Year associated with this record.	VARCHAR2(63)	RLRDLOR	RLRDLOR_SAYR_CODE
SCHEDULED_ACADEMIC_YEAR_DESC	Scheduled Academic Year Desc	Scheduled Academic Year description.	VARCHAR2(255)	RTVSAYR	RTVSAYR_DESC
SURROGATE_ID	Surrogate Id	The surrogate id for this record.	NUMBER	RLRDLOR	RLRDLOR_SURROGATE_ID
TOTAL_FEE_AMOUNT	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	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	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	Total Rebate Amount	The sum of actual rebate amounts for the loan as calculated by COD.	NUMBER	RLRDDAS	RLRDDAS_TOTAL_REBATE_AMT
TRANSACTION_DATE	Transaction Date	The date disbursement activity occurred at the school.	DATE	RLRDDAS	RLRDDAS_TRANSACTION_DATE
TRANSACTION_TYPE	Transaction Type	Disbursement activity type recorded at COD.	VARCHAR2(63)	RLRDDAS	RLRDDAS_TRANS_TYPE
TRANSACTION_TYPE_DESC	Transaction Type Desc	Transaction record description.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
USER_ID	User Id	The user ID of the person who inserted or last updated this record.	VARCHAR2(63)	RLRDLOR	RLRDLOR_USER_ID
YEAR_IN_COLLEGE	Year In College	The student's year in college for this origination record.	VARCHAR2(63)	RLRDLOR	RLRDLOR_YR_IN_COLL
YEAR_IN_COLLEGE_DESC	Year In College Desc	The student's year in college for this origination record.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC

Ver: 9.2