BAS_WC_WCOUDT_OU_LEV_WCDET
This is a work center master table that stores certificate level codes for 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.
Primary key
WCOUDT_WORK_CENTER, WCOUDT_OUINSTANCE
Columns (32)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | WCOUDT_OUINSTANCE 🔑 | varchar | Work center operating details organization unit instance |
| 2 | WCOUDT_WORK_CENTER 🔑 | varchar | Work center identifier |
| 3 | WCOUDT_ROTA_SCHEDULE_CODE | varchar | Rota schedule code |
| 4 | WCOUDT_WORK_PHONE | varchar | Work center phone number |
| 5 | WCOUDT_COMMENTS | decimal | Comments regarding work center operations |
| 6 | WCOUDT_ROTA_SCHCODE_OU | varchar | Organization unit of rota schedule code |
| 7 | WCOUDT_STATION_CODE | decimal | Station code of the work center |
| 8 | WCOUDT_STATION_OU | varchar | Station organization unit |
| 9 | WCOUDT_LUNCH_START_TIME | varchar | Lunch start time for work center |
| 10 | WCOUDT_LUNCH_END_TIME | varchar | Lunch end time for work center |
| 11 | WCOUDT_DINNER_START_TIME | varchar | Dinner start time for work center |
| 12 | WCOUDT_DINNER_END_TIME | varchar | Dinner end time for work center |
| 13 | wcoudt_hangarjob | varchar | Hangar jobs flag |
| 14 | wcoudt_shopjob | varchar | Shop jobs flag |
| 15 | wcoudt_linejob | varchar | Line jobs flag |
| 16 | wcoudt_alljob | varchar | Flag indicating all jobs |
| 17 | wcoudt_cost_center | varchar | Cost center associated with work center |
| 18 | wcoudt_AutoLineSch | varchar | Flag for automatic line scheduling |
| 19 | wcoudt_ref_wc | varchar | Reference work center |
| 20 | WcOuDt_SignOffStmnts | varchar | Sign-off statements |
| 21 | subscoutt_geofen | varchar | Geofence information |
| 22 | subscoutt_latdir | varchar | Latitude direction (N/S) |
| 23 | subscoutt_latitude | varchar | Latitude value |
| 24 | subscoutt_longdir | varchar | Longitude direction (E/W) |
| 25 | subscoutt_longitude | int | Longitude value |
| 26 | subscoutt_radius | varchar | Geofence radius |
| 27 | WCOUDT_Fin_book | varchar | Financial book associated with work center |
| 28 | wcoudt_skip_cap | datetime | Flag to skip capacity checks |
| 29 | wcoudt_Addl_BF_End_Time | datetime | Additional backflush end time |
| 30 | wcoudt_Addl_BF_Start_Time | datetime | Additional backflush start time |
| 31 | wcoudt_Brkfst_End_Time | datetime | Breakfast end time |
| 32 | wcoudt_Brkfst_Start_Time | decimal | Breakfast start time |
Sample rows (from live DB)
WCOUDT_OUINSTANCE | WCOUDT_WORK_CENTER | WCOUDT_ROTA_SCHEDULE_CODE | WCOUDT_WORK_PHONE | WCOUDT_COMMENTS | WCOUDT_ROTA_SCHCODE_OU |
|---|---|---|---|---|---|
| 2.0 | 09809 | — | — | — | — |
| 2.0 | 10 | — | — | hechhh | — |
| 2.0 | 100-00 | — | 784565 | — | — |
Showing 3 of 840 rows.