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.