View HLPDTEST.STATEGPS.RESOURCE_PERFORMANCE_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
DEPT_NAME varchar2 255
DESIGNATION_CODE varchar2 50  √  null
RESOURCE_NAME varchar2 2000  √  null
MOVED_OUT_DATE date 7  √  null
RESOURCE_PERFORMANCE number 22  √  null

Analyzed at Mon May 23 01:05 IST 2022

View Definition:
SELECT D.NAME DEPT_NAME, EE.DESIGNATION_CODE DESIGNATION_CODE, MV_RESOURCE_PERFORMANCE_MATRIX.RESOURCE_NAME RESOURCE_NAME, MV_RESOURCE_PERFORMANCE_MATRIX.MOVED_OUT_DATE MOVED_OUT_DATE, MV_RESOURCE_PERFORMANCE_MATRIX.RESOURCE_PERFORMANCE RESOURCE_PERFORMANCE FROM STATEGPS.MV_RESOURCE_PERFORMANCE_MATRIX MV_RESOURCE_PERFORMANCE_MATRIX, EIS.EIS_EMPLOYEE EE, EIS.T_DEPARTMENTS D, EIS.EIS_LOGIN EL WHERE D.ID = EE.DEPT_ID AND EE.EMPLOYEE_ID = EL.EMPLOYEE_ID AND STATEGPS.MV_RESOURCE_PERFORMANCE_MATRIX.RESOURCE_NAME = EL.USERNAME
 
Possibly Referenced Tables/Views: