PTCS_MENULNKS_V |
index back |
---|
SELECT A.PORTAL_NAME , A.PORTAL_OBJNAME , A.PTCS_MENUID , B.PTCS_FOLDERID , B.PTCS_PRNT_FOLDERID , C.PTCS_SERVICEID , C.PTCS_INSTANCEID , B.PTCS_FOLDERLBL , A.PTCS_PNLFLDNAME , D.PTCS_ISCOMPSERVICE , D.PNLNAME , B.PTCS_FOLDERSEQNUM , C.SEQNUM , D.PTCS_HIDEFROMSRCH , D.IS_DEFAULT , D.PTCS_MAPSECOPTIONS , D.HANDLERNAME , D.PTCS_INSTANCELBL , D.PTCS_URLTARGET , D.PTCS_RCMENUOPT , D.PTCS_MAINMENUOPT , D.PACKAGEROOT , D.QUALIFYPATH , D.APPCLASSID FROM PSPTCS_MENU_TBL A , PSPTCS_MNUFLDRS B , PSPTCS_MNULINKS C , PSPTCSSRVCONF D WHERE A.PTCS_MENUID = B.PTCS_MENUID AND B.PTCS_MENUID = C.PTCS_MENUID AND B.PTCS_FOLDERID = C.PTCS_FOLDERID AND D.PORTAL_NAME = C.PORTAL_NAME AND D.PORTAL_OBJNAME = C.PORTAL_OBJNAME AND D.PTCS_SERVICEID = C.PTCS_SERVICEID |
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 |
PTCS_MENUID | Character(30) | VARCHAR2(30) NOT NULL | Menu |
PTCS_FOLDERID | Character(30) | VARCHAR2(30) NOT NULL | Folder |
PTCS_PRNT_FOLDERID | Character(30) | VARCHAR2(30) NOT NULL | Parent Folder |
PTCS_SERVICEID | Character(30) | VARCHAR2(30) NOT NULL |
Services ID (see PSPTCSSRVDEFN).
Prompt Table: PTCSSERVICEDEFN |
PTCS_INSTANCEID | Number(10,0) | DECIMAL(10) NOT NULL | Instance ID |
PTCS_FOLDERLBL | Character(50) | VARCHAR2(50) NOT NULL | Folder Label |
PTCS_PNLFLDNAME | Character(254) | VARCHAR2(254) NOT NULL | Page Field Name |
PTCS_ISCOMPSERVICE | Character(1) | VARCHAR2(1) NOT NULL |
Component Service
C=Services at Component Level F=Event Mapping Comp Rec Fld P=Services at Page level R=Event Mapping at Comp Rec |
PNLNAME | Character(30) | VARCHAR2(30) NOT NULL |
Page Name (see PSPNLDEFN).
Prompt Table: PTCS_PNLLST_DVW |
PTCS_FOLDERSEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
PTCS_HIDEFROMSRCH | Character(1) | VARCHAR2(1) NOT NULL |
Private Data
Y/N Table Edit Default: N |
IS_DEFAULT | Character(1) | VARCHAR2(1) NOT NULL |
Default Template
N=No Y=Yes Y/N Table Edit Default: N |
PTCS_MAPSECOPTIONS | Character(1) | VARCHAR2(1) NOT NULL |
Security options to display Map fields page
P=Public Access R=Related Content Security T=Transaction Security |
HANDLERNAME | Character(30) | VARCHAR2(30) NOT NULL | Handler Name |
PTCS_INSTANCELBL | Character(50) | VARCHAR2(50) NOT NULL | Service Label |
PTCS_URLTARGET | Character(4) | VARCHAR2(4) NOT NULL |
Service Target
MDLW=Modal Window NWIN=New Window RCF=Related Content SRCF=Right Frame TGTF=Target Content TOPF=Replace Window USRD=User Defined Default: RCF |
PTCS_RCMENUOPT | Character(1) | VARCHAR2(1) NOT NULL |
Related Content Menu
N=No Y=Yes Default: Y |
PTCS_MAINMENUOPT | Character(1) | VARCHAR2(1) NOT NULL |
Related Actions Menu
N=No Y=Yes Default: N |
PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table: PSPACKAGROOT_VW |
QUALIFYPATH | Character(127) | VARCHAR2(127) NOT NULL |
Qualified Package/Class Path
Prompt Table: PSPACKAGPATH_VW |
APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table: PSPACKAGCLAS_VW |
index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |