Table Description
Compartment: Logical grouping of the smaller units such as beds Within a provider facility.

A placement service involves placing a client physically with the provider for a period of time. For example, depending on the placement service the placement may be to a bed in a foster home, a room in a women's shelter, a cell in a juvenile detention unit. Within a provider facility, the smaller units such as beds may be logically grouped into compartments.

Example

The foster home is set up as the high level compartment, with the bedrooms as compartments within it and beds added as places within the rooms.

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::Place Management::Compartment::Entity::Compartment
Controlling File: CPM\model\Packages\Service Layer\Place Mangement\Compartment\Compartment_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (11)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
compartmentIDkeynoThe unique system generated identifier for the compartment record.INTERNAL_ID SVR_INT64
providerConcernRoleIDdetailsnoThe unique system generated identifier for the provider.CONCERN_ID SVR_INT64
namedetails Name of the compartment. For example, Lake County Detention Services has four buildings as compartments - Building A, Building B, Building C and Building D.CPM_COMMON_NAME SVR_STRING<56>
descriptiondetails A description of the compartmentADDITIONAL_INFORMATION SVR_STRING<200>
dateCreateddetails The date the compartment was created in the system.CURAM_DATE SVR_DATE
dateCloseddetails The date on which the compartment and the child compartments along with the places within the compartment were closed.CURAM_DATE SVR_DATE
recordStatusdetails The status is used to indicate if the compartment has been logically deleted or closed.COMPARTMENT_STATUSCompartmentStatusSVR_STRING<10>
parentCompartmentIDdetails The unique system generated identifier for the parent compartment.INTERNAL_ID SVR_INT64
commentsdetails Comments recorded by a user relating to the compartment.COMMENTS SVR_STRING<300>
dateTimeCreateddetailsyesThe date the compartment was created in the system.CURAM_DATETIME SVR_DATETIME
dateTimeCloseddetailsyesThe date on which the compartment and the child compartments along with the places within the compartment were closed.CURAM_DATETIME SVR_DATETIME
Foreign Keys (5)
ChildParent
Compartment.providerConcernRoleIDProvider.providerConcernRoleID
DerivedCompCharacteristic.compartmentIDCompartment.compartmentID
Place.compartmentIDCompartment.compartmentID
PlacementCharacteristic.compartmentIDCompartment.compartmentID
ProviderIncident.compartmentIDCompartment.compartmentID
Indices (3)
Index NameAttributes
CompartmentIndex1parentCompartmentID
CompartmentIndex2compartmentID, providerConcernRoleID
CompartmentIndex3providerConcernRoleID
Operations (9)
OperationStereotypeOptionsDescriptionSQL
readread Reads a row of data from Compartment table. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies an existing row on Compartment table. 
insertinsertAUTO_ID: compartmentID
Creates a new row on Compartment table. 
removeremove Removes an existing row from Compartment table. 
searchChildrenreadmultiREADMULTI_LIM: 0
Searches all children of the compartment. 
searchAllCompartmentsForProviderreadmultiORDER_BY: name
READMULTI_LIM: 0
Searches immediate children of compartment. 
searchOtherCompartmentsForProviderreadmultiREADMULTI_LIM: 0
WHERE: Compartment.providerConcernRoleID = :providerConcernRoleID AND Compartment.compartmentID <> :compartmentID
Searches all the compartments for the provider. 
searchActiveParentCompartmentForProviderreadmultiREADMULTI_LIM: 0
WHERE: Compartment.parentCompartmentID is NULL AND (Compartment.dateClosed IS NULL OR Compartment.dateClosed <> :currentDate ) AND Compartment.recordStatus = :recordStatus AND Compartment.providerConcernRoleID = :providerConcernRoleID
Gets the active parent compartment for a provider. 
searchChildCompartmentIDsnsreadmultiWHERE: parentCompartmentID = :compartmentID
Fetches the child comparment IDs of a given parent compartment. 
Related Pages (115)
New Ethnicity (ProviderManagement_addEthnicityCharacteristic)
Add Existing Places (ProviderManagement_addExistingPlaces)
Add Existing Places (ProviderManagement_addExistingPlaces1)
New Gang Affiliation (ProviderManagement_addGangAffiliationCharacteristic)
New Incident Participant (ProviderManagement_addIncidentParticipant)
New Language (ProviderManagement_addLanguageCharacteristic)
New Religion (ProviderManagement_addReligionCharacteristic)
Add Service Authorization Line Item: (ProviderManagement_addSampleServiceAuthorizationLineItem)
Delete Place (ProviderManagement_cancelPlace)
Cancel Reservation (ProviderManagement_cancelReservation)
Close Compartment (ProviderManagement_closeCompartment)
Compartment View (ProviderManagement_compartmentTreeWindow)
Confirm cancel overlapping reservations (ProviderManagement_confirmCancelOverlappingActiveRes)
Confirm cancel overlapping reservations (ProviderManagement_confirmCancelOverlappingActiveResForAnyClient)
Confirm Modify Overlapping Placements (ProviderManagement_confirmModifyOverlappingPlacementPrd)
Confirm modify overlapping placements (ProviderManagement_confirmModifyPlacementPrdForWL)
Confirm Transfer of Placement to Reservation (ProviderManagement_confirmTransferToReservation)
New Compartment (ProviderManagement_createCompartment)
New Characteristics (ProviderManagement_createCompartmentCharacteristics)
New Place (ProviderManagement_createPlace)
Create Emergency Placement (ProviderManagement_createSampleEmergencyPlacement)
Create Reservation (ProviderManagement_createSampleReservation)
Create Service Authorization Line Items (ProviderManagement_createSampleSAWithSALI)
Delete Compartment (ProviderManagement_deleteCompartment)
Delete Placement (ProviderManagement_deleteSamplePlacement)
Step 5: Register Person (ProviderManagement_duplicateRegisterPersonAsProvider)
Enroll Provider (ProviderManagement_enrollAsProvider)
Enroll Provider (ProviderManagement_enrollProvider)
Transfer to Provider (ProviderManagement_enrollProviderFromEnquiry)
Participants (ProviderManagement_IncidentParticipants)
Participants (ProviderManagement_IncidentParticipantsForPG)
Deductions (ProviderManagement_listActiveDeductionForProvider)
Placements (ProviderManagement_listAllProviderPlacements)
Applied and Un-applied Deductions: (ProviderManagement_listAppliedUnappliedDeductionForProvider)
ProviderManagement_listExternalAccessRequestsForResMgr
Incidents (ProviderManagement_listIncidentForProvider)
Incidents (ProviderManagement_listIncidentForProviderGroup)
Incidents (ProviderManagement_listIncidentForProviderMember)
Places (ProviderManagement_listOccupiedPlaces)
Incidents (ProviderManagement_listProviderIncidents)
Incidents (ProviderManagement_listProviderIncidentsModal)
Incidents (ProviderManagement_listReferralProviderIncidents)
Submitted External Access Requests (ProviderManagement_listRequestsForResourceManagerSupervisor)
Third Party Deductions: (ProviderManagement_listThirdPartyDeductionForProvider)
Mark All Places For Use (ProviderManagement_markAllPlacesForUse)
Mark All Places Out Of Use (ProviderManagement_markAllPlacesOutOfUse)
Mark for Use (ProviderManagement_markPlaceInUse)
Mark Out Of Use (ProviderManagement_markPlaceOutOfUse)
Edit Compartment (ProviderManagement_modifyCompartment)
Edit Characteristics (ProviderManagement_modifyCompartmentCharacteristics)
Edit Provider Incident (ProviderManagement_modifyIncident)
Edit Place (ProviderManagement_modifyPlace)
Confirm Placement (ProviderManagement_modifyPlaceDuringConfirmation)
Edit Reservation (ProviderManagement_modifyPlaceForReservationFrmCompartment)
Edit Reservation (ProviderManagement_modifyPlaceForReservationFrmPlace)
Edit Reservation (ProviderManagement_modifyPlaceForReservationFromList)
Edit Reservation (ProviderManagement_modifyPlaceForReservationFromView)
Edit Placement (ProviderManagement_modifyPlacementDetails)
Modify Placement Information (ProviderManagement_modifyPlacementInformation)
Confirm Cancel Reservation (ProviderManagement_modifyPlacementInformationConfirmCancelReservation)
Allocate Place (ProviderManagement_modifyPlaceProviderOfferingAllocate)
Allocate Place (ProviderManagement_modifyPrdForAllocatePOWaitList)
Allocate Place (ProviderManagement_modifyPrdForAllocateProviderWaitList)
Edit Provider Details (ProviderManagement_modifyProvider)
Edit Reservation (ProviderManagement_modifyReservation)
Edit Reservation (ProviderManagement_modifyReservationFrmCompartment)
Edit Reservation (ProviderManagement_modifyReservationFrmPlace)
Edit Reservation (ProviderManagement_modifyReservationPeriodAndServiceFromList)
Modify Reservation (ProviderManagement_modifyReservationPeriodAndServiceFromView)
Confirm Placement (ProviderManagement_modifyResPeriodDuringConfirmation)
Confirm Placement: (ProviderManagement_modifySamplePlaceDuringConfirmation)
Confirm Placement: (ProviderManagement_modifySampleResPeriodDuringConfirmation)
Modify Service Authorization Line Item: (ProviderManagement_modifySampleServiceAuthorizationLineItem)
Place Client (ProviderManagement_placeSampleClient)
Search Place (ProviderManagement_placeSearchCriteria)
Home (ProviderManagement_providerHome)
Home (ProviderManagement_providerHomeForFacilityManager)
ProviderManagement_providerHomeTabDetailsPreview
New Provider Incident (ProviderManagement_recordIncidentForProvider)
Register As Person (ProviderManagement_registerProviderAsPersonFrmProviderHome)
Step 2: Enroll Provider (ProviderManagement_sampleEnrollProvider)
Select Compartment (ProviderManagement_searchActiveCompartmentForProvider)
Search Available Places (ProviderManagement_searchAvailablePlaces)
) (ProviderManagement_searchAvailablePlacesForReservation)
Available Places (ProviderManagement_searchAvailablePlacesForWaitList)
ProviderManagement_searchExternalAccessRequests
External Access Request Search (ProviderManagement_searchRequestsForSupervisor)
Search Available Places: (ProviderManagement_searchSampleAvailablePlaces)
Override Maximum Deduction Rate (ProviderManagement_setOverrideMDR)
Transfer Client (ProviderManagement_transferClient)
Transfer Placement to Another Case (ProviderManagement_transferSamplePlacementToAnotherCase)
Override Maximum Deduction Rate (ProviderManagement_unsetOverrideMDR)
Update Placement Period (ProviderManagement_updateSamplePlacementPeriod)
Places (ProviderManagement_viewAllPlaces)
ProviderManagement_viewCompartment
Home (ProviderManagement_viewExternalAccessRequest)
ProviderManagement_viewExternalAccessRequestTabDetails
Home (ProviderManagement_viewIncident)
View Incident: (ProviderManagement_viewIncidentForInvestigation)
Home (ProviderManagement_viewIncidentForPG)
View Placement: (ProviderManagement_viewPlacementDetails)
View Placement Type Payment Detail for Provider: (ProviderManagement_viewPlacementPaymentForProvider)
View Placement Type Payment Detail for Provider Group: (ProviderManagement_viewPlacementPaymentForProviderGroup)
- (ProviderManagement_viewProviderIncidentTabDetails)
ProviderManagement_viewProviderTabDetails
ProviderManagement_viewProviderTabDetailsForFacilityManager
View External Access Request: (ProviderManagement_viewRequestsForSupervisor)
View Reservation (ProviderManagement_viewReservation)
View Reservation: (ProviderManagement_viewSampleReservation)
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)