Table Description
Service Invoice Line Item History: A history of the status and changes made to an individual service invoice line item.

A history of the status and changes made to an individual service invoice line item. Changes can result from the correction of a service invoice line item that has already been processed, or as a result of a change to a service invoice line item that has modified during processing.

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::SILIHistory
Controlling File: CPM\model\Packages\Service Layer\Financials\Service Invoice\Service Invoice_cat.efx
Attributes (21)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
siliHistoryIDkeynoThe unique system generated identifier for the Service Invoice Line Item History.SERVICE_INVOICE_ID SVR_INT64
serviceInvoiceLineItemIDdetailsnoThe unique system generated identifier for the Service Invoice Line Item.SERVICE_INVOICE_ID SVR_INT64
statusdetailsnoThe status of the service invoice line item.SILI_STATUSSILIStatusSVR_STRING<10>
dateTimeChangeddetailsnoThe date and time of the modification of a service invoice line item.CURAM_DATETIME SVR_DATETIME
saReferenceNodetails The reference number of the service authorization that authorizes payment for the service delivered.INVOICE_REF_NUMBER SVR_STRING<18>
serviceIDdetailsyesThe unique system generated identifier for the Service Offering.PROVIDER_SERVICE_ID SVR_INT64
serviceDateFromdetails The start date and time of the period during which the service was delivered.CURAM_DATE SVR_DATE
serviceDateTodetails The end date and time of the period during which the service was delivered.CURAM_DATE SVR_DATE
noOfUnitsdetails Number of units of the service delivered.NUMBER_WORK_UNITS SVR_INT32
unitAmountdetailsyesThe amount invoiced for each unit of the service delivered.CURAM_AMOUNT SVR_MONEY
amountInvoiceddetailsyesThe total amount invoiced for the service delivered (equals unit amount multiplied by number of units). This information should be entered by the user to ensure accuracy.CURAM_AMOUNT SVR_MONEY
caseReferenceNodetails The reference number of the case for which the client is receiving the service.INVOICE_REF_NUMBER SVR_STRING<18>
providerReferenceNodetails The reference number of the provider who delivered the service to the client of the agency.INVOICE_REF_NUMBER SVR_STRING<18>
providerNamedetails The name of the provider who delivered the service to the client of the agency.PROVIDER_NAME SVR_STRING<56>
payeeReferenceNodetails The reference number of the provider or provider group who is to be paid for the delivery of the service.INVOICE_REF_NUMBER SVR_STRING<18>
payeeNamedetails The name of the provider or provider group who is to be paid for the delivery of the service.PROVIDER_NAME SVR_STRING<56>
clientReferenceNodetails The reference number of the client to whom the service was delivered.INVOICE_REF_NUMBER SVR_STRING<18>
clientFirstNamedetails The first name of the client to whom the service was delivered.FIRST_FORENAME SVR_STRING<65>
clientLastNamedetails The last name of the client to whom the service was delivered.MOTHER_BIRTH_SURNAME SVR_STRING<65>
clientDOBdetails The date of birth of the client to whom the service was delivered.CURAM_DATE SVR_DATE
siliCorrectionIDdetailsyesThe identifier for the service invoice line item correction.INTERNAL_ID SVR_INT64
Foreign Keys (4)
ChildParent
SILIHistory.siliCorrectionIDSILICorrection.siliCorrectionID
SILIHistory.serviceInvoiceLineItemIDServiceInvoiceLineItem.serviceInvoiceLineItemID
SILIHistory.serviceIDServiceOffering.serviceOfferingID
SILIClientHistory.siliHistoryIDSILIHistory.siliHistoryID
Indices (3)
Index NameAttributes
SILIHistrySILICorrectionIDIdxsiliCorrectionID
SILIHistryServInvcLinItmIDIdxserviceInvoiceLineItemID
IND__45570414serviceID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: siliHistoryID
Creates a new row on SILIHistory table. 
readread Reads a row of data from SILIHistory table. 
searchByServiceInvoiceLineItemreadmulti Search Service Invoice Line Item History by Service Invoice Line Item. 
searchBySILIAndCorrectionreadmulti   
Related Pages (108)
Accept Request (ProviderManagement_acceptRequest)
New Client (ProviderManagement_addClientToLineItemCorrection)
New Client (ProviderManagement_addClientToOpenLineItemCorrection)
New Client (ProviderManagement_addClientToOpenSILI)
New Client (ProviderManagement_addClientToServiceInvoiceLineItem)
New Client (ProviderManagement_addClientToSILI)
New Client (ProviderManagement_addClientToSILICorrection)
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)
Restore Original Data (ProviderManagement_cancelLineItemCorrections)
Restore Original Data (ProviderManagement_cancelOpenLineItemCorrections)
Delete Line Item (ProviderManagement_cancelServiceInvoiceLineItem)
Cancel Service Invoice Line Items (ProviderManagement_cancelServiceInvoiceLineItems)
Restore Original Data (ProviderManagement_cancelSILICorrections)
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 Line Item (ProviderManagement_createServiceInvoiceLineItem)
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)
Restore Original Data (ProviderManagement_denyLineItemCorrections)
Restore Original Data (ProviderManagement_denyOpenLineItemCorrections)
Deny Line Item (ProviderManagement_denyServiceInvoiceLineItem)
Deny Service Invoice Line Items (ProviderManagement_denyServiceInvoiceLineItems)
Restore Original Data (ProviderManagement_denySILICorrections)
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)
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 Line Item (ProviderManagement_modifySILICorrection)
Edit Utilization Contract (ProviderManagement_modifyUtilizationContractForProviderGroup)
Edit Rate (ProviderManagement_modifyUtilizationContractProviderOfferingRate)
Place Client (ProviderManagement_placeSampleClient)
Remove Client (ProviderManagement_removeClientFromServiceInvoiceLineItem)
Remove Client (ProviderManagement_removeClientFromSILICorrection)
Renew Contract (ProviderManagement_renewContract)
Renew Contract (ProviderManagement_renewProviderGroupContract)
Submit Line Item (ProviderManagement_submitForApprovalSILICorrections)
Submit Line Item (ProviderManagement_submitOpenSILICorrectionsForApproval)
Submit Line Item (ProviderManagement_submitOpenSILIForProcessing)
Submit Line Item (ProviderManagement_submitServiceInvoiceLineItemForProcessing)
Submit Line Items (ProviderManagement_submitServiceInvoiceLineItems)
Submit Line Item (ProviderManagement_submitSILI)
Submit Line Item (ProviderManagement_submitSILICorrectionsForApproval)
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)
Service Invoice Line Item History (ProviderManagement_viewServiceInvoiceLineItemHistory)
Service Invoice Line Item Modifications (ProviderManagement_viewServiceInvoiceLineItemModifications)
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)