Table Description
Organization Calendar: A facility to view all activities created for the organization.
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::OrganisationCalendar::OrganisationCalendar
Controlling File: core\model\Packages\Organisation\OrganisationCalendar_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
VALIDATION_EXIT_POINTno
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
orgCalendarIDkeynounique identifier for the organization Calendar recordORG_CALENDAR_ID SVR_INT64
organisationIDdetailsnoUnique identifier for the OrganizationORGANISATION_ID SVR_INT64
nonWorkingDatedetailsnoDate on which the organization is closedCURAM_DATE SVR_DATE
nonWorkingDayTypedetails Code table value for the type of closure e.g. HolidayNON_WORKING_DAY_CODENonWorkingDaySVR_STRING<10>
reasondetails Free form text concerning the closureREASON_TEXT SVR_STRING<200>
Foreign Keys (1)
ChildParent
OrganisationCalendar.organisationIDOrganisation.organisationID
Indices (1)
Index NameAttributes
OrgCalendarIndexorganisationID, nonWorkingDate
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
readByDatensread Method to check the status on a specific date 
searchByDateRangensmultiREADMULTI_LIM: 250
 		Method to return all records for an organization from a specified date onwards.SQL
Related Pages (0)