aurora_standard.styptoad

Field Type Null Default Key Extra Comment
orig_journal varchar(2) YES
doc_no int(11) YES
accr_code varchar(6) YES
accr_rate decimal(18,8) YES
accr_hrs decimal(12,5) YES
empl_code varchar(6) YES
eop_date date YES
log_in varchar(20) YES
accr_ytd_adj decimal(12,5) YES
accr_allow_adj decimal(12,5) YES
comment varchar(30) YES
accr_allowed decimal(12,5) YES
accr_used decimal(12,2) YES
accr_ytd decimal(12,5) YES
new_lapse_date date YES
date_hired date YES
active_flag varchar(1) YES
inc_rate decimal(18,8) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
comment
TableColumn
_1.orders_commentsorc_comment
_1.orders_comments_templatesorct_comment
_1.precerts_commentsprc_comment
_1.radiology_order_notesradnot_comment
_1188.orders_commentsorc_comment
_1188.orders_comments_templatesorct_comment
_1188.precerts_commentsprc_comment
_1188.radiology_order_notesradnot_comment
_1218.orders_commentsorc_comment
_1218.orders_comments_templatesorct_comment
_1218.precerts_commentsprc_comment
_1218.radiology_order_notesradnot_comment
_1548.orders_commentsorc_comment
_1548.orders_comments_templatesorct_comment
_1548.precerts_commentsprc_comment
_1548.radiology_order_notesradnot_comment
_435.orders_commentsorc_comment
_435.orders_comments_templatesorct_comment
_435.precerts_commentsprc_comment
_435.radiology_order_notesradnot_comment
_436.orders_commentsorc_comment
_436.orders_comments_templatesorct_comment
_436.precerts_commentsprc_comment
_436.radiology_order_notesradnot_comment
_436_archive_testing.orders_commentsorc_comment
_436_archive_testing.orders_comments_templatesorct_comment
_436_archive_testing.precerts_commentsprc_comment
_436_archive_testing.radiology_order_notesradnot_comment
_437.orders_commentsorc_comment
_437.orders_comments_templatesorct_comment
_437.precerts_commentsprc_comment
_437.radiology_order_notesradnot_comment
_8.orders_commentsorc_comment
_8.orders_comments_templatesorct_comment
_8.precerts_commentsprc_comment
_8.radiology_order_notesradnot_comment
_81.orders_commentsorc_comment
_81.orders_comments_templatesorct_comment
_81.precerts_commentsprc_comment
_81.radiology_order_notesradnot_comment
_999.orders_commentsorc_comment
_999.orders_comments_templatesorct_comment
_999.precerts_commentsprc_comment
_999.radiology_order_notesradnot_comment
ahiWiki.archivear_comment
ahiWiki.logginglog_comment
ahiWiki.recentchangesrc_comment
ahiWiki.revisionrev_comment
aurora_standard.audppayddenial_comment
aurora_standard.chmabstrstatus_comment
aurora_standard.chmblogddenial_comment
aurora_standard.chmbremddenial_comment
aurora_standard.chmmcqudemp_comment
aurora_standard.chmmcqudsp_emp_comment
aurora_standard.chmozpcdacct_comment
aurora_standard.chmppayddenial_comment
aurora_standard.chpevaldreviewer_comment
aurora_standard.hl7ntesrc_comment
aurora_standard.hl7nteadsrc_comment
common.service_tickets_commentsstcp_comment
template_library.orders_comments_templatesorct_comment
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
accr_code
TableColumn
aurora_standard.styemplrsick_accr_code
aurora_standard.styemplrvac_accr_code
aurora_standard.stytypersick_accr_code
aurora_standard.stytypervac_accr_code