RETURN TO COMPOSITE VIEW REPORTS LIST
Financial Aid Composite View Reports

SGHE 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
ACAD_YEAR_END_DATE Date on which the student's academic year ends at the institution. DATE

RPRLAPP

RPRLAPP_ACAD_YR_END_DATE

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

RPRLAPP

RPRLAPP_ACAD_YR_START_DATE

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

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

RPRLAPP

RPRLAPP_AIDY_CODE

AID_YEAR_DESC Financial aid year name. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

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

RPRLAPP

RPRLAPP_ALT_BOR_LOAN_DEBT

ALT_LOAN_PROGRAM_TYPE Indicates the specific category of alternative loan for reporting. VARCHAR2(3)

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

RPRLAPP

RPRLAPP_ALT_LOAN_SB_IND

APPROVED_AMT Loan amount that was approved by the approving agency. NUMBER(11, 2)

RPRLAPP

RPRLAPP_APPROVE_AMT

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

RPRLAPP

RPRLAPP_APPROVE_DATE

APP_PHASE_CODE Current processing phase for the application or loan. VARCHAR2(4)

RPRLAPP

RPRLAPP_APP_PHASE_CDE

APP_RECEIVED_DATE Date that the loan application was received. DATE

RPRLAPP

RPRLAPP_RECEIVE_DATE

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

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

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

RPRLAPP

RPRLAPP_DL_RECON_STATUS

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

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

RPRLAPP

RPRLAPP_BOR_OTH_INC

CANCEL_DATE Date the loan was cancelled. DATE

RPRLAPP

RPRLAPP_CANCEL_DATE

CANCEL_IND Indicates whether a direct loan was canceled/inactivated for this student. VARCHAR2(1)

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

RPRLAPP

RPRLAPP_CITZ_IND

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

RPRLAPP

RPRLAPP_CITY

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

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

RPRLAPP

RPRLAPP_COSIGN1_CITZ_IND

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

RPRLAPP

RPRLAPP_COSIGN1_CITY

COSIGN1_DRIVER_LIC_NO First cosigner's driver's license number. VARCHAR2(20)

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

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

FUNCTION

GOKODSF.F_GET_DESC

COSIGN1_FIRST_NAME First name of the cosigner. VARCHAR2(12)

RPRLAPP

RPRLAPP_COSIGN1_FIRST_NAME

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

RPRLAPP

RPRLAPP_COSIGN1_FOR_POST_CDE

COSIGN1_LAST_NAME Last name of the cosigner. VARCHAR2(35)

RPRLAPP

RPRLAPP_COSIGN1_LAST_NAME

COSIGN1_MIDDLE_INITIAL Middle initial of the cosigner. VARCHAR2(1)

RPRLAPP

RPRLAPP_COSIGN1_MI

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

RPRLAPP

RPRLAPP_COSIGN1_OTH_INC

COSIGN1_PHONE_NUMBER_COMBINED First cosigner's last known telephone home number. Includes the area code. VARCHAR2(10)

RPRLAPP

RPRLAPP_COSIGN1_PHONE_NO

COSIGN1_POSTAL_CODE Postal code of the cosigner's last known address. VARCHAR2(9)

RPRLAPP

RPRLAPP_COSIGN1_ZIP

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

RPRLAPP

RPRLAPP_COSIGN1_RELATION_IND

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

CALCULATION

DECODE(RPRLAPP_COSIGN1_RELATION_IND)

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

RPRLAPP

RPRLAPP_COSIGN1_SIGNED_IND

COSIGN1_SSN Social security number of the cosigner. VARCHAR2(9)

RPRLAPP

RPRLAPP_COSIGN1_SSN

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

RPRLAPP

RPRLAPP_COSIGN1_STAT_CODE

COSIGN1_STATE_PROVINCE_DESC Name of the state/province of the first cosigner's last known address. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

RPRLAPP

RPRLAPP_COSIGN1_ADDR_LINE1

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

RPRLAPP

RPRLAPP_COSIGN1_ADDR_LINE2

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

RPRLAPP

RPRLAPP_COSIGN1_SUFFIX

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

RPRLAPP

RPRLAPP_COSIGN1_YR_ADDRESS

COSIGN2_ANNUAL_INCOME Total income earned by cosigner 2 from his or her primary employment. NUMBER(7)

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

RPRLAPP

RPRLAPP_COSIGN2_CITZ_IND

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

RPRLAPP

RPRLAPP_COSIGN2_CITY

COSIGN2_DRIVER_LIC_NO Second cosigner's driver's license number. VARCHAR2(20)

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

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

FUNCTION

GOKODSF.F_GET_DESC

COSIGN2_FIRST_NAME First name of the cosigner. VARCHAR2(12)

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

RPRLAPP

RPRLAPP_COSIGN2_FOR_POST_CDE

