aurora_standard.hl7in2ad
| Field | Type | Null | Default | Key | Extra | Comment |
| 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_tit1 | 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 | | | | |
| chs_rowID | bigint(20) unsigned | NO | | PRI | auto_increment | |
References