BDNA Data Platform 5.4 July 2017 (Oracle)
TECHNOPEDIA_TABS_METADATA_VW - Internal Technopedia view

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
TECHNOPEDIA_TABS_METADATA_ID number 18  √  null
OWNER nvarchar2 75  √  null
TABLE_NAME nvarchar2 290  √  null
COLUMN_NAME nvarchar2 75  √  null
COLUMN_LABEL nvarchar2 250  √  null
DATA_TYPE nvarchar2 265  √  null
DATA_LENGTH number 0  √  null
DATA_PRECISION number 0  √  null
NULLABLE nvarchar2 2  √  null
DATA_DEFAULT nvarchar2 250  √  null
TABLE_ORDER number 0  √  null
COLUMN_ORDER number 0  √  null
DISPLAY_ORDER number 0  √  null
IS_IN_DEFAULT_VIEW nvarchar2 2  √  null
ACTIVE nvarchar2 2  √  null
VERSION nvarchar2 12  √  null
COMMENTS varchar2 4000  √  null
IS_VISIBLE nvarchar2 2  √  null
IS_PRIVATE char 1  √  null
SECTION varchar2 100  √  null
ISEDITABLE number 1  √  null
ISREQUIRED number 1  √  null

Analyzed at Thu Jul 20 12:13 PDT 2017

View Definition:
SELECT TECH.TECHNOPEDIA_TABS_METADATA_ID, TECH.OWNER, TECH.TABLE_NAME, TECH.COLUMN_NAME, TECH.COLUMN_LABEL, TECH.DATA_TYPE, TECH.DATA_LENGTH, TECH.DATA_PRECISION, TECH.NULLABLE, TECH.DATA_DEFAULT, TECH.TABLE_ORDER, TECH.COLUMN_ORDER, COALESCE(TECHNOPEDIA_UI_META.DISPLAY_ORDER,TECH.DISPLAY_ORDER) DISPLAY_ORDER, COALESCE(TECHNOPEDIA_UI_META.IS_IN_DEFAULT_VIEW,TECH.IS_IN_DEFAULT_VIEW) IS_IN_DEFAULT_VIEW, TECH.ACTIVE, TECH.VERSION, TECH.COMMENTS, TECH.IS_VISIBLE, TECH.IS_PRIVATE, TECH.SECTION, TECH.ISEDITABLE, TECH.ISREQUIRED FROM ( select TECHNOPEDIA_TABS_METADATA_ID, TO_NCHAR(OWNER) OWNER, TO_NCHAR(case when substr(TABLE_NAME,1,4) ='TCAT' then substr(TABLE_NAME,2,length(TABLE_NAME)) else TABLE_NAME end) TABLE_NAME, TO_NCHAR(COLUMN_NAME) COLUMN_NAME, TO_NCHAR(DISPLAY_LABEL) AS COLUMN_LABEL, TO_NCHAR(DATA_TYPE) DATA_TYPE, DATA_LENGTH, DATA_PRECISION, TO_NCHAR(NULLABLE) NULLABLE, TO_NCHAR(DATA_DEFAULT) DATA_DEFAULT, TABLE_ORDER, COLUMN_ORDER, DISPLAY_ORDER AS DISPLAY_ORDER, TO_NCHAR(IS_IN_DEFAULT_VIEW) IS_IN_DEFAULT_VIEW, TO_NCHAR(ACTIVE) ACTIVE, TO_NCHAR(VERSION) VERSION, COMMENTS, TO_NCHAR(IS_VISIBLE) IS_VISIBLE, 'N' IS_PRIVATE, SECTION, ISEDITABLE, ISREQUIRED FROM TECHNOPEDIA_TABS_METADATA UNION SELECT TPC_TABS_METADATA_ID, OWNER, TABLE_NAME, COLUMN_NAME, DISPLAY_LABEL AS COLUMN_LABEL, DATA_TYPE, DATA_LENGTH, DATA_PRECISION, NULLABLE, DATA_DEFAULT, TABLE_ORDER, COLUMN_ORDER, DISPLAY_ORDER, IS_IN_DEFAULT_VIEW, ACTIVE, VERSION, COMMENTS, IS_VISIBLE, 'Y' IS_PRIVATE, SECTION, ISEDITABLE, ISREQUIRED FROM TPC_TABS_METADATA ) TECH LEFT JOIN TECHNOPEDIA_UI_META ON TECHNOPEDIA_UI_META.TECHNOPEDIA_TABS_METADATA_ID = TECH.TECHNOPEDIA_TABS_METADATA_ID
 
Possibly Referenced Tables/Views:

Confidential and Proprietary to BDNA