Table Description
Provider Roster Line Item History: A history of the changes made to a provider roster line item.

A history of the status and changes made to an individual provider roster line item. Changes can result from the correction of a roster line item that has already been processed, or as a result of a change to a roster line item that has modified during processing.

Example

For example, when a provider roster line item is submitted for processing, its status changes to 'Pending Approval' or 'Complete'. This status change is captured in Provider Roster Line Item Status History.
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::Attendance Tracking::Roster::Entity::PRLIHistory
Controlling File: CPM\model\Packages\Service Layer\Attendance Tracking\Roster\Entity\Entity_cat.efx
Attributes (16)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
prliHistoryIDkeynoThe unique system generated identifier for the provider roster line item history record.PRLI_HISTORY_ID SVR_INT64
providerRosterLineItemIDdetailsnoThe unique system generated identifier for the provider roster line item record.PROVIDER_ROSTER_LINE_ITEM_ID SVR_INT64
rosterLineItemHistoryIDdetailsnoThe unique system generated identifier for the roster line item record.ROSTER_LINE_ITEM_HISTORY_ID SVR_INT64
addressIDdetailsyesThe unique system generated identifier for the address record.ADDRESS_ID SVR_INT64
clientReferenceNodetailsyesThe reference number of the client to whom the service was delivered.REFERENCE_NUMBER SVR_STRING<20>
clientFirstNamedetailsyesThe first name of the client to whom the service was delivered.FIRST_FORENAME SVR_STRING<65>
clientLastNamedetailsyesThe last name of the client to whom the service was delivered.SURNAME SVR_STRING<65>
clientDOBdetailsyesThe date of birth of the client to whom the service was delivered.CURAM_DATE SVR_DATE
caseReferenceNodetailsyesThe reference number of the case for which the client is receiving the service.CASE_REFERENCE SVR_STRING<40>
saReferenceNodetailsyesThe reference number of the service authorization that authorizes payment for a service delivered to a client.SERVICE_AUTHORIZATION_REFERENCE_NUMBER SVR_STRING<20>
voucherNumberdetailsyesA number assigned to the voucher that has been issued to the client and which authorizes the client to receive services.VOUCHER_NUMBER SVR_STRING<20>
denialReasondetailsyesThe reason for which a roster line item was denied.PRLI_DENIAL_REASONPRLIDenialReasonSVR_STRING<10>
cancelationReasondetailsyesThe reason for which a roster line item was canceled.PRLI_CANCEL_REASONPRLICancelationReasonSVR_STRING<10>
statusdetailsnoThe status of the Provider Roster Line Item for which the history was captured.PROVIDER_ROSTER_LINE_ITEM_STATUSPRLIStatusSVR_STRING<10>
prliCorrectionIDdetailsyesThe unique system generated identifier for the provider roster line item correction record.PRLI_CORRECTION_ID SVR_INT64
correctionReasondetailsyesThe reason for which roster line item is being corrected.COMMENTS SVR_STRING<300>
Foreign Keys (5)
ChildParent
PRLIHistory.addressIDAddress.addressID
PRLIHistory.prliCorrectionIDPRLICorrection.prliCorrectionID
PRLIHistory.providerRosterLineItemIDProviderRosterLineItem.providerRosterLineItemID
PRLIHistory.rosterLineItemHistoryIDRosterLineItemHistory.rosterLineItemHistoryID
PRLIClientHistory.prliHistoryIDPRLIHistory.prliHistoryID
Indices (4)
Index NameAttributes
PRLIHistryPRLICorrectnIDIdxprliCorrectionID
PRLIHistoryPRLIIDIdxproviderRosterLineItemID
PRLIHistoryRLIHistoryIDIdxrosterLineItemHistoryID
IND_1004654821addressID
Operations (3)
OperationStereotypeOptionsDescriptionSQL
readread Standard Operation 
searchByPRLIIDreadmulti Searches for Provider Roster Line Item Status History for a Provider Roster Line Item. 
insertinsertAUTO_ID: prliHistoryID
Standard Operation 
Related Pages (88)
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)
Add Service Authorization Line Item: (ProviderManagement_addSampleServiceAuthorizationLineItem)
Daily Attendance Details (ProviderManagement_addServiceDailyAttendanceForPRLI)
Approve All Line Items (ProviderManagement_approveAllRosterLineItems)
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)
Cancel Roster Line Item (ProviderManagement_cancelRosterLineItem)
Delete Service Authorization Line Item: (ProviderManagement_cancelServiceAuthorizationLineItem)
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)
Edit Line Item (ProviderManagement_correctAttendancePRLIWithMultipleClients)
Correct Roster Line Item (ProviderManagement_correctPRLI)
Edit Line Item (ProviderManagement_correctPRLIWithMultipleClients)
Create Emergency Placement (ProviderManagement_createSampleEmergencyPlacement)
Create Service Authorization Line Items (ProviderManagement_createSampleSAWithSALI)
Delete Roster Line Item (ProviderManagement_deletePRLIFromExceptionTask)
Delete Roster (ProviderManagement_deleteRoster)
Delete Line Item (ProviderManagement_deleteRosterLineItem)
Delete Placement (ProviderManagement_deleteSamplePlacement)
Restore Original Data (ProviderManagement_denyPRLICorrectionFromView)
Deny Line Item Correction (ProviderManagement_denyPRLICorrections)
Deny Roster Line Item (ProviderManagement_denyPRLIFromExceptionTask)
Deny Roster Line Item (ProviderManagement_denyRosterLineItem)
Record Attendance (ProviderManagement_maintainDailyAttendanceCorrectionForAttendanceMethod)
Edit Client (ProviderManagement_modifyClientInPRLI)
Modify Client (ProviderManagement_modifyClientInPRLICorrection)
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)
Confirm Placement: (ProviderManagement_modifySamplePlaceDuringConfirmation)
Modify Service Authorization Line Item: (ProviderManagement_modifySampleServiceAuthorizationLineItem)
Place Client (ProviderManagement_placeSampleClient)
Submit Line Item (ProviderManagement_submitPRLICorrection)
Submit Roster Line Item (ProviderManagement_submitPRLIFromExceptionTask)
Submit Roster (ProviderManagement_submitRoster)
Submit Roster (ProviderManagement_submitRosterForFacilityManager)
Submit Line Item (ProviderManagement_submitRosterLineItem)
Transfer Placement to Another Case (ProviderManagement_transferSamplePlacementToAnotherCase)
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)
View Line Item Modifications (ProviderManagement_viewAttendanceRLIModifications)
Line Item History (ProviderManagement_viewAttendanceRLIStatusHistory)
View Client (ProviderManagement_viewClientInPRLIHistory)
Daily Attendance History (ProviderManagement_viewDACorrectionHistoryForReporting)
Daily Attendance History (ProviderManagement_viewDailyAttendanceCorrectionHistory)
Daily Attendance History (ProviderManagement_viewDailyAttendanceHistory)
Daily Attendance History (ProviderManagement_viewDailyAttendanceHistoryForReporting)
Line Item History (ProviderManagement_viewRosterLineItemCorrectionStatusHistory)
View Roster Line Item Modifications (ProviderManagement_viewRosterLineItemModifications)
Roster Line Item History (ProviderManagement_viewRosterLineItemStatusHistory)
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)