Table Detail Report

HF_D_FORMULARY_TYPE



Column Section Top of Page


Table-level Detail

Description: HF_D_FORMULARY_TYPE
Definition: This is the HealthFacts dimension table that contains standard values for formulary type
Table Type: REFERENCE





Column Detail - HF_D_FORMULARY_TYPE


Column Name Type Null? Definition
FORMULARY_TYPE_CODE VARCHAR(20) Y A short description of the formulary type
FORMULARY_TYPE_DESC VARCHAR(60) Y The description for the formulary type
FORMULARY_TYPE_ID DOUBLE Y Primary key to the table. Uniquely defines a formulary type
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_FREQUENCY



Column Section Top of Page


Table-level Detail

Description: HF_D_FREQUENCY
Definition: This is the HealthFacts dimension table that contains standard values for frequency
Table Type: REFERENCE





Column Detail - HF_D_FREQUENCY


Column Name Type Null? Definition
FREQUENCY_DESC VARCHAR(60) Y The description for the frequency
FREQUENCY_DISP VARCHAR(40) Y The display for the frequency
FREQUENCY_ID DOUBLE Y Primary key to the table. Uniquely defines a frequency
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_GENDER



Column Section Top of Page


Table-level Detail

Description: HF_D_GENDER
Definition: This is the HealthFacts dimension table that contains standard values for gender
Table Type: REFERENCE





Column Detail - HF_D_GENDER


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.
GENDER_DESC VARCHAR(60) Y The description for the gender
GENDER_ID DOUBLE Y Primary key to the table. Uniquely defines a gender
HF_IND DOUBLE Y Indicates if the record was generated via the Health Facts solution.
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_HOSPITAL



Column Section Top of Page


Table-level Detail

Description: health facts dimension hospital
Definition: This is the HealthFacts dimension table that contains HealthFacts recognized hospitals for all health systems
Table Type: REFERENCE





Column Detail - HF_D_HOSPITAL


Column Name Type Null? Definition
ACUTE_IND DOUBLE Y Indicates if the facility is an acute or non-acute care facility
ACUTE_STATUS VARCHAR(20) Y Indicated whether the facility is an acute or non-acute care facility.
ALT_HEALTH_SYSTEM_ID DOUBLE Y The unique Health System Identifier for the alternative hospital.
ALT_HOSPITAL_ID DOUBLE Y The unique identifier for the alternative hospital.
BED_SIZE_RANGE VARCHAR(10) Y Gives the approximate number of beds in a hospital.
CATH_LAB_DIAGNOSTIC_IND DOUBLE Y Indicates whether the facility has a diagnostic Catheterization laboratory
CATH_LAB_FULL_IND DOUBLE Y Indicates whether the facility has a full Catheterization laboratory
CENSUS_DIVISION VARCHAR(40) Y Specifies which of the 9 census divisions (New England, Middle Atlantic, West North Central, East North Central, East South Central, South Atlantic, West South Central, Mountain, Pacific) the facility is located in
CENSUS_REGION VARCHAR(40) Y Specifies which of the four census regions (Northeast, Midwest, South, West) the facility is located in
CLIA_NBR VARCHAR(10) Y The CLIA number associated with the facility
COUNTY_FIPS_CODE VARCHAR(10) Y The FIPS county code is a three-digit Federal Information Processing Standard (FIPS) code (FIPS 6-4) which uniquely identifies counties and county equivalents in the United States, certain U.S. possessions, and certain freely associated states. The first two digits are the FIPS state code and the last three are the county code within the state or possession.
CREATE_PSP_REPORT_IND DOUBLE Y Indicates if the facility should have PSP reports created
DEFAULT_FACILITY_IND DOUBLE Y Indicates that this is the default facility for the hospital.
DIRECTOR_FIRST_NAME VARCHAR(100) Y The first name of the Director of the hospital.
DIRECTOR_LAST_NAME VARCHAR(100) Y The last name of the Director of the hospital.
DIRECTOR_MIDDLE_NAME VARCHAR(100) Y The middle name of the Director of the hospital.
DIRECTOR_PREFIX VARCHAR(10) Y The prefix of the Director of the hospital.
DIRECTOR_SUFFIX VARCHAR(10) Y The suffix of the Director of the hospital.
DIRECTOR_TITLE VARCHAR(10) Y The title of the Director of the hospital.
HEALTHFACTS_IND DOUBLE Y This is an indicator 0 (no) or 1 (yes) if this is to be used for Health Data (Health Facts or HealthSentry) mapping purposes.
HEALTHSENTRY_IND DOUBLE Y This is an indicator 0 (no) or 1 (yes) if this is to be used for Health Data (Health Facts or HealthSentry) mapping purposes.
HEALTH_SYSTEM_ID DOUBLE Y The health system that the hospital belongs to
HOSPITAL_ADDRESS VARCHAR(100) Y Address of the hospital
HOSPITAL_ADDRESS_2 VARCHAR(100) Y The second line of address for the hospital.
HOSPITAL_CALL_INSTRUCTIONS VARCHAR(300) Y The documented instructions for how to contact the hospital.
HOSPITAL_CBSA VARCHAR(25) Y Core Based Statistical Area for the hospital. http://www.zip-codes.com/. Look up the zip code to find the CBSA.
HOSPITAL_CITY VARCHAR(100) Y City of the hospital
HOSPITAL_CODE DOUBLE Y A Millennium identifier for the hospital
HOSPITAL_COUNTRY VARCHAR(100) Y The country in which the hospital resides.
HOSPITAL_COUNTY VARCHAR(100) Y The county in which the hospital resides.
HOSPITAL_DISPLAY VARCHAR(30) Y The display value of the hospital.
HOSPITAL_EXTENSION VARCHAR(100) Y The phone extension for the hospital.
HOSPITAL_ID DOUBLE Y Primary key to the table. Uniquely defines an isolate
HOSPITAL_NAME VARCHAR(255) Y Name of the hospital
HOSPITAL_OID VARCHAR(100) Y The OID of the hospital.
HOSPITAL_PHONE VARCHAR(30) Y Phone number for the hospital
HOSPITAL_STATE VARCHAR(50) Y State of the hospital
HOSPITAL_ZIP VARCHAR(25) Y Zipcode of the hospital
INSTITUTION_REF VARCHAR(40) Y Code value that defines that institution. This field is used in conjunction with Health_System_ID to join activity data to this table.
NPI VARCHAR(10) Y National Provider Identifier (NPI) is a Health Insurance Portability and Accountability Act (HIPAA) Administrative Simplification Standard. The NPI is a unique identification number for covered health care providers.
PERFORM_FACILITY_IND DOUBLE Y Indicates that this is a performing facility for the hospital.
STATE_FIPS_CODE VARCHAR(10) Y The FIPS State code is a two-digit Federal Information Processing Standard (FIPS) code (FIPS 6-4) which uniquely identifies States and State equivalents in the United States, certain U.S. possessions, and certain freely associated states.
TEACHING_FACILITY_IND DOUBLE Y Indicates if the facility is a teaching facility
TOTAL_BEDS DOUBLE Y Number of beds in a hospital. Only populated for HealthSentry
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.
URBAN_RURAL_STATUS VARCHAR(20) Y Urban or rural indicator for this facility. U (Urban), R (Rural)
URBAN_RURAL_STATUS_IND DOUBLE Y Indicates if the facility is in an urban or rural area


HF_D_INTERP_RESULT



Column Section Top of Page


Table-level Detail

Description: HF_D_Interp_Result
Definition: This is the HealthFacts dimension table that contains standard values for interpretative results
Table Type: REFERENCE





Column Detail - HF_D_INTERP_RESULT


Column Name Type Null? Definition
INTERP_RESULT_DESC VARCHAR(60) Y The textual description of an interpretative result
INTERP_RESULT_ID DOUBLE Y A unique non-intelligent identifier for the table
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.