Dimensional Warehouse Model Data Model

Entity

Entity Consent Dimension

Description

A record that tracks approval by a patient or authorized representative to participate in clinical studies, procedures, examinations, and other activities. Also includes approvals for the release of personal information.

Attributes
AWM Load Info Sk
Blood Product Refusal Ind
Comfort Measures Only Ind
Competency Ind
Competency Txt
Consent Bk
Consent Bypass Reason Cd
Consent Bypass Reason Code Sk
Consent Bypass Reason Descr
Consent Disclosure Level Cd
Consent Disclosure Level Code Sk
Consent Disclosure Level Descr
Consent Dk
Consent Non-Disclosure Reason Cd
Consent Non-Disclosure Reason Code Sk
Consent Non-Disclosure Reason Descr
Consent Purpose Cd
Consent Purpose Code Sk
Consent Purpose Descr
Consent Sk
Consent Type Cd
Consent Type Code Sk
Consent Type Descr
Current Ind
DWM Load Info Sk
Effective From Dt
Effective To Dt
Form Cd
Form Code Sk
Form Descr
Form Identification Num
Informational Material Provided Ind
Life Support Ind
Mode Cd
Mode Code Sk
Mode Descr
Non-Subject Consenter Reason Cd
Non-Subject Consenter Reason Code Sk
Non-Subject Consenter Reason Descr
Source Cd
Source Code Descr
Source Code Sk
Status Cd
Status Code Sk
Status Descr
Study Approval Authority Nm
Tenant Sk
Translated Language Cd
Translated Language Code Sk
Translated Language Descr
Translator Ind
Tube Feeding Ind
Valid From Ts
Valid To Ts

Primary Key
Consent 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

Blood Product Refusal Ind

Description	Indicates that the patient should or should not receive blood products.
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

Comfort Measures Only Ind

Description	Indicates if the individual's care is to be limited to comfort measures only.
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

Competency Ind

Description	Identifies whether the subject was deemed competent to provide consent.
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

Competency Txt

Description	Contains a description of circumstances surrounding subject competency.
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

Consent 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

Consent Bypass Reason Cd

Description	Identifies why the subject's consent was not sought. For example: Emergency Professional Judgment
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

Consent Bypass Reason Code Sk

Description	Identifies why the subject's consent was not sought. For example: Emergency Professional Judgment
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

Consent Bypass Reason Descr

Description	Identifies why the subject's consent was not sought. For example: Emergency Professional Judgment
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

Consent Disclosure Level Cd

Description	Identifies how much information was disclosed to the subject as part of the informed consent process. For example: Full Disclosure Partial Disclosure No Disclosure
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

Consent Disclosure Level Code Sk

Description	Identifies how much information was disclosed to the subject as part of the informed consent process. For example: Full Disclosure Partial Disclosure No Disclosure
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

Consent Disclosure Level Descr

Description	Identifies how much information was disclosed to the subject as part of the informed consent process. For example: Full Disclosure Partial Disclosure No Disclosure
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

Consent 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

Consent Non-Disclosure Reason Cd

Description	Identifies why the subject did not receive full disclosure. For example: Emergency Rx Private Patient Request
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

Consent Non-Disclosure Reason Code Sk

Description	Identifies why the subject did not receive full disclosure. For example: Emergency Rx Private Patient Request
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

Consent Non-Disclosure Reason Descr

Description	Identifies why the subject did not receive full disclosure. For example: Emergency Rx Private Patient Request
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

Consent Purpose Cd

Description	The purpose of the consent. For example: Copy of Record Legal Review Insurance Review
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

Consent Purpose Code Sk

Description	The purpose of the consent. For example: Copy of Record Legal Review Insurance Review
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

Consent Purpose Descr

Description	The purpose of the consent. For example: Copy of Record Legal Review Insurance Review
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

Consent 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

Consent Type Cd

Description	Described the type of consent provided. For example: Expressed Implied Third Party
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

Consent Type Code Sk

Description	Described the type of consent provided. For example: Expressed Implied Third Party
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

Consent Type Descr

Description	Described the type of consent provided. For example: Expressed Implied Third Party
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

Form Cd

Description	Indicates the form identifier that was used to record the consent.
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

Form Code Sk

Description	Indicates the form identifier that was used to record the consent.
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

Form Descr

Description	Indicates the form identifier that was used to record the consent.
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

Form Identification Num

Description	Indicates the unique identifier of the instance of the consent form.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Informational Material Provided Ind

Description	Identifies whether additional educational or reference material was provided to the subject as part of the consent process.
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

Life Support Ind

Description	Indicates that life support should or should not be used.
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

Mode Cd

Description	Describes the form in which the consent was provided. For example: Verbal Written Implied
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

Mode Code Sk

Description	Describes the form in which the consent was provided. For example: Verbal Written Implied
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

Mode Descr

Description	Describes the form in which the consent was provided. For example: Verbal Written Implied
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

Non-Subject Consenter Reason Cd

Description	Identifies why the consent was granted by a person other than the subject of the consent. For example: Subject is a minor Subject is not competent to consent Legally mandated
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

Non-Subject Consenter Reason Code Sk

Description	Identifies why the consent was granted by a person other than the subject of the consent. For example: Subject is a minor Subject is not competent to consent Legally mandated
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

Non-Subject Consenter Reason Descr

Description	Identifies why the consent was granted by a person other than the subject of the consent. For example: Subject is a minor Subject is not competent to consent Legally mandated
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 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

Status Cd

Description	Indicates whether the consent has been sought and granted. For example: Active – Consent has been granted Limited – Consent has been granted with limitations Refused – Consent has been refused Pending – Consent has not yet been sought Rescinded – Consent was initially granted, but was subsequently revoked or ended. Bypassed – Consent not sought
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

Status Code Sk

Description	Indicates whether the consent has been sought and granted. For example: Active – Consent has been granted Limited – Consent has been granted with limitations Refused – Consent has been refused Pending – Consent has not yet been sought Rescinded – Consent was initially granted, but was subsequently revoked or ended. Bypassed – Consent not sought
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

Status Descr

Description	Indicates whether the consent has been sought and granted. For example: Active – Consent has been granted Limited – Consent has been granted with limitations Refused – Consent has been refused Pending – Consent has not yet been sought Rescinded – Consent was initially granted, but was subsequently revoked or ended. Bypassed – Consent not sought
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

Study Approval Authority Nm

Description	The approval authority that approved the consent for use in the study.
Data Type	Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	false
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

Translated Language Cd

Description	Identifies the language the consent material must be translated to.
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

Translated Language Code Sk

Description	Identifies the language the consent material must be translated to.
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

Translated Language Descr

Description	Identifies the language the consent material must be translated to.
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

Translator Ind

Description	Identifies whether translation was (or will be) required to obtain informed consent from the subject.
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

Tube Feeding Ind

Description	Indicates that a feeding tube should or should not be used.
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

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

Consent Dimension PK

Key Attribute

Consent Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model