Business Context Metadata Table
MD_BUSINESS_CONTEXT (Non-partitioned)
This table contains information about published business contexts. For more information, see About Business Contexts in SAS Customer Intelligence 360: User’s Guide.
The categories for this table are
DESTINATIONS,
ENGAGEDIGITAL,
ENGAGEEMAIL,
ENGAGEDIRECT,ENGAGEMETADATA,
ENGAGEWEB,
ENGAGEMOBILE, and
SMS. For more information, see Categories for Data Tables in SAS Customer Intelligence 360: Administration Guide.
|
Column Name |
Data Type |
Label |
Description |
Schema First Introduced |
|---|---|---|---|---|
|
business_context_id |
VARCHAR(36) |
Business Context ID |
Unique identifier for the business context object. |
6 |
|
business_context_nm |
VARCHAR(256) |
Business Context Name |
Name of the business context. |
6 |
|
business_context_status_cd |
VARCHAR(20) |
Business Context Status |
Publish status of the business context (active, completed, or history). |
6 |
|
business_context_version_id |
VARCHAR(36) |
Business Context Version ID |
Version of the business context based on publishing. Each subsequent publish adds a new version ID. |
6 |
|
valid_from_dttm |
TIMESTAMP |
Business Context Valid From Datetime |
Timestamp of when an item was published. |
6 |
|
valid_to_dttm |
TIMESTAMP |
Business Context Valid To Datetime |
Timestamp of when an item was ended. The value of the column is based on the item's status:
|
6 |
|
business_context_desc |
VARCHAR(1332) |
Business Context Description |
Description of the business context. |
6 |
|
created_user_nm |
VARCHAR(256) Note: The length of the column is updated in schema 16. |
Business Context Created By User |
User that created the object. |
6 |
|
owner_nm |
VARCHAR(256) Note: The length of the column is updated in schema 16. |
Business Context Published By User |
User that modified the object. |
6 |
|
last_published_dttm |
TIMESTAMP |
Business Context Last Published Date |
Datetime stamp for when the object was last published. |
6 |
|
business_context_src_cd |
VARCHAR(40) |
Business Context Source |
Source for the business context. |
6 |
|
information_map_nm |
VARCHAR(40) |
Business Context Information Map |
Placeholder for a future attribute. |
6 |
|
locked_information_map_nm |
VARCHAR(40) |
Business Context Locked Information Map |
Placeholder for a future attribute. |
6 |
MD_BUSINESS_CONTEXT_ALL (Non-partitioned)
This table contains information about published business contexts. For more information, see About Business Contexts in SAS Customer Intelligence 360: User’s Guide. This table includes the complete history of metadata for the items.
The category for this table is
METADATA_ALL. For more information, see Categories for Data Tables in SAS Customer Intelligence 360: Administration Guide.
|
Column Name |
Data Type |
Label |
Description |
Schema First Introduced |
|---|---|---|---|---|
|
business_context_id |
VARCHAR(36) |
Business Context ID |
Unique identifier for the business context object. |
20 |
|
business_context_nm |
VARCHAR(256) |
Business Context Name |
Name of the business context. |
20 |
|
business_context_status_cd |
VARCHAR(20) |
Business Context Status |
Publish status of the business context (active, completed, or history). |
20 |
|
business_context_version_id |
VARCHAR(36) |
Business Context Version ID |
Version of the business context based on publishing. Each subsequent publish adds a new version ID. |
20 |
|
valid_from_dttm |
TIMESTAMP |
Business Context Valid From Datetime |
Timestamp of when an item was published. |
20 |
|
valid_to_dttm |
TIMESTAMP |
Business Context Valid To Datetime |
Timestamp of when an item was ended. The value of the column is based on the item's status:
|
20 |
|
business_context_desc |
VARCHAR(1332) |
Business Context Description |
Description of the business context. |
20 |
|
created_user_nm |
VARCHAR(256) |
Business Context Created By User |
User that created the object. |
20 |
|
owner_nm |
VARCHAR(256) |
Business Context Published By User |
User that modified the object. |
20 |
|
last_published_dttm |
TIMESTAMP |
Business Context Last Published Date |
Datetime stamp for when the object was last published. |
20 |
|
business_context_src_cd |
VARCHAR(40) |
Business Context Source |
Source for the business context. |
20 |
|
information_map_nm |
VARCHAR(40) |
Business Context Information Map |
Placeholder for a future attribute. |
20 |
|
locked_information_map_nm |
VARCHAR(40) |
Business Context Locked Information Map |
Placeholder for a future attribute. |
20 |