aurora_standard.hl7gt1ad

Field Type Null Default Key Extra Comment
seg_gt1 varchar(3) YES
set_id varchar(4) YES
guar_num varchar(59) YES
guar_name varchar(48) YES
guar_sp_name varchar(48) YES
guar_addr varchar(106) YES
guar_hm_ph_num varchar(40) YES
guar_wk_ph_num varchar(40) YES
guar_d_t_of_birth varchar(26) YES
guar_sex varchar(1) YES
guar_type varchar(2) YES
guar_rel varchar(2) YES
guar_ssn varchar(11) YES
guar_date_begin varchar(8) YES
guar_date_end varchar(8) YES
guar_priority varchar(2) YES
guar_empl_name varchar(130) YES
guar_empl_addr varchar(106) YES
guar_emp_ph_num varchar(40) YES
guar_empl_id varchar(20) YES
guar_empl_stat varchar(20) YES
guar_org_name varchar(130) YES
guar_bill_hld_flg varchar(2) YES
guar_credit_rt varchar(20) YES
guar_death_d_t varchar(26) 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