REPORT_PERIODASSIGNED_FLAGA=Assigned
U=Unassigned
RS_BENCH_WS(SQL Table) |
Index Back |
|---|---|
Derived record for Bench Repor |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REPORT_PERIOD |
Date(10) | DATE | Report Period |
| 2 | ASSIGNED_FLAG |
Character(1) | VARCHAR2(1) NOT NULL |
Assigned/Unassigned Flag
A=Assigned U=Unassigned |
| 3 | PERIOD | Number(3,0) | SMALLINT NOT NULL | Period |
| 4 | PERCENTAGE | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Percentage |
| 5 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 6 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 7 | TASK_COLOR | Number(2,0) | SMALLINT NOT NULL | Task colors. |