| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| Active | Indicates if the Shift is Active (True or False) | bit | |
| Code | Shift Code | nvarchar | |
| Color | Shift Color | nvarchar | |
| CreatedDate | Record Creation Date | datetime | |
| CreatorId | User Id (Record Creator) | int | vr_users |
| Description | Shift Description | nvarchar | |
| Differential | Shift Differential | decimal | |
| Duration | Shift Duration | decimal | |
| End | Shift End | nvarchar | |
| Friday | Indicates if Friday | bit | |
| Id | Shift Id | int | |
| IsCustodial | Shift Is Custodial | bit | |
| LunchEnd | Shift Lunch End | nvarchar | |
| LunchStart | Shift Lunch Start | nvarchar | |
| ModifiedDate | Last Modified Date | datetime | |
| ModifierId | User Id (Record Modifier) | int | vr_users |
| Monday | Monday | bit | |
| Saturday | Saturday | bit | |
| Start | Shift Start | nvarchar | |
| Sunday | Sunday | bit | |
| Thursday | Thursday | bit | |
| Tuesday | Tuesday | bit | |
| Wednesday | Wednesday | bit |