aurora_standard.hl7obr
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| hl7joinno | smallint(6) | YES | ||||
| seg_obr | varchar(3) | YES | ||||
| set_id | varchar(4) | YES | ||||
| placer_ord_num | varchar(75) | YES | ||||
| filler_ord_num | varchar(75) | YES | ||||
| univ_serv_id | varchar(200) | YES | ||||
| priority | varchar(2) | YES | ||||
| req_date_time | varchar(26) | YES | ||||
| observ_date_time | varchar(26) | YES | ||||
| obs_end_d_t | varchar(26) | YES | ||||
| collection_vol | varchar(20) | YES | ||||
| collector_id | varchar(60) | YES | ||||
| spec_action_cd | varchar(1) | YES | ||||
| danger_cd | varchar(60) | YES | ||||
| relevent_clin_info | varchar(300) | YES | ||||
| spec_rec_d_t | varchar(26) | YES | ||||
| spec_src | varchar(300) | YES | ||||
| ord_prov | varchar(80) | YES | ||||
| order_cb_ph_num | varchar(40) | YES | ||||
| placer_field_1 | varchar(60) | YES | ||||
| placer_field_2 | varchar(60) | YES | ||||
| filler_field_1 | varchar(60) | YES | ||||
| filler_field_2 | varchar(60) | YES | ||||
| res_rpt_chg_d_t | varchar(26) | YES | ||||
| chg_2_prac | varchar(40) | YES | ||||
| diag_serv_sect_id | varchar(10) | YES | ||||
| result_stat | varchar(1) | YES | ||||
| parent_result | varchar(400) | YES | ||||
| quant_timing | varchar(200) | YES | ||||
| res_copies_2 | varchar(150) | YES | ||||
| parent | varchar(150) | YES | ||||
| transport_mode | varchar(20) | YES | ||||
| reas_for_study | varchar(300) | YES | ||||
| princ_res_interp | varchar(200) | YES | ||||
| asst_res_interp | varchar(200) | YES | ||||
| technician | varchar(200) | YES | ||||
| transcrip | varchar(200) | YES | ||||
| sched_date_time | varchar(26) | YES | ||||
| num_samp_cont | varchar(4) | YES | ||||
| trans_log_col_smpl | varchar(60) | YES | ||||
| collector_cmnt | varchar(200) | YES | ||||
| trans_arngment_res | varchar(60) | YES | ||||
| trans_arranged | varchar(30) | YES | ||||
| escort_req | varchar(1) | YES | ||||
| plnd_pat_trans_com | varchar(200) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |