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 |