DBA Data[Home] [Help] [Dependency Information]

TABLE: IGF.IGF_SL_CL_RESP_R4_ALL

Object Details
Object Name: IGF_SL_CL_RESP_R4_ALL
Object Type: TABLE
Owner: IGF
FND Design Data: TableIGF.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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGF_SL_CL_RESP_R4_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCLRP1_ID
Columns
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
Query Text

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;

Dependencies

[top of page]

IGF.IGF_SL_CL_RESP_R4_ALL does not reference any database object

IGF.IGF_SL_CL_RESP_R4_ALL is referenced by following:

SchemaAPPS
SynonymIGF_SL_CL_RESP_R4_ALL