Table Description
Service Authorization Line Item: A service authorization line item contains information created about one specific line item on a service authorization.

A service authorization line item is created in response to the approval of an authorization to deliver a service to a client.
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 Authorization::Entity::ServiceAuthorizationLineItem
Controlling File: CPM\model\Packages\Service Layer\Financials\Service Authorization\Service Authorization_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGno
Attributes (16)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
serviceAuthorizationLIIDkeynoThe unique system generated identifier for the Service Authorization Line Item record.SERVICE_AUTHORIZATION_LINE_ITEM_ID SVR_INT64
serviceAuthorizationIDdetailsnoThe unique system generated identifier for the Service Authorization.SERVICE_AUTHORIZATION_ID SVR_INT64
dateAddeddetailsnoThe date on which the service authorization line item was added to the service authorization.CURAM_DATE SVR_DATE
fromDatedetailsnoThe start date and time of the period during which the client is authorized to receive the service.CURAM_DATE SVR_DATE
toDatedetailsyesThe end date and time of the period during which the client is authorized to receive the service.CURAM_DATE SVR_DATE
unitsAuthorizeddetailsnoThe number of units of the service that are authorized.UNITS_AUTHORIZED SVR_INT32
unitAmountdetailsyesThe stipulated amount per unit that the agency authorizes for payment to a provider for delivering the service to a particular client.CURAM_AMOUNT SVR_MONEY
unitAmountFixedInddetailsyesIndicates whether or not the Unit Amount is considered a fixed or estimated amount.BOOLEAN_TYPE SVR_BOOLEAN
totalCostdetailsyesThe total cost of the service authorization line item. When a value is not entered by the user, this stores -1 as a sentinel value.CURAM_AMOUNT SVR_MONEY
maximumUnitsdetailsyesUsed in conjunction with the Maximum Units Frequency attribute to define the number of units that a client is authorized to receive during a specific period.MAXIMUM_UNIT SVR_INT64
maximumUnitsFrequencydetailsyesUsed in conjunction with the Maximum Units attribute to define the number of units that a client is authorized to receive during a specific period.UNIT_FREQUENCYUnitFrequencySVR_STRING<10>
providerIDdetailsyesThe unique system generated identifier for the Provider.PROVIDER_ID SVR_INT64
serviceIDdetailsnoThe unique system generated identifier for the Service Offering.PROVIDER_SERVICE_ID SVR_INT64
recordStatusdetailsnoThe status is used to indicate if the service authorization line item has been logically deleted.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
nomineeIDdetailsyesThe reference number of the nominee who is entitled to receive the provider payment. When a provider payment is generated, payment will be issued directly to the nominee rather than the provider.CONCERN_ROLE_ID SVR_INT64
providerTypedetails The type of the provider for whom this service authorization has been created.PROVIDER_TYPEProviderTypeSVR_STRING<10>
Foreign Keys (9)
ChildParent
ServiceAuthorizationLineItem.nomineeIDConcernRole.concernRoleID
ServiceAuthorizationLineItem.providerIDProvider.providerConcernRoleID
ServiceAuthorizationLineItem.serviceAuthorizationIDServiceAuthorization.serviceAuthorizationID
ServiceAuthorizationLineItem.serviceIDServiceOffering.serviceOfferingID
PRLISALILink.serviceAuthorizationLIIDServiceAuthorizationLineItem.serviceAuthorizationLIID
SILICorrection.serviceAuthorizationLIIDServiceAuthorizationLineItem.serviceAuthorizationLIID
ServiceAuthorizationLIHistory.serviceAuthorizationLIIDServiceAuthorizationLineItem.serviceAuthorizationLIID
ServiceInvoiceLineItem.serviceAuthorizationLIIDServiceAuthorizationLineItem.serviceAuthorizationLIID
ServiceInvoiceRequestLineItem.serviceAuthorizationLIIDServiceAuthorizationLineItem.serviceAuthorizationLIID
Indices (5)
Index NameAttributes
ServceAuthLineItmSrvAuthIDIdxserviceAuthorizationID
ServceAuthLineItmServiceIDIdxserviceID
SevceAuthLineItmToDateIdxtoDate
IND__2017979368nomineeID
IND__1954004384providerID
Operations (16)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: serviceAuthorizationLIID
Creates a new row on ServiceAuthorizationLineItem table. 
readread Reads a row of data from ServiceAuthorizationLineItem table. 
modifymodifyOPTIMISTIC_LOCKING: no
Modifies an existing row on ServiceAuthorizationLineItem table. 
removeremove Removes an existing row from ServiceAuthorizationLineItem table. 
searchByServiceAuthorizationreadmulti Searches the Service Authorization Line Item for the given Service Authorization. 
searchByServiceAndAuthorizedPeriodnsmulti Searches the Service Authorization Line Item by Service Offering Details like Service ID, Service From Date, Service To Date and Service Authorization ID.SQL
searchByServiceProvisionAndCaseParticipantDetailsnsmulti Searches the Service Authorization Line Item by Service Offering Details like Service ID, Service From Date, Service To Date and Case Participant Details like Case ID and Client ID.SQL
searchByServicereadmulti Searches the Service Authorization Line Item for the given Service ID. 
searchByServiceAndClientnsmulti Searches the Service Authorization Line Item for the given Service and Client.SQL
searchByServiceAndCaseParticipantRolensmulti Searches the Service Authorization Line Item for the given Service, Case and Client.SQL
searchByServiceAndStatusnsmulti Searches for all service authorization line items for a particular service offering. The method also ensures that provider details is mentioned in the service authorization line item and provider and service authorization line item conforms to passed status.SQL
searchByServiceAndStatusAndDateRangensmulti Searches for all service authorization line items for a particular service by given date range and status.SQL
searchByParticipantRoleServiceStatusAndDateRangensmulti  SQL
searchByProviderServiceStatusAndDateRangereadmultiWHERE: SERVICEAUTHORIZATIONLINEITEM.PROVIDERID =:providerID AND SERVICEAUTHORIZATIONLINEITEM.SERVICEID =:serviceID AND SERVICEAUTHORIZATIONLINEITEM.RECORDSTATUS =:recordStatus AND ( ( ServiceAuthorizationLineItem.fromDate >= :fromDate AND ServiceAuthorizationLineItem.toDate <= :toDate ) OR ( ServiceAuthorizationLineItem.fromDate <= :fromDate AND ServiceAuthorizationLineItem.toDate >= :toDate ) OR (ServiceAuthorizationLineItem.fromDate <= :fromDate AND ServiceAuthorizationLineItem.toDate >= :fromDate) OR ( ServiceAuthorizationLineItem.fromDate <= :toDate AND ServiceAuthorizationLineItem.toDate >= :toDate ))
Searches for all active service authorization line items for given service and provider having their date within given date range. 
searchBySAAndDateRangensreadmultiWHERE: ServiceAuthorizationLineItem.serviceAuthorizationID = :serviceAuthorizationID AND ServiceAuthorizationLineItem.fromDate > :toDate
Searches for all service authorization line items for a particular service by given date range and status. 
searchByServiceAuthorizationAndStatusreadmulti Searches the Service Authorization Line Item for the given Service Authorization. 
Related Pages (193)
) (OutcomePlanService_viewContextPanel)
New Line Item (ProviderManagement_addClientToRoster)
Record Attendance (ProviderManagement_addDailyAttendance)
Record Attendance (ProviderManagement_addDailyAttendanceCorrection)
Record Attendance (ProviderManagement_addDailyAttendanceForFacilityManager)
Daily Attendance Details (ProviderManagement_addDailyAttendanceForPRLI)
Daily Attendance Details (ProviderManagement_addDailyAttendanceForPRLIReporting)
Record Attendance (ProviderManagement_addDailyAttendanceForReporting)
Daily Attendance Details (ProviderManagement_addDailyAttendanceFromExceptionTask)
New Text Translation (ProviderManagement_addDescriptionTranslationToServiceOffering)
New Text Translation (ProviderManagement_addNameTranslationToServiceOffering)
Add Service Authorization Line Item: (ProviderManagement_addSampleServiceAuthorizationLineItem)
Daily Attendance Details (ProviderManagement_addServiceDailyAttendanceForPRLI)
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 All Line Items (ProviderManagement_approveAllRosterLineItems)
Approve Line Item (ProviderManagement_approveLineItemCorrections)
Provider Roster Line Item (ProviderManagement_approveordenyPRLI)
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 Roster Line Item (ProviderManagement_approveRosterLineItem)
Approve Roster Line Item (ProviderManagement_approveRosterLineItemFromTask)
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)
Cancel Roster Line Item (ProviderManagement_cancelRosterLineItem)
Delete Service Authorization: (ProviderManagement_cancelServiceAuthorization)
Delete Service Authorization Line Item: (ProviderManagement_cancelServiceAuthorizationLineItem)
Delete Line Item (ProviderManagement_cancelServiceInvoiceLineItem)
Cancel Service Invoice Line Items (ProviderManagement_cancelServiceInvoiceLineItems)
Delete Service (ProviderManagement_cancelServiceOfferingFrmList)
Delete Service (ProviderManagement_cancelServiceOfferingFrmServiceGroup)
Delete Service (ProviderManagement_cancelServiceOfferingFromSearch)
Cancel Service Invoice Line Item (ProviderManagement_cancelSILIFromTask)
Delete Service (ProviderManagement_cancelTrainingServiceOffering)
Close Service Authorization Line Item: (ProviderManagement_closeServiceAuthorizationLineItem)
Approve Line Items (ProviderManagement_confirmApproveServiceInvoiceLineItems)
Confirm cancel overlapping reservations (ProviderManagement_confirmCancelOverlappingActiveResForAnyClient)
Confirm Modify Overlapping Placements (ProviderManagement_confirmModifyOverlappingPlacementPrd)
Confirm modify overlapping placements (ProviderManagement_confirmModifyPlacementPrdForWL)
Submit Roster (ProviderManagement_confirmSubmitRoster)
Submit Roster (ProviderManagement_confirmSubmitRosterForFacilityManager)
Submit Line Item (ProviderManagement_confirmSubmitRosterLineItem)
Submit Line Items (ProviderManagement_confirmSubmitServiceInvoiceLineItems)
Confirm Transfer of Placement to Reservation (ProviderManagement_confirmTransferToReservation)
Edit Line Item (ProviderManagement_correctAttendancePRLIWithMultipleClients)
Correct Roster Line Item (ProviderManagement_correctPRLI)
Edit Line Item (ProviderManagement_correctPRLIWithMultipleClients)
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)
Delete Roster Line Item (ProviderManagement_deletePRLIFromExceptionTask)
Delete Roster (ProviderManagement_deleteRoster)
Delete Line Item (ProviderManagement_deleteRosterLineItem)
Delete Placement (ProviderManagement_deleteSamplePlacement)
Deny Roster Line Item (ProviderManagement_denyPRLIFromExceptionTask)
Deny Roster Line Item (ProviderManagement_denyRosterLineItem)
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)
Payment Details: (ProviderManagement_listILIDetailsForProvider)
Payment Details: (ProviderManagement_listILIDetailsForProviderGroup)
Performance Measures (ProviderManagement_listPOPerformanceMeasures)
Performance Measures (ProviderManagement_listProviderPerformanceMeasures)
Attendance (ProviderManagement_listServiceAttendance)
Invoices (ProviderManagement_listServiceInvoices)
Transactions (ProviderManagement_listServicePayments)
Payment Details: (ProviderManagement_listSIPaymentForProvider)
Payment Details: (ProviderManagement_listSIPaymentForProviderGroup)
Record Attendance (ProviderManagement_maintainDailyAttendanceCorrectionForAttendanceMethod)
Modify Client (ProviderManagement_modifyClientInPRLICorrection)
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)
Update Roster Line Item (ProviderManagement_modifyPRLIFromExceptionTask)
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)
No Match Task Action (ProviderManagement_processRosterLineItemException)
No Match Task Action (ProviderManagement_processSILIException)
Related Authorizations (ProviderManagement_relatedServiceAuthorizationLineItems)
Remove Client (ProviderManagement_removeClientFromServiceInvoiceLineItem)
Remove Client (ProviderManagement_removeClientFromSILICorrection)
Renew Contract (ProviderManagement_renewContract)
Renew Contract (ProviderManagement_renewProviderGroupContract)
Retrieve Payment Information For Service Authorization: (ProviderManagement_sampleRetrievePaymentInformationForServiceAuthorization)
Submit Line Item (ProviderManagement_submitOpenSILIForProcessing)
Submit Line Item (ProviderManagement_submitPRLICorrection)
Submit Roster Line Item (ProviderManagement_submitPRLIFromExceptionTask)
Submit Roster (ProviderManagement_submitRoster)
Submit Roster (ProviderManagement_submitRosterForFacilityManager)
Submit Line Item (ProviderManagement_submitRosterLineItem)
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 Client (ProviderManagement_transferClient)
Transfer Placement to Another Case (ProviderManagement_transferSamplePlacementToAnotherCase)
Reassessment Details (ProviderManagement_triggerReassessment)
Edit Line Item (ProviderManagement_updateAttendancePRLICorrection)
Edit Line Item (ProviderManagement_updateAttendanceRosterLineItem)
Edit Line Item (ProviderManagement_updatePRLICorrection)
Edit Line Item (ProviderManagement_updateRLIClientInfo)
Update Roster Line Item (ProviderManagement_updateRLIClientInfoFrmET)
Edit Line Item (ProviderManagement_updateRosterLineItem)
Update Roster Line Item (ProviderManagement_updateRosterLineItemFrmET)
Update Placement Period (ProviderManagement_updateSamplePlacementPeriod)
Current Performance (ProviderManagement_viewActualContractPerformanceMeasure)
Current Performance (ProviderManagement_viewActualServiceContractPerformanceMeasure)
View Line Item (ProviderManagement_viewAttendanceRosterLineItem)
View Completed Line Item (ProviderManagement_viewCompletedAttendanceRLI)
View Completed Line Item (ProviderManagement_viewCompletedRLI)
Completed Line Item (ProviderManagement_viewCompleteServiceInvoiceLineItem)
View Line Item (ProviderManagement_viewEPRosterLineItem)
ProviderManagement_viewEPServiceInvoiceLineItem
View Service Invoice Line Item: (ProviderManagement_viewInsertServiceInvoiceLineItem)
View Roster Line Item: (ProviderManagement_viewRelatedRosterLineItem)
View Line Item (ProviderManagement_viewRosterLineItem)
View Roster Line Item: (ProviderManagement_viewRosterLineItemFrmTask)
View Roster Line Item: (ProviderManagement_viewRosterLineItemFromAttendancePayments)
View Message for Roster Line Item (ProviderManagement_viewRosterLineItemInfoMessages)
View Service Authorization Line Item (ProviderManagement_viewSALIForSILIAdjustmentFactor)
View Service Authorization: (ProviderManagement_viewSampleServiceAuthorization)
Service Authorization Budget Information: (ProviderManagement_viewSampleServiceAuthorizationBudgetInformation)
Service Authorization Line Items: (ProviderManagement_viewSampleServiceAuthorizationLineItems)
Service Authorization List: (ProviderManagement_viewSampleServiceAuthorizations)
View Service Authorization Line Item: (ProviderManagement_viewSamplesServiceAuthorizationLineItem)
Service Authorization (ProviderManagement_viewServiceAuthorization)
Authorization Budget (ProviderManagement_viewServiceAuthorizationBudgetInformation)
View Service Authorization Line Item (ProviderManagement_viewServiceAuthorizationLineItem)
Authorization Line Items (ProviderManagement_viewServiceAuthorizationLineItems)
View Service Authorization: (ProviderManagement_viewServiceAuthorizationTabDetails)
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)
View Details: (ProviderManagement_viewServiceInvoiceRequestLineItem)
) (ProviderManagement_viewServiceSummaryDetails)
View Service Invoice Type Payment Detail for Provider: (ProviderManagement_viewSIPaymentForProvider)
View Service Invoice Type Payment Detail for Provider Group: (ProviderManagement_viewSIPaymentForProviderGroup)
Over and Under Payments (ServiceDelivery_listOverUnderPayment)
Attendance (ServiceDelivery_listServiceAttendance)
Invoices (ServiceDelivery_listServiceInvoices)
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)
Delete Plan Item : (ServicePlanDelivery_removePlanItem)