Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Financial Aid Reporting View Reports

Banner Operational Data Store
Reporting View Target: LOAN_APPLICATION

Description Contains data from a loan application submitted by a person for an aid year. Detail data may include loan application number, citizen indicator, alien registration number, driver's license number, addresses, phone numbers, and detailed loan data for various loans.
Key & Frequency One row per aid year per loan application number.
Recommended Search Columns AID_YEAR, FUND
PERSON_UID, FUND

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ACADEMIC_YEAR_END_DATE Date on which the student's academic year ends at the institution. DATE

RLRDLOR

RPRLAPP

RLRDLOR_ACAD_YR_END_DATE

RPRLAPP_ACAD_YR_END_DATE

NO

NO

NO
ACADEMIC_YEAR_START_DATE Date on which the student's academic year starts at the institution. DATE

RLRDLOR

RPRLAPP

RLRDLOR_ACAD_YR_START_DATE

RPRLAPP_ACAD_YR_START_DATE

NO

NO

NO
ADDITIONAL_STAFFORD_ELIG_IND Indicates whether this dependent student is eligible for an additional unsubsidized loan amount. VARCHAR2(63)

CALCULATION

RLRDLOR

NVL(RPRLAPP_ADDL_STFD_ELIG_IND,'N')

RLRDLOR_ADDL_UNSUB_ELIG_IND

NO

NO

NO
ADDL_UNSUBSIDIZED_ELIG_IND DO NOT USE THIS COLUMN. Was inadvertently added. Use ADDITIONAL_STAFFORD_ELIG_IND instead. VARCHAR2(1)

CALCULATION

RLRDLOR

NVL(RPRLAPP_ADDL_STFD_ELIG_IND,'N')

RLRDLOR_ADDL_UNSUB_ELIG_IND

NO

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
AGENCY_RETURN_ID Person's identification used to adjust the record. VARCHAR2(63)

NA

SPRIDEN

NULL

SPRIDEN_ID

NO

NO

NO
AGENCY_RETURN_NAME Name of the agency/lender to whom unused funds are to be returned. VARCHAR2(255)

FUNCTION

NA

F_FORMAT_NAME

NULL

NO

NO

NO
AID_YEAR Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation. VARCHAR2(63)

RLRDLOR

RPRLAPP

RLRDLOR_AIDY_CODE

RPRLAPP_AIDY_CODE

NO

NO

NO
AID_YEAR_DESC Financial aid year name. VARCHAR2(255)

ROBINST

ROBINST_AIDY_DESC

NO

NO
ALIEN_REGISTRATION_NUMBER Student's alien registration number (when applicable). VARCHAR2(63)

NA

RPRLAPP

NULL

RPRLAPP_ALIEN_REG_NO

NO

NO

NO
ALT_LOAN_BORROWER_LOAN_DEBT Total amount of outstanding education debt (undergrad and graduate) for the alternative loan borrower prior to the application. Amount includes all fed. And alternative loans including fed. Consolidation loans. NUMBER

RPRLAPP

RPRLAPP_ALT_BOR_LOAN_DEBT

NO

NO
ALT_LOAN_PROGRAM_TYPE Indicates the specific category of alternative loan for reporting. VARCHAR2(63)

RPRLAPP

RPRLAPP_ALT_LOAN_PROG_TYPE_CDE

NO

NO
ALT_LOAN_STUDENT_BORROWER_IND Borrower's total federal STUDENT LOAN SERVICE (SLS) loan debt prior to the loan period and should include the federal STUDENT LOAN SERVICE (SLS) loan portion of the borrower's federal consolidation loan. VARCHAR2(63)

RPRLAPP

RPRLAPP_ALT_LOAN_SB_IND

NO

NO
APPLICANT_LOAN_REQUESTED_AMT Amount of loan requested by the applicant. This amount cannot be negative or zero. NUMBER

RLRPLUS

RPRLAPP

RLRPLUS_REQUEST_AMT

RPRLAPP_REQUEST_AMT

NO

NO

NO
APPLICATION_ACTIVITY_DATE Date record was inserted or updated. DATE

RLRDLOR

RPRLAPP

RLRDLOR_ACTIVITY_DATE

RPRLAPP_ACTIVITY_DATE

NO

NO

NO
APPLICATION_COMPLETE_DATE Date the loan application was completed. DATE

RLRPAPP

RPRLAPP

RLRPAPP_APP_COMP_DATE

RPRLAPP_APP_COMP_DATE

NO

NO

NO
APPLICATION_DATA_ORIGIN Source system that last created or updated the data. VARCHAR2(63)

RLRDLOR

RPRLAPP

RLRDLOR_DATA_ORIGIN

RPRLAPP_DATA_ORIGIN

NO

NO

NO
APPLICATION_LOAN_AMOUNT Loan amount requested for this application if the maximum loan amount was not requested. NUMBER

RPRLAPP

RPRLAPP

RLRPAPP_APP_LOAN_AMT

RPRLAPP_APP_LOAN_AMT

NO

NO

NO
APPLICATION_USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)

RLRDLOR

RPRLAPP

RLRDLOR_USER_ID

RPRLAPP_USER_ID

NO

NO

NO
APPROVED_AMOUNT Loan amount that was approved by the approving agency. NUMBER

RLRDLOR

RPRLAPP

RLRDLOR_LOAN_AMT

RPRLAPP_APPROVE_AMT

NO

NO

NO
APPROVED_DATE Date the loan was approved by the approving agency. DATE

NA

RPRLAPP

NULL

RPRLAPP_APPROVE_DATE

NO

NO

NO
BATCH_ID_FOR_DIRECT_LOAN Batch number of the file of origination records for direct loans that was sent to the service provider that included this student. VARCHAR2(63)

NA

RPRLAPP

NULL

RPRLAPP_BATCH_NO

NO

NO

NO
BBAY_TYPE Borrower-Based Academic Year type. VARCHAR2(63)

NA

ROBBBAY

NULL

ROBBBAY_BBTP_CODE

NO

NO

NO
BBAY_TYPE_DESC Borrower-Based Academic Year type description. VARCHAR2(255)

NA

RTVBBTP

NULL

RTVBBTP_DESC

NO

NO

NO
BIRTH_DATE Student's birth date. DATE

RLRCBID

RPRLAPP

RERCSID_BIRTH_DATE

RPRLAPP_BIRTH_DATE

NO

NO

NO
BORROWER_ANNUAL_INCOME Total income earned by the borrower from his or her primary employment. NUMBER

RPRLAPP

RPRLAPP_BOR_GROSS_YR_SAL

NO

NO
BORROWER_BASED_ACADEMIC_YEAR Borrower-Based Academic Year. VARCHAR2(63)

NA

RLRDLOR

NULL

RLRDLOR_BBAY_CODE

NO

NO

NO
BORROWER_BASED_ACAD_YEAR_DESC Borrower-Based Academic Year description. VARCHAR2(255)

NA

ROBBBAY

NULL

ROBBBAY_DESC

NO

NO

NO
BORROWER_EMAIL_ADDRESS Parent borrower's email address. VARCHAR2(255)

RLRDBOR

RPRLAPP

RLRDBOR_EMAIL

RPRLAPP_BORROWER_EMAIL

NO

NO

NO
BORROWER_OTHER_INCOME Total income earned by the borrower from a source other than his or her primary employment. NUMBER

RPRLAPP

RPRLAPP_BOR_OTH_INC

NO

NO
CANCEL_INACTIVATED_DATE Date a direct loan cancel/inactive indicator changed for this student. DATE

NA

RPRLAPP

NULL

RPRLAPP_CANCEL_DATE

NO

NO

NO
CANCEL_INACTIVATED_IND Date a direct loan cancel/inactive indicator changed for this student. VARCHAR2(63)

NA

RPRLAPP

NULL

RPRLAPP_CANCEL_IND

NO

NO

NO
CERTIFICATION_DATE Date that the loan application was certified. DATE

NA

RPRLAPP

NULL

RPRLAPP_CERT_DATE

NO

NO

NO
CITIZEN_IND Indicates whether the person has been identified as a citizen of the institution's home country. VARCHAR2(63)

RERCODS

RPRLAPP

RERCODS_CITZ_IND

RPRLAPP_CITZ_IND

NO

NO

NO
CITY Address city, town or municipality. VARCHAR2(63)

RERCODA

RPRLAPP

RERCODA_CITY

RPRLAPP_CITY

NO

NO

NO
COMMONLINE_APP_VERSION_NUMBER Version of the common line application file has been sent once the loan application has been extracted. VARCHAR2(63)

NA

RPRLAPP

NULL

RPRLAPP_APP_VER_NO

NO

NO

NO
COMMONLINE_LOAN_DATE_SENT Date the loan was sent to the loan service provider (common line). DATE

NA

RPRLAPP

NULL

RPRLAPP_EL_DATE_SENT

NO

NO

NO
COMMONLINE_LOAN_ID Loan identification number used by electronic loan processing (common line). VARCHAR2(63)

NA

RPRLAPP

NULL

RPRLAPP_EL_LOAN_ID

NO

NO

NO
COMMONLINE_LOAN_SEQ_NUMBER Sequence number used by electronic loan processing (common line) to further identify the loan. NUMBER

NA

RPRLAPP

NULL

RPRLAPP_EL_SEQ_NO

NO

NO

NO
COMMONLINE_LOAN_STATUS Status of a loan processed via electronic loan processing (common line). VARCHAR2(63)

NA

RPRLAPP

NULL

RPRLAPP_EL_STATUS

NO

NO

NO
COMMONLINE_PROCESSING_STATUS Status of the common line application process for this record. VARCHAR2(63)

RLRDLOR

RPRLAPP

RLRDLOR_LNST_CODE

RPRLAPP_LNST_CODE

NO

NO

NO
COSIGN1_ANNUAL_INCOME Total income earned by cosigner 1 from his or her primary employment. NUMBER

RPRLAPP

RPRLAPP_COSIGN1_GROSS_YR_SAL

NO

NO
COSIGN1_BIRTH_DATE First cosigner's date of birth. DATE

RPRLAPP

RPRLAPP_COSIGN1_BIRTH_DATE

NO

NO
COSIGN1_CITIZEN_IND A 1-digit code indicating the first cosigner's citizenship status. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN1_CITZ_IND

NO

NO
COSIGN1_CITY City of the first cosigner's last known address. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN1_CITY

NO

NO
COSIGN1_DR_LIC_NUMBER First cosigner's driver's license number. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN1_DRIVER_LIC_NO

NO

NO
COSIGN1_DR_LIC_STATE_DESC Name of the state/province that issued the first cosigner's driver's license. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

NO

NO
COSIGN1_DR_LIC_STATE_PROV 2-character abbreviation for the state/province that issued the first cosigner's driver's license. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN1_STAT_CODE_LIC

NO

NO
COSIGN1_FIRST_NAME First name of the cosigner. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN1_FIRST_NAME

NO

NO
COSIGN1_FOREIGN_POSTAL_CODE Foreign postal code of the cosigner's last known address. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN1_FOR_POST_CDE

NO

NO
COSIGN1_LAST_NAME Last name of the cosigner. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN1_LAST_NAME

NO

NO
COSIGN1_MIDDLE_INITIAL Middle initial of the cosigner. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN1_MI

NO

NO
COSIGN1_OTHER_INCOME Total income earned by cosigner 1 from a source other than his or her primary employment. NUMBER

RPRLAPP

RPRLAPP_COSIGN1_OTH_INC

NO

NO
COSIGN1_PHONE_NUMBER_COMBINED First cosigner's last known telephone home number. Includes the area code. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN1_PHONE_NO

NO

NO
COSIGN1_POSTAL_CODE Postal code of the cosigner's last known address. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN1_ZIP

NO

NO
COSIGN1_RELATIONSHIP First cosigner's relationship to the student. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN1_RELATION_IND

NO

NO
COSIGN1_RELATIONSHIP_DESC Cosigner's relationship description. VARCHAR2(255)

CALCULATION

DECODE(RPRLAPP_COSIGN1_RELATION_IND)

NO

NO
COSIGN1_SIGNATURE_IND A 1-character code indicating if the signature of the first cosigner is present. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN1_SIGNED_IND

NO

NO
COSIGN1_STATE_PROVINCE 2-character state abbreviation of the first cosigner's last known address. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN1_STAT_CODE

NO

NO
COSIGN1_STATE_PROVINCE_DESC Name of the state/province of the first cosigner's last known address. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

NO

NO
COSIGN1_STREET_LINE1 First line of the first cosigner's last known address. VARCHAR2(255)

RPRLAPP

RPRLAPP_COSIGN1_ADDR_LINE1

NO

NO
COSIGN1_STREET_LINE2 Second line of the first cosigner's last known address. VARCHAR2(255)

RPRLAPP

RPRLAPP_COSIGN1_ADDR_LINE2

NO

NO
COSIGN1_SUFFIX Suffix of the first cosigner's name. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN1_SUFFIX

NO

NO
COSIGN1_TAX_ID Tax identification number or social security number of the cosigner. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN1_SSN

NO

NO
COSIGN1_YRS_AT_ADDRESS Indicates the number of years the first cosigner has been at his/her address. NUMBER

RPRLAPP

RPRLAPP_COSIGN1_YR_ADDRESS

NO

NO
COSIGN2_ANNUAL_INCOME Total income earned by cosigner 2 from his or her primary employment. NUMBER

RPRLAPP

RPRLAPP_COSIGN2_GROSS_YR_SAL

NO

NO
COSIGN2_BIRTH_DATE Second cosigner's date of birth. DATE

RPRLAPP

RPRLAPP_COSIGN2_BIRTH_DATE

NO

NO
COSIGN2_CITIZEN_IND A 1-digit code indicating the second cosigner's citizenship status. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN2_CITZ_IND

NO

NO
COSIGN2_CITY City of the second cosigner's last known address. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN2_CITY

NO

NO
COSIGN2_DR_LIC_NUMBER Second cosigner's driver's license number. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN2_DRIVER_LIC_NO

NO

NO
COSIGN2_DR_LIC_STATE_DESC Name of the state/province that issued the second cosigner's driver's license. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

NO

NO
COSIGN2_DR_LIC_STATE_PROV Two-character abbreviation for the state that issued the second cosigner's drivers license. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN2_STAT_CODE_LIC

NO

NO
COSIGN2_FIRST_NAME First name of the cosigner. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN2_FIRST_NAME

NO

NO
COSIGN2_FOREIGN_POSTAL_CODE A 14-character field indicating the foreign postal code of the second cosigner's last known address. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN2_FOR_POST_CDE

NO

NO
COSIGN2_LAST_NAME Last name of the cosigner. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN2_LAST_NAME

NO

NO
COSIGN2_MIDDLE_INITIAL Middle initial of the second cosigner. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN2_MI

NO

NO
COSIGN2_OTHER_INCOME Total income earned by cosigner 2 from a source other than his or her primary employment. NUMBER

RPRLAPP

RPRLAPP_COSIGN2_OTH_INC

NO

NO
COSIGN2_PHONE_NUMBER_COMBINED Second cosigner's last known telephone home number. Includes the area code. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN2_PHONE_NO

NO

NO
COSIGN2_POSTAL_CODE Postal code of the cosigner's last known address. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN2_ZIP_CODE

NO

NO
COSIGN2_RELATIONSHIP Second cosigner's relationship to the student. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN2_RELATION_IND

NO

NO
COSIGN2_RELATIONSHIP_DESC Description of the second cosigner's relationship to the student. VARCHAR2(255)

CALCULATION

DECODE(RPRLAPP_COSIGN2_RELATION_IND)

NO

NO
COSIGN2_SIGNATURE_IND A 1-character code indicating if the signature of the second cosigner is present. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN2_SIGNED_IND

NO

NO
COSIGN2_STATE_PROVINCE State abbreviation of the second cosigner's last known address. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN2_STAT_CODE

