aurora_standard.choordrc

Field	Type	Null	Key	Extra
fac_no	varchar(3)	YES
order_item	varchar(20)	YES	UNI
kit_code	varchar(1)	YES
whse_code	varchar(10)	YES
description	varchar(30)	YES
default_units	int(11)	YES
default_uom	varchar(10)	YES
results_code	varchar(20)	YES
consent_form	varchar(18)	YES
service_code	varchar(10)	YES
item_code	varchar(20)	YES
other_code	varchar(20)	YES
order_text	varchar(70)	YES
order_type	varchar(2)	YES
cat_group	varchar(20)	YES
cat_seq	smallint(6)	YES
form_name	varchar(18)	YES
when_print	varchar(12)	YES
time_limit	int(11)	YES
alert	varchar(12)	YES
chs_rowID	bigint(20) unsigned	NO	PRI	auto_increment

References

Local Column

References

description

Table	Column
HSPI_Bastrop.devices	device_description
HSPI_CURES2015_B1.devices	device_description
HSPI_Central_Hospital.devices	device_description
HSPI_Dewitt.devices	device_description
HSPI_Fulton.devices	device_description
HSPI_Inferno.devices	device_description
HSPI_MU2015_E1.devices	device_description
HSPI_MU2015_G2.devices	device_description
HSPI_MU2015_G9.devices	device_description
HSPI_Sandbox.devices	device_description
HSPI_Summit_General.devices	device_description
HSPI_United_Physicians.devices	device_description
MPI.devices	device_description
_1.adjustment_rules	ar_description
_1.cqm_errors	cqmer_description
_1.encounters_alert_rules	ear_description
_1.patients_implantable_devices	pid_device_description
_1188.cqm_errors	cqmer_description
_1188.encounters_alert_rules	ear_description
_1188.patients_implantable_devices	pid_device_description
_1218.adjustment_rules	ar_description
_1218.cqm_errors	cqmer_description
_1218.encounters_alert_rules	ear_description
_1218.patients_implantable_devices	pid_device_description
_1548.adjustment_rules	ar_description
_1548.cqm_errors	cqmer_description
_1548.encounters_alert_rules	ear_description
_1548.patients_implantable_devices	pid_device_description
_435.adjustment_rules	ar_description
_435.cqm_errors	cqmer_description
_435.encounters_alert_rules	ear_description
_435.patients_implantable_devices	pid_device_description
_436.adjustment_rules	ar_description
_436.cqm_errors	cqmer_description
_436.encounters_alert_rules	ear_description
_436.patients_implantable_devices	pid_device_description
_436_archive_testing.adjustment_rules	ar_description
_436_archive_testing.cqm_errors	cqmer_description
_436_archive_testing.encounters_alert_rules	ear_description
_436_archive_testing.patients_implantable_devices	pid_device_description
_437.adjustment_rules	ar_description
_437.cqm_errors	cqmer_description
_437.encounters_alert_rules	ear_description
_437.patients_implantable_devices	pid_device_description
_8.adjustment_rules	ar_description
_8.cqm_errors	cqmer_description
_8.encounters_alert_rules	ear_description
_8.patients_implantable_devices	pid_device_description
_81.cqm_errors	cqmer_description
_81.encounters_alert_rules	ear_description
_81.patients_implantable_devices	pid_device_description
_999.adjustment_rules	ar_description
_999.cqm_errors	cqmer_description
_999.encounters_alert_rules	ear_description
_999.patients_implantable_devices	pid_device_description
ahiWiki.filearchive	fa_description
ahiWiki.image	img_description
ahiWiki.oldimage	oi_description
aurora_standard.medgenix_modules	module_description
aurora_standard.stfclond	asst_description
aurora_standard.stpapckv	acct_description
aurora_standard.stultypr	update_description
aurora_standard.stxparmd	val_description
aurora_standard.stydeddv	home_description
aurora_standard.styincdv	home_description
aurora_standard.styintfc	source_description
aurora_standard.styjobtc	job_description
aurora_standard.styobldv	home_description
aurora_standard.styptodv	home_description
common.data_import_options	dio_description
common.data_import_value_types	divt_description
common.dev_requests	dev_description
common.dev_requests_screencasts	drs_description
common.insurances_claim_indicators	insci_description
common.smoking_statuses	ss_description
common.test_codes	tco_x_specimen_description
common.test_codes_profiles	tcp_description

alert

Table	Column
_1.encounters_cpt_codes	ecp_cc_gender_alert
_1.encounters_cpt_codes	ecp_cc_age_alert
_1.encounters_cpt_codes	ecp_cc_ncd_alert
_1.encounters_cpt_codes	ecp_cc_lcd_alert
_1.encounters_cpt_codes	ecp_cc_cci_alert
_1.encounters_cpt_codes	ecp_cc_cpt_mod_alert
_1.encounters_cpt_codes	ecp_cc_expired_dx_alert
_1.encounters_cpt_codes	ecp_cc_expired_cpt_alert
_1.encounters_cpt_codes	ecp_cc_abn_alert
_1188.encounters_cpt_codes	ecp_cc_gender_alert
_1188.encounters_cpt_codes	ecp_cc_age_alert
_1188.encounters_cpt_codes	ecp_cc_ncd_alert
_1188.encounters_cpt_codes	ecp_cc_lcd_alert
_1188.encounters_cpt_codes	ecp_cc_cci_alert
_1188.encounters_cpt_codes	ecp_cc_cpt_mod_alert
_1188.encounters_cpt_codes	ecp_cc_expired_dx_alert
_1188.encounters_cpt_codes	ecp_cc_expired_cpt_alert
_1188.encounters_cpt_codes	ecp_cc_abn_alert
_1218.encounters_cpt_codes	ecp_cc_gender_alert
_1218.encounters_cpt_codes	ecp_cc_age_alert
_1218.encounters_cpt_codes	ecp_cc_ncd_alert
_1218.encounters_cpt_codes	ecp_cc_lcd_alert
_1218.encounters_cpt_codes	ecp_cc_cci_alert
_1218.encounters_cpt_codes	ecp_cc_cpt_mod_alert
_1218.encounters_cpt_codes	ecp_cc_expired_dx_alert
_1218.encounters_cpt_codes	ecp_cc_expired_cpt_alert
_1218.encounters_cpt_codes	ecp_cc_abn_alert
_1548.encounters_cpt_codes	ecp_cc_gender_alert
_1548.encounters_cpt_codes	ecp_cc_age_alert
_1548.encounters_cpt_codes	ecp_cc_ncd_alert
_1548.encounters_cpt_codes	ecp_cc_lcd_alert
_1548.encounters_cpt_codes	ecp_cc_cci_alert
_1548.encounters_cpt_codes	ecp_cc_cpt_mod_alert
_1548.encounters_cpt_codes	ecp_cc_expired_dx_alert
_1548.encounters_cpt_codes	ecp_cc_expired_cpt_alert
_1548.encounters_cpt_codes	ecp_cc_abn_alert
_435.encounters_cpt_codes	ecp_cc_gender_alert
_435.encounters_cpt_codes	ecp_cc_age_alert
_435.encounters_cpt_codes	ecp_cc_ncd_alert
_435.encounters_cpt_codes	ecp_cc_lcd_alert
_435.encounters_cpt_codes	ecp_cc_cci_alert
_435.encounters_cpt_codes	ecp_cc_cpt_mod_alert
_435.encounters_cpt_codes	ecp_cc_expired_dx_alert
_435.encounters_cpt_codes	ecp_cc_expired_cpt_alert
_435.encounters_cpt_codes	ecp_cc_abn_alert
_436.encounters_cpt_codes	ecp_cc_gender_alert
_436.encounters_cpt_codes	ecp_cc_age_alert
_436.encounters_cpt_codes	ecp_cc_ncd_alert
_436.encounters_cpt_codes	ecp_cc_lcd_alert
_436.encounters_cpt_codes	ecp_cc_cci_alert
_436.encounters_cpt_codes	ecp_cc_cpt_mod_alert
_436.encounters_cpt_codes	ecp_cc_expired_dx_alert
_436.encounters_cpt_codes	ecp_cc_expired_cpt_alert
_436.encounters_cpt_codes	ecp_cc_abn_alert
_436_archive_testing.encounters_cpt_codes	ecp_cc_gender_alert
_436_archive_testing.encounters_cpt_codes	ecp_cc_age_alert
_436_archive_testing.encounters_cpt_codes	ecp_cc_ncd_alert
_436_archive_testing.encounters_cpt_codes	ecp_cc_lcd_alert
_436_archive_testing.encounters_cpt_codes	ecp_cc_cci_alert
_436_archive_testing.encounters_cpt_codes	ecp_cc_cpt_mod_alert
_436_archive_testing.encounters_cpt_codes	ecp_cc_expired_dx_alert
_436_archive_testing.encounters_cpt_codes	ecp_cc_expired_cpt_alert
_436_archive_testing.encounters_cpt_codes	ecp_cc_abn_alert
_437.encounters_cpt_codes	ecp_cc_gender_alert
_437.encounters_cpt_codes	ecp_cc_age_alert
_437.encounters_cpt_codes	ecp_cc_ncd_alert
_437.encounters_cpt_codes	ecp_cc_lcd_alert
_437.encounters_cpt_codes	ecp_cc_cci_alert
_437.encounters_cpt_codes	ecp_cc_cpt_mod_alert
_437.encounters_cpt_codes	ecp_cc_expired_dx_alert
_437.encounters_cpt_codes	ecp_cc_expired_cpt_alert
_437.encounters_cpt_codes	ecp_cc_abn_alert
_8.encounters_cpt_codes	ecp_cc_gender_alert
_8.encounters_cpt_codes	ecp_cc_age_alert
_8.encounters_cpt_codes	ecp_cc_ncd_alert
_8.encounters_cpt_codes	ecp_cc_lcd_alert
_8.encounters_cpt_codes	ecp_cc_cci_alert
_8.encounters_cpt_codes	ecp_cc_cpt_mod_alert
_8.encounters_cpt_codes	ecp_cc_expired_dx_alert
_8.encounters_cpt_codes	ecp_cc_expired_cpt_alert
_8.encounters_cpt_codes	ecp_cc_abn_alert
_81.encounters_cpt_codes	ecp_cc_gender_alert
_81.encounters_cpt_codes	ecp_cc_age_alert
_81.encounters_cpt_codes	ecp_cc_ncd_alert
_81.encounters_cpt_codes	ecp_cc_lcd_alert
_81.encounters_cpt_codes	ecp_cc_cci_alert
_81.encounters_cpt_codes	ecp_cc_cpt_mod_alert
_81.encounters_cpt_codes	ecp_cc_expired_dx_alert
_81.encounters_cpt_codes	ecp_cc_expired_cpt_alert
_81.encounters_cpt_codes	ecp_cc_abn_alert
_999.encounters_cpt_codes	ecp_cc_gender_alert
_999.encounters_cpt_codes	ecp_cc_age_alert
_999.encounters_cpt_codes	ecp_cc_ncd_alert
_999.encounters_cpt_codes	ecp_cc_lcd_alert
_999.encounters_cpt_codes	ecp_cc_cci_alert
_999.encounters_cpt_codes	ecp_cc_cpt_mod_alert
_999.encounters_cpt_codes	ecp_cc_expired_dx_alert
_999.encounters_cpt_codes	ecp_cc_expired_cpt_alert
_999.encounters_cpt_codes	ecp_cc_abn_alert

