Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACAD_YEAR_END_DATE	Date on which the student's academic year ends at the institution.	DATE	RPRLAPP	RPRLAPP_ACAD_YR_END_DATE	NO	NO
ACAD_YEAR_START_DATE	Date on which the student's academic year starts at the institution.	DATE	RPRLAPP	RPRLAPP_ACAD_YR_START_DATE	NO	NO
ADDL_STAFFORD_ELIG_IND	Indicates whether this dependent student is eligible for an additional unsubsidized loan amount.	VARCHAR2(1)	CALCULATION	NVL(RPRLAPP_ADDL_STFD_ELIG_IND,'N')	NO	NO
AID_YEAR	Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation.	VARCHAR2(4)	RPRLAPP	RPRLAPP_AIDY_CODE	NO	NO
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(30)	ROBINST	ROBINST_AIDY_DESC	NO	NO
ALIEN_REGISTRATION_NO	Student's alien registration number (when applicable).	VARCHAR2(9)	RPRLAPP	RPRLAPP_ALIEN_REG_NO	NO	NO
ALT_LOAN_BORROWER_LN_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(3)	RPRLAPP	RPRLAPP_ALT_LOAN_PROG_TYPE_CDE	NO	NO
ALT_LOAN_STU_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(1)	RPRLAPP	RPRLAPP_ALT_LOAN_SB_IND	NO	NO
APPLICATION_COMPLETE_DATE		DATE				NO
APPLICATION_LOAN_AMOUNT		NUMBER				NO
APPROVED_AMT	Loan amount that was approved by the approving agency.	NUMBER	RPRLAPP	RPRLAPP_APPROVE_AMT	NO	NO
APPROVED_DATE	Date the loan was approved by the approving agency.	DATE	RPRLAPP	RPRLAPP_APPROVE_DATE	NO	NO
APP_PHASE_CODE	Current processing phase for the application or loan.	VARCHAR2(4)	RPRLAPP	RPRLAPP_APP_PHASE_CDE	NO	NO
APP_RECEIVED_DATE	Date that the loan application was received.	DATE	RPRLAPP	RPRLAPP_RECEIVE_DATE	NO	NO
APP_VERSION_NO	Version of the common line application file has been sent once the loan application has been extracted.	VARCHAR2(1)	RPRLAPP	RPRLAPP_APP_VER_NO	NO	NO
BATCH_ID	Batch number of the file of origination records for direct loans that were sent to the loan servicer that included this student.	VARCHAR2(23)	RPRLAPP	RPRLAPP_BATCH_NO	NO	NO
BOOKING_STATUS	Overall reconciliation status from the servicer (loan origination center) for this loan.	VARCHAR2(1)	RPRLAPP	RPRLAPP_DL_RECON_STATUS	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_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_DATE	Date the loan was cancelled.	DATE	RPRLAPP	RPRLAPP_CANCEL_DATE	NO	NO
CANCEL_IND	Indicates whether a direct loan was canceled/inactivated for this student.	VARCHAR2(1)	RPRLAPP	RPRLAPP_CANCEL_IND	NO	NO
CERTIFICATION_DATE	Date that the loan application was certified.	DATE	RPRLAPP	RPRLAPP_CERT_DATE	NO	NO
CITIZEN_IND	Indicates whether the person has been identified as a citizen of the institution's home country.	VARCHAR2(1)	RPRLAPP	RPRLAPP_CITZ_IND	NO	NO
CITY	Address city, town or municipality.	VARCHAR2(50)	RPRLAPP	RPRLAPP_CITY	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(1)	RPRLAPP	RPRLAPP_COSIGN1_CITZ_IND	NO	NO
COSIGN1_CITY	City of the first cosigner's last known address.	VARCHAR2(50)	RPRLAPP	RPRLAPP_COSIGN1_CITY	NO	NO
COSIGN1_DRIVER_LIC_NO	First cosigner's driver's license number.	VARCHAR2(20)	RPRLAPP	RPRLAPP_COSIGN1_DRIVER_LIC_NO	NO	NO
COSIGN1_DRIVER_LIC_STAT	2-character abbreviation for the state that issued the first cosigner's driver's license.	VARCHAR2(2)	RPRLAPP	RPRLAPP_COSIGN1_STAT_CODE_LIC	NO	NO
COSIGN1_DRIVER_LIC_STAT_DESC	Name of the state/province that issued the first cosigner's driver's license.	VARCHAR2(30)	STVSTAT	STVSTAT_DESC	NO	NO
COSIGN1_FIRST_NAME	First name of the cosigner.	VARCHAR2(60)	RPRLAPP	RPRLAPP_COSIGN1_FIRST_NAME	NO	NO
COSIGN1_FOREIGN_POSTAL_CODE	Foreign postal code of the cosigner's last known address.	VARCHAR2(14)	RPRLAPP	RPRLAPP_COSIGN1_FOR_POST_CDE	NO	NO
COSIGN1_LAST_NAME	Last name of the cosigner.	VARCHAR2(60)	RPRLAPP	RPRLAPP_COSIGN1_LAST_NAME	NO	NO
COSIGN1_MIDDLE_INITIAL	Middle initial of the cosigner.	VARCHAR2(60)	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(18)	RPRLAPP	RPRLAPP_COSIGN1_PHONE_NO	NO	NO
COSIGN1_POSTAL_CODE	Postal code of the cosigner's last known address.	VARCHAR2(30)	RPRLAPP	RPRLAPP_COSIGN1_ZIP	NO	NO
COSIGN1_RELATIONSHIP	First cosigner's relationship to the student.	VARCHAR2(1)	RPRLAPP	RPRLAPP_COSIGN1_RELATION_IND	NO	NO
COSIGN1_RELATIONSHIP_DESC	COSIGNER 1 RELATIONSHIP TO STUDENT DESC: The description of the cosigner's relationship.	VARCHAR2(30)	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(1)	RPRLAPP	RPRLAPP_COSIGN1_SIGNED_IND	NO	NO
COSIGN1_STATE_PROVINCE	2-character state abbreviation of the first cosigner's last known address.	VARCHAR2(2)	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(30)	STVSTAT	STVSTAT_DESC	NO	NO
COSIGN1_STREET_LINE1	First line of the first cosigner's last known address.	VARCHAR2(75)	RPRLAPP	RPRLAPP_COSIGN1_ADDR_LINE1	NO	NO
COSIGN1_STREET_LINE2	Second line of the first cosigner's last known address.	VARCHAR2(75)	RPRLAPP	RPRLAPP_COSIGN1_ADDR_LINE2	NO	NO
COSIGN1_SUFFIX	Suffix of the first cosigner's name.	VARCHAR2(3)	RPRLAPP	RPRLAPP_COSIGN1_SUFFIX	NO	NO
COSIGN1_TAX_ID	Social security number of the cosigner.	VARCHAR2(15)	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(1)	RPRLAPP	RPRLAPP_COSIGN2_CITZ_IND	NO	NO
COSIGN2_CITY	City of the second cosigner's last known address.	VARCHAR2(50)	RPRLAPP	RPRLAPP_COSIGN2_CITY	NO	NO
COSIGN2_DRIVER_LIC_NO	Second cosigner's driver's license number.	VARCHAR2(20)	RPRLAPP	RPRLAPP_COSIGN2_DRIVER_LIC_NO	NO	NO
COSIGN2_DRIVER_LIC_STAT_PROV	Two-character abbreviation for the state that issued the second cosigner's drivers license.	VARCHAR2(2)	RPRLAPP	RPRLAPP_COSIGN2_STAT_CODE_LIC	NO	NO
COSIGN2_DRIVER_LIC_ST_PR_DESC	Name of the state/province that issued the second cosigner's driver's license.	VARCHAR2(30)	STVSTAT	STVSTAT_DESC	NO	NO
COSIGN2_FIRST_NAME	First name of the cosigner.	VARCHAR2(60)	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(14)	RPRLAPP	RPRLAPP_COSIGN2_FOR_POST_CDE	NO	NO
COSIGN2_LAST_NAME	Last name of the cosigner.	VARCHAR2(60)	RPRLAPP	RPRLAPP_COSIGN2_LAST_NAME	NO	NO
COSIGN2_MIDDLE_INITIAL	Middle initial of the second cosigner.	VARCHAR2(60)	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(18)	RPRLAPP	RPRLAPP_COSIGN2_PHONE_NO	NO	NO
COSIGN2_POSTAL_CODE	Postal code of the cosigner's last known address.	VARCHAR2(30)	RPRLAPP	RPRLAPP_COSIGN2_ZIP_CODE	NO	NO
COSIGN2_RELATIONSHIP	Second cosigner's relationship to the student.	VARCHAR2(1)	RPRLAPP	RPRLAPP_COSIGN2_RELATION_IND	NO	NO
COSIGN2_RELATIONSHIP_DESC	COSIGNER 2 RELATIONSHIP TO STUDENT DESC: The description of the second cosigner's relationship to the student.	VARCHAR2(30)	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(1)	RPRLAPP	RPRLAPP_COSIGN2_SIGNED_IND	NO	NO
COSIGN2_STATE_PROVINCE	State abbreviation of the second cosigner's last known address.	VARCHAR2(2)	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(30)	STVSTAT	STVSTAT_DESC	NO	NO
COSIGN2_STREET_LINE1	First line of the second cosigner's last known address.	VARCHAR2(75)	RPRLAPP	RPRLAPP_COSIGN2_ADDR_LINE1	NO	NO
COSIGN2_STREET_LINE2	Second line of the second cosigner's last known address.	VARCHAR2(75)	RPRLAPP	RPRLAPP_COSIGN2_ADDR_LINE2	NO	NO
COSIGN2_SUFFIX	Suffix of the second cosigner's name.	VARCHAR2(3)	RPRLAPP	RPRLAPP_COSIGN2_SUFFIX	NO	NO
COSIGN2_TAX_ID	Social security number of the cosigner.	VARCHAR2(15)	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
CREATE_DATE	Date the loan application was created. For dl loans initialized by the loan origination batch process.	DATE	RPRLAPP	RPRLAPP_CREATE_DATE	NO	NO
CREDIT_ACTION		VARCHAR2(1)				NO
CREDIT_ACTION_DESC		VARCHAR2(4000)				NO
CREDIT_APPLICATION_DOCUMENT_ID		VARCHAR2(30)				NO
CREDIT_BALANCE_OPTION_IND		VARCHAR2(1)				NO
CREDIT_CHECK_APPEAL_STATUS		VARCHAR2(1)				NO
CREDIT_CHECK_EXPIRATION_DATE		DATE				NO
CREDIT_CHECK_OVERRIDDEN		VARCHAR2(1)				NO
CREDIT_CHECK_OVERRIDDEN_DESC		VARCHAR2(4000)				NO
CREDIT_CHK_APPEAL_STATUS_DESC		VARCHAR2(4000)				NO
CREDIT_IN_DIFF_NAME_IND	Indicates the borrower has been granted credit under a different name.	VARCHAR2(1)	RPRLAPP	RPRLAPP_CRED_DIF_NM_IND	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DEFAULT_IND	Indicates whether this is the default type to be used.	VARCHAR2(1)	RPRLAPP	RPRLAPP_IN_DEFAULT	NO	NO
DEFAULT_IND_DESC	Description of the loan default status.	VARCHAR2(4000)				NO
DEFERRED_PAYMENT_IND		VARCHAR2(1)				NO
DEPENDENCY_STATUS	Identifies the student's dependency status as computed by INAS or loaded from the tape record.	VARCHAR2(1)	RPRLAPP	RPRLAPP_MODEL_CDE	NO	NO
DISCLOSURE_NEED_PRINT_FLAG	New or revised disclosure statement needs to be printed for this loan record.	VARCHAR2(1)	RPRLAPP	RPRLAPP_DISC_NEED_PRINT_FLAG	NO	NO
DISCLOSURE_PRINT_DATE	Last date that a disclosure statement was printed for this loan.	DATE	RPRLAPP	RPRLAPP_DISC_PRINT_DATE	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.	VARCHAR2(1)	RPRLAPP	RPRLAPP_DISC_PRINT_IND	NO	NO
DL_LOAN_ID	Identifies a specific loan application.	VARCHAR2(21)	RPRLAPP	RPRLAPP_DL_LOAN_ID	NO	NO
DL_LOAN_STATUS	Origination status code, typically system maintained for direct loan applications.	VARCHAR2(1)	RPRLAPP	RPRLAPP_DL_STATUS	NO	NO
DL_MPN_STATUS_DESC		VARCHAR2(4000)				NO
DL_REBATE_FEE_PERCENT	Rebate fee percent.	NUMBER	RPRLAPP	RPRLAPP_DL_REBATE_PERCENT	NO	NO
DL_RECON_REJECT1	First reconciliation reject code sent from the servicer (loan origination center) for this loan disbursement.	VARCHAR2(3)	RPRLAPP	RPRLAPP_DL_RECON_REJECT_1	NO	NO
DL_RECON_REJECT2	Second reconciliation reject code sent from the servicer (loan origination center) for this loan disbursement.	VARCHAR2(3)	RPRLAPP	RPRLAPP_DL_RECON_REJECT_2	NO	NO
DL_RECON_REJECT3	Third reconciliation reject code sent from the servicer (loan origination center) for this loan disbursement.	VARCHAR2(3)	RPRLAPP	RPRLAPP_DL_RECON_REJECT_3	NO	NO
DL_RECON_REJECT4	Fourth reconciliation reject code sent from the servicer (loan origination center) for this loan disbursement.	VARCHAR2(3)	RPRLAPP	RPRLAPP_DL_RECON_REJECT_4	NO	NO
DL_RECON_REJECT5	Fifth reconciliation reject code sent from the servicer (loan origination center) for this loan disbursement.	VARCHAR2(3)	RPRLAPP	RPRLAPP_DL_RECON_REJECT_5	NO	NO
DL_REJECT_CODE1	May contain a reject code from the dl servicer if the servicer did not accept the loan origination.	VARCHAR2(3)	RPRLAPP	RPRLAPP_DL_REJECT_CODE_1	NO	NO
DL_REJECT_CODE2	May contain a reject code from the dl servicer if the servicer did not accept the loan origination.	VARCHAR2(3)	RPRLAPP	RPRLAPP_DL_REJECT_CODE_2	NO	NO
DL_REJECT_CODE3	May contain a reject code from the dl servicer if the servicer did not accept the loan origination.	VARCHAR2(3)	RPRLAPP	RPRLAPP_DL_REJECT_CODE_3	NO	NO
DL_REJECT_CODE4	May contain a reject code from the dl servicer if the servicer did not accept the loan origination.	VARCHAR2(3)	RPRLAPP	RPRLAPP_DL_REJECT_CODE_4	NO	NO
DL_REJECT_CODE5	May contain a reject code from the dl servicer if the servicer did not accept the loan origination.	VARCHAR2(3)	RPRLAPP	RPRLAPP_DL_REJECT_CODE_5	NO	NO
DL_SENT_DATE	Date that a direct loan origination record was sent to the service provider.	DATE	RPRLAPP	RPRLAPP_DL_SENT_DATE	NO	NO
DL_SEQ_NO	System generated sequence number to designate direct loan applications.	NUMBER	RPRLAPP	RPRLAPP_DL_SEQ_NO	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
DRIVER_LICENSE_NO	Applicant's driver's license number as reported on the applicant's need analysis document.	VARCHAR2(20)	RPRLAPP	RPRLAPP_DRIVER_LIC_NO	NO	NO
DRIVER_LICENSE_STATE_PROVINCE	State/province of the state in which the student holds a drivers license.	VARCHAR2(3)	RPRLAPP	RPRLAPP_STAT_CODE_LIC	NO	NO
DRIVER_LICENSE_ST_PR_DESC	State/province description in which the student holds a drivers license.	VARCHAR2(30)	STVSTAT	STVSTAT_DESC	NO	NO
EL_DATE_SENT	Date the loan was sent to the loan service provider (common line).	DATE	RPRLAPP	RPRLAPP_EL_DATE_SENT	NO	NO
EL_LOAN_ID	Loan identification number used by electronic loan processing (common line).	VARCHAR2(17)	RPRLAPP	RPRLAPP_EL_LOAN_ID	NO	NO
EL_LOAN_STATUS	Status of a loan processed via electronic loan processing (common line).	VARCHAR2(1)	RPRLAPP	RPRLAPP_EL_STATUS	NO	NO
EL_PROCESS_TYPE	Type of processing done to the loan by the servicer (GP - guarantee and print, GO - guarantee only, PO - print only, RP - reprint, CR - certification request).	VARCHAR2(2)	RPRLAPP	RPRLAPP_EL_PROCESS_TYPE	NO	NO
EL_SEQ_NO	Sequence number used by electronic loan processing (common line) to further identify the loan.	NUMBER	RPRLAPP	RPRLAPP_EL_SEQ_NO	NO	NO
ENDORSER_AMOUNT		NUMBER				NO
ENROLL_START_DATE	Enrollment start date.	DATE	RPRLAPP	RPRLAPP_ENROLL_START_DATE	NO	NO
ENTRANCE_COUNSELING_IND		VARCHAR2(1)				NO
EXPECTED_AMT	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.	NUMBER	RPRLAPP	RPRLAPP_EXPECT_AMT	NO	NO
EXPECTED_GRAD_DATE	Program completion date of a student in a direct loan application.	DATE	RPRLAPP	RPRLAPP_EXP_GRAD_DATE	NO	NO
FIRST_NAME	Student's first name as reported on the loan application.	VARCHAR2(60)	RPRLAPP	RPRLAPP_FIRST_NAME	NO	NO
FORMER_HEAL_IND	Indicator of student qualification for additional Stafford unsubsidized loans in replacement of the heal loan program.	VARCHAR2(1)	RPRLAPP	RPRLAPP_FORMER_HEAL_IND	NO	NO
FUND	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(6)	RPRLAPP	RPRLAPP_FUND_CODE	NO	NO
FUND_TITLE	Full title of the financial aid fund code.	VARCHAR2(30)	RFRBASE	RFRBASE_FUND_TITLE	NO	NO
GUARANTOR_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	RPRLAPP	RPRLAPP_GUAR_PIDM	NO	NO
HEAL_LOAN_DEBT	Borrower's total heal loan debt prior to the loan period.	NUMBER	RPRLAPP	RPRLAPP_HEAL_DEBT	NO	NO
INTEREST_RATE_OPTION_CODE	Indicates the type of interest rate associated with the loan (e.g., fixed or variable).	VARCHAR2(1)	RPRLAPP	RPRLAPP_INT_RATE_OPT_IND	NO	NO
LAST_NAME	Student's last name as reported on the loan application.	VARCHAR2(60)	RPRLAPP	RPRLAPP_LAST_NAME	NO	NO
LENDER_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	RPRLAPP	RPRLAPP_LENDER_PIDM	NO	NO
LOAN_AMOUNT_UNKNOWN_IND		VARCHAR2(1)				NO
LOAN_APPLICATION_NO	System assigned number is assigned when the application is added.	NUMBER	RPRLAPP	RPRLAPP_APPL_NO	NO	NO
LOAN_FEE	Percentage of the loan that is subtracted from the loan proceeds because of origination fees, etc.	NUMBER	RPRLAPP	RPRLAPP_FEE_PCT	NO	NO
LOAN_PERIOD	Period covered by the loan.	VARCHAR2(6)	RPRLAPP	RPRLAPP_LOAN_PERIOD	NO	NO
LOAN_PERIOD_DESC	Loan period description.	VARCHAR2(30)	RPBLPRD	RPBLPRD_DESC	NO	NO
LOAN_STATUS	Identifies the current status of the loan in processing.	VARCHAR2(4)	RPRLAPP	RPRLAPP_LNST_CODE	NO	NO
LOAN_STATUS_DESC	Loan status description.	VARCHAR2(30)	RTVLNST	RTVLNST_DESC	NO	NO
LOAN_TYPE		VARCHAR2(1)				NO
LOAN_TYPE_DESC		VARCHAR2(4000)				NO
LOCAL_CITY	City in the local address of the borrower of a direct loan.	VARCHAR2(50)	RPRLAPP	RPRLAPP_LOCAL_CITY	NO	NO
LOCAL_NATION	Nation/country associated with the local address of the borrower.	VARCHAR2(5)	RPRLAPP	RPRLAPP_LOCAL_NATN_CODE	NO	NO
LOCAL_NATION_DESC	Nation/country description for borrower's local address.	VARCHAR2(30)	STVNATN	STVNATN_NATION	NO	NO
LOCAL_PHONE_NUMBER_COMBINED	Local phone number of the borrower of a direct loan.	VARCHAR2(18)	RPRLAPP	RPRLAPP_LOCAL_PHONE_NO	NO	NO
LOCAL_POSTAL_CODE	Postal code in the local address of the borrower of a direct loan.	VARCHAR2(30)	RPRLAPP	RPRLAPP_LOCAL_ZIP	NO	NO
LOCAL_STATE_PROVINCE	State in the local address of the borrower of a direct loan.	VARCHAR2(2)	RPRLAPP	RPRLAPP_LOCAL_STAT_CODE	NO	NO
LOCAL_STATE_PROVINCE_DESC	State description of the local address of the borrower of a direct loan.	VARCHAR2(30)	STVSTAT	STVSTAT_DESC	NO	NO
LOCAL_STREET_LINE1	Local address of the borrower of a direct loan.	VARCHAR2(75)	RPRLAPP	RPRLAPP_LOCAL_ADDRESS	NO	NO
LOCAL_STREET_LINE2	Second line of student's local street address.	VARCHAR2(75)	RPRLAPP	RPRLAPP_LOCAL_ADDR_LINE2	NO	NO
LOCK_IND	Hold indicator.	VARCHAR2(1)	RPRLAPP	RPRLAPP_HOLD_IND	NO	NO
MAXIMUM_ELIGIBLE_AMT	Maximum loan amount for which the student is eligible. (The processed amount.).	NUMBER	RPRLAPP	RPRLAPP_MAX_ELIG_AMT	NO	NO
MAXIMUM_LOAN_REQUESTED_IND		VARCHAR2(1)				NO
MIDDLE_INITIAL	The student's middle initial as reported on the loan application.	VARCHAR2(60)	RPRLAPP	RPRLAPP_MI	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
MPN_BATCH_ID	Batch identification number used to report the master promissory note status and identification number.	VARCHAR2(23)	RPRLAPP	RPRLAPP_MPN_BATCH_ID	NO	NO
MPN_ID	Identification number printed on the master promissory note associated with this loan.	VARCHAR2(21)	RPRLAPP	RPRLAPP_MPN_ID	NO	NO
MPN_STATUS_IND	Status of the borrower's master promissory note at the loan origination center (loc).	VARCHAR2(1)	RPRLAPP	RPRLAPP_MPN_STATUS_IND	NO	NO
NATION	Nation/country code associated with the address of the borrower.	VARCHAR2(5)	RPRLAPP	RPRLAPP_NATN_CODE	NO	NO
NATION_DESC	Address nation/country description.	VARCHAR2(30)	STVNATN	STVNATN_NATION	NO	NO
ORIGINAL_CREDIT_STATUS		VARCHAR2(1)				NO
ORIGINAL_CREDIT_STATUS_DESC		VARCHAR2(4000)				NO
OTHER_LOANS_FOR_LN_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(1)	RPRLAPP	RPRLAPP_OWES_REFUND	NO	NO
PARENT_ALIEN_REGISTRATION_NO	Alien registration of the parent when a direct loan is of a parent type.	VARCHAR2(9)	RPRLAPP	RPRLAPP_PAR_ALIEN_REG_NO	NO	NO
PARENT_BIRTH_DATE	Birth date of the parent when a direct loan is of a parent type.	DATE	RPRLAPP	RPRLAPP_PAR_BIRTH_DATE	NO	NO
PARENT_CITIZEN_IND	Citizen indicator of the parent when a direct loan is of a parent type.	VARCHAR2(1)	RPRLAPP	RPRLAPP_PAR_CITZ_IND	NO	NO
PARENT_CITY	City of the parent when a direct loan is of a parent type.	VARCHAR2(50)	RPRLAPP	RPRLAPP_PAR_CITY	NO	NO
PARENT_DEFAULT_IND	Indicates whether the borrower of a direct loan is in default or owes a refund on a grant.	VARCHAR2(1)	RPRLAPP	RPRLAPP_PAR_IN_DEFAULT	NO	NO
PARENT_DRIVER_LICENSE_NO	Driver license number of the parent when a direct loan is of a parent type.	VARCHAR2(20)	RPRLAPP	RPRLAPP_PAR_DRIVER_LIC_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(2)	RPRLAPP	RPRLAPP_PAR_STAT_CODE_LIC	NO	NO
PARENT_DRIVER_LIC_ST_PR_DESC	State license code description for the parent when a direct loan is of a parent type.	VARCHAR2(30)	STVSTAT	STVSTAT_DESC	NO	NO
PARENT_FIRST_NAME	First name of the parent when a direct loan is of a parent type.	VARCHAR2(60)	RPRLAPP	RPRLAPP_PAR_FIRST_NAME	NO	NO
PARENT_LAST_NAME	Last name of the parent when a direct loan is of a parent type.	VARCHAR2(60)	RPRLAPP	RPRLAPP_PAR_LAST_NAME	NO	NO
PARENT_LOCAL_CITY	City in the local address of the parent when a direct loan is of a parent type.	VARCHAR2(50)	RPRLAPP	RPRLAPP_PAR_LOCAL_CITY	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(5)	RPRLAPP	RPRLAPP_PAR_LOCAL_NATN_CODE	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(30)	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(30)	RPRLAPP	RPRLAPP_PAR_LOCAL_ZIP	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(2)	RPRLAPP	RPRLAPP_PAR_LOCAL_STAT_CODE	NO	NO
PARENT_LOCAL_STATE_PROV_DESC	Name of the state/province of the local address of the parent when a direct loan is of a parent type.	VARCHAR2(30)	STVSTAT	STVSTAT_DESC	NO	NO
PARENT_LOCAL_STREET_LINE1	Local address of the parent when a direct loan is of a parent type.	VARCHAR2(75)	RPRLAPP	RPRLAPP_PAR_LOCAL_ADDRESS	NO	NO
PARENT_LOCAL_STREET_LINE2	Second line of parent's local street address.	VARCHAR2(75)	RPRLAPP	RPRLAPP_PAR_LOCAL_ADDR_LINE2	NO	NO
PARENT_MIDDLE_INITIAL	Middle initial of the parent when a direct loan is of a parent type.	VARCHAR2(60)	RPRLAPP	RPRLAPP_PAR_MI	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(5)	RPRLAPP	RPRLAPP_PAR_NATN_CODE	NO	NO
PARENT_NATION_DESC	Nation/country description for the borrower's parent's address when the loan is of a parent type.	VARCHAR2(30)	STVNATN	STVNATN_NATION	NO	NO
PARENT_PHONE_NUMBER_COMBINED	Phone number of the parent when a direct loan is of a parent type.	VARCHAR2(18)	RPRLAPP	RPRLAPP_PAR_PHONE_NO	NO	NO
PARENT_POSTAL_CODE	Postal code of the parent when a direct loan is of a parent type.	VARCHAR2(30)	RPRLAPP	RPRLAPP_PAR_ZIP	NO	NO
PARENT_STATE_PROVINCE	State/province of the parent when a direct loan is of a parent type.	VARCHAR2(2)	RPRLAPP	RPRLAPP_PAR_STATE	NO	NO
PARENT_STATE_PROVINCE_DESC	Name of the state/province of the parent when a direct loan is of a parent type.	VARCHAR2(30)	STVSTAT	STVSTAT_DESC	NO	NO
PARENT_STATE_PROVINCE_OF_RES	State/Province in which the parent of the applicant is a legal resident.	VARCHAR2(3)	RPRLAPP	RPRLAPP_PAR_STAT_CODE_RES	NO	NO
PARENT_STATE_PROV_OF_RES_DESC	Name of the state/province in which the parent of the applicant is a legal resident.	VARCHAR2(30)	STVSTAT	STVSTAT_DESC	NO	NO
PARENT_STREET_LINE1	Address of the parent when a direct loan is of a parent type.	VARCHAR2(75)	RPRLAPP	RPRLAPP_PAR_ADDRESS	NO	NO
PARENT_STREET_LINE2	Second line of parent's permanent street address.	VARCHAR2(75)	RPRLAPP	RPRLAPP_PAR_ADDR_LINE2	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(15)	RPRLAPP	RPRLAPP_PAR_SSN	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	RPRLAPP	RPRLAPP_PIDM	NO	NO
PHONE_NUMBER_COMBINED	All recorded pieces of the telephone number combined in a single field. International code, area code, number, extension.	VARCHAR2(18)	RPRLAPP	RPRLAPP_PHONE_NO	NO	NO
PLUS_APPLICATION_REASON		VARCHAR2(30)				NO
PLUS_CREDIT_CHECK_DATE	Date a credit check was performed for a direct loan for this student.	DATE	RPRLAPP	RPRLAPP_CREDIT_CHECK_DATE	NO	NO
PLUS_CREDIT_CHECK_STATUS	Status of the plus loan credit check on the parent.	VARCHAR2(1)	RPRLAPP	RPRLAPP_CREDIT_CHECK_IND	NO	NO
PLUS_LOAN_APPLICATION_ID		NUMBER				NO
PLUS_PREVIOUS_APPLICATION_ID		NUMBER				NO
PLUS_TO_STUDENT_IND	Plus to student indicator.	VARCHAR2(1)	RPRLAPP	RPRLAPP_PLUS_TO_STUDENT	NO	NO
POSTAL_CODE	Postal code in the address of the borrower of a direct loan.	VARCHAR2(30)	RPRLAPP	RPRLAPP_ZIP	NO	NO
PROCESS_DATE	Date the loan application was processed.	DATE	RPRLAPP	RPRLAPP_PROCESS_DATE	NO	NO
PROGRAM_OF_STUDY		VARCHAR2(3)				NO
PROGRAM_OF_STUDY_DESC		VARCHAR2(4000)				NO
PROM_NOTE_DATE	Date the borrower signed the promissory note for the loan.	DATE	RPRLAPP	RPRLAPP_PN_DATE	NO	NO
RECOMMENDED_AMT	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	RPRLAPP	RPRLAPP_RECOMMEND_AMT	NO	NO
RECORD_TYPE	Record type indicator for passing information to the loan application server.	VARCHAR2(1)	RPRLAPP	RPRLAPP_RECORD_TYPE	NO	NO
REPAYMENT_OPTION_CODE	Type of repayment option requested by the borrower.	VARCHAR2(1)	RPRLAPP	RPRLAPP_REPAY_OPT_IND	NO	NO
REQUESTED_AMT	Amount of loan that the applicant requests. This amount cannot be negative or zero.	NUMBER	RPRLAPP	RPRLAPP_REQUEST_AMT	NO	NO
REQUESTED_AWARD_END_DATE		DATE				NO
REQUESTED_AWARD_START_DATE		DATE				NO
RETURN_UID	Identification number for the agency/lender to whom unused funds are to be returned.	NUMBER	RPRLAPP	RPRLAPP_RETURN_PIDM	NO	NO
SERVICER_CONFIRMATION_DATE	Service provider confirmation date.	DATE	RPRLAPP	RPRLAPP_CONF_DATE	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_OF_RESIDENCE	State in the address of the borrower of a direct loan.	VARCHAR2(2)	RPRLAPP	RPRLAPP_STATE	NO	NO
STATE_PROVINCE_OF_RES_DESC	State/province name.	VARCHAR2(30)	STVSTAT	STVSTAT_DESC	NO	NO
STREET_LINE1	First line of the address.	VARCHAR2(75)	RPRLAPP	RPRLAPP_ADDRESS	NO	NO
STREET_LINE2	Second line of the address.	VARCHAR2(75)	RPRLAPP	RPRLAPP_ADDR_LINE2	NO	NO
STUDENT_EMAIL_ADDRESS	EMAIL ADDRESS: Student's email address.	VARCHAR2(128)	RPRLAPP	RPRLAPP_STU_EMAIL	NO	NO
STUDENT_MAJOR	Student's major field of study.	VARCHAR2(15)	RPRLAPP	RPRLAPP_STU_MAJOR	NO	NO
STUDENT_MAJOR_DESC	Major or subject area description.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC	NO	NO
SUBMISSION_DATE	Date the loan application was submitted.	DATE	RPRLAPP	RPRLAPP_SUB_DATE	NO	NO
TAX_ID	Student's tax identification number assigned by their home federal government as reported on the loan application.	VARCHAR2(15)	RPRLAPP	RPRLAPP_SSN	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.	VARCHAR2(21)	RPRLAPP	RPRLAPP_XREF_LOAN_ID	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: