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 are implemented as nvarchar in SQLServer deployments and as character varying in PostgresSQL deployments.
Mapping Template