PTRCUSERPRCS

index back

User process bookmarks

Reporting Console

PeopleSoft Field Name Field Type Column Type Description
USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
PTRC_PROCESS_ID Number(12,0) DECIMAL(12) NOT NULL
PTRCFAVPOS Number(3,0) SMALLINT NOT NULL
PTRC_PRNT_FLDR_ID Number(12,0) DECIMAL(12) NOT NULL Parent Folder's Unique identifier
PTRC_FOLDER_ID Number(12,0) DECIMAL(12) NOT NULL Folder's Unique identifier
PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
CONQRSNAME Character(30) VARCHAR2(30) NOT NULL Connected Queries object name
BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
REPORT_ID Character(8) VARCHAR2(8) NOT NULL Report Identifier
REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL Report Name (see PSXPRPTDEFN).
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19