TL_GPPY_FLD_VW1 (SQL View)	Index Back
View of All Fields in GP_PYGRP View of All Fields in GP_PYGRP for groups field security.

TL_GPPY_FLD_VW1

(SQL View)

View of All Fields in GP_PYGRP

View of All Fields in GP_PYGRP for groups field security.

SELECT A.FIELDNAME FROM PSRECFIELD A WHERE ((A.RECNAME = 'GP_PYGRP' AND SUBRECORD = 'N') OR A.RECNAME IN ( SELECT FIELDNAME FROM PSRECFIELD B WHERE B.RECNAME = 'GP_PYGRP' AND B.SUBRECORD = 'Y'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).