November 2024

New

• Support for combining arrays from Slate. Allows syncing multiple source tables in Slate to one PowerCampus destination table.
• Support multiple Teams webhooks for error notifications

Changed

• Bring back compatibility with pre-9.2.1 PowerCampus versions
• Scheduled Actions improvements
  • Option to mark Waived actions completed
  • Custom Waived Reason
  • Error checking
  • Fix auto-delete bug that affected actions with names >50 characters
• Make GOVERNMENT_ID/SSN errors non-fatal
• Fix PROGRAM_START_DATE: Respect @SetProgramStartDate flag whether or not @Matriculated is true

May 2024

New

• PowerCampus 9.2.3 compatibility updates
  • Use new ACADEMIC GUID instead of custom key
  • API Bearer auth support
  • Other API updates
• Ability to use multiple POE's with PowerFAIDS via FINAIDMAPPING
• More implementation tools
• Default LegalName field
• Sync COLLEGE field
• Sync PROGRAM_START_DATE field

Changed

• PowerCampus-AcademicKey no longer required for auto-updating PDC
• Remove SQL logging feature
• Improved error messages

February 2024

New

• Sync Scholarships
• Sync Associations
• Sync Religion field
• Return student SSO ID to Slate
• Option to bind HTTP server to specific IP address
• Option to accept blank COLLEGE_ATTEND as valid
• Office365 OAuth Support for error emails
• Microsoft Teams support for error notifications

Changed

• Bugfix: Use correct default ENROLL_SEPARATION code
• Replace record_found flag with error_flag (less confusing)
• Improved deployment tools
• Updated sample Slate objects and documentation

June 2022

New

• Award data from PowerFAIDS can be displayed in Slate (for simplicity, awards are extracted from PF as XML and cannot be queried in Slate)
• Automatic updating of Program/Degree/Curriculum in PowerCampus to reduce sync errors. Requires PowerCampus-AcademicKey installed.
• Automatic mapping of AcademicLevel and AcademicTerm in recruiterMapping.xml

Changed

• Bugfix: Don't update ACADEMIC_FLAG if AppStatus and AppDecision are NULL
• Show error in HTTP sync when app has error flag
• Restructured config file

March 2022

New

• Send Advisor from ACADEMIC record back to Slate
• Insert Stops into PowerCampus from Slate
• Added five new fields like custom_1, custom_2, etc. that can be configured to upload arbitrary data back to Slate.
• Workaround for CR-000182917, where the campus passed to the API isn't written to ACADEMIC.

Changed

• Ability to set NONTRAD_PROGRAM back to NULL. Formerly, clearing a value in Slate did not clear it in PowerCampus.
• Campus Email Type is now a configuration option instead of hardcoded in SQL.
• Fix #49, ENROLL_SEPARATION is sometimes blank or null with accept decision.
• Fix potentially uncommitted transaction bug.
• HTTP server will retry all errors instead of just SQL connection errors.
• Instead of sending a single flag whenever a school org is NOT found in PowerCampus, return a positive org_found status of True or False for each record. The problem with the former approach was that corrected records were not automatically marked as resolved in Slate.
• Updated documentation and Slate briefcase examples
• Other small bugfixes and quality improvements

June 2021

New

• Sync Education records*
• Sync Test Scores.* Only numeric scores supported (not alpha).
• Delete orphaned scheduled actions that no longer exist in Slate's checklist.
• Auto-configure new program mappings in recruiterApplication.xml and ProgramOfStudy table. This was a major source of difficulty.

*Utilizes new nested JSON export functionality in Slate's Configurable Joins. See PowerSlate Integration Fields.docx for additional details.

Changed

• Fixed datatype comparison bug when detecting changed fields to upload back to Slate
• Fixed bug that caused crash when SSN duplicate check found two or more duplicates
• Fixed missing dependency in scheduled actions SQL routine
• Updated Slate briefcase examples

April 2021

New

• Support for Matric field group:
  • MATRIC field passed from Slate.
  • MATRIC_YEAR, MATRIC_TERM, MATRIC_SESSION set to match application YTS.
  • MATRIC_DATE set to first day of term from ACADEMICCALENDAR.
• Support for Admit field group
  • ADMIT_DATE field passed from Slate.
  • ADMIT_YEAR, ADMIT_TERM, ADMIT_SESSION set to match application YTS.
• Other fields added:
  • DEMOGRAPHICS.PRIMARY_LANGUAGE
  • DEMOGRAPHICS.HOME_LANGUAGE
  • ACADEMIC.COUNSELOR
• HTTP sync automatically recovers broken SQL connections
• Tie RecruiterApplication row to AcademicKey unique ID. Allows comparing Application tables to Academic. See https://github.com/WyattBest/PowerCampus-AcademicKey

Changed

• Government ID field (SSN) synced on an ongoing basis with duplicate checking
• Refactored module pscore (about 1k lines) into four modules (ps_core, ps_format, ps_powercampus, ps_models)
• Improved error emails
• Fix potential bugs with multiple applications in same YTS being updated indiscriminately
• Fix SSN datatype error when querying a PowerFAIDS database with illegal characters in SSN
• Improved SQL helper script that auto-generates XML for AcademicProgram mapping

March 2021

New

• Diagram of data flow between systems
• More fields passed to PowerCampus:
  • DEMOGRAPHICS.ETHNICITY
  • ACADEMIC.APP_STATUS_DATE
  • ACADEMIC.APP_DECISION_DATE
  • ACADEMIC.DEPARTMENT
  • ACADEMIC.COLLEGE_ATTEND
  • ACADEMIC.POPULATION
  • ACADEMIC.EXTRA_CURRICULAR
  • User Defined fields (configurable)
  • Notes (configurable)
• SQL script to create RecruiterApplication and Application rows without posting to API (to backfill old applications)
• SQL scripts to auto-generate portions of recruiterMapping.xml
• SQL script to copy ProgramOfStudy between test and prod databases
• HTTP listening port is configurable
• Additional configurable strings and error messages
• More detailed console output while syncing

Changed

• Python 3.9 required (for new dictionary merge operator)
• Don't update AppStatus or AppDecision unless both codes are present
• Improved error handling in many areas
• Performance improvements
• Split PowerCampus upload into two configurable feeds - one for "active" fields that should trigger Slate rules and another for "passive" fields
• Work around bugs in PowerCampus Web API's Veteran field
• Updated sample queries and source formats

November 2020

New

• Slate's Financial Aid Checklist feature is populated from PowerFAIDS student_required_documents table.

Changed

• Fix: Send Ref instead of AppID to log table
• Fix: US prefix correctly removed from phone numbers

October 2020

All the original code has been refactored or rewritten, and code shared between modules has been moved into pscore module. Instead of storing applications lists in three formats (Slate, API, and SQL) and cross-referencing among them, a single list is kept in Slate format and translated on-demand. Functions are decoupled so as to be stateless (except for the global config file and network connections). All this should make new feature development much easier.

New:

• PowerCampus PREREG_VAL_DATE/REG_VAL_DATE passed back to Slate.
• PowerCampus ENROLL_SEPARATION passed back to Slate.
• School email address passed back to Slate.
• Record Found flag passed back to Slate for error handling.
• Slate's Application Submission Date is written to PowerCampus's APPLICATION_DATE.
• Arbitrary number of addresses and phone numbers can be sent from Slate.
• Default phone country code setting.
• Default phone type setting.
• New sample Slate queries and Windows Task Scheduler definitions included.

Changed:

• All fields are updated during initial sync if application is processed automatically through Handle Applications. Formerly, some fields were only updated on subsequent syncs.
• PowerSlate Integration Fields.docx updated.
• Registered Credits field sent to Slate is no longer used as an error flag.