aurora_standard.chrcntrc

Field Type Null Default Key Extra Comment
fac_no varchar(3) YES
lag_days decimal(3,0) YES
order_no int(11) YES
iv_expire_hrs decimal(2,0) YES
percent_amt decimal(2,0) YES
mar1_from_tm time YES
mar1_to_tm time YES
mar2_from_tm time YES
mar2_to_tm time YES
mar3_from_tm time YES
mar3_to_tm time YES
matman_interface varchar(1) YES
rx_location varchar(10) YES
rx_inv_acct_no int(11) YES
rx_exp_acct_no int(11) YES
rx_item_class varchar(6) YES
rx_item_type varchar(1) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
lag_days
TableColumn
HSPI_Bastrop.locationsinpatient_lag_days
HSPI_Bastrop.locationsoutpatient_lag_days
HSPI_CURES2015_B1.locationsinpatient_lag_days
HSPI_CURES2015_B1.locationsoutpatient_lag_days
HSPI_Central_Hospital.locationsinpatient_lag_days
HSPI_Central_Hospital.locationsoutpatient_lag_days
HSPI_Dewitt.locationsinpatient_lag_days
HSPI_Dewitt.locationsoutpatient_lag_days
HSPI_Fulton.locationsinpatient_lag_days
HSPI_Fulton.locationsoutpatient_lag_days
HSPI_Inferno.locationsinpatient_lag_days
HSPI_Inferno.locationsoutpatient_lag_days
HSPI_MU2015_E1.locationsinpatient_lag_days
HSPI_MU2015_E1.locationsoutpatient_lag_days
HSPI_MU2015_G2.locationsinpatient_lag_days
HSPI_MU2015_G2.locationsoutpatient_lag_days
HSPI_MU2015_G9.locationsinpatient_lag_days
HSPI_MU2015_G9.locationsoutpatient_lag_days
HSPI_Sandbox.locationsinpatient_lag_days
HSPI_Sandbox.locationsoutpatient_lag_days
HSPI_Summit_General.locationsinpatient_lag_days
HSPI_Summit_General.locationsoutpatient_lag_days
HSPI_United_Physicians.locationsinpatient_lag_days
HSPI_United_Physicians.locationsoutpatient_lag_days
MPI.locationsinpatient_lag_days
MPI.locationsoutpatient_lag_days
aurora_standard.chhcntrcphys_lag_days
aurora_standard.chhcntrcint_lag_days
aurora_standard.chmcntrcphys_lag_days
aurora_standard.chmcntrcint_lag_days
order_no
TableColumn
aurora_standard.chmpintrrx_order_no
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