EMPLIDSEQNODATE_UNDER_RPT0=Black
1=Blue
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
7=Magenta
8=Orange
9=Pink
RS_SCH_TASK_VW(SQL View) |
Index Back |
|---|
| SELECT A.EMPLID , A.SEQNO , A.DATE_UNDER_RPT , A.DESCR254 , A.ASSIGNMENT_ID , A.RS_APPT_ID , A.TASK_TYPE , A.PERCENTAGE , A.TIME_START , B.OPRID , B.RUN_CNTL_ID , B.RS_TASK_COLOR FROM PS_RS_SCHED_TASK A , PS_RUN_CNTL_SRS_TT B WHERE A.TASK_TYPE = B.TASK_TYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 3 | DATE_UNDER_RPT |
Date(10) | DATE | Date Under Report |
| 4 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 5 | ASSIGNMENT_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Assignment ID |
| 6 | RS_APPT_ID | Character(15) | VARCHAR2(15) NOT NULL | Appointment Id |
| 7 | TASK_TYPE | Character(18) | VARCHAR2(18) NOT NULL | Task Category |
| 8 | PERCENTAGE | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Percentage |
| 9 | TIME_START | Time(15) | TIMESTAMP | Start Time |
| 10 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 11 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 12 | RS_TASK_COLOR | Character(3) | VARCHAR2(3) NOT NULL |
Colors for tasks.
0=Black 1=Blue 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 7=Magenta 8=Orange 9=Pink |