Can anyone tell me which main table and field indicates which Grade Center column is set as the External Grade Column?
It's in gradebook_settings.public_item_pk1, that identifies the references to the "external grade."
SELECT [cm].[course_id], [gm].[title]
FROM [dbo].[gradebook_settings] gs (NOLOCK)
JOIN [dbo].[gradebook_main] gm (NOLOCK) ON gm.[pk1] = [gs].[public_item_pk1]
JOIN [dbo].[course_main] cm (NOLOCK) ON cm.[pk1] = [gs].[crsmain_pk1]
This does not seem to work. I need the query to give me the name of the course, and the title of the Grade Center column that is set as the external grade column (i.e. the one with the green check mark).
I tested that query against our system this morning, and verified that the value of the public_item_pk1 changed as I modified the external grade column. I'm not sure if you're using Oracle or SQL Server (I ran this against our SQL Server), or how the query may be different on Oracle.
Chris and Lee -
See my answer over at: Re: External Grade Designation . Chris you may have to ask to join the group to see the link, I am not sure.
Retrieving data ...