[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_SL_CL_RESP_R4_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | IGF |
| FND Design Data: |  IGF.IGF_SL_CL_RESP_R4_ALL
|
| Subobject Name: | |
| Status: | VALID |
IGF_SL_CL_RESP_R4_ALL stores all the details which are returned by @4 record type, while processing the CommonLine Origination Acknowledgment Process.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGF_SL_CL_RESP_R4_ALL_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 CLRP1_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CLRP1_ID | NUMBER | (15) | Yes | Identifier for the details which are returned by @4 record type, while processing the CommonLine Origination Acknowledgment Process. |
| LOAN_NUMBER | VARCHAR2 | (30) | Yes | Unique identifier for Direct Loan or CommonLine loan |
| FED_STAFFORD_LOAN_DEBT | NUMBER | (12) | Total Federal Stafford loan debt prior to this loan period, as known by the sending organization for the borrower | |
| FED_SLS_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 | |
| CRDT_UNDR_DIFFT_NAME | VARCHAR2 | (30) | Credit Under Different Name CodeA 1-character code indicating if the borrower has been granted credit under a different name.Y - YesN - No | |
| BORW_GROSS_ANNUAL_SAL | NUMBER | (12) | Borrower Gross Annual Salary | |
| BORW_OTHER_INCOME | NUMBER | (12) | Borrower Other Income | |
| STUDENT_MAJOR | VARCHAR2 | (30) | Student Major | |
| INT_RATE_OPT | VARCHAR2 | (30) | Interest Rate Option | |
| REPAYMENT_OPT_CODE | VARCHAR2 | (30) | Repayment Option Code | |
| STUD_MTH_HOUSING_PYMT | NUMBER | (12) | Total monthly housing payment paid by the student. | |
| STUD_MTH_CRDTCARD_PYMT | NUMBER | (12) | Total monthly credit card payment paid by the student. | |
| STUD_MTH_AUTO_PYMT | NUMBER | (12) | Total monthly auto payment paid by the student. | |
| STUD_MTH_ED_LOAN_PYMT | NUMBER | (12) | Total monthly educational loan payment paid by the student. | |
| STUD_MTH_OTHER_PYMT | NUMBER | (12) | Total monthly payment for other debts paid by the student | |
| COSNR_1_LAST_NAME | VARCHAR2 | (60) | First CoSigner's Last name | |
| COSNR_1_FIRST_NAME | VARCHAR2 | (60) | First CoSigner's First name | |
| COSNR_1_MIDDLE_NAME | VARCHAR2 | (30) | First CoSigner's Middle name | |
| COSNR_1_SSN | VARCHAR2 | (20) | First CoSigner's Social Security Number | |
| COSNR_1_CITIZENSHIP | VARCHAR2 | (30) | Indicates first cosigner's citizenship status. Values are U.S. citizen, eligible non-citizen, or ineligible non-citizen. | |
| COSNR_1_ADDR_LINE1 | VARCHAR2 | (60) | First Cosigner's first line of address | |
| COSNR_1_ADDR_LINE2 | VARCHAR2 | (60) | First CoSigner's second line of address | |
| COSNR_1_CITY | VARCHAR2 | (60) | First CoSigner's city | |
| COSNR_1_STATE | VARCHAR2 | (60) | First CoSigner's State | |
| COSNR_1_ZIP | VARCHAR2 | (30) | First CoSigner's zip code | |
| COSNR_1_ZIP_SUFFIX | VARCHAR2 | (30) | First CoSigner's zip suffix | |
| COSNR_1_PHONE | VARCHAR2 | (60) | First CoSigner Phone | |
| COSNR_1_SIG_CODE | VARCHAR2 | (30) | Indicates whether First CoSigner's borrower signed note | |
| COSNR_1_GROSS_ANL_SAL | NUMBER | (12) | First CoSigner's annual salary | |
| COSNR_1_OTHER_INCOME | NUMBER | (12) | First Cosigner's other income | |
| COSNR_1_FORN_POSTAL_CODE | VARCHAR2 | (30) | First Cosigner's foreign postal code | |
| COSNR_1_FORN_PHONE_PREFIX | VARCHAR2 | (30) | First Cosigner's foreign phone prefix | |
| COSNR_1_DOB | DATE | First Cosigner's date of birth | ||
| COSNR_1_LICENSE_STATE | VARCHAR2 | (30) | Indicates driver's license state of the first cosigner | |
| COSNR_1_LICENSE_NUM | VARCHAR2 | (30) | Indicates driver's license number of first cosigner | |
| COSNR_1_RELATIONSHIP_TO | VARCHAR2 | (30) | First cosigner's relationship to the student | |
| COSNR_1_YEARS_AT_ADDR | VARCHAR2 | (30) | Number of years the first Cosigner has been at this address | |
| COSNR_1_MTH_HOUSING_PYMT | NUMBER | (12) | Total monthly housing payment paid by the first cosigner | |
| COSNR_1_MTH_CRDTCARD_PYMT | NUMBER | (12) | Total monthly credit card payment paid by the first cosigner | |
| COSNR_1_MTH_AUTO_PYMT | NUMBER | (12) | Total monthly auto payment paid by the first cosigner | |
| COSNR_1_MTH_ED_LOAN_PYMT | NUMBER | (12) | Total monthly educational loan payment paid by the first cosigner | |
| COSNR_1_MTH_OTHER_PYMT | NUMBER | (12) | Total monthly payment for other debts paid by the first cosigner | |
| COSNR_1_CRDT_AUTH_CODE | VARCHAR2 | (30) | First Cosigner's credit authorisation code | |
| COSNR_2_LAST_NAME | VARCHAR2 | (60) | Second Cosigner's last name | |
| COSNR_2_FIRST_NAME | VARCHAR2 | (60) | Second Cosigner's first name | |
| COSNR_2_MIDDLE_NAME | VARCHAR2 | (30) | Second CoSigner's middle name | |
| COSNR_2_SSN | VARCHAR2 | (20) | Second Cosigner's social security number | |
| COSNR_2_CITIZENSHIP | VARCHAR2 | (30) | Indicates second cosigner's citizenship status. Values are U.S. citizen, eligible non-citizen, or ineligible non-citizen. | |
| COSNR_2_ADDR_LINE1 | VARCHAR2 | (60) | Second Cosigner's first line of address | |
| COSNR_2_ADDR_LINE2 | VARCHAR2 | (60) | Second CoSigner's second line of address | |
| COSNR_2_CITY | VARCHAR2 | (60) | Second CoSigner's city | |
| COSNR_2_STATE | VARCHAR2 | (60) | Second CoSigner's State | |
| COSNR_2_ZIP | VARCHAR2 | (30) | Seond CoSigner's zip code | |
| COSNR_2_ZIP_SUFFIX | VARCHAR2 | (30) | Second CoSigner's zip suffix | |
| COSNR_2_PHONE | VARCHAR2 | (60) | Seond CoSigner Phone | |
| COSNR_2_SIG_CODE | VARCHAR2 | (30) | Indicates whether Second CoSigner's borrower signed note | |
| COSNR_2_GROSS_ANL_SAL | NUMBER | (12) | Second CoSigner's annual salary | |
| COSNR_2_OTHER_INCOME | NUMBER | (12) | Second Cosigner's other income | |
| COSNR_2_FORN_POSTAL_CODE | VARCHAR2 | (30) | Second Cosigner's foreign postal code | |
| COSNR_2_FORN_PHONE_PREFIX | VARCHAR2 | (30) | Second Cosigner's foreign phone prefix | |
| COSNR_2_DOB | DATE | Second Cosigner's date of birth | ||
| COSNR_2_LICENSE_STATE | VARCHAR2 | (30) | Indicates driver's license state of the second cosigner | |
| COSNR_2_LICENSE_NUM | VARCHAR2 | (30) | Indicates driver's license number of second cosigner | |
| COSNR_2_RELATIONSHIP_TO | VARCHAR2 | (30) | Second cosigner's relationship to the student | |
| COSNR_2_YEARS_AT_ADDR | VARCHAR2 | (30) | Number of years the second Cosigner has been at this address | |
| COSNR_2_MTH_HOUSING_PYMT | NUMBER | (12) | Total monthly housing payment paid by the second cosigner | |
| COSNR_2_MTH_CRDTCARD_PYMT | NUMBER | (12) | Total monthly credit card payment paid by the second cosigner | |
| COSNR_2_MTH_AUTO_PYMT | NUMBER | (12) | Total monthly auto payment paid by the second cosigner | |
| COSNR_2_MTH_ED_LOAN_PYMT | NUMBER | (12) | Total monthly educational loan payment paid by the second cosigner | |
| COSNR_2_MTH_OTHER_PYMT | NUMBER | (12) | Total monthly payment for other debts paid by the second cosigner | |
| COSNR_2_CRDT_AUTH_CODE | VARCHAR2 | (30) | Second Cosigner's credit authorisation code | |
| ORG_ID | NUMBER | (15) | Organization Identifier | |
| 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 | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| REQUEST_ID | NUMBER | (15) | Standard who column for concurrent programs | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard who column for concurrent programs | |
| PROGRAM_ID | NUMBER | (15) | Standard who column for concurrent programs | |
| PROGRAM_UPDATE_DATE | DATE | Standard who column for concurrent programs | ||
| OTHER_LOAN_AMT | NUMBER | The borrowers total other student educational loan debt for this loan period, as reported by the creator of the Application Send File. This amount includes both federal and alternative loans. | ||
| ALT_LAYOUT_OWNER_CODE_TXT | VARCHAR2 | (4) | Alternative Loan Layout Owner Code. A code (maximum of 4 characters) indicating the owner of the fields layout included in this record. Because the Alternative Loan Response (@4) Detail Record layout is owned by NCHELP, this field contains the constant: NCLP | |
| ALT_LAYOUT_IDENTI_CODE_TXT | VARCHAR2 | (2) | Alternative Loan Layout Identifier Code. A 2-character code identifying the field's layout included in this detail record. This field contains the constant: 05 | |
| STUDENT_SCHOOL_PHONE_TXT | VARCHAR2 | (10) | Student School Phone. The student's school telephone number. This includes the 3-digit area code and 7-digit telephone number. | |
| FIRST_CSGNR_ELEC_SIGN_FLAG | VARCHAR2 | (1) | A 1-character code indicating if the first cosigner electronically signed the promissory note. Y = Yes, the signature has been captured electronically. Valid values Y and Blank | |
| SECOND_CSGNR_ELEC_SIGN_FLAG | VARCHAR2 | (1) | A 1-character code indicating if the second cosigner electronically signed the promissory note. Y = Yes, the signature has been captured electronically. Valid values Y and Blank |
Cut, paste (and edit) the following text to query this object:
SELECT CLRP1_ID
, LOAN_NUMBER
, FED_STAFFORD_LOAN_DEBT
, FED_SLS_DEBT
, HEAL_DEBT
, PERKINS_DEBT
, OTHER_DEBT
, CRDT_UNDR_DIFFT_NAME
, BORW_GROSS_ANNUAL_SAL
, BORW_OTHER_INCOME
, STUDENT_MAJOR
, INT_RATE_OPT
, REPAYMENT_OPT_CODE
, STUD_MTH_HOUSING_PYMT
, STUD_MTH_CRDTCARD_PYMT
, STUD_MTH_AUTO_PYMT
, STUD_MTH_ED_LOAN_PYMT
, STUD_MTH_OTHER_PYMT
, COSNR_1_LAST_NAME
, COSNR_1_FIRST_NAME
, COSNR_1_MIDDLE_NAME
, COSNR_1_SSN
, COSNR_1_CITIZENSHIP
, COSNR_1_ADDR_LINE1
, COSNR_1_ADDR_LINE2
, COSNR_1_CITY
, COSNR_1_STATE
, COSNR_1_ZIP
, COSNR_1_ZIP_SUFFIX
, COSNR_1_PHONE
, COSNR_1_SIG_CODE
, COSNR_1_GROSS_ANL_SAL
, COSNR_1_OTHER_INCOME
, COSNR_1_FORN_POSTAL_CODE
, COSNR_1_FORN_PHONE_PREFIX
, COSNR_1_DOB
, COSNR_1_LICENSE_STATE
, COSNR_1_LICENSE_NUM
, COSNR_1_RELATIONSHIP_TO
, COSNR_1_YEARS_AT_ADDR
, COSNR_1_MTH_HOUSING_PYMT
, COSNR_1_MTH_CRDTCARD_PYMT
, COSNR_1_MTH_AUTO_PYMT
, COSNR_1_MTH_ED_LOAN_PYMT
, COSNR_1_MTH_OTHER_PYMT
, COSNR_1_CRDT_AUTH_CODE
, COSNR_2_LAST_NAME
, COSNR_2_FIRST_NAME
, COSNR_2_MIDDLE_NAME
, COSNR_2_SSN
, COSNR_2_CITIZENSHIP
, COSNR_2_ADDR_LINE1
, COSNR_2_ADDR_LINE2
, COSNR_2_CITY
, COSNR_2_STATE
, COSNR_2_ZIP
, COSNR_2_ZIP_SUFFIX
, COSNR_2_PHONE
, COSNR_2_SIG_CODE
, COSNR_2_GROSS_ANL_SAL
, COSNR_2_OTHER_INCOME
, COSNR_2_FORN_POSTAL_CODE
, COSNR_2_FORN_PHONE_PREFIX
, COSNR_2_DOB
, COSNR_2_LICENSE_STATE
, COSNR_2_LICENSE_NUM
, COSNR_2_RELATIONSHIP_TO
, COSNR_2_YEARS_AT_ADDR
, COSNR_2_MTH_HOUSING_PYMT
, COSNR_2_MTH_CRDTCARD_PYMT
, COSNR_2_MTH_AUTO_PYMT
, COSNR_2_MTH_ED_LOAN_PYMT
, COSNR_2_MTH_OTHER_PYMT
, COSNR_2_CRDT_AUTH_CODE
, ORG_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, OTHER_LOAN_AMT
, ALT_LAYOUT_OWNER_CODE_TXT
, ALT_LAYOUT_IDENTI_CODE_TXT
, STUDENT_SCHOOL_PHONE_TXT
, FIRST_CSGNR_ELEC_SIGN_FLAG
, SECOND_CSGNR_ELEC_SIGN_FLAG
FROM IGF.IGF_SL_CL_RESP_R4_ALL;
IGF.IGF_SL_CL_RESP_R4_ALL does not reference any database object
IGF.IGF_SL_CL_RESP_R4_ALL is referenced by following:
APPS
IGF_SL_CL_RESP_R4_ALL
|
|
|
|