DATA_FIND_BASE

(SQL Table)
Index Back

base record for find tables

Used as search record for the panel. SHould always be empty.

# 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

Y/N Table Edit

6 PSARCH_BUILD_PROJ Character(1) VARCHAR2(1) NOT NULL Build Project

Y/N Table Edit