Table Description
Non-standard Working Pattern: The working pattern of non-standard days which do not conform to a default working pattern.
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::Non Standard Working Pattern::NonStandardWorkingPattern
Controlling File: core\model\Packages\Organisation\NonStandardWorkingPattern_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
VALIDATION_EXIT_POINTyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
nsWorkingPatternIDkeynoUnique internal reference number assigned to the non-standard working pattern.NS_WORKING_PATTERN_ID SVR_INT64
workingPatternIDdetailsnoUnique internal reference number assigned to the associated working pattern.WORKING_PATTERN_ID SVR_INT64
nonStandardTypeCodedetailsnoCode table code referring to the type of non-standard working pattern.WORKING_PATTERN_TYPE_CODEWorkingPatternTypeSVR_STRING<10>
dayNumberdetailsnoThe number of the day for the non-standard working pattern. This is a number between 1 and 14, indicating which day of the two-week period of the working pattern is non-standard.NS_WORKING_PATTERN_DAY SVR_INT16
startTimedetails The start time of the non-standard working pattern (if any).CURAM_DATETIME SVR_DATETIME
endTimedetails The end time of the non-standard working pattern (if any).CURAM_DATETIME SVR_DATETIME
recordStatusCodedetailsnoCode table code referring to the status of the record.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
NonStandardWorkingPattern.workingPatternIDWorkingPattern.workingPatternID
Indices (2)
Index NameAttributes
SearchNSPIdxworkingPatternID, recordStatusCode
SearchNSPDayIdxworkingPatternID, dayNumber, recordStatusCode
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readActiveNSPatternnsread search for Active non standard working pattern for specified day index 
cancelNonStandardPatternsnsmodify sets all non standard patterns that belong to specified default working pattern as Canceled 
searchNSPatternsForDefaultPatternreadmultiORDER_BY: dayNumber
reads details of all active non standard working patterns for specified default working pattern 
Related Pages (96)
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)
Calendar (Organization_currentOrganizationCalendar)
Events (Organization_currentUserCalendar)
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)
Edit User Working Pattern (Supervisor_modifyUserWorkingPatternFromList)
Edit User Working Pattern (Supervisor_modifyUserWorkingPatternFromView)
View User Working Pattern (Supervisor_viewUserWorkingPattern)
Welcome to Cúram (Supervisor_workspace)
Welcome to Cúram (SysAdmin_workspace)