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

SGHE 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.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACAD_YEAR_END_DATE Date on which the student's academic year ends at the institution.    

RPRLAPP

RPRLAPP_ACAD_YR_END_DATE

 
ACAD_YEAR_START_DATE Date on which the student's academic year starts at the institution.    

RPRLAPP

RPRLAPP_ACAD_YR_START_DATE

 
ADDL_STAFFORD_ELIG_IND Indicates whether this dependent student is eligible for an additional unsubsidized loan amount.    

RPRLAPP

RPRLAPP_ADDL_STFD_ELIG_IND

 
AID_YEAR Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005).    

RPRLAPP

RPRLAPP_AIDY_CODE

 
AID_YEAR_DESC Financial aid year name.    

ROBINST

ROBINST_AIDY_DESC

 
ALIEN_REGISTRATION_NO Student's alien registration number (when applicable).    

RPRLAPP

RPRLAPP_ALIEN_REG_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.    

RPRLAPP

RPRLAPP_ALT_BOR_LOAN_DEBT

 
ALT_LOAN_PROGRAM_TYPE Indicates the specific category of alternative loan for reporting.    

RPRLAPP

RPRLAPP_ALT_LOAN_PROG_TYPE_CDE

 
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.    

RPRLAPP

RPRLAPP_ALT_LOAN_SB_IND

 
APPROVED_AMT Loan amount that was approved by the approving agency.    

RPRLAPP

RPRLAPP_APPROVE_AMT

 
APPROVED_DATE Date the loan was approved by the approving agency.    

RPRLAPP

RPRLAPP_APPROVE_DATE

 
APP_PHASE_CODE Current processing phase for the application or loan.    

RPRLAPP

RPRLAPP_APP_PHASE_CDE

 
APP_RECEIVED_DATE Date that the loan application was received.    

RPRLAPP

RPRLAPP_RECEIVE_DATE

 
APP_VERSION_NO Version of the common line application file has been sent once the loan application has been extracted.    

RPRLAPP

RPRLAPP_APP_VER_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.    

RPRLAPP

RPRLAPP_BATCH_NO

 
BOOKING_STATUS Overall reconciliation status from the servicer (loan origination center) for this loan.    

RPRLAPP

RPRLAPP_DL_RECON_STATUS

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

RPRLAPP

RPRLAPP_BOR_GROSS_YR_SAL

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

RPRLAPP

RPRLAPP_BOR_OTH_INC

 
CANCEL_DATE Date the loan was cancelled.    

RPRLAPP

RPRLAPP_CANCEL_DATE

 
CANCEL_IND Indicates whether a direct loan was canceled/inactivated for this student.    

RPRLAPP

RPRLAPP_CANCEL_IND

 
CERTIFICATION_DATE Date that the loan application was certified.    

RPRLAPP

RPRLAPP_CERT_DATE

 
CITIZEN_IND Indicates whether the person has been identified as a citizen of the institution's home country.    

RPRLAPP

RPRLAPP_CITZ_IND

 
CITY Address city, town or municipality.    

RPRLAPP

RPRLAPP_CITY

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

RPRLAPP

RPRLAPP_COSIGN1_GROSS_YR_SAL

 
COSIGN1_BIRTH_DATE First cosigner's date of birth.    

RPRLAPP

RPRLAPP_COSIGN1_BIRTH_DATE

 
COSIGN1_CITIZEN_IND A 1-digit code indicating the first cosigner's citizenship status.    

RPRLAPP

RPRLAPP_COSIGN1_CITZ_IND

 
COSIGN1_CITY City of the first cosigner's last known address.    

RPRLAPP

RPRLAPP_COSIGN1_CITY

 
COSIGN1_DRIVER_LIC_NO First cosigner's driver's license number.    

RPRLAPP

RPRLAPP_COSIGN1_DRIVER_LIC_NO

 
COSIGN1_DRIVER_LIC_STAT 2-character abbreviation for the state that issued the first cosigner's driver's license.    

RPRLAPP

RPRLAPP_COSIGN1_STAT_CODE_LIC

 
COSIGN1_DRIVER_LIC_STAT_DESC Name of the state/province that issued the first cosigner's driver's license.    

STVSTAT

STVSTAT_DESC

 
COSIGN1_FIRST_NAME First name of the cosigner.    