NO

NO
COSIGN2_STATE_PROVINCE_DESC Name of the state/province of the second cosigner's last known address. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

NO

NO
COSIGN2_STREET_LINE1 First line of the second cosigner's last known address. VARCHAR2(255)

RPRLAPP

RPRLAPP_COSIGN2_ADDR_LINE1

NO

NO
COSIGN2_STREET_LINE2 Second line of the second cosigner's last known address. VARCHAR2(255)

RPRLAPP

RPRLAPP_COSIGN2_ADDR_LINE2

NO

NO
COSIGN2_SUFFIX Suffix of the second cosigner's name. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN2_SUFFIX

NO

NO
COSIGN2_TAX_ID Tax identification number or social security number of the cosigner. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN2_SSN

NO

NO
COSIGN2_YRS_AT_ADDRESS Number of years the second cosigner has been at his/her address. NUMBER

RPRLAPP

RPRLAPP_COSIGN2_YR_ADDRESS

NO

NO
CREDIT_ACTION Indicates action the borrower wishes to take when the credit status is denied. VARCHAR2(63)

RLRPLUS

RPRLAPP

RLRPLUS_CR_ACTION_OPT

RPRLAPP_CR_ACTION_OPT

NO

NO

NO
CREDIT_ACTION_DESC Credit action description. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
CREDIT_ACTION_STATUS Status of credit action after being initially denied. VARCHAR2(63)

NA

RLRPLUS

NULL

RLRPLUS_CR_ACTION_STATUS

NO

NO

NO
CREDIT_ACTION_STATUS_DESC Denied credit action status description. VARCHAR2(255)

FUNCTION

NA

ROKODSF.F_GET_RORMVAL_DESC

NULL

NO

NO

NO
CREDIT_APPLICATION_DOCUMENT_ID Document ID in which the credit check status was received. VARCHAR2(63)

RLRPLUS

RPRLAPP

RLRPLUS_CO_DOCUMENT_ID

RPRLAPP_CREDIT_DOCUMENT_ID

NO

NO

NO
CREDIT_BALANCE_OPTION_IND Indicates whether the PLUS borrower remaining loan funds can be applied to non-institutional charges. VARCHAR2(1)

RLRPAPP

RPRLAPP

RLRPAPP_SCHOOL_CR_BALANCE_OPT

RPRLAPP_SCHOOL_CR_BALANCE_OPT

NO

NO

NO
CREDIT_CHECK_APPEAL_STATUS Credit check appeal status. VARCHAR2(63)

RLRPLUS

RPRLAPP

RLRPLUS_CR_APPEAL_STATUS

RPRLAPP_CR_APPEAL_STATUS

NO

NO

NO
CREDIT_CHECK_EXPIRATION_DATE Date a credit check status expires. DATE

RLRPLUS

RPRLAPP

RLRPLUS_CREDIT_CHECK_EXP_DATE

RPRLAPP_CREDIT_CHECK_EXP_DATE

NO

NO

NO
CREDIT_CHECK_OVERRIDDEN Indicates whether denies credit status has been overriden. VARCHAR2(63)

RLRPLUS

RPRLAPP

RLRPLUS_CR_OVERRIDE_CDE

RPRLAPP_CR_OVERRIDE_CDE

NO

NO

NO
CREDIT_CHECK_OVERRIDDEN_DESC Credit check overridden description. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
CREDIT_CHK_APPEAL_STATUS_DESC Credit check appeal status description. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
CREDIT_IN_DIFFERENT_NAME_IND Indicates the borrower has been granted credit under a different name. VARCHAR2(63)

RPRLAPP

RPRLAPP_CRED_DIF_NM_IND

NO

NO
DEFAULT_IND Indicates whether this is the default type to be used. VARCHAR2(63)

RLRDLOR

RPRLAPP

RLRDLOR_IN_DEFAULT

RPRLAPP_IN_DEFAULT

NO

NO

NO
DEFAULT_IND_DESC Description of the loan default status. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
DEFERRED_PAYMENT_IND Indicates whether applicant has chosen to defer payments. VARCHAR2(1)

CALCULATION

RLRPAPP

NVL(RPRLAPP_DEFERMENT_OPT,'N')

NVL(RLRPAPP_DEFERMENT_OPT,'N')

NO

NO

NO
DEPENDENCY_STATUS Identifies the student's dependency status as computed by INAS or loaded from the tape record. VARCHAR2(63)

RLRDLOR

RPRLAPP

RLRDLOR_DEPENDENCY_STATUS

RPRLAPP_MODEL_CDE

NO

NO

NO
DEPENDENCY_STATUS_DESC Dependency status description. VARCHAR2(255)

CALCULATION

FUNCTION

CASE WHEN RPRLAPP_MODEL_CDE

ROKODSF.F_GET_RORMVAL_DESC

NO

NO

NO
DIRECT_LOAN_DATE_SENT Date that a direct loan origination record was sent to the service provider. DATE

RLRDLOR

RPRLAPP

RLRDLOR_DATE_SENT

RPRLAPP_DL_SENT_DATE

NO

NO

NO
DIRECT_LOAN_ID Identifies a specific loan application. VARCHAR2(63)

RLRDLOR

RPRLAPP

RLRDLOR_LOAN_ID

RPRLAPP_DL_LOAN_ID

NO

NO

NO
DIRECT_LOAN_NUMBER System generated sequence number to designate direct loan applications. No longer used after Financial Aid release 8.22.1. NUMBER

NA

RPRLAPP

NULL

RPRLAPP_DL_SEQ_NO

NO

NO

NO
DIRECT_LOAN_SCHOOL_CODE Department of Education's Direct Loan school code to be used for loan processing for the attending institution. VARCHAR2(63)

RLRDLOR

RPRLAPP

RLRDLOR_SCHOOL_CODE

RPRLAPP_SCHOOL_CODE

NO

NO

NO
DIRECT_LOAN_STATUS Origination status code, typically system maintained for direct loan applications. VARCHAR2(63)

RLRDLOR

RPRLAPP

RLRDLOR_STATUS

RPRLAPP_DL_STATUS

NO

NO

NO
DISCLOSURE_PRINT_DATE Last date that a disclosure statement was printed for this loan. No longer used after Financial Aid release 8.22.1. DATE

NA

RPRLAPP

NULL

RPRLAPP_DISC_PRINT_DATE

NO

NO

NO
DISCLOSURE_PRINT_IND Indicates whether a new or revised disclosure statement needs to be printed for this loan and signed by the student. No longer used after Financial Aid release 8.22.1. VARCHAR2(63)

NA

RPRLAPP

NULL

RPRLAPP_DISC_PRINT_IND

NO

NO

NO
DISCLOSURE_REQUIRED_IND New or revised disclosure statement needs to be printed for this loan record. VARCHAR2(63)

RLRDLOR

RPRLAPP

RLRDLOR_DISC_PRINT_FLAG

RPRLAPP_DISC_NEED_PRINT_FLAG

NO

NO

NO
DISCLOSURE_REQUIRED_IND_DESC Disclosure required indicator description. VARCHAR2(255)

CALCULATION

FUNCTION

CASE WHEN RLRLAPP_DISC_NEED_PRINT_FLAG

ROKODSF.F_GET_RORMVAL_DESC

NO

NO

NO
DL_BOOKING_STATUS Overall reconciliation status from the service provider (loan origination center) for this loan. VARCHAR2(63)

NA

RPRLAPP

NULL

RPRLAPP_DL_RECON_STATUS

NO

NO

NO
DL_DISB_RECON_REJECT_1 First reconciliation reject code sent from the servicer (loan origination center) for this loan disbursement. No longer used after Financial Aid release 8.22.1. VARCHAR2(63)

NA

RPRLAPP

NULL

RPRLAPP_DL_RECON_REJECT_1

NO

NO

NO
DL_DISB_RECON_REJECT_2 Second reconciliation reject code sent from the servicer (loan origination center) for this loan disbursement. No longer used after Financial Aid release 8.22.1. VARCHAR2(63)

NA

RPRLAPP

