PSPTCS_USRPRSNL

index back

Related ContentPersonalization


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
ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name
PTCS_MAPPEDFLD Character(254) VARCHAR2(254) NOT NULL Mapped To
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
PTCS_ISHIDDEN Character(1) VARCHAR2(1) NOT NULL Hidden

Default: N

PTCS_MENUTYPE Character(4) VARCHAR2(4) NOT NULL Menu Display Type
FLDM=Field Menu
MMNU=Drop-Down Menu
PGBM=Pivot grid Bulk Menu
RCF=Related Content Frame
RCMU=Related Content Menu
PTCS_SERVICEID Character(30) VARCHAR2(30) NOT NULL Services ID (see PSPTCSSRVDEFN).
PTCS_INSTANCEID Number(10,0) DECIMAL(10) NOT NULL Instance ID
PTCS_SRVCATTR Character(4) VARCHAR2(4) NOT NULL Template Based
VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
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
PTCS_SEQNUM_MMNU Number(3,0) SMALLINT NOT NULL Sequence Number
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20