GP_MT_TRG_PAR (SQL Table)	Index Back
Input Param for Mass Trg SQL This table serves for storing the input parameters for the SQL Objects assigned in GP_MT_TRG_SQL.

GP_MT_TRG_PAR

(SQL Table)

Input Param for Mass Trg SQL

This table serves for storing the input parameters for the SQL Objects assigned in GP_MT_TRG_SQL.

# 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 SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
SQLTYPE = 0: SQL object name
SQLTYPE = 1: Application Engine Step Identifier
SQLTYPE = 2: RECNAME
SQLTYPE = 6: Application Engine XSLT (XML definition)
Prompt Table: GP_MT_SQL_VW

4 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
Prompt Table: GP_MT_RFLD_VW

#	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	SQLID	Character(30)	VARCHAR2(30) NOT NULL	SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE SQLTYPE = 0: SQL object name SQLTYPE = 1: Application Engine Step Identifier SQLTYPE = 2: RECNAME SQLTYPE = 6: Application Engine XSLT (XML definition) Prompt Table: GP_MT_SQL_VW
4	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
5	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: GP_MT_RFLD_VW