Table Detail Report

HF_D_DISCHG_DISP



Column Section Top of Page


Table-level Detail

Description: HF_D_DISCHG_DISP
Definition: This is the HealthFacts dimension table that contains standard values for discharge dispositions
Table Type: REFERENCE





Column Detail - HF_D_DISCHG_DISP


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.
DISCHG_DISP_CODE DOUBLE Y The UB92 standard value that defines a specific discharge disposition
DISCHG_DISP_CODE_DESC VARCHAR(190) Y The UB92 standard textual description of a discharge disposition
DISCHG_DISP_ID DOUBLE Y A primary key to the table. Uniquely identifies a discharge disposition
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.
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_DISCONTINUE_REASON



Column Section Top of Page


Table-level Detail

Description: HF_D_DISCONTINUE_REASON
Definition: This is the HealthFacts dimension table that contains standard values for discontinue reason
Table Type: REFERENCE





Column Detail - HF_D_DISCONTINUE_REASON


Column Name Type Null? Definition
DISCONTINUE_REASON_CODE VARCHAR(20) Y A short description of the discontinue reason
DISCONTINUE_REASON_DESC VARCHAR(60) Y The description for the discontinue reason
DISCONTINUE_REASON_ID DOUBLE Y Primary key to the table. Uniquely defines a discontinue reason
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_DISPENSE_EVENT_TYPE



Column Section Top of Page


Table-level Detail

Description: HF_D_DISPENSE_EVENT_TYPE
Definition: This is the HealthFacts dimension table that contains standard values for dispense event types
Table Type: REFERENCE





Column Detail - HF_D_DISPENSE_EVENT_TYPE


Column Name Type Null? Definition
DISPENSE_EVENT_TYPE_DESC VARCHAR(60) Y The description of the dispense event type
DISPENSE_EVENT_TYPE_ID DOUBLE N Primary key to 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.


HF_D_DRG



Column Section Top of Page


Table-level Detail

Description: HF_D_DRG
Definition: This is that HealthFacts dimension table that contains standard values for CMS DRG's
Table Type: REFERENCE





Column Detail - HF_D_DRG


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.
CLINICAL_SERVICE_CODE DOUBLE Y A CMS code for the clinical service
DRG VARCHAR(3) Y The CMS standard numeric value assigned for a particular DRG
DRG_DEFINITION VARCHAR(255) Y The full definition of the DRG
DRG_DESCRIPTION VARCHAR(45) Y A longer description of the DRG
DRG_DISPLAY VARCHAR(15) Y A short description of the DRG
DRG_ID DOUBLE N Primary key to the table. Uniquely defines a DRG
DRG_TYPE VARCHAR(10) Y The type of DRG system
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.
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_ETHNICITY



Column Section Top of Page


Table-level Detail

Description: HF_D_ETHNICITY
Definition: Dimension table for ethnicity, a religious, national, racial, or cultural group of persons.
Table Type: REFERENCE





Column Detail - HF_D_ETHNICITY


Column Name Type Null? Definition
ETHNICITY_DESC VARCHAR(60) Y The description of the religious, national, racial, or cultural group of the person.
ETHNICITY_ID DOUBLE Y The Health Data identifier that is unique to the table for ethnicity.
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.