SF_OP_LIST2_VW

(SQL View)
 Index Back

Production's Op List View

10/15/98 CN#SF800-17.0 dfl - Add new field, count_point. 8/27/02 CN#MG880 - Add new fields ASSY_STARTS_QTY, EXPECTD_CMPL_QTY, FIXED_SCRAP_QTY, CONTINUOUS_FLG, IGNORE_CAPACITY, ASSY_STARTS_FACTOR, EXPECTD_CMPL_FACTR. 5/25/06 MMT - Adding new field SUB_ITM_ID

SELECT business_unit , production_id , op_sequence , task_code , task_intensity , crewsize , mach_resources , count_point , subcontracted , vendor_id , sub_item_id , subpo_status , work_center_code , qty_iss_to_op , qty_comp_and_at , qty_comp_and_thru , qty_scrapped , percent_comp , operation_yield , op_completed , setup_earned , post_prod_earned , op_overlap , send_ahead_qty , op_start_dt , op_start_time , op_start_shift , op_end_dt , op_end_time , op_end_shift , op_run_start_dt , op_run_start_time , op_run_start_shift , op_prdn_start_dt , op_prdn_start_shft , op_prdn_end_dt , op_prdn_end_shft , op_prdn_run_st_dt , op_prdn_run_st_sh , sim_setup_queue , conversion_code , con_oh_code_1 , con_oh_code_2 , con_oh_code_3 , con_oh_code_4 , process_instance , plan_frozen_flg , assy_starts_qty , expectd_cmpl_qty , fixed_scrap_qty , continuous_flg , ignore_capacity , text254 FROM PS_SF_OP_LIST

# 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

2 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
3 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
4 TASK_CODE Character(6) VARCHAR2(6) NOT NULL Task Code
5 TASK_INTENSITY Character(1) VARCHAR2(1) NOT NULL Intensity
0=Labor Time
1=Mach Time
2=Longest
3=Cumulative

Default Value: 2

6 CREWSIZE Number(7,2) DECIMAL(6,2) NOT NULL Crew Size
7 MACH_RESOURCES Number(7,2) DECIMAL(6,2) NOT NULL Machine Resources
8 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

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

Y/N Table Edit

Default Value: N

10 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
11 SUB_ITEM_ID Character(18) VARCHAR2(18) NOT NULL 11/02/05 EGS: Created
12 SUBPO_STATUS Character(2) VARCHAR2(2) NOT NULL Subcontract PO Creation Status
10=None
20=Ready for POBuild
30=InProcess POBuild
40=Completed POBuild

Default Value: 10

13 WORK_CENTER_CODE Character(10) VARCHAR2(10) NOT NULL Work Center
14 QTY_ISS_TO_OP Number(12,4) DECIMAL(11,4) NOT NULL Quantity Issued to Operation
15 QTY_COMP_AND_AT Number(12,4) DECIMAL(11,4) NOT NULL Qty Completed and at Operation
16 QTY_COMP_AND_THRU Number(12,4) DECIMAL(11,4) NOT NULL Qty Completed and Thru Oper
17 QTY_SCRAPPED Number(12,4) DECIMAL(11,4) NOT NULL Assembly Qty Scrapped at Op
18 PERCENT_COMP Number(6,2) DECIMAL(5,2) NOT NULL Scrap Prdn Pct
19 OPERATION_YIELD Number(8,4) DECIMAL(7,4) NOT NULL Operation Yield

Default Value: 100

20 OP_COMPLETED Character(1) VARCHAR2(1) NOT NULL Operation Completed

Y/N Table Edit

Default Value: N

21 SETUP_EARNED Character(1) VARCHAR2(1) NOT NULL Setup Earned

Y/N Table Edit

Default Value: N

22 POST_PROD_EARNED Character(1) VARCHAR2(1) NOT NULL Post Production Earned

Y/N Table Edit

Default Value: N

23 OP_OVERLAP Number(5,1) DECIMAL(4,1) NOT NULL CN#PL800-20.0 MACN 06/14/99- Changed the short name
24 SEND_AHEAD_QTY Number(12,4) DECIMAL(11,4) NOT NULL Send Ahead Quantity
25 OP_START_DT Date(10) DATE Operation Start Date
26 OP_START_TIME Time(15) TIMESTAMP Operation's Start Time
27 OP_START_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Operation's Start Shift
28 OP_END_DT Date(10) DATE Operation Due Date
29 OP_END_TIME Time(15) TIMESTAMP Operation's Due Time
30 OP_END_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Operation's Due Shift
31 OP_RUN_START_DT Date(10) DATE Operation's Run Start Date
32 OP_RUN_START_TIME Time(15) TIMESTAMP Operation's Run Start Time
33 OP_RUN_START_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Operation's Run Start Shift
34 OP_PRDN_START_DT Date(10) DATE Operation's Prdn Start Date
35 OP_PRDN_START_SHFT Number(1,0) SMALLINT NOT NULL Operation's Prdn Start Shift
36 OP_PRDN_END_DT Date(10) DATE Operation's Prdn Due Date
37 OP_PRDN_END_SHFT Number(1,0) SMALLINT NOT NULL Operation's Prdn Due Shift
38 OP_PRDN_RUN_ST_DT Date(10) DATE Operation Prdn Run Start Date
39 OP_PRDN_RUN_ST_SH Number(1,0) SMALLINT NOT NULL Operation Prdn Run Start Shift
40 SIM_SETUP_QUEUE Character(1) VARCHAR2(1) NOT NULL Simultaneous Setup and Queue

Y/N Table Edit

Default Value: N

41 CONVERSION_CODE Character(4) VARCHAR2(4) NOT NULL Conversion Code
42 CON_OH_CODE_1 Character(4) VARCHAR2(4) NOT NULL First Conversion Ovhd Code
43 CON_OH_CODE_2 Character(4) VARCHAR2(4) NOT NULL Second Conversion Ovhd Code
44 CON_OH_CODE_3 Character(4) VARCHAR2(4) NOT NULL Third Conversion Ovhd Code
45 CON_OH_CODE_4 Character(4) VARCHAR2(4) NOT NULL Fourth Conversion Ovhd Code
46 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
47 PLAN_FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL 11/01/01 PCL (CN#PL900-1): Updated
N=No
Y=Yes

Default Value: N

48 ASSY_STARTS_QTY Number(12,4) DECIMAL(11,4) NOT NULL Assembly Starts Qty
49 EXPECTD_CMPL_QTY Number(12,4) DECIMAL(11,4) NOT NULL Expected Completions Qty
50 FIXED_SCRAP_QTY Number(12,4) DECIMAL(11,4) NOT NULL YBO Enhancement
51 CONTINUOUS_FLG Character(1) VARCHAR2(1) NOT NULL 08/29/01 EGS (CN#PL900-1): Added.

Default Value: N

52 IGNORE_CAPACITY Character(1) VARCHAR2(1) NOT NULL 08/29/01 EGS (CN#PL900-1): Added.

Default Value: N

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