Table Description
Service Invoice Line Item Transactions: A transaction on a service invoice line item that occurs during the processing of the service invoice line item that affects the final amount that will be approved for payment.

A transaction on a service invoice line item that occurs during the processing of the service invoice line item that affects the final amount that will be approved for payment.

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::CPM::Service Layer::Financials::Service Invoice::Entity::SILITransaction
Controlling File: CPM\model\Packages\Service Layer\Financials\Service Invoice\Service Invoice_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (33)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
siliTransactionIDkeynoThe unique system generated identifier for the Service Invoice Line Item Transactions.SERVICE_INVOICE_ID SVR_INT64
serviceInvoiceLineItemIDdetailsnoThe unique system generated identifier for the Service Invoice Line Item.SERVICE_INVOICE_ID SVR_INT64
creationDateTimedetailsnoThe date and time of the creation of the transaction.CURAM_DATETIME SVR_DATETIME
transactionTypedetailsnoThe type of transaction captured for the service invoice line item.SILI_TRANSACTION_TYPESILITransactionTypeSVR_STRING<10>
adjustmentReasondetailsyesThe reason that the amount invoiced for a service invoice line item is adjusted.SILI_ADJUSTMENT_REASONSILIAdjustmentReasonSVR_STRING<10>
adjustmentAmountdetailsyesThe amount of the adjustment. When a value is not entered by the user, this stores -1 as a sentinel value.CURAM_AMOUNT SVR_MONEY
amountdetailsyesThe adjusted amount to be paid for the service invoice line item. When a value is not entered by the user, this stores -1 as a sentinel value.CURAM_AMOUNT SVR_MONEY
saliUnitAmountdetailsyesThe stipulated amount per unit that the agency authorizes for payment to a provider for delivering the service to a particular client.  When a value is not entered by the user, this stores -1 as a sentinel value.CURAM_AMOUNT SVR_MONEY
serviceRateFixedAmountdetailsyesThe fixed amount that the organization will pay for the service offering.  When a value is not entered by the user, this stores -1 as a sentinel value.CURAM_AMOUNT SVR_MONEY
serviceRateMinAmountdetailsyesThe minimum amount that the organization will pay for the service offering.  When a value is not entered by the user, this stores -1 as a sentinel value.CURAM_AMOUNT SVR_MONEY
serviceRateMaxAmountdetailsyesThe maximum amount that the organization will pay for the service offering.  When a value is not entered by the user, this stores -1 as a sentinel value.CURAM_AMOUNT SVR_MONEY
soFixedAmountPaymentOptiondetailsyesThe payment options available to the organization if a service invoice is received for a provider offering that is not equal to the fixed amount specified for the service offering.FIXED_AMT_PMT_OPTIONFixedAmountPaymentOptionSVR_STRING<10>
soMinAmountPaymentOptiondetailsyesThe payment options available to the organization if a service invoice is received for a provider offering where the amount billed is less than the minimum amount specified for the service offering.MIN_AMT_PMT_OPTIONMinAmountPaymentOptionSVR_STRING<10>
soMaxAmountPaymentOptiondetailsyesThe payment options available to the organization if a service invoice is received for a provider offering where the amount billed is greater than the maximum amount specified for the service offering.MAX_AMT_PMT_OPTIONMaxAmountPaymentOptionSVR_STRING<10>
providerOfferingRateFixAmountdetailsyesThe fixed amount that the organization will pay for the service offering when being provided by a particular provider.  When a value is not entered by the user, this stores -1 as a sentinel value.CURAM_AMOUNT SVR_MONEY
providerOfferingRateMinAmountdetailsyesThe minimum amount that the organization will pay for the service offering when being provided by a particular provider. This can be used in conjunction with the maximum amount to define a range within which payments for a service are valid.  When a value is not entered by the user, this stores -1 as a sentinel value.CURAM_AMOUNT SVR_MONEY
providerOfferingRateMaxAmountdetailsyesThe maximum amount that the organization will pay for the service offering when being provided by a particular provider. This can be used in conjunction with the minimum amount to define a range within which payments for a service are valid.  When a value is not entered by the user, this stores -1 as a sentinel value.CURAM_AMOUNT SVR_MONEY
poFixedAmountPaymentOptiondetailsyesThe payment options available to the organization if a service invoice is received for a provider offering that is not equal to the fixed amount specified for the provider offering.FIXED_AMT_PMT_OPTIONFixedAmountPaymentOptionSVR_STRING<10>
poMinAmountPaymentOptiondetailsyesThe payment options available to the organization if a service invoice is received for a provider offering where the amount billed is less than the minimum amount specified for the provider offering.MIN_AMT_PMT_OPTIONMinAmountPaymentOptionSVR_STRING<10>
poMaximumAmountPaymentOptiondetailsyesThe payment options available to the organization if a service invoice is received for a provider offering where the amount billed is greater than the maximum amount specified for the provider offering.MAX_AMT_PMT_OPTIONMaxAmountPaymentOptionSVR_STRING<10>
statusdetails The adjusted amount to be paid for the service invoice line item.SILI_TRANSACTION_STATUSSILITransactionStatusSVR_STRING<10>
serviceRateIDdetailsyesThe unique system generated identifier for the service rate record.INTERNAL_ID SVR_INT64
providerRateIDdetailsyesThe unique system generated identifier for the provider offering rate record.INTERNAL_ID SVR_INT64
paymentOptionsIDdetailsyesThe unique system generated identifier for the payment option record.INTERNAL_ID SVR_INT64
rateTypedetails The type of the rate for which it is applicable to. For e.g., Service Offering Rate, Provider Offering Rate etc.CPM_RATE_TYPERateTypeSVR_STRING<10>
rateIDdetails The unique identifier of the rate. For e.g., Service Offering Rate ID, Provider Offering Rate ID etc.INTERNAL_ID SVR_INT64
paymentOptionTypedetails The type of the payment option of the transaction. For e.g., Service Offering, Provider Offering etc.CPM_PAYMENT_OPTION_TYPEPaymentOptionTypeSVR_STRING<10>
fixedRateAmountdetailsyesThe fixed amount per unit of service that the organization pays to the provider for providing the service.  When a value is not entered by the user, this stores -1 as a sentinel value.CURAM_AMOUNT SVR_MONEY
minimumRateAmountdetailsyesThe minimum amount per unit of service that the organization pays to the provider for providing the service.  When a value is not entered by the user, this stores -1 as a sentinel value.CURAM_AMOUNT SVR_MONEY
maximumRateAmountdetailsyesThe maximum amount per unit of service that the organization pays to the provider for providing the service.  When a value is not entered by the user, this stores -1 as a sentinel value.CURAM_AMOUNT SVR_MONEY
fixedAmountPaymentOptiondetails The payment options available to the organization if an invoice received for a service that is equal to the fixed amount specified for the service.FIXED_AMT_PMT_OPTIONFixedAmountPaymentOptionSVR_STRING<10>
minimumAmountPaymentOptiondetails The payment options available to the organization if an invoice is received for a service where the amount billed is less than the minimum amount specified for the service.MIN_AMT_PMT_OPTIONMinAmountPaymentOptionSVR_STRING<10>
maximumAmountPaymentOptiondetails The payment options available to the organization if an invoice is received for a service where the amount billed is greater than the maximum amount specified for the service.MAX_AMT_PMT_OPTIONMaxAmountPaymentOptionSVR_STRING<10>
Foreign Keys (4)
ChildParent
SILITransaction.paymentOptionsIDPaymentOptions.paymentOptionID
SILITransaction.providerRateIDProviderOfferingRate.providerOfferingRateID
SILITransaction.serviceInvoiceLineItemIDServiceInvoiceLineItem.serviceInvoiceLineItemID
SILITransaction.serviceRateIDServiceRate.serviceRateID
Indices (4)
Index NameAttributes
SILITransactionIndex1providerRateID
SILITransactionIndex2paymentOptionsID
SILITransactionIndex3serviceInvoiceLineItemID, transactionType, status
IND__101107108serviceRateID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: siliTransactionID
Creates a new row on Service Invoice Line Item Transaction table. 
readread Reads a row of data from Service Invoice Line Item Transaction table. 
searchByServiceInvoiceLineItemreadmulti Search Service Invoice Line Item Transaction by Service Invoice Line Item. 
searchBySILIAndTransactionTypeAndStatusreadmulti Search Service Invoice Line Item Transaction by Service Invoice Line Item, Transaction Type and Status. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies an existing row on Service Invoice Line Item Transaction table. 
searchByPaymentOptionreadmulti Search Service Invoice Line Item Transaction by Payment Option. 
searchByProviderOfferingRatereadmulti Search Service Invoice Line Item Transaction by Provider Offering Rate. 
Related Pages (120)
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)
Service Invoice Line Item (ProviderManagement_approveordenySILI)
Approve Line Item (ProviderManagement_approvePendingSILI)
Approve Line Item (ProviderManagement_approvePendingSILICorrections)
Approve Line Item (ProviderManagement_approvePRLICorrectionFromView)
Approve Provider Roster Line Item Correction (ProviderManagement_approvePRLICorrections)
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)
Delete Payment Option (ProviderManagement_cancelProviderPaymentOption)
Delete Line Item (ProviderManagement_cancelServiceInvoiceLineItem)
Cancel Service Invoice Line Items (ProviderManagement_cancelServiceInvoiceLineItems)
Cancel Service Invoice Line Item (ProviderManagement_cancelSILIFromTask)
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 Line Item (ProviderManagement_createNewServiceInvoiceLineItem)
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 Line Item (ProviderManagement_createSILICorrection)
New Training Service (ProviderManagement_createTrainingServiceOffering)
New Utilization Contract (ProviderManagement_createUtilizationContractForProvider)
New Rate (ProviderManagement_createUtilizationContractProviderOfferingRate)
Deny Line Item (ProviderManagement_denyServiceInvoiceLineItem)
Deny Service Invoice Line Items (ProviderManagement_denyServiceInvoiceLineItems)
Deny Service Invoice Line Item (ProviderManagement_denySILIFromTask)
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)
Service Invoice Line Items (ProviderManagement_listServiceInvoiceLineItemsForProvider)
View Service Invoice Line Items: (ProviderManagement_listServiceInvoiceLineItemsForProviderGroup)
Service Invoices: (ProviderManagement_listServiceInvoicesForProvider)
Service Invoices: (ProviderManagement_listServiceInvoicesForProviderGroup)
Edit Service Invoice Line Item (ProviderManagement_modifyEPServiceInvoiceLineItem)
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 Line Item (ProviderManagement_modifyServiceInvoiceLineItem)
Edit Utilization Contract (ProviderManagement_modifyUtilizationContractForProviderGroup)
Edit Rate (ProviderManagement_modifyUtilizationContractProviderOfferingRate)
Place Client (ProviderManagement_placeSampleClient)
No Match Task Action (ProviderManagement_processSILIException)
Remove Client (ProviderManagement_removeClientFromServiceInvoiceLineItem)
Renew Contract (ProviderManagement_renewContract)
Renew Contract (ProviderManagement_renewProviderGroupContract)
Retrieve Service Invoice Line Item Information: (ProviderManagement_sampleRetrieveServiceInvoiceLineItemDetails)
Service Invoices (ProviderManagement_searchServiceInvoiceForProvider)
Service Invoices (ProviderManagement_searchServiceInvoiceForProviderGroup)
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 Placement to Another Case (ProviderManagement_transferSamplePlacementToAnotherCase)
Reassessment Details (ProviderManagement_triggerReassessment)
Update Placement Period (ProviderManagement_updateSamplePlacementPeriod)
Completed Line Item (ProviderManagement_viewCompleteServiceInvoiceLineItem)
View Contracted Rate Adjustment Details (ProviderManagement_viewContractedRateForSILIAdjustmentFactor)
ProviderManagement_viewEPServiceInvoiceLineItem
View Service Invoice Line Item: (ProviderManagement_viewInsertServiceInvoiceLineItem)
Open Line Items (ProviderManagement_viewOpenServiceInvoiceLineItems)
View Provider Offering Adjustment Details (ProviderManagement_viewProviderServiceRateForSILIAdjustmentFactor)
View Service Authorization Line Item (ProviderManagement_viewSALIForSILIAdjustmentFactor)
View Service Authorization Line Item: (ProviderManagement_viewSamplesServiceAuthorizationLineItem)
View Service Authorization Line Item (ProviderManagement_viewServiceAuthorizationLineItem)
Service Invoice Line Item (ProviderManagement_viewServiceInvoiceLineItem)
Service Invoice Line Item for Provider (ProviderManagement_viewServiceInvoiceLineItemForProvider)
View Service Invoice Line Item for Provider Group: (ProviderManagement_viewServiceInvoiceLineItemForProviderGroup)
Messages for Line Item (ProviderManagement_viewServiceInvoiceLineItemInfoMessages)
All Line Items (ProviderManagement_viewServiceInvoiceLineItems)
Service Invoice Line Item Transactions (ProviderManagement_viewServiceInvoiceLineItemTransanctions)
View Service Adjustment Details (ProviderManagement_viewServiceOfferingRateForSILIAdjustmentFactor)
View Service Invoice Type Payment Detail for Provider: (ProviderManagement_viewSIPaymentForProvider)
View Service Invoice Type Payment Detail for Provider Group: (ProviderManagement_viewSIPaymentForProviderGroup)
Transactions (ProviderManagement_viewSIPaymentTransactionForPG)
Transactions (ProviderManagement_viewSIPaymentTransactionForProvider)
Pending Line Items (ProviderManagement_viewSubmittedServiceInvoiceLineItems)
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)