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_CL_RESP_R7_DTLS

Object Details

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

CommonLine Response Table holds information from the Response @3 Layouts

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_SL_CL_RESP_R7_DTLS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CLRESP7_ID
IGF_SL_CL_RESP_R7_DTLS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CLRP1_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CLRESP7_ID	NUMBER		Yes	Primary Key of the table, generated from IGF_SL_CL_RESP_R7_DTLS_S
CLRP1_ID	NUMBER		Yes	Foreign Key to Response @4 table
RECORD_CODE_TXT	VARCHAR2	(2)		Record Code
LAYOUT_OWNER_CODE_TXT	VARCHAR2	(4)		A code (maximum of 4 characters) indicating the owner of the fields layout included in this record. Because the Supplemental Borrower Information Response (@7) Detail Record layout is owned by NCHELP, this field must contain the constant: NCLP
LAYOUT_IDENTIFIER_CODE_TXT	VARCHAR2	(2)		A 2-character code identifying the field layout included in this detail record. This field must contain the constant: 05
EMAIL_TXT	VARCHAR2	(256)		Email of the Borrower. This field may contain both upper- and lower-case characters. Service providers must store and forward data in the same format received in the Supplemental Borrower Information (@7) Detail Record(s) Addendum.
VALID_EMAIL_FLAG	VARCHAR2	(1)		A 1-character field that indicates if the borrower's e-mail address is valid.Y = Yes, e-mail address provided in field 4 is an active e-mail address for the borrowerN = No, e-mail address provided in field 4 is no longer a valid email address
EMAIL_EFFECTIVE_DATE	DATE			The date the borrower's e-mail address became effective or the sender became aware of the information
BORROWER_TEMP_ADD_LINE_1_TXT	VARCHAR2	(30)		The first line of the borrower's temporary address.
BORROWER_TEMP_ADD_LINE_2_TXT	VARCHAR2	(30)		The second line of the borrower's temporary address.
BORROWER_TEMP_ADD_CITY_TXT	VARCHAR2	(30)		The city of the borrower's temporary address.
BORROWER_TEMP_ADD_STATE_TXT	VARCHAR2	(2)		The 2-character state abbreviation of the borrower's temporary address.
BORROWER_TEMP_ADD_ZIP_NUM	NUMBER	(5)		The 5-digit zip code of the borrower's temporary address
BORROWER_TEMP_ADD_ZIP_XTN_NUM	NUMBER	(4)		The 4-digit zip code extension of the borrower's temporary address
BORROWER_FORGN_POSTAL_CODE_TXT	VARCHAR2	(14)		A 14-character field indicating the foreign postal code of the borrower's temporary address
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		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
REQUEST_ID	NUMBER	(15)		Standard Who column for Concurrent Program
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who column for Concurrent Program
PROGRAM_ID	NUMBER	(15)		Standard Who column for Concurrent Program
PROGRAM_UPDATE_DATE	DATE			Standard Who column for Concurrent Program

Query Text

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


SELECT CLRESP7_ID
,      CLRP1_ID
,      RECORD_CODE_TXT
,      LAYOUT_OWNER_CODE_TXT
,      LAYOUT_IDENTIFIER_CODE_TXT
,      EMAIL_TXT
,      VALID_EMAIL_FLAG
,      EMAIL_EFFECTIVE_DATE
,      BORROWER_TEMP_ADD_LINE_1_TXT
,      BORROWER_TEMP_ADD_LINE_2_TXT
,      BORROWER_TEMP_ADD_CITY_TXT
,      BORROWER_TEMP_ADD_STATE_TXT
,      BORROWER_TEMP_ADD_ZIP_NUM
,      BORROWER_TEMP_ADD_ZIP_XTN_NUM
,      BORROWER_FORGN_POSTAL_CODE_TXT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM IGF.IGF_SL_CL_RESP_R7_DTLS;

Dependencies

[top of page]

IGF.IGF_SL_CL_RESP_R7_DTLS does not reference any database object

IGF.IGF_SL_CL_RESP_R7_DTLS is referenced by following:

APPS: IGF_SL_CL_RESP_R7_DTLS