Canvas Data 2.0 Accounts

[a1222679]

Problem statement:

Canvas Data 1.0 had a fields which indicated which school and faculty a course belonged to (ACCOUNT_DIM.SUBACCOUNT3 and ACCOUNT_DIM.SUBACCOUNT2). From what I can see in the Accounts table of Canvas Data 2.0 there's only the parent account (i.e. one level up - school) and no faculty data.

Proposed solution:

Could the faculty information be added? Or, if it's already there, where is it?

User role(s):

admin

[a1222679]

Ignore above I've cracked the code.  You just need to string multiple account tables together joining COURSE.ACCOUNT.ID to ACCOUNT.ACCOUNT.ID to get the school level data and then join another account table to the first one on ACCOUNT.PARENT_ACCOUNT_ID and ACCOUNT.ID to get the faculty.

[KristinL]

Thank you @a1222679 for sharing a solution!