BDNA Data Platform 5.4 July 2017 (SQL Server) TECHNOPEDIA_TABS_METADATA_VW - Internal Technopedia view
|
View Definition:
CREATE VIEW TECHNOPEDIA_TABS_METADATA_VW AS
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,
CAST(OWNER AS NVARCHAR(30)) OWNER,
CAST((case when substring(TABLE_NAME,1,4) ='TCAT'
then substring(TABLE_NAME,2,len(TABLE_NAME)) else TABLE_NAME end) AS NVARCHAR(30)) TABLE_NAME,
CAST(COLUMN_NAME AS NVARCHAR(30)) COLUMN_NAME,
CAST(DISPLAY_LABEL AS NVARCHAR(100)) COLUMN_LABEL,
CAST(DATA_TYPE AS NVARCHAR(106)) DATA_TYPE,
DATA_LENGTH,
DATA_PRECISION,
CAST(NULLABLE AS NVARCHAR(1)) NULLABLE,
CAST(DATA_DEFAULT AS NVARCHAR(100)) DATA_DEFAULT,
TABLE_ORDER,
COLUMN_ORDER,
DISPLAY_ORDER AS DISPLAY_ORDER,
CAST(IS_IN_DEFAULT_VIEW AS NVARCHAR(1)) IS_IN_DEFAULT_VIEW,
CAST(ACTIVE AS NVARCHAR(1)) ACTIVE,
CAST(VERSION AS NVARCHAR(5)) VERSION,
COMMENTS,
CAST(IS_VISIBLE AS NVARCHAR(1)) 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: