The table REPORTMART_CONFIG contains details for storing data to the Report Mart. More...
Go to the source code of this file.
The table REPORTMART_CONFIG contains details for storing data to the Report Mart.
PK | Variable | Type | Required? | Label | Description |
---|---|---|---|---|---|
![]() | REPORTMART_GROUP_ID | VARCHAR(32) | Y | Reportmart Group Identifier | Reportmart Group Identifier |
![]() | SCHEMA_NAME | VARCHAR(100) | Y | Schema Name | Schema Name |
![]() | SCHEMA_VERSION | VARCHAR(50) | Y | Schema Version | Schema Version |
WHERE_CLAUSE | VARCHAR(10000) | Where Clause | Optional where condition applied when extracting the data from the Analysis Data Repository | ||
CUSTOM_CODE | VARCHAR(10000) | Custom Code | Optional custom code applied when extracting the data from the Analysis Data Repository. This code is executed within a data step. | ||
RLS_TABLE_NAME | VARCHAR(100) | Y | Row-Level Security Table Name | Name of the table that controls row-level security | |
![]() | MART_TABLE_NAME | VARCHAR(100) | Y | Mart Table Name | Name of the target Report Mart table |
AGGREGATION_FLG | VARCHAR(1) | N | Aggregation Flag | Flag (Y/N). Controls whether reportmart data should be aggregated | |
AGGREGATION_FILTER | VARCHAR(32000) | N | Aggregation Filter | Optional condition used to control which records should be aggregated |
See irmc_node_load_reportmart.sas for details.
Definition in file reportmart_config.sas.