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