Table Description
Working Pattern: The default working hours of a user or organization.

Working patterns relate to a two-week period, starting on a Monday, and repeat until an end date.

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::Organisation::Entity Objects::Working Pattern::WorkingPattern
Controlling File: core\model\Packages\Organisation\WorkingPattern_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
VALIDATION_EXIT_POINTyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
workingPatternIDkeynoUnique internal reference number assigned to the working pattern.WORKING_PATTERN_ID SVR_INT64
userNamedetailsyesThe user name of the user associated with the working pattern.USER_NAME SVR_STRING<64>
organisationIDdetailsyesThe unique internal reference number of the organization associated with the working pattern.ORGANISATION_ID SVR_INT64
startDatedetailsnoThe date from which the working pattern is active.CURAM_DATE SVR_DATE
endDatedetailsyesThe last date on which the working pattern is effective.CURAM_DATE SVR_DATE
defaultStartTimedetailsnoThe default start time for days covered by the working pattern.CURAM_TIME SVR_DATETIME
defaultEndTimedetailsnoThe default end time for days covered by the working pattern.CURAM_TIME SVR_DATETIME
recordStatusCodedetailsnoCode table code referring to the record status.CODETABLE_CODE SVR_STRING<10>
locationIDdetails The unique internal reference number of the location associated with the working pattern.LOCATION_ID SVR_INT64
workingHoursTypedetailsnoCode table code referring to the type of working hours this working pattern represents.WORKING_HOURS_TYPE_CODEWorkingHoursTypeSVR_STRING<10>
Foreign Keys (3)
ChildParent
WorkingPattern.organisationIDOrganisation.organisationID
WorkingPattern.userNameUsers.userName
NonStandardWorkingPattern.workingPatternIDWorkingPattern.workingPatternID
Indices (3)
Index NameAttributes
WPIndex4organisationID
WPIndex1userName
WPLocationIndexlocationID
Operations (17)
OperationStereotypeOptionsDescriptionSQL
insertinsertPRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
searchPatternsByUsernsreadmultiREADMULTI_LIM: 0
Retrieves the working patterns for the specified user. 
searchPatternsByOrganisationnsreadmultiREADMULTI_LIM: 0
Retrieves the default working patterns for the specified organization. 
searchWorkingPatternsForOverlapnsmulti checks if there is another active working pattern in specified dates range for specified ownerSQL
searchDefaultPatternForDatensmulti function search default active pattern for date specifiedSQL
readPatternByUserAndDatens Retrieves the working pattern for the specified user and date.SQL
searchPatternsByLocationnsreadmultiREADMULTI_LIM: 0
Retrieves the working patterns for the specified location. 
searchByOwnerTypeAndRecordStatusnsmulti This method searches for an active working pattern of a specific type in the specified date range for the specified ownerSQL
searchDefaultPatternForDateAndTypensmulti This method searches for the default active pattern of the specified type for the date specified.SQL
readActivePatternByOwnerDateAndTypensPRE_DATA_ACCESS: yes
 
This method retrieves the active working pattern of the appropriate type for the specified owner and date.SQL
searchByLocationIDreadmulti <p> Reads all the records for a location id. </p> 
removeremove Removes a record from working pattern entity. 
searchByUserNamereadmulti Reads all record for a user. 
insertWorkingPatterninsert Inserts working pattern record. This method expects the workingPatternID to be set. It is preferred to call insertWorkingPattern method only in scenarios where calling method wants to set the value of primary key by itself. 
modifyWorkingPatternmodifyOPTIMISTIC_LOCKING: yes
This modify operation will be called while re-applying a change set in the target system. Entity level validations that will happen during a standard modify operation will not be applicable in this case. This modify operation will update all the attributes defined for this entity. 
Related Pages (104)
Welcome to Cúram (Admin_workspace)
Confirm Location Hearing (Appeal_confirmIssueLocationHearingIC)
Confirm Location Hearing (Appeal_confirmLocationHearing)
Confirm Location Hearing (Appeal_confirmLocationHearingIC)
Schedule Hearing (Appeal_displaySchedule_HearingReview)
Schedule Hearing Review (Appeal_displaySchedule_HearingReviewForIC)
Schedule Hearing (Appeal_displaySchedule_HomeHearing)
Schedule Hearing (Appeal_displaySchedule_HomeHearingForIC)
Schedule Hearing (Appeal_displaySchedule_HomeHearingForIC1)
Schedule Hearing REVIEW (Appeal_displaySchedule_IssueHearingReviewForIC)
Schedule Hearing (Appeal_displaySchedule_IssueHomeHearingForIC)
Schedule Hearing (Appeal_displaySchedule_IssueLocationHearingIC)
Schedule Hearing (Appeal_displaySchedule_IssuePhoneHearingForIC)
Schedule Hearing (Appeal_displaySchedule_LocationHearing)
Schedule Hearing (Appeal_displaySchedule_LocationHearingIC)
Schedule Hearing (Appeal_displaySchedule_PhoneHearing)
Schedule Hearing (Appeal_displaySchedule_PhoneHearingForIC)
Schedule Hearing (Appeal_displaySchedule_PhoneHearingForIC1)
Reschedule Hearing Review Hearing (Appeal_rescheduleHearingReviewHearing)
Reschedule Hearing Review Hearing (Appeal_rescheduleHearingReviewHearingForIC)
Reschedule Home Hearing (Appeal_rescheduleHomeHearing)
Reschedule Home Hearing (Appeal_rescheduleHomeHearingIC)
Reschedule Home Hearing (Appeal_rescheduleHomeHearingIC1)
Reschedule Location Hearing (Appeal_rescheduleLocationHearing)
Reschedule Location Hearing (Appeal_rescheduleLocationHearingIC)
Reschedule Telephone Hearing (Appeal_reschedulePhoneHearing)
Reschedule Telephone Hearing (Appeal_reschedulePhoneHearingIC)
Reschedule Telephone Hearing (Appeal_reschedulePhoneHearingIC1)
Schedule Hearing Review (Appeal_scheduleHearingReviewHearing)
Schedule Hearing Review (Appeal_scheduleHearingReviewHearingForIC)
Schedule Home Hearing (Appeal_scheduleHomeHearing)
Schedule Home Hearing (Appeal_scheduleHomeHearingIC)
Schedule Home Hearing (Appeal_scheduleHomeHearingIC1)
Schedule Hearing Review (Appeal_scheduleIssueHearingReviewHearingForIC)
Schedule Home Hearing (Appeal_scheduleIssueHomeHearingIC)
Schedule Hearing (Appeal_scheduleIssueLocationHearingIC)
Schedule Phone Hearing (Appeal_scheduleIssuePhoneHearingIC)
Schedule Location Hearing (Appeal_scheduleLocationHearing)
Schedule Hearing (Appeal_scheduleLocationHearingIC)
Schedule Phone Hearing (Appeal_schedulePhoneHearing)
Schedule Phone Hearing (Appeal_schedulePhoneHearingIC)
Schedule Phone Hearing (Appeal_schedulePhoneHearingIC1)
Cúram - Administration Home (Application_administrationHome)
Cúram (Application_home)
Welcome to Cúram (Application_workspace)
New Application Case (CommonIntake_createApplicationCaseForConcernRole)
Reopen Program (CommonIntake_createProgramReopening)
New Referral (CommonIntake_createReferralApplicationCaseForConcernRole)
Edit And Approve Timer Extension (CommonIntake_editAndApproveTimerExtension)
Edit Application (CommonIntake_editApplicationCase)
Edit Date Program Added (CommonIntake_editProgramDateAdded)
Extend Timer (CommonIntake_extendTimers)
New Application Form (CommonIntake_listInternalIntakePrograms)
New Application Form (CommonIntake_listInternalIntakeProgramsForST)
Edit Reopen Details (CommonIntake_modifyProgramReopenDetails)
Cúram Financials (Financial_home)
Welcome to Cúram (Financial_workspace)
Welcome to Cúram (FundPM_fundManagerHome)
Schedule Appointment: (IncomeScreening_scheduleAppointment)
Schedule Appointment: (IncomeSupportScreening_checkUserAvailability)
Integrated Social Enterprise (IntegratedSocialEnterprise_home)
Cúram (ISPApplication_home)
ISPApplication_workspace
Basic Intake Information (ISPIntakeInformation_create)
Basic Intake Information (ISPIntakeInformation_createFromScreening)
Basic Intake Information (ISPIntakeInformation_createWithIntegratedCase)
ISSApplication_workspace
Delete Location Working Pattern (Organization_cancelLocationWorkingPattern)
Delete User Working Pattern (Organization_cancelUserWorkingPattern)
Delete Organization Working Pattern (Organization_cancelWorkingPattern)
New Location Working Pattern (Organization_createLocationWorkingPattern)
New Working Pattern (Organization_createUserWorkingPattern)
New Organization Working Pattern (Organization_createWorkingPattern)
Calendar (Organization_currentOrganizationCalendar)
Events (Organization_currentUserCalendar)
Working Patterns (Organization_listLocationWorkingPattern)
Working Patterns (Organization_listUserWorkingPattern)
Working Patterns (Organization_listWorkingPattern)
Edit Location Non Standard Working Days (Organization_maintainLocationNonStandardWorkingPattern)
Edit Working Pattern Day (Organization_maintainNonStandardWorkingPattern)
Edit Non Standard Hours (Organization_maintainUserNonStandardWorkingPattern)
Edit Location Working Pattern (Organization_modifyLocationWorkingPatternFromList)
Edit Location Working Pattern (Organization_modifyLocationWorkingPatternFromView)
Edit User Working Pattern (Organization_modifyUserWorkingPatternFromList)
Edit User Working Pattern (Organization_modifyUserWorkingPatternFromView)
Edit Organization Working Pattern (Organization_modifyWorkingPatternFromList)
Edit Organization Working Pattern (Organization_modifyWorkingPatternFromView)
Calendar (Organization_selectedUserCalendar)
View Location Working Pattern (Organization_viewLocationWorkingPattern)
View User Working Pattern (Organization_viewUserWorkingPattern)
View Organization Working Pattern (Organization_viewWorkingPattern)
My Workspace: Welcome to Cúram (ProviderManagement_facilityMgrHome)
My Workspace: Welcome to Cúram (ProviderManagement_resourceMgrHome)
My Workspace: Welcome to Cúram (ProviderManagement_resourceMgrSupervisorHome)
Calendar (Supervisor_calendar)
Delete User Working Pattern (Supervisor_cancelUserWorkingPattern)
Calendar (Supervisor_caseUserCalendar)
New User Working Pattern (Supervisor_createUserWorkingPattern)
Edit User Working Pattern (Supervisor_modifyUserWorkingPatternFromList)
Edit User Working Pattern (Supervisor_modifyUserWorkingPatternFromView)
View User Working Pattern (Supervisor_viewUserWorkingPattern)
Working Patterns (Supervisor_workingPatterns)
Welcome to Cúram (Supervisor_workspace)
Welcome to Cúram (SysAdmin_workspace)