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