PORTAL_NAMEFSPC_DB_OBJNAMEFSPC_DSHBRD_VW(SQL View) |
Index Back |
|---|---|
Work Center Pages |
| SELECT A.PORTAL_NAME , A.PORTAL_OBJNAME , A.PORTAL_LABEL FROM PSPRSMDEFN A WHERE A.PORTAL_REFTYPE = 'C' AND A.PORTAL_CREF_USGT = 'HPGT' AND A.PORTAL_PRNTOBJNAME = 'PORTAL_HP_TAB' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PORTAL_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Portal Name (see PSPRDMDEFN). |
| 2 | FSPC_DB_OBJNAME |
Character(30) | VARCHAR2(30) NOT NULL | Dashboard Menu Item |
| 3 | PORTAL_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Portal Label |