The table DATA_MAP_CONFIG is a generic mapper used to rename/map or compute new columns. More...
Go to the source code of this file.
The table DATA_MAP_CONFIG is a generic mapper used to rename/map or compute new columns.
PK | Variable | Type | Not Null * | Label | Description |
---|---|---|---|---|---|
WORKGROUP | VARCHAR(32) | Y | Risk Workgroup | Risk Workgroup | |
MODELING_SYSTEM | VARCHAR(150) | Y | Modeling System (Name and Version) | Expected format: <Modeling System Name> [(<Version>)]. | |
MAP_TYPE | VARCHAR(100) | Y | Map Type | Indicates which target table the mapping refers to. Expected values: - PRE_STAGE_ALLOC: Mapping performed before stage allocation. - POST_STAGE_ALLOC: Mapping performed after stage allocation. - DETAIL_DATA: Mapping to detail data structure. - RPTMART_DETAIL: Mapping to the report mart detail data structure. - RPTMART_MOVEMENTS: Mapping to the report mart movements (waterfall) data structure. | |
TARGET_VAR_NAME | VARCHAR(32) | N | Target Variable Name | Name of the target variable. | |
EXPRESSION_TXT | VARCHAR(4096) | N | Expression text | Expression. Can be any of the following: - <Variable Name>: it will result in the variable being renamed. - =<assignment> (i.e.: = Var1 + Var2): any valid SAS statement. - <Blank>: This record will be ignored. | |
MAPPING_DESC | VARCHAR(1024) | N | Mapping Description | (Optional) Description about the purpose of the mapping rule. | |
TARGET_VAR_LENGTH | VARCHAR(32) | N | Target Variable Length | (Optional) Set the length of the target variable (i.e.: $32. for characters or 8. for numeric variables). | |
TARGET_VAR_LABEL | VARCHAR(150) | N | Target Variable Label | (Optional) Set the label for the target variable (Do not include quotes!). | |
TARGET_VAR_FMT | VARCHAR(32) | N | Target Variable Format | (Optional) Set the format of the target variable. |
(*) indicates a not-nullable variable.
Definition in file data_map_config.sas.