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.