aurora_standard.stybankd

Field Type Null Default Key Extra Comment
doc_no int(11) YES
empl_code varchar(6) YES
ded_code varchar(6) YES
eop_date date YES
hours decimal(12,2) YES
reason varchar(10) YES
posted varchar(1) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
hours
TableColumn
Azalea.employeesemp_pto_hours
_1.reports_queuerq_after_hours
_1188.reports_queuerq_after_hours
_1218.reports_queuerq_after_hours
_1548.reports_queuerq_after_hours
_435.reports_queuerq_after_hours
_436.reports_queuerq_after_hours
_436_archive_testing.reports_queuerq_after_hours
_437.reports_queuerq_after_hours
_8.reports_queuerq_after_hours
_81.reports_queuerq_after_hours
_999.reports_queuerq_after_hours
aurora_standard.chmhidicobserv_hours
aurora_standard.chpempidinservice_hours
aurora_standard.chshotlrtot_hours
aurora_standard.chtclokdinc_hours
aurora_standard.chtemplrreview_hours
aurora_standard.chtemplradd_vac_hours
aurora_standard.chtemplrdistribute_hours
aurora_standard.chtemplrmax_hours
aurora_standard.chtptordnum_hours
aurora_standard.chtsupvcmodify_own_hours
aurora_standard.chtwkhrdcarry_hours
aurora_standard.cmhrescrmax_hours
aurora_standard.hhtclokdinc_hours
aurora_standard.oddpayretotal_hours
aurora_standard.odhpayretotal_hours
aurora_standard.styactpvaccr_hours
aurora_standard.styempidinc_hours
aurora_standard.styemplravg_hours
aurora_standard.styemplrtotal_hours
aurora_standard.styinccdlow_earned_hours
aurora_standard.styinccdhigh_earned_hours
aurora_standard.styinccrdflt_hours
aurora_standard.styoblcdlow_earned_hours
aurora_standard.styoblcdhigh_earned_hours
aurora_standard.stypayretotal_hours
aurora_standard.styptodvusable_hours
aurora_standard.stypyupdtotal_hours
aurora_standard.styrevsdtotal_hours
aurora_standard.styrtimdinc_hours
aurora_standard.stytimedinc_hours
aurora_standard.stytypidinc_hours
aurora_standard.timetablinc_hours
aurora_standard.timetabl_ininc_hours
common.applicantsapp_employer_1_hours
common.applicantsapp_employer_2_hours
common.applicantsapp_employer_3_hours
common.applicantsapp_employer_4_hours
common.customerscus_office_hours
common.leadslea_office_hours
common.reports_queue_ordersrqo_after_hours
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
doc_no
TableColumn
aurora_standard.audpadjdpy_doc_no
aurora_standard.chmgltrcar_doc_no
aurora_standard.chmgltrcrm_doc_no
aurora_standard.chmgltrcip_doc_no
aurora_standard.chmgltrcop_doc_no
aurora_standard.chmgltrcr3_doc_no
aurora_standard.chmgltrcr4_doc_no
aurora_standard.chmgltrccr_doc_no
aurora_standard.chmgltrcaj_doc_no
aurora_standard.chmgltrcnr_doc_no
aurora_standard.chmgltrcnc_doc_no
aurora_standard.chmgltrcfc_doc_no
aurora_standard.chmpadjdpy_doc_no
aurora_standard.chmrefndcheck_doc_no
aurora_standard.discountsinv_doc_no
aurora_standard.odhpayddpy_doc_no
aurora_standard.odhpayidpy_doc_no
aurora_standard.odhpayodpy_doc_no
aurora_standard.odhpayrepy_doc_no
aurora_standard.stfcntrcfa_doc_no
aurora_standard.stgcntrcgenjrn_doc_no
aurora_standard.stgcntrcstdent_doc_no
aurora_standard.sticstvrrec_doc_no
aurora_standard.stoinvceinv_doc_no
aurora_standard.stoordreorig_doc_no
aurora_standard.stoordreinv_doc_no
aurora_standard.stoshipdinv_doc_no
aurora_standard.stoshipdpo_doc_no
aurora_standard.stpactvdinv_doc_no
aurora_standard.stpactvvinv_doc_no
aurora_standard.stpcashdinv_doc_no
aurora_standard.stpcntrcap_doc_no
aurora_standard.stpcntrccd_doc_no
aurora_standard.stpvoidrchk_doc_no
aurora_standard.stractvdinv_doc_no
aurora_standard.stractvvinv_doc_no
aurora_standard.strcashdinv_doc_no
aurora_standard.strcntrcar_doc_no
aurora_standard.strcntrccr_doc_no
aurora_standard.stucntrcreq_doc_no
aurora_standard.stucntrcpo_doc_no
aurora_standard.stucntrcrec_doc_no
aurora_standard.stucntrcinv_doc_no
aurora_standard.stucntrcret_doc_no
aurora_standard.stuinvcdinv_doc_no
aurora_standard.stuinvcdpo_doc_no
aurora_standard.stuinvceinv_doc_no
aurora_standard.stuinvcepo_doc_no
aurora_standard.stuordrdorder_doc_no
aurora_standard.stuordreorig_doc_no
aurora_standard.stuordreorder_doc_no
aurora_standard.stuprcheinv_doc_no
aurora_standard.sturectdrec_doc_no
aurora_standard.sturectdpo_doc_no
aurora_standard.sturecterec_doc_no
aurora_standard.sturectepo_doc_no
aurora_standard.sturqstdpo_doc_no
aurora_standard.sturqstdref_doc_no
aurora_standard.sturtrndret_doc_no
aurora_standard.sturtrndpo_doc_no
aurora_standard.sturtrndrec_doc_no
aurora_standard.sturtrndinv_doc_no
aurora_standard.sturtrneret_doc_no
aurora_standard.stxmtaxdinv_doc_no
aurora_standard.stxtaxldinv_doc_no
aurora_standard.stycdeddpy_doc_no
aurora_standard.stycincdpy_doc_no
aurora_standard.stycntrcpy_doc_no
aurora_standard.stypayarpy_doc_no
aurora_standard.stypddrdpy_doc_no
aurora_standard.styvoidepay_doc_no
eop_date
TableColumn
aurora_standard.chtesigdta_eop_date
aurora_standard.chtwkhrdcarry_eop_date
empl_code
TableColumn
aurora_standard.chtsupvcsupv_empl_code
aurora_standard.stypddrdadj_empl_code
ded_code
TableColumn
aurora_standard.stycdeddpy_ded_code
aurora_standard.styintfcsource_ded_code