SPL_DETAIL_AET

(SQL Table)
Index Back

Resource Details

01/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