RUN_CNTL_EN1003(SQL Table) |
Index Back |
|---|---|
Master Rtg Where Used Rpt Rec03/31/99 Lee CN#EN800-12.0 Initial create. 7/18/99 lee changed prompt for items to en_rtg_mst_p_vw 10/26/99 lee - added product_version to control heading for eng & mfg. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUMGOP_NONVW |
| 5 | RTG_STATE | Character(2) | VARCHAR2(2) NOT NULL |
Routing State
EN=Engineering PR=Manufacturing Default Value: EN |
| 6 | RTG_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Routing Type
PR=Production RW=Rework TD=Teardown Default Value: PR |
| 7 | SEL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Selection
A=All Status R=Range Stat Default Value: A |
| 8 | REF_ROUTING_ITEM | Character(18) | VARCHAR2(18) NOT NULL |
Reference Routing Item
Prompt Table: EN_RTG_MST_P_VW |
| 9 | EN_ITEM_TO_ID | Character(18) | VARCHAR2(18) NOT NULL |
To Item ID
Prompt Table: EN_RTG_MST_P_VW |
| 10 | PS_DATE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Production Schedule date Opt
A=All R=Range Default Value: A |
| 11 | PS_DATE_FROM | Date(10) | DATE | Production Schedule From Date |
| 12 | PS_DATE_TO | Date(10) | DATE | Production Schedule Date To |
| 13 | PRINT_DETAILS | Character(1) | VARCHAR2(1) NOT NULL |
Print Details
N=No Y=Yes |
| 14 | PS_PRINT_ENTERED | Character(1) | VARCHAR2(1) NOT NULL |
3/24/98 rlk - Change rftshort to "Firm" to work with run_sfs2004 panel
Y/N Table Edit |
| 15 | PS_PRINT_FIRM | Character(1) | VARCHAR2(1) NOT NULL |
3/24/98 rlk - Change rftshort to "Firm" to work with run_sfs2004 panel
Y/N Table Edit |
| 16 | PS_PRINT_RELEASED | Character(1) | VARCHAR2(1) NOT NULL |
3/26/98 rlk - Changed rftshort to "Released" to work with run_sfs2004 panel.
Y/N Table Edit |
| 17 | PS_PRINT_INPROCESS | Character(1) | VARCHAR2(1) NOT NULL |
3/24/98 rlk - Change rftshort to "In Process" to work with run_sfs2004 panel
Y/N Table Edit |
| 18 | PS_PRINT_PEND_COMP | Character(1) | VARCHAR2(1) NOT NULL |
3/25/98 rlk - Change rftlong to "Pending Complete" so it works with run_sfs2004 panel
Y/N Table Edit |
| 19 | PS_PRINT_COMPLETE | Character(1) | VARCHAR2(1) NOT NULL |
3/23/98 rlk - Change rftshort to "Complete" to work with RUN_SFS2004 panel
Y/N Table Edit |
| 20 | PS_PRINT_CLS_LAB | Character(1) | VARCHAR2(1) NOT NULL |
3/23/98 rlk - Change rftshort to "Clsd Labor" to work on RUN_SFS2004
Y/N Table Edit |
| 21 | PS_PRINT_CLS_ACTG | Character(1) | VARCHAR2(1) NOT NULL |
3/23/98 rlk - Change rftshort to Clsd Acctg so can use in panel RUN_SFS2004.
Y/N Table Edit |
| 22 | PS_PRINT_CANCELLED | Character(1) | VARCHAR2(1) NOT NULL |
3/23/98 rlk - Changed rftshort to "Canceled" so can use on RUN_SFS2004 panel
Y/N Table Edit |
| 23 | PRODUCT_VERSION | Character(25) | VARCHAR2(25) NOT NULL | Product Version |