EN_REV_STG

(SQL Table)
Index Back

Item Revision (Status)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: MG_ITEM_OWN_VW

4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUMGOP_NONVW

5 DATE_IN_EFFECT Date(10) DATE NOT NULL 01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label
6 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label

Prompt Table: EN_REV_SCH_VW

7 DATE_OBSOLETE Date(10) DATE Obsolete Date
8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
9 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text
10 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
11 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag