View HLPDTEST.STATEGPS.T_PROJECT_CURRENT_PLAN_TAG_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 timestamp(6) 11,6  √  null
FINISH_DATE timestamp(6) 11,6  √  null
PERCENT_COMPLETED number 22  √  null
TAG varchar2 255  √  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
TAG_ORDER number 22  √  null
WORKFLOW_ID number 22  √  null
TOTAL_TASKS number 22  √  null
TASKS_COMPLETED number 22  √  null
DURATION number 22  √  null
TAG_ID number 22  √  null
T_REPORTING_PLAN_TAGS.TAG_ID Implied Constraint R

Analyzed at Fri Dec 03 01:06 IST 2021

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 , TAG, MODULE, WORKFLOW, PROJECT, PROJECT_ID, TAG_ORDER, WORKFLOW_ID, COUNT(TASK_ID)TOTAL_TASKS, SUM( CASE WHEN DAYSREMAINING = 0 AND TAG IS NOT NULL THEN 1 ELSE 0 END )TASKS_COMPLETED, TRUNC(MAX(END_DATE))- TRUNC(MIN(START_DATE))DURATION, TAG_ID FROM T_PROJECT_PLAN_TAGS_V --where project_id = 9733 GROUP BY TAG, MODULE, WORKFLOW, PROJECT, PROJECT_ID, TAG_ORDER, TAG_ID, WORKFLOW_ID
 
Possibly Referenced Tables/Views:


Close relationships: