Dimensional Warehouse Model Data Model

Entity

Entity Party Role Dimension

Description

A role that describes a particular context of interaction for a party. This role can specify additional information specific to the context, such as a mailing address for a subscriber.

Attributes
Address Line 1 Descr
Address Line 2 Descr
Address Line 3 Descr
Address Line 4 Descr
Address Type Cd
Address Type Code Sk
Address Type Descr
Address Use Cd
Address Use Code Sk
Address Use Descr
AWM Load Info Sk
City Nm
Country Nm
County Nm
Current Ind
Degree Nm
Display Nm
DWM Load Info Sk
Effective From Dt
Effective To Dt
Email Address Resource Locator Nm
Email Type Cd
Email Type Code Sk
Email Type Descr
Email Use Cd
Email Use Code Sk
Email Use Descr
End Dt
Equipment Type Cd
Equipment Type Code Sk
Equipment Type Descr
First Nm
Full Nm
Last Nm
Middle Nm
Name Type Cd
Name Type Code Sk
Name Type Descr
Number Of Sessions Attended
Party Role Bk
Party Role Dk
Party Role Sk
Phone Area Cd
Phone Country Cd
Phone Exchange Cd
Phone Extension Num
Phone Line Num
Phone Num
Phone Speed Dial Num
Phone Type Cd
Phone Type Code Sk
Phone Type Descr
Phone Use Cd
Phone Use Code Sk
Phone Use Descr
Postal Cd
Prefix Nm
Program Nominating Party Type Cd
Program Nominating Party Type Code Descr
Program Nominating Party Type Code Sk
Program Participant Consent Level Cd
Program Participant Consent Level Code Descr
Program Participant Consent Level Code Sk
Program Participant Status Cd
Program Participant Status Code Descr
Program Participant Status Code Sk
Reason For Ending Cd
Reason For Ending Code Descr
Reason For Ending Code Sk
Social Security Num
Source Cd
Source Code Descr
Source Code Sk
Start Dt
State Province Cd
Suffix Nm
Tenant Sk
Valid From Ts
Valid To Ts

Primary Key
Party Role Dimension PK

Dependencies

Reverse Dependencies

Attribute Details

Address Line 1 Descr

Description	First line of the address. Use for Primary Street and Building Number
Data Type	Standards - Data Domains.ddm/Data Domains/Address Line [VARCHAR(100)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Address Line 2 Descr

Description	Second line of the address
Data Type	Standards - Data Domains.ddm/Data Domains/Address Line [VARCHAR(100)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Address Line 3 Descr

Description	Third line of the address
Data Type	Standards - Data Domains.ddm/Data Domains/Address Line [VARCHAR(100)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Address Line 4 Descr

Description	Fourth line of the address
Data Type	Standards - Data Domains.ddm/Data Domains/Address Line [VARCHAR(100)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Address Type Cd

Description	Identifies the type of the relationship as defined in the business data model.
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

Address Type Code Sk

Description	Identifies the type of the relationship as defined in the business 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

Address Type Descr

Description	Identifies the type of the relationship as defined in the business data model.
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

Address Use Cd

Description	Indicates the way an address is used by a party. For example: Default Mailing Billing Delivery Statement Alert Contact After Hours
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

Address Use Code Sk

Description	Indicates the way an address is used by a party. For example: Default Mailing Billing Delivery Statement Alert Contact After Hours
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

Address Use Descr

Description	Indicates the way an address is used by a party. For example: Default Mailing Billing Delivery Statement Alert Contact After Hours
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

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

City Nm

Description	Name for the city of the address.
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

Country Nm

Description	Name of the country for the address.
Data Type	Standards - Data Domains.ddm/Data Domains/Area Name [VARCHAR(50)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

County Nm

Description	Name of the county for the address.
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

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

Degree Nm

Description	The party name component indicating degrees and certifications a Party uses in their formal name.
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

Display Nm

Description	The complete name (first, middle, last) for a person.
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

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

Email Address Resource Locator Nm

Description	Email address string, representing the contact email address
Data Type	Standards - Data Domains.ddm/Data Domains/URL [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Email Type Cd

Description	Identifies the type of the relationship as defined in the business data model.
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

Email Type Code Sk

Description	Identifies the type of the relationship as defined in the business 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

Email Type Descr

Description	Identifies the type of the relationship as defined in the business data model.
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

Email Use Cd

Description	Indicates the way an email address is used by a party. For example: Default Mailing Billing Delivery Statement Alert Contact After Hours
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

Email Use Code Sk

Description	Indicates the way an email address is used by a party. For example: Default Mailing Billing Delivery Statement Alert Contact After Hours
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

Email Use Descr

Description	Indicates the way an email address is used by a party. For example: Default Mailing Billing Delivery Statement Alert Contact After Hours
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

End Dt

Description	The date the practitioner ended or intends to end practicing at the given institution (e.g., at hospital, at physician organization, at managed care network).
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

Equipment Type Cd

Description	Indicates the kind of telephone represented by the number.
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

Equipment Type Code Sk

Description	Indicates the kind of telephone represented by the number.
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

Equipment Type Descr

Description	Indicates the kind of telephone represented by the number.
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

First Nm

Description	First name of a person.
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

Full Nm

Description	The complete name (first, middle, last) for a person.
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

Last Nm

Description	Last name of a person.
Data Type	Standards - Data Domains.ddm/Data Domains/Last Name [VARCHAR(75)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Middle Nm

Description	The middle name of a person.
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

Name Type Cd

Description	Identifies the type of the relationship as defined in the business data model.
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

Name Type Code Sk

Description	Identifies the type of the relationship as defined in the business 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

Name Type Descr

Description	Identifies the type of the relationship as defined in the business data model.
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

Number Of Sessions Attended

Description	The number of sessions or modules the program participant has attended or completed.
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

Party Role 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

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

Party Role 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

Phone Area Cd

Description	Indicates the area code for the telephone, cell, or pager number.
Data Type	Standards - Data Domains.ddm/Data Domains/Phone Area Code [VARCHAR(8)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Phone Country Cd

Description	Indicates the country code for the telephone, cell, or pager number.
Data Type	Standards - Data Domains.ddm/Data Domains/Phone Country Code [CHAR(3)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Phone Exchange Cd

Description	Indicates the telephone exchange code for the telephone, cell, or pager number. For US telephone numbers the exchange code or Central Office Code refers to the first 3 digits of the local number (NNN-xxxx).
Data Type	Standards - Data Domains.ddm/Data Domains/Phone Exchange Code [VARCHAR(3)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Phone Extension Num

Description	A suffix for a telephone number to reach a specific phone in a main telephone network
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

Phone Line Num

Description	Represents the telephone line number for the telephone, cell, or pager number. For US telephone numbers the line number refers to the last 4 digits of the local number (xxx-NNNN).
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

Phone Num

Description	Represents the actual number (without formatting) for the telephone, cell, or pager number.
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

Phone Speed Dial Num

Description	The characters established within a company's internal telephone system used in place of the (external) telephone number to facilitate calling because its length is shorter than that of the telephone number. Note that digits, as well as special characters (for example, *, #) may be used.
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

Phone Type Cd

Description	Identifies the type of the relationship as defined in the business data model.
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

Phone Type Code Sk

Description	Identifies the type of the relationship as defined in the business 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

Phone Type Descr

Description	Identifies the type of the relationship as defined in the business data model.
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

Phone Use Cd

Description	Indicates the way a telephone number is used by a party. For example: Default Alert Contact After Hours
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

Phone Use Code Sk

Description	Indicates the way a telephone number is used by a party. For example: Default Alert Contact After Hours
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

Phone Use Descr

Description	Indicates the way a telephone number is used by a party. For example: Default Alert Contact After Hours
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

Postal Cd

Description	Zip code and International Postal Code for the address.
Data Type	Standards - Data Domains.ddm/Data Domains/Postal Code [VARCHAR(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Prefix Nm

Description	A prefix name refers to titles that precede a name. For Example: Mr. Mrs. Ms. Miss Dr.
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

Program Nominating Party Type Cd

Description	Indicates the type of individual or organization that nominated the individual for participation in the health management program. For example: Physician Employer Parent Insurer
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

Program Nominating Party Type Code Descr

Description	Indicates the type of individual or organization that nominated the individual for participation in the health management program. For example: Physician Employer Parent Insurer
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

Program Nominating Party Type Code Sk

Description	Indicates the type of individual or organization that nominated the individual for participation in the health management program. For example: Physician Employer Parent Insurer
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

Program Participant Consent Level Cd

Description	Indicates the level of consent individuals have given to their participation in a health management 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

Program Participant Consent Level Code Descr

Description	Indicates the level of consent individuals have given to their participation in a health management 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

Program Participant Consent Level Code Sk

Description	Indicates the level of consent individuals have given to their participation in a health management 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

Program Participant Status Cd

Description	Indicates the current participation state of participants in a health 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

Program Participant Status Code Descr

Description	Indicates the current participation state of participants in a health 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

Program Participant Status Code Sk

Description	Indicates the current participation state of participants in a health 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

Reason For Ending Cd

Description	Indicates why an individual ceased participation in a health management program For example: Change of employment Injury Loss of interest
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

Reason For Ending Code Descr

Description	Indicates why an individual ceased participation in a health management program For example: Change of employment Injury Loss of interest
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

Reason For Ending Code Sk

Description	Indicates why an individual ceased participation in a health management program For example: Change of employment Injury Loss of interest
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

Social Security Num

Description	Primary alpha-numeric identifier for a role player's registration
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

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

Start Dt

Description	The date the practitioner began practicing at the present institution (e.g., at hospital, at physician organization, at managed care network).
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

State Province Cd

Description	Indicates the state or province for the address using a recognized set of codes or abbreviations.
Data Type	Standards - Data Domains.ddm/Data Domains/State Code [CHAR(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Suffix Nm

Description	A name suffix follows a person's full name and provides additional information about the person. For Example: Jr for Junior MD for Medical Doctor
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

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

Party Role Dimension PK

Key Attribute

Party Role Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model