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
|
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
AID_YEAR
|
The aid year to be associated with the information in this record.
|
VARCHAR2(63)
|
RLRDLOR
|
RLRDLOR_AIDY_CODE
|
NO
|
NO
|
AID_YEAR_DESC
|
The description of the valid aid year.
|
VARCHAR2(255)
|
ROBINST
|
ROBINST_AIDY_DESC
|
NO
|
NO
|
BORROWER_BASED_ACADEMIC_YEAR
|
The Borrower-Based Academic Year associated with this record.
|
VARCHAR2(63)
|
RLRDLOR
|
RLRDLOR_BBAY_CODE
|
NO
|
NO
|
BORROWER_BASED_ACAD_YEAR_DESC
|
Borrower-Based Academic Year type description.
|
VARCHAR2(255)
|
ROBBBAY
|
ROBBBAY_DESC
|
NO
|
NO
|
CREATE_DATE
|
The date the loan application was created.
|
DATE
|
RLRDLOR
|
RLRDLOR_CREATE_DATE
|
NO
|
NO
|
DEFAULT_DESC
|
Description of the default code.
|
VARCHAR2(255)
|
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(63)
|
RLRDLOR
|
RLRDLOR_IN_DEFAULT
|
NO
|
NO
|
DEPENDENCY_STATUS
|
Indicates if the student is (I)ndependent or (D)ependent.
|
VARCHAR2(63)
|
RLRDLOR
|
RLRDLOR_DEPENDENCY_STATUS
|
NO
|
NO
|
DEPENDENCY_STATUS_DESC
|
Dependency status description.
|
VARCHAR2(255)
|
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(63)
|
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(63)
|
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(63)
|
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(63)
|
RLRDLOR
|
RLRDLOR_DISC_PRINT_FLAG
|
NO
|
NO
|
DISCLOSURE_REQUIRED_IND_DESC
|
Disclosure required indicator description.
|
VARCHAR2(255)
|
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
|
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(63)
|
RLRDLOR
|
RLRDLOR_FUND_CODE
|
NO
|
NO
|
FUND_TITLE
|
This field identifies the full title of the fund code.
|
VARCHAR2(63)
|
RFRBASE
|
RFRBASE_FUND_TITLE
|
NO
|
NO
|
HPPA_IND
|
Indicates whether this student qualifies for additional Unsubsidized loans up to the HPPA limits.
|
VARCHAR2(63)
|
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(255)
|
RLRDDAS
|
RLRDDAS_SERVICER
|
NO
|
NO
|
LOAN_STATUS
|
The code used to identify the current status of the loan in processing.
|
VARCHAR2(63)
|
RLRDLOR
|
RLRDLOR_LNST_CODE
|
NO
|
NO
|
LOAN_STATUS_DESC
|
The description of the loan status.
|
VARCHAR2(255)
|
RTVLNST
|
RTVLNST_DESC
|
NO
|
NO
|
LOAN_TYPE
|
The loan type for the record.
|
VARCHAR2(63)
|
RLRDLOR
|
RLRDLOR_LOAN_TYPE
|
NO
|
NO
|
LOAN_TYPE_DESC
|
Loan type description.
|
VARCHAR2(255)
|
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
|
MPN_ID
|
The ID printed on the Master Promissory Note associated with this loan.
|
VARCHAR2(63)
|
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
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
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
|
NO
|
NO
|
ORIGINATION_STATUS
|
The current status of the origination.
|
VARCHAR2(63)
|
RLRDLOR
|
RLRDLOR_STATUS
|
NO
|
NO
|
ORIGINATION_STATUS_DESC
|
Origination status description.
|
VARCHAR2(255)
|
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(255)
|
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(63)
|
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
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
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(63)
|
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(63)
|
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(63)
|
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(63)
|
RLRDDAS
|
RLRDDAS_REGION_CDE
|
NO
|
NO
|
SAS_STATE_PROVINCE
|
Two character state code of the school received in the statement of account file.
|
VARCHAR2(63)
|
RLRDDAS
|
RLRDDAS_SCHOOL_STAT_CODE
|
NO
|
NO
|
SAS_STATE_PROVINCE_DESC
|
State or province name.
|
VARCHAR2(255)
|
STVSTAT
|
STVSTAT_DESC
|
NO
|
NO
|
SCHEDULED_ACADEMIC_YEAR
|
The Scheduled Academic Year associated with this record.
|
VARCHAR2(63)
|
RLRDLOR
|
RLRDLOR_SAYR_CODE
|
NO
|
NO
|
SCHEDULED_ACADEMIC_YEAR_DESC
|
Scheduled Academic Year description.
|
VARCHAR2(255)
|
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(63)
|
RLRDDAS
|
RLRDDAS_TRANS_TYPE
|
NO
|
NO
|
TRANSACTION_TYPE_DESC
|
Transaction record description.
|
VARCHAR2(255)
|
FUNCTION
|
ROKODSF.F_GET_RORMVAL_DESC
|
NO
|
NO
|
USER_ID
|
The user ID of the person who inserted or last updated this record.
|
VARCHAR2(63)
|
RLRDLOR
|
RLRDLOR_USER_ID
|
NO
|
NO
|
YEAR_IN_COLLEGE
|
The student's year in college for this origination record.
|
VARCHAR2(63)
|
RLRDLOR
|
RLRDLOR_YR_IN_COLL
|
NO
|
NO
|
YEAR_IN_COLLEGE_DESC
|
The student's year in college for this origination record.
|
VARCHAR2(255)
|
FUNCTION
|
ROKODSF.F_GET_RORMVAL_DESC
|
NO
|
NO
|