RPRLAPP

RPRLAPP_COSIGN1_FIRST_NAME

 
COSIGN1_FOREIGN_POSTAL_CODE Foreign postal code of the cosigner's last known address.    

RPRLAPP

RPRLAPP_COSIGN1_FOR_POST_CDE

 
COSIGN1_LAST_NAME Last name of the cosigner.    

RPRLAPP

RPRLAPP_COSIGN1_LAST_NAME

 
COSIGN1_MIDDLE_INITIAL Middle initial of the cosigner.    

RPRLAPP

RPRLAPP_COSIGN1_MI

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

RPRLAPP

RPRLAPP_COSIGN1_OTH_INC

 
COSIGN1_PHONE_NUMBER_COMBINED First cosigner's last known telephone home number. Includes the area code.    

RPRLAPP

RPRLAPP_COSIGN1_PHONE_NO

 
COSIGN1_POSTAL_CODE Postal code of the cosigner's last known address.    

RPRLAPP

RPRLAPP_COSIGN1_ZIP

 
COSIGN1_RELATIONSHIP First cosigner's relationship to the student.    

RPRLAPP

RPRLAPP_COSIGN1_RELATION_IND

 
COSIGN1_RELATIONSHIP_DESC COSIGNER 1 RELATIONSHIP TO STUDENT DESC: The description of the cosigner's relationship.    

CALCULATION

DECODE(RPRLAPP_COSIGN1_RELATION_IND)

 
COSIGN1_SIGNATURE_IND A 1-character code indicating if the signature of the first cosigner is present.    

RPRLAPP

RPRLAPP_COSIGN1_SIGNED_IND

 
COSIGN1_STATE_PROVINCE 2-character state abbreviation of the first cosigner's last known address.    

RPRLAPP

RPRLAPP_COSIGN1_STAT_CODE

 
COSIGN1_STATE_PROVINCE_DESC Name of the state/province of the first cosigner's last known address.    

STVSTAT

STVSTAT_DESC

 
COSIGN1_STREET_LINE1 First line of the first cosigner's last known address.    

RPRLAPP

RPRLAPP_COSIGN1_ADDR_LINE1

 
COSIGN1_STREET_LINE2 Second line of the first cosigner's last known address.    

RPRLAPP

RPRLAPP_COSIGN1_ADDR_LINE2

 
COSIGN1_SUFFIX Suffix of the first cosigner's name.    

RPRLAPP

RPRLAPP_COSIGN1_SUFFIX

 
COSIGN1_TAX_ID Social security number of the cosigner.    

RPRLAPP

RPRLAPP_COSIGN1_SSN

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

RPRLAPP

RPRLAPP_COSIGN1_YR_ADDRESS

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

RPRLAPP

RPRLAPP_COSIGN2_GROSS_YR_SAL

 
COSIGN2_BIRTH_DATE Second cosigner's date of birth.    

RPRLAPP

RPRLAPP_COSIGN2_BIRTH_DATE

 
COSIGN2_CITIZEN_IND A 1-digit code indicating the second cosigner's citizenship status.    

RPRLAPP

RPRLAPP_COSIGN2_CITZ_IND

 
COSIGN2_CITY City of the second cosigner's last known address.    

RPRLAPP

RPRLAPP_COSIGN2_CITY

 
COSIGN2_DRIVER_LIC_NO Second cosigner's driver's license number.    

RPRLAPP

RPRLAPP_COSIGN2_DRIVER_LIC_NO

 
COSIGN2_DRIVER_LIC_STAT_PROV Two-character abbreviation for the state that issued the second cosigner's drivers license.    

RPRLAPP

RPRLAPP_COSIGN2_STAT_CODE_LIC

 
COSIGN2_DRIVER_LIC_ST_PR_DESC Name of the state/province that issued the second cosigner's driver's license.    

STVSTAT

STVSTAT_DESC

 
COSIGN2_FIRST_NAME First name of the cosigner.    

RPRLAPP

RPRLAPP_COSIGN2_FIRST_NAME

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

RPRLAPP

RPRLAPP_COSIGN2_FOR_POST_CDE

 
COSIGN2_LAST_NAME Last name of the cosigner.    

RPRLAPP

