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
P=Services at Page level
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 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19