Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Financial Aid Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: LOAN_APPLICATION

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

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

RPRLAPP

RPRLAPP_ACAD_YR_END_DATE

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

RPRLAPP

RPRLAPP_ACAD_YR_START_DATE

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

RPRLAPP

RPRLAPP_ADDL_STFD_ELIG_IND

ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

AGENCY_RETURN_ID Person's identification used to adjust the record. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

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

FUNCTION

F_FORMAT_NAME

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

RPRLAPP

RPRLAPP_AIDY_CODE

AID_YEAR_DESC Financial aid year name. VARCHAR2(255)

ROBINST

ROBINST_AIDY_DESC

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

RPRLAPP

RPRLAPP_ALIEN_REG_NO

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

RPRLAPP

RPRLAPP_ALT_BOR_LOAN_DEBT

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 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 Amount of loan requested by the applicant. This amount cannot be negative or zero. NUMBER

RPRLAPP

RPRLAPP_REQUEST_AMT

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

RPRLAPP

RPRLAPP_APPROVE_AMT

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

RPRLAPP

RPRLAPP_APPROVE_DATE

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)

RPRLAPP

RPRLAPP_BATCH_NO

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

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

RPRLAPP

RPRLAPP_BOR_OTH_INC

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

RPRLAPP

RPRLAPP_CANCEL_DATE

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

RPRLAPP

RPRLAPP_CANCEL_IND

CERTIFICATION_DATE Date that the loan application was certified. DATE

RPRLAPP

RPRLAPP_CERT_DATE

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

RPRLAPP

RPRLAPP_CITZ_IND

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

RPRLAPP

RPRLAPP_CITY

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

RPRLAPP

RPRLAPP_APP_VER_NO

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

RPRLAPP

RPRLAPP_EL_DATE_SENT

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

RPRLAPP

RPRLAPP_EL_LOAN_ID

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

RPRLAPP

RPRLAPP_EL_SEQ_NO

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

RPRLAPP

RPRLAPP_EL_STATUS

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

RPRLAPP

RPRLAPP_LNST_CODE

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

RPRLAPP

RPRLAPP_COSIGN1_GROSS_YR_SAL

COSIGN1_BIRTH_DATE First cosigner's date of birth. DATE

RPRLAPP

RPRLAPP_COSIGN1_BIRTH_DATE

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

RPRLAPP

RPRLAPP_COSIGN1_CITZ_IND

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

RPRLAPP

RPRLAPP_COSIGN1_CITY

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

RPRLAPP

RPRLAPP_COSIGN1_DRIVER_LIC_NO

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

STVSTAT

STVSTAT_DESC

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

RPRLAPP

RPRLAPP_COSIGN1_STAT_CODE_LIC

COSIGN1_FIRST_NAME First name of the cosigner. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN1_FIRST_NAME

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

RPRLAPP

RPRLAPP_COSIGN1_FOR_POST_CDE

COSIGN1_LAST_NAME Last name of the cosigner. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN1_LAST_NAME

COSIGN1_MIDDLE_INITIAL Middle initial of the cosigner. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN1_MI

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

COSIGN1_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 Postal code of the cosigner's last known address. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN1_ZIP

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

RPRLAPP

RPRLAPP_COSIGN1_RELATION_IND

COSIGN1_RELATIONSHIP_DESC Cosigner's relationship description. VARCHAR2(255)

CALCULATION

DECODE(RPRLAPP_COSIGN1_RELATION_IND)

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

RPRLAPP

RPRLAPP_COSIGN1_SIGNED_IND

COSIGN1_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 Name of the state/province of the first cosigner's last known address. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

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

RPRLAPP

RPRLAPP_COSIGN1_ADDR_LINE1

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

RPRLAPP

RPRLAPP_COSIGN1_ADDR_LINE2

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

RPRLAPP

RPRLAPP_COSIGN1_SUFFIX

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

RPRLAPP

RPRLAPP_COSIGN1_SSN

COSIGN1_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 Total income earned by cosigner 2 from his or her primary employment. NUMBER

