_1548.locations

Field	Type	Null	Default	Key	Extra	Comment
loc_id	int(11)	NO		PRI	auto_increment
loc_default_bp_id	int(11)	YES		MUL
loc_cus_id	int(11)	NO		MUL
loc_cli_id	int(11)	NO		MUL
loc_spl_id	int(11)	NO		MUL
loc_cfs_id	int(11)	NO		MUL
loc_mnemonic	varchar(40)	NO
loc_name	varchar(40)	NO
loc_address1	varchar(40)	NO
loc_address2	varchar(40)	NO
loc_city	varchar(30)	NO
loc_state	varchar(2)	NO
loc_zip	varchar(5)	NO
loc_zip_plus4	varchar(4)	NO
loc_npi	varchar(15)	NO
loc_phone	varchar(20)	NO
loc_clia_num	varchar(20)	NO
loc_tax_id	varchar(9)	NO				Tax Identifier
loc_taxonomy	varchar(20)	NO				used for UB-04 claims box 81CCa
loc_scheduler_default	char(1)	NO		MUL
loc_no_scheduler	char(1)	NO		MUL
loc_no_encounters	char(1)	NO		MUL
loc_ub04_surgery_center	tinyint(1)	NO	0			Indicates encounters with this location should default to ub04
loc_ub04_bill_type	varchar(4)	YES				Indicates encounters with this location should default to this ub04 bill type
loc_id_ext	varchar(30)	NO	0	MUL
loc_id_interface_ext	varchar(40)	NO		MUL
loc_disabled	char(1)	NO
loc_modified	datetime	YES	CURRENT_TIMESTAMP
loc_created	datetime	YES	CURRENT_TIMESTAMP

References

Local Column

References

loc_mnemonic

Table	Column
_1.appointment_reminders_configurations	arcon_loc_mnemonic
_1188.appointment_reminders_configurations	arcon_loc_mnemonic
_1218.appointment_reminders_configurations	arcon_loc_mnemonic
_1548.appointment_reminders_configurations	arcon_loc_mnemonic
_435.appointment_reminders_configurations	arcon_loc_mnemonic
_436.appointment_reminders_configurations	arcon_loc_mnemonic
_436_archive_testing.appointment_reminders_configurations	arcon_loc_mnemonic
_437.appointment_reminders_configurations	arcon_loc_mnemonic
_8.appointment_reminders_configurations	arcon_loc_mnemonic
_81.appointment_reminders_configurations	arcon_loc_mnemonic
_999.appointment_reminders_configurations	arcon_loc_mnemonic

loc_id

Table	Column
_1.appointments	apt_loc_id
_1.appointments_requests	aptreq_loc_id
_1.audits	aud_loc_id
_1.audits_archive	aud_loc_id
_1.buildings	bld_loc_id
_1.charts	chrt_loc_id
_1.configured_encounters_templates	cet_loc_id
_1.encounters	enc_loc_id
_1.inventory	inv_loc_id
_1.ledger	led_loc_id
_1.ledger_unapplied_payments	lup_loc_id
_1.orders	ord_loc_id
_1.patients	pat_loc_id
_1.patients_responsibility_estimates	prest_loc_id
_1.precerts	pre_loc_id
_1.radiology_orders	rad_loc_id
_1.recall_list	rcl_loc_id
_1.recall_list_templates	rclt_loc_id
_1.rooms	rms_loc_id
_1.rooms_flags	rfs_loc_id
_1.schedules	sch_loc_id
_1.schedules_events	sevnt_loc_id
_1.schedules_exceptions	sexc_loc_id
_1.schedules_markup	smu_loc_id
_1.voided_payments	vp_loc_id
_1188.appointments	apt_loc_id
_1188.appointments_requests	aptreq_loc_id
_1188.audits	aud_loc_id
_1188.audits_archive	aud_loc_id
_1188.buildings	bld_loc_id
_1188.charts	chrt_loc_id
_1188.configured_encounters_templates	cet_loc_id
_1188.encounters	enc_loc_id
_1188.ledger	led_loc_id
_1188.ledger_unapplied_payments	lup_loc_id
_1188.orders	ord_loc_id
_1188.patients	pat_loc_id
_1188.patients_responsibility_estimates	prest_loc_id
_1188.precerts	pre_loc_id
_1188.radiology_orders	rad_loc_id
_1188.recall_list	rcl_loc_id
_1188.recall_list_templates	rclt_loc_id
_1188.rooms	rms_loc_id
_1188.rooms_flags	rfs_loc_id
_1188.schedules	sch_loc_id
_1188.schedules_events	sevnt_loc_id
_1188.schedules_exceptions	sexc_loc_id
_1188.schedules_markup	smu_loc_id
_1188.voided_payments	vp_loc_id
_1218.appointments	apt_loc_id
_1218.appointments_requests	aptreq_loc_id
_1218.audits	aud_loc_id
_1218.audits_archive	aud_loc_id
_1218.buildings	bld_loc_id
_1218.charts	chrt_loc_id
_1218.configured_encounters_templates	cet_loc_id
_1218.encounters	enc_loc_id
_1218.inventory	inv_loc_id
_1218.ledger	led_loc_id
_1218.ledger_unapplied_payments	lup_loc_id
_1218.orders	ord_loc_id
_1218.patients	pat_loc_id
_1218.patients_responsibility_estimates	prest_loc_id
_1218.precerts	pre_loc_id
_1218.radiology_orders	rad_loc_id
_1218.recall_list	rcl_loc_id
_1218.recall_list_templates	rclt_loc_id
_1218.rooms	rms_loc_id
_1218.rooms_flags	rfs_loc_id
_1218.schedules	sch_loc_id
_1218.schedules_events	sevnt_loc_id
_1218.schedules_exceptions	sexc_loc_id
_1218.schedules_markup	smu_loc_id
_1218.voided_payments	vp_loc_id
_1548.appointments	apt_loc_id
_1548.appointments_requests	aptreq_loc_id
_1548.audits	aud_loc_id
_1548.audits_archive	aud_loc_id
_1548.buildings	bld_loc_id
_1548.charts	chrt_loc_id
_1548.configured_encounters_templates	cet_loc_id
_1548.encounters	enc_loc_id
_1548.inventory	inv_loc_id
_1548.ledger	led_loc_id
_1548.ledger_unapplied_payments	lup_loc_id
_1548.orders	ord_loc_id
_1548.patients	pat_loc_id
_1548.patients_responsibility_estimates	prest_loc_id
_1548.precerts	pre_loc_id
_1548.radiology_orders	rad_loc_id
_1548.recall_list	rcl_loc_id
_1548.recall_list_templates	rclt_loc_id
_1548.rooms	rms_loc_id
_1548.rooms_flags	rfs_loc_id
_1548.schedules	sch_loc_id
_1548.schedules_events	sevnt_loc_id
_1548.schedules_exceptions	sexc_loc_id
_1548.schedules_markup	smu_loc_id
_1548.voided_payments	vp_loc_id
_435.appointments	apt_loc_id
_435.appointments_requests	aptreq_loc_id
_435.audits	aud_loc_id
_435.audits_archive	aud_loc_id
_435.buildings	bld_loc_id
_435.charts	chrt_loc_id
_435.configured_encounters_templates	cet_loc_id
_435.encounters	enc_loc_id
_435.inventory	inv_loc_id
_435.ledger	led_loc_id
_435.ledger_unapplied_payments	lup_loc_id
_435.orders	ord_loc_id
_435.patients	pat_loc_id
_435.patients_responsibility_estimates	prest_loc_id
_435.precerts	pre_loc_id
_435.radiology_orders	rad_loc_id
_435.recall_list	rcl_loc_id
_435.recall_list_templates	rclt_loc_id
_435.rooms	rms_loc_id
_435.rooms_flags	rfs_loc_id
_435.schedules	sch_loc_id
_435.schedules_events	sevnt_loc_id
_435.schedules_exceptions	sexc_loc_id
_435.schedules_markup	smu_loc_id
_435.voided_payments	vp_loc_id
_436.appointments	apt_loc_id
_436.appointments_requests	aptreq_loc_id
_436.audits	aud_loc_id
_436.audits_archive	aud_loc_id
_436.buildings	bld_loc_id
_436.charts	chrt_loc_id
_436.configured_encounters_templates	cet_loc_id
_436.encounters	enc_loc_id
_436.inventory	inv_loc_id
_436.ledger	led_loc_id
_436.ledger_unapplied_payments	lup_loc_id
_436.orders	ord_loc_id
_436.patients	pat_loc_id
_436.patients_responsibility_estimates	prest_loc_id
_436.precerts	pre_loc_id
_436.radiology_orders	rad_loc_id
_436.recall_list	rcl_loc_id
_436.recall_list_templates	rclt_loc_id
_436.rooms	rms_loc_id
_436.rooms_flags	rfs_loc_id
_436.schedules	sch_loc_id
_436.schedules_events	sevnt_loc_id
_436.schedules_exceptions	sexc_loc_id
_436.schedules_markup	smu_loc_id
_436.voided_payments	vp_loc_id
_436_archive_testing.appointments	apt_loc_id
_436_archive_testing.appointments_requests	aptreq_loc_id
_436_archive_testing.audits	aud_loc_id
_436_archive_testing.audits_archive	aud_loc_id
_436_archive_testing.buildings	bld_loc_id
_436_archive_testing.charts	chrt_loc_id
_436_archive_testing.configured_encounters_templates	cet_loc_id
_436_archive_testing.encounters	enc_loc_id
_436_archive_testing.inventory	inv_loc_id
_436_archive_testing.ledger	led_loc_id
_436_archive_testing.ledger_unapplied_payments	lup_loc_id
_436_archive_testing.orders	ord_loc_id
_436_archive_testing.patients	pat_loc_id
_436_archive_testing.patients_responsibility_estimates	prest_loc_id
_436_archive_testing.precerts	pre_loc_id
_436_archive_testing.radiology_orders	rad_loc_id
_436_archive_testing.recall_list	rcl_loc_id
_436_archive_testing.recall_list_templates	rclt_loc_id
_436_archive_testing.rooms	rms_loc_id
_436_archive_testing.rooms_flags	rfs_loc_id
_436_archive_testing.schedules	sch_loc_id
_436_archive_testing.schedules_events	sevnt_loc_id
_436_archive_testing.schedules_exceptions	sexc_loc_id
_436_archive_testing.schedules_markup	smu_loc_id
_436_archive_testing.voided_payments	vp_loc_id
_437.appointments	apt_loc_id
_437.appointments_requests	aptreq_loc_id
_437.audits	aud_loc_id
_437.audits_archive	aud_loc_id
_437.buildings	bld_loc_id
_437.charts	chrt_loc_id
_437.configured_encounters_templates	cet_loc_id
_437.encounters	enc_loc_id
_437.inventory	inv_loc_id
_437.ledger	led_loc_id
_437.ledger_unapplied_payments	lup_loc_id
_437.orders	ord_loc_id
_437.patients	pat_loc_id
_437.patients_responsibility_estimates	prest_loc_id
_437.precerts	pre_loc_id
_437.radiology_orders	rad_loc_id
_437.recall_list	rcl_loc_id
_437.recall_list_templates	rclt_loc_id
_437.rooms	rms_loc_id
_437.rooms_flags	rfs_loc_id
_437.schedules	sch_loc_id
_437.schedules_events	sevnt_loc_id
_437.schedules_exceptions	sexc_loc_id
_437.schedules_markup	smu_loc_id
_437.voided_payments	vp_loc_id
_8.appointments	apt_loc_id
_8.appointments_requests	aptreq_loc_id
_8.audits	aud_loc_id
_8.audits_archive	aud_loc_id
_8.buildings	bld_loc_id
_8.charts	chrt_loc_id
_8.configured_encounters_templates	cet_loc_id
_8.daily_close_calculations	dcc_loc_id
_8.encounters	enc_loc_id
_8.inventory	inv_loc_id
_8.ledger	led_loc_id
_8.ledger_unapplied_payments	lup_loc_id
_8.orders	ord_loc_id
_8.patients	pat_loc_id
_8.patients_responsibility_estimates	prest_loc_id
_8.precerts	pre_loc_id
_8.radiology_orders	rad_loc_id
_8.recall_list	rcl_loc_id
_8.recall_list_templates	rclt_loc_id
_8.rooms	rms_loc_id
_8.rooms_flags	rfs_loc_id
_8.schedules	sch_loc_id
_8.schedules_events	sevnt_loc_id
_8.schedules_exceptions	sexc_loc_id
_8.schedules_markup	smu_loc_id
_8.voided_payments	vp_loc_id
_81.appointments	apt_loc_id
_81.appointments_requests	aptreq_loc_id
_81.audits	aud_loc_id
_81.audits_archive	aud_loc_id
_81.buildings	bld_loc_id
_81.charts	chrt_loc_id
_81.configured_encounters_templates	cet_loc_id
_81.encounters	enc_loc_id
_81.inventory	inv_loc_id
_81.ledger	led_loc_id
_81.ledger_unapplied_payments	lup_loc_id
_81.orders	ord_loc_id
_81.patients	pat_loc_id
_81.patients_responsibility_estimates	prest_loc_id
_81.precerts	pre_loc_id
_81.radiology_orders	rad_loc_id
_81.recall_list	rcl_loc_id
_81.recall_list_templates	rclt_loc_id
_81.rooms	rms_loc_id
_81.rooms_flags	rfs_loc_id
_81.schedules	sch_loc_id
_81.schedules_events	sevnt_loc_id
_81.schedules_exceptions	sexc_loc_id
_81.schedules_markup	smu_loc_id
_81.voided_payments	vp_loc_id
_999.appointments	apt_loc_id
_999.appointments_requests	aptreq_loc_id
_999.audits	aud_loc_id
_999.audits_archive	aud_loc_id
_999.buildings	bld_loc_id
_999.charts	chrt_loc_id
_999.configured_encounters_templates	cet_loc_id
_999.encounters	enc_loc_id
_999.inventory	inv_loc_id
_999.ledger	led_loc_id
_999.ledger_unapplied_payments	lup_loc_id
_999.orders	ord_loc_id
_999.patients	pat_loc_id
_999.patients_responsibility_estimates	prest_loc_id
_999.precerts	pre_loc_id
_999.radiology_orders	rad_loc_id
_999.recall_list	rcl_loc_id
_999.recall_list_templates	rclt_loc_id
_999.rooms	rms_loc_id
_999.rooms_flags	rfs_loc_id
_999.schedules	sch_loc_id
_999.schedules_events	sevnt_loc_id
_999.schedules_exceptions	sexc_loc_id
_999.schedules_markup	smu_loc_id
_999.voided_payments	vp_loc_id
common.ahi_audits	aud_loc_id
common.applicants	app_loc_id
common.card_connect_merchant_accounts	ccma_loc_id
common.card_connect_merchant_devices_map	ccmdm_loc_id
common.clients	cli_default_loc_id
common.users_notification_settings	usrnotset_loc_id