The table AGGREGATION_RULES_CONFIG contains parameters for the BEP jobflow execution. More...
Go to the source code of this file.
The table AGGREGATION_RULES_CONFIG contains parameters for the BEP jobflow execution.
PK | Variable | Type | Required? | Label | Description |
---|---|---|---|---|---|
![]() | TGT_TABLE_SCHEMA_NM | VARCHAR(150) | Y | Target Schema Name | Schema name of the target table |
TGT_TABLE_SCHEMA_VER | VARCHAR(50) | Y | Target Schema Version | Schema version of the target table | |
TGT_TBL_VAL_COL | VARCHAR(32) | Y | Target Value Column | Variable name where aggregation should be applied | |
![]() | TGT_TBL_ID_COL | VARCHAR(32) | Y | Target Id Column | Column in target table with unique identifier for filtering and application of aggregated value |
![]() | TGT_TBL_ID_VAL | VARCHAR(100) | Y | Target Id Value | Value in target id column to use for filtering application of aggregated value |
SRC_TABLE_SCHEMA_NM | VARCHAR(150) | Y | Source Schema Name | Schema name of the source table | |
SRC_TABLE_SCHEMA_VER | VARCHAR(50) | Y | Source Schema Version | Schema version of the source table | |
SRC_COL | VARCHAR(32) | Y | Source Column | Variable that should be aggregated | |
SRC_WHERE_COND | VARCHAR(4000) | Y | Source Where Condition | Filtering condition for aggregation | |
SRC_WHERE_VARS | VARCHAR(2000) | Y | Source Where Variables | Filtering condition for aggregation | |
AGGREGATION_RULE | VARCHAR(20) | Y | Aggregation Method | Method for aggregation | |
WEIGHT_VAR | VARCHAR(100) | Y | Weight Variable | Weight variable for aggregation |
This table is used during the balance sheet projection to retrieve aggregation rules for GL and PL tables. Any valid aggregation function supported by the proc SUMMARY procedure can be specified.
Definition in file aggregation_rules_config.sas.