ADP Summer 2013 Updates
New TxxxEXTRACTS Data
These tables will need to be populated in order for the Unusual Action Code display and the Registration Hold features to be available.
- UNUSUAL_ACTN_D
- UNUSUAL_CD_M
- PUN_ACTN_M
New ADP Database Tables
- HoldControl
- UnusualActionControl
- WorkAttendControl
- RestrictedNote
- RestrictedNotesAdminRole
- RestrictedNotesRole
Hold Display Feature
Holds are displayed above the Basic Student Information section. No screen space is used if no holds are in effect. Holds will not be displayed until the feature is configured by editing the appropriate database table.
Configuring the Hold Display Feature
The database setup scripts will populate the ADP HoldControl table with default values. All holds are initially set to hidden. The table below shows the Registration Hold set to be visible. Only the ADPHoldResolution and DisplayThisHold fields should be edited. The other values must be unchanged as the ADP code depends on them.
Work Attend Code Display
Selected Work Attend codes will appear below the Basic Student Information area. This feature is activated by putting data into the ADP WorkAttendControl table. The WorkAttndCode, Label, and Description fields will all need to be configured. The table below is provided for reference only. The work attend code is pulled from the student’s STU-D record (specifically the STU_D_BIO.STU_WORK_ATTND field.)
Unusual Action Code Display
Selected unusual action codes will be displayed below the Basic Student Information area. Codes are only displayed if they are configured in the ADP UnusualActionControl table. The UACode, Label, and Instructions fields must be populated. See the example table below.
Restricted Notes Feature
The restricted notes feature is very similar to the Advisor Notes feature in terms of how notes are added and displayed. The main difference is that only users who are explicitly added to a security role in ADP will be able to add and view the restricted notes for a student. There is an admin role specific to this feature that allows for deleting specific notes from any student. The actual notes are stored in the RestrictedNote table in the ADP database.
Granting add/view rights
Users are granted add/view access to the feature by adding their userID (SID) to the RestrictedNotesRole table in the ADP database.
Granting admin rights
Add the user’s userID (SID) to the RestrictedNotesAdminRole table in the ADP database.
Batch Degree Audit Feature
In this version the batch degree audit feature was changed substantially. The ADP code base is no longer responsible for parsing and storing the output of the SBCTC Batch Degree Audit jobs. There is a separate application based on a database backend and a .NET command line application to allow scripted processing of the batch audits. There are three main enhancements to the meta data extracted from the individual batch audits. More specific details will be packaged with the audit processing application. ADP is now just configured to point at the database where the parsed data is accumulated rather than feeding the reports into the ADP web interface.
- AuditTimestamp: the timestamp is extracted and converted to a SQL datetime format.
- ProgramCode: If a convention for modifying the audit template’s title is followed the new parser is able to extract the program code (EPC) and store that value in a field allowing audits against different degrees to be stored and indexed.
- UnusedCourses: The unused courses section of the audit is now parsed and most if not all of the data course elements are stored for potential querying.
Once parsed data is available you can cause ADP to consume the data by