PJT_RES_WEEKLY_ALLOC_HRS_V

Details

• Schema: FUSION

• Object owner: PJT

• Object type: VIEW

Columns

Name
RESOURCE_ID PERSON_ID EMAIL SCHEDULE_ID PROJECT_ID PROJECT_ROLE_ID WEEK_START_DATE ALLOCATED_HOURS

Query

SQL_Statement
SELECT a.resource_id, null person_id , null email , a.resource_calendar_id schedule_id , a.project_id , a.project_role_id , TRUNC(a.daily_date, 'D') week_start_date , ROUND(SUM(a.effort_d), 2) allocated_hours FROM PJT_SUM_PRS_LINEAR_SPREAD a GROUP BY a.resource_id , a.resource_calendar_id , a.project_id , a.project_role_id, TRUNC(a.daily_date, 'D')