2.4.6.1.2.1 Hierarchy Data Load

Following fields are mandatory and must be sourced.

Table 2-5 Generic Dimension attribute description

Business Term Comments
As Of Date The data must be valid.
Hierarchy Code Each hierarchy code for a specific As Of date must have one root node.
Effective Date Refers to the effective date of the account or contract or interest rate or exchange rate from which it is effective. In the case of hierarchy dimension entities, it refers to the effective date of the hierarchy code, and while sourcing data, users need to provide a snapshot of the latest hierarchy code with the same effective date. The data must be valid.
Child Code Child Code should be available in corresponding Master Table and should be unique.
Parent Code Parent Code should be available in corresponding Master Table.
Name The data must be valid.
Description The data must be valid.