Link to FAQ in SGHE Customer Support Center

To address a FAQ issue similar to the absence of direct RPE links in the SunGard HE Customer Support Center described in a previous post, hopefully the utility below will give users a way to share FAQ's more quickly and effectively.

FAQ #:
URL:

Link to RPE in SGHE Customer Support Center

Getting to RPE's in the SunGard HE Customer Support Center seems to be a bit of a chore, and there isn't an intuitive way to grab a URL that can be shared with colleagues or the SGHE community. Hopefully this post will give users a way to share URL's conveniently and get to the content faster.

RPE #:
URL:

Putting a Name with a User ID in DegreeWorks

I came across a question once about what users all exist in DegreeWorks. I couldn't figure out the issue at first, so I created an SR with the AL and got some pointers that ultimately led me to the following query:

select shp_access_id, rad_name
from shp_user_mst, rad_primary_mst
where shp_access_id=rad_id
order by shp_access_id;

This query showed me the names associated with each of the logins to DegreeWorks.

On a side note: The DegreeWorks schema is not documented in any of the PDF publications. Instead, the schema is explained in files that are created during the server installation inside the .../app/schema/ directory:

• dapdb
• raddb
• shpdb