aurora_standard.stypyupd

Field Type Null Default Key Extra Comment
empl_code varchar(6) YES
chg_date date YES
chg_time varchar(8) YES
action varchar(6) YES
log_in varchar(10) YES
pay_date date YES
eop_date date YES
inc_gross decimal(12,2) YES
total_hours decimal(12,2) YES
inc_net decimal(12,2) YES
print_check varchar(1) YES
check_no int(11) YES
ok_to_post varchar(1) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
action
TableColumn
HSPI_System.web_hook_triggersevent_action
_1.auditsaud_action
_1.audits_archiveaud_action
_1.audits_newaud_action
_1.audits_new_archiveaud_action
_1.charts_medicationscm_action
_1.delta_typedt_action
_1.patients_medicationspms_action
_1.patients_prescriptionsprx_action
_1188.auditsaud_action
_1188.audits_archiveaud_action
_1188.audits_newaud_action
_1188.audits_new_archiveaud_action
_1188.charts_medicationscm_action
_1188.delta_typedt_action
_1188.patients_medicationspms_action
_1188.patients_prescriptionsprx_action
_1218.auditsaud_action
_1218.audits_archiveaud_action
_1218.audits_newaud_action
_1218.audits_new_archiveaud_action
_1218.charts_medicationscm_action
_1218.delta_typedt_action
_1218.patients_medicationspms_action
_1218.patients_prescriptionsprx_action
_1548.auditsaud_action
_1548.audits_archiveaud_action
_1548.audits_newaud_action
_1548.audits_new_archiveaud_action
_1548.charts_medicationscm_action
_1548.delta_typedt_action
_1548.patients_medicationspms_action
_1548.patients_prescriptionsprx_action
_435.auditsaud_action
_435.audits_archiveaud_action
_435.audits_archive_2008aud_action
_435.audits_archive_2009aud_action
_435.audits_archive_2010aud_action
_435.audits_archive_2011aud_action
_435.audits_archive_2012aud_action
_435.audits_archive_2013aud_action
_435.audits_archive_2014aud_action
_435.audits_archive_2015aud_action
_435.audits_archive_2016aud_action
_435.audits_archive_2017aud_action
_435.audits_archive_2018aud_action
_435.audits_archive_2019aud_action
_435.audits_archive_2020aud_action
_435.audits_newaud_action
_435.audits_new_archiveaud_action
_435.audits_new_trialaud_action
_435.charts_medicationscm_action
_435.delta_typedt_action
_435.patients_medicationspms_action
_435.patients_prescriptionsprx_action
_436.auditsaud_action
_436.audits_archiveaud_action
_436.audits_newaud_action
_436.audits_new_archiveaud_action
_436.charts_medicationscm_action
_436.delta_typedt_action
_436.patients_medicationspms_action
_436.patients_prescriptionsprx_action
_436_archive_testing.auditsaud_action
_436_archive_testing.audits_archiveaud_action
_436_archive_testing.audits_archive_2008aud_action
_436_archive_testing.audits_archive_2009aud_action
_436_archive_testing.audits_archive_2010aud_action
_436_archive_testing.audits_archive_2011aud_action
_436_archive_testing.audits_archive_2012aud_action
_436_archive_testing.audits_archive_2013aud_action
_436_archive_testing.audits_archive_2014aud_action
_436_archive_testing.audits_archive_2015aud_action
_436_archive_testing.audits_archive_2016aud_action
_436_archive_testing.audits_archive_2017aud_action
_436_archive_testing.audits_archive_2018aud_action
_436_archive_testing.audits_archive_2019aud_action
_436_archive_testing.audits_archive_2020aud_action
_436_archive_testing.audits_archive_2021aud_action
_436_archive_testing.audits_newaud_action
_436_archive_testing.audits_new_archiveaud_action
_436_archive_testing.charts_medicationscm_action
_436_archive_testing.delta_typedt_action
_436_archive_testing.patients_medicationspms_action
_436_archive_testing.patients_prescriptionsprx_action
_437.auditsaud_action
_437.audits_archiveaud_action
_437.audits_newaud_action
_437.audits_new_archiveaud_action
_437.charts_medicationscm_action
_437.delta_typedt_action
_437.patients_medicationspms_action
_437.patients_prescriptionsprx_action
_8.auditsaud_action
_8.audits_archiveaud_action
_8.audits_archive_2020aud_action
_8.audits_newaud_action
_8.audits_new_archiveaud_action
_8.charts_medicationscm_action
_8.delta_typedt_action
_8.patients_medicationspms_action
_8.patients_prescriptionsprx_action
_81.auditsaud_action
_81.audits_archiveaud_action
_81.audits_newaud_action
_81.audits_new_archiveaud_action
_81.charts_medicationscm_action
_81.delta_typedt_action
_81.patients_medicationspms_action
_81.patients_prescriptionsprx_action
_999.auditsaud_action
_999.audits_archiveaud_action
_999.audits_newaud_action
_999.audits_new_archiveaud_action
_999.charts_medicationscm_action
_999.delta_typedt_action
_999.patients_medicationspms_action
_999.patients_prescriptionsprx_action
ahiWiki.logginglog_action
ahiWiki.recentchangesrc_log_action
aurora_standard.anotesdan_action
aurora_standard.chmadmqrlast_action
aurora_standard.chmopseclast_action
common.ahi_auditsaud_action
common.users_historyuhs_action
pay_date
TableColumn
aurora_standard.chmadmqrself_pay_date
aurora_standard.chmagesdlast_pay_date
aurora_standard.chpcobrdfirst_pay_date
aurora_standard.stpinvceto_pay_date
aurora_standard.stpopendto_pay_date
aurora_standard.stpopendlast_pay_date
aurora_standard.stpvendrlast_pay_date
aurora_standard.strcustrlast_pay_date
aurora_standard.stropendlast_pay_date
chg_date
TableColumn
aurora_standard.chmbchgrdef_chg_date
aurora_standard.chmbitmrdef_chg_date
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