Location States

The Location States hierarchy has the following views:

  1. V_LocationStatus
  2. V_LocationStatusCategory
  3. V_LocationStatusType
  4. V_LocationStatusGroup

V_LocationStatus

The V_LocationStatus view defines the states that are applied to locations, for example, Drilling, Bogging, To Drill, To Bog, etc. Location states are defined in the Reference Data (Groups | Configuration Items | States | Location States).

Column Description
Mandatory Column Set
LocationStatus_Category Select the Location Status Category of the status as defined in V_LocationStatus_Category.
LocationStatus_Category_Code The value in this column is generated automatically by the system. It is the Code of the selected Location Status Category.
LocationStatus_ValidDurationMinutes Define the acceptable duration that the location can remain at the current location status. In Data Acquisition, a warning will be received if the defined interval has been exceeded.

V_LocationStatus_Category

The V_LocationStatus_Category view defines a general category to which a location status belongs.

Location Status Categories could be defined as Operating, Delay, etc. If the status of a location is Drilling, the Location Status Category could be Operating, for example. If the status of a location is To Drill, the Location Status Category could be Delay or NextOperation.

Column Description
Mandatory Column Set
LocationStatus_Category_Type Select the Location Status Type of the category.
LocationStatus_Category_Type_Code The value in this column is generated automatically by the system. It is the Code of the selected Location Status Category Type.

V_LocationStatus_Type

The V_LocationStatus_Type view defines a subset of a V_Status_Group. Many sites, for example, define the V_Status_Types as Operating and Delay.

Column Description
Mandatory Column Set
LocationStatus_Type_Group Select the Location Status Type Group of the Location Status Type.
LocationStatus_Type_Group_Code The value in this column is generated automatically by the system. It is the Code of the selected Location Status Type Category Group.