common.applicants

Field	Type	Null	Default	Key	Extra
app_id	int(11)	NO		PRI	auto_increment
app_fname	varchar(40)	NO
app_mname	varchar(20)	NO
app_lname	varchar(40)	NO
app_18	tinyint(1)	NO
app_email	varchar(60)	NO
app_address	varchar(60)	NO
app_city	varchar(20)	NO
app_state	varchar(2)	NO
app_zip	varchar(5)	NO
app_phone	varchar(15)	NO
app_cell_phone	varchar(15)	NO
app_position_1	varchar(100)	YES
app_pos_type	varchar(9)	NO
app_pos_shift	varchar(8)	NO
app_salary_req	varchar(10)	NO
app_date_available	varchar(8)	NO
app_travel	tinyint(1)	NO
app_trans	tinyint(1)	NO
app_family	tinyint(1)	NO
app_family_name	varchar(60)	NO
app_legal	tinyint(1)	NO
app_related	text	NO
app_worked	tinyint(1)	NO
app_worked_when	varchar(40)	NO
app_refer	varchar(28)	NO
app_referred_by	text	NO
app_performance	tinyint(1)	NO
app_arrest	tinyint(1)	NO
app_arrest_reason	text	NO
app_law	tinyint(1)	NO
app_law_reason	text	NO
app_fed	tinyint(1)	NO
app_currently_employed	tinyint(1)	NO	0
app_contact_employer	tinyint(1)	NO
app_hs_name	varchar(50)	NO
app_hs_city	varchar(40)	NO
app_hs_state	varchar(2)	NO
app_hs_level	char(2)	NO
app_hs_graduated	tinyint(1)	NO
app_hs_degree	varchar(100)	NO
app_c1_name	varchar(50)	NO
app_c1_city	varchar(40)	NO
app_c1_state	char(2)	NO
app_c1_level	char(2)	NO
app_c1_graduated	tinyint(1)	NO
app_c1_degree	varchar(100)	NO
app_c2_name	varchar(50)	NO
app_c2_city	varchar(30)	NO
app_c2_state	char(2)	NO
app_c2_level	char(2)	NO
app_c2_graduated	tinyint(1)	NO
app_c2_degree	varchar(100)	NO
app_gs_name	varchar(50)	NO
app_gs_city	varchar(30)	NO
app_gs_state	char(2)	NO
app_gs_level	char(2)	NO
app_gs_graduated	tinyint(1)	NO
app_gs_degree	varchar(100)	NO
app_o1_name	varchar(50)	NO
app_o1_city	varchar(30)	NO
app_o1_state	char(2)	NO
app_o1_level	char(2)	NO
app_o1_graduated	tinyint(1)	NO
app_o1_degree	varchar(100)	NO
app_o2_name	varchar(50)	NO
app_o2_city	varchar(30)	NO
app_o2_state	char(2)	NO
app_o2_level	char(2)	NO
app_o2_graduated	tinyint(1)	NO
app_o2_degree	varchar(100)	NO
app_qualifications	text	NO
app_clerical	text	NO
app_software	text	NO
app_other_skills	text	NO
app_honors	text	NO
app_machines	text	NO
app_employer_1_name_while_employed	varchar(60)	NO
app_employer_1_name	varchar(30)	NO
app_employer_1_address	varchar(50)	NO
app_employer_1_city	varchar(30)	NO
app_employer_1_state	char(2)	NO
app_employer_1_zip	varchar(5)	NO
app_employer_1_phone	varchar(15)	NO
app_employer_1_fax	varchar(15)	NO
app_employer_1_supervisor	varchar(40)	NO
app_employer_1_supervisor_email	varchar(40)	NO
app_employer_1_start	varchar(8)	NO
app_employer_1_end	varchar(8)	NO
app_employer_1_positions	varchar(50)	NO
app_employer_1_functions	text	NO
app_employer_1_start_salary	varchar(10)	NO
app_employer_1_end_salary	varchar(10)	NO
app_employer_1_leaving	text	NO
app_employer_1_hours	varchar(10)	NO
app_employer_1_hours_per_week	varchar(30)	NO
app_employer_1_value	varchar(100)	NO
app_employer_1_contact	char(1)	NO
app_employer_1_still_employed	char(1)	NO
app_employer_2_name_while_employed	varchar(60)	NO
app_employer_2_name	varchar(30)	NO
app_employer_2_address	varchar(50)	NO
app_employer_2_city	varchar(30)	NO
app_employer_2_state	char(2)	NO
app_employer_2_zip	varchar(5)	NO
app_employer_2_phone	varchar(15)	NO
app_employer_2_fax	varchar(15)	NO
app_employer_2_supervisor	varchar(40)	NO
app_employer_2_supervisor_email	varchar(40)	NO
app_employer_2_start	varchar(8)	NO
app_employer_2_end	varchar(8)	NO
app_employer_2_positions	varchar(50)	NO
app_employer_2_functions	text	NO
app_employer_2_start_salary	varchar(10)	NO
app_employer_2_end_salary	varchar(10)	NO
app_employer_2_leaving	text	NO
app_employer_2_hours	varchar(10)	NO
app_employer_2_hours_per_week	varchar(30)	NO
app_employer_2_value	varchar(100)	NO
app_employer_2_contact	char(1)	NO
app_employer_2_still_employed	char(1)	NO
app_employer_3_name_while_employed	varchar(60)	NO
app_employer_3_name	varchar(30)	NO
app_employer_3_address	varchar(50)	NO
app_employer_3_city	varchar(30)	NO
app_employer_3_state	char(2)	NO
app_employer_3_zip	varchar(5)	NO
app_employer_3_phone	varchar(15)	NO
app_employer_3_fax	varchar(15)	NO
app_employer_3_supervisor	varchar(40)	NO
app_employer_3_supervisor_email	varchar(40)	NO
app_employer_3_start	varchar(8)	NO
app_employer_3_end	varchar(8)	NO
app_employer_3_positions	varchar(50)	NO
app_employer_3_functions	text	NO
app_employer_3_start_salary	varchar(10)	NO
app_employer_3_end_salary	varchar(10)	NO
app_employer_3_leaving	text	NO
app_employer_3_hours	varchar(10)	NO
app_employer_3_hours_per_week	varchar(30)	NO
app_employer_3_value	varchar(100)	NO
app_employer_3_contact	char(1)	NO
app_employer_3_still_employed	char(1)	NO
app_employer_4_name_while_employed	varchar(60)	NO
app_employer_4_name	varchar(30)	NO
app_employer_4_address	varchar(50)	NO
app_employer_4_city	varchar(30)	NO
app_employer_4_state	char(2)	NO
app_employer_4_zip	varchar(5)	NO
app_employer_4_phone	varchar(15)	NO
app_employer_4_fax	varchar(15)	NO
app_employer_4_supervisor	varchar(40)	NO
app_employer_4_supervisor_email	varchar(40)	NO
app_employer_4_start	varchar(8)	NO
app_employer_4_end	varchar(8)	NO
app_employer_4_positions	varchar(50)	NO
app_employer_4_functions	text	NO
app_employer_4_start_salary	varchar(10)	NO
app_employer_4_end_salary	varchar(10)	NO
app_employer_4_leaving	text	NO
app_employer_4_hours	varchar(10)	NO
app_employer_4_hours_per_week	varchar(30)	NO
app_employer_4_value	varchar(100)	NO
app_employer_4_contact	char(1)	NO
app_employer_4_still_employed	char(1)	NO
app_reference_1_name	varchar(30)	NO
app_reference_1_position	varchar(40)	NO
app_reference_1_address	varchar(40)	NO
app_reference_1_phone	varchar(15)	NO
app_reference_1_years	varchar(2)	NO
app_reference_2_name	varchar(30)	NO
app_reference_2_position	varchar(40)	NO
app_reference_2_address	varchar(40)	NO
app_reference_2_phone	varchar(15)	NO
app_reference_2_years	varchar(2)	NO
app_reference_3_name	varchar(30)	NO
app_reference_3_position	varchar(40)	NO
app_reference_3_address	varchar(40)	NO
app_reference_3_phone	varchar(15)	NO
app_reference_3_years	varchar(2)	NO
app_reference_4_name	varchar(30)	NO
app_reference_4_position	varchar(40)	NO
app_reference_4_address	varchar(40)	NO
app_reference_4_phone	varchar(15)	NO
app_reference_4_years	varchar(2)	NO
app_approve	tinyint(1)	NO
app_signature	varchar(40)	NO
app_convicted	tinyint(1)	NO
app_convicted_reason	text	NO
app_adjudicated	tinyint(1)	NO
app_not_adjudicated_reason	text	NO
app_not_convicted	tinyint(1)	NO
app_not_convicted_reason	text	NO
app_civil	tinyint(1)	NO
app_civil_reason	text	NO
pending	tinyint(1)	NO
app_rating	int(11)	NO
archived	tinyint(1)	NO
hired	char(1)	NO
employed_elsewhere	char(1)	NO
deleted	tinyint(1)	NO
app_loc_id	varchar(20)	NO
app_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
app_created	timestamp	YES	CURRENT_TIMESTAMP
search_date	varchar(8)	NO
email_info	text	NO
resume	text	NO
app_comments	text	NO
demo	tinyint(1)	NO	0