RPRLAPP_COSIGN2_LAST_NAME

 
COSIGN2_MIDDLE_INITIAL Middle initial of the second cosigner.    

RPRLAPP

RPRLAPP_COSIGN2_MI

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

RPRLAPP

RPRLAPP_COSIGN2_OTH_INC

 
COSIGN2_PHONE_NUMBER_COMBINED Second cosigner's last known telephone home number. Includes the area code.    

RPRLAPP

RPRLAPP_COSIGN2_PHONE_NO

 
COSIGN2_POSTAL_CODE Postal code of the cosigner's last known address.    

RPRLAPP

RPRLAPP_COSIGN2_ZIP_CODE

 
COSIGN2_RELATIONSHIP Second cosigner's relationship to the student.    

RPRLAPP

RPRLAPP_COSIGN2_RELATION_IND

 
COSIGN2_RELATIONSHIP_DESC COSIGNER 2 RELATIONSHIP TO STUDENT DESC: The description of the second cosigner's relationship to the student.    

CALCULATION

DECODE(RPRLAPP_COSIGN2_RELATION_IND)

 
COSIGN2_SIGNATURE_IND A 1-character code indicating if the signature of the second cosigner is present.    

RPRLAPP

RPRLAPP_COSIGN2_SIGNED_IND

 
COSIGN2_STATE_PROVINCE State abbreviation of the second cosigner's last known address.    

RPRLAPP

RPRLAPP_COSIGN2_STAT_CODE

 
COSIGN2_STATE_PROVINCE_DESC Name of the state/province of the second cosigner's last known address.    

STVSTAT

STVSTAT_DESC

 
COSIGN2_STREET_LINE1 First line of the second cosigner's last known address.    

RPRLAPP

RPRLAPP_COSIGN2_ADDR_LINE1

 
COSIGN2_STREET_LINE2 Second line of the second cosigner's last known address.    

RPRLAPP

RPRLAPP_COSIGN2_ADDR_LINE2

 
COSIGN2_SUFFIX Suffix of the second cosigner's name.    

RPRLAPP

RPRLAPP_COSIGN2_SUFFIX

 
COSIGN2_TAX_ID Social security number of the cosigner.    

RPRLAPP

RPRLAPP_COSIGN2_SSN

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

RPRLAPP

RPRLAPP_COSIGN2_YR_ADDRESS

 
CREATE_DATE Date the loan application was created. For dl loans initialized by the loan origination batch process.    

RPRLAPP

RPRLAPP_CREATE_DATE

 
CREDIT_IN_DIFF_NAME_IND Indicates the borrower has been granted credit under a different name.    

RPRLAPP

RPRLAPP_CRED_DIF_NM_IND

 
CURRENT_DATE System current date (sysdate) or date the data was extracted.    

NA

SYSDATE

 
DEFAULT_IND Indicates whether this is the default type to be used.    

RPRLAPP

RPRLAPP_IN_DEFAULT

 
DEFAULT_IND_DESC Description of the loan default status.    

CALCULATION

DECODE(RPRLAPP_IN_DEFAULT)

 
DEPENDENCY_STATUS Identifies the student's dependency status as computed by INAS or loaded from the tape record.    

RPRLAPP

RPRLAPP_MODEL_CDE

 
DISCLOSURE_NEED_PRINT_FLAG New or revised disclosure statement needs to be printed for this loan record.    

RPRLAPP

RPRLAPP_DISC_NEED_PRINT_FLAG

 
DISCLOSURE_PRINT_DATE Last date that a disclosure statement was printed for this loan.    

RPRLAPP

RPRLAPP_DISC_PRINT_DATE

 
DISCLOSURE_PRINT_IND Indicates whether a new or revised disclosure statement needs to be printed for this loan and signed by the student.    

RPRLAPP

RPRLAPP_DISC_PRINT_IND

 
DL_LOAN_ID Identifies a specific loan application.    

RPRLAPP

RPRLAPP_DL_LOAN_ID

 
DL_LOAN_STATUS Origination status code, typically system maintained for direct loan applications.    

RPRLAPP

RPRLAPP_DL_STATUS

 
DL_REBATE_FEE_PERCENT Rebate fee percent.    

RPRLAPP