NULL

RPRLAPP_DL_RECON_REJECT_2

NO

NO

NO
DL_DISB_RECON_REJECT_3 Third reconciliation reject code sent from the servicer (loan origination center) for this loan disbursement. No longer used after Financial Aid release 8.22.1. VARCHAR2(63)

NA

RPRLAPP

NULL

RPRLAPP_DL_RECON_REJECT_3

NO

NO

NO
DL_DISB_RECON_REJECT_4 Fourth reconciliation reject code sent from the servicer (loan origination center) for this loan disbursement. No longer used after Financial Aid release 8.22.1. VARCHAR2(63)

NA

RPRLAPP

NULL

RPRLAPP_DL_RECON_REJECT_4

NO

NO

NO
DL_DISB_RECON_REJECT_5 Fifth reconciliation reject code sent from the servicer (loan origination center) for this loan disbursement. No longer used after Financial Aid release 8.22.1. VARCHAR2(63)

NA

RPRLAPP

NULL

RPRLAPP_DL_RECON_REJECT_5

NO

NO

NO
DL_MPN_STATUS_DESC Direct loan status description. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
DL_MPN_STATUS_IND Status of the borrower's master promissory note at the loan origination center (loc). VARCHAR2(63)

RLRDMPN

RPRLAPP

RLRDMPN_MPN_STATUS

RPRLAPP_MPN_STATUS_IND

NO

NO

NO
DL_ORIGINATION_REJECT1_DESC First reject code description. VARCHAR2(255)

RTVRJCT

RTVRJCT_DESC

NO

NO
DL_ORIGINATION_REJECT2_DESC Second reject code description. VARCHAR2(255)

RTVRJCT

RTVRJCT_DESC

NO

NO
DL_ORIGINATION_REJECT3_DESC First third code description. VARCHAR2(255)

RTVRJCT

RTVRJCT_DESC

NO

NO
DL_ORIGINATION_REJECT4_DESC Fourth reject code description. VARCHAR2(255)

RTVRJCT

RTVRJCT_DESC

NO

NO
DL_ORIGINATION_REJECT5_DESC Fifth reject code description. VARCHAR2(255)

RTVRJCT

RTVRJCT_DESC

NO

NO
DL_ORIGINATION_REJECT_1 May contain a reject code from the dl service provider if the service provider did not accept the loan origination. VARCHAR2(63)

RERCDED

RPRLAPP

RERCDED_RJCT_CODE

RPRLAPP_DL_REJECT_CODE_1

NO

NO

NO
DL_ORIGINATION_REJECT_2 May contain a reject code from the dl service provider if the service provider did not accept the loan origination. VARCHAR2(63)

RERCDED

RPRLAPP

RERCDED_RJCT_CODE

RPRLAPP_DL_REJECT_CODE_2

NO

NO

NO
DL_ORIGINATION_REJECT_3 May contain a reject code from the dl service provider if the service provider did not accept the loan origination. VARCHAR2(63)

RERCDED

RPRLAPP

RERCDED_RJCT_CODE

RPRLAPP_DL_REJECT_CODE_3

NO

NO

NO
DL_ORIGINATION_REJECT_4 May contain a reject code from the dl service provider if the service provider did not accept the loan origination. VARCHAR2(63)

RERCDED

RPRLAPP

RERCDED_RJCT_CODE

RPRLAPP_DL_REJECT_CODE_4

NO

NO

NO
DL_ORIGINATION_REJECT_5 May contain a reject code from the dl service provider if the service provider did not accept the loan origination. VARCHAR2(63)

RERCDED

RPRLAPP

RERCDED_RJCT_CODE

RPRLAPP_DL_REJECT_CODE_5

NO

NO

NO
DL_REBATE_FEE_PERCENT Rebate fee percent. NUMBER

DLRDLOR

RPRLAPP

RLRDLOR_REBATE_PCT

RPRLAPP_DL_REBATE_PERCENT

NO

NO

NO
DRIVER_LICENSE_NUMBER Applicant's driver's license number as reported on the applicant's need analysis document. VARCHAR2(63)

RERCODS

RPRLAPP

RERCODS_DRIVER_LIC_NO

RPRLAPP_DRIVER_LIC_NO

NO

NO

NO
DRIVER_LICENSE_STATE_PROVINCE State/province of the state in which the student holds a drivers license. VARCHAR2(63)

RERCODS

RPRLAPP

RERCODS_CDST_CODE_LIC

RPRLAPP_STAT_CODE_LIC

NO

NO

NO
DRIVER_LICENSE_ST_PR_DESC State/province description in which the student holds a drivers license. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

NO

NO
ELECTRONIC_MPN_IND Indicates whether the MPN is an electronic master promissory note or paper. VARCHAR2(1)

NA

RLRDMPN

NULL

RLRDMPN_EMPN_IND

NO

NO

NO
EMAIL_ADDRESS Preferred email address. VARCHAR2(255)

RERCODS

RPRLAPP

RERCODS_EMAIL

RPRLAPP_STU_EMAIL

NO

NO

NO
ENDORSER_AMOUNT Loan amount signed for by the endorser on the Endorser Addendum. NUMBER

RLRPLUS

RPRLAPP

RLRPLUS_ENDORSER_AMT

RPRLAPP_PAR_ENDORSER_AMT

NO

NO

NO
ENROLL_START_DATE Enrollment start date. No longer used after Financial Aid release 8.22.1. DATE

NA

RPRLAPP

NULL

RPRLAPP_ENROLL_START_DATE

NO

NO

NO
ENTRANCE_COUNSELING_IND Indicates whether borrower has completed entrance counseling. VARCHAR2(1)

RLRDLOR

RPRLAPP

RLRDLOR_ENTRANCE_IND

RPRLAPP_ENTRANCE_IND

NO

NO

NO
EXPECTED_AMOUNT Amount of the loan that the student is expected to receive. It is the lower of either the maximum eligible amount or the requested amount. No longer used after Financial Aid release 8.22.1. NUMBER

NA

RPRLAPP

NULL

RPRLAPP_EXPECT_AMT

NO

NO

NO
EXPECTED_GRADUATION_DATE Expected graduation date. No longer used after Financial Aid release 8.22.1. DATE

NA

RPRLAPP

NULL

RPRLAPP_EXP_GRAD_DATE

NO

NO

NO
FIRST_NAME Student's first name as reported on the loan application. VARCHAR2(63)

CALCULATION

CALCULATION

NVL(RERCODS_FIRST_NAME, MGKFUNC.F_GET_PERSON_INFO)

NVL(RPRLAPP_FIRST_NAME, MGKFUNC.F_GET_PERSON_INFO)

NO

NO

NO
FORMER_HEAL_INDICATOR Indicator of student qualification for additional Stafford unsubsidized loans in replacement of the heal loan program. VARCHAR2(63)

RLRDLOR

RPRLAPP

RLRDLOR_HPPA_IND

RPRLAPP_FORMER_HEAL_IND

NO

NO

NO
FUND Financial Aid Fund code to be associated with information in this record. VARCHAR2(63)

RLRDLOR

RPRLAPP

RLRDLOR_FUND_CODE

RPRLAPP_FUND_CODE

NO

NO

NO
FUND_TITLE Full title of the financial aid fund code. VARCHAR2(255)

RFRBASE

RFRBASE_FUND_TITLE

NO

NO
GIVE_PLUS_TO_STUDENT_IND Plus to student indicator. VARCHAR2(63)

RLRPLUS

RPRLAPP

RLRPLUS_PLUS_TO_STUDENT

RPRLAPP_PLUS_TO_STUDENT

NO

NO

NO
GUARANTOR_ID Id for the guarantee agency that guaranteed the loan. VARCHAR2(63)

NA

SPRIDEN

NULL

SPRIDEN_ID

NO

NO

NO
GUARANTOR_NAME Name of the guarantee agency that guaranteed the loan. VARCHAR2(255)

FUNCTION

NA

F_FORMAT_NAME

NULL

NO

NO

NO
HEAL_LOAN_DEBT Borrower's total heal loan debt prior to the loan period. NUMBER

RPRLAPP

RPRLAPP_HEAL_DEBT

NO

NO
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

NO

NO
INTEREST_RATE_OPTION Indicates the type of interest rate associated with the loan (e.g., fixed or variable). VARCHAR2(63)

RPRLAPP

RPRLAPP_INT_RATE_OPT_IND

NO

NO
LAST_NAME Student's last name as reported on the loan application. VARCHAR2(63)

CALCULATION

CALCULATION

NVL(RERCSID_LAST_NAME, MGKFUNC.F_GET_PERSON_INFO)

NVL(RPRLAPP_LAST_NAME, MGKFUNC.F_GET_PERSON_INFO)

NO

NO

NO
LENDER_ID Id for the lender who issued the loan. VARCHAR2(63)

NA

SPRIDEN

NULL

SPRIDEN_ID

NO

NO

NO
LENDER_NAME Name of the lender that issued the loan. VARCHAR2(255)

FUNCTION

NA

F_FORMAT_NAME

NULL

NO

NO

NO
LOAN_AMOUNT_UNKNOWN_IND Indicates whether borrower does not know the loan amount for the PLUS Application. VARCHAR2(1)

RLRPAPP

RPRLAPP

RLRPAPP_UNKNOWN_LOAN_AMT_IND

RPRLAPP_UNKNOWN_LOAN_AMT_IND

NO

NO

NO
LOAN_APPLICATION_NUMBER System assigned number is assigned when the application is added. NUMBER

RLRDLOR

RPRLAPP

RLRDLOR_LOAN_NO

RPRLAPP_APPL_NO

NO

NO

NO
LOAN_APPLICATION_RECEIVED_DATE Date that the loan application was received. DATE

NA

RPRLAPP

NULL

RPRLAPP_RECEIVE_DATE

NO

NO

NO
LOAN_APP_CREATE_DATE Date the loan application was created. For dl loans initialized by the loan origination batch process. DATE

NA

RPRLAPP

NULL

RPRLAPP_CREATE_DATE

NO

NO

NO
LOAN_FEE Percentage of the loan subtracted from the loan proceeds because of origination fees. Column will be removed. Use LOAN_FEE_PERCENT instead. NUMBER

RLRDLOR

RPRLAPP

RLRDLOR_FEE_PCT

RPRLAPP_FEE_PCT

NO

NO

NO
LOAN_FEE_PERCENT Percentage of the loan subtracted from the loan proceeds because of origination fees. NUMBER

RLRDLOR

RPRLAPP

RLRDLOR_FEE_PCT

RPRLAPP_FEE_PCT

NO

NO

NO
LOAN_NUMBER System generated loan number for the student. NUMBER

RLRDLOR

RPRLAPP

RLRDLOR_LOAN_NO

RPRLAPP_APPL_NO

NO

NO

NO
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

NO

NO

NO
LOAN_PERIOD_DESC Loan Period description. No longer used after Financial Aid release 8.22.1. VARCHAR2(255)

NA

RPBLPRD

NULL

RPBLPRD_DESC

NO

NO

NO
LOAN_PERIOD_END_DATE Loan award period end date based on the period awards contained within the loan. DATE

RLRDLOR

RPRLAPP

RLRDLOR_AWARD_END_DATE

RPRLAPP_LPRD_END_DATE

NO

NO

NO
LOAN_PERIOD_START_DATE Loan award period start date based on the period awards contained within the loan. DATE

RLRDLOR

RPRLAPP

RLRDLOR_AWARD_START_DATE

RPRLAPP_LPRD_START_DATE

NO

NO

NO
LOAN_RECOMMENDED_AMOUNT Packaged loan recommendation from the student's award record. This defaults from the student's offered amount. If the fund has not been packaged for the aid year, the amount recommended is blank. NUMBER

NA

RPRLAPP

NULL

RPRLAPP_RECOMMEND_AMT

NO

NO

NO
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

NO

NO
LOAN_SOURCE_DESC Loan source description. VARCHAR2(255)

CALCULATION

CASE WHEN RFRASPC_DIRECT_LOAN_IND

NO

NO
LOAN_STATUS Identifies the current status of the loan in processing. VARCHAR2(63)

RLRDLOR

RPRLAPP

RLRDLOR_LNST_CODE

RPRLAPP_LNST_CODE

NO

NO

NO
LOAN_STATUS_DESC Loan status description. VARCHAR2(255)

RTVLNST

RTVLNST_DESC

NO

NO
LOAN_TYPE Type of loan. VARCHAR2(63)

RLRDLOR

RPRLAPP

RLRDLOR_LOAN_TYPE

RPRLAPP_LOAN_TYPE

NO

NO

NO
LOAN_TYPE_DESC Loan type description.  

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
LOCAL_CITY City in the local address of the borrower of a direct loan. VARCHAR2(63)

RERCODA

RPRLAPP

RERCODA_CITY

RPRLAPP_LOCAL_CITY

NO

NO

NO
LOCAL_NATION Nation/country associated with the local address of the borrower. VARCHAR2(63)

RERCODA

RPRLAPP

RERCODA_CDNT_CODE

RPRLAPP_LOCAL_NATN_CODE

NO

NO

NO
LOCAL_NATION_DESC Nation/country description for borrower's local address. VARCHAR2(255)

STVNATN

STVNATN_NATION

NO

NO
LOCAL_PHONE_NUMBER_COMBINED Local phone number of the borrower of a direct loan. VARCHAR2(63)

NA

RPRLAPP

NULL

RPRLAPP_LOCAL_PHONE_NO

NO

NO

NO
LOCAL_POSTAL_CODE Postal code in the local address of the borrower of a direct loan. VARCHAR2(63)

RERCODA

RPRLAPP

RERCODA_ZIP

RPRLAPP_LOCAL_ZIP

NO

NO

NO
LOCAL_STATE_PROVINCE State in the local address of the borrower of a direct loan. VARCHAR2(63)

RERCODA

RPRLAPP

RERCODA_CDST_CODE

RPRLAPP_LOCAL_STAT_CODE

NO

NO

NO
LOCAL_STATE_PROVINCE_DESC State/province description of the local address of the borrower of a direct loan. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

NO

NO
LOCAL_STREET_LINE1 First line of the borrower's local address. VARCHAR2(255)

RERCODA

RPRLAPP

RERCODA_ADDR_LINE1

RPRLAPP_LOCAL_ADDRESS

NO

NO

NO
LOCAL_STREET_LINE2 Second line of the borrower's local address. VARCHAR2(255)

RERCODA

RPRLAPP

RERCODA_ADDR_LINE2

RPRLAPP_LOCAL_ADDR_LINE2

NO

NO

NO
LOCAL_STREET_LINE3 Third line of the borrower's local address. VARCHAR2(255)

RERCODA

RPRLAPP

RERCODA_ADDR_LINE3

RPRLAPP_LOCAL_ADDR_LINE3

NO

NO

NO
LOCAL_STREET_LINE4 Fourth line of the borrower's local address. VARCHAR2(255)

NA

NULL

NO

NO
LOCK_INDICATOR Hold indicator. VARCHAR2(63)

RLRDLOR

RPRLAPP

RLRDLOR_LOCK_IND

RPRLAPP_HOLD_IND

NO

NO

NO
MAJOR Major subject area of the person's academic study. VARCHAR2(63)

RPRLAPP

RPRLAPP_STU_MAJOR

NO

NO
MAJOR_DESC Name of the student's major subject area. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

NO

NO
MAXIMUM_ELIGIBLE_AMOUNT Maximum loan amount for which the student is eligible. (The processed amount.). NUMBER

NA

RPRLAPP

NULL

RPRLAPP_MAX_ELIG_AMT

NO

NO

NO
MAXIMUM_LOAN_REQUESTED_IND Indicates whether borrower has requested the maximum possible loan amount. VARCHAR2(1)

CALCULATION

CALCULATION

NVL(RLRPAPP_MAX_LOAN_IND,'N')

NVL(RPRLAPP_MAX_LOAN_IND,'N')

