GM_RES_CHART_VW(SQL View) |
Index Back |
|---|
| SELECT A.PROJ_ROLE , A.DESCR50 , SUM(A.QTY_X_HOURS) FROM PS_GM_OPPTY_DTL_TM A GROUP BY A.PROJ_ROLE , A.DESCR50 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROJ_ROLE | Character(15) | VARCHAR2(15) NOT NULL | Project Role |
| 2 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 3 | QTY_X_HOURS | Number(11,0) | DECIMAL(11) NOT NULL | Quantity * Hours |