SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
aggregation_rules_config.sas
Go to the documentation of this file.
1/* Copyright (C) 2019 SAS Institute Inc. Cary, NC, USA */
2
3/*!
4\file
5\brief The table AGGREGATION_RULES_CONFIG contains parameters for the BEP jobflow execution.
6
7 |PK |Variable |Type | Required? |Label |Description |
8 |--------------|--------------------------------|------------------|-----------|---------------------------|-------------------------------------------------------------|
9 |![ ](pk.jpg) | <b>TGT_TABLE_SCHEMA_NM</b> | VARCHAR(150) | Y | Target Schema Name | Schema name of the target table |
10 | | TGT_TABLE_SCHEMA_VER | VARCHAR(50) | Y | Target Schema Version | Schema version of the target table |
11 | | TGT_TBL_VAL_COL | VARCHAR(32) | Y | Target Value Column | Variable name where aggregation should be applied |
12 |![ ](pk.jpg) | <b>TGT_TBL_ID_COL</b> | VARCHAR(32) | Y | Target Id Column | Column in target table with unique identifier for filtering and application of aggregated value |
13 |![ ](pk.jpg) | <b>TGT_TBL_ID_VAL</b> | VARCHAR(100) | Y | Target Id Value | Value in target id column to use for filtering application of aggregated value |
14 | | SRC_TABLE_SCHEMA_NM | VARCHAR(150) | Y | Source Schema Name | Schema name of the source table |
15 | | SRC_TABLE_SCHEMA_VER | VARCHAR(50) | Y | Source Schema Version | Schema version of the source table |
16 | | SRC_COL | VARCHAR(32) | Y | Source Column | Variable that should be aggregated |
17 | | SRC_WHERE_COND | VARCHAR(4000) | Y | Source Where Condition | Filtering condition for aggregation |
18 | | SRC_WHERE_VARS | VARCHAR(2000) | Y | Source Where Variables | Filtering condition for aggregation |
19 | | AGGREGATION_RULE | VARCHAR(20) | Y | Aggregation Method | Method for aggregation |
20 | | WEIGHT_VAR | VARCHAR(100) | Y | Weight Variable | Weight variable for aggregation |
21
22 \details
23
24 This table is used during the balance sheet projection to retrieve aggregation rules for GL and PL tables.
25 Any valid aggregation function supported by the proc SUMMARY procedure can be specified.
26
27 \ingroup ddlStaticFlow
28 \author SAS Institute Inc.
29 \date 2019
30*/
31
32CREATE TABLE &LIBREF..AGGREGATION_RULES_CONFIG (
33 TGT_TABLE_SCHEMA_NM VARCHAR(150) label = 'Target Schema Name',
34 TGT_TABLE_SCHEMA_VER VARCHAR(50) label = 'Target Schema Version',
35 TGT_TBL_VAL_COL VARCHAR(32) label = 'Target colunm',
36 TGT_TBL_ID_COL VARCHAR(32) label = 'Target Id Column',
37 TGT_TBL_ID_VAL VARCHAR(100) label = 'Target Id Value',
38 SRC_TABLE_SCHEMA_NM VARCHAR(150) label = 'Source Schema Name',
39 SRC_TABLE_SCHEMA_VER VARCHAR(50) label = 'Source Schema Version',
40 SRC_COL VARCHAR(32) label = 'Source Column',
41 SRC_WHERE_COND VARCHAR(4000) label = 'Source Where Condition',
42 SRC_WHERE_VARS VARCHAR(2000) label = 'Source Where Variables',
43 AGGREGATION_RULE VARCHAR(20) label = 'Aggregation Method',
44 WEIGHT_VAR VARCHAR(100) label = 'Weight Variable',
45 CONSTRAINT PRIM_KEY PRIMARY KEY (TGT_TABLE_SCHEMA_NM, TGT_TBL_ID_VAL, TGT_TBL_ID_COL)
46);