DATA_FIND_C_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 NameField TypeColumn TypeDescription
PSARCH_RECCOUNTCharacter(18)VARCHAR2(18) NOT NULLPS Record Name
PSARCH_NUM_ROWSNumber(18,0)DECIMAL(18) NOT NULLNumber of Rows
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
SQLTABLENAMECharacter(18)VARCHAR2(18) NOT NULLSQL Table Name
PSARCH_IS_KEYCharacter(1)VARCHAR2(1) NOT NULLKey Field
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19