Table Description
User Calendar: A facility to view all activities created for the user .
Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Organisation::Entity Objects::UserCalendar::UserCalendar
Controlling File: core\model\Packages\Organisation\UserCalendar_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
nonWorkingDatedetailsnoDate on which the user is not working.CURAM_DATE SVR_DATE
nonWorkingDayTypedetailsnoCode table value for the type of non working day e.g. holidayNON_WORKING_DAY_CODENonWorkingDaySVR_STRING<10>
reasondetailsyesReason, if supplied, why the user is unavailable.REASON_TEXT SVR_STRING<200>
userCalendarIDkeynoUnique identifier for the user calender recordUSER_CALENDAR_ID SVR_INT64
userNamedetailsnoUser to whom this record calender record relates.USER_NAME SVR_STRING<64>
assignToUserdetailsyesUser to whom tasks are to be reassigned during an absence.USER_NAME SVR_STRING<64>
Indices (1)
Index NameAttributes
UserCalendarIndexnonWorkingDate, userName
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
readByUserAndDatensread Method to check a user By Date 
searchByDateRangensmultiREADMULTI_LIM: 250
 		Method to return all records after a specified dateSQL
Related Pages (0)