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

TABLE: IGF.IGF_SL_LENDER_BRC

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


IGF_SL_LENDER_BRC contains lender non-ED branch codes and descriptions.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGF_SL_LENDER_BRC_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLENDER_ID
ColumnLEND_NON_ED_BRC_ID
IGF_SL_LENDER_BRC_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
LEND_NON_ED_BRC_ID VARCHAR2 (30) Yes Indicates unique identification code assigned by entity other than US Department of Education to lender's branch office
DESCRIPTION VARCHAR2 (80) Yes Indicates description of lender branch
PARTY_ID NUMBER (15)
Used to link lender's branch 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
,      LEND_NON_ED_BRC_ID
,      DESCRIPTION
,      PARTY_ID
,      ENABLED
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGF.IGF_SL_LENDER_BRC;

Dependencies

[top of page]

IGF.IGF_SL_LENDER_BRC does not reference any database object

IGF.IGF_SL_LENDER_BRC is referenced by following:

SchemaAPPS
SynonymIGF_SL_LENDER_BRC