EN_RTG_EREIP_VW

(SQL View)
Index Back

RoutingTransfer Error Messages

11/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