PTRCUSERPREF

index back

User Preferences

Reporting Console

PeopleSoft Field Name Field Type Column Type Description
USERID Character(30) VARCHAR2(30) NOT NULL A user's ID

Prompt Table: PMN_OPRID_VW

PTRCFAVPUBLIC Character(1) VARCHAR2(1) NOT NULL Public Access to Favorites
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
SERVERNAME Character(8) VARCHAR2(8) NOT NULL Server Name

Prompt Table: SERVERDEFN

PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type

Prompt Table: PMN_PRCSTYPE_VW

RUNSTATUS Character(2) VARCHAR2(2) NOT NULL Process Scheduler Process Run Status
1=Cancel
10=Not Successful
11=Posted
12=Unable to post
13=Resend
14=Posting
15=Content Generated
16=Pending
17=Success With Warning
18=Blocked
19=Restart
2=Delete
3=Error
4=Hold
5=Queued
6=Initiated
7=Processing
8=Cancelled
9=Success
WS_OPRID Character(30) VARCHAR2(30) NOT NULL Work user's ID

Prompt Table: PMN_OPRID_VW

PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name

Prompt Table: PMN_PRCSNAME_VW

DISTSTATUS Character(2) VARCHAR2(2) NOT NULL Distribution Status
0=None
1=Scheduled
2=Processing
3=Generated
4=Unable to Post
5=Posted to Web
6=Delete
7=Posting
9=Pending for Approval

Default: 5

PT_FILTERTYPE Character(1) VARCHAR2(1) NOT NULL Filter Type
0=Last
1=Date Range

Default: 0

PT_FILTERVALUE Number(4,0) SMALLINT NOT NULL Filter Value

Default: 1

PT_FILTERUNIT Character(1) VARCHAR2(1) NOT NULL Filter Unit
0=All
1=Days
2=Hours
3=Minutes
4=Years

Default: 1

TO_DT Date(10) DATE To Date
FROM_DT Date(10) DATE From Date
PTRC_ACTION_TEXT Character(1) VARCHAR2(1) NOT NULL Report Console - Action button Option
B=Both Text and Image
N=Image Button
Y=Text Link

Default: B

PTRC_DISPLAY_OPT Character(1) VARCHAR2(1) NOT NULL Report Console - text display option
B=Name and Description
D=Description only
N=Name only

Default: D

PTRC_MAXSRCH Number(9,0) DECIMAL(9) NOT NULL Max. Number of row to display

Default: 10

PTRCNOTIFICATION Character(1) VARCHAR2(1) NOT NULL Report Console Notification Setting

Y/N Table Edit

Default: N

index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19