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.