The table DATASTORE_CONFIG contains details for storing data to the Centralized Data Repository. More...
Go to the source code of this file.
The table DATASTORE_CONFIG contains details for storing data to the Centralized Data Repository.
PK | Variable | Type | Required? | Label | Description |
---|---|---|---|---|---|
![]() | DATASTORE_GROUP_ID | VARCHAR(32) | Y | Datastore Group Identifier | Identifier used to process tables together. |
![]() | LIBREF | VARCHAR(20) | Y | Source Libref | Source Libref |
![]() | TABLE_NAME | VARCHAR(100) | Y | Source Table Name | Source Table Name |
ANALYSIS_DATA_NAME | VARCHAR(150) | Y | Analysis Data Name | Analysis Data Name | |
ANALYSIS_DATA_DESC | VARCHAR(250) | N | Analysis Data Description | Analysis Data Description | |
DATA_DEFINITION_NAME | VARCHAR(150) | Y | Data Definition Name | Data Definition Name | |
DATA_DEFINITION_DESC | VARCHAR(250) | N | Data Definition Description | Data Definition Description | |
SCHEMA_NAME | VARCHAR(100) | Y | Schema Name | Logical name of the table schema | |
SCHEMA_VERSION | VARCHAR(50) | Y | Schema Version | Identifies a specific version of the metadata. Each metadata version may specify different primary key, business key, indexes, partition scheme, etc. | |
SCHEMA_TYPE | VARCHAR(20) | Y | Schema Type | Schema Type: - FLAT - DIMENSION - FACT | |
BUSINESS_CATEGORY | VARCHAR(100) | Y | Business Category | Business Category: - ST - ALM - IFRS9 - CECL - IFRS17 | |
DATA_CATEGORY | VARCHAR(100) | Y | Data Category | Data Category: PORTFOLIO - COUNTERPARTY - CASHFLOW - AUDIT_SUMMARY - DATA_QUALITY - BALANCE_SHEET - OWN_FUNDS - PROFIT_LOSS - RESULTS - SCENARIO - SYNTHETIC_INSTRUMENT - MAPPING - CONFIGURATION - PARAMETER - BUSINESS_EVOLUTION - OTHER | |
DATA_SUB_CATEGORY | CHARACTER(100) | Y | Data Sub-Category | Data Sub-Category - valid values are defined in the dataSubCategories named list. | |
RESULTS_CATEGORY | VARCHAR(100) | Y | Results Category | Results Category to assign to Analysis Data instance. Valid values are defined in the resultCategoryCd NamedList (e.g. FR_HTM, AFS, Other). | |
RISK_TYPE | VARCHAR(100) | Y | Risk Type | Risk Type: - CREDIT - MARKET - OPERATIONAL - FINANCIAL - REPUTATIONAL - OTHER | |
DATA_TYPE | VARCHAR(100) | N | Data Type | Free text: it can be used to specify custom attributes related to this table schema | |
REPORTMART_GROUP_ID | VARCHAR(32) | N | Reportmart Group Id | Relevant for tables where Data Category = RESULTS. It must match the corresponding entry inside table reportmart_config.sas | |
MART_LIBRARY_NAME | CHARACTER(10000) | N | Reportmart Library Name | Reportmart library name as defined in metadata | |
MART_TABLE_NAME | CHARACTER(32) | N | Reportmart Table Name | Table name of the reportmart table. It must match the corresponding entry inside table reportmart_config.sas | |
RLS_TABLE_NAME | CHARACTER(32) | N | Row-Level-Security Table Name | Table name of the row-level-security table. It must match the corresponding entry inside table reportmart_config.sas | |
LASR_LIBRARY_NAME | CHARACTER(10000) | N | LASR Library Name | LASR library name as defined in metadata | |
LASR_META_FOLDER | CHARACTER(10000) | N | LASR Meta Folder | Metadata folder where the LASR libray is defined. It must include the full path. | |
PARTITION_VARS | VARCHAR(4096) | N | Partition Vars | List of custom partition variables. This is in addition to project_id, load_id, workgroup and entity_id | |
FILTERABLE_VARS | VARCHAR(10000) | N | Filterable Vars | List of filterable variables. This controls which fields will have a dropdown filter in the Data View of the Analysis Data. | |
CLASSIFICATION_VARS | VARCHAR(10000) | N | Classification Vars | List of classification variables. This controls which fields can be used as classification fields in the Classification Rule Set. | |
ATTRIBUTABLE_VARS | VARCHAR(10000) | N | Attributable Vars | List of attributable variables. This controls which variables can be used in attribution analysis. | |
MANDATORY_SEGMENTATION_VARS | VARCHAR(10000) | N | Mandatory Segmentation Vars | List of mandatory segmentation variables. This controls which variables must be part of the segmentation scheme. | |
PROJECTION_VARS | VARCHAR(10000) | N | Projection Vars | List of fields that can be used for projection in Business Evolution Plans. | |
FX_VARS | CHARACTER(10000) | N | FX Vars | Variables subject to currency conversion | |
CUSTOM_CODE | VARCHAR(10000) | N | Custom Code | Custom code to be executed as part of the data preparation. It must contain valid data step syntax. | |
PRIMARY_KEY | VARCHAR(10000) | N | Primary Key | For flat tables, it is a space separated list of columns of the input table that make up the primary key. For dimension and fact tables, it is the name that will be given to the surrogate key column. | |
INDEX_LIST | VARCHAR(10000) | N | Index List | List of indexes. These indexes are created independently on each partition. | |
BUSINESS_KEY | VARCHAR(10000) | N | Business Key | Space separated list of columns that make up the business key. Only applicable to Dimension tables. | |
DIMENSION_LIST | VARCHAR(10000) | N | Dimension List | Space separated list of dimension tables (schema names and version) that are related to the fact table. | |
TYPE2_COLS | VARCHAR(10000) | N | Type2 Columns | Space separated list of Type-2 columns that will be used to determine whether a new record must be added to the dimension table. | |
META_LIBRARY_NAME | VARCHAR(10000) | N | Metadata Library Name | Name of the metadata library where this table is stored | |
DETAILS_ROOT | VARCHAR(10000) | N | Details Root Location | Root to the location where the partition tables are stored. | |
DETAILS_APP | VARCHAR(1024) | N | Details Application | Name of the SAS Application for which the detail data are stored. Used if the details_root parameter points to the <AppData>/SASRiskWorkgroup location. | |
CONSTRAINT_ENABLED_FLG | VARCHAR(10) | N | Constraints Enabled Flag | Flag Y/N. Controls whether index/constraint creation is enabled. | |
RULE_SET_NAME | VARCHAR(100) | N | Rule Set Name | Rule Set Name | |
RULE_SET_DESC | VARCHAR(250) | N | Rule Set Description | Rule Set Description | |
RULE_SET_GROUP_ID | VARCHAR(100) | N | Rule Set Group Id | Rule Set Group Identifier. Linked to ruleset_config.sas | |
RULE_SET_CATEGORY | VARCHAR(100) | N | Rule Set Categoru | Rule Set Category: - DQ: Data Quality - STAGE: Stage Allocation - ADJ: Adjustments - OTHER: Other |
See irmst_node_store_analysis_data.sas for details.
Valid values for column DATASTORE_GROUP_ID are:
The following values for the LIBREF column are supported (i.e. already assigned at execution time):
Definition in file datastore_config.sas.