EODP_SRCH_RF_VW(SQL View) |
Index Back |
|---|---|
Search reference ViewMain record for search reference grid |
| SELECT SR.PTSF_SRCCAT_NAME ,SR.PTSF_SBO_NAME ,SR.PTSF_SOURCE_NAME , SR.RECNAME , SR.FIELDNAME ,SC.OBJECTOWNERID ,SR.EODP_ISCOMSRCH , SR.PTSF_ISGBLSRCH ,SR.PTSF_SOURCE_TYPE ,RF.EODP_CTGRY_CD , RF.EODP_CLFNCD ,RF.EODP_PERS_IDFR , RF.EODP_SNSTV FROM PS_EODP_SRCH_REF SR LEFT OUTER JOIN PSPTSF_SRCCAT SC ON SC.PTSF_SRCCAT_NAME = SR.PTSF_SRCCAT_NAME , PS_EODP_RECFLDDB RF WHERE SR.RECNAME = RF.RECNAME AND SR.FIELDNAME = RF.FIELDNAME |
| # | 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 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 7 | EODP_ISCOMSRCH | Character(1) | VARCHAR2(1) NOT NULL |
IsComponentSearch
Y/N Table Edit |
| 8 | PTSF_ISGBLSRCH | Character(1) | VARCHAR2(1) NOT NULL |
IsGlobalSearch
Y/N Table Edit |
| 9 | 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 |
| 10 | EODP_CTGRY_CD | Character(6) | VARCHAR2(6) NOT NULL |
Category Code
Prompt Table: EODP_CTGRY_CODE |
| 11 | EODP_CLFNCD | Number(3,0) | SMALLINT NOT NULL |
Classification Code
Prompt Table: EODP_CLSFCN_VW |
| 12 | EODP_PERS_IDFR | Character(1) | VARCHAR2(1) NOT NULL |
Personal Identifier
A=All N=No Y=Yes Y/N Table Edit Default Value: N |
| 13 | EODP_SNSTV | Character(1) | VARCHAR2(1) NOT NULL |
Sensitive
A=All N=No Y=Yes Y/N Table Edit Default Value: N |