Table Detail Report

HF_R_ORDERS



Column Section Top of Page


Table-level Detail

Description: HF_R_Orders
Definition: This table is used to facilitate in the creation of the Health Sentry orders BO report
Table Type: REFERENCE





Column Detail - HF_R_ORDERS


Column Name Type Null? Definition
DISCHARGED_DT_TM DATETIME Y The discharge date of the encounter associated with this record
ENCOUNTER_ID DOUBLE N The visit identifier for the encounter
HEALTH_SYSTEM_ID DOUBLE N The health system that the hospital belongs to
HOSPITAL_ID DOUBLE N The dim table key for the hospital that this record's encounter is attached to
HOSPITAL_NAME VARCHAR(50) Y Name of the hospital
ORDERED_DT_TM DATETIME Y The date/time an order was placed
ORDERED_MONTH_NAME VARCHAR(9) Y The month represented as text
ORDERED_YEAR DOUBLE Y The 4 digit year of the date
ORDER_LAB_PROCEDURE_GROUP VARCHAR(60) Y The lab procedure group can be used to find all related tests
ORDER_LAB_PROCEDURE_NAME VARCHAR(100) Y Full name of a laboratory test
ORDER_LAB_SUPER_GROUP VARCHAR(25) Y A high level group relating lab procedures together
ORG_ENCOUNTER_NBR DOUBLE Y The encounter identifier from the source system
PARTITION_DT_TM DATETIME Y Indicates which partition of the table this record is in. Matches the partition date/time of the parent encounter
PATIENT_ID DOUBLE N The patient unique identifier used within the Cerner Health Facts Data Warehouse.
RESULT_SOURCE VARCHAR(15) Y Indicates if the order was from General Lab or Microbiology


HF_R_SYNDROMIC



Column Section Top of Page


Table-level Detail

Description: HF_R_SYNDROMIC
Definition: BLANK
Table Type: REFERENCE





Column Detail - HF_R_SYNDROMIC


Column Name Type Null? Definition
ADMISSION_REASON VARCHAR(255) Y If the person was admitted as Inpatient particularly from the emergency room, this is the physician textual reason for admission.
ADMISSION_SOURCE_CODE VARCHAR(12) Y The mapped admission source PHINVads concept value.
ADMISSION_SOURCE_CODE_DESC VARCHAR(60) Y The mapped admission source PHINVads concept description.
ADMISSION_TYPE_CODE_DESC VARCHAR(60) Y The mapped admission type PHINVads concept description.
ADMISSION_TYPE_CONCEPT VARCHAR(10) Y The mapped admission type PHINVads concept value.
ADMITTED_TO_ER_IND DOUBLE Y Not valid any longer. This is a flag that says if the visit came through the Emergency room: 1 is yes, 0 is no, and blank is unknown.
ADMITTING_DIAGNOSIS_1_DESC VARCHAR(255) Y Free text admitting diagnosis 1 from the encounter.
ADMITTING_DIAGNOSIS_2_DESC VARCHAR(255) Y Free text admitting diagnosis 2 from the encounter.
ADMITTING_DIAGNOSIS_3_DESC VARCHAR(255) Y Free text admitting diagnosis 3 from the encounter.
ADMIT_DIAGNOSIS_DESC VARCHAR(2000) Y A list of codified admitting diagnoses from the diagnosis table. This text field contains the codes and descriptions separated by a delimiter if there are more than one.
ADMIT_DIAGNOSIS_DT_TM_TXT VARCHAR(2000) Y The dates for the admitting diagnoses from the diagnosis table.
ADMIT_DIAG_DTTM_ICD10 VARCHAR(2000) Y Admitting diagnosis date times for the ICD-10 codes.
ADMIT_DIAG_ICD10 VARCHAR(2000) Y ICD-10 diagnosis codes and descriptions for admitting diagnoses separated by delimiters.
ADMIT_DT_TM DATETIME Y The date in which the patient was registered.
ADMIT_PHSYICIAN_NAME VARCHAR(100) Y The admitting physician's name.
ADMIT_PHYSICIAN_ADDRESS VARCHAR(100) Y The admitting physician's address.
ADMIT_PHYSICIAN_CITY VARCHAR(100) Y The admitting physician's city.
ADMIT_PHYSICIAN_COUNTRY VARCHAR(100) Y The admitting physician's country.
ADMIT_PHYSICIAN_COUNTY VARCHAR(100) Y The admitting physician's county.
ADMIT_PHYSICIAN_EMAIL VARCHAR(100) Y The email of the admitting physician.
ADMIT_PHYSICIAN_EXTENSION VARCHAR(100) Y The admitting physician's phone extension.
ADMIT_PHYSICIAN_FAX VARCHAR(50) Y The fax number of the admitting physician.
ADMIT_PHYSICIAN_FIRST_NAME VARCHAR(100) Y The admitting physician first name.
ADMIT_PHYSICIAN_INITIALS VARCHAR(100) Y The admitting physician name initials.
ADMIT_PHYSICIAN_LAST_NAME VARCHAR(100) Y The admitting physician first name.
ADMIT_PHYSICIAN_MIDDLE_NAME VARCHAR(100) Y The admitting physician middle name.
ADMIT_PHYSICIAN_MOBILE VARCHAR(100) Y The mobile phone number of the admitting physician.
ADMIT_PHYSICIAN_NPI VARCHAR(200) Y The admitting physician NPI.
ADMIT_PHYSICIAN_PHONE VARCHAR(30) Y The admitting physician's primary phone number.
ADMIT_PHYSICIAN_PREFIX VARCHAR(100) Y The admitting physician name prefix.
ADMIT_PHYSICIAN_STATE VARCHAR(100) Y The admitting physician's state.
ADMIT_PHYSICIAN_SUFFIX VARCHAR(100) Y The admitting physician name suffix.
ADMIT_PHYSICIAN_TITLE VARCHAR(100) Y The admitting physician name title.
ADMIT_PHYSICIAN_ZIP_CODE VARCHAR(25) Y The zip code of the admitting physician.
ADMIT_TM_ZN DOUBLE Y The time zone in which the admission occurred.
AD_PHYSICIAN_CALL_INSTRUCTIONS VARCHAR(300) Y Text field to be used to indicate any specific protocol or instructions to be followed when calling the admitting physician's number.
AGE_IN_MONTHS DOUBLE Y The age represent in months if the person if less than 2 years old.
AGE_IN_YEARS DOUBLE Y The age in years of the patient at time of registration.
ARRIVAL_MODE_CODE VARCHAR(10) Y Admit mode code which identifies the method by which the patient arrived. (i.e., helicopter, ambulance, etc.)
ARRIVAL_MODE_DESC VARCHAR(100) Y Admit mode description which identifies the method by which the patient arrived. (i.e., helicopter, ambulance, etc.)
ATTEND_PHYSICIAN_ADDRESS VARCHAR(100) Y The address of the attending physician.
ATTEND_PHYSICIAN_CITY VARCHAR(100) Y The city of the attending physician.
ATTEND_PHYSICIAN_COUNTRY VARCHAR(100) Y The attending physician's country.
ATTEND_PHYSICIAN_COUNTY VARCHAR(100) Y The attending physician's county.
ATTEND_PHYSICIAN_EMAIL VARCHAR(100) Y The email of the attending physician.
ATTEND_PHYSICIAN_EXTENSION VARCHAR(100) Y The attending physician's phone extension.
ATTEND_PHYSICIAN_FAX VARCHAR(50) Y The fax number of the attending physician.
ATTEND_PHYSICIAN_FIRST_NAME VARCHAR(100) Y The attending physician first name.
ATTEND_PHYSICIAN_INITIALS VARCHAR(100) Y The attending physician name initials.
ATTEND_PHYSICIAN_LAST_NAME VARCHAR(100) Y The attending physician last name.
ATTEND_PHYSICIAN_MIDDLE_NAME VARCHAR(100) Y The attending physician middle name.
ATTEND_PHYSICIAN_MOBILE VARCHAR(100) Y The mobile phone number of the attending physician.
ATTEND_PHYSICIAN_NAME VARCHAR(100) Y The name of the attending physician.
ATTEND_PHYSICIAN_NPI VARCHAR(200) Y The attending physician NPI.
ATTEND_PHYSICIAN_PHONE VARCHAR(30) Y The primary phone number of the attending physician.
ATTEND_PHYSICIAN_PREFIX VARCHAR(100) Y The attending physician name prefix.
ATTEND_PHYSICIAN_STATE VARCHAR(100) Y The State of the attending physician.
ATTEND_PHYSICIAN_SUFFIX VARCHAR(100) Y The attending physician name suffix.
ATTEND_PHYSICIAN_TITLE VARCHAR(100) Y The attending physician name title.
ATTEND_PHYSICIAN_ZIP_CODE VARCHAR(25) Y The zip code of the attending physician.
AT_PHYSICIAN_CALL_INSTRUCTIONS VARCHAR(300) Y Text field to be used to indicate any specific protocol or instructions to be followed when calling the attending physician's number.
BIRTH_DT_TM DATETIME Y The patient's birth date.
CARESETTING_DESC VARCHAR(40) Y The mapped caresetting for the admitting location.
CHIEF_COMPLAINT_CODE_TXT VARCHAR(2000) Y Some chief complaints have code field.
CHIEF_COMPLAINT_TXT VARCHAR(255) Y A free text field that should contain the persons point of view of why they presented for this visit.
CHIEF_COMPLAINT_VERF_DT_TM DATETIME Y The clinical event verified date for chief complaint being entered.
CLIA_NBR VARCHAR(10) Y The admitting hospital CLIA number.
CLINICAL_IMPRESSION_TXT VARCHAR(255) Y A free text field containing the clinical impression which are the physicians additional impressions not captured per other diagnostic fields.
COUNTY_FIPS_CODE VARCHAR(10) Y The ordering hospital three digit county FIPS code.
CPT_PROCEDURE_CODE VARCHAR(2000) Y If there are CPT procedures, this field contains the procedure codes separated by a delimiter.
CPT_PROCEDURE_DESC VARCHAR(2000) Y If there are CPT procedures, this field contains the procedure descriptions separated by a delimiter.
CPT_PROCEDURE_DT_TM_TXT VARCHAR(2000) Y If there are CPT procedures, this field contains the procedure date times separated by a delimiter.
DECEASED_DT_TM DATETIME Y The person's date of death.
DISCHARGED_DT_TM DATETIME Y The patient's medical record number.
DISCHARGE_DIAGNOSIS_DESC VARCHAR(2000) Y The codes and descriptions for the discharge ICD-9 diagnoses separated by delimiters.
DISCHARGE_DIAGNOSIS_DT_TM_TXT VARCHAR(2000) Y The date and time for the discharge ICD-9 diagnoses separated by delimiters.
DISCHARGE_DIAG_DTTM_ICD10 VARCHAR(2000) Y Discharge diagnosis date times for the ICD-10 codes.
DISCHARGE_DIAG_ICD10 VARCHAR(2000) Y ICD-10 diagnosis codes and descriptions for discharge diagnoses separated by delimiters.
DISCHARGE_DISP_DESC VARCHAR(190) Y The mapped description for discharge disposition.
DISCHG_DISP_CODE DOUBLE Y The standard code for the discharge disposition.
ENCOUNTER_ID DOUBLE Y The encounter unique identifier used within the Cerner Health Facts Data Warehouse. This is the visit identifier for the patient that this record is associated. This number is unique to the patient.
ETHNICITY VARCHAR(40) Y The mapped ethnicity for the person. Identifies a religious national racial or cultural group of the person.
EXTRACT_DT_TM DATETIME Y The date and time of the contributor extraction of data.
FINAL_DIAGNOSIS_DESC VARCHAR(2000) Y The ICD-9 final diagnosis codes and descriptions separated by delimiters.
FINAL_DIAGNOSIS_DT_TM_TXT VARCHAR(2000) Y The ICD-9 final diagnosis date/times separated by delimiters.
FINAL_DIAG_DTTM_ICD10 VARCHAR(2000) Y Final diagnosis date times for the ICD-10 codes.
FINAL_DIAG_ICD10 VARCHAR(2000) Y ICD-10 diagnosis codes and descriptions for final diagnoses separated by delimiters.
FINANCIAL_NBR VARCHAR(40) Y This number identifies the encounter or visit typically for financial and medical record identification. This financial number should be unique per encounter and crosses clinical and billing systems.
FINANCIAL_NBR_RAW VARCHAR(40) Y This unformatted number identifies the encounter or visit typically for financial and medical record identification. This financial number should be unique per encounter and crosses clinical and billing systems.
GENDER VARCHAR(60) Y The gender of the patient.
HEALTH_SYSTEM_ID DOUBLE Y The health system that the hospital belongs to.
HEIGHT DOUBLE Y Height value from clinical events.
HEIGHT_TYPE VARCHAR(60) Y The mapped type of height such as Height, Height Estimated, Height Measured.
HEIGHT_UNIT_DESC VARCHAR(60) Y The mapped long description for the height unit of measurement.
HEIGHT_UNIT_DISPLAY VARCHAR(60) Y The abbreviation or short display of the mapped unit. UCUM abbreviation.
HEIGHT_UNIT_UCUM VARCHAR(250) Y The standard UCUM description for the person's initial height unit of measure.
HOSPITAL_ADDRESS VARCHAR(100) Y The address of the hospital as defined by HealthSentry.
HOSPITAL_CITY VARCHAR(50) Y The city of the hospital as defined by HealthSentry.
HOSPITAL_CODE DOUBLE Y The hospital code.
HOSPITAL_DISPLAY VARCHAR(30) Y The display value of the hospital name.
HOSPITAL_ID DOUBLE Y The unique identifier of the hospital from the hf_d_hospital. Assigned per the organization roll up for the ordering facility.
HOSPITAL_NAME VARCHAR(50) Y The name of the admitting hospital as defined by HealthSentry.
HOSPITAL_OID VARCHAR(100) Y The OID (HL7 Object Identifier) for the facility. http://www.hl7.org/oid/index.cfm
HOSPITAL_PHONE VARCHAR(30) Y The primary phone number of the hospital as defined by HealthSentry.
HOSPITAL_STATE VARCHAR(2) Y The state of the hospital as defined by HealthSentry.
HOSPITAL_UNIT_ID VARCHAR(40) Y The Health Data internal ID from hf_d_caresetting for the admitting nursing unit location.
HOSPITAL_ZIP VARCHAR(25) Y The zip code of the hospital as defined by HealthSentry.
INITIAL_DIASTOLIC_BP_VALUE DOUBLE Y The initial diastolic blood pressure value.
INITIAL_ED_ACUITY_TXT VARCHAR(255) Y A free text field from clinical events describing the ED Acuity.
INITIAL_PULSE_OXIMETRY_VALUE DOUBLE Y The initial pulse oximetry value.
INITIAL_PULSE_OX_UNIT_DESC VARCHAR(60) Y The unit of measure long description for the initial pulse oximetry.
INITIAL_PULSE_OX_UNIT_DISPLAY VARCHAR(60) Y The unit of measure display abbreviation for the initial pulse oximetry or SPO2.
INITIAL_PULSE_OX_UNIT_UCUM VARCHAR(250) Y The standard UCUM description for the initial pulse oximetry unit of measure.
INITIAL_SYSTOLIC_BP_VALUE DOUBLE Y The initial systolic blood pressure value.
INITIAL_TEMPERATURE_UNIT_DESC VARCHAR(60) Y The unit of measure long description for the initial temperature.
INITIAL_TEMPERATURE_VALUE DOUBLE Y The initial temperature value.
INITIAL_TEMP_UNIT_DISPLAY VARCHAR(60) Y The unit of measure display abbreviation for the initial temperature.
INITIAL_TEMP_UNIT_UCUM VARCHAR(250) Y The standard UCUM description for the person's initial temperature unit of measure.
MAPPED_PAYER_CODE_DESC VARCHAR(100) Y The insurance payer two digit character code per PHINVads.
MEDICAL_RECORD_NBR VARCHAR(40) Y The patient's medical record number.
MEDICAL_RECORD_NBR_RAW VARCHAR(40) Y The unformatted patient medical record number.
MEDICAL_SERVICE_CODE VARCHAR(40) Y A PHINVads standard abbreviation for the type of medical service for the visit.
MEDICAL_SERVICE_DESC VARCHAR(100) Y A PHINVads standard description for the type of medical service for the visit.
MEDICAL_SERVICE_ID DOUBLE Y The unique identifier for the type or category of medical service that was received.
MOBILE_NUMBER VARCHAR(100) Y The mobile phone number of the patient.
MSG_FLG DOUBLE Y Each synodromic message is an A01, A03, A04 or A08. This field has a 1, 3, 4 or 8 denoting the trigger reason for the message.
NEXT_OF_KIN_ADDRESS_1 VARCHAR(100) Y The patient's next of kin's address.
NEXT_OF_KIN_ADDRESS_2 VARCHAR(100) Y The patient's next of kin's address.
NEXT_OF_KIN_CITY VARCHAR(100) Y The patient's next of kin's city.
NEXT_OF_KIN_FIRST_NAME VARCHAR(40) Y The patient's next of kin's first name.
NEXT_OF_KIN_LAST_NAME VARCHAR(100) Y The patient's next of kin's last name.
NEXT_OF_KIN_MIDDLE_NAME VARCHAR(40) Y The patient's next of kin's middle name.
NEXT_OF_KIN_NAME VARCHAR(100) Y The patient's next of kin's name.
NEXT_OF_KIN_PHONE VARCHAR(30) Y The patient's next of kin's primary phone number.
NEXT_OF_KIN_RELATION VARCHAR(40) Y The relation of the next of kin to the patient.
NEXT_OF_KIN_RELATION_CODE VARCHAR(40) Y The mapped person relationship for the next of kin.
NEXT_OF_KIN_STATE VARCHAR(50) Y The patient's next of kin's state.
NEXT_OF_KIN_ZIP_CODE VARCHAR(25) Y The patient's next of kin's zip code.
NPI VARCHAR(10) Y The NPI for the admit hospital.
ONSET_DT_TM DATETIME Y The chief complaint on set date.
ORG_ENCOUNTER_NBR DOUBLE Y The encounter identifier from the source system.
OUTBOUND_HSS_ID DOUBLE Y The unique identifier of the organization that this result will be reported to.
PATIENT_ADDRESS_1 VARCHAR(100) Y The first line of the patient's address.
PATIENT_ADDRESS_2 VARCHAR(100) Y The second line of the patient's address.
PATIENT_CITY VARCHAR(100) Y The city that the patient lives in.
PATIENT_COUNTRY VARCHAR(50) Y The country that the patient lives in.
PATIENT_COUNTRY_CODE VARCHAR(10) Y The patient's country standard PHINVads code.
PATIENT_COUNTY VARCHAR(50) Y The county that the patient lives in.
PATIENT_COUNTY_CODE VARCHAR(40) Y The county code that the patient lives in.
PATIENT_FIRST_NAME VARCHAR(40) Y The first name of the patient.
PATIENT_ID DOUBLE Y The unformatted patient medical record number.
PATIENT_LAST_NAME VARCHAR(100) Y The last name of the patient.
PATIENT_MIDDLE_NAME VARCHAR(40) Y The middle name of the patient.
PATIENT_NAME VARCHAR(100) Y The full name of the patient.
PATIENT_PHONE VARCHAR(40) Y The primary phone number of the patient.
PATIENT_SSN VARCHAR(40) Y The social security number of the patient.
PATIENT_STATE VARCHAR(50) Y The state that the patient lives in.
PATIENT_STATE_CODE VARCHAR(10) Y If the person State is populate, this is a State FIPS code.
PATIENT_TYPE_DESC VARCHAR(60) Y The mapped visit type for the encounter.
PATIENT_ZIP_CODE VARCHAR(25) Y The zip code that the patient lives in.
PAYER_SOURCE_DESC VARCHAR(100) Y The mapped payer (insurance) description.
PHIN_CARESETTING_CODE VARCHAR(10) Y The PHINVads code for the type of care given at the admitting nursing unit.
PHIN_CARESETTING_DESC VARCHAR(100) Y The PHINVads description for the type of care given at the admitting nursing unit.
PREGNANCY_STATUS VARCHAR(255) Y Pregnancy status from clinical event.
PREGNANCY_STATUS_SNOMED VARCHAR(20) Y The SNOMED code for the patient's pregnancy status.
PROBLEM_CODE_LIST VARCHAR(2000) Y The SNOMED, ICD9 or ICD10 codes related to the problem list diagnoses.
PROBLEM_LIST VARCHAR(2000) Y The problem list are diagnoses that are at the person level and unresolved such as chronic conditions. These are not visit related. Problems are often SNOMED but can be ICD9 or 10 as well.
PROCEDURE_CODE VARCHAR(2000) Y If there are ICD-9 procedures, this field contains the procedure codes separated by a delimiter.
PROCEDURE_CODE_ICD10 VARCHAR(2000) Y ICD-10 procedure codes separated by delimiters.
PROCEDURE_DESC VARCHAR(2000) Y If there are ICD-9 procedures, this field contains the procedure descriptions separated by a delimiter.
PROCEDURE_DESC_ICD10 VARCHAR(2000) Y ICD-10 procedure descriptions separated by delimiters.
PROCEDURE_DT_TM_ICD10 VARCHAR(2000) Y Procedure date times for the ICD-10 codes.
PROCEDURE_DT_TM_TXT VARCHAR(2000) Y If there are ICD-9 procedures, this field contains the procedure date times separated by a delimiter.
RACE VARCHAR(40) Y The mapped race for the person.
RAW_FACILITY_ADDRESS VARCHAR(100) Y The first address for the raw ordering facility.
RAW_FACILITY_ADDRESS_2 VARCHAR(100) Y The second address for the raw facility.
RAW_FACILITY_ADDRESS_3 VARCHAR(100) Y The third address for the raw facility.
RAW_FACILITY_ADDRESS_4 VARCHAR(100) Y The fourth address for the raw facility.
RAW_FACILITY_CITY VARCHAR(100) Y The raw ordering facility city.
RAW_FACILITY_NAME VARCHAR(100) Y The raw ordering facility client description.
RAW_FACILITY_STATE VARCHAR(50) Y The raw ordering facility state.
RAW_FACILITY_ZIP_CODE VARCHAR(25) Y The raw ordering facility zip code.
REASON_FOR_VISIT_CODE_DESC VARCHAR(500) Y The ICD-9 diagnosis code descriptions if reason for visit came from the diagnosis table.
REASON_FOR_VISIT_DT_TM DATETIME Y The ICD-9 reason for visit diagnosis date/times separated by delimiters.
REASON_FOR_VISIT_TXT VARCHAR(255) Y A free text field from the encounter table for the reason for visit.
RELEASE_NUMBER VARCHAR(255) Y The Health Data release number based on the date of this records update date.
SMOKING_STATUS VARCHAR(255) Y The mapped smoking status from clinical event.
STATE_FIPS_CODE VARCHAR(10) Y The ordering hospital two digit state FIPS code.
SYN_REPORT_DT_TM DATETIME Y The date and time associated to the event trigger.
TEMPERATURE_ROUTE VARCHAR(255) Y If there is an initial temperature, this field specifies if it came from a Temperature (Route Not Specified), Temperature Oral, Temperature Skin or other route.
TRANSPORT_MODE_TXT VARCHAR(255) Y A free text field from clinical events describing the mode of transportation to the facility.
TRIAGE_NOTES_TXT VARCHAR(255) Y A free text field containing triage notes which are usually additional nursing notes and documentation.
TRIAGE_NOTES_VERF_DT_TM DATETIME Y The clinical event verified date for triage notes being entered.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated.
WEIGHT DOUBLE Y The weight from clinical events.
WEIGHT_TYPE VARCHAR(60) Y HealthSentry weight name such as Weight, Weight Admit, Weight Pounds.
WEIGHT_UNIT_DESC VARCHAR(60) Y The mapped long description for the weight unit of measurement.
WEIGHT_UNIT_DISPLAY VARCHAR(40) Y The unit for weight from clinical events.
WEIGHT_UNIT_UCUM VARCHAR(250) Y The standard UCUM description for the person's initial weight unit of measure.
WORKING_DIAGNOSIS_DESC VARCHAR(2000) Y The ICD-9 working diagnosis codes and descriptions separated by delimiters.
WORKING_DIAGNOSIS_DT_TM_TXT VARCHAR(2000) Y The ICD-9 working diagnosis date/times separated by delimiters.
WORKING_DIAG_DTTM_ICD10 VARCHAR(2000) Y Working diagnosis date times for the ICD-10 codes.
WORKING_DIAG_ICD10 VARCHAR(2000) Y ICD-10 diagnosis codes and descriptions for working diagnoses separated by delimiters.


