Table Detail Report

HF_D_DATE



Column Section Top of Page


Table-level Detail

Description: HF_D_DATE
Definition: The HealthSentry Date table that contains the parts of the date for the calendar.
Table Type: REFERENCE





Column Detail - HF_D_DATE


Column Name Type Null? Definition
DATE_DT DATETIME Y The date representation.
DATE_DT_TM DATETIME Y ** OBSOLETE -- use column DATE_DT
DATE_ID DOUBLE Y DATE IDENTIFIER
DAY_NUMBER_IN_MONTH DOUBLE Y The day of the month of the date.
DAY_NUMBER_OF_WEEK DOUBLE Y The numeric representation of the day of week of the date.
DAY_OF_WEEK VARCHAR(9) Y The display name of the day of week of the date.
HOLIDAY_IND DOUBLE Y Indicates if the day is a holiday.
MONTH DOUBLE Y The numeric representation of the month of the date.
MONTH_NAME VARCHAR(9) Y The display name of the month of the date.
QUARTER DOUBLE Y The quarter of the date.
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.
WEEKDAY_IND DOUBLE Y Indicates if the day is a weekend.
WEEK_NUMBER_IN_YEAR DOUBLE Y The week number of the date.
YEAR DOUBLE Y The year of the date.


HF_D_DETAIL_TEST_TYPE



Column Section Top of Page


Table-level Detail

Description: HF_D_DETAIL_TEST_TYPE
Definition: This is the HealthFacts dimension table that contains standard values for susceptibility detail test types
Table Type: REFERENCE





Column Detail - HF_D_DETAIL_TEST_TYPE


Column Name Type Null? Definition
DETAIL_TEST_TYPE_DESC VARCHAR(60) Y The description for the susceptibility detail test type. This tells if the susceptibility test was a Blood, CSF, or Urine type test
DETAIL_TEST_TYPE_ID DOUBLE Y Primary key to the table. Uniquely defines a detail test 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_DIAGNOSIS



Column Section Top of Page


Table-level Detail

Description: HF_D_DIAGNOSIS
Definition: This is the HealthFacts dimension table that contains standard values for ICD diagnosis
Table Type: REFERENCE





Column Detail - HF_D_DIAGNOSIS


Column Name Type Null? Definition
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CONDITION_CATEGORY VARCHAR(150) Y A standard diagnosis category to summarize related diagnoses.
DIAGNOSIS_CODE VARCHAR(12) Y The ICD diagnosis code
DIAGNOSIS_DESCRIPTION VARCHAR(255) Y The ICD diagnosis description
DIAGNOSIS_ID DOUBLE Y Primary key to the table. Uniquely defines an ICD diagnosis
DIAGNOSIS_TYPE VARCHAR(50) Y The type of ICD classification.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
HEALTHAWARE_IND DOUBLE Y Indicator signifying if this is used for HealthAware: 0 No and 1 Yes
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_DIAGNOSIS_TYPE



Column Section Top of Page


Table-level Detail

Description: HF_D_DIAGNOSIS_TYPE
Definition: The dimension table for the types of diagnosis.
Table Type: REFERENCE





Column Detail - HF_D_DIAGNOSIS_TYPE


Column Name Type Null? Definition
DIAGNOSIS_TYPE_DISPLAY VARCHAR(60) Y The display value of the diagnosis type.
DIAGNOSIS_TYPE_ID DOUBLE Y PRIMARY KEY
DIAGNOSIS_TYPE_MEANING VARCHAR(12) Y The meaning for the diagnosis type is the same as the display or an abbreviation.
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_DIAGNOSTIC_GROUPING



Column Section Top of Page


Table-level Detail

Description: HF_D_DIAGNOSTIC_GROUPING
Definition: This is the HealthFacts dimension table that contains standard values for diagnostic grouping
Table Type: REFERENCE





Column Detail - HF_D_DIAGNOSTIC_GROUPING


Column Name Type Null? Definition
DIAGNOSTIC_GROUPING_ID DOUBLE Y Primary key to the table. Uniquely defines a diagnostic grouping
DRG_CODE VARCHAR(12) Y The standard code for drg code
DRG_CODE_DESC VARCHAR(255) Y A description of the drg code
DRG_ID DOUBLE N Foreign key pointing to HF_D_DRG table
DRG_TYPE VARCHAR(10) Y The type of DRG system
MDC_CODE VARCHAR(12) Y The standard code for mdc code
MDC_CODE_DESC VARCHAR(255) Y A description of the mdc code.
MDC_ID DOUBLE N Foreign key pointing to HF_D_MDC table
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.