aurora_standard.schappttempr

Field	Type	Null	Key
appt_id	int(11)	YES	MUL
appt_seq	smallint(6)	YES
appt_status	varchar(1)	YES	MUL
fac_no	varchar(3)	YES	MUL
group_id	smallint(6)	YES
resource_id	smallint(6)	YES
procedure_id	varchar(15)	YES
emr_no	int(11)	YES
input_by	int(11)	YES
comments	varchar(255)	YES
scheduled_date	date	YES
scheduled_time	time	YES
input_date	date	YES
input_time	time	YES
appt_date	date	YES
appt_time	time	YES
cancel_date	date	YES
cancel_time	time	YES
cancel_by	int(11)	YES
scheduled_by	int(11)	YES
reccurence_id	int(11)	YES
number	int(11)	YES
note_id	int(11)	YES
prep_id	int(11)	YES
ane_id	smallint(6)	YES
suffix_id	smallint(6)	YES
duration	int(11)	YES
multi	varchar(1)	YES
appt_link	int(11)	YES

References

Local Column

References

number

Table	Column
API.partner_accounts	phone_number
AzaleaStats.error_reports	err_source_line_number
EFaxes.efaxes_recipients	efr_number
HSPI_Bastrop.coverages	group_number
HSPI_Bastrop.coverages	policy_number
HSPI_Bastrop.locations	clia_number
HSPI_Bastrop.phone_numbers	phone_number
HSPI_CURES2015_B1.cbos_inventory_log	document_number
HSPI_CURES2015_B1.coverages	group_number
HSPI_CURES2015_B1.coverages	policy_number
HSPI_CURES2015_B1.locations	clia_number
HSPI_CURES2015_B1.phone_numbers	phone_number
HSPI_Central_Hospital.cbos_inventory_log	document_number
HSPI_Central_Hospital.coverages	group_number
HSPI_Central_Hospital.coverages	policy_number
HSPI_Central_Hospital.locations	clia_number
HSPI_Central_Hospital.phone_numbers	phone_number
HSPI_Dewitt.cbos_inventory_log	document_number
HSPI_Dewitt.coverages	group_number
HSPI_Dewitt.coverages	policy_number
HSPI_Dewitt.locations	clia_number
HSPI_Dewitt.phone_numbers	phone_number
HSPI_Fulton.cbos_inventory_log	document_number
HSPI_Fulton.coverages	group_number
HSPI_Fulton.coverages	policy_number
HSPI_Fulton.locations	clia_number
HSPI_Fulton.phone_numbers	phone_number
HSPI_Inferno.cbos_inventory_log	document_number
HSPI_Inferno.coverages	group_number
HSPI_Inferno.coverages	policy_number
HSPI_Inferno.locations	clia_number
HSPI_Inferno.phone_numbers	phone_number
HSPI_MU2015_E1.cbos_inventory_log	document_number
HSPI_MU2015_E1.coverages	group_number
HSPI_MU2015_E1.coverages	policy_number
HSPI_MU2015_E1.locations	clia_number
HSPI_MU2015_E1.phone_numbers	phone_number
HSPI_MU2015_G2.cbos_inventory_log	document_number
HSPI_MU2015_G2.coverages	group_number
HSPI_MU2015_G2.coverages	policy_number
HSPI_MU2015_G2.locations	clia_number
HSPI_MU2015_G2.phone_numbers	phone_number
HSPI_MU2015_G9.cbos_inventory_log	document_number
HSPI_MU2015_G9.coverages	group_number
HSPI_MU2015_G9.coverages	policy_number
HSPI_MU2015_G9.locations	clia_number
HSPI_MU2015_G9.phone_numbers	phone_number
HSPI_Ness.coverages	group_number
HSPI_Ness.coverages	policy_number
HSPI_Ness.phone_numbers	phone_number
HSPI_Sandbox.cbos_inventory_log	document_number
HSPI_Sandbox.coverages	group_number
HSPI_Sandbox.coverages	policy_number
HSPI_Sandbox.locations	clia_number
HSPI_Sandbox.phone_numbers	phone_number
HSPI_Summit_General.cbos_inventory_log	document_number
HSPI_Summit_General.coverages	group_number
HSPI_Summit_General.coverages	policy_number
HSPI_Summit_General.locations	clia_number
HSPI_Summit_General.phone_numbers	phone_number
HSPI_System.phone_numbers	phone_number
HSPI_United_Physicians.cbos_inventory_log	document_number
HSPI_United_Physicians.coverages	group_number
HSPI_United_Physicians.coverages	policy_number
HSPI_United_Physicians.locations	clia_number
HSPI_United_Physicians.phone_numbers	phone_number
MPI.cbos_inventory_log	document_number
MPI.coverages	group_number
MPI.coverages	policy_number
MPI.locations	clia_number
MPI.phone_numbers	phone_number
SSO.developer_profiles	phone_number
_1.client_contacts	clicon_fax_number
_1.encounters_claims_supplemental_informations	ecsi_control_number
_1.encounters_cpt_codes	ecp_prescription_number
_1.encounters_ub04	enc_ub04_81_a_number
_1.encounters_ub04	enc_ub04_81_b_number
_1.encounters_ub04	enc_ub04_81_c_number
_1.encounters_ub04	enc_ub04_81_d_number
_1.hl7_orders	ord_group_number
_1.inventory	inv_lot_number
_1.inventory	inv_product_number
_1.patients	pat_emergency_number
_1.patients_demographics_snapshots	pds_emergency_number
_1.patients_histories	ph_enc_version_number
_1.patients_inventory	pinv_lot_number
_1.patients_inventory	pinv_product_number
_1.patients_prescriptions	prx_order_number
_1188.client_contacts	clicon_fax_number
_1188.encounters_claims_supplemental_informations	ecsi_control_number
_1188.encounters_cpt_codes	ecp_prescription_number
_1188.encounters_ub04	enc_ub04_81_a_number
_1188.encounters_ub04	enc_ub04_81_b_number
_1188.encounters_ub04	enc_ub04_81_c_number
_1188.encounters_ub04	enc_ub04_81_d_number
_1188.hl7_orders	ord_group_number
_1188.inventory	inv_lot_number
_1188.inventory	inv_product_number
_1188.patients	pat_emergency_number
_1188.patients_demographics_snapshots	pds_emergency_number
_1188.patients_histories	ph_enc_version_number
_1188.patients_inventory	pinv_lot_number
_1188.patients_inventory	pinv_product_number
_1188.patients_prescriptions	prx_order_number
_1218.client_contacts	clicon_fax_number
_1218.encounters_claims_supplemental_informations	ecsi_control_number
_1218.encounters_cpt_codes	ecp_prescription_number
_1218.encounters_ub04	enc_ub04_81_a_number
_1218.encounters_ub04	enc_ub04_81_b_number
_1218.encounters_ub04	enc_ub04_81_c_number
_1218.encounters_ub04	enc_ub04_81_d_number
_1218.hl7_orders	ord_group_number
_1218.inventory	inv_lot_number
_1218.inventory	inv_product_number
_1218.patients	pat_emergency_number
_1218.patients_demographics_snapshots	pds_emergency_number
_1218.patients_histories	ph_enc_version_number
_1218.patients_inventory	pinv_lot_number
_1218.patients_inventory	pinv_product_number
_1218.patients_prescriptions	prx_order_number
_1548.client_contacts	clicon_fax_number
_1548.encounters_claims_supplemental_informations	ecsi_control_number
_1548.encounters_cpt_codes	ecp_prescription_number
_1548.encounters_ub04	enc_ub04_81_a_number
_1548.encounters_ub04	enc_ub04_81_b_number
_1548.encounters_ub04	enc_ub04_81_c_number
_1548.encounters_ub04	enc_ub04_81_d_number
_1548.hl7_orders	ord_group_number
_1548.inventory	inv_lot_number
_1548.inventory	inv_product_number
_1548.patients	pat_emergency_number
_1548.patients_demographics_snapshots	pds_emergency_number
_1548.patients_histories	ph_enc_version_number
_1548.patients_inventory	pinv_lot_number
_1548.patients_inventory	pinv_product_number
_1548.patients_prescriptions	prx_order_number
_435.client_contacts	clicon_fax_number
_435.encounters_claims_supplemental_informations	ecsi_control_number
_435.encounters_cpt_codes	ecp_prescription_number
_435.encounters_ub04	enc_ub04_81_a_number
_435.encounters_ub04	enc_ub04_81_b_number
_435.encounters_ub04	enc_ub04_81_c_number
_435.encounters_ub04	enc_ub04_81_d_number
_435.hl7_orders	ord_group_number
_435.inventory	inv_lot_number
_435.inventory	inv_product_number
_435.patients	pat_emergency_number
_435.patients_demographics_snapshots	pds_emergency_number
_435.patients_histories	ph_enc_version_number
_435.patients_inventory	pinv_lot_number
_435.patients_inventory	pinv_product_number
_435.patients_prescriptions	prx_order_number
_436.client_contacts	clicon_fax_number
_436.encounters_claims_supplemental_informations	ecsi_control_number
_436.encounters_cpt_codes	ecp_prescription_number
_436.encounters_ub04	enc_ub04_81_a_number
_436.encounters_ub04	enc_ub04_81_b_number
_436.encounters_ub04	enc_ub04_81_c_number
_436.encounters_ub04	enc_ub04_81_d_number
_436.hl7_orders	ord_group_number
_436.inventory	inv_lot_number
_436.inventory	inv_product_number
_436.patients	pat_emergency_number
_436.patients_demographics_snapshots	pds_emergency_number
_436.patients_histories	ph_enc_version_number
_436.patients_inventory	pinv_lot_number
_436.patients_inventory	pinv_product_number
_436.patients_prescriptions	prx_order_number
_436_archive_testing.client_contacts	clicon_fax_number
_436_archive_testing.encounters_claims_supplemental_informations	ecsi_control_number
_436_archive_testing.encounters_cpt_codes	ecp_prescription_number
_436_archive_testing.encounters_ub04	enc_ub04_81_a_number
_436_archive_testing.encounters_ub04	enc_ub04_81_b_number
_436_archive_testing.encounters_ub04	enc_ub04_81_c_number
_436_archive_testing.encounters_ub04	enc_ub04_81_d_number
_436_archive_testing.hl7_orders	ord_group_number
_436_archive_testing.inventory	inv_lot_number
_436_archive_testing.inventory	inv_product_number
_436_archive_testing.patients	pat_emergency_number
_436_archive_testing.patients_demographics_snapshots	pds_emergency_number
_436_archive_testing.patients_histories	ph_enc_version_number
_436_archive_testing.patients_inventory	pinv_lot_number
_436_archive_testing.patients_inventory	pinv_product_number
_436_archive_testing.patients_prescriptions	prx_order_number
_437.client_contacts	clicon_fax_number
_437.encounters_claims_supplemental_informations	ecsi_control_number
_437.encounters_cpt_codes	ecp_prescription_number
_437.encounters_ub04	enc_ub04_81_a_number
_437.encounters_ub04	enc_ub04_81_b_number
_437.encounters_ub04	enc_ub04_81_c_number
_437.encounters_ub04	enc_ub04_81_d_number
_437.hl7_orders	ord_group_number
_437.inventory	inv_lot_number
_437.inventory	inv_product_number
_437.patients	pat_emergency_number
_437.patients_demographics_snapshots	pds_emergency_number
_437.patients_histories	ph_enc_version_number
_437.patients_inventory	pinv_lot_number
_437.patients_inventory	pinv_product_number
_437.patients_prescriptions	prx_order_number
_8.client_contacts	clicon_fax_number
_8.encounters_claims_supplemental_informations	ecsi_control_number
_8.encounters_cpt_codes	ecp_prescription_number
_8.encounters_ub04	enc_ub04_81_a_number
_8.encounters_ub04	enc_ub04_81_b_number
_8.encounters_ub04	enc_ub04_81_c_number
_8.encounters_ub04	enc_ub04_81_d_number
_8.hl7_orders	ord_group_number
_8.inventory	inv_lot_number
_8.inventory	inv_product_number
_8.patients	pat_emergency_number
_8.patients_demographics_snapshots	pds_emergency_number
_8.patients_histories	ph_enc_version_number
_8.patients_inventory	pinv_lot_number
_8.patients_inventory	pinv_product_number
_8.patients_prescriptions	prx_order_number
_81.client_contacts	clicon_fax_number
_81.encounters_claims_supplemental_informations	ecsi_control_number
_81.encounters_cpt_codes	ecp_prescription_number
_81.encounters_ub04	enc_ub04_81_a_number
_81.encounters_ub04	enc_ub04_81_b_number
_81.encounters_ub04	enc_ub04_81_c_number
_81.encounters_ub04	enc_ub04_81_d_number
_81.hl7_orders	ord_group_number
_81.inventory	inv_lot_number
_81.inventory	inv_product_number
_81.patients	pat_emergency_number
_81.patients_demographics_snapshots	pds_emergency_number
_81.patients_histories	ph_enc_version_number
_81.patients_inventory	pinv_lot_number
_81.patients_inventory	pinv_product_number
_81.patients_prescriptions	prx_order_number
_999.client_contacts	clicon_fax_number
_999.encounters_claims_supplemental_informations	ecsi_control_number
_999.encounters_cpt_codes	ecp_prescription_number
_999.encounters_ub04	enc_ub04_81_a_number
_999.encounters_ub04	enc_ub04_81_b_number
_999.encounters_ub04	enc_ub04_81_c_number
_999.encounters_ub04	enc_ub04_81_d_number
_999.hl7_orders	ord_group_number
_999.inventory	inv_lot_number
_999.inventory	inv_product_number
_999.patients	pat_emergency_number
_999.patients_demographics_snapshots	pds_emergency_number
_999.patients_histories	ph_enc_version_number
_999.patients_inventory	pinv_lot_number
_999.patients_inventory	pinv_product_number
_999.patients_prescriptions	prx_order_number
aurora_standard.acptwrk	cpt_number
aurora_standard.acptwrk	dec_number
aurora_standard.addcdm	dept_number
aurora_standard.b2badd	mr_number
aurora_standard.bhbadd	mr_number
aurora_standard.bhldgr	mr_number
aurora_standard.bhphybak	mr_number
aurora_standard.bhtldgr	mr_number
aurora_standard.caadj	gl_number
aurora_standard.cachrg	gl_number
aurora_standard.cachrg2	gl_number
aurora_standard.cachrgca	gl_number
aurora_standard.cachrgevo	gl_number
aurora_standard.canullchrg	gl_number
aurora_standard.capay	gl_number
aurora_standard.caroom	gl_number
aurora_standard.cgsinptr	auto_number
aurora_standard.chcimmuc	join_number
aurora_standard.chcmanuc	join_number
aurora_standard.chcprovc	join_number
aurora_standard.chcseric	join_number
aurora_standard.chm15chd	phys_number
aurora_standard.chm835ps	svc_number
aurora_standard.chmbatex	mc_number
aurora_standard.chmblogd	seq_number
aurora_standard.chmmbc37	policy_number
aurora_standard.chmmbc37	ocna_number
aurora_standard.chmmbc50	payor_number
aurora_standard.chmmbc51	check_number
aurora_standard.chmmhbcr	check_number
aurora_standard.chmmneca	orig_number
aurora_standard.chmpatmd	mr_number
aurora_standard.chmphync	mr_number
aurora_standard.chmpress	client_number
aurora_standard.chpcobrd	cobra_number
aurora_standard.chpemphd	seq_number
aurora_standard.chpliced	license_number
aurora_standard.chpparba	cus_number
aurora_standard.chqcardd	phy_number
aurora_standard.chqchekd	phy_number
aurora_standard.chqchrtd	phy_number
aurora_standard.chqcmeud	phy_number
aurora_standard.chqletrd	phy_number
aurora_standard.chqliabd	phy_number
aurora_standard.chqlicnd	license_number
aurora_standard.chqlicnd	phy_number
aurora_standard.chqnpdbd	phy_number
aurora_standard.chqphync	phy_number
aurora_standard.chqstafd	phy_number
aurora_standard.chrdfile	id_number
aurora_standard.chtclokd	inc_number
aurora_standard.hhtclokd	inc_number
aurora_standard.oeorder	phy_number
aurora_standard.stfasstr	po_number
aurora_standard.stonwall	dept_number
aurora_standard.stpapckv	document_number
aurora_standard.stpapckv	posting_number
aurora_standard.stpapckv	check_number
aurora_standard.stpapckv	account_number
aurora_standard.stxerord	err_number
aurora_standard.stxerorh	err_number
aurora_standard.stxhelpd	hlp_number
aurora_standard.stxmssgr	mssg_number
aurora_standard.stycntrc	ein_number
aurora_standard.stycntrc	state_number
aurora_standard.stycntrc	suta_number
aurora_standard.stydeddv	document_number
aurora_standard.stydeddv	check_number
aurora_standard.stydeddv	empl_acct_number
aurora_standard.styempid	inc_number
aurora_standard.styincdv	document_number
aurora_standard.styincdv	check_number
aurora_standard.styobldv	document_number
aurora_standard.styobldv	check_number
aurora_standard.styoctcc	gov_entity_id_number
aurora_standard.styoctcc	form_1095c_number
aurora_standard.styoctcc	ale_form_1095c_number
aurora_standard.stypddrd	trace_number
aurora_standard.styptodv	document_number
aurora_standard.styrtimd	inc_number
aurora_standard.stytimed	inc_number
aurora_standard.stytypid	inc_number
aurora_standard.stywtwoe	state_number
aurora_standard.stywtwoe	local_number
aurora_standard.timetabl	inc_number
aurora_standard.timetabl_in	inc_number
aurora_standard.tmpmrrpt	control_number
aurora_standard.vault_relationships	relationship_code_number
common.appointments_clienttell_statuses	acs_number
common.card_connect_merchant_accounts	ccma_hsn_number
common.card_connect_merchant_devices_map	ccmdm_hsn_number
common.faxes	fax_number
xlnt.builds	bamboo_build_number
xlnt.selenium_test_queue	build_number
xlnt.selenium_test_results	build_number

group_id

Table	Column
HSPI_Bastrop.billing_alert_rules	entity_condition_group_id
HSPI_Bastrop.claim_batch_generation_rules	entity_condition_group_id
HSPI_Bastrop.claim_field_adjustment_rules	entity_condition_group_id
HSPI_Bastrop.claim_item_generation_rules	entity_condition_group_id
HSPI_Bastrop.saved_filters	entity_condition_group_id
HSPI_CURES2015_B1.billing_alert_rules	entity_condition_group_id
HSPI_CURES2015_B1.billing_controls	entity_condition_group_id
HSPI_CURES2015_B1.claim_batch_generation_rules	entity_condition_group_id
HSPI_CURES2015_B1.claim_field_adjustment_rules	entity_condition_group_id
HSPI_CURES2015_B1.claim_item_generation_rules	entity_condition_group_id
HSPI_CURES2015_B1.claim_splitting_rule_charge_groups	entity_condition_group_id
HSPI_CURES2015_B1.claim_splitting_rules	encounter_matching_condition_group_id
HSPI_CURES2015_B1.invoice_generation_rule_sets	entity_condition_group_id
HSPI_CURES2015_B1.saved_filters	entity_condition_group_id
HSPI_Central_Hospital.billing_alert_rules	entity_condition_group_id
HSPI_Central_Hospital.billing_controls	entity_condition_group_id
HSPI_Central_Hospital.claim_batch_generation_rules	entity_condition_group_id
HSPI_Central_Hospital.claim_field_adjustment_rules	entity_condition_group_id
HSPI_Central_Hospital.claim_item_generation_rules	entity_condition_group_id
HSPI_Central_Hospital.claim_splitting_rule_charge_groups	entity_condition_group_id
HSPI_Central_Hospital.claim_splitting_rules	encounter_matching_condition_group_id
HSPI_Central_Hospital.invoice_generation_rule_sets	entity_condition_group_id
HSPI_Central_Hospital.saved_filters	entity_condition_group_id
HSPI_Dewitt.billing_alert_rules	entity_condition_group_id
HSPI_Dewitt.billing_controls	entity_condition_group_id
HSPI_Dewitt.claim_batch_generation_rules	entity_condition_group_id
HSPI_Dewitt.claim_field_adjustment_rules	entity_condition_group_id
HSPI_Dewitt.claim_item_generation_rules	entity_condition_group_id
HSPI_Dewitt.claim_splitting_rule_charge_groups	entity_condition_group_id
HSPI_Dewitt.claim_splitting_rules	encounter_matching_condition_group_id
HSPI_Dewitt.invoice_generation_rule_sets	entity_condition_group_id
HSPI_Dewitt.saved_filters	entity_condition_group_id
HSPI_Fulton.billing_alert_rules	entity_condition_group_id
HSPI_Fulton.billing_controls	entity_condition_group_id
HSPI_Fulton.claim_batch_generation_rules	entity_condition_group_id
HSPI_Fulton.claim_field_adjustment_rules	entity_condition_group_id
HSPI_Fulton.claim_item_generation_rules	entity_condition_group_id
HSPI_Fulton.claim_splitting_rule_charge_groups	entity_condition_group_id
HSPI_Fulton.claim_splitting_rules	encounter_matching_condition_group_id
HSPI_Fulton.invoice_generation_rule_sets	entity_condition_group_id
HSPI_Fulton.saved_filters	entity_condition_group_id
HSPI_Inferno.billing_alert_rules	entity_condition_group_id
HSPI_Inferno.billing_controls	entity_condition_group_id
HSPI_Inferno.claim_batch_generation_rules	entity_condition_group_id
HSPI_Inferno.claim_field_adjustment_rules	entity_condition_group_id
HSPI_Inferno.claim_item_generation_rules	entity_condition_group_id
HSPI_Inferno.claim_splitting_rule_charge_groups	entity_condition_group_id
HSPI_Inferno.claim_splitting_rules	encounter_matching_condition_group_id
HSPI_Inferno.invoice_generation_rule_sets	entity_condition_group_id
HSPI_Inferno.saved_filters	entity_condition_group_id
HSPI_MU2015_E1.billing_alert_rules	entity_condition_group_id
HSPI_MU2015_E1.billing_controls	entity_condition_group_id
HSPI_MU2015_E1.claim_batch_generation_rules	entity_condition_group_id
HSPI_MU2015_E1.claim_field_adjustment_rules	entity_condition_group_id
HSPI_MU2015_E1.claim_item_generation_rules	entity_condition_group_id
HSPI_MU2015_E1.claim_splitting_rule_charge_groups	entity_condition_group_id
HSPI_MU2015_E1.claim_splitting_rules	encounter_matching_condition_group_id
HSPI_MU2015_E1.invoice_generation_rule_sets	entity_condition_group_id
HSPI_MU2015_E1.saved_filters	entity_condition_group_id
HSPI_MU2015_G2.billing_alert_rules	entity_condition_group_id
HSPI_MU2015_G2.billing_controls	entity_condition_group_id
HSPI_MU2015_G2.claim_batch_generation_rules	entity_condition_group_id
HSPI_MU2015_G2.claim_field_adjustment_rules	entity_condition_group_id
HSPI_MU2015_G2.claim_item_generation_rules	entity_condition_group_id
HSPI_MU2015_G2.claim_splitting_rule_charge_groups	entity_condition_group_id
HSPI_MU2015_G2.claim_splitting_rules	encounter_matching_condition_group_id
HSPI_MU2015_G2.invoice_generation_rule_sets	entity_condition_group_id
HSPI_MU2015_G2.saved_filters	entity_condition_group_id
HSPI_MU2015_G9.billing_alert_rules	entity_condition_group_id
HSPI_MU2015_G9.billing_controls	entity_condition_group_id
HSPI_MU2015_G9.claim_batch_generation_rules	entity_condition_group_id
HSPI_MU2015_G9.claim_field_adjustment_rules	entity_condition_group_id
HSPI_MU2015_G9.claim_item_generation_rules	entity_condition_group_id
HSPI_MU2015_G9.claim_splitting_rule_charge_groups	entity_condition_group_id
HSPI_MU2015_G9.claim_splitting_rules	encounter_matching_condition_group_id
HSPI_MU2015_G9.invoice_generation_rule_sets	entity_condition_group_id
HSPI_MU2015_G9.saved_filters	entity_condition_group_id
HSPI_Sandbox.billing_alert_rules	entity_condition_group_id
HSPI_Sandbox.billing_controls	entity_condition_group_id
HSPI_Sandbox.claim_batch_generation_rules	entity_condition_group_id
HSPI_Sandbox.claim_field_adjustment_rules	entity_condition_group_id
HSPI_Sandbox.claim_item_generation_rules	entity_condition_group_id
HSPI_Sandbox.claim_splitting_rule_charge_groups	entity_condition_group_id
HSPI_Sandbox.claim_splitting_rules	encounter_matching_condition_group_id
HSPI_Sandbox.invoice_generation_rule_sets	entity_condition_group_id
HSPI_Sandbox.saved_filters	entity_condition_group_id
HSPI_Summit_General.billing_alert_rules	entity_condition_group_id
HSPI_Summit_General.billing_controls	entity_condition_group_id
HSPI_Summit_General.claim_batch_generation_rules	entity_condition_group_id
HSPI_Summit_General.claim_field_adjustment_rules	entity_condition_group_id
HSPI_Summit_General.claim_item_generation_rules	entity_condition_group_id
HSPI_Summit_General.claim_splitting_rule_charge_groups	entity_condition_group_id
HSPI_Summit_General.claim_splitting_rules	encounter_matching_condition_group_id
HSPI_Summit_General.invoice_generation_rule_sets	entity_condition_group_id
HSPI_Summit_General.saved_filters	entity_condition_group_id
HSPI_United_Physicians.billing_alert_rules	entity_condition_group_id
HSPI_United_Physicians.billing_controls	entity_condition_group_id
HSPI_United_Physicians.claim_batch_generation_rules	entity_condition_group_id
HSPI_United_Physicians.claim_field_adjustment_rules	entity_condition_group_id
HSPI_United_Physicians.claim_item_generation_rules	entity_condition_group_id
HSPI_United_Physicians.claim_splitting_rule_charge_groups	entity_condition_group_id
HSPI_United_Physicians.claim_splitting_rules	encounter_matching_condition_group_id
HSPI_United_Physicians.invoice_generation_rule_sets	entity_condition_group_id
HSPI_United_Physicians.saved_filters	entity_condition_group_id
MPI.billing_alert_rules	entity_condition_group_id
MPI.billing_controls	entity_condition_group_id
MPI.claim_batch_generation_rules	entity_condition_group_id
MPI.claim_field_adjustment_rules	entity_condition_group_id
MPI.claim_item_generation_rules	entity_condition_group_id
MPI.claim_splitting_rule_charge_groups	entity_condition_group_id
MPI.claim_splitting_rules	encounter_matching_condition_group_id
MPI.invoice_generation_rule_sets	entity_condition_group_id
MPI.saved_filters	entity_condition_group_id
_1.schedules	sch_group_id
_1188.schedules	sch_group_id
_1218.schedules	sch_group_id
_1548.schedules	sch_group_id
_435.schedules	sch_group_id
_436.schedules	sch_group_id
_436_archive_testing.schedules	sch_group_id
_437.schedules	sch_group_id
_8.schedules	sch_group_id
_81.schedules	sch_group_id
_999.schedules	sch_group_id
aurora_standard.vault_icd9s	icd_group_id
common.clients	cli_medicare_group_id
common.clients	cli_medicaid_group_id

