Versions Compared

Old Version 9

changes.mady.by.user Jason Elwood

Saved on

compared with

New Version 10

changes.mady.by.user Jason Elwood

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Install SettingsGeneral SettingsCounseling Reference Guide (CRG)Journal Track-Step-Detail
Section 1Section 2WorksheetWorksheet
  • Student ID Alias
  • Coach Label
  • Retrieve External Data
  • Coach Query
  • Coach Set from External Data
  • Coach Unset from External Data
  • Student Type Set from External Data
  • Student Type Unset from External Data
  • External Sync Schedule (multiple)
  • Send Mail
  • Test Mail Server Port
  • BCC Email Address
  • Manage Integration Database
  • Status Code Mapping
  • Highly Trust IPs
  • Client Side Timeout
  • Student Types
  • Special Service Groups
  • Reasons for Service
  • Referral Sources
  • Program Status Change Reasons
  • Confidentiality Levels
  • Financial Aid Files
  • Financial Aid SAP Status Codes
  • The CRG will take time to collect and organize.  The worksheet should be distributed darly and often in order to complete.
  • The Journal associations will take time to collect and organize.  The worksheet should be distributed darly and often in order to complete.

...

Block 2 - Main Tool Phase 1

External DB Tables

external_registration_status_by_termDescription
PurposeHolds registration status for each student by term. Used in SSP reporting capabilities.  Used in the Main Tool Details Tab
Considerations
  • The student search uses data in this table.  For each term with a course count greater than zero
external_student_academic_programDescription
PurposeDefines each student's current academic program(s) of study.  Used in the Main Tool Dashboard Tab
Considerations
  • Students may have multiple rows, one for each declared program
  • The academic programs are display only and not connected to MAP
external_student_transcriptDescription
PurposeHolds current, cumulative student transcript summary information.  Used in the Main Tool Dashboard Tab. Note that SSP will never attempt to calculate a GPA.
Considerations
  • It is important to ensure that totals in the transcript table match a sum of the external_student_transcript_term table (described below)
  • The corresponding fields in the user interface appear whether or not data exists. 
external_student_transcript_termDescription
PurposeHolds term by term student transcript summary information.  Used in the Main Tool Dashboard Tab. Note that SSP will never attempt to calculate a GPA.
Considerations
  • Data for each term can be cumulative or term specific only.  Implementers can choose either meaning for the data when populating the table, specifically GPA
  • Implementers most commonly load current and registered terms

SSP Configuration Guide

  1. Begin Continue collecting referrals items for the Counseling Reference Guide
  2. Continue collecting items for the Journal Track-Step-Detail associations

...

Block 3 - Main Tool Phase 2

...

  1. General Settings (FinAid)
    • Financial Aid Files
    • Financial Aid SAP Status Codes

External DB Tables

external_student_testDescription
PurposeHolds student test score data.  Used in the Main Tool Placement Tab
Considerations
  • Any test data can be stored in the table along with the outcome
  • An integration to Smarter Measures test reports can be configured
external_student_transcript_courseDescription
PurposeContains section- or course-scoped student transcript records. Used in the Main Tool Transcript Tab. Each row represents a collection of course completion metrics (grade, credits earned, etc) for a particular student at at least course granularity (course code + term code). Additional values can be specified to scope a given entry to a particular section, but this may not be possible in all cases, e.g. transcript entries sourced from other institutions.
Considerations
  • Most implementers load current and future term registrations
  • Each row in the database should have a grade.  This is most important for the MAP plan status calculation process.  Planned courses will be evaluated by grade to determine the plan status based on a list of passing grades.  Null grades will not be considered during the calculation
  • credit_type = Transfer is the only significant value.  All rows with 'Transfer' as the value will be displayed as a total hours calculation on the Details tab
  • course_code is an optioned field for each row but must be populated from day 1 if the course_code matching criteria will be used in the plan status calculation
external_student_financial_aidDescription
PurposeHolds student financial aid information.  Used in Main Tool Details Tab
Considerations
  • The SAP Status Codes are defined in the configuration and matched with rows in the table to show the students current status along with the description configured.
  • gpa_20_b_hrs_needed/gpa_20_a_hrs_needed: the original intent is to give students an indication of what they would have to accomplish to achieve an A or B GPA .  A & B level will vary for each school.  Traditionally, they would indicate a GPA representing an A (4.0) or B (3.0) using a standard calculation of earned/attempted.
  • financial_aid_file_status is an overall status of all files in the external_student_financial_aid_file table
external_financial_aid_award_termDescription
PurposeHolds student financial aid information to describe the term by term acceptance of financial aid.  Each term financial aid was offered to a student should be included along with the acceptance status for each term.  Used in Main Tool Details Tab
Considerations
  • SSP will display the rows in the table.  Most commonly implementers load the table for each term a student is offered financial aid along with the acceptance for that term.
external_student_financial_aid_fileDescription
PurposeHolds student financial aid information related to the files required in the students application.  Each of the required files should be associated to a row for each student.  Each row should have an appropriate status code to describe the status of each file.  Used in Main Tool Details Tab and MAP
Considerations
  • Most commonly implementers configured each required file to apply for and receive financial aid.  Each file has an individual status that is displayed in list form.

...

Block 4 - Student Intake

SSP Configuration Guide

...