Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_YEAR_END_DATE	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
ACADEMIC_YEAR_START_DATE	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
ADDITIONAL_STAFFORD_ELIG_IND	Additional Stafford Elig Indicator	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
ADDL_UNSUBSIDIZED_ELIG_IND	Additional Unsubsidized Eligible Indicator	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
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
AGENCY_RETURN_ID	Agency Return ID	Person's identification used to adjust the record.	VARCHAR2(63)	NA SPRIDEN	NULL SPRIDEN_ID
AGENCY_RETURN_NAME	Agency Return Name	Name of the agency/lender to whom unused funds are to be returned.	VARCHAR2(255)	FUNCTION NA	F_FORMAT_NAME NULL
AID_YEAR	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
AID_YEAR_DESC	Aid Year Description	Financial aid year name.	VARCHAR2(255)	ROBINST	ROBINST_AIDY_DESC
ALIEN_REGISTRATION_NUMBER	Alien Registration Number	Student's alien registration number (when applicable).	VARCHAR2(63)	NA RPRLAPP	NULL RPRLAPP_ALIEN_REG_NO
ALT_LOAN_BORROWER_LOAN_DEBT	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
ALT_LOAN_PROGRAM_TYPE	Alt Loan Program Type	Indicates the specific category of alternative loan for reporting.	VARCHAR2(63)	RPRLAPP	RPRLAPP_ALT_LOAN_PROG_TYPE_CDE
ALT_LOAN_STUDENT_BORROWER_IND	Alt Loan Student Borrower Indicator	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
APPLICANT_LOAN_REQUESTED_AMT	Applicant Loan Requested Amount	Amount of loan requested by the applicant. This amount cannot be negative or zero.	NUMBER	RLRPLUS RPRLAPP	RLRPLUS_REQUEST_AMT RPRLAPP_REQUEST_AMT
APPLICATION_ACTIVITY_DATE	Application Activity Date	Date record was inserted or updated.	DATE	RLRDLOR RPRLAPP	RLRDLOR_ACTIVITY_DATE RPRLAPP_ACTIVITY_DATE
APPLICATION_COMPLETE_DATE	Application Completion Date	Date the loan application was completed.	DATE	RLRPAPP RPRLAPP	RLRPAPP_APP_COMP_DATE RPRLAPP_APP_COMP_DATE
APPLICATION_DATA_ORIGIN	Application Data Origin	Source system that last created or updated the data.	VARCHAR2(63)	RLRDLOR RPRLAPP	RLRDLOR_DATA_ORIGIN RPRLAPP_DATA_ORIGIN
APPLICATION_LOAN_AMOUNT	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
APPLICATION_USER_ID	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
APPROVED_AMOUNT	Approved Amount	Loan amount that was approved by the approving agency.	NUMBER	RLRDLOR RPRLAPP	RLRDLOR_LOAN_AMT RPRLAPP_APPROVE_AMT
APPROVED_DATE	Approved Date	Date the loan was approved by the approving agency.	DATE	NA RPRLAPP	NULL RPRLAPP_APPROVE_DATE
BATCH_ID_FOR_DIRECT_LOAN	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
BBAY_TYPE	Bbay Type	Borrower-Based Academic Year type.	VARCHAR2(63)	NA ROBBBAY	NULL ROBBBAY_BBTP_CODE
BBAY_TYPE_DESC	Bbay Type Description	Borrower-Based Academic Year type description.	VARCHAR2(255)	NA RTVBBTP	NULL RTVBBTP_DESC
BIRTH_DATE	Birth Date	Student's birth date.	DATE	RLRCBID RPRLAPP	RERCSID_BIRTH_DATE RPRLAPP_BIRTH_DATE
BORROWER_ANNUAL_INCOME	Borrower Annual Income	Total income earned by the borrower from his or her primary employment.	NUMBER	RPRLAPP	RPRLAPP_BOR_GROSS_YR_SAL
BORROWER_BASED_ACADEMIC_YEAR	Borrower Based Academic Year	Borrower-Based Academic Year.	VARCHAR2(63)	NA RLRDLOR	NULL RLRDLOR_BBAY_CODE
BORROWER_BASED_ACAD_YEAR_DESC	Borrower Based Academic Year Description	Borrower-Based Academic Year description.	VARCHAR2(255)	NA ROBBBAY	NULL ROBBBAY_DESC
BORROWER_EMAIL_ADDRESS	Borrower Email Address	Parent borrower's email address.	VARCHAR2(255)	RLRDBOR RPRLAPP	RLRDBOR_EMAIL RPRLAPP_BORROWER_EMAIL
BORROWER_OTHER_INCOME	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
CANCEL_INACTIVATED_DATE	Cancel Inactivated Date	Date a direct loan cancel/inactive indicator changed for this student.	DATE	NA RPRLAPP	NULL RPRLAPP_CANCEL_DATE
CANCEL_INACTIVATED_IND	Cancel Inactivated Indicator	Date a direct loan cancel/inactive indicator changed for this student.	VARCHAR2(63)	NA RPRLAPP	NULL RPRLAPP_CANCEL_IND
CERTIFICATION_DATE	Certification Date	Date that the loan application was certified.	DATE	NA RPRLAPP	NULL RPRLAPP_CERT_DATE
CITIZEN_IND	Citizen Indicator	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
CITY	City	Address city, town or municipality.	VARCHAR2(63)	RERCODA RPRLAPP	RERCODA_CITY RPRLAPP_CITY
COMMONLINE_APP_VERSION_NUMBER	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
COMMONLINE_LOAN_DATE_SENT	Commonline Loan Date Sent	Date the loan was sent to the loan service provider (common line).	DATE	NA RPRLAPP	NULL RPRLAPP_EL_DATE_SENT
COMMONLINE_LOAN_ID	Commonline Loan ID	Loan identification number used by electronic loan processing (common line).	VARCHAR2(63)	NA RPRLAPP	NULL RPRLAPP_EL_LOAN_ID
COMMONLINE_LOAN_SEQ_NUMBER	Commonline Loan Sequence Number	Sequence number used by electronic loan processing (common line) to further identify the loan.	NUMBER	NA RPRLAPP	NULL RPRLAPP_EL_SEQ_NO
COMMONLINE_LOAN_STATUS	Commonline Loan Status	Status of a loan processed via electronic loan processing (common line).	VARCHAR2(63)	NA RPRLAPP	NULL RPRLAPP_EL_STATUS
COMMONLINE_PROCESSING_STATUS	Commonline Processing Status	Status of the common line application process for this record.	VARCHAR2(63)	RLRDLOR RPRLAPP	RLRDLOR_LNST_CODE RPRLAPP_LNST_CODE
COSIGN1_ANNUAL_INCOME	Cosign 1 Annual Income	Total income earned by cosigner 1 from his or her primary employment.	NUMBER	RPRLAPP	RPRLAPP_COSIGN1_GROSS_YR_SAL
COSIGN1_BIRTH_DATE	Cosign 1 Birth Date	First cosigner's date of birth.	DATE	RPRLAPP	RPRLAPP_COSIGN1_BIRTH_DATE
COSIGN1_CITIZEN_IND	Cosign 1 Citizen Indicator	A 1-digit code indicating the first cosigner's citizenship status.	VARCHAR2(63)	RPRLAPP	RPRLAPP_COSIGN1_CITZ_IND
COSIGN1_CITY	Cosign 1 City	City of the first cosigner's last known address.	VARCHAR2(63)	RPRLAPP	RPRLAPP_COSIGN1_CITY
COSIGN1_DR_LIC_NUMBER	Cosign 1 Dr Lic Number	First cosigner's driver's license number.	VARCHAR2(63)	RPRLAPP	RPRLAPP_COSIGN1_DRIVER_LIC_NO
COSIGN1_DR_LIC_STATE_DESC	Cosign 1 Dr Lic State Description	Name of the state/province that issued the first cosigner's driver's license.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
COSIGN1_DR_LIC_STATE_PROV	Cosign 1 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
COSIGN1_FIRST_NAME	Cosign 1 First Name	First name of the cosigner.	VARCHAR2(63)	RPRLAPP	RPRLAPP_COSIGN1_FIRST_NAME
COSIGN1_FOREIGN_POSTAL_CODE	Cosign 1 Foreign Postal Code	Foreign postal code of the cosigner's last known address.	VARCHAR2(63)	RPRLAPP	RPRLAPP_COSIGN1_FOR_POST_CDE
COSIGN1_LAST_NAME	Cosign 1 Last Name	Last name of the cosigner.	VARCHAR2(63)	RPRLAPP	RPRLAPP_COSIGN1_LAST_NAME
COSIGN1_MIDDLE_INITIAL	Cosign 1 Middle Initial	Middle initial of the cosigner.	VARCHAR2(63)	RPRLAPP	RPRLAPP_COSIGN1_MI
COSIGN1_OTHER_INCOME	Cosign 1 Other Income	Total income earned by cosigner 1 from a source other than his or her primary employment.	NUMBER	RPRLAPP	RPRLAPP_COSIGN1_OTH_INC
COSIGN1_PHONE_NUMBER_COMBINED	Cosign 1 Phone Number Combined	First cosigner's last known telephone home number. Includes the area code.	VARCHAR2(63)	RPRLAPP	RPRLAPP_COSIGN1_PHONE_NO
COSIGN1_POSTAL_CODE	Cosign 1 Postal Code	Postal code of the cosigner's last known address.	VARCHAR2(63)	RPRLAPP	RPRLAPP_COSIGN1_ZIP
COSIGN1_RELATIONSHIP	Cosign 1 Relationship	First cosigner's relationship to the student.	VARCHAR2(63)	RPRLAPP	RPRLAPP_COSIGN1_RELATION_IND
COSIGN1_RELATIONSHIP_DESC	Cosign 1 Relationship Description	Cosigner's relationship description.	VARCHAR2(255)	CALCULATION	DECODE(RPRLAPP_COSIGN1_RELATION_IND)
COSIGN1_SIGNATURE_IND	Cosign 1 Signature Indicator	A 1-character code indicating if the signature of the first cosigner is present.	VARCHAR2(63)	RPRLAPP	RPRLAPP_COSIGN1_SIGNED_IND
COSIGN1_STATE_PROVINCE	Cosign 1 State Province	2-character state abbreviation of the first cosigner's last known address.	VARCHAR2(63)	RPRLAPP	RPRLAPP_COSIGN1_STAT_CODE
COSIGN1_STATE_PROVINCE_DESC	Cosign 1 State Province Description	Name of the state/province of the first cosigner's last known address.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
COSIGN1_STREET_LINE1	Cosign 1 Street Line 1	First line of the first cosigner's last known address.	VARCHAR2(255)	RPRLAPP	RPRLAPP_COSIGN1_ADDR_LINE1
COSIGN1_STREET_LINE2	Cosign 1 Street Line 2	Second line of the first cosigner's last known address.	VARCHAR2(255)	RPRLAPP	RPRLAPP_COSIGN1_ADDR_LINE2
COSIGN1_SUFFIX	Cosign 1 Suffix	Suffix of the first cosigner's name.	VARCHAR2(63)	RPRLAPP	RPRLAPP_COSIGN1_SUFFIX
COSIGN1_TAX_ID	Cosign 1 Tax ID	Tax identification number or social security number of the cosigner.	VARCHAR2(63)	RPRLAPP	RPRLAPP_COSIGN1_SSN
COSIGN1_YRS_AT_ADDRESS	Cosign 1 Yrs At Address	Indicates the number of years the first cosigner has been at his/her address.	NUMBER	RPRLAPP	RPRLAPP_COSIGN1_YR_ADDRESS
COSIGN2_ANNUAL_INCOME	Cosign 2 Annual Income	Total income earned by cosigner 2 from his or her primary employment.	NUMBER	RPRLAPP	RPRLAPP_COSIGN2_GROSS_YR_SAL
COSIGN2_BIRTH_DATE	Cosign 2 Birth Date	Second cosigner's date of birth.	DATE	RPRLAPP	RPRLAPP_COSIGN2_BIRTH_DATE
COSIGN2_CITIZEN_IND	Cosign 2 Citizen Indicator	A 1-digit code indicating the second cosigner's citizenship status.	VARCHAR2(63)	RPRLAPP	RPRLAPP_COSIGN2_CITZ_IND
COSIGN2_CITY	Cosign 2 City	City of the second cosigner's last known address.	VARCHAR2(63)	RPRLAPP	RPRLAPP_COSIGN2_CITY
COSIGN2_DR_LIC_NUMBER	Cosign 2 Dr Lic Number	Second cosigner's driver's license number.	VARCHAR2(63)	RPRLAPP	RPRLAPP_COSIGN2_DRIVER_LIC_NO
COSIGN2_DR_LIC_STATE_DESC	Cosign 2 Dr Lic State Description	Name of the state/province that issued the second cosigner's driver's license.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
COSIGN2_DR_LIC_STATE_PROV	Cosign 2 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
COSIGN2_FIRST_NAME	Cosign 2 First Name	First name of the cosigner.	VARCHAR2(63)	RPRLAPP	RPRLAPP_COSIGN2_FIRST_NAME
COSIGN2_FOREIGN_POSTAL_CODE	Cosign 2 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
COSIGN2_LAST_NAME	Cosign 2 Last Name	Last name of the cosigner.	VARCHAR2(63)	RPRLAPP	RPRLAPP_COSIGN2_LAST_NAME
COSIGN2_MIDDLE_INITIAL	Cosign 2 Middle Initial	Middle initial of the second cosigner.	VARCHAR2(63)	RPRLAPP	RPRLAPP_COSIGN2_MI
COSIGN2_OTHER_INCOME	Cosign 2 Other Income	Total income earned by cosigner 2 from a source other than his or her primary employment.	NUMBER	RPRLAPP	RPRLAPP_COSIGN2_OTH_INC
COSIGN2_PHONE_NUMBER_COMBINED	Cosign 2 Phone Number Combined	Second cosigner's last known telephone home number. Includes the area code.	VARCHAR2(63)	RPRLAPP	RPRLAPP_COSIGN2_PHONE_NO
COSIGN2_POSTAL_CODE	Cosign 2 Postal Code	Postal code of the cosigner's last known address.	VARCHAR2(63)	RPRLAPP	RPRLAPP_COSIGN2_ZIP_CODE
COSIGN2_RELATIONSHIP	Cosign 2 Relationship	Second cosigner's relationship to the student.	VARCHAR2(63)	RPRLAPP	RPRLAPP_COSIGN2_RELATION_IND
COSIGN2_RELATIONSHIP_DESC	Cosign 2 Relationship Description	Description of the second cosigner's relationship to the student.	VARCHAR2(255)	CALCULATION	DECODE(RPRLAPP_COSIGN2_RELATION_IND)
COSIGN2_SIGNATURE_IND	Cosign 2 Signature Indicator	A 1-character code indicating if the signature of the second cosigner is present.	VARCHAR2(63)	RPRLAPP	RPRLAPP_COSIGN2_SIGNED_IND
COSIGN2_STATE_PROVINCE	Cosign 2 State Province	State abbreviation of the second cosigner's last known address.	VARCHAR2(63)	RPRLAPP	RPRLAPP_COSIGN2_STAT_CODE
COSIGN2_STATE_PROVINCE_DESC	Cosign 2 State Province Description	Name of the state/province of the second cosigner's last known address.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
COSIGN2_STREET_LINE1	Cosign 2 Street Line 1	First line of the second cosigner's last known address.	VARCHAR2(255)	RPRLAPP	RPRLAPP_COSIGN2_ADDR_LINE1
COSIGN2_STREET_LINE2	Cosign 2 Street Line 2	Second line of the second cosigner's last known address.	VARCHAR2(255)	RPRLAPP	RPRLAPP_COSIGN2_ADDR_LINE2
COSIGN2_SUFFIX	Cosign 2 Suffix	Suffix of the second cosigner's name.	VARCHAR2(63)	RPRLAPP	RPRLAPP_COSIGN2_SUFFIX
COSIGN2_TAX_ID	Cosign 2 Tax ID	Tax identification number or social security number of the cosigner.	VARCHAR2(63)	RPRLAPP	RPRLAPP_COSIGN2_SSN
COSIGN2_YRS_AT_ADDRESS	Cosign 2 Yrs At Address	Number of years the second cosigner has been at his/her address.	NUMBER	RPRLAPP	RPRLAPP_COSIGN2_YR_ADDRESS
CREDIT_ACTION	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
CREDIT_ACTION_DESC	Credit Action Description	Credit action description.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
CREDIT_ACTION_STATUS	Credit Action Status	Status of credit action after being initially denied.	VARCHAR2(63)	NA RLRPLUS	NULL RLRPLUS_CR_ACTION_STATUS
CREDIT_ACTION_STATUS_DESC	Credit Action Status Description	Denied credit action status description.	VARCHAR2(255)	FUNCTION NA	ROKODSF.F_GET_RORMVAL_DESC NULL
CREDIT_APPLICATION_DOCUMENT_ID	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
CREDIT_BALANCE_OPTION_IND	Credit Balance Option Indicator	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
CREDIT_CHECK_APPEAL_STATUS	Credit Check Appeal Status	Credit check appeal status.	VARCHAR2(63)	RLRPLUS RPRLAPP	RLRPLUS_CR_APPEAL_STATUS RPRLAPP_CR_APPEAL_STATUS
CREDIT_CHECK_EXPIRATION_DATE	Credit Check Expiration Date	Date a credit check status expires.	DATE	RLRPLUS RPRLAPP	RLRPLUS_CREDIT_CHECK_EXP_DATE RPRLAPP_CREDIT_CHECK_EXP_DATE
CREDIT_CHECK_OVERRIDDEN	Credit Check Overridden	Indicates whether denies credit status has been overriden.	VARCHAR2(63)	RLRPLUS RPRLAPP	RLRPLUS_CR_OVERRIDE_CDE RPRLAPP_CR_OVERRIDE_CDE
CREDIT_CHECK_OVERRIDDEN_DESC	Credit Check Overridden Description	Credit check overridden description.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
CREDIT_CHK_APPEAL_STATUS_DESC	Credit Chk Appeal Status Description	Credit check appeal status description.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
CREDIT_IN_DIFFERENT_NAME_IND	Credit IN Different Name Indicator	Indicates the borrower has been granted credit under a different name.	VARCHAR2(63)	RPRLAPP	RPRLAPP_CRED_DIF_NM_IND
DEFAULT_IND	Default Indicator	Indicates whether this is the default type to be used.	VARCHAR2(63)	RLRDLOR RPRLAPP	RLRDLOR_IN_DEFAULT RPRLAPP_IN_DEFAULT
DEFAULT_IND_DESC	Default Indicator Description	Description of the loan default status.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
DEFERRED_PAYMENT_IND	Deferred Payment Indicator	Indicates whether applicant has chosen to defer payments.	VARCHAR2(1)	CALCULATION RLRPAPP	NVL(RPRLAPP_DEFERMENT_OPT,'N') NVL(RLRPAPP_DEFERMENT_OPT,'N')
DEPENDENCY_STATUS	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
DEPENDENCY_STATUS_DESC	Dependency Status Description	Dependency status description.	VARCHAR2(255)	CALCULATION FUNCTION	CASE WHEN RPRLAPP_MODEL_CDE ROKODSF.F_GET_RORMVAL_DESC
DIRECT_LOAN_DATE_SENT	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
DIRECT_LOAN_ID	Direct Loan ID	Identifies a specific loan application.	VARCHAR2(63)	RLRDLOR RPRLAPP	RLRDLOR_LOAN_ID RPRLAPP_DL_LOAN_ID
DIRECT_LOAN_NUMBER	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
DIRECT_LOAN_SCHOOL_CODE	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
DIRECT_LOAN_STATUS	Direct Loan Status	Origination status code, typically system maintained for direct loan applications.	VARCHAR2(63)	RLRDLOR RPRLAPP	RLRDLOR_STATUS RPRLAPP_DL_STATUS
DISCLOSURE_PRINT_DATE	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
DISCLOSURE_PRINT_IND	Disclosure Print Indicator	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
DISCLOSURE_REQUIRED_IND	Disclosure Required Indicator	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
DISCLOSURE_REQUIRED_IND_DESC	Disclosure Required Indicator Description	Disclosure required indicator description.	VARCHAR2(255)	CALCULATION FUNCTION	CASE WHEN RLRLAPP_DISC_NEED_PRINT_FLAG ROKODSF.F_GET_RORMVAL_DESC
DL_BOOKING_STATUS	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
DL_DISB_RECON_REJECT_1	Direct Loan Disb Reconciliation Rejection 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
DL_DISB_RECON_REJECT_2	Direct Loan Disb Reconciliation Rejection 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
DL_DISB_RECON_REJECT_3	Direct Loan Disb Reconciliation Rejection 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
DL_DISB_RECON_REJECT_4	Direct Loan Disb Reconciliation Rejection 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
DL_DISB_RECON_REJECT_5	Direct Loan Disb Reconciliation Rejection 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
DL_MPN_STATUS_DESC	Direct Loan Master Promissory Note Status Description	Direct loan status description.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
DL_MPN_STATUS_IND	Dl Mpn Status Indicator	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
DL_ORIGINATION_REJECT1_DESC	Direct Loan Origination Rejection 1 Description	First reject code description.	VARCHAR2(255)	RTVRJCT	RTVRJCT_DESC
DL_ORIGINATION_REJECT2_DESC	Direct Loan Origination Rejection 2 Description	Second reject code description.	VARCHAR2(255)	RTVRJCT	RTVRJCT_DESC
DL_ORIGINATION_REJECT3_DESC	Direct Loan Origination Rejection 3 Description	First third code description.	VARCHAR2(255)	RTVRJCT	RTVRJCT_DESC
DL_ORIGINATION_REJECT4_DESC	Direct Loan Origination Rejection 4 Description	Fourth reject code description.	VARCHAR2(255)	RTVRJCT	RTVRJCT_DESC
DL_ORIGINATION_REJECT5_DESC	Direct Loan Origination Rejection 5 Description	Fifth reject code description.	VARCHAR2(255)	RTVRJCT	RTVRJCT_DESC
DL_ORIGINATION_REJECT_1	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
DL_ORIGINATION_REJECT_2	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
DL_ORIGINATION_REJECT_3	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
DL_ORIGINATION_REJECT_4	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
DL_ORIGINATION_REJECT_5	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
DL_REBATE_FEE_PERCENT	Dl Rebate Fee Percent	Rebate fee percent.	NUMBER	DLRDLOR RPRLAPP	RLRDLOR_REBATE_PCT RPRLAPP_DL_REBATE_PERCENT
DRIVER_LICENSE_NUMBER	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
DRIVER_LICENSE_STATE_PROVINCE	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
DRIVER_LICENSE_ST_PR_DESC	Driver License St Pr Description	State/province description in which the student holds a drivers license.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
ELECTRONIC_MPN_IND	Electronic Master Promissory Note Indicator	Indicates whether the MPN is an electronic master promissory note or paper.	VARCHAR2(1)	NA RLRDMPN	NULL RLRDMPN_EMPN_IND
EMAIL_ADDRESS	Email Address	Preferred email address.	VARCHAR2(255)	RERCODS RPRLAPP	RERCODS_EMAIL RPRLAPP_STU_EMAIL
ENDORSER_AMOUNT	Endorser Amount	Loan amount signed for by the endorser on the Endorser Addendum.	NUMBER	RLRPLUS RPRLAPP	RLRPLUS_ENDORSER_AMT RPRLAPP_PAR_ENDORSER_AMT
ENROLL_START_DATE	Enrollment Start Date	Enrollment start date. No longer used after Financial Aid release 8.22.1.	DATE	NA RPRLAPP	NULL RPRLAPP_ENROLL_START_DATE
ENTRANCE_COUNSELING_IND	Entrance Counseling Indicator	Indicates whether borrower has completed entrance counseling.	VARCHAR2(1)	RLRDLOR RPRLAPP	RLRDLOR_ENTRANCE_IND RPRLAPP_ENTRANCE_IND
EXPECTED_AMOUNT	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
EXPECTED_GRADUATION_DATE	Expected Graduation Date	Expected graduation date. No longer used after Financial Aid release 8.22.1.	DATE	NA RPRLAPP	NULL RPRLAPP_EXP_GRAD_DATE
FIRST_NAME	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)
FORMER_HEAL_INDICATOR	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
FUND	Fund	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(63)	RLRDLOR RPRLAPP	RLRDLOR_FUND_CODE RPRLAPP_FUND_CODE
FUND_TITLE	Fund Title	Full title of the financial aid fund code.	VARCHAR2(255)	RFRBASE	RFRBASE_FUND_TITLE
GIVE_PLUS_TO_STUDENT_IND	Give Plus To Student Indicator	Plus to student indicator.	VARCHAR2(63)	RLRPLUS RPRLAPP	RLRPLUS_PLUS_TO_STUDENT RPRLAPP_PLUS_TO_STUDENT
GUARANTOR_ID	Guarantor ID	Id for the guarantee agency that guaranteed the loan.	VARCHAR2(63)	NA SPRIDEN	NULL SPRIDEN_ID
GUARANTOR_NAME	Guarantor Name	Name of the guarantee agency that guaranteed the loan.	VARCHAR2(255)	FUNCTION NA	F_FORMAT_NAME NULL
HEAL_LOAN_DEBT	Heal Loan Debt	Borrower's total heal loan debt prior to the loan period.	NUMBER	RPRLAPP	RPRLAPP_HEAL_DEBT
ID	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
INTEREST_RATE_OPTION	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
LAST_NAME	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)
LENDER_ID	Lender ID	Id for the lender who issued the loan.	VARCHAR2(63)	NA SPRIDEN	NULL SPRIDEN_ID
LENDER_NAME	Lender Name	Name of the lender that issued the loan.	VARCHAR2(255)	FUNCTION NA	F_FORMAT_NAME NULL
LOAN_AMOUNT_UNKNOWN_IND	Loan Amount Unknown Indicator	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
LOAN_APPLICATION_NUMBER	Loan Application Number	System assigned number is assigned when the application is added.	NUMBER	RLRDLOR RPRLAPP	RLRDLOR_LOAN_NO RPRLAPP_APPL_NO
LOAN_APPLICATION_RECEIVED_DATE	Loan Application Received Date	Date that the loan application was received.	DATE	NA RPRLAPP	NULL RPRLAPP_RECEIVE_DATE
LOAN_APP_CREATE_DATE	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
LOAN_FEE	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
LOAN_FEE_PERCENT	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
LOAN_NUMBER	Loan Number	System generated loan number for the student.	NUMBER	RLRDLOR RPRLAPP	RLRDLOR_LOAN_NO RPRLAPP_APPL_NO
LOAN_PERIOD	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
LOAN_PERIOD_DESC	Loan Period Description	Loan Period description. No longer used after Financial Aid release 8.22.1.	VARCHAR2(255)	NA RPBLPRD	NULL RPBLPRD_DESC
LOAN_PERIOD_END_DATE	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
LOAN_PERIOD_START_DATE	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
LOAN_RECOMMENDED_AMOUNT	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
LOAN_SOURCE	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
LOAN_SOURCE_DESC	Loan Source Description	Loan source description.	VARCHAR2(255)	CALCULATION	CASE WHEN RFRASPC_DIRECT_LOAN_IND
LOAN_STATUS	Loan Status	Identifies the current status of the loan in processing.	VARCHAR2(63)	RLRDLOR RPRLAPP	RLRDLOR_LNST_CODE RPRLAPP_LNST_CODE
LOAN_STATUS_DESC	Loan Status Description	Loan status description.	VARCHAR2(255)	RTVLNST	RTVLNST_DESC
LOAN_TYPE	Loan Type	Type of loan.	VARCHAR2(63)	RLRDLOR RPRLAPP	RLRDLOR_LOAN_TYPE RPRLAPP_LOAN_TYPE
LOAN_TYPE_DESC	Loan Type Description	Loan type description.		FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
LOCAL_CITY	Local City	City in the local address of the borrower of a direct loan.	VARCHAR2(63)	RERCODA RPRLAPP	RERCODA_CITY RPRLAPP_LOCAL_CITY
LOCAL_NATION	Local Nation	Nation/country associated with the local address of the borrower.	VARCHAR2(63)	RERCODA RPRLAPP	RERCODA_CDNT_CODE RPRLAPP_LOCAL_NATN_CODE
LOCAL_NATION_DESC	Local Nation Description	Nation/country description for borrower's local address.	VARCHAR2(255)	STVNATN	STVNATN_NATION
LOCAL_PHONE_NUMBER_COMBINED	Local Phone Number Combined	Local phone number of the borrower of a direct loan.	VARCHAR2(63)	NA RPRLAPP	NULL RPRLAPP_LOCAL_PHONE_NO
LOCAL_POSTAL_CODE	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
LOCAL_STATE_PROVINCE	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
LOCAL_STATE_PROVINCE_DESC	Local State Province Description	State/province description of the local address of the borrower of a direct loan.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
LOCAL_STREET_LINE1	Local Street Line 1	First line of the borrower's local address.	VARCHAR2(255)	RERCODA RPRLAPP	RERCODA_ADDR_LINE1 RPRLAPP_LOCAL_ADDRESS
LOCAL_STREET_LINE2	Local Street Line 2	Second line of the borrower's local address.	VARCHAR2(255)	RERCODA RPRLAPP	RERCODA_ADDR_LINE2 RPRLAPP_LOCAL_ADDR_LINE2
LOCAL_STREET_LINE3	Local Street Line 3	Third line of the borrower's local address.	VARCHAR2(255)	RERCODA RPRLAPP	RERCODA_ADDR_LINE3 RPRLAPP_LOCAL_ADDR_LINE3
LOCAL_STREET_LINE4	Local Street Line 4	Fourth line of the borrower's local address.	VARCHAR2(255)	NA	NULL
LOCK_INDICATOR	Lock Indicator	Hold indicator.	VARCHAR2(63)	RLRDLOR RPRLAPP	RLRDLOR_LOCK_IND RPRLAPP_HOLD_IND
MAJOR	Major	Major subject area of the person's academic study.	VARCHAR2(63)	RPRLAPP	RPRLAPP_STU_MAJOR
MAJOR_DESC	Major Description	Name of the student's major subject area.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
MAXIMUM_ELIGIBLE_AMOUNT	Maximum Eligible Amount	Maximum loan amount for which the student is eligible. (The processed amount.).	NUMBER	NA RPRLAPP	NULL RPRLAPP_MAX_ELIG_AMT
MAXIMUM_LOAN_REQUESTED_IND	Maximum Loan Requested Indicator	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')
MIDDLE_INITIAL	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)
MPN_BATCH_ID	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
MPN_BORROWER_BIRTH_DATE	Master Promissory Note Borrower Birth Date	Borrower's birth date.	DATE	NA RLRDMPN	NULL RLRDMPN_BORROWER_BIRTH_DATE
MPN_BORROWER_FIRST_NAME	Master Promissory Note Borrower First Name	Borrower's first name.	VARCHAR2(63)	NA RLRDMPN	NULL RLRDMPN_BORROWER_FIRST_NAME
MPN_BORROWER_LAST_NAME	Master Promissory Note Borrower Last Name	Borrower's last name.	VARCHAR2(63)	NA RLRDMPN	NULL RLRDMPN_BORROWER_LAST_NAME
MPN_BORROWER_MIDDLE_NAME	Master Promissory Note Borrower Middle Name	Borrower's middle name.	VARCHAR2(63)	NA RLRDMPN	NULL RLRDMPN_BORROWER_MI
MPN_BORROWER_SSN	Master Promissory Note Borrower Tax ID	Borrower's social security number.	VARCHAR2(63)	NA RLRDMPN	NULL RLRDMPN_BORROWER_SSN
MPN_DOCUMENT_ID	Master Promissory Note Document ID	Master promissory note record's document identification.	VARCHAR2(63)	RLRDMPN RPRLAPP	RLRDMPN_DOCUMENT_ID RPRLAPP_MPN_DOCUMENT_ID
MPN_EXPIRATION_DATE	Master Promissory Note Expiration Date	Master promissory note expiration date.	DATE	RLRDMPN RPRLAPP	RLRDMPN_EXP_DATE RPRLAPP_MPN_EXP_DATE
MPN_EXPIRATION_REASON	Master Promissory Note Expiration Reason	COD reason why the master promissory note expired.	VARCHAR2(63)	RLRDMPN RPRLAPP	RLRDMPN_EXP_REASON RPRLAPP_MPN_EXP_CODE
MPN_EXPIRATION_REASON_DESC	Master Promissory Note Expiration Reason Description	COD reason description why the master promissory note expired.	VARCHAR2(255)	RLRDMPN RPRLAPP	RLRDMPN_EXP_DESC RPRLAPP_MPN_EXP_DESC
MPN_ID	Mpn ID	Identification number printed on the master promissory note associated with this loan.	VARCHAR2(63)	RLRDLOR RPRLAPP	RLRDLOR_MPN_ID RPRLAPP_MPN_ID
MPN_LINKED_IND	Master Promissory Note Linked Indicator	COD's acknowledgement that this origination is linked to the MPN ID at COD.	VARCHAR2(1)	NA RLRDLOR	NULL RLRDLOR_LINKED_IND
MPN_SEQUENCE_NUMBER	Master Promissory Note Sequence Number	Master promissory note sequence number.	NUMBER	NA RLRDMPN	NULL RLRDMPN_SEQ_NO
MPN_SINGLE_LOAN_IND	Master Promissory Note Single Loan Indicator	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
MPN_SINGLE_YEAR_AID_YEAR	Master Promissory Note Single Year Financial 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
MPN_SINGLE_YEAR_AID_YEAR_DESC	Master Promissory Note Single Year Financial Aid Year Description	Financial aid year name.	VARCHAR2(255)	NA ROBINST	NULL ROBINST_AIDY_DESC
MPN_STATUS_DATE	Master Promissory Note Status Date	Master promissory note status effective date.	DATE	NA RLRDMPN	NULL RLRDMPN_MPN_STATUS_EFF_DATE
MPN_STUDENT_BIRTH_DATE	Master Promissory Note Student Birth Date	Student's birth date.	DATE	NA RLRDMPN	NULL RLRDMPN_BIRTH_DATE
MPN_STUDENT_FIRST_NAME	Master Promissory Note Student First Name	Student's first name.	VARCHAR2(63)	NA RLRDMPN	NULL RLRDMPN_FIRST_NAME
MPN_STUDENT_LAST_NAME	Master Promissory Note Student Last Name	Student's last name.	VARCHAR2(63)	NA RLRDMPN	NULL RLRDMPN_LAST_NAME
MPN_STUDENT_MIDDLE_NAME	Master Promissory Note Student Middle Name	Student's middle name.	VARCHAR2(63)	NA RLRDMPN	NULL RLRDMPN_MI
MPN_STUDENT_SSN	Master Promissory Note Student Tax ID	Student's social security number.	VARCHAR2(63)	NA RLRDMPN	NULL RLRDMPN_SSN
MPN_TYPE	Master Promissory Note Type	Master promissory note type.	VARCHAR2(63)	NA RLRDMPN	NULL RLRDMPN_MPN_TYPE
MPN_TYPE_DESC	Master Promissory Note Type Description	Master promissory note type desc.	VARCHAR2(255)	FUNCTION NA	ROKODSF.F_GET_RORMVAL_DESC NULL
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
NATION	Nation	Nation/country code associated with the address of the borrower.	VARCHAR2(63)	RERCODA RPRLAPP	RERCODA_CDNT_CODE RPRLAPP_NATN_CODE
NATION_DESC	Nation Description	Address nation/country description.	VARCHAR2(255)	STVNATN	STVNATN_NATION
NOTIFICATION_BOOK_AMOUNT	Notification Book Amount	Total net amount of the first disbursement accepted and booked for the loan.	NUMBER	NA RLRDLBN	NULL RLRDLBN_BOOK_AMOUNT
NOTIFICATION_BOOK_DATE	Notification Book Date	Date the loan booked at COD.	DATE	RLRDLBN RPRLAPP	RLRDLBN_BOOK_DATE RPRLAPP_BOOK_DATE
NOTIFICATION_DOCUMENT_ID	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
ORIGINAL_CREDIT_STATUS	Original Credit Status	Loan application original credit status.	VARCHAR2(63)	RLRPLUS RPRLAPP	RLRPLUS_ORIG_CREDIT_STATUS RPRLAPP_ORIG_CREDIT_STATUS
ORIGINAL_CREDIT_STATUS_DESC	Original Credit Status Description	Loan application original credit status description.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
ORIGINATION_DOCUMENT_ID	Origination Document ID	Loan's initial origination document identification number as sent to COD.	VARCHAR2(63)	RLRDLOR RPRLAPP	RLRDLOR_DOCUMENT_ID RPRLAPP_DOCUMENT_ID
OTHER_LOANS_LOAN_PERIOD	Other Loans Loan Period	Borrower's total other student educational loan debt for the requested loan period.	NUMBER	RPRLAPP	RPRLAPP_OTH_LOANS_PERIOD
OTHER_LOAN_DEBT	Other Loan Debt	Borrower's total other student educational loan debt prior to the requested loan period.	NUMBER	RPRLAPP	RPRLAPP_OTHER_DEBT
OWES_REFUND_IND	Owes Refund Indicator	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
PARENT_ALIEN_REG_NUMBER	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
PARENT_BIRTH_DATE	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
PARENT_CITIZEN_IND	Parent Citizen Indicator	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
PARENT_CITY	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
PARENT_DEFAULT_IND	Parent Default Indicator	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
PARENT_DRIVER_LICENSE_NUMBER	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
PARENT_DRIVER_LIC_STATE_PROV	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
PARENT_DRIVER_LIC_ST_PR_DESC	Parent Driver Lic St Pr Description	Name of the state/province license code of the parent when a direct loan is of a parent type.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
PARENT_FIRST_NAME	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
PARENT_LAST_NAME	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
PARENT_LOCAL_CITY	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
PARENT_LOCAL_NATION	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
PARENT_LOCAL_NATION_DESC	Parent Local Nation Description	Nation/country description for the parent's local address when a direct loan is of a parent type.	VARCHAR2(255)	STVNATN	STVNATN_NATION
PARENT_LOCAL_POSTAL_CODE	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
PARENT_LOCAL_STATE_PROVINCE	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
PARENT_LOCAL_STATE_PR_DESC	Parent Local State Pr Description	Local address state/province description for the parent when a direct loan is of a parent type.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
PARENT_LOCAL_STREET_LINE1	Parent Local Street Line 1	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
PARENT_LOCAL_STREET_LINE2	Parent Local Street Line 2	Second line of parent's local street address.	VARCHAR2(255)	RLRDBOR RPRLAPP	RLRDBOR_LOCAL_ADDR_LINE2 RPRLAPP_PAR_LOCAL_ADDR_LINE2
PARENT_LOCAL_STREET_LINE3	Parent Local Street Line 3	Third line of parent's local street address.	VARCHAR2(255)	RLRDBOR RPRLAPP	RPRLAPP_PAR_LOCAL_ADDR_LINE3 RPRLAPP_PAR_LOCAL_ADDR_LINE3
PARENT_LOCAL_STREET_LINE4	Parent Local Street Line 4	Fourth line of parent's local street address.	VARCHAR2(255)	NA	NULL
PARENT_MIDDLE_INITIAL	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
PARENT_NATION	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
PARENT_NATION_DESC	Parent Nation Description	Nation/country description for the borrower's parent's address when the loan is of a parent type.	VARCHAR2(255)	STVNATN	STVNATN_NATION
PARENT_PHONE_NUMBER_COMBINED	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
PARENT_POSTAL_CODE	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
PARENT_STATE_PROVINCE	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
PARENT_STATE_PROVINCE_DESC	Parent State Province Description	Name of the state/province of the parent when a direct loan is of a parent type.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
PARENT_STATE_PROVINCE_OF_RES	Parent State Province Of Residence	State/Province in which the parent of the applicant is a legal resident.	VARCHAR2(63)	NA RPRLAPP	NULL RPRLAPP_PAR_STAT_CODE_RES
PARENT_STATE_PROV_OF_RES_DESC	Parent State Prov Of Residence Description	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
PARENT_STREET_LINE1	Parent Street Line 1	Address of the parent when a direct loan is of a parent type.	VARCHAR2(255)	RLRDBOR RPRLAPP	RLRDBOR_PERM_ADDRESS RPRLAPP_PAR_ADDRESS
PARENT_STREET_LINE2	Parent Street Line 2	Second line of parent's permanent street address.	VARCHAR2(255)	RLRDBOR RPRLAPP	RLRDBOR_PERM_ADDR_LINE2 RPRLAPP_PAR_ADDR_LINE2
PARENT_STREET_LINE3	Parent Street Line 3	Third line of parent's permanent street address.	VARCHAR2(255)	RLRDBOR RPRLAPP	RLRDBOR_PERM_ADDR_LINE3 RPRLAPP_PAR_ADDR_LINE3
PARENT_STREET_LINE4	Parent Street Line 4	Fourth line of parent's permanent street address.	VARCHAR2(255)	NA	NULL
PARENT_TAX_ID	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
PERKINS_LOAN_DEBT	Perkins Loan Debt	Borrower's total Perkins loan debt prior to the loan period.	NUMBER	RPRLAPP	RPRLAPP_PERKINS_DEBT
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RLRDLOR RPRLAPP	RLRDLOR_PIDM RPRLAPP_PIDM
PHONE_NUMBER_COMBINED	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
PLUS_APPLICATION_REASON	PLUS Application Reason	Reason the PLUS Application was submitted.	VARCHAR2(255)	RLRPAPP RPRLAPP	RLRPAPP_PLUS_APP_REASON RPRLAPP_PLUS_APP_REASON
PLUS_BORROWER_ID	PLUS Borrower ID	PLUS borrower system assigned identifier number.	VARCHAR2(63)	RLRDBOR RPRLAPP	RLRDBOR_BORROWER_ID_NO RPRLAPP_PLUS_BORROWER_ID_NO
PLUS_CREDIT_CHECK_DATE	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
PLUS_CREDIT_CHECK_STATUS	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
PLUS_CREDIT_CHECK_STATUS_DESC	PLUS Credit Check Status Description	PLUS loan credit check status description.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
PLUS_LOAN_APPLICATION_ID	PLUS Loan Application ID	PLUS application ID associated with this loan.	NUMBER	RLRPLUS RPRLAPP	RLRPLUS_PLUS_APP_ID RPRLAPP_APPL_ID
PLUS_PREVIOUS_APPLICATION_ID	PLUS Previous Application ID	Previously submitted PLUS Application ID.	VARCHAR2(63)	RLRPAPP RPRLAPP	RLRPAPP_PREVIOUS_APP_ID RPRLAPP_PREVIOUS_APP_ID
POSTAL_CODE	Postal Code	Postal code in the address of the borrower of a direct loan.	VARCHAR2(63)	RERCODA RPRLAPP	RERCODA_ZIP RPRLAPP_ZIP
PREP_TEACHER_CERTIFICATION	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
PREP_TEACH_CERTIFICATION_DESC	Prep Teach Certification Description	Preparation or teacher certification coursework description.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
PROCESSING_APP_PHASE_CRNT_LOAN	Processing App Phase Crnt Loan	Current processing phase for the application or loan.	VARCHAR2(63)	NA RPRLAPP	NULL RPRLAPP_APP_PHASE_CDE
PROCESS_DATE	Process Date	Date the loan application was processed.	DATE	RLRDLOR RPRLAPP	RLRDLOR_PROCESS_DATE RPRLAPP_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_OF_STUDY	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
PROGRAM_OF_STUDY_DESC	Program Of Study Description	Program of study description. No longer used after Financial Aid release 8.22.1.	VARCHAR2(255)	FUNCTION NA	ROKODSF.F_GET_RORMVAL_DESC NULL
PROGRAM_SEQUENCE_LOCK_IND	Program Sequence Lock Indicator	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
PROGRAM_SEQUENCE_NUMBER	Program Sequence Number	Program information record sequence number for this origination.	NUMBER	RLRDLOR RPRLAPP	RLRDLOR_SPGM_SEQ_NO RPRLAPP_SPGM_SEQ_NO
PROMISSORY_NOTE_DATE	Promissory Note Date	Date the borrower signed the promissory note for the loan.	DATE	NA RPRLAPP	NULL RPRLAPP_PN_DATE
RECORD_TYPE	Record Type	Record type indicator for passing information to the loan application server.	VARCHAR2(63)	NA RPRLAPP	NULL RPRLAPP_RECORD_TYPE
REPAYMENT_OPTION_CODE	Repayment Option Code	Type of repayment option requested by the borrower.	VARCHAR2(63)	RPRLAPP	RPRLAPP_REPAY_OPT_IND
REQUESTED_AWARD_END_DATE	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
REQUESTED_AWARD_START_DATE	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
SAR_TRANSACTION_NUMBER	SAR Transaction Number	Eligible SAR transaction number reported with the origination record.	VARCHAR2(63)	RLRDLOR RPRLAPP	RLRDLOR_SAR_TRAN_NO RPRLAPP_SAR_TRAN_NO
SCHEDULED_ACADEMIC_YEAR	Scheduled Academic Year	Scheduled Academic Year.	VARCHAR2(63)	NA RLRDLOR	NULL RLRDLOR_SAYR_CODE
SCHEDULED_ACADEMIC_YEAR_DESC	Scheduled Academic Year Description	Scheduled Academic Year description.	VARCHAR2(255)	NA RTVSAYR	NULL RTVSAYR_DESC
SERVICER_CONFIRMATION_DATE	Servicer Confirmation Date	Service provider confirmation date.	DATE	RLRDLOR RPRLAPP	RLRDLOR_PROCESS_DATE RPRLAPP_CONF_DATE
SLS_LOAN_DEBT	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
STAFFORD_LOAN_DEBT	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
STATE_PROVINCE	State Province	State or province associated with this address.	VARCHAR2(63)	RERCODA RPRLAPP	RERCODA_CDST_CODE RPRLAPP_STATE
STATE_PROVINCE_DESC	State Province Description	State/province name.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
STREET_LINE1	Street Line 1	First line of the address.	VARCHAR2(255)	RERCODA RPRLAPP	RERCODA_ADDR_LINE1 RPRLAPP_ADDRESS
STREET_LINE2	Street Line 2	Second line of the address.	VARCHAR2(255)	RERCODA RPRLAPP	RERCODA_ADDR_LINE2 RPRLAPP_ADDR_LINE2
STREET_LINE3	Street Line 3	Third line of the address.	VARCHAR2(255)	RERCODA RPRLAPP	RERCODA_ADDR_LINE3 RPRLAPP_ADDR_LINE3
STREET_LINE4	Street Line 4	Fourth line of the address.	VARCHAR2(255)	NA	NULL
SUBMISSION_DATE	Submission Date	Date the loan application was submitted.	DATE	NA RPRLAPP	NULL RPRLAPP_SUB_DATE
TAX_ID	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)
XREF_LOAN_ID	Cross Reference 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
YEAR_IN_COLLEGE	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
YEAR_IN_COLLEGE_DESC	Year In College Description	Year of study (first, second, etc.) that the student is enrolled for this origination.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC

Ver: 9.2