PJT_RES_WEEKLY_CAPACITY_V

Details

• Schema: FUSION

• Object owner: PJT

• Object type: VIEW

Columns

Name
SCHEDULE_ID RESOURCE_ID PERSON_ID EMAIL WEEK_START_DATE CAPACITY_HOURS

Query

SQL_Statement

SELECT A.SCHEDULE_ID , A.resource_id , A.person_id , A.email , TRUNC(dlyhrs.daily_date, 'D') week_start_date , SUM(hours_d) capacity_hours FROM ( SELECT DISTINCT NVL(res.schedule_id, -99) AS schedule_id , res.resource_id , res.person_id , res.email FROM fusion.pjt_prj_enterprise_resource_b res WHERE res.resource_class = 'PEOPLE' )a, PJT_SUM_RES_LINEAR_SPREAD dlyhrs WHERE a.resource_id = dlyhrs.resource_id GROUP BY a.schedule_id , a.resource_id , a.person_id , a.email , TRUNC(dlyhrs.daily_date, 'D')