duration

Table	Column
HSPI_Bastrop.medication_requests	dosage_duration
HSPI_CURES2015_B1.medication_requests	dosage_duration
HSPI_Central_Hospital.medication_requests	dosage_duration
HSPI_Dewitt.medication_requests	dosage_duration
HSPI_Fulton.medication_requests	dosage_duration
HSPI_Inferno.medication_requests	dosage_duration
HSPI_MU2015_E1.medication_requests	dosage_duration
HSPI_MU2015_G2.medication_requests	dosage_duration
HSPI_MU2015_G9.medication_requests	dosage_duration
HSPI_Sandbox.medication_requests	dosage_duration
HSPI_Summit_General.medication_requests	dosage_duration
HSPI_United_Physicians.medication_requests	dosage_duration
MPI.medication_requests	dosage_duration
SSO.users	lock_next_duration
_1.appointment_recurrence	arec_apt_duration
_1.appointments	apt_duration
_1.appointments_reasons	are_duration
_1.orders	ord_duration
_1.orders_templates	ordt_duration
_1.patients_medications	pms_duration
_1.patients_prescriptions	prx_duration
_1.radiology_orders	rad_duration
_1.recalls_reasons	rr_duration
_1.schedules	sch_duration
_1.tasks_categories	tcat_duration
_1188.appointment_recurrence	arec_apt_duration
_1188.appointments	apt_duration
_1188.appointments_reasons	are_duration
_1188.orders	ord_duration
_1188.orders_templates	ordt_duration
_1188.patients_medications	pms_duration
_1188.patients_prescriptions	prx_duration
_1188.radiology_orders	rad_duration
_1188.recalls_reasons	rr_duration
_1188.schedules	sch_duration
_1188.tasks_categories	tcat_duration
_1218.appointment_recurrence	arec_apt_duration
_1218.appointments	apt_duration
_1218.appointments_reasons	are_duration
_1218.orders	ord_duration
_1218.orders_templates	ordt_duration
_1218.patients_medications	pms_duration
_1218.patients_prescriptions	prx_duration
_1218.radiology_orders	rad_duration
_1218.recalls_reasons	rr_duration
_1218.schedules	sch_duration
_1218.tasks_categories	tcat_duration
_1548.appointment_recurrence	arec_apt_duration
_1548.appointments	apt_duration
_1548.appointments_reasons	are_duration
_1548.orders	ord_duration
_1548.orders_templates	ordt_duration
_1548.patients_medications	pms_duration
_1548.patients_prescriptions	prx_duration
_1548.radiology_orders	rad_duration
_1548.recalls_reasons	rr_duration
_1548.schedules	sch_duration
_1548.tasks_categories	tcat_duration
_435.appointment_recurrence	arec_apt_duration
_435.appointments	apt_duration
_435.appointments_reasons	are_duration
_435.orders	ord_duration
_435.orders_templates	ordt_duration
_435.patients_medications	pms_duration
_435.patients_prescriptions	prx_duration
_435.radiology_orders	rad_duration
_435.recalls_reasons	rr_duration
_435.schedules	sch_duration
_435.tasks_categories	tcat_duration
_436.appointment_recurrence	arec_apt_duration
_436.appointments	apt_duration
_436.appointments_reasons	are_duration
_436.orders	ord_duration
_436.orders_templates	ordt_duration
_436.patients_medications	pms_duration
_436.patients_prescriptions	prx_duration
_436.radiology_orders	rad_duration
_436.recalls_reasons	rr_duration
_436.schedules	sch_duration
_436.tasks_categories	tcat_duration
_436_archive_testing.appointment_recurrence	arec_apt_duration
_436_archive_testing.appointments	apt_duration
_436_archive_testing.appointments_reasons	are_duration
_436_archive_testing.orders	ord_duration
_436_archive_testing.orders_templates	ordt_duration
_436_archive_testing.patients_medications	pms_duration
_436_archive_testing.patients_prescriptions	prx_duration
_436_archive_testing.radiology_orders	rad_duration
_436_archive_testing.recalls_reasons	rr_duration
_436_archive_testing.schedules	sch_duration
_436_archive_testing.tasks_categories	tcat_duration
_437.appointment_recurrence	arec_apt_duration
_437.appointments	apt_duration
_437.appointments_reasons	are_duration
_437.orders	ord_duration
_437.orders_templates	ordt_duration
_437.patients_medications	pms_duration
_437.patients_prescriptions	prx_duration
_437.radiology_orders	rad_duration
_437.recalls_reasons	rr_duration
_437.schedules	sch_duration
_437.tasks_categories	tcat_duration
_8.appointment_recurrence	arec_apt_duration
_8.appointments	apt_duration
_8.appointments_reasons	are_duration
_8.orders	ord_duration
_8.orders_templates	ordt_duration
_8.patients_medications	pms_duration
_8.patients_prescriptions	prx_duration
_8.radiology_orders	rad_duration
_8.recalls_reasons	rr_duration
_8.schedules	sch_duration
_8.tasks_categories	tcat_duration
_81.appointment_recurrence	arec_apt_duration
_81.appointments	apt_duration
_81.appointments_reasons	are_duration
_81.orders	ord_duration
_81.orders_templates	ordt_duration
_81.patients_medications	pms_duration
_81.patients_prescriptions	prx_duration
_81.radiology_orders	rad_duration
_81.recalls_reasons	rr_duration
_81.schedules	sch_duration
_81.tasks_categories	tcat_duration
_999.appointment_recurrence	arec_apt_duration
_999.appointments	apt_duration
_999.appointments_reasons	are_duration
_999.orders	ord_duration
_999.orders_templates	ordt_duration
_999.patients_medications	pms_duration
_999.patients_prescriptions	prx_duration
_999.radiology_orders	rad_duration
_999.recalls_reasons	rr_duration
_999.schedules	sch_duration
_999.tasks_categories	tcat_duration
aurora_standard.chpcobrc	months_duration
common.telehealth_sessions	ths_duration
common.telehealth_sessions	ths_summed_duration
template_library.orders_templates	ordt_duration
xlnt.builds	build_duration

comments

Table	Column
Loinc.loinc_codes	lc_comments
_1.patient_amendments	pa_comments
_1.patients_allergies	palg_comments
_1.patients_medications	pms_erx_comments
_1.patients_reminders	pr_comments
_1188.patient_amendments	pa_comments
_1188.patients_allergies	palg_comments
_1188.patients_medications	pms_erx_comments
_1188.patients_reminders	pr_comments
_1218.patient_amendments	pa_comments
_1218.patients_allergies	palg_comments
_1218.patients_medications	pms_erx_comments
_1218.patients_reminders	pr_comments
_1548.patient_amendments	pa_comments
_1548.patients_allergies	palg_comments
_1548.patients_medications	pms_erx_comments
_1548.patients_reminders	pr_comments
_435.patient_amendments	pa_comments
_435.patients_allergies	palg_comments
_435.patients_medications	pms_erx_comments
_435.patients_reminders	pr_comments
_436.patient_amendments	pa_comments
_436.patients_allergies	palg_comments
_436.patients_medications	pms_erx_comments
_436.patients_reminders	pr_comments
_436_archive_testing.patient_amendments	pa_comments
_436_archive_testing.patients_allergies	palg_comments
_436_archive_testing.patients_medications	pms_erx_comments
_436_archive_testing.patients_reminders	pr_comments
_437.patient_amendments	pa_comments
_437.patients_allergies	palg_comments
_437.patients_medications	pms_erx_comments
_437.patients_reminders	pr_comments
_8.patient_amendments	pa_comments
_8.patients_allergies	palg_comments
_8.patients_medications	pms_erx_comments
_8.patients_reminders	pr_comments
_81.patient_amendments	pa_comments
_81.patients_allergies	palg_comments
_81.patients_medications	pms_erx_comments
_81.patients_reminders	pr_comments
_999.patient_amendments	pa_comments
_999.patients_allergies	palg_comments
_999.patients_medications	pms_erx_comments
_999.patients_reminders	pr_comments
aurora_standard.cgsifldd	f_comments
aurora_standard.chlrescd	res_comments
aurora_standard.chpinsrd	class_comments
common.applicants	app_comments
common.data_import_clients_meta_data	dicmd_comments
common.data_import_field_types	dift_comments
common.data_import_fields	dif_comments
common.leads	lea_comments
common.loinc_codes	lc_comments

fac_no

Table	Column
aurora_standard.chmprica	prev_fac_no
aurora_standard.chmprica	cur_fac_no
aurora_standard.chpcashr	cash_fac_no
aurora_standard.chpcobpd	cash_fac_no
aurora_standard.chpcobpd	bal_fac_no
aurora_standard.chscustd	dept_fac_no
aurora_standard.chshotlr	dept_fac_no
aurora_standard.chtemplr	dflt_fac_no
aurora_standard.curs_temp	cash_fac_no
aurora_standard.curs_temp	ap_fac_no
aurora_standard.stgrowpd	rod_beg_fac_no
aurora_standard.stgrowpd	rod_end_fac_no
aurora_standard.stpcashd	dist_fac_no
aurora_standard.stpcashd	disc_fac_no
aurora_standard.stpcashe	cash_fac_no
aurora_standard.stpcntrc	cash_fac_no
aurora_standard.stpcntrc	disc_fac_no
aurora_standard.stpinvce	cash_fac_no
aurora_standard.stpopend	ap_fac_no
aurora_standard.stpopend	cash_fac_no
aurora_standard.stucntrc	cash_fac_no
aurora_standard.stuinvce	cash_fac_no
aurora_standard.stxfinsd	fin_fac_no
aurora_standard.styaccrr	liab_fac_no
aurora_standard.styaccrr	expense_fac_no
aurora_standard.styemplr	cash_fac_no
aurora_standard.stypayfd	cash_fac_no
aurora_standard.stypayod	bal_fac_no
aurora_standard.stypayre	cash_fac_no
aurora_standard.styrevsd	cash_fac_no
aurora_standard.stytyper	cash_fac_no

appt_date

Table	Column
aurora_standard.chqphync	init_appt_date

appt_time

Table	Column
aurora_standard.schapptmastr	actual_appt_time