RPRLAPP_DL_REBATE_PERCENT

 
DL_RECON_REJECT1 First reconciliation reject code sent from the servicer (loan origination center) for this loan disbursement.    

RPRLAPP

RPRLAPP_DL_RECON_REJECT_1

 
DL_RECON_REJECT2 Second reconciliation reject code sent from the servicer (loan origination center) for this loan disbursement.    

RPRLAPP

RPRLAPP_DL_RECON_REJECT_2

 
DL_RECON_REJECT3 Third reconciliation reject code sent from the servicer (loan origination center) for this loan disbursement.    

RPRLAPP

RPRLAPP_DL_RECON_REJECT_3

 
DL_RECON_REJECT4 Fourth reconciliation reject code sent from the servicer (loan origination center) for this loan disbursement.    

RPRLAPP

RPRLAPP_DL_RECON_REJECT_4

 
DL_RECON_REJECT5 Fifth reconciliation reject code sent from the servicer (loan origination center) for this loan disbursement.    

RPRLAPP

RPRLAPP_DL_RECON_REJECT_5

 
DL_REJECT_CODE1 May contain a reject code from the dl servicer if the servicer did not accept the loan origination.    

RPRLAPP

RPRLAPP_DL_REJECT_CODE_1

 
DL_REJECT_CODE2 May contain a reject code from the dl servicer if the servicer did not accept the loan origination.    

RPRLAPP

RPRLAPP_DL_REJECT_CODE_2

 
DL_REJECT_CODE3 May contain a reject code from the dl servicer if the servicer did not accept the loan origination.    

RPRLAPP

RPRLAPP_DL_REJECT_CODE_3

 
DL_REJECT_CODE4 May contain a reject code from the dl servicer if the servicer did not accept the loan origination.    

RPRLAPP

RPRLAPP_DL_REJECT_CODE_4

 
DL_REJECT_CODE5 May contain a reject code from the dl servicer if the servicer did not accept the loan origination.    

RPRLAPP

RPRLAPP_DL_REJECT_CODE_5

 
DL_SENT_DATE Date that a direct loan origination record was sent to the service provider.    

RPRLAPP

RPRLAPP_DL_SENT_DATE

 
DL_SEQ_NO System generated sequence number to designate direct loan applications.    

RPRLAPP

RPRLAPP_DL_SEQ_NO

 
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined.    

NA

NA

 
DRIVER_LICENSE_NO Applicant's driver's license number as reported on the applicant's need analysis document.    

RPRLAPP

RPRLAPP_DRIVER_LIC_NO

 
DRIVER_LICENSE_STATE_PROVINCE State/province of the state in which the student holds a drivers license.    

RPRLAPP

RPRLAPP_STAT_CODE_LIC

 
DRIVER_LICENSE_ST_PR_DESC State/province description in which the student holds a drivers license.    

STVSTAT

STVSTAT_DESC

 
EL_DATE_SENT Date the loan was sent to the loan service provider (common line).    

RPRLAPP

RPRLAPP_EL_DATE_SENT

 
EL_LOAN_ID Loan identification number used by electronic loan processing (common line).    

RPRLAPP

RPRLAPP_EL_LOAN_ID

 
EL_LOAN_STATUS Status of a loan processed via electronic loan processing (common line).    

RPRLAPP

RPRLAPP_EL_STATUS

 
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).    

RPRLAPP

RPRLAPP_EL_PROCESS_TYPE

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

RPRLAPP

RPRLAPP_EL_SEQ_NO

 
ENROLL_START_DATE Enrollment start date.    

RPRLAPP

RPRLAPP_ENROLL_START_DATE

 
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.    

RPRLAPP

RPRLAPP_EXPECT_AMT

 
EXPECTED_GRAD_DATE Program completion date of a student in a direct loan application.    

RPRLAPP

RPRLAPP_EXP_GRAD_DATE

 
FIRST_NAME Student's first name as reported on the loan application.    

RPRLAPP

RPRLAPP_FIRST_NAME

 
FORMER_HEAL_IND Indicator of student qualification for additional Stafford unsubsidized loans in replacement of the heal loan program.    

RPRLAPP

RPRLAPP_FORMER_HEAL_IND

 
FUND Financial Aid Fund code to be associated with information in this record.    

RPRLAPP

