aurora_standard.chpemtad

Field Type Null Default Key Extra Comment
empl_code varchar(6) YES
emp_tardy_abs varchar(6) YES
reason varchar(30) YES
tarabs_date date YES
emp_warning varchar(2) YES
input_by int(11) YES
source varchar(12) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
reason
TableColumn
Azalea.pto_requestspto_reason
Loinc.loinc_codeslc_status_reason
SSO.login_eventsfailed_reason
_1.appointmentsapt_ins_reject_reason
_1.cpoe_responsescpoe_res_testing_reason
_1.encounters_soapesp_referring_reason
_1.hl7_accessionsacc_testing_reason
_1.hl7_ordersord_specimen_reject_reason
_1.patients_enrollmentspert_opt_out_reason
_1.patients_implantable_devicespid_inactive_reason
_1.patients_medicationspms_stop_reason
_1.patients_referralspref_reason
_1.radiology_resultsrad_res_testing_reason
_1.schedulessch_reason
_1188.appointmentsapt_ins_reject_reason
_1188.cpoe_responsescpoe_res_testing_reason
_1188.encounters_soapesp_referring_reason
_1188.hl7_accessionsacc_testing_reason
_1188.hl7_ordersord_specimen_reject_reason
_1188.patients_enrollmentspert_opt_out_reason
_1188.patients_implantable_devicespid_inactive_reason
_1188.patients_medicationspms_stop_reason
_1188.patients_referralspref_reason
_1188.radiology_resultsrad_res_testing_reason
_1188.schedulessch_reason
_1218.appointmentsapt_ins_reject_reason
_1218.cpoe_responsescpoe_res_testing_reason
_1218.encounters_soapesp_referring_reason
_1218.hl7_accessionsacc_testing_reason
_1218.hl7_ordersord_specimen_reject_reason
_1218.patients_enrollmentspert_opt_out_reason
_1218.patients_implantable_devicespid_inactive_reason
_1218.patients_medicationspms_stop_reason
_1218.patients_referralspref_reason
_1218.radiology_resultsrad_res_testing_reason
_1218.schedulessch_reason
_1548.appointmentsapt_ins_reject_reason
_1548.cpoe_responsescpoe_res_testing_reason
_1548.encounters_soapesp_referring_reason
_1548.hl7_accessionsacc_testing_reason
_1548.hl7_ordersord_specimen_reject_reason
_1548.patients_enrollmentspert_opt_out_reason
_1548.patients_implantable_devicespid_inactive_reason
_1548.patients_medicationspms_stop_reason
_1548.patients_referralspref_reason
_1548.radiology_resultsrad_res_testing_reason
_1548.schedulessch_reason
_435.appointmentsapt_ins_reject_reason
_435.cpoe_responsescpoe_res_testing_reason
_435.encounters_soapesp_referring_reason
_435.hl7_accessionsacc_testing_reason
_435.hl7_ordersord_specimen_reject_reason
_435.patients_enrollmentspert_opt_out_reason
_435.patients_implantable_devicespid_inactive_reason
_435.patients_medicationspms_stop_reason
_435.patients_referralspref_reason
_435.radiology_resultsrad_res_testing_reason
_435.schedulessch_reason
_436.appointmentsapt_ins_reject_reason
_436.cpoe_responsescpoe_res_testing_reason
_436.encounters_soapesp_referring_reason
_436.hl7_accessionsacc_testing_reason
_436.hl7_ordersord_specimen_reject_reason
_436.patients_enrollmentspert_opt_out_reason
_436.patients_implantable_devicespid_inactive_reason
_436.patients_medicationspms_stop_reason
_436.patients_referralspref_reason
_436.radiology_resultsrad_res_testing_reason
_436.schedulessch_reason
_436_archive_testing.appointmentsapt_ins_reject_reason
_436_archive_testing.cpoe_responsescpoe_res_testing_reason
_436_archive_testing.encounters_soapesp_referring_reason
_436_archive_testing.hl7_accessionsacc_testing_reason
_436_archive_testing.hl7_ordersord_specimen_reject_reason
_436_archive_testing.patients_enrollmentspert_opt_out_reason
_436_archive_testing.patients_implantable_devicespid_inactive_reason
_436_archive_testing.patients_medicationspms_stop_reason
_436_archive_testing.patients_referralspref_reason
_436_archive_testing.radiology_resultsrad_res_testing_reason
_436_archive_testing.schedulessch_reason
_437.appointmentsapt_ins_reject_reason
_437.cpoe_responsescpoe_res_testing_reason
_437.encounters_soapesp_referring_reason
_437.hl7_accessionsacc_testing_reason
_437.hl7_ordersord_specimen_reject_reason
_437.patients_enrollmentspert_opt_out_reason
_437.patients_implantable_devicespid_inactive_reason
_437.patients_medicationspms_stop_reason
_437.patients_referralspref_reason
_437.radiology_resultsrad_res_testing_reason
_437.schedulessch_reason
_8.appointmentsapt_ins_reject_reason
_8.cpoe_responsescpoe_res_testing_reason
_8.encounters_soapesp_referring_reason
_8.hl7_accessionsacc_testing_reason
_8.hl7_ordersord_specimen_reject_reason
_8.patients_enrollmentspert_opt_out_reason
_8.patients_implantable_devicespid_inactive_reason
_8.patients_medicationspms_stop_reason
_8.patients_referralspref_reason
_8.radiology_resultsrad_res_testing_reason
_8.schedulessch_reason
_81.appointmentsapt_ins_reject_reason
_81.cpoe_responsescpoe_res_testing_reason
_81.encounters_soapesp_referring_reason
_81.hl7_accessionsacc_testing_reason
_81.hl7_ordersord_specimen_reject_reason
_81.patients_enrollmentspert_opt_out_reason
_81.patients_implantable_devicespid_inactive_reason
_81.patients_medicationspms_stop_reason
_81.patients_referralspref_reason
_81.radiology_resultsrad_res_testing_reason
_81.schedulessch_reason
_999.appointmentsapt_ins_reject_reason
_999.cpoe_responsescpoe_res_testing_reason
_999.encounters_soapesp_referring_reason
_999.hl7_accessionsacc_testing_reason
_999.hl7_ordersord_specimen_reject_reason
_999.patients_enrollmentspert_opt_out_reason
_999.patients_implantable_devicespid_inactive_reason
_999.patients_medicationspms_stop_reason
_999.patients_referralspref_reason
_999.radiology_resultsrad_res_testing_reason
_999.schedulessch_reason
ahiWiki.filearchivefa_deleted_reason
ahiWiki.ipblocksipb_reason
ahiWiki.protected_titlespt_reason
aurora_standard.bdallvisdis_reason
aurora_standard.bdvisdis_reason
aurora_standard.bsvisdis_reason
aurora_standard.bsvisbddis_reason
aurora_standard.c7visdis_reason
aurora_standard.c9visdis_reason
aurora_standard.cavisdis_reason
aurora_standard.cavishdis_reason
aurora_standard.chhl7adtdischg_reason
aurora_standard.chmadmtrdischg_reason
aurora_standard.chmchpsdchg_dischg_reason
aurora_standard.chmcostadischg_reason
aurora_standard.chmcox06dischg_reason
aurora_standard.chmertmrer_reason
aurora_standard.chmhid4adischg_reason
aurora_standard.chmhidiadischg_reason
aurora_standard.chmmbc41med_b_reason
aurora_standard.chmrtrndtran_reason
aurora_standard.chmstatcdef_dis_reason
aurora_standard.chmutahdischg_reason
aurora_standard.chmutah1dischg_reason
aurora_standard.chmutah4dischg_reason
aurora_standard.chpbatadwarning_reason
aurora_standard.chpcoberenddate_reason
aurora_standard.chpcobrdenddate_reason
aurora_standard.chptermrtermination_reason
aurora_standard.hhmadmtrdischg_reason
aurora_standard.hl7gt1cont_reason
aurora_standard.hl7in2empl_cont_reason
aurora_standard.hl7pv2admit_reason
aurora_standard.hl7pv2trans_reason
aurora_standard.kcvisdis_reason
aurora_standard.kcvisitdis_reason
aurora_standard.oeordauditaudit_reason
aurora_standard.oeorderorder_reason
aurora_standard.schovrwtblkcunblock_reason
aurora_standard.stoordrdcm_dm_reason
aurora_standard.stucntrccm_reason
aurora_standard.stucntrcdm_reason
aurora_standard.stuordrdcm_dm_reason
aurora_standard.stxvckrdvoid_reason
aurora_standard.tmpmrrptdischg_reason
common.applicantsapp_arrest_reason
common.applicantsapp_law_reason
common.applicantsapp_convicted_reason
common.applicantsapp_not_adjudicated_reason
common.applicantsapp_not_convicted_reason
common.applicantsapp_civil_reason
common.clients_contract_dataccd_churn_reason
common.clients_enrollments_mapcem_no_optout_reason
common.loinc_codeslc_status_reason
source
TableColumn
Loinc.loinc_codeslc_source
Loinc.loinc_codes_sourcelcsrc_source
_1.encounters_ub04enc_ub04_15_source
_1.hl7_ordersord_specimen_source
_1.immunizationsimz_funding_source
_1.ordersord_source
_1.orders_templatesordt_source
_1.patient_portal_requestsppr_source
_1.patients_education_resultsperes_source
_1.patients_immunizationspim_funding_source
_1.pre_services_line_adjustmentsprestsla_source
_1.radiology_ordersrad_source
_1.referral_sourcesref_source
_1188.encounters_ub04enc_ub04_15_source
_1188.hl7_ordersord_specimen_source
_1188.immunizationsimz_funding_source
_1188.ordersord_source
_1188.orders_templatesordt_source
_1188.patient_portal_requestsppr_source
_1188.patients_education_resultsperes_source
_1188.patients_immunizationspim_funding_source
_1188.pre_services_line_adjustmentsprestsla_source
_1188.radiology_ordersrad_source
_1188.referral_sourcesref_source
_1218.encounters_ub04enc_ub04_15_source
_1218.hl7_ordersord_specimen_source
_1218.immunizationsimz_funding_source
_1218.ordersord_source
_1218.orders_templatesordt_source
_1218.patient_portal_requestsppr_source
_1218.patients_education_resultsperes_source
_1218.patients_immunizationspim_funding_source
_1218.pre_services_line_adjustmentsprestsla_source
_1218.radiology_ordersrad_source
_1218.referral_sourcesref_source
_1548.encounters_ub04enc_ub04_15_source
_1548.hl7_ordersord_specimen_source
_1548.immunizationsimz_funding_source
_1548.ordersord_source
_1548.orders_templatesordt_source
_1548.patient_portal_requestsppr_source
_1548.patients_education_resultsperes_source
_1548.patients_immunizationspim_funding_source
_1548.pre_services_line_adjustmentsprestsla_source
_1548.radiology_ordersrad_source
_1548.referral_sourcesref_source
_435.encounters_ub04enc_ub04_15_source
_435.hl7_ordersord_specimen_source
_435.immunizationsimz_funding_source
_435.ordersord_source
_435.orders_templatesordt_source
_435.patient_portal_requestsppr_source
_435.patients_education_resultsperes_source
_435.patients_immunizationspim_funding_source
_435.pre_services_line_adjustmentsprestsla_source
_435.radiology_ordersrad_source
_435.referral_sourcesref_source
_436.encounters_ub04enc_ub04_15_source
_436.hl7_ordersord_specimen_source
_436.immunizationsimz_funding_source
_436.ordersord_source
_436.orders_templatesordt_source
_436.patient_portal_requestsppr_source
_436.patients_education_resultsperes_source
_436.patients_immunizationspim_funding_source
_436.pre_services_line_adjustmentsprestsla_source
_436.radiology_ordersrad_source
_436.referral_sourcesref_source
_436_archive_testing.encounters_ub04enc_ub04_15_source
_436_archive_testing.hl7_ordersord_specimen_source
_436_archive_testing.immunizationsimz_funding_source
_436_archive_testing.ordersord_source
_436_archive_testing.orders_templatesordt_source
_436_archive_testing.patient_portal_requestsppr_source
_436_archive_testing.patients_education_resultsperes_source
_436_archive_testing.patients_immunizationspim_funding_source
_436_archive_testing.pre_services_line_adjustmentsprestsla_source
_436_archive_testing.radiology_ordersrad_source
_436_archive_testing.referral_sourcesref_source
_437.encounters_ub04enc_ub04_15_source
_437.hl7_ordersord_specimen_source
_437.immunizationsimz_funding_source
_437.ordersord_source
_437.orders_templatesordt_source
_437.patient_portal_requestsppr_source
_437.patients_education_resultsperes_source
_437.patients_immunizationspim_funding_source
_437.pre_services_line_adjustmentsprestsla_source
_437.radiology_ordersrad_source
_437.referral_sourcesref_source
_8.encounters_ub04enc_ub04_15_source
_8.hl7_ordersord_specimen_source
_8.immunizationsimz_funding_source
_8.ordersord_source
_8.orders_templatesordt_source
_8.patient_portal_requestsppr_source
_8.patients_education_resultsperes_source
_8.patients_immunizationspim_funding_source
_8.pre_services_line_adjustmentsprestsla_source
_8.radiology_ordersrad_source
_8.referral_sourcesref_source
_81.encounters_ub04enc_ub04_15_source
_81.hl7_ordersord_specimen_source
_81.immunizationsimz_funding_source
_81.ordersord_source
_81.orders_templatesordt_source
_81.patient_portal_requestsppr_source
_81.patients_education_resultsperes_source
_81.patients_immunizationspim_funding_source
_81.pre_services_line_adjustmentsprestsla_source
_81.radiology_ordersrad_source
_81.referral_sourcesref_source
_999.encounters_ub04enc_ub04_15_source
_999.hl7_ordersord_specimen_source
_999.immunizationsimz_funding_source
_999.ordersord_source
_999.orders_templatesordt_source
_999.patient_portal_requestsppr_source
_999.patients_education_resultsperes_source
_999.patients_immunizationspim_funding_source
_999.pre_services_line_adjustmentsprestsla_source
_999.radiology_ordersrad_source
_999.referral_sourcesref_source
ahiWiki.recentchangesrc_source
ahiWiki.sitessite_source
aurora_standard.chm1500rpayor_source
aurora_standard.chmabstrgrp_source
aurora_standard.chmdrgccgrp_source
aurora_standard.chmedilrpayor_source
aurora_standard.chmfcglcgrp_source
aurora_standard.chmgrprcgrp_source
aurora_standard.chmmdcccgrp_source
aurora_standard.chmmrhdrget_grp_source
aurora_standard.chmpysrcpay_source
aurora_standard.chmpysrcgrp_source
aurora_standard.chmvrsncgrp_source
aurora_standard.chpvacidvac_phy_source
aurora_standard.chpvacscvac_source
aurora_standard.chqletrdletter_source
aurora_standard.chtclokdtrans_source
aurora_standard.hhtclokdtrans_source
aurora_standard.hl7in2policy_source
aurora_standard.timetabltrans_source
aurora_standard.tmpmrrptclaim_source
aurora_standard.workdrggrp_source
common.loinc_codeslc_source
template_library.orders_templatesordt_source
empl_code
TableColumn
aurora_standard.chtsupvcsupv_empl_code
aurora_standard.stypddrdadj_empl_code