aurora_standard.mergpts

Field Type Null Default Key Extra Comment
chs_rowID int(11) NO PRI auto_increment
mergdoc_id int(11) YES
part_type varchar(255) YES
description varchar(255) YES
page_no int(11) YES
required tinyint(1) YES
x_coord_tl int(11) YES
y_coord_tl int(11) YES
x_coord_br int(11) YES
y_coord_br int(11) YES
part_file varchar(255) YES
default_value varchar(255) YES
source_table varchar(255) YES
source_column varchar(255) YES
checked_value varchar(255) YES

References

Local Column References
description
TableColumn
HSPI_Bastrop.devicesdevice_description
HSPI_CURES2015_B1.devicesdevice_description
HSPI_Central_Hospital.devicesdevice_description
HSPI_Dewitt.devicesdevice_description
HSPI_Fulton.devicesdevice_description
HSPI_Inferno.devicesdevice_description
HSPI_MU2015_E1.devicesdevice_description
HSPI_MU2015_G2.devicesdevice_description
HSPI_MU2015_G9.devicesdevice_description
HSPI_Sandbox.devicesdevice_description
HSPI_Summit_General.devicesdevice_description
HSPI_United_Physicians.devicesdevice_description
MPI.devicesdevice_description
_1.adjustment_rulesar_description
_1.cqm_errorscqmer_description
_1.encounters_alert_rulesear_description
_1.patients_implantable_devicespid_device_description
_1188.cqm_errorscqmer_description
_1188.encounters_alert_rulesear_description
_1188.patients_implantable_devicespid_device_description
_1218.adjustment_rulesar_description
_1218.cqm_errorscqmer_description
_1218.encounters_alert_rulesear_description
_1218.patients_implantable_devicespid_device_description
_1548.adjustment_rulesar_description
_1548.cqm_errorscqmer_description
_1548.encounters_alert_rulesear_description
_1548.patients_implantable_devicespid_device_description
_435.adjustment_rulesar_description
_435.cqm_errorscqmer_description
_435.encounters_alert_rulesear_description
_435.patients_implantable_devicespid_device_description
_436.adjustment_rulesar_description
_436.cqm_errorscqmer_description
_436.encounters_alert_rulesear_description
_436.patients_implantable_devicespid_device_description
_436_archive_testing.adjustment_rulesar_description
_436_archive_testing.cqm_errorscqmer_description
_436_archive_testing.encounters_alert_rulesear_description
_436_archive_testing.patients_implantable_devicespid_device_description
_437.adjustment_rulesar_description
_437.cqm_errorscqmer_description
_437.encounters_alert_rulesear_description
_437.patients_implantable_devicespid_device_description
_8.adjustment_rulesar_description
_8.cqm_errorscqmer_description
_8.encounters_alert_rulesear_description
_8.patients_implantable_devicespid_device_description
_81.cqm_errorscqmer_description
_81.encounters_alert_rulesear_description
_81.patients_implantable_devicespid_device_description
_999.adjustment_rulesar_description
_999.cqm_errorscqmer_description
_999.encounters_alert_rulesear_description
_999.patients_implantable_devicespid_device_description
ahiWiki.filearchivefa_description
ahiWiki.imageimg_description
ahiWiki.oldimageoi_description
aurora_standard.medgenix_modulesmodule_description
aurora_standard.stfclondasst_description
aurora_standard.stpapckvacct_description
aurora_standard.stultyprupdate_description
aurora_standard.stxparmdval_description
aurora_standard.stydeddvhome_description
aurora_standard.styincdvhome_description
aurora_standard.styintfcsource_description
aurora_standard.styjobtcjob_description
aurora_standard.styobldvhome_description
aurora_standard.styptodvhome_description
common.data_import_optionsdio_description
common.data_import_value_typesdivt_description
common.dev_requestsdev_description
common.dev_requests_screencastsdrs_description
common.insurances_claim_indicatorsinsci_description
common.smoking_statusesss_description
common.test_codestco_x_specimen_description
common.test_codes_profilestcp_description
required
TableColumn
HSPI_Bastrop.financial_classescertification_required
HSPI_Bastrop.financial_classesfinal_diagnosis_required
HSPI_CURES2015_B1.financial_classescertification_required
HSPI_CURES2015_B1.financial_classesfinal_diagnosis_required
HSPI_Central_Hospital.financial_classescertification_required
HSPI_Central_Hospital.financial_classesfinal_diagnosis_required
HSPI_Dewitt.financial_classescertification_required
HSPI_Dewitt.financial_classesfinal_diagnosis_required
HSPI_Fulton.financial_classescertification_required
HSPI_Fulton.financial_classesfinal_diagnosis_required
HSPI_Inferno.financial_classescertification_required
HSPI_Inferno.financial_classesfinal_diagnosis_required
HSPI_MU2015_E1.financial_classescertification_required
HSPI_MU2015_E1.financial_classesfinal_diagnosis_required
HSPI_MU2015_G2.financial_classescertification_required
HSPI_MU2015_G2.financial_classesfinal_diagnosis_required
HSPI_MU2015_G9.financial_classescertification_required
HSPI_MU2015_G9.financial_classesfinal_diagnosis_required
HSPI_Ness.financial_classescertification_required
HSPI_Ness.financial_classesfinal_diagnosis_required
HSPI_Sandbox.financial_classescertification_required
HSPI_Sandbox.financial_classesfinal_diagnosis_required
HSPI_Summit_General.financial_classescertification_required
HSPI_Summit_General.financial_classesfinal_diagnosis_required
HSPI_United_Physicians.financial_classescertification_required
HSPI_United_Physicians.financial_classesfinal_diagnosis_required
MPI.financial_classescertification_required
MPI.financial_classesfinal_diagnosis_required
_1.social_questionssqu_required
_1188.social_questionssqu_required
_1218.social_questionssqu_required
_1548.social_questionssqu_required
_435.social_questionssqu_required
_436.social_questionssqu_required
_436_archive_testing.social_questionssqu_required
_437.social_questionssqu_required
_8.social_questionssqu_required
_81.social_questionssqu_required
_999.social_questionssqu_required
aurora_standard.cgsiflddf_required
aurora_standard.chractpcasub_required
aurora_standard.chrintpcsub_required
aurora_standard.stulockrlock_required
common.data_import_fieldsdif_required
default_value
TableColumn
_1.systems_componentsscmp_default_value
_1188.systems_componentsscmp_default_value
_1218.systems_componentsscmp_default_value
_1548.systems_componentsscmp_default_value
_435.systems_componentsscmp_default_value
_436.systems_componentsscmp_default_value
_436_archive_testing.systems_componentsscmp_default_value
_437.systems_componentsscmp_default_value
_8.systems_componentsscmp_default_value
_81.systems_componentsscmp_default_value
_999.systems_componentsscmp_default_value
common.data_import_optionsdio_default_value
common.test_codes_aoetcaoe_default_value
template_library.systems_componentsscmp_default_value