Versions Compared

Key

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

The Excel spreadsheet is a template to map data required for SSP and optionally displayed throughout SSP.  The template can be used to map database columns to SSP fields. 

Download the  the template

View Usage

SSP uses the view names defined below, prefixed with "v_".  These views can select data from any underlying datasource.  The below examples show corresponding database tables, found in the external database schema, that the SSP views utilize by default.  For those institutions that wish to utilize a linked server setup, simply modify the view selection query to select from real-time data, a data-warehouse, etc.  Note that when using the views linked to sources that are not the local tables performance times for the SSP application and the corresponding API may be negatively affected. 

...

Excel
nameSIS Data Mappings v2.6.1.xlsx