Server (Cells) Design
Space shortcuts
Space Tools
Skip to end of metadata
Go to start of metadata


patient_data

The root element that holds data from the patient data tables. May contain any number of observation_sets, and none or one patient_set, event_set, concept_set, observer_set, code_set, pid_set, or eid_set. They can occur in any order.

 

 

event_set

Data from the VISIT_DIMENSION table.

event

One row of data from the VISIT_DIMENSION table.

event_id

A choice between ENCOUNTER_NUM (if source is HIVE) and ENCOUNTER_ID if another source. As source with "_e" at the end is encrypted.

patient_id

A choice between PATIENT_NUM (if source is HIVE) and PATIENT_ID if another source. As source with "_e" at the end is encrypted.

start_date

The date-time that the event started.

end_date

The date-time that the event ended.

active_status_cd

A code to represent the meaning of the date fields above (START_DATE & END_DATE).

param

 

event_blob

XML data that includes partially structured and unstructured data about a visit.

 

 

concept_set

Data from the CONCEPT_DIMENSION table.

concept

One row of data from the CONCEPT_DIMENSION table.

concept_path

 

concept_cd

A unique code that represents a concept.

name_char

A string name that represents this concept, idea or person.

concept_blob

XML data that includes partially structured and unstructured data about a concept.

 

 

observer_set

Data from the PROVIDER_DIMENSION table.

observer

One row of data from the PROVIDER_DIMENSION table.

observer_path

 

observer_cd

A unique code that represents an observer (provider).

name_char

A string name that represents the observer, it could be person or machine.

observer_blob

XML data that includes partially structured and unstructured data about an observer.

 

 

code_set

Data from the CODE_LOOKUP table.

code

One row of data from the CODE_LOOKUP table.

table_cd

The name of one of the 8 tables represented in the PDO.

column_cd

The column name in the table where there code is found.

code_cd

The code itself.

name_char

The human-readable description of what the code represents.

 

 

pid_set

Data from the PATIENT_MAPPING table.

pid

One set of mappings on a single PATIENT_NUM.

patient_id

A choice between PATIENT_NUM (if the source is HIVE) and PATIENT_ID (if another source is defined). A source with "_e" at the end is encrypted.

patient_map_id

A PATIENT_ID that should have the same PTIENT_NUM as the PATIENT_ID in the PID.

 

 

eid_set

Data from the ENCOUNTER_MAPPING table.

eid

One set of mappings on a single ENCOUNTER_NUM.

event_id

A choice between ENCOUNTER_NUM (if the source is HIVE) and ENCOUNTER_ID (if another source is defined). A source with "_e" at the end is encrypted.

event_map_id

An ENCOUNTER_ID that should have the same PATIENT_NUM as the VISIT_ID in this EID.

 

 

observation_set

 

observation

One row of data from the OBSERVATION_FACT table.

event_id

A choice between ENCOUNTER_NUM (if the source is HIVE) and ENCOUNTER_ID (if another source is defined). A source with "_e" at the end is encrypted.

patient_id

A choice between PATIENT_NUM (if the source is HIVE) and PATIENT_ID (if another source is defined). A source with "_e" at the end is encrypted.

concept_cd

A unique code that represents a concept.

observer_cd

A unique code that represents an observer (provider).

start_date

The date that the observation was made or the observation started. If the date is derived or calculated from another observation (like a report) then the start date is the same as the observation it was derived or calculated from.

modifier_cd

The modifier code for a concept or provider.

valtype_cd

A code representing whether a value is stored in the TVAL_CHAR, NVAL_NUM, or OBSERVATION_BLOB columns.

tval_char

A text value.

nval_num

A numerical value.

valueflag_cd

A code that represents the type of value present in the NVAL_NUM, the TVAL_CHAR, or OBSERVATION_BLOB columns.

quantity_num

The number of observations represented by this fact.

units_cd

A textual description of the units associated with a value.

end_date

The date that the observation ended. If the date is derived or calculated from another observation (like a report) then the end date is the same as the observation it was derived or calculated from.

location_cd

A code representing the hospital associated with this visit.

confidence_num

A code or number representing the confidence in the accuracy of the data.

observation_blob

XML data that includes partially structured and unstructured data about an observation.

 

 

patient_set

Data from the PATIENT_DIMENSION table.

patient

One row of data from the PATIENT_DIMENSION table.

patient_id

A choice between PATIENT_NUM (if the source is HIVE) and PATIENT_ID (if another source is defined). A source with "_e" at the end is encrypted.

birth_date

The date-time the patient was born.

death_date

The date-time the patient died.

vital_status_cd

A code to represent the meaning of the date fields above (BIRTH_DATE & DEATH_DATE).

param

 

patient_blob

XML data that includes partially structured and unstructured data about a patient.

 

 

annotationGroup

A group of fields that appear together at the end of all tables and store annotation or administrative information.

update_date

The date the data was last updated according to the source system from which the data was obtained. If the source system dos not supply this data, it defaults to the DOWNLOAD_DATE.

download_date

The date the data was obtained from the source system. If the data is derived or calculated from other data then the DOWNLOAD_DATE is the date of the calculation.

import_date

The date the data is placed into the table of the data mart.

sourcesystem_cd

A code representing the source system that provided the data.

upload_id

A tracking number assigned to any file uploaded.

  • No labels