EODP_SRCCAT_NAMEPTSF_SBO_NAMEPTSF_SOURCE_NAMEEODP_RECNAMEFIELDNAMEEODP_ISCOMSRCHY/N Table Edit
EODP_ISGBLSRCHEODP_PERS_IDFRA=All
N=No
Y=Yes
EODP_SNSTVA=All
N=No
Y=Yes
EODP_QRY_CHILDEODP_SR_DWN_VW(SQL View) |
Index Back |
|---|---|
Search reference ViewMain 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 |
| # | 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 | Query Description |