aurora_standard.chmagerd

Field Type Null Default Key Extra Comment
fac_no varchar(3) YES
date_type varchar(1) YES MUL
report_no smallint(6) YES MUL
age_date date YES
calc_now char(1) YES
last_calc date YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
date_type
TableColumn
HSPI_Bastrop.claim_item_generation_rulesbuild_date_type
HSPI_CURES2015_B1.claim_item_generation_rulesbuild_date_type
HSPI_Central_Hospital.claim_item_generation_rulesbuild_date_type
HSPI_Dewitt.claim_item_generation_rulesbuild_date_type
HSPI_Fulton.claim_item_generation_rulesbuild_date_type
HSPI_Inferno.claim_item_generation_rulesbuild_date_type
HSPI_MU2015_E1.claim_item_generation_rulesbuild_date_type
HSPI_MU2015_G2.claim_item_generation_rulesbuild_date_type
HSPI_MU2015_G9.claim_item_generation_rulesbuild_date_type
HSPI_Sandbox.claim_item_generation_rulesbuild_date_type
HSPI_Summit_General.claim_item_generation_rulesbuild_date_type
HSPI_United_Physicians.claim_item_generation_rulesbuild_date_type
MPI.claim_item_generation_rulesbuild_date_type
age_date
TableColumn
aurora_standard.atklrrevrpt_age_date
aurora_standard.chmtkl1rrpt_age_date
aurora_standard.chmtkl2rrpt_age_date
aurora_standard.chmtkl3rrpt_age_date
aurora_standard.chmtkl4rrpt_age_date
aurora_standard.chmtkl5rrpt_age_date
aurora_standard.chmtkl6rrpt_age_date
aurora_standard.chmtkl7rrpt_age_date
aurora_standard.chmtkl8rrpt_age_date
aurora_standard.chmtkl9rrpt_age_date
fac_no
TableColumn
aurora_standard.chmpricaprev_fac_no
aurora_standard.chmpricacur_fac_no
aurora_standard.chpcashrcash_fac_no
aurora_standard.chpcobpdcash_fac_no
aurora_standard.chpcobpdbal_fac_no
aurora_standard.chscustddept_fac_no
aurora_standard.chshotlrdept_fac_no
aurora_standard.chtemplrdflt_fac_no
aurora_standard.curs_tempcash_fac_no
aurora_standard.curs_tempap_fac_no
aurora_standard.stgrowpdrod_beg_fac_no
aurora_standard.stgrowpdrod_end_fac_no
aurora_standard.stpcashddist_fac_no
aurora_standard.stpcashddisc_fac_no
aurora_standard.stpcashecash_fac_no
aurora_standard.stpcntrccash_fac_no
aurora_standard.stpcntrcdisc_fac_no
aurora_standard.stpinvcecash_fac_no
aurora_standard.stpopendap_fac_no
aurora_standard.stpopendcash_fac_no
aurora_standard.stucntrccash_fac_no
aurora_standard.stuinvcecash_fac_no
aurora_standard.stxfinsdfin_fac_no
aurora_standard.styaccrrliab_fac_no
aurora_standard.styaccrrexpense_fac_no
aurora_standard.styemplrcash_fac_no
aurora_standard.stypayfdcash_fac_no
aurora_standard.stypayodbal_fac_no
aurora_standard.stypayrecash_fac_no
aurora_standard.styrevsdcash_fac_no
aurora_standard.stytypercash_fac_no