aurora_standard.chmexvis
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| fac_no | char(3) | YES | ||||
| vis_no | char(10) | YES | ||||
| 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(2) | YES | ||||
| adm_src | char(2) | YES | ||||
| dis_dt | char(10) | YES | ||||
| dis_tm | char(8) | YES | ||||
| dis_status | char(2) | YES | ||||
| bill_date | char(10) | YES | ||||
| tot_charges | char(20) | YES | ||||
| tot_adjs | char(20) | YES | ||||
| tot_pmts | char(20) | YES | ||||
| cur_bal | char(20) | YES | ||||
| bd_bal | char(20) | YES | ||||
| pat_name | char(35) | YES | ||||
| pat_ssn | char(11) | YES | ||||
| gu_no | char(10) | YES | ||||
| attend_phy | char(6) | YES | ||||
| attend_phy_nm | char(35) | YES | ||||
| attend_phy_npi | char(10) | YES | ||||
| admit_phy | char(6) | YES | ||||
| admit_phy_nm | char(35) | YES | ||||
| admit_phy_npi | char(10) | YES | ||||
| admit_dx | char(10) | YES | ||||
| admit_dx_t | char(40) | YES | ||||
| accident_type | char(10) | 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 | ||||
| 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 | ||||
| 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 | ||||
| archive_flag | char(1) | YES | ||||
| spec_hand | char(2) | YES | ||||
| fin_class | char(2) | YES | ||||
| date_forwarded | char(10) | YES | ||||
| coll_agency | char(10) | YES | ||||
| last_stmt_date | char(10) | YES |