View HLPDTEST.STATEGPS.V_TASKS_WHITEBOARD 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
INSTANCE_ID number 22  √  null
T_GPS_WORKFLOW_INSTANCES.INSTANCE_ID Implied Constraint R
TASK_START_DATE date 7  √  null
USER_NAME varchar2 2000  √  null
DURATION number 22  √  null
DAYSREMAINING number 22  √  null
IA_ISSUE_NUMBER varchar2 4000  √  null
IA_ISSUE_TITLE varchar2 4000  √  null
STATE_NAME varchar2 255  √  null
STATE_ID number 22
T_GPS_WORKFLOW_STATES.STATE_ID Implied Constraint R
WORKFLOW_TYPE_NAME varchar2 255
WORKFLOW_TYPE_ID number 22
T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID Implied Constraint R
APPLICATION_ID number 22
T_GPS_APPLICATIONS.APPLICATION_ID Implied Constraint R
APPLICATION_NAME varchar2 255  √  null
TASK_LAST_UPDATED_DATE date 7  √  null
ACTIVITY varchar2 4000  √  null
SPENT_ACTIVITY_HOURS number 22  √  null
PREDECESSOR varchar2 4000  √  null
STATUS varchar2 11  √  null
ESTIMATED_HOURS number 22  √  null
SPENT_HOURS number 22  √  null
LEFT_HOURS number 22  √  null
SUB_TASK_STATUS varchar2 6  √  null
APPLICATION_MODULE varchar2 50  √  null
PROJECT_TASK_ID number 22  √  null
T_PROJECT_TASK.PROJECT_TASK_ID Implied Constraint R

Analyzed at Tue Aug 11 01:05 IST 2020

View Definition:
SELECT t_project_task_v.property3 instance_id, t_project_task_v.start_date Task_Start_Date, t_project_task_v.user_name, t_project_task_v.duration, t_project_task_v.daysremaining, v_instance_props.ia_issue_number, v_instance_props.ia_issue_title, t_gps_workflow_states.state_name, t_gps_workflow_states.state_id, t_gps_workflow_types.workflow_type_name, t_gps_workflow_types.workflow_type_id, t_gps_applications.application_id, t_gps_applications.application_name, --t_project_task_history.update_date Task_last_updated_date, T_PROJECT_ACTIVITY.Created_date Task_last_updated_date, T_PROJECT_ACTIVITY.activity, ((Nvl(BILLABLE_HOURS, 0) + Nvl(NON_BILLABLE_HOURS, 0) + Nvl(EXTRA_BILLABLE_HOURS, 0))) spent_activity_hours, t_instances.predecessor, t_project_task_v.status, Nvl(t_project_task_v.duration, 0) * 8 ESTIMATED_HOURS, NVL(Activity_hours.SPENT_HOURS, 0) SPENT_HOURS, (Nvl(t_project_task_v.duration, 0) * 8 - NVL(Activity_hours.SPENT_HOURS, 0)) LEFT_HOURS, Decode(t_project_task_v.daysremaining, 0, 'Closed', 'OPEN') SUB_TASK_STATUS, issues.application_module, t_project_task_v.project_task_id FROM stategps.t_project_task_v T_PROJECT_TASK_V, stategps.v_instance_props V_INSTANCE_PROPS, stategps.t_gps_workflow_states T_GPS_WORKFLOW_STATES, stategps.t_gps_workflow_types T_GPS_WORKFLOW_TYPES, stategps.t_gps_applications T_GPS_APPLICATIONS, stategps.t_project_task_history T_PROJECT_TASK_HISTORY, stategps.t_instances T_INSTANCES, stategps.t_project_activity T_PROJECT_ACTIVITY, tri2gps_dev.issues ISSUES, (SELECT a.PROJECT_TASK_ID, SUM(Nvl(BILLABLE_HOURS, 0) + Nvl(NON_BILLABLE_HOURS, 0) + Nvl(EXTRA_BILLABLE_HOURS, 0)) SPENT_HOURS FROM T_PROJECT_ACTIVITY a GROUP BY a.PROJECT_TASK_ID) Activity_hours WHERE t_project_task_v.project_task_id = t_project_task_history.project_task_id( + ) AND T_PROJECT_TASK_V.PROJECT_TASK_ID = Activity_hours.PROJECT_TASK_ID (+) AND t_project_task_v.property3 = t_instances.instance_id (+) AND t_project_task_v.project_task_id = t_project_activity.project_task_id ( + ) AND t_project_task_v.property3 = v_instance_props.instance_id(+) AND t_project_task_v.ia_issue_number IS NOT NULL AND t_project_task_v.state_id = t_gps_workflow_states.state_id AND t_project_task_v.ia_issue_number = issues.issue_number (+) AND t_gps_workflow_types.application_id = t_gps_applications.application_id AND t_gps_workflow_states.workflow_type_id = t_gps_workflow_types.workflow_type_id AND ( t_project_task_history.history_id IS NULL OR t_project_task_history.history_id = (SELECT Max( T_PROJECT_TASK_HISTORY$1.history_id) FROM stategps.t_project_task_history T_PROJECT_TASK_HISTORY$1 WHERE T_PROJECT_TASK_HISTORY$1.project_task_id = t_project_task_v.project_task_id) ) -- AND t_project_task_v.project_task_id = 27537 --AND t_project_task_v.ia_issue_number = 'IS065517' ORDER BY t_project_task_v.project_task_id
 
Possibly Referenced Tables/Views:


Close relationships: