Entity Patient Dimension

DescriptionAn individual that is awaiting or is already under medical care and treatment.

Attributes
Address Line 1 DescrAddress Line 1 Descr
Address Line 2 DescrAddress Line 2 Descr
Address Line 3 DescrAddress Line 3 Descr
Address Line 4 DescrAddress Line 4 Descr
Address Text DescrAddress Text Descr
Address Type CdAddress Type Cd
Address Type Code DescrAddress Type Code Descr
Address Type Code SkAddress Type Code Sk
Address Type DescrAddress Type Descr
Address Use CdAddress Use Cd
Address Use Code DescrAddress Use Code Descr
Address Use Code SkAddress Use Code Sk
Address Use DescrAddress Use Descr
Advanced Directive CdAdvanced Directive Cd
Advanced Directive Code DescrAdvanced Directive Code Descr
Advanced Directive Code SkAdvanced Directive Code Sk
Advanced Directive DescrAdvanced Directive Descr
Age Band CdAge Band Cd
Age Band Code DescrAge Band Code Descr
Age Band Code SkAge Band Code Sk
Age In Years CntAge In Years Cnt
APGAR1 Score NumAPGAR1 Score Num
APGAR5 Score NumAPGAR5 Score Num
AWM Load Info SkAWM Load Info Sk
Baby Mother Patient NumBaby Mother Patient Num
Birth Order SeqBirth Order Seq
Birth Place DescrBirth Place Descr
Birth State CdBirth State Cd
Birth State Code DescrBirth State Code Descr
Birth State Code SkBirth State Code Sk
Birth TsBirth Ts
Blood Type CdBlood Type Cd
Blood Type Code DescrBlood Type Code Descr
Blood Type Code SkBlood Type Code Sk
Blood Type DescrBlood Type Descr
City NmCity Nm
Comfort Measures Only IndComfort Measures Only Ind
Country NmCountry Nm
County NmCounty Nm
Current IndCurrent Ind
Deactivate DtDeactivate Dt
Death TsDeath Ts
Degree NmDegree Nm
Disability Status CdDisability Status Cd
Disability Status Code DescrDisability Status Code Descr
Disability Status Code SkDisability Status Code Sk
Disability Status DescrDisability Status Descr
Display NmDisplay Nm
Driver License Issues State CdDriver License Issues State Cd
Driver License Issues State Code DescrDriver License Issues State Code Descr
Driver License Issues State Code SkDriver License Issues State Code Sk
Driver License Issues State DescrDriver License Issues State Descr
Driver License NumDriver License Num
Duplicate Patient DescrDuplicate Patient Descr
DWM Load Info SkDWM Load Info Sk
Education CdEducation Cd
Education Code DescrEducation Code Descr
Education Code SkEducation Code Sk
Education DescrEducation Descr
Effective From DtEffective From Dt
Effective To DtEffective To Dt
Email Address Resource Locator NmEmail Address Resource Locator Nm
Email Type CdEmail Type Cd
Email Type Code DescrEmail Type Code Descr
Email Type Code SkEmail Type Code Sk
Email Type DescrEmail Type Descr
Email Use CdEmail Use Cd
Email Use Code DescrEmail Use Code Descr
Email Use Code SkEmail Use Code Sk
Email Use DescrEmail Use Descr
Employment Status CdEmployment Status Cd
Employment Status Code DescrEmployment Status Code Descr
Employment Status Code SkEmployment Status Code Sk
Employment Status DescrEmployment Status Descr
First NmFirst Nm
Full NmFull Nm
Gestation Week CntGestation Week Cnt
Home Equipment Type CdHome Equipment Type Cd
Home Equipment Type Code DescrHome Equipment Type Code Descr
Home Equipment Type Code SkHome Equipment Type Code Sk
Home Equipment Type DescrHome Equipment Type Descr
Home Phone Area CdHome Phone Area Cd
Home Phone Country CdHome Phone Country Cd
Home Phone Exchange CdHome Phone Exchange Cd
Home Phone Extension NumHome Phone Extension Num
Home Phone Line NumHome Phone Line Num
Home Phone NumHome Phone Num
Home Phone Speed Dial NumHome Phone Speed Dial Num
Identity Reliability CdIdentity Reliability Cd
Identity Reliability Code DescrIdentity Reliability Code Descr
Identity Reliability Code SkIdentity Reliability Code Sk
Identity Reliability DescrIdentity Reliability Descr
Identity Unknown IndIdentity Unknown Ind
Immunization Registry CdImmunization Registry Cd
Immunization Registry Code DescrImmunization Registry Code Descr
Immunization Registry Code DtImmunization Registry Code Dt
Immunization Registry Code SkImmunization Registry Code Sk
Immunization Registry DescrImmunization Registry Descr
Last Contact DtLast Contact Dt
Last NmLast Nm
Literacy CdLiteracy Cd
Literacy Code DescrLiteracy Code Descr
Literacy Code SkLiteracy Code Sk
Literacy DescrLiteracy Descr
Living Arrangement CdLiving Arrangement Cd
Living Arrangement Code DescrLiving Arrangement Code Descr
Living Arrangement Code SkLiving Arrangement Code Sk
Living Arrangement DescrLiving Arrangement Descr
Living Status CdLiving Status Cd
Living Status Code DescrLiving Status Code Descr
Living Status Code SkLiving Status Code Sk
Living Status DescrLiving Status Descr
Living Will CdLiving Will Cd
Living Will Code DescrLiving Will Code Descr
Living Will Code SkLiving Will Code Sk
Living Will DescrLiving Will Descr
Majority DtMajority Dt
Marital Status CdMarital Status Cd
Marital Status Code DescrMarital Status Code Descr
Marital Status Code SkMarital Status Code Sk
Marital Status DescrMarital Status Descr
Medicaid NumMedicaid Num
Medical Record NumMedical Record Num
Medicare NumMedicare Num
Middle NmMiddle Nm
Military Branch CdMilitary Branch Cd
Military Branch Code DescrMilitary Branch Code Descr
Military Branch Code SkMilitary Branch Code Sk
Military Branch DescrMilitary Branch Descr
Military Rank CdMilitary Rank Cd
Military Rank Code DescrMilitary Rank Code Descr
Military Rank Code SkMilitary Rank Code Sk
Military Rank DescrMilitary Rank Descr
Military Status CdMilitary Status Cd
Military Status Code DescrMilitary Status Code Descr
Military Status Code SkMilitary Status Code Sk
Military Status DescrMilitary Status Descr
Mother Maiden NmMother Maiden Nm
Multiple Birth IndMultiple Birth Ind
Name Type CdName Type Cd
Name Type Code DescrName Type Code Descr
Name Type Code SkName Type Code Sk
Name Type DescrName Type Descr
Name Usage CdName Usage Cd
Name Usage Code DescrName Usage Code Descr
Name Usage Code SkName Usage Code Sk
Name Usage DescrName Usage Descr
Nationality Country CdNationality Country Cd
Nationality Country Code DescrNationality Country Code Descr
Nationality Country Code SkNationality Country Code Sk
Nationality Country DescrNationality Country Descr
Necropsy IndNecropsy Ind
Occupation CdOccupation Cd
Occupation Code DescrOccupation Code Descr
Occupation Code SkOccupation Code Sk
Occupation DescrOccupation Descr
Organ Donor CdOrgan Donor Cd
Organ Donor Code DescrOrgan Donor Code Descr
Organ Donor Code SkOrgan Donor Code Sk
Organ Donor DescrOrgan Donor Descr
Patient BkPatient Bk
Patient Death IndPatient Death Ind
Patient DkPatient Dk
Patient SkPatient Sk
Person DkPerson Dk
Person SkPerson Sk
Place Of Worship DescrPlace Of Worship Descr
Postal CdPostal Cd
Practitioner SkPractitioner Sk
Prefix NmPrefix Nm
Primary Citizenship Country CdPrimary Citizenship Country Cd
Primary Citizenship Country Code DescrPrimary Citizenship Country Code Descr
Primary Citizenship Country Code SkPrimary Citizenship Country Code Sk
Primary Citizenship Country DescrPrimary Citizenship Country Descr
Primary Citizenship Tribal CdPrimary Citizenship Tribal Cd
Primary Citizenship Tribal Code DescrPrimary Citizenship Tribal Code Descr
Primary Citizenship Tribal Code SkPrimary Citizenship Tribal Code Sk
Primary Citizenship Tribal DescrPrimary Citizenship Tribal Descr
Primary Ethnicity CdPrimary Ethnicity Cd
Primary Ethnicity Code DescrPrimary Ethnicity Code Descr
Primary Ethnicity Code SkPrimary Ethnicity Code Sk
Primary Ethnicity DescrPrimary Ethnicity Descr
Primary Ethnicity PctPrimary Ethnicity Pct
Primary Language CdPrimary Language Cd
Primary Language Code DescrPrimary Language Code Descr
Primary Language Code SkPrimary Language Code Sk
Primary Language DescrPrimary Language Descr
Primary Living Dependency CdPrimary Living Dependency Cd
Primary Living Dependency Code DescrPrimary Living Dependency Code Descr
Primary Living Dependency Code SkPrimary Living Dependency Code Sk
Primary Living Dependency DescrPrimary Living Dependency Descr
Primary Patient Race PctPrimary Patient Race Pct
Primary Race CdPrimary Race Cd
Primary Race Code DescrPrimary Race Code Descr
Primary Race Code SkPrimary Race Code Sk
Primary Race DescrPrimary Race Descr
Protection CdProtection Cd
Protection Code DescrProtection Code Descr
Protection Code Effective DtProtection Code Effective Dt
Protection Code SkProtection Code Sk
Protection DescrProtection Descr
Publicity CdPublicity Cd
Publicity Code DescrPublicity Code Descr
Publicity Code DtPublicity Code Dt
Publicity Code SkPublicity Code Sk
Publicity DescrPublicity Descr
Registration TsRegistration Ts
Religion CdReligion Cd
Religion Code DescrReligion Code Descr
Religion Code SkReligion Code Sk
Religion DescrReligion Descr
Separate Bill CdSeparate Bill Cd
Separate Bill Code DescrSeparate Bill Code Descr
Separate Bill Code SkSeparate Bill Code Sk
Separate Bill DescrSeparate Bill Descr
Sex CdSex Cd
Sex Code DescrSex Code Descr
Sex Code SkSex Code Sk
Sex DescrSex Descr
SMPI NumSMPI Num
Social Security NumSocial Security Num
Source CdSource Cd
Source Code DescrSource Code Descr
Source Code SkSource Code Sk
State Province CdState Province Cd
Student Status CdStudent Status Cd
Student Status Code DescrStudent Status Code Descr
Student Status Code SkStudent Status Code Sk
Student Status DescrStudent Status Descr
Suffix NmSuffix Nm
Tenant SkTenant Sk
UMPI NumUMPI Num
Valid From TsValid From Ts
Valid To TsValid To Ts
VIP CdVIP Cd
VIP Code DescrVIP Code Descr
VIP Code SkVIP Code Sk
VIP DescrVIP Descr
Work Equipment Type CdWork Equipment Type Cd
Work Equipment Type Code DescrWork Equipment Type Code Descr
Work Equipment Type Code SkWork Equipment Type Code Sk
Work Equipment Type DescrWork Equipment Type Descr
Work Phone Area CdWork Phone Area Cd
Work Phone Country CdWork Phone Country Cd
Work Phone Exchange CdWork Phone Exchange Cd
Work Phone Extension NumWork Phone Extension Num
Work Phone Line NumWork Phone Line Num
Work Phone NumWork Phone Num
Work Phone Speed Dial NumWork Phone Speed Dial Num

Relationship
Patient Dimension_Person Dimension_FKPatient Dimension_Person Dimension_FK

Primary Key
Patient Dimension PKPatient Dimension PK

Dependencies
 
 

Reverse Dependencies
 

Attribute Details

 Address Line 1 Descr
DescriptionFirst line of the address. Use for Primary Street and Building Number
Data TypeStandards - Data Domains.ddm/Data Domains/Address Line [VARCHAR(100)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Address Line 2 Descr
DescriptionSecond line of the address
Data TypeStandards - Data Domains.ddm/Data Domains/Address Line [VARCHAR(100)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Address Line 3 Descr
DescriptionThird line of the address
Data TypeStandards - Data Domains.ddm/Data Domains/Address Line [VARCHAR(100)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Address Line 4 Descr
DescriptionFourth line of the address
Data TypeStandards - Data Domains.ddm/Data Domains/Address Line [VARCHAR(100)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Address Text Descr
DescriptionFree form textual comments with respect to the telephone number.
Data TypeStandards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Address Type Cd
DescriptionIdentifies the type of the relationship as defined in the business data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Address Type Code Descr
DescriptionIdentifies the type of the relationship as defined in the business data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Address Type Code Sk
DescriptionIdentifies the type of the relationship as defined in the business data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Address Type Descr
DescriptionIdentifies the type of the relationship as defined in the business data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Address Use Cd
DescriptionIndicates the way a telephone number is used by a party.

For example:
Default
Alert Contact
After Hours
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Address Use Code Descr
DescriptionIndicates the way a telephone number is used by a party.

For example:
Default
Alert Contact
After Hours
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Address Use Code Sk
DescriptionIndicates the way a telephone number is used by a party.

For example:
Default
Alert Contact
After Hours
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Address Use Descr
DescriptionIndicates the way a telephone number is used by a party.

For example:
Default
Alert Contact
After Hours
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Advanced Directive Cd
DescriptionIdentifies instructions to the healthcare facility that the patient has put in place.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Advanced Directive Code Descr
DescriptionIdentifies instructions to the healthcare facility that the patient has put in place.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Advanced Directive Code Sk
DescriptionIdentifies instructions to the healthcare facility that the patient has put in place.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Advanced Directive Descr
DescriptionIdentifies instructions to the healthcare facility that the patient has put in place.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Age Band Cd
DescriptionThe date and time a patient was born.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Age Band Code Descr
DescriptionThe date and time a patient was born.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Age Band Code Sk
DescriptionThe date and time a patient was born.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Age In Years Cnt
DescriptionThe date and time a patient was born.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 APGAR1 Score Num
DescriptionAPGAR score 1 minute after delivery. The APGAR scale is used to evaluate a baby's health immediately after birth using five criteria, Appearance, Pulse, Grimace (reflex irritability), Activity and Respiration.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 APGAR5 Score Num
DescriptionAPGAR score 5 minutes after delivery. The APGAR scale is used to evaluate a baby's health immediately after birth using five criteria, Appearance, Pulse, Grimace (reflex irritability), Activity and Respiration.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 AWM Load Info Sk
DescriptionThe surrogate key of the load information entry describing the details regarding the loading of the row in the atomic data warehouse.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Baby Mother Patient Num
DescriptionAn identification number for the mother of a baby patient.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Birth Order Seq
DescriptionA number indicating the baby's birth order, when a baby was part of a multiple birth.
Data TypeStandards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Birth Place Descr
DescriptionThe location of the baby's birth.
For example:
St. Francis Community Hospital of Lower South Side
Data TypeStandards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Birth State Cd
DescriptionIndicates the state or province where the patient was born. In U.S., the 2-letter state code, for example, IN, NY, or CA. In other countries, a locally applicable code may be used.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Birth State Code Descr
DescriptionIndicates the state or province where the patient was born. In U.S., the 2-letter state code, for example, IN, NY, or CA. In other countries, a locally applicable code may be used.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Birth State Code Sk
DescriptionIndicates the state or province where the patient was born. In U.S., the 2-letter state code, for example, IN, NY, or CA. In other countries, a locally applicable code may be used.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Birth Ts
DescriptionThe date and time a patient was born.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Blood Type Cd
DescriptionA blood type (also called a blood group) is a classification of blood based on the presence or absence of inherited antigenic substances on the surface of red blood cells (RBCs).
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Blood Type Code Descr
DescriptionA blood type (also called a blood group) is a classification of blood based on the presence or absence of inherited antigenic substances on the surface of red blood cells (RBCs).
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Blood Type Code Sk
DescriptionA blood type (also called a blood group) is a classification of blood based on the presence or absence of inherited antigenic substances on the surface of red blood cells (RBCs).
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Blood Type Descr
DescriptionA blood type (also called a blood group) is a classification of blood based on the presence or absence of inherited antigenic substances on the surface of red blood cells (RBCs).
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 City Nm
DescriptionName for the city of the address.
Data TypeStandards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Comfort Measures Only Ind
DescriptionIndicates if the patient's care is to be limited to comfort measures only.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Country Nm
DescriptionName of the country for the address.
Data TypeStandards - Data Domains.ddm/Data Domains/Area Name [VARCHAR(50)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 County Nm
DescriptionThe name of the county for the address.
Data TypeStandards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Current Ind
DescriptionSet to 'Y' if this is the most recent row of a group having the same Surrogate Key.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Deactivate Dt
DescriptionDate upon which the patient is no longer considered an active patient of the healthcare organization or facility.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Death Ts
DescriptionThe date and time a patient died.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Degree Nm
DescriptionThe party name component indicating degrees and certifications a Party uses in their formal name.
Data TypeStandards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Disability Status Cd
DescriptionIndicates any permanent or transient handicapped conditions. Also known as ambulatory status.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Disability Status Code Descr
DescriptionIndicates any permanent or transient handicapped conditions. Also known as ambulatory status.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Disability Status Code Sk
DescriptionIndicates any permanent or transient handicapped conditions. Also known as ambulatory status.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Disability Status Descr
DescriptionIndicates any permanent or transient handicapped conditions. Also known as ambulatory status.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Display Nm
DescriptionThe complete name (first, middle, last) for a person.
Data TypeStandards - Data Domains.ddm/Data Domains/Name Compound [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Driver License Issues State Cd
DescriptionThe state or territory issuing the driver's license
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Driver License Issues State Code Descr
DescriptionThe state or territory issuing the driver's license
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Driver License Issues State Code Sk
DescriptionThe state or territory issuing the driver's license
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Driver License Issues State Descr
DescriptionThe state or territory issuing the driver's license
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Driver License Num
DescriptionThe patient's driver's license number.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Duplicate Patient Descr
DescriptionIndicates that a patient is the same as, or a duplicate of, another patient found on the sending system.  The intent is to be informational only and no action is required by the receiver.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 DWM Load Info Sk
DescriptionThe surrogate key of the load information entry describing the details regarding the loading of the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Education Cd
DescriptionIdentifies the individual's highest level of education attained.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Education Code Descr
DescriptionIdentifies the individual's highest level of education attained.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Education Code Sk
DescriptionIdentifies the individual's highest level of education attained.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Education Descr
DescriptionIdentifies the individual's highest level of education attained.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Effective From Dt
DescriptionEstablishes a period where a set of attributes are true according to the business.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Effective To Dt
DescriptionEnds a period of effectivity.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Email Address Resource Locator Nm
DescriptionEmail address string, representing the contact email address
Data TypeStandards - Data Domains.ddm/Data Domains/URL [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Email Type Cd
DescriptionIndicates the nature of the email address.

For example:
Personal
Work
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Email Type Code Descr
DescriptionIndicates the nature of the email address.

For example:
Personal
Work
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Email Type Code Sk
DescriptionIndicates the nature of the email address.

For example:
Personal
Work
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Email Type Descr
DescriptionIndicates the nature of the email address.

For example:
Personal
Work
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Email Use Cd
DescriptionIndicates the way an email address is used by a party.

For example:
Default
Mailing
Billing
Delivery
Statement
Alert Contact
After Hours
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Email Use Code Descr
DescriptionIndicates the way an email address is used by a party.

For example:
Default
Mailing
Billing
Delivery
Statement
Alert Contact
After Hours
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Email Use Code Sk
DescriptionIndicates the way an email address is used by a party.

For example:
Default
Mailing
Billing
Delivery
Statement
Alert Contact
After Hours
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Email Use Descr
DescriptionIndicates the way an email address is used by a party.

For example:
Default
Mailing
Billing
Delivery
Statement
Alert Contact
After Hours
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Employment Status Cd
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Employment Status Code Descr
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Employment Status Code Sk
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Employment Status Descr
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 First Nm
DescriptionFirst name of a person.
Data TypeStandards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Full Nm
DescriptionThe complete name (first, middle, last) for a person.
Data TypeStandards - Data Domains.ddm/Data Domains/Name Compound [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Gestation Week Cnt
DescriptionThe number of weeks after conception the baby was delivered.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Home Equipment Type Cd
DescriptionIndicates the kind of telephone represented by the number.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Home Equipment Type Code Descr
DescriptionIndicates the kind of telephone represented by the number.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Home Equipment Type Code Sk
DescriptionIndicates the kind of telephone represented by the number.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Home Equipment Type Descr
DescriptionIndicates the kind of telephone represented by the number.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Home Phone Area Cd
DescriptionIndicates the area code for the telephone, cell, or pager number.
Data TypeStandards - Data Domains.ddm/Data Domains/Phone Area Code [VARCHAR(8)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Home Phone Country Cd
DescriptionIndicates the country code for the telephone, cell, or pager number.
Data TypeStandards - Data Domains.ddm/Data Domains/Phone Country Code [CHAR(3)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Home Phone Exchange Cd
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Phone Exchange Code [VARCHAR(3)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Home Phone Extension Num
DescriptionA suffix for a telephone number to reach a specific phone in a main telephone network
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Home Phone Line Num
DescriptionRepresents 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 TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Home Phone Num
DescriptionRepresents the actual number (without formatting) for the telephone, cell, or pager number.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Home Phone Speed Dial Num
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Identity Reliability Cd
DescriptionIndicates the reliability of information identifying an individual. This could indicate that certain information for a given patient/person are known to be false (for example, use of default or system-generated values for Date of Birth or Social Security Number).
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Identity Reliability Code Descr
DescriptionIndicates the reliability of information identifying an individual. This could indicate that certain information for a given patient/person are known to be false (for example, use of default or system-generated values for Date of Birth or Social Security Number).
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Identity Reliability Code Sk
DescriptionIndicates the reliability of information identifying an individual. This could indicate that certain information for a given patient/person are known to be false (for example, use of default or system-generated values for Date of Birth or Social Security Number).
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Identity Reliability Descr
DescriptionIndicates the reliability of information identifying an individual. This could indicate that certain information for a given patient/person are known to be false (for example, use of default or system-generated values for Date of Birth or Social Security Number).
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Identity Unknown Ind
DescriptionIndicates that the actual identity of patient cannot be determined.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Immunization Registry Cd
DescriptionIdentifies the immunization registry status of the patient. This may be used to indicate the changed status of a once active patient in an immunization registry.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Immunization Registry Code Descr
DescriptionIdentifies the immunization registry status of the patient. This may be used to indicate the changed status of a once active patient in an immunization registry.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Immunization Registry Code Dt
DescriptionThe date upon which the immunization registry status is defined.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Immunization Registry Code Sk
DescriptionIdentifies the immunization registry status of the patient. This may be used to indicate the changed status of a once active patient in an immunization registry.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Immunization Registry Descr
DescriptionIdentifies the immunization registry status of the patient. This may be used to indicate the changed status of a once active patient in an immunization registry.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Last Contact Dt
DescriptionThe date upon which the last contact was made with the individual. This could be the date of death in the case of a deceased person.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Last Nm
DescriptionLast name of a person.
Data TypeStandards - Data Domains.ddm/Data Domains/Last Name [VARCHAR(75)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Literacy Cd
DescriptionIndicates whether the patient has the ability to understand written correspondence.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Literacy Code Descr
DescriptionIndicates whether the patient has the ability to understand written correspondence.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Literacy Code Sk
DescriptionIndicates whether the patient has the ability to understand written correspondence.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Literacy Descr
DescriptionIndicates whether the patient has the ability to understand written correspondence.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Living Arrangement Cd
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Living Arrangement Code Descr
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Living Arrangement Code Sk
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Living Arrangement Descr
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Living Status Cd
DescriptionIndicates that the person is still alive.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Living Status Code Descr
DescriptionIndicates that the person is still alive.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Living Status Code Sk
DescriptionIndicates that the person is still alive.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Living Status Descr
DescriptionIndicates that the person is still alive.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Living Will Cd
DescriptionIndicates whether or not the patient has a living will and, if so, whether a copy of the living will is on file at the healthcare facility. If the patient does not have a living will, this may indicate whether the patient was provided information on living wills.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Living Will Code Descr
DescriptionIndicates whether or not the patient has a living will and, if so, whether a copy of the living will is on file at the healthcare facility. If the patient does not have a living will, this may indicate whether the patient was provided information on living wills.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Living Will Code Sk
DescriptionIndicates whether or not the patient has a living will and, if so, whether a copy of the living will is on file at the healthcare facility. If the patient does not have a living will, this may indicate whether the patient was provided information on living wills.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Living Will Descr
DescriptionIndicates whether or not the patient has a living will and, if so, whether a copy of the living will is on file at the healthcare facility. If the patient does not have a living will, this may indicate whether the patient was provided information on living wills.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Majority Dt
DescriptionThe date from which the patient is able to legally act on their own behalf. In legal terminology this is referred to as 'reaching the age of majority'. The date a person can enter into contracts and approve medical care.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Marital Status Cd
DescriptionIndicates the current marital status of an individual.

For example:
Married
Single
Divorced
Widow
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Marital Status Code Descr
DescriptionIndicates the current marital status of an individual.

For example:
Married
Single
Divorced
Widow
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Marital Status Code Sk
DescriptionIndicates the current marital status of an individual.

For example:
Married
Single
Divorced
Widow
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Marital Status Descr
DescriptionIndicates the current marital status of an individual.

For example:
Married
Single
Divorced
Widow
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Medicaid Num
DescriptionThe Medicaid case number, defined by CMS or other regulatory agencies, which uniquely identifies a patient's Medicaid policy.
Data TypeStandards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Medical Record Num
DescriptionThe medical record number (MRN) currently used to identify the patient.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Medicare Num
DescriptionThe Medicare case number, defined by CMS or other regulatory agencies, which uniquely identifies a patient's Medicare policy.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Middle Nm
DescriptionThe middle name of a person.
Data TypeStandards - Data Domains.ddm/Data Domains/Name Compound [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Military Branch Cd
DescriptionIdentifies the Branch of Service for Military personnel.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Military Branch Code Descr
DescriptionIdentifies the Branch of Service for Military personnel.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Military Branch Code Sk
DescriptionIdentifies the Branch of Service for Military personnel.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Military Branch Descr
DescriptionIdentifies the Branch of Service for Military personnel.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Military Rank Cd
DescriptionIdentifies the military rank/grade of an individual.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Military Rank Code Descr
DescriptionIdentifies the military rank/grade of an individual.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Military Rank Code Sk
DescriptionIdentifies the military rank/grade of an individual.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Military Rank Descr
DescriptionIdentifies the military rank/grade of an individual.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Military Status Cd
DescriptionThe military status of an individual as defined by CMS or other regulatory agencies.
For example:

ACT Active duty
RET Retired
DEC Deceased
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Military Status Code Descr
DescriptionThe military status of an individual as defined by CMS or other regulatory agencies.
For example:

ACT Active duty
RET Retired
DEC Deceased
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Military Status Code Sk
DescriptionThe military status of an individual as defined by CMS or other regulatory agencies.
For example:

ACT Active duty
RET Retired
DEC Deceased
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Military Status Descr
DescriptionThe military status of an individual as defined by CMS or other regulatory agencies.
For example:

ACT Active duty
RET Retired
DEC Deceased
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Mother Maiden Nm
DescriptionThe surname before marriage of an individuals mother.
Data TypeStandards - Data Domains.ddm/Data Domains/Name Medium [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Multiple Birth Ind
DescriptionIndicates whether the baby was a part of a multiple birth.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Name Type Cd
DescriptionIdentifies the type of the relationship as defined in the business data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Name Type Code Descr
DescriptionIdentifies the type of the relationship as defined in the business data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Name Type Code Sk
DescriptionIdentifies the type of the relationship as defined in the business data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Name Type Descr
DescriptionIdentifies the type of the relationship as defined in the business data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Name Usage Cd
DescriptionIndicates how a role player uses a name.

For example:
Default
Mailing
Legal
DBA
Alias
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Name Usage Code Descr
DescriptionIndicates how a role player uses a name.

For example:
Default
Mailing
Legal
DBA
Alias
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Name Usage Code Sk
DescriptionIndicates how a role player uses a name.

For example:
Default
Mailing
Legal
DBA
Alias
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Name Usage Descr
DescriptionIndicates how a role player uses a name.

For example:
Default
Mailing
Legal
DBA
Alias
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Nationality Country Cd
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Nationality Country Code Descr
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Nationality Country Code Sk
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Nationality Country Descr
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Necropsy Ind
DescriptionIndicates whether the baby was delivered deceased.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Occupation Cd
DescriptionThe primary reported occupation of a person.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Occupation Code Descr
DescriptionThe primary reported occupation of a person.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Occupation Code Sk
DescriptionThe primary reported occupation of a person.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Occupation Descr
DescriptionThe primary reported occupation of a person.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Organ Donor Cd
DescriptionIndicates whether a person wants to donate his/her organs and whether an organ donor card or similar documentation is on file with the healthcare organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Organ Donor Code Descr
DescriptionIndicates whether a person wants to donate his/her organs and whether an organ donor card or similar documentation is on file with the healthcare organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Organ Donor Code Sk
DescriptionIndicates whether a person wants to donate his/her organs and whether an organ donor card or similar documentation is on file with the healthcare organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Organ Donor Descr
DescriptionIndicates whether a person wants to donate his/her organs and whether an organ donor card or similar documentation is on file with the healthcare organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Patient Bk
DescriptionConcatenated values of a set of business attributes that uniquely identify the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Patient Death Ind
DescriptionIndicates if the patient is deceased.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Patient Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keytrue



 Patient Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Person Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Person Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Place Of Worship Descr
DescriptionIdentifies the patient's place of worship.

For example:
The First Baptist Church of Atlanta.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Postal Cd
DescriptionZip code and International Postal Code for the address.
Data TypeStandards - Data Domains.ddm/Data Domains/Postal Code [VARCHAR(15)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Practitioner Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Prefix Nm
DescriptionA prefix name refers to titles that precede a name.

For Example:
Mr.
Mrs.
Ms.
Miss
Dr.
Data TypeStandards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Citizenship Country Cd
DescriptionIndicates the citizenship of an individual.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Citizenship Country Code Descr
DescriptionIndicates the citizenship of an individual.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Citizenship Country Code Sk
DescriptionIndicates the citizenship of an individual.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Citizenship Country Descr
DescriptionIndicates the citizenship of an individual.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Citizenship Tribal Cd
DescriptionIndicates a person's tribal affiliation.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Citizenship Tribal Code Descr
DescriptionIndicates a person's tribal affiliation.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Citizenship Tribal Code Sk
DescriptionIndicates a person's tribal affiliation.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Citizenship Tribal Descr
DescriptionIndicates a person's tribal affiliation.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Ethnicity Cd
DescriptionIndicates the individual's ethnic group.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Ethnicity Code Descr
DescriptionIndicates the individual's ethnic group.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Ethnicity Code Sk
DescriptionIndicates the individual's ethnic group.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Ethnicity Descr
DescriptionIndicates the individual's ethnic group.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Ethnicity Pct
DescriptionThe percentage an ethnicity contributes to the patient's overall ethnic make-up.
Data TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Language Cd
DescriptionUnique coded value for language.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Language Code Descr
DescriptionIdentifies 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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Language Code Sk
DescriptionIdentifies 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Language Descr
DescriptionIdentifies 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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Living Dependency Cd
DescriptionIndicates any dependencies that relate 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 TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Living Dependency Code Descr
DescriptionIndicates any dependencies that relate 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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Living Dependency Code Sk
DescriptionIndicates any dependencies that relate 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Living Dependency Descr
DescriptionIndicates any dependencies that relate 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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Patient Race Pct
DescriptionThe percentage a race contributes to the patient's overall racial make-up.
Data TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Race Cd
DescriptionIndicates the race of an individual.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Race Code Descr
DescriptionIndicates the race of an individual.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Race Code Sk
DescriptionIndicates the race of an individual.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Race Descr
DescriptionIndicates the race of an individual.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Protection Cd
DescriptionIdentifies the patient'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 TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Protection Code Descr
DescriptionIdentifies the patient'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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Protection Code Effective Dt
DescriptionThe date upon which a person's protection commences. This means access to the person's data is restricted to the people who do not have adequate authority.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Protection Code Sk
DescriptionIdentifies the patient'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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Protection Descr
DescriptionIdentifies the patient'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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Publicity Cd
DescriptionIndicates what level of publicity is allowed for an individual.

For example:
No Publicity
Family Only
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Publicity Code Descr
DescriptionIndicates what level of publicity is allowed for an individual.

For example:
No Publicity
Family Only
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Publicity Code Dt
DescriptionThe date upon which the patient's publicity level comes into effect.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Publicity Code Sk
DescriptionIndicates what level of publicity is allowed for an individual.

For example:
No Publicity
Family Only
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Publicity Descr
DescriptionIndicates what level of publicity is allowed for an individual.

For example:
No Publicity
Family Only
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Registration Ts
DescriptionThe date and time of initial registration for a patient.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Religion Cd
DescriptionIndicates the religion practiced by an individual.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Religion Code Descr
DescriptionIndicates the religion practiced by an individual.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Religion Code Sk
DescriptionIndicates the religion practiced by an individual.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Religion Descr
DescriptionIndicates the religion practiced by an individual.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Separate Bill Cd
DescriptionSpecifies that charges for this patient are to be billed separately from other patient bills with the same guarantor. (This bill is now a patient bill rather than a guarantor bill.)
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Separate Bill Code Descr
DescriptionSpecifies that charges for this patient are to be billed separately from other patient bills with the same guarantor. (This bill is now a patient bill rather than a guarantor bill.)
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Separate Bill Code Sk
DescriptionSpecifies that charges for this patient are to be billed separately from other patient bills with the same guarantor. (This bill is now a patient bill rather than a guarantor bill.)
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Separate Bill Descr
DescriptionSpecifies that charges for this patient are to be billed separately from other patient bills with the same guarantor. (This bill is now a patient bill rather than a guarantor bill.)
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Sex Cd
DescriptionIdentifies the gender of an individual.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Sex Code Descr
DescriptionIdentifies the gender of an individual.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Sex Code Sk
DescriptionIdentifies the gender of an individual.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Sex Descr
DescriptionIdentifies the gender of an individual.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 SMPI Num
DescriptionThe master patient identifier, a universal identifier assigned by a subscribing facility/system.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Social Security Num
DescriptionThe individual's social security number.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Source Cd
DescriptionThe code that corresponds to the Source Code Sk.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Source Code Descr
DescriptionThe description that corresponds to the Source Type Cd.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Source Code Sk
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 State Province Cd
DescriptionIndicates the state or province for the address using a recognized set of codes or abbreviations.
Data TypeStandards - Data Domains.ddm/Data Domains/State Code [CHAR(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Student Status Cd
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Student Status Code Descr
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Student Status Code Sk
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Student Status Descr
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Suffix Nm
DescriptionA 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 TypeStandards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Tenant Sk
DescriptionThe surrogate key of the entry identifying the legal owner of the data.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 UMPI Num
DescriptionThe Universal patient identifier set in Master Data Management (MDM).
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Valid From Ts
DescriptionEstablishes 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 TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Valid To Ts
DescriptionEnds a period of validity.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 VIP Cd
DescriptionIndicates that the individual is considered a very important person (VIP) such as ahead of state or religious leader.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 VIP Code Descr
DescriptionIndicates that the individual is considered a very important person (VIP) such as ahead of state or religious leader.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 VIP Code Sk
DescriptionIndicates that the individual is considered a very important person (VIP) such as ahead of state or religious leader.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 VIP Descr
DescriptionIndicates that the individual is considered a very important person (VIP) such as ahead of state or religious leader.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Work Equipment Type Cd
DescriptionIndicates the kind of telephone represented by the number.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Work Equipment Type Code Descr
DescriptionIndicates the kind of telephone represented by the number.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Work Equipment Type Code Sk
DescriptionIndicates the kind of telephone represented by the number.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Work Equipment Type Descr
DescriptionIndicates the kind of telephone represented by the number.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Work Phone Area Cd
DescriptionIndicates the area code for the telephone, cell, or pager number.
Data TypeStandards - Data Domains.ddm/Data Domains/Phone Area Code [VARCHAR(8)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Work Phone Country Cd
DescriptionIndicates the country code for the telephone, cell, or pager number.
Data TypeStandards - Data Domains.ddm/Data Domains/Phone Country Code [CHAR(3)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Work Phone Exchange Cd
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Phone Exchange Code [VARCHAR(3)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Work Phone Extension Num
DescriptionA suffix for a telephone number to reach a specific phone in a main telephone network
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Work Phone Line Num
DescriptionRepresents 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 TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Work Phone Num
DescriptionRepresents the actual number (without formatting) for the telephone, cell, or pager number.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Work Phone Speed Dial Num
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Patient Dimension_Person Dimension_FK
Is Identifying Relationshipfalse
Child TablePatient Dimension
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePerson Dimension
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Primary Key Details

 Patient Dimension PK
Key AttributePatient Dk