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. |