RPRLAPP_FUND_CODE

 
FUND_TITLE Full title of the financial aid fund code.    

RFRBASE

RFRBASE_FUND_TITLE

 
GUARANTOR_UID System generated, unique, internal identification number assigned to this person or organization entity.    

RPRLAPP

RPRLAPP_GUAR_PIDM

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

RPRLAPP

RPRLAPP_HEAL_DEBT

 
INTEREST_RATE_OPTION_CODE Indicates the type of interest rate associated with the loan (e.g., fixed or variable).    

RPRLAPP

RPRLAPP_INT_RATE_OPT_IND

 
LAST_NAME Student's last name as reported on the loan application.    

RPRLAPP

RPRLAPP_LAST_NAME

 
LENDER_UID System generated, unique, internal identification number assigned to this person or organization entity.    

RPRLAPP

RPRLAPP_LENDER_PIDM

 
LOAN_APPLICATION_NO System assigned number is assigned when the application is added.    

RPRLAPP

RPRLAPP_APPL_NO

 
LOAN_FEE Percentage of the loan that is subtracted from the loan proceeds because of origination fees, etc.    

RPRLAPP

RPRLAPP_FEE_PCT

 
LOAN_PERIOD Period covered by the loan.    

RPRLAPP

RPRLAPP_LOAN_PERIOD

 
LOAN_PERIOD_DESC Loan period description.    

RPBLPRD

RPBLPRD_DESC

 
LOAN_STATUS Identifies the current status of the loan in processing.    

RPRLAPP

RPRLAPP_LNST_CODE

 
LOAN_STATUS_DESC Loan status description.    

RTVLNST

RTVLNST_DESC

 
LOCAL_CITY City in the local address of the borrower of a direct loan.    

RPRLAPP

RPRLAPP_LOCAL_CITY

 
LOCAL_NATION Nation/country associated with the local address of the borrower.    

RPRLAPP

RPRLAPP_LOCAL_NATN_CODE

 
LOCAL_NATION_DESC Nation/country description for borrower's local address.    

STVNATN

STVNATN_NATION

 
LOCAL_PHONE_NUMBER_COMBINED Local phone number of the borrower of a direct loan.    

RPRLAPP

RPRLAPP_LOCAL_PHONE_NO

 
LOCAL_POSTAL_CODE Postal code in the local address of the borrower of a direct loan.    

RPRLAPP

RPRLAPP_LOCAL_ZIP

 
LOCAL_STATE_PROVINCE State in the local address of the borrower of a direct loan.    

RPRLAPP

RPRLAPP_LOCAL_STAT_CODE

 
LOCAL_STATE_PROVINCE_DESC State description of the local address of the borrower of a direct loan.    

STVSTAT

STVSTAT_DESC

 
LOCAL_STREET_LINE1 Local address of the borrower of a direct loan.    

RPRLAPP

RPRLAPP_LOCAL_ADDRESS

 
LOCAL_STREET_LINE2 Second line of student's local street address.    

RPRLAPP

RPRLAPP_LOCAL_ADDR_LINE2

 
LOCK_IND Hold indicator.    

RPRLAPP

RPRLAPP_HOLD_IND

 
MAXIMUM_ELIGIBLE_AMT Maximum loan amount for which the student is eligible. (The processed amount.).    

RPRLAPP

RPRLAPP_MAX_ELIG_AMT

 
MIDDLE_INITIAL The student's middle initial as reported on the loan application.    

RPRLAPP

RPRLAPP_MI

 
MIF_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
MPN_BATCH_ID Batch identification number used to report the master promissory note status and identification number.    

RPRLAPP

RPRLAPP_MPN_BATCH_ID

 
MPN_ID Identification number printed on the master promissory note associated with this loan.    

RPRLAPP

RPRLAPP_MPN_ID

 
MPN_STATUS_IND Status of the borrower's master promissory note at the loan origination center (loc).    

RPRLAPP

RPRLAPP_MPN_STATUS_IND

 
NATION Nation/country code associated with the address of the borrower.    

RPRLAPP

RPRLAPP_NATN_CODE

 
NATION_DESC Address nation/country description.    

STVNATN

STVNATN_NATION

 
OTHER_LOANS_FOR_LN_PERIOD Borrower's total other student educational loan debt for the requested loan period.    

