[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGFBV_ALT_ORIG_RESPONSES |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGF.IGFBV_ALT_ORIG_RESPONSES
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Base view for the entity that holds Alternate Loan Origination Response Details
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LOAN_NUMBER | VARCHAR2 | (30) | Yes | Unique identifier for Direct Loan or CommonLine loan |
| FEDERAL_STAFFORD_LOAN_DEBT | NUMBER | (12) | Total Federal Stafford loan debt prior to this loan period, as known by the sending organization for the borrower | |
| FEDERAL_SUPPLEMENTARY_DEBT | NUMBER | (12) | 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 | (12) | Total Health Education Assistance Loan (HEAL) debt prior to this loan period, as known by the sending organization for the borrower | |
| PERKINS_DEBT | NUMBER | (12) | Total Perkins loan debt prior to this loan period, as known by the sending organization for the borrower | |
| OTHER_DEBT | NUMBER | (12) | Total other student educational loan debt prior to this loan period, as known by the sending organization for the borrower. This amount includes both federal and alternative loans | |
| BORROWER_GROSS_ANNUAL_SALARY | NUMBER | (12) | Borrower Gross Annual Salary | |
| BORROWER_OTHER_INCOME | NUMBER | (12) | Borrower Other Income | |
| STUDENT_MAJOR | VARCHAR2 | (30) | Student Major | |
| _LA:CREDIT_UNDER_DIFF_NAME | CHAR | (69) | 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 | |
| _LA:INTEREST_RATE_OPTION | CHAR | (74) | Interest Rate Option | |
| _LA:REPAYMENT_OPTION_CODE | CHAR | (77) | Repayment Option Code | |
| STUDENT_MONTHLY_HOUSING_PYMT | NUMBER | (12) | Total monthly housing payment paid by the student | |
| STUDENT_MONTHLY_CRDTCARD_PYMT | NUMBER | (12) | Total monthly credit card payment paid by the student | |
| STUDENT_MONTHLY_AUTO_PYMT | NUMBER | (12) | Total monthly auto payment paid by the student | |
| STUDENT_MONTHLY_ED_LOAN_PYMT | NUMBER | (12) | Total monthly educational loan payment paid by the student | |
| STUDENT_MONTHLY_OTHER_PYMT | NUMBER | (12) | Total monthly payment for other debts paid by the student | |
| COSIGNER_1_FIRST_NAME | VARCHAR2 | (60) | First Cosigner's First name | |
| COSIGNER_1_LAST_NAME | VARCHAR2 | (60) | First Cosigner's Last name | |
| COSIGNER_1_MIDDLE_NAME | VARCHAR2 | (30) | First Cosigner's Middle name | |
| COSIGNER_1_SSN | VARCHAR2 | (20) | First Cosigner's Social Security Number | |
| COSIGNER_1_CITIZENSHIP | VARCHAR2 | (30) | Indicates first cosigner's citizenship status. Values are U.S. citizen, eligible non-citizen, or ineligible non-citizen | |
| COSIGNER_1_ADDRESS_LINE1 | VARCHAR2 | (60) | First Cosigner's first line of address | |
| COSIGNER_1_ADDRESS_LINE2 | VARCHAR2 | (60) | First Cosigner's second line of address | |
| COSIGNER_1_CITY | VARCHAR2 | (60) | First Cosigner's city | |
| COSIGNER_1_STATE | VARCHAR2 | (60) | First Cosigner's State | |
| COSIGNER_1_ZIP | VARCHAR2 | (30) | First Cosigner's zip code | |
| COSIGNER_1_ZIP_SUFFIX | VARCHAR2 | (30) | First Cosigner's zip suffix | |
| COSIGNER_1_PHONE | VARCHAR2 | (60) | First Cosigner Phone | |
| COSIGNER_1_SIGNATURE_CODE | VARCHAR2 | (30) | Indicates whether First Cosigner's borrower signed note | |
| COSIGNER_1_GROSS_ANUAL_SALARY | NUMBER | (12) | First Cosigner's annual salary | |
| COSIGNER_1_OTHER_INCOME | NUMBER | (12) | First Cosigner's other income | |
| COSIGNER_1_FORIEN_POSTAL_CODE | VARCHAR2 | (30) | First Cosigner's foreign postal code | |
| COSIGNER_1_FORIEN_PHONE_PREFIX | VARCHAR2 | (30) | First Cosigner's foreign phone prefix | |
| COSIGNER_1_DATE_OF_BIRTH | DATE | First Cosigner's date of birth | ||
| COSIGNER_1_LICENSE_STATE | VARCHAR2 | (30) | Indicates driver's license state of the first cosigner | |
| COSIGNER_1_LICENSE_NUMBER | VARCHAR2 | (30) | Indicates driver's license number of first cosigner | |
| COSIGNER_1_RELATIONSHIP_TO | VARCHAR2 | (30) | First cosigner's relationship to the student | |
| COSIGNER_1_YEARS_AT_ADDRESS | VARCHAR2 | (30) | Number of years the first Cosigner has been at this address | |
| COSIGNER_1_MONTH_HOUSING_PYMT | NUMBER | (12) | Total monthly housing payment paid by the first cosigner | |
| COSIGNER_1_MONTH_CRDTCARD_PYMT | NUMBER | (12) | Total monthly credit card payment paid by the first cosigner | |
| COSIGNER_1_MONTH_AUTO_PYMT | NUMBER | (12) | Total monthly auto payment paid by the first cosigner | |
| COSIGNER_1_MONTH_ED_LOAN_PYMT | NUMBER | (12) | Total monthly educational loan payment paid by the first cosigner | |
| COSIGNER_1_MONTH_OTHER_PYMT | NUMBER | (12) | Total monthly payment for other debts paid by the first cosigner | |
| COSIGNER_1_CRDT_AUTH_CODE | VARCHAR2 | (30) | First Cosigner's credit authorization code | |
| COSIGNER_2_FIRST_NAME | VARCHAR2 | (60) | Second Cosigner's first name | |
| COSIGNER_2_LAST_NAME | VARCHAR2 | (60) | Second Cosigner's last name | |
| COSIGNER_2_MIDDLE_NAME | VARCHAR2 | (30) | Second Cosigner's middle name | |
| COSIGNER_2_SSN | VARCHAR2 | (20) | Second Cosigner's social security number | |
| COSIGNER_2_CITIZENSHIP | VARCHAR2 | (30) | Indicates second cosigner's citizenship status. Values are U.S. citizen, eligible non-citizen, or ineligible non-citizen | |
| COSIGNER_2_ADDRESS_LINE1 | VARCHAR2 | (60) | Second Cosigner's first line of address | |
| COSIGNER_2_ADDRRESS_LINE2 | VARCHAR2 | (60) | Second Cosigner's second line of address | |
| COSIGNER_2_CITY | VARCHAR2 | (60) | Second Cosigner's city | |
| COSIGNER_2_STATE | VARCHAR2 | (60) | Second Cosigner's State | |
| COSIGNER_2_ZIP | VARCHAR2 | (30) | Second Cosigner's zip code | |
| COSIGNER_2_ZIP_SUFFIX | VARCHAR2 | (30) | Second Cosigner's zip suffix | |
| COSIGNER_2_PHONE | VARCHAR2 | (60) | Second Cosigner Phone | |
| COSIGNER_2_SIGNATURE_CODE | VARCHAR2 | (30) | Indicates whether Second Cosigner's borrower signed note | |
| COSIGNER_2_GROSS_ANUAL_SALARY | NUMBER | (12) | Second Cosigner's annual salary | |
| COSIGNER_2_OTHER_INCOME | NUMBER | (12) | Second Cosigner's other income | |
| COSIGNER_2_FOREIGN_POSTAL_CODE | VARCHAR2 | (30) | Second Cosigner's foreign postal code | |
| COSIGNER_2_FOREIN_PHONE_PREFIX | VARCHAR2 | (30) | Second Cosigner's foreign phone prefix | |
| COSIGNER_2_DATE_OF_BIRTH | DATE | Second Cosigner's date of birth | ||
| COSIGNER_2_LICENSE_STATE | VARCHAR2 | (30) | Indicates driver's license state of the second cosigner | |
| COSIGNER_2_LICENSE_NUMBER | VARCHAR2 | (30) | Indicates driver's license number of second cosigner | |
| COSIGNER_2_RELATIONSHIP_TO | VARCHAR2 | (30) | Second cosigner's relationship to the student | |
| COSIGNER_2_YEARS_AT_ADDRESS | VARCHAR2 | (30) | Number of years the second Cosigner has been at this address | |
| COSIGNER_2_MONTH_HOUSING_PYMT | NUMBER | (12) | Total monthly housing payment paid by the second cosigner | |
| COSIGNER_2_MONTH_CRDTCARD_PYMT | NUMBER | (12) | Total monthly credit card payment paid by the second cosigner | |
| COSIGNER_2_MONTH_AUTO_PYMT | NUMBER | (12) | Total monthly auto payment paid by the second cosigner | |
| COSIGNER_2_MONTH_ED_LOAN_PYMT | NUMBER | (12) | Total monthly educational loan payment paid by the second cosigner | |
| COSIGNER_2_MONTH_OTHER_PYMT | NUMBER | (12) | Total monthly payment for other debts paid by the second cosigner | |
| COSIGNER_2_CRDT_AUTH_CODE | VARCHAR2 | (30) | Second Cosigner's credit authorization code | |
| RECORD_TYPE_INDICATOR | VARCHAR2 | (30) | Yes | Indicates if record is school certification request, modification response after first notification of guarantee, reprint response, change transaction send response, application response up to first notification of guarantee, or service provider does not support change transaction |
| BORROWER_FIRST_NAME | VARCHAR2 | (150) | Borrower First Name | |
| BORROWER_LAST_NAME | VARCHAR2 | (150) | Indicates borrower's last name | |
| BORROWER_MIDDLE_NAME | VARCHAR2 | (150) | Indicates borrower's middle name | |
| BORROWER_SSN | NUMBER | (9) | Indicates borrower's SSN | |
| INTERNAL_RESPONSE_R1_ID | NUMBER | (15) | Yes | Identifier for the details which are returned by @4 record type, while processing the CommonLine Origination Acknowledgment Process |
| 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 | Standard WHO column |
Cut, paste (and edit) the following text to query this object:
SELECT LOAN_NUMBER
, FEDERAL_STAFFORD_LOAN_DEBT
, FEDERAL_SUPPLEMENTARY_DEBT
, HEAL_DEBT
, PERKINS_DEBT
, OTHER_DEBT
, BORROWER_GROSS_ANNUAL_SALARY
, BORROWER_OTHER_INCOME
, STUDENT_MAJOR
, _LA:CREDIT_UNDER_DIFF_NAME
, _LA:INTEREST_RATE_OPTION
, _LA:REPAYMENT_OPTION_CODE
, STUDENT_MONTHLY_HOUSING_PYMT
, STUDENT_MONTHLY_CRDTCARD_PYMT
, STUDENT_MONTHLY_AUTO_PYMT
, STUDENT_MONTHLY_ED_LOAN_PYMT
, STUDENT_MONTHLY_OTHER_PYMT
, COSIGNER_1_FIRST_NAME
, COSIGNER_1_LAST_NAME
, COSIGNER_1_MIDDLE_NAME
, COSIGNER_1_SSN
, COSIGNER_1_CITIZENSHIP
, COSIGNER_1_ADDRESS_LINE1
, COSIGNER_1_ADDRESS_LINE2
, COSIGNER_1_CITY
, COSIGNER_1_STATE
, COSIGNER_1_ZIP
, COSIGNER_1_ZIP_SUFFIX
, COSIGNER_1_PHONE
, COSIGNER_1_SIGNATURE_CODE
, COSIGNER_1_GROSS_ANUAL_SALARY
, COSIGNER_1_OTHER_INCOME
, COSIGNER_1_FORIEN_POSTAL_CODE
, COSIGNER_1_FORIEN_PHONE_PREFIX
, COSIGNER_1_DATE_OF_BIRTH
, COSIGNER_1_LICENSE_STATE
, COSIGNER_1_LICENSE_NUMBER
, COSIGNER_1_RELATIONSHIP_TO
, COSIGNER_1_YEARS_AT_ADDRESS
, COSIGNER_1_MONTH_HOUSING_PYMT
, COSIGNER_1_MONTH_CRDTCARD_PYMT
, COSIGNER_1_MONTH_AUTO_PYMT
, COSIGNER_1_MONTH_ED_LOAN_PYMT
, COSIGNER_1_MONTH_OTHER_PYMT
, COSIGNER_1_CRDT_AUTH_CODE
, COSIGNER_2_FIRST_NAME
, COSIGNER_2_LAST_NAME
, COSIGNER_2_MIDDLE_NAME
, COSIGNER_2_SSN
, COSIGNER_2_CITIZENSHIP
, COSIGNER_2_ADDRESS_LINE1
, COSIGNER_2_ADDRRESS_LINE2
, COSIGNER_2_CITY
, COSIGNER_2_STATE
, COSIGNER_2_ZIP
, COSIGNER_2_ZIP_SUFFIX
, COSIGNER_2_PHONE
, COSIGNER_2_SIGNATURE_CODE
, COSIGNER_2_GROSS_ANUAL_SALARY
, COSIGNER_2_OTHER_INCOME
, COSIGNER_2_FOREIGN_POSTAL_CODE
, COSIGNER_2_FOREIN_PHONE_PREFIX
, COSIGNER_2_DATE_OF_BIRTH
, COSIGNER_2_LICENSE_STATE
, COSIGNER_2_LICENSE_NUMBER
, COSIGNER_2_RELATIONSHIP_TO
, COSIGNER_2_YEARS_AT_ADDRESS
, COSIGNER_2_MONTH_HOUSING_PYMT
, COSIGNER_2_MONTH_CRDTCARD_PYMT
, COSIGNER_2_MONTH_AUTO_PYMT
, COSIGNER_2_MONTH_ED_LOAN_PYMT
, COSIGNER_2_MONTH_OTHER_PYMT
, COSIGNER_2_CRDT_AUTH_CODE
, RECORD_TYPE_INDICATOR
, BORROWER_FIRST_NAME
, BORROWER_LAST_NAME
, BORROWER_MIDDLE_NAME
, BORROWER_SSN
, INTERNAL_RESPONSE_R1_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGFBV_ALT_ORIG_RESPONSES;
APPS
IGF_SL_CL_RESP_R1_ALL
IGF_SL_CL_RESP_R4_ALL
APPS.IGFBV_ALT_ORIG_RESPONSES is not referenced by any database object
|
|
|
|