EN_CREW(SQL Table) |
Index Back |
|---|---|
CrewsCN#PL800-21.0, 24.0 & 33.0 MACN 5/21/99 - Removed PLANNING_INSTANCE. Renamed AGGREGATE_BUCKET to PLAN_BUCKET, CAL_DEDICATED_FLG to TASK_WRAP. Also added new field IGNORE_VIOLATIONS. CN#PL800-33.0 MACN 07/13/99 - Removed AGGREGATE_TIME, AGGREGATE_UNIT & OP_TIME_UNIT. Added AVAIL_PERCENTAGE 10/07/99 EGS (DI-ESTAUFFE-11): removed DEDICATED_FLG. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUMGOP_NONVW |
| 2 | CREW_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Crew Name |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | CREWSIZE | Number(7,2) | DECIMAL(6,2) NOT NULL | Crew Size |
| 6 | CREW_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Crew Status
01=Pending 02=Available 03=Unavailable Default Value: 01 |
| 7 | AGGREGATE_OPT_PL | Character(1) | VARCHAR2(1) NOT NULL |
CN#PL800-21.0,24,0&33.0 MACN 5/21/99 - Changed the long/short name to match with Supply Chain Planning. Also added a new translate value '2' for aggregate by unit.
0=Detailed Planning 1=Aggregate Resource by Time 2=Aggregate Resource by Unit Default Value: 0 |
| 8 | PLAN_BUCKET | Character(1) | VARCHAR2(1) NOT NULL |
08/03/99 MACN (CN#PL800-33.0) Changed the translate values from D, W, M to 0, 1, 2
0=Daily 1=Weekly 2=Monthly Default Value: 1 |
| 9 | AGGREGATE_STRATEGY | Character(1) | VARCHAR2(1) NOT NULL |
CN#PL800-21.0,24,0&33.0 MACN 5/21/99 - Changed the long/short name to match with Supply Chain Planning.
0=Start 1=Finish 2=Proportional Default Value: 2 |
| 10 | AGGREGATE_REPAIR | Character(1) | VARCHAR2(1) NOT NULL |
Aggregate Repair Option
0=None 1=Score Capacity 2=Repair Capacity Default Value: 2 |
| 11 | AVAIL_PERCENTAGE | Number(3,0) | SMALLINT NOT NULL | CN#PL800-33.0 MACN 07/13/99 - Utilization factor for aggregate resources. |
| 12 | TASK_WRAP | Character(1) | VARCHAR2(1) NOT NULL |
Task Wrap Flag
Y/N Table Edit Default Value: Y |
| 13 | TEXT254 | Character(254) | VARCHAR2(254) NOT NULL | Text |
| 14 | CALENDAR_CODE | Character(10) | VARCHAR2(10) NOT NULL |
This code is for a group of dates associated with exchange (stock, money, commodity) traded future or option contracts.
Prompt Table: MG_CAL_CODE_VW |
| 15 | IGNORE_VIOLATIONS | Character(1) | VARCHAR2(1) NOT NULL |
CN#PL800-21.0,24,0&33.0 MACN 5/21/99 - Created to differrentiate resources that should be repaired or not repaired.
N=N Y=Y Default Value: N |