COSIGN2_LAST_NAME Last name of the cosigner. VARCHAR2(35)

RPRLAPP

RPRLAPP_COSIGN2_LAST_NAME

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

RPRLAPP

RPRLAPP_COSIGN2_MI

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

RPRLAPP

RPRLAPP_COSIGN2_OTH_INC

COSIGN2_PHONE_NUMBER_COMBINED Second cosigner's last known telephone home number. Includes the area code. VARCHAR2(10)

RPRLAPP

RPRLAPP_COSIGN2_PHONE_NO

COSIGN2_POSTAL_CODE Postal code of the cosigner's last known address. VARCHAR2(9)

RPRLAPP

RPRLAPP_COSIGN2_ZIP_CODE

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

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

CALCULATION

DECODE(RPRLAPP_COSIGN2_RELATION_IND)

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

RPRLAPP

RPRLAPP_COSIGN2_SIGNED_IND

COSIGN2_SSN Social security number of the cosigner. VARCHAR2(9)

RPRLAPP

RPRLAPP_COSIGN2_SSN

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

RPRLAPP

RPRLAPP_COSIGN2_STAT_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

RPRLAPP

RPRLAPP_COSIGN2_ADDR_LINE1

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

RPRLAPP

RPRLAPP_COSIGN2_ADDR_LINE2

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

RPRLAPP

RPRLAPP_COSIGN2_SUFFIX

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

RPRLAPP

RPRLAPP_COSIGN2_YR_ADDRESS

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

RPRLAPP

RPRLAPP_CREATE_DATE

CREDIT_IN_DIFF_NAME_IND Indicates the borrower has been granted credit under a different name. VARCHAR2(1)

RPRLAPP

RPRLAPP_CRED_DIF_NM_IND

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

NA

SYSDATE

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

RPRLAPP

RPRLAPP_IN_DEFAULT

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

RPRLAPP

RPRLAPP_MODEL_CDE

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

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

RPRLAPP

RPRLAPP_DISC_PRINT_IND

DL_LOAN_ID Identifies a specific loan application. VARCHAR2(21)

RPRLAPP

RPRLAPP_DL_LOAN_ID

DL_LOAN_STATUS Origination status code, typically system maintained for direct loan applications. VARCHAR2(1)

RPRLAPP

RPRLAPP_DL_STATUS

DL_REBATE_FEE_PERCENT Rebate fee percent. NUMBER(6, 3)

RPRLAPP

RPRLAPP_DL_REBATE_PERCENT

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

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

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

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

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

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

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

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

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

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

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

RPRLAPP

RPRLAPP_DL_SENT_DATE

DL_SEQ_NO System generated sequence number to designate direct loan applications. NUMBER(2)

RPRLAPP

RPRLAPP_DL_SEQ_NO

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

NA

NA

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

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

RPRLAPP

RPRLAPP_STAT_CODE_LIC

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

FUNCTION

GOKODSF.F_GET_DESC

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

RPRLAPP

RPRLAPP_EL_DATE_SENT

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

RPRLAPP

RPRLAPP_EL_LOAN_ID

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

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

RPRLAPP

RPRLAPP_EL_PROCESS_TYPE

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

RPRLAPP

RPRLAPP_EL_SEQ_NO

ENROLL_START_DATE Enrollment start date. 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. NUMBER(11, 2)

RPRLAPP

RPRLAPP_EXPECT_AMT

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

RPRLAPP

RPRLAPP_EXP_GRAD_DATE

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

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

RPRLAPP

RPRLAPP_FUND_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

RPRLAPP

RPRLAPP_GUAR_PIDM

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

RPRLAPP

RPRLAPP_HEAL_DEBT

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

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

RPRLAPP

RPRLAPP_LENDER_PIDM

LOAN_APPLICATION_NO System assigned number is assigned when the application is added. NUMBER(3)

RPRLAPP

RPRLAPP_APPL_NO

LOAN_FEE Percentage of the loan that is subtracted from the loan proceeds because of origination fees, etc. NUMBER(6, 3)

RPRLAPP

RPRLAPP_FEE_PCT

LOAN_PERIOD Period covered by the loan. VARCHAR2(6)

RPRLAPP

RPRLAPP_LOAN_PERIOD

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

RPRLAPP

RPRLAPP_LNST_CODE

LOAN_STATUS_DESC Loan status description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

RPRLAPP

RPRLAPP_LOCAL_CITY

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

RPRLAPP

RPRLAPP_LOCAL_NATN_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

RPRLAPP

RPRLAPP_LOCAL_PHONE_NO

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

RPRLAPP

RPRLAPP_LOCAL_ZIP

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

RPRLAPP

RPRLAPP_LOCAL_STAT_CODE

LOCAL_STATE_PROVINCE_DESC State description of the local address of the borrower of a direct loan. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

LOCAL_STREET_LINE1 Local address of the borrower of a direct loan. VARCHAR2(35)

RPRLAPP

RPRLAPP_LOCAL_ADDRESS

LOCAL_STREET_LINE2 Second line of student's local street address. VARCHAR2(30)

RPRLAPP

RPRLAPP_LOCAL_ADDR_LINE2

LOCK_IND Hold indicator. VARCHAR2(1)

RPRLAPP

RPRLAPP_HOLD_IND

MAXIMUM_ELIGIBLE_AMT Maximum loan amount for which the student is eligible. (The processed amount.). NUMBER(11, 2)

RPRLAPP

RPRLAPP_MAX_ELIG_AMT

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

NA

NA

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

NA

NA

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

RPRLAPP

RPRLAPP_MPN_BATCH_ID

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

RPRLAPP

RPRLAPP_MPN_ID

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

RPRLAPP

RPRLAPP_MPN_STATUS_IND

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

RPRLAPP

RPRLAPP_NATN_CODE

NATION_DESC Address nation/country description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

OTHER_LOANS_FOR_LN_PERIOD Borrower's total other student educational loan debt for the requested loan period. NUMBER(7)

RPRLAPP

RPRLAPP_OTH_LOANS_PERIOD

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

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

RPRLAPP

RPRLAPP_OWES_REFUND

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

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

RPRLAPP

RPRLAPP_PAR_CITZ_IND

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

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

RPRLAPP

RPRLAPP_PAR_IN_DEFAULT

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

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

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

FUNCTION

GOKODSF.F_GET_DESC

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

RPRLAPP

RPRLAPP_PAR_FIRST_NAME

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

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

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

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

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

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

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

FUNCTION

GOKODSF.F_GET_DESC

PARENT_LOCAL_STREET_LINE1 Local address of the parent when a direct loan is of a parent type. VARCHAR2(35)

RPRLAPP

RPRLAPP_PAR_LOCAL_ADDRESS

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

RPRLAPP

RPRLAPP_PAR_LOCAL_ADDR_LINE2

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

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

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

FUNCTION

GOKODSF.F_GET_DESC

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

RPRLAPP

RPRLAPP_PAR_PHONE_NO

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

RPRLAPP

RPRLAPP_PAR_ZIP

PARENT_SSN Tax identification number or social security number of the parent when a direct loan is of a parent type. VARCHAR2(9)

RPRLAPP

RPRLAPP_PAR_SSN

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

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

FUNCTION

GOKODSF.F_GET_DESC

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

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

FUNCTION

GOKODSF.F_GET_DESC

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

RPRLAPP

RPRLAPP_PAR_ADDRESS

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

RPRLAPP

RPRLAPP_PAR_ADDR_LINE2

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

RPRLAPP

RPRLAPP_PERKINS_DEBT

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

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

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

RPRLAPP

RPRLAPP_CREDIT_CHECK_IND

PLUS_TO_STUDENT_IND Plus to student indicator. VARCHAR2(1)

RPRLAPP

RPRLAPP_PLUS_TO_STUDENT

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

RPRLAPP

RPRLAPP_ZIP

PROCESS_DATE Date the loan application was processed. DATE

RPRLAPP

RPRLAPP_PROCESS_DATE

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

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. NUMBER(11, 2)

RPRLAPP

RPRLAPP_RECOMMEND_AMT

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

RPRLAPP

RPRLAPP_RECORD_TYPE

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

RPRLAPP

RPRLAPP_REPAY_OPT_IND

REQUESTED_AMT Amount of loan that the applicant requests. This amount cannot be negative or zero. NUMBER(11, 2)

RPRLAPP

RPRLAPP_REQUEST_AMT

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

RPRLAPP

RPRLAPP_RETURN_PIDM

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

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

RPRLAPP

RPRLAPP_STAF_LOAN_DEBT

STATE_PROVINCE_OF_RESIDENCE State in the address of the borrower of a direct loan. VARCHAR2(2)

RPRLAPP

RPRLAPP_STATE

STATE_PROVINCE_OF_RES_DESC State/province name. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

STREET_LINE1 First line of the address. VARCHAR2(35)

RPRLAPP

RPRLAPP_ADDRESS

STREET_LINE2 Second line of the address. VARCHAR2(30)

RPRLAPP

RPRLAPP_ADDR_LINE2

STUDENT_EMAIL_ADDRESS EMAIL ADDRESS: Student's email address. VARCHAR2(128)

RPRLAPP

RPRLAPP_STU_EMAIL

STUDENT_MAJOR Student's major field of study. VARCHAR2(15)

RPRLAPP

RPRLAPP_STU_MAJOR

STUDENT_MAJOR_DESC Major or subject area description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

SUBMISSION_DATE Date the loan application was submitted. DATE

RPRLAPP

RPRLAPP_SUB_DATE

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

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

NA

NA



Ver: 3.1