User Defined Attributes (UDA) Mapping
The user-defined attributes label data is loaded from the ATTR.csv file or from RMFCS. This table is only
for the attribute group and value labels and hierarchy. UDA type code refers to 3 types (LV, FF, or DT) which is a list of values, free-form text, or date attribute type. Different implementations may
require different subsets of UDAs from their source system.
| Measure | Target Table | Target Column | Data Source |
|---|---|---|---|
|
UDA Type |
W_PDS_UDA_D |
UDA_TYPE_CODE |
W_RTL_PRODUCT_ATTR_D.PROD_ATTR_TYPE |
|
UDA Group ID |
W_PDS_UDA_D |
UDA_ID |
W_RTL_PRODUCT_ATTR_D.PROD_ATTR_GROUP_ID |
|
UDA Group Desc |
W_PDS_UDA_D |
UDA_DESC |
W_DOMAIN_MEMBER_LKP_TL.DOMAIN_MEMBER_NAME |
|
UDA Value ID |
W_PDS_UDA_D |
UDA_VALUE |
W_RTL_PRODUCT_ATTR_D.PROD_ATTR_ID |
|
UDA Value Desc |
W_PDS_UDA_D |
UDA_VALUE_DESC |
W_DOMAIN_MEMBER_LKP_TL.DOMAIN_MEMBER_NAME |