Table Description
Service Invoice Line Item Client: A service invoice line item client contains the client information for a service invoice line item entered by a user about one specific line item on a service invoice.

The client information for a service invoice line item.

Example

John's Clinic is a provider who delivers counseling for couples. John Smith and Linda Smith attend the counseling sessions and submit an invoice with the details of how many sessions were attended by them and other details.

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::ServiceInvoiceLineItemClient
Controlling File: CPM\model\Packages\Service Layer\Financials\Service Invoice\Service Invoice_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (8)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
siliClientIDkeyno INTERNAL_ID SVR_INT64
serviceInvoiceLineItemIDdetailsyes SERVICE_INVOICE_ID SVR_INT64
clientReferenceNodetails  REFERENCE_NO SVR_STRING<18>
clientIDdetailsyes CONCERN_ROLE_ID SVR_INT64
clientFirstNamedetails  FIRST_FORENAME SVR_STRING<65>
clientLastNamedetails  MOTHER_BIRTH_SURNAME SVR_STRING<65>
clientDOBdetails  CURAM_DATE SVR_DATE
siliCorrectionIDdetailsyes INTERNAL_ID SVR_INT64
Foreign Keys (3)
ChildParent
ServiceInvoiceLineItemClient.clientIDConcernRole.concernRoleID
ServiceInvoiceLineItemClient.siliCorrectionIDSILICorrection.siliCorrectionID
ServiceInvoiceLineItemClient.serviceInvoiceLineItemIDServiceInvoiceLineItem.serviceInvoiceLineItemID
Indices (3)
Index NameAttributes
SILIClientSILICorrectionIDIdxsiliCorrectionID
SILIClientServInvcLinItmIDIdxserviceInvoiceLineItemID
IND__18992645clientID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: siliClientID
Creates a new row on Service Invoice Line Item Client table. 
readread Reads a row of data from Service Invoice Line Item Client table. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies an existing row on Service Invoice Line Item Client table. 
removeremove Removes an existing row from Service Invoice Line Item Client table. 
searchByServiceInvoiceLineItemreadmulti Searches all the clients for a given service invoice line item. 
readyByClientAndServiceInvoiceLineItemnsread Reads Service Invoice Line Item client by client ID and service invoice line item client ID. 
searchBySILIAndCorrectionreadmulti   
Related Pages (68)
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)
Submit Service Invoice Line Item for Processing (ProviderManagement_allowSILIForProcessingAsDuplicate)
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_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)
Submit Line Items (ProviderManagement_confirmSubmitServiceInvoiceLineItems)
New Line Item (ProviderManagement_createNewServiceInvoiceLineItem)
New Line Item (ProviderManagement_createServiceInvoiceLineItem)
New Line Item (ProviderManagement_createSILICorrection)
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)
Clients (ProviderManagement_listClientsForServiceInvoiceLineItem)
View Service Invoice Line Item Correction Clients: (ProviderManagement_listClientsForSILICorrection)
Edit Service Invoice Line Item (ProviderManagement_modifyEPServiceInvoiceLineItem)
Edit Line Item (ProviderManagement_modifyServiceInvoiceLineItem)
Edit Line Item (ProviderManagement_modifySILICorrection)
No Match Task Action (ProviderManagement_processSILIException)
Remove Client (ProviderManagement_removeClientFromServiceInvoiceLineItem)
Remove Client (ProviderManagement_removeClientFromSILICorrection)
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)
Current Performance (ProviderManagement_viewActualContractPerformanceMeasure)
Current Performance (ProviderManagement_viewActualServiceContractPerformanceMeasure)
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)
Messages for Line Item (ProviderManagement_viewServiceInvoiceLineItemInfoMessages)
All Line Items (ProviderManagement_viewServiceInvoiceLineItems)
Service Invoice Line Item (ProviderManagement_viewSILICorrection)
View Service Invoice Type Payment Detail for Provider: (ProviderManagement_viewSIPaymentForProvider)
View Service Invoice Type Payment Detail for Provider Group: (ProviderManagement_viewSIPaymentForProviderGroup)
Pending Line Items (ProviderManagement_viewSubmittedServiceInvoiceLineItems)