TR_EVENT_CHANGE (SQL Table)	Index Back
What's Changed Table Contains the data that has changed for a rowset for a given event.

TR_EVENT_CHANGE

(SQL Table)

What's Changed Table

Contains the data that has changed for a rowset for a given event.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EVENT_TRACKING_ID Number(10,0) DECIMAL(10) NOT NULL The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID.

2 EVENT_CODE Character(15) VARCHAR2(15) NOT NULL Event code that corresponds to a specific type of event. Can be used for finer filtering of events.
Prompt Table: TR_EVENT_CD_TBL
Set Control Field: EVENT_CODE

3 EVENT_SEQUENCE Character(40) VARCHAR2(40) NOT NULL Event Sequence Number

4 EVENT_CHANGE_ID Number(10,0) DECIMAL(10) NOT NULL Unique identifier for a changed field on a given event instance.

5 EVENT_FIELD_NAME Character(254) VARCHAR2(254) NOT NULL For a change event this field holds the field name.

6 RECORDNAME Character(15) VARCHAR2(15) NOT NULL Record Name
01=MASTER_ITEM_EC
02=INV_ITEMS_EC
03=BU_ITM_INV_EC
04=BU_ITM_WTVL_EC
05=ITEM_SUPPLIER_EC
06=ITM_SUPP_LOC_EC
07=ITM_VNDR_UOM_EC
08=ITM_VND_UMPR_EC
09=INV_ITM_UOM_EC
10=PUR_ITM_ATTR_EC
13=EN_REVISION_EC
14=ITEM_MFG_GPO_EC
15=ITEM_MFG_EC
16=ITEM_CAT_EC

7 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

8 EVENT_OLD_VALUE Character(254) VARCHAR2(254) NOT NULL For a change event this field holds the old value.

9 EVENT_NEW_VALUE Character(254) VARCHAR2(254) NOT NULL For a change event this field holds the new value.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EVENT_TRACKING_ID	Number(10,0)	DECIMAL(10) NOT NULL	The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID.
2	EVENT_CODE	Character(15)	VARCHAR2(15) NOT NULL	Event code that corresponds to a specific type of event. Can be used for finer filtering of events. Prompt Table: TR_EVENT_CD_TBL Set Control Field: EVENT_CODE
3	EVENT_SEQUENCE	Character(40)	VARCHAR2(40) NOT NULL	Event Sequence Number
4	EVENT_CHANGE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Unique identifier for a changed field on a given event instance.
5	EVENT_FIELD_NAME	Character(254)	VARCHAR2(254) NOT NULL	For a change event this field holds the field name.
6	RECORDNAME	Character(15)	VARCHAR2(15) NOT NULL	Record Name 01=MASTER_ITEM_EC 02=INV_ITEMS_EC 03=BU_ITM_INV_EC 04=BU_ITM_WTVL_EC 05=ITEM_SUPPLIER_EC 06=ITM_SUPP_LOC_EC 07=ITM_VNDR_UOM_EC 08=ITM_VND_UMPR_EC 09=INV_ITM_UOM_EC 10=PUR_ITM_ATTR_EC 13=EN_REVISION_EC 14=ITEM_MFG_GPO_EC 15=ITEM_MFG_EC 16=ITEM_CAT_EC
7	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
8	EVENT_OLD_VALUE	Character(254)	VARCHAR2(254) NOT NULL	For a change event this field holds the old value.
9	EVENT_NEW_VALUE	Character(254)	VARCHAR2(254) NOT NULL	For a change event this field holds the new value.