PTPPB_USR_THRSH

index back

PeopleSoft Field Name Field Type Column Type Description
PTPPB_PAGELET_ID Character(30) VARCHAR2(30) NOT NULL Pagelet ID
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
PTPPB_COLUMN_NAME Character(190) VARCHAR2(190) NOT NULL Column Name

Prompt Table: PTPPB_THRESHOLD

SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
PTPPB_COMPARATOR Character(2) VARCHAR2(2) NOT NULL Comparator
CT=Contains
EQ=Equal
GE=Greater Than or Equal
GT=Greater Than
LE=Less Than or Equal
LT=Less Than
NE=Not Equal
SW=Starts With
PTPPB_VALUE Character(150) VARCHAR2(150) NOT NULL Default Value
PTPPB_HIGHLIGHT Character(4) VARCHAR2(4) NOT NULL Highlight
CELL=Single Cell
ROW=Entire Row
PTPPB_CHART_COLOR Character(4) VARCHAR2(4) NOT NULL Color
-1=Default
0=Black
1=Blue
10=Red
11=White
12=Yellow
13=Red-Orange
14=Yellow-Green
15=Blue-Violet
16=Purple
17=Yellow-Orange
2=Cyan
3=Dark Gray
4=Gray
5=Green
6=Light Gray
7=Magenta
8=Orange
9=Pink
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19