DATA_FIND_C_VW (SQL View)	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

DATA_FIND_C_VW

(SQL View)

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 PeopleSoft Field Type Database Column Type Description

1 PSARCH_RECCOUNT Character(18) VARCHAR2(18) NOT NULL PS Record Name

2 PSARCH_NUM_ROWS Number(18,0) DECIMAL(18) NOT NULL Number of Rows

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

4 SQLTABLENAME Character(18) VARCHAR2(18) NOT NULL SQL Table Name

5 PSARCH_IS_KEY Character(1) VARCHAR2(1) NOT NULL Key Field

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_RECCOUNT	Character(18)	VARCHAR2(18) NOT NULL	PS Record Name
2	PSARCH_NUM_ROWS	Number(18,0)	DECIMAL(18) NOT NULL	Number of Rows
3	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
4	SQLTABLENAME	Character(18)	VARCHAR2(18) NOT NULL	SQL Table Name
5	PSARCH_IS_KEY	Character(1)	VARCHAR2(1) NOT NULL	Key Field