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. |