SLI - Revision history

Kia: /* When will a record be deleted from SLI table */

2023-01-11T21:27:17Z

When will a record be deleted from SLI table

← Older revision		Revision as of 21:27, 11 January 2023
Line 52:		Line 52:

	==== When will a record be deleted from SLI table ====		==== When will a record be deleted from SLI table ====
	When all ~~Usernames for a user has been deleted~~ the record will be deleted ~~in the SLI table~~		The functionality "Delete inactive XXXX" works like this:

			When the date for "Keep record for" + [SLI].[WhenDisabledEmployee] is occurs [SLI].[SLI_ID_Employee] vil be set to null.

			When the date for "Keep record for" + [SLI].[WhenDisabledStudent] is occurs [SLI].[SLI_ID_Student] vil be set to null.

			When the date for "Keep record for" + [SLI].[WhenDisabledParent] is occurs [SLI].[SLI_ID_Parent] vil be set to null.

			When [SLI].[SLI_ID_Employee], [SLI].[SLI_ID_Student] and [SLI].[SLI_ID_Parent] all are NULL the record/row will be deleted from UMS.

Kia: /* Installation */

2022-12-08T12:55:30Z

Installation

← Older revision		Revision as of 12:55, 8 December 2022
Line 17:		Line 17:
	The SLI Setup window:		The SLI Setup window:

	==== ~~'''~~Use SLI~~'''~~ ====		==== Use SLI ====
	Activate Single Login Identification. This only maintains a SLI table and not UMS.		Activate Single Login Identification. This only maintains a SLI table and not UMS.

	==== ~~'''~~Maintain UMS~~'''~~ ====		==== Maintain UMS ====
	Check this option to maintain UMS with the SLI.		Check this option to maintain UMS with the SLI.

	==== ~~'''~~Create new username for employees~~'''~~ ====		==== Create new username for employees ====
	Gives employees new user name if changed in administrative system.		Gives employees new user name if changed in administrative system.

	===~~'''~~Advanced SLI Settings~~'''~~===		===Advanced SLI Settings===

	==== ~~'''~~Delete inactive students~~'''~~ ====		==== Delete inactive students ====
	Deletes SLI Username when students no longer in UMS.		Deletes SLI Username when students no longer in UMS.

	==== ~~'''~~Delete inactive employee~~'''~~ ====		==== Delete inactive employee ====
	Deletes SLI Username when employee no longer in UMS.		Deletes SLI Username when employee no longer in UMS.

	==== ~~'''~~Delete inactive parents~~'''~~ ====		==== Delete inactive parents ====
	Deletes SLI Username when parent no longer in UMS.		Deletes SLI Username when parent no longer in UMS.

Line 40:		Line 40:
	Keep the Username in the SLI table for x number of days after it is no longer in the data source.		Keep the Username in the SLI table for x number of days after it is no longer in the data source.

	==== ~~'''~~Create separate accounts~~'''~~ ====		==== Create separate accounts ====
	Check this option to give employee a new user name if the employee becomes a student. Unless UNI-Login is used.		Check this option to give employee a new user name if the employee becomes a student. Unless UNI-Login is used.

	==== ~~'''~~Create new username for employees~~'''~~ ====		==== Create new username for employees ====
	Gives employees new user name if changed in administrative system.		Gives employees new user name if changed in administrative system.

	==== ~~'''~~Create new SLI~~'''~~ ====		==== Create new SLI ====
	Check this to give all users a new SLI. CAUTION: This can have critical impact if the SLI table has been edited manually.		Check this to give all users a new SLI. CAUTION: This can have critical impact if the SLI table has been edited manually.

Kia: /* Installation */

2022-11-30T10:49:46Z

Installation

← Older revision		Revision as of 10:49, 30 November 2022
Line 28:		Line 28:
	==='''Advanced SLI Settings'''===		==='''Advanced SLI Settings'''===

	==== '''~~Create new~~ SLI''' ====		==== '''Delete inactive students''' ====
	~~Check this to give all users a new~~ SLI. ~~CAUTION: This can have critical impact if~~ the SLI table ~~has been edited manually~~.		Deletes SLI Username when students no longer in UMS.

			==== '''Delete inactive employee''' ====
			Deletes SLI Username when employee no longer in UMS.

			==== '''Delete inactive parents''' ====
			Deletes SLI Username when parent no longer in UMS.

			==== Keep record for ====
			Keep the Username in the SLI table for x number of days after it is no longer in the data source.

	==== '''Create separate accounts''' ====		==== '''Create separate accounts''' ====
Line 37:		Line 46:
	Gives employees new user name if changed in administrative system.		Gives employees new user name if changed in administrative system.

	==== '''~~Delete inactive students~~''' ====		==== '''Create new SLI''' ====
	~~Deletes~~ SLI ~~info when students no longer in UMS~~.		Check this to give all users a new SLI. CAUTION: This can have critical impact if the SLI table has been edited manually.

	==~~== '''Delete inactive employee''' ====~~		==FAQ==
	~~Deletes SLI info when employee no longer in UMS.~~

	~~==== '''Delete inactive parents''' ====~~
	~~Deletes SLI info when parent no longer in UMS.~~

	~~==Technical settings~~==

	==~~FAQ~~==		==== When will a record be deleted from SLI table ====
			When all Usernames for a user has been deleted the record will be deleted in the SLI table

Kia: /* Installation */

2022-01-28T13:24:06Z

Installation

← Older revision		Revision as of 13:24, 28 January 2022
Line 14:		Line 14:
	==Installation==		==Installation==
	Configurator - Modules - SLI Setup		Configurator - Modules - SLI Setup
	[[File:SLI Setup.jpg\|none\|thumb\|~~621x621px~~]]		[[File:SLI Setup.jpg\|none\|thumb\|724x724px]]
	The SLI Setup window:		The SLI Setup window:

	*'''Use SLI'''~~: Activate~~ Single Login Identification. This only maintains a SLI table and not UMS.		==== '''Use SLI''' ====
	*'''Maintain UMS''': Check this option to maintain UMS with the SLI.		Activate Single Login Identification. This only maintains a SLI table and not UMS.

	'''~~Identifier settings~~'''		==== '''Maintain UMS''' ====
			Check this option to maintain UMS with the SLI.

	*'''Employee identifier'''		==== '''Create new username for employees''' ====
	**'''First Found Occurrence''': The user name from administrative system.		Gives employees new user name if changed in administrative system.
	**'''Next Number''': To give a number as user name.
	*'''Employee starting number''': Set starting number for first user name.
	*'''Employee identifier prefix''': It is possible to prefix the user name. Put wanted prefix here.
	*'''Student identifier'''
	**'''First Found Occurrence''': The user name from administrative system.
	**'''Next Number''': To give a number as user name.
	*'''Student starting number''': Set starting number for first user name.
	*'''Student identifier prefix''': It is possible to prefix the user name. Put wanted prefix here.
	*'''Parent identifier'''
	**'''First Found Occurrence''': The user name from administrative system.
	**'''Next Number''': To give a number as user name.
	*'''Parent starting number''': Set starting number for first user name.
	*'''Parent identifier prefix''': It is possible to prefix the user name. Put wanted prefix here.
	*'''Create new username for employees'''~~: Gives~~ employees new user name if changed in administrative system.

	==='''Advanced SLI Settings'''===		==='''Advanced SLI Settings'''===
	~~· '''Create new SLI''': Check this to give all users a new SLI. CAUTION: This can have critical impact if the SLI table has been edited manually.~~

	· '''Create ~~separate accounts:~~''' Check this ~~option~~ to give ~~employee~~ a new ~~user name~~ if the ~~employee becomes a student. Unless UNI-Login is used~~.		==== '''Create new SLI''' ====
			Check this to give all users a new SLI. CAUTION: This can have critical impact if the SLI table has been edited manually.

	· '''~~Delete inactive students~~'''~~: Deletes SLI info when students no longer in UMS~~.		==== '''Create separate accounts''' ====
			Check this option to give employee a new user name if the employee becomes a student. Unless UNI-Login is used.

	· '''~~Delete inactive employee~~'''~~: Deletes SLI info when employee no longer~~ in ~~UMS~~.		==== '''Create new username for employees''' ====
			Gives employees new user name if changed in administrative system.

	· '''Delete inactive parents'''~~: Deletes~~ SLI info when parent no longer in UMS.		==== '''Delete inactive students''' ====
			Deletes SLI info when students no longer in UMS.

			==== '''Delete inactive employee''' ====
			Deletes SLI info when employee no longer in UMS.

			==== '''Delete inactive parents''' ====
			Deletes SLI info when parent no longer in UMS.

	==Technical settings==		==Technical settings==

	==FAQ==		==FAQ==

	~~===Change SLI ID starting number===~~

	~~====Get current ID====~~
	~~DBCC checkident ('sli')~~

	~~====Set Next ID====~~
	~~DBCC checkident ('sli', reseed, 10000)~~
	~~<br />~~

Kia: /* Advanced SLI Settings */

2020-11-13T12:38:42Z

Advanced SLI Settings

← Older revision		Revision as of 12:38, 13 November 2020
Line 47:		Line 47:

	· '''Delete inactive employee''': Deletes SLI info when employee no longer in UMS.		· '''Delete inactive employee''': Deletes SLI info when employee no longer in UMS.

			· '''Delete inactive parents''': Deletes SLI info when parent no longer in UMS.

	==Technical settings==		==Technical settings==

Kia: /* Installation */

2020-11-13T12:35:43Z

Installation

← Older revision		Revision as of 12:35, 13 November 2020
Line 14:		Line 14:
	==Installation==		==Installation==
	Configurator - Modules - SLI Setup		Configurator - Modules - SLI Setup
	[[File:~~Sli setup~~.~~png~~\|none\|thumb]]		[[File:SLI Setup.jpg\|none\|thumb\|621x621px]]

	The SLI Setup window:		The SLI Setup window:

Line 33:		Line 32:
	*'''Student starting number''': Set starting number for first user name.		*'''Student starting number''': Set starting number for first user name.
	*'''Student identifier prefix''': It is possible to prefix the user name. Put wanted prefix here.		*'''Student identifier prefix''': It is possible to prefix the user name. Put wanted prefix here.
			*'''Parent identifier'''
			**'''First Found Occurrence''': The user name from administrative system.
			**'''Next Number''': To give a number as user name.
			*'''Parent starting number''': Set starting number for first user name.
			*'''Parent identifier prefix''': It is possible to prefix the user name. Put wanted prefix here.
	*'''Create new username for employees''': Gives employees new user name if changed in administrative system.		*'''Create new username for employees''': Gives employees new user name if changed in administrative system.

Line 50:		Line 54:
	===Change SLI ID starting number===		===Change SLI ID starting number===

	==== Get current ID ====		====Get current ID====
	DBCC checkident ('sli')		DBCC checkident ('sli')

	==== Set Next ID ====		====Set Next ID====
	DBCC checkident ('sli', reseed, 10000)		DBCC checkident ('sli', reseed, 10000)
	<br />		<br />

Kia: /* Change SLI ID starting number */

2019-03-07T20:23:29Z

Change SLI ID starting number

← Older revision		Revision as of 20:23, 7 March 2019
Line 48:		Line 48:
	==FAQ==		==FAQ==

	=== Change SLI ID starting number ===		===Change SLI ID starting number===

			==== Get current ID ====
	DBCC checkident ('sli')		DBCC checkident ('sli')

			==== Set Next ID ====
	DBCC checkident ('sli', reseed, 10000)		DBCC checkident ('sli', reseed, 10000)
	<br />		<br />

Kia: /* FAQ */

2019-03-07T20:22:43Z

FAQ

← Older revision		Revision as of 20:22, 7 March 2019
Line 47:		Line 47:

	==FAQ==		==FAQ==
	~~Change SLI ID starting number~~

			=== Change SLI ID starting number ===
	DBCC checkident ('sli')		DBCC checkident ('sli')

	DBCC checkident ('sli', reseed, 10000)		DBCC checkident ('sli', reseed, 10000)
	<br />		<br />

Khm: /* Technical settings */

2019-03-01T09:22:01Z

Technical settings

← Older revision		Revision as of 09:22, 1 March 2019
Line 1:		Line 1:
	SLI maintains Single Login Identifier for all users.		SLI maintains Single Login Identifier for all users.

	== Prerequisites ==		==Prerequisites==

	=== Supported administrative systems ===		===Supported administrative systems===
	All		All

	=== Module requirements ===		===Module requirements===
	[[UMS]]		[[UMS]]

	=== What to have ready ===		===What to have ready===
	Connection to Administrative system		Connection to Administrative system

	== Installation ==		==Installation==
	Configurator - Modules - SLI Setup		Configurator - Modules - SLI Setup
	[[File:Sli setup.png\|none\|thumb]]		[[File:Sli setup.png\|none\|thumb]]

	The SLI Setup window:		The SLI Setup window:
	* '''Use SLI''': Activate Single Login Identification. This only maintains a SLI table and not UMS.
	* '''Maintain UMS''': Check this option to maintain UMS with the SLI.		*'''Use SLI''': Activate Single Login Identification. This only maintains a SLI table and not UMS.
			*'''Maintain UMS''': Check this option to maintain UMS with the SLI.

	'''Identifier settings'''		'''Identifier settings'''
	* '''Employee identifier'''
	** '''First Found Occurrence''': The user name from administrative system.
	** '''Next Number''': To give a number as user name.
	* '''Employee starting number''': Set starting number for first user name.
	* '''Employee identifier prefix''': It is possible to prefix the user name. Put wanted prefix here.
	* '''Student identifier'''
	** '''First Found Occurrence''': The user name from administrative system.
	** '''Next Number''': To give a number as user name.
	* '''Student starting number''': Set starting number for first user name.
	* '''Student identifier prefix''': It is possible to prefix the user name. Put wanted prefix here.
	* '''Create new username for employees''': Gives employees new user name if changed in administrative system.

	=== '''Advanced SLI Settings''' ===		*'''Employee identifier'''
			**'''First Found Occurrence''': The user name from administrative system.
			**'''Next Number''': To give a number as user name.
			*'''Employee starting number''': Set starting number for first user name.
			*'''Employee identifier prefix''': It is possible to prefix the user name. Put wanted prefix here.
			*'''Student identifier'''
			**'''First Found Occurrence''': The user name from administrative system.
			**'''Next Number''': To give a number as user name.
			*'''Student starting number''': Set starting number for first user name.
			*'''Student identifier prefix''': It is possible to prefix the user name. Put wanted prefix here.
			*'''Create new username for employees''': Gives employees new user name if changed in administrative system.

			==='''Advanced SLI Settings'''===
	· '''Create new SLI''': Check this to give all users a new SLI. CAUTION: This can have critical impact if the SLI table has been edited manually.		· '''Create new SLI''': Check this to give all users a new SLI. CAUTION: This can have critical impact if the SLI table has been edited manually.

Line 41:		Line 44:
	· '''Delete inactive employee''': Deletes SLI info when employee no longer in UMS.		· '''Delete inactive employee''': Deletes SLI info when employee no longer in UMS.

	== Technical settings ==		==Technical settings==

			==FAQ==
			Change SLI ID starting number

			DBCC checkident ('sli')

	~~== FAQ ==~~		DBCC checkident ('sli', reseed, 10000)
			<br />

Bjk at 12:10, 1 May 2017

2017-05-01T12:10:49Z

← Older revision		Revision as of 12:10, 1 May 2017
Line 1:		Line 1:
	~~Introduction text~~.		SLI maintains Single Login Identifier for all users.

	== Prerequisites ==		== Prerequisites ==

	=== Supported administrative systems ===		=== Supported administrative systems ===
			All

	=== Module requirements ===		=== Module requirements ===
			[[UMS]]

	=== ~~Additional functionality~~ ===		=== What to have ready ===
			Connection to Administrative system

	=== ~~Testing after~~ setup ~~===~~		== Installation ==
			Configurator - Modules - SLI Setup
			[[File:Sli setup.png\|none\|thumb]]

	=== ~~What to have ready~~ ===		The SLI Setup window:
			* '''Use SLI''': Activate Single Login Identification. This only maintains a SLI table and not UMS.
			* '''Maintain UMS''': Check this option to maintain UMS with the SLI.
			'''Identifier settings'''
			* '''Employee identifier'''
			** '''First Found Occurrence''': The user name from administrative system.
			** '''Next Number''': To give a number as user name.
			* '''Employee starting number''': Set starting number for first user name.
			* '''Employee identifier prefix''': It is possible to prefix the user name. Put wanted prefix here.
			* '''Student identifier'''
			** '''First Found Occurrence''': The user name from administrative system.
			** '''Next Number''': To give a number as user name.
			* '''Student starting number''': Set starting number for first user name.
			* '''Student identifier prefix''': It is possible to prefix the user name. Put wanted prefix here.
			* '''Create new username for employees''': Gives employees new user name if changed in administrative system.

			=== '''Advanced SLI Settings''' ===
			· '''Create new SLI''': Check this to give all users a new SLI. CAUTION: This can have critical impact if the SLI table has been edited manually.

	~~=== Is any physical item required ===~~		· '''Create separate accounts:''' Check this option to give employee a new user name if the employee becomes a student. Unless UNI-Login is used.

	~~=== Should third party be contacted ===~~		· '''Delete inactive students''': Deletes SLI info when students no longer in UMS.

	~~== Installation ==~~		· '''Delete inactive employee''': Deletes SLI info when employee no longer in UMS.

	== Technical settings ==		== Technical settings ==

	== FAQ ==		== FAQ ==