SF_OP_LIST_FS(SQL View) |
Index Back |
|---|---|
Production's Operation List |
| SELECT business_unit , production_id , op_sequence , task_code , task_intensity , crewsize , mach_resources , 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 , 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 | SUBCONTRACTED | Character(1) | VARCHAR2(1) NOT NULL |
Subcontracted
N=No Y=Yes Y/N Table Edit Default Value: N |
| 9 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 10 | 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 |
| 11 | WORK_CENTER_CODE | Character(10) | VARCHAR2(10) NOT NULL | Work Center |
| 12 | QTY_ISS_TO_OP | Number(12,4) | DECIMAL(11,4) NOT NULL | Quantity Issued to Operation |
| 13 | QTY_COMP_AND_AT | Number(12,4) | DECIMAL(11,4) NOT NULL | Qty Completed and at Operation |
| 14 | QTY_COMP_AND_THRU | Number(12,4) | DECIMAL(11,4) NOT NULL | Qty Completed and Thru Oper |
| 15 | QTY_SCRAPPED | Number(12,4) | DECIMAL(11,4) NOT NULL | Assembly Qty Scrapped at Op |
| 16 | PERCENT_COMP | Number(6,2) | DECIMAL(5,2) NOT NULL | Scrap Prdn Pct |
| 17 | OPERATION_YIELD | Number(8,4) | DECIMAL(7,4) NOT NULL |
Operation Yield
Default Value: 100 |
| 18 | OP_COMPLETED | Character(1) | VARCHAR2(1) NOT NULL |
Operation Completed
Y/N Table Edit Default Value: N |
| 19 | SETUP_EARNED | Character(1) | VARCHAR2(1) NOT NULL |
Setup Earned
Y/N Table Edit Default Value: N |
| 20 | POST_PROD_EARNED | Character(1) | VARCHAR2(1) NOT NULL |
Post Production Earned
Y/N Table Edit Default Value: N |
| 21 | OP_OVERLAP | Number(5,1) | DECIMAL(4,1) NOT NULL | CN#PL800-20.0 MACN 06/14/99- Changed the short name |
| 22 | SEND_AHEAD_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Send Ahead Quantity |
| 23 | OP_START_DT | Date(10) | DATE | Operation Start Date |
| 24 | OP_START_TIME | Time(15) | TIMESTAMP | Operation's Start Time |
| 25 | OP_START_SHIFT | Signed Number(2,0) | DECIMAL(1) NOT NULL | Operation's Start Shift |
| 26 | OP_END_DT | Date(10) | DATE | Operation Due Date |
| 27 | OP_END_TIME | Time(15) | TIMESTAMP | Operation's Due Time |
| 28 | OP_END_SHIFT | Signed Number(2,0) | DECIMAL(1) NOT NULL | Operation's Due Shift |
| 29 | OP_RUN_START_DT | Date(10) | DATE | Operation's Run Start Date |
| 30 | OP_RUN_START_TIME | Time(15) | TIMESTAMP | Operation's Run Start Time |
| 31 | OP_RUN_START_SHIFT | Signed Number(2,0) | DECIMAL(1) NOT NULL | Operation's Run Start Shift |
| 32 | OP_PRDN_START_DT | Date(10) | DATE | Operation's Prdn Start Date |
| 33 | OP_PRDN_START_SHFT | Number(1,0) | SMALLINT NOT NULL | Operation's Prdn Start Shift |
| 34 | OP_PRDN_END_DT | Date(10) | DATE | Operation's Prdn Due Date |
| 35 | OP_PRDN_END_SHFT | Number(1,0) | SMALLINT NOT NULL | Operation's Prdn Due Shift |
| 36 | OP_PRDN_RUN_ST_DT | Date(10) | DATE | Operation Prdn Run Start Date |
| 37 | OP_PRDN_RUN_ST_SH | Number(1,0) | SMALLINT NOT NULL | Operation Prdn Run Start Shift |
| 38 | SIM_SETUP_QUEUE | Character(1) | VARCHAR2(1) NOT NULL |
Simultaneous Setup and Queue
Y/N Table Edit Default Value: N |
| 39 | CONVERSION_CODE | Character(4) | VARCHAR2(4) NOT NULL | Conversion Code |
| 40 | CON_OH_CODE_1 | Character(4) | VARCHAR2(4) NOT NULL | First Conversion Ovhd Code |
| 41 | CON_OH_CODE_2 | Character(4) | VARCHAR2(4) NOT NULL | Second Conversion Ovhd Code |
| 42 | CON_OH_CODE_3 | Character(4) | VARCHAR2(4) NOT NULL | Third Conversion Ovhd Code |
| 43 | CON_OH_CODE_4 | Character(4) | VARCHAR2(4) NOT NULL | Fourth Conversion Ovhd Code |
| 44 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 45 | PLAN_FROZEN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
11/01/01 PCL (CN#PL900-1): Updated
N=No Y=Yes Default Value: N |
| 46 | TEXT254 | Character(254) | VARCHAR2(254) NOT NULL | Text |