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 NameField TypeColumn TypeDescription
PORTAL_NAMECharacter(30)VARCHAR2(30) NOT NULLPortal Name (see PSPRDMDEFN).
PORTAL_OBJNAMECharacter(30)VARCHAR2(30) NOT NULLPortal Object Name
PTCS_MENUIDCharacter(30)VARCHAR2(30) NOT NULLMenu
PTCS_FOLDERIDCharacter(30)VARCHAR2(30) NOT NULLFolder
PTCS_PRNT_FOLDERIDCharacter(30)VARCHAR2(30) NOT NULLParent Folder
PTCS_SERVICEIDCharacter(30)VARCHAR2(30) NOT NULLServices ID (see PSPTCSSRVDEFN).

Prompt Table: PTCSSERVICEDEFN

PTCS_INSTANCEIDNumber(10,0)DECIMAL(10) NOT NULLInstance ID
PTCS_FOLDERLBLCharacter(50)VARCHAR2(50) NOT NULLFolder Label
PTCS_PNLFLDNAMECharacter(254)VARCHAR2(254) NOT NULLPage Field Name
PTCS_ISCOMPSERVICECharacter(1)VARCHAR2(1) NOT NULLComponent Service
C=Services at Component Level
P=Services at Page level
PNLNAMECharacter(30)VARCHAR2(30) NOT NULLPage Name (see PSPNLDEFN).

Prompt Table: PTCS_PNLLST_DVW

PTCS_FOLDERSEQNUMNumber(3,0)SMALLINT NOT NULLSequence Number
SEQNUMNumber(3,0)SMALLINT NOT NULLSequence Number
PTCS_HIDEFROMSRCHCharacter(1)VARCHAR2(1) NOT NULLPrivate Data

Y/N Table Edit

Default: N

IS_DEFAULTCharacter(1)VARCHAR2(1) NOT NULLDefault Template
N=No
Y=Yes

Y/N Table Edit

Default: N

PTCS_MAPSECOPTIONSCharacter(1)VARCHAR2(1) NOT NULLSecurity options to display Map fields page
P=Public Access
R=Related Content Security
T=Transaction Security
HANDLERNAMECharacter(30)VARCHAR2(30) NOT NULLHandler Name
PTCS_INSTANCELBLCharacter(50)VARCHAR2(50) NOT NULLService Label
PTCS_URLTARGETCharacter(4)VARCHAR2(4) NOT NULLService 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_RCMENUOPTCharacter(1)VARCHAR2(1) NOT NULLRelated Content Menu
N=No
Y=Yes

Default: Y

PTCS_MAINMENUOPTCharacter(1)VARCHAR2(1) NOT NULLRelated Actions Menu
N=No
Y=Yes

Default: N

PACKAGEROOTCharacter(30)VARCHAR2(30) NOT NULLRoot Package ID

Prompt Table: PSPACKAGROOT_VW

QUALIFYPATHCharacter(127)VARCHAR2(127) NOT NULLQualified Package/Class Path

Prompt Table: PSPACKAGPATH_VW

APPCLASSIDCharacter(30)VARCHAR2(30) NOT NULLApplication Class ID

Prompt Table: PSPACKAGCLAS_VW

index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19