aurora_standard.cgsmncmd

Field Type Null Default Key Extra Comment
opt varchar(1) YES MUL
mname varchar(32) YES
ilevel smallint(6) YES
cmd varchar(256) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
mname
TableColumn
Azalea.employeesemp_mname
_1.billing_providersbp_mname
_1.chartschrt_mname
_1.client_contactsclicon_mname
_1.cpoe_responsescpoe_res_mname
_1.donorsdon_mname
_1.encountersenc_mname
_1.hl7_accessionsacc_mname
_1.non_patientsnpat_mname
_1.ordersord_mname
_1.patient_next_of_kinpnk_mname
_1.patientspat_mname
_1.patientspat_birth_mname
_1.patients_demographics_snapshotspds_mname
_1.patients_namespn_mname
_1.patients_responsibility_estimatesprest_mname
_1.physiciansphy_mname
_1.precertspre_mname
_1.radiology_ordersrad_mname
_1.radiology_resultsrad_res_mname
_1188.billing_providersbp_mname
_1188.chartschrt_mname
_1188.client_contactsclicon_mname
_1188.cpoe_responsescpoe_res_mname
_1188.donorsdon_mname
_1188.encountersenc_mname
_1188.hl7_accessionsacc_mname
_1188.non_patientsnpat_mname
_1188.ordersord_mname
_1188.patient_next_of_kinpnk_mname
_1188.patientspat_mname
_1188.patientspat_birth_mname
_1188.patients_demographics_snapshotspds_mname
_1188.patients_namespn_mname
_1188.patients_responsibility_estimatesprest_mname
_1188.physiciansphy_mname
_1188.precertspre_mname
_1188.radiology_ordersrad_mname
_1188.radiology_resultsrad_res_mname
_1218.billing_providersbp_mname
_1218.chartschrt_mname
_1218.client_contactsclicon_mname
_1218.cpoe_responsescpoe_res_mname
_1218.donorsdon_mname
_1218.encountersenc_mname
_1218.hl7_accessionsacc_mname
_1218.non_patientsnpat_mname
_1218.ordersord_mname
_1218.patient_next_of_kinpnk_mname
_1218.patientspat_mname
_1218.patientspat_birth_mname
_1218.patients_demographics_snapshotspds_mname
_1218.patients_namespn_mname
_1218.patients_responsibility_estimatesprest_mname
_1218.physiciansphy_mname
_1218.precertspre_mname
_1218.radiology_ordersrad_mname
_1218.radiology_resultsrad_res_mname
_1548.billing_providersbp_mname
_1548.chartschrt_mname
_1548.client_contactsclicon_mname
_1548.cpoe_responsescpoe_res_mname
_1548.donorsdon_mname
_1548.encountersenc_mname
_1548.hl7_accessionsacc_mname
_1548.non_patientsnpat_mname
_1548.ordersord_mname
_1548.patient_next_of_kinpnk_mname
_1548.patientspat_mname
_1548.patientspat_birth_mname
_1548.patients_demographics_snapshotspds_mname
_1548.patients_namespn_mname
_1548.patients_responsibility_estimatesprest_mname
_1548.physiciansphy_mname
_1548.precertspre_mname
_1548.radiology_ordersrad_mname
_1548.radiology_resultsrad_res_mname
_435.billing_providersbp_mname
_435.chartschrt_mname
_435.client_contactsclicon_mname
_435.cpoe_responsescpoe_res_mname
_435.donorsdon_mname
_435.encountersenc_mname
_435.hl7_accessionsacc_mname
_435.non_patientsnpat_mname
_435.ordersord_mname
_435.patient_next_of_kinpnk_mname
_435.patientspat_mname
_435.patientspat_birth_mname
_435.patients_demographics_snapshotspds_mname
_435.patients_namespn_mname
_435.patients_responsibility_estimatesprest_mname
_435.physiciansphy_mname
_435.precertspre_mname
_435.radiology_ordersrad_mname
_435.radiology_resultsrad_res_mname
_436.billing_providersbp_mname
_436.chartschrt_mname
_436.client_contactsclicon_mname
_436.cpoe_responsescpoe_res_mname
_436.donorsdon_mname
_436.encountersenc_mname
_436.hl7_accessionsacc_mname
_436.non_patientsnpat_mname
_436.ordersord_mname
_436.patient_next_of_kinpnk_mname
_436.patientspat_mname
_436.patientspat_birth_mname
_436.patients_demographics_snapshotspds_mname
_436.patients_namespn_mname
_436.patients_responsibility_estimatesprest_mname
_436.physiciansphy_mname
_436.precertspre_mname
_436.radiology_ordersrad_mname
_436.radiology_resultsrad_res_mname
_436_archive_testing.billing_providersbp_mname
_436_archive_testing.chartschrt_mname
_436_archive_testing.client_contactsclicon_mname
_436_archive_testing.cpoe_responsescpoe_res_mname
_436_archive_testing.donorsdon_mname
_436_archive_testing.encountersenc_mname
_436_archive_testing.hl7_accessionsacc_mname
_436_archive_testing.non_patientsnpat_mname
_436_archive_testing.ordersord_mname
_436_archive_testing.patient_next_of_kinpnk_mname
_436_archive_testing.patientspat_mname
_436_archive_testing.patientspat_birth_mname
_436_archive_testing.patients_demographics_snapshotspds_mname
_436_archive_testing.patients_responsibility_estimatesprest_mname
_436_archive_testing.physiciansphy_mname
_436_archive_testing.precertspre_mname
_436_archive_testing.radiology_ordersrad_mname
_436_archive_testing.radiology_resultsrad_res_mname
_437.billing_providersbp_mname
_437.chartschrt_mname
_437.client_contactsclicon_mname
_437.cpoe_responsescpoe_res_mname
_437.donorsdon_mname
_437.encountersenc_mname
_437.hl7_accessionsacc_mname
_437.non_patientsnpat_mname
_437.ordersord_mname
_437.patient_next_of_kinpnk_mname
_437.patientspat_mname
_437.patientspat_birth_mname
_437.patients_demographics_snapshotspds_mname
_437.patients_namespn_mname
_437.patients_responsibility_estimatesprest_mname
_437.physiciansphy_mname
_437.precertspre_mname
_437.radiology_ordersrad_mname
_437.radiology_resultsrad_res_mname
_8.billing_providersbp_mname
_8.chartschrt_mname
_8.client_contactsclicon_mname
_8.cpoe_responsescpoe_res_mname
_8.donorsdon_mname
_8.encountersenc_mname
_8.hl7_accessionsacc_mname
_8.non_patientsnpat_mname
_8.ordersord_mname
_8.patient_next_of_kinpnk_mname
_8.patientspat_mname
_8.patientspat_birth_mname
_8.patients_demographics_snapshotspds_mname
_8.patients_namespn_mname
_8.patients_responsibility_estimatesprest_mname
_8.physiciansphy_mname
_8.precertspre_mname
_8.radiology_ordersrad_mname
_8.radiology_resultsrad_res_mname
_81.billing_providersbp_mname
_81.chartschrt_mname
_81.client_contactsclicon_mname
_81.cpoe_responsescpoe_res_mname
_81.donorsdon_mname
_81.encountersenc_mname
_81.hl7_accessionsacc_mname
_81.non_patientsnpat_mname
_81.ordersord_mname
_81.patient_next_of_kinpnk_mname
_81.patientspat_mname
_81.patientspat_birth_mname
_81.patients_demographics_snapshotspds_mname
_81.patients_namespn_mname
_81.patients_responsibility_estimatesprest_mname
_81.physiciansphy_mname
_81.precertspre_mname
_81.radiology_ordersrad_mname
_81.radiology_resultsrad_res_mname
_999.billing_providersbp_mname
_999.chartschrt_mname
_999.client_contactsclicon_mname
_999.cpoe_responsescpoe_res_mname
_999.donorsdon_mname
_999.encountersenc_mname
_999.hl7_accessionsacc_mname
_999.non_patientsnpat_mname
_999.ordersord_mname
_999.patient_next_of_kinpnk_mname
_999.patientspat_mname
_999.patientspat_birth_mname
_999.patients_demographics_snapshotspds_mname
_999.patients_namespn_mname
_999.patients_responsibility_estimatesprest_mname
_999.physiciansphy_mname
_999.precertspre_mname
_999.radiology_ordersrad_mname
_999.radiology_resultsrad_res_mname
aurora_standard.abmmpigu_mname
aurora_standard.abmvisgu_mname
aurora_standard.bharg_mname
aurora_standard.bmnkinn_mname
aurora_standard.bparg_mname
aurora_standard.bpar2g_mname
aurora_standard.c7mpigu_mname
aurora_standard.chmpdemop_mname
aurora_standard.chmpdemosp_mname
aurora_standard.chmpdemofam_phy_mname
aurora_standard.chmpdemoattend_phy_mname
aurora_standard.chmpdemoadmit_phy_mname
aurora_standard.chmpsvcdrend_mname
aurora_standard.chmpsvcdref_mname
aurora_standard.styoctcccontact_mname
aurora_standard.styoctccgov_entity_contact_person_mname
aurora_standard.styoempddepend_mname
aurora_standard.styoemprempl_mname
common.applicantsapp_mname
common.usersusr_mname
opt
TableColumn
_1.orders_afpsoafp_mult_gest_opt
_1.patientspat_health_exchange_opt
_1.patients_demographics_snapshotspds_health_exchange_opt
_1.patients_statements_mappstm_txt_opt
_1.patients_statements_mappstm_estatement_opt
_1188.orders_afpsoafp_mult_gest_opt
_1188.patientspat_health_exchange_opt
_1188.patients_demographics_snapshotspds_health_exchange_opt
_1188.patients_statements_mappstm_txt_opt
_1188.patients_statements_mappstm_estatement_opt
_1218.orders_afpsoafp_mult_gest_opt
_1218.patientspat_health_exchange_opt
_1218.patients_demographics_snapshotspds_health_exchange_opt
_1218.patients_statements_mappstm_txt_opt
_1218.patients_statements_mappstm_estatement_opt
_1548.orders_afpsoafp_mult_gest_opt
_1548.patientspat_health_exchange_opt
_1548.patients_demographics_snapshotspds_health_exchange_opt
_1548.patients_statements_mappstm_txt_opt
_1548.patients_statements_mappstm_estatement_opt
_435.orders_afpsoafp_mult_gest_opt
_435.patientspat_health_exchange_opt
_435.patients_demographics_snapshotspds_health_exchange_opt
_435.patients_statements_mappstm_txt_opt
_435.patients_statements_mappstm_estatement_opt
_436.orders_afpsoafp_mult_gest_opt
_436.patientspat_health_exchange_opt
_436.patients_demographics_snapshotspds_health_exchange_opt
_436.patients_statements_mappstm_txt_opt
_436.patients_statements_mappstm_estatement_opt
_436_archive_testing.orders_afpsoafp_mult_gest_opt
_436_archive_testing.patientspat_health_exchange_opt
_436_archive_testing.patients_demographics_snapshotspds_health_exchange_opt
_436_archive_testing.patients_statements_mappstm_txt_opt
_436_archive_testing.patients_statements_mappstm_estatement_opt
_437.orders_afpsoafp_mult_gest_opt
_437.patientspat_health_exchange_opt
_437.patients_demographics_snapshotspds_health_exchange_opt
_437.patients_statements_mappstm_txt_opt
_437.patients_statements_mappstm_estatement_opt
_8.orders_afpsoafp_mult_gest_opt
_8.patientspat_health_exchange_opt
_8.patients_demographics_snapshotspds_health_exchange_opt
_8.patients_statements_mappstm_txt_opt
_8.patients_statements_mappstm_estatement_opt
_81.orders_afpsoafp_mult_gest_opt
_81.patientspat_health_exchange_opt
_81.patients_demographics_snapshotspds_health_exchange_opt
_81.patients_statements_mappstm_txt_opt
_81.patients_statements_mappstm_estatement_opt
_999.orders_afpsoafp_mult_gest_opt
_999.patientspat_health_exchange_opt
_999.patients_demographics_snapshotspds_health_exchange_opt
_999.patients_statements_mappstm_txt_opt
_999.patients_statements_mappstm_estatement_opt
aurora_standard.chsmodsrmenu_opt
cmd
TableColumn
ahiWiki.jobjob_cmd
aurora_standard.stgrowpdrod_cmd