BAS_CM_PRI_PRIORITY_NUMBER
This stores the priority number. The execution planning of different maintenance activities is based on their respective levels of urgency and importance, which is expressed through the assigned priority numbers.
Process: MAINTPLANNING · Component: BASCm · Table type: Master Table Category: Provides master data for task definitions, sub-task definitions and task zones used in maintenance and operational planning.
This table is the canonical store for the Priority entity.
Primary key
PRI_PRIORITY, PRI_OUINSTANCE
Columns (11)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | PRI_OUINSTANCE 🔑 | #N/A | Organization Unit instance for the priority record |
| 2 | PRI_PRIORITY 🔑 | varchar | Priority code |
| 3 | PRI_DESCRIPTION | varchar | Description of the priority |
| 4 | PRI_DESCRIPTION_UP | varchar | Priority description in uppercase |
| 5 | PRI_STATUS | varchar | Status of the priority |
| 6 | PRI_COMMENTS | varchar | Comments related to the priority |
| 7 | PRI_CREATED_BY | varchar | User who created the priority record |
| 8 | PRI_MODIFIED_BY | datetime | User who last modified the priority record |
| 9 | PRI_CREATIONDATE | datetime | Date when the priority record was created |
| 10 | PRI_MODIFIEDDATE | #N/A | Date when the priority record was last modified |
| 11 | PRI_TIMESTAMP | varchar | Timestamp of the priority record |
Relationships (1)
- ShopWorkOrder (swo_swoh_shop_wo_hdr) →
HAS_PRIORITY(this table is target)- Join:
swo_swoh_shop_wo_hdr.swoh_swo_priority_no = BAS_CM_PRI_PRIORITY_NUMBER.PRI_PRIORITY_NO - SWO has priority level
- Join:
Sample rows (from live DB)
PRI_OUINSTANCE | PRI_PRIORITY | PRI_DESCRIPTION | PRI_DESCRIPTION_UP | PRI_STATUS | PRI_COMMENTS |
|---|---|---|---|---|---|
| 2.0 | 2.0 | NRM | Normal | A | — |
| 2.0 | 3.0 | High | High | A | — |
| 2.0 | 4.0 | PR-3 | Priority-3 | I | — |
Showing 3 of 18 rows.