FWLocationWindow

Ü Note― See Generic Window Attributes for details.

This table is used to specify specific time windows for a given location. It is optional in that it does not need to exist when an FWLocation table is created.

Create: Must be associated with a location record

Delete: Must be deleted whenever the associated location record is deleted.

Update: individual record only

Attribute Name	Type	Field Size	Description	Required
LocationWindowID	int	4	Unique internal DB Identifier of the Location window record.	Required
LocationID	int	4	Unique internal DB Identifier of the Location record. Must exist on the FWLocation table.	Required
CreatedBy	int	4	See CreatedBy.
CreatedDate	datetime	8	See CreatedDate.
Type	nvarchar	50	See Type.	Required
EarliestTime	datetime	8	Beginning time for time window
LatestTime	datetime	8	Ending time for time window
EarliestDate	datetime	8	Beginning date for time window X. Values of "ScheduleDate + X and 'Today + X' can be used to create relative dates.
LatestDate	datetime	8	Ending date for time window X. Values of 'ScheduleDate + X' and 'Today + X' can be used to create relative dates.
Frequency	nvarchar	255	Designates which weekdays or dates the item is available to be scheduled. For weekdays, you can use the standard abbreviations, full names, or numbers 1 through 7 corresponding to days Monday through Sunday. Dates may be written as M/D/Y, M-D-Y, MMDDYY, or MMDDYYYY. For example, a setting of ”r;135” schedules the item for Monday, Wednesday and Friday. A setting of ”r;Mon Wed Fri 6/30/1999 7/1/1999” schedules the item for Monday, Wednesday, and Friday and for 6/30/1999 and 7/1/1999.
ProfitFactor	float	8	Portion of the job or task's profit gained by serving it within the time window.
VariationDuration	int	4	A "fudge factor" for time windows. Extends every time window's open and close times by the specified duration.
VariationProfit	float	8	Portion of the task’s profit gained when it is served outside the defined time window, but within the allowed variation. Encourages Optimizer to assign jobs inside the variation if the time window cannot be achieved. For example, a value of 0.75 gives a job served within the variation 75% of its normal profit.
ModifiedBy	int	4	See ModifiedBy.
ModifyDate	datetime	8	See ModifyDate.
Comment	nvarchar	500	See Comment.
OpenDateTime	datetime	8	Opening Date/Time of the Time Window
CloseDateTime	datetime	8	Closing Date/Time of the time window