RPRLAPP

RPRLAPP_COSIGN2_GROSS_YR_SAL

COSIGN2_BIRTH_DATE Second cosigner's date of birth. DATE

RPRLAPP

RPRLAPP_COSIGN2_BIRTH_DATE

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

RPRLAPP

RPRLAPP_COSIGN2_CITZ_IND

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

RPRLAPP

RPRLAPP_COSIGN2_CITY

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

RPRLAPP

RPRLAPP_COSIGN2_DRIVER_LIC_NO

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

STVSTAT

STVSTAT_DESC

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

RPRLAPP

RPRLAPP_COSIGN2_STAT_CODE_LIC

COSIGN2_FIRST_NAME First name of the cosigner. VARCHAR2(63)

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. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN2_FOR_POST_CDE

COSIGN2_LAST_NAME Last name of the cosigner. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN2_LAST_NAME

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

RPRLAPP

RPRLAPP_COSIGN2_MI

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

COSIGN2_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 Postal code of the cosigner's last known address. VARCHAR2(63)

RPRLAPP

RPRLAPP_COSIGN2_ZIP_CODE

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

RPRLAPP

RPRLAPP_COSIGN2_RELATION_IND

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

CALCULATION

DECODE(RPRLAPP_COSIGN2_RELATION_IND)

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

RPRLAPP

RPRLAPP_COSIGN2_SIGNED_IND

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

RPRLAPP

RPRLAPP_COSIGN2_STAT_CODE

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

STVSTAT

STVSTAT_DESC

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

RPRLAPP

RPRLAPP_COSIGN2_ADDR_LINE1

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

RPRLAPP

RPRLAPP_COSIGN2_ADDR_LINE2

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

RPRLAPP

RPRLAPP_COSIGN2_SUFFIX

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

RPRLAPP

RPRLAPP_COSIGN2_SSN

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

RPRLAPP

RPRLAPP_COSIGN2_YR_ADDRESS

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

RPRLAPP

RPRLAPP_CRED_DIF_NM_IND

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

RPRLAPP

RPRLAPP_IN_DEFAULT

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

CALCULATION

DECODE(RPRLAPP_IN_DEFAULT)

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

RPRLAPP

RPRLAPP_MODEL_CDE

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

RPRLAPP

RPRLAPP_DL_SENT_DATE

DIRECT_LOAN_ID Identifies a specific loan application. VARCHAR2(63)

RPRLAPP

RPRLAPP_DL_LOAN_ID

DIRECT_LOAN_NUMBER System generated sequence number to designate direct loan applications. NUMBER

RPRLAPP

RPRLAPP_DL_SEQ_NO

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

RPRLAPP

RPRLAPP_DL_STATUS

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

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. VARCHAR2(63)

RPRLAPP

RPRLAPP_DISC_PRINT_IND

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

RPRLAPP

RPRLAPP_DISC_NEED_PRINT_FLAG

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

RPRLAPP

RPRLAPP_DL_RECON_STATUS

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

RPRLAPP

RPRLAPP_DL_RECON_REJECT_1

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

RPRLAPP

RPRLAPP_DL_RECON_REJECT_2

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

RPRLAPP

RPRLAPP_DL_RECON_REJECT_3

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

RPRLAPP

RPRLAPP_DL_RECON_REJECT_4

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

RPRLAPP

RPRLAPP_DL_RECON_REJECT_5

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

RPRLAPP

RPRLAPP_MPN_STATUS_IND

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)

RPRLAPP

RPRLAPP_DL_REJECT_CODE_1

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)

RPRLAPP

RPRLAPP_DL_REJECT_CODE_2

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)

RPRLAPP

RPRLAPP_DL_REJECT_CODE_3

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)

RPRLAPP

RPRLAPP_DL_REJECT_CODE_4

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)

RPRLAPP

RPRLAPP_DL_REJECT_CODE_5

DL_REBATE_FEE_PERCENT Rebate fee percent. NUMBER

