aurora_standard.hl7pv2
| Field | Type | Null | Default | Key | Extra | Comment |
| hl7joinno | smallint(6) | YES | | | | |
| seg_pv2 | varchar(3) | YES | | | | |
| prior_pend_loc | varchar(80) | YES | | | | |
| accom_code | varchar(60) | YES | | | | |
| admit_reason | varchar(60) | YES | | | | |
| trans_reason | varchar(60) | YES | | | | |
| pat_valuables | varchar(25) | YES | | | | |
| pat_valu_loc | varchar(25) | YES | | | | |
| visit_user_cd | varchar(2) | YES | | | | |
| expect_admit_date | varchar(8) | YES | | | | |
| exp_dischg_date | varchar(8) | YES | | | | |
| est_leng_ip_stay | varchar(3) | YES | | | | |
| act_leng_ip_stay | varchar(3) | YES | | | | |
| visit_desc | varchar(50) | YES | | | | |
| referral_src_cd | varchar(90) | YES | | | | |
| prev_serv_date | varchar(8) | YES | | | | |
| empl_ill_rel_ind | varchar(1) | YES | | | | |
| purge_stat_cd | varchar(1) | YES | | | | |
| purge_stat_dt | varchar(8) | YES | | | | |
| spec_prog_cd | varchar(2) | YES | | | | |
| retention_ind | varchar(1) | YES | | | | |
| exp_num_ins_plans | varchar(1) | YES | | | | |
| vis_plubl_cd | varchar(1) | YES | | | | |
| visit_protect_ind | varchar(1) | YES | | | | |
| clinic_org_name | varchar(90) | YES | | | | |
| pat_stat_cd | varchar(2) | YES | | | | |
| visit_prior_cd | varchar(1) | YES | | | | |
| prev_trtmnt_date | varchar(8) | YES | | | | |
| exp_dischg_dispo | varchar(2) | YES | | | | |
| sig_on_file_date | varchar(8) | YES | | | | |
| first_sim_ill_dt | varchar(8) | YES | | | | |
| pat_chg_adj_cd | varchar(3) | YES | | | | |
| recur_serv_cd | varchar(2) | YES | | | | |
| billing_media_cd | varchar(1) | YES | | | | |
| exp_surg_d_t | varchar(26) | YES | | | | |
| milit_partn_cd | varchar(2) | YES | | | | |
| milit_nonava_cd | varchar(2) | YES | | | | |
| newborn_bab_ind | varchar(1) | YES | | | | |
| baby_detained_ind | varchar(1) | YES | | | | |
| chs_rowID | bigint(20) unsigned | NO | | PRI | auto_increment | |
References