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

Prompt Table: PSPTCSSRVDEFN

PTCS_INSTANCEIDNumber(10,0)DECIMAL(10) NOT NULLInstance ID
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

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

PTCS_SEQNUM_MMNUNumber(3,0)SMALLINT NOT NULLSequence Number
PTCS_SEQNUM_RMNUNumber(3,0)SMALLINT NOT NULLSequence Number
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

PTCS_INITMINCharacter(1)VARCHAR2(1) NOT NULLInitially Minimized

Y/N Table Edit

Default: N

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

Default: 1

LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies 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.
OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19