Dimensional Warehouse Model Data Model

Entity

Entity Communication Dimension

Description

An entry that records the receiving or sending of a communication between two parties, one of which is typically the modeled organization. A communication may be in any medium such as a telephone call, a letter, a fax, an email, a meeting, and so on. It may have occurred or be planned to occur. In each case, a discrete occurrence of communication is identifiable. Correspondence which takes place over a period of time, it is not a single communication but is modeled as a series of individual related communications.

Attributes
Actual End Dt
Actual Labor Hours
Actual Start Dt
Actual Time Spent
AWM Load Info Sk
Communication Delivery Format Cd
Communication Delivery Format Code Descr
Communication Delivery Format Code Sk
Communication Dimension Bk
Communication Dimension Dk
Communication Dimension Sk
Communication Direction Cd
Communication Direction Code Descr
Communication Direction Code Sk
Communication Incomplete Flag
Communication Incomplete Ind
Communication Response Dt
Communication Response Type Cd
Communication Response Type Code Descr
Communication Response Type Code Sk
Communication Status Cd
Communication Status Code Descr
Communication Status Code Sk
Communication Status Reason Cd
Communication Status Reason Code Descr
Communication Status Reason Code Sk
Communication Storage Location
Communication Thread Status Cd
Communication Thread Status Code Descr
Communication Thread Status Code Sk
Communication Type Cd
Communication Type Code Descr
Communication Type Code Sk
Current Ind
Delay Reason Cd
Delay Reason Code Descr
Delay Reason Code Sk
DWM Load Info Sk
Effective From Dt
Effective To Dt
Inbound Outbound Ind
Initiator Type Cd
Initiator Type Code Descr
Initiator Type Code Sk
Most Recent Communication Dt
Name
Party Role Dk
Planned Duration
Planned End Dt
Planned Manpower
Planned Start Dt
Recipient Type Cd
Recipient Type Code Descr
Recipient Type Code Sk
Requested Dt
Source Cd
Source Code Descr
Source Code Sk
Tenant Sk
Thread Start Dt
Thread Type Cd
Thread Type Code Descr
Thread Type Code Sk
Type Cd
Type Code Descr
Type Code Sk
Valid From Ts
Valid To Ts

Relationship
Communication Dimension_Party Role Dimension_FK

Primary Key
Communication Dimension PK

Dependencies

Reverse Dependencies

Attribute Details

Actual End Dt

Description	Actual date upon which the activity was completed.
Data Type	Standards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Actual Labor Hours

Description	A count of hours taken to perform the activity.
Data Type	Standards - Data Domains.ddm/Data Domains/Small Counter [SHORT]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Actual Start Dt

Description	Actual date upon which the activity commenced.
Data Type	Standards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Actual Time Spent

Description	The actual time spent performing the activity. This describes elapsed time rather than effort so a 4 hour task may have been completed over a period of 3 days.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Large [DECIMAL(15,6)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

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

Communication Delivery Format Cd

Description	A Communication Delivery Format classifies communications according to the specific format of the communication. For example: Face-to-face Fax Internet Mail Phone Telephone direct
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

Communication Delivery Format Code Descr

Description	A Communication Delivery Format classifies communications according to the specific format of the communication. For example: Face-to-face Fax Internet Mail Phone Telephone direct
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

Communication Delivery Format Code Sk

Description	A Communication Delivery Format classifies communications according to the specific format of the communication. For example: Face-to-face Fax Internet Mail Phone Telephone direct
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

Communication Dimension 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

Communication Dimension 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

Communication Dimension 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

Communication Direction Cd

Description	The direction of a communication relative to the modeled organization. For example: External Inbound Internal Outbound
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

Communication Direction Code Descr

Description	The direction of a communication relative to the modeled organization. For example: External Inbound Internal Outbound
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

Communication Direction Code Sk

Description	The direction of a communication relative to the modeled organization. For example: External Inbound Internal Outbound
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

Communication Incomplete Flag

Description	Indicates that a communication may not have been complete.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Communication Incomplete Ind

Description	Indicates that a communication may not have been complete.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Communication Response Dt

Description	The date upon which the response to the communication was received.
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

Communication Response Type Cd

Description	The communication response type distinguishes between communications according to the nature of the response received.
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

Communication Response Type Code Descr

Description	The communication response type distinguishes between communications according to the nature of the response received.
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

Communication Response Type Code Sk

Description	The communication response type distinguishes between communications according to the nature of the response received.
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

Communication Status Cd

Description	The communication status distinguishes between communications according to their current state. For example: Awaiting further information Closed Open
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

Communication Status Code Descr

Description	The communication status distinguishes between communications according to their current state. For example: Awaiting further information Closed Open
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

Communication Status Code Sk

Description	The communication status distinguishes between communications according to their current state. For example: Awaiting further information Closed Open
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

Communication Status Reason Cd

Description	The reasons why a communication is currently in a given communication status.
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

Communication Status Reason Code Descr

Description	The reasons why a communication is currently in a given communication status.
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

Communication Status Reason Code Sk

Description	The reasons why a communication is currently in a given communication status.
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

Communication Storage Location

Description	The place where the full details and content of the communication can be found, for example, the physical or electronic file in which a letter is stored.
Data Type	Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Communication Thread Status Cd

Description	Classifies the communication threads according to their status.
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

Communication Thread Status Code Descr

Description	Classifies the communication threads according to their status.
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

Communication Thread Status Code Sk

Description	Classifies the communication threads according to their status.
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

Communication Type Cd

Description	Indicates which type of communication occurs or is planned to occur. For example: Campaign mailing Claim coverage notification Complaint Demographic data Eligibility response Quotation request Regular statement Returned mail Sale
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

Communication Type Code Descr

Description	Indicates which type of communication occurs or is planned to occur. For example: Campaign mailing Claim coverage notification Complaint Demographic data Eligibility response Quotation request Regular statement Returned mail Sale
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

Communication Type Code Sk

Description	Indicates which type of communication occurs or is planned to occur. For example: Campaign mailing Claim coverage notification Complaint Demographic data Eligibility response Quotation request Regular statement Returned mail Sale
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

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

Delay Reason Cd

Description	Indicates the cause of any discrepancy between planned and actual end dates.
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

Delay Reason Code Descr

Description	Indicates the cause of any discrepancy between planned and actual end dates.
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

Delay Reason Code Sk

Description	Indicates the cause of any discrepancy between planned and actual end dates.
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

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

Inbound Outbound Ind

Description	Indicates whether the thread was initiated by an external involved party, for example a person (inbound thread), or by the health care institution itself (outbound thread). Derived from the communication direction of the communication that initiated the thread. For example: (I) Inbound Thread (O) Outbound Thread
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Initiator Type Cd

Description	The type of the party who is the initiator of the communication.
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

Initiator Type Code Descr

Description	The type of the party who is the initiator of the communication.
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

Initiator Type Code Sk

Description	The type of the party who is the initiator of the communication.
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

Most Recent Communication Dt

Description	Date upon which most recent communication is received or issued on the thread.
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

Name

Description	A text reference that aids the identification and understanding of this communication content. For example, Complaint Direct debit authorization. Policy document
Data Type	Standards - Data Domains.ddm/Data Domains/Name Long [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Party Role 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Planned Duration

Description	The time planned for the performing of the activity. This describes elapsed time rather than effort so a 4 hour task may be planned for completion over a period of 3 days.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Large [DECIMAL(15,6)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Planned End Dt

Description	Date upon which the activity is planned to finish.
Data Type	Standards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Planned Manpower

Description	The anticipated manpower required for the activity typically expressed in labor hours.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Large [DECIMAL(15,6)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Planned Start Dt

Description	Date upon which the activity is planned to commence.
Data Type	Standards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Recipient Type Cd

Description	The type of the party who is the recipient of the communication.
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

Recipient Type Code Descr

Description	The type of the party who is the recipient of the communication.
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

Recipient Type Code Sk

Description	The type of the party who is the recipient of the communication.
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

Requested Dt

Description	The date upon which the communication is requested.
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	false
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	false
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

Thread Start Dt

Description	Date upon which the communication thread is initiated. This is a field derived from the date of the first communication in the communication thread
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

Thread Type Cd

Description	Classifies a communication thread by its thread type.
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

Thread Type Code Descr

Description	Classifies a communication thread by its thread type.
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

Thread Type Code Sk

Description	Classifies a communication thread by its thread type.
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

Type Cd

Description	The code that corresponds to the Type Code Sk.
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

Type Code Descr

Description	The description that corresponds to the Type Cd.
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

Type Code Sk

Description	The code identifying the actual type of the entity as per the type hierarchy defined in the analysis data 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

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

Relationship Details

Communication Dimension_Party Role Dimension_FK

Is Identifying Relationship	false
Child Table	Communication Dimension
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Party Role Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Communication Dimension PK

Key Attribute

Communication Dimension Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model