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

TABLE: IGF.IGF_SL_LENDER

Object Details
Object Name: IGF_SL_LENDER
Object Type: TABLE
Owner: IGF
FND Design Data: TableIGF.IGF_SL_LENDER
Subobject Name:
Status: VALID


IGF_SL_LENDER contains lender codes and descriptions.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGF_SL_LENDER_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLENDER_ID
IGF_SL_LENDER_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTY_ID
Columns
Name Datatype Length Mandatory Comments
LENDER_ID VARCHAR2 (30) Yes Indicates unique 6-character identification code assigned by ED to lender associated with loan
DESCRIPTION VARCHAR2 (80) Yes Indicates lender name or description
DUNS_LENDER_ID VARCHAR2 (30)
Obsolete
PARTY_ID NUMBER (15)
Used to link lender organization with TCA
ENABLED VARCHAR2 (1) Yes Indicator that specifies whether lender is active. Setting check box to inactive prevents use of lender in new or modified records.
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
Query Text

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


SELECT LENDER_ID
,      DESCRIPTION
,      DUNS_LENDER_ID
,      PARTY_ID
,      ENABLED
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGF.IGF_SL_LENDER;

Dependencies

[top of page]

IGF.IGF_SL_LENDER does not reference any database object

IGF.IGF_SL_LENDER is referenced by following:

SchemaAPPS
SynonymIGF_SL_LENDER