RPRLAPP

RPRLAPP_DL_REBATE_PERCENT

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

RPRLAPP

RPRLAPP_DRIVER_LIC_NO

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

RPRLAPP

RPRLAPP_STAT_CODE_LIC

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

STVSTAT

STVSTAT_DESC

EMAIL_ADDRESS Preferred email address. VARCHAR2(255)

RPRLAPP

RPRLAPP_STU_EMAIL

ENROLL_START_DATE Enrollment start date. DATE

RPRLAPP

RPRLAPP_ENROLL_START_DATE

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

RPRLAPP

RPRLAPP_EXPECT_AMT

EXPECTED_GRADUATION_DATE Expected graduation date. DATE

RPRLAPP

RPRLAPP_EXP_GRAD_DATE

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

CALCULATION

NVL(RPRLAPP_FIRST_NAME, MGKFUNC.F_GET_PERSON_INFO)

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

RPRLAPP

RPRLAPP_FORMER_HEAL_IND

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

RPRLAPP

RPRLAPP_FUND_CODE

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

RFRBASE

RFRBASE_FUND_TITLE

GIVE_PLUS_TO_STUDENT_IND Plus to student indicator. VARCHAR2(63)

RPRLAPP

RPRLAPP_PLUS_TO_STUDENT

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

SPRIDEN

SPRIDEN_ID

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

FUNCTION

F_FORMAT_NAME

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

RPRLAPP

RPRLAPP_HEAL_DEBT

ID Person's or organization's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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 Student's last name as reported on the loan application. VARCHAR2(63)

CALCULATION

NVL(RPRLAPP_LAST_NAME, MGKFUNC.F_GET_PERSON_INFO)

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

SPRIDEN

SPRIDEN_ID

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

FUNCTION

F_FORMAT_NAME

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

RPRLAPP

RPRLAPP_APPL_NO

LOAN_APPLICATION_RECEIVED_DATE Date that the loan application was received. DATE

RPRLAPP

RPRLAPP_RECEIVE_DATE

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

RPRLAPP

RPRLAPP_CREATE_DATE

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

RPRLAPP

RPRLAPP_FEE_PCT

LOAN_PERIOD Period covered by the loan. VARCHAR2(63)

RPRLAPP

RPRLAPP_LOAN_PERIOD

LOAN_PERIOD_DESC Loan Period description. VARCHAR2(255)

RPBLPRD

RPBLPRD_DESC

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

RPRLAPP

RPRLAPP_RECOMMEND_AMT

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

RPRLAPP

RPRLAPP_LNST_CODE

LOAN_STATUS_DESC Loan status description. VARCHAR2(255)

RTVLNST

RTVLNST_DESC

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

RPRLAPP

RPRLAPP_LOCAL_CITY

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

RPRLAPP

RPRLAPP_LOCAL_NATN_CODE

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

STVNATN

STVNATN_NATION

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

RPRLAPP

RPRLAPP_LOCAL_PHONE_NO

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

RPRLAPP

RPRLAPP_LOCAL_ZIP

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

RPRLAPP

RPRLAPP_LOCAL_STAT_CODE

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

STVSTAT

STVSTAT_DESC

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

RPRLAPP

RPRLAPP_LOCAL_ADDRESS

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

RPRLAPP

RPRLAPP_LOCAL_ADDR_LINE2

LOCK_INDICATOR Hold indicator. VARCHAR2(63)

RPRLAPP

RPRLAPP_HOLD_IND

MAJOR Student's major field of study. VARCHAR2(63)

RPRLAPP

RPRLAPP_STU_MAJOR

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

STVMAJR

STVMAJR_DESC

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

RPRLAPP

RPRLAPP_MAX_ELIG_AMT

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

CALCULATION

NVL(RPRLAPP_MI, MGKFUNC.F_GET_PERSON_INFO)

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

RPRLAPP

RPRLAPP_MPN_BATCH_ID

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

RPRLAPP

RPRLAPP_MPN_ID

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NATION Nation/country code associated with the address of the borrower. VARCHAR2(63)

