GP_MT_TRG_VAL (SQL Table)	Index Back
Mass Trg Field Values This table serves for storing the field values of the triggering record at the time of the mass trigger event. The data get inserted by the PeopleCode module that stores the mass trigger event.

GP_MT_TRG_VAL

(SQL Table)

Mass Trg Field Values

This table serves for storing the field values of the triggering record at the time of the mass trigger event. The data get inserted by the PeopleCode module that stores the mass trigger event.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

3 DTTM_CREATED DateTime(26) TIMESTAMP Datetime Created

4 GP_MT_VALUE_SET Character(1) VARCHAR2(1) NOT NULL Set of field values relevant for Mass Trigger generation
1=Original Values
2=Current Values

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

6 GP_MT_FLD_VALUE Character(30) VARCHAR2(30) NOT NULL When storing a mass trigger event the names and the values of the triggering fields are stored. This field is used to hold the fieldvalues in char-format.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PNLGRPNAME	Character(18)	VARCHAR2(18) NOT NULL	Component Name
2	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
3	DTTM_CREATED	DateTime(26)	TIMESTAMP	Datetime Created
4	GP_MT_VALUE_SET	Character(1)	VARCHAR2(1) NOT NULL	Set of field values relevant for Mass Trigger generation 1=Original Values 2=Current Values
5	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
6	GP_MT_FLD_VALUE	Character(30)	VARCHAR2(30) NOT NULL	When storing a mass trigger event the names and the values of the triggering fields are stored. This field is used to hold the fieldvalues in char-format.