aurora_standard.stxpcrtr

Field Type Null Default Key Extra Comment
from_currency_code varchar(3) YES MUL
to_currency_code varchar(3) YES
rate_type varchar(6) YES
period varchar(3) YES
period_year varchar(4) YES
rate decimal(16,0) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
rate
TableColumn
_1.encounters_soap_vitalsespv_resp_rate
_1.encounters_soap_vitalsespv_oxy_inhaled_flow_rate
_1.patients_vitalspvs_resp_rate
_1188.encounters_soap_vitalsespv_resp_rate
_1188.encounters_soap_vitalsespv_oxy_inhaled_flow_rate
_1188.patients_vitalspvs_resp_rate
_1218.encounters_soap_vitalsespv_resp_rate
_1218.encounters_soap_vitalsespv_oxy_inhaled_flow_rate
_1218.patients_vitalspvs_resp_rate
_1548.encounters_soap_vitalsespv_resp_rate
_1548.encounters_soap_vitalsespv_oxy_inhaled_flow_rate
_1548.patients_vitalspvs_resp_rate
_435.encounters_soap_vitalsespv_resp_rate
_435.encounters_soap_vitalsespv_oxy_inhaled_flow_rate
_435.patients_vitalspvs_resp_rate
_436.encounters_soap_vitalsespv_resp_rate
_436.encounters_soap_vitalsespv_oxy_inhaled_flow_rate
_436.patients_vitalspvs_resp_rate
_436_archive_testing.encounters_soap_vitalsespv_resp_rate
_436_archive_testing.patients_vitalspvs_resp_rate
_437.encounters_soap_vitalsespv_resp_rate
_437.encounters_soap_vitalsespv_oxy_inhaled_flow_rate
_437.patients_vitalspvs_resp_rate
_8.encounters_soap_vitalsespv_resp_rate
_8.encounters_soap_vitalsespv_oxy_inhaled_flow_rate
_8.patients_vitalspvs_resp_rate
_81.encounters_soap_vitalsespv_resp_rate
_81.encounters_soap_vitalsespv_oxy_inhaled_flow_rate
_81.patients_vitalspvs_resp_rate
_999.encounters_soap_vitalsespv_resp_rate
_999.encounters_soap_vitalsespv_oxy_inhaled_flow_rate
_999.patients_vitalspvs_resp_rate
aurora_standard.cadrgp_rate
aurora_standard.chhcntrcint_rate
aurora_standard.chmaccocprevious_rate
aurora_standard.chmapcccpmt_rate
aurora_standard.chmcntrcint_rate
aurora_standard.chmcontrinterest_rate
aurora_standard.chmfcglcinterest_rate
aurora_standard.chminsrddrg_wts_rate
aurora_standard.chmnetwdroom_rate
aurora_standard.chmroomcdaily_rate
aurora_standard.chmvrsncprospective_rate
aurora_standard.chrordrrflow_rate
aurora_standard.oddpayddded_rate
aurora_standard.oddpayidinc_rate
aurora_standard.oddpayodobl_rate
aurora_standard.odhpayddded_rate
aurora_standard.odhpayidinc_rate
aurora_standard.odhpayodobl_rate
aurora_standard.ohoemplrpay_rate
aurora_standard.price2prev_rate
aurora_standard.stfdtabddepr_rate
aurora_standard.stfdtabrdepr_rate
aurora_standard.stilocarusage_rate
aurora_standard.stistatdusage_rate
aurora_standard.stoinvcest_tx_rate
aurora_standard.stoinvceco_tx_rate
aurora_standard.stoinvceci_tx_rate
aurora_standard.stoinvcetax_rate
aurora_standard.stoinvcetrd_ds_rate
aurora_standard.stoinvcecurrency_rate
aurora_standard.stoordretrd_ds_rate
aurora_standard.stoordretax_rate
aurora_standard.stoordrecurrency_rate
aurora_standard.stoshipdtax_rate
aurora_standard.stpactvdcurr_ex_rate
aurora_standard.stpinvcecurr_ex_rate
aurora_standard.stpopendcurr_ex_rate
aurora_standard.stractvdcurr_ex_rate
aurora_standard.strinvcecurr_ex_rate
aurora_standard.stropendcurr_ex_rate
aurora_standard.stuinvcecurrency_rate
aurora_standard.stuordrecurrency_rate
aurora_standard.stxcurrrcurr_ex_rate
aurora_standard.stxcurrrper_ex_rate
aurora_standard.stxmtaxrmtax_rate
aurora_standard.stxtaxldmtax_rate
aurora_standard.styaccrraccr_rate
aurora_standard.styacmxraccrual_rate
aurora_standard.styactpvaccr_rate
aurora_standard.stydedcrdflt_rate
aurora_standard.stydeddvdeduction_rate
aurora_standard.styempddded_rate
aurora_standard.styempidinc_rate
aurora_standard.styempodobl_rate
aurora_standard.styemrcdold_rate
aurora_standard.styemrcdnew_rate
aurora_standard.styinccrdflt_rate
aurora_standard.styincdvpay_rate
aurora_standard.styjobcrclass1_rate
aurora_standard.styjobcrclass2_rate
aurora_standard.styjobcrclass3_rate
aurora_standard.styjobcrclass4_rate
aurora_standard.styjobcrclass5_rate
aurora_standard.styjobcrclass6_rate
aurora_standard.styjobcrclass7_rate
aurora_standard.styjobcrclass8_rate
aurora_standard.styjobcrclass9_rate
aurora_standard.styjobcrclass10_rate
aurora_standard.styoblcrdflt_rate
aurora_standard.styobldvobligation_rate
aurora_standard.stypacadbase_pay_rate
aurora_standard.stypayarded_rate
aurora_standard.stypayddded_rate
aurora_standard.stypayidinc_rate
aurora_standard.stypayodobl_rate
aurora_standard.stypaypdaccr_rate
aurora_standard.styptoadaccr_rate
aurora_standard.styptoadinc_rate
aurora_standard.styptodvaccrual_rate
aurora_standard.styrtimdinc_rate
aurora_standard.stystwhrfed_tax_rate
aurora_standard.stytaxtdtax_rate
aurora_standard.stytimedinc_rate
aurora_standard.stytimodreg_rate
aurora_standard.stytimodot_rate
aurora_standard.stytimodother_rate
aurora_standard.stytypddded_rate
aurora_standard.stytypidinc_rate
aurora_standard.stytypodobl_rate
aurora_standard.tmplocarusage_rate
aurora_standard.vault_accommodation_codesprevious_rate
aurora_standard.vault_room_bedsdaily_rate
rcmroi.dev__rcm_roi_resultsazalea_rcm_rate
rcmroi.prod__rcm_roi_resultsazalea_rcm_rate
rcmroi.test__rcm_roi_resultsazalea_rcm_rate
period
TableColumn
aurora_standard.logdetldacct_period
aurora_standard.stgactvvacct_period
aurora_standard.stgcntrccurr_period
aurora_standard.stgcolpdcod_beg_period
aurora_standard.stgcolpdcod_end_period
aurora_standard.stgtranracct_period
aurora_standard.stgtranvacct_period
aurora_standard.stgwhsedacct_period
aurora_standard.stydeddvacct_period
aurora_standard.styemplrpay_period
aurora_standard.styincdvacct_period
aurora_standard.styobldvacct_period
aurora_standard.stypaydtend_of_period
aurora_standard.stytaxtdpay_period
aurora_standard.stytyperpay_period
aurora_standard.styuimmerpt_period
common.users_permissionsupr_invoice_close_period
rate_type
TableColumn
aurora_standard.stoinvcecurr_rate_type
aurora_standard.stoordrecurr_rate_type
aurora_standard.stuinvcecurr_rate_type
aurora_standard.stuordrecurr_rate_type