What table stores 'division' details?
Summary
What table stores all the effective dated rows for 'Divisions' which is part of 'workforce structures'?Content
I added 15 effective dated rows for a certain division using HDL. 'Organization ID' field in my HDL file was blank. As seen the 'name' field will vary. Which table stores all these 15 rows in backend? I queried 'Worker Assignment Event Real Time' subject area and filtered on 'org classification' and 'org name'. It only displays one row which is latest effective row. I also queried HR_ALL_ORGANIZATION_UNITS_F table but could not find 'name' field. This table uses 'organization ID' as key field which is numeric. Which table can show me all the 15 rows so that i can validate my HDL