WH_OTH_XREF_RULES



Column Section Top of Page


Table-level Detail

Description: WH_OTH_XREF_RULES
Definition: Rule table which drives the Health Data Mapping Tool and ETL process.
Table Type: REFERENCE





Column Detail - WH_OTH_XREF_RULES


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
CLIENT_CODE_SET VARCHAR(20) Y Client code set that is to be mapped
CLIENT_TABLE_NAME VARCHAR(30) Y Client table name containing the value to be mapped.
CONDITIONS VARCHAR(2000) Y Contains additional logic required to return a subset of available values for mapping.
DESC1_DIM_FIELD VARCHAR(30) Y Field Name of the dimension description 1
DESC2_DIM_FIELD VARCHAR(30) Y Field Name of the dimension description 2
DESC3_DIM_FIELD VARCHAR(30) Y Field Name of the dimension description 3
DESC4_DIM_FIELD VARCHAR(30) Y Field Name of the Dimension description 4
DESC5_DIM_FIELD VARCHAR(30) Y Field Name of the Dimension description 5
DESC6_DIM_FIELD VARCHAR(30) Y Field Name of the Dimension description 6
DIMENSION_TABLE_NAME VARCHAR(30) Y Client table name containing the value to be mapped.
GROUP_FIELD VARCHAR(30) Y Secondary column name identifier
GROUP_MEANING VARCHAR(45) Y Secondary subject area identifier
GROUP_TABLE_NAME VARCHAR(30) Y Secondary name identifier
GROUP_VALUE VARCHAR(40) Y Secondary code set identifier
KEY_DIM_FIELD VARCHAR(30) Y Field Name of the dimension identifier
RULE_ID DOUBLE Y Unique generated number that identifies a single row on the wh_oth_xref_rules table.
RULE_NAME VARCHAR(50) Y Name of the mapping rule.
SRC_ALIAS_FIELD VARCHAR(30) Y Client column name containing the value to be mapped.
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.
XREF_TYPE_FLG DOUBLE Y Identifies the type of mapping required. 1 = Reference value mapping, 2 = Activity value mapping, 3 = Activity/Reference value mapping


WH_OTH_XREF_WORK



Column Section Top of Page


Table-level Detail

Description: WH OTH XREF WORK
Definition: Work table containing all possible values to be mapped by the Health Data Mapping Tool.
Table Type: REFERENCE





Column Detail - WH_OTH_XREF_WORK


Column Name Type Null? Definition
APPROVAL_STATUS VARCHAR(50) Y Approval status of the xref row. A = Approved, R = Rejected
CLIENT_CODE_SET VARCHAR(20) Y Client code set to be mapped.
CLIENT_TABLE_NAME VARCHAR(30) Y Client table name containing the value to be mapped.
CLIENT_VALUE_REF VARCHAR(100) Y Client value to be mapped.
DESC1 VARCHAR(255) Y Dimension description 1
DESC2 VARCHAR(255) Y Dimension description 2
DESC3 VARCHAR(255) Y Dimension description 3
DESC4 VARCHAR(255) Y Dimension description 4
DIMENSION_KEY DOUBLE Y Dimension identifier
DIMENSION_MEANING VARCHAR(50) Y Subject area name of the dimension being mapped.
HEALTH_SYSTEM_SOURCE_ID DOUBLE Y Unique number assigned by Health Facts. Typically the universal Cerner assigned client id of the sending health system, but may be adjusted if there is >1 HF feed from the client.
MAPPING_STATUS VARCHAR(50) Y Mapping status of the row. N = New value, C = Changed value
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.
XREF_WORK_KEY DOUBLE Y Unique generated number that identifies a singgle row on the wh_oth_xref_work table.


WH_WRK_FCT_CE_MICRO



Column Section Top of Page


Table-level Detail

Description: WH_WRK_FCT_CE_MICRO
Definition: This is a Health Sentry Work table for processing clinical events for microbiology.
Table Type: REFERENCE





Column Detail - WH_WRK_FCT_CE_MICRO


Column Name Type Null? Definition
ABNORMAL_IND DOUBLE Y ABNORMAL_IND field
ACCESSION VARCHAR(100) Y ACCESSION field
CANCELED_DT_TM DATETIME Y CANCELED_DT_TM field
CANCELED_TM_ZN DOUBLE Y CANCELED_TM_ZN field
CANCEL_TM_VLD_FLG DOUBLE Y If the time stamp received for this date is valid, then 1, Else 0. If the time stamp is invalid, the time of 00:00 is placed in the date/time field. If the sending system puts a time of 00:00 in the time field for invalid times, and they know the difference between this scenario and an actual time of midnight, those times should be flagged as invalid. 0 = Invalid Time Stamp; 1 = Valid Time Stamp
COMPLETED_DT_TM DATETIME Y COMPLETED_DT_TM field
COMPLETED_TM_VLD_FLG DOUBLE Y If the time stamp received for this date is valid, then 1, Else 0. If the time stamp is invalid, the time of 00:00 is placed in the date/time field. If the sending system puts a time of 00:00 in the time field for invalid times, and they know the difference between this scenario and an actual time of midnight, those times should be flagged as invalid. 0 = Invalid Time Stamp; 1 = Valid Time Stamp
COMPLETED_TM_ZN DOUBLE Y COMPLETED_TM_ZN field
DEPT_STATUS_REF VARCHAR(40) Y DEPT_STATUS_REF field
DISCH_DT_TM DATETIME Y DISCH_DT_TM field
FALSE_POSITIVE_IND DOUBLE Y FALSE_POSITIVE_IND field
FIRST_CTNR_COLL_METHOD_REF VARCHAR(40) Y FIRST_CTNR_COLL_METHOD_REF field
FIRST_CTNR_DRAWN_DT_TM DATETIME Y FIRST_CTNR_DRAWN_DT_TM field
FIRST_CTNR_DRAWN_TM_VLD_FLG DOUBLE Y If the time stamp received for this date is valid, then 1, Else 0. If the time stamp is invalid, the time of 00:00 is placed in the date/time field. If the sending system puts a time of 00:00 in the time field for invalid times, and they know the difference between this scenario and an actual time of midnight, those times should be flagged as invalid. 0 = Invalid Time Stamp; 1 = Valid Time Stamp
FIRST_CTNR_DRAWN_TM_ZN DOUBLE Y FIRST_CTNR_DRAWN_TM_ZN field
FIRST_CTNR_RECEIVED_DT_TM DATETIME Y FIRST_CTNR_RECEIVED_DT_TM field
FIRST_CTNR_RECEIVED_TM_VLD_FLG DOUBLE Y If the time stamp received for this date is valid, then 1, Else 0. If the time stamp is invalid, the time of 00:00 is placed in the date/time field. If the sending system puts a time of 00:00 in the time field for invalid times, and they know the difference between this scenario and an actual time of midnight, those times should be flagged as invalid. 0 = Invalid Time Stamp; 1 = Valid Time Stamp
FIRST_CTNR_RECEIVED_TM_ZN DOUBLE Y FIRST_CTNR_RECEIVED_TM_ZN field
FIRST_OBSERVED_DT_TM DATETIME Y FIRST_OBSERVED_DT_TM field
FIRST_SPECIMEN_SITE_REF VARCHAR(40) Y FIRST_SPECIMEN_SITE_REF field
FIRST_SPECIMEN_TYPE_REF VARCHAR(40) Y FIRST_SPECIMEN_TYPE_REF field
FRST_PERF_SVC_RES_DEPT_HIER_SK VARCHAR(40) Y FRST_PERF_SVC_RES_DEPT_HIER_SK field
HEALTH_SYSTEM_ID DOUBLE Y HEALTH_SYSTEM_ID field
HEALTH_SYSTEM_SOURCE_ID DOUBLE Y HEALTH_SYSTEM_SOURCE_ID field
HOSPITAL_ID DOUBLE Y HOSPITAL_ID field
INTERFACE_IND DOUBLE Y INTERFACE_IND field
LAST_PROCESS_DT_TM DATETIME Y LAST_PROCESS_DT_TM field
MICRO_ORDER_SK VARCHAR(100) Y MICRO_ORDER_SK field
MOST_RECENT_TASK_IND DOUBLE Y MOST_RECENT_TASK_IND field
OBSERVED_DT_TM DATETIME Y OBSERVED_DT_TM field
OBSERVED_TM_ZN DOUBLE Y OBSERVED_TM_ZN field
ORDER_DOC_PRSNL VARCHAR(40) Y ORDER_DOC_PRSNL field
ORDER_DT_TM DATETIME Y ORDER_DT_TM field
ORDER_ORDBL VARCHAR(40) Y ORDER_ORDBL field
ORDER_POSITIVE_IND DOUBLE Y ORDER_POSITIVE_IND field
ORDER_TM_VLD_FLG DOUBLE Y If the time stamp received for this date is valid, then 1, Else 0. If the time stamp is invalid, the time of 00:00 is placed in the date/time field. If the sending system puts a time of 00:00 in the time field for invalid times, and they know the difference between this scenario and an actual time of midnight, those times should be flagged as invalid. 0 = Invalid Time Stamp; 1 = Valid Time Stamp
ORDER_TM_ZN DOUBLE Y ORDER_TM_ZN field
ORGANISM_REF VARCHAR(40) Y ORGANISM_REF field
PARTITION_DT_TM DATETIME Y PARTITION_DT_TM field
PATIENT_LOC_NURSE_UNIT_SK VARCHAR(40) Y PATIENT_LOC_NURSE_UNIT_SK field
PERFORM_LOC_INST VARCHAR(40) Y PERFORM_LOC_INST field
POSITIVE_IND DOUBLE Y POSITIVE_IND field
REPONSE_REF VARCHAR(40) Y REPONSE_REF field
REPORTING_PRIORITY_REF VARCHAR(40) Y REPORTING_PRIORITY_REF field
REPORT_TYPE_REF VARCHAR(40) Y REPORT_TYPE_REF field
REP_NULL_IND DOUBLE Y REP_NULL_IND field
RESPONSE_CLASS_FLG DOUBLE Y RESPONSE_CLASS_FLG field
SOURCE_FLG DOUBLE Y The HIS system or interface being used to send us the data extract. 0 = Unknown; 1 = Classic; 2 = MSMeds; 3 = HNAM; 4 = HL7; 5 = Foreign System; 6 = CoPath; 7 = Critical Outcomes - Apache; 8 = Critical Outcomes - Project Impact; 9 = Critical Outcomes - Web; 10 = Critical Outcomes - HNAM; 11 = PI Third Party XML File; 12 = Shell Record; 13 = PI Defined Record; 14 = Healthe Analytics
SPECIFIC_SOURCE VARCHAR(40) Y SPECIFIC_SOURCE field
SRC_MICRO_ORDER_KEY VARCHAR(200) Y SRC_MICRO_ORDER_KEY field
STATUS_REF VARCHAR(40) Y STATUS_REF field
TASK_NULL_IND DOUBLE Y TASK_NULL_IND field
TASK_REF VARCHAR(40) Y TASK_REF field
TASK_SEQ DOUBLE Y TASK_SEQ field
TASK_TYPE_FLG DOUBLE Y TASK_TYPE_FLG field
VERIFIED_DT_TM DATETIME Y VERIFIED_DT_TM field
VERIFIED_PRSNL VARCHAR(40) Y VERIFIED_PRSNL field
VERIFIED_TM_ZN DOUBLE Y VERIFIED_TM_ZN field
VISIT_ID DOUBLE Y VISIT_ID field