SLI: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
← Older edit
VisualWikitext
Kia (talk | contribs)
engineering, inHouse, Administrators
2,475 edits
Kia (talk | contribs)
engineering, inHouse, Administrators
2,475 edits
 
(6 intermediate revisions by the same user not shown)
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|724x724px]]
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.


The SLI Setup window:
==== Create new username for employees ====
Gives employees new user name if changed in administrative system.


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


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


*'''Employee identifier'''
==== Delete inactive employee ====
**'''First Found Occurrence''':  The user name from administrative system.
Deletes SLI Username when employee no longer in UMS.
**'''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'''===
==== Delete inactive parents ====
·        '''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.
Deletes SLI Username when parent 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.
==== Keep record for ====
Keep the Username in the SLI table for x number of days after it is no longer in the data source.


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


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


==FAQ==
==FAQ==


=== Change SLI ID starting number ===
==== When will a record be deleted from SLI table ====
DBCC checkident ('sli')
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.


DBCC checkident ('sli', reseed, 10000)
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.
<br />

Latest revision as of 21:27, 11 January 2023

SLI maintains Single Login Identifier for all users.

Prerequisites

Supported administrative systems

All

Module requirements

UMS

What to have ready

Connection to Administrative system

Installation

Configurator - Modules - SLI Setup

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.

Create new username for employees

Gives employees new user name if changed in administrative system.

Advanced SLI Settings

Delete inactive students

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

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

Gives employees new user name if changed in administrative system.

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.

FAQ

When will a record be deleted from 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.

Retrieved from "http://wiki.inlogic.dk/index.php?title=SLI&oldid=4620"