aurora_standard.surpcchrgd

Field Type Null Default Key Extra Comment
visit_no int(11) NO MUL
card_no int(11) NO
procedure_date date NO
location varchar(20) NO
item_code varchar(20) NO
qty int(11) NO
input_by bigint(20) NO
input_date date NO
processed varchar(1) NO

References

Local Column References
location
TableColumn
_1.cpoe_responsescpoe_res_location
_1.encounters_soap_vitalsespv_location
_1.hl7_accessionsacc_location
_1.patients_immunizationspim_location
_1.precertspre_scheduled_location
_1.precerts_mapprem_location
_1.radiology_resultsrad_res_location
_1188.cpoe_responsescpoe_res_location
_1188.encounters_soap_vitalsespv_location
_1188.hl7_accessionsacc_location
_1188.patients_immunizationspim_location
_1188.precertspre_scheduled_location
_1188.precerts_mapprem_location
_1188.radiology_resultsrad_res_location
_1218.cpoe_responsescpoe_res_location
_1218.encounters_soap_vitalsespv_location
_1218.hl7_accessionsacc_location
_1218.patients_immunizationspim_location
_1218.precertspre_scheduled_location
_1218.precerts_mapprem_location
_1218.radiology_resultsrad_res_location
_1548.cpoe_responsescpoe_res_location
_1548.encounters_soap_vitalsespv_location
_1548.hl7_accessionsacc_location
_1548.patients_immunizationspim_location
_1548.precertspre_scheduled_location
_1548.precerts_mapprem_location
_1548.radiology_resultsrad_res_location
_435.cpoe_responsescpoe_res_location
_435.encounters_soap_vitalsespv_location
_435.hl7_accessionsacc_location
_435.patients_immunizationspim_location
_435.precertspre_scheduled_location
_435.precerts_mapprem_location
_435.radiology_resultsrad_res_location
_436.cpoe_responsescpoe_res_location
_436.encounters_soap_vitalsespv_location
_436.hl7_accessionsacc_location
_436.patients_immunizationspim_location
_436.precertspre_scheduled_location
_436.precerts_mapprem_location
_436.radiology_resultsrad_res_location
_436_archive_testing.cpoe_responsescpoe_res_location
_436_archive_testing.encounters_soap_vitalsespv_location
_436_archive_testing.hl7_accessionsacc_location
_436_archive_testing.patients_immunizationspim_location
_436_archive_testing.precertspre_scheduled_location
_436_archive_testing.precerts_mapprem_location
_436_archive_testing.radiology_resultsrad_res_location
_437.cpoe_responsescpoe_res_location
_437.encounters_soap_vitalsespv_location
_437.hl7_accessionsacc_location
_437.patients_immunizationspim_location
_437.precertspre_scheduled_location
_437.precerts_mapprem_location
_437.radiology_resultsrad_res_location
_8.cpoe_responsescpoe_res_location
_8.encounters_soap_vitalsespv_location
_8.hl7_accessionsacc_location
_8.patients_immunizationspim_location
_8.precertspre_scheduled_location
_8.precerts_mapprem_location
_8.radiology_resultsrad_res_location
_81.cpoe_responsescpoe_res_location
_81.encounters_soap_vitalsespv_location
_81.hl7_accessionsacc_location
_81.patients_immunizationspim_location
_81.precertspre_scheduled_location
_81.precerts_mapprem_location
_81.radiology_resultsrad_res_location
_999.cpoe_responsescpoe_res_location
_999.encounters_soap_vitalsespv_location
_999.hl7_accessionsacc_location
_999.patients_immunizationspim_location
_999.precertspre_scheduled_location
_999.precerts_mapprem_location
_999.radiology_resultsrad_res_location
aurora_standard.bhguaremp_location
aurora_standard.bhtguaremp_location
aurora_standard.chpinsrdclass_location
aurora_standard.chplocacclass_location
aurora_standard.chqcmeudcme_location
aurora_standard.chqletrdletter_location
aurora_standard.chrcntrcrx_location
aurora_standard.mergdocsfile_location
aurora_standard.mergsigsfile_location
aurora_standard.sthcadjdstock_location
aurora_standard.sticadjdstock_location
aurora_standard.stilocarstock_location
aurora_standard.stipyxlcrev_location
aurora_standard.stipyxlcexp_location
aurora_standard.stistkldstock_location
aurora_standard.stock2stock_location
aurora_standard.stoshipdstock_location
aurora_standard.tmplocarstock_location
visit_no
TableColumn
aurora_standard.anotesdan_visit_no
aurora_standard.bdfiledbd_visit_no
aurora_standard.chmarsipat_visit_no
aurora_standard.chmcampipat_visit_no
aurora_standard.chmcombrto_visit_no
aurora_standard.chmexmpipat_visit_no
aurora_standard.chmokipdpat_visit_no
aurora_standard.chmokopdpat_visit_no
aurora_standard.chmradedpat_visit_no
aurora_standard.chmradexpat_visit_no
aurora_standard.chrcombrto_visit_no
aurora_standard.ncexmpipat_visit_no
processed
TableColumn
aurora_standard.api_cbos_invoice_logdt_api_processed
aurora_standard.api_cbos_je_logdt_api_processed
aurora_standard.api_cbos_refund_logdt_api_processed
aurora_standard.api_cbos_vendor_logdt_api_processed
common.data_import_clients_meta_datadicmd_csv_line_last_processed
item_code
TableColumn
aurora_standard.chmbitmdvend_item_code
aurora_standard.chmschgdvend_item_code
aurora_standard.glstrackp_item_code
aurora_standard.glstrackm_item_code
aurora_standard.icactvvvend_item_code
aurora_standard.stiixrefvend_item_code
aurora_standard.stmaintdmaint_po_item_code
aurora_standard.stuctlgdvend_item_code
aurora_standard.sturqstdvend_item_code
aurora_standard.tmpctlgdvend_item_code
aurora_standard.tmplvl2vend_item_code
aurora_standard.tmplvl3vend_item_code
aurora_standard.tmpparlvlvend_item_code
qty
TableColumn
aurora_standard.chmpriccndc_qty
aurora_standard.chrdrugcpack_qty
aurora_standard.gary13sum_qty
aurora_standard.gary2sum_recv_qty
aurora_standard.item1ordr_qty
aurora_standard.sthcadjdadj_qty
aurora_standard.sthcadjdcount_qty
aurora_standard.stiadjmdadj_qty
aurora_standard.sticadjdadj_qty
aurora_standard.sticadjdcount_qty
aurora_standard.stiinvtrcase_qty
aurora_standard.stilocarlast_qty
aurora_standard.stilocarconsign_qty
aurora_standard.stipurcdpurch_qty
aurora_standard.stiselldsell_qty
aurora_standard.stiserlalot_qty
aurora_standard.stiserldlot_qty
aurora_standard.stiserlelot_qty
aurora_standard.stitrandtran_qty
aurora_standard.stoordrdordr_qty
aurora_standard.stoordrdback_qty
aurora_standard.stoordrdcommit_qty
aurora_standard.stopricddisc_qty
aurora_standard.stoshipdship_qty
aurora_standard.stoshipdcommit_qty
aurora_standard.stuctlgdcase_qty
aurora_standard.stuinvcdcost_qty
aurora_standard.stuordrdordr_qty
aurora_standard.stuordrdrlse_qty
aurora_standard.stuordrdrjct_qty
aurora_standard.stuordrdrecv_qty
aurora_standard.stuordrdcost_qty
aurora_standard.stuordrdacpt_qty
aurora_standard.stuordrdexp_rec_qty
aurora_standard.stuordrdexp_inv_qty
aurora_standard.stuprchecost_qty
aurora_standard.stupricddisc_qty
aurora_standard.sturectdrecv_qty
aurora_standard.sturectdrjct_qty
aurora_standard.sturqstdordr_qty
aurora_standard.sturqstdrecv_qty
aurora_standard.sturqstdcase_qty
aurora_standard.sturtrndreturn_qty
aurora_standard.tmpctlgdcase_qty
aurora_standard.tmplocarlast_qty
aurora_standard.tmplocarconsign_qty
aurora_standard.tmplvl2consign_qty
aurora_standard.tmplvl3consign_qty
aurora_standard.tmpparlvlconsign_qty
aurora_standard.ttiinvtrcase_qty
card_no
TableColumn
aurora_standard.stpvendrcredit_card_no
aurora_standard.styrtimdrec_card_no
aurora_standard.styrtimerec_card_no