Table Description
RosterLineItem: Information about actual units delivered to a client for a service on a roster.

A roster line item is specific to a client who receives service on a Attendance Roster. A Roster Line Item records units for roster period for a concern Role.

Example

An Attendance Roster is created for Child Care service. A child was scheduled to receive 64 units of Child Care for the period 01/05/2008-08/05/2008 but he/she received 62 units. The actual units are recorded as 62 for this 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::Core::Reference Model::Service Layer::AttendanceTracking::Roster Line Item::Entity::RosterLineItem
Controlling File: core\model\Packages\Reference Model\Service Layer\Attendance Tracking\Roster Line Item\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (8)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
rosterLineItemIDkeynoThe unique system generated identifier for the roster line item.ROSTER_LINE_ITEM_ID SVR_INT64
referenceNodetailsnoA reference number assigned by the organization to a roster line item to uniquely identify it.REFERENCE_NO SVR_STRING<18>
concernRoleIDdetailsyesThe unique system generated identifier for the person.CONCERN_ROLE_ID SVR_INT64
expectedUnitsdetailsyesNumber of units of a service which are expected to be delivered to a client in the roster period.ATTENDANCE_UNITS SVR_INT16
totalUnitsDelivereddetailsyesThe total number of units of the service that were delivered to the client for that period.ATTENDANCE_UNITS SVR_INT16
rosterIDdetailsnoAttendance roster ID from roster table to which the roster line item belongs to.ROSTER_ID SVR_INT64
serviceFromdetails The start date of the period of the service delivery for which attendance has been recorded.CURAM_DATE SVR_DATE
serviceTodetails =The end date of the period of the service delivery for which the attendance has been recorded.CURAM_DATE SVR_DATE
Foreign Keys (7)
ChildParent
RosterLineItem.concernRoleIDConcernRole.concernRoleID
RosterLineItem.rosterIDRoster.rosterID
AbsencePeriod.rosterLineItemIDRosterLineItem.rosterLineItemID
DailyAttendance.rosterLineItemIDRosterLineItem.rosterLineItemID
ProviderRosterLineItem.rosterLineItemIDRosterLineItem.rosterLineItemID
RosterLineItemClient.rosterLineItemIDRosterLineItem.rosterLineItemID
RosterLineItemHistory.rosterLineItemIDRosterLineItem.rosterLineItemID
Indices (2)
Index NameAttributes
RosterLineItemRosterIDIdxrosterID
IND__1255530940concernRoleID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: rosterLineItemID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
searchByRosterIDreadmulti Returns the roster line items associated to specific roaster. 
Related Pages (254)
Record Absence (ProviderManagement_addAbsenceReason)
New Absence Reason (ProviderManagement_addAbsenceReasonForPRLI)
Add Absence Reason (ProviderManagement_addAbsenceReasonFromExceptionTask)
New Client (ProviderManagement_addClientToPRLI)
Add Client (ProviderManagement_addClientToPRLICorrection)
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 delete rows from daily attendance roster (ProviderManagement_confirmDeleteDARosterRows)
Confirm delete rows from daily attendance roster (ProviderManagement_confirmDeleteDARosterRowsFrmET)
Restore Original Data (ProviderManagement_confirmDeletePRLICorrection)
Confirm delete rows from daily attendance roster (ProviderManagement_confirmDeleteRowsForDARoster)
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 Attendance Payment Configuration (ProviderManagement_createSOAttendancePayment)
New Training Service (ProviderManagement_createTrainingServiceOffering)
New Utilization Contract (ProviderManagement_createUtilizationContractForProvider)
New Rate (ProviderManagement_createUtilizationContractProviderOfferingRate)
Delete Service (ProviderManagement_deleteContractProviderOffering)
Delete Service (ProviderManagement_deleteContractProviderOfferingForProviderGroup)
Delete Roster Line Item (ProviderManagement_deletePRLIFromExceptionTask)
Delete Roster (ProviderManagement_deleteRoster)
Delete Line Item (ProviderManagement_deleteRosterLineItem)
Delete Placement (ProviderManagement_deleteSamplePlacement)
Delete Attendance Payment Configuration (ProviderManagement_deleteSOAttendancePayment)
Delete Contract (ProviderManagement_deleteUtilizationContractForProvider)
Delete Service (ProviderManagement_deleteUtilizationContractProviderOfferingForProvider)
Delete Service (ProviderManagement_deleteUtilizationContractProviderOfferingForProviderGroup)
Restore Original Data (ProviderManagement_denyPRLICorrectionFromView)
Deny Line Item Correction (ProviderManagement_denyPRLICorrections)
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)
View Completed Line Item (ProviderManagement_listAbsenceReasonForCompletedPRLI)
Absences (ProviderManagement_listAbsenceReasonForPRLI)
Absences: (ProviderManagement_listAbsenceReasonForPRLIFrmET)
Payment Details: (ProviderManagement_listAttendancePaymentForProvider)
View Provider Roster Line Item Clients: (ProviderManagement_listClientsForProviderRosterLineItem)
Payment Details: (ProviderManagement_listILIDetailsForProvider)
Payment Details: (ProviderManagement_listILIDetailsForProviderGroup)
Performance Measures (ProviderManagement_listPOPerformanceMeasures)
Performance Measures (ProviderManagement_listProviderPerformanceMeasures)
Rosters (ProviderManagement_listRoster)
Rosters (ProviderManagement_listRosterForFacilityManager)
View Pay Based on Payment Indicator for RLI (Providermanagement_listSamplePayBasedOnAttendanceIndForRLI)
Attendance (ProviderManagement_listServiceAttendance)
Transactions (ProviderManagement_listServicePayments)
List SO Attendance Configuration for RLI (Providermanagement_listSOConfigurationForRLI)
Record Attendance (ProviderManagement_maintainDailyAttendanceCorrectionForAttendanceMethod)
Edit Client (ProviderManagement_modifyClientInPRLI)
Modify Client (ProviderManagement_modifyClientInPRLICorrection)
Edit Service Invoice Line Item (ProviderManagement_modifyEPServiceInvoiceLineItem)
Edit Flat Rate Contract (ProviderManagement_modifyFlatRateContractForProviderGroup)
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 Attendance Payment Configuration (ProviderManagement_modifySOAttendancePayment)
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)
Delete Provider (ProviderManagement_removeProviderFromProviderGroup)
Delete Provider Group (ProviderManagement_removeProviderGroupFromPGAssociation)
Delete Rate (ProviderManagement_removeProviderOfferingRate)
Renew Contract (ProviderManagement_renewContract)
Renew Contract (ProviderManagement_renewProviderGroupContract)
Retrieve Payment Information: (ProviderManagement_sampleRetrievePaymentInformation)
Retrieve Payment Information For Service Authorization: (ProviderManagement_sampleRetrievePaymentInformationForServiceAuthorization)
Retrieve Service Delivery/Utilization Information: (ProviderManagement_sampleRetrieveServiceDeliveryAndUtilizationInfoForCaseParticipant)
Retrieve Service Delivery/Utilization Information: (ProviderManagement_sampleRetrieveServiceDeliveryAndUtilizationInformation)
Roster Line Item Search (ProviderManagement_searchProviderRosterLineItemsForCase)
Roster Line Item Search (ProviderManagement_searchProviderRosterLineItemsForClient)
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 Attendance Roster (ProviderManagement_updateAttendanceRoster)
Edit Line Item (ProviderManagement_updateAttendanceRosterLineItem)
Edit Line Item (ProviderManagement_updatePRLICorrection)
Edit Line Item (ProviderManagement_updateRLIClientInfo)
Update Roster Line Item (ProviderManagement_updateRLIClientInfoFrmET)
Edit Line Items (ProviderManagement_updateRoster)
Edit Roster (ProviderManagement_updateRosterForFacilityManager)
Edit Line Item (ProviderManagement_updateRosterLineItem)
Update Roster Line Item (ProviderManagement_updateRosterLineItemFrmET)
Update Placement Period (ProviderManagement_updateSamplePlacementPeriod)
Absence History (ProviderManagement_viewAbsenceCorrectionHistory)
Absence History (ProviderManagement_viewAbsenceHistory)
Current Performance (ProviderManagement_viewActualContractPerformanceMeasure)
Current Performance (ProviderManagement_viewActualServiceContractPerformanceMeasure)
View Attendance Type Payment Detail for Provider: (ProviderManagement_viewAttendancePaymentForProvider)
View Attendance Type Payment Detail for Provider Group: (ProviderManagement_viewAttendancePaymentForProviderGroup)
Transactions (ProviderManagement_viewAttendancePaymentTransactionForPG)
Transactions (ProviderManagement_viewAttendancePaymentTransactionForProvider)
Line Item History (ProviderManagement_viewAttendanceRLIStatusHistory)
Roster Line Item Transactions: (ProviderManagement_viewAttendanceRLITransactions)
View Roster (ProviderManagement_viewAttendanceRoster)
ProviderManagement_viewAttendanceRosterForFacilityManager
View Line Item (ProviderManagement_viewAttendanceRosterLineItem)
View Completed Line Item (ProviderManagement_viewCompletedAttendanceRLI)
View Completed Line Item (ProviderManagement_viewCompletedRLI)
Completed Line Item (ProviderManagement_viewCompleteServiceInvoiceLineItem)
Daily Attendance History (ProviderManagement_viewDACorrectionHistoryForReporting)
View Daily Attendance (ProviderManagement_viewDailyAttendance)
View Daily Attendance (ProviderManagement_viewDailyAttendanceCorrection)
Daily Attendance History (ProviderManagement_viewDailyAttendanceCorrectionHistory)
View Daily Attendance (ProviderManagement_viewDailyAttendanceDetailsForReporting)
View Completed Line Item (ProviderManagement_viewDailyAttendanceForCompletedAttendanceRLI)
View Completed Line Item (ProviderManagement_viewDailyAttendanceForCompletedRLI)
View Daily Attendance: (ProviderManagement_viewDailyAttendanceFrmET)
Daily Attendance History (ProviderManagement_viewDailyAttendanceHistory)
Daily Attendance History (ProviderManagement_viewDailyAttendanceHistoryForReporting)
View Line Item (ProviderManagement_viewEPRosterLineItem)
ProviderManagement_viewEPServiceInvoiceLineItem
View Service Invoice Line Item: (ProviderManagement_viewInsertServiceInvoiceLineItem)
View Line Item (ProviderManagement_viewPRLICorrection)
View Roster Line Item Correction (ProviderManagement_viewPRLICorrectionFromTask)
View Roster Line Item: (ProviderManagement_viewRelatedRosterLineItem)
View Roster (ProviderManagement_viewRoster)
ProviderManagement_viewRosterForFacilityManager
View Line Item (ProviderManagement_viewRosterLineItem)
Line Item History (ProviderManagement_viewRosterLineItemCorrectionStatusHistory)
Roster Line Item Transactions (ProviderManagement_viewRosterLineItemCorrectionTransactions)
View Roster Line Item: (ProviderManagement_viewRosterLineItemFrmTask)
View Roster Line Item: (ProviderManagement_viewRosterLineItemFromAttendancePayments)
View Message for Roster Line Item (ProviderManagement_viewRosterLineItemInfoMessages)
Roster Line Item History (ProviderManagement_viewRosterLineItemStatusHistory)
Roster Line Item Transactions (ProviderManagement_viewRosterLineItemTransactions)
View Service Authorization Line Item (ProviderManagement_viewSALIForSILIAdjustmentFactor)
View Daily Attendance: (ProviderManagement_viewSampleDailyAttendance)
View Service Authorization: (ProviderManagement_viewSampleServiceAuthorization)
Service Authorization Line Items: (ProviderManagement_viewSampleServiceAuthorizationLineItems)
Service Authorization List: (ProviderManagement_viewSampleServiceAuthorizations)
View Service Authorization Line Item: (ProviderManagement_viewSamplesServiceAuthorizationLineItem)
Service Authorization (ProviderManagement_viewServiceAuthorization)
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 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)
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)