Describes a user’s open session of IDM Document Services. The system adds a Session object each time an IDM Document Services session is opened.
CREATING REPORTSUSING DATABASE TABLES
Database Schema: SESSIONTAB Table (SPI_OBJ_SESSION, 2816)
SE_ID
Type/Length
MSSQL int
Oracle numeric(10)
API Reference
Session Number (SPI_SES_ID, 2817)
Description
Contains the unique identifier for the open session.
SE_OWNER Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
User Name (SPI_SES_OWNER, 2818)
Description
Contains the user name of the person who opened the session.
SE_GROUP Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
Active Group (SPI_SES_GROUP, 2819)
Description
Contains the name of the user’s active group.
SE_DATE Type/Length
MSSQL datetime null Oracle date null
API Reference
CREATING REPORTSUSING DATABASE TABLES
Database Schema: SESSIONTAB Table (SPI_OBJ_SESSION, 2816)
Description
Contains the date and time the user opened the session.
SE_WS_ADR Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
Client Workstation Address (SPI_SES_WS_ADDRESS, 2821)
Description
Contains the network address of the workstation on which the user opened the ses- sion.
SE_ADMIN Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Admin Privileges? (SPI_SES_IS_ADMIN, 2822)
Description
(Internal use only) Indicates whether the user was in the Administrators group when he or she opened the session.
SE_FILE_C Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Add Items? (SPI_SES_ADD_ITEM, 2823)
Description
Indicates whether the user who opened the session can add Item objects to the property repository.
CREATING REPORTSUSING DATABASE TABLES
Database Schema: SESSIONTAB Table (SPI_OBJ_SESSION, 2816)
SE_USER_C Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Add Users? (SPI_SES_ADD_USER, 2824)
Description
Indicates whether the user who opened the session can add User objects to the property repository.
SE_GRP_C Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Add Groups? (SPI_SES_ADD_GROUP, 2825)
Description
Indicates whether the user who opened the session can add Group objects to the property repository.
SE_PATH Type/Length
MSSQL varchar(96) null Oracle varchar2(96) null
API Reference
Default Checkout Path (SPI_SES_DEF_PATH, 2826)
Description
Contains the value from the U_PATH property in the User object of the user who opened the session.
SE_F_EXT
CREATING REPORTSUSING DATABASE TABLES
Database Schema: SESSIONTAB Table (SPI_OBJ_SESSION, 2816)
SE_STOR_ALLOC Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
Default Storage Category (SPI_SES_DEF_FILE_CATEGORY, 2828)
Description
Contains the default storage category that will be assigned to any new items added by the user during this session.
SE_DISPOSITION Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
Default Archive Category (SPI_SES_DEF_DISP_CATEGORY, 2829)
Description
Contains the default archive category that will be assigned to any new items added by the user during this session.
SE_STATE Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Status (SPI_SES_STATE, 2830)
Description
Indicates the status of the session.
SE_SUSPEND_DATE Type/Length
MSSQL datetime null Oracle date null
CREATING REPORTSUSING DATABASE TABLES
Database Schema: SESSIONTAB Table (SPI_OBJ_SESSION, 2816)
API Reference
Suspension Date (SPI_SES_SUSPEND_DATE, 2831)
Description
Indicates the date and time the session was suspended.
SE_CATALOG_ID Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Property Manager Process ID (SPI_SES_CATALOG_ID, 2832)
Description
Contains the unique identifier of the Property Manager process that is servicing the session.
SE_PRIMARY_SERVER Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
Primary Storage Manager (SPI_SES_PRIMARY_SERVER, 2833)
Description
Contains the primary Storage Manager for operational requests submitted by the user during this session.
SE_INSTALLATION Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
System Name (SPI_SES_SYSTEM, 2834)
Description
CREATING REPORTSUSING DATABASE TABLES
Database Schema: SESSIONTAB Table (SPI_OBJ_SESSION, 2816)
SE_SECURE_SEARCH Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Secure Searches? (SPI_SES_SECURE_SEARCH, 2835)
Description
Indicates whether the user who opened this session must have at least Viewer access rights to an item to have that item included in the results of one of his or her searches.
SE_SEARCH_DOMAIN Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Access Domain (SPI_SES_ACCESS_DOMAIN, 2836)
Description
Contains one of the following group-domain values indicating the group affiliation(s) to apply when determining which search results to return during the user’s search: • SPI_ACCDOMAIN_ACTIVEGROUP_S
Search results based on the user’s active group. • SPI_ACCDOMAIN_ALLGROUPS_S
Search results based on all groups in which the user is a member.
SE_CSINDEX_DEFAULT Type/Length
MSSQL tinyint null Oracle numeric(3) null
API Reference
Default Index Versions? (SPI_SES_CSI_DEFAULT, 2837)
Description
Contains the value that will be entered for the Default Index Versions? property in new Item objects added by the user during this session.
CREATING REPORTSUSING DATABASE TABLES
Database Schema: SESSIONTAB Table (SPI_OBJ_SESSION, 2816)
SE_LANGUAGE Type/Length
MSSQL tinyint null Oracle numeric(3) null
API Reference
Display Language (SPI_SES_LANGUAGE, 2838)
Description
Contains the language with which the user opened the session.
SE_NET_USER Type/Length
MSSQL varchar(224) null Oracle varchar2(224) null
API Reference
Network Login Name (SPI_SES_NETWORK_USER, 2839)
Description
Contains the network login name used to open the session.
SE_CS_THRESHOLD Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Content Search Threshold (SPI_SES_CSSEARCH_THRESHOLD, 2840)
Description
Determines whether to do a content search or property search first, when both types of criteria are specified for a search.
SE_RECLAIM_ACCESS Type/Length
MSSQL smallint null Oracle numeric(5) null
API Reference
CREATING REPORTSUSING DATABASE TABLES
Database Schema: STACK Table (SPI_OBJ_SHELF, 2304)
Description
Indicates the minimum level of access rights needed to reclaim an item.
SE_ITEM_DEL_ACCESS Type/Length
MSSQL smallint null Oracle numeric(5) null
API Reference
Min Item Delete Access Level (SPI_SES_ITEM_DEL_ACCESS, 2842)
Description
Indicates the minimum level of access rights needed to delete an item. The value of this property is supplied from the L_ITEM_DEL_ACCESS property of the System object. This property value is supplied when the session opens. Any changes to L_ITEM_DEL_ACCESS are not effected until the next session is opened.