Table Description
OutOfUsePeriod: The period during which a place is out of use.

The period during which a place is out of use.

Example

For example, a cell in a detention center is out of use from 10/07/2007 onwards due to renovation.

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::OutOfUsePeriod::Entity::OutOfUsePeriod
Controlling File: CPM\model\Packages\Service Layer\Place Mangement\OutOfUsePeriod\OutOfUsePeriod_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
outOfUsePeriodIDkeynoThe unique system generated identifier for the out of use period record.INTERNAL_ID SVR_INT64
startDatedetails The date from which the place is out of use.CURAM_DATE SVR_DATE
endDatedetails The last date on which the place is out of use.CURAM_DATE SVR_DATE
placeIDdetailsnoThe unique system generated identifier for the place.INTERNAL_ID SVR_INT64
reasondetails The reason for marking the place out of use.OUT_OF_USE_REASONPlaceOutOfUseReasonSVR_STRING<10>
startDateTimedetails The date time from which the place is out of use.CURAM_DATETIME SVR_DATETIME
endDateTimedetails The last date time on which the place is out of use.CURAM_DATETIME SVR_DATETIME
Foreign Keys (1)
ChildParent
OutOfUsePeriod.placeIDPlace.placeID
Indices (1)
Index NameAttributes
OutOfUsePeriodIndex1placeID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
readread Reads a row of data from OutOfUsePeriod table.  
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies an existing row on OutOfUsePeriod table.  
insertinsertAUTO_ID: outOfUsePeriodID
Creates a new row on OutOfUsePeriod table.  
removeremove Removes an existing row from OutOfUsePeriod table.  
searchByPlaceIDreadmulti Searches for all out of use records for a specific place. 
searchPlaceOutOfUsePeriodreadmultiORDER_BY: outOfUsePeriodID
WHERE: placeId=:placeID AND startDate<=:date AND (endDate is NULL OR endDate>=:date)
Searches out of use period for a place on a specific date. 
searchPlaceForOutOfUsePeriodInDateTimereadmultiWHERE: placeId=:placeID AND (endDateTime IS NULL AND endDate IS NULL)
Searches out of use period for a place for a specified date time. 
Related Pages (65)
Add Existing Places (ProviderManagement_addExistingPlaces)
Add Existing Places (ProviderManagement_addExistingPlaces1)
Add Service Authorization Line Item: (ProviderManagement_addSampleServiceAuthorizationLineItem)
Delete Place (ProviderManagement_cancelPlace)
Compartment View (ProviderManagement_compartmentTreeWindow)
Confirm cancel overlapping reservations (ProviderManagement_confirmCancelOverlappingActiveResForAnyClient)
Confirm Modify Overlapping Placements (ProviderManagement_confirmModifyOverlappingPlacementPrd)
Confirm modify overlapping placements (ProviderManagement_confirmModifyPlacementPrdForWL)
Create Emergency Placement (ProviderManagement_createSampleEmergencyPlacement)
Create Reservation (ProviderManagement_createSampleReservation)
Create Service Authorization Line Items (ProviderManagement_createSampleSAWithSALI)
Delete Compartment (ProviderManagement_deleteCompartment)
Step 5: Register Person (ProviderManagement_duplicateRegisterPersonAsProvider)
Deductions (ProviderManagement_listActiveDeductionForProvider)
Applied and Un-applied Deductions: (ProviderManagement_listAppliedUnappliedDeductionForProvider)
ProviderManagement_listExternalAccessRequestsForResMgr
Places (ProviderManagement_listOccupiedPlaces)
ProviderManagement_listPlace
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 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)
Edit Provider Details (ProviderManagement_modifyProvider)
Edit Reservation (ProviderManagement_modifyReservation)
Confirm Placement (ProviderManagement_modifyResPeriodDuringConfirmation)
Confirm Placement: (ProviderManagement_modifySamplePlaceDuringConfirmation)
Confirm Placement: (ProviderManagement_modifySampleResPeriodDuringConfirmation)
Modify Service Authorization Line Item: (ProviderManagement_modifySampleServiceAuthorizationLineItem)
Place Client (ProviderManagement_placeSampleClient)
Home (ProviderManagement_providerHome)
Home (ProviderManagement_providerHomeForFacilityManager)
ProviderManagement_providerHomeTabDetailsPreview
Register As Person (ProviderManagement_registerProviderAsPersonFrmProviderHome)
ProviderManagement_searchExternalAccessRequests
External Access Request Search (ProviderManagement_searchRequestsForSupervisor)
Override Maximum Deduction Rate (ProviderManagement_setOverrideMDR)
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
View Place (ProviderManagement_viewPlace)
ProviderManagement_viewProviderTabDetails
ProviderManagement_viewProviderTabDetailsForFacilityManager
View External Access Request: (ProviderManagement_viewRequestsForSupervisor)
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)