TL_PERS_FLD_VW1 (SQL View)	Index Back
View of fields in PERS_DATA View of All Fields inPERSONAL_DATA for groups field security.

TL_PERS_FLD_VW1

(SQL View)

View of fields in PERS_DATA

View of All Fields inPERSONAL_DATA for groups field security.

SELECT A.FIELDNAME FROM PSRECFIELD A WHERE ((A.RECNAME = 'PERSONAL_DT_FST' AND SUBRECORD = 'N') OR A.RECNAME IN ( SELECT FIELDNAME FROM PSRECFIELD B WHERE B.RECNAME = 'PERSONAL_DT_FST' 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).