PTPPB_TRSH_VAL(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 | PTPPB_COLUMN_NAME | Character(190) | VARCHAR2(190) NOT NULL | Column Name |
3 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
4 | 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 |
5 | PTPPB_VALUE | Character(150) | VARCHAR2(150) NOT NULL | Default Value |
6 | PTPPB_HIGHLIGHT | Character(4) | VARCHAR2(4) NOT NULL |
Highlight
CELL=Single Cell ROW=Entire Row |
7 | 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 |