[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGFBV_FFELP_LOAN_ORIGINATIONS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGF.IGFBV_FFELP_LOAN_ORIGINATIONS
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Base view for the entity that holds Financial Aid FFELP Loan Originations
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SCHOOL_CERTIFICATION_DATE | DATE | Indicates date on which school certified loan | ||
| LOAN_SEQUENCE_NUMBER | NUMBER | (15) | Indicates value assigned by guarantor at time of guarantee or by lender in case of blanket guarantee for CommonLine loan | |
| LENDER_RELATIONSHIP_CODE | VARCHAR2 | (30) | Lender relationship code | |
| _LA:PROMISSORY_NOTE_STATUS | CHAR | (65) | Indicates promissory note status | |
| _LA:STUDENT_DEFAULT_STATUS | CHAR | (73) | Indicates student borrower's default status for loan | |
| _LA:BORROWER_DEFAULT_STATUS | CHAR | (73) | Indicates parent borrower's default or refund status on Title IV loans | |
| _LA:PROCESSING_TYPE_CODE | CHAR | (67) | Indicates processing type for CommonLine loan | |
| _LA:RECORD_TYPE_INDICATOR | CHAR | (65) | Indicates application type of loan record | |
| _LA:REQ_SERIAL_LOAN_CODE | CHAR | (77) | Indicates serial loan code requested by student | |
| _LA:ACT_SERIAL_LOAN_CODE | CHAR | (81) | Indicates actual serial loan code as returned by service provider | |
| _LA:PROM_NOTE_DELIVERY_CODE | CHAR | (74) | Indicates promissory note delivery code | |
| _LA:BORWER_CONFIRM_IND | CHAR | (69) | Indicates borrower's confirmation of loan | |
| _LA:GUARNTEE_STATUS_CODE | CHAR | (72) | Indicates status of loan with respect to lender | |
| _LA:LENDER_STATUS_CODE | CHAR | (68) | Indicates status of loan with respect to lender | |
| _LA:CREDIT_OVERRIDE_CODE | CHAR | (71) | Indicates credit decision returned by external processor | |
| _LA:GRADE_LEVEL_CODE | CHAR | (71) | Indicates grade level code of student at time loan originated | |
| _LA:ENROLLMENT_CODE | CHAR | (71) | Indicates enrollment status of student at time loan originated | |
| _LA:GUARNTEE_AMT_REDUCN_CODE | CHAR | (80) | Indicates whether guarantee fee was reduced from loan amount requested or school certified loan | |
| _LA:GUARNTEE_ADJUSTMENT_IND | CHAR | (61) | Indicates whether guarantee amount has been adjusted and is different from school amount | |
| _LA:STUDENT_SIGNATURE_CODE | CHAR | (63) | Indicates whether student borrower signed note | |
| _LA:BORROWER_SIGNATURE_CODE | CHAR | (63) | Indicates whether parent borrower signed note | |
| _LA:BORW_OUTSTD_LOAN_CODE | CHAR | (68) | Indicates whether borrower has outstanding federal student loans | |
| BORROWER_SIGNATURE_DATE | DATE | Indicates date on which school received signed promissory note | ||
| LAST_RESORT_LENDER | VARCHAR2 | (30) | Indicates whether lender is eligible lender of last resort for which value is updated by service provider | |
| BORROWER_CREDIT_AUTH_CODE | VARCHAR2 | (30) | Borrower Credit Authorization Code | |
| STUDENT_ELEC_SIGN_INDICATOR | VARCHAR2 | (30) | Student Signature Indicator | |
| BORROWER_ELEC_SIGN_INDICATOR | VARCHAR2 | (30) | Borrower Signature Indicator | |
| BOROWER_INTEREST_INDICATOR | VARCHAR2 | (30) | Indicates whether borrower intends to pay interest on loan while in school, grace, or deferment | |
| ACTUAL_INTEREST_RATE | NUMBER | (12) | Indicates latest interest rate of loan while student is still enrolled in school | |
| GUARANTEE_AMT | NUMBER | (12) | Indicates guarantee amount | |
| GUARANTEE_DATE | DATE | Indicates guarantee date | ||
| GUARNTEE_STATUS_DATE | DATE | Indicates date on which guarantee status was changed by service provider | ||
| PROMISSORY_NOTE_STATUS_DATE | DATE | Indicates date on which promissory note status changed by service provider | ||
| LENDER_STATUS_DATE | DATE | Indicates date on which lender status was changed by service provider | ||
| CREDIT_DECISION_DATE | DATE | Indicates last date on which credit decision was updated | ||
| STAFFORD_LOAN_DEBT | NUMBER | Total Federal Stafford loan debt prior to this loan period, as known by the sending organization for the borrower | ||
| SUPPLEMENTAL_LOAN_DEBT | NUMBER | Total Federal Supplemental Loans for Students (SLS) debt prior to this loan period, as known by the sending organization for the borrower | ||
| HEAL_DEBT | NUMBER | Total Health Education Assistance Loan (HEAL) debt prior to this loan period, as known by the sending organization for the borrower | ||
| PERKINS_DEBT | NUMBER | Total Perkins loan debt prior to this loan period, as known by the sending organization for the borrower | ||
| OTHER_DEBT | NUMBER | Total other student educational loan debt prior to this loan period, as known by the sending organization. This amount includes both federal and alternative loans for the borrower | ||
| BORROWER_GROSS_ANNUAL_SALARY | NUMBER | Borrower Gross Annual Salary | ||
| BORROWER_OTHER_INCOME | NUMBER | Borrower Other Income | ||
| STUDENT_MAJOR | VARCHAR2 | (30) | Student Major | |
| STUDENT_MONTHLY_HOUSING_PYMT | NUMBER | Student Monthly Housing Payment | ||
| STUDENT_MONTHLY_CRDTCARD_PYMT | NUMBER | Student Monthly Credit Card Payment | ||
| STUDENT_MONTHLY_AUTO_PYMT | NUMBER | Student Monthly Auto Payment | ||
| STUDENT_MONTHLY_ED_LOAN_PYMT | NUMBER | Student Monthly Educational Loan Payment | ||
| STUDENT_MONTHLY_OTHER_PYMT | NUMBER | Student Monthly Other Payment | ||
| _LA:INTEREST_RATE_OPTION | CHAR | (72) | Interest Rate Option | |
| _LA:REPAYMENT_OPTION_CODE | CHAR | (75) | Repayment Option Code | |
| _LA:CREDIT_UNDER_DIFF_NAME | CHAR | (67) | Credit Under Different Name Code A 1-character code indicating if the borrower has been granted credit under a different name. Y - Yes N - No | |
| LOAN_AMOUNT | NUMBER | (12) | Total award amount accepted | |
| LOAN_NUMBER | VARCHAR2 | (30) | Identifier for loans | |
| LOAN_PERIOD_BEGIN_DATE | DATE | Yes | Indicates loan period start date | |
| LOAN_PERIOD_END_DATE | DATE | Yes | Indicates loan period end date | |
| _LA:LOAN_RECORD_STATUS | CHAR | (65) | Indicates loan status | |
| LOAN_STATUS_DATE | DATE | Indicates date on which loan status changed | ||
| LOAN_IS_ACTIVE | VARCHAR2 | (1) | Yes | Indicator that specifies whether loan is active |
| LOAN_IS_ACTIVE_DATE | DATE | Yes | Indicates date on which loan was activated or inactivated | |
| LENDER_RELATIONSHIP_DESC | VARCHAR2 | (80) | Relationship code description | |
| RECIPIENT_TYPE | VARCHAR2 | (30) | Indicates lender, guarantor, or servicer | |
| AWARD_CALENDAR_TYPE | VARCHAR2 | (10) | Yes | Calendar Type for Award Calendar |
| AWARD_YEAR_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Unique Sequence Number for Award Calendar |
| P_PERSON_ID | NUMBER | (15) | Identifier for parent or alternate borrower from TCA | |
| INTERNAL_LOAN_ID | NUMBER | (15) | Yes | Identifier for loans |
| INTERNAL_ALT_RECORD_ID | NUMBER | (15) | Identifier for the additional information provided by the student for Alternate loans | |
| LENDER_ID | VARCHAR2 | (30) | Identifier for lender | |
| LENDER_NON_ED_BRANCH_ID | VARCHAR2 | (30) | Indicates non-ED branch for particular lender | |
| GUARANTOR_ID | VARCHAR2 | (30) | Identifier for guarantor | |
| RECIPIENT_ID | VARCHAR2 | (30) | Indicates either lender, guarantor, or servicer identifier | |
| RECIPIENT_NON_ED_BRANCH_ID | VARCHAR2 | (30) | Indicates non-ED branch of lender or servicer selected as recipient | |
| BASE_ID | NUMBER | (10) | Yes | Unique identifier for student financial aid record |
| PERSON_ID | NUMBER | (15) | Yes | Unique Person Identifier |
| INETRNAL_ORIGINATION_ID | NUMBER | (15) | Yes | Identifier for loan origination |
| CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
| CREATION_DATE | DATE | Yes | Standard WHO Column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
| LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
| B_ALIEN_REG_NUM_TXT | VARCHAR2 | (30) | Borrower Alien Registration Number | |
| ESIGN_SRC_TYP_CD | VARCHAR2 | (30) | Electronic Signature Source Type Code |
Cut, paste (and edit) the following text to query this object:
SELECT SCHOOL_CERTIFICATION_DATE
, LOAN_SEQUENCE_NUMBER
, LENDER_RELATIONSHIP_CODE
, _LA:PROMISSORY_NOTE_STATUS
, _LA:STUDENT_DEFAULT_STATUS
, _LA:BORROWER_DEFAULT_STATUS
, _LA:PROCESSING_TYPE_CODE
, _LA:RECORD_TYPE_INDICATOR
, _LA:REQ_SERIAL_LOAN_CODE
, _LA:ACT_SERIAL_LOAN_CODE
, _LA:PROM_NOTE_DELIVERY_CODE
, _LA:BORWER_CONFIRM_IND
, _LA:GUARNTEE_STATUS_CODE
, _LA:LENDER_STATUS_CODE
, _LA:CREDIT_OVERRIDE_CODE
, _LA:GRADE_LEVEL_CODE
, _LA:ENROLLMENT_CODE
, _LA:GUARNTEE_AMT_REDUCN_CODE
, _LA:GUARNTEE_ADJUSTMENT_IND
, _LA:STUDENT_SIGNATURE_CODE
, _LA:BORROWER_SIGNATURE_CODE
, _LA:BORW_OUTSTD_LOAN_CODE
, BORROWER_SIGNATURE_DATE
, LAST_RESORT_LENDER
, BORROWER_CREDIT_AUTH_CODE
, STUDENT_ELEC_SIGN_INDICATOR
, BORROWER_ELEC_SIGN_INDICATOR
, BOROWER_INTEREST_INDICATOR
, ACTUAL_INTEREST_RATE
, GUARANTEE_AMT
, GUARANTEE_DATE
, GUARNTEE_STATUS_DATE
, PROMISSORY_NOTE_STATUS_DATE
, LENDER_STATUS_DATE
, CREDIT_DECISION_DATE
, STAFFORD_LOAN_DEBT
, SUPPLEMENTAL_LOAN_DEBT
, HEAL_DEBT
, PERKINS_DEBT
, OTHER_DEBT
, BORROWER_GROSS_ANNUAL_SALARY
, BORROWER_OTHER_INCOME
, STUDENT_MAJOR
, STUDENT_MONTHLY_HOUSING_PYMT
, STUDENT_MONTHLY_CRDTCARD_PYMT
, STUDENT_MONTHLY_AUTO_PYMT
, STUDENT_MONTHLY_ED_LOAN_PYMT
, STUDENT_MONTHLY_OTHER_PYMT
, _LA:INTEREST_RATE_OPTION
, _LA:REPAYMENT_OPTION_CODE
, _LA:CREDIT_UNDER_DIFF_NAME
, LOAN_AMOUNT
, LOAN_NUMBER
, LOAN_PERIOD_BEGIN_DATE
, LOAN_PERIOD_END_DATE
, _LA:LOAN_RECORD_STATUS
, LOAN_STATUS_DATE
, LOAN_IS_ACTIVE
, LOAN_IS_ACTIVE_DATE
, LENDER_RELATIONSHIP_DESC
, RECIPIENT_TYPE
, AWARD_CALENDAR_TYPE
, AWARD_YEAR_SEQUENCE_NUMBER
, P_PERSON_ID
, INTERNAL_LOAN_ID
, INTERNAL_ALT_RECORD_ID
, LENDER_ID
, LENDER_NON_ED_BRANCH_ID
, GUARANTOR_ID
, RECIPIENT_ID
, RECIPIENT_NON_ED_BRANCH_ID
, BASE_ID
, PERSON_ID
, INETRNAL_ORIGINATION_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, B_ALIEN_REG_NUM_TXT
, ESIGN_SRC_TYP_CD
FROM APPS.IGFBV_FFELP_LOAN_ORIGINATIONS;
APPS
IGF_AP_FA_BASE_REC_ALL
IGF_AW_AWARD_ALL
IGF_AW_FUND_CAT_ALL
IGF_AW_FUND_MAST_ALL
IGF_SL_ALT_BORW_ALL
IGF_SL_CL_RECIPIENT
IGF_SL_LOANS_ALL
IGF_SL_LOR_ALL
APPS.IGFBV_FFELP_LOAN_ORIGINATIONS is not referenced by any database object
|
|
|
|