Describes the library system elements (for example, users, groups, items, custom properties) and supplies system-wide limits and defaults.
L_NAME
Type/Length
MSSQL varchar(32) Oracle varchar2(32)
API Reference
System Name (SPI_SYS_NAME, 1281)
Description
Contains the name assigned to the library system when it was installed.
L_INST_NAME Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
Installer (SPI_SYS_INSTALL_USER, 1282)
Description
Contains the name of the person who installed the library system.
L_INST_DATE Type/Length
MSSQL datetime null Oracle date null
CREATING REPORTSUSING DATABASE TABLES
Database Schema: LIBRARY Table (SPI_OBJ_SYSTEM, 1280)
API Reference
Installation Date (SPI_SYS_INSTALL_DATE, 1283)
Description
Contains the date and time when the library system was installed.
L_COMMENT Type/Length
MSSQL varchar(224) null Oracle varchar2(224) null
API Reference
Comment (SPI_SYS_COMMENT, 1284)
Description
Contains a comment about the IDM Document Services system.
L_SW_VERSION Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
IDM Document Services Software Version (SPI_SYS_SW_VERSION, 1285)
Description
Contains the software version of the product being used (as specified in the L_PRODUCT property in this object).
L_VARIANT_FLAG Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Default Allow Secondary Lines? (SPI_SYS_DEF_ALLOW_VARIANTS, 1286)
Description
CREATING REPORTSUSING DATABASE TABLES
Database Schema: LIBRARY Table (SPI_OBJ_SYSTEM, 1280)
L_VERSION_LIMIT Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Default Online Limit (SPI_SYS_DEF_ONLINE_LIMIT, 1287)
Description
Provides an initial value for the E_ONLINE_LMT property in the Item object created when a document is added to the library system.
L_DISPOSITION Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
Default Archive Category (SPI_SYS_DEF_DISP_CATEGORY, 1288)
Description
Provides a value for the SPI_SES_DEF_DISP_CATEGORY property in the Session object while the session is open and active.
L_CHKOUT_F_NAME Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Default Checkout File Name (SPI_SYS_DEF_CHECKOUT_FILE, 1289)
Description
Indicates which option the system is to use to create the initial value for the
SPI_ITEM_CHECKOUT_FILE property in a new Item object that is created when a file is being added.
L_ENABLE_REPL Type/Length
MSSQL int null
CREATING REPORTSUSING DATABASE TABLES
Database Schema: LIBRARY Table (SPI_OBJ_SYSTEM, 1280)
API Reference
Replication Enabled? (SPI_SYS_ENABLE_REPLICATION, 1290)
Description
Indicates whether replication is enabled for this system.
L_DEFAULT_ACCESS Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Default General Access (SPI_SYS_DEF_GENERAL_ACCESS, 1291)
Description
Not Used.
L_STOR_ALLOC Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
Default Storage Category (SPI_SYS_DEF_FILE_CATEGORY, 1292)
Description
Contains the value to apply to the SPI_SES_DEF_FILE_CATEGORY property in the Session object while the session is open and active.
L_LOGIN_LIMIT Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Max Number of Active Sessions (SPI_SYS_LOGIN_LIMIT, 1293)
Description
CREATING REPORTSUSING DATABASE TABLES
Database Schema: LIBRARY Table (SPI_OBJ_SYSTEM, 1280)
L_LOGIN_COUNT Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Number of Active Sessions (SPI_SYS_LOGIN_COUNT, 1294)
Description
Contains the current number of active sessions.
L_USER_COUNT Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Number of Users (SPI_SYS_USER_COUNT, 1295)
Description
Contains the total number of users who have been added to the library system.
L_BACKUP_DEVICE Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
Backup Device (SPI_SYS_BACKUP_DEVICE, 1296)
Description
Reserved for future use.
L_BACKUP_PATH Type/Length
MSSQL varchar(96) null Oracle varchar2(96) null
API Reference
CREATING REPORTSUSING DATABASE TABLES
Database Schema: LIBRARY Table (SPI_OBJ_SYSTEM, 1280)
Description
Reserved for future use.
L_SERIAL_NO Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
Serial Number (SPI_SYS_SERIAL_NO, 1305)
Description
Contains the serial number of the license for the library system.
L_NETWORK_LOGIN
Obsolete.
L_INST_TYPE Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
System Type (SPI_SYS_TYPE, 1307)
Description
Indicates the library system type.
L_CMD_LINE_PSWD Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Allow Cmd-line Passwd? (SPI_SYS_COMMAND_LINE_PSWD, 1308)
Description
CREATING REPORTSUSING DATABASE TABLES
Database Schema: LIBRARY Table (SPI_OBJ_SYSTEM, 1280)
L_LOGINS_ENABLED Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Logins Enabled? (SPI_SYS_LOGINS_ENABLED, 1309)
Description
Indicates whether users whose default group is not set to Administrators can open sessions
L_PRIMARY_SERVER Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
Primary Storage Manager (SPI_SYS_PRIMARY_SERVER, 1311)
Description
Provides a value for the SE_PRIMARY_SERVER property in the Session object while the session is open and active. The value indicates which Storage Manager IDM Document Services will attempt to use first to handle an operational request from a user.
L_THING_1 Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
Future (SPI_SYS_THING_1, 1312)
Description
For future use.
L_THING_2 Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
CREATING REPORTSUSING DATABASE TABLES
Database Schema: LIBRARY Table (SPI_OBJ_SYSTEM, 1280)
API Reference
Future (SPI_SYS_THING_2, 1313)
Description
For future use.
L_PV_IN_LIMIT Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Permanent Versions in Limit? (SPI_SYS_PV_IN_LIMIT, 1215)
Description
Indicates whether versions marked as Permanent are to be included in the online limit for a protected item.
L_SECURE_SEARCH Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Secure Searches? (SPI_SYS_SECURE_SEARCH, 1316)
Description
Indicates whether users must have at least Viewer access rights to an item to have that item included in the results of their searches.
L_SUSPENDED_COUNT Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Num. of Suspended Sess (SPI_SYS_SUSPENDED_COUNT, 1318)
Description
CREATING REPORTSUSING DATABASE TABLES
Database Schema: LIBRARY Table (SPI_OBJ_SYSTEM, 1280)
L_CS_ENABLED Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Content Search Enabled? (SPI_SYS_CS_ENABLED, 1319)
Description
Indicates whether content searches are allowed.
L_CSINDEX_DEFAULT Type/Length
MSSQL tinyint null Oracle numeric(3) null
API Reference
Default Index Versions? (SPI_SYS_CSI_DEFAULT, 1320)
Description
Indicates a default value for the Default Index Versions? property in Item objects.
L_CSINDEX_LIMIT Type/Length
MSSQL smallint null Oracle numeric(5) null
API Reference
Default Indexed Version Limit (SPI_SYS_CSI_LIMIT, 1321)
Description
Indicates a default value for the Indexed Version Limit property in Item objects.
L_CSI_PV_IN_LIMIT Type/Length
MSSQL tinyint null Oracle numeric(3) null
API Reference
CREATING REPORTSUSING DATABASE TABLES
Database Schema: LIBRARY Table (SPI_OBJ_SYSTEM, 1280)
Description
Indicates whether versions marked as permanently indexed (in the
SPI_VERS_CSI_PERMANENT property) are to be included in the indexed version limit for an item.
L_SEARCH_DOMAIN Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Access Domain (SPI_SYS_ACCESS_DOMAIN, 1323)
Description
Contains one of the following group-domain values indicating the group affiliation(s) to apply when determining which search results to return to the caller during a search:
• SPI_ACCDOMAIN_ACTIVEGROUP_S
Search results based on the access rights assigned to the user’s active group (the default value).
• SPI_ACCDOMAIN_ALLGROUPS_S
Search results based on the highest access rights assigned to any of the groups in which the user is a member.
L_ADMIN_USER Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
Administrative User (SPI_SYS_ADMIN_USER, 1324)
Description
The name given to the initial administrator in the particular IDM Document Services system, with the default value being Admin. This user is added automatically by the installation program.
L_ADMIN_GROUP Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
CREATING REPORTSUSING DATABASE TABLES
Database Schema: LIBRARY Table (SPI_OBJ_SYSTEM, 1280)
API Reference
Administrative Group (SPI_SYS_ADMIN_GROUP, 1325)
Description
The name given to the administrative group, with the default value being Administra- tors.
L_GENERAL_GROUP Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
Universal Group (SPI_SYS_GENERAL_GROUP, 1326)
Description
The name given to the universal group, with the default value being General Users.
L_LANGUAGE Type/Length
MSSQL tinyint null Oracle numeric(3) null
API Reference
Display Language (SPI_SYS_LANGUAGE, 1327)
Description
Contains the language in which the software is being presented (for example, Ger- man).
L_ROOT
Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
Root Path (SPI_SYS_ROOT, 1328)
Description
Contains the path name of the root directory used for the IDM Document Services installation.
CREATING REPORTSUSING DATABASE TABLES
Database Schema: LIBRARY Table (SPI_OBJ_SYSTEM, 1280)
L_PRODUCT Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
Product Name (SPI_SYS_PRODUCT, 1329)
Description
Contains the name to be used for the ELS product. The default value is “IDM Docu- ment Services.”
L_SEQ_ITEM_IDS Type/Length
MSSQL tinyint null Oracle numeric(3) null
API Reference
Sequential Item Ids? (SPI_SYS_SEQ_ITEM_IDS, 1330)
Description
Specifies whether to use sequential item ID’s rather than Julian date IDs for all items added.
L_CS_THRESHOLD Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Content Search Threshold (SPI_SYS_CSSEARCH_THRESHOLD, 1338)
Description
Determines whether to do a content search or property search first, when both types of criteria are specified for a search.
L_RECLAIM_ACCESS Type/Length
MSSQL smallint null Oracle numeric(5) null
CREATING REPORTSUSING DATABASE TABLES
Database Schema: MESSAGE Table (SPI_OBJ_MESSAGE, 6656)
API Reference
Min Reclaim Access Level (SPI_SYS_RECLAIM_ACCESS, 1339)
Description
Indicates the minimum level of access rights needed to reclaim an item.
L_ITEM_DEL_ACCESS Type/Length
MSSQL smallint null Oracle numeric(5) null
API Reference
Min Item Delete Access Level (SPI_SYS_ITEM_DEL_ACCESS, 1341)
Description
Indicates the minimum level of access rights needed to delete an item. The only acceptable values are Admin or Owner access. NOTE: Regardless of this setting, if an item has no associated versions, anyone with Owner access rights to the Item object can delete it.