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

TABLE: IGF.IGF_SL_SERVICER

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


IGF_SL_SERVICER contains servicer codes and descriptions.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGF_SL_SERVICER_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSERVICER_ID
IGF_SL_SERVICER_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTY_ID
Columns
Name Datatype Length Mandatory Comments
SERVICER_ID VARCHAR2 (30) Yes Indicates unique 6-character identification code assigned by ED to servicer processing loan
DESCRIPTION VARCHAR2 (80) Yes Indicates servicer name or description
DUNS_SERVICER_ID VARCHAR2 (30)
Obsolete
PARTY_ID NUMBER (15)
Used to link servicer organization with TCA
ENABLED VARCHAR2 (1) Yes Indicator that specifies whether servicer is active. Setting check box to inactive prevents use of servicer 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 SERVICER_ID
,      DESCRIPTION
,      DUNS_SERVICER_ID
,      PARTY_ID
,      ENABLED
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGF.IGF_SL_SERVICER;

Dependencies

[top of page]

IGF.IGF_SL_SERVICER does not reference any database object

IGF.IGF_SL_SERVICER is referenced by following:

SchemaAPPS
SynonymIGF_SL_SERVICER