Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

Below is a recommended approach to dividing the configuration and corresponding external data into blocks of effort.  Based on the SSP tools to be implemented, the corresponding block(s) of effort can be scheduled into the project timeline.  The main goal of the block approach is to divide the effort into measurable segments of work that can be analyzed, executed and tested independently from other SSP tools.

Block 1 - Base SSP Configuration

External DB Tables

external_personDescription
PurposeHolds attributes for any user accessing or referenced by SSP. For example, supports search results, early alerting and student creation. Records in this table are periodically synchronized into the "person" table and several of its supporting tables. Both school_id and username must be unique identifiers for each record. I.e. any given school_id or username can occur at most once.
Considerations
  • All users who will sign into SSP or MyGPS should have a row in the table including;
    • All students that may be added to SSP
    • All coaches (counselors, faculty members, advisors, etc) that may be assigned as a coach for a student
    • All faculty members who may have an Early Alert rosters
  • Only students should have a coach_school_id and student_type_code
  • Commonly implementers add students to external data that are "system active" so that they are available to SSP.  The litmus test would be: "Could the student walk off the street and register for courses?"
  • The username must match the username that a user will use to log into SSP
Sync'd Fields 
external_termDescription
Purpose 
Consideration 

 

SSP Configuration Guide

  1. Install Settings
  2. General Settings
  3. Begin collecting referrals for counseling reference guide
  4. Begin collecting Journal track-step-detail

uPortal Roles and Permission

  1. Role Assignments
  2. Tool Permissions

Block 2 - Main Tool Phase 1

External DB Tables

  1. external_registration_status_by_term
  2. external_student_academic_program
  3. external_student_transcript
  4. external_student_transcript_term

SSP Configuration Guide

  1. Begin collecting referrals for Counseling Reference Guide

Block 3 - Main Tool Phase 2

SSP Configuration Guide

  1. General Settings (FinAid)

External DB Tables

  1. external_student_test
  2. external_student_transcript_course
  3. external_student_financial_aid
  4. external_financial_aid_award_term
  5. external_student_financial_aid_file

Block 4 - Student Intake

SSP Configuration Guide

  1. Student Intake Settings
  2. Student Intake Message Template
  3. Intake Field Labels

Block 5 - Early Alert

External DB Tables

  1. external_faculty_course_roster
  2. external_faculty_course

SSP Configuration Guide

  1. Early Alert Settings
  2. Early Alert Message Templates

Block 6 - Journal

SSP Configuration Guide

  1. Journal Settings

Block 7 - Counseling Reference Guide and Action Plan

SSP Configuration Guide

  1. Action Plan Settings
  2. MyGPS
  3. Action Plan Message Templates

Block 8 - Map Phase 1

External DB Tables

  1. external_course
  2. external_division
  3. external_department
  4. external_program

SSP Configuration Guide

  1. MAP message templates
  2. MAP Settings
  3. MAP Plan Status Calculation

Block 9 - Map Phase 2

External DB Tables

  1. external_course_term
  2. external_course_program
  3. external_course_tag
  4. external_course_requisite
  5. external_substitutable_courses
  6. external_person_planning_status (optional)

SSP Configuration Guide

  1. MAP Settings

Block 10 - Notes and Accommodation

External DB Tables

  1. external_person_note

SSP Configuration Guide

  1. Accommodation Settings

 
 
 

  • No labels