eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IGF.IGF_SL_DL_RESP_DTLS

Object Details

Object Name:	IGF_SL_DL_RESP_DTLS
Object Type:	TABLE
Owner:	IGF
FND Design Data:	IGF.IGF_SL_DL_RESP_DTLS
Subobject Name:
Status:	VALID

Table storing the 'DLU','DLS','DLP' Tag Response Elements from the response XML file

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_SL_DL_RESP_DTLS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	DL_LOAN_RESP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DL_LOAN_RESP_ID	NUMBER		Yes	Identifier for the direct loan response records
STDNT_RESP_ID	NUMBER			Identifier for the corresponding student response record.
DL_LOAN_TYPE	VARCHAR2	(30)	Yes	Indicates the direct loan type. ('DLU','DLS','DLP')
LOAN_KEY_NUM	NUMBER			Indicates the loan key
FIN_AWD_YR	VARCHAR2	(30)		Indicates the year corresponding to awards.
CPS_TRANS_NUM	NUMBER			Indicates the transaction number from eligible ISIR used to calculate award.
AWARD_AMT	NUMBER			Indicates the total award amount that the student is eligible to receive as determined by the school.
NOTE_MESSAGE	VARCHAR2	(100)		Indicates the Note Message
DEPNCY_STATUS	VARCHAR2	(30)		Indicates the student's dependency status code.
DEFAULT_STATUS	VARCHAR2	(30)		Indicates the student's default overpay code status
COD_AWARD_NUMBER_TXT	NUMBER			Indicates the last three digits of the Direct Loan - Loan Identifier
LOAN_NUMBER_TXT	VARCHAR2	(30)		Indicates the unique Direct Loan - Loan Identifier
AWARD_CREATE_DATE	DATE			Indicates the date the school created the award record.
B_SSN	VARCHAR2	(30)		Attribute indicating the Borrower driver's License State.
B_DRIVER_LIC_STATE	VARCHAR2	(60)		Attribute indicating the Borrower driver's License State.
B_DRIVER_LIC_NUMBER	VARCHAR2	(30)		Attribute indicating the Borrower driver's License Number.
B_BIRTH_DATE	DATE			Attribute indicating the Borrower Date of birth.
B_FIRST_NAME	VARCHAR2	(60)		Attribute indicating the Borrower First name
B_MIDDLE_NAME	VARCHAR2	(60)		Attribute indicating the Borrower Middle name.
B_LAST_NAME	VARCHAR2	(60)		Attribute indicating the pers Borroweron's Last name.
B_CHG_BIRTH_DATE	DATE			Indicates the changed Date of Birth
B_CHG_LAST_NAME	VARCHAR2	(60)		Indicates the changed Last Name
B_CHG_SSN	VARCHAR2	(30)		Indicates the changed SSN
B_PERMT_ADDR_FOREIGN_FLAG	VARCHAR2	(60)		Indicates if the Borrower's permanent address is foreign or not.
B_ADDR_TYPE_CODE	VARCHAR2	(30)		Indicates whether the Borrower's address is Permanent or Temporary
B_PERMT_ADDR_LINE_1	VARCHAR2	(40)		Indicates the Borrower's first line of permanent address
B_PERMT_ADDR_LINE_2	VARCHAR2	(40)		Indicates the Borrower's second line of permanent address
B_PERMT_ADDR_LINE_3	VARCHAR2	(40)		Indicates the Borrower's third line of permanent address
B_PERMT_ADDR_CITY	VARCHAR2	(60)		Indicates the Borrower's permanent address's city
B_PERMT_ADDR_STATE_CODE	VARCHAR2	(30)		Indicates the Borrower's permanent address's state code
B_PERMT_ADDR_POST_CODE	VARCHAR2	(30)		Indicates the Borrower's permanent address's postal Code (zip code).
B_PERMT_ADDR_COUNTY	VARCHAR2	(30)		Indicates the Borrower's permanent address's county
B_PERMT_ADDR_COUNTRY	VARCHAR2	(30)		Indicates the Borrower's permanent address's country
B_PHONE_NUMBER_1	VARCHAR2	(30)		Indicating the Borrower's phone number. There can be maximum of three phone numbers for a person.
B_PHONE_NUMBER_2	VARCHAR2	(30)		Indicating the Borrower's phone number. There can be maximum of three phone numbers for a person.
B_PHONE_NUMBER_3	VARCHAR2	(30)		Indicating the Borrower's phone number. There can be maximum of three phone numbers for a person.
B_TEMP_ADDR_FOREIGN_FLAG	VARCHAR2	(30)		Indicates if the Borrower's temporary address is foreign or not.
B_TEMP_ADDR_LINE_1	VARCHAR2	(40)		Indicates the Borrower's first line of temporary address
B_TEMP_ADDR_LINE_2	VARCHAR2	(40)		Indicates the Borrower's second line of temporary address
B_TEMP_ADDR_LINE_3	VARCHAR2	(40)		Indicates the Borrower's third line of temporary address
B_TEMP_ADDR_CITY	VARCHAR2	(60)		Indicates the Borrower's temporary address's city
B_TEMP_ADDR_STATE_CODE	VARCHAR2	(30)		Indicates the Borrower's temporary address's state code
B_TEMP_ADDR_POST_CODE	VARCHAR2	(30)		Indicates the Borrower's temporary address's postal Code (zip code).
B_TEMP_ADDR_COUNTY	VARCHAR2	(30)		Indicates the Borrower's temporary address's county
B_TEMP_ADDR_COUNTRY	VARCHAR2	(30)		Indicates the Borrower's temporary address's country
B_EMAIL_ADDRESS	VARCHAR2	(138)		Indicates the Borrower's E-mail address
B_CITZN_STATUS_CODE	VARCHAR2	(30)		Indicates the Borrower's citizenship status code
B_DEFAULT_STATUS	VARCHAR2	(30)		Indicates the Borrower's default overpay code status
B_RESP_CODE	VARCHAR2	(30)		Indicates the Borrower's Response Code
ELEC_MPN_FLAG	VARCHAR2	(30)		Indicates whether there is an electronic or paper MPN.
PNOTE_MPN_ID	VARCHAR2	(30)		Indicates the MPN identifier printed on the MPN.
MPN_STATUS_CODE	VARCHAR2	(30)		Indicates the status of the MPN on file at COD.
MPN_LINK_FLAG	VARCHAR2	(30)		Indicates whether or not the record has been linked to an MPN at COD.
PYMT_SERVICER_AMT	NUMBER			Indicates Amount of payment sent to the Servicer by the borrower.
PYMT_SERVICER_DATE	DATE			Indicates the date the Servicer posted the payment to the student's account.
BOOK_LOAN_AMT	NUMBER			Indicates the total net amount of disbursements accepted and booked.
BOOK_LOAN_AMT_DATE	DATE			Indicates the date the loan booked on COD.
ENDORSER_AMT	NUMBER			Indicates the total amount of loan for which the endorser has agreed to co-sign.
CRDT_DECISION_STATUS	VARCHAR2	(30)		Indicates the status of the PLUS credit decision for the loan on COD.
CRDT_DECISION_DATE	DATE			Indicates the date on which the creditcheck decision was processed.
CRDT_DECISION_OVRD_CODE	VARCHAR2	(30)		Indicates the status of the credit check for this loan on COD as a result of an override.
RESP_CODE	VARCHAR2	(30)		Indicates the response code
STATUS_CODE	VARCHAR2	(30)		Indicates the status of the record whether it has been processed or not. P - Processed R - Received N - Processed, Not found in the System
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who column
PROGRAM_ID	NUMBER	(15)		Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
REQUEST_ID	NUMBER	(15)		Standard Who column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DL_LOAN_RESP_ID
,      STDNT_RESP_ID
,      DL_LOAN_TYPE
,      LOAN_KEY_NUM
,      FIN_AWD_YR
,      CPS_TRANS_NUM
,      AWARD_AMT
,      NOTE_MESSAGE
,      DEPNCY_STATUS
,      DEFAULT_STATUS
,      COD_AWARD_NUMBER_TXT
,      LOAN_NUMBER_TXT
,      AWARD_CREATE_DATE
,      B_SSN
,      B_DRIVER_LIC_STATE
,      B_DRIVER_LIC_NUMBER
,      B_BIRTH_DATE
,      B_FIRST_NAME
,      B_MIDDLE_NAME
,      B_LAST_NAME
,      B_CHG_BIRTH_DATE
,      B_CHG_LAST_NAME
,      B_CHG_SSN
,      B_PERMT_ADDR_FOREIGN_FLAG
,      B_ADDR_TYPE_CODE
,      B_PERMT_ADDR_LINE_1
,      B_PERMT_ADDR_LINE_2
,      B_PERMT_ADDR_LINE_3
,      B_PERMT_ADDR_CITY
,      B_PERMT_ADDR_STATE_CODE
,      B_PERMT_ADDR_POST_CODE
,      B_PERMT_ADDR_COUNTY
,      B_PERMT_ADDR_COUNTRY
,      B_PHONE_NUMBER_1
,      B_PHONE_NUMBER_2
,      B_PHONE_NUMBER_3
,      B_TEMP_ADDR_FOREIGN_FLAG
,      B_TEMP_ADDR_LINE_1
,      B_TEMP_ADDR_LINE_2
,      B_TEMP_ADDR_LINE_3
,      B_TEMP_ADDR_CITY
,      B_TEMP_ADDR_STATE_CODE
,      B_TEMP_ADDR_POST_CODE
,      B_TEMP_ADDR_COUNTY
,      B_TEMP_ADDR_COUNTRY
,      B_EMAIL_ADDRESS
,      B_CITZN_STATUS_CODE
,      B_DEFAULT_STATUS
,      B_RESP_CODE
,      ELEC_MPN_FLAG
,      PNOTE_MPN_ID
,      MPN_STATUS_CODE
,      MPN_LINK_FLAG
,      PYMT_SERVICER_AMT
,      PYMT_SERVICER_DATE
,      BOOK_LOAN_AMT
,      BOOK_LOAN_AMT_DATE
,      ENDORSER_AMT
,      CRDT_DECISION_STATUS
,      CRDT_DECISION_DATE
,      CRDT_DECISION_OVRD_CODE
,      RESP_CODE
,      STATUS_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM IGF.IGF_SL_DL_RESP_DTLS;

Dependencies

[top of page]

IGF.IGF_SL_DL_RESP_DTLS does not reference any database object

IGF.IGF_SL_DL_RESP_DTLS is referenced by following:

APPS: IGF_SL_DL_RESP_DTLS