# BI views

## Introduction <a href="#toc132789806" id="toc132789806"></a>

The BI views have been divided into five categories: [Facts](#toc132789807), [dimensions](#toc132789814), [filters](#toc132789829), [Row level security](#toc132789832) and [Helpers](#helpers). Some views for fact, dimensions and filters will contain references to Site, Department or Skill category for [Row level security ](#toc132789832)purposes

## Facts <a href="#toc132789807" id="toc132789807"></a>

Used to provide data for the decisionmaking process or kpi’s. Prefix: applv\_bi\_fact.

### applv\_bi\_factBITarget <a href="#toc132789808" id="toc132789808"></a>

#### **Purpose**

Get target percentages set for BI

#### **Source**

BITarget

#### **Filter**

BiTRecStatus >= 0

#### **Fields**

| **Field**            | **Example** | **Remark**                         |
| -------------------- | ----------- | ---------------------------------- |
| PPC target           | 0.800000    | Percentage Preventive corrective.  |
| PMC target           | 0.900000    | Preventive Maintenance compliance. |
| Emergency job target | 0.100000    | Rush jobs.                         |

#### **Status**

Available since 2020.R2

#### **Remarks**

* Percentage shown as decimal 0.8 -> 80%<br>

### applv\_bi\_factBudget <a href="#toc132789809" id="toc132789809"></a>

#### **Purpose**

Approved monthly budgets including approved mutations and the amount it’s being used

**Source**

Budgetperiod

**Filter**

BdgpContext = 4\
AND BdgpRecStatus = 8\
AND BdgpStartDate >= UmmgStartDateFinanceYear – 5

**Fields**

| **Field**       | **Example**        | **Remark**                                                                             |
| --------------- | ------------------ | -------------------------------------------------------------------------------------- |
| Year            | 2018               |                                                                                        |
| Period          | 2018-m04           |                                                                                        |
| Date            | 1-4-2018           |                                                                                        |
| Total budget    | 750.000.000        |                                                                                        |
| Budget          | 550.000.000        |                                                                                        |
| Cost            | 875.000            |                                                                                        |
| Difference      | 749.125.000        |                                                                                        |
| Budget left%    | 0.9988333333333333 |                                                                                        |
| Percentage used | 0.12               |                                                                                        |
| Mutation        | 200.000.000        |                                                                                        |
| BdgpCompId      | 000001             |                                                                                        |
| BdgpCcrId       | 01                 | [applfn\_GetBIIdWithCompany](/database/bi-overview/bi-functions.md#_toc132789802) used |
| Status          | Approved           | [applv\_bi\_helperUsedStatusDescriptions](#applv_bi_helperusedstatusdescriptions) used |

**Status**

Available since 2020.R2

**Remarks**

* Percentage shown as decimal 0.8 -> 80%
* Amounts are shown in company currency

### applv\_bi\_factCompany <a href="#toc132789810" id="toc132789810"></a>

**Purpose**

Companies and their currency

**Source**

Company

**Filter**

**None**

**Fields**

| **Field** | **Example** | **Remark** |
| --------- | ----------- | ---------- |
| CompId    | 000001      |            |
| Currency  | EUR         |            |

**Status**

Available since 2020.R2

### applv\_bi\_factCost <a href="#toc132789811" id="toc132789811"></a>

**Purpose**

Incurred costs, categorised by period, object type, category, costs centre, cost type and department

**Source**

applvw\_CcrPrint (Cost)

**Filter**

CstRecStatus = 2 AND CstBookDate >= UmmgStartDateFinanceYear – 5

**Fields**

<table data-header-hidden><thead><tr><th width="182.33333333333331"></th><th width="177"></th><th></th></tr></thead><tbody><tr><td><strong>Field</strong></td><td><strong>Example</strong></td><td><strong>Remark</strong></td></tr><tr><td>Costs</td><td>835.00000</td><td></td></tr><tr><td>CstContext</td><td>8</td><td></td></tr><tr><td>Cost category</td><td>Miscellaneous items</td><td><a href="#applv_bi_helperusedcontextdescriptions">applv_bi_helperUsedContextDescriptions</a> used</td></tr><tr><td>Book date</td><td>2023-09-26</td><td></td></tr><tr><td>CstEqmId</td><td>FL019</td><td><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn_GetBIIdWithCompany</a> used</td></tr><tr><td>CstPrfId</td><td>00013</td><td><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn_GetBIIdWithCompany</a> used</td></tr><tr><td>CstSitId</td><td>05</td><td><p><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn_GetBIIdWithCompany</a> used,</p><p>for <a href="#_toc132789832">Row level security</a></p></td></tr><tr><td>CstCcrId</td><td>06</td><td><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn_GetBIIdWithCompany</a> used</td></tr><tr><td>CstCsttId</td><td>FL08</td><td></td></tr><tr><td>CstDepId</td><td>06</td><td><p><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn_GetBIIdWithCompany</a> used,</p><p>for <a href="#_toc132789832">Row level security</a></p></td></tr><tr><td>EqmtId</td><td>FL003</td><td>From Equipment or Processfunction</td></tr><tr><td>CstCompId</td><td>000001</td><td></td></tr><tr><td>CstSkcId</td><td>015</td><td><p><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn_GetBIIdWithCompany</a> used,</p><p>for <a href="#_toc132789832">Row level security</a></p></td></tr></tbody></table>

**Status**

Available since 2020.R2

**Remarks**

* Amounts are shown in company currency

### applv\_bi\_factJob <a href="#toc135647617" id="toc135647617"></a>

**Purpose**

Reported jobs with dimensions and are they fininished in time

**Source**

Job

**Filter**

JobRecStatus >= 0 AND ‘Date reported’ >= UmmgStartDateFinanceYear – 5

**Fields**

<table data-header-hidden><thead><tr><th width="212.33333333333331"></th><th></th><th></th></tr></thead><tbody><tr><td><strong>Field</strong></td><td><strong>Example</strong></td><td><strong>Remark</strong></td></tr><tr><td>JobId</td><td>1001598</td><td></td></tr><tr><td>JobDepId</td><td>07</td><td><p><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn_GetBIIdWithCompany </a>used,</p><p>for <a href="#_toc132789832">Row level security</a></p></td></tr><tr><td>Date reported</td><td>2023-03-02 00:00:00.0000000 +00:00</td><td><p>When JobPmId is not null then COALESCE(job.JobOriginalSchStartDate, job.JobRecCreateDate)</p><p>else COALESCE(job.JobReportDate, job.JobRecCreateDate)</p><p><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789782">applfn_ConvertToBITimeZone</a>  used</p></td></tr><tr><td>Scheduled start date</td><td>2023-03-02 07:00:00.0000000 +00:00</td><td><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789782">applfn_ConvertToBITimeZone</a> used</td></tr><tr><td>Target date</td><td>2023-03-02 16:00:00.0000000 +00:00</td><td><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789782">applfn_ConvertToBITimeZone</a> used</td></tr><tr><td>Date finished</td><td>NULL</td><td><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789782">applfn_ConvertToBITimeZone</a> used</td></tr><tr><td>JobCompId</td><td>000001</td><td></td></tr><tr><td>JobWotId</td><td>005</td><td></td></tr><tr><td>JobPriId</td><td>M</td><td></td></tr><tr><td>JobFalId</td><td>NULL</td><td></td></tr><tr><td>JobSitId</td><td>06</td><td><p><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn_GetBIIdWithCompany </a>used,</p><p>for <a href="#_toc132789832">Row level security</a></p></td></tr><tr><td>JobPrfId</td><td>000001</td><td><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn_GetBIIdWithCompany </a>used</td></tr><tr><td>JobEqmId</td><td>39704</td><td><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn_GetBIIdWithCompany </a>used</td></tr><tr><td>JobEqmtId</td><td>007</td><td></td></tr><tr><td>JobSkcId</td><td>015</td><td><p><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn_GetBIIdWithCompany </a>used,</p><p>for <a href="#_toc132789832">Row level security</a></p></td></tr><tr><td>JobCcrId</td><td>07</td><td><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn_GetBIIdWithCompany </a>used</td></tr><tr><td>JobPrsId</td><td>064</td><td></td></tr><tr><td>JobContext</td><td>1</td><td></td></tr><tr><td>Description</td><td>Maintenance photocopier</td><td></td></tr><tr><td>JobExecutionDays</td><td>73</td><td></td></tr><tr><td>Final finish date</td><td>2023-05-13 00:00:00.0000000 +00:00</td><td><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789782">applfn_ConvertToBITimeZone</a> used</td></tr><tr><td>Finished on time</td><td>0</td><td>Only when ‘Final finish date’ has value</td></tr><tr><td>Overdue</td><td>0</td><td>Only when ‘Final finish date’ has value</td></tr><tr><td>Days overdue</td><td>NULL</td><td>Only when ‘Final finish date’ has value</td></tr><tr><td>Exceedance</td><td>NULL</td><td>Only when ‘Final finish date’ has value</td></tr><tr><td>Preventive</td><td>1</td><td>based on WotCategory = 'P’</td></tr><tr><td>Emergency job</td><td>0</td><td>based on PriEmergency</td></tr><tr><td>Non Emergency job</td><td>1</td><td>based on PriEmergency</td></tr><tr><td>PM model</td><td>00407</td><td></td></tr><tr><td>JobReportDate</td><td>2023-02-28 11:03:00.0000000 +00:00</td><td><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789782">applfn_ConvertToBITimeZone</a> used</td></tr></tbody></table>

**Status**

Available since 2020.R2

### applv\_bi\_factJobReportedAndFinished <a href="#toc135647618" id="toc135647618"></a>

**Purpose**

Compare date reported and finished for jobs

**Source**

Job

**Filter**

JobRecStatus >= 0 AND ‘Date reported / finished’ >= UmmgStartDateFinanceYear – 5

**Fields**

<table data-header-hidden><thead><tr><th></th><th width="227.33333333333331"></th><th></th></tr></thead><tbody><tr><td><strong>Field</strong></td><td><strong>Example</strong></td><td><strong>Remark</strong></td></tr><tr><td>JobId</td><td>1000012</td><td></td></tr><tr><td>JobCompId</td><td>000001</td><td></td></tr><tr><td>JobSitId</td><td>01</td><td><p><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn_GetBIIdWithCompany </a>used,</p><p>for <a href="#_toc132789832">Row level security</a></p></td></tr><tr><td>JobDepId</td><td>07</td><td><p><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn_GetBIIdWithCompany </a>used,</p><p>for <a href="#_toc132789832">Row level security</a></p></td></tr><tr><td>JobSkcId</td><td>015</td><td><p><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn_GetBIIdWithCompany </a>used,</p><p>for <a href="#_toc132789832">Row level security</a></p></td></tr><tr><td>Date</td><td>2022-12-06 10:18:00.0000000 +00:00</td><td><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789782">applfn_ConvertToBITimeZone</a> used</td></tr><tr><td>JobAction</td><td>Reported</td><td>Reported or Finished</td></tr></tbody></table>

**Status**

Available since 2020.R2

### applv\_bi\_factJobWeekLab <a href="#toc135647619" id="toc135647619"></a>

**Purpose**

Compare preventive and corrective hours spend on jobs

**Source**

Job

**Filter**

JobRecStatus >= 0\
AND COALESCE(JobReportDate, JobRecCreateDate) >= UmmgStartDateFinanceYear – 5

**Fields**

| **Field**                   | **Example** | **Remark**                                                                                                                                                |
| --------------------------- | ----------- | --------------------------------------------------------------------------------------------------------------------------------------------------------- |
| JobwlJobId                  | 1000047     |                                                                                                                                                           |
| JobwlCompId                 | 000001      |                                                                                                                                                           |
| JobwlDepId                  | 07          | <p><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn\_GetBIIdWithCompany </a>used,</p><p>for <a href="#_toc132789832">Row level security</a></p> |
| JobwlSkcId                  | 015         | <p><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn\_GetBIIdWithCompany </a>used,</p><p>for <a href="#_toc132789832">Row level security</a></p> |
| Total hours corrective      | 0.00        | WotCategory = 'C’                                                                                                                                         |
| Total hours preventive      | 2.75        | WotCategory = 'P’                                                                                                                                         |
| Total hours maintenance     | 2.75        | WotCategory in (‘C’, 'P’)                                                                                                                                 |
| Total hours non maintenance | 0.00        | WotCategory not in (‘C’, 'P’)                                                                                                                             |
| Total hours unknown         | 0.00        | WotCategory is null                                                                                                                                       |
| Total hours                 | 2.75        |                                                                                                                                                           |

**Status**

Available since 2020.R2

**Remarks**

* Grouped by jobid, wotcategory, compid, depid, skcid

### applv\_bi\_factObjectDowntime <a href="#toc135647620" id="toc135647620"></a>

**Purpose**

Mean Time to Repair (MTTR), Mean Time Between Failures (MTBF) and Mean Time To Failure (MTTF)

**Source**

ObjectDowntime

**Filter**

JobRecStatus >= 0\
AND ObjDwtContext = 2\
AND ObjDwtEndDate IS NOT NULL\
AND ObjDwtStartDate >= UmmgStartDateFinanceYear – 5

**Fields**

<table data-header-hidden><thead><tr><th width="215.33333333333331"></th><th></th><th></th></tr></thead><tbody><tr><td><strong>Field</strong></td><td><strong>Example</strong></td><td><strong>Remark</strong></td></tr><tr><td>Downtime</td><td>3.000000</td><td></td></tr><tr><td>Duration in minutes</td><td>180</td><td></td></tr><tr><td>Production loss</td><td>119.999999</td><td></td></tr><tr><td>MTBF</td><td>168</td><td></td></tr><tr><td>MTTF</td><td>165</td><td></td></tr><tr><td>ObjDwtCompId</td><td>000001</td><td></td></tr><tr><td>ObjDwtAssetFkId</td><td>N.EXP.01P</td><td><p>Equipment ->  <a href="https://app.gitbook.com/o/-MTFzUh_rAZv8SUsiLpY/s/-MZmRVbbu75Ds8MiWx_F/~/changes/119/database/bi-overview/bi-functions#_toc132789802">applfn_GetBIIdWithCompany</a> + 'E'</p><p>Processfunction -> <a href="https://app.gitbook.com/o/-MTFzUh_rAZv8SUsiLpY/s/-MZmRVbbu75Ds8MiWx_F/~/changes/119/database/bi-overview/bi-functions#_toc132789802">applfn_GetBIIdWithCompany</a> + 'P'</p></td></tr><tr><td>ObjDwtDepId</td><td>05</td><td><p><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn_GetBIIdWithCompany </a>used,</p><p>for <a href="#_toc132789832">Row level security</a></p></td></tr><tr><td>ObjDwtCcrId</td><td>05</td><td><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn_GetBIIdWithCompany </a>used</td></tr><tr><td>ObjDwtSitId</td><td>02</td><td><p><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn_GetBIIdWithCompany </a>used,</p><p>for <a href="#_toc132789832">Row level security</a></p></td></tr><tr><td>Start date</td><td>2022-05-01 09:00:00.0000000 +00:00</td><td><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789782">applfn_ConvertToBITimeZone </a>used</td></tr><tr><td>JobFalId</td><td>US005</td><td></td></tr><tr><td>JobEqmtId</td><td>0020</td><td></td></tr><tr><td>Repair costs</td><td>135.00000</td><td></td></tr><tr><td>JobAssetFkId</td><td>N.EXP.01P</td><td><p>Equipment -> <a href="https://app.gitbook.com/o/-MTFzUh_rAZv8SUsiLpY/s/-MZmRVbbu75Ds8MiWx_F/~/changes/119/database/bi-overview/bi-functions#_toc132789802">applfn_GetBIIdWithCompany</a> + 'E'</p><p>Processfunction -> <a href="https://app.gitbook.com/o/-MTFzUh_rAZv8SUsiLpY/s/-MZmRVbbu75Ds8MiWx_F/~/changes/119/database/bi-overview/bi-functions#_toc132789802">applfn_GetBIIdWithCompany</a> + 'P'</p></td></tr><tr><td>Total costs</td><td>254.999999</td><td></td></tr></tbody></table>

**Status**

Available since 21.01.03

**Remarks**

* Amounts are shown in company currency

### applv\_bi\_factPmWorkOrder <a href="#toc135647621" id="toc135647621"></a>

**Purpose**

Determine the end date for periodical maintenance

**Source**

PmWorkOrder

**Filter**

PmwRecStatus >= 0

**Fields**

| **Field**       | **Example** | **Remark**                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| --------------- | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| PmwId           | 00542       |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| Execution days  | 37          |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| PmwRecordStatus | 2           |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| PmwDepId        | 29          | <p><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn\_GetBIIdWithCompany </a>used,</p><p>for <a href="#_toc132789832">Row level security</a></p>                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| PmwSitId        | 24          | <p><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn\_GetBIIdWithCompany </a>used,</p><p>for <a href="#_toc132789832">Row level security</a></p>                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| PmwSkcId        | 015         | <p><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn\_GetBIIdWithCompany </a>used,</p><p>for <a href="#_toc132789832">Row level security</a></p>                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| PmwCompId       | 000001      |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| PmwContext      | 1024        |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| Context         | 64          | <p>For Pmwcontext 1024 (PeriodicActivityChild) the context is based on backoffice for corresponding Maintenanceclassification.</p><ul><li>When bofJobContext = 1 -> 1 --TS</li><li>When bofJobContext = 512 -> 2 --Instrument</li><li>When bofJobContext = 2048 -> 16 --Building</li><li>When bofJobContext = 16384 -> 64 --Fleet</li><li>When bofJobContext = 32768 -> 32768 --Infra</li><li>When bofJobContext = 64 -> 131072 -- ITKnownError -> IT</li><li>When bofJobContext = 128 -> 131072 --ITIncident -> IT</li><li>When bofJobContext = 256 -> 131072 --ITProblem -> IT</li><li>Else PmwContext</li></ul> |

**Status**

Available since RR (2021.05.11)

### applv\_bi\_factShiftLogLine <a href="#toc135647622" id="toc135647622"></a>

**Purpose**

'Autonomous maintenance performance', the processing performance of maintenance tasks

**Source**

ShiftLogLine

**Filter**

ShllContext = 2\
AND ShllShlId IS NOT NULL\
AND ShllRecCreateDate >= UmmgStartDateFinanceYear – 5

**Fields**

| **Field**                            | **Example**                        | **Remark**                                                                             |
| ------------------------------------ | ---------------------------------- | -------------------------------------------------------------------------------------- |
| ShllOriginShllId                     | 0000000000044                      | [applfn\_GetBIIdWithCompany used](/database/bi-overview/bi-functions.md#_toc132789802) |
| ShllShlbId                           | 01                                 | [applfn\_GetBIIdWithCompany used](/database/bi-overview/bi-functions.md#_toc132789802) |
| ShllCompId                           | 000001                             |                                                                                        |
| ShllSrId                             | NULL                               |                                                                                        |
| ShllPrfId                            | N.PRO.02.008                       | [applfn\_GetBIIdWithCompany used](/database/bi-overview/bi-functions.md#_toc132789802) |
| ShllEqmId                            | 39861                              | [applfn\_GetBIIdWithCompany used](/database/bi-overview/bi-functions.md#_toc132789802) |
| Date                                 | 2022-12-27 10:22:55.0000000 +00:00 | [pplfn\_ConvertToBITimeZone used](/database/bi-overview/bi-functions.md#_toc132789782) |
| Finished on time                     | 1                                  |                                                                                        |
| Finished too late                    | 0                                  |                                                                                        |
| Skipped                              | 0                                  |                                                                                        |
| Applicable for performance dashboard | 1                                  | ShllRecStatus = 128 OR ShllRecStatus = 256                                             |

**Status**

Available since RR (2022.04.29)

## Dimensions <a href="#toc132789814" id="toc132789814"></a>

Used to describe the objects in facts. Prefix: applv\_bi\_dim.

#### Remarks <a href="#toc135647624" id="toc135647624"></a>

* To be able to only show dimension relevant for a specific company extra item(s) will be added to the dimensions with a company.
  * A ‘blank’ (null) dimension item will be added per company.
    * Example: ‘BIRWC-Blank-000001’ (Id) for ‘blank’ and company “000001

### applv\_bi\_dimAsset <a href="#toc135647625" id="toc135647625"></a>

**Purpose**

Assets for applv\_bi\_factPmWorkOrder

**Source**

Equipment / processfunction

**Fields**

| **Field**      | **Example**                  | **Remark**                                                                                                                                                                                                                    |
| -------------- | ---------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| AssetId        | 00003E                       | <p>Equipment -> <a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn\_GetBIIdWithCompany</a> + 'E'</p><p>Processfunction -> <a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn\_GetBIIdWithCompany</a>+ 'P'</p> |
| Asset          | Crate washer machine (00003) | [Aplfn\_GetBIDescriptionWithId](/database/bi-overview/bi-functions.md#_toc132789792) used                                                                                                                                     |
| AssetRecStatus | 2                            |                                                                                                                                                                                                                               |
| AssetCompId    | 000001                       |                                                                                                                                                                                                                               |
| AssetSitId     | 02                           | <p><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn\_GetBIIdWithCompany </a>used,</p><p>for <a href="#_toc132789832">Row level security</a></p>                                                                     |
| AssetDepId     | 05                           | <p><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn\_GetBIIdWithCompany </a>used,</p><p>for <a href="#_toc132789832">Row level security</a></p>                                                                     |
| FilterAssetId  | 00003E                       | [applfn\_GetBIFilterId](/database/bi-overview/bi-functions.md#_toc132789797) used                                                                                                                                             |

**Status**

Available since 21.01.03

### applv\_bi\_dimCostCenter <a href="#toc135647626" id="toc135647626"></a>

**Source**

Costcenter

**Fields**

| **Field**    | **Example**  | **Remark**                                                                                 |
| ------------ | ------------ | ------------------------------------------------------------------------------------------ |
| CcrId        | 001          | [applfn\_GetBIIdWithCompany](/database/bi-overview/bi-functions.md#_toc132789802) used     |
| Cost centre  | Office (001) | [applfn\_GetBIDescriptionWithId](/database/bi-overview/bi-functions.md#_toc132789792) used |
| CcrRecStatus | 2            |                                                                                            |
| CcrCompId    | 000001       |                                                                                            |
| FilterCcrId  | 001          | [applfn\_GetBIFilterId](/database/bi-overview/bi-functions.md#_toc132789797) used          |

**Status**

Available since 2020 R2

### applv\_bi\_dimCostType <a href="#toc132789817" id="toc132789817"></a>

**Source**

CostType

**Fields**

| **Field**     | **Example**  | **Remark**                                                                                 |
| ------------- | ------------ | ------------------------------------------------------------------------------------------ |
| CsttId        | 001          |                                                                                            |
| Cost type     | Office (001) | [applfn\_GetBIDescriptionWithId](/database/bi-overview/bi-functions.md#_toc132789792) used |
| CsttRecStatus | 0            |                                                                                            |
| FilterCsttId  | 001          | [applfn\_GetBIFilterId](/database/bi-overview/bi-functions.md#_toc132789797) used used     |

**Status**

Available since 2020 R2

### applv\_bi\_dimDepartment <a href="#toc132789818" id="toc132789818"></a>

**Source**

Department

**Fields**

| **Field**    | **Example**         | **Remark**                                                                                 |
| ------------ | ------------------- | ------------------------------------------------------------------------------------------ |
| DepId        | 01                  | [applfn\_GetBIIdWithCompany](/database/bi-overview/bi-functions.md#_toc132789802) used     |
| Department   | Administration (01) | [applfn\_GetBIDescriptionWithId](/database/bi-overview/bi-functions.md#_toc132789792) used |
| DepRecStatus | 0                   |                                                                                            |
| DepCompId    | 000001              |                                                                                            |
| FilterDepId  | 001                 | [applfn\_GetBIFilterId](/database/bi-overview/bi-functions.md#_toc132789797) used          |
| IsEmpty      | 0                   |                                                                                            |

**Status**

Available since 2020 R1

### applv\_bi\_dimEqmType <a href="#toc132789819" id="toc132789819"></a>

**Source**

EqmType

**Fields**

| **Field**      | **Example**          | **Remark**                                                                                 |
| -------------- | -------------------- | ------------------------------------------------------------------------------------------ |
| EqmtId         | 001                  |                                                                                            |
| Equipment type | Accessories (000001) | [applfn\_GetBIDescriptionWithId](/database/bi-overview/bi-functions.md#_toc132789792) used |
| EqmtRecStatus  | 0                    |                                                                                            |
| FilterEqmtId   | 001                  | [applfn\_GetBIFilterId](/database/bi-overview/bi-functions.md#_toc132789797) used          |

**Status**

Available since 2020 R2

### applv\_bi\_dimFailType <a href="#toc135647630" id="toc135647630"></a>

**Source**

FailType

**Fields**

| **Field**     | **Example**              | **Remark**                                                                                    |
| ------------- | ------------------------ | --------------------------------------------------------------------------------------------- |
| FalId         | 016                      |                                                                                               |
| Failure cause | Faulty maintenance (016) | [applfn\_GetBIDescriptionWithId](/database/bi-overview/bi-functions.md#_toc132789792) is used |
| FalRecStatus  | 0                        |                                                                                               |
| FilterFalId   | 016                      | [applfn\_GetBIFilterId](/database/bi-overview/bi-functions.md#_toc132789797) used             |

**Status**

Available since 2020 R1

### applv\_bi\_dimOriginalShiftLogLine <a href="#toc132789821" id="toc132789821"></a>

**Source**

ShiftLogLine

**Fields**

| **Field**        | **Example**                             | **Remark**                                                                             |
| ---------------- | --------------------------------------- | -------------------------------------------------------------------------------------- |
| ShllId           | 0000000000050                           | [applfn\_GetBIIdWithCompany](/database/bi-overview/bi-functions.md#_toc132789802) used |
| ShllCompId       | 000001                                  |                                                                                        |
| Maintenance task | Lubricate conveyor belt of Packing line |                                                                                        |
| ShllRecStatus    | 128                                     |                                                                                        |
| FilterShllId     | 0000000000050                           | [applfn\_GetBIFilterId](/database/bi-overview/bi-functions.md#_toc132789797) used      |

**Status**

Available since 21.01.03

### applv\_bi\_dimPriority <a href="#toc135647632" id="toc135647632"></a>

**Source**

Priority

**Fields**

| **Field**          | **Example** | **Remark**                                                                                 |
| ------------------ | ----------- | ------------------------------------------------------------------------------------------ |
| PriId              | 01          |                                                                                            |
| Priority           | High (01)   | [applfn\_GetBIDescriptionWithId](/database/bi-overview/bi-functions.md#_toc132789792) used |
| PriRecStatus       | 0           |                                                                                            |
| Priority emergency | 1           |                                                                                            |

**Status**

Available since 2020 R1

### applv\_bi\_dimProgressStatus <a href="#toc132789823" id="toc132789823"></a>

**Source**

ProgressStatus

**Fields**

| **Field**       | **Example**      | **Remark**                                                                                 |
| --------------- | ---------------- | ------------------------------------------------------------------------------------------ |
| PrsId           | 026              |                                                                                            |
| Progress status | Registered (026) | [applfn\_GetBIDescriptionWithId](/database/bi-overview/bi-functions.md#_toc132789792) used |
| PrsRecStatus    | 0                |                                                                                            |

**Status**

Available since 2020 R1

### applv\_bi\_dimShiftLogbook <a href="#toc135647634" id="toc135647634"></a>

**Source**

ShiftLogbook

**Fields**

| **Field**     | **Example**                      | **Remark**                                                                                                                                                |
| ------------- | -------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------- |
| ShlbId        | 02                               | [applfn\_GetBIIdWithCompany](/database/bi-overview/bi-functions.md#_toc132789802) used                                                                    |
| Logbook       | Logbook - Purifying installation |                                                                                                                                                           |
| ShlbRecStatus | 0                                |                                                                                                                                                           |
| ShlbDepId     | 000001                           | <p><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn\_GetBIIdWithCompany </a>used,</p><p>for <a href="#_toc132789832">Row level security</a></p> |
| ShlbSitId     | 07                               | <p><a href="/pages/bLitCwxmMYRlIEDMlZrt#_toc132789802">applfn\_GetBIIdWithCompany </a>used,</p><p>for <a href="#_toc132789832">Row level security</a></p> |
| ShlbCompId    | 000001                           |                                                                                                                                                           |
| FilterShlbId  | 02                               | [applfn\_GetBIFilterId](/database/bi-overview/bi-functions.md#_toc132789797) used                                                                         |
| IsEmpty       | 0                                |                                                                                                                                                           |

**Status**

Available since 21.01.03

### applv\_bi\_dimSite <a href="#toc132789825" id="toc132789825"></a>

**Source**

Site

**Fields**

| **Field**    | **Example** | **Remark**                                                                            |
| ------------ | ----------- | ------------------------------------------------------------------------------------- |
| SitId        | 01          | [applfn\_GetBIIdWithCompany](/database/bi-overview/bi-functions.md#_toc132789802)     |
| Site         | Office (01) | [applfn\_GetBIDescriptionWithId](/database/bi-overview/bi-functions.md#_toc132789792) |
| Country      | Netherlands |                                                                                       |
| SitRecstatus | 0           |                                                                                       |
| SitCompId    | 000001      |                                                                                       |
| FilterSitId  | 01          | [applfn\_GetBIFilterId](/database/bi-overview/bi-functions.md#_toc132789797) used     |

**Status**

Available since 2020.R1

### applv\_bi\_dimSkillCat <a href="#toc135647636" id="toc135647636"></a>

**Source**

SkillCat

**Fields**

| **Field**    | **Example**    | **Remark**                                                                                 |
| ------------ | -------------- | ------------------------------------------------------------------------------------------ |
| SkcId        | 011            | [applfn\_GetBIIdWithCompany](/database/bi-overview/bi-functions.md#_toc132789802) used     |
| Team         | Other (011) \* | [applfn\_GetBIDescriptionWithId](/database/bi-overview/bi-functions.md#_toc132789792) used |
| SkcRecstatus | -2147483648    |                                                                                            |
| SkcCompId    | 000001         |                                                                                            |

**Status**

Available since 2020.R1

### applv\_bi\_dimSkipReason <a href="#toc132789827" id="toc132789827"></a>

**Source**

Site

**Fields**

| **Field**      | **Example**              | **Remark**                                                                           |
| -------------- | ------------------------ | ------------------------------------------------------------------------------------ |
| SrId           | US01                     |                                                                                      |
| Reason to skip | Insufficient time (US01) | [applfn\_GetBIDescriptionWithId](/database/bi-overview/bi-functions.md#toc132789792) |
| FilterSrId     | US01                     | [applfn\_GetBIFilterId](/database/bi-overview/bi-functions.md#_toc132789797)         |
| SrRecStatus    | 0                        |                                                                                      |

**Status**

Available since RR (2022.04.29)

### applv\_bi\_dimWorkOrderType <a href="#toc135647638" id="toc135647638"></a>

**Source**

Site

**Fields**

| **Field**           | **Example**                  | **Remark**                                                                                                                                                               |
| ------------------- | ---------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| WotId               | 003                          |                                                                                                                                                                          |
| Job type            | Inspection/Calibration (003) | [applfn\_GetBIDescriptionWithId](/database/bi-overview/bi-functions.md#_toc132789792)                                                                                    |
| WotCategory         | P                            |                                                                                                                                                                          |
| Category (job type) | Preventive                   | <p>WHEN WotCategory = 'P' THEN 'Preventive'</p><p>WHEN WotCategory = 'C' THEN 'Corrective'</p><p>WHEN WotCategory NOT IN('P', 'C') THEN 'Other'</p><p>ELSE 'Unknown'</p> |
| WotRecstatus        | 0                            |                                                                                                                                                                          |
| FilterWotId         | 003                          | [applfn\_GetBIFilterId](/database/bi-overview/bi-functions.md#_toc132789797) used                                                                                        |

**Status**

Available since 2020.R1

## Filters <a href="#toc132789829" id="toc132789829"></a>

Filter facts / dimension. Prefix: applv\_bi\_filter.

#### Remarks <a href="#toc132789830" id="toc132789830"></a>

* To provide extra filtering possibilities extra/replacement items will be added to the filters.
  * For filters with a company a ‘blank’ (null) filter item will be added per company.
    * Example: ‘BIRWC-Blank-000001’ (Id) for ‘blank’ and company “000001
  * When trashed items exist all trashed items will be replaced with one trashed filter item (per company) and the description will be ‘\* (Trashed)’
    * Example: ‘ ‘BIRWC-Trashed-000001’ (Id) for ‘trashed’ and company “000001
    * Example: ‘ ‘BIR-Trashed’ (Id) for ‘trashed’ without company
* Most filters are a representation of their dimension, look at the dimension for extra information (source, used functions, remarks, etc.)

### applv\_bi\_filterAsset <a href="#toc135647641" id="toc135647641"></a>

**Purpose**

Assets for applv\_bi\_factPmWorkOrder

**Source**

applv\_bi\_dimAsset

**Fields**

| **Field**     | **Example**           |
| ------------- | --------------------- |
| FilterAssetId | BIRWC-Trashed-000001E |
| Asset         | \* (Trashed)          |
| IsTrashed     | 1                     |
| AssetCompId   | 000001                |

**Remarks**

Could contain two trashed items per company. One for equipment and one for processfunction

**Status**

Available since 21.01.03

### applv\_bi\_filterCostCenter <a href="#toc135647642" id="toc135647642"></a>

**Source**

applv\_bi\_dimCostCenter

**Fields**

| **Field**   | **Example**              |
| ----------- | ------------------------ |
| FilterCcrId | 06                       |
| Cost centre | Dispatch department (06) |
| IsTrashed   | 0                        |
| CcrCompId   | 000001                   |

**Status**

Available since 2020R2

### applv\_bi\_filterCostType <a href="#toc135647643" id="toc135647643"></a>

**Source**

applv\_bi\_dimCostType

**Fields**

| **Field**    | **Example**          |
| ------------ | -------------------- |
| FilterCsttId | 010                  |
| Cost type    | Hardware costs (010) |
| IsTrashed    | 0                    |

**Status**

Available since 2020R2

### applv\_bi\_filterDepartment <a href="#toc135647644" id="toc135647644"></a>

**Source**

applv\_bi\_dimDepartment

**Fields**

| **Field**   | **Example**               |
| ----------- | ------------------------- |
| FilterDepId | 05                        |
| Department  | Dispatch & Logistics (05) |
| IsTrashed   | 0                         |
| DepCompId   | 000001                    |
| IsEmpty     | 0                         |

**Status**

Available since 2020R2

### applv\_bi\_filterEqmType <a href="#toc135647645" id="toc135647645"></a>

**Source**

applv\_bi\_dimEqmType

**Fields**

| **Field**      | **Example**                 |
| -------------- | --------------------------- |
| FilterEqmtId   | 0009                        |
| Equipment type | Hydraulic Generators (0009) |
| IsTrashed      | 0                           |

**Status**

Available since 2020R2

### applv\_bi\_filterEquipment <a href="#toc135647646" id="toc135647646"></a>

**Source**

Equipment (joined with equipment via EqmTopOfEqmId)

**Fields**

| **Field**     | **Example**                | **Remark**                                                                                        |
| ------------- | -------------------------- | ------------------------------------------------------------------------------------------------- |
| EqmId         | 00001                      | [applfn\_GetBIIdWithCompany](/database/bi-overview/bi-functions.md#_toc132789802) used            |
| Equipment     | Forklift 1 type 35 (00001) | [applfn\_GetBIDescriptionWithId](/database/bi-overview/bi-functions.md#_toc132789792) used        |
| EqmRecStatus  | 2                          | <p>WHEN EqmRecStatus < 0 THEN EqmRecStatus</p><p>ELSE topeqm.EqmRecStatus (via EqmTopOfEqmId)</p> |
| EqmTopOfEqmId | 00001                      | if equals EqmId then it's a top eqm                                                               |
| EqmCompId     | 000001                     |                                                                                                   |
| FilterEqmId   | 00001                      | [applfn\_GetBIFilterId](/database/bi-overview/bi-functions.md#_toc132789797) used                 |
| IsEmpty       | 0                          |                                                                                                   |
| EqmContext    | 1                          |                                                                                                   |

**Remarks**

Best practice is to use applv\_bi\_filterTopOfEquipment

**Status**

Available since 2020R1

### applv\_bi\_filterEquipmentContext <a href="#toc135647647" id="toc135647647"></a>

**Source**

[applv\_bi\_helperUsedContextDescriptions ](#applv_bi_helperusedcontextdescriptions)

**Fields**

| **Field**         | **Example**   |
| ----------------- | ------------- |
| EqmContext        | 1             |
| Equipment context | Equipment (1) |

**Status**

Available since RR (2021.12.16)

### applv\_bi\_filterFailType <a href="#toc135647648" id="toc135647648"></a>

**Source**

applv\_bi\_dimFailType

**Fields**

| **Field**     | **Example**              |
| ------------- | ------------------------ |
| FilterFalId   | 016                      |
| Failure cause | Faulty maintenance (016) |
| IsTrashed     | 0                        |

**Status**

#### Available since 2020R2 <a href="#toc135647649" id="toc135647649"></a>

### applv\_bi\_filterProcessFunction <a href="#toc135647650" id="toc135647650"></a>

**Source**

ProcessFunction (joined with equipment via PrfTopOfPrfId)

**Fields**

| **Field**        | **Example**                | **Remark**                                                                                        |
| ---------------- | -------------------------- | ------------------------------------------------------------------------------------------------- |
| PrfId            | 0.24                       | [applfn\_GetBIIdWithCompany](/database/bi-overview/bi-functions.md#_toc132789802)used             |
| Process function | Buildings and Sites (0.24) | [applfn\_GetBIDescriptionWithId](/database/bi-overview/bi-functions.md#_toc132789792)used         |
| PrfRecStatus     | 1                          | <p>WHEN PrfRecStatus < 0 THEN PrfRecStatus</p><p>ELSE topPrf.PrfRecStatus (via PrfTopOfPrfId)</p> |
| PrfTopOfPrfId    | 002                        | if equals PrfId then it's a top Prf                                                               |
| PrfCompId        | 000001                     |                                                                                                   |
| FilterPrfId      | 002                        | [applfn\_GetBIFilterId](/database/bi-overview/bi-functions.md#_toc132789797) used used            |
| IsEmpty          | 0                          |                                                                                                   |

**Remarks**

Best practice is to use applv\_bi\_filterTopOfProcessFunction

**Status**

Available since 2020R1

### applv\_bi\_filterShiftLogbook <a href="#toc135647651" id="toc135647651"></a>

applv\_bi\_dimShiftLogBook

**Fields**

| **Field**    | **Example** |
| ------------ | ----------- |
| FilterShlbId | 01          |
| Logbook      | Cake line 2 |
| IsTrashed    | 0           |
| ShlbCompId   | 000001      |

**Status**

Available since 21.01.03

### applv\_bi\_filterShiftLogLine <a href="#toc135647652" id="toc135647652"></a>

applv\_bi\_dimShiftLogLine

**Fields**

| **Field**        | **Example**                                 |
| ---------------- | ------------------------------------------- |
| FilterShllId     | 0000000000038                               |
| Maintenance task | Measure noise level near crate washing line |
| IsTrashed        | 0                                           |
| ShllCompId       | 000001                                      |

**Status**

Available since 21.01.03

### applv\_bi\_filterSite <a href="#toc135647653" id="toc135647653"></a>

**Source**

applv\_bi\_dimSite

**Fields**

| **Field**   | **Example** |
| ----------- | ----------- |
| FilterSitId | 01          |
| Site        | Office (01) |
| IsTrashed   | 0           |
| SitCompId   | 000001      |

**Status**

Available since 2020R2

### applv\_bi\_filterSkipReason <a href="#toc135647654" id="toc135647654"></a>

**Source**

applv\_bi\_dimSkipReason

**Fields**

| **Field**      | **Example**              |
| -------------- | ------------------------ |
| FilterSrId     | US01                     |
| Reason to skip | Insufficient time (US01) |
| IsTrashed      | 0                        |

**Status**

Available since 21.01.03

### applv\_bi\_filterTopOfEquipment <a href="#toc135647655" id="toc135647655"></a>

**Source**

applv\_bi\_dimEquipment

**Filter**

EqmRecStatus >= 0 AND eqmid = EqmTopOfEqmId

**Fields**

| **Field**   | **Example**                |
| ----------- | -------------------------- |
| FilterEqmId | 00001                      |
| Equipment   | Forklift 1 type 35 (00001) |
| IsTrashed   | 0                          |
| EqmCompId   | 000001                     |
| IsEmpty     | 0                          |

**Status**

Available since 2020R1

### applv\_bi\_filterTopOfProcessFunction <a href="#toc135647656" id="toc135647656"></a>

**Source**

applv\_bi\_dimProcessFunction

**Filter**

PrfRecStatus >= 0 AND Prfid = PrfTopOfPrfId

**Fields**

| **Field**       | **Example**                 |
| --------------- | --------------------------- |
| FilterPrfId     | 00001                       |
| ProcessFunction | Reception workplace (00001) |
| IsTrashed       | 0                           |
| PrfCompId       | 000001                      |
| IsEmpty         | 0                           |

**Status**

Available since 2020R1

### applv\_bi\_filterWorkOrderType <a href="#toc135647657" id="toc135647657"></a>

**Source**

applv\_bi\_dimWorkOrderType

**Fields**

| **Field**   | **Example**          |
| ----------- | -------------------- |
| FilterWotId | 001                  |
| Job type    | Administration (001) |
| IsTrashed   | 0                    |

**Status**

Available since 2020R2

## Row level security <a href="#toc132789832" id="toc132789832"></a>

Used to limit access to data like our record authorization would. Prefix: applv\_bi\_RLS.\
Contains all data (dimensions) per user for which he is authorized via record authorization.

### Remarks <a href="#toc132789833" id="toc132789833"></a>

* When no record for a user, no record authorization applies, and all data is visible to the user.
* Data will always show all records that can be seen by the user even when only a subset is used when logging in.
* Configurational changes to record authorization via workflows will not be shown as they are not in the standard database
* Only most used dimensions have a view at this moment

### applv\_bi\_RLSDepartment <a href="#toc135647660" id="toc135647660"></a>

**Source**

Standard record authorization settings for user or group (SuserRecordAuthSetting, SuserRecordAuthorization, SgroupRecordAuthSetting and SgroupRecordAuthorization)

**Filter**

DepRecStatus >= 0

**Fields**

| **Field** | **Example** |
| --------- | ----------- |
| User      | Manager     |
| SiteId    | 01          |

**Status**

Available since 2020R1

### applv\_bi\_RLSSite <a href="#toc135647661" id="toc135647661"></a>

**Source**

Standard record authorization settings for user or group (SuserRecordAuthSetting, SuserRecordAuthorization, SgroupRecordAuthSetting and SgroupRecordAuthorization)

**Filter**

SitRecStatus >= 0

**Fields**

| **Field** | **Example** |
| --------- | ----------- |
| User      | JohnW       |
| DepId     | 02          |

**Status**

Available since 2020R1

### applv\_bi\_RLSSkillCat <a href="#toc135647662" id="toc135647662"></a>

**Source**

Standard record authorization settings for user or group (SuserRecordAuthSetting, SuserRecordAuthorization, SgroupRecordAuthSetting and SgroupRecordAuthorization)

**Filter**

SkcRecStatus >= 0

**Fields**

| Field | Example  |
| ----- | -------- |
| User  | Purchase |
| SkcId | 001      |

**Status**

Available since 2020R1

## Helpers

Used to help show data in the bi views that cannot (completely) be found in the database

### **applv\_bi\_helperUsedContextDescriptions**

**Purpose**

Show English context descriptions for contexts that are used in views for filtering or displaying categories

**Source**

Standard Context descriptions (as copy from datafile) and custom context descriptions from SRECORDCONTEXTCOUNTRY for tables Equipment and Cost (EN)

**Filter**

SRECXREC IN ('COST', 'EQUIPMENT' AND SrecxRecStatus >= 0 AND (SRECCCCOU IS NULL OR SRECCCCOU = 'EN')

**Fields**

| Field       | Example    |
| ----------- | ---------- |
| TableName   | Equipment  |
| Context     | 512        |
| Description | Instrument |

**Status**

Available since 24.02.21

### **applv\_bi\_helperUsedStatusDescriptions**

**Purpose**

Show English status descriptions for contexts that are used in views for displaying categories

**Source**

Standard status descriptions (as copy from datafile) and custom status descriptions from SRECORDSTATUSCOUNTRY for table BUDGETPERIOD (EN)

**Filter**

SRESTRECORD = 'BUDGETPERIOD' AND (SRECSCCOU IS NULL OR SRECSCCOU = 'EN')

**Fields**

| Field       | Example      |
| ----------- | ------------ |
| TableName   | BudgetPeriod |
| Status      | 1            |
| Description | Created      |

&#x20;**Status**

Available since 24.03.14


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://developer.ultimo.net/database/bi-overview/bi-views.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.