Table Detail Report
HF_D_PSP_DRUG_CLASS
Column Section | Top of Page |
Table-level Detail
Description: | HF_D_PSP_DRUG_CLASS |
Definition: | This is the HealthFacts dimension table that contains standard values for therapeutic classes used in the PSP Rules |
Table Type: | REFERENCE |
Column Detail - HF_D_PSP_DRUG_CLASS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | Indicates if the therapeutic class is active |
ADE_ID | DOUBLE | N | A link to the adverse drug event associated with this therapeutic class |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | Defines when HealthFacts first used this therapeutic class in the PSP rules |
DRUG_CLASS_ID | DOUBLE | N | Primary key to the table. Uniquely identifies a drug therapeutic class (or a drug therapeutic class name pattern) |
DRUG_CLASS_VALUATION_STRING | VARCHAR(2000) | Y | Contains either a therapeutic class name or a pattern describing multiple therapeutic class names |
END_EFFECTIVE_DT_TM | DATETIME | Y | Defines when HealthFacts will discontinue using this therapeutic class in the PSP rules |
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_PSP_TEST
Column Section | Top of Page |
Table-level Detail
Description: | HF_D_PSP_TEST |
Definition: | This is the HealthFacts dimension table that contains standard values for groups of lab procedures checked for by the PSP rules |
Table Type: | REFERENCE |
Column Detail - HF_D_PSP_TEST
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | Indicates if the test is active |
ADE_ID | DOUBLE | N | The adverse drug event this test is associated with |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | Defines when HealthFacts first used this test in the PSP rules |
END_EFFECTIVE_DT_TM | DATETIME | Y | Defines when HealthFacts will discontinue using this test in the PSP rules |
PSP_RULE_GROUP | VARCHAR(25) | Y | The group this test belongs to |
TEST_ID | DOUBLE | N | Primary key to the table. Uniquely identifies a test |
TEST_MNEMONIC | VARCHAR(100) | Y | A short description of the test |
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_RACE
Column Section | Top of Page |
Table-level Detail
Description: | HF_D_RACE |
Definition: | This is the HealthFacts dimension table that contains standard values for race |
Table Type: | REFERENCE |
Column Detail - HF_D_RACE
Column Name | Type | Null? | Definition |
---|---|---|---|
CO_DISPLAY | VARCHAR(100) | Y | This is the Critical Outcomes description they want to see in the Critical Outcome Business Objects reports. |
CO_IND | DOUBLE | Y | This is an indicator 0 (no) or 1 (yes) if this is to be used for Critical Outcomes mappings. Some CO values are combinations and HF are separate or vice versa. |
HF_IND | DOUBLE | Y | Indicates if the record was generated via the Health Facts solution. |
RACE_DESC | VARCHAR(60) | Y | The description for the race |
RACE_ID | DOUBLE | Y | Primary key to the table. Uniquely defines a race |
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_RELEASE
Column Section | Top of Page |
Table-level Detail
Description: | HF_D_RELEASE |
Definition: | BLANK |
Table Type: | REFERENCE |
Column Detail - HF_D_RELEASE
Column Name | Type | Null? | Definition |
---|---|---|---|
RELEASE_BEG_DT_TM | DATETIME | Y | The begin effective date and time of the release. |
RELEASE_END_DT_TM | DATETIME | Y | The end effective date and time of the release. |
RELEASE_ID | DOUBLE | Y | PRIMARY KEY |
RELEASE_NUMBER | VARCHAR(255) | Y | The identifying number of the release. The release numbers are about a month behind the actual month to match the ONC website information. |
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_RELIGION
Column Section | Top of Page |
Table-level Detail
Description: | HF_D_RELIGION |
Definition: | Dimension table of the list of religions |
Table Type: | REFERENCE |
Column Detail - HF_D_RELIGION
Column Name | Type | Null? | Definition |
---|---|---|---|
RELIGION_CODE | VARCHAR(10) | Y | The PHINVADs concept code for religion. |
RELIGION_DESC | VARCHAR(120) | Y | The description of the person's religion. |
RELIGION_ID | DOUBLE | Y | PRIMARY KEY |
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. |