GP_MT_TVAL_VW (SQL View)	Index Back
Mass Trg Field Values This view selects the first four keys of the above record. It serves as a base record for the Trigger Values page GP_MT_TRG_VAL on level 2.

GP_MT_TVAL_VW

(SQL View)

Mass Trg Field Values

This view selects the first four keys of the above record. It serves as a base record for the Trigger Values page GP_MT_TRG_VAL on level 2.

SELECT DISTINCT PNLGRPNAME , RECNAME , DTTM_CREATED , GP_MT_VALUE_SET FROM PS_GP_MT_TRG_VAL

# 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

#	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