This table stores the shift details of the resource, which is taken from the organization shift details.
|
Field Name |
Data type |
Field Length |
FK Relationship |
Allow Null? |
Short description (Default value if applicable) |
|
|
Field |
Table |
|||||
|
ID |
INTEGER |
4 |
|
|
N |
Unique identifier |
|
VIRTUALUSERID |
INTEGER |
4 |
|
|
Y |
Id of the resource which maps the SWVirtualUser table |
|
RESOURCESHIFTID |
INTEGER |
4 |
|
|
Y |
Shift Id of the shift to which the resource is assigned. This maps SWOrganizationShiftDetails. |
|
LASTUPDATEDDATETIME |
DATETIME |
8 |
|
|
Y |
Last updated time of resource shift details |