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

TABLE: BIM.BIM_TRGT_SGMT_PERF_SUMM

Object Details
Object Name: BIM_TRGT_SGMT_PERF_SUMM
Object Type: TABLE
Owner: BIM
FND Design Data: TableBIM.BIM_TRGT_SGMT_PERF_SUMM
Subobject Name:
Status: VALID


BIM_TRGT_SGMT_PERF_SUMM contains summarized data by user-defined period.
.
The measures are number of lead, number of new customer accounts and initiated revenue.
.
These measures are dimensioned by target segments, campaigns, media, channels, market segments, sales channel and geographic locations.
.
Populated by BIM_TRGT_SGMT_PERF_PKG concurrent program.
.
.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BIM_TRGT_SGMT_PERF_SUMM_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnPERIOD_START_DATE
ColumnPERIOD_END_DATE
ColumnTARGET_SEGMENT_ID
ColumnCAMPAIGN_ID
ColumnMEDIA_ID
ColumnCHANNEL_ID
ColumnMARKET_SEGMENT_ID
ColumnSALES_CHANNEL_CODE
ColumnBILL_TO_GEOGRAPHY_CODE
Columns
Name Datatype Length Mandatory Comments
TARGET_SEGMENT_ID NUMBER
Yes Target segment id. -999 if unknown. Refer to view BIM_DIMV_TARGET_SGMTS for target segment details.
PERIOD_NAME VARCHAR2 (25) Yes Name of period that the data is summarized to.
CREATION_DATE DATE
Yes standard WHO column
CREATED_BY NUMBER
Yes standard WHO column
LAST_UPDATE_DATE DATE
Yes standard WHO column
LAST_UPDATED_BY NUMBER
Yes standard WHO column
LAST_UPDATE_LOGIN NUMBER

standard WHO column
REQUEST_ID NUMBER

Request identifier of last concurrent program to update record
PROGRAM_APPLICATION_ID NUMBER

Application identifier of last concurrent program to update record
PROGRAM_ID NUMBER

Identifier of last concurrent program to update record
PROGRAM_UPDATE_DATE DATE

Last date concurrent program updated record
PERIOD_START_DATE DATE
Yes Period start date.
PERIOD_END_DATE DATE
Yes Period end date.
CAMPAIGN_ID NUMBER
Yes campaign id of a campaign. -999 for no campaign. Refer to view BIM_DIMV_CAMPAIGNS for campaign details.
MEDIA_ID NUMBER
Yes Marketing Media id. -999 if unknown. Refer to view BIM_DIMV_MEDIA for media details.
CHANNEL_ID VARCHAR2 (80) Yes Marketing channel id. -999 if unknown. Channels can be media channels, events or event offerings. Channel prefixes are: CHLS for media channels, EVEH for events, EVEO for event offerings. Refer to view BIM_DIMV_CHANNELS for channel details.
MARKET_SEGMENT_ID NUMBER
Yes Market segment id. -999 if unknown. Refer to view BIM_DIMV_MARKET_SGMTS for market segment details.
SALES_CHANNEL_CODE VARCHAR2 (30) Yes Sales channel. -999 if unknown. Refer to view BIM_DIMV_SALES_CHANNELS for sales channel details.
SHIP_TO_GEOGRAPHY_CODE VARCHAR2 (240)
not used.
BILL_TO_GEOGRAPHY_CODE VARCHAR2 (240) Yes Location code. -999 if unknown. Refer to view BIM_DIMV_GEOGRAPHY for location details.
NUM_OF_LEADS NUMBER

number of leads.
NUM_OF_NEW_ACCTS NUMBER

number of new customer accounts.
INITIATED_REVENUE NUMBER

initiated revenue.
SECURITY_GROUP_ID NUMBER

This column is used in hosted environments
Query Text

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


SELECT TARGET_SEGMENT_ID
,      PERIOD_NAME
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      CAMPAIGN_ID
,      MEDIA_ID
,      CHANNEL_ID
,      MARKET_SEGMENT_ID
,      SALES_CHANNEL_CODE
,      SHIP_TO_GEOGRAPHY_CODE
,      BILL_TO_GEOGRAPHY_CODE
,      NUM_OF_LEADS
,      NUM_OF_NEW_ACCTS
,      INITIATED_REVENUE
,      SECURITY_GROUP_ID
FROM BIM.BIM_TRGT_SGMT_PERF_SUMM;

Dependencies

[top of page]

BIM.BIM_TRGT_SGMT_PERF_SUMM does not reference any database object

BIM.BIM_TRGT_SGMT_PERF_SUMM is referenced by following:

SchemaAPPS
SynonymBIM_TRGT_SGMT_PERF_SUMM