[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
IGF.IGF_SL_CL_RESP_R7_DTLS does not reference any database object
IGF.IGF_SL_CL_RESP_R7_DTLS is referenced by following:
|
|
|