[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_SL_CL_RESP_R4 |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGF.IGF_SL_CL_RESP_R4
|
| Subobject Name: | |
| Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| CLRP1_ID | NUMBER | (15) | Yes | |
| LOAN_NUMBER | VARCHAR2 | (30) | Yes | |
| FED_STAFFORD_LOAN_DEBT | NUMBER | (12) | ||
| FED_SLS_DEBT | NUMBER | (12) | ||
| HEAL_DEBT | NUMBER | (12) | ||
| PERKINS_DEBT | NUMBER | (12) | ||
| OTHER_DEBT | NUMBER | (12) | ||
| CRDT_UNDR_DIFFT_NAME | VARCHAR2 | (30) | ||
| BORW_GROSS_ANNUAL_SAL | NUMBER | (12) | ||
| BORW_OTHER_INCOME | NUMBER | (12) | ||
| STUDENT_MAJOR | VARCHAR2 | (30) | ||
| INT_RATE_OPT | VARCHAR2 | (30) | ||
| REPAYMENT_OPT_CODE | VARCHAR2 | (30) | ||
| STUD_MTH_HOUSING_PYMT | NUMBER | (12) | ||
| STUD_MTH_CRDTCARD_PYMT | NUMBER | (12) | ||
| STUD_MTH_AUTO_PYMT | NUMBER | (12) | ||
| STUD_MTH_ED_LOAN_PYMT | NUMBER | (12) | ||
| STUD_MTH_OTHER_PYMT | NUMBER | (12) | ||
| COSNR_1_LAST_NAME | VARCHAR2 | (60) | ||
| COSNR_1_FIRST_NAME | VARCHAR2 | (60) | ||
| COSNR_1_MIDDLE_NAME | VARCHAR2 | (30) | ||
| COSNR_1_SSN | VARCHAR2 | (20) | ||
| COSNR_1_CITIZENSHIP | VARCHAR2 | (30) | ||
| COSNR_1_ADDR_LINE1 | VARCHAR2 | (60) | ||
| COSNR_1_ADDR_LINE2 | VARCHAR2 | (60) | ||
| COSNR_1_CITY | VARCHAR2 | (60) | ||
| COSNR_1_STATE | VARCHAR2 | (60) | ||
| COSNR_1_ZIP | VARCHAR2 | (30) | ||
| COSNR_1_ZIP_SUFFIX | VARCHAR2 | (30) | ||
| COSNR_1_PHONE | VARCHAR2 | (60) | ||
| COSNR_1_SIG_CODE | VARCHAR2 | (30) | ||
| COSNR_1_GROSS_ANL_SAL | NUMBER | (12) | ||
| COSNR_1_OTHER_INCOME | NUMBER | (12) | ||
| COSNR_1_FORN_POSTAL_CODE | VARCHAR2 | (30) | ||
| COSNR_1_FORN_PHONE_PREFIX | VARCHAR2 | (30) | ||
| COSNR_1_DOB | DATE | |||
| COSNR_1_LICENSE_STATE | VARCHAR2 | (30) | ||
| COSNR_1_LICENSE_NUM | VARCHAR2 | (30) | ||
| COSNR_1_RELATIONSHIP_TO | VARCHAR2 | (30) | ||
| COSNR_1_YEARS_AT_ADDR | VARCHAR2 | (30) | ||
| COSNR_1_MTH_HOUSING_PYMT | NUMBER | (12) | ||
| COSNR_1_MTH_CRDTCARD_PYMT | NUMBER | (12) | ||
| COSNR_1_MTH_AUTO_PYMT | NUMBER | (12) | ||
| COSNR_1_MTH_ED_LOAN_PYMT | NUMBER | (12) | ||
| COSNR_1_MTH_OTHER_PYMT | NUMBER | (12) | ||
| COSNR_1_CRDT_AUTH_CODE | VARCHAR2 | (30) | ||
| COSNR_2_LAST_NAME | VARCHAR2 | (60) | ||
| COSNR_2_FIRST_NAME | VARCHAR2 | (60) | ||
| COSNR_2_MIDDLE_NAME | VARCHAR2 | (30) | ||
| COSNR_2_SSN | VARCHAR2 | (20) | ||
| COSNR_2_CITIZENSHIP | VARCHAR2 | (30) | ||
| COSNR_2_ADDR_LINE1 | VARCHAR2 | (60) | ||
| COSNR_2_ADDR_LINE2 | VARCHAR2 | (60) | ||
| COSNR_2_CITY | VARCHAR2 | (60) | ||
| COSNR_2_STATE | VARCHAR2 | (60) | ||
| COSNR_2_ZIP | VARCHAR2 | (30) | ||
| COSNR_2_ZIP_SUFFIX | VARCHAR2 | (30) | ||
| COSNR_2_PHONE | VARCHAR2 | (60) | ||
| COSNR_2_SIG_CODE | VARCHAR2 | (30) | ||
| COSNR_2_GROSS_ANL_SAL | NUMBER | (12) | ||
| COSNR_2_OTHER_INCOME | NUMBER | (12) | ||
| COSNR_2_FORN_POSTAL_CODE | VARCHAR2 | (30) | ||
| COSNR_2_FORN_PHONE_PREFIX | VARCHAR2 | (30) | ||
| COSNR_2_DOB | DATE | |||
| COSNR_2_LICENSE_STATE | VARCHAR2 | (30) | ||
| COSNR_2_LICENSE_NUM | VARCHAR2 | (30) | ||
| COSNR_2_RELATIONSHIP_TO | VARCHAR2 | (30) | ||
| COSNR_2_YEARS_AT_ADDR | VARCHAR2 | (30) | ||
| COSNR_2_MTH_HOUSING_PYMT | NUMBER | (12) | ||
| COSNR_2_MTH_CRDTCARD_PYMT | NUMBER | (12) | ||
| COSNR_2_MTH_AUTO_PYMT | NUMBER | (12) | ||
| COSNR_2_MTH_ED_LOAN_PYMT | NUMBER | (12) | ||
| COSNR_2_MTH_OTHER_PYMT | NUMBER | (12) | ||
| COSNR_2_CRDT_AUTH_CODE | VARCHAR2 | (30) | ||
| ORG_ID | NUMBER | (15) | ||
| CREATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | |||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| REQUEST_ID | NUMBER | (15) | ||
| PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
| PROGRAM_ID | NUMBER | (15) | ||
| PROGRAM_UPDATE_DATE | DATE | |||
| 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 ROW_ID
, 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 APPS.IGF_SL_CL_RESP_R4;
APPS
IGF_SL_CL_RESP_R4_ALL
APPS
IGF_SL_CL_ORIG_ACK
- show dependent code
|
|
|
|