Edit Note - Life OS

Title *

Domain *

Project

Content

table_name	sql_server_count	oracle_count
V_sdk_allergy_category_description	392	392
V_sdk_allergy_category_drug	1914	1914
V_sdk_allergy_category_drug_cross_reactivity	28398	28398
V_sdk_allergy_interaction_text	389	389
V_sdk_alr_category_class_map	392	392
V_sdk_brandname_category_leaflet	22348	22348
V_sdk_brandname_drug_leaflet_category_exists	17282	17282
V_sdk_condition_description	533	533
V_sdk_database_info	3	3
V_sdk_dcm_body_system	12	12
V_sdk_dcm_condition_info	506	506
V_sdk_dcm_condition_xref	1012	1012
V_sdk_dcm_group	1946	1946
V_sdk_dcm_group_condition_map	3047	3047
V_sdk_dcm_group_mmdc_map	9413	9413
V_sdk_dcm_medical_specialty	22	22
V_sdk_ddi_condition_description	0	0
V_sdk_ddi_drug_condition	2194	2194
V_sdk_ddm_condition_hcfa_map_icd_10	11274	11274
V_sdk_ddm_map_icd_10	2251426	2251426
V_sdk_doseranges	17311	17311
V_sdk_doseranges_mmdc	30079	30079
V_sdk_drc_type	13	13
V_sdk_drcheck_case_list	9776	9776
V_sdk_drcheck_contraindication_description	232	232
V_sdk_drcheck_group_name	8788	8788
V_sdk_drcheck_group_route_case	72661	72661
V_sdk_drcheck_group_route_drug_product	28132	28132
V_sdk_drcheck_group_route_drug_product_old	28132	28132
V_sdk_drcheck_range_type_description	13	13
V_sdk_drcheck_recommendation_description	311	311
V_sdk_drug_marking_data	48926	48926
V_sdk_drugs_for_condition_icd_10	2251426	2251426
V_sdk_dup_category_description	439	439
V_sdk_dup_drug_category	438	438
V_sdk_dup_drug_category_map	2374	2374
V_sdk_dup_drug_sub_category	397	397
V_sdk_dup_text_type	78	78
V_sdk_ftd_text_age_range_description	9962	9962
V_sdk_ftd_text_type_description	14454	14454
V_sdk_global_condition_description	2339	2339
V_sdk_global_content_set	20345	20345
V_sdk_global_disclaimer	1	1
V_sdk_global_dose_form_description	112	112
V_sdk_global_drug_modifier_description	10	10
V_sdk_global_drug_modifier_map	2204	2204
V_sdk_global_drug_therapeutic_duplication_map	4178	4178
V_sdk_global_frequency_description	171	171
V_sdk_global_generic_drug	4178	4178
V_sdk_global_ingredient_description	3618	3618
V_sdk_global_instruction_description	1808	1808
V_sdk_global_prn_description	95	95
V_sdk_global_product_strength_description	7357	7357
V_sdk_global_rounding_format	3	3
V_sdk_global_rounding_mask	5	5
V_sdk_global_route_description	147	147
V_sdk_global_route_group_map	0	0
V_sdk_global_unit_of_measure_description	138	138
V_sdk_hcfa_icd_10	98055	98055
V_sdk_hcfa_icd_10_mmdc	2264833	2264833
V_sdk_hcfa_icd_9	17454	17454
V_sdk_icd10_map	13832	13832
V_sdk_icd_9_disease_name	7903	7903
V_sdk_int_drug_interactions	812731	812731
V_sdk_int_header	7	7
V_sdk_int_header_severity_map	11	11
V_sdk_int_interaction_description	17066	17066
V_sdk_int_interaction_header_severity_map	7600	7600
V_sdk_inter_content_set_country_map	156609	156609
V_sdk_iV_drug_drug_compatibility	46423	46423
V_sdk_iV_drug_drug_map	25000	25000
V_sdk_iV_drug_drug_map_text	32653	32653
V_sdk_iV_drug_drug_map_text_reference	36945	36945
V_sdk_iV_drug_keyword_compatibility	2554	2554
V_sdk_iV_drug_keyword_map	1057	1057
V_sdk_iV_drug_keyword_map_text	3287	3287
V_sdk_iV_drug_keyword_map_text_reference	3937	3937
V_sdk_iV_keyword	28	28
V_sdk_iV_reference	3366	3366
V_sdk_iV_solution	12	12
V_sdk_iV_solution_code	12	12
V_sdk_label_drug_xref	35396	35396
V_sdk_lactation_text	3703	3703
V_sdk_leaf_mdp_product_code	1137860	1137860
V_sdk_leaflet_mmdc_map	64368	64368
V_sdk_leaflet_ndc	187910	187910
V_sdk_mapsyntoivc_fluid	19	19
V_sdk_medication_order_catalog	0	0
V_sdk_mmdc_product_name	40918	40918
V_sdk_multum_additional_doseform	8	8
V_sdk_multum_clinical_route	101	101
V_sdk_multum_color	169	169
V_sdk_multum_combination_drug	3155	3155
V_sdk_multum_condition	572	572
V_sdk_multum_country	15	15
V_sdk_multum_dose_form	112	112
V_sdk_multum_dose_form_manufactured	87	87
V_sdk_multum_drug_id	4178	4178
V_sdk_multum_drug_modifier	10	10
V_sdk_multum_drug_modifier_map	2204	2204
V_sdk_multum_drug_name	78323	78323
V_sdk_multum_drug_name_derivation	40918	40918
V_sdk_multum_drug_name_map	98211	98211
V_sdk_multum_flavor	47	47
V_sdk_multum_frequency	171	171
V_sdk_multum_function_type	37	37
V_sdk_multum_mmdc_name_map	87397	87397
V_sdk_multum_product_route	47	47
V_sdk_multum_product_strength	7357	7357
V_sdk_multum_shape	22	22
V_sdk_multum_subject_status	109435	109435
V_sdk_multum_units	138	138
V_sdk_ndc_active_ingredient_list	22018	22018
V_sdk_ndc_additional_description	10392	10392
V_sdk_ndc_core_description	223624	223624
V_sdk_ndc_cost	443829	443829
V_sdk_ndc_dnum	223624	223624
V_sdk_ndc_drug_synonym_map_1	203194	203194
V_sdk_ndc_drug_synonym_map_2	213682	213682
V_sdk_ndc_drug_synonym_map_3	298957	298957
V_sdk_ndc_image	48078	48078
V_sdk_ndc_ingredient_strength	3057	3057
V_sdk_ndc_multum_main_drug_code	15514	15514
V_sdk_ndc_source	2414	2414
V_sdk_os_script	80444	80444
V_sdk_os_script_order_drug_name_map	80423	80423
V_sdk_os_translation_description	0	0
V_sdk_packagingandpricing	223624	223624
V_sdk_pharm_text	2657	2657
V_sdk_pharmaco_text	2584	2584
V_sdk_pregnancy_text	5029	5029
V_sdk_ref_detail	31829	31829
V_sdk_ref_drug	193419	193419
V_sdk_rx_builder_dictionary_info	5215	5215
V_sdk_rx_builder_info	267840	267840
V_sdk_rx_dispense_rules	13290	13290
V_sdk_rx_dose_quantity_links1	8067	8067
V_sdk_rx_dose_quantity_links2	7965	7965
V_sdk_rx_drug_product	37005	37005
V_sdk_rx_drug_product_desc	7909	7909
V_sdk_rx_drug_product_principal_route	37004	37004
V_sdk_rx_drug_product_syn	50027	50027
V_sdk_rx_duration_rules	3273	3273
V_sdk_rxn_multum_map	28041	28041
V_sdk_side_effect_text	34629	34629
V_sdk_snomed_allergy_category_map	383	383
V_sdk_snomed_condition_map	2156	2156
V_sdk_snomed_dose_form_map	81	81
V_sdk_snomed_frequency_map	110	110
V_sdk_snomed_generic_drug_name_map	0	0
V_sdk_snomed_route_map	118	118
V_sdk_snomed_unit_of_measure_map	90	90
V_sdk_tc_category_description	494	494
V_sdk_tc_drug_category	494	494
V_sdk_tc_drug_category_map	4468	4468
V_sdk_tc_drug_sub_category	471	471
V_sdk_update_status	109827	109827
V_sdk_us_ddi_condition_category	583	583
V_sdk_us_ddi_description	4862	4862
V_sdk_us_ddi_drug_condition	17141	17141
V_sdk_us_ddi_map	17856	17856
V_sdk_us_drug_leaflet_map	2704	2704
V_sdk_us_hcfa_icd_9	17454	17454
V_sdk_us_icd9_map	7903	7903
V_sdk_us_icd_9	40760	40760
V_sdk_us_leaflet	38774	38774
V_sdk_us_leaflet_mmdc_map	8046	8046
V_sdk_us_leaflet_multi_map	13229	13229
V_sdk_us_medco_leaflet_cur	366999	366999
V_sdk_us_medco_leaflet_delta	16196	16196
V_sdk_us_medco_leaflet_prev	366939	366939
V_sdk_val_input_drug_id	1	1
V_sdk_val_input_drug_product	15	15
V_sdk_val_input_ndc	119	119
V_sdk_val_output_drug_id	0	0
V_sdk_val_output_drug_product	0	0
V_sdk_val_output_ndc	0	0
V_sdk_warning_text	2657	2657
V_sdk_us_icd9_map_upd	7903	7903
V_sdk_label	54	54
V_sdk_rx_alternate_route	3260	3260