Table Detail Report

HF_R_GEN_LAB_FULL_TEXT



Column Section Top of Page


Table-level Detail

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





Column Detail - HF_R_GEN_LAB_FULL_TEXT


Column Name Type Null? Definition
ACCESSION VARCHAR(20) Y The primary accession number identifies an order or a group of orders.
CHARACTER_RESULT VARCHAR(2000) Y The textual value of the gen lab result
DETAIL_LAB_PROCEDURE_ID DOUBLE N The dim table key for the detail lab procedure (the task assay)
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
GENDER VARCHAR(60) Y Patient's gender
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
LAB_COMPLETED_DT_TM DATETIME Y The date/time the micro order was completed
LAB_PROCEDURE_NAME VARCHAR(100) Y Full name of a laboratory test
LAB_RESULT_TYPE_DESC VARCHAR(60) Y The textual description of the lab result (numeric, character, date, etc.)
NORMAL_RANGE_HIGH VARCHAR(40) Y Defines the normal high reference range value associated with a result. The result must be greater than the normal high to be flagged as high.
NORMAL_RANGE_LOW VARCHAR(40) Y Defines the normal low reference range value associated with a result. The result must be less than the normal low to be flagged as low.
NUMERIC_RESULT DOUBLE Y The numeric value of the gen lab result
ORG_ENCOUNTER_NBR DOUBLE Y The encounter identifier from the source system
OUTBOUND_HSS_ID DOUBLE N The unique identifier of the organization that this result will be reported to
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.
PATIENT_NAME VARCHAR(100) Y Patient's name
RESULT_INDICATOR_DESC VARCHAR(60) Y The textual description of the normality of the result (out of range, not normal, etc.)
UNIT_DISPLAY VARCHAR(40) Y The display of the unit of measure for the result


HF_R_HL7_ISOLATE



Column Section Top of Page


Table-level Detail

Description: HF_R_HL7_ISOLATE
Definition: This table contains all the general lab and microbiology result that being outbound
Table Type: REFERENCE





Column Detail - HF_R_HL7_ISOLATE