References

Local Column

References

app_id

Table	Column
API.exceptions	request_app_id
API.request_logs_v2	request_app_id
_1.audits_applications	audapp_api_app_id
_1188.audits_applications	audapp_api_app_id
_1218.audits_applications	audapp_api_app_id
_1548.audits_applications	audapp_api_app_id
_435.audits_applications	audapp_api_app_id
_436.audits_applications	audapp_api_app_id
_436_archive_testing.audits_applications	audapp_api_app_id
_437.audits_applications	audapp_api_app_id
_8.audits_applications	audapp_api_app_id
_81.audits_applications	audapp_api_app_id
_999.audits_applications	audapp_api_app_id
ahiWiki.bot_passwords	bp_app_id
common.applicants_docs	apd_app_id
common.application_notes	appn_app_id

deleted

Table	Column
API.partner_accounts	is_deleted
HSPI_Bastrop.Files	is_deleted
HSPI_Bastrop.PatientTracking	is_deleted
HSPI_Bastrop.accommodation_codes	is_deleted
HSPI_Bastrop.action_codes	is_deleted
HSPI_Bastrop.addresses	is_deleted
HSPI_Bastrop.allergies	is_deleted
HSPI_Bastrop.appointments	is_deleted
HSPI_Bastrop.authorization_roles	is_deleted
HSPI_Bastrop.billing_alert_rules	is_deleted
HSPI_Bastrop.billing_controls	is_deleted
HSPI_Bastrop.billing_diagnoses	is_deleted
HSPI_Bastrop.billing_procedures	is_deleted
HSPI_Bastrop.care_plan_activities	is_deleted
HSPI_Bastrop.care_plans	is_deleted
HSPI_Bastrop.care_team	is_deleted
HSPI_Bastrop.charge_master_code_extensions	is_deleted
HSPI_Bastrop.charge_master_codes	is_deleted
HSPI_Bastrop.charge_masters	is_deleted
HSPI_Bastrop.charges	is_deleted
HSPI_Bastrop.claim_batch_generation_rules	is_deleted
HSPI_Bastrop.claim_batches	is_deleted
HSPI_Bastrop.claim_field_adjustment_rules	is_deleted
HSPI_Bastrop.claim_insurances	is_deleted
HSPI_Bastrop.claim_items	is_deleted
HSPI_Bastrop.claims	is_deleted
HSPI_Bastrop.clearinghouse_configurations	is_deleted
HSPI_Bastrop.clinical_assessment_records	is_deleted
HSPI_Bastrop.clinical_assessment_structures	is_deleted
HSPI_Bastrop.clinical_assessments	is_deleted
HSPI_Bastrop.codeable_concepts	is_deleted
HSPI_Bastrop.codings	is_deleted
HSPI_Bastrop.communication_recipients	is_deleted
HSPI_Bastrop.communications	is_deleted
HSPI_Bastrop.conditions	is_deleted
HSPI_Bastrop.contacts	is_deleted
HSPI_Bastrop.coverages	is_deleted
HSPI_Bastrop.department	is_deleted
HSPI_Bastrop.devices	is_deleted
HSPI_Bastrop.encounters	is_deleted
HSPI_Bastrop.entity_condition_groups	is_deleted
HSPI_Bastrop.examples	is_deleted
HSPI_Bastrop.family_history	is_deleted
HSPI_Bastrop.financial_accounts	is_deleted
HSPI_Bastrop.financial_classes	is_deleted
HSPI_Bastrop.groups	is_deleted
HSPI_Bastrop.guarantors	is_deleted
HSPI_Bastrop.handling_codes	is_deleted
HSPI_Bastrop.identifiers	is_deleted
HSPI_Bastrop.immunizations	is_deleted
HSPI_Bastrop.invoice_batches	is_deleted
HSPI_Bastrop.invoices	is_deleted
HSPI_Bastrop.laboratory_orders	is_deleted
HSPI_Bastrop.laboratory_results	is_deleted
HSPI_Bastrop.locations	is_deleted
HSPI_Bastrop.medical_encoder_configurations	is_deleted
HSPI_Bastrop.medication_requests	is_deleted
HSPI_Bastrop.medications	is_deleted
HSPI_Bastrop.names	is_deleted
HSPI_Bastrop.notes	is_deleted
HSPI_Bastrop.observations	is_deleted
HSPI_Bastrop.participants	is_deleted
HSPI_Bastrop.patient_abstracts	is_deleted
HSPI_Bastrop.patient_contacts	is_deleted
HSPI_Bastrop.patient_status_codes	is_deleted
HSPI_Bastrop.patient_tracking	is_deleted
HSPI_Bastrop.patients	is_deleted
HSPI_Bastrop.patients_ethnicities	is_deleted
HSPI_Bastrop.patients_races	is_deleted
HSPI_Bastrop.payers	is_deleted
HSPI_Bastrop.phone_numbers	is_deleted
HSPI_Bastrop.practitioner_roles	is_deleted
HSPI_Bastrop.practitioners	is_deleted
HSPI_Bastrop.procedures	is_deleted
HSPI_Bastrop.providers	is_deleted
HSPI_Bastrop.reporting_keys	is_deleted
HSPI_Bastrop.saved_filters	is_deleted
HSPI_Bastrop.transaction_batches	is_deleted
HSPI_Bastrop.transaction_codes	is_deleted
HSPI_CURES2015_B1.Files	is_deleted
HSPI_CURES2015_B1.allergies	is_deleted
HSPI_CURES2015_B1.appointments	is_deleted
HSPI_CURES2015_B1.authorization_roles	is_deleted
HSPI_CURES2015_B1.billing_diagnoses	is_deleted
HSPI_CURES2015_B1.billing_procedures	is_deleted
HSPI_CURES2015_B1.care_plan_activities	is_deleted
HSPI_CURES2015_B1.care_plans	is_deleted
HSPI_CURES2015_B1.care_team	is_deleted
HSPI_CURES2015_B1.charges	is_deleted
HSPI_CURES2015_B1.claim_batch_generation_rules	is_deleted
HSPI_CURES2015_B1.claim_batches	is_deleted
HSPI_CURES2015_B1.claim_field_adjustment_rules	is_deleted
HSPI_CURES2015_B1.claim_insurances	is_deleted
HSPI_CURES2015_B1.claim_items	is_deleted
HSPI_CURES2015_B1.claims	is_deleted
HSPI_CURES2015_B1.clinical_assessment_records	is_deleted
HSPI_CURES2015_B1.clinical_assessment_structures	is_deleted
HSPI_CURES2015_B1.clinical_assessments	is_deleted
HSPI_CURES2015_B1.communication_recipients	is_deleted
HSPI_CURES2015_B1.communications	is_deleted
HSPI_CURES2015_B1.conditions	is_deleted
HSPI_CURES2015_B1.configured_reports	is_deleted
HSPI_CURES2015_B1.coverages	is_deleted
HSPI_CURES2015_B1.devices	is_deleted
HSPI_CURES2015_B1.entity_condition_groups	is_deleted
HSPI_CURES2015_B1.examples	is_deleted
HSPI_CURES2015_B1.family_history	is_deleted
HSPI_CURES2015_B1.financial_accounts	is_deleted
HSPI_CURES2015_B1.groups	is_deleted
HSPI_CURES2015_B1.guarantors	is_deleted
HSPI_CURES2015_B1.handling_codes	is_deleted
HSPI_CURES2015_B1.immunizations	is_deleted
HSPI_CURES2015_B1.invoice_batches	is_deleted
HSPI_CURES2015_B1.invoices	is_deleted
HSPI_CURES2015_B1.laboratory_orders	is_deleted
HSPI_CURES2015_B1.laboratory_results	is_deleted
HSPI_CURES2015_B1.locations	is_deleted
HSPI_CURES2015_B1.medical_encoder_configurations	is_deleted
HSPI_CURES2015_B1.medication_requests	is_deleted
HSPI_CURES2015_B1.medications	is_deleted
HSPI_CURES2015_B1.notes	is_deleted
HSPI_CURES2015_B1.observations	is_deleted
HSPI_CURES2015_B1.participants	is_deleted
HSPI_CURES2015_B1.patient_abstracts	is_deleted
HSPI_CURES2015_B1.patient_contacts	is_deleted
HSPI_CURES2015_B1.patient_tracking	is_deleted
HSPI_CURES2015_B1.patients_ethnicities	is_deleted
HSPI_CURES2015_B1.patients_races	is_deleted
HSPI_CURES2015_B1.practitioner_roles	is_deleted
HSPI_CURES2015_B1.procedures	is_deleted
HSPI_CURES2015_B1.providers	is_deleted
HSPI_CURES2015_B1.reporting_keys	is_deleted
HSPI_CURES2015_B1.saved_filters	is_deleted
HSPI_CURES2015_B1.subscriptions	is_deleted
HSPI_CURES2015_B1.transaction_codes	is_deleted
HSPI_Central_Hospital.Files	is_deleted
HSPI_Central_Hospital.allergies	is_deleted
HSPI_Central_Hospital.appointments	is_deleted
HSPI_Central_Hospital.authorization_roles	is_deleted
HSPI_Central_Hospital.billing_diagnoses	is_deleted
HSPI_Central_Hospital.billing_procedures	is_deleted
HSPI_Central_Hospital.care_plan_activities	is_deleted
HSPI_Central_Hospital.care_plans	is_deleted
HSPI_Central_Hospital.care_team	is_deleted
HSPI_Central_Hospital.charges	is_deleted
HSPI_Central_Hospital.claim_batch_generation_rules	is_deleted
HSPI_Central_Hospital.claim_batches	is_deleted
HSPI_Central_Hospital.claim_field_adjustment_rules	is_deleted
HSPI_Central_Hospital.claim_insurances	is_deleted
HSPI_Central_Hospital.claim_items	is_deleted
HSPI_Central_Hospital.claims	is_deleted
HSPI_Central_Hospital.clinical_assessment_records	is_deleted
HSPI_Central_Hospital.clinical_assessment_structures	is_deleted
HSPI_Central_Hospital.clinical_assessments	is_deleted
HSPI_Central_Hospital.communication_recipients	is_deleted
HSPI_Central_Hospital.communications	is_deleted
HSPI_Central_Hospital.conditions	is_deleted
HSPI_Central_Hospital.configured_reports	is_deleted
HSPI_Central_Hospital.coverages	is_deleted
HSPI_Central_Hospital.devices	is_deleted
HSPI_Central_Hospital.entity_condition_groups	is_deleted
HSPI_Central_Hospital.examples	is_deleted
HSPI_Central_Hospital.family_history	is_deleted
HSPI_Central_Hospital.financial_accounts	is_deleted
HSPI_Central_Hospital.groups	is_deleted
HSPI_Central_Hospital.guarantors	is_deleted
HSPI_Central_Hospital.handling_codes	is_deleted
HSPI_Central_Hospital.immunizations	is_deleted
HSPI_Central_Hospital.invoice_batches	is_deleted
HSPI_Central_Hospital.invoices	is_deleted
HSPI_Central_Hospital.laboratory_orders	is_deleted
HSPI_Central_Hospital.laboratory_results	is_deleted
HSPI_Central_Hospital.locations	is_deleted
HSPI_Central_Hospital.medical_encoder_configurations	is_deleted
HSPI_Central_Hospital.medication_requests	is_deleted
HSPI_Central_Hospital.medications	is_deleted
HSPI_Central_Hospital.notes	is_deleted
HSPI_Central_Hospital.observations	is_deleted
HSPI_Central_Hospital.participants	is_deleted
HSPI_Central_Hospital.patient_abstracts	is_deleted
HSPI_Central_Hospital.patient_contacts	is_deleted
HSPI_Central_Hospital.patient_tracking	is_deleted
HSPI_Central_Hospital.patients_ethnicities	is_deleted
HSPI_Central_Hospital.patients_races	is_deleted
HSPI_Central_Hospital.practitioner_roles	is_deleted
HSPI_Central_Hospital.procedures	is_deleted
HSPI_Central_Hospital.providers	is_deleted
HSPI_Central_Hospital.reporting_keys	is_deleted
HSPI_Central_Hospital.saved_filters	is_deleted
HSPI_Central_Hospital.subscriptions	is_deleted
HSPI_Central_Hospital.transaction_codes	is_deleted
HSPI_Dewitt.Files	is_deleted
HSPI_Dewitt.allergies	is_deleted
HSPI_Dewitt.appointments	is_deleted
HSPI_Dewitt.authorization_roles	is_deleted
HSPI_Dewitt.billing_diagnoses	is_deleted
HSPI_Dewitt.billing_procedures	is_deleted
HSPI_Dewitt.care_plan_activities	is_deleted
HSPI_Dewitt.care_plans	is_deleted
HSPI_Dewitt.care_team	is_deleted
HSPI_Dewitt.charges	is_deleted
HSPI_Dewitt.claim_batch_generation_rules	is_deleted
HSPI_Dewitt.claim_batches	is_deleted
HSPI_Dewitt.claim_field_adjustment_rules	is_deleted
HSPI_Dewitt.claim_insurances	is_deleted
HSPI_Dewitt.claim_items	is_deleted
HSPI_Dewitt.claims	is_deleted
HSPI_Dewitt.clinical_assessment_records	is_deleted
HSPI_Dewitt.clinical_assessment_structures	is_deleted
HSPI_Dewitt.clinical_assessments	is_deleted
HSPI_Dewitt.communication_recipients	is_deleted
HSPI_Dewitt.communications	is_deleted
HSPI_Dewitt.conditions	is_deleted
HSPI_Dewitt.configured_reports	is_deleted
HSPI_Dewitt.coverages	is_deleted
HSPI_Dewitt.devices	is_deleted
HSPI_Dewitt.entity_condition_groups	is_deleted
HSPI_Dewitt.examples	is_deleted
HSPI_Dewitt.family_history	is_deleted
HSPI_Dewitt.financial_accounts	is_deleted
HSPI_Dewitt.groups	is_deleted
HSPI_Dewitt.guarantors	is_deleted
HSPI_Dewitt.handling_codes	is_deleted
HSPI_Dewitt.immunizations	is_deleted
HSPI_Dewitt.invoice_batches	is_deleted
HSPI_Dewitt.invoices	is_deleted
HSPI_Dewitt.laboratory_orders	is_deleted
HSPI_Dewitt.laboratory_results	is_deleted
HSPI_Dewitt.locations	is_deleted
HSPI_Dewitt.medical_encoder_configurations	is_deleted
HSPI_Dewitt.medication_requests	is_deleted
HSPI_Dewitt.medications	is_deleted
HSPI_Dewitt.notes	is_deleted
HSPI_Dewitt.observations	is_deleted
HSPI_Dewitt.participants	is_deleted
HSPI_Dewitt.patient_abstracts	is_deleted
HSPI_Dewitt.patient_contacts	is_deleted
HSPI_Dewitt.patient_tracking	is_deleted
HSPI_Dewitt.patients_ethnicities	is_deleted
HSPI_Dewitt.patients_races	is_deleted
HSPI_Dewitt.practitioner_roles	is_deleted
HSPI_Dewitt.procedures	is_deleted
HSPI_Dewitt.providers	is_deleted
HSPI_Dewitt.reporting_keys	is_deleted
HSPI_Dewitt.saved_filters	is_deleted
HSPI_Dewitt.subscriptions	is_deleted
HSPI_Dewitt.transaction_codes	is_deleted
HSPI_Fulton.Files	is_deleted
HSPI_Fulton.allergies	is_deleted
HSPI_Fulton.appointments	is_deleted
HSPI_Fulton.authorization_roles	is_deleted
HSPI_Fulton.billing_diagnoses	is_deleted
HSPI_Fulton.billing_procedures	is_deleted
HSPI_Fulton.care_plan_activities	is_deleted
HSPI_Fulton.care_plans	is_deleted
HSPI_Fulton.care_team	is_deleted
HSPI_Fulton.charges	is_deleted
HSPI_Fulton.claim_batch_generation_rules	is_deleted
HSPI_Fulton.claim_batches	is_deleted
HSPI_Fulton.claim_field_adjustment_rules	is_deleted
HSPI_Fulton.claim_insurances	is_deleted
HSPI_Fulton.claim_items	is_deleted
HSPI_Fulton.claims	is_deleted
HSPI_Fulton.clinical_assessment_records	is_deleted
HSPI_Fulton.clinical_assessment_structures	is_deleted
HSPI_Fulton.clinical_assessments	is_deleted
HSPI_Fulton.communication_recipients	is_deleted
HSPI_Fulton.communications	is_deleted
HSPI_Fulton.conditions	is_deleted
HSPI_Fulton.configured_reports	is_deleted
HSPI_Fulton.coverages	is_deleted
HSPI_Fulton.devices	is_deleted
HSPI_Fulton.entity_condition_groups	is_deleted
HSPI_Fulton.examples	is_deleted
HSPI_Fulton.family_history	is_deleted
HSPI_Fulton.financial_accounts	is_deleted
HSPI_Fulton.groups	is_deleted
HSPI_Fulton.guarantors	is_deleted
HSPI_Fulton.handling_codes	is_deleted
HSPI_Fulton.immunizations	is_deleted
HSPI_Fulton.invoice_batches	is_deleted
HSPI_Fulton.invoices	is_deleted
HSPI_Fulton.laboratory_orders	is_deleted
HSPI_Fulton.laboratory_results	is_deleted
HSPI_Fulton.locations	is_deleted
HSPI_Fulton.medical_encoder_configurations	is_deleted
HSPI_Fulton.medication_requests	is_deleted
HSPI_Fulton.medications	is_deleted
HSPI_Fulton.notes	is_deleted
HSPI_Fulton.observations	is_deleted
HSPI_Fulton.participants	is_deleted
HSPI_Fulton.patient_abstracts	is_deleted
HSPI_Fulton.patient_contacts	is_deleted
HSPI_Fulton.patient_tracking	is_deleted
HSPI_Fulton.patients_ethnicities	is_deleted
HSPI_Fulton.patients_races	is_deleted
HSPI_Fulton.practitioner_roles	is_deleted
HSPI_Fulton.procedures	is_deleted
HSPI_Fulton.providers	is_deleted
HSPI_Fulton.reporting_keys	is_deleted
HSPI_Fulton.saved_filters	is_deleted
HSPI_Fulton.subscriptions	is_deleted
HSPI_Fulton.transaction_codes	is_deleted
HSPI_Inferno.Files	is_deleted
HSPI_Inferno.allergies	is_deleted
HSPI_Inferno.appointments	is_deleted
HSPI_Inferno.authorization_roles	is_deleted
HSPI_Inferno.billing_diagnoses	is_deleted
HSPI_Inferno.billing_procedures	is_deleted
HSPI_Inferno.care_plan_activities	is_deleted
HSPI_Inferno.care_plans	is_deleted
HSPI_Inferno.care_team	is_deleted
HSPI_Inferno.charges	is_deleted
HSPI_Inferno.claim_batch_generation_rules	is_deleted
HSPI_Inferno.claim_batches	is_deleted
HSPI_Inferno.claim_field_adjustment_rules	is_deleted
HSPI_Inferno.claim_insurances	is_deleted
HSPI_Inferno.claim_items	is_deleted
HSPI_Inferno.claims	is_deleted
HSPI_Inferno.clinical_assessment_records	is_deleted
HSPI_Inferno.clinical_assessment_structures	is_deleted
HSPI_Inferno.clinical_assessments	is_deleted
HSPI_Inferno.communication_recipients	is_deleted
HSPI_Inferno.communications	is_deleted
HSPI_Inferno.conditions	is_deleted
HSPI_Inferno.configured_reports	is_deleted
HSPI_Inferno.coverages	is_deleted
HSPI_Inferno.devices	is_deleted
HSPI_Inferno.entity_condition_groups	is_deleted
HSPI_Inferno.examples	is_deleted
HSPI_Inferno.family_history	is_deleted
HSPI_Inferno.financial_accounts	is_deleted
HSPI_Inferno.groups	is_deleted
HSPI_Inferno.guarantors	is_deleted
HSPI_Inferno.handling_codes	is_deleted
HSPI_Inferno.immunizations	is_deleted
HSPI_Inferno.invoice_batches	is_deleted
HSPI_Inferno.invoices	is_deleted
HSPI_Inferno.laboratory_orders	is_deleted
HSPI_Inferno.laboratory_results	is_deleted
HSPI_Inferno.locations	is_deleted
HSPI_Inferno.medical_encoder_configurations	is_deleted
HSPI_Inferno.medication_requests	is_deleted
HSPI_Inferno.medications	is_deleted
HSPI_Inferno.notes	is_deleted
HSPI_Inferno.observations	is_deleted
HSPI_Inferno.participants	is_deleted
HSPI_Inferno.patient_abstracts	is_deleted
HSPI_Inferno.patient_contacts	is_deleted
HSPI_Inferno.patient_tracking	is_deleted
HSPI_Inferno.patients_ethnicities	is_deleted
HSPI_Inferno.patients_races	is_deleted
HSPI_Inferno.practitioner_roles	is_deleted
HSPI_Inferno.procedures	is_deleted
HSPI_Inferno.providers	is_deleted
HSPI_Inferno.reporting_keys	is_deleted
HSPI_Inferno.saved_filters	is_deleted
HSPI_Inferno.subscriptions	is_deleted
HSPI_Inferno.transaction_codes	is_deleted
HSPI_MU2015_E1.Files	is_deleted
HSPI_MU2015_E1.allergies	is_deleted
HSPI_MU2015_E1.appointments	is_deleted
HSPI_MU2015_E1.authorization_roles	is_deleted
HSPI_MU2015_E1.billing_diagnoses	is_deleted
HSPI_MU2015_E1.billing_procedures	is_deleted
HSPI_MU2015_E1.care_plan_activities	is_deleted
HSPI_MU2015_E1.care_plans	is_deleted
HSPI_MU2015_E1.care_team	is_deleted
HSPI_MU2015_E1.charges	is_deleted
HSPI_MU2015_E1.claim_batch_generation_rules	is_deleted
HSPI_MU2015_E1.claim_batches	is_deleted
HSPI_MU2015_E1.claim_field_adjustment_rules	is_deleted
HSPI_MU2015_E1.claim_insurances	is_deleted
HSPI_MU2015_E1.claim_items	is_deleted
HSPI_MU2015_E1.claims	is_deleted
HSPI_MU2015_E1.clinical_assessment_records	is_deleted
HSPI_MU2015_E1.clinical_assessment_structures	is_deleted
HSPI_MU2015_E1.clinical_assessments	is_deleted
HSPI_MU2015_E1.communication_recipients	is_deleted
HSPI_MU2015_E1.communications	is_deleted
HSPI_MU2015_E1.conditions	is_deleted
HSPI_MU2015_E1.configured_reports	is_deleted
HSPI_MU2015_E1.coverages	is_deleted
HSPI_MU2015_E1.devices	is_deleted
HSPI_MU2015_E1.entity_condition_groups	is_deleted
HSPI_MU2015_E1.examples	is_deleted
HSPI_MU2015_E1.family_history	is_deleted
HSPI_MU2015_E1.financial_accounts	is_deleted
HSPI_MU2015_E1.groups	is_deleted
HSPI_MU2015_E1.guarantors	is_deleted
HSPI_MU2015_E1.handling_codes	is_deleted
HSPI_MU2015_E1.immunizations	is_deleted
HSPI_MU2015_E1.invoice_batches	is_deleted
HSPI_MU2015_E1.invoices	is_deleted
HSPI_MU2015_E1.laboratory_orders	is_deleted
HSPI_MU2015_E1.laboratory_results	is_deleted
HSPI_MU2015_E1.locations	is_deleted
HSPI_MU2015_E1.medical_encoder_configurations	is_deleted
HSPI_MU2015_E1.medication_requests	is_deleted
HSPI_MU2015_E1.medications	is_deleted
HSPI_MU2015_E1.notes	is_deleted
HSPI_MU2015_E1.observations	is_deleted
HSPI_MU2015_E1.participants	is_deleted
HSPI_MU2015_E1.patient_abstracts	is_deleted
HSPI_MU2015_E1.patient_contacts	is_deleted
HSPI_MU2015_E1.patient_tracking	is_deleted
HSPI_MU2015_E1.patients_ethnicities	is_deleted
HSPI_MU2015_E1.patients_races	is_deleted
HSPI_MU2015_E1.practitioner_roles	is_deleted
HSPI_MU2015_E1.procedures	is_deleted
HSPI_MU2015_E1.providers	is_deleted
HSPI_MU2015_E1.reporting_keys	is_deleted
HSPI_MU2015_E1.saved_filters	is_deleted
HSPI_MU2015_E1.subscriptions	is_deleted
HSPI_MU2015_E1.transaction_codes	is_deleted
HSPI_MU2015_G2.Files	is_deleted
HSPI_MU2015_G2.allergies	is_deleted
HSPI_MU2015_G2.appointments	is_deleted
HSPI_MU2015_G2.authorization_roles	is_deleted
HSPI_MU2015_G2.billing_diagnoses	is_deleted
HSPI_MU2015_G2.billing_procedures	is_deleted
HSPI_MU2015_G2.care_plan_activities	is_deleted
HSPI_MU2015_G2.care_plans	is_deleted
HSPI_MU2015_G2.care_team	is_deleted
HSPI_MU2015_G2.charges	is_deleted
HSPI_MU2015_G2.claim_batch_generation_rules	is_deleted
HSPI_MU2015_G2.claim_batches	is_deleted
HSPI_MU2015_G2.claim_field_adjustment_rules	is_deleted
HSPI_MU2015_G2.claim_insurances	is_deleted
HSPI_MU2015_G2.claim_items	is_deleted
HSPI_MU2015_G2.claims	is_deleted
HSPI_MU2015_G2.clinical_assessment_records	is_deleted
HSPI_MU2015_G2.clinical_assessment_structures	is_deleted
HSPI_MU2015_G2.clinical_assessments	is_deleted
HSPI_MU2015_G2.communication_recipients	is_deleted
HSPI_MU2015_G2.communications	is_deleted
HSPI_MU2015_G2.conditions	is_deleted
HSPI_MU2015_G2.configured_reports	is_deleted
HSPI_MU2015_G2.coverages	is_deleted
HSPI_MU2015_G2.devices	is_deleted
HSPI_MU2015_G2.entity_condition_groups	is_deleted
HSPI_MU2015_G2.examples	is_deleted
HSPI_MU2015_G2.family_history	is_deleted
HSPI_MU2015_G2.financial_accounts	is_deleted
HSPI_MU2015_G2.groups	is_deleted
HSPI_MU2015_G2.guarantors	is_deleted
HSPI_MU2015_G2.handling_codes	is_deleted
HSPI_MU2015_G2.immunizations	is_deleted
HSPI_MU2015_G2.invoice_batches	is_deleted
HSPI_MU2015_G2.invoices	is_deleted
HSPI_MU2015_G2.laboratory_orders	is_deleted
HSPI_MU2015_G2.laboratory_results	is_deleted
HSPI_MU2015_G2.locations	is_deleted
HSPI_MU2015_G2.medical_encoder_configurations	is_deleted
HSPI_MU2015_G2.medication_requests	is_deleted
HSPI_MU2015_G2.medications	is_deleted
HSPI_MU2015_G2.notes	is_deleted
HSPI_MU2015_G2.observations	is_deleted
HSPI_MU2015_G2.participants	is_deleted
HSPI_MU2015_G2.patient_abstracts	is_deleted
HSPI_MU2015_G2.patient_contacts	is_deleted
HSPI_MU2015_G2.patient_tracking	is_deleted
HSPI_MU2015_G2.patients_ethnicities	is_deleted
HSPI_MU2015_G2.patients_races	is_deleted
HSPI_MU2015_G2.practitioner_roles	is_deleted
HSPI_MU2015_G2.procedures	is_deleted
HSPI_MU2015_G2.providers	is_deleted
HSPI_MU2015_G2.reporting_keys	is_deleted
HSPI_MU2015_G2.saved_filters	is_deleted
HSPI_MU2015_G2.subscriptions	is_deleted
HSPI_MU2015_G2.transaction_codes	is_deleted
HSPI_MU2015_G9.Files	is_deleted
HSPI_MU2015_G9.allergies	is_deleted
HSPI_MU2015_G9.appointments	is_deleted
HSPI_MU2015_G9.authorization_roles	is_deleted
HSPI_MU2015_G9.billing_diagnoses	is_deleted
HSPI_MU2015_G9.billing_procedures	is_deleted
HSPI_MU2015_G9.care_plan_activities	is_deleted
HSPI_MU2015_G9.care_plans	is_deleted
HSPI_MU2015_G9.care_team	is_deleted
HSPI_MU2015_G9.charges	is_deleted
HSPI_MU2015_G9.claim_batch_generation_rules	is_deleted
HSPI_MU2015_G9.claim_batches	is_deleted
HSPI_MU2015_G9.claim_field_adjustment_rules	is_deleted
HSPI_MU2015_G9.claim_insurances	is_deleted
HSPI_MU2015_G9.claim_items	is_deleted
HSPI_MU2015_G9.claims	is_deleted
HSPI_MU2015_G9.clinical_assessment_records	is_deleted
HSPI_MU2015_G9.clinical_assessment_structures	is_deleted
HSPI_MU2015_G9.clinical_assessments	is_deleted
HSPI_MU2015_G9.communication_recipients	is_deleted
HSPI_MU2015_G9.communications	is_deleted
HSPI_MU2015_G9.conditions	is_deleted
HSPI_MU2015_G9.configured_reports	is_deleted
HSPI_MU2015_G9.coverages	is_deleted
HSPI_MU2015_G9.devices	is_deleted
HSPI_MU2015_G9.entity_condition_groups	is_deleted
HSPI_MU2015_G9.examples	is_deleted
HSPI_MU2015_G9.family_history	is_deleted
HSPI_MU2015_G9.financial_accounts	is_deleted
HSPI_MU2015_G9.groups	is_deleted
HSPI_MU2015_G9.guarantors	is_deleted
HSPI_MU2015_G9.handling_codes	is_deleted
HSPI_MU2015_G9.immunizations	is_deleted
HSPI_MU2015_G9.invoice_batches	is_deleted
HSPI_MU2015_G9.invoices	is_deleted
HSPI_MU2015_G9.laboratory_orders	is_deleted
HSPI_MU2015_G9.laboratory_results	is_deleted
HSPI_MU2015_G9.locations	is_deleted
HSPI_MU2015_G9.medical_encoder_configurations	is_deleted
HSPI_MU2015_G9.medication_requests	is_deleted
HSPI_MU2015_G9.medications	is_deleted
HSPI_MU2015_G9.notes	is_deleted
HSPI_MU2015_G9.observations	is_deleted
HSPI_MU2015_G9.participants	is_deleted
HSPI_MU2015_G9.patient_abstracts	is_deleted
HSPI_MU2015_G9.patient_contacts	is_deleted
HSPI_MU2015_G9.patient_tracking	is_deleted
HSPI_MU2015_G9.patients_ethnicities	is_deleted
HSPI_MU2015_G9.patients_races	is_deleted
HSPI_MU2015_G9.practitioner_roles	is_deleted
HSPI_MU2015_G9.procedures	is_deleted
HSPI_MU2015_G9.providers	is_deleted
HSPI_MU2015_G9.reporting_keys	is_deleted
HSPI_MU2015_G9.saved_filters	is_deleted
HSPI_MU2015_G9.subscriptions	is_deleted
HSPI_MU2015_G9.transaction_codes	is_deleted
HSPI_Ness.action_codes	is_deleted
HSPI_Ness.addresses	is_deleted
HSPI_Ness.allergies	is_deleted
HSPI_Ness.appointments	is_deleted
HSPI_Ness.charge	is_deleted
HSPI_Ness.charge_master_codes	is_deleted
HSPI_Ness.charge_masters	is_deleted
HSPI_Ness.charges	is_deleted
HSPI_Ness.claim_insurances	is_deleted
HSPI_Ness.claims	is_deleted
HSPI_Ness.codeable_concepts	is_deleted
HSPI_Ness.codings	is_deleted
HSPI_Ness.conditions	is_deleted
HSPI_Ness.contacts	is_deleted
HSPI_Ness.coverages	is_deleted
HSPI_Ness.encounters	is_deleted
HSPI_Ness.family_history	is_deleted
HSPI_Ness.financial_accounts	is_deleted
HSPI_Ness.financial_classes	is_deleted
HSPI_Ness.guarantors	is_deleted
HSPI_Ness.identifiers	is_deleted
HSPI_Ness.immunizations	is_deleted
HSPI_Ness.laboratory_orders	is_deleted
HSPI_Ness.laboratory_results	is_deleted
HSPI_Ness.locations	is_deleted
HSPI_Ness.medications	is_deleted
HSPI_Ness.names	is_deleted
HSPI_Ness.observations	is_deleted
HSPI_Ness.participants	is_deleted
HSPI_Ness.patient_contacts	is_deleted
HSPI_Ness.patients	is_deleted
HSPI_Ness.patients_ethnicities	is_deleted
HSPI_Ness.patients_races	is_deleted
HSPI_Ness.payers	is_deleted
HSPI_Ness.phone_numbers	is_deleted
HSPI_Ness.practitioner_roles	is_deleted
HSPI_Ness.practitioners	is_deleted
HSPI_Ness.procedures	is_deleted
HSPI_Ness.providers	is_deleted
HSPI_Sandbox.Files	is_deleted
HSPI_Sandbox.allergies	is_deleted
HSPI_Sandbox.appointments	is_deleted
HSPI_Sandbox.authorization_roles	is_deleted
HSPI_Sandbox.billing_diagnoses	is_deleted
HSPI_Sandbox.billing_procedures	is_deleted
HSPI_Sandbox.care_plan_activities	is_deleted
HSPI_Sandbox.care_plans	is_deleted
HSPI_Sandbox.care_team	is_deleted
HSPI_Sandbox.charges	is_deleted
HSPI_Sandbox.claim_batch_generation_rules	is_deleted
HSPI_Sandbox.claim_batches	is_deleted
HSPI_Sandbox.claim_field_adjustment_rules	is_deleted
HSPI_Sandbox.claim_insurances	is_deleted
HSPI_Sandbox.claim_items	is_deleted
HSPI_Sandbox.claims	is_deleted
HSPI_Sandbox.clinical_assessment_records	is_deleted
HSPI_Sandbox.clinical_assessment_structures	is_deleted
HSPI_Sandbox.clinical_assessments	is_deleted
HSPI_Sandbox.communication_recipients	is_deleted
HSPI_Sandbox.communications	is_deleted
HSPI_Sandbox.conditions	is_deleted
HSPI_Sandbox.configured_reports	is_deleted
HSPI_Sandbox.coverages	is_deleted
HSPI_Sandbox.devices	is_deleted
HSPI_Sandbox.entity_condition_groups	is_deleted
HSPI_Sandbox.examples	is_deleted
HSPI_Sandbox.family_history	is_deleted
HSPI_Sandbox.financial_accounts	is_deleted
HSPI_Sandbox.groups	is_deleted
HSPI_Sandbox.guarantors	is_deleted
HSPI_Sandbox.handling_codes	is_deleted
HSPI_Sandbox.immunizations	is_deleted
HSPI_Sandbox.invoice_batches	is_deleted
HSPI_Sandbox.invoices	is_deleted
HSPI_Sandbox.laboratory_orders	is_deleted
HSPI_Sandbox.laboratory_results	is_deleted
HSPI_Sandbox.locations	is_deleted
HSPI_Sandbox.medical_encoder_configurations	is_deleted
HSPI_Sandbox.medication_requests	is_deleted
HSPI_Sandbox.medications	is_deleted
HSPI_Sandbox.notes	is_deleted
HSPI_Sandbox.observations	is_deleted
HSPI_Sandbox.participants	is_deleted
HSPI_Sandbox.patient_abstracts	is_deleted
HSPI_Sandbox.patient_contacts	is_deleted
HSPI_Sandbox.patient_tracking	is_deleted
HSPI_Sandbox.patients_ethnicities	is_deleted
HSPI_Sandbox.patients_races	is_deleted
HSPI_Sandbox.practitioner_roles	is_deleted
HSPI_Sandbox.procedures	is_deleted
HSPI_Sandbox.providers	is_deleted
HSPI_Sandbox.reporting_keys	is_deleted
HSPI_Sandbox.saved_filters	is_deleted
HSPI_Sandbox.subscriptions	is_deleted
HSPI_Sandbox.transaction_codes	is_deleted
HSPI_Summit_General.Files	is_deleted
HSPI_Summit_General.allergies	is_deleted
HSPI_Summit_General.appointments	is_deleted
HSPI_Summit_General.authorization_roles	is_deleted
HSPI_Summit_General.billing_diagnoses	is_deleted
HSPI_Summit_General.billing_procedures	is_deleted
HSPI_Summit_General.care_plan_activities	is_deleted
HSPI_Summit_General.care_plans	is_deleted
HSPI_Summit_General.care_team	is_deleted
HSPI_Summit_General.charges	is_deleted
HSPI_Summit_General.claim_batch_generation_rules	is_deleted
HSPI_Summit_General.claim_batches	is_deleted
HSPI_Summit_General.claim_field_adjustment_rules	is_deleted
HSPI_Summit_General.claim_insurances	is_deleted
HSPI_Summit_General.claim_items	is_deleted
HSPI_Summit_General.claims	is_deleted
HSPI_Summit_General.clinical_assessment_records	is_deleted
HSPI_Summit_General.clinical_assessment_structures	is_deleted
HSPI_Summit_General.clinical_assessments	is_deleted
HSPI_Summit_General.communication_recipients	is_deleted
HSPI_Summit_General.communications	is_deleted
HSPI_Summit_General.conditions	is_deleted
HSPI_Summit_General.configured_reports	is_deleted
HSPI_Summit_General.coverages	is_deleted
HSPI_Summit_General.devices	is_deleted
HSPI_Summit_General.entity_condition_groups	is_deleted
HSPI_Summit_General.examples	is_deleted
HSPI_Summit_General.family_history	is_deleted
HSPI_Summit_General.financial_accounts	is_deleted
HSPI_Summit_General.groups	is_deleted
HSPI_Summit_General.guarantors	is_deleted
HSPI_Summit_General.handling_codes	is_deleted
HSPI_Summit_General.immunizations	is_deleted
HSPI_Summit_General.invoice_batches	is_deleted
HSPI_Summit_General.invoices	is_deleted
HSPI_Summit_General.laboratory_orders	is_deleted
HSPI_Summit_General.laboratory_results	is_deleted
HSPI_Summit_General.locations	is_deleted
HSPI_Summit_General.medical_encoder_configurations	is_deleted
HSPI_Summit_General.medication_requests	is_deleted
HSPI_Summit_General.medications	is_deleted
HSPI_Summit_General.notes	is_deleted
HSPI_Summit_General.observations	is_deleted
HSPI_Summit_General.participants	is_deleted
HSPI_Summit_General.patient_abstracts	is_deleted
HSPI_Summit_General.patient_contacts	is_deleted
HSPI_Summit_General.patient_tracking	is_deleted
HSPI_Summit_General.patients_ethnicities	is_deleted
HSPI_Summit_General.patients_races	is_deleted
HSPI_Summit_General.practitioner_roles	is_deleted
HSPI_Summit_General.procedures	is_deleted
HSPI_Summit_General.providers	is_deleted
HSPI_Summit_General.reporting_keys	is_deleted
HSPI_Summit_General.saved_filters	is_deleted
HSPI_Summit_General.subscriptions	is_deleted
HSPI_Summit_General.transaction_codes	is_deleted
HSPI_System.addresses	is_deleted
HSPI_System.networks	is_deleted
HSPI_System.organization_links	is_deleted
HSPI_System.organizations	is_deleted
HSPI_System.phone_numbers	is_deleted
HSPI_System.system_roles	is_deleted
HSPI_United_Physicians.Files	is_deleted
HSPI_United_Physicians.allergies	is_deleted
HSPI_United_Physicians.appointments	is_deleted
HSPI_United_Physicians.authorization_roles	is_deleted
HSPI_United_Physicians.billing_diagnoses	is_deleted
HSPI_United_Physicians.billing_procedures	is_deleted
HSPI_United_Physicians.care_plan_activities	is_deleted
HSPI_United_Physicians.care_plans	is_deleted
HSPI_United_Physicians.care_team	is_deleted
HSPI_United_Physicians.charges	is_deleted
HSPI_United_Physicians.claim_batch_generation_rules	is_deleted
HSPI_United_Physicians.claim_batches	is_deleted
HSPI_United_Physicians.claim_field_adjustment_rules	is_deleted
HSPI_United_Physicians.claim_insurances	is_deleted
HSPI_United_Physicians.claim_items	is_deleted
HSPI_United_Physicians.claims	is_deleted
HSPI_United_Physicians.clinical_assessment_records	is_deleted
HSPI_United_Physicians.clinical_assessment_structures	is_deleted
HSPI_United_Physicians.clinical_assessments	is_deleted
HSPI_United_Physicians.communication_recipients	is_deleted
HSPI_United_Physicians.communications	is_deleted
HSPI_United_Physicians.conditions	is_deleted
HSPI_United_Physicians.configured_reports	is_deleted
HSPI_United_Physicians.coverages	is_deleted
HSPI_United_Physicians.devices	is_deleted
HSPI_United_Physicians.entity_condition_groups	is_deleted
HSPI_United_Physicians.examples	is_deleted
HSPI_United_Physicians.family_history	is_deleted
HSPI_United_Physicians.financial_accounts	is_deleted
HSPI_United_Physicians.groups	is_deleted
HSPI_United_Physicians.guarantors	is_deleted
HSPI_United_Physicians.handling_codes	is_deleted
HSPI_United_Physicians.immunizations	is_deleted
HSPI_United_Physicians.invoice_batches	is_deleted
HSPI_United_Physicians.invoices	is_deleted
HSPI_United_Physicians.laboratory_orders	is_deleted
HSPI_United_Physicians.laboratory_results	is_deleted
HSPI_United_Physicians.locations	is_deleted
HSPI_United_Physicians.medical_encoder_configurations	is_deleted
HSPI_United_Physicians.medication_requests	is_deleted
HSPI_United_Physicians.medications	is_deleted
HSPI_United_Physicians.notes	is_deleted
HSPI_United_Physicians.observations	is_deleted
HSPI_United_Physicians.participants	is_deleted
HSPI_United_Physicians.patient_abstracts	is_deleted
HSPI_United_Physicians.patient_contacts	is_deleted
HSPI_United_Physicians.patient_tracking	is_deleted
HSPI_United_Physicians.patients_ethnicities	is_deleted
HSPI_United_Physicians.patients_races	is_deleted
HSPI_United_Physicians.practitioner_roles	is_deleted
HSPI_United_Physicians.procedures	is_deleted
HSPI_United_Physicians.providers	is_deleted
HSPI_United_Physicians.reporting_keys	is_deleted
HSPI_United_Physicians.saved_filters	is_deleted
HSPI_United_Physicians.subscriptions	is_deleted
HSPI_United_Physicians.transaction_codes	is_deleted
MPI.Bed	is_deleted
MPI.Files	is_deleted
MPI.Site	is_deleted
MPI.allergies	is_deleted
MPI.appointments	is_deleted
MPI.authorization_roles	is_deleted
MPI.billing_diagnoses	is_deleted
MPI.billing_procedures	is_deleted
MPI.care_plan_activities	is_deleted
MPI.care_plans	is_deleted
MPI.care_team	is_deleted
MPI.charge	is_deleted
MPI.charges	is_deleted
MPI.claim_batch_generation_rules	is_deleted
MPI.claim_batches	is_deleted
MPI.claim_field_adjustment_rules	is_deleted
MPI.claim_insurances	is_deleted
MPI.claim_items	is_deleted
MPI.claims	is_deleted
MPI.clinical_assessment_records	is_deleted
MPI.clinical_assessment_structures	is_deleted
MPI.clinical_assessments	is_deleted
MPI.communication_recipients	is_deleted
MPI.communications	is_deleted
MPI.conditions	is_deleted
MPI.configured_reports	is_deleted
MPI.coverages	is_deleted
MPI.devices	is_deleted
MPI.entity_condition_groups	is_deleted
MPI.examples	is_deleted
MPI.family_history	is_deleted
MPI.financial_accounts	is_deleted
MPI.groups	is_deleted
MPI.guarantors	is_deleted
MPI.handling_codes	is_deleted
MPI.immunizations	is_deleted
MPI.invoice_batches	is_deleted
MPI.invoices	is_deleted
MPI.laboratory_orders	is_deleted
MPI.laboratory_results	is_deleted
MPI.locations	is_deleted
MPI.medical_encoder_configurations	is_deleted
MPI.medication_requests	is_deleted
MPI.medications	is_deleted
MPI.networks	is_deleted
MPI.notes	is_deleted
MPI.observations	is_deleted
MPI.organization_links	is_deleted
MPI.organizations	is_deleted
MPI.participants	is_deleted
MPI.patient_abstracts	is_deleted
MPI.patient_contacts	is_deleted
MPI.patient_tracking	is_deleted
MPI.patients_ethnicities	is_deleted
MPI.patients_races	is_deleted
MPI.practitioner_roles	is_deleted
MPI.procedures	is_deleted
MPI.providers	is_deleted
MPI.reporting_keys	is_deleted
MPI.saved_filters	is_deleted
MPI.subscriptions	is_deleted
MPI.transaction_codes	is_deleted
Messaging.messages_access	mxs_deleted
Messaging.messages_access_new	mxs_deleted
SSO.employee_roles	is_deleted
SSO.names	is_deleted
_1.charts_custom_fields_values	ccfv_deleted
_1.cqm_entries	cqme_deleted
_1.cqm_stats	cqms_deleted
_1.cqm_stats_supplemental	cqmss_deleted
_1.encounters_soap_images	espi_deleted
_1.encounters_soap_labels_values	eslv_deleted
_1.health_maintenance	hm_deleted
_1.orders	ord_deleted
_1.patients_allergies	palg_deleted
_1.patients_handouts	phs_deleted
_1.patients_immunizations	pim_deleted
_1.patients_inventory	pinv_deleted
_1.patients_medications	pms_deleted
_1.patients_prescriptions	prx_deleted
_1.patients_smoking_status	pss_deleted
_1.radiology_orders	rad_deleted
_1.rooms_flags	rfs_deleted
_1188.charts_custom_fields_values	ccfv_deleted
_1188.cqm_entries	cqme_deleted
_1188.cqm_stats	cqms_deleted
_1188.cqm_stats_supplemental	cqmss_deleted
_1188.encounters_soap_images	espi_deleted
_1188.encounters_soap_labels_values	eslv_deleted
_1188.health_maintenance	hm_deleted
_1188.orders	ord_deleted
_1188.patients_allergies	palg_deleted
_1188.patients_handouts	phs_deleted
_1188.patients_immunizations	pim_deleted
_1188.patients_inventory	pinv_deleted
_1188.patients_medications	pms_deleted
_1188.patients_prescriptions	prx_deleted
_1188.patients_smoking_status	pss_deleted
_1188.radiology_orders	rad_deleted
_1188.rooms_flags	rfs_deleted
_1218.charts_custom_fields_values	ccfv_deleted
_1218.cqm_entries	cqme_deleted
_1218.cqm_stats	cqms_deleted
_1218.cqm_stats_supplemental	cqmss_deleted
_1218.encounters_soap_images	espi_deleted
_1218.encounters_soap_labels_values	eslv_deleted
_1218.health_maintenance	hm_deleted
_1218.orders	ord_deleted
_1218.patients_allergies	palg_deleted
_1218.patients_handouts	phs_deleted
_1218.patients_immunizations	pim_deleted
_1218.patients_inventory	pinv_deleted
_1218.patients_medications	pms_deleted
_1218.patients_prescriptions	prx_deleted
_1218.patients_smoking_status	pss_deleted
_1218.radiology_orders	rad_deleted
_1218.rooms_flags	rfs_deleted
_1548.charts_custom_fields_values	ccfv_deleted
_1548.cqm_entries	cqme_deleted
_1548.cqm_stats	cqms_deleted
_1548.cqm_stats_supplemental	cqmss_deleted
_1548.encounters_soap_images	espi_deleted
_1548.encounters_soap_labels_values	eslv_deleted
_1548.health_maintenance	hm_deleted
_1548.orders	ord_deleted
_1548.patients_allergies	palg_deleted
_1548.patients_handouts	phs_deleted
_1548.patients_immunizations	pim_deleted
_1548.patients_inventory	pinv_deleted
_1548.patients_medications	pms_deleted
_1548.patients_prescriptions	prx_deleted
_1548.patients_smoking_status	pss_deleted
_1548.radiology_orders	rad_deleted
_1548.rooms_flags	rfs_deleted
_435.charts_custom_fields_values	ccfv_deleted
_435.cqm_entries	cqme_deleted
_435.cqm_stats	cqms_deleted
_435.cqm_stats_supplemental	cqmss_deleted
_435.encounters_soap_images	espi_deleted
_435.encounters_soap_labels_values	eslv_deleted
_435.health_maintenance	hm_deleted
_435.orders	ord_deleted
_435.patients_allergies	palg_deleted
_435.patients_handouts	phs_deleted
_435.patients_immunizations	pim_deleted
_435.patients_inventory	pinv_deleted
_435.patients_medications	pms_deleted
_435.patients_prescriptions	prx_deleted
_435.patients_smoking_status	pss_deleted
_435.radiology_orders	rad_deleted
_435.rooms_flags	rfs_deleted
_436.charts_custom_fields_values	ccfv_deleted
_436.cqm_entries	cqme_deleted
_436.cqm_stats	cqms_deleted
_436.cqm_stats_supplemental	cqmss_deleted
_436.encounters_soap_images	espi_deleted
_436.encounters_soap_labels_values	eslv_deleted
_436.health_maintenance	hm_deleted
_436.orders	ord_deleted
_436.patients_allergies	palg_deleted
_436.patients_handouts	phs_deleted
_436.patients_immunizations	pim_deleted
_436.patients_inventory	pinv_deleted
_436.patients_medications	pms_deleted
_436.patients_prescriptions	prx_deleted
_436.patients_smoking_status	pss_deleted
_436.radiology_orders	rad_deleted
_436.rooms_flags	rfs_deleted
_436_archive_testing.charts_custom_fields_values	ccfv_deleted
_436_archive_testing.cqm_entries	cqme_deleted
_436_archive_testing.cqm_stats	cqms_deleted
_436_archive_testing.cqm_stats_supplemental	cqmss_deleted
_436_archive_testing.encounters_soap_images	espi_deleted
_436_archive_testing.encounters_soap_labels_values	eslv_deleted
_436_archive_testing.health_maintenance	hm_deleted
_436_archive_testing.orders	ord_deleted
_436_archive_testing.patients_allergies	palg_deleted
_436_archive_testing.patients_handouts	phs_deleted
_436_archive_testing.patients_immunizations	pim_deleted
_436_archive_testing.patients_inventory	pinv_deleted
_436_archive_testing.patients_medications	pms_deleted
_436_archive_testing.patients_prescriptions	prx_deleted
_436_archive_testing.patients_smoking_status	pss_deleted
_436_archive_testing.radiology_orders	rad_deleted
_436_archive_testing.rooms_flags	rfs_deleted
_437.charts_custom_fields_values	ccfv_deleted
_437.cqm_entries	cqme_deleted
_437.cqm_stats	cqms_deleted
_437.cqm_stats_supplemental	cqmss_deleted
_437.encounters_soap_images	espi_deleted
_437.encounters_soap_labels_values	eslv_deleted
_437.health_maintenance	hm_deleted
_437.orders	ord_deleted
_437.patients_allergies	palg_deleted
_437.patients_handouts	phs_deleted
_437.patients_immunizations	pim_deleted
_437.patients_inventory	pinv_deleted
_437.patients_medications	pms_deleted
_437.patients_prescriptions	prx_deleted
_437.patients_smoking_status	pss_deleted
_437.radiology_orders	rad_deleted
_437.rooms_flags	rfs_deleted
_8.charts_custom_fields_values	ccfv_deleted
_8.cqm_entries	cqme_deleted
_8.cqm_stats	cqms_deleted
_8.cqm_stats_supplemental	cqmss_deleted
_8.encounters_soap_images	espi_deleted
_8.encounters_soap_labels_values	eslv_deleted
_8.health_maintenance	hm_deleted
_8.orders	ord_deleted
_8.patients_allergies	palg_deleted
_8.patients_handouts	phs_deleted
_8.patients_immunizations	pim_deleted
_8.patients_inventory	pinv_deleted
_8.patients_medications	pms_deleted
_8.patients_prescriptions	prx_deleted
_8.patients_smoking_status	pss_deleted
_8.radiology_orders	rad_deleted
_8.rooms_flags	rfs_deleted
_81.charts_custom_fields_values	ccfv_deleted
_81.cqm_entries	cqme_deleted
_81.cqm_stats	cqms_deleted
_81.cqm_stats_supplemental	cqmss_deleted
_81.encounters_soap_images	espi_deleted
_81.encounters_soap_labels_values	eslv_deleted
_81.health_maintenance	hm_deleted
_81.orders	ord_deleted
_81.patients_allergies	palg_deleted
_81.patients_handouts	phs_deleted
_81.patients_immunizations	pim_deleted
_81.patients_inventory	pinv_deleted
_81.patients_medications	pms_deleted
_81.patients_prescriptions	prx_deleted
_81.patients_smoking_status	pss_deleted
_81.radiology_orders	rad_deleted
_81.rooms_flags	rfs_deleted
_999.charts_custom_fields_values	ccfv_deleted
_999.cqm_entries	cqme_deleted
_999.cqm_stats	cqms_deleted
_999.cqm_stats_supplemental	cqmss_deleted
_999.encounters_soap_images	espi_deleted
_999.encounters_soap_labels_values	eslv_deleted
_999.health_maintenance	hm_deleted
_999.orders	ord_deleted
_999.patients_allergies	palg_deleted
_999.patients_handouts	phs_deleted
_999.patients_immunizations	pim_deleted
_999.patients_inventory	pinv_deleted
_999.patients_medications	pms_deleted
_999.patients_prescriptions	prx_deleted
_999.patients_smoking_status	pss_deleted
_999.radiology_orders	rad_deleted
_999.rooms_flags	rfs_deleted
ahiWiki.archive	ar_deleted
ahiWiki.filearchive	fa_deleted
ahiWiki.ipblocks	ipb_deleted
ahiWiki.logging	log_deleted
ahiWiki.oldimage	oi_deleted
ahiWiki.recentchanges	rc_deleted
ahiWiki.revision	rev_deleted
aurora_standard.dtgactvd	date_deleted
aurora_standard.dtgactvd	time_deleted
xlnt.pullrequests	files_deleted

archived

Table	Column
EFaxes.efaxes	efax_archived
Messaging.messages_access	mxs_archived
_1.encounters_claims_statuses	ecs_archived
_1188.encounters_claims_statuses	ecs_archived
_1218.encounters_claims_statuses	ecs_archived
_1548.encounters_claims_statuses	ecs_archived
_435.encounters_claims_statuses	ecs_archived
_436.encounters_claims_statuses	ecs_archived
_436_archive_testing.encounters_claims_statuses	ecs_archived
_437.encounters_claims_statuses	ecs_archived
_8.encounters_claims_statuses	ecs_archived
_81.encounters_claims_statuses	ecs_archived
_999.encounters_claims_statuses	ecs_archived

demo

Table	Column
HSPI_Bastrop.patients	is_demo
HSPI_CURES2015_B1.patients	is_demo
HSPI_Central_Hospital.patients	is_demo
HSPI_Dewitt.patients	is_demo
HSPI_Fulton.patients	is_demo
HSPI_Inferno.patients	is_demo
HSPI_MU2015_E1.patients	is_demo
HSPI_MU2015_G2.patients	is_demo
HSPI_MU2015_G9.patients	is_demo
HSPI_Ness.patients	is_demo
HSPI_Sandbox.patients	is_demo
HSPI_Summit_General.patients	is_demo
HSPI_System.networks	is_demo
HSPI_System.organizations	is_demo
HSPI_United_Physicians.patients	is_demo
MPI.organizations	is_demo
MPI.patients	is_demo
common.clients	cli_demo
common.customers	cus_demo

pending

Table	Column
_1.cpoe_responses	cpoe_res_pending
_1.erx_notification_counts	erx_not_rx_pending
_1.erx_notification_counts	erx_not_rx_orders_pending
_1.hl7_accessions	acc_pending
_1.radiology_results	rad_res_pending
_1188.cpoe_responses	cpoe_res_pending
_1188.erx_notification_counts	erx_not_rx_pending
_1188.erx_notification_counts	erx_not_rx_orders_pending
_1188.hl7_accessions	acc_pending
_1188.radiology_results	rad_res_pending
_1218.cpoe_responses	cpoe_res_pending
_1218.erx_notification_counts	erx_not_rx_pending
_1218.erx_notification_counts	erx_not_rx_orders_pending
_1218.hl7_accessions	acc_pending
_1218.radiology_results	rad_res_pending
_1548.cpoe_responses	cpoe_res_pending
_1548.erx_notification_counts	erx_not_rx_pending
_1548.erx_notification_counts	erx_not_rx_orders_pending
_1548.hl7_accessions	acc_pending
_1548.radiology_results	rad_res_pending
_435.cpoe_responses	cpoe_res_pending
_435.erx_notification_counts	erx_not_rx_pending
_435.erx_notification_counts	erx_not_rx_orders_pending
_435.hl7_accessions	acc_pending
_435.radiology_results	rad_res_pending
_436.cpoe_responses	cpoe_res_pending
_436.erx_notification_counts	erx_not_rx_pending
_436.erx_notification_counts	erx_not_rx_orders_pending
_436.hl7_accessions	acc_pending
_436.radiology_results	rad_res_pending
_436_archive_testing.cpoe_responses	cpoe_res_pending
_436_archive_testing.erx_notification_counts	erx_not_rx_pending
_436_archive_testing.erx_notification_counts	erx_not_rx_orders_pending
_436_archive_testing.hl7_accessions	acc_pending
_436_archive_testing.radiology_results	rad_res_pending
_437.cpoe_responses	cpoe_res_pending
_437.erx_notification_counts	erx_not_rx_pending
_437.erx_notification_counts	erx_not_rx_orders_pending
_437.hl7_accessions	acc_pending
_437.radiology_results	rad_res_pending
_8.cpoe_responses	cpoe_res_pending
_8.erx_notification_counts	erx_not_rx_pending
_8.erx_notification_counts	erx_not_rx_orders_pending
_8.hl7_accessions	acc_pending
_8.radiology_results	rad_res_pending
_81.cpoe_responses	cpoe_res_pending
_81.erx_notification_counts	erx_not_rx_pending
_81.erx_notification_counts	erx_not_rx_orders_pending
_81.hl7_accessions	acc_pending
_81.radiology_results	rad_res_pending
_999.cpoe_responses	cpoe_res_pending
_999.erx_notification_counts	erx_not_rx_pending
_999.erx_notification_counts	erx_not_rx_orders_pending
_999.hl7_accessions	acc_pending
_999.radiology_results	rad_res_pending

hired

Table	Column
aurora_standard.chpcempr	date_hired
aurora_standard.styanniv	date_hired
aurora_standard.styemplr	date_hired
aurora_standard.styptoad	date_hired