RPRLAPP

RPRLAPP_OTH_LOANS_PERIOD

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

RPRLAPP

RPRLAPP_OTHER_DEBT

 
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.    

RPRLAPP

RPRLAPP_OWES_REFUND

 
PARENT_ALIEN_REGISTRATION_NO Alien registration of the parent when a direct loan is of a parent type.    

RPRLAPP

RPRLAPP_PAR_ALIEN_REG_NO

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

RPRLAPP

RPRLAPP_PAR_BIRTH_DATE

 
PARENT_CITIZEN_IND Citizen indicator of the parent when a direct loan is of a parent type.    

RPRLAPP

RPRLAPP_PAR_CITZ_IND

 
PARENT_CITY City of the parent when a direct loan is of a parent type.    

RPRLAPP

RPRLAPP_PAR_CITY

 
PARENT_DEFAULT_IND Indicates whether the borrower of a direct loan is in default or owes a refund on a grant.    

RPRLAPP

RPRLAPP_PAR_IN_DEFAULT

 
PARENT_DRIVER_LICENSE_NO Driver license number of the parent when a direct loan is of a parent type.    

RPRLAPP

RPRLAPP_PAR_DRIVER_LIC_NO

 
PARENT_DRIVER_LIC_STATE_PROV State/province issuing the driver's license when a direct loan is of a parent type.    

RPRLAPP

RPRLAPP_PAR_STAT_CODE_LIC

 
PARENT_DRIVER_LIC_ST_PR_DESC State license code description for the parent when a direct loan is of a parent type.    

STVSTAT

STVSTAT_DESC

 
PARENT_FIRST_NAME First name of the parent when a direct loan is of a parent type.    

RPRLAPP

RPRLAPP_PAR_FIRST_NAME

 
PARENT_LAST_NAME Last name of the parent when a direct loan is of a parent type.    

RPRLAPP

RPRLAPP_PAR_LAST_NAME

 
PARENT_LOCAL_CITY City in the local address of the parent when a direct loan is of a parent type.    

RPRLAPP

RPRLAPP_PAR_LOCAL_CITY

 
PARENT_LOCAL_NATION Nation/country associated with the local address of the parent when a direct loan is of a parent type.    

RPRLAPP

RPRLAPP_PAR_LOCAL_NATN_CODE

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

STVNATN

STVNATN_NATION

 
PARENT_LOCAL_POSTAL_CODE Postal code in the local address of the parent when a direct loan is of a parent type.    

RPRLAPP

RPRLAPP_PAR_LOCAL_ZIP

 
PARENT_LOCAL_STATE_PROVINCE State/province in the local address of the parent when a direct loan is of a parent type.    

RPRLAPP

RPRLAPP_PAR_LOCAL_STAT_CODE

 
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.    

STVSTAT

STVSTAT_DESC

 
PARENT_LOCAL_STREET_LINE1 Local address of the parent when a direct loan is of a parent type.    

RPRLAPP

RPRLAPP_PAR_LOCAL_ADDRESS

 
PARENT_LOCAL_STREET_LINE2 Second line of parent's local street address.    

RPRLAPP

RPRLAPP_PAR_LOCAL_ADDR_LINE2

 
PARENT_MIDDLE_INITIAL Middle initial of the parent when a direct loan is of a parent type.    

RPRLAPP

RPRLAPP_PAR_MI

 
PARENT_NATION Nation/country associated with the address of the parent of the borrower when the loan is of a parent type.    

RPRLAPP

RPRLAPP_PAR_NATN_CODE

 
PARENT_NATION_DESC Nation/country description for the borrower's parent's address when the loan is of a parent type.    

STVNATN

STVNATN_NATION

 
PARENT_PHONE_NUMBER_COMBINED Phone number of the parent when a direct loan is of a parent type.    

RPRLAPP

RPRLAPP_PAR_PHONE_NO

 
PARENT_POSTAL_CODE Postal code of the parent when a direct loan is of a parent type.    

RPRLAPP

RPRLAPP_PAR_ZIP

 
PARENT_STATE_PROVINCE State/province of the parent when a direct loan is of a parent type.    

RPRLAPP

RPRLAPP_PAR_STATE

 
PARENT_STATE_PROVINCE_DESC Name of the state/province of the parent when a direct loan is of a parent type.    