Column Name Type Null? Definition
ACCESSION VARCHAR(100) Y Accession number
ACTION_PRSNL_FT VARCHAR(100) Y The free text value of the personnel that performed the action. This is used to map the PERFORMED_PRSNL_* fields.
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.
ADMITTING_DIAGNOSIS_1_DESC VARCHAR(255) Y The description of the first admitting diagnosis
ADMITTING_DIAGNOSIS_2_DESC VARCHAR(255) Y The description of the second admitting diagnosis
ADMITTING_DIAGNOSIS_3_DESC VARCHAR(255) Y The description of the third admitting diagnosis
ADMIT_DT_TM DATETIME Y The date and time when the patient was admitted to the hospital
ADMIT_PHSYICIAN_NAME VARCHAR(100) Y The admitting Physician name
ADMIT_PHYSICIAN_ADDRESS VARCHAR(100) Y The admitting physician address
ADMIT_PHYSICIAN_CITY VARCHAR(100) Y The admitting physician city
ADMIT_PHYSICIAN_EMAIL VARCHAR(100) Y The admitting physician's email address.
ADMIT_PHYSICIAN_FAX VARCHAR(50) Y The admitting physician's fax number.
ADMIT_PHYSICIAN_MOBILE VARCHAR(100) Y The admitting physician's mobile phone number.
ADMIT_PHYSICIAN_NPI VARCHAR(200) Y The NPI for the admitting physician.
ADMIT_PHYSICIAN_PHONE VARCHAR(30) Y The admitting physician's phone number
ADMIT_PHYSICIAN_STATE VARCHAR(100) Y The admitting physician state
ADMIT_PHYSICIAN_ZIP_CODE VARCHAR(25) Y The admitting physician's zip code
ADMIT_TM_ZN DOUBLE Y The time zone in which the admission occurred.
AGE_IN_DAYS DOUBLE Y The persons age in days if 2 days thru 2 weeks old. Values 2 - 13 days. This value is blank if the age was extracted to only the whole year detail.
AGE_IN_HOURS DOUBLE Y The persons age in hours, if less than 2 days old. Values 0-47 hours. This value is blank if the age was extracted to only the whole year detail. If hours, days, weeks, months, and years are all equal 0, then these persons are less than 1 hour.
AGE_IN_MONTHS DOUBLE Y The persons age in months if 3 months thru 2 years. Values 3-23 months. This value is blank if the age was extracted to only the whole year detail.
AGE_IN_WEEKS DOUBLE Y The persons age in weeks if 2 weeks thru 3 months. Values 2-8 weeks. This value is blank if the age was extracted to only the whole year detail.
AGE_IN_YEARS DOUBLE Y The age (in years) of the patient at admission. For HIPAA compliance, ages greater than 90 are categorized as age 90. If the person is less than 2 years old, this field will be set to 0 but age_in_months, age_in_weeks, age_in_days or age_in_hours will be populated
ALT_PATIENT_ADDRESS_1 VARCHAR(100) Y The patient alternative first address.
ALT_PATIENT_ADDRESS_2 VARCHAR(100) Y The patient alternative second address.
ALT_PATIENT_CITY VARCHAR(100) Y The patient alternative city.
ALT_PATIENT_COUNTRY VARCHAR(100) Y The patient alternative country.
ALT_PATIENT_COUNTY VARCHAR(100) Y The patient alternative county.
ALT_PATIENT_FIRST_NAME VARCHAR(100) Y The patient alternative first name.
ALT_PATIENT_LAST_NAME VARCHAR(100) Y The patient alternative last name.
ALT_PATIENT_NAME_INITIALS VARCHAR(100) Y The patient's alternative initials.
ALT_PATIENT_NAME_PREFIX VARCHAR(100) Y The patient alternative name prefix.
ALT_PATIENT_NAME_SUFFIX VARCHAR(100) Y The patient alternative name suffix.
ALT_PATIENT_NAME_TITLE VARCHAR(100) Y The patient alternative name title.
ALT_PATIENT_STATE VARCHAR(100) Y The patient alternative state.
ALT_PATIENT_ZIP_CODE VARCHAR(25) Y The patient alternative zip code.
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_EMAIL VARCHAR(100) Y The attending physician's email address.
ATTEND_PHYSICIAN_FAX VARCHAR(50) Y The attending physician's fax number.
ATTEND_PHYSICIAN_MOBILE VARCHAR(100) Y The attending physician's mobile phone number.
ATTEND_PHYSICIAN_NAME VARCHAR(100) Y The name of the attending physician.
ATTEND_PHYSICIAN_NPI VARCHAR(200) Y The NPI for the attending physician.
ATTEND_PHYSICIAN_PHONE VARCHAR(30) Y The primary phone number of the attending physician.
ATTEND_PHYSICIAN_STATE VARCHAR(100) Y The State of the attending physician.
ATTEND_PHYSICIAN_ZIP_CODE VARCHAR(25) Y The zip code of the attending physician.
BIRTH_DT_TM DATETIME Y Patient's birth date and time
BUSINESS_CALL_INSTRUCTIONS VARCHAR(300) Y Text field to be used to indicate any specific protocol or instructions to be followed when calling the business phone number.
BUSINESS_PHONE VARCHAR(100) Y The patient's business phone number.
BUSINESS_PHONE_EXTENSION VARCHAR(100) Y The patient's business phone number extension.
CALL_INSTRUCTION VARCHAR(300) Y Text field to be used to indicate any specific protocol or instructions to be followed when calling the patient's number.
CARESETTING_DESC VARCHAR(40) Y The description of the caresetting
CHARACTER_RESULT VARCHAR(60) Y The character result
CLIA_NBR VARCHAR(10) Y The CLIA number associated with the facility
CLIENT_DTA_CODE VARCHAR(40) Y The client task assay number from the task assay reference for the detail lab test.
CLIENT_DTA_DESC VARCHAR(100) Y The client task assay long description from the task assay reference for the detail lab test.
CLIENT_DTA_MNEM VARCHAR(50) Y The client task assay mnemonic from the task assay reference for the detail lab test.
CLIENT_LOINC_CODE VARCHAR(10) Y The LOINC code assigned by the client for the detail test if general lab and the order if microbiology.
CLIENT_LOINC_CONCEPT_NAME VARCHAR(255) Y If the hospital assigned their own LOINC codes at the detail test level, this is the LOINC concept description.
CLIENT_LOINC_DESC VARCHAR(255) Y The LOINC description assigned by the client for the detail test if general lab and the order if microbiology.
CLIENT_METHOD_CODE VARCHAR(40) Y The client code value from code set 2058 for the collection method.
CLIENT_METHOD_DESC VARCHAR(100) Y The client code value description from code set 2058 for the collection method.
CLIENT_METHOD_DISPLAY VARCHAR(45) Y The client code value display from code set 2058 for the collection method.
CLIENT_METHOD_MEANING VARCHAR(45) Y The client code value CDF meaning from code set 2058 for the collection method.
CLIENT_ORDERABLE_CONCEPT_NAME VARCHAR(255) Y If the hospital assigned their own LOINC codes for the orderable, this is the LOINC concept description.
CLIENT_ORDERABLE_LOINC_CODE VARCHAR(10) Y If the hospital assigned their own LOINC codes for the orderable, this is the LOINC Code.
CLIENT_ORDERABLE_LOINC_DESC VARCHAR(255) Y If the hospital assigned their own LOINC codes for the orderable, this is the long LOINC description.
CLIENT_ORDER_CODE VARCHAR(40) Y The client orderable number from code set 200.
CLIENT_ORDER_DESC VARCHAR(100) Y The client orderable description from code set 200.
CLIENT_ORDER_DISPLAY VARCHAR(45) Y The client orderable mnemonic from code set 200.
CLIENT_ORGANISM_CODE VARCHAR(40) Y The client code value from code set 1021/1022 for the organism or codified result.
CLIENT_ORGANISM_DESC VARCHAR(100) Y The client code value description from code set 1021/1022 for the organism or codified result.
CLIENT_ORGANISM_DISPLAY VARCHAR(45) Y The client code value display from code set 1021/1022 for the organism or codified result.
CLIENT_ORGANISM_MEANING VARCHAR(45) Y The client code value CDF meaning from code set 1021/1022 for the organism or codified result.
CLIENT_RESULT_IND_CODE VARCHAR(40) Y The client code value code for the abnormal indicator. Code set 52.
CLIENT_RESULT_IND_DESC VARCHAR(100) Y The client code value description for the abnormal indicator. Code set 52.
CLIENT_RESULT_IND_DISPLAY VARCHAR(45) Y The client code value display for the abnormal indicator. Code set 52.
CLIENT_RESULT_IND_MEANING VARCHAR(45) Y The client code value CDF meaning for the abnormal indicator. Code set 52.
CLIENT_SITE_CODE VARCHAR(40) Y The client code value from code set 1028 for the body site.
CLIENT_SITE_DESC VARCHAR(100) Y The client code value description from code set 1028 for the body site.
CLIENT_SITE_DISPLAY VARCHAR(45) Y The client code value display from code set 1028 for the body site.
CLIENT_SITE_MEANING VARCHAR(45) Y The client code value CDF meaning from code set 1028 for the body site.
CLIENT_SPECIMEN_CODE VARCHAR(40) Y The client code value from code set 2052 for the specimen.
CLIENT_SPECIMEN_DESC VARCHAR(100) Y The client code value description from code set 2052 for the specimen.
CLIENT_SPECIMEN_DISPLAY VARCHAR(45) Y The client code value display from code set 2052 for the specimen.
CLIENT_SPECIMEN_MEANING VARCHAR(45) Y The client code value CDF meaning from code set 2052 for the specimen.
CLIENT_UNIT_CODE VARCHAR(40) Y The client code value from code set 54 for the unit of measure.
CLIENT_UNIT_DESC VARCHAR(100) Y The client code value description from code set 54 for the unit of measure.
CLIENT_UNIT_DISPLAY VARCHAR(45) Y The client code value display from code set 54 for the unit of measure.
CLIENT_UNIT_MEANING VARCHAR(45) Y The client code value CDF meaning from code set 54 for the unit of measure.
CLINICAL_OBSERVATION VARCHAR(4000) Y A long text field that originates from the client long text field.
COLLECTION_METHOD_CODE VARCHAR(6) Y The code of the procedure for collecting a specimen.
COLLECTION_METHOD_DESC VARCHAR(40) Y The description of the procedure for collecting a specimen.
COLLECTION_METHOD_ID VARCHAR(40) Y The identifier for the procedure for collecting a specimen.
COLLECTION_METHOD_MOD_DESC VARCHAR(100) Y The standard modifier description for the collection method modifier. A modifier is the left, right, upper, lower location for the collection method.
COLLECTION_METHOD_MOD_SNOMED VARCHAR(10) Y The SNOMED CT code for the collection method modifier. A modifier is the left, right, upper, lower location for the collection method.
COLLECTION_METHOD_SNOMED VARCHAR(10) Y The HealthSentry assigned SNOMED CT for the collection method.
COLLECTION_SITE_CODE VARCHAR(6) Y The SNOMED code for sites from an HL7 file
COLLECTION_SITE_DESC VARCHAR(40) Y The collection site for the microbiology specimen
COLLECTION_SITE_ID DOUBLE N The collection site
COLLECTION_SITE_MOD_DESC VARCHAR(100) Y The standard modifier description for the body site modifier. A modifier is the left, right, upper, lower location for the site.
COLLECTION_SITE_MOD_SNOMED VARCHAR(10) Y The SNOMED code for the body site modifier. A modifier is the left, right, upper, lower location for the body site.
COLLECTION_SITE_SNOMED VARCHAR(10) Y The HealthSentry assigned SNOMED CT for the collection site.
COLLECTION_SOURCE_CODE VARCHAR(6) Y The SNOMED code for sources from an HL7 file
COLLECTION_SOURCE_DESC VARCHAR(40) Y The collection source for the microbiology specimen
COLLECTION_SOURCE_ID DOUBLE N The collection source
COLLECTION_SOURCE_SNOMED VARCHAR(10) Y The HealthSentry assigned SNOMED CT for the collection source.
COLLECTION_SRC_MOD_DESC VARCHAR(100) Y The standard modifier description for the collection specimen modifier. A modifier is the left, right, upper, lower location for the specimen.
COLLECTION_SRC_MOD_SNOMED VARCHAR(10) Y The SNOMED CT code for the collection specimen modifier. A modifier is the left, right, upper, lower location for the specimen.
COLLECTION_STATUS_DESC VARCHAR(60) Y The textual description of a collection status (collection, ordered, scheduled, etc.)
CONTAINER_TYPE VARCHAR(100) Y The type of contain the specimen was collected in.
COUNTY_FIPS_CODE VARCHAR(10) Y The ordering hospital three digit county FIPS code.
DECEASED_DT_TM DATETIME Y The date and time in which the patient expired.
DIRECTOR_FIRST_NAME VARCHAR(100) Y The hospital's director's first name.
DIRECTOR_LAST_NAME VARCHAR(100) Y The hospital's director's last name.
DIRECTOR_MIDDLE_NAME VARCHAR(100) Y The hospital's director's middle name.
DIRECTOR_PREFIX VARCHAR(10) Y The hospital's directors prefix.
DIRECTOR_SUFFIX VARCHAR(10) Y The hospital's directors suffix.
DIRECTOR_TITLE VARCHAR(10) Y The title of the hospital's director.
DISCHARGED_DT_TM DATETIME Y The discharge date of the encounter associated with this record
DISCHARGE_DISP_DESC VARCHAR(190) Y The UB92 standard textual description of a discharge disposition
EMAIL_ADDRESS VARCHAR(100) Y The patient's email address.
ENCOUNTER_ID DOUBLE N The visit identifier for the encounter
ETHNICITY VARCHAR(40) Y 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.
FALSE_POSITIVE_IND DOUBLE Y When a response is marked as positive but the system has detected a negating phrase surrounding the response, this will be set to 1. For all other rows, it will be set to 0
FILE_NAME VARCHAR(50) Y The flat file name that was contains this record. This file is prior to the HL7 transformation in Open Engine.
FINANCIAL_NBR VARCHAR(40) Y The formatted Financial number
FINANCIAL_NBR_RAW VARCHAR(40) Y The unformatted Financial number.
FIRST_OBSERVED_ISOLATE_DT_TM DATETIME Y The date/time when an isolate was first observed on this micro task
GENDER VARCHAR(60) Y Patient's gender
HOSPITAL_ADDRESS VARCHAR(100) Y Address of the hospital
HOSPITAL_ADDRESS_2 VARCHAR(100) Y The second line address of the hospital.
HOSPITAL_CALL_INSTRUCTIONS VARCHAR(300) Y Text field to be used to indicate any specific protocol or instructions to be followed when calling the hospital number.
HOSPITAL_CITY VARCHAR(50) Y City of the hospital
HOSPITAL_CODE DOUBLE Y A Millennium identifier for the hospital
HOSPITAL_COUNTRY VARCHAR(100) Y The country of the hospital.
HOSPITAL_COUNTY VARCHAR(100) Y The county of the hospital.
HOSPITAL_DISPLAY VARCHAR(30) Y The display name of the hospital.
HOSPITAL_EXTENSION VARCHAR(100) Y The phone extension of the hospital's primary phone number.
HOSPITAL_ID DOUBLE Y The dim table key for the hospital that this record's encounter is attached to
HOSPITAL_NAME VARCHAR(50) Y Name of the hospital
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 Phone number for the hospital
HOSPITAL_STATE VARCHAR(2) Y State of the hospital
HOSPITAL_ZIP VARCHAR(25) Y Zipcode of the hospital
INTERP_DATA VARCHAR(4000) Y A long text field that originates from the client interp field.
ISOLATE_ID DOUBLE N The isolate name
ISOLATE_NAME VARCHAR(50) Y The scientific name for the isolate
ISOLATE_REPT_CATEGORY VARCHAR(30) Y The reporting category for the isolate. Typically the genus; however sometimes this is at a finer grain than the genus
ISOLATE_TYPE VARCHAR(25) Y The type of isolate
LAB_COMPLETED_DT_TM DATETIME Y The date and time when a micro result is completed or general lab result is verified
LAB_COMPLETED_MONTH_NAME VARCHAR(9) Y The month represented as text
LAB_COMPLETED_YEAR DOUBLE Y The 4 digit year of the date
LAB_DRAWN_DT_TM DATETIME Y The date/time the specimen was drawn
LAB_ORDERED_DT_TM DATETIME Y The date/time a gen lab order was ordered
LAB_PERFORMED_DT_TM DATETIME Y The date and time in which the lab was performed.
LAB_PROCEDURE_NAME VARCHAR(100) Y Full name of a laboratory test
LAB_RECEIVED_DT_TM DATETIME Y The date/time the specimen was received
LAST_REPORT_UPDATED_DT_TM DATETIME Y The date/time when a report was last entered for this micro task
LOINC_CODE VARCHAR(10) Y The PHIN approved LOINC codes used for reporting purposes
LOINC_CODE_LONG VARCHAR(255) Y The long RELMA description for the mapped detail test LOINC.
LOINC_CODE_SHORT VARCHAR(60) Y The short RELMA description for the mapped detail test LOINC
MEDICAL_RECORD_NBR VARCHAR(40) Y The formatted patient medical record number
MEDICAL_RECORD_NBR_RAW VARCHAR(40) Y The unformatted patient medical record number
MEDICAL_SERVICE_CODE VARCHAR(40) Y The code for the Medical Services.
MEDICAL_SERVICE_DESC VARCHAR(100) Y The description of the Medical Services.
MEDICAL_SERVICE_ID DOUBLE Y Unique identifier for Medical Services
MICRO_RESULT_TYPE_DESC VARCHAR(60) Y The textual description of the micro result type (preliminary, final, amended, etc.)
MICRO_RESULT_TYPE_ID DOUBLE N The result type
MIC_ORDER_STATUS_DESC VARCHAR(60) Y The textual description of the micro order status (preliminary report, final report, etc.)
MOBILE_NUMBER VARCHAR(100) Y The patient's mobile phone number.
MOTHER_MAIDEN_FIRST_NAME VARCHAR(200) Y The patient's mother's maiden first name.
MOTHER_MAIDEN_LAST_NAME VARCHAR(200) Y The patient's mother's maiden last name.
MOTHER_MAIDEN_NAME_INITIALS VARCHAR(100) Y The patient's mother's maiden name initials.
MOTHER_MAIDEN_NAME_PREFIX VARCHAR(100) Y The patient's mother's maiden name prefix.
MOTHER_MAIDEN_NAME_SUFFIX VARCHAR(100) Y The patient's mother's maiden name suffix.
MOTHER_MAIDEN_NAME_TITLE VARCHAR(100) Y The patient's mother's maiden name title.
NAME_INITIALS VARCHAR(100) Y The patient's initials.
NAME_PREFIX VARCHAR(100) Y The prefix of the patient name.
NAME_SUFFIX VARCHAR(100) Y The suffix of the patient name.
NAME_TITLE VARCHAR(100) Y The title of the patient.
NEXT_OF_KIN_ADDRESS_1 VARCHAR(100) Y The address of the patient's closest living blood relative or relatives
NEXT_OF_KIN_ADDRESS_2 VARCHAR(100) Y The address of the patient's closest living blood relative or relatives
NEXT_OF_KIN_CALL_INSTRUCTIONS VARCHAR(300) Y Text field to be used to indicate any specific protocol or instructions to be followed when calling the next of kin number.
NEXT_OF_KIN_CITY VARCHAR(100) Y The city where the patient's closest living blood relative or relatives live
NEXT_OF_KIN_FIRST_NAME VARCHAR(40) Y The first name of the patient's closest living blood relative or relatives
NEXT_OF_KIN_LAST_NAME VARCHAR(100) Y The last name of the patient's closest living blood relative or relatives
NEXT_OF_KIN_MIDDLE_NAME VARCHAR(40) Y The middle name of the patient's closest living blood relative or relatives
NEXT_OF_KIN_NAME VARCHAR(100) Y The next of kin's full name
NEXT_OF_KIN_PHONE VARCHAR(30) Y The phone number of the patient's closest living blood relative or relatives live
NEXT_OF_KIN_PHONE_EXTENSION VARCHAR(100) Y The patient's next of kin's phone extension.
NEXT_OF_KIN_RELATION VARCHAR(40) Y The relationship type of the patient's closest living blood relative 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 state where the patient's closest living blood relative or relatives live
NEXT_OF_KIN_ZIP_CODE VARCHAR(25) Y The zip code where the patient's closest living blood relative or relatives live
NOK_COUNTRY VARCHAR(100) Y The country of the patient's next of kin.
NOK_COUNTY VARCHAR(100) Y The county of the patient's next of kin.
NOK_EMAIL VARCHAR(100) Y The email of the patient's next of kin.
NOK_NAME_INITIALS VARCHAR(100) Y The patient's next of kin initials.
NOK_NAME_PREFIX VARCHAR(100) Y The patient's next of kin's name prefix.
NOK_NAME_SUFFIX VARCHAR(100) Y The patient's next of kin's name suffix.
NOK_NAME_TITLE VARCHAR(100) Y The patient's next of kin's title.
NORMAL_ALPHA VARCHAR(200) Y Defines the normal alpha response for a procedure with the result type of alpha.
NORMAL_RANGE_HIGH VARCHAR(16) Y Defines the normal high reference range value associated with a result. The result must be greater than the normal high to be flagged as high.
NORMAL_RANGE_LOW VARCHAR(16) Y Defines the normal low reference range value associated with a result. The result must be less than the normal low to be flagged as low.
NOTE_TEXT VARCHAR(4000) Y A long text field that originates from the client clinical event note field.
NPI VARCHAR(10) Y The NPI for the ordering hospital.
NUMERIC_RESULT DOUBLE Y The numeric result
ORDERABLE_DESC VARCHAR(100) Y The HealthSentry mapped test description for the orderable.
ORDERABLE_LAB_PROCEDURE_ID DOUBLE Y The Health Data internal ID for the orderable lab.
ORDERABLE_LOINC_CODE VARCHAR(10) Y The HealthSentry assigned LOINC code for the mapped orderable.
ORDERABLE_LOINC_CODE_LONG VARCHAR(255) Y The long RELMA description for the mapped orderable LOINC.
ORDERABLE_LOINC_CODE_SHORT VARCHAR(60) Y The short RELMA description for the mapped orderable LOINC
ORDER_CARESETTING_RAW VARCHAR(40) Y The client value representing the location where the test was ordered
ORDER_LAB_PROCEDURE_ID DOUBLE N The lab procedure
ORDER_PHYSICIAN_ADDRESS VARCHAR(100) Y The ordering physician address
ORDER_PHYSICIAN_ADDRESS_2 VARCHAR(255) Y The second line of the address for the ordering physician.
ORDER_PHYSICIAN_CITY VARCHAR(100) Y The ordering physician city
ORDER_PHYSICIAN_COUNTRY VARCHAR(100) Y The country of the ordering physician.
ORDER_PHYSICIAN_COUNTY VARCHAR(100) Y The county of the ordering physician.
ORDER_PHYSICIAN_EMAIL VARCHAR(100) Y The ordering physician's email address.
ORDER_PHYSICIAN_EXTENSION VARCHAR(100) Y The ordering physician's phone extension.
ORDER_PHYSICIAN_FAX VARCHAR(50) Y The ordering physician's fax number.
ORDER_PHYSICIAN_FIRST_NAME VARCHAR(100) Y The first name of the ordering physician.
ORDER_PHYSICIAN_INITIALS VARCHAR(100) Y The initials of the ordering physician.
ORDER_PHYSICIAN_LAST_NAME VARCHAR(100) Y The last name of the ordering physician.
ORDER_PHYSICIAN_MIDDLE_NAME VARCHAR(100) Y The middle name of the ordering physician.
ORDER_PHYSICIAN_MOBILE VARCHAR(100) Y The ordering physician's mobile phone number.
ORDER_PHYSICIAN_NAME VARCHAR(100) Y The ordering Physician name
ORDER_PHYSICIAN_NPI VARCHAR(200) Y The NPI for the ordering physician.
ORDER_PHYSICIAN_PHONE VARCHAR(30) Y The ordering physician's phone number
ORDER_PHYSICIAN_PREFIX VARCHAR(100) Y The prefix of the ordering physician.
ORDER_PHYSICIAN_STATE VARCHAR(100) Y The ordering physician state
ORDER_PHYSICIAN_SUFFIX VARCHAR(100) Y The suffix of the ordering physician.
ORDER_PHYSICIAN_TITLE VARCHAR(100) Y The title of the ordering physician.
ORDER_PHYSICIAN_ZIP_CODE VARCHAR(25) Y The ordering physician's zip code
ORGANISM_OCCURRENCE_NBR DOUBLE Y Within microbiology, the organisms have a sequence. This is the sequence number of the organism that is associated with the susceptibility results.
ORG_ENCOUNTER_NBR DOUBLE Y The encounter identifier from the source system
OUTBOUND_HSS_ID DOUBLE N The outbound health system source
O_PHYSICIAN_CALL_INSTRUCTIONS VARCHAR(300) Y Text field to be used to indicate any specific protocol or instructions to be followed when calling the physician number.
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_ADDRESS1 VARCHAR(100) Y Patient's hone address
PATIENT_ADDRESS2 VARCHAR(100) Y Patient's hone address
PATIENT_ADDRESS_1 VARCHAR(100) Y Patient's home address
PATIENT_CITY VARCHAR(100) Y Patient's city
PATIENT_COUNTRY VARCHAR(50) Y Patient's country
PATIENT_COUNTRY_CODE VARCHAR(10) Y The patient's country standard PHINVads code.
PATIENT_COUNTY VARCHAR(50) Y Patient's county
PATIENT_COUNTY_CODE VARCHAR(40) Y The source key of the county from the source system
PATIENT_ID DOUBLE Y The patient unique identifier used within the Cerner Health Facts Data Warehouse.
PATIENT_LAST_NAME VARCHAR(100) Y Patient's last name
PATIENT_MAIDEN_LAST_NAME VARCHAR(100) Y The patient's maiden last name.
PATIENT_MIDDLE_NAME VARCHAR(40) Y Patient's middle name
PATIENT_NAME VARCHAR(100) Y The patient's full name
PATIENT_PHONE VARCHAR(40) Y Patient's phone number
PATIENT_SSN VARCHAR(40) Y Patient social security numbe
PATIENT_STATE VARCHAR(50) Y Patient state
PATIENT_STATE_CODE VARCHAR(10) Y The patient state FIP code per the zipcode.
PATIENT_TYPE_DESC VARCHAR(60) Y A description of the patient type. Defines the type of visit made
PATIENT_ZIP_CODE VARCHAR(25) Y Patient's zip code
PERFORMED_BENCH_ADDRESS VARCHAR(100) Y The perform lab address derived from the bench location.
PERFORMED_BENCH_CITY VARCHAR(50) Y The perform lab city derived from the bench location.
PERFORMED_BENCH_CLIA_NBR VARCHAR(10) Y The perform lab CLIA derived from the bench location.
PERFORMED_BENCH_CODE DOUBLE Y The client code for the bench.
PERFORMED_BENCH_COUNTRY VARCHAR(100) Y The perform lab country derived from the bench location.
PERFORMED_BENCH_COUNTY VARCHAR(100) Y The perform lab county derived from the bench location.
PERFORMED_BENCH_DISPLAY VARCHAR(30) Y The perform lab display name derived from the bench location. Usually the display is 20 characters or less and used for the HL7 messages.
PERFORMED_BENCH_ID DOUBLE Y The unique identifier of the bench that was used.
PERFORMED_BENCH_NAME VARCHAR(50) Y The perform lab name derived from bench location.
PERFORMED_BENCH_PHONE VARCHAR(30) Y The perform lab phone derived from the bench location.
PERFORMED_BENCH_STATE VARCHAR(2) Y The perform lab state derived from the bench location.
PERFORMED_BENCH_ZIP VARCHAR(25) Y The perform lab zip derived from the bench location.
PERFORMED_HOSPITAL_ADDRESS VARCHAR(100) Y The address of the hospital in which the action was performed.
PERFORMED_HOSPITAL_CITY VARCHAR(50) Y The city of the hospital in which the action was performed.
PERFORMED_HOSPITAL_CLIA_NBR VARCHAR(10) Y The CLIA number for the performing hospital.
PERFORMED_HOSPITAL_CODE DOUBLE Y The identifying code of the hospital in which the action was performed.
PERFORMED_HOSPITAL_COUNTRY VARCHAR(100) Y The country of the hospital in which the action was performed.
PERFORMED_HOSPITAL_COUNTY VARCHAR(100) Y The county of the hospital in which the action was performed.
PERFORMED_HOSPITAL_DISPLAY VARCHAR(30) Y The display name of the hospital in which the action was performed.
PERFORMED_HOSPITAL_ID DOUBLE Y The unique identifier of the hospital in which the action was performed.
PERFORMED_HOSPITAL_NAME VARCHAR(50) Y The name of the hospital in which the action was performed.
PERFORMED_HOSPITAL_PHONE VARCHAR(30) Y The primary phone number of the hospital in which the action was performed.
PERFORMED_HOSPITAL_STATE VARCHAR(2) Y The state of the hospital in which the action was performed.
PERFORMED_HOSPITAL_ZIP VARCHAR(25) Y The zip code of the hospital in which the action was performed.
PERFORMED_PRSNL_ADDRESS VARCHAR(100) Y The mapped perform hospital address determined from action perform personnel.
PERFORMED_PRSNL_CITY VARCHAR(50) Y The mapped perform hospital city determined from action perform personnel.
PERFORMED_PRSNL_CLIA_NBR VARCHAR(10) Y The mapped perform hospital CLIA number determined from action perform personnel.
PERFORMED_PRSNL_CODE DOUBLE Y N/A. Blank.
PERFORMED_PRSNL_COUNTRY VARCHAR(100) Y The mapped perform hospital country determined from action perform personnel.
PERFORMED_PRSNL_COUNTY VARCHAR(100) Y The mapped perform hospital county determined from action perform personnel.
PERFORMED_PRSNL_DISPLAY VARCHAR(30) Y The mapped perform hospital display name determined from action perform personnel.
PERFORMED_PRSNL_ID DOUBLE Y The mapped perform hospital id determined from action perform personnel from hf_d_hospital.
PERFORMED_PRSNL_NAME VARCHAR(50) Y The mapped perform hospital name determined from action perform personnel.
PERFORMED_PRSNL_PHONE VARCHAR(30) Y The mapped perform hospital phone determined from action perform personnel.
PERFORMED_PRSNL_STATE VARCHAR(2) Y The mapped perform hospital state determined from action perform personnel.
PERFORMED_PRSNL_ZIP VARCHAR(25) Y The mapped perform hospital zip code determined from action perform personnel.
PHIN_ABNORMAL_CODE VARCHAR(10) Y PHINVADs has defined abbreviations for abnormal flags. This translates the Health Data values to a standard code for HL7.
PHIN_ABNORMAL_DESC VARCHAR(100) Y PHINVADs has defined abbreviations for abnormal flags. This translates the Health Data values to a standard description for HL7.
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.
PHONE_EXTENSION VARCHAR(100) Y The patient's phone extension.
POSITIVE_IND DOUBLE Y Some reportables microbiology are negative. This differentiates the positive microbiology from the negative.
PREGNANCY_STATUS VARCHAR(255) Y The raw text from pregnancy status entered by the client.
PREGNANCY_STATUS_SNOMED VARCHAR(20) Y After pregnancy status values are mapped, a standard SNOMED code is applied. This field contains the standard SNOMED code for the response.
QUALITATIVE_RESULT VARCHAR(100) Y The mapped general lab character_result (qualitative).
QUALITATIVE_RESULT_SNOMED VARCHAR(60) Y The SNOMED CT code for mapped general lab character_result (qualitative).
RACE VARCHAR(40) Y Patient's race
RAW_FACILITY_ADDRESS VARCHAR(100) Y The first address for the raw 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 facility city.
RAW_FACILITY_NAME VARCHAR(100) Y The raw facility client description.
RAW_FACILITY_PHONE VARCHAR(50) Y The unformatted phone number of the facility.
RAW_FACILITY_STATE VARCHAR(50) Y The raw facility state.
RAW_FACILITY_ZIP_CODE VARCHAR(25) Y The raw facility zip code.
REASON_FOR_STUDY_DESC VARCHAR(1000) Y The reason why the study was initiated.
RELEASE_NUMBER VARCHAR(255) Y A field with the release number to pass into the HL7 message.
REMARK VARCHAR(100) Y Blank.
REPORTING_PRIORITY_DESC VARCHAR(60) Y The textual description of the reporting priority (As Soon As Possible)
RESULT_INDICATOR_DESC VARCHAR(60) Y A text description of the type of normality. If the result was not normal, this field indicates that the result was out of range, not normal, etc.
RESULT_TYPE_PROCEDURE_DESC VARCHAR(60) Y A textual description of the detail procedure/report (preliminary, final, etc.)
RESULT_TYPE_PROCEDURE_ID DOUBLE Y The dim table key for the type of procedure that was performed
RESULT_UNIT_DESC VARCHAR(60) Y A description of the unit of measure for the result
RESULT_UNIT_DISPLAY VARCHAR(40) Y The display of the unit of measure for the result
RESULT_UNIT_UCUM VARCHAR(250) Y The standard UCUM description for the result unit.
SNOMEDCT_CODE VARCHAR(15) Y A newer version of the SNOMED code. Only populated when the SNOMEDCT code is different from the SNOMED code
SNOMED_CODE VARCHAR(15) Y The SNOMED code(s) for the isolate
SRC_FCT_KEY VARCHAR(100) Y The identifying source key for the record.
STATE_FIPS_CODE VARCHAR(10) Y The ordering hospital two digit state FIPS code.
TOTAL_REPORT_UPDATES DOUBLE Y The total number of times reports have been entered for this micro task
UNIQUE_ORDER_ID VARCHAR(80) Y Combination of fields that uniquely define an order
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated.
VERIFIED_DT_TM DATETIME Y The date and time in which the result was verified.
VERIFIED_PRSNL_INITIALS VARCHAR(100) Y The initials of the personnel that verified the results.
VERIFIED_PRSNL_NAME VARCHAR(100) Y The full name of the personnel that validated the results.
VERIFIED_PRSNL_PREFIX VARCHAR(100) Y The prefix of the personnel that verified the results.
VERIFIED_PRSNL_SUFFIX VARCHAR(100) Y The suffix of the personnel that verified the results.
VERIFIED_PRSNL_TITLE VARCHAR(100) Y The title of the personnel that verified the results.
VITAL_STATUS VARCHAR(60) Y A field that identifies alive, deceased status.
WEIGHT DOUBLE Y Patient's weight
WEIGHT_UNIT_DISPLAY VARCHAR(40) Y The display of the unit of measure


HF_R_ISOLATE



Column Section Top of Page


Table-level Detail

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





Column Detail - HF_R_ISOLATE


Column Name Type Null? Definition
ACCESSION VARCHAR(20) Y The primary accession number identifies an order or a group of orders.
ACTION_PRSNL_FT VARCHAR(100) Y The free text value of the personnel that performed the action. This is used to map the PERFORMED_PRSNL_* fields.
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.
ADMITTING_DIAGNOSIS_1_DESC VARCHAR(255) Y The description of the first admitting diagnosis
ADMITTING_DIAGNOSIS_2_DESC VARCHAR(255) Y The description of the second admitting diagnosis
ADMITTING_DIAGNOSIS_3_DESC VARCHAR(255) Y The description of the third admitting diagnosis
ADMIT_DT_TM DATETIME Y The date and time when the patient was admitted to the hospital
ADMIT_PHSYICIAN_NAME VARCHAR(100) Y The admitting Physician name
ADMIT_PHYSICIAN_ADDRESS VARCHAR(100) Y The admitting physician address
ADMIT_PHYSICIAN_CITY VARCHAR(100) Y The admitting physician city
ADMIT_PHYSICIAN_EMAIL VARCHAR(100) Y The admitting physician's email address.
ADMIT_PHYSICIAN_FAX VARCHAR(50) Y The admitting physician's fax number.
ADMIT_PHYSICIAN_MOBILE VARCHAR(100) Y The admitting physician's mobile phone number.
ADMIT_PHYSICIAN_NPI VARCHAR(200) Y The NPI for the admitting physician.
ADMIT_PHYSICIAN_PHONE VARCHAR(30) Y The admitting physician's phone number
ADMIT_PHYSICIAN_STATE VARCHAR(100) Y The admitting physician state
ADMIT_PHYSICIAN_ZIP_CODE VARCHAR(25) Y The admitting physician's zip code
ADMIT_TM_ZN DOUBLE Y The time zone in which the admission occurred.
AGE_IN_DAYS DOUBLE Y The persons age in days if 2 days thru 2 weeks old. Values 2 - 13 days. This value is blank if the age was extracted to only the whole year detail.
AGE_IN_HOURS DOUBLE Y The persons age in hours, if less than 2 days old. Values 0-47 hours. This value is blank if the age was extracted to only the whole year detail. If hours, days, weeks, months, and years are all equal 0, then these persons are less than 1 hour.
AGE_IN_MONTHS DOUBLE Y The persons age in months if 3 months thru 2 years. Values 3-23 months. This value is blank if the age was extracted to only the whole year detail.
AGE_IN_WEEKS DOUBLE Y The persons age in weeks if 2 weeks thru 3 months. Values 2-8 weeks. This value is blank if the age was extracted to only the whole year detail.
AGE_IN_YEARS DOUBLE Y The age (in years) of the patient at admission. For HIPAA compliance, ages greater than 90 are categorized as age 90. If the person is less than 2 years old, this field will be set to 0 but age_in_months, age_in_weeks, age_in_days or age_in_hours will be populated
ALT_PATIENT_ADDRESS_1 VARCHAR(100) Y The patient alternative first address.
ALT_PATIENT_ADDRESS_2 VARCHAR(100) Y The patient alternative second address.
ALT_PATIENT_CITY VARCHAR(100) Y The patient alternative city.
ALT_PATIENT_COUNTRY VARCHAR(100) Y The patient alternative country.
ALT_PATIENT_COUNTY VARCHAR(100) Y The patient alternative county.
ALT_PATIENT_FIRST_NAME VARCHAR(100) Y The patient alternative first name.
ALT_PATIENT_LAST_NAME VARCHAR(100) Y The patient alternative last name.
ALT_PATIENT_NAME_INITIALS VARCHAR(100) Y The patient's alternative initials.
ALT_PATIENT_NAME_PREFIX VARCHAR(100) Y The patient alternative name prefix.
ALT_PATIENT_NAME_SUFFIX VARCHAR(100) Y The patient alternative name suffix.
ALT_PATIENT_NAME_TITLE VARCHAR(100) Y The patient alternative name title.
ALT_PATIENT_STATE VARCHAR(100) Y The patient alternative state.
ALT_PATIENT_ZIP_CODE VARCHAR(25) Y The patient alternative zip code.
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_EMAIL VARCHAR(100) Y The attending physician's email address.
ATTEND_PHYSICIAN_FAX VARCHAR(50) Y The attending physician's fax number.
ATTEND_PHYSICIAN_MOBILE VARCHAR(100) Y The attending physician's mobile phone number.
ATTEND_PHYSICIAN_NAME VARCHAR(100) Y The name of the attending physician.
ATTEND_PHYSICIAN_NPI VARCHAR(200) Y The NPI for the attending physician.
ATTEND_PHYSICIAN_PHONE VARCHAR(30) Y The primary phone number of the attending physician.
ATTEND_PHYSICIAN_STATE VARCHAR(100) Y The State of the attending physician.
ATTEND_PHYSICIAN_ZIP_CODE VARCHAR(25) Y The zip code of the attending physician.
BIRTH_DT_TM DATETIME Y Patient's birth date and time
BUSINESS_CALL_INSTRUCTIONS VARCHAR(300) Y Text field to be used to indicate any specific protocol or instructions to be followed when calling the business phone number.
BUSINESS_PHONE VARCHAR(100) Y The patient's business phone number.
BUSINESS_PHONE_EXTENSION VARCHAR(100) Y The patient's business phone number extension.
CALL_INSTRUCTION VARCHAR(300) Y Text field to be used to indicate any specific protocol or instructions to be followed when calling the patient's number.
CARESETTING_DESC VARCHAR(40) Y The description of the caresetting
CHARACTER_RESULT VARCHAR(2000) Y The textual value of the gen lab result
CLIA_NBR VARCHAR(10) Y The CLIA number associated with the facility
CLIENT_DTA_CODE VARCHAR(40) Y The client task assay number from the task assay reference for the detail lab test.
CLIENT_DTA_DESC VARCHAR(100) Y The client task assay long description from the task assay reference for the detail lab test.
CLIENT_DTA_MNEM VARCHAR(50) Y The client task assay mnemonic from the task assay reference for the detail lab test.
CLIENT_LOINC_CODE VARCHAR(10) Y The LOINC code assigned by the client for the detail test if general lab and the order if microbiology.
CLIENT_LOINC_CONCEPT_NAME VARCHAR(255) Y If the hospital assigned their own LOINC codes at the detail test level, this is the LOINC concept description.
CLIENT_LOINC_DESC VARCHAR(255) Y The LOINC description assigned by the client for the detail test if general lab and the order if microbiology.
CLIENT_METHOD_CODE VARCHAR(40) Y The client code value from code set 2058 for the collection method.
CLIENT_METHOD_DESC VARCHAR(100) Y The client code value description from code set 2058 for the collection method.
CLIENT_METHOD_DISPLAY VARCHAR(45) Y The client code value display from code set 2058 for the collection method.
CLIENT_METHOD_MEANING VARCHAR(45) Y The client code value CDF meaning from code set 2058 for the collection method.
CLIENT_ORDERABLE_CONCEPT_NAME VARCHAR(255) Y If the hospital assigned their own LOINC codes for the orderable, this is the LOINC concept description.
CLIENT_ORDERABLE_LOINC_CODE VARCHAR(10) Y If the hospital assigned their own LOINC codes for the orderable, this is the LOINC Code.
CLIENT_ORDERABLE_LOINC_DESC VARCHAR(255) Y If the hospital assigned their own LOINC codes for the orderable, this is the long LOINC description.
CLIENT_ORDER_CODE VARCHAR(40) Y The client orderable number from code set 200.
CLIENT_ORDER_DESC VARCHAR(100) Y The client orderable description from code set 200.
CLIENT_ORDER_DISPLAY VARCHAR(45) Y The client orderable mnemonic from code set 200.
CLIENT_ORGANISM_CODE VARCHAR(40) Y The client code value from code set 1021/1022 for the organism or codified result.
CLIENT_ORGANISM_DESC VARCHAR(100) Y The client code value description from code set 1021/1022 for the organism or codified result.
CLIENT_ORGANISM_DISPLAY VARCHAR(45) Y The client code value display from code set 1021/1022 for the organism or codified result.
CLIENT_ORGANISM_MEANING VARCHAR(45) Y The client code value CDF meaning from code set 1021/1022 for the organism or codified result.
CLIENT_RESULT_IND_CODE VARCHAR(40) Y The client code value code for the abnormal indicator. Code set 52.
CLIENT_RESULT_IND_DESC VARCHAR(100) Y The client code value description for the abnormal indicator. Code set 52.
CLIENT_RESULT_IND_DISPLAY VARCHAR(45) Y The client code value display for the abnormal indicator. Code set 52.
CLIENT_RESULT_IND_MEANING VARCHAR(45) Y The client code value CDF meaning for the abnormal indicator. Code set 52.
CLIENT_SITE_CODE VARCHAR(40) Y The client code value from code set 1028 for the body site.
CLIENT_SITE_DESC VARCHAR(100) Y The client code value description from code set 1028 for the body site.
CLIENT_SITE_DISPLAY VARCHAR(45) Y The client code value display from code set 1028 for the body site.
CLIENT_SITE_MEANING VARCHAR(45) Y The client code value CDF meaning from code set 1028 for the body site.
CLIENT_SPECIMEN_CODE VARCHAR(40) Y The client code value from code set 2052 for the specimen.
CLIENT_SPECIMEN_DESC VARCHAR(100) Y The client code value description from code set 2052 for the specimen.
CLIENT_SPECIMEN_DISPLAY VARCHAR(45) Y The client code value display from code set 2052 for the specimen.
CLIENT_SPECIMEN_MEANING VARCHAR(45) Y The client code value CDF meaning from code set 2052 for the specimen.
CLIENT_UNIT_CODE VARCHAR(40) Y The client code value from code set 54 for the unit of measure.
CLIENT_UNIT_DESC VARCHAR(100) Y The client code value description from code set 54 for the unit of measure.
CLIENT_UNIT_DISPLAY VARCHAR(45) Y The client code value display from code set 54 for the unit of measure.
CLIENT_UNIT_MEANING VARCHAR(45) Y The client code value CDF meaning from code set 54 for the unit of measure.
CLINICAL_OBSERVATION VARCHAR(4000) Y A long text field that originates from the client long text field.
COLLECTION_METHOD_CODE VARCHAR(6) Y The code of the procedure for collecting a specimen.
COLLECTION_METHOD_DESC VARCHAR(40) Y The description of the procedure for collecting a specimen.
COLLECTION_METHOD_ID VARCHAR(40) Y The Health Data ID fro HF_D_COLLECTION_SRC_SITE for the mapped collection method.
COLLECTION_METHOD_ID_TXT VARCHAR(40) Y The identifier for the procedure for collecting a specimen.
COLLECTION_METHOD_MOD_DESC VARCHAR(100) Y The standard modifier description for the collection method modifier. A modifier is the left, right, upper, lower location for the collection method.
COLLECTION_METHOD_MOD_SNOMED VARCHAR(10) Y The SNOMED CT code for the collection method modifier. A modifier is the left, right, upper, lower location for the collection method.
COLLECTION_METHOD_SNOMED VARCHAR(10) Y The HealthSentry assigned SNOMED CT for the collection method.
COLLECTION_SITE_CODE VARCHAR(6) Y The SNOMED code for sites from an HL7 file
COLLECTION_SITE_DESC VARCHAR(40) Y The collection site for the microbiology specimen
COLLECTION_SITE_ID DOUBLE N The dim table key for the collection site of the isolate
COLLECTION_SITE_MOD_DESC VARCHAR(100) Y The standard modifier description for the body site modifier. A modifier is the left, right, upper, lower location for the site.
COLLECTION_SITE_MOD_SNOMED VARCHAR(10) Y The SNOMED code for the body site modifier. A modifier is the left, right, upper, lower location for the body site.
COLLECTION_SITE_SNOMED VARCHAR(10) Y The HealthSentry assigned SNOMED CT for the collection site.
COLLECTION_SOURCE_CODE VARCHAR(6) Y The SNOMED code for sources from an HL7 file
COLLECTION_SOURCE_DESC VARCHAR(40) Y The collection source for the microbiology specimen
COLLECTION_SOURCE_ID DOUBLE N The dim table key for the collection source of the isolate
COLLECTION_SOURCE_SNOMED VARCHAR(100) Y The HealthSentry assigned SNOMED CT for the collection source.
COLLECTION_SRC_MOD_DESC VARCHAR(100) Y The standard modifier description for the collection specimen modifier. A modifier is the left, right, upper, lower location for the specimen.
COLLECTION_SRC_MOD_SNOMED VARCHAR(10) Y The SNOMED CT code for the collection specimen modifier. A modifier is the left, right, upper, lower location for the specimen.
COLLECTION_STATUS_DESC VARCHAR(60) Y The textual description of a collection status (collection, ordered, scheduled, etc.)
COL_IDENT VARCHAR(50) Y N/A Should be No such field on this table.
CONTAINER_TYPE VARCHAR(100) Y The type of contain the specimen was collected in.
COUNTY_FIPS_CODE VARCHAR(10) Y The ordering hospital three digit county FIPS code.
DECEASED_DT_TM DATETIME Y The date and time in which the patient expired.
DIRECTOR_FIRST_NAME VARCHAR(100) Y The hospital's director's first name.
DIRECTOR_LAST_NAME VARCHAR(100) Y The hospital's director's last name.
DIRECTOR_MIDDLE_NAME VARCHAR(100) Y The hospital's director's middle name.
DIRECTOR_PREFIX VARCHAR(10) Y The hospital's directors prefix.
DIRECTOR_SUFFIX VARCHAR(10) Y The hospital's directors suffix.
DIRECTOR_TITLE VARCHAR(10) Y The title of the hospital's director.
DISCHARGED_DT_TM DATETIME Y The discharge date of the encounter associated with this record
DISCHARGE_DISP_DESC VARCHAR(190) Y The UB92 standard textual description of a discharge disposition
EMAIL_ADDRESS VARCHAR(100) Y The patient's email address.
ENCOUNTER_ID DOUBLE N The visit identifier for the encounter
ETHNICITY VARCHAR(40) Y 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.
FALSE_POSITIVE_IND DOUBLE Y When a response is marked as positive but the system has detected a negating phrase surrounding the response, this will be set to 1. For all other rows, it will be set to 0
FINANCIAL_NBR VARCHAR(40) Y The formatted Financial number
FINANCIAL_NBR_RAW VARCHAR(40) Y The unformatted Financial number.
FIRST_OBSERVED_ISOLATE_DT_TM DATETIME Y The date/time when an isolate was first observed on this micro task
GENDER VARCHAR(60) Y Patient's gender
HEALTH_SYSTEM_ID DOUBLE N The health system that the hospital belongs to
HOSPITAL_ADDRESS VARCHAR(100) Y Address of the hospital
HOSPITAL_ADDRESS_2 VARCHAR(100) Y The second line address of the hospital.
HOSPITAL_CALL_INSTRUCTIONS VARCHAR(300) Y Text field to be used to indicate any specific protocol or instructions to be followed when calling the hospital number.
HOSPITAL_CITY VARCHAR(50) Y City of the hospital
HOSPITAL_CODE DOUBLE Y A Millennium identifier for the hospital
HOSPITAL_COUNTRY VARCHAR(100) Y The country of the hospital.
HOSPITAL_COUNTY VARCHAR(100) Y The county of the hospital.
HOSPITAL_DISPLAY VARCHAR(30) Y The display name of the hospital.
HOSPITAL_EXTENSION VARCHAR(100) Y The phone extension of the hospital's primary phone number.
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
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 Phone number for the hospital
HOSPITAL_STATE VARCHAR(2) Y State of the hospital
HOSPITAL_ZIP VARCHAR(25) Y Zipcode of the hospital
INTERP_DATA VARCHAR(4000) Y A long text field that originates from the client interp field.
ISOLATE_ID DOUBLE N The dim table key for the isolate
ISOLATE_NAME VARCHAR(50) Y The scientific name for the isolate
ISOLATE_REPT_CATEGORY VARCHAR(30) Y The reporting category for the isolate. Typically the genus; however sometimes this is at a finer grain than the genus
ISOLATE_TYPE VARCHAR(25) Y The type of isolate
LAB_COMPLETED_DT_TM DATETIME Y The date/time the micro order was completed
LAB_COMPLETED_MONTH_NAME VARCHAR(9) Y The month represented as text
LAB_COMPLETED_YEAR DOUBLE Y The 4 digit year of the date
LAB_DRAWN_DT_TM DATETIME Y The date/time the specimen was drawn
LAB_ORDERED_DT_TM DATETIME Y The date/time a gen lab order was ordered
LAB_PERFORMED_DT_TM DATETIME Y The date and time in which the lab was performed.
LAB_PROCEDURE_NAME VARCHAR(100) Y Full name of a laboratory test
LAB_RECEIVED_DT_TM DATETIME Y The date/time the specimen was received
LAST_REPORT_UPDATED_DT_TM DATETIME Y The date/time when a report was last entered for this micro task
LOINC_CODE VARCHAR(10) Y The PHIN approved LOINC codes used for reporting purposes
LOINC_CODE_LONG VARCHAR(255) Y The long RELMA description for the mapped detail test LOINC.
LOINC_CODE_SHORT VARCHAR(60) Y The short RELMA description for the mapped detail test LOINC
MEDICAL_RECORD_NBR VARCHAR(40) Y The formatted patient medical record number
MEDICAL_RECORD_NBR_RAW VARCHAR(40) Y The unformatted patient medical record number
MEDICAL_SERVICE_CODE VARCHAR(40) Y The code for the Medical Services.
MEDICAL_SERVICE_DESC VARCHAR(100) Y The description of the Medical Services.
MEDICAL_SERVICE_ID DOUBLE Y Unique identifier for Medical Services
MICRO_RESULT_TYPE_DESC VARCHAR(60) Y The textual description of the micro result type (preliminary, final, amended, etc.)
MICRO_RESULT_TYPE_ID DOUBLE N The dim table key for the type of micro result (preliminary, final, etc.)
MIC_ORDER_STATUS_DESC VARCHAR(60) Y The textual description of the micro order status (preliminary report, final report, etc.)
MOBILE_NUMBER VARCHAR(100) Y The patient's mobile phone number.
MOTHER_MAIDEN_FIRST_NAME VARCHAR(200) Y The patient's mother's maiden first name.
MOTHER_MAIDEN_LAST_NAME VARCHAR(200) Y The patient's mother's maiden last name.
MOTHER_MAIDEN_NAME_INITIALS VARCHAR(100) Y The patient's mother's maiden name initials.
MOTHER_MAIDEN_NAME_PREFIX VARCHAR(100) Y The patient's mother's maiden name prefix.
MOTHER_MAIDEN_NAME_SUFFIX VARCHAR(100) Y The patient's mother's maiden name suffix.
MOTHER_MAIDEN_NAME_TITLE VARCHAR(100) Y The patient's mother's maiden name title.
NAME_INITIALS VARCHAR(100) Y The patient's initials.
NAME_PREFIX VARCHAR(100) Y The prefix of the patient name.
NAME_SUFFIX VARCHAR(100) Y The suffix of the patient name.
NAME_TITLE VARCHAR(100) Y The title of the patient.
NEXT_OF_KIN_ADDRESS_1 VARCHAR(100) Y The address of the patient's closest living blood relative or relatives
NEXT_OF_KIN_ADDRESS_2 VARCHAR(100) Y The address of the patient's closest living blood relative or relatives
NEXT_OF_KIN_CALL_INSTRUCTIONS VARCHAR(300) Y Text field to be used to indicate any specific protocol or instructions to be followed when calling the next of kin number.
NEXT_OF_KIN_CITY VARCHAR(100) Y The city where the patient's closest living blood relative or relatives live
NEXT_OF_KIN_FIRST_NAME VARCHAR(40) Y The first name of the patient's closest living blood relative or relatives
NEXT_OF_KIN_LAST_NAME VARCHAR(100) Y The last name of the patient's closest living blood relative or relatives
NEXT_OF_KIN_MIDDLE_NAME VARCHAR(40) Y The middle name of the patient's closest living blood relative or relatives
NEXT_OF_KIN_NAME VARCHAR(100) Y The person name of the patient's closest living blood relative or relatives
NEXT_OF_KIN_PHONE VARCHAR(30) Y The phone number of the patient's closest living blood relative or relatives live
NEXT_OF_KIN_PHONE_EXTENSION VARCHAR(100) Y The patient's next of kin's phone extension.
NEXT_OF_KIN_RELATION VARCHAR(40) Y The relationship type of the patient's closest living blood relative 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 state where the patient's closest living blood relative or relatives live
NEXT_OF_KIN_ZIP_CODE VARCHAR(25) Y The zip code where the patient's closest living blood relative or relatives live
NOK_COUNTRY VARCHAR(100) Y The country of the patient's next of kin.
NOK_COUNTY VARCHAR(100) Y The county of the patient's next of kin.
NOK_EMAIL VARCHAR(100) Y The email of the patient's next of kin.
NOK_NAME_INITIALS VARCHAR(100) Y The patient's next of kin initials.
NOK_NAME_PREFIX VARCHAR(100) Y The patient's next of kin's name prefix.
NOK_NAME_SUFFIX VARCHAR(100) Y The patient's next of kin's name suffix.
NOK_NAME_TITLE VARCHAR(100) Y The patient's next of kin's title.
NORMAL_ALPHA VARCHAR(200) Y Defines the normal alpha response for a procedure with the result type of alpha.
NORMAL_RANGE_HIGH VARCHAR(16) Y Defines the normal high reference range value associated with a result. The result must be greater than the normal high to be flagged as high.
NORMAL_RANGE_LOW VARCHAR(16) Y Defines the normal low reference range value associated with a result. The result must be less than the normal low to be flagged as low.
NOTE_TEXT VARCHAR(4000) Y A long text field that originates from the client clinical event note field.
NPI VARCHAR(10) Y The NPI for the ordering hospital.
NUMERIC_RESULT DOUBLE Y The numeric value of the gen lab result
ORDERABLE_DESC VARCHAR(100) Y The HealthSentry mapped test description for the orderable.
ORDERABLE_LAB_PROCEDURE_ID DOUBLE Y The Health Data internal ID for the orderable lab.
ORDERABLE_LOINC_CODE VARCHAR(10) Y The HealthSentry assigned LOINC code for the mapped orderable.
ORDERABLE_LOINC_CODE_LONG VARCHAR(255) Y The long RELMA description for the mapped orderable LOINC.
ORDERABLE_LOINC_CODE_SHORT VARCHAR(60) Y The short RELMA description for the mapped orderable LOINC
ORDER_CARESETTING_RAW VARCHAR(40) Y The client value representing the location where the test was ordered
ORDER_LAB_PROCEDURE_ID DOUBLE N The dim table key for the ordered lab procedure
ORDER_PHYSICIAN_ADDRESS VARCHAR(100) Y The ordering physician address
ORDER_PHYSICIAN_ADDRESS_2 VARCHAR(255) Y The second line of the address for the ordering physician.
ORDER_PHYSICIAN_CITY VARCHAR(100) Y The ordering physician city
ORDER_PHYSICIAN_COUNTRY VARCHAR(100) Y The country of the ordering physician.
ORDER_PHYSICIAN_COUNTY VARCHAR(100) Y The county of the ordering physician.
ORDER_PHYSICIAN_EMAIL VARCHAR(100) Y The ordering physician's email address.
ORDER_PHYSICIAN_EXTENSION VARCHAR(100) Y The ordering physician's phone extension.
ORDER_PHYSICIAN_FAX VARCHAR(50) Y The ordering physician's fax number.
ORDER_PHYSICIAN_FIRST_NAME VARCHAR(100) Y The first name of the ordering physician.
ORDER_PHYSICIAN_INITIALS VARCHAR(100) Y The initials of the ordering physician.
ORDER_PHYSICIAN_LAST_NAME VARCHAR(100) Y The last name of the ordering physician.
ORDER_PHYSICIAN_MIDDLE_NAME VARCHAR(100) Y The middle name of the ordering physician.
ORDER_PHYSICIAN_MOBILE VARCHAR(100) Y The ordering physician's mobile phone number.
ORDER_PHYSICIAN_NAME VARCHAR(100) Y The ordering Physician name
ORDER_PHYSICIAN_NPI VARCHAR(200) Y The NPI for the ordering physician.
ORDER_PHYSICIAN_PHONE VARCHAR(30) Y The ordering physician's phone number
ORDER_PHYSICIAN_PREFIX VARCHAR(100) Y The prefix of the ordering physician.
ORDER_PHYSICIAN_STATE VARCHAR(100) Y The ordering physician state
ORDER_PHYSICIAN_SUFFIX VARCHAR(100) Y The suffix of the ordering physician.
ORDER_PHYSICIAN_TITLE VARCHAR(100) Y The title of the ordering physician.
ORDER_PHYSICIAN_ZIP_CODE VARCHAR(25) Y The ordering physician's zip code
ORGANISM_OCCURRENCE_NBR DOUBLE Y Within microbiology, the organisms have a sequence. This is the sequence number of the organism that is associated with the susceptibility results.
ORG_ENCOUNTER_NBR DOUBLE Y The encounter identifier from the source system
OUTBOUND_HSS_ID DOUBLE N The unique identifier of the organization that this result will be reported to
O_PHYSICIAN_CALL_INSTRUCTIONS VARCHAR(300) Y Text field to be used to indicate any specific protocol or instructions to be followed when calling the physician number.
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_ADDRESS_1 VARCHAR(100) Y Patient's home address
PATIENT_ADDRESS_2 VARCHAR(100) Y Patient's home address
PATIENT_CITY VARCHAR(100) Y City of the patient's home
PATIENT_COUNTRY VARCHAR(50) Y Country of the patient's home
PATIENT_COUNTRY_CODE VARCHAR(10) Y The patient's country standard PHINVads code.
PATIENT_COUNTY VARCHAR(50) Y County of the patient's home
PATIENT_COUNTY_CODE VARCHAR(40) Y The source key of the county from the source system
PATIENT_FIRST_NAME VARCHAR(40) Y Patient's first name
PATIENT_ID DOUBLE N The patient unique identifier used within the Cerner Health Facts Data Warehouse.
PATIENT_LAST_NAME VARCHAR(100) Y Patient's last name
PATIENT_MAIDEN_LAST_NAME VARCHAR(100) Y The patient's maiden last name.
PATIENT_MIDDLE_NAME VARCHAR(40) Y Patient's middle name
PATIENT_NAME VARCHAR(100) Y Patient's name
PATIENT_PHONE VARCHAR(40) Y Patient's phone number
PATIENT_SSN VARCHAR(40) Y Patient's social security number
PATIENT_STATE VARCHAR(50) Y State of the patient's home
PATIENT_STATE_CODE VARCHAR(10) Y The patient state FIP code per the zipcode.
PATIENT_TYPE_DESC VARCHAR(60) Y A description of the patient type. Defines the type of visit made
PATIENT_ZIP_CODE VARCHAR(25) Y Zipcode of the patient's home
PERFORMED_BENCH_ADDRESS VARCHAR(100) Y The perform lab address derived from the bench location.
PERFORMED_BENCH_CITY VARCHAR(50) Y The perform lab city derived from the bench location.
PERFORMED_BENCH_CLIA_NBR VARCHAR(10) Y The perform lab CLIA derived from the bench location.
PERFORMED_BENCH_CODE DOUBLE Y The client code for the bench.
PERFORMED_BENCH_COUNTRY VARCHAR(100) Y The perform lab country derived from the bench location.
PERFORMED_BENCH_COUNTY VARCHAR(100) Y The perform lab county derived from the bench location.
PERFORMED_BENCH_DISPLAY VARCHAR(30) Y The perform lab display name derived from the bench location. Usually the display is 20 characters or less and used for the HL7 messages.
PERFORMED_BENCH_ID DOUBLE Y The unique identifier of the bench that was used.
PERFORMED_BENCH_NAME VARCHAR(50) Y The perform lab name derived from bench location.
PERFORMED_BENCH_PHONE VARCHAR(30) Y The perform lab phone derived from the bench location.
PERFORMED_BENCH_STATE VARCHAR(2) Y The perform lab state derived from the bench location.
PERFORMED_BENCH_ZIP VARCHAR(25) Y The perform lab zip derived from the bench location.
PERFORMED_HOSPITAL_ADDRESS VARCHAR(100) Y The address of the hospital in which the action was performed.
PERFORMED_HOSPITAL_CITY VARCHAR(50) Y The city of the hospital in which the action was performed.
PERFORMED_HOSPITAL_CLIA_NBR VARCHAR(10) Y The CLIA number for the performing hospital.
PERFORMED_HOSPITAL_CODE DOUBLE Y The identifying code of the hospital in which the action was performed.
PERFORMED_HOSPITAL_COUNTRY VARCHAR(100) Y The country of the hospital in which the action was performed.
PERFORMED_HOSPITAL_COUNTY VARCHAR(100) Y The county of the hospital in which the action was performed.
PERFORMED_HOSPITAL_DISPLAY VARCHAR(30) Y The display name of the hospital in which the action was performed.
PERFORMED_HOSPITAL_ID DOUBLE N The unique identifier of the hospital in which the action was performed.
PERFORMED_HOSPITAL_NAME VARCHAR(50) Y The name of the hospital in which the action was performed.
PERFORMED_HOSPITAL_PHONE VARCHAR(30) Y The primary phone number of the hospital in which the action was performed.
PERFORMED_HOSPITAL_STATE VARCHAR(2) Y The state of the hospital in which the action was performed.
PERFORMED_HOSPITAL_ZIP VARCHAR(25) Y The zip code of the hospital in which the action was performed.
PERFORMED_PRSNL_ADDRESS VARCHAR(100) Y The mapped perform hospital address determined from action perform personnel.
PERFORMED_PRSNL_CITY VARCHAR(50) Y The mapped perform hospital city determined from action perform personnel.
PERFORMED_PRSNL_CLIA_NBR VARCHAR(10) Y The mapped perform hospital CLIA number determined from action perform personnel.
PERFORMED_PRSNL_CODE DOUBLE Y N/A. Blank.
PERFORMED_PRSNL_COUNTRY VARCHAR(100) Y The mapped perform hospital country determined from action perform personnel.
PERFORMED_PRSNL_COUNTY VARCHAR(100) Y The mapped perform hospital county determined from action perform personnel.
PERFORMED_PRSNL_DISPLAY VARCHAR(30) Y The mapped perform hospital display name determined from action perform personnel.
PERFORMED_PRSNL_ID DOUBLE Y The mapped perform hospital id determined from action perform personnel from hf_d_hospital.
PERFORMED_PRSNL_NAME VARCHAR(50) Y The mapped perform hospital name determined from action perform personnel.
PERFORMED_PRSNL_PHONE VARCHAR(30) Y The mapped perform hospital phone determined from action perform personnel.
PERFORMED_PRSNL_STATE VARCHAR(2) Y The mapped perform hospital state determined from action perform personnel.
PERFORMED_PRSNL_ZIP VARCHAR(25) Y The mapped perform hospital zip code determined from action perform personnel.
PHIN_ABNORMAL_CODE VARCHAR(10) Y PHINVADs has defined abbreviations for abnormal flags. This translates the Health Data values to a standard code for HL7.
PHIN_ABNORMAL_DESC VARCHAR(100) Y PHINVADs has defined abbreviations for abnormal flags. This translates the Health Data values to a standard description for HL7.
PHONE_EXTENSION VARCHAR(100) Y The patient's phone extension.
POSITIVE_IND DOUBLE Y Some reportables microbiology are negative. This differentiates the positive microbiology from the negative.
PREGNANCY_STATUS VARCHAR(255) Y The raw text from pregnancy status entered by the client.
PREGNANCY_STATUS_SNOMED VARCHAR(20) Y After pregnancy status values are mapped, a standard SNOMED code is applied. This field contains the standard SNOMED code for the response.
QUALITATIVE_RESULT VARCHAR(100) Y The mapped general lab character_result (qualitative).
QUALITATIVE_RESULT_SNOMED VARCHAR(60) Y The SNOMED CT code for mapped general lab character_result (qualitative).
RACE VARCHAR(40) Y Patient's race
RAW_FACILITY_ADDRESS VARCHAR(100) Y The first address for the raw 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 facility city.
RAW_FACILITY_NAME VARCHAR(100) Y The raw facility client description.
RAW_FACILITY_PHONE VARCHAR(50) Y The unformatted phone number of the facility.
RAW_FACILITY_STATE VARCHAR(50) Y The raw facility state.
RAW_FACILITY_ZIP_CODE VARCHAR(25) Y The raw facility zip code.
REASON_FOR_STUDY_DESC VARCHAR(1000) Y The reason why the study was initiated.
RELEASE_NUMBER VARCHAR(255) Y A field with the release number to pass into the HL7 message.
REMARK VARCHAR(100) Y Blank.
REPORTING_PRIORITY_DESC VARCHAR(60) Y The textual description of the reporting priority (As Soon As Possible)
RESULT_INDICATOR_CODE VARCHAR(40) Y The dim table key used to indicate special information in regards to the gen lab result (Abnormal, Low, High, Critical, etc.)
RESULT_INDICATOR_DESC VARCHAR(60) Y A text description of the type of normality. If the result was not normal, this field indicates that the result was out of range, not normal, etc.
RESULT_INDICATOR_DISPLAY VARCHAR(45) Y The display value to indicate special information in regards to the gen lab result (Abnormal, Low, High, Critical, etc.)
RESULT_INDICATOR_MEANING VARCHAR(45) Y The Health Data standard mapped value for abnormal flag.
RESULT_TYPE_PROCEDURE_DESC VARCHAR(60) Y A textual description of the detail procedure/report (preliminary, final, etc.)
RESULT_TYPE_PROCEDURE_ID DOUBLE N The dim table key for the type of procedure that was performed
RESULT_UNIT_DESC VARCHAR(60) Y A description of the unit of measure for the result
RESULT_UNIT_DISPLAY VARCHAR(2) Y The display of the unit of measure for the result
RESULT_UNIT_UCUM VARCHAR(250) Y The standard UCUM description for the result unit.
SNOMEDCT_CODE VARCHAR(15) Y A newer version of the SNOMED code. Only populated when the SNOMEDCT code is different from the SNOMED code
SNOMED_CODE VARCHAR(15) Y The SNOMED code(s) for the isolate
SRC_FCT_KEY DOUBLE Y The identifying source key for the record.
STATE_FIPS_CODE VARCHAR(10) Y The ordering hospital two digit state FIPS code.
TOTAL_REPORT_UPDATES DOUBLE Y The total number of times reports have been entered for this micro task
UNIQUE_ORDER_ID VARCHAR(80) N Combination of fields that uniquely define an order
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated.
VERIFIED_DT_TM DATETIME Y The date and time in which the result was verified.
VERIFIED_PRSNL_INITIALS VARCHAR(100) Y The initials of the personnel that verified the results.
VERIFIED_PRSNL_NAME VARCHAR(100) Y The full name of the personnel that validated the results.
VERIFIED_PRSNL_PREFIX VARCHAR(100) Y The prefix of the personnel that verified the results.
VERIFIED_PRSNL_SUFFIX VARCHAR(100) Y The suffix of the personnel that verified the results.
VERIFIED_PRSNL_TITLE VARCHAR(100) Y The title of the personnel that verified the results.
VITAL_STATUS VARCHAR(60) Y A field that identifies alive, deceased status.
WEIGHT DOUBLE Y Patient's weight
WEIGHT_UNIT_DISPLAY VARCHAR(40) Y The display of the unit of measure


HF_R_MICRO_FULL_TEXT



Column Section Top of Page


Table-level Detail

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





Column Detail - HF_R_MICRO_FULL_TEXT


Column Name Type Null? Definition
ACCESSION VARCHAR(100) Y The primary accession number identifies an order or a group of orders.
CLIENT_ORDER_CULTURE_NAME VARCHAR(100) Y The client display value for the ordered lab procedure
CLIENT_REPORT_VALUE VARCHAR(200) Y The textual value of the report response. This can be either free text or the code value description of a codified response
COMPLETED_DT_TM DATETIME Y The date/time the micro order was completed
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
FALSE_POSITIVE_IND DOUBLE Y When a response is marked as positive but the system has detected a negating phrase surrounding the response, this will be set to 1. For all other rows, it will be set to 0
FINANCIAL_NBR VARCHAR(40) Y The formatted Financial number
FINANCIAL_NBR_RAW VARCHAR(40) Y The unformatted Financial number.
GENDER VARCHAR(60) Y Patient's gender
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
MICRO_RESPONSE_SEQUENCE DOUBLE Y The field contains a value that uniquely identifies each report response. This value will allow multiples of the same report response to be uniquely identified.
MICRO_TASK_ID DOUBLE N A unique identifier for a micro task. Combine with Micro_Response_Sequence for an alternate key into this table
ORDER_LAB_PROCEDURE_ID DOUBLE N The dim table key for the ordered lab procedure
ORG_ENCOUNTER_NBR DOUBLE Y The encounter identifier from the source system
OUTBOUND_HSS_ID DOUBLE N The unique identifier of the organization that this result will be reported to
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.
PATIENT_NAME VARCHAR(100) Y Patient's name
PERFORMED_HOSPITAL_ID DOUBLE Y The Health Data hospital identifier for the perform laboratory if determined from the facility information.
POSITIVE_IND VARCHAR(1) Y This field identifies whether or not the response has been defined as a positive report response. Valid values include: 0 = negative response 1= positive response
REPORTABLE_ISOLATE_IND DOUBLE Y Indicates if the row of text in the micro response was reportable or not as an isolate
RESPONSE_CLASS_FLG VARCHAR(10) Y This field identifies the type of response used in issuing the report. 0 - Textual Response 5 - Coded Response 6 - Member of a Group Response 101 - Organism
RESULT_TYPE_PROCEDURE_DESC VARCHAR(60) Y A textual description of the detail procedure/report (preliminary, final, etc.)
SRC_FCT_KEY VARCHAR(100) Y The identifying source key for the record.
TASK_TYPE_FLG VARCHAR(10) Y This field identifies a value that determines the task type associated with the task entered. The task type further categorizes similar tasks within each task class.


HF_R_MICRO_SUSCEPTIBILITY



Column Section Top of Page


Table-level Detail

Description: HF_R_MICRO_SUSCEPTIBILITY
Definition: BLANK
Table Type: REFERENCE





Column Detail - HF_R_MICRO_SUSCEPTIBILITY


Column Name Type Null? Definition
ACCESSION VARCHAR(20) Y The primary accession number identifies an order or a group of orders.
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.
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_DT_TM DATETIME Y The date in which the patient was registered.
ADMIT_PHYSICIAN_ADDRESS VARCHAR(100) Y The admitting physician's address.
ADMIT_PHYSICIAN_CITY VARCHAR(100) Y The admitting physician's city.
ADMIT_PHYSICIAN_EMAIL VARCHAR(100) Y The admitting physician's email address.
ADMIT_PHYSICIAN_FAX VARCHAR(50) Y The admitting physician's fax number.
ADMIT_PHYSICIAN_MOBILE VARCHAR(100) Y The admitting physician's mobile phone number.
ADMIT_PHYSICIAN_NAME VARCHAR(100) Y The admitting physician's name.
ADMIT_PHYSICIAN_NPI VARCHAR(200) Y The NPI for the admitting physician.
ADMIT_PHYSICIAN_PHONE VARCHAR(30) Y The admitting physician's primary phone number.
ADMIT_PHYSICIAN_STATE VARCHAR(100) Y The admitting physician's state.
ADMIT_PHYSICIAN_ZIP_CODE VARCHAR(25) Y The zip code of the admitting physician.
ADMIT_TM_ZN DOUBLE Y The time zone of the admit date/time.
AGE_IN_YEARS DOUBLE Y The age in years of the patient at time of registration.
ALT_PATIENT_ADDRESS_1 VARCHAR(100) Y The first address for the person's alternative information.
ALT_PATIENT_ADDRESS_2 VARCHAR(100) Y The second address for the person's alternative information.
ALT_PATIENT_CITY VARCHAR(100) Y The city for the person's alternative information.
ALT_PATIENT_COUNTRY VARCHAR(100) Y The country for the person's alternative information.
ALT_PATIENT_COUNTY VARCHAR(100) Y The county for the person's alternative information.
ALT_PATIENT_FIRST_NAME VARCHAR(100) Y The first name for the person's alternative name.
ALT_PATIENT_LAST_NAME VARCHAR(100) Y The last name for the person's alternative name.
ALT_PATIENT_NAME_INITIALS VARCHAR(100) Y The initials for the person's alternative name.
ALT_PATIENT_NAME_PREFIX VARCHAR(100) Y The prefix for the person's alternative name.
ALT_PATIENT_NAME_SUFFIX VARCHAR(100) Y The suffix for the person's alternative name.
ALT_PATIENT_NAME_TITLE VARCHAR(100) Y The title for the person's alternative name.
ALT_PATIENT_STATE VARCHAR(100) Y The state for the person's alternative information.
ALT_PATIENT_ZIP_CODE VARCHAR(25) Y The zip code for the person's alternative information.
ANTIMICROBIAL_DESC VARCHAR(50) Y The textual description of an antimicrobial
ANTIMICROBIAL_ID DOUBLE N The dim table key for the antimicrobial being used in the susceptibility test
ANTIMICROBIAL_LOINC VARCHAR(10) Y The LOINC for the antimicrobial
ANTIMICROBIAL_LOINC_LONG VARCHAR(255) Y The long RELMA description for the mapped antimicrobial.
ANTIMICROBIAL_LOINC_SHORT VARCHAR(60) Y The short RELMA description for the mapped antimicrobial.
ANTIMICROBIAL_MNEMONIC VARCHAR(10) Y A standard (NCLS) abbreviation for an antimicrobial
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_EMAIL VARCHAR(100) Y The attending physician's email address.
ATTEND_PHYSICIAN_FAX VARCHAR(50) Y The attending physician's fax number.
ATTEND_PHYSICIAN_MOBILE VARCHAR(100) Y The attending physician's mobile phone number.
ATTEND_PHYSICIAN_NAME VARCHAR(100) Y The name of the attending physician.
ATTEND_PHYSICIAN_NPI VARCHAR(200) Y The NPI for the attending physician.
ATTEND_PHYSICIAN_PHONE VARCHAR(30) Y The primary phone number of the attending physician.
ATTEND_PHYSICIAN_STATE VARCHAR(100) Y The State of the attending physician.
ATTEND_PHYSICIAN_ZIP_CODE VARCHAR(25) Y The zip code of the attending physician.
BIRTH_DT_TM DATETIME Y The patient's birth date.
BUSINESS_CALL_INSTRUCTIONS VARCHAR(300) Y Text field to be used to indicate any specific protocol or instructions to be followed when calling the business phone number.
BUSINESS_PHONE VARCHAR(100) Y The patient's business phone
BUSINESS_PHONE_EXTENSION VARCHAR(100) Y The patient's business phone number extension.
CALL_INSTRUCTION VARCHAR(300) Y Text field to be used to indicate any specific protocol or instructions to be followed when calling the patient's number.
CARESETTING_DESC VARCHAR(40) Y The mapped caresetting for the ordering location.
CLIA_NBR VARCHAR(10) Y The ordering hospital CLIA number.
CLIENT_ABX_CODE VARCHAR(40) Y The client code value from code set 1011 for the antimicrobial.
CLIENT_ABX_DESC VARCHAR(100) Y The client code value description from code set 1011 for the antimicrobial.
CLIENT_ABX_DISPLAY VARCHAR(45) Y The client code value display from code set 1011 for the antimicrobial.
CLIENT_ABX_MEANING VARCHAR(45) Y The client code value CDF meaning from code set 1011 for the antimicrobial.
CLIENT_METHOD_CODE VARCHAR(40) Y The client code value from code set 2058 for the collection method.
CLIENT_METHOD_DESC VARCHAR(100) Y The client code value description from code set 2058 for the collection method.
CLIENT_METHOD_DISPLAY VARCHAR(45) Y The client code value display from code set 2058 for the collection method.
CLIENT_METHOD_MEANING VARCHAR(45) Y The client code value CDF meaning from code set 2058 for the collection method.
CLIENT_ORDERABLE_CONCEPT_NAME VARCHAR(255) Y The client LOINC code concept description for the orderable.
CLIENT_ORDERABLE_LOINC_CODE VARCHAR(10) Y The client assigned LOINC code for orderable.
CLIENT_ORDERABLE_LOINC_DESC VARCHAR(255) Y The client LOINC code description for the orderable.
CLIENT_ORDER_CODE VARCHAR(40) Y The client orderable number from code set 200.
CLIENT_ORDER_DESC VARCHAR(100) Y The client orderable description from code set 200.
CLIENT_ORDER_DISPLAY VARCHAR(45) Y The client orderable mnemonic from code set 200.
CLIENT_ORGANISM_CODE VARCHAR(40) Y The client code value from code set 1021/1022 for the organism or codified result.
CLIENT_ORGANISM_DESC VARCHAR(100) Y The client code value description from code set 1021/1022 for the organism or codified result.
CLIENT_ORGANISM_DISPLAY VARCHAR(45) Y The client code value display from code set 1021/1022 for the organism or codified result.
CLIENT_ORGANISM_MEANING VARCHAR(45) Y The client code value CDF meaning from code set 1021/1022 for the organism or codified result.
CLIENT_RESULT_IND_CODE VARCHAR(40) Y The client code value code for the abnormal indicator. Code set 52.
CLIENT_RESULT_IND_DESC VARCHAR(100) Y The client code value description for the abnormal indicator. Code set 52.
CLIENT_RESULT_IND_DISPLAY VARCHAR(45) Y The client code value display for the abnormal indicator. Code set 52.
CLIENT_SITE_CODE VARCHAR(40) Y The client code value from code set 1028 for the body site.
CLIENT_SITE_DESC VARCHAR(100) Y The client code value description from code set 1028 for the body site.
CLIENT_SITE_DISPLAY VARCHAR(45) Y The client code value display from code set 1028 for the body site.
CLIENT_SITE_MEANING VARCHAR(45) Y The client code value CDF meaning from code set 1028 for the body site.
CLIENT_SPECIMEN_CODE VARCHAR(40) Y The client code value from code set 2052 for the specimen.
CLIENT_SPECIMEN_DESC VARCHAR(100) Y The client code value description from code set 2052 for the specimen.
CLIENT_SPECIMEN_DISPLAY VARCHAR(45) Y The client code value display from code set 2052 for the specimen.
CLIENT_SPECIMEN_MEANING VARCHAR(45) Y The client code value CDF meaning from code set 2052 for the specimen.
CLIENT_UNIT_CODE VARCHAR(40) Y The client code value from code set 54 for the unit of measure.
CLIENT_UNIT_DESC VARCHAR(100) Y The client code value description from code set 54 for the unit of measure.
CLIENT_UNIT_DISPLAY VARCHAR(45) Y The client code value display from code set 54 for the unit of measure.
CLIENT_UNIT_MEANING VARCHAR(45) Y The client code value CDF meaning from code set 54 for the unit of measure.
COLLECTION_METHOD_CODE VARCHAR(6) Y The code of the procedure for collecting a specimen.
COLLECTION_METHOD_DESC VARCHAR(40) Y The description of the procedure for collecting a specimen.
COLLECTION_METHOD_ID VARCHAR(40) Y The identifier for the procedure for collecting a specimen.
COLLECTION_METHOD_MOD_DESC VARCHAR(100) Y The standard modifier description for the collection method modifier. A modifier is the left, right, upper, lower location for the collection method.
COLLECTION_METHOD_MOD_SNOMED VARCHAR(10) Y The SNOMED CT code for the collection method modifier. A modifier is the left, right, upper, lower location for the collection method.
COLLECTION_METHOD_SNOMED VARCHAR(10) Y The HealthSentry assigned SNOMED CT for the collection method.
COLLECTION_SITE_CODE VARCHAR(6) Y The SNOMED CT code for collection site from an HL7 file.
COLLECTION_SITE_DESC VARCHAR(40) Y The collection site for the microbiology specimen.
COLLECTION_SITE_ID DOUBLE N The dim table key for the collection site of the isolate.
COLLECTION_SITE_MOD_DESC VARCHAR(100) Y The standard modifier description for the body site modifier. A modifier is the left, right, upper, lower location for the site.
COLLECTION_SITE_MOD_SNOMED VARCHAR(10) Y The SNOMED code for the body site modifier. A modifier is the left, right, upper, lower location for the body site.
COLLECTION_SITE_SNOMED VARCHAR(10) Y The HealthSentry assigned SNOMED CT for the collection site.
COLLECTION_SOURCE_CODE VARCHAR(6) Y The SNOMED CT code for specimen.
COLLECTION_SOURCE_DESC VARCHAR(40) Y The collection specimen for the microbiology order.
COLLECTION_SOURCE_ID DOUBLE N The dim table key for the collection specimen of the isolate.
COLLECTION_SOURCE_SNOMED VARCHAR(10) Y The HealthSentry assigned SNOMED CT for the collection specimen.
COLLECTION_SRC_MOD_DESC VARCHAR(100) Y The standard modifier description for the collection specimen modifier. A modifier is the left, right, upper, lower location for the specimen.
COLLECTION_SRC_MOD_SNOMED VARCHAR(10) Y The SNOMED CT code for the collection specimen modifier. A modifier is the left, right, upper, lower location for the specimen.
COUNTY_FIPS_CODE VARCHAR(10) Y The ordering hospital three digit county FIPS code.
DECEASED_DT_TM DATETIME Y The date on which a person died or is officially deemed to have died.
DIRECTOR_FIRST_NAME VARCHAR(100) Y The hospital's director's first first name.
DIRECTOR_LAST_NAME VARCHAR(100) Y The hospital's director's last name.
DIRECTOR_MIDDLE_NAME VARCHAR(100) Y The hospital's director's middle name.
DIRECTOR_PREFIX VARCHAR(10) Y The hospital's director's prefix.
DIRECTOR_SUFFIX VARCHAR(10) Y The hospital's director's suffix.
DIRECTOR_TITLE VARCHAR(10) Y The hospital's director's title.
DISCHARGED_DT_TM DATETIME Y The date time in which the patient was discharged.
DISCHARGE_DISP_DESC VARCHAR(190) Y The mapped description for discharge disposition.
EMAIL_ADDRESS VARCHAR(100) Y The patient's email address
ENCOUNTER_ID DOUBLE N 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.
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 N The health system that the hospital belongs to.
HOSPITAL_ADDRESS VARCHAR(100) Y The address of the hospital as defined by HealthSentry.
HOSPITAL_ADDRESS_2 VARCHAR(100) Y The second line of the hospital's address.
HOSPITAL_CALL_INSTRUCTIONS VARCHAR(300) Y Text field to be used to indicate any specific protocol or instructions to be followed when calling the hospital number.
HOSPITAL_CITY VARCHAR(50) Y The city of the hospital as defined by HealthSentry.
HOSPITAL_CODE DOUBLE Y The hospital code.
HOSPITAL_COUNTRY VARCHAR(100) Y The country of the hospital for the ordering hospital.
HOSPITAL_COUNTY VARCHAR(100) Y The county of the hospital for the ordering hospital.
HOSPITAL_DISPLAY VARCHAR(30) Y The display value of the hospital name.
HOSPITAL_EXTENSION VARCHAR(100) Y The phone extension of the hospital.
HOSPITAL_ID DOUBLE N 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 ordering hospital as defined by HealthSentry.
HOSPITAL_OID VARCHAR(100) N 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_ZIP VARCHAR(20) Y The zip code of the hospital as defined by HealthSentry.
INTERP_RESULT_DESC VARCHAR(60) Y The textual description of an interpretative result
INTERP_RESULT_ID DOUBLE N The dim table key for the interpretive result.
ISOLATE_ID DOUBLE N The dim table key for the isolate against which the susceptibility test is run
ISOLATE_NAME VARCHAR(50) Y The mapped description for the isolate.
ISOLATE_REPT_CATEGORY VARCHAR(30) Y The reporting category for the isolate. Typically the genus; however sometimes this is at a finer grain than the genus
ISOLATE_TYPE VARCHAR(25) Y A high level category for the isolate such as Bacteria, Virus, Fungus.
LAB_COMPLETED_DT_TM DATETIME Y The date/time the micro order was completed
LAB_DRAWN_DT_TM DATETIME Y The date/time the specimen was drawn
LAB_PERFORMED_DT_TM DATETIME Y The date and time in which the lab was performed.
LAB_PROCEDURE_NAME VARCHAR(100) Y The mapped lab procedure name for the detail test if general lab or orderable for microbiology.
LAB_RECEIVED_DT_TM DATETIME Y The date/time the specimen was received
LOINC_CODE VARCHAR(10) Y The PHIN approved LOINC codes used for reporting purposes.
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 N The unique identifier for the type or category of medical service that was received.
MICRO_RESULT_TYPE_DESC VARCHAR(60) Y The description for the micro result type. This is similar to micro_result_type and more specific for the stains.
MICRO_RESULT_TYPE_ID DOUBLE N The dim table key for the type of micro result (preliminary, final, etc.)
MOBILE_NUMBER VARCHAR(100) Y The patient's mobile phone number.
MOTHER_MAIDEN_FIRST_NAME VARCHAR(200) Y The patient's mother's maiden first name.
MOTHER_MAIDEN_LAST_NAME VARCHAR(200) Y The patient's mother's maiden last name.
MOTHER_MAIDEN_NAME_INITIALS VARCHAR(100) Y The patient's mother's maiden name initials.
MOTHER_MAIDEN_NAME_PREFIX VARCHAR(100) Y The patient's mother's maiden name prefix.
MOTHER_MAIDEN_NAME_SUFFIX VARCHAR(100) Y The patient's mother's maiden name suffix.
MOTHER_MAIDEN_NAME_TITLE VARCHAR(100) Y The patient's mother's maiden name title.
NAME_INITIALS VARCHAR(100) Y The initials for the person's name.
NAME_PREFIX VARCHAR(100) Y The prefix for the person's name.
NAME_SUFFIX VARCHAR(100) Y The suffix for the person's name.
NAME_TITLE VARCHAR(100) Y The title for the person's name.
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_CALL_INSTRUCTIONS VARCHAR(300) Y Text field to be used to indicate any specific protocol or instructions to be followed when calling the next of kin number.
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_PHONE_EXTENSION VARCHAR(100) Y The patient's next of kin's phone extension.
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.
NOK_COUNTRY VARCHAR(50) Y The country of the patient's next of kin.
NOK_COUNTY VARCHAR(50) Y The county of the patient's next of kin.
NOK_EMAIL VARCHAR(100) Y The email address of the patient's next of kin.
NOK_NAME_INITIALS VARCHAR(100) Y The initials of the patient's next of kin name.
NOK_NAME_PREFIX VARCHAR(100) Y The prefix of the patient's next of kin name.
NOK_NAME_SUFFIX VARCHAR(100) Y The suffix of the patient's next of kin name.
NOK_NAME_TITLE VARCHAR(100) Y The title of the patient's next of kin name.
NPI VARCHAR(10) Y The NPI for the perform hospital.
NUMERIC_RESULT VARCHAR(40) Y A numeric/alpha numeric result for this susceptibility test.
ORDERABLE_LOINC_CODE VARCHAR(10) Y The LOINC code for the orderable.
ORDERABLE_LOINC_CODE_LONG VARCHAR(255) Y The long RELMA description for the mapped orderable LOINC.
ORDERABLE_LOINC_CODE_SHORT VARCHAR(60) Y The short RELMA description for the mapped orderable LOINC
ORDERED_DT_TM DATETIME Y The date/time an order was placed.
ORDER_CARESETTING_RAW VARCHAR(40) Y The client value representing the location (nursing or ambulatory unit) where the test was ordered.
ORDER_LAB_PROCEDURE_ID DOUBLE N The dim table key for the ordered lab procedure.
ORDER_PHYSICIAN_ADDRESS VARCHAR(100) Y The ordering physician's address.
ORDER_PHYSICIAN_ADDRESS_2 VARCHAR(255) Y The second line of the ordering physician's address.
ORDER_PHYSICIAN_CITY VARCHAR(100) Y The ordering physician's city.
ORDER_PHYSICIAN_COUNTRY VARCHAR(100) Y The country of the ordering physician.
ORDER_PHYSICIAN_COUNTY VARCHAR(100) Y The county of the ordering physician.
ORDER_PHYSICIAN_EMAIL VARCHAR(100) Y The ordering physician's email address.
ORDER_PHYSICIAN_EXTENSION VARCHAR(100) Y The phone extension of the ordering physician.
ORDER_PHYSICIAN_FAX VARCHAR(50) Y The ordering physician's fax number.
ORDER_PHYSICIAN_FIRST_NAME VARCHAR(100) Y The ordering physician's first name.
ORDER_PHYSICIAN_INITIALS VARCHAR(100) Y The three character initial abbreviation of the ordering physician's name.
ORDER_PHYSICIAN_LAST_NAME VARCHAR(100) Y The ordering physician's last name.
ORDER_PHYSICIAN_MIDDLE_NAME VARCHAR(100) Y The ordering physician's middle name.
ORDER_PHYSICIAN_MOBILE VARCHAR(100) Y The ordering physician's mobile phone number.
ORDER_PHYSICIAN_NAME VARCHAR(100) Y The ordering physician's full name.
ORDER_PHYSICIAN_NPI VARCHAR(200) Y The NPI for the ordering physician.
ORDER_PHYSICIAN_PHONE VARCHAR(30) Y The ordering physician's primary phone number.
ORDER_PHYSICIAN_PREFIX VARCHAR(100) Y The prefix of the ordering physician.
ORDER_PHYSICIAN_STATE VARCHAR(100) Y The ordering physician's state.
ORDER_PHYSICIAN_SUFFIX VARCHAR(100) Y The suffix of the ordering physician.
ORDER_PHYSICIAN_TITLE VARCHAR(100) Y The title of the ordering physician.
ORDER_PHYSICIAN_ZIP_CODE VARCHAR(25) Y The ordering physician's zip code.
ORGANISM_OCCURRENCE_NBR DOUBLE Y Within microbiology, the organisms have a sequence. This is the sequence number of the organism that is associated with the susceptibility results.
ORG_ENCOUNTER_NBR DOUBLE Y The encounter identifier from the source system.
OUTBOUND_HSS_ID DOUBLE N The unique identifier of the organization that this result will be reported to.
O_PHYSICIAN_CALL_INSTRUCTIONS VARCHAR(300) Y Text field to be used to indicate any specific protocol or instructions to be followed when calling the physician number.
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_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 N The unique identifier of the patient.
PATIENT_LAST_NAME VARCHAR(100) Y The last name of the patient.
PATIENT_MAIDEN_LAST_NAME VARCHAR(200) Y The patient's maiden last name.
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 The patient state FIP code per the zipcode.
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.
PERFORMED_BENCH_ADDRESS VARCHAR(100) Y The mapped perform hospital address determined from the bench level.
PERFORMED_BENCH_CITY VARCHAR(50) Y The mapped perform hospital city determined from the bench level.
PERFORMED_BENCH_CLIA_NBR VARCHAR(10) Y The mapped perform hospital CLIA number determined from the bench level.
PERFORMED_BENCH_CODE DOUBLE Y N/A. Blank.
PERFORMED_BENCH_COUNTRY VARCHAR(100) Y The mapped perform hospital country determined from the bench level.
PERFORMED_BENCH_COUNTY VARCHAR(100) Y The mapped perform hospital county determined from the bench level.
PERFORMED_BENCH_DISPLAY VARCHAR(30) Y The mapped perform hospital display name determined from the bench level.
PERFORMED_BENCH_ID DOUBLE N The perform hospital mapped at the bench level. The ID from hf_d_hospital.
PERFORMED_BENCH_NAME VARCHAR(50) Y The mapped perform hospital name determined from the bench level.
PERFORMED_BENCH_PHONE VARCHAR(30) Y The mapped perform hospital phone number determined from the bench level.
PERFORMED_BENCH_STATE VARCHAR(2) Y The mapped perform hospital state determined from the bench level.
PERFORMED_BENCH_ZIP VARCHAR(25) Y The mapped perform hospital zip determined from the bench level.
PERFORMED_HOSPITAL_ADDRESS VARCHAR(100) Y The address of the hospital in which the action was performed.
PERFORMED_HOSPITAL_CITY VARCHAR(50) Y The city of the hospital in which the action was performed.
PERFORMED_HOSPITAL_CLIA_NBR VARCHAR(10) Y The CLIA number for the performing hospital.
PERFORMED_HOSPITAL_CODE DOUBLE Y The identifying code of the hospital in which the action was performed.
PERFORMED_HOSPITAL_COUNTRY VARCHAR(100) Y The country of the performing hospital.
PERFORMED_HOSPITAL_COUNTY VARCHAR(100) Y The county of the performing hospital.
PERFORMED_HOSPITAL_DISPLAY VARCHAR(30) Y The display value of the performed hospital name.
PERFORMED_HOSPITAL_ID DOUBLE N The unique identifier of the hospital in which the action was performed.
PERFORMED_HOSPITAL_NAME VARCHAR(50) Y The name of the hospital in which the action was performed.
PERFORMED_HOSPITAL_PHONE VARCHAR(30) Y The primary phone number of the hospital in which the action was performed.
PERFORMED_HOSPITAL_STATE VARCHAR(2) Y The state of the hospital in which the action was performed.
PERFORMED_HOSPITAL_ZIP VARCHAR(25) Y The zip code of the hospital in which the action was performed.
PERFORMED_PRSNL_ADDRESS VARCHAR(100) Y The mapped perform hospital address determined from action perform personnel.
PERFORMED_PRSNL_CITY VARCHAR(50) Y The mapped perform hospital city determined from action perform personnel.
PERFORMED_PRSNL_CLIA_NBR VARCHAR(10) Y The mapped perform hospital CLIA number determined from action perform personnel.
PERFORMED_PRSNL_CODE DOUBLE Y N/A. Blank.
PERFORMED_PRSNL_COUNTRY VARCHAR(100) Y The mapped perform hospital country determined from action perform personnel.
PERFORMED_PRSNL_COUNTY VARCHAR(100) Y The mapped perform hospital county determined from action perform personnel.
PERFORMED_PRSNL_DISPLAY VARCHAR(30) Y The mapped perform hospital display name determined from action perform personnel.
PERFORMED_PRSNL_ID DOUBLE N The mapped perform hospital id determined from action perform personnel from hf_d_hospital.
PERFORMED_PRSNL_NAME VARCHAR(50) Y The mapped perform hospital name determined from action perform personnel.
PERFORMED_PRSNL_PHONE VARCHAR(30) Y The mapped perform hospital phone determined from action perform personnel.
PERFORMED_PRSNL_STATE VARCHAR(2) Y The mapped perform hospital state determined from action perform personnel.
PERFORMED_PRSNL_ZIP VARCHAR(25) Y The mapped perform hospital zip code determined from action perform personnel.
PHONE_EXTENSION VARCHAR(100) Y The patient's phone extension
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_PHONE VARCHAR(50) Y The phone number for the raw ordering facility.
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_STUDY_DESC VARCHAR(1000) Y ICD code and descriptions for the visit selected by a clinician. This is often missing.
RELEASE_NUMBER VARCHAR(255) Y The Health Data release number at the time of the record being updated.
REMARK VARCHAR(100) Y Blank.
RESULT_INDICATOR_DESC VARCHAR(60) Y The mapping description of the normality of the result (out of range, not normal, etc.).
RESULT_TYPE_PROCEDURE_DESC VARCHAR(60) Y A textual description of the detail procedure/report (preliminary, final, etc.)
RESULT_TYPE_PROCEDURE_ID DOUBLE N The dim table key for the type of procedure that was performed
RESULT_UNIT_DESC VARCHAR(60) Y The description for the result unit.
RESULT_UNIT_DISPLAY VARCHAR(40) Y The display of the unit of measure for the result.
RESULT_UNIT_UCUM VARCHAR(250) Y The standard UCUM description for the susceptibility result unit.
SNOMEDCT_CODE VARCHAR(15) Y The SNOMED CT code for the isolate.
SNOMED_CODE VARCHAR(15) Y The SNOMED code for the isolate.
SRC_FCT_KEY VARCHAR(100) Y The internal identifier of the fact table from which the record came.
STATE_FIPS_CODE VARCHAR(10) Y The ordering hospital two digit state FIPS code.
TEST_TYPE_DESC VARCHAR(40) Y The textual description for the type of susceptibility test (Minimum Inhibitory Concentration, Kirby Bauer, etc.)
TEST_TYPE_ID DOUBLE N The dim table key for the type of susceptibility test
TEST_TYPE_MNEMONIC VARCHAR(25) Y A standard abbreviation for the type of susceptibility test (MIC, KB, etc.)
UNIQUE_ORDER_ID VARCHAR(80) Y The unique identifier of the order.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated.
VERIFIED_DT_TM DATETIME Y Date and time this result / event is verified
VERIFIED_PRSNL_INITIALS VARCHAR(100) Y The initials of the personnel that verified the results.
VERIFIED_PRSNL_NAME VARCHAR(100) Y The full name of the personnel that verified the results.
VERIFIED_PRSNL_PREFIX VARCHAR(100) Y The prefix of the personnel that verified the results.
VERIFIED_PRSNL_SUFFIX VARCHAR(100) Y The suffix of the personnel that verified the results.
VERIFIED_PRSNL_TITLE VARCHAR(100) Y The title of the personnel that verified the results.
VITAL_STATUS VARCHAR(60) Y The mapped vital status for there person: alive, deceased, or unknown.
WEIGHT DOUBLE Y The weight entered on the encounter record. Mostly blank or out of date.
WEIGHT_UNIT_DISPLAY VARCHAR(40) Y The unit for weight from the encounter record. Mostly blank.