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 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |