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
PTPG_SORTSEQNOPTPG_CHARTCOLOR(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTPG_THRCOLOR_CHT | Character(2) | VARCHAR2(2) NOT NULL |
Chart Color
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 |
| 2 | PTPG_SAVE | Character(1) | VARCHAR2(1) NOT NULL | Save |
| 3 | PTPG_SORTSEQNO |
Number(3,0) | SMALLINT NOT NULL | Sort Seq No |
| 4 | PTPG_THR_COLOR | Character(20) | VARCHAR2(20) NOT NULL | Threshold Color |
| 5 | PTPG_THR_COLHTM | Long Character | CLOB | Threshold |