PTCS_MENULNKS_V

(SQL View)
 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 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 PTCS_MENUID Character(30) VARCHAR2(30) NOT NULL Menu
4 PTCS_FOLDERID Character(30) VARCHAR2(30) NOT NULL Folder
5 PTCS_PRNT_FOLDERID Character(30) VARCHAR2(30) NOT NULL Parent Folder
6 PTCS_SERVICEID Character(30) VARCHAR2(30) NOT NULL Services ID (see PSPTCSSRVDEFN).

Prompt Table: PTCSSERVICEDEFN

7 PTCS_INSTANCEID Number(10,0) DECIMAL(10) NOT NULL Instance ID
8 PTCS_FOLDERLBL Character(50) VARCHAR2(50) NOT NULL Folder Label
9 PTCS_PNLFLDNAME Character(254) VARCHAR2(254) NOT NULL Page Field Name
10 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
11 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).

Prompt Table: PTCS_PNLLST_DVW

12 PTCS_FOLDERSEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
13 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
14 PTCS_HIDEFROMSRCH Character(1) VARCHAR2(1) NOT NULL Private Data

Y/N Table Edit

Default Value: N

15 IS_DEFAULT Character(1) VARCHAR2(1) NOT NULL Default Template
N=No
Y=Yes

Y/N Table Edit

Default Value: N

16 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
17 HANDLERNAME Character(30) VARCHAR2(30) NOT NULL Handler Name
18 PTCS_INSTANCELBL Character(50) VARCHAR2(50) NOT NULL Service Label
19 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 Value: RCF

20 PTCS_RCMENUOPT Character(1) VARCHAR2(1) NOT NULL Related Content Menu
N=No
Y=Yes

Default Value: Y

21 PTCS_MAINMENUOPT Character(1) VARCHAR2(1) NOT NULL Related Actions Menu
N=No
Y=Yes

Default Value: N

22 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

Prompt Table: PSPACKAGROOT_VW

23 QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path

Prompt Table: PSPACKAGPATH_VW

24 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

Prompt Table: PSPACKAGCLAS_VW