EN_TRN_ERR4_VW (SQL View)	Index Back
Transfer Exceptions View 11/14/97 WTK CN#EG750-5.0 : Created 11/99 LAJ...Since process_instance was replaced with eip_ctl_id in the exceptions table, added link to table en_trns_tmp to get the process_instance. Also had to add DISTINCT, now that there are multiple rows in the en_trns_tmp table for one process_instance.

EN_TRN_ERR4_VW

(SQL View)

Transfer Exceptions View

11/14/97 WTK CN#EG750-5.0 : Created 11/99 LAJ...Since process_instance was replaced with eip_ctl_id in the exceptions table, added link to table en_trns_tmp to get the process_instance. Also had to add DISTINCT, now that there are multiple rows in the en_trns_tmp table for one process_instance.

SELECT DISTINCT B.PROCESS_INSTANCE , A.RUN_CNTL_ID , A.BUSINESS_UNIT FROM PS_EN_TRN_ERR_HDR 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 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUMGOP_NONVW