[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGFFV_FFELP_LOAN_ORIGINATIONS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGF.IGFFV_FFELP_LOAN_ORIGINATIONS
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Full 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 | |
| PERSON_NUMBER | VARCHAR2 | (30) | Yes | Person Number |
| FIRST_NAME | VARCHAR2 | (150) | Person First Name | |
| LAST_NAME | VARCHAR2 | (150) | Person Last Name | |
| MIDDLE_NAME | VARCHAR2 | (60) | Person Middle Name | |
| PERM_ADDRESS_LINE_1 | VARCHAR2 | (240) | Permanent Address attribute of the student | |
| PERM_ADDRESS_LINE_2 | VARCHAR2 | (240) | Permanent Address attribute of the student | |
| PERM_ADDRESS_LINE_3 | VARCHAR2 | (240) | Permanent Address attribute of the student | |
| PERM_ADDRESS_LINE_4 | VARCHAR2 | (240) | Permanent Address attribute of the student | |
| PERMANENT_CITY | VARCHAR2 | (60) | Indicates permanent city of the student | |
| PERMANENT_STATE_CODE | VARCHAR2 | (60) | Indicates permanent State of the student | |
| PERMANENT_ZIP_CODE | VARCHAR2 | (60) | Indicates permanent Zip Code of the student | |
| E_MAIL_ADDRESS | VARCHAR2 | (2000) | Indicates email address of the student | |
| PLUS_BORROWER_PERSON_NUMBER | VARCHAR2 | (30) | Parent or alternate borrower's Person Number | |
| PLUS_BORROWER_FIRST_NAME | VARCHAR2 | (150) | Parent or alternate borrower's First Name | |
| PLUS_BORROWER_LAST_NAME | VARCHAR2 | (150) | Parent or alternate borrower's Last Name | |
| PLUS_BORROWER_MIDDLE_NAME | VARCHAR2 | (60) | Parent or alternate borrower's Middle Name | |
| PLUS_BORROWER_PERM_ADD_LINE_1 | VARCHAR2 | (240) | Parent or alternate borrower's Permanent address attribute | |
| PLUS_BORROWER_PERM_ADD_LINE_2 | VARCHAR2 | (240) | Parent or alternate borrower's Permanent address attribute | |
| PLUS_BORROWER_PERM_ADD_LINE_3 | VARCHAR2 | (240) | Parent or alternate borrower's Permanent address attribute | |
| PLUS_BORROWER_PERM_ADD_LINE_4 | VARCHAR2 | (240) | Parent or alternate borrower's Permanent address attribute | |
| PLUS_BORROWER_PERMANENT_CITY | VARCHAR2 | (60) | Parent or alternate borrower's Permanent City | |
| PLUS_BORROWER_PERMANENT_STATE | VARCHAR2 | (60) | Parent or alternate borrower's Permanent State | |
| PLUS_BORROWER_PERMANENT_ZIP | VARCHAR2 | (60) | Parent or alternate borrower's Permanent Zip Code | |
| PLUS_BORROWER_E_MAIL_ADDRESS | VARCHAR2 | (2000) | Parent or alternate borrower's email address | |
| 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 |
| AWARD_YEAR | VARCHAR2 | (10) | Awarding Year | |
| 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 | |
| LOAN_AMOUNT | NUMBER | (12) | Total award amount accepted | |
| FUND_DESCRIPTION | VARCHAR2 | (80) | Fund Description | |
| INETRNAL_LOAN_ID | NUMBER | (15) | Yes | Identifier for loans |
| PLUS_BORROW_PERSON_ID | NUMBER | (15) | Identifier for parent or alternate borrower from TCA | |
| 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
, PERSON_NUMBER
, FIRST_NAME
, LAST_NAME
, MIDDLE_NAME
, PERM_ADDRESS_LINE_1
, PERM_ADDRESS_LINE_2
, PERM_ADDRESS_LINE_3
, PERM_ADDRESS_LINE_4
, PERMANENT_CITY
, PERMANENT_STATE_CODE
, PERMANENT_ZIP_CODE
, E_MAIL_ADDRESS
, PLUS_BORROWER_PERSON_NUMBER
, PLUS_BORROWER_FIRST_NAME
, PLUS_BORROWER_LAST_NAME
, PLUS_BORROWER_MIDDLE_NAME
, PLUS_BORROWER_PERM_ADD_LINE_1
, PLUS_BORROWER_PERM_ADD_LINE_2
, PLUS_BORROWER_PERM_ADD_LINE_3
, PLUS_BORROWER_PERM_ADD_LINE_4
, PLUS_BORROWER_PERMANENT_CITY
, PLUS_BORROWER_PERMANENT_STATE
, PLUS_BORROWER_PERMANENT_ZIP
, PLUS_BORROWER_E_MAIL_ADDRESS
, LENDER_RELATIONSHIP_DESC
, RECIPIENT_TYPE
, AWARD_CALENDAR_TYPE
, AWARD_YEAR_SEQUENCE_NUMBER
, AWARD_YEAR
, LOAN_NUMBER
, LOAN_PERIOD_BEGIN_DATE
, LOAN_PERIOD_END_DATE
, _LA:LOAN_RECORD_STATUS
, LOAN_STATUS_DATE
, LOAN_IS_ACTIVE
, LOAN_IS_ACTIVE_DATE
, LOAN_AMOUNT
, FUND_DESCRIPTION
, INETRNAL_LOAN_ID
, PLUS_BORROW_PERSON_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.IGFFV_FFELP_LOAN_ORIGINATIONS;
APPS
HZ_PARTIES
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
IGS_CA_INST_ALL
APPS.IGFFV_FFELP_LOAN_ORIGINATIONS is not referenced by any database object
|
|
|
|