Table Detail Report
HF_D_MARITAL_STATUS
Column Section | Top of Page |
Table-level Detail
Description: | HF_D_MARITAL_STATUS |
Definition: | This is the HealthFacts dimension table that contains standard values for marital status |
Table Type: | REFERENCE |
Column Detail - HF_D_MARITAL_STATUS
Column Name | Type | Null? | Definition |
---|---|---|---|
MARITAL_STATUS_DESC | VARCHAR(60) | Y | The description for the marital status |
MARITAL_STATUS_ID | DOUBLE | Y | Primary key to the table. Uniquely defines a marital status |
UPDT_DT_TM | DATETIME | Y | The date/time that this record was updated. |
UPDT_TASK | VARCHAR(40) | Y | The application that performed the insert or update on this record. If this was done manually, MANUAL should be entered. |
UPDT_USER | VARCHAR(40) | Y | The user id that performed the update or insert on this record. |
HF_D_MDC
Column Section | Top of Page |
Table-level Detail
Description: | HF_D_MDC |
Definition: | This is that HealthFacts dimension table that contains standard values for CMS MDC's |
Table Type: | REFERENCE |
Column Detail - HF_D_MDC
Column Name | Type | Null? | Definition |
---|---|---|---|
BEG_EFFECTIVE_DT_TM | DATETIME | Y | Date that the MDC value came into use |
END_EFFECTIVE_DT_TM | DATETIME | Y | Date that the MDC value stopped being used |
MDC | VARCHAR(2) | Y | The CMS standard numeric value assigned for a particular MDC |
MDC_DEFINITION | VARCHAR(255) | Y | The full definition of the MDC |
MDC_DESCRIPTION | VARCHAR(45) | Y | A longer description of the MDC |
MDC_DISPLAY | VARCHAR(15) | Y | A short description of the MDC |
MDC_ID | DOUBLE | N | Primary key to the table. Uniquely defines an MDC |
UPDT_DT_TM | DATETIME | Y | The date/time that this record was updated. |
UPDT_TASK | VARCHAR(40) | Y | The application that performed the insert or update on this record. If this was done manually, 'MANUAL' should be entered. |
UPDT_USER | VARCHAR(40) | Y | The user id that performed the update or insert on this record. |
HF_D_MEDICAL_SERVICE
Column Section | Top of Page |
Table-level Detail
Description: | HF_D_MEDICAL_SERVICE |
Definition: | A dimension table that stores the list of medical services. |
Table Type: | REFERENCE |
Column Detail - HF_D_MEDICAL_SERVICE
Column Name | Type | Null? | Definition |
---|---|---|---|
MEDICAL_SERVICE_CODE | VARCHAR(40) | Y | The short abbreviation that represents the medical service (hospital service). Approved values for HL7. |
MEDICAL_SERVICE_DESC | VARCHAR(100) | Y | The description of the medical service (hospital service). Used for HealthSentry and PV1.10. |
MEDICAL_SERVICE_ID | DOUBLE | Y | PRIMARY KEY |
UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated. |
UPDT_TASK | VARCHAR(40) | Y | The registered (assigned) task number for the process that inserted or updated the row. |
UPDT_USER | VARCHAR(40) | Y | The user id that performed the update or insert on this record. |
HF_D_MEDICAL_SPECIALTY
Column Section | Top of Page |
Table-level Detail
Description: | HF_D_MEDICAL_SPECIALTY |
Definition: | This is the HealthFacts dimension table that contains standard values for medical specialty |
Table Type: | REFERENCE |
Column Detail - HF_D_MEDICAL_SPECIALTY
Column Name | Type | Null? | Definition |
---|---|---|---|
CO_DISPLAY | VARCHAR(100) | Y | This is the Critical Outcomes description they want to see in the Critical Outcome Business Objects reports. |
CO_IND | DOUBLE | Y | This is an indicator 0 (no) or 1 (yes) if this is to be used for Critical Outcomes mappings. Some CO values are combinations and HF are separate or vice versa. |
HF_IND | DOUBLE | Y | Indicates if the record was generated via the Health Facts solution. |
MEDICAL_SPECIALTY_DESC | VARCHAR(60) | Y | The description for the medical specialty |
MEDICAL_SPECIALTY_ID | DOUBLE | Y | Primary key to the table. Uniquely defines a medical specialty |
UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated. |
UPDT_TASK | VARCHAR(40) | Y | The registered (assigned) task number for the process that inserted or updated the row. |
UPDT_USER | VARCHAR(40) | Y | The user id that performed the update or insert on this record. |
HF_D_MEDICATION
Column Section | Top of Page |
Table-level Detail
Description: | HF_D_MEDICATION |
Definition: | This Health Facts dimension table contains standard values for Medications. Medications are stored at the NDC grain. |
Table Type: | REFERENCE |
Column Detail - HF_D_MEDICATION
Column Name | Type | Null? | Definition |
---|---|---|---|
BRAND_NAME | VARCHAR(100) | Y | The brand or trade name for a medication. |
DOSE_FORM_DESCRIPTION | VARCHAR(40) | Y | The standard form in which the medication is administered (based on the Multum database). |
GENERIC_NAME | VARCHAR(100) | Y | The generic name for a medication. |
MEDICATION_ID | DOUBLE | Y | Primary key to the table. Uniquely defines a medication. |
NDC_CODE | DOUBLE | Y | The National Drug Classification code. The value does not contain formatting or leading 0's. |
OBSOLETE_DT_TM | DATETIME | Y | Contains the date when an NDC was retired. Not filled out for active NDC codes. |
PRODUCT_STRENGTH_DESCRIPTION | VARCHAR(255) | Y | The standard strength for a medication (based on the Multum database). |
ROUTE_DESCRIPTION | VARCHAR(60) | Y | The standard route of administration for a medication (based on the Multum database) |
UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated. |
UPDT_TASK | VARCHAR(40) | Y | The registered (assigned) task number for the process that inserted or updated the row. |
UPDT_USER | VARCHAR(40) | Y | The user id that performed the update or insert on this record. |