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
...
More notes on data integration strategies here.
All varchar fields listed below are implemented as nvarchar in SQLServer deployments and as character varying in PostgresSQL deployments 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 | ||
|---|---|---|
|
...