The following tables are not currently in the 2.2 Schema
Table |
Comment |
Addressed in ERD |
|---|---|---|
agent_queue_item |
replace with JMS Queue. It was never used anyways. |
Yes |
comment |
renamed to clinical_note for oracle compliance |
Yes |
event |
dropped for new auditing tables |
Yes |
event_action |
dropped for new auditing tables |
Yes |
event_type |
dropped for new auditing tables |
Yes |
loinc |
not a part of the installation; Noted in ERD for display purposes. |
Yes |
mirth_results_user_cl_item_type |
renamed for oracle compliance to mirth_results_user_cl_itm_type |
Yes |
person_event |
* possible new table |
Yes |
service_event |
* possible new table |
WIP |
The following tables are new tables added for 2.2
Table |
Comment |
Addressed in ERD |
|---|---|---|
administrative_gender |
created by concept_class loader |
N/A |
clin_mess_del_doc_type |
Clinical Message Delivery can do filtering on different doc types. For example only send ADT. This table helps keeps track of the different doc types CMD can handle |
Yes |
clin_mess_del_queue_item |
Table for handling the CMD queue. Used for processing and re-processing. |
Yes |
clin_mess_dest_type |
CMD can utilize different methods for delivery data. This table keeps track of the available delivery types. |
Yes |
clinical_note |
oracle rename |
Yes |
coded_element_bk |
migration script didnt drop this table it seems...should be dropped |
Yes |
concept_class_alias |
defines aliases for concept classes e.g. SNMD-CT to correlate to our SMOMED_CT class name |
Yes |
document_set |
xds...new clinical item type for document set |
Yes |
entity_change_log |
For Mirth Analytics |
NA |
hcpcs_ii |
this should not be here because it should be part of another Concept Class |
Yes |
hl7 |
part of defaul concept load |
Yes |
import |
importing subjects, providers |
Yes |
mirth_results_user_cl_itm_type |
oracle rename |
Yes |
prv_grp_clin_mess_del_doc_type |
clinical message delivery |
Yes |
sequence_table |
for making sequences db agnostic |
NA |
sub_grp_prv_grp |
linkage between subject group and provider group |
Yes |
subject_demographic |
jonb added for demo tracking |
|
subject_status |
just like provider status |
Yes |
The following table changes occured
Table |
Column |
2.2 |
2.0.1 |
Comment |
Addressed in ERD |
|---|---|---|---|---|---|
attachment |
format_code_key |
NULL NUMERIC |
Not Found |
New field for attachment for xds |
Yes |
|
health_care_fac_type_code_key |
NULL NUMERIC |
Not Found |
New field for attachment for xds |
Yes |
|
practice_setting_code_key |
NULL NUMERIC |
Not Found |
New field for attachment for xds |
Yes |
|
type_code_key |
NULL NUMERIC |
Not Found |
New field for attachment for xds |
Yes |
|
event_code_key |
NULL NUMERIC |
Not Found |
New field for attachment for xds |
Yes |
clinical_item |
subject_alias_key |
NULL NUMERIC |
Not Found |
subject alias to link to subject demographics |
|
concept_alias |
comment |
Not Found |
NULL LONG VARCHAR(4000) |
|
Yes |
|
description |
NULL LONG VARCHAR(4000) |
Not Found |
|
Yes |
configuration |
type |
NULL VARCHAR(32) |
Not Found |
|
Yes |
|
descr |
NULL LONG VARCHAR(8190) |
Not Found |
|
Yes |
consent |
provider_key |
Not Found |
NULL NUMERIC |
jonb added more details for consent |
|
|
consented |
Not Found |
NULL NUMERIC(1) |
jonb added more details for consent |
|
|
created_on |
NULL TIMESTAMP(26) |
Not Found |
jonb added more details for consent |
|
|
location |
NULL VARCHAR(80) |
Not Found |
jonb added more details for consent |
|
|
creating_user_key |
NULL NUMERIC |
Not Found |
jonb added more details for consent |
|
|
updating_user_key |
NULL NUMERIC |
Not Found |
jonb added more details for consent |
|
|
updated_on |
NULL TIMESTAMP(26) |
Not Found |
jonb added more details for consent |
|
encounter |
subject_class |
Not Found |
NULL VARCHAR(80) |
Removed to go to CE |
Yes |
|
admission_type |
Not Found |
NULL VARCHAR(80) |
Removed to go to CE |
Yes |
|
subject_class_key |
NULL NUMERIC |
Not Found |
changed from varchar to CE |
Yes |
|
admission_type_key |
NULL NUMERIC |
Not Found |
changed from varchar to CE |
Yes |
|
alternate_id |
NULL VARCHAR(80) |
Not Found |
New Column |
Yes |
event_audit |
network_access_point_id |
NULL VARCHAR(64) |
Not Found |
New Table |
Yes |
|
participant_object_id |
NULL VARCHAR(128) |
Not Found |
New Table |
Yes |
event_audit_type |
event_action_code |
NULL VARCHAR(1) |
Not Found |
New Table |
Yes |
|
part_object_type_code |
NULL NUMERIC(2) |
Not Found |
New Table |
Yes |
|
part_object_type_role |
NULL NUMERIC(2) |
Not Found |
New Table |
Yes |
|
part_object_id_type_code |
NULL NUMERIC(2) |
Not Found |
New Table |
Yes |
facility |
clinical_item_ttl |
NULL NUMERIC |
Not Found |
|
Yes |
|
is_authority |
NULL NUMERIC |
Not Found |
defines if source is authoratative for demographics |
Yes |
guarantor |
relationship |
Not Found |
NULL VARCHAR(32) |
Removed to go to CE |
Yes |
|
relationship_key |
NULL NUMERIC |
Not Found |
changed from varchar to CE |
Yes |
insurance |
plan_id |
Not Found |
NULL VARCHAR(80) |
Removed to go to CE |
|
|
company_id |
Not Found |
NULL VARCHAR(80) |
Removed to go to CE |
|
|
coverage_type |
NULL VARCHAR(80) |
NULL VARCHAR(20) |
|
|
|
plan_id_key |
NULL NUMERIC |
Not Found |
changed from varchar to CE |
|
|
company_id_key |
NULL NUMERIC |
Not Found |
changed from varchar to CE |
|
lab_order |
lab_order_type_key |
NULL NUMERIC(1) |
NULL NUMERIC |
added lab order types for rad, path, trn |
|
misc_person |
gender |
Not Found |
NULL VARCHAR(1) |
|
|
|
job_title |
NULL VARCHAR(80) |
NULL VARCHAR(32) |
|
|
|
gender_code |
NULL NUMERIC |
Not Found |
|
|
ndc |
ndc_formatted |
Not Found |
NULL VARCHAR(32) |
this whole table is result of concept load for NDC |
|
|
brand |
Not Found |
NOT NULL VARCHAR(20) |
this whole table is result of concept load for NDC |
|
|
route |
Not Found |
NULL VARCHAR(128) |
this whole table is result of concept load for NDC |
|
|
dose_form |
Not Found |
NULL VARCHAR(128) |
this whole table is result of concept load for NDC |
|
|
product_strength |
Not Found |
NULL VARCHAR(128) |
this whole table is result of concept load for NDC |
|
|
active_ingredient |
Not Found |
NULL LONG VARCHAR(256) |
this whole table is result of concept load for NDC |
|
|
strength_num_amount |
Not Found |
NULL VARCHAR(20) |
this whole table is result of concept load for NDC |
|
|
strength_num |
Not Found |
NULL VARCHAR(20) |
this whole table is result of concept load for NDC |
|
|
strength_denom_amount |
Not Found |
NULL VARCHAR(20) |
this whole table is result of concept load for NDC |
|
|
strength_denom |
Not Found |
NULL VARCHAR(20) |
this whole table is result of concept load for NDC |
|
|
mfgr |
NULL LONG VARCHAR(400) |
Not Found |
this whole table is result of concept load for NDC |
|
|
rx_otc |
NULL VARCHAR(18) |
Not Found |
this whole table is result of concept load for NDC |
|
next_of_kin |
relationship |
Not Found |
NULL VARCHAR(32) |
changed to CE |
|
|
relationship_key |
NULL NUMERIC |
Not Found |
changed to CE |
|
provider_group |
subject_group_key |
Not Found |
NULL NUMERIC |
turned into many to many |
Yes |
|
http_body |
Not Found |
NULL LONG VARCHAR(8190) |
Moved to PropertyBag |
Yes |
|
hostname |
Not Found |
NULL VARCHAR(40) |
Moved to PropertyBag |
Yes |
|
port |
Not Found |
NULL VARCHAR(5) |
Moved to PropertyBag |
Yes |
|
protocol |
Not Found |
NULL VARCHAR(10) |
Moved to PropertyBag |
Yes |
|
clin_mess_dest_type_key |
NULL NUMERIC |
Not Found |
delivery |
Yes |
|
property_bag_key |
NULL NUMERIC |
Not Found |
delivery |
Yes |
|
unique_delivery |
NULL NUMERIC |
Not Found |
delivery |
Yes |
|
outgoing_msg_format |
NULL NUMERIC |
Not Found |
delivery |
Yes |
subject |
subject_status_key |
NULL NUMERIC |
Not Found |
someone added subject status |
Yes |
|
time_of_birth |
NULL TIME(8) |
Not Found |
time for birth instead of just date |
Yes |
subject_alias |
alias |
NOT NULL VARCHAR(128) |
NOT NULL VARCHAR(30) |
size increase |
Yes |
task_request_param |
string_value |
NULL LONG VARCHAR(8190) |
NULL LONG VARCHAR(4000) |
|
Yes |