EN_RTG_HDR_TMP(SQL Table) |
Index Back |
|---|---|
Item Rtg Header (copy)9/97 WTK (CN# EG750-1.0) Created 11/99 HLK...Changed process_instance to eip_ctl_id so that this table may be shared with the app messaging process. 01/17/03 pwf added cum_yield onto subpanel EN_RTG_HDR_SBR |
| # | 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
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUMGOP_NONVW |
| 3 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: %EDITTABLE |
| 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 |
| 6 | RTG_STATE |
Character(2) | VARCHAR2(2) NOT NULL |
Routing State
EN=Engineering PR=Manufacturing Default Value: PR |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 9 | COPY_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
COPY_FLAG
N=No Y=Yes Y/N Table Edit Default Value: Y |
| 10 | COPY_TO_PLANNING | Character(1) | VARCHAR2(1) NOT NULL |
Copy Routing to Planning
N=No Y=Yes Y/N Table Edit Default Value: Y |
| 11 | PRIORITY_NBR | Number(3,0) | SMALLINT NOT NULL |
Priority
Default Value: 1 |
| 12 | TEXT254 | Character(254) | VARCHAR2(254) NOT NULL | Text |
| 13 | CUM_YIELD | Number(8,4) | DECIMAL(7,4) NOT NULL | Expected Yield % |
| 14 | RTG_TRANSFER_STAT | Character(1) | VARCHAR2(1) NOT NULL | Routing Transfer Status |