DATA_REC_VW

 index back

Tables with column

This view will select the records from the PeopleTools data dictionary that contain the column that the user is searching for
SELECT A.RECNAME, 0, B.FIELDNAME, A.SQLTABLENAME, 'N' FROM PSRECDEFN A, PSRECFIELD B WHERE A.RECNAME = B.RECNAME AND A.RECTYPE = 0

PeopleSoft Field Name Field Type Column Type Description
PSARCH_RECCOUNT Character(18) VARCHAR2(18) NOT NULL PS Record Name
PSARCH_NUM_ROWS Number(18,0) DECIMAL(18) NOT NULL Number of Rows
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
SQLTABLENAME Character(18) VARCHAR2(18) NOT NULL SQL Table Name
PSARCH_IS_KEY Character(1) VARCHAR2(1) NOT NULL Key Field
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20