Dimensional Warehouse Model Data Model

Entity

Entity Survey Respondent Dimension

Description

The details of a person who has responded to a survey but whose identity is unknown. Many sources of statistics provide analysis derived from population surveys without disclosing the identity of those who responded and provided the data for the survey.

Attributes
AWM Load Info Sk
Cholesterol Tested
Current Ind
DWM Load Info Sk
Effective From Dt
Effective To Dt
Frequency Of Days Now Smoking Cd
Frequency Of Days Now Smoking Code Descr
Frequency Of Days Now Smoking Code Sk
Respondent Adult BMI
Respondent Child BMI Cd
Respondent Child BMI Code Descr
Respondent Child BMI Code Sk
Respondent General Health Status Cd
Respondent General Health Status Code Descr
Respondent General Health Status Code Sk
Respondent Geographic Location
Respondent Height Unit Of Measure Cd
Respondent Height Unit Of Measure Code Descr
Respondent Height Unit Of Measure Code Sk
Respondent is Smoker
Respondent Perceived Mental Health Status Cd
Respondent Perceived Mental Health Status Code Descr
Respondent Perceived Mental Health Status Code Sk
Respondent Perceived Physical Health Status Cd
Respondent Perceived Physical Health Status Code Descr
Respondent Perceived Physical Health Status Code Sk
Respondent Reported Height
Respondent Reported Weight
Respondent Serial Num
Respondent Survey Weight
Respondent Weight Unit Of Measure Cd
Respondent Weight Unit Of Measure Code Descr
Respondent Weight Unit Of Measure Code Sk
Smokeless Tobacco Use
Source Cd
Source Code Descr
Source Code Sk
Stopped Smoking Recently
Survey Period
Survey Reference Num
Survey Respondent Bk
Survey Respondent Dk
Survey Respondent Sk
Survey Source
Tenant Sk
Time Since Last Checkup
Time Since Last Cholesterol Test
Time Since Last Smoked
Type Cd
Type Code Descr
Type Code Sk
Valid From Ts
Valid To Ts

Primary Key
Survey Respondent 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

Cholesterol Tested

Description	An indication that the respondent has ever had their cholesterol level tested.
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

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

Frequency Of Days Now Smoking Cd

Description	The regularity of the respondent's current smoking behavior in terms of frequency of days. For example: Chain Smoker Every Day Occasional
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

Frequency Of Days Now Smoking Code Descr

Description	The regularity of the respondent's current smoking behavior in terms of frequency of days. For example: Chain Smoker Every Day Occasional
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

Frequency Of Days Now Smoking Code Sk

Description	The regularity of the respondent's current smoking behavior in terms of frequency of days. For example: Chain Smoker Every Day Occasional
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

Respondent Adult BMI

Description	The body mass index of a respondent where the response relate to an person over 17 years of age.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Respondent Child BMI Cd

Description	The body mass index of a respondent where the response relate to an person below 18 years of age.
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

Respondent Child BMI Code Descr

Description	The body mass index of a respondent where the response relate to an person below 18 years of age.
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

Respondent Child BMI Code Sk

Description	The body mass index of a respondent where the response relate to an person below 18 years of age.
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

Respondent General Health Status Cd

Description	The state of a respondent's overall health, physical and mental, as understood by the respondent. For example: Excellent Good Fair Poor
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

Respondent General Health Status Code Descr

Description	The state of a respondent's overall health, physical and mental, as understood by the respondent. For example: Excellent Good Fair Poor
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

Respondent General Health Status Code Sk

Description	The state of a respondent's overall health, physical and mental, as understood by the respondent. For example: Excellent Good Fair Poor
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

Respondent Geographic Location

Description	A location associated with the respondent. Geographic locations can be based on state, county, city or census blocks, electoral divisions, regions or even national.
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

Respondent Height Unit Of Measure Cd

Description	The units in which the respondent's height is expressed. For example: Feet Meters
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

Respondent Height Unit Of Measure Code Descr

Description	The units in which the respondent's height is expressed. For example: Feet Meters
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

Respondent Height Unit Of Measure Code Sk

Description	The units in which the respondent's height is expressed. For example: Feet Meters
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

Respondent is Smoker

Description	An indication that the respondent smokes. This may be qualified on a minimum consumption such as the respondent has smoked at least 100 cigarettes.
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

Respondent Perceived Mental Health Status Cd

Description	The state of a respondent's mental health as understood by the respondent. For example: Excellent Good Fair Poor
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

Respondent Perceived Mental Health Status Code Descr

Description	The state of a respondent's mental health as understood by the respondent. For example: Excellent Good Fair Poor
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

Respondent Perceived Mental Health Status Code Sk

Description	The state of a respondent's mental health as understood by the respondent. For example: Excellent Good Fair Poor
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

Respondent Perceived Physical Health Status Cd

Description	The state of a respondent's physical health as understood by the respondent. For example: Excellent Good Fair Poor
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

Respondent Perceived Physical Health Status Code Descr

Description	The state of a respondent's physical health as understood by the respondent. For example: Excellent Good Fair Poor
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

Respondent Perceived Physical Health Status Code Sk

Description	The state of a respondent's physical health as understood by the respondent. For example: Excellent Good Fair Poor
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

Respondent Reported Height

Description	The person's height as declared by the respondent.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Respondent Reported Weight

Description	The person's weight as declared by the respondent.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Respondent Serial Num

Description	A non-identifying serial number used to represent a survey respondent while not enabling any individual person or household to be identified. Note that the serial number relates to this instance of a survey only and that respondent serial numbers can be recycled in subsequent versions.
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

Respondent Survey Weight

Description	A statistical weighting factor associated with this respondent in relation to this survey.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Respondent Weight Unit Of Measure Cd

Description	The units in which the respondent's weight is expressed. For example: lb Kg
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

Respondent Weight Unit Of Measure Code Descr

Description	The units in which the respondent's weight is expressed. For example: lb Kg
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

Respondent Weight Unit Of Measure Code Sk

Description	The units in which the respondent's weight is expressed. For example: lb Kg
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

Smokeless Tobacco Use

Description	An indication that the respondent uses a smokeless tobacco product.
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

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

Stopped Smoking Recently

Description	An indication that the respondent has stopped smoking within the last 12 months.
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

Survey Period

Description	The time period that the survey data related to. Some surveys are based on a point in time while others might relate to activity over an extended duration such as expenditure over 12 months.
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

Survey Reference Num

Description	A number that identifies a particular instance or version of a survey.
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

Survey Respondent 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

Survey Respondent 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

Survey Respondent 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

Survey Source

Description	The original source of the survey response data. For example: American Community Survey (ACS) Medical Expenditure Panel Survey (MEPS) Behavioral Risk Factor Surveillance System (BRFSS)
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

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

Time Since Last Checkup

Description	The length of time that had elapsed since a respondent had their most recent routine health checkup. This would typically be a visit with their primary care practitioner.
Data Type	Standards - Data Domains.ddm/Data Domains/Time [TIME]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Time Since Last Cholesterol Test

Description	The length of time that had elapsed since a respondent had their most recent cholesterol test.
Data Type	Standards - Data Domains.ddm/Data Domains/Time [TIME]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Time Since Last Smoked

Description	The length of time that has elapsed since a respondent most recently smoked.
Data Type	Standards - Data Domains.ddm/Data Domains/Time [TIME]
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	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

Survey Respondent Dimension PK

Key Attribute

Survey Respondent Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model