EODP_SR_DWN_VW (SQL View)	Index Back
Search reference View Main record for search reference grid

EODP_SR_DWN_VW

(SQL View)

Search reference View

Main record for search reference grid

SELECT SR.PTSF_SRCCAT_NAME ,SC.DESCR100 ,SR.PTSF_SBO_NAME ,SR.PTSF_SOURCE_NAME , SR.RECNAME , SR.FIELDNAME ,SR.EODP_ISCOMSRCH , SR.PTSF_ISGBLSRCH ,CT.EODP_CTGRY_DESC , CL.EODP_CFCN_NAME ,RF.EODP_PERS_IDFR , RF.EODP_SNSTV ,PD.EODP_PROD_DESCR ,SD.EODP_QUERYNAME ,QD.EODP_QUERY_DESCR FROM PS_EODP_SRCH_REF SR LEFT OUTER JOIN PS_EODP_SRCH_DTL SD ON SR.PTSF_SRCCAT_NAME = SD.PTSF_SRCCAT_NAME AND SR.PTSF_SBO_NAME = SD.PTSF_SBO_NAME AND SR.PTSF_SOURCE_NAME = SD.PTSF_SOURCE_NAME AND SR.RECNAME = SD.RECNAME AND SR.FIELDNAME = SD.FIELDNAME LEFT OUTER JOIN PS_EODP_QRYDSCR_VW QD ON QD.EODP_QUERYNAME = SD.EODP_QUERYNAME , PS_EODP_RECFLDDB RF LEFT OUTER JOIN PS_EODP_CLSFCN CL ON RF.EODP_CLFNCD = CL.EODP_CLFNCD LEFT OUTER JOIN PS_EODP_CTGRY_CODE CT ON RF.EODP_CTGRY_CD = CT.EODP_CTGRY_CD , PSPTSF_SRCCAT sc LEFT OUTER JOIN PS_EODP_SRCHPRD_VW PD ON PD.PTSF_SRCCAT_NAME = SC.PTSF_SRCCAT_NAME WHERE SR.RECNAME = RF.RECNAME AND SR.FIELDNAME = RF.FIELDNAME AND SC.PTSF_SRCCAT_NAME = SR.PTSF_SRCCAT_NAME

Related Language Record: EODP_SR_DWN_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EODP_SRCCAT_NAME Character(65) VARCHAR2(65) NOT NULL Search Category

2 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

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

4 PTSF_SOURCE_NAME Character(30) VARCHAR2(30) NOT NULL Connected Query Name

5 EODP_RECNAME Character(15) VARCHAR2(15) NOT NULL Record Name

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

7 EODP_ISCOMSRCH Character(1) VARCHAR2(1) NOT NULL Component Search
Y/N Table Edit

8 EODP_ISGBLSRCH Character(1) VARCHAR2(1) NOT NULL Global Search

9 EODP_CTGRY_DESC Character(100) VARCHAR2(100) NOT NULL Category

10 EODP_CFCN_NAME Character(100) VARCHAR2(100) NOT NULL Classification

11 EODP_PERS_IDFR Character(1) VARCHAR2(1) NOT NULL Personal Identifier
A=All
N=No
Y=Yes

12 EODP_SNSTV Character(1) VARCHAR2(1) NOT NULL Sensitive
A=All
N=No
Y=Yes

13 EODP_PROD_DESCR Character(30) VARCHAR2(30) NOT NULL Product Description

14 EODP_QRY_CHILD Character(30) VARCHAR2(30) NOT NULL Child Query Name

15 EODP_QUERY_DESCR Character(30) VARCHAR2(30) NOT NULL Child Query Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EODP_SRCCAT_NAME	Character(65)	VARCHAR2(65) NOT NULL	Search Category
2	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
3	PTSF_SBO_NAME	Character(65)	VARCHAR2(65) NOT NULL	Search Definition (see PSPTSF_SD).
4	PTSF_SOURCE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Connected Query Name
5	EODP_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record Name
6	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
7	EODP_ISCOMSRCH	Character(1)	VARCHAR2(1) NOT NULL	Component Search Y/N Table Edit
8	EODP_ISGBLSRCH	Character(1)	VARCHAR2(1) NOT NULL	Global Search
9	EODP_CTGRY_DESC	Character(100)	VARCHAR2(100) NOT NULL	Category
10	EODP_CFCN_NAME	Character(100)	VARCHAR2(100) NOT NULL	Classification
11	EODP_PERS_IDFR	Character(1)	VARCHAR2(1) NOT NULL	Personal Identifier A=All N=No Y=Yes
12	EODP_SNSTV	Character(1)	VARCHAR2(1) NOT NULL	Sensitive A=All N=No Y=Yes
13	EODP_PROD_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Product Description
14	EODP_QRY_CHILD	Character(30)	VARCHAR2(30) NOT NULL	Child Query Name
15	EODP_QUERY_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Child Query Description