GPBR_AGENTS_VW

(SQL View)
 Index Back

Available agents in a layout

Agents to be used in calculated fields

SELECT DISTINCT A.GPBR_LAYOUT_ID ,A.GPBR_FIELD_NAME FROM PS_GPBR_LAYOUT_FLD A WHERE (A.GPBR_AGENT_COUNT = 'Y' OR A.GPBR_AGENT_SUM = 'Y')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPBR_LAYOUT_ID Character(15) VARCHAR2(15) NOT NULL Layout identificator.
2 GPBR_FIELD_NAME Character(30) VARCHAR2(30) NOT NULL Unique field name used in query definition, includes alias table.