Database Table: ServiceDeliveryStatusHistory
| Service Delivery Status History:
A history of service states changes.
When a service is first created the status of the service is 'Open'. The service is then submitted by the case worker and if approval is required the status is 'Submitted'. If approval is not required, the status of the service is 'In Progress' if the start date of the service is effective or 'Not Started' if the start date is in the future. When the client completes the service the status of the service is 'Completed'. This entity stores a record of each of these state changes.
Example James Smith was assessed for substance abuse issues and as a result the case worker scheduled 10 sessions of counseling from 01/01/2011 to 02/15/2011 provided by Dr. John Kelly. An authorized rate of $50 per session was specified. The service is submitted for approval and the status is set to submitted as rates specified by a case worker must always be approved by a supervisor which sets the status of the service to 'Not Started'. The supervisor approves the service. This table stores a history record for the states of 'Open', 'Submitted' and 'Not Started'.
|
|
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
|
|
|
| Location in Model: | Logical View::MetaModel::Curam::CPM::Service Layer::ServiceDelivery::ServiceDelivery::Entity::ServiceDeliveryStatusHistory |
| Controlling File: | CPM\model\Packages\Service Layer\Service Delivery\ServiceDelivery.efx |
| Index Name | Attributes |
| ServDelStatHsServDelivryIDIdx | serviceDeliveryID |
|
| Operation | Stereotype | Options | Description | SQL |
| insert | insert | AUTO_ID: serviceDeliveryStatusHistoryID
| Standard Operation | |
| modify | modify | | Standard Operation | |
| read | read | | Standard Operation | |
| searchByServiceDelivery | readmulti | ORDER_BY: effectiveDateTime
| Returns a list of service delivery status history records for the specified service delivery. | |
|
