Degree Works Platinum Analytics Table Access
The following tables are used in the interface with Degree Works for degree audit data. Additional table access is required for the student information system (e.g. Banner).
The Platinum Analytics database user must have read access the following Degree Works tables for Student Educational Planner integration
The Platinum Analytics database user must have read access to the following Degree Works tables for Student Educational Planner integration:
v8.0 Release Changes
Clients will need to generate updated degree audits for import and processing based on a schedule to be arranged with your consultant.
Frequently Asked Questions:
How many times will batch audits need to be generated annually?
Consultants will work with you to determine the exact frequency. At a minimum, the audits will need to be generated at least once for each major term. If your institution is interested in additional analysis results following key milestones on the academic calendar, then the batch audit process could be completed more frequently (but usually no more than 2-3 times per term).
What is the student population for the batch degree audit process?
Platinum Analytics results are generated for an analysis term (eg. Fall). When generating degree audits, students enrolled in the analysis term and the prior term (e.g. Spring) should be included. In other words, the continuing student population as well as any new students who have already registered should be included in the batch audit.
Are there specific settings for the audits that should be used?
The Platinum Analytics import uses the audit type and the batch date to ensure the correct audit is selected for processing. Only audits of type "AA" (Academic Audit) are imported. In addition, in-progress courses and pre-registered courses should be included in the batch audit process. The CPA parameter must also be included on the batch audit. Depending on business practices, audits may need to be frozen for a short period of time while they are imported.
What is the required retention for the audits?
In general, audits should be saved for one week to ensure import processing. If this is not feasible, then an alternate retention schedule can be discussed.
How does Ad Astra access the audit information?
The output itself is not Ad Astra accesses the audit result information from the Degree Works tables (DAP_RESULT_DTL and CPA_CLASSNEEDED). The Degree Works user will need to have its security profile updated to include query access to the tables listed above.
Our institution uses a dynamic versus static bridge for updates from Banner. Are there impacts on the batch audit process?
To ensure that all audit data is current, the institution should update the Degree Works data repository (RAD). Ideally, RAD11 or RAD30 should be updated prior to kicking off the batch degree audit process.
When are the first degree audits needed?
Consultants will work with clients on the exact timing.
For further information or questions, please contact your consultant directly.