EN_RTG_EREIP_VW(SQL View) |
Index Back |
---|---|
RoutingTransfer Error Messages11/99 LAJ...Since process_instance was replaced with eip_ctl_id in the exceptions table, created this view to link the exceptions table to en_trns_tmp to get the process_instance. |
SELECT A.EIP_CTL_ID , A.BUSINESS_UNIT ,A.BUSINESS_UNIT_TO , A.INV_ITEM_ID , A.RTG_STATE , A.RTG_TYPE , RTG_CODE , A.MESSAGE_SET_NBR , A.MESSAGE_NBR ,A.COPY_DIRECTION , A.RUN_CNTL_ID , A.BOM_TRANSFER_STAT , B.PROCESS_INSTANCE FROM PS_EN_RTG_ERR_TMP A , PS_EN_TRNS_TMP B WHERE A.EIP_CTL_ID = B.EIP_CTL_ID |
# | 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 |
3 | BUSINESS_UNIT_TO | Character(5) | VARCHAR2(5) NOT NULL | 04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT |
4 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
5 | RTG_STATE | Character(2) | VARCHAR2(2) NOT NULL |
Routing State
EN=Engineering PR=Manufacturing |
6 | RTG_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Routing Type
PR=Production RW=Rework TD=Teardown |
7 | RTG_CODE | Number(2,0) | SMALLINT NOT NULL | Routing Code |
8 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
9 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
10 | COPY_DIRECTION | Character(2) | VARCHAR2(2) NOT NULL |
Copy From/To
EE=Engineering to Engineering EM=Engineering to Manufacturing ME=Manufacturing to Engineering |
11 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
12 | BOM_TRANSFER_STAT | Character(1) | VARCHAR2(1) NOT NULL |
02/01/00 LAJ
Took the word "Transfer" out of the label, since we now display this field for BOM Mass Maintenance Error correction.
Also added new translate (Update) to distiguish between the EG transfer process status and the BOM Mass Maintenance Status
05/18/00 LAJ
Added new label id for BOM results. This is used by the Mass Maint staged results panelgroup.
E=Error O=No Change T=Transfer U=No Errors W=Warning |
13 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |