For more information, please refer to this announcement explaining best practices for getting answers to questions.
Seeking documentation to code for HR Org hierarchy
Summary:
Hello All,
I see that Fusion utilizes the following tables to manage HR organizations and their hierarchies:
- HR_ALL_ORGANIZATION_UNITS_F (internal CDEE_FSCM_ORG_UNIT),
- PER_ORG_TREE_NODE_CF (internal CDEE_PER_ORG_TREE_NODE_CF),
- PER_ORG_TREE_NODE_RF (internal CDEE_PER_ORG_TREE_NODE_RF),
- PER_ORG_TREE_NODE (internal CDEE_HCM_PER_ORG_TREE_STRUCTURE),
- HR_ORG_CLASSIFICATIONS (internal CDEE_FSCM_ORGANIZATION), and
- HR_ORGANIZATION_INFORMATION_F.
I have reviewed table and column descriptions in the online TRM. Unfortunately, that documentation is very lean and lacks details. For example, table PER_ORG_TREE_NODE_CF has the same description for all of the DEP0_PK#_VALUE columns. In addition, there is no explanation of DEP0 vs DEP1 vs DEP2, etc.