GP_MT_TRG_DFN (SQL Table)	Index Back
Mass Trigger Definition This is the base record for storing the definition of a mass trigger.

GP_MT_TRG_DFN

(SQL Table)

Mass Trigger Definition

This is the base record for storing the definition of a mass trigger.

# 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).
Prompt Table: GP_MT_CREC_VW

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

4 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: GP_COUNTRY_VW

5 TRGR_EVENT_ID Character(10) VARCHAR2(10) NOT NULL Trigger Event ID
Prompt Table: GP_RTO_EVT

6 GP_MT_REMOVE_TER Character(1) VARCHAR2(1) NOT NULL This checkbox indicates if terminated employees should be removed from the result set of a mass trigger event.
Y/N Table Edit
Default Value: Y

#	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). Prompt Table: GP_MT_CREC_VW
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: GP_COUNTRY_VW
5	TRGR_EVENT_ID	Character(10)	VARCHAR2(10) NOT NULL	Trigger Event ID Prompt Table: GP_RTO_EVT
6	GP_MT_REMOVE_TER	Character(1)	VARCHAR2(1) NOT NULL	This checkbox indicates if terminated employees should be removed from the result set of a mass trigger event. Y/N Table Edit Default Value: Y