PTPPB_USR_THRSH(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PTPPB_PAGELET_ID |
Character(30) | VARCHAR2(30) NOT NULL | Pagelet ID |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | PTPPB_COLUMN_NAME |
Character(190) | VARCHAR2(190) NOT NULL |
Column Name
Prompt Table: PTPPB_THRESHOLD |
| 4 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 5 | 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 |
| 6 | PTPPB_VALUE | Character(150) | VARCHAR2(150) NOT NULL | Default Value |
| 7 | PTPPB_HIGHLIGHT | Character(4) | VARCHAR2(4) NOT NULL |
Highlight
CELL=Single Cell ROW=Entire Row |
| 8 | 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 |