FND Design Data [Home] [Help]

Lookup Type: IGF_SL_LOAN_FIELDS

Product: IGF - Financial Aid
Meaning: Loan Fields
Description: Loan Fields
Quick Codes
Code Meaning Description
ACTIVE Active Active
ACTIVE_DATE Active Date Active Date
ACT_INTEREST_RATE Actual Interest Rate Actual Interest Rate
ACT_SERIAL_LOAN_CODE Actual Serial Loan Actual Serial Loan
ALT_APPL_VER_CODE Alternative Application Version Code Alternative Application Version Code
ALT_BORW_TOT_DEBT Alternative Borrower Total Debt Alternative Borrower Total Debt
ALT_LOAN_CODE Alternative Loan Code Alternative Loan Code
ALT_PROG_TYPE_CODE Alternative Program Type Code Alternative Program Type Code
ANTICIP_COMPL_DATE Anticipated Completion Anticipated Completion
APPL_LOAN_PHASE_CODE Loan Application Phase Code Loan Application Phase Code
APPL_LOAN_PHASE_CODE_CHG Application Loan Phase Code Change Application Loan Phase Code Change
APPL_SEND_ERROR_CODE Applicant Sends Error Change Applicant Sends Error Change
ATD_ENTITY_ID_TXT Attending School Entity ID Attending School Entity ID
AWARD_ID Award ID Award ID
BASE_ID Base ID Base ID
BORW_CONFIRM_IND Borrower Confirmation Indicator Borrower Confirmation Indicator
BORW_GROSS_ANNUAL_SAL Borrower Gross Annual Salary Borrower Gross Annual Salary
BORW_INTEREST_IND Interest Indicator Interest Indicator
BORW_LENDER_ID Borrower's Lender ID Borrower's Lender ID
BORW_OTHER_INCOME Borrower Other Income Borrower Other Income
BORW_OUTSTD_LOAN_CODE Outstanding Loan Outstanding Loan
B_ALIEN_REG_NUM Plus/Alternative Borrower Alien Registration Number Plus/Alternative Borrower Alien Registration Number
B_FULL_NAME Borrower Full Name Borrower Full Name
B_SSN Borrower SSN Borrower SSN
CHECK_NUMBER Check Number Check Number
CHG_BATCH_ID Change Batch ID Change Batch ID
CHG_RESP_STATUS Change Response Status Change Response Status
CI_ALTERNATE_CODE Award Year Award Year
CI_CAL_TYPE Calendar Type Calendar Type
CI_END_DATE Calendar End Date Calendar End Date
CI_SEQUENCE_NUMBER Calendar Sequence Number Calendar Sequence Number
CI_START_DATE Calendar Start date Calendar Start date
CL_LOAN_TYPE FFELP Loan Type FFELP Loan Type
CL_REC_STATUS Loan Application Record Status Loan Application Record Status
CL_REC_STATUS_LAST_UPDATE FFELP Record Status Last Update FFELP Record Status Last Update
CL_SEQ_NUMBER FFELP Sequence Number FFELP Sequence Number
CPS_TRANS_NUM ISIR Transaction Number ISIR Transaction Number
CRDT_UNDER_DIFFT_NAME Credit under different name code Credit under different name code
CREDIT_DECISION_DATE Credit Decision Date Credit Decision Date
CREDIT_OVERRIDE Credit Override Credit Override
CSGNR1_GROSS_ANNUAL_SAL Cosigner 1 Gross Annual Salary Cosigner 1 Gross Annual Salary
CSGNR1_MTHL_AUTO_PAYMENT Cosigner 1 Monthly Auto Payment Cosigner 1 Monthly Auto Payment
CSGNR1_MTHL_CC_PAYMENT Cosigner 1 Monthly Credit Card Payment Cosigner 1 Monthly Credit Card Payment
CSGNR1_MTHL_ED_LOANN_PAYMENT Cosigner 1 Monthly Educational Loan Payment Cosigner 1 Monthly Educational Loan Payment
CSGNR1_MTHL_HOUSE_PAYMENT Cosigner 1 Monthly Housing Payment Cosigner 1 Monthly Housing Payment
CSGNR1_MTHL_OTHER_PAYMENT Cosigner 1 Monthly Other Payment Cosigner 1 Monthly Other Payment
CSGNR1_OTHER_INCOME Cosigner 1 Other Income Cosigner 1 Other Income
CSGNR2_GROSS_ANNUAL_SAL Cosigner 2 Gross Annual Salary Cosigner 2 Gross Annual Salary
CSGNR2_MTHL_AUTO_PAYMENT Cosigner 2 Monthly Auto Payment Cosigner 2 Monthly Auto Payment
CSGNR2_MTHL_CC_PAYMENT Cosigner 2 Monthly Credit Card Payment Cosigner 2 Monthly Credit Card Payment
CSGNR2_MTHL_ED_LOANN_PAYMENT Cosigner 2 Monthly Educational Loan Payment Cosigner 2 Monthly Educational Loan Payment
CSGNR2_MTHL_HOUSE_PAYMENT Cosigner 2 Monthly Housing Payment Cosigner 2 Monthly Housing Payment
CSGNR2_MTHL_OTHER_PAYMENT Cosigner 2 Monthly Other Payment Cosigner 2 Monthly Other Payment
CSGNR2_OTHER_INCOME Cosigner 2 Other Income Cosigner 2 Other Income
DEFER_REQ_CODE Deferment Request Code Deferment Request Code
DISB_ADJ_AMT Adjustment amount Adjustment amount
DISB_DATE Anticipated Disbursement Date Anticipated Disbursement Date
DISB_GROSS_AMT Disbursement Gross Amount Disbursement Gross Amount
DISB_NET_AMT Disbursement Net Amount Disbursement Net Amount
DISB_NUM Disbursement Number Disbursement Number#
DISB_SEQ_NUM Disbursement Sequence Number Disbursement Sequence Number
DISCLOSURE_PRINT_IND Disclosure Print Indicator Disclosure Print Indicator
DISC_PRINT_IND Disclosure Statement Print Indicator Disclosure Statement Print Indicator
DUNS_BORW_LENDER_ID DUNS ID DUNS ID
DUNS_GUARNT_CODE DUNS Guarantor ID DUNS Guarantor ID
DUNS_LENDER_ID DUNS Lender ID DUNS Lender ID
DUNS_RECIP_ID DUNS Recipient ID DUNS Recipient ID
EFT_AUTHORIZATION EFT Authorization EFT Authorization
ENROLLMENT_CODE Enrollment Code Enrollment Code
ERROR_MSG_1_CODE Error Message Code 1 Error Message Code 1
ERROR_MSG_2_CODE Error Message Code 2 Error Message Code 2
ERROR_MSG_3_CODE Error Message Code 3 Error Message Code 3
ERROR_MSG_4_CODE Error Message Code 4 Error Message Code 4
ERROR_MSG_5_CODE Error Message Code 5 Error Message Code 5
ESIGN_SRC_TYP_CODE E-signature Source Type Code E-signature Source Type Code
FED_APPL_FORM_CODE Federal Application Form Code Federal Application Form Code
FED_FUND_CODE Federal Fund Code Federal Fund Code
FED_SLS_DEBT Federal Supplemental Loan Debt Federal Supplemental Loan Debt
FED_STAFFORD_LOAN_DEBT Federal Stafford Loan Debt Federal Stafford Loan Debt
FEE_1 Origination Fees Origination Fees
FEE_2 Guarantee Fees Guarantee Fees
FEE_PAID_1 Origination Fees Paid Origination Fees Paid
FEE_PAID_2 Guarantee Fees Paid Guarantee Fees Paid
FUND_DISB_MTHD Fund Disbursement Method Fund Disbursement Method
FUND_ID Fund ID Fund ID
FUND_RELEASE_DATE Fund Release Date Fund Release Date
FUND_SOURCE Fund Source Fund Source
FUND_TYPE Fund Type Fund Type
GRADE_LEVEL_CODE Grade Level Grade Level
GUARANTEE_DATE Guarantee Date Guarantee Date
GUARANTOR_AMT Guarantee Amount Guarantee Amount
GUARANTOR_ID Guarantor ID Guarantor ID
GUARNT_ADJ_IND Guarantee Adjusted Guarantee Adjusted
GUARNT_AMT_REDN_CODE Guarantee Amount Reduction Code Guarantee Amount Reduction Code
GUARNT_STATUS_CODE Guarantee Status Code Guarantee Status Code
GUARNT_STATUS_DATE Guarantee Status Date Guarantee Status Date
HEAL_DEBT Health Assistance Loan Debt Health Assistance Loan Debt
HOLD_REL_IND Disbursement Hold/Release Indicator Disbursement Hold/Release Indicator
IGF_SL_LOAN_FIELDS Override Grade Level - obsolete Override Grade Level - obsolete
INTEREST_REBATE_AMT Interest Rebate Amount Interest Rebate Amount
INT_RATE_OPT Interest Rate Option Interest Rate Option
LAST_RESORT_LENDER Lender of Last Resort Lender of Last Resort
LATE_DISB_IND Late Disbursement Indicator Late Disbursement Indicator
LENDER_ID Lender ID Lender ID
LEND_APPRV_DENIED_CODE Lender Approved Denied Code Lender Approved Denied Code
LEND_APPRV_DENIED_DATE Lender Approved Denied Date Lender Approved Denied Date
LEND_NON_ED_BRC_ID Lender Non-ED Branch ID Lender Non-ED Branch ID
LEND_STATUS_CODE Lender Status Code Lender Status Code
LEND_STATUS_DATE Lender Status Date Lender Status Date
LOAN_AMT_ACCEPTED Accepted Loan Amount Accepted Loan Amount
LOAN_AMT_OFFERED Loan Amount Offered Loan Amount Offered
LOAN_CATG Loan Category Loan Category
LOAN_CHG_STATUS Loan Change Status Loan Change Status
LOAN_CHG_STATUS_DATE Loan Change Status Date Loan Change Status Date
LOAN_ID Loan ID Loan ID
LOAN_NUMBER Loan ID(1) Loan ID(1)
LOAN_PER_BEGIN_DATE Loan Period Begin Date Loan Period Begin Date
LOAN_PER_END_DATE Loan Period End Date Loan Period End Date
LOAN_STATUS Loan Status Loan Status
LOAN_STATUS_DATE Loan Status Date Loan Status Date
LOAN_TYPE Loan Type Loan Type
LOAN_TYPE_NUM Loan Type Number Loan Type Number
MPN_CONFIRM_CODE MPN Confirm Code MPN Confirm Code
ORIGINATION_ID Origination ID Origination ID
ORIG_ACK_DATE Origination Acknowledgement Date Origination Acknowledgement Date
ORIG_BATCH_DATE Origination Batch Date Origination Batch Date
ORIG_BATCH_ID Origination Batch ID Origination Batch ID
ORIG_FEE_PERCT Origination Fee Percentage Origination Fee Percentage
ORIG_STATUS_FLAG Origination Status Flag Origination Status Flag
OTHER_DEBT Total Other Debt Total Other Debt
OVERRIDE_GRADE_LEVEL_CODE Override Grade Level Override Grade Level
PERKINS_DEBT Perkins Loan Debt Perkins Loan Debt
PNOTE_ACCEPT_AMT Promissory Note Accepted Amount Promissory Note Accepted Amount
PNOTE_ACCEPT_DATE Promissory Note Accepted Date Promissory Note Accepted Date
PNOTE_DELIVERY_CODE Promissory Note Delivery Code Promissory Note Delivery Code
PNOTE_ID Promissory Note ID Promissory Note ID
PNOTE_PRINT_IND Promissory Note Print Indicator Promissory Note Print Indicator
PNOTE_STATUS Promissory Note Status Promissory Note Status
PNOTE_STATUS_DATE Promissory Note Status Date Promissory Note Status Date
PRC_TYPE_CODE Processing Type Code Processing Type Code
PREV_REPORTED_IND Previously Reported Previously Reported
P_ALIEN_REG_NUM Parent Alien Registration Number Parent Alien Registration Number
P_CITIZENSHIP_STATUS PLUS/Alternative Borrower Citizenship Status PLUS/Alternative Borrower Citizenship Status
P_DATE_OF_BIRTH PLUS/Alternative Borrower Date of Birth PLUS/Alternative Borrower Date of Birth
P_DEFAULT_STATUS PLUS/Alternative Borrower Default Status PLUS/Alternative Borrower Default Status
P_DOB_CHG_DATE PLUS/Alternative Borrower Date of Birth Change Date PLUS/Alternative Borrower Date of Birth Change Date
P_EMAIL_ADDR PLUS/Alternative Borrower E-mail Address PLUS/Alternative Borrower E-mail Address
P_FIRST_NAME PLUS/Alternative Borrower First Name PLUS/Alternative Borrower First Name
P_FOREIGN_POSTAL_CODE PLUS/Alternative Borrower Foreign Postal Code PLUS/Alternative Borrower Foreign Postal Code
P_FULL_NAME PLUS/Alternative Borrower Full Name PLUS/Alternative Borrower Full Name
P_LAST_NAME PLUS/Alternative Borrower Last Name PLUS/Alternative Borrower Last Name
P_LEGAL_RES_DATE PLUS/Alternative Borrower Legal residence Date PLUS/Alternative Borrower Legal residence Date
P_LICENSE_NUM PLUS/Alternative Borrower License Number PLUS/Alternative Borrower License Number
P_LICENSE_STATE PLUS/Alternative Borrower License State PLUS/Alternative Borrower License State
P_MIDDLE_NAME PLUS/Alternative Borrower Middle Name PLUS/Alternative Borrower Middle Name
P_PERMT_ADDR1 PLUS/Alternative Borrower Permanent Address Line 1 PLUS/Alternative Borrower Permanent Address Line 1
P_PERMT_ADDR2 PLUS/Alternative Borrower Permanent Address Line 2 PLUS/Alternative Borrower Permanent Address Line 2
P_PERMT_ADDR_CHG_DATE PLUS/Alternative Borrower Permanent Address Change Date PLUS/Alternative Borrower Permanent Address Change Date
P_PERMT_CITY PLUS/Alternative Borrower Permanent City PLUS/Alternative Borrower Permanent City
P_PERMT_PHONE PLUS/Alternative Borrower Permanent Phone PLUS/Alternative Borrower Permanent Phone
P_PERMT_STATE PLUS/Alternative Borrower Permanent State PLUS/Alternative Borrower Permanent State
P_PERMT_ZIP PLUS/Alternative Borrower Permanent Zip PLUS/Alternative Borrower Permanent Zip
P_PERSON_ID PLUS/Alternative Borrower Person ID PLUS/Alternative Borrower Person ID
P_SIGNATURE_CODE PLUS/Alternative Borrower Signature PLUS/Alternative Borrower Signature
P_SIGNATURE_DATE PLUS/Alternative Borrower Signature Date PLUS/Alternative Borrower Signature Date
P_SSN PLUS/Alternative Borrower SSN PLUS/Alternative Borrower SSN
P_SSN_CHG_DATE PLUS/Alternative Borrower SSN Change Date PLUS/Alternative Borrower SSN Change Date
P_STATE_OF_LEGAL_RES PLUS/Alternative Borrower State of Legal residence PLUS/Alternative Borrower State of Legal residence
RECIPIENT_ID Recipient ID Recipient ID
RECIPIENT_TYPE Recipient Type Recipient Type
RECIP_NON_ED_BRC_ID Recipient Non-ED Branch ID Recipient Non-ED Branch ID
REC_TYPE_IND Record Type Indicator Record Type Indicator
REPAYMENT_OPT_CODE Repayment Option Code Repayment Option Code
REP_ENTITY_ID_TXT Reporting School Entity ID Reporting School Entity ID
REQUESTED_LOAN_AMT Requested Loan Amount Requested Loan Amount
REQ_SERIAL_LOAN_CODE Requested Serial Loan Requested Serial Loan
RESP_TO_ORIG_CODE Response to Origination Code Response to Origination Code
REV_NOTICE_OF_GUARNT Revised Notice of Guarantee Revised Notice of Guarantee
SCHOOL_ID Financial Aid Office Code Financial Aid Office Code
SCH_CERT_DATE School Certification School Certification
SCH_REFUND_AMT School Refund Amount School Refund Amount
SCH_REFUND_DATE School Refund Date School Refund Date
SEQ_NUM Sequence Number Sequence Number
SERVICE_TYPE_CODE Service Type Code Service Type Code
STUDENT_ID Student ID Student ID
STUDENT_MAJOR Student's Major Study Student's Major Study
STUD_MTH_AUTO_PYMT Student Monthly Auto Payment Student Monthly Auto Payment
STUD_MTH_ED_LOAN Student Monthly Educational Loan Debt Student Monthly Educational Loan Debt
STUD_MTH_HOUSING_PYMT Student Monthly Housing Payment Student Monthly Housing Payment
STUD_MTH_OTHER_PYMT Student Monthly Other Payment Student Monthly Other Payment
SYS_FUND_TYPE Student Fund Type Student Fund Type
S_CITIZENSHIP_STATUS Student Citizenship Status Student Citizenship Status
S_DATA_ATTR Data Attribute Data Attribute
S_DATE_OF_BIRTH Student Date of Birth Student Date of Birth
S_DEFAULT_STATUS Student Default Status Student Default Status
S_DEPNCY_STATUS Student Dependency Status Student Dependency Status
S_DOB_CHG_DATE Student Date of Birth Change Date Student Date of Birth Change Date
S_EMAIL_ADDR Student E-mail Address Student E-mail Address
S_ESIGN_IND_CODE Plus/Alternative Student Electronic Signature Indicator Code Plus/Alternative Student Electronic Signature Indicator Code
S_FIRST_NAME Student First Name Student First Name
S_FULL_NAME Student Full Name Student Full Name
S_LAST_NAME Student Last Name Student Last Name
S_LICENSE_NUM Student License Number Student License Number
S_LICENSE_STATE Student License State Student License State
S_LOCAL_ADDR1 Student Local Address Line1 Student Local Address Line1
S_LOCAL_ADDR2 Student Local Address Line2 Student Local Address Line2
S_LOCAL_ADDR_CHG_DATE Student Local Address Change Date Student Local Address Change Date
S_LOCAL_CITY Student Local City Student Local City
S_LOCAL_STATE Student Local State Student Local State
S_LOCAL_ZIP Student Local Zip Student Local Zip
S_MIDDLE_NAME Student Middle Name Student Middle Name
S_NEW_VAL New Value New Value
S_OLD_VAL Old Value Old Value
S_PERMT_ADDR1 Student Permanent Address Line1 Student Permanent Address Line1
S_PERMT_ADDR2 Student Permanent Address Line2 Student Permanent Address Line2
S_PERMT_ADDR_CHG_DATE Student Permanent Address Change Date Student Permanent Address Change Date
S_PERMT_CITY Student Permanent City Student Permanent City
S_PERMT_PHONE Student Permanent Phone Student Permanent Phone
S_PERMT_STATE Student Permanent State Student Permanent State
S_PERMT_ZIP Student Permanent Zip Student Permanent Zip
S_PER_NUM Person Number Person Number
S_REJECT_DESC Reject Reasons Reject Reasons
S_REJECT_NUM Reject Number Reject Number
S_SIGNATURE_CODE Student Signature Code Student Signature Code
S_SSN Student SSN Student SSN
S_SSN_CHG_DATE Student SSN Change Date Student SSN Change Date
TOT_OUTSTD_PLUS Total Outstanding PLUS Total Outstanding PLUS
TOT_OUTSTD_STAFFORD Total Outstanding Stafford Total Outstanding Stafford
UNIQ_LAYOUT_IDENT_CODE Unique Layout Identification Code Unique Layout Identification Code
UNIQ_LAYOUT_VEND_CODE Unique Layout Vendor Code Unique Layout Vendor Code
UNSUB_ELIG_FOR_DEPNT Unsubsidized Eligibility for Dependent Students Unsubsidized Eligibility for Dependent Students
UNSUB_ELIG_FOR_HEAL Unsubsidized Eligibility for Health Professions Unsubsidized Eligibility for Health Professions