STVSTAT

STVSTAT_DESC

 
PARENT_STATE_PROVINCE_OF_RES State/Province in which the parent of the applicant is a legal resident.    

RPRLAPP

RPRLAPP_PAR_STAT_CODE_RES

 
PARENT_STATE_PROV_OF_RES_DESC Name of the state/province in which the parent of the applicant is a legal resident.    

STVSTAT

STVSTAT_DESC

 
PARENT_STREET_LINE1 Address of the parent when a direct loan is of a parent type.    

RPRLAPP

RPRLAPP_PAR_ADDRESS

 
PARENT_STREET_LINE2 Second line of parent's permanent street address.    

RPRLAPP

RPRLAPP_PAR_ADDR_LINE2

 
PARENT_TAX_ID Tax identification number or social security number of the parent when a direct loan is of a parent type.    

RPRLAPP

RPRLAPP_PAR_SSN

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

RPRLAPP

RPRLAPP_PERKINS_DEBT

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

RPRLAPP

RPRLAPP_PIDM

 
PHONE_NUMBER_COMBINED All recorded pieces of the telephone number combined in a single field. International code, area code, number, extension.    

RPRLAPP

RPRLAPP_PHONE_NO

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

RPRLAPP

RPRLAPP_CREDIT_CHECK_DATE

 
PLUS_CREDIT_CHECK_STATUS Status of the plus loan credit check on the parent.    

RPRLAPP

RPRLAPP_CREDIT_CHECK_IND

 
PLUS_TO_STUDENT_IND Plus to student indicator.    

RPRLAPP

RPRLAPP_PLUS_TO_STUDENT

 
POSTAL_CODE Postal code in the address of the borrower of a direct loan.    

RPRLAPP

RPRLAPP_ZIP

 
PROCESS_DATE Date the loan application was processed.    

RPRLAPP

RPRLAPP_PROCESS_DATE

 
PROM_NOTE_DATE Date the borrower signed the promissory note for the loan.    

RPRLAPP

RPRLAPP_PN_DATE

 
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.    

RPRLAPP

RPRLAPP_RECOMMEND_AMT

 
RECORD_TYPE Record type indicator for passing information to the loan application server.    

RPRLAPP

RPRLAPP_RECORD_TYPE

 
REPAYMENT_OPTION_CODE Type of repayment option requested by the borrower.    

RPRLAPP

RPRLAPP_REPAY_OPT_IND

 
REQUESTED_AMT Amount of loan that the applicant requests. This amount cannot be negative or zero.    

RPRLAPP

RPRLAPP_REQUEST_AMT

 
RETURN_UID Identification number for the agency/lender to whom unused funds are to be returned.    

RPRLAPP

RPRLAPP_RETURN_PIDM

 
SERVICER_CONFIRMATION_DATE Service provider confirmation date.    

RPRLAPP

RPRLAPP_CONF_DATE

 
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.    

RPRLAPP

RPRLAPP_SLS_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.    

RPRLAPP

RPRLAPP_STAF_LOAN_DEBT

 
STATE_PROVINCE_OF_RESIDENCE State in the address of the borrower of a direct loan.    

RPRLAPP

RPRLAPP_STATE

 
STATE_PROVINCE_OF_RES_DESC State/province name.    

STVSTAT

STVSTAT_DESC

 
STREET_LINE1 First line of the address.    

RPRLAPP

RPRLAPP_ADDRESS

 
STREET_LINE2 Second line of the address.    

RPRLAPP

RPRLAPP_ADDR_LINE2

 
STUDENT_EMAIL_ADDRESS EMAIL ADDRESS: Student's email address.    

RPRLAPP

RPRLAPP_STU_EMAIL

 
STUDENT_MAJOR Student's major field of study.    

RPRLAPP

RPRLAPP_STU_MAJOR

 
STUDENT_MAJOR_DESC Major or subject area description.    

STVMAJR

STVMAJR_DESC

 
SUBMISSION_DATE Date the loan application was submitted.    

RPRLAPP

RPRLAPP_SUB_DATE

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

RPRLAPP

RPRLAPP_SSN

 
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.    

RPRLAPP

RPRLAPP_XREF_LOAN_ID

 
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 


Ver: 8.3