PJT_RES_WEEKLY_SUMM_V

Details

  • Schema: FUSION

  • Object owner: PJT

  • Object type: VIEW

Columns

Name

SCHEDULE_ID

RESOURCE_ID

PERSON_ID

EMAIL

WEEK_START_DATE

CAPACITY_HOURS

ALLOCATED_HOURS

REMAINING_HOURS

TASK_ALLOCATED_HOURS

Query

SQL_Statement

SELECT NULL schedule_id ,

a.resource_id ,

NULL person_id ,

NULL email ,

a.week_start_date ,

a.capacity_hours ,

a.allocated_hours allocated_hours ,

a.remaining_hours ,

a.task_allocated_hours

FROM pjt_res_weekly_summ a