EG_RTG_AUDIT

(SQL Table)
Index Back

Routing Time Stamped Audit

CN#EG750-4.0 dbe (Engineering Routings) - New record to support audit of Routing Copy. 11/03/99 LAJ...Added default of 1 to RTG_CODE to be consistent with the BOM audit table. 12/07/99 TKI Removed FieldDefault code from OPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUMGOP_NONVW

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: EG_BOM_AUD_P_VW

3 RTG_TYPE Character(2) VARCHAR2(2) NOT NULL Routing Type
PR=Production
RW=Rework
TD=Teardown

Default Value: PR

4 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code

Default Value: 1

5 EG_DATETIME DateTime(26) TIMESTAMP NOT NULL Copy Date / Time
6 COPY_DIRECTION Character(2) VARCHAR2(2) NOT NULL Copy From/To
EE=Engineering to Engineering
EM=Engineering to Manufacturing
ME=Manufacturing to Engineering
7 ECO_ID Character(10) VARCHAR2(10) NOT NULL ECO Number
8 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
9 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
10 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).