EOTR_METAREC_VW

(SQL View)
Index Back

Internal: Used for OWNER Audit

Internal: Used for OWNER Audit. This view contains peopletools records with OBJECTOWNERID as a field.. This record and the data is not to be delivered to customers.

SELECT r.RECNAME FROM PSRECDEFN r , PSRECFIELD rf WHERE r.OBJECTOWNERID LIKE 'PPT%' AND r.RECTYPE = 0 AND rf.RECNAME = r.RECNAME AND rf.FIELDNAME = 'OBJECTOWNERID'

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