76CREATE TABLE &LIBREF..DATASTORE_CONFIG (
77 DATASTORE_GROUP_ID VARCHAR(32) label =
'Datastore Group Identifier',
78 LIBREF VARCHAR(20) label =
'Source Libref',
79 TABLE_NAME VARCHAR(100) label =
'Source Table Name',
80 ANALYSIS_DATA_NAME VARCHAR(150) label =
'Analysis Data Name',
81 ANALYSIS_DATA_DESC VARCHAR(250) label =
'Analysis Data Description',
82 DATA_DEFINITION_NAME VARCHAR(150) label =
'Data Definition Name',
83 DATA_DEFINITION_DESC VARCHAR(250) label =
'Data Definition Description',
84 SCHEMA_NAME VARCHAR(100) label =
'Schema Name',
85 SCHEMA_VERSION VARCHAR(50) label =
'Schema Version',
86 SCHEMA_TYPE VARCHAR(20) label =
'Schema Type',
87 BUSINESS_CATEGORY VARCHAR(100) label =
'Business Category',
88 DATA_CATEGORY VARCHAR(100) label =
'Data Category',
89 DATA_SUB_CATEGORY VARCHAR(100) label =
'Data Sub-Category',
90 RESULTS_CATEGORY VARCHAR(100) label =
'Results Category',
91 RISK_TYPE VARCHAR(100) label =
'Risk Type',
92 DATA_TYPE VARCHAR(100) label =
'Data Type',
93 REPORTMART_GROUP_ID VARCHAR(32) label =
'Reportmart Group Id',
94 MART_LIBRARY_NAME VARCHAR(10000) LABEL =
'Reportmart Library Name',
95 MART_TABLE_NAME VARCHAR(32) LABEL =
'Reportmart Table Name',
96 RLS_TABLE_NAME VARCHAR(32) LABEL =
'Row-Level Security Table Name',
97 LASR_LIBRARY_NAME VARCHAR(10000) LABEL =
'LASR Library Name',
98 LASR_META_FOLDER VARCHAR(10000) LABEL =
'LASR Metadata Folder',
99 PARTITION_VARS VARCHAR(4096) label =
'Partition Vars',
100 FILTERABLE_VARS VARCHAR(10000) label =
'Filterable Vars',
101 CLASSIFICATION_VARS VARCHAR(10000) label =
'Classification Vars',
102 ATTRIBUTABLE_VARS VARCHAR(10000) label =
'Attributable Vars',
103 MANDATORY_SEGMENTATION_VARS VARCHAR(10000) label =
'Mandatory Segmentation Vars',
104 PROJECTION_VARS VARCHAR(10000) label =
'Projection Vars',
105 FX_VARS VARCHAR(10000) label =
'FX Vars',
106 CUSTOM_CODE VARCHAR(10000) label =
'Custom Code',
107 PRIMARY_KEY VARCHAR(10000) label =
'Primary Key',
108 INDEX_LIST VARCHAR(10000) label =
'Index List',
109 BUSINESS_KEY VARCHAR(10000) label =
'Business Key',
110 DIMENSION_LIST VARCHAR(10000) label =
'Dimension List',
111 TYPE2_COLS VARCHAR(10000) label =
'Type2 Columns',
112 META_LIBRARY_NAME VARCHAR(10000) label =
'Metadata Library Name',
113 DETAILS_ROOT VARCHAR(10000) label =
'Details Root Location',
114 DETAILS_APP VARCHAR(1024) label =
'Details Application',
115 CONSTRAINT_ENABLED_FLG VARCHAR(10) label =
'Constraints Enabled Flag',
116 RULE_SET_NAME VARCHAR(100) label =
'Rule Set Name',
117 RULE_SET_DESC VARCHAR(250) label =
'Rule Set Description',
118 RULE_SET_GROUP_ID VARCHAR(100) label =
'Rule Set Group Id',
119 RULE_SET_CATEGORY VARCHAR(100) label =
'Rule Set Category',
120 CONSTRAINT PRIM_KEY PRIMARY KEY (DATASTORE_GROUP_ID, LIBREF, TABLE_NAME)