PTCSVCCONFRCF_V

(SQL View)
 Index Back

SELECT PORTAL_NAME , PORTAL_OBJNAME , PTCS_SERVICEID , PTCS_INSTANCEID , PTCS_ISCOMPSERVICE , PNLNAME ,SEQNUM , PTCS_HIDEFROMSRCH , IS_DEFAULT , PTCS_MAPSECOPTIONS , HANDLERNAME , PTCS_INSTANCELBL , PTCS_URLTARGET , PTCS_RCMENUOPT , PTCS_MAINMENUOPT , PTCS_SEQNUM_MMNU , PTCS_SEQNUM_RMNU , PACKAGEROOT , QUALIFYPATH , APPCLASSID , PTCS_INITMIN ,PTCS_SRVCATTR , VERSION , LASTUPDDTTM , LASTUPDOPRID , OBJECTOWNERID FROM PSPTCSSRVCONF WHERE PTCS_URLTARGET = 'RCF' AND PTCS_SRVCATTR <> 'CLON' AND PTCS_EMBEDDABLE <> 'Y' AND PTCS_SUOWSERV <> 'Y'

# 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_SERVICEID Character(30) VARCHAR2(30) NOT NULL Services ID (see PSPTCSSRVDEFN).

Prompt Table: PSPTCSSRVDEFN

4 PTCS_INSTANCEID Number(10,0) DECIMAL(10) NOT NULL Instance ID
5 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
6 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).

Prompt Table: PTCS_PNLLST_DVW

7 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
8 PTCS_HIDEFROMSRCH Character(1) VARCHAR2(1) NOT NULL Private Data

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

10 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
11 HANDLERNAME Character(30) VARCHAR2(30) NOT NULL Handler Name
12 PTCS_INSTANCELBL Character(50) VARCHAR2(50) NOT NULL Service Label
13 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

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

Default Value: Y

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

Default Value: N

16 PTCS_SEQNUM_MMNU Number(3,0) SMALLINT NOT NULL Sequence Number
17 PTCS_SEQNUM_RMNU Number(3,0) SMALLINT NOT NULL Sequence Number
18 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

Prompt Table: PSPACKAGROOT_VW

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

Prompt Table: PSPACKAGPATH_VW

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

Prompt Table: PSPACKAGCLAS_VW

21 PTCS_INITMIN Character(1) VARCHAR2(1) NOT NULL Initially Minimized

Y/N Table Edit

Default Value: N

22 PTCS_SRVCATTR Character(4) VARCHAR2(4) NOT NULL Template Based
23 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

Default Value: 1

24 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
25 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
26 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier