SSP v2.0.0 Data Integration Mapping

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 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. 

More notes on data integration strategies here.

All varchar fields listed below are implemented as nvarchar in SQLServer deployments and as character varying in PostgreSQL deployments.

All date fields listed below are implemented as date in both SQLServer and PostreSQL deployments. The application interprets these values in the default JVM timezone, which should typically be configured for institution-local time.

All datetime fields are implemented as datetime in SQLServer deployments and as timestamp without time zone in PostgreSQL. The application interprets these values in UTC by default, but this timezone is configurable in ssp-config.properties.

Mapping Template 

Excel: spreadsheet preview is finally here!

You can now display this file as a spreadsheet, instead of a PDF. Re-upload SIS Data Mappings v2.0.0.xlsx to display the new preview. You can access the file here.