NO

NO

NO
MIDDLE_INITIAL The student's middle initial as reported on the loan application. VARCHAR2(1)

CALCULATION

CALCULATION

NVL(RERCODS_MI, MGKFUNC.F_GET_PERSON_INFO)

NVL(RPRLAPP_MI, MGKFUNC.F_GET_PERSON_INFO)

NO

NO

NO
MPN_BATCH_ID Batch identification number used to report the master promissory note status and identification number. VARCHAR2(63)

RLRDMPN

RPRLAPP

RLRDMPN_EXP_BATCH_ID

RPRLAPP_MPN_BATCH_ID

NO

NO

NO
MPN_BORROWER_BIRTH_DATE Borrower's birth date. DATE

NA

RLRDMPN

NULL

RLRDMPN_BORROWER_BIRTH_DATE

NO

NO

NO
MPN_BORROWER_FIRST_NAME Borrower's first name. VARCHAR2(63)

NA

RLRDMPN

NULL

RLRDMPN_BORROWER_FIRST_NAME

NO

NO

NO
MPN_BORROWER_LAST_NAME Borrower's last name. VARCHAR2(63)

NA

RLRDMPN

NULL

RLRDMPN_BORROWER_LAST_NAME

NO

NO

NO
MPN_BORROWER_MIDDLE_NAME Borrower's middle name. VARCHAR2(63)

NA

RLRDMPN

NULL

RLRDMPN_BORROWER_MI

NO

NO

NO
MPN_BORROWER_SSN Borrower's social security number. VARCHAR2(63)

NA

RLRDMPN

NULL

RLRDMPN_BORROWER_SSN

NO

NO

NO
MPN_DOCUMENT_ID Master promissory note record's document identification. VARCHAR2(63)

RLRDMPN

RPRLAPP

RLRDMPN_DOCUMENT_ID

RPRLAPP_MPN_DOCUMENT_ID

NO

NO

NO
MPN_EXPIRATION_DATE Master promissory note expiration date. DATE

RLRDMPN

RPRLAPP

RLRDMPN_EXP_DATE

RPRLAPP_MPN_EXP_DATE

NO

NO

NO
MPN_EXPIRATION_REASON COD reason why the master promissory note expired. VARCHAR2(63)

RLRDMPN

RPRLAPP

RLRDMPN_EXP_REASON

RPRLAPP_MPN_EXP_CODE

NO

NO

NO
MPN_EXPIRATION_REASON_DESC COD reason description why the master promissory note expired. VARCHAR2(255)

RLRDMPN

RPRLAPP

RLRDMPN_EXP_DESC

RPRLAPP_MPN_EXP_DESC

NO

NO

NO
MPN_ID Identification number printed on the master promissory note associated with this loan. VARCHAR2(63)

RLRDLOR

RPRLAPP

RLRDLOR_MPN_ID

RPRLAPP_MPN_ID

NO

NO

NO
MPN_LINKED_IND COD's acknowledgement that this origination is linked to the MPN ID at COD. VARCHAR2(1)

NA

RLRDLOR

NULL

RLRDLOR_LINKED_IND

NO

NO

NO
MPN_SEQUENCE_NUMBER Master promissory note sequence number. NUMBER

NA

RLRDMPN

NULL

RLRDMPN_SEQ_NO

NO

NO

NO
MPN_SINGLE_LOAN_IND Indicates whether the MPN is for the linked Origination which has an endorser and may not be used for additional loans. VARCHAR2(1)

NA

RLRDMPN

NULL

RLRDMPN_SINGLE_LOAN_IND

NO

NO

NO
MPN_SINGLE_YEAR_AID_YEAR Aid year code associated with this Direct Loan MPN when processing Single Year MPNs. VARCHAR2(63)

NA

RLRDMPN

NULL

RLRDMPN_AIDY_CODE_SY

NO

NO

NO
MPN_SINGLE_YEAR_AID_YEAR_DESC Financial aid year name. VARCHAR2(255)

NA

ROBINST

NULL

ROBINST_AIDY_DESC

NO

NO

NO
MPN_STATUS_DATE Master promissory note status effective date. DATE

NA

RLRDMPN

NULL

RLRDMPN_MPN_STATUS_EFF_DATE

NO

NO

NO
MPN_STUDENT_BIRTH_DATE Student's birth date. DATE

NA

RLRDMPN

NULL

RLRDMPN_BIRTH_DATE

NO

NO

NO
MPN_STUDENT_FIRST_NAME Student's first name. VARCHAR2(63)

NA

RLRDMPN

NULL

RLRDMPN_FIRST_NAME

NO

NO

NO
MPN_STUDENT_LAST_NAME Student's last name. VARCHAR2(63)

NA

RLRDMPN

NULL

RLRDMPN_LAST_NAME

NO

NO

NO
MPN_STUDENT_MIDDLE_NAME Student's middle name. VARCHAR2(63)

NA

RLRDMPN

NULL

RLRDMPN_MI

NO

NO

NO
MPN_STUDENT_SSN Student's social security number. VARCHAR2(63)

NA

RLRDMPN

NULL

RLRDMPN_SSN

NO

NO

NO
MPN_TYPE Master promissory note type. VARCHAR2(63)

NA

RLRDMPN

NULL

RLRDMPN_MPN_TYPE

NO

NO

NO
MPN_TYPE_DESC Master promissory note type desc. VARCHAR2(255)

FUNCTION

NA

ROKODSF.F_GET_RORMVAL_DESC

NULL

NO

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
NATION Nation/country code associated with the address of the borrower. VARCHAR2(63)

RERCODA

RPRLAPP

RERCODA_CDNT_CODE

RPRLAPP_NATN_CODE

NO

NO

NO
NATION_DESC Address nation/country description. VARCHAR2(255)

STVNATN

STVNATN_NATION

NO

NO
NOTIFICATION_BOOK_AMOUNT Total net amount of the first disbursement accepted and booked for the loan. NUMBER

NA

RLRDLBN

NULL

RLRDLBN_BOOK_AMOUNT

NO

NO

NO
NOTIFICATION_BOOK_DATE Date the loan booked at COD. DATE

RLRDLBN

RPRLAPP

RLRDLBN_BOOK_DATE

RPRLAPP_BOOK_DATE

NO

NO

NO
NOTIFICATION_DOCUMENT_ID Document identification number for the document in which the loan's booking information was received. VARCHAR2(63)

RLRDLBN

RPRLAPP

RLRDLBN_DOCUMENT_ID

RPRLAPP_BOOK_DOCUMENT_ID

NO

NO

NO
ORIGINAL_CREDIT_STATUS Loan application original credit status. VARCHAR2(63)

RLRPLUS

RPRLAPP

RLRPLUS_ORIG_CREDIT_STATUS

RPRLAPP_ORIG_CREDIT_STATUS

NO

NO

NO
ORIGINAL_CREDIT_STATUS_DESC Loan application original credit status description. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
ORIGINATION_DOCUMENT_ID Loan's initial origination document identification number as sent to COD. VARCHAR2(63)

RLRDLOR

RPRLAPP

RLRDLOR_DOCUMENT_ID

RPRLAPP_DOCUMENT_ID

NO

NO

NO
OTHER_LOANS_LOAN_PERIOD Borrower's total other student educational loan debt for the requested loan period. NUMBER

RPRLAPP

RPRLAPP_OTH_LOANS_PERIOD

NO

NO
OTHER_LOAN_DEBT Borrower's total other student educational loan debt prior to the requested loan period. NUMBER

RPRLAPP

RPRLAPP_OTHER_DEBT

NO

NO
OWES_REFUND_IND Indicates whether the student owes a refund on a federal title iv grant as reported in the student's need analysis record. VARCHAR2(63)

NA

RPRLAPP

NULL

RPRLAPP_OWES_REFUND

NO

NO

NO
PARENT_ALIEN_REG_NUMBER Alien registration of the parent when a direct loan is of a parent type. VARCHAR2(63)

NA

RPRLAPP

NULL

RPRLAPP_PAR_ALIEN_REG_NO

NO

NO

NO
PARENT_BIRTH_DATE Birth date of the parent when a direct loan is of a parent type. DATE

RLRCBID

RPRLAPP

RLRCBID_BIRTH_DATE

RPRLAPP_PAR_BIRTH_DATE

NO

NO

NO
PARENT_CITIZEN_IND Citizen indicator of the parent when a direct loan is of a parent type. VARCHAR2(63)

RLRDBOR

RPRLAPP

RLRDBOR_CITZ_IND

RPRLAPP_PAR_CITZ_IND

NO

NO

NO
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

NO

NO

NO
PARENT_DEFAULT_IND Indicates whether the borrower of a direct loan is in default or owes a refund on a grant. VARCHAR2(63)

RLRDBOR

RPRLAPP

RLRDBOR_IN_DEFAULT

RPRLAPP_PAR_IN_DEFAULT

NO

NO

NO
PARENT_DRIVER_LICENSE_NUMBER Driver license number of the parent when a direct loan is of a parent type. VARCHAR2(63)

RLRDBOR

RPRLAPP

RLRDBOR_DRIVER_LIC_NO

RPRLAPP_PAR_DRIVER_LIC_NO

NO

NO

NO
PARENT_DRIVER_LIC_STATE_PROV State/province issuing the driver's license when a direct loan is of a parent type. VARCHAR2(63)

RLRDBOR

RPRLAPP

RLRDBOR_CDST_CODE_LIC

RPRLAPP_PAR_STAT_CODE_LIC

NO

NO

NO
PARENT_DRIVER_LIC_ST_PR_DESC Name of the state/province license code of the parent when a direct loan is of a parent type. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

NO

NO
PARENT_FIRST_NAME First name of the parent when a direct loan is of a parent type. VARCHAR2(63)

RLRDBOR

RPRLAPP

RLRDBOR_FIRST_NAME

RPRLAPP_PAR_FIRST_NAME

NO

NO

NO
PARENT_LAST_NAME Last name of the parent when a direct loan is of a parent type. VARCHAR2(63)

RLRCBID

RPRLAPP

RLRCBID_LAST_NAME

RPRLAPP_PAR_LAST_NAME

NO

NO

NO
PARENT_LOCAL_CITY City in the local address of the parent when a direct loan is of a parent type. VARCHAR2(63)

RLRDBOR

RPRLAPP

RLRDBOR_LOCAL_CITY

RPRLAPP_PAR_LOCAL_CITY

NO

NO

NO
PARENT_LOCAL_NATION Nation/country associated with the local address of the parent when a direct loan is of a parent type. VARCHAR2(63)

RLRDBOR

RPRLAPP

RLRDBOR_LOCAL_CDNT_CODE

RPRLAPP_PAR_LOCAL_NATN_CODE

NO

NO

NO
PARENT_LOCAL_NATION_DESC Nation/country description for the parent's local address when a direct loan is of a parent type. VARCHAR2(255)

STVNATN

STVNATN_NATION

NO

NO
PARENT_LOCAL_POSTAL_CODE Postal code in the local address of the parent when a direct loan is of a parent type. VARCHAR2(63)

RLRDBOR

RPRLAPP

RLRDBOR_LOCAL_ZIP

RPRLAPP_PAR_LOCAL_ZIP

NO

NO

NO
PARENT_LOCAL_STATE_PROVINCE State/province in the local address of the parent when a direct loan is of a parent type. VARCHAR2(63)

RLRDBOR

RPRLAPP

RLRDBOR_LOCAL_CDST_CODE

RPRLAPP_PAR_LOCAL_STAT_CODE

NO

NO

NO
PARENT_LOCAL_STATE_PR_DESC Local address state/province description for the parent when a direct loan is of a parent type. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

NO

NO
PARENT_LOCAL_STREET_LINE1 First line of the parent's local address when a direct loan is of a parent type. VARCHAR2(255)

RLRDBOR

RPRLAPP

RLRDBOR_LOCAL_ADDRESS

RPRLAPP_PAR_LOCAL_ADDRESS

NO

NO

NO
PARENT_LOCAL_STREET_LINE2 Second line of parent's local street address. VARCHAR2(255)

RLRDBOR

RPRLAPP

RLRDBOR_LOCAL_ADDR_LINE2

RPRLAPP_PAR_LOCAL_ADDR_LINE2

NO

NO

NO
PARENT_LOCAL_STREET_LINE3 Third line of parent's local street address. VARCHAR2(255)

RLRDBOR

RPRLAPP

RPRLAPP_PAR_LOCAL_ADDR_LINE3

RPRLAPP_PAR_LOCAL_ADDR_LINE3

NO

NO

NO
PARENT_LOCAL_STREET_LINE4 Fourth line of parent's local street address. VARCHAR2(255)

NA

NULL

NO

NO
PARENT_MIDDLE_INITIAL Middle initial of the parent when a direct loan is of a parent type. VARCHAR2(63)

RLRDBOR

RPRLAPP

RLRDBOR_MI

RPRLAPP_PAR_MI

NO

NO

NO
PARENT_NATION Nation/country associated with the address of the parent of the borrower when the loan is of a parent type. VARCHAR2(63)

RLRDBOR

RPRLAPP

RLRDBOR_PERM_CDNT_CODE

RPRLAPP_PAR_NATN_CODE

NO

NO

NO
PARENT_NATION_DESC Nation/country description for the borrower's parent's address when the loan is of a parent type. VARCHAR2(255)

STVNATN

STVNATN_NATION

NO

NO
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

NO

NO

NO
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

NO

NO

NO
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

NO

NO

NO
PARENT_STATE_PROVINCE_DESC Name of the state/province of the parent when a direct loan is of a parent type. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

NO

NO
PARENT_STATE_PROVINCE_OF_RES State/Province in which the parent of the applicant is a legal resident. VARCHAR2(63)

NA

RPRLAPP

NULL

RPRLAPP_PAR_STAT_CODE_RES

NO

NO

NO
PARENT_STATE_PROV_OF_RES_DESC Name of the state/province of the state in which the parent of the applicant is a legal resident. VARCHAR2(255)

NA

STVSTAT

NULL

STVSTAT_DESC

NO

NO

NO
PARENT_STREET_LINE1 Address of the parent when a direct loan is of a parent type. VARCHAR2(255)

RLRDBOR

RPRLAPP

RLRDBOR_PERM_ADDRESS

RPRLAPP_PAR_ADDRESS

NO

NO

NO
PARENT_STREET_LINE2 Second line of parent's permanent street address. VARCHAR2(255)

RLRDBOR

RPRLAPP

RLRDBOR_PERM_ADDR_LINE2

RPRLAPP_PAR_ADDR_LINE2

NO

NO

NO
PARENT_STREET_LINE3 Third line of parent's permanent street address. VARCHAR2(255)

RLRDBOR

RPRLAPP

RLRDBOR_PERM_ADDR_LINE3

RPRLAPP_PAR_ADDR_LINE3

NO

NO

NO
PARENT_STREET_LINE4 Fourth line of parent's permanent street address. VARCHAR2(255)

NA

NULL

NO

NO
PARENT_TAX_ID Tax identification number or social security number of the parent when a direct loan is of a parent type. VARCHAR2(63)

RLRCBID

RPRLAPP

RLRCBID_SSN

RPRLAPP_PAR_SSN

NO

NO

NO
PERKINS_LOAN_DEBT Borrower's total Perkins loan debt prior to the loan period. NUMBER

RPRLAPP

RPRLAPP_PERKINS_DEBT

NO

NO
PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

RLRDLOR

RPRLAPP

RLRDLOR_PIDM

RPRLAPP_PIDM

NO

NO

NO
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

NO

NO

NO
PLUS_APPLICATION_REASON Reason the PLUS Application was submitted. VARCHAR2(255)

RLRPAPP

RPRLAPP

RLRPAPP_PLUS_APP_REASON

RPRLAPP_PLUS_APP_REASON

NO

NO

