BUSINESS_UNITPROJECT_IDACTIVITY_IDPGM_ED_WORK_VW(SQL View) |
Index Back |
|---|---|
Project Discovery Assign WorkAssigned work and generic resource counts by project activities used for Project Discovery. Includes only labor resources. |
| SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , SUM(A.ASSGND_WORK) , AVG(A.COST_RATE) , SUM(CASE WHEN A.TEAM_MEMBER_CLASS = 'L' AND A.TEAM_MEMBER_IND = 'G' THEN 1 ELSE 0 END) AS NUM_GENERIC_RES , SUM(CASE WHEN B.RESOURCE_STS IN ('CO' , 'RQ') THEN 1 ELSE 0 END) AS NUM_UNFILL_REQ FROM PS_PROJ_ACT_TEAM A , PS_PROJECT_TEAM B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND A.TEAM_MEMBER_CLASS = 'L' AND A.TEAM_MEMBER = B.TEAM_MEMBER 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 | COST_RATE | Number(27,3) | DECIMAL(26,3) NOT NULL | Cost Rate |
| 6 | NUM_GEN_RESOURCES | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | The number of generic resources |
| 7 | NUM_UNFIL_REQUESTS | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | The number of unfilled resource requests |