aurora_standard.hl7ft1

Field Type Null Default Key Extra Comment
hl7joinno smallint(6) YES
seg_ft1 varchar(3) YES
set_id varchar(4) YES
trans_id varchar(12) YES
trans_batch_id varchar(10) YES
trans_date varchar(26) YES
trans_post_date varchar(26) YES
trans_type varchar(8) YES
trans_code varchar(80) YES
trans_descrip varchar(40) YES
trans_descrip_alt varchar(40) YES
trans_quantity varchar(6) YES
trans_amt_ext varchar(12) YES
trans_amt_unit varchar(12) YES
dept_code varchar(60) YES
ins_plan_id varchar(8) YES
ins_amt varchar(12) YES
ass_pat_loc varchar(80) YES
fee_sched varchar(1) YES
pat_type varchar(2) YES
diag_cd varchar(60) YES
perform_by_cd varchar(120) YES
order_by_cd varchar(120) YES
unit_cost varchar(12) YES
filler_ord_num varchar(30) YES
enter_by_code varchar(120) YES
proced_cd varchar(80) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
set_id
TableColumn
HSPI_CURES2015_B1.invoice_batchesrule_set_id
HSPI_Central_Hospital.invoice_batchesrule_set_id
HSPI_Dewitt.invoice_batchesrule_set_id
HSPI_Fulton.invoice_batchesrule_set_id
HSPI_Inferno.invoice_batchesrule_set_id
HSPI_MU2015_E1.invoice_batchesrule_set_id
HSPI_MU2015_G2.invoice_batchesrule_set_id
HSPI_MU2015_G9.invoice_batchesrule_set_id
HSPI_Sandbox.invoice_batchesrule_set_id
HSPI_Summit_General.invoice_batchesrule_set_id
HSPI_United_Physicians.invoice_batchesrule_set_id
MPI.invoice_batchesrule_set_id
aurora_standard.vault_icd9sorder_set_id
ins_plan_id
TableColumn
aurora_standard.chhl7in1prior_ins_plan_id
aurora_standard.hl7in1prior_ins_plan_id
aurora_standard.hl7in1adprior_ins_plan_id
ins_amt
TableColumn
aurora_standard.chmgltcroth_ins_amt
aurora_standard.chmmbc41co_ins_amt
aurora_standard.chmmbc55co_ins_amt
unit_cost
TableColumn
aurora_standard.gary13calc_avg_unit_cost
aurora_standard.gary14calc_avg_unit_cost
aurora_standard.gary2avg_unit_cost
aurora_standard.pharm1pricc_unit_cost
aurora_standard.stilocaravg_unit_cost
aurora_standard.stilocarpurch_unit_cost
aurora_standard.stipurcdpurch_unit_cost
aurora_standard.tmplocaravg_unit_cost
aurora_standard.tmplocarpurch_unit_cost