View HLPDTEST.STATEGPS.V_ACTUAL_HOURS 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
PROJECT_TASK_ID number 22  √  null
T_PROJECT_TASK.PROJECT_TASK_ID Implied Constraint R
ACTUAL_HOURS number 22  √  null

Analyzed at Sun Jan 17 01:06 IST 2021

View Definition:
select project_task_id, sum(nvl(billable_hours,0)+nvl(non_billable_hours,0)+nvl(extra_billable_hours,0)) actual_hours from t_project_activity group by project_task_id
 
Possibly Referenced Tables/Views:


Close relationships: