BUSINESS_UNITPROJECT_IDACTIVITY_IDPGM_ACT_WORK(SQL View) |
Index Back |
|---|---|
Summary of Activity work/costThis view will summarize the work and cost totals from the Activity Team by Activity ID. |
| SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , SUM(A.ASSGND_WORK) , SUM(A.ACTUAL_WORK) , SUM(A.REMAINING_WORK) , SUM(A.COST) FROM PS_PROJ_ACT_TEAM A GROUP BY A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 3 | ACTIVITY_ID |
Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 4 | ASSGND_WORK | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Assigned Work |
| 5 | ACTUAL_WORK | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Actual Work |
| 6 | REMAINING_WORK | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | New Remaining work in hours |
| 7 | COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Cost |