order_type

Table	Column
_1.physician_order_delegations	phyod_order_type
_1188.physician_order_delegations	phyod_order_type
_1218.physician_order_delegations	phyod_order_type
_1548.physician_order_delegations	phyod_order_type
_435.physician_order_delegations	phyod_order_type
_436.physician_order_delegations	phyod_order_type
_436_archive_testing.physician_order_delegations	phyod_order_type
_437.physician_order_delegations	phyod_order_type
_8.physician_order_delegations	phyod_order_type
_81.physician_order_delegations	phyod_order_type
_999.physician_order_delegations	phyod_order_type

item_code

Table	Column
aurora_standard.chmbitmd	vend_item_code
aurora_standard.chmschgd	vend_item_code
aurora_standard.glstrack	p_item_code
aurora_standard.glstrack	m_item_code
aurora_standard.icactvv	vend_item_code
aurora_standard.stiixref	vend_item_code
aurora_standard.stmaintd	maint_po_item_code
aurora_standard.stuctlgd	vend_item_code
aurora_standard.sturqstd	vend_item_code
aurora_standard.tmpctlgd	vend_item_code
aurora_standard.tmplvl2	vend_item_code
aurora_standard.tmplvl3	vend_item_code
aurora_standard.tmpparlvl	vend_item_code

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

whse_code

Table	Column
aurora_standard.choordmd	send_to_whse_code
aurora_standard.choordmd	input_whse_code
aurora_standard.choordmd	received_whse_code