PTCSVCCONFRCF_V

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 , VERSION , LASTUPDDTTM , LASTUPDOPRID , OBJECTOWNERID FROM PSPTCSSRVCONF WHERE PTCS_URLTARGET = 'RCF'

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

Prompt Table: PSPTCSSRVDEFN

PTCS_INSTANCEID Number(10,0) DECIMAL(10) NOT NULL Instance ID
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

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

PTCS_SEQNUM_MMNU Number(3,0) SMALLINT NOT NULL Sequence Number
PTCS_SEQNUM_RMNU Number(3,0) SMALLINT NOT NULL Sequence Number
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

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

Y/N Table Edit

Default: N

VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

Default: 1

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.
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.
OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier translate values
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19