EODP_SRCH_STG (SQL Table)	Index Back
Staging Table Search def Refs

EODP_SRCH_STG

(SQL Table)

Staging Table Search def Refs

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PTSF_SRCCAT_NAME Character(65) VARCHAR2(65) NOT NULL Search Category Name (see PSPTSF_SRCCAT).

2 PTSF_SBO_NAME Character(65) VARCHAR2(65) NOT NULL Search Definition (see PSPTSF_SD).

3 PTSF_SOURCE_NAME Character(30) VARCHAR2(30) NOT NULL Source Name

4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

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

6 PTSF_SOURCE_TYPE Character(1) VARCHAR2(1) NOT NULL Source Type
A=Activity Guide
C=Connected Query
F=File Source
Q=Query
R=External Data Source
W=Web Source

7 PTSF_ISGBLSRCH Character(1) VARCHAR2(1) NOT NULL IsGlobalSearch
Y/N Table Edit

8 EODP_ISCOMSRCH Character(1) VARCHAR2(1) NOT NULL IsComponentSearch
Y/N Table Edit

9 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

10 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTSF_SRCCAT_NAME	Character(65)	VARCHAR2(65) NOT NULL	Search Category Name (see PSPTSF_SRCCAT).
2	PTSF_SBO_NAME	Character(65)	VARCHAR2(65) NOT NULL	Search Definition (see PSPTSF_SD).
3	PTSF_SOURCE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Source Name
4	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
5	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
6	PTSF_SOURCE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Source Type A=Activity Guide C=Connected Query F=File Source Q=Query R=External Data Source W=Web Source
7	PTSF_ISGBLSRCH	Character(1)	VARCHAR2(1) NOT NULL	IsGlobalSearch Y/N Table Edit
8	EODP_ISCOMSRCH	Character(1)	VARCHAR2(1) NOT NULL	IsComponentSearch Y/N Table Edit
9	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
10	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.