SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
datastore_config.sas File Reference

The table DATASTORE_CONFIG contains details for storing data to the Centralized Data Repository. More...

Go to the source code of this file.

Detailed Description

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:

  • Enrichment - Tables in this group will be registered as part of the Data Enrichment process
  • DataQuality - Tables in this group will be registered as part of the Data Quality process
  • CreditRisk - Tables in this group will be registered as part of the Credit Stress Testing analytical process
  • <Any other value> - Custom values can be used to extend the functionality of the solution.

The following values for the LIBREF column are supported (i.e. already assigned at execution time):

  • ST_LND: Landing Area library (IRM Landing Area - Staging)
  • ST_MAP: Mapping library (IRM Landing Area - Mapping)
  • ST_CFG: Configuration library (IRM Landing Area - Static)
  • ST_PRM: Parameter library (IRM Persistence Area)
  • ST_STG: Staging library (IRM Persistence Area)
Author
SAS Institute Inc.
Date
2018

Definition in file datastore_config.sas.