aurora_standard.hl7dg1

Field Type Null Default Key Extra Comment
hl7joinno smallint(6) YES
seg_dg1 varchar(3) YES
set_id varchar(4) YES
diag_cd_meth varchar(2) YES
diag_cd varchar(60) YES
diag_desc varchar(40) YES
diag_d_t varchar(26) YES
diag_type varchar(2) YES
maj_diag_cat varchar(60) YES
diag_rel_grp varchar(4) YES
drg_appr_ind varchar(2) YES
drg_grp_rev_cd varchar(2) YES
outlier_type varchar(60) YES
outlier_days varchar(3) YES
outlier_cost varchar(12) YES
grp_vers_type varchar(4) YES
diag_prior varchar(2) YES
diag_clinician varchar(60) YES
diag_class varchar(3) YES
conf_ind varchar(1) YES
attest_date_time 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