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

TABLE: JTF.JTF_IH_MEDIA_ITEMS_STG

Object Details
Object Name: JTF_IH_MEDIA_ITEMS_STG
Object Type: TABLE
Owner: JTF
FND Design Data: TableJTF.JTF_IH_MEDIA_ITEMS_STG
Subobject Name:
Status: VALID


An instance of media that was processed by the system and/or its users. Media Items can be generated by a customer or by the system or an application. Media Items can be inbound (ex. Mail or call from a customer/person ) or outbound (ex. Mail or a call to a customer/person). It is not required that the Media Item is related to a known customer within the system. (Example: A call is received by an agent and it is then determined that the caller has the wrong number. )


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 20
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JTF_IH_MEDIA_ITEMS_STG_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnMEDIA_ID
Columns
Name Datatype Length Mandatory Comments
MEDIA_ID NUMBER (15) Yes Unique Media Identifier
SESSION_NO NUMBER (22)
Session Number for JTF_IH_IMPORT
SESSION_DATE DATE

Session Date for JTF_IH_IMPORT
STATUS_FL NUMBER (1)
Status Flag for JTF_IH_IMPORT
OBJECT_VERSION_NUMBER NUMBER (9)
Sequential number used for database locking control when using HTML as a user interface.
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
DURATION NUMBER

The number of seconds between the media item start and end times.
DIRECTION VARCHAR2 (240)
INBOUND or OUTBOUND
END_DATE_TIME DATE

The date and time the media item was completed.
SOURCE_ITEM_CREATE_DATE_TIME DATE

The date and time the interaction entered the source system
INTERACTION_PERFORMED VARCHAR2 (240)
Indicates if the item has been handled by and an interaction.
SOURCE_ITEM_ID NUMBER

Source system item identifer
START_DATE_TIME DATE

The date and time the media item entered the system
SOURCE_ID NUMBER

Unique identifer of a media source system
MEDIA_ITEM_TYPE VARCHAR2 (80) Yes Type of Media, such as telephone, email, or fax.
MEDIA_ITEM_REF VARCHAR2 (240)
Media reference to JTF_OBJECTS column OJBECT_CODE
MEDIA_DATA VARCHAR2 (80)
Reference to Media data from media provider
ACTIVE VARCHAR2 (1) Yes Used for Interaction History media item caching.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
MEDIA_ABANDON_FLAG VARCHAR2 (1)
Flag set by Media provider to indicate that media was abandoned.
MEDIA_TRANSFERRED_FLAG VARCHAR2 (1)
Flag set by Media provider to indicate that media was transferred.
SERVER_GROUP_ID NUMBER (15)
Server Group Identifier
CLASSIFICATION VARCHAR2 (64)
Classification
DNIS VARCHAR2 (30)
DNIS
ANI VARCHAR2 (30)
ANI
ADDRESS VARCHAR2 (2000)
Address
Query Text

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


SELECT MEDIA_ID
,      SESSION_NO
,      SESSION_DATE
,      STATUS_FL
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DURATION
,      DIRECTION
,      END_DATE_TIME
,      SOURCE_ITEM_CREATE_DATE_TIME
,      INTERACTION_PERFORMED
,      SOURCE_ITEM_ID
,      START_DATE_TIME
,      SOURCE_ID
,      MEDIA_ITEM_TYPE
,      MEDIA_ITEM_REF
,      MEDIA_DATA
,      ACTIVE
,      SECURITY_GROUP_ID
,      MEDIA_ABANDON_FLAG
,      MEDIA_TRANSFERRED_FLAG
,      SERVER_GROUP_ID
,      CLASSIFICATION
,      DNIS
,      ANI
,      ADDRESS
FROM JTF.JTF_IH_MEDIA_ITEMS_STG;

Dependencies

[top of page]

JTF.JTF_IH_MEDIA_ITEMS_STG does not reference any database object

JTF.JTF_IH_MEDIA_ITEMS_STG is referenced by following:

SchemaJTF
ViewJTF_IH_MEDIA_ITEMS_STG#