Dimensional Warehouse Model Data Model

Entity

Entity Business Rule Event Dimension

Description

A precise and detailed statement that specifies the data conditions to be monitored in relation to a business rule event.

For example:
The vital signs, test results and clinical observations required to identify a patient infection.

Attributes
AWM Load Info Sk
Business Rule Event Definition Access Cd
Business Rule Event Definition Access Code Sk
Business Rule Event Definition Access Descr
Business Rule Event Definition Author Job Title Nm
Business Rule Event Definition Author Login Nm
Business Rule Event Definition Author Sk
Business Rule Event Definition Author Tenant Bk
Business Rule Event Definition Author Tenant Nm
Business Rule Event Definition Author Tenant Num
Business Rule Event Definition Author Tenant Sk
Business Rule Event Definition Author Type Cd
Business Rule Event Definition Author Type Code Sk
Business Rule Event Definition Author Type Descr
Business Rule Event Definition Bk
Business Rule Event Definition Detail Message Descr
Business Rule Event Definition Dk
Business Rule Event Definition Sk
Business Rule Event Definition Status Cd
Business Rule Event Definition Status Code Sk
Business Rule Event Definition Status Descr
Business Rule Event Definition Status Dt
Business Rule Event Descr
Business Rule Event Nm
Business Rule Event Type Cd
Business Rule Event Type Code Sk
Business Rule Event Type Descr
Current Ind
DWM Load Info Sk
Effective From Dt
Effective To Dt
Source Cd
Source Code Descr
Source Code Sk
Tenant Sk
Valid From Ts
Valid To Ts

Primary Key
Business Rule Event Dimension PK

Dependencies

Reverse Dependencies

Attribute Details

AWM Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row in the atomic data warehouse.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Business Rule Event Definition Access Cd

Description	An arbitrary acronym or abbreviation that is used in place of the full name for the Business Rule Event Access name. It will provide a way to describe the categories of users or people who can look at or use this Business Rule Event Definition. Examples are: all, administrator, use only.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Business Rule Event Definition Access Code Sk

Description	An arbitrary acronym or abbreviation that is used in place of the full name for the Business Rule Event Access name. It will provide a way to describe the categories of users or people who can look at or use this Business Rule Event Definition. Examples are: all, administrator, use only.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Business Rule Event Definition Access Descr

Description	The description of the Business Rule Event Access name. It will provide a way to describe the categories of users or people who can look at or use this Business Rule Event Definition. Examples are: all, administrator, use only.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Business Rule Event Definition Author Job Title Nm

Description	A brief description or name of the job position held by the event definition author. Examples: Manager of Quality Services, Quality Analyst.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Business Rule Event Definition Author Login Nm

Description	An acronym or abbreviation, combining both numbers and letters, that will name one and only event definition author.
Data Type	Standards - Data Domains.ddm/Data Domains/Name Medium [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Business Rule Event Definition Author Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Business Rule Event Definition Author Tenant Bk

Description	Concatenated values of a set of business attributes that uniquely identify the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Business Rule Event Definition Author Tenant Nm

Description	Tenant Name registered with the managing association for the business event author.
Data Type	Standards - Data Domains.ddm/Data Domains/Name Compound [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Business Rule Event Definition Author Tenant Num

Description	Number/identifier forwarded from or assigned to the Primary Tenant of the event definition author.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Business Rule Event Definition Author Tenant Sk

Description	Identification of the of the event definition author's primary tenant.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Business Rule Event Definition Author Type Cd

Description	User type code that indicates whether the event definition author is an Internal User or an external user.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Business Rule Event Definition Author Type Code Sk

Description	Surrogate key for the user type code that indicates whether the event definition author is an Internal User or an external user.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Business Rule Event Definition Author Type Descr

Description	Description for the user type code that indicates whether the event definition author is an Internal User or an external user.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Business Rule Event Definition Bk

Description	Concatenated values of a set of business attributes that uniquely identify the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Business Rule Event Definition Detail Message Descr

Description	Business Rule Event Trigger descr is a technical storage location for the parameters that define the business rules used in the rules engine.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Business Rule Event Definition Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	true

Business Rule Event Definition Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Business Rule Event Definition Status Cd

Description	An arbitrary acronym or abbreviation that is used in place of the full name for the Business Rule Event Definition Status Code. The Status Code describes the condition of current position of the Business Rule Event Definition. Examples are: active or retired.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Business Rule Event Definition Status Code Sk

Description	An arbitrary acronym or abbreviation that is used in place of the full name for the Business Rule Event Definition Status Code. The Status Code describes the condition of current position of the Business Rule Event Definition. Examples are: active or retired.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Business Rule Event Definition Status Descr

Description	An arbitrary acronym or abbreviation that is used in place of the full name for the Business Rule Event Definition Status Code. The Status Code describes the condition of current position of the Business Rule Event Definition. Examples are: active or retired.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Business Rule Event Definition Status Dt

Description	A valid calendar date in month, day, year format that establishes the first day a Business Rule Event Definition Status Code became effective.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Business Rule Event Descr

Description	Words or phrases that augment the Business Rule Event Definition Name to provide more detail regarding the characteristics and or functionality of the Business Rule Event Definition.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Business Rule Event Nm

Description	A word or words used to distinguish one Business Rule Event Definition from another.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Business Rule Event Type Cd

Description	An arbitrary acronym or abbreviation that is used in place of the full name for the Business Rule Event Type name.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Business Rule Event Type Code Sk

Description	An arbitrary acronym or abbreviation that is used in place of the full name for the Business Rule Event Type name.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Business Rule Event Type Descr

Description	An arbitrary acronym or abbreviation that is used in place of the full name for the Business Rule Event Type name.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Current Ind

Description	Set to 'Y' if this is the most recent row of a group having the same Surrogate Key.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

DWM Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Effective From Dt

Description	Establishes a period where a set of attributes are true according to the business.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Effective To Dt

Description	Ends a period of effectivity.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Source Cd

Description	The code that corresponds to the Source Code Sk.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Source Code Descr

Description	The description that corresponds to the Source Type Cd.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Source Code Sk

Description	The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Tenant Sk

Description	The surrogate key of the entry identifying the legal owner of the data.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Valid From Ts

Description	Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Valid To Ts

Description	Ends a period of validity.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Primary Key Details

Business Rule Event Dimension PK

Key Attribute

Business Rule Event Definition Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model