Table Description
Service Invoice Line Item Correction: A history of the corrections initiated against a completed service invoice line item.

A corrected version of a service invoice line item may or may not be applied against the actual service invoice line item, depending upon whether the correction is approved or denied for processing.

Example

A Complete SILI with 3 units is modified to have 4 units or a Complete SILI is modified to have a different payee name etc.
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 Line Item Correction::Entity::SILICorrection
Controlling File: CPM\model\Packages\Service Layer\Financials\Service Invoice Line Item Correction\ServiceInvoiceLineItemCorrection_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (28)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
reasondetailsnoThe reason for which service invoice line item is being corrected.COMMENTS SVR_STRING<300>
recordStatusdetailsnoThe status is used to indicate if the service invoice line item correction has been logically deleted.SILI_CORRECTION_STATUSSILICorrectionStatusSVR_STRING<10>
externalRefNodetails A reference number provided by the provider or provider group who serves as the originator of the service invoice line item.REFERENCE_NUMBER SVR_STRING<20>
saRefNodetails The reference number of the service authorization that authorizes payment for the service delivered.REFERENCE_NUMBER SVR_STRING<20>
serviceFromDatedetailsnoThe start date and time of the period during which the service was delivered.CURAM_DATE SVR_DATE
serviceToDatedetailsnoThe end date and time of the period during which the service was delivered.CURAM_DATE SVR_DATE
numberOfUnitsdetailsnoNumber of units of the service delivered.NUMBER_WORK_UNITS SVR_INT32
unitAmountdetails The amount invoiced for each unit of the service delivered.CURAM_AMOUNT SVR_MONEY
amountInvoiceddetails The total amount invoiced for the service delivered.CURAM_AMOUNT SVR_MONEY
caseRefNodetailsnoThe reference number of the case for which the client is receiving the service. The case reference number entered by a user will be used to search for a case.REFERENCE_NUMBER SVR_STRING<20>
providerRefNodetails The reference number of the provider who delivered the service to the client of the agency.REFERENCE_NUMBER SVR_STRING<20>
providerNamedetails The name of the provider who delivered the service to the client of the agency.CONCERN_ROLE_NAME SVR_STRING<131>
payeeRefNodetails The reference number of the provider or provider group who is to be paid for the delivery of the service.REFERENCE_NUMBER SVR_STRING<20>
payeeNamedetails The name of the provider or provider group who is to be paid for the delivery of the service.CONCERN_ROLE_NAME SVR_STRING<131>
clientRefNodetails The reference number of the client to whom the service was delivered.REFERENCE_NUMBER SVR_STRING<20>
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.SURNAME SVR_STRING<65>
clientDOBdetails The date of birth of the client to whom the service was delivered.CURAM_DATE SVR_DATE
siliCorrectionIDkeynoThe unique system generated identifier for the service invoice line item correction.INTERNAL_ID SVR_INT64
serviceInvoiceLineItemIDdetailsyesThe unique system generated identifier for the service invoice line item.SERVICE_INVOICE_ID SVR_INT64
serviceIDdetailsyesThe unique system generated identifier for the service offering.PROVIDER_SERVICE_ID SVR_INT64
caseIDdetailsyesThe unique system generated identifier for the case.CASE_ID SVR_INT64
clientIDdetailsyesThe unique system generated identifier for the client.CONCERN_ROLE_ID SVR_INT64
providerIDdetailsyesThe unique system generated identifier for the provider.PROVIDER_ID SVR_INT64
payeeIDdetailsyesThe unique system generated identifier for the payee.SERVICE_INVOICE_ID SVR_INT64
serviceAuthorizationLIIDdetailsyesThe unique system generated identifier for the service authorization line item.SERVICE_INVOICE_ID SVR_INT64
referenceNodetails A reference number assigned by the organization to a service invoice line item correction to uniquely identify it.REFERENCE_NUMBER SVR_STRING<20>
creationDateTimedetails The date and time of the creation of the service invoice line item correction.CURAM_DATETIME SVR_DATETIME
Foreign Keys (12)
ChildParent
SILICorrection.caseIDCaseHeader.caseID
SILICorrection.clientIDConcernRole.concernRoleID
SILICorrection.payeeIDConcernRole.concernRoleID
SILICorrection.providerIDProvider.providerConcernRoleID
SILICorrection.serviceAuthorizationLIIDServiceAuthorizationLineItem.serviceAuthorizationLIID
SILICorrection.serviceInvoiceLineItemIDServiceInvoiceLineItem.serviceInvoiceLineItemID
SILICorrection.serviceIDServiceOffering.serviceOfferingID
SILIClientHistory.siliCorrectionIDSILICorrection.siliCorrectionID
SILICorrectionClient.siliCorrectionIDSILICorrection.siliCorrectionID
SILICorrectionHistory.siliCorrectionIDSILICorrection.siliCorrectionID
SILIHistory.siliCorrectionIDSILICorrection.siliCorrectionID
ServiceInvoiceLineItemClient.siliCorrectionIDSILICorrection.siliCorrectionID
Indices (7)
Index NameAttributes
SILICorrctServInvcLinItmIDIdxserviceInvoiceLineItemID
IND__1147639239caseID
IND_1812751508clientID
IND_1736103477payeeID
IND_1695523258providerID
IND_368660362serviceAuthorizationLIID
IND_2070648290serviceID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: siliCorrectionID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
searchByServiceInvoiceLineItemreadmulti   
searchOverUnderPaymentsByRelatedReferencensmulti Returns over and under payment details for the given related reference identifier. The related reference identifier could be a service invoice line item identifier or a provider roster line item identifier.SQL
Related Pages (43)
New Client (ProviderManagement_addClientToLineItemCorrection)
New Client (ProviderManagement_addClientToOpenLineItemCorrection)
New Client (ProviderManagement_addClientToOpenSILI)
New Client (ProviderManagement_addClientToServiceInvoiceLineItem)
New Client (ProviderManagement_addClientToSILI)
New Client (ProviderManagement_addClientToSILICorrection)
Approve Line Item (ProviderManagement_approveLineItemCorrections)
Service Invoice Line Item Correction (ProviderManagement_approveordenySILICorrection)
Approve Line Item (ProviderManagement_approvePendingSILICorrections)
Approve Line Item (ProviderManagement_approveSILICorrections)
Approve Line Items (ProviderManagement_approveSubmittedSILI)
Restore Original Data (ProviderManagement_cancelLineItemCorrections)
Restore Original Data (ProviderManagement_cancelOpenLineItemCorrections)
Restore Original Data (ProviderManagement_cancelSILICorrections)
Approve Line Items (ProviderManagement_confirmApproveServiceInvoiceLineItems)
Submit Line Items (ProviderManagement_confirmSubmitServiceInvoiceLineItems)
New Line Item (ProviderManagement_createNewServiceInvoiceLineItem)
New Line Item (ProviderManagement_createSILICorrection)
Restore Original Data (ProviderManagement_denyLineItemCorrections)
Restore Original Data (ProviderManagement_denyOpenLineItemCorrections)
Restore Original Data (ProviderManagement_denySILICorrections)
Clients (ProviderManagement_listClientsForServiceInvoiceLineItem)
View Service Invoice Line Item Correction Clients: (ProviderManagement_listClientsForSILICorrection)
Edit Line Item (ProviderManagement_modifyServiceInvoiceLineItem)
Edit Line Item (ProviderManagement_modifySILICorrection)
Remove Client (ProviderManagement_removeClientFromServiceInvoiceLineItem)
Remove Client (ProviderManagement_removeClientFromSILICorrection)
Submit Line Item (ProviderManagement_submitForApprovalSILICorrections)
Submit Line Item (ProviderManagement_submitOpenSILICorrectionsForApproval)
Submit Line Items (ProviderManagement_submitServiceInvoiceLineItems)
Submit Line Item (ProviderManagement_submitSILICorrectionsForApproval)
Completed Line Item (ProviderManagement_viewCompleteServiceInvoiceLineItem)
Denied Service Invoice Line Item (ProviderManagement_viewDeniedCorrection)
ProviderManagement_viewEPServiceInvoiceLineItem
View Service Invoice Line Item: (ProviderManagement_viewInsertServiceInvoiceLineItem)
Open Line Items (ProviderManagement_viewOpenServiceInvoiceLineItems)
Service Invoice Line Item (ProviderManagement_viewServiceInvoiceLineItem)
Service Invoice Line Item for Provider (ProviderManagement_viewServiceInvoiceLineItemForProvider)
View Service Invoice Line Item for Provider Group: (ProviderManagement_viewServiceInvoiceLineItemForProviderGroup)
Service Invoice Line Item History (ProviderManagement_viewServiceInvoiceLineItemHistory)
All Line Items (ProviderManagement_viewServiceInvoiceLineItems)
Service Invoice Line Item (ProviderManagement_viewSILICorrection)
Pending Line Items (ProviderManagement_viewSubmittedServiceInvoiceLineItems)