In many tables I noticed there is a DCID and also an ID column. In most cases the values are identical. Could someone tell me what the difference is between these two columns?
@mmarx The ID is the field's actual ID number. It is a unique identifier for the field. The DCID is the ID to use in certain cases when joining tables or extended tables. It is used for associations with other records. That's the short answer anyway!
@lthorne Are you sure about that? You are saying when I'm joining the teachers table to the cc table I use "cc.teacherid = teachers.dcid" in the condition, and not "cc.teacherid = teachers.id"?
I see some tables use the teacherid as a key, others uses the teacherdcid as a key. Wouldn't I join it to whatever is used?
@mmarx That is why I said "in some cases" - and that it was the short answer! I do not personally know of the reason why we sometimes join on ID and sometimes on DCID, but if you are looking for specific information about specific tables for joins with sql, a great resource is the PSUG listserv where you can get real time answers from PowerSchool users who are very skilled in sql specifically. I read your question as more in general, as to why is there an ID and a DCID.
@mmarx Go to groups.io and search for PSUG. Are also familiar with the Data Dictionary? It will list every field and corresponding ID/DCID. You can easily locate it in your PowerSchool instance by going to the top right corner and clicking the Help ? icon. Likewise searching in Community for Data Dictionary will bring up related information to the data dictionary most relevant to your PowerSchool version.
Draft of Post:
Thank you for reaching out to the Community!
The Student table provides the DCID. Please refer to this document: students-1 to know more.