PTCS_KIBRI_VW(SQL View) |
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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PORTAL_NAME | Character(30) | VARCHAR2(30) NOT NULL | Portal Name (see PSPRDMDEFN). |
| 2 | PORTAL_OBJNAME | Character(30) | VARCHAR2(30) NOT NULL | Portal Object Name |
| 3 | PORTAL_URI_SEG1 | Character(30) | VARCHAR2(30) NOT NULL | URI Segment 1 |
| 4 | PORTAL_URI_SEG2 | Character(30) | VARCHAR2(30) NOT NULL | URI Segment 2 |
| 5 | PTCS_INSTANCELBL | Character(50) | VARCHAR2(50) NOT NULL | Service Label |
| 6 | PTCS_INSTANCEID | Number(10,0) | DECIMAL(10) NOT NULL | Instance ID |