NO
PLUS_BORROWER_ID PLUS borrower system assigned identifier number. VARCHAR2(63)

RLRDBOR

RPRLAPP

RLRDBOR_BORROWER_ID_NO

RPRLAPP_PLUS_BORROWER_ID_NO

NO

NO

NO
PLUS_CREDIT_CHECK_DATE Date a credit check was performed for a direct loan for this student. DATE

RLRPLUS

RPRLAPP

RLRPLUS_CREDIT_CHECK_DATE

RPRLAPP_CREDIT_CHECK_DATE

NO

NO

NO
PLUS_CREDIT_CHECK_STATUS Status of the plus loan credit check on the parent. VARCHAR2(63)

RLRPLUS

RPRLAPP

RLRPLUS_CREDIT_CHECK_IND

RPRLAPP_CREDIT_CHECK_IND

NO

NO

NO
PLUS_CREDIT_CHECK_STATUS_DESC PLUS loan credit check status description. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
PLUS_LOAN_APPLICATION_ID PLUS application ID associated with this loan. NUMBER

RLRPLUS

RPRLAPP

RLRPLUS_PLUS_APP_ID

RPRLAPP_APPL_ID

NO

NO

NO
PLUS_PREVIOUS_APPLICATION_ID Previously submitted PLUS Application ID. VARCHAR2(63)

RLRPAPP

RPRLAPP

RLRPAPP_PREVIOUS_APP_ID

RPRLAPP_PREVIOUS_APP_ID

NO

NO

NO
POSTAL_CODE Postal code in the address of the borrower of a direct loan. VARCHAR2(63)

RERCODA

RPRLAPP

RERCODA_ZIP

RPRLAPP_ZIP

NO

NO

NO
PREP_TEACHER_CERTIFICATION 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

RPRLAPP

RLRDLOR_PREP_OR_TEACH_IND

RPRLAPP_PREP_OR_TEACH_IND

NO

NO

NO
PREP_TEACH_CERTIFICATION_DESC Preparation or teacher certification coursework description. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
PROCESSING_APP_PHASE_CRNT_LOAN Current processing phase for the application or loan. VARCHAR2(63)

NA

RPRLAPP

NULL

RPRLAPP_APP_PHASE_CDE

NO

NO

NO
PROCESS_DATE Date the loan application was processed. DATE

RLRDLOR

RPRLAPP

RLRDLOR_PROCESS_DATE

RPRLAPP_PROCESS_DATE

NO

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_OF_STUDY Program of study attributed to the origination record. Only valid for foreign schools processing Direct Loan funds. No longer used after Financial Aid release 8.22.1. VARCHAR2(63)

NA

RPRLAPP

NULL

RPRLAPP_PROGRAM_OF_STUDY

NO

NO

NO
PROGRAM_OF_STUDY_DESC Program of study description. No longer used after Financial Aid release 8.22.1. VARCHAR2(255)

FUNCTION

NA

ROKODSF.F_GET_RORMVAL_DESC

NULL

NO

NO

NO
PROGRAM_SEQUENCE_LOCK_IND Indicates whether the student program information sequence is locked for the loan origination record. VARCHAR2(1)

RLRDLOR

RPRLAPP

RLRDLOR_SPGM_LOCK_IND

RPRLAPP_SPGM_LOCK_IND

NO

NO

NO
PROGRAM_SEQUENCE_NUMBER Program information record sequence number for this origination. NUMBER

RLRDLOR

RPRLAPP

RLRDLOR_SPGM_SEQ_NO

RPRLAPP_SPGM_SEQ_NO

NO

NO

NO
PROMISSORY_NOTE_DATE Date the borrower signed the promissory note for the loan. DATE

NA

RPRLAPP

NULL

RPRLAPP_PN_DATE

NO

NO

NO
RECORD_TYPE Record type indicator for passing information to the loan application server. VARCHAR2(63)

NA

RPRLAPP

NULL

RPRLAPP_RECORD_TYPE

NO

NO

NO
REPAYMENT_OPTION_CODE Type of repayment option requested by the borrower. VARCHAR2(63)

RPRLAPP

RPRLAPP_REPAY_OPT_IND

NO

NO
REQUESTED_AWARD_END_DATE End date for which the borrower is requesting the PLUS loan. DATE

RLRPAPP

RPRLAPP

RLRPAPP_REQ_AWARD_END_DATE

RPRLAPP_REQ_AWARD_END_DATE

NO

NO

NO
REQUESTED_AWARD_START_DATE Start date for which the borrower is requesting the PLUS loan. DATE

RLRPAPP

RPRLAPP

RLRPAPP_REQ_AWARD_START_DATE

RPRLAPP_REQ_AWARD_START_DATE

NO

NO

NO
SAR_TRANSACTION_NUMBER Eligible SAR transaction number reported with the origination record. VARCHAR2(63)

RLRDLOR

RPRLAPP

RLRDLOR_SAR_TRAN_NO

RPRLAPP_SAR_TRAN_NO

NO

NO

NO
SCHEDULED_ACADEMIC_YEAR Scheduled Academic Year. VARCHAR2(63)

NA

RLRDLOR

NULL

RLRDLOR_SAYR_CODE

NO

NO

NO
SCHEDULED_ACADEMIC_YEAR_DESC Scheduled Academic Year description. VARCHAR2(255)

NA

RTVSAYR

NULL

RTVSAYR_DESC

NO

NO

NO
SERVICER_CONFIRMATION_DATE Service provider confirmation date. DATE

RLRDLOR

RPRLAPP

RLRDLOR_PROCESS_DATE

RPRLAPP_CONF_DATE

NO

NO

NO
SLS_LOAN_DEBT Borrower's total federal SLS loan debt prior to the loan period and should include the federal SLS loan portion of the borrower's federal consolidation loan. NUMBER

RPRLAPP

RPRLAPP_SLS_LOAN_DEBT

NO

NO
STAFFORD_LOAN_DEBT Borrower's total federal Stafford loan debt prior to the loan period and should include the federal Stafford loan portion of the borrower's federal consolidation loan. NUMBER

RPRLAPP

RPRLAPP_STAF_LOAN_DEBT

NO

NO
STATE_PROVINCE State or province associated with this address. VARCHAR2(63)

RERCODA

RPRLAPP

RERCODA_CDST_CODE

RPRLAPP_STATE

NO

NO

NO
STATE_PROVINCE_DESC State/province name. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

NO

NO
STREET_LINE1 First line of the address. VARCHAR2(255)

RERCODA

RPRLAPP

RERCODA_ADDR_LINE1

RPRLAPP_ADDRESS

NO

NO

NO
STREET_LINE2 Second line of the address. VARCHAR2(255)

RERCODA

RPRLAPP

RERCODA_ADDR_LINE2

RPRLAPP_ADDR_LINE2

NO

NO

NO
STREET_LINE3 Third line of the address. VARCHAR2(255)

RERCODA

RPRLAPP

RERCODA_ADDR_LINE3

RPRLAPP_ADDR_LINE3

NO

NO

NO
STREET_LINE4 Fourth line of the address. VARCHAR2(255)

NA

NULL

NO

NO
SUBMISSION_DATE Date the loan application was submitted. DATE

NA

RPRLAPP

NULL

RPRLAPP_SUB_DATE

NO

NO

NO
TAX_ID Student's tax identification number assigned by their home federal government as reported on the loan application. VARCHAR2(63)

CALCULATION

CALCULATION

NVL(RERCSID_SSN, MGKFUNC.F_GET_PERSON_INFO)

NVL(RPRLAPP_SSN, MGKFUNC.F_GET_PERSON_INFO)

NO

NO

NO
XREF_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

NO

NO

NO
YEAR_IN_COLLEGE Year of study (first, second, etc.) that the student is enrolled for this origination. VARCHAR2(63)

RLRDLOR

RPRLAPP

RLRDLOR_YR_IN_COLL

RPRLAPP_YR_IN_COLL

NO

NO

NO
YEAR_IN_COLLEGE_DESC Year of study (first, second, etc.) that the student is enrolled for this origination. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO


Ver: 9.2