| Dimensional Warehouse Model Data Model |
| Description | An individual that is awaiting or is already under medical care and treatment. |
| Relationship | |
Patient Dimension_Person Dimension_FK |
|
| Primary Key | |
Patient 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 Text Descr
| Description | Free form textual comments with respect to the telephone number. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)] |
| 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 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 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 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 |
Address Use Code 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 |
Address 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 |
Address 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 |
Advanced Directive Cd
| Description | Identifies instructions to the healthcare facility that the patient has put in place. |
| 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 |
Advanced Directive Code Descr
| Description | Identifies instructions to the healthcare facility that the patient has put in place. |
| 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 |
Advanced Directive Code Sk
| Description | Identifies instructions to the healthcare facility that the patient has put in place. |
| 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 |
Advanced Directive Descr
| Description | Identifies instructions to the healthcare facility that the patient has put in place. |
| 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 |
Age Band Cd
| Description | The date and time a patient was born. |
| 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 |
Age Band Code Descr
| Description | The date and time a patient was born. |
| 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 |
Age Band Code Sk
| Description | The date and time a patient was born. |
| 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 |
Age In Years Cnt
| Description | The date and time a patient was born. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
APGAR1 Score Num
| Description | APGAR 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 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 |
APGAR5 Score Num
| Description | APGAR 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 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 |
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 |
Baby Mother Patient Num
| Description | An identification number for the mother of a baby patient. |
| 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 |
Birth Order Seq
| Description | A number indicating the baby's birth order, when a baby was part of a multiple birth. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Birth Place Descr
| Description | The location of the baby's birth. For example: St. Francis Community Hospital of Lower South Side |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Birth State Cd
| Description | Indicates 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 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 |
Birth State Code Descr
| Description | Indicates 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 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 |
Birth State Code Sk
| Description | Indicates 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 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 |
Birth Ts
| Description | The date and time a patient was born. |
| 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 |
Blood Type Cd
| Description | A 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 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 |
Blood Type Code Descr
| Description | A 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 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 |
Blood Type Code Sk
| Description | A 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 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 |
Blood Type Descr
| Description | A 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 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 |
Comfort Measures Only Ind
| Description | Indicates if the patient's care is to be limited to comfort measures only. |
| 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 | The name of the county for the address. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Current Ind
| Description | Set to 'Y' if this is the most recent row of a group having the same Surrogate Key. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Deactivate Dt
| Description | Date upon which the patient is no longer considered an active patient of the healthcare organization or facility. |
| 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 |
Death Ts
| Description | The date and time a patient died. |
| 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 |
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 |
Disability Status Cd
| Description | Indicates any permanent or transient handicapped conditions. Also known as ambulatory status. |
| 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 Descr
| Description | Indicates any permanent or transient handicapped conditions. Also known as ambulatory status. |
| 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 Code Sk
| Description | Indicates any permanent or transient handicapped conditions. Also known as ambulatory status. |
| 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 any permanent or transient handicapped conditions. Also known as ambulatory status. |
| 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 |
Driver License Issues State Cd
| Description | The state or territory issuing the driver's license |
| 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 |
Driver License Issues State Code Descr
| Description | The state or territory issuing the driver's license |
| 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 |
Driver License Issues State Code Sk
| Description | The state or territory issuing the driver's license |
| 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 |
Driver License Issues State Descr
| Description | The state or territory issuing the driver's license |
| 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 |
Driver License Num
| Description | The patient's driver's 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 |
Duplicate Patient Descr
| Description | Indicates 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 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 |
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 |
Education Cd
| Description | Identifies the individual's highest level of education attained. |
| 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 |
Education Code Descr
| Description | Identifies the individual's highest level of education attained. |
| 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 |
Education Code Sk
| Description | Identifies the individual's highest level of education attained. |
| 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 |
Education Descr
| Description | Identifies the individual's highest level of education attained. |
| 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 |
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 | Indicates the nature of the email address. For example: Personal Work |
| 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 Descr
| Description | Indicates the nature of the email address. For example: Personal Work |
| 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 Type Code Sk
| Description | Indicates the nature of the email address. For example: Personal Work |
| 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 | Indicates the nature of the email address. For example: Personal Work |
| 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 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 |
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 |
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 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 |
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 |
First Nm
| Description | First name of a person. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Full Nm
| Description | The complete name (first, middle, last) for a person. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Name Compound [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Gestation Week Cnt
| Description | The number of weeks after conception the baby was delivered. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Home 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 |
Home Equipment Type Code 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 |
Home 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 |
Home 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 |
Home 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 |
Home 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 |
Home 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 |
Home 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 |
Home 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 |
Home 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 |
Home 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 |
Identity Reliability Cd
| Description | Indicates 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 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 |
Identity Reliability Code Descr
| Description | Indicates 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 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 |
Identity Reliability Code Sk
| Description | Indicates 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 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 |
Identity Reliability Descr
| Description | Indicates 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 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 |
Identity Unknown Ind
| Description | Indicates that the actual identity of patient cannot be determined. |
| 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 |
Immunization Registry Cd
| Description | Identifies 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 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 |
Immunization Registry Code Descr
| Description | Identifies 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 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 |
Immunization Registry Code Dt
| Description | The date upon which the immunization registry status is defined. |
| 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 |
Immunization Registry Code Sk
| Description | Identifies 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 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 |
Immunization Registry Descr
| Description | Identifies 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 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 Contact Dt
| Description | The 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 Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| 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 |
Literacy Cd
| Description | Indicates whether the patient has the ability to understand written correspondence. |
| 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 |
Literacy Code Descr
| Description | Indicates whether the patient has the ability to understand written correspondence. |
| 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 |
Literacy Code Sk
| Description | Indicates whether the patient has the ability to understand written correspondence. |
| 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 |
Literacy Descr
| Description | Indicates whether the patient has the ability to understand written correspondence. |
| 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 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 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 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 Status Cd
| Description | Indicates that the person is still alive. |
| 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 Status Code Descr
| Description | Indicates that the person is still alive. |
| 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 Status Code Sk
| Description | Indicates that the person is still alive. |
| 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 Status Descr
| Description | Indicates that the person is still alive. |
| 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 Will Cd
| Description | Indicates 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 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 Will Code Descr
| Description | Indicates 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 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 Will Code Sk
| Description | Indicates 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 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 Will Descr
| Description | Indicates 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 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 |
Majority Dt
| Description | The 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 Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| 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 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 |
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 |
Medicaid Num
| Description | The Medicaid case number, defined by CMS or other regulatory agencies, which uniquely identifies a patient's Medicaid 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 |
Medical Record Num
| Description | The medical record number (MRN) currently used to identify the patient. |
| 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 |
Medicare Num
| Description | The Medicare case number, defined by CMS or other regulatory agencies, which uniquely identifies a patient's Medicare policy. |
| 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 Branch Cd
| Description | Identifies the Branch of Service for Military personnel. |
| 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 Branch Code Descr
| Description | Identifies the Branch of Service for Military personnel. |
| 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 Branch Code Sk
| Description | Identifies the Branch of Service for Military personnel. |
| 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 Branch Descr
| Description | Identifies the Branch of Service for Military personnel. |
| 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 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 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 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 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 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 |
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 |
Mother Maiden Nm
| Description | The surname before marriage of an individuals mother. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Name Medium [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Multiple Birth Ind
| Description | Indicates whether the baby was a part of a multiple birth. |
| 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 |
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 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 |
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 |
Name Usage Cd
| Description | Indicates how a role player uses a name. For example: Default Mailing Legal DBA Alias |
| 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 Usage Code Descr
| Description | Indicates how a role player uses a name. For example: Default Mailing Legal DBA Alias |
| 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 |
Name Usage Code Sk
| Description | Indicates how a role player uses a name. For example: Default Mailing Legal DBA Alias |
| 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 Usage Descr
| Description | Indicates how a role player uses a name. For example: Default Mailing Legal DBA Alias |
| 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 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 |
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 |
Necropsy Ind
| Description | Indicates whether the baby was delivered deceased. |
| 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 |
Occupation Cd
| Description | The primary reported occupation of a person. |
| 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 |
Occupation Code Descr
| Description | The primary reported occupation of a person. |
| 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 |
Occupation Code Sk
| Description | The primary reported occupation of a person. |
| 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 |
Occupation Descr
| Description | The primary reported occupation of a person. |
| 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 |
Organ Donor Cd
| Description | Indicates 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 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 |
Organ Donor Code Descr
| Description | Indicates 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 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 |
Organ Donor Code Sk
| Description | Indicates 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 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 |
Organ Donor Descr
| Description | Indicates 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 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 |
Patient 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 |
Patient Death Ind
| Description | Indicates if the patient is deceased. |
| 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 |
Patient 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 |
Patient 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 |
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 |
Place Of Worship Descr
| Description | Identifies the patient's place of worship. For example: The First Baptist Church of Atlanta. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Postal Cd
| Description | Zip code and International Postal Code for the address. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Postal Code [VARCHAR(15)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Practitioner 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 |
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 |
Primary Citizenship Country Cd
| Description | Indicates the citizenship 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 |
Primary Citizenship Country Code Descr
| Description | Indicates the citizenship 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 |
Primary Citizenship Country Code Sk
| Description | Indicates the citizenship 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 |
Primary Citizenship Country Descr
| Description | Indicates the citizenship 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 |
Primary Citizenship Tribal Cd
| Description | Indicates a person's tribal affiliation. |
| 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 |
Primary Citizenship Tribal Code Descr
| Description | Indicates a person's tribal affiliation. |
| 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 |
Primary Citizenship Tribal Code Sk
| Description | Indicates a person's tribal affiliation. |
| 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 |
Primary Citizenship Tribal Descr
| Description | Indicates a person's tribal affiliation. |
| 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 |
Primary Ethnicity Cd
| Description | Indicates the individual's ethnic group. |
| 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 |
Primary Ethnicity Code Descr
| Description | Indicates the individual's ethnic group. |
| 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 |
Primary Ethnicity Code Sk
| Description | Indicates the individual's ethnic group. |
| 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 |
Primary Ethnicity Descr
| Description | Indicates the individual's ethnic group. |
| 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 |
Primary Ethnicity Pct
| Description | The percentage an ethnicity contributes to the patient's overall ethnic make-up. |
| 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 |
Primary Language Cd
| Description | Unique coded value for language. |
| 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 |
Primary Language Code 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 |
Primary 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 |
Primary 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 |
Primary Living Dependency Cd
| Description | Indicates 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 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 |
Primary Living Dependency Code Descr
| Description | Indicates 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 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 |
Primary Living Dependency Code Sk
| Description | Indicates 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 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 |
Primary Living Dependency Descr
| Description | Indicates 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 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 |
Primary Patient Race Pct
| Description | The percentage a race contributes to the patient's overall racial make-up. |
| 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 |
Primary Race Cd
| Description | Indicates the race 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 |
Primary Race Code Descr
| Description | Indicates the race 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 |
Primary Race Code Sk
| Description | Indicates the race 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 |
Primary Race Descr
| Description | Indicates the race 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 |
Protection Cd
| Description | Identifies 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 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 |
Protection Code Descr
| Description | Identifies 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 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 |
Protection Code Effective Dt
| Description | The 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 Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Protection Code Sk
| Description | Identifies 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 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 |
Protection Descr
| Description | Identifies 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 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 |
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 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 |
Publicity Code Dt
| Description | The date upon which the patient's publicity level comes into effect. |
| 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 |
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 |
Registration Ts
| Description | The date and time of initial registration for a patient. |
| 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 |
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 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 |
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 |
Separate Bill Cd
| Description | Specifies 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 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 |
Separate Bill Code Descr
| Description | Specifies 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 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 |
Separate Bill Code Sk
| Description | Specifies 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 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 |
Separate Bill Descr
| Description | Specifies 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 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 |
Sex 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 |
Sex Code 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 |
Sex 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 |
Sex 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 |
SMPI Num
| Description | The master patient identifier, a universal identifier assigned by a subscribing facility/system. |
| 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 |
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 Status Cd
| 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/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Student Status Code Descr
| 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/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Student Status Code Sk
| 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/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Student Status Descr
| 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/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Suffix Nm
| Description | A name suffix follows a person's full name and provides additional information about the person. For Example: Jr for Junior MD for Medical Doctor |
| Data Type | Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Tenant Sk
| Description | The surrogate key of the entry identifying the legal owner of the data. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
UMPI Num
| Description | The Universal patient identifier set in Master Data Management (MDM). |
| 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 |
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 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 |
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 |
Work 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 |
Work Equipment Type Code 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 |
Work 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 |
Work 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 |
Work 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 |
Work 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 |
Work 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 |
Work 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 |
Work 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 |
Work 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 |
Work 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 |
| Relationship Details |
Patient Dimension_Person Dimension_FK
| Is Identifying Relationship | false |
| Child Table | Patient 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 |
Patient Dimension PK
| Key Attribute | Patient Dk |
| Dimensional Warehouse Model Data Model |