BAS_WC_WCUSR_WC_USER_MAP
This is a work center master table that maps users to work centers. It provides reference data used by transaction tables to allocate resources, assign capacity, and map facilities or certificates to operations.
Process: MAINTPLANNING · Component: BASWc · Table type: Master Table Category: Defines master setup of work centers, facilities, capacity, and certifications that transactions reference for planning and execution.
This table is the canonical store for the WorkCenterUser entity.
Primary key
WCUSR_WORK_CENTER, WCUSR_USER_ID, WCUSR_OUINSTANCE
Columns (7)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | WCUSR_OUINSTANCE 🔑 | varchar | Work center user organization unit instance |
| 2 | WCUSR_WORK_CENTER 🔑 | varchar | Work center identifier |
| 3 | WCUSR_USER_ID 🔑 | varchar | User ID associated with the work center |
| 4 | WCUSR_CHILDWC_ALLOW_FLAG | decimal | Flag indicating if child work centers are allowed for the user |
| 5 | WCUSR_TIMESTAMP | varchar | Timestamp of user record |
| 6 | wcusr_created_by | datetime | User who created the record |
| 7 | wcusr_created_date | decimal | User record creation date |
Sample rows (from live DB)
WCUSR_OUINSTANCE | WCUSR_WORK_CENTER | WCUSR_USER_ID | WCUSR_CHILDWC_ALLOW_FLAG | WCUSR_TIMESTAMP | wcusr_created_by |
|---|---|---|---|---|---|
| 2.0 | 09809 | gthangar | — | 1.0 | — |
| 2.0 | 10 | admin | — | 1.0 | — |
| 2.0 | 10 | DMUSER | — | 1.0 | — |
Showing 3 of 50,000 rows.