aurora_standard.chmradex
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| pat_visit_no | char(10) | NO | PRI | |||
| pat_mr_no | char(20) | YES | ||||
| pat_status | char(3) | YES | ||||
| ps_descrip | char(30) | 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 | ||||
| pat_first | char(20) | YES | ||||
| pat_mid | char(20) | YES | ||||
| pat_last | char(20) | 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 | ||||
| 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 | ||||
| gu_first | char(20) | YES | ||||
| gu_mid | char(20) | YES | ||||
| gu_last | char(20) | 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 | ||||
| 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 | ||||
| accident_type | char(2) | YES | ||||
| accident_date | char(10) | YES | ||||
| ins1_co_no | 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_f1 | char(20) | YES | ||||
| insured_m1 | char(20) | YES | ||||
| insured_l1 | char(20) | 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_co_no | 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_f2 | char(20) | YES | ||||
| insured_m2 | char(20) | YES | ||||
| insured_l2 | char(20) | 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_co_no | 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_f3 | char(20) | YES | ||||
| insured_m3 | char(20) | YES | ||||
| insured_l3 | char(20) | 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 | ||||
| admit_dx | char(10) | YES | ||||
| dx1 | char(10) | YES | ||||
| dx2 | char(10) | YES | ||||
| dx3 | char(10) | YES | ||||
| dx4 | char(10) | YES | ||||
| dx5 | char(10) | YES | ||||
| medicare_flag | char(2) | YES | ||||
| arrival_ps | char(2) | YES |