PSFIELD_VW

(SQL View)
 Index Back

ID-Like Flds

This is a view for selecting all Field names which have the values prompted against Personal Data 'EMPLID'. The prompt table can be other than 'PERSONAL_DATA'.

SELECT A.RECNAME ,A.FIELDNAME FROM PS_ID_DEL_RCFLD_VW A WHERE (A.FIELDNAME = 'EMPLID' AND A.RECNAME NOT LIKE 'AUDIT%' AND A.RECNAME NOT LIKE 'UPG%' AND RECNAME NOT LIKE '%AET') OR (A.FIELDNAME = 'COMMON_ID' AND A.RECNAME NOT LIKE 'AUDIT%' AND A.RECNAME NOT LIKE 'UPG%') OR (A.EDITTABLE IN ('PERSONAL_DATA','TRN_CRS_INSTRCT') AND A.FIELDNAME <> 'EMPLID')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).