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

TABLE: BIX.BIX_DM_GOALS_EMC

Object Details
Object Name: BIX_DM_GOALS_EMC
Object Type: TABLE
Owner: BIX
Subobject Name:
Status: VALID


This table contains goals defined for email center for each classification .


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CLASSIFICATION_ID NUMBER
Yes Unique identifier for classification .
SL_FOR_REPLIED_EMAILS NUMBER

An email is considered to be replied within service level if it is replied within the time (in hours) specified in this column .
SL_PERCENTAGE_GOAL NUMBER

Not Used .
CUSTOMIZATION_NPAR_1 NUMBER

Customization parameter for customer use .
CUSTOMIZATION_NPAR_2 NUMBER

Customization parameter for customer use .
CUSTOMIZATION_NPAR_3 NUMBER

Customization parameter for customer use .
CUSTOMIZATION_NPAR_4 NUMBER

Customization parameter for customer use .
CUSTOMIZATION_NPAR_5 NUMBER

Customization parameter for customer use .
CUSTOMIZATION_CPAR_1 VARCHAR2 (100)
Customization parameter for customer use .
CUSTOMIZATION_CPAR_2 VARCHAR2 (100)
Customization parameter for customer use .
CUSTOMIZATION_CPAR_3 VARCHAR2 (100)
Customization parameter for customer use .
CUSTOMIZATION_CPAR_4 VARCHAR2 (100)
Customization parameter for customer use .
CUSTOMIZATION_CPAR_5 VARCHAR2 (100)
Customization parameter for customer use .
SECURITY_GROUP_ID NUMBER

Subscriber id for CRM Online Services use .
LAST_UPDATE_DATE DATE

Standard Who Column .
CREATED_BY NUMBER

Standard Who Column .
CREATION_DATE DATE

Standard Who Column .
LAST_UPDATED_BY NUMBER

Standard Who Column .
LAST_UPDATE_LOGIN NUMBER

Standard Who Column .
END_DATE_ACTIVE DATE

The date when the content of the record ceases to be active. If this column is blank, then the record is still active.
ACCOUNTING_CODE VARCHAR2 (80)
Not used .
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment .
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment .
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment .
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment .
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment .
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment .
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment .
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment .
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment .
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment .
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment .
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment .
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment .
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment .
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment .
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfiled structure defining column .
Query Text

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


SELECT CLASSIFICATION_ID
,      SL_FOR_REPLIED_EMAILS
,      SL_PERCENTAGE_GOAL
,      CUSTOMIZATION_NPAR_1
,      CUSTOMIZATION_NPAR_2
,      CUSTOMIZATION_NPAR_3
,      CUSTOMIZATION_NPAR_4
,      CUSTOMIZATION_NPAR_5
,      CUSTOMIZATION_CPAR_1
,      CUSTOMIZATION_CPAR_2
,      CUSTOMIZATION_CPAR_3
,      CUSTOMIZATION_CPAR_4
,      CUSTOMIZATION_CPAR_5
,      SECURITY_GROUP_ID
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      END_DATE_ACTIVE
,      ACCOUNTING_CODE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
FROM BIX.BIX_DM_GOALS_EMC;

Dependencies

[top of page]

BIX.BIX_DM_GOALS_EMC does not reference any database object

BIX.BIX_DM_GOALS_EMC is referenced by following:

SchemaAPPS
SynonymBIX_DM_GOALS_EMC