PTPPB_USR_THRSH

index back

PeopleSoft Field NameField TypeColumn TypeDescription
PTPPB_PAGELET_IDCharacter(30)VARCHAR2(30) NOT NULLPagelet ID
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
PTPPB_COLUMN_NAMECharacter(190)VARCHAR2(190) NOT NULLColumn Name

Prompt Table: PTPPB_THRESHOLD

SEQ_NUMNumber(3,0)SMALLINT NOT NULLSequence
PTPPB_COMPARATORCharacter(2)VARCHAR2(2) NOT NULLComparator
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_VALUECharacter(150)VARCHAR2(150) NOT NULLDefault Value
PTPPB_HIGHLIGHTCharacter(4)VARCHAR2(4) NOT NULLHighlight
CELL=Single Cell
ROW=Entire Row
PTPPB_CHART_COLORCharacter(4)VARCHAR2(4) NOT NULLColor
-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.ukPeopleTools 8.54
PTRef generated on 09-JUN-19