View HLPDTEST.STATEGPS.T_PROJECT_CURRENT_PLAN_V Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
START_DATE date 7  √  null
FINISH_DATE date 7  √  null
PERCENT_COMPLETED number 22  √  null
TAG varchar2 1000  √  null
MODULE varchar2 50  √  null
WORKFLOW varchar2 255  √  null
PROJECT varchar2 255  √  null
PROJECT_ID number 22  √  null
T_PROJECT_DETAILS.PROJECT_ID Implied Constraint R
WORKFLOW_ORDER number 22  √  null
WORKFLOW_ID number 22  √  null
TOTAL_TASKS number 22  √  null
TASKS_COMPLETED number 22  √  null
DURATION number 22  √  null

Analyzed at Tue Aug 11 01:05 IST 2020

View Definition:
select min(start_date) start_date, max(end_date) finish_date, round(coalesce(decode(sum(decode(daysremaining, 0, duration)), null, 0, sum(decode(daysremaining, 0, duration))) / sum(decode(daysremaining, 0, duration, coalesce(daysremaining, duration))) * 100, 0), 2) percent_completed, task, module, workflow, project, project_id, workflow_order, workflow_id, count(task_id) total_tasks, sum(case when daysremaining = 0 and task is not null then 1 else 0 end) tasks_completed, trunc(max(end_date)) - trunc(min(start_date)) duration from t_project_plan_tasks_v --where project_id = 8522 group by task, module, workflow, project, project_id, workflow_order, workflow_id
 
Possibly Referenced Tables/Views:


Close relationships: