BusinessObjects users are able to leverage employee organization attributes across multiple information systems to facilitate the grouping of information for various reporting needs. Because of this functionality, it can be challenging to select the appropriate attributes, and to troubleshoot when a report does not return expected results. Use this page to understand where various attributes come from, and how they’re connected.
Supervisory Organization
Supervisory Organizations group positions into a hierarchy indicating a position’s peers, subordinates, and chain of command. In Workday, each position is assigned to a supervisory organization, which contains the following attributes. In BusinessObjects, these attributes can be found in the Organization Attributes folder.
- Organization ID – unique identifier in Workday for each supervisory organization (e.g. 02999999_M11111)
- Organization Description – matches the supervisory organization description you would see displayed in Workday (e.g. 02999999 Chemistry (Jane Doe))
- Organization Code – an 8-digit number in the Details section of the Workday supervisory organization record, corresponding to the adloc table in FAMIS. Generally, this matches the 8-digit number displayed in the organization description, but the two can differ
- Superior Organization – the supervisory organization in Workday to which this supervisory organization reports. It is the next level up in the hierarchy of supervisory organizations. When you review the Team Org Chart in Workday, you are navigating this hierarchy. In BusinessObjects, attributes of the superior organization are located in Organization Attributes > Superior Organization
Adloc
Adlocs are a broader grouping of positions, allowing you to group positions that don’t necessarily report to the same manager. A table with one record per adloc is maintained in FAMIS screen 722, with the following attributes. In BusinessObjects, these attributes can be found in the Organization Attributes > Adloc folder.
- Adloc – an 8-digit number serving as the unique identifier per adloc, and used to lookup adloc information for a given supervisory organization from Workday
- Adloc Name – the description for each adloc record
- Sub-Department and Department – codes indicating the broader sub-department and department to which the adloc belongs. This corresponds to the FAMIS Organization table
FAMIS Organization
FAMIS Organizations represent a 5-part hierarchy that can be used to broadly group positions, as well as financial information. A table with one record per member, per sub-department is maintained in FAMIS screen 860, with the following attributes. In BusinessObjects, these attributes can be found in the Organization Attributes > Adloc > Adloc Org folder.
- Sub-Department – a code grouping related adlocs into one unit for reporting. One department can have many sub-departments, and one sub-department can be used to group related adlocs across multiple departments
- Department – a code grouping sub-departments into one overall department
- Department head – the UIN of the person identified to be the department head, generally for the purpose of routing and approvals within FAMIS
- Division and College – 2-character codes grouping related departments together. Generally, you will either see a division or a college used to group departments, but it is possible to see both types of groupings for one member. In BusinessObjects, you will see “division/college” attributes that combine the two into one column for reporting
- Executive – 2-character code grouping related divisions or colleges together
- Member – 2-digit number representing the A&M System member to which the organization belongs
Employee Location
Employee Location information is popular for use in directories, because it allows managers to be listed in the same organization as their subordinates, rather than the organization to which they report. For each employee in Workday, a calculation determines an 8-digit adloc representing the employee location code. With some exceptions, the employee location code represents the adloc of a manager’s greatest number of subordinates (excluding non-employee benefits only positions, and being sure not to cross member IDs). For non-managers, it is the same as their adloc.
Because the outcome of this calculation is an adloc, not a supervisory organization, the description for an employee location code comes from the adloc table mentioned above. And because the calculation is made using all of a worker’s subordinates, regardless of whether he or she has multiple positions, there is one employee location code per worker, not per position.
In BusinessObjects, the attributes can be found in the Worker Current Attributes > Worker Location Adloc folder.