aurora_standard.c7abs

Field Type Null Default Key Extra Comment
vis_no int(11) YES MUL
mr_no varchar(20) YES MUL
abs_status varchar(6) YES
compl_dt varchar(10) YES
last_nm varchar(20) YES
first_nm varchar(20) YES
mid_nm varchar(20) YES
age varchar(10) YES
marital varchar(10) YES
zip_1 varchar(10) YES
county_cd varchar(20) YES
mdc varchar(3) YES
drg varchar(3) YES
drg_reimb decimal(16,2) YES

References

Local Column References
age
TableColumn
_1.chartschrt_age
_1.clinical_alertsca_pat_age
_1.cpoe_responsescpoe_res_age
_1.encountersenc_age
_1.hl7_accessionsacc_age
_1.ordersord_age
_1.precertspre_age
_1.radiology_ordersrad_age
_1.radiology_resultsrad_res_age
_1188.chartschrt_age
_1188.clinical_alertsca_pat_age
_1188.cpoe_responsescpoe_res_age
_1188.encountersenc_age
_1188.hl7_accessionsacc_age
_1188.ordersord_age
_1188.precertspre_age
_1188.radiology_ordersrad_age
_1188.radiology_resultsrad_res_age
_1218.chartschrt_age
_1218.clinical_alertsca_pat_age
_1218.cpoe_responsescpoe_res_age
_1218.encountersenc_age
_1218.hl7_accessionsacc_age
_1218.ordersord_age
_1218.precertspre_age
_1218.radiology_ordersrad_age
_1218.radiology_resultsrad_res_age
_1548.chartschrt_age
_1548.clinical_alertsca_pat_age
_1548.cpoe_responsescpoe_res_age
_1548.encountersenc_age
_1548.hl7_accessionsacc_age
_1548.ordersord_age
_1548.precertspre_age
_1548.radiology_ordersrad_age
_1548.radiology_resultsrad_res_age
_435.chartschrt_age
_435.clinical_alertsca_pat_age
_435.cpoe_responsescpoe_res_age
_435.encountersenc_age
_435.hl7_accessionsacc_age
_435.ordersord_age
_435.precertspre_age
_435.radiology_ordersrad_age
_435.radiology_resultsrad_res_age
_436.chartschrt_age
_436.clinical_alertsca_pat_age
_436.cpoe_responsescpoe_res_age
_436.encountersenc_age
_436.hl7_accessionsacc_age
_436.ordersord_age
_436.precertspre_age
_436.radiology_ordersrad_age
_436.radiology_resultsrad_res_age
_436_archive_testing.chartschrt_age
_436_archive_testing.clinical_alertsca_pat_age
_436_archive_testing.cpoe_responsescpoe_res_age
_436_archive_testing.encountersenc_age
_436_archive_testing.hl7_accessionsacc_age
_436_archive_testing.ordersord_age
_436_archive_testing.precertspre_age
_436_archive_testing.radiology_ordersrad_age
_436_archive_testing.radiology_resultsrad_res_age
_437.chartschrt_age
_437.clinical_alertsca_pat_age
_437.cpoe_responsescpoe_res_age
_437.encountersenc_age
_437.hl7_accessionsacc_age
_437.ordersord_age
_437.precertspre_age
_437.radiology_ordersrad_age
_437.radiology_resultsrad_res_age
_8.chartschrt_age
_8.clinical_alertsca_pat_age
_8.cpoe_responsescpoe_res_age
_8.encountersenc_age
_8.hl7_accessionsacc_age
_8.ordersord_age
_8.precertspre_age
_8.radiology_ordersrad_age
_8.radiology_resultsrad_res_age
_81.chartschrt_age
_81.clinical_alertsca_pat_age
_81.cpoe_responsescpoe_res_age
_81.encountersenc_age
_81.hl7_accessionsacc_age
_81.ordersord_age
_81.precertspre_age
_81.radiology_ordersrad_age
_81.radiology_resultsrad_res_age
_999.chartschrt_age
_999.clinical_alertsca_pat_age
_999.cpoe_responsescpoe_res_age
_999.encountersenc_age
_999.hl7_accessionsacc_age
_999.ordersord_age
_999.precertspre_age
_999.radiology_ordersrad_age
_999.radiology_resultsrad_res_age
aurora_standard.chmaptpcmin_age
aurora_standard.chmarbexpat_age
aurora_standard.chmbatexpat_age
aurora_standard.chmhcaphpat_age
aurora_standard.chmhcapspat_age
aurora_standard.chmhstmrpat_age
aurora_standard.chmhstrmpat_age
aurora_standard.chmmhastoutlier_age
aurora_standard.chrdintrstart_age
aurora_standard.chrdintrstop_age
aurora_standard.schprocedurcmin_age
compl_dt
TableColumn
aurora_standard.abmvismr_compl_dt
mdc
TableColumn
aurora_standard.abshl7di9_mdc
aurora_standard.chmabstrest_mdc
aurora_standard.chmabstractual_mdc
drg
TableColumn
aurora_standard.abshl7di9_drg
aurora_standard.chmabstrest_drg
aurora_standard.chmabstractual_drg
aurora_standard.chmclaimfin_drg
aurora_standard.chmclaimms_drg
aurora_standard.chmcostams_drg
aurora_standard.chmhidiaest_drg
aurora_standard.chmpresgms_drg
aurora_standard.chmpresg2ms_drg
aurora_standard.chmvtotdest_drg
aurora_standard.drg_workw_drg
aurora_standard.logdetldest_drg
aurora_standard.ohocptcpt_drg
aurora_standard.workdescw_drg
zip_1
TableColumn
aurora_standard.bdmpisp_zip_1
aurora_standard.bdmpink_zip_1
aurora_standard.bdmpipat_zip_1
aurora_standard.bsinsurspouse_zip_1
aurora_standard.bsinsurnextkin_zip_1
aurora_standard.bsinsurpatient_zip_1
aurora_standard.campispouse_zip_1
aurora_standard.campinextkin_zip_1
aurora_standard.campipatient_zip_1
aurora_standard.chhl7adtpatient_zip_1
aurora_standard.chhl7in1ins_zip_1
aurora_standard.chhl7in1ins_empl_zip_1
aurora_standard.chmp340bpatient_zip_1
aurora_standard.chmpatirsubscri_zip_1
aurora_standard.chmpatmrspouse_zip_1
aurora_standard.chmpatmrnextkin_zip_1
aurora_standard.chmpatmrpatient_zip_1
aurora_standard.chmpresspatient_zip_1
aurora_standard.nbspousespouse_zip_1
vis_no
TableColumn
aurora_standard.bmvismoms_vis_no
mr_no
TableColumn
aurora_standard.bsinsursnf_mr_no
aurora_standard.bsinsurprev_mr_no
aurora_standard.chhcntrcauto_snf_mr_no
aurora_standard.chhcntrcauto_mr_no
aurora_standard.chmarbexpat_mr_no
aurora_standard.chmarsipat_mr_no
aurora_standard.chmbatexpat_mr_no
aurora_standard.chmcampipat_mr_no
aurora_standard.chmcntrcauto_snf_mr_no
aurora_standard.chmcntrcauto_mr_no
aurora_standard.chmexmpipat_mr_no
aurora_standard.chmhstmrpat_mr_no
aurora_standard.chmhstrmpat_mr_no
aurora_standard.chmlastrmother_mr_no
aurora_standard.chmmhastco_mr_no
aurora_standard.chmmrhdrupd_mr_no
aurora_standard.chmnrcexpat_mr_no
aurora_standard.chmokipdpat_mr_no
aurora_standard.chmokopdpat_mr_no
aurora_standard.chmpatmrsnf_mr_no
aurora_standard.chmpatmrprev_mr_no
aurora_standard.chmradedpat_mr_no
aurora_standard.chmradexpat_mr_no
aurora_standard.chmreqsrofc_mr_no
aurora_standard.ncexmpipat_mr_no
marital
TableColumn
aurora_standard.chmarsipat_marital
aurora_standard.chmazstdpat_marital
aurora_standard.chmazstipat_marital
aurora_standard.chmazstopat_marital
aurora_standard.chmcampipat_marital
aurora_standard.chmexmpipat_marital
aurora_standard.chmlastrpat_marital
aurora_standard.chmmrhdrupd_marital
aurora_standard.chmokipdpat_marital
aurora_standard.chmokopdpat_marital
aurora_standard.chmpdemop_marital
aurora_standard.chmradexpat_marital
aurora_standard.chmtxstrpat_marital
aurora_standard.ohoemaddstate_marital
aurora_standard.ohoemaddfed_marital
aurora_standard.styemplrstate_marital
aurora_standard.stytaxtdstate_marital
first_nm
TableColumn
aurora_standard.chmmhastpat_first_nm
aurora_standard.chmpatirinsured_first_nm
aurora_standard.chmpyr1vinsured_first_nm
last_nm
TableColumn
aurora_standard.chmmhastpat_last_nm