View HLPDTEST.STATEGPS.TEST_TIME_TRACKING_V_7292 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 varchar2 255  √  null
PROCESS varchar2 0  √  null
RESOURCE_NAME varchar2 2000  √  null
ENTERED_DATE date 7  √  null
BILLABLE_HOURS number 22  √  null
NON_BILLABLE_HOURS number 22  √  null
EXTRA_BILLABLE_HOURS number 22  √  null
BRANCH_ID varchar2 20  √  null
STATUS varchar2 25  √  null
EMPLOYEE_ID varchar2 200
PROJECT_ID number 22
T_PROJECT_DETAILS.PROJECT_ID Implied Constraint R
MANAGER_ID number 22  √  null
REPORTING_MANAGER_ID number 22  √  null

Analyzed at Tue Sep 22 01:05 IST 2020

View Definition:
SELECT T_GPS_APPLICATIONS.APPLICATION_NAME PROJECT, NULL process, DECODE(T_PROJECT_ACTIVITY.USER_NAME, NULL, T_PROJECT_TASK.USER_NAME, T_PROJECT_ACTIVITY.USER_NAME) RESOURCE_NAME, (T_PROJECT_ACTIVITY.CREATED_DATE) ENTERED_DATE, SUM(T_PROJECT_ACTIVITY.BILLABLE_HOURS) BILLABLE_HOURS, SUM(T_PROJECT_ACTIVITY.NON_BILLABLE_HOURS) NON_BILLABLE_HOURS, SUM(T_PROJECT_ACTIVITY.EXTRA_BILLABLE_HOURS) EXTRA_BILLABLE_HOURS, ee.branch_id BRANCH_ID, t_project_activity.approve STATUS, ee.employee_id, T_GPS_APPLICATIONS.Application_Id PROJECT_ID, TO_NUMBER((SELECT el.employee_id from TAS.t_users u, t_gps_app_properties ap, eis.eis_login el where to_char(u.user_id) = ap.property_value and ap.property_name = 'PROJECT_MANAGER' and u.user_name = el.username and ap.application_id = T_GPS_APPLICATIONS.application_id)) MANAGER_ID, to_number(ee.next_higher_authority) REPORTING_MANAGER_ID FROM STATEGPS.T_PROJECT_ACTIVITY T_PROJECT_ACTIVITY, STATEGPS.T_PROJECT_TASK T_PROJECT_TASK, STATEGPS.T_INSTANCES T_INSTANCES, STATEGPS.T_GPS_APPLICATIONS T_GPS_APPLICATIONS, EIS.EIS_EMPLOYEE ee, EIS.EIS_LOGIN EL WHERE T_PROJECT_TASK.PROJECT_TASK_ID = T_PROJECT_ACTIVITY.PROJECT_TASK_ID AND T_INSTANCES.INSTANCE_ID = T_PROJECT_TASK.INSTANCE_ID AND T_GPS_APPLICATIONS.APPLICATION_ID = T_INSTANCES.APPLICATION_ID and ee.employee_id = el.employee_id AND EL.USERNAME = DECODE(T_PROJECT_ACTIVITY.USER_NAME, NULL, T_PROJECT_TASK.USER_NAME, T_PROJECT_ACTIVITY.USER_NAME) AND T_GPS_APPLICATIONS.VISIBLE_FLAG = 'true' AND el.employee_id = '7292' and T_PROJECT_ACTIVITY.CREATED_DATE between sysdate - 4 and sysdate GROUP BY T_GPS_APPLICATIONS.APPLICATION_NAME, NULL, DECODE(T_PROJECT_ACTIVITY.USER_NAME, NULL, T_PROJECT_TASK.USER_NAME, T_PROJECT_ACTIVITY.USER_NAME), (T_PROJECT_ACTIVITY.CREATED_DATE), ee.firstname || ' ' || ee.middlename || ' ' || ee.lastname, ee.branch_id, t_project_activity.approve, ee.employee_id, T_GPS_APPLICATIONS.Application_Id, NULL, to_number(ee.next_higher_authority)
 
Possibly Referenced Tables/Views:


Close relationships: