Server (Cells) Design
Space shortcuts
Space Tools
Skip to end of metadata
Go to start of metadata


Column Name

Data Type
(Oracle)

Data Type
(SQL)

C_HLEVEL

INT

INT

C_FULLNAME

VARCHAR2(1500)

VARCHAR(700)

C_NAME

VARCHAR2(2000)

VARCHAR(2000)

C_SYNONYM_CD

CHAR(1)

CHAR(1)

C_VISUALATTRIBUTES

CHAR(3)

CHAR(3)

C_TOTALNUM

INT

INT

C_BASECODE

VARCHAR2(50)

VARCHAR(50)

C_METADATAXML

CLOB

TEXT

C_FACTTABLECOLUMN

VARCHAR2(50)

VARCHAR(50)

C_TABLENAME

VARCHAR2(50)

VARCHAR(50)

C_COLUMNNAME

VARCHAR2(50)

VARCHAR(50)

C_COLUMNDATATYPE

VARCHAR2(50)

VARCHAR(50)

C_OPERATOR

VARCHAR2(10)

VARCHAR(10)

C_DIMCODE

VARCHAR2(700)

VARCHAR(700)

C_COMMENT

CLOB

TEXT

C_TOOLTIP

VARCHAR2(900)

VARCHAR(900)

UPDATE_DATE

DATE

DATETIME

DOWNLOAD_DATE

DATE

DATETIME

IMPORT_DATE

DATE

DATETIME

SOURCESYSTEM_CD

VARCHAR2(50)

VARCHAR(50)

VALUETYPE_CD

VARCHAR2(50)

VARCHAR(50)

M_APPLIED_PATH

VARCHAR2(700)

VARCHAR(700)

M_EXCLUSION_CD

VARCHAR2(25)

VARCHAR(25)

C_PATH

VARCHAR2(1300)

VARCHAR(700)

C_SYMBOL

VARCHAR2(200)

VARCHAR(50)



  • No labels