Table Description
ServiceInvoiceRequestLineItem: A service invoice line item contains information entered by a user about one specific line item on a service invoice.

A service invoice line item contains information entered by a user about one specific line item on a service invoice.

Example

A provider who has an external user account, can create a service invoice request line item. They can submit this. It will then either be accepted or rejected by a Resource Manager.
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::External User Access::Service Invoice Request Line Item::Entity::ServiceInvoiceRequestLineItem
Controlling File: CPM\model\Packages\Service Layer\External User Access\Service Invoice Line Item Request\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (26)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
referenceNumberdetailsnoA reference number assigned by the organization to a service invoice line item to uniquely identify it.REFERENCE_NUMBER SVR_STRING<20>
serviceAuthRefNumdetails The reference number of the service authorization that authorizes payment for the service delivered.REFERENCE_NUMBER SVR_STRING<20>
clientRefNumdetails The reference number of the client to whom the service was delivered. The client reference number entered by a user will be used to search for a registered person.REFERENCE_NUMBER SVR_STRING<20>
clientFirstNamedetails The first name of the client to whom the service was delivered. The first name entered by a user will be used to search for a registered person.FIRST_FORENAME SVR_STRING<65>
clientLastNamedetails The last name of the client to whom the service was delivered. The last name entered by a user will be used to search for a registered person.SURNAME SVR_STRING<65>
clientDateOfBirthdetails The date of birth of the client to whom the service was delivered. The date of birth entered by a user will be used to search for a registered person.CURAM_DATE SVR_DATE
serviceStartDatedetailsnoThe start date and time of the period during which the service was delivered.CURAM_DATE SVR_DATE
serviceEndDatedetailsnoThe end date and time of the period during which the service was delivered.CURAM_DATE SVR_DATE
serviceInvReqLineItemIDkeynoThe unique system generated identifier for the Service Invoice Request Line Item record.INTERNAL_ID SVR_INT64
caseRefNumdetails The 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>
providerRefNumdetails 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.NAME SVR_STRING<131>
payeeRefNumdetails The reference number of the provider or provider group who is to be paid for the delivery of the service. The payee may or may not have delivered the service.REFERENCE_NUMBER SVR_STRING<20>
payeeNamedetails The name of the provider who is to be paid for the delivery of the service. The provider may or may not have delivered the service.NAME SVR_STRING<131>
serviceInvoiceRequestIDdetailsnoThe unique identifier for the Service Invoice Request.INTERNAL_ID SVR_INT64
numberOfUnitsdetailsnoNumber of units of the service delivered.NUMBER_WORK_UNITS SVR_INT32
unitAmountdetailsnoThe amount invoiced for each unit of the service delivered.CURAM_AMOUNT SVR_MONEY
invoiceAmountdetailsyesThe 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
externalRefNumdetails 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>
statusdetails The status of the service invoice line item.SIREQUESTLI_STATUSSIRequestLIStatusSVR_STRING<10>
serviceIDdetailsyesThe unique system generated identifier for the Service record.PROVIDER_SERVICE_ID SVR_INT64
caseIDdetailsyesThe unique system generated identifier for the case record.CASE_ID SVR_INT64
clientIDdetailsyesThe unique system generated identifier for the client record.CONCERN_ROLE_ID SVR_INT64
providerIDdetailsyesThe unique system generated identifier for the provider record.CONCERN_ROLE_ID SVR_INT64
payeeIDdetailsyesThe unique system generated identifier for the payee record.INTERNAL_ID SVR_INT64
serviceAuthorizationLIIDdetailsyesThe unique system generated identifier for the Service Authorization Line Item record.INTERNAL_ID SVR_INT64
Foreign Keys (8)
ChildParent
ServiceInvoiceRequestLineItem.caseIDCaseHeader.caseID
ServiceInvoiceRequestLineItem.clientIDConcernRole.concernRoleID
ServiceInvoiceRequestLineItem.payeeIDConcernRole.concernRoleID
ServiceInvoiceRequestLineItem.providerIDProvider.providerConcernRoleID
ServiceInvoiceRequestLineItem.serviceAuthorizationLIIDServiceAuthorizationLineItem.serviceAuthorizationLIID
ServiceInvoiceRequestLineItem.serviceInvoiceRequestIDServiceInvoiceRequest.requestID
ServiceInvoiceRequestLineItem.serviceIDServiceOffering.serviceOfferingID
ServiceInvReqLineItemClient.serviceInvReqLineItemIDServiceInvoiceRequestLineItem.serviceInvReqLineItemID
Indices (7)
Index NameAttributes
SIRequestLineItemIndex1serviceInvoiceRequestID
IND_1928392908caseID
IND__1352822169clientID
IND__1691147774payeeID
IND_416065229providerID
IND__279808163serviceAuthorizationLIID
IND__1572855185serviceID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: serviceInvReqLineItemID
Creates a new row on Service Invoice Request Line Item table. 
readread Reads a row of data from Service Invoice Request Line Item table. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies an existing row on Service Invoice Request Line Item table. 
searchByServiceInvoiceRequestIDreadmulti Retrieves all Service Invoice Request Line Items records for an associated Service Invoice Request record. 
Related Pages (3)