Table Description
Currency Exchange: A conversion rate between two currencies.

Currency exchange rates can be stored in Curam to support the payment and receipt of monetary amounts in a currency other than the base currency of the organization.

Example

The organization makes pension payments to entitled participants who have retired to other countries. The base currency of the organization is Euros.

John Smith has retired to England where the currency is Sterling. John's weekly payment of 100 euro converts to 69 pounds using an exchange rate of Euro/GBP 0.6864.

Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Organisation::Entity Objects::CurrencyExchange::CurrencyExchange
Controlling File: core\model\Packages\Organisation\Currency Exchange_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
VALIDATION_EXIT_POINTyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
currencyExchangeIDkeynoUnique reference number assigned by the systemCURRENCY_EXCHANGE_ID SVR_INT64
organisationIDdetailsnoorganization for which the currency exchange is recordedORGANISATION_ID SVR_INT64
currencyTypeCodedetails Code value to indicate the type of currency. Codetable is 'Currency'CURRENCY_CODECurrencySVR_STRING<10>
ratedetails The governing monetary value at which a set currency figure is exchangedFOREIGN_EXCHANGE_RATE SVR_DOUBLE
rateFromDatedetails Date Currency Exchange Rate is effective from.CURAM_DATE SVR_DATE
rateToDatedetails Date Currency Exchange Rate is effective to.CURAM_DATE SVR_DATE
statusCodedetails Code value to reflect the record's status e.g. Active or canceled.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (8)
ChildParent
CurrencyExchange.organisationIDOrganisation.organisationID
FinancialInstruction.currencyExchangeIDCurrencyExchange.currencyExchangeID
InstructionLineItem.currencyExchangeIDCurrencyExchange.currencyExchangeID
LiabilityInstrument.currencyExchangeIDCurrencyExchange.currencyExchangeID
PaymentInstrument.currencyExchangeIDCurrencyExchange.currencyExchangeID
PaymentReceivedInstrument.currencyExchangeIDCurrencyExchange.currencyExchangeID
SuspenseAccount.currencyExchangeIDCurrencyExchange.currencyExchangeID
WMInstanceData.currencyExchangeIDCurrencyExchange.currencyExchangeID
Indices (2)
Index NameAttributes
CurrExDatesTypeIndcurrencyTypeCode, rateFromDate, rateToDate, statusCode, organisationID
OrgIDFXTypeIndexorganisationID, currencyTypeCode
Operations (11)
OperationStereotypeOptionsDescriptionSQL
insertinsertPRE_DATA_ACCESS: no
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: no
Standard Operation 
readread Standard Operation 
searchByOrganisationnsreadmultiORDER_BY: currencyTypeCode
PRE_DATA_ACCESS: yes
READMULTI_LIM: 0
Read all records from the CurrencyExchange table for a particular Organization. This method has a Pre Data Access function that checks if the input Organization key is valid. If invalid this function throws an exception. 
removeremove Standard Operation 
readRateByDateTypens Gets a currency for one currency type and specific date (i.e. rateFromDate <= input_Date <= rateToDate)SQL
searchCurrencyExchangesInDateRangensmulti reads the currency exchange records for the specified rate type with start or end date falling between the dates specified. This is used in the auto validate functions to prevent people from entering duplicate currencies of the same type for the same periods in timeSQL
searchCurrExchByDatensmulti This operation will list all the currency exchange rates that are active for the current date. It will only show one rate per currency.SQL
getRateByDateType  @superseded - replaced by readRateByDateType 
searchCurrExchangeRatesByDatesnsmultiPRE_DATA_ACCESS: yes
 
reads the currency exchange records for the specified date rangeSQL
readCurrencyExchangeIDByDateTypens  SQL
Related Pages (246)
Create Case (BenefitSample_createCase)
BenefitSample_listFinInstruction
Case Financials (BenefitSampleOverpayment_listFinInstruction)
BenefitSampleOverpayment_listFinInstruction1
- (CHIPDecision_context)
Add Member (CHIPProduct_addAssistanceGroupMember)
Confirm Benefit Group Member (CHIPProduct_confirmAddBenefitGroupMember)
Remove Member (CHIPProduct_removeAssistanceGroupMember)
Remove Member (CHIPProduct_removeBenefitGroupMember)
Authorize (CREOLEProgramRecommendation_confirmAuthorize)
New Product Delivery (DefaultIC_createProductDelivery)
New Case (DefaultICMember_createProductDelivery)
Transactions (DefaultICProduct_listTransaction)
- (DefaultICProduct_tabDetails)
DefaultICProduct_tabDetailsPreview
Program Summary (Eligibility_createProgram)
- (EmergencyMedicaidDecision_context)
Financials (Employer_listFinancial)
Employer_listFinancial1
- (ESIDecision_context)
- (ExemptionDecision_context)
ExternalParty_listFinancial1
Adjustment Instruction Details (ExternalParty_viewAdjustmentInstruction)
Financial Line Item Details (ExternalParty_viewLineItem)
Payment Instruction Details (ExternalParty_viewNonClientPaymentInstruction)
Payment Instruction Details (ExternalParty_viewPaymentInstruction)
Canceled Payment Details (Financial_cancelledPaymentInstruction)
Cancel Payment (Financial_cancelPayment)
Cancel Payment (Financial_cancelPayment1)
Cancel Issued Payment (Financial_cancelPaymentInstrument)
Capture Account Adjustment (Financial_captureAccountAdjustment)
Reissue with Applied Deduction (Financial_createAppliedFixedDeductionWizard)
Reverse Instruction (Financial_createInstructionReversal)
Reverse Details (Financial_createLineItemReversal)
Create Manual Payment (Financial_createManualPayment)
Record Manually Issued Payment (Financial_createManualPaymentWizard)
Refund Payment (Financial_createRefund)
Reissue with Un-applied Deduction (Financial_createUnappliedDeductionWizard)
Invalidate Payment (Financial_invalidatePayment)
New Account Adjustment (Financial_newAccountAdjustment)
Financial_paymentReceivedSearch
Receive Payment for an Employer (Financial_recordPaymentReceivedForEmployer)
Receive Payment for a Person (Financial_recordPaymentReceivedForPerson)
Receive Payment Into Suspense Account (Financial_recordPaymentReceivedInSuspense)
Refund Payments (Financial_refundPayments)
Confirm & Reissue (Financial_regenerateAppliedFixedDeduction)
Reissue with Un-applied Deduction (Financial_regenerateUnappliedDeduction)
Reversed Liability Details (Financial_reversedLiabilityInstruction)
Simulate Payment (Financial_simulatePayment1)
Transfer From Suspense To Client (Financial_suspenseTransferIssuerDetails)
Transfer from Suspense Account to Employer (Financial_suspenseTransferToEmployerDetails)
Transfer from Suspense Account to Person (Financial_suspenseTransferToPersonDetails)
Adjustment Instruction Details (Financial_viewAdjustmentInstruction)
Account Adjustment Details (Financial_viewAdjustmentInstruction1)
Liability Instruction Details (Financial_viewLiabilityInstruction)
Liability Details (Financial_viewLiabilityInstruction1)
Liability Details (Financial_viewLiabilityInstructionDetailsTransaction)
Financial Line Item Details (Financial_viewLiabilityLineItem)
Financial Line Item Details (Financial_viewLineItem)
Manual Payment Details (Financial_viewManualPaymentInstruction)
Payment Instruction Details (Financial_viewNonClientPaymentInstruction)
Payment Instruction Details (Financial_viewNonClientPaymentInstruction1)
Payment Details (Financial_viewPaymentInstruction)
Payment Details (Financial_viewPaymentInstruction1)
Payment Instruction Details (Financial_viewPaymentInstructionDetailsTransaction)
Financial_viewPaymentInstructionInline
Payment Details (Financial_viewPaymentInstructionModal)
- (Financial_viewPaymentInstrument)
Payment Instrument Details (Financial_viewPaymentInstrument1)
Payment Received Details (Financial_viewPaymentReceivedInstruction)
Payment Received (Financial_viewPaymentReceivedInstruction1)
Payment Received Details (Financial_viewPaymentReceivedInstructionDetailsTransaction)
Reversal Instruction Details (Financial_viewReversalInstruction)
Reversal Instruction Details (Financial_viewReversalInstructionDetailsTransaction)
Financial Line Item Details (Financial_viewReversedLineItem)
Financial Line Item Details (Financial_viewReversedLineItemForDebitType)
Suspense Account Item Details (Financial_viewSuspenseAccountItemDetail)
Payment Details (Financial_viewUnderpmtPaymentInstruction)
Write Off Instruction Details (Financial_viewWriteOffInstruction)
Write Off (Financial_viewWriteOffInstruction1)
Check Retroactive Medicaid Eligibility (HCRRetroactiveMedicaid_confirmCheckEligibilty)
ICBenefitUnderPayment_listFinInstruction1
New Case (ICMember_createProductDelivery)
ICProductSample_listFinInstruction1
Create Delivery (ICSample_createProductDelivery)
Case Financials (ICSportingGrantSample_listFinancial)
ICSportingGrantSample_listFinInstruction1
Financials (InformationProvider_listFinancial)
InformationProvider_listFinancial1
- (InsuranceAssistanceDecision_context)
Cancel Sanction (ISP_cancelSanctionEvidence)
Cancel Disregard (ISP_cancelSanctionOverride)
New Pay In Evidence (ISP_createISPPayInProductEvidence_sa)
Assign New Pay In (ISP_createPayInEvidenceFromApplyNewPayInFromSD)
Retroactive Program Summary (ISP_createRetroactiveProgram)
New Sanction (ISP_createSanctionEvidence)
New Disregard (ISP_createSanctionOverride)
Edit Sanction (ISP_modifySanctionEvidence_fromList)
Edit Sanction (ISP_modifySanctionEvidence_fromView)
Edit Disregard (ISP_modifySanctionOverride_fromList)
Modify Sanction Override Details: (ISP_modifySanctionOverride_fromView)
Transactions (ISPProduct_listFinInstruction)
Medical Assistance with Spend Down Program Summary (ISPSpendDown_createProgram)
Create Program (ISPSpendDown_createRetroactiveProgram)
Case Financials (LiabilityOverbilling_listFinInstruction)
Create Case (LiabilitySample_createCase)
Case Financials (LiabilitySample_listFinInstruction)
LiabilitySample_listFinInstruction1
Delete Exchange Rate (Organization_cancelCurrencyExchange)
New Exchange Rate (Organization_createCurrencyExchange)
Currency Exchange Rates (Organization_listCurrencyExchange)
Currency Exchange History (Organization_listCurrencyExchangeHistory)
Edit Exchange Rate (Organization_modifyCurrencyExchangeFromList)
Search Exchange Rates (Organization_searchCurrencyExchangeRates)
Capture Account Adjustment (Participant_captureAccountAdjustment)
Reverse Line Item (Participant_createLineItemReversal)
New Account Adjustment (Participant_newAccountAdjustment)
Adjustment Instruction Details (Participant_viewAdjustmentInstruction)
Liability Instruction Details (Participant_viewLiabilityInstruction)
Liability Instruction Details (Participant_viewLiabilityInstructionFromWriteOff)
Financial Line Item Details (Participant_viewLiabilityLineItem)
Financial Line Item Details (Participant_viewLineItem)
Payment Instruction Details (Participant_viewNonClientPaymentInstruction)
Payment Details (Participant_viewPaymentInstruction)
- (Participant_viewPaymentInstrument)
Payment Received Details (Participant_viewPaymentReceivedInstruction)
Reversal Instruction Details (Participant_viewReversalInstruction)
Financial Line Item Details (Participant_viewReversedLineItem)
Write Off Instruction Details (Participant_viewWriteOffInstruction)
PaymentCorrection_listTransaction
PDBenefitUnderPayment_listFinInstruction
PDServiceDelivery_listTransaction
Financials (Person_listFinancial)
Transactions (Person_listFinancial1)
Person_listFinancialForDuplicate1
Save Simulation (ProductDelivery_saveSimulation)
Simulate Payment (ProductDelivery_simulatePayment)
- (ProductDelivery_tabDetails)
ProductDelivery_tabDetailsPreview
Payment Details (ProductDelivery_viewDedPaymentInstruction)
Financials (ProductProvider_listFinancial)
ProductProvider_listFinancial1
Authorize (ProgramRecommendation_confirmAuthorize)
Authorize (ProgramRecommendation_listHouseholdMembersForMA)
Authorize (ProgramRecommendation_PremiumCoPaymentDetails)
Activate Contract (ProviderManagement_activateContract)
New Text Translation (ProviderManagement_addDescriptionTranslationToServiceOffering)
New Text Translation (ProviderManagement_addNameTranslationToServiceOffering)
Add Service Authorization Line Item: (ProviderManagement_addSampleServiceAuthorizationLineItem)
New Service (ProviderManagement_addServicesToProviderContract)
Add Services to Contract (ProviderManagement_addServicesToProviderGroupContract)
New Service (ProviderManagement_addServicesToProviderGroupContract_fromView)
Update to Training (ProviderManagement_addTrainingForServiceOffering)
Submit Service Invoice Line Item for Processing (ProviderManagement_allowSILIForProcessingAsDuplicate)
Amend Utilization Contract (ProviderManagement_amendProviderGroupUtilizationContract)
Amend Contract (ProviderManagement_amendUtilizationContract)
Approve Line Item (ProviderManagement_approveLineItemCorrections)
Approve Line Item (ProviderManagement_approvePendingSILI)
Approve Line Item (ProviderManagement_approvePendingSILICorrections)
Approve Line Item (ProviderManagement_approveServiceInvoiceLineItem)
Approve Service Invoice Line Items (ProviderManagement_approveServiceInvoiceLineItems)
Approve Line Item (ProviderManagement_approveSILI)
Approve Service Invoice Line Item as Duplicate (ProviderManagement_approveSILIAsDuplicate)
Approve Line Item (ProviderManagement_approveSILICorrections)
Approve Line Items (ProviderManagement_approveSubmittedSILI)
Approve Line Items (ProviderManagement_confirmApproveServiceInvoiceLineItems)
Confirm cancel overlapping reservations (ProviderManagement_confirmCancelOverlappingActiveResForAnyClient)
Confirm Modify Overlapping Placements (ProviderManagement_confirmModifyOverlappingPlacementPrd)
Confirm modify overlapping placements (ProviderManagement_confirmModifyPlacementPrdForWL)
Submit Line Items (ProviderManagement_confirmSubmitServiceInvoiceLineItems)
New Service (ProviderManagement_createNewServiceOffering)
New Service (ProviderManagement_createNewTrainingServiceOffering)
New Service Rate (ProviderManagement_createProviderGroupUtilizationContractProviderOfferingRate)
New Payment Options (ProviderManagement_createProviderPaymentOption)
New Rate (ProviderManagement_createProviderServiceOfferingRate)
Create Emergency Placement (ProviderManagement_createSampleEmergencyPlacement)
Create Service Authorization Line Items (ProviderManagement_createSampleSAWithSALI)
New Service (ProviderManagement_createServiceOffering)
New Payment Options (ProviderManagement_createServicePaymentOption)
New Service Rate (ProviderManagement_createServiceRate)
New Training Service (ProviderManagement_createTrainingServiceOffering)
New Utilization Contract (ProviderManagement_createUtilizationContractForProvider)
New Rate (ProviderManagement_createUtilizationContractProviderOfferingRate)
Edit Payment Option (ProviderManagement_editProviderPaymentOption)
Edit Service (ProviderManagement_editServiceOffering)
Edit Service (ProviderManagement_editServiceOfferingFrmView)
Edit Payment Options (ProviderManagement_editServicePaymentOption)
Edit Service Rate (ProviderManagement_editServiceRate)
Edit Training Service (ProviderManagement_editTrainingServiceOffering)
Edit Training Service (ProviderManagement_editTrainingServiceOfferingFrmView)
Liabilities (ProviderManagement_listLiabilitiesForProvider)
Liabilities (ProviderManagement_listLiabilitiesForProviderGroup)
Transactions (ProviderManagement_listProviderGroupPaymentTransactions)
Transactions (ProviderManagement_listProviderPaymentTransactions)
Edit Text Translation (ProviderManagement_modifyLocalizableSODescriptionTextTranslation)
Edit Text Translation (ProviderManagement_modifyLocalizableSONameTextTranslation)
Confirm Placement (ProviderManagement_modifyPlaceDuringConfirmation)
Edit Placement (ProviderManagement_modifyPlacementDetails)
Modify Placement Information (ProviderManagement_modifyPlacementInformation)
Confirm Cancel Reservation (ProviderManagement_modifyPlacementInformationConfirmCancelReservation)
Allocate Place (ProviderManagement_modifyPlaceProviderOfferingAllocate)
Edit Service Rate (ProviderManagement_modifyProviderGroupUtilizationContractProviderOfferingRate)
Edit Rate (ProviderManagement_modifyProviderServiceOfferingRate)
Confirm Placement: (ProviderManagement_modifySamplePlaceDuringConfirmation)
Modify Service Authorization Line Item: (ProviderManagement_modifySampleServiceAuthorizationLineItem)
Edit Delivery Configuration (ProviderManagement_modifySecurityRightsAndServiceDeliveryConfiguration)
Edit Utilization Contract (ProviderManagement_modifyUtilizationContractForProviderGroup)
Edit Rate (ProviderManagement_modifyUtilizationContractProviderOfferingRate)
Place Client (ProviderManagement_placeSampleClient)
Renew Contract (ProviderManagement_renewContract)
Renew Contract (ProviderManagement_renewProviderGroupContract)
Submit Line Item (ProviderManagement_submitOpenSILIForProcessing)
Submit Line Item (ProviderManagement_submitServiceInvoiceLineItemForProcessing)
Submit Line Items (ProviderManagement_submitServiceInvoiceLineItems)
Submit Line Item (ProviderManagement_submitSILI)
Submit Service Invoice Line Item for Processing (ProviderManagement_submitSILIForProcessingFromTask)
Submit Service Invoice (ProviderManagement_submittServiceInvoiceForProcessing)
Transfer Client (ProviderManagement_transferClient)
Transfer Placement to Another Case (ProviderManagement_transferSamplePlacementToAnotherCase)
Reassessment Details (ProviderManagement_triggerReassessment)
Update Placement Period (ProviderManagement_updateSamplePlacementPeriod)
Financial Line Item Details (ProviderManagement_viewBenefitUnderPayment)
Payment Instruction Details (ProviderManagement_viewBenefitUnderPaymentInstruction)
Financials (Representative_listFinancial)
Representative_listFinancial1
New Disregard (SanctionAssessment_createDisregard_CREOLE)
New Sanction (SanctionAssessment_createSanction_CREOLE)
Edit Sanction (SanctionAssessment_modifySanction)
Edit Recommendation Disregard (SanctionAssessment_modifySanctionOverride)
ServiceDelivery_listTransaction
Add Plan Item (ServicePlanDelivery_addCustomServicePlanItem)
Add Plan Item (ServicePlanDelivery_addServicePlanItem)
Edit Plan Item (ServicePlanDelivery_modifyCustomServicePlanItemProviderEditable)
Edit Plan Item (ServicePlanDelivery_modifyCustomServicePlanItemProviderNonEditable)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanItemProviderEditable)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanItemProviderNonEditable)
Financials (ServiceSupplier_listFinancial)
ServiceSupplier_listFinancial1
Liability Instruction Details (SocialEnterpriseFolder_viewFinancialLiabilityInstruction)
Payment Instruction Details: (SocialEnterpriseFolder_viewFinancialPaymentInstruction)
Payment Received Details (SocialEnterpriseFolder_viewFinancialPaymentReceivedInstruction)
- (StateBasicPlanDecision_context)
- (StreamlineMedicaidDecision_context)
- (UQHPDecision_context)
Financials (Utility_listFinancial)
Utility_listFinancial1