Table Detail Report
HF_D_EVENT_CLASS
Column Section | Top of Page |
Table-level Detail
Description: | HF_D_EVENT_CLASS |
Definition: | HF_D_EVENT_CLASS table |
Table Type: | REFERENCE |
Column Detail - HF_D_EVENT_CLASS
Column Name | Type | Null? | Definition |
---|---|---|---|
EVENT_CLASS_DESC | VARCHAR(60) | Y | The description for the event class |
EVENT_CLASS_ID | DOUBLE | Y | Primary key to the table. Uniquely defines an event class |
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_EVENT_CODE
Column Section | Top of Page |
Table-level Detail
Description: | HF_D_EVENT_CODE |
Definition: | HF_D_EVENT_CODE table |
Table Type: | REFERENCE |
Column Detail - HF_D_EVENT_CODE
Column Name | Type | Null? | Definition |
---|---|---|---|
EVENT_CODE_CATEGORY | VARCHAR(40) | Y | The category of the event code. |
EVENT_CODE_DESC | VARCHAR(60) | Y | The description for the event code |
EVENT_CODE_DISPLAY | VARCHAR(40) | Y | The display value of the event code. |
EVENT_CODE_GROUP | VARCHAR(40) | Y | The group of event codes that the event code belongs to. |
EVENT_CODE_ID | DOUBLE | Y | Primary key to the table. Uniquely defines an event code |
HEALTHAWARE_IND | DOUBLE | Y | Indicates if the record was generated via the HealthAware solution. |
HS_IND | DOUBLE | Y | Indicates if the record was generated via the HealthSentry solution. |
LOINC_CODE | VARCHAR(10) | Y | The LOINC code associated with a foreign file system DTA. |
SNOMED_CODE | VARCHAR(15) | Y | The Health Data assigned SNOMED code if applicable for the event. |
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_EVENT_RELTN
Column Section | Top of Page |
Table-level Detail
Description: | HF_D_EVENT_RELTN |
Definition: | HF_D_EVENT_RELTN table |
Table Type: | REFERENCE |
Column Detail - HF_D_EVENT_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
EVENT_RELTN_DESC | VARCHAR(60) | Y | The description for the event relation |
EVENT_RELTN_ID | DOUBLE | Y | Primary key to the table. Uniquely defines an event relation |
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_EVENT_SOURCE
Column Section | Top of Page |
Table-level Detail
Description: | HF_D_EVENT_SOURCE |
Definition: | HF_D_EVENT_SOURCE table |
Table Type: | REFERENCE |
Column Detail - HF_D_EVENT_SOURCE
Column Name | Type | Null? | Definition |
---|---|---|---|
EVENT_SOURCE_DESC | VARCHAR(60) | Y | The description for the event source |
EVENT_SOURCE_ID | DOUBLE | Y | Primary key to the table. Uniquely defines an event source |
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_FIPS
Column Section | Top of Page |
Table-level Detail
Description: | HF_D_FIPS |
Definition: | BLANK |
Table Type: | REFERENCE |
Column Detail - HF_D_FIPS
Column Name | Type | Null? | Definition |
---|---|---|---|
COUNTY_DESC | VARCHAR(40) | Y | The county of the FIPS |
COUNTY_FIPS_CODE | VARCHAR(10) | Y | The county FIPS code. |
FIPS_CLASS_CODE | VARCHAR(10) | Y | The FIPS class code |
FIPS_ID | DOUBLE | N | PRIMARY KEY |
STATE_FIPS_CODE | VARCHAR(10) | Y | The state code for the FIPS. |
STATE_POST_CODE | VARCHAR(10) | Y | The state postal code for the FIPS. |
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. |