SchemaSpy - View HLPDTEST.STATEGPS.V_ACTUAL

Generated by
SchemaSpy

Legend:

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

√

null

T_PROJECT_TASK.PROJECT_TASK_ID

Implied Constraint R

ACTUAL_HOURS

number

√

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:

T_PROJECT_ACTIVITY