PTRCUSERPREF

index back

User Preferences

Reporting Console

PeopleSoft Field NameField TypeColumn TypeDescription
USERIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID

Prompt Table: PMN_OPRID_VW

PTRCFAVPUBLICCharacter(1)VARCHAR2(1) NOT NULLPublic Access to Favorites
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
SERVERNAMECharacter(8)VARCHAR2(8) NOT NULLServer Name

Prompt Table: SERVERDEFN

PRCSTYPECharacter(30)VARCHAR2(30) NOT NULLProcess Type

Prompt Table: PMN_PRCSTYPE_VW

RUNSTATUSCharacter(2)VARCHAR2(2) NOT NULLProcess 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_OPRIDCharacter(30)VARCHAR2(30) NOT NULLWork user's ID

Prompt Table: PMN_OPRID_VW

PRCSNAMECharacter(12)VARCHAR2(12) NOT NULLProcess Name

Prompt Table: PMN_PRCSNAME_VW

DISTSTATUSCharacter(2)VARCHAR2(2) NOT NULLDistribution 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_FILTERTYPECharacter(1)VARCHAR2(1) NOT NULLFilter Type
0=Last
1=Date Range

Default: 0

PT_FILTERVALUENumber(4,0)SMALLINT NOT NULLFilter Value

Default: 1

PT_FILTERUNITCharacter(1)VARCHAR2(1) NOT NULLFilter Unit
0=All
1=Days
2=Hours
3=Minutes
4=Years

Default: 1

TO_DTDate(10)DATETo Date
FROM_DTDate(10)DATEFrom Date
PTRC_ACTION_TEXTCharacter(1)VARCHAR2(1) NOT NULLReport Console - Action button Option
B=Both Text and Image
N=Image Button
Y=Text Link

Default: B

PTRC_DISPLAY_OPTCharacter(1)VARCHAR2(1) NOT NULLReport Console - text display option
B=Name and Description
D=Description only
N=Name only

Default: D

PTRC_MAXSRCHNumber(9,0)DECIMAL(9) NOT NULLMax. Number of row to display

Default: 10

PTRCNOTIFICATIONCharacter(1)VARCHAR2(1) NOT NULLReport Console Notification Setting

Y/N Table Edit

Default: N

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