Location States
The Location States hierarchy has the following views:
- V_LocationStatus
- V_LocationStatusCategory
- V_LocationStatusType
- 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. |