Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Financial Aid Composite View Reports

Banner Operational Data Store
Composite View Target: AR_LOAN_APPLICATION

Description Source composite view contains loan application information for each person, fund and application number.

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: