This table stores the organization’s holiday details. The dates are selected by a resource in the Organization web control. These holidays are shown to the resources in their resource calendar.
|
Field Name |
Data type |
Field Length |
FK Relationship |
Allow Null? |
Short description (Default value if applicable) |
|
|
Field |
Table |
|||||
|
ID |
INTEGER |
4 |
RESOURCESHIFTID |
SWRESOURCESHIFTDETAILS |
N |
Unique identifier which identifies the organization’s holiday details |
|
ORGHOLIDAYDATE |
DATETIME |
8 |
|
|
Y |
Holiday date |
|
RESOURCEHANDLER |
NVARCHAR |
30 |
|
|
Y |
Name of the resource handler which is used for querying and extracting the resource’s properties |
|
ORGHOLIDAYREASON |
NVARCHAR |
200 |
|
|
Y |
Reason for the holiday |
|
LASTUPDATEDDATETIME |
DATETIME |
8 |
|
|
Y |
Last updated date of the organization holiday details |