PTCS_KIBRI_VW |
index back |
|---|
| SELECT DISTINCT A.PORTAL_NAME , A.PORTAL_OBJNAME , B.PORTAL_URI_SEG1 , B.PORTAL_URI_SEG2 , A.PTCS_INSTANCELBL , A.PTCS_INSTANCEID FROM PSPTCSSRVCONF A , PSPRSMDEFN B WHERE A.PORTAL_OBJNAME = B.PORTAL_OBJNAME AND B.FLUIDMODE = '1' AND A.PTCS_ISCOMPSERVICE='C' AND A.PTCS_SERVICEID='KIBANA_SER_R' AND A.PORTAL_NAME <> '_PTCS_EVMAP' AND A.PORTAL_NAME <> '_PTCS_PTPG' |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| PORTAL_NAME | Character(30) | VARCHAR2(30) NOT NULL | Portal Name (see PSPRDMDEFN). |
| PORTAL_OBJNAME | Character(30) | VARCHAR2(30) NOT NULL | Portal Object Name |
| PORTAL_URI_SEG1 | Character(30) | VARCHAR2(30) NOT NULL | URI Segment 1 |
| PORTAL_URI_SEG2 | Character(30) | VARCHAR2(30) NOT NULL | URI Segment 2 |
| PTCS_INSTANCELBL | Character(50) | VARCHAR2(50) NOT NULL | Service Label |
| PTCS_INSTANCEID | Number(10,0) | DECIMAL(10) NOT NULL | Instance ID |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |