HD_D_GUARANTOR_TYPE



Column Section Top of Page


Table-level Detail

Description: HD_D_GUARANTOR_TYPE
Definition: The guarantor type indicates that the guarantor for the encounter is either a person or an organization. This code is used to determine which set of tables to query to find the guarantor.
Table Type: REFERENCE





Column Detail - HD_D_GUARANTOR_TYPE


Column Name Type Null? Definition
GUARANTOR_TYPE_DESC VARCHAR(100) N The long description for the guarantor type indicating the guarantor for the encounter.
GUARANTOR_TYPE_ID DOUBLE N IDENTIFIER
GUARANTOR_TYPE_NAME VARCHAR(40) N The PHINVADs concept code for the Person Relationship or same as desc field if there isn't a standard code.
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 that performed the update or insert on this record.


HF_D_ADMISSION_SOURCE



Column Section Top of Page


Table-level Detail

Description: HF_D_ADMISSION_SOURCE
Definition: This is the HealthFacts dimension table that contains standard values for admission sources
Table Type: REFERENCE





Column Detail - HF_D_ADMISSION_SOURCE


Column Name Type Null? Definition
ADMISSION_SOURCE_CODE VARCHAR(12) Y The standard code for admission source
ADMISSION_SOURCE_CODE_DESC VARCHAR(60) Y A description of the admission source code.
ADMISSION_SOURCE_ID DOUBLE Y Primary key to the table. Uniquely defines a admission source
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_ADMISSION_TYPE



Column Section Top of Page


Table-level Detail

Description: HF_D_ADMISSION_TYPE
Definition: This is the HealthFacts dimension table that contains standard values for admission types
Table Type: REFERENCE





Column Detail - HF_D_ADMISSION_TYPE


Column Name Type Null? Definition
ADMISSION_TYPE_CODE VARCHAR(2) Y The standard code for admission type
ADMISSION_TYPE_CODE_DESC VARCHAR(60) Y A description of the admission type code.
ADMISSION_TYPE_CONCEPT VARCHAR(10) Y A one character field containing the PHINVads concept identifier for admission type used for HealthSentry HL7.
ADMISSION_TYPE_ID DOUBLE Y Primary key to the table. Uniquely defines a admission type
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_ADMITTING_DIAGNOSIS



Column Section Top of Page


Table-level Detail

Description: HF_D_ADMITTING_DIAGNOSIS
Definition: Contains the distinct list of possible diagnosis for selection during admission diagnosis.
Table Type: REFERENCE





Column Detail - HF_D_ADMITTING_DIAGNOSIS


Column Name Type Null? Definition
ADMITTING_DIAGNOSIS_DESC VARCHAR(255) Y The raw text admitting diagnosis description provided by the clinical system. Not codified at this time.
ADMITTING_DIAGNOSIS_ID DOUBLE Y A unique identifier used to link the admitting_diagnosis dimension table to the hf_f_encounter table.
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_ANTIMICROBIAL



Column Section Top of Page


Table-level Detail

Description: HF_D_Antimicrobial
Definition: This is the HealthFacts dimension table that contains standard values for antimicrobials
Table Type: REFERENCE





Column Detail - HF_D_ANTIMICROBIAL


Column Name Type Null? Definition
ANTIBIOGRAM_CLASS VARCHAR(30) Y A grouping of antimicrobials used by the Antibiogram solution
ANTIBIOGRAM_IND DOUBLE Y Indicates if this antimicrobial is used as a part of the Antibiogram solution
ANTIMICROBIAL_DCODE VARCHAR(6) Y The Multum drug classification code used to associate this antimicrobial to a drug classification
ANTIMICROBIAL_DESC VARCHAR(50) Y The textual description of an antimicrobial
ANTIMICROBIAL_ID DOUBLE Y A unique non-intelligent identifier for the table
ANTIMICROBIAL_MNEMONIC VARCHAR(10) Y A standard (NCLS) abbreviation for an antimicrobial
DRUG_CLASSIFICATION VARCHAR(45) Y The Multum drug classification for this antimicrobial
LOINC_CD VARCHAR(10) Y The LOINC Code ( Character field - not a Millennium code value )
LOINC_CODE VARCHAR(10) Y ** OBSOLETE - see/use column LOINC_CD
LOINC_LONG VARCHAR(255) Y The standard RELMA long description for the LOINC code.
LOINC_SHORT VARCHAR(60) Y The standard RELMA short description for the LOINC code.
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.
URINE_ONLY_IND VARCHAR(1) Y Indicates if this antimicrobial should only be considered in the Antibiogram solution if the isolate source is Urine