MKT_SR_ACCOUNT
This table stores the resulting SRS (saved result sets) data for Customers (Accounts) Real Time target level. Specifically, it saves the customer identifiers of complex segmentation criteria which can be used in other segments and to keep track of which targets joined or left a segment.
Details
-
Schema: FUSION
-
Object owner: MKT
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
MKT_SR_ACCOUNT_PK |
GUID, TARGET_LEVEL_ID |
Columns
Name | Datatype | Length | Not-null | Comments |
---|---|---|---|---|
GUID | VARCHAR2 | 50 | Yes | Unique identifier of the saved result set |
TARGET_LEVEL_ID | VARCHAR2 | 30 | Yes | Target level ID that qualified for this saved result set |
OFFER_CODE | VARCHAR2 | 100 | Standard attribute for offer code | |
CHANNEL | VARCHAR2 | 100 | Standard attribute for channel type | |
TAG_01 | VARCHAR2 | 250 | Column to hold custom attribute or column | |
TAG_02 | VARCHAR2 | 250 | Column to hold custom attribute or column | |
TAG_03 | VARCHAR2 | 250 | Column to hold custom attribute or column | |
TAG_04 | VARCHAR2 | 250 | Column to hold custom attribute or column | |
TAG_05 | VARCHAR2 | 250 | Column to hold custom attribute or column | |
TAG_06 | VARCHAR2 | 250 | Column to hold custom attribute or column | |
TAG_07 | VARCHAR2 | 250 | Column to hold custom attribute or column | |
TAG_08 | VARCHAR2 | 250 | Column to hold custom attribute or column | |
TAG_09 | VARCHAR2 | 250 | Column to hold custom attribute or column | |
TAG_10 | VARCHAR2 | 250 | Column to hold custom attribute or column | |
TAG_11 | VARCHAR2 | 250 | Column to hold custom attribute or column | |
TAG_12 | VARCHAR2 | 250 | Column to hold custom attribute or column | |
TAG_13 | VARCHAR2 | 250 | Column to hold custom attribute or column | |
TAG_14 | VARCHAR2 | 250 | Column to hold custom attribute or column | |
TAG_15 | VARCHAR2 | 250 | Column to hold custom attribute or column |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
MKT_SR_ACCOUNT | mkt_sr_header | GUID |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
MKT_SR_ACCOUNT_N1 | Non Unique | FUSION_TS_TX_DATA | GUID | Obsolete |
MKT_SR_ACCOUNT_U1 | Unique | Default | GUID, TARGET_LEVEL_ID |