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 |