aurora_standard.hl7in2

Field Type Null Default Key Extra Comment
hl7joinno smallint(6) YES
seg_in2 varchar(3) YES
ins_emplee_id varchar(59) YES
ins_ssn varchar(11) YES
ins_empl_name varchar(130) YES
empl_info_data varchar(1) YES
mail_claim_party varchar(1) YES
mdcare_ins_crd_num varchar(15) YES
mdcaid_case_name varchar(48) YES
mdcaid_case_num varchar(15) YES
champus_spons_name varchar(48) YES
champus_id_num varchar(20) YES
dep_champus_recip varchar(80) YES
champus_org varchar(25) YES
champus_station varchar(25) YES
champus_serv varchar(14) YES
champus_rank_grade varchar(2) YES
champus_stat varchar(3) YES
champus_retire_dt varchar(8) YES
chmps_nonav_cert varchar(1) YES
baby_coverage varchar(1) YES
combine_baby_bill varchar(1) YES
blood_deduct varchar(1) YES
spec_cov_appr_name varchar(48) YES
spec_cov_appr_titl varchar(30) YES
non_cover_ins_cd varchar(8) YES
payor_id varchar(59) YES
payor_subscrib_id varchar(59) YES
eligibility_src varchar(1) YES
rm_cvrg_typ_amt varchar(25) YES
policy_type_amt varchar(25) YES
daily_deductible varchar(25) YES
living_depend varchar(2) YES
ambulatory_stat varchar(2) YES
citizenship varchar(4) YES
prim_lang varchar(60) YES
living_arrngmnt varchar(2) YES
publicity_ind varchar(80) YES
protect_ind varchar(1) YES
student_ind varchar(2) YES
religion varchar(3) YES
mom_maiden_name varchar(48) YES
nationality varchar(80) YES
ethnic_group varchar(3) YES
marital_stat varchar(1) YES
ins_empl_start_dt varchar(8) YES
ins_empl_stop_dt varchar(8) YES
job_title varchar(20) YES
job_code_class varchar(20) YES
job_status varchar(2) YES
empl_cont_pers_nam varchar(48) YES
empl_cont_pers_num varchar(40) YES
empl_cont_reason varchar(2) YES
ins_cont_pers_name varchar(48) YES
ins_cont_pers_num varchar(40) YES
ins_cont_pers_reas varchar(2) YES
rel_2_pat_start_dt varchar(8) YES
rel_2_pat_stop_dt varchar(8) YES
ins_co_cont_reas varchar(2) YES
ins_co_cont_phnum varchar(40) YES
policy_scope varchar(2) YES
policy_source varchar(2) YES
pat_mem_numb varchar(60) YES
guar_rel_2_insured varchar(2) YES
ins_hm_ph_num varchar(40) YES
ins_empl_ph_num varchar(40) YES
milit_handic_prog varchar(60) YES
suspend_flag varchar(2) YES
copay_limit_flag varchar(2) YES
stoploss_lim_flag varchar(2) YES
ins_org_name_id varchar(130) YES
ins_empl_org_nm_id varchar(130) YES
race varchar(1) YES
hcfa_pat_rel2ins varchar(60) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
race
TableColumn
_1.chartschrt_race
_1.encountersenc_race
_1.orders_afpsoafp_race
_1.patientspat_race
_1.precertspre_race
_1188.chartschrt_race
_1188.encountersenc_race
_1188.orders_afpsoafp_race
_1188.patientspat_race
_1188.precertspre_race
_1218.chartschrt_race
_1218.encountersenc_race
_1218.orders_afpsoafp_race
_1218.patientspat_race
_1218.precertspre_race
_1548.chartschrt_race
_1548.encountersenc_race
_1548.orders_afpsoafp_race
_1548.patientspat_race
_1548.precertspre_race
_435.chartschrt_race
_435.encountersenc_race
_435.orders_afpsoafp_race
_435.patientspat_race
_435.precertspre_race
_436.chartschrt_race
_436.encountersenc_race
_436.orders_afpsoafp_race
_436.patientspat_race
_436.precertspre_race
_436_archive_testing.chartschrt_race
_436_archive_testing.encountersenc_race
_436_archive_testing.orders_afpsoafp_race
_436_archive_testing.patientspat_race
_436_archive_testing.precertspre_race
_437.chartschrt_race
_437.encountersenc_race
_437.orders_afpsoafp_race
_437.patientspat_race
_437.precertspre_race
_8.chartschrt_race
_8.encountersenc_race
_8.orders_afpsoafp_race
_8.patientspat_race
_8.precertspre_race
_81.chartschrt_race
_81.encountersenc_race
_81.orders_afpsoafp_race
_81.patientspat_race
_81.precertspre_race
_999.chartschrt_race
_999.encountersenc_race
_999.orders_afpsoafp_race
_999.patientspat_race
_999.precertspre_race
aurora_standard.bharp_race
aurora_standard.bharg_race
aurora_standard.bhguarg_race
aurora_standard.bhtguarg_race
aurora_standard.bparp_race
aurora_standard.bparg_race
aurora_standard.bpar2p_race
aurora_standard.bpar2g_race
aurora_standard.bpmpip_race
aurora_standard.bpmpi2p_race
aurora_standard.chmazstdpat_race
aurora_standard.chmazstipat_race
aurora_standard.chmazstopat_race
aurora_standard.chmhistpp_race
aurora_standard.chmlastrpat_race
aurora_standard.chmmhastpat_race
aurora_standard.chmokipdpat_race
aurora_standard.chmokopdpat_race
aurora_standard.chmtxstrpat_race
aurora_standard.hl7gt1guar_race
aurora_standard.tmpmrrptsex_race
protect_ind
TableColumn
aurora_standard.hl7pv2visit_protect_ind