Dimensional Warehouse Model Data Model

Entity

Entity Trial Resource Dimension

Description

An item that is necessary to support a research study.

For example:
Funding
Material
Labor

Attributes
Active Ind
AWM Load Info Sk
Current Ind
DWM Load Info Sk
Effective From Dt
Effective To Dt
Funding Category Cd
Funding Category Code Descr
Funding Category Code Sk
Funding Mechanism Cd
Funding Mechanism Code Descr
Funding Mechanism Code Sk
NCI Program Cd
NCI Program Code Descr
NCI Program Code Sk
NIH Institute Cd
NIH Institute Code Descr
NIH Institute Code Sk
Serial Number Txt
Source Cd
Source Code Descr
Source Code Sk
Tenant Sk
Trial Resource Bk
Trial Resource Dk
Trial Resource Sk
Type Cd
Type Code Descr
Type Code Sk
Valid From Ts
Valid To Ts

Primary Key
Trial Resource Dimension PK

Dependencies

Reverse Dependencies

Attribute Details

Active Ind

Description	Specifies whether the resource is active.
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

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

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

Funding Category Cd

Description	Specifies the type of funding provided for a study. This is as defined for the NCI Summary 4 Funding requirements. For example: National Externally Peer-Reviewed Institutional Industrial
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

Funding Category Code Descr

Description	Specifies the type of funding provided for a study. This is as defined for the NCI Summary 4 Funding requirements. For example: National Externally Peer-Reviewed Institutional Industrial
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

Funding Category Code Sk

Description	Specifies the type of funding provided for a study. This is as defined for the NCI Summary 4 Funding requirements. For example: National Externally Peer-Reviewed Institutional Industrial
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

Funding Mechanism Cd

Description	A coded value specifying the unique identifier for areas of extramural research activity applied to various funding mechanisms. For example: R01 (Research Project) U10 (Cooperative Clinical Research Cooperative Agreements)
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

Funding Mechanism Code Descr

Description	A coded value specifying the unique identifier for areas of extramural research activity applied to various funding mechanisms. For example: R01 (Research Project) U10 (Cooperative Clinical Research Cooperative Agreements)
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

Funding Mechanism Code Sk

Description	A coded value specifying the unique identifier for areas of extramural research activity applied to various funding mechanisms. For example: R01 (Research Project) U10 (Cooperative Clinical Research Cooperative Agreements)
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

NCI Program Cd

Description	Specifies the organizational units within the National Cancer Institute (NCI) (divisions, programs and offices) that provide funding. For example: CTEP (Cancer Therapy Evaluation Program) DTP (Developmental Therapeutics Program) CDP (Cancer Diagnosis Program)
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

NCI Program Code Descr

Description	Specifies the organizational units within the National Cancer Institute (NCI) (divisions, programs and offices) that provide funding. For example: CTEP (Cancer Therapy Evaluation Program) DTP (Developmental Therapeutics Program) CDP (Cancer Diagnosis Program)
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

NCI Program Code Sk

Description	Specifies the organizational units within the National Cancer Institute (NCI) (divisions, programs and offices) that provide funding. For example: CTEP (Cancer Therapy Evaluation Program) DTP (Developmental Therapeutics Program) CDP (Cancer Diagnosis Program)
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

NIH Institute Cd

Description	A two letter coded value specifying the first major-level subdivision of the organization that supports a grant, contract, or inter-agency agreement. The support may be financial or administrative. For example: CP2 Division of Cancer Epidemiology and Genetics (NCI) LM National Library of Medicine (NLM)
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

NIH Institute Code Descr

Description	A two letter coded value specifying the first major-level subdivision of the organization that supports a grant, contract, or inter-agency agreement. The support may be financial or administrative. For example: CP2 Division of Cancer Epidemiology and Genetics (NCI) LM National Library of Medicine (NLM)
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

NIH Institute Code Sk

Description	A two letter coded value specifying the first major-level subdivision of the organization that supports a grant, contract, or inter-agency agreement. The support may be financial or administrative. For example: CP2 Division of Cancer Epidemiology and Genetics (NCI) LM National Library of Medicine (NLM)
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

Serial Number Txt

Description	A character string that represents the six-digit number generally assigned sequentially to a funding mechanism within an institute, center, or division.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Small [VARCHAR(50)]
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

Trial Resource 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

Trial Resource 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

Trial Resource 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

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	true
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	true
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	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

Trial Resource Dimension PK

Key Attribute

Trial Resource Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model