SF_ACTHRS_OP_VW

(SQL View)
 Index Back

Production Operation List

Duplication of sf_op_list for actual hours processing. 05/23/2000 SPL Changed SELECT * statement to explicitly list all fields.

SELECT business_unit , production_id , op_sequence , task_code , task_intensity , crewsize , mach_resources , count_point , subcontracted , vendor_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 , 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

Prompt Table: SP_BUMGOP_NONVW

2 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID

Prompt Table: SF_OP_MTN_VW

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

Prompt Table: %EDITTABLE14

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

Prompt Table: VENDOR_PO_VW

11 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

12 WORK_CENTER_CODE Character(10) VARCHAR2(10) NOT NULL Work Center

Prompt Table: EN_WORK_CENTER

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

Default Value: 100

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Prompt Table: CE_CONCODE

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

Prompt Table: CE_CONOH_CODE

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

Prompt Table: CE_CONOH_CODE

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

Prompt Table: CE_CONOH_CODE

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

Prompt Table: CE_CONOH_CODE

45 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
46 PLAN_FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL 11/01/01 PCL (CN#PL900-1): Updated
N=No
Y=Yes

Default Value: N

47 ASSY_STARTS_QTY Number(12,4) DECIMAL(11,4) NOT NULL Assembly Starts Qty
48 EXPECTD_CMPL_QTY Number(12,4) DECIMAL(11,4) NOT NULL Expected Completions Qty
49 FIXED_SCRAP_QTY Number(12,4) DECIMAL(11,4) NOT NULL YBO Enhancement
50 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text