EN_RTG_OPS_TMP

(SQL Table)
Index Back

Item Rtg Ops (transfer)

9/97 WTK Created 11/99 LAJ...Changed process_instance to eip_ctl_id so that this table may be shared with the app messaging process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BUS_UNIT_OPT_MG

3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: MG_ITEM_OWN_VW

4 RTG_TYPE Character(2) VARCHAR2(2) NOT NULL Routing Type
PR=Production
RW=Rework
TD=Teardown

Default Value: PR

5 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code

Default Value: 1

6 RTG_STATE Character(2) VARCHAR2(2) NOT NULL Routing State
EN=Engineering
PR=Manufacturing

Default Value: PR

7 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
8 TASK_CODE Character(6) VARCHAR2(6) NOT NULL Task Code

Prompt Table: %EDITTABLE14

9 TASK_INTENSITY Character(1) VARCHAR2(1) NOT NULL Intensity
0=Labor Time
1=Mach Time
2=Longest
3=Cumulative

Default Value: 2

10 CREWSIZE Number(7,2) DECIMAL(6,2) NOT NULL Crew Size
11 MACH_RESOURCES Number(7,2) DECIMAL(6,2) NOT NULL Machine Resources
12 COUNT_POINT Character(1) VARCHAR2(1) NOT NULL 3/22/2000 dfl - Change short name from cnt ptr to cnt pt, more std.
N=No
Y=Yes

Y/N Table Edit

Default Value: N

13 SUBCONTRACTED Character(1) VARCHAR2(1) NOT NULL Subcontracted
N=No
Y=Yes

Y/N Table Edit

Default Value: N

14 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_PO_VW

15 SUB_ITEM_ID Character(18) VARCHAR2(18) NOT NULL 11/02/05 EGS: Created
16 WORK_CENTER_CODE Character(10) VARCHAR2(10) NOT NULL Work Center

Prompt Table: EN_WORK_CENTER

17 OPERATION_YIELD Number(8,4) DECIMAL(7,4) NOT NULL Operation Yield

Default Value: 100

18 FIXED_SCRAP_QTY Number(12,4) DECIMAL(11,4) NOT NULL YBO Enhancement
19 OPERATION_FLOAT Character(1) VARCHAR2(1) NOT NULL Allow Operation Float

Y/N Table Edit

20 OP_OVERLAP Number(5,1) DECIMAL(4,1) NOT NULL CN#PL800-20.0 MACN 06/14/99- Changed the short name
21 SEND_AHEAD_QTY Number(12,4) DECIMAL(11,4) NOT NULL Send Ahead Quantity
22 SIM_SETUP_QUEUE Character(1) VARCHAR2(1) NOT NULL Simultaneous Setup and Queue

Y/N Table Edit

Default Value: N

23 CONVERSION_CODE Character(4) VARCHAR2(4) NOT NULL Conversion Code

Prompt Table: CE_CONCODE

24 CON_OH_CODE_1 Character(4) VARCHAR2(4) NOT NULL First Conversion Ovhd Code

Prompt Table: CE_CONOH_CODE

25 CON_OH_CODE_2 Character(4) VARCHAR2(4) NOT NULL Second Conversion Ovhd Code

Prompt Table: CE_CONOH_CODE

26 CON_OH_CODE_3 Character(4) VARCHAR2(4) NOT NULL Third Conversion Ovhd Code

Prompt Table: CE_CONOH_CODE

27 CON_OH_CODE_4 Character(4) VARCHAR2(4) NOT NULL Fourth Conversion Ovhd Code

Prompt Table: CE_CONOH_CODE

28 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text