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

TABLE: IEC.IEC_G_CAL_CALENDARS_TL

Object Details
Object Name: IEC_G_CAL_CALENDARS_TL
Object Type: TABLE
Owner: IEC
Subobject Name:
Status: VALID


Contains translatable data describing Advanced Outbound calling calendars.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IEC_G_CAL_CALENDARS_TL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCALENDAR_ID
ColumnLANGUAGE
Columns
Name Datatype Length Mandatory Comments
CALENDAR_ID NUMBER (15) Yes Unique Identifier for the calling calendar. Is a foreign key to IEC_G_CALENDARS_B, and also makes up the primary key along with LANGUAGE.
CALENDAR_NAME VARCHAR2 (60)
The name of the calling calendar. Will be used to select this calendar when configuring lists or campaign schedules if this is an arbitrary calendar.
LANGUAGE VARCHAR2 (4) Yes Language code for the current record.
SOURCE_LANG VARCHAR2 (4) Yes The language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
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.
SECURITY_GROUP_ID NUMBER (15)
Used in hosted environments.
Query Text

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


SELECT CALENDAR_ID
,      CALENDAR_NAME
,      LANGUAGE
,      SOURCE_LANG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM IEC.IEC_G_CAL_CALENDARS_TL;

Dependencies

[top of page]

IEC.IEC_G_CAL_CALENDARS_TL does not reference any database object

IEC.IEC_G_CAL_CALENDARS_TL is referenced by following:

SchemaAPPS
SynonymIEC_G_CAL_CALENDARS_TL