View slot9.WORLD.TSTA.USRSCRN_FIELDINTERVIEW_VW
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
INTERVIEW_ID number 0
INTERVIEW_DATE date 7
TYPE_DESC varchar2 4000  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT FI.FLDINT_ID,FI.FLDINT_DATE, EC.DESCRIPTION AS TYPE_DESC FROM FIELD_INTERVIEWS FI INNER JOIN EJS_CODES EC ON FI.FLDINT_TYPE = EC.CODE AND FI.FLDINT_TYPE_TYPE = EC.CODE_TYPE
 
Possibly Referenced Tables/Views:
EJS_CODES FIELD_INTERVIEWS