Dimensional Warehouse Model Data Model

Entity

Entity Plan Member Dimension

Description

A person that is covered by a health plan.

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
Birth Dt
Birthplace Nm
Citizenship Country Cd
Citizenship Country Code Sk
Citizenship Country Descr
City Nm
Contact Person Reason Cd
Contact Person Reason Code Sk
Contact Person Reason Descr
Continuous Cover Maintained Ind
Country Nm
County Nm
Current Entitlement Reason Cd
Current Entitlement Reason Code Sk
Current Entitlement Reason Descr
Current Ind
Degree Nm
Dependent Of Military Recipient Cd
Dependent Of Military Recipient Code Sk
Dependent Of Military Recipient Descr
Disability Cd
Disability Code Sk
Disability Descr
Disability Status Cd
Disability Status Code Sk
Disability Status Descr
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
Employee Alternate Identifier Num
Employee Num
Employer Contact Reason Cd
Employer Contact Reason Code Sk
Employer Contact Reason Descr
Employment End Ts
Employment Start Ts
Employment Status Cd
Employment Status Code Sk
Employment Status Descr
Encounter Participation Pct
Equipment Type Cd
Equipment Type Code Sk
Equipment Type Descr
ESRD Ind
First Nm
Fraud and Abuse Ind
Full Nm
Gender Cd
Gender Code Sk
Gender Descr
Guarantor Relationship Cd
Guarantor Relationship Code Sk
Guarantor Relationship Descr
Healthcare Insurer Contact Reason Cd
Healthcare Insurer Contact Reason Code Sk
Healthcare Insurer Contact Reason Descr
Healthcare Insurer Patient Member Num
Health Program Participation Status Cd
Health Program Participation Status Code Descr
Health Program Participation Status Code Sk
Job Class Cd
Job Class Code Sk
Job Class Descr
Job Status Cd
Job Status Code Sk
Job Status Descr
Job Title Nm
Language Cd
Language Code Sk
Language Descr
Last Nm
Level1 Txt
Level2 Txt
Level3 Txt
Level4 Txt
Living Arrangement Cd
Living Arrangement Code Sk
Living Arrangement Descr
Living Dependency Cd
Living Dependency Code Sk
Living Dependency Descr
Marital Status Cd
Marital Status Code Sk
Marital Status Descr
Medicare Health Insurance Card Num
Medicare Status Cd
Medicare Status Code Sk
Medicare Status Descr
Member Card Group Num
Member Card ID Num
Middle Nm
Military Handicapped Program Cd
Military Handicapped Program Code Sk
Military Handicapped Program Descr
Military ID Num
Military Non-Avail Cert On File Ind
Military Organization Nm
Military Rank Cd
Military Rank Code Sk
Military Rank Descr
Military Retire Dt
Military Service Cd
Military Service Code Sk
Military Service Descr
Military Station Nm
Military Status Cd
Military Status Code Sk
Military Status Descr
Multiple Coverage Status Cd
Multiple Coverage Status Code Descr
Multiple Coverage Status Code Sk
Multiple Coverage Status Reason Cd
Multiple Coverage Status Reason Code Descr
Multiple Coverage Status Reason Code Sk
Name Type Cd
Name Type Code Sk
Name Type Descr
Nationality Country Cd
Nationality Country Code Sk
Nationality Country Descr
Original Entitlement Reason Cd
Original Entitlement Reason Code Sk
Original Entitlement Reason Descr
Personal Data Access Status Cd
Personal Data Access Status Code Descr
Personal Data Access Status Code Sk
Personal Health Record Usage Type Cd
Personal Health Record Usage Type Code Descr
Personal Health Record Usage Type Code Sk
Person Dk
Person 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
Plan Member Bk
Plan Member Dk
Plan Member Sk
Postal Cd
Prefix Nm
Protection Ind
Publicity Cd
Publicity Code Sk
Publicity Descr
Religion Cd
Religion Code Sk
Religion Descr
Social Security Num
Source Cd
Source Code Descr
Source Code Sk
State Province Cd
Student Ind
Suffix Nm
Supplied Date Of Birth
Tenant Sk
Valid From Ts
Valid To Ts
VIP Cd
VIP Code Sk
VIP Descr

Relationship
Plan Member Dimension_Person Dimension_FK

Primary Key
Plan Member 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

Birth Dt

Description	Date of birth of the insured.
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

Birthplace Nm

Description	A textual description of the place an individual was born.
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

Citizenship Country Cd

Description	Indicates the insured's country of citizenship.
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

Citizenship Country Code Sk

Description	Indicates the insured's country of citizenship.
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

Citizenship Country Descr

Description	Indicates the insured's country of citizenship.
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

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

Contact Person Reason Cd

Description	A textual description of the reason(s) a person should be contacted regarding the insured.
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

Contact Person Reason Code Sk

Description	A textual description of the reason(s) a person should be contacted regarding the insured.
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

Contact Person Reason Descr

Description	A textual description of the reason(s) a person should be contacted regarding the insured.
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

Continuous Cover Maintained Ind

Description	Indicates whether the plan member maintained continuous coverage without an interruption of a specified number of days, prior to enrollment with the health plan organization. 1 Yes 0 No
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

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 Entitlement Reason Cd

Description	indicates why an individual is still in an entitlement 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

Current Entitlement Reason Code Sk

Description	indicates why an individual is still in an entitlement 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

Current Entitlement Reason Descr

Description	indicates why an individual is still in an entitlement 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

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

Dependent Of Military Recipient Cd

Description	Specifies if the individual is a military recipient dependent.
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

Dependent Of Military Recipient Code Sk

Description	Specifies if the individual is a military recipient dependent.
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

Dependent Of Military Recipient Descr

Description	Specifies if the individual is a military recipient dependent.
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

Disability Cd

Description	Indicates the nature of an individual's disability. For example: Wheelchair bound Visually impaired Deaf
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

Disability Code Sk

Description	Indicates the nature of an individual's disability. For example: Wheelchair bound Visually impaired Deaf
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

Disability Descr

Description	Indicates the nature of an individual's disability. For example: Wheelchair bound Visually impaired Deaf
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

Disability Status Cd

Description	Indicates the nature of an individual's disability. For example: Wheelchair bound Visually impaired Deaf
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

Disability Status Code Sk

Description	Indicates the nature of an individual's disability. For example: Wheelchair bound Visually impaired Deaf
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

Disability Status Descr

Description	Indicates the nature of an individual's disability. For example: Wheelchair bound Visually impaired Deaf
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

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

Employee Alternate Identifier Num

Description	An alternate way of identifying the employee such as a national identity number, passport number or drivers license 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

Employee Num

Description	The insured's employee 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

Employer Contact Reason Cd

Description	A textual description of the reason(s) that an employer of an individual.
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

Employer Contact Reason Code Sk

Description	A textual description of the reason(s) that an employer of an individual.
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

Employer Contact Reason Descr

Description	A textual description of the reason(s) that an employer of an individual.
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

Employment End Ts

Description	The date and time that the employment ended.
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

Employment Start Ts

Description	The date and time that the employment began.
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

Employment Status Cd

Description	Indicates the current employment status of an individual. For example: Full time employed Part time employed Self-employed, Contract, per diem Leave of absence (for example, Family leave, sabbatical, etc.) Temporarily unemployed Unemployed Retired On active military duty Other Unknown
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

Employment Status Code Sk

Description	Indicates the current employment status of an individual. For example: Full time employed Part time employed Self-employed, Contract, per diem Leave of absence (for example, Family leave, sabbatical, etc.) Temporarily unemployed Unemployed Retired On active military duty Other Unknown
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

Employment Status Descr

Description	Indicates the current employment status of an individual. For example: Full time employed Part time employed Self-employed, Contract, per diem Leave of absence (for example, Family leave, sabbatical, etc.) Temporarily unemployed Unemployed Retired On active military duty Other Unknown
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

Encounter Participation Pct

Description	The plan member's attendance at scheduled treatment, therapy, encounters or other program sessions expressed as a percentage of the number of scheduled encounters.
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
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

ESRD Ind

Description	Indication of whether the individual is in End State Renal Disease.
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

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

Fraud and Abuse Ind

Description	Indicates whether a plan member has been found to have submitted fraudulent claims or to have abused their cover or acted suspiciously in some other way. May also indicate that the plan member is currently under investigation for such behavior.
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

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

Gender Cd

Description	Identifies the gender of an individual.
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

Gender Code Sk

Description	Identifies the gender of an individual.
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

Gender Descr

Description	Identifies the gender of an individual.
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

Guarantor Relationship Cd

Description	Indicates the relationship of the guarantor to the insured.
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

Guarantor Relationship Code Sk

Description	Indicates the relationship of the guarantor to the insured.
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

Guarantor Relationship Descr

Description	Indicates the relationship of the guarantor to the insured.
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

Healthcare Insurer Contact Reason Cd

Description	Indicates how and why the healthcare insurer should be contacted. For example: Medicare claim status Medicaid claim status Name/address change
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

Healthcare Insurer Contact Reason Code Sk

Description	Indicates how and why the healthcare insurer should be contacted. For example: Medicare claim status Medicaid claim status Name/address change
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

Healthcare Insurer Contact Reason Descr

Description	Indicates how and why the healthcare insurer should be contacted. For example: Medicare claim status Medicaid claim status Name/address change
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

Healthcare Insurer Patient Member Num

Description	An identifying number assigned by the payor for each individual covered by the insurance policy issued to the insured. For example, each individual family member may have a different member number from the insurance policy number issued to the head of household.
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

Health Program Participation Status Cd

Description	Indicates the current participation state of a member in a health program., such as a disease management program, prevention and wellness program, smoking cessation 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

Health Program Participation Status Code Descr

Description	Indicates the current participation state of a member in a health program., such as a disease management program, prevention and wellness program, smoking cessation 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

Health Program Participation Status Code Sk

Description	Indicates the current participation state of a member in a health program., such as a disease management program, prevention and wellness program, smoking cessation 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

Job Class Cd

Description	Indicates the classification of an individual's job.
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

Job Class Code Sk

Description	Indicates the classification of an individual's job.
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

Job Class Descr

Description	Indicates the classification of an individual's job.
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

Job Status Cd

Description	Indicates the current status of an individual's job.
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

Job Status Code Sk

Description	Indicates the current status of an individual's job.
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

Job Status Descr

Description	Indicates the current status of an individual's job.
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

Job Title Nm

Description	Descriptive name of the individual's occupation. For example: Systems Analyst Accountant
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

Language Cd

Description	Identifies a language an individual can speak, read and / or write. May also identify the language or dialect in which a comment or text is recorded.
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

Language Code Sk

Description	Identifies a language an individual can speak, read and / or write. May also identify the language or dialect in which a comment or text is recorded.
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

Language Descr

Description	Identifies a language an individual can speak, read and / or write. May also identify the language or dialect in which a comment or text is recorded.
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

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

Level1 Txt

Description	An employer group defined element defining a level of employee, such as division, region, pay grade, etc.”
Data Type	Standards - Data Domains.ddm/Data Domains/Text Very Small [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Level2 Txt

Description	An employer group defined element defining a level of employee, such as division, region, pay grade, etc.”
Data Type	Standards - Data Domains.ddm/Data Domains/Text Very Small [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Level3 Txt

Description	An employer group defined element defining a level of employee, such as division, region, pay grade, etc.”
Data Type	Standards - Data Domains.ddm/Data Domains/Text Very Small [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Level4 Txt

Description	An employer group defined element defining a level of employee, such as division, region, pay grade, etc.”
Data Type	Standards - Data Domains.ddm/Data Domains/Text Very Small [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Living Arrangement Cd

Description	Indicates the situation that an individual lives in at his/her residential address. For example: A - Alone F - Family I - Institution R - Relative U - Unknown S - Spouse Only
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

Living Arrangement Code Sk

Description	Indicates the situation that an individual lives in at his/her residential address. For example: A - Alone F - Family I - Institution R - Relative U - Unknown S - Spouse Only
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

Living Arrangement Descr

Description	Indicates the situation that an individual lives in at his/her residential address. For example: A - Alone F - Family I - Institution R - Relative U - Unknown S - Spouse Only
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

Living Dependency Cd

Description	Indicates any dependency that relates to an individual in their day to day lives. For example: S Spouse Dependent M Medical Supervision Required C Small Children Dependent O Other U Unknown
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

Living Dependency Code Sk

Description	Indicates any dependency that relates to an individual in their day to day lives. For example: S Spouse Dependent M Medical Supervision Required C Small Children Dependent O Other U Unknown
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

Living Dependency Descr

Description	Indicates any dependency that relates to an individual in their day to day lives. For example: S Spouse Dependent M Medical Supervision Required C Small Children Dependent O Other U Unknown
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

Marital Status Cd

Description	Indicates the current marital status of an individual. For example: Married Single Divorced Widow
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

Marital Status Code Sk

Description	Indicates the current marital status of an individual. For example: Married Single Divorced Widow
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

Marital Status Descr

Description	Indicates the current marital status of an individual. For example: Married Single Divorced Widow
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

Medicare Health Insurance Card Num

Description	Medicare Health Insurance Number (HIN), defined by CMS or other regulatory agencies.
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

Medicare Status Cd

Description	Indicates the status of an individual in a Medicare 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

Medicare Status Code Sk

Description	Indicates the status of an individual in a Medicare 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

Medicare Status Descr

Description	Indicates the status of an individual in a Medicare 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

Member Card Group Num

Description	The health plan's group number that appears on the membership card.
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

Member Card ID Num

Description	A plan member's unique identifier appearing on the membership card.
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

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

Military Handicapped Program Cd

Description	Indicates a military program for the handicapped in which the individual is enrolled.
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

Military Handicapped Program Code Sk

Description	Indicates a military program for the handicapped in which the individual is enrolled.
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

Military Handicapped Program Descr

Description	Indicates a military program for the handicapped in which the individual is enrolled.
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

Military ID Num

Description	Military ID number, defined by CMS or other regulatory agencies, which uniquely identifies a patient's military policy.
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

Military Non-Avail Cert On File Ind

Description	Indicates whether or not a military non-available certificate is on file.
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

Military Organization Nm

Description	Description of the military organization to which the individual is associated.
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

Military Rank Cd

Description	Identifies the military rank/grade of an individual.
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

Military Rank Code Sk

Description	Identifies the military rank/grade of an individual.
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

Military Rank Descr

Description	Identifies the military rank/grade of an individual.
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

Military Retire Dt

Description	The date upon which the individual retired from the military service.
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

Military Service Cd

Description	The military service branch of the individual as defined by CMS or other regulatory agencies. For example: USA US Army USN US Navy USAF US Air Force USMC US Marine Corps USCG US Coast Guard USPHS US Public Health Service NOAA National Oceanic and Atmospheric Administration NATO North Atlantic Treaty Organization AUSA Australian Army AUSN Australian Navy AUSAF Australian Air Force
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

Military Service Code Sk

Description	The military service branch of the individual as defined by CMS or other regulatory agencies. For example: USA US Army USN US Navy USAF US Air Force USMC US Marine Corps USCG US Coast Guard USPHS US Public Health Service NOAA National Oceanic and Atmospheric Administration NATO North Atlantic Treaty Organization AUSA Australian Army AUSN Australian Navy AUSAF Australian Air Force
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

Military Service Descr

Description	The military service branch of the individual as defined by CMS or other regulatory agencies. For example: USA US Army USN US Navy USAF US Air Force USMC US Marine Corps USCG US Coast Guard USPHS US Public Health Service NOAA National Oceanic and Atmospheric Administration NATO North Atlantic Treaty Organization AUSA Australian Army AUSN Australian Navy AUSAF Australian Air Force
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

Military Station Nm

Description	Description of a specific military station.
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

Military Status Cd

Description	The military status of an individual as defined by CMS or other regulatory agencies. For example: ACT Active duty RET Retired DEC Deceased
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

Military Status Code Sk

Description	The military status of an individual as defined by CMS or other regulatory agencies. For example: ACT Active duty RET Retired DEC Deceased
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

Military Status Descr

Description	The military status of an individual as defined by CMS or other regulatory agencies. For example: ACT Active duty RET Retired DEC Deceased
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

Multiple Coverage Status Cd

Description	Indicates whether or not plan members are currently covered for the same benefits under two or more policies.
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

Multiple Coverage Status Code Descr

Description	Indicates whether or not plan members are currently covered for the same benefits under two or more policies.
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

Multiple Coverage Status Code Sk

Description	Indicates whether or not plan members are currently covered for the same benefits under two or more policies.
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

Multiple Coverage Status Reason Cd

Description	Indicates why the plan member is covered for the same benefits under two or more policies.
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

Multiple Coverage Status Reason Code Descr

Description	Indicates why the plan member is covered for the same benefits under two or more policies.
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

Multiple Coverage Status Reason Code Sk

Description	Indicates why the plan member is covered for the same benefits under two or more policies.
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 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

Nationality Country Cd

Description	Indicates the nation or national grouping to which a person belongs. This information may be different from a person's citizenship in countries in which multiple nationalities are recognized (for example, Spain: Basque, Catalan, etc.).
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

Nationality Country Code Sk

Description	Indicates the nation or national grouping to which a person belongs. This information may be different from a person's citizenship in countries in which multiple nationalities are recognized (for example, Spain: Basque, Catalan, etc.).
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

Nationality Country Descr

Description	Indicates the nation or national grouping to which a person belongs. This information may be different from a person's citizenship in countries in which multiple nationalities are recognized (for example, Spain: Basque, Catalan, etc.).
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

Original Entitlement Reason Cd

Description	Indicates why the individual was in an entitlement program to begin with.
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

Original Entitlement Reason Code Sk

Description	Indicates why the individual was in an entitlement program to begin with.
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

Original Entitlement Reason Descr

Description	Indicates why the individual was in an entitlement program to begin with.
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

Personal Data Access Status Cd

Description	Indicates whether a plan member has access to the personal data relating to them, stored internally by the healthcare insurer or benefits provider, for example their employer. For example: Yes No
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

Personal Data Access Status Code Descr

Description	Indicates whether a plan member has access to the personal data relating to them, stored internally by the healthcare insurer or benefits provider, for example their employer. For example: Yes No
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

Personal Data Access Status Code Sk

Description	Indicates whether a plan member has access to the personal data relating to them, stored internally by the healthcare insurer or benefits provider, for example their employer. For example: Yes No
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

Personal Health Record Usage Type Cd

Description	Indicates the level of interaction a member has with their personal health record.
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

Personal Health Record Usage Type Code Descr

Description	Indicates the level of interaction a member has with their personal health record.
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

Personal Health Record Usage Type Code Sk

Description	Indicates the level of interaction a member has with their personal health record.
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

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

Person 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

Plan Member 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

Plan Member 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

Plan Member 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

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

Protection Ind

Description	Identifies the individual's protection, which determines whether or not access to information about this person should be restricted from users who do not have adequate authority. 1 restrict access 0 do not restrict access
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

Publicity Cd

Description	Indicates what level of publicity is allowed for an individual. For example: No Publicity Family Only
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

Publicity Code Sk

Description	Indicates what level of publicity is allowed for an individual. For example: No Publicity Family Only
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

Publicity Descr

Description	Indicates what level of publicity is allowed for an individual. For example: No Publicity Family Only
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

Religion Cd

Description	Indicates the religion practiced by an individual.
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

Religion Code Sk

Description	Indicates the religion practiced by an individual.
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

Religion Descr

Description	Indicates the religion practiced by an individual.
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

Social Security Num

Description	The individual's social security 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

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

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

Student Ind

Description	Indicates whether the individual is currently a student, and whether the individual is a full-time or part-time student. 1 Student 0 Not a student
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

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

Supplied Date Of Birth

Description	The date of birth submitted for the plan member, that was the contractual basis for the membership. This may subsequently be discovered to be incorrect and therefore differing to the actual date of birth at the person level.
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

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

VIP Cd

Description	Indicates that the individual is considered a very important person (VIP) such as ahead of state or religious leader.
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

VIP Code Sk

Description	Indicates that the individual is considered a very important person (VIP) such as ahead of state or religious leader.
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

VIP Descr

Description	Indicates that the individual is considered a very important person (VIP) such as ahead of state or religious leader.
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

Relationship Details

Plan Member Dimension_Person Dimension_FK

Is Identifying Relationship	false
Child Table	Plan Member 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	Person Dimension
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Plan Member Dimension PK

Key Attribute

Plan Member Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model