aurora_standard.chmexmpi
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| fac_no | char(3) | YES | ||||
| pat_visit_no | char(10) | YES | ||||
| pat_mr_no | char(20) | YES | ||||
| pat_status | char(3) | YES | ||||
| pat_service | char(30) | YES | ||||
| drg | char(3) | YES | ||||
| pri_fc | char(2) | YES | ||||
| adm_dt | char(10) | YES | ||||
| adm_tm | char(8) | YES | ||||
| adm_typ | char(1) | YES | ||||
| adm_src | char(1) | YES | ||||
| dis_dt | char(10) | YES | ||||
| dis_tm | char(8) | YES | ||||
| dis_status | char(2) | YES | ||||
| bill_date | char(10) | YES | ||||
| tot_charges | char(16) | YES | ||||
| tot_adjs | char(16) | YES | ||||
| tot_pmts | char(16) | YES | ||||
| cur_bal | char(16) | YES | ||||
| pat_name | char(35) | YES | ||||
| pat_add1 | char(30) | YES | ||||
| pat_add2 | char(20) | YES | ||||
| pat_city | char(20) | YES | ||||
| pat_st | char(2) | YES | ||||
| pat_zip | char(10) | YES | ||||
| pat_county | char(20) | YES | ||||
| pat_phone | char(20) | YES | ||||
| pat_ssn | char(11) | YES | ||||
| pat_sex | char(1) | YES | ||||
| pat_dob | char(10) | YES | ||||
| pat_marital | char(1) | YES | ||||
| gu_name | char(35) | YES | ||||
| gu_addr1 | char(30) | YES | ||||
| gu_addr2 | char(20) | YES | ||||
| gu_city | char(20) | YES | ||||
| gu_st | char(2) | YES | ||||
| gu_zip | char(10) | YES | ||||
| gu_phone | char(20) | YES | ||||
| gu_dob | char(10) | YES | ||||
| gu_ssn | char(11) | YES | ||||
| gu_emp_nm | char(30) | YES | ||||
| gu_emp_addr1 | char(20) | YES | ||||
| gu_emp_addr2 | char(20) | YES | ||||
| gu_emp_city | char(20) | YES | ||||
| gu_emp_st | char(2) | YES | ||||
| gu_emp_zip | char(5) | YES | ||||
| gu_emp_ph | char(20) | YES | ||||
| pat_emp_nm | char(30) | YES | ||||
| pat_emp_addr1 | char(20) | YES | ||||
| pat_emp_addr2 | char(20) | YES | ||||
| pat_emp_city | char(20) | YES | ||||
| pat_emp_st | char(2) | YES | ||||
| pat_emp_zip | char(5) | YES | ||||
| pat_emp_phone | char(20) | YES | ||||
| sp_name | char(35) | YES | ||||
| sp_ssn | char(11) | YES | ||||
| sp_phone | char(20) | YES | ||||
| sp_emp_nm | char(30) | YES | ||||
| sp_dob | char(10) | YES | ||||
| fam_phy_no | char(6) | YES | ||||
| fam_phy_nm | char(30) | YES | ||||
| fam_phy_npi | char(10) | YES | ||||
| attend_phy | char(6) | YES | ||||
| attend_phy_nm | char(30) | YES | ||||
| attend_phy_npi | char(10) | YES | ||||
| admit_phy | char(6) | YES | ||||
| admit_phy_nm | char(30) | YES | ||||
| admit_phy_npi | char(10) | YES | ||||
| admit_dx_t | char(40) | YES | ||||
| req_accom | char(6) | YES | ||||
| accident_type | char(2) | YES | ||||
| accident_date | char(10) | YES | ||||
| ins1_plan | char(6) | YES | ||||
| ins1_name | char(30) | YES | ||||
| ins1_addr1 | char(30) | YES | ||||
| ins1_addr2 | char(20) | YES | ||||
| ins1_city | char(20) | YES | ||||
| ins1_st | char(2) | YES | ||||
| ins1_zip | char(10) | YES | ||||
| ins1_ph_no | char(20) | YES | ||||
| insured_name1 | char(37) | YES | ||||
| insured_add1 | char(20) | YES | ||||
| insured_city1 | char(20) | YES | ||||
| insured_state1 | char(2) | YES | ||||
| insured_zip1 | char(5) | YES | ||||
| insured_dob1 | char(10) | YES | ||||
| ins1_sex | char(1) | YES | ||||
| insured_rel1 | char(2) | YES | ||||
| ins1_group_nm | char(20) | YES | ||||
| ins1_group_no | char(20) | YES | ||||
| ins1_certif_no | char(20) | YES | ||||
| pre_cert1 | char(20) | YES | ||||
| ins1_empl_nm | char(30) | YES | ||||
| ins1_empl_addr | char(20) | YES | ||||
| ins1_empl_city | char(20) | YES | ||||
| ins1_empl_st | char(2) | YES | ||||
| ins1_empl_zip | char(5) | YES | ||||
| ins1_empl_stat | char(2) | YES | ||||
| ins2_plan | char(6) | YES | ||||
| ins2_name | char(30) | YES | ||||
| ins2_addr1 | char(30) | YES | ||||
| ins2_addr2 | char(20) | YES | ||||
| ins2_city | char(20) | YES | ||||
| ins2_st | char(2) | YES | ||||
| ins2_zip | char(10) | YES | ||||
| ins2_ph_no | char(20) | YES | ||||
| insured_name2 | char(37) | YES | ||||
| insured_add2 | char(20) | YES | ||||
| insured_city2 | char(20) | YES | ||||
| insured_state2 | char(2) | YES | ||||
| insured_zip2 | char(5) | YES | ||||
| insured_dob2 | char(10) | YES | ||||
| ins2_sex | char(1) | YES | ||||
| insured_rel2 | char(2) | YES | ||||
| ins2_group_nm | char(20) | YES | ||||
| ins2_group_no | char(20) | YES | ||||
| ins2_certif_no | char(20) | YES | ||||
| pre_cert2 | char(20) | YES | ||||
| ins2_empl_nm | char(30) | YES | ||||
| ins2_empl_addr | char(20) | YES | ||||
| ins2_empl_city | char(20) | YES | ||||
| ins2_empl_st | char(2) | YES | ||||
| ins2_empl_zip | char(5) | YES | ||||
| ins2_empl_stat | char(2) | YES | ||||
| ins3_plan | char(6) | YES | ||||
| ins3_name | char(30) | YES | ||||
| ins3_addr1 | char(30) | YES | ||||
| ins3_addr2 | char(20) | YES | ||||
| ins3_city | char(20) | YES | ||||
| ins3_st | char(2) | YES | ||||
| ins3_zip | char(10) | YES | ||||
| ins3_ph_no | char(20) | YES | ||||
| insured_name3 | char(37) | YES | ||||
| insured_add3 | char(20) | YES | ||||
| insured_city3 | char(20) | YES | ||||
| insured_state3 | char(2) | YES | ||||
| insured_zip3 | char(5) | YES | ||||
| insured_dob3 | char(10) | YES | ||||
| ins3_sex | char(1) | YES | ||||
| insured_rel3 | char(2) | YES | ||||
| ins3_group_nm | char(20) | YES | ||||
| ins3_group_no | char(20) | YES | ||||
| ins3_certif_no | char(20) | YES | ||||
| pre_cert3 | char(20) | YES | ||||
| ins3_empl_nm | char(30) | YES | ||||
| ins3_empl_addr | char(20) | YES | ||||
| ins3_empl_city | char(20) | YES | ||||
| ins3_empl_st | char(2) | YES | ||||
| ins3_empl_zip | char(5) | YES | ||||
| ins3_empl_stat | char(2) | YES | ||||
| spec_hand | char(2) | YES | ||||
| cur_fin_class | char(2) | YES | ||||
| archive_flag | char(1) | YES |