GPAR_AGENTS_VW (SQL View)	Index Back
Layout Agents Agents to be used in calculated fields

GPAR_AGENTS_VW

(SQL View)

Layout Agents

Agents to be used in calculated fields

SELECT DISTINCT A.GPAR_LAYOUT_ID ,A.GPAR_FIELD_NAME FROM PS_GPAR_LAYOUT_FLD A WHERE (A.GPAR_AGENT_COUNT = 'Y' OR A.GPAR_AGENT_SUM = 'Y')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPAR_LAYOUT_ID Character(15) VARCHAR2(15) NOT NULL Layout Identificator.

2 GPAR_FIELD_NAME Character(30) VARCHAR2(30) NOT NULL Unique field name used in query definitions. Includes alias table.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPAR_LAYOUT_ID	Character(15)	VARCHAR2(15) NOT NULL	Layout Identificator.
2	GPAR_FIELD_NAME	Character(30)	VARCHAR2(30) NOT NULL	Unique field name used in query definitions. Includes alias table.