aurora_standard.chmagerv

Field Type Null Default Key Extra Comment
date_type varchar(1) YES
report_no smallint(6) YES
report_format smallint(6) YES
report_desc varchar(30) YES
age_per_1 smallint(6) YES
age_per_2 smallint(6) YES
age_per_3 smallint(6) YES
age_per_4 smallint(6) YES
age_per_5 smallint(6) YES
age_per_6 smallint(6) YES
age_per_7 smallint(6) YES
age_per_8 smallint(6) YES
age_per_9 smallint(6) YES
age_per_10 smallint(6) YES
age_per_11 smallint(6) YES
age_per_12 smallint(6) YES
age_desc_1 varchar(15) YES
age_desc_2 varchar(15) YES
age_desc_3 varchar(15) YES
age_desc_4 varchar(15) YES
age_desc_5 varchar(15) YES
age_desc_6 varchar(15) YES
age_desc_7 varchar(15) YES
age_desc_8 varchar(15) YES
age_desc_9 varchar(15) YES
age_desc_10 varchar(15) YES
age_desc_11 varchar(15) YES
age_desc_12 varchar(15) YES
age_desc_13 varchar(15) YES
fac_no varchar(3) YES
age_date date YES

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