PROCESS_INSTANCE10=Primary Crew
20=Alt Crew
30=Primary Machine
40=Alt Machine
50=Primary Tool
60=Alternate Tool
SPL_DETAIL_AET(SQL Table) |
Index Back |
|---|---|
Resource Details01/16/03 JC (CN#PL880-1): Added |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | PROBINST | Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 3 | RESRC_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Resource Type
10=Primary Crew 20=Alt Crew 30=Primary Machine 40=Alt Machine 50=Primary Tool 60=Alternate Tool |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | CREW_CODE | Character(10) | VARCHAR2(10) NOT NULL | Crew Name |
| 6 | MACHINE_CODE | Character(10) | VARCHAR2(10) NOT NULL | Machine Code |
| 7 | TOOL_CODE | Character(10) | VARCHAR2(10) NOT NULL | Tool ID |
| 8 | SPL_RESOURCE_DTTM | DateTime(26) | TIMESTAMP | 01/16/03 JC (CN#PL880-1): Added |
| 9 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 10 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 11 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 12 | WORK_CENTER_CODE | Character(10) | VARCHAR2(10) NOT NULL | Work Center |
| 13 | SPL_RES_NEEDED | Number(12,4) | DECIMAL(11,4) NOT NULL | 01/16/03 JC (CN#PL880-1): Added |
| 14 | SPL_RES_RELEASED | Number(12,4) | DECIMAL(11,4) NOT NULL | 01/16/03 JC (CN#PL880-1): Added |