RPRLAPP

RPRLAPP_NATN_CODE

NATION_DESC Address nation/country description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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 Borrower's total other student educational loan debt prior to the requested loan period. NUMBER

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. VARCHAR2(63)

RPRLAPP

RPRLAPP_OWES_REFUND

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

RPRLAPP

RPRLAPP_PAR_ALIEN_REG_NO

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

RPRLAPP

RPRLAPP_PAR_BIRTH_DATE

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

RPRLAPP

RPRLAPP_PAR_CITZ_IND

PARENT_CITY City of the parent when a direct loan is of a parent type. VARCHAR2(63)

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. VARCHAR2(63)

RPRLAPP

RPRLAPP_PAR_IN_DEFAULT

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

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. VARCHAR2(63)

RPRLAPP

RPRLAPP_PAR_STAT_CODE_LIC

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

FUNCTION

GOKODSF.F_GET_DESC

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

RPRLAPP

RPRLAPP_PAR_FIRST_NAME

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

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. VARCHAR2(63)

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. VARCHAR2(63)

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. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

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. VARCHAR2(63)

RPRLAPP

RPRLAPP_PAR_LOCAL_STAT_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

RPRLAPP

RPRLAPP_PAR_LOCAL_ADDRESS

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

RPRLAPP

RPRLAPP_PAR_LOCAL_ADDR_LINE2

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

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. VARCHAR2(63)

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. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PARENT_PHONE_NUMBER_COMBINED Phone number of the parent when a direct loan is of a parent type. VARCHAR2(63)

RPRLAPP

RPRLAPP_PAR_PHONE_NO

PARENT_POSTAL_CODE Postal code of the parent when a direct loan is of a parent type. VARCHAR2(63)

RPRLAPP

RPRLAPP_PAR_ZIP

PARENT_STATE_PROVINCE State/province of the parent when a direct loan is of a parent type. VARCHAR2(63)

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. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

RPRLAPP

RPRLAPP_PAR_STAT_CODE_RES

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

FUNCTION

GOKODSF.F_GET_DESC

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

RPRLAPP

RPRLAPP_PAR_ADDRESS

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

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. VARCHAR2(63)

RPRLAPP

RPRLAPP_PAR_SSN

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

RPRLAPP

RPRLAPP_PERKINS_DEBT

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

RPRLAPP

RPRLAPP_PIDM

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

RPRLAPP

RPRLAPP_PHONE_NO

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

RPRLAPP

RPRLAPP_CREDIT_CHECK_DATE

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

RPRLAPP

RPRLAPP_CREDIT_CHECK_IND

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

RPRLAPP

RPRLAPP_ZIP

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

RPRLAPP

RPRLAPP_APP_PHASE_CDE

PROCESS_DATE Date the loan application was processed. DATE

RPRLAPP

RPRLAPP_PROCESS_DATE

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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

RPRLAPP

RPRLAPP_PN_DATE

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

RPRLAPP

RPRLAPP_RECORD_TYPE

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

RPRLAPP

RPRLAPP_REPAY_OPT_IND

SERVICER_CONFIRMATION_DATE Service provider confirmation date. 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. NUMBER

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

RPRLAPP

RPRLAPP_STAF_LOAN_DEBT

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

RPRLAPP

RPRLAPP_STATE

STATE_PROVINCE_DESC State/province name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

STREET_LINE1 First line of the address. VARCHAR2(255)

RPRLAPP

RPRLAPP_ADDRESS

STREET_LINE2 Second line of the address. VARCHAR2(255)

RPRLAPP

RPRLAPP_ADDR_LINE2

SUBMISSION_DATE Date the loan application was submitted. DATE

RPRLAPP

RPRLAPP_SUB_DATE

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

CALCULATION

NVL(RPRLAPP_SSN, MGKFUNC.F_GET_PERSON_INFO)

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(63)

RPRLAPP

RPRLAPP_XREF_LOAN_ID



Ver: 8.0