Open/Close Relations

Internal Table Name: OpenCloseRelations

Period

Technology: NO

Table: OpenCloseRelations

Internal Name: PeriodName

Type: Short Text (50)

One of (ALL_Periods) (All), (ALL_Periods) (Each), period name, period group.

Select the period or set of periods to which the constraint will apply. If there are no Periods specified in the model or when this field is left blank, the constraint will apply to the planning horizon.

If Type

Technology: NO

Table: OpenCloseRelations

Internal Name: IfType

Type: Short Text (50)

Select the type of constraint from the following:

• At Least
• At Most
• Equals
• Not Equals

Default: At Least

If Value

Technology: NO

Table: OpenCloseRelations

Internal Name: IfValue

Type: Number (Long Integer)

Enter the numeric value associated with the If Type selection. For example, you may define a constraint where at least 2 sites are open in a specified period. The If Value would be 2.

Default: 0

If Site

Technology: NO

Table: OpenCloseRelations

Internal Name: IfSiteName

Type: Short Text (100)

Select the site, site set or (All) sites to which the “If” clause applies. Selected Sites must have a Status = "Consider", otherwise the model may be infeasible.

If Work Center

Technology: NO

Table: OpenCloseRelations

Internal Name: IfWorkCenterName

Type: Short Text (100)

Select the work center, work center set or (All) work centers to which the “If” clause applies. Selected Work Centers must have a Status = "Consider", otherwise the model may be infeasible.

If Condition

Technology: NO

Table: OpenCloseRelations

Internal Name: IfCondition

Type: Short Text (50)

One of Open, Closed.

Select whether the condition of the site or work center in the “If” clause is Open or Closed.

Default: Open

Then Type

Technology: NO

Table: OpenCloseRelations

Internal Name: ThenType

Type: Short Text (50)

Select the type of constraint from the following:

• At Least
• At Most
• Equals
• Not Equals

Default: At Least

Then Value

Technology: NO

Table: OpenCloseRelations

Internal Name: ThenValue

Type: Number (Long Integer)

Enter the numeric value associated with the Then Type selection. For example, you may define a constraint where if 2 sites are open in a specified period, exactly 1 work center must be open. The Then Value would be 1.

Default: 0

Then Site

Technology: NO

Table: OpenCloseRelations

Internal Name: ThenSiteName

Type: Short Text (100)

Select the site, site set or (All) sites to which the “Then” clause applies. Selected Sites must have a Status = "Consider", otherwise the model may be infeasible.

Then Work Center

Technology: NO

Table: OpenCloseRelations

Internal Name: ThenWorkCenterName

Type: Short Text (100)

Select the work center, work center set or (All) work centers to which the Then clause applies. Selected Work Centers must have a Status = "Consider", otherwise the model may be infeasible.

Then Condition

Technology: NO

Table: OpenCloseRelations

Internal Name: ThenCondition

Type: Short Text (50)

One of Open, Closed.

Select whether the condition of the site or work center in the Then clause is Open or Closed.

Default: Open

If And Only If

Technology: NO

Table: OpenCloseRelations

Internal Name: IfAndOnlyIf

Type: Short Text (50)

One of Yes, No.

When set to No, if the “If” clause is evaluated as True, the “Then” clause must also be True. If the “If” clause is False, the “Then” clause can be either True or False.

When set to Yes, if the “If” clause is evaluated as False, the “Then” clause must also be False.

Default: No

Status

Technology: NO

Table: OpenCloseRelations

Internal Name: Status

Type: Short Text (25)

One of Include, Exclude.

Use this field to specify whether a record is included or excluded from optimization.

Default: Include