aurora_standard.c8pvis

Field Type Null Default Key Extra Comment
mpino char(20) YES MUL
vis_no char(20) YES MUL
filler char(10) YES
admdttm char(20) YES
disdt char(10) YES
dis_disp char(10) YES
phy char(20) YES
fac char(10) YES
location char(20) YES
status_cd char(10) YES
mrno varchar(20) NO MUL

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
fac
TableColumn
aurora_standard.TABLE 1424new_fac
aurora_standard.TABLE 1425new_fac
aurora_standard.chmcntrcbatch_by_fac
aurora_standard.chmpaytcpmt_fac
aurora_standard.chmpaytcadj_fac
aurora_standard.chmpaytcar_fac
aurora_standard.chpcntrccobra_cash_fac
aurora_standard.chpcntrccobra_bal_fac
aurora_standard.chpcntrccobra_fee_fac
aurora_standard.chscustddept_fac
aurora_standard.glxrefnew_fac
aurora_standard.glxrefold_fac
aurora_standard.hl7mshsend_fac
aurora_standard.hl7mshrec_fac
aurora_standard.hl7mshadsend_fac
aurora_standard.hl7mshadrec_fac
aurora_standard.hl7pd1pat_prim_fac
aurora_standard.hl7pd1adpat_prim_fac
aurora_standard.hl7pv1servicing_fac
aurora_standard.hl7pv1adservicing_fac
phy
TableColumn
aurora_standard.abmmpifam_phy
aurora_standard.abmvisadm_phy
aurora_standard.abmvisatt_phy
aurora_standard.adjpayatt_phy
aurora_standard.adjpayfam_phy
aurora_standard.ainsrvwatt_phy
aurora_standard.ainsrvwfam_phy
aurora_standard.amcbdatt_phy
aurora_standard.anarcatt_phy
aurora_standard.anmpifam_phy
aurora_standard.apsaratt_phy
aurora_standard.apsar0att_phy
aurora_standard.apsarbdatt_phy
aurora_standard.apsarhistatt_phy
aurora_standard.apsmpifam_phy
aurora_standard.apsvisatt_phy
aurora_standard.avtotsattend_phy
aurora_standard.bdallvisadm_phy
aurora_standard.bdallvisatt_phy
aurora_standard.bdallvisfam_phy
aurora_standard.bdmpifam_phy
aurora_standard.bdvisadm_phy
aurora_standard.bdvisatt_phy
aurora_standard.bdvisfam_phy
aurora_standard.bharadm_phy
aurora_standard.bharatt_phy
aurora_standard.bmpactadm_phy
aurora_standard.bparadm_phy
aurora_standard.bparatt_phy
aurora_standard.bpar2adm_phy
aurora_standard.bpar2att_phy
aurora_standard.bpmpiatt_phy
aurora_standard.bpmpi2att_phy
aurora_standard.bpmradm_phy
aurora_standard.bpmratt_phy
aurora_standard.bpmrref_phy
aurora_standard.bpmrcon1_phy
aurora_standard.bpmrcon2_phy
aurora_standard.bpmrcon3_phy
aurora_standard.bpmrcon4_phy
aurora_standard.bpmrcon5_phy
aurora_standard.bpmr2adm_phy
aurora_standard.bpmr2att_phy
aurora_standard.bpmr2ref_phy
aurora_standard.bpmr2con1_phy
aurora_standard.bpmr2con2_phy
aurora_standard.bpmr2con3_phy
aurora_standard.bpmr2con4_phy
aurora_standard.bpmr2con5_phy
aurora_standard.bs2mpifam_phy
aurora_standard.bsmpifam_phy
aurora_standard.bsvisadm_phy
aurora_standard.bsvisfam_phy
aurora_standard.bsvisbdadm_phy
aurora_standard.bsvisbdfam_phy
aurora_standard.c7visadm_phy
aurora_standard.c7visatt_phy
aurora_standard.c7visfam_phy
aurora_standard.c9visfam_phy
aurora_standard.catotsattend_phy
aurora_standard.cavisadm_phy
aurora_standard.cavisatt_phy
aurora_standard.cavisfam_phy
aurora_standard.cavishadm_phy
aurora_standard.cavishatt_phy
aurora_standard.cavishfam_phy
aurora_standard.chhl7adtattend_phy
aurora_standard.chhl7adtother_cc_phy
aurora_standard.chhl7adtadmit_phy
aurora_standard.chmadmtradmit_phy
aurora_standard.chmadmtrattend_phy
aurora_standard.chmadmtrfam_phy
aurora_standard.chmadmtrother_cc_phy
aurora_standard.chmarsiattend_phy
aurora_standard.chmarsiadmit_phy
aurora_standard.chmarstphoth_phy
aurora_standard.chmarstpooth_phy
aurora_standard.chmazstdprin_proc_phy
aurora_standard.chmazstiprin_proc_phy
aurora_standard.chmazstoprin_proc_phy
aurora_standard.chmcampiattend_phy
aurora_standard.chmcampiadmit_phy
aurora_standard.chmclaimatt_phy
aurora_standard.chmclaimop_phy
aurora_standard.chmcox06attend_phy
aurora_standard.chmertmrfam_phy
aurora_standard.chmescptprimary_phy
aurora_standard.chmexmpiattend_phy
aurora_standard.chmexmpiadmit_phy
aurora_standard.chmexvisattend_phy
aurora_standard.chmexvisadmit_phy
aurora_standard.chmhdpcdproc_phy
aurora_standard.chmhidiaother_phy
aurora_standard.chmhistdattend_phy
aurora_standard.chmhistpatt_phy
aurora_standard.chmhstmradmit_phy
aurora_standard.chmhstmrattend_phy
aurora_standard.chmhstrmadmit_phy
aurora_standard.chmhstrmattend_phy
aurora_standard.chmmashradm_phy
aurora_standard.chmmashratt_phy
aurora_standard.chmmhastatt_phy
aurora_standard.chmmhastco_att_phy
aurora_standard.chmmhastref_phy
aurora_standard.chmmhastother_phy
aurora_standard.chmmhastconsult_phy
aurora_standard.chmmhbcrattn_phy
aurora_standard.chmmhbcrpsp_phy
aurora_standard.chmmichrattn_phy
aurora_standard.chmmichrpsp_phy
aurora_standard.chmokipdatt_phy
aurora_standard.chmokipdprin_proc_phy
aurora_standard.chmokipdproc01_phy
aurora_standard.chmokipdproc02_phy
aurora_standard.chmokipdproc03_phy
aurora_standard.chmokipdproc04_phy
aurora_standard.chmokipdproc05_phy
aurora_standard.chmokopdatt_phy
aurora_standard.chmokopdprin_proc_phy
aurora_standard.chmokopdproc01_phy
aurora_standard.chmokopdproc02_phy
aurora_standard.chmokopdproc03_phy
aurora_standard.chmokopdproc04_phy
aurora_standard.chmokopdproc05_phy
aurora_standard.chmpdemoattend_phy
aurora_standard.chmpdemoadmit_phy
aurora_standard.chmpresgattnd_phy
aurora_standard.chmpresg2attnd_phy
aurora_standard.chmpressadmit_phy
aurora_standard.chmpsvcdrend_phy
aurora_standard.chmpsvcdref_phy
aurora_standard.chmradexattend_phy
aurora_standard.chmradexadmit_phy
aurora_standard.chmvtotdattend_phy
aurora_standard.chmvtotdfam_phy
aurora_standard.chxexamdorder_phy
aurora_standard.chxleasdorder_phy
aurora_standard.chyrespdorder_phy
aurora_standard.hhmadmtradmit_phy
aurora_standard.hhmadmtrattend_phy
aurora_standard.kcvisadm_phy
aurora_standard.kcvisatt_phy
aurora_standard.kcvisitadm_phy
aurora_standard.kcvisitatt_phy
aurora_standard.schactsurdattending_phy
aurora_standard.tmpmrrptattend_phy
mrno
TableColumn
aurora_standard.abmmpigu_mrno
aurora_standard.abmvisgu_mrno
aurora_standard.amrnowkgood_mrno
aurora_standard.amrnowkold_mrno
aurora_standard.apsmpi2ca_mrno
aurora_standard.aseympica_mrno
aurora_standard.b2baddnew_mrno
aurora_standard.b2mrdrnew_mrno
aurora_standard.bhbaddnew_mrno
aurora_standard.bhldgrnew_mrno
aurora_standard.bhmrdrnew_mrno
aurora_standard.bhtldgrnew_mrno
aurora_standard.bvmpinew_mrno
aurora_standard.bvmpi2new_mrno
aurora_standard.chmcntrcassign_mrno
aurora_standard.chxcntrcid_is_mrno
vis_no
TableColumn
aurora_standard.bmvismoms_vis_no
filler
TableColumn
aurora_standard.chlmdssds_filler
aurora_standard.chlswbddcnt_filler
aurora_standard.chltrnsdcnt_filler
aurora_standard.chltrnsds_filler
aurora_standard.chmhaapypy_filler
aurora_standard.drg_workw_filler
aurora_standard.workdescw_filler