Describes a user who has been added to the library system.
U_NAME
Type/Length
MSSQL varchar(32) Oracle varchar2(32)
API Reference
User Name (SPI_USER_NAME, 1793)
Description
CREATING REPORTSUSING DATABASE TABLES
Database Schema: USR Table (SPI_OBJ_USER, 1792)
U_CREATE_DATE Type/Length
MSSQL datetime null Oracle date null
API Reference
Date Added (SPI_USER_CREATE_DATE, 1794)
Description
Contains the date and time the user was added to the library system.
U_COMMENT Type/Length
MSSQL varchar(224) null Oracle varchar2(224) null
API Reference
Comment (SPI_USER_COMMENT, 1795)
Description
Contains a comment about the user.
U_PWD
Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
Password (SPI_USER_PASSWORD, 1796)
Description
Contains an optional password for the user. If any value is present, a password must be provided to open a session. If the value is blank (contains only a carriage return) then no password is required to open a session.
U_ACT_GRP Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
CREATING REPORTSUSING DATABASE TABLES
Database Schema: USR Table (SPI_OBJ_USER, 1792)
API Reference
Default Group (SPI_USER_DEF_GROUP, 1797)
Description
Contains the name of the group to be used as the user’s active group when the user opens a session.
U_PATH
Type/Length
MSSQL varchar(96) null Oracle varchar2(96) null
API Reference
Default Path (SPI_USER_DEF_PATH, 1798)
Description
Provides a value for the SE_PATH in the Session object. This value contains the default path (drive and directory names only) that indicates where version files will be sent when they are checked out or copied by this user.
U_FILE_CREATOR Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Add Items? (SPI_USER_PRIV_ADD_ITEMS, 1799)
Description
Provides the value for the SPI_SES_ADD_ITEMS property in the Session object, which indicates whether the user can add items to the library system.
U_USER_CREATOR Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
CREATING REPORTSUSING DATABASE TABLES
Database Schema: USR Table (SPI_OBJ_USER, 1792)
Description
Provides the value for the SPI_SES_ADD_USERS property in the Session object, which indicates whether the user can add users to the library system.
U_GROUP_CREATOR Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Add Groups? (SPI_USER_PRIV_ADD_GROUPS, 1801)
Description
Provides the value for the SPI_SES_ADD_GROUPS property in the Session object, which indicates whether the user can add groups to the library system.
U_STOR_ALLOC Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
Default Storage Category (SPI_USER_DEF_FILE_CATEGORY, 1806)
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.
U_DISPOSITION Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
Default Archive Category (SPI_USER_DEF_DISP_CATEGORY, 1807)
Description
Provides a value for the SPI_SES_DEF_DISP_CATEGORY property in the Session object while the session is open and active.
CREATING REPORTSUSING DATABASE TABLES
Database Schema: USR Table (SPI_OBJ_USER, 1792)
U_CHKOUT_F_NAME Obsolete. U_CHKOUT_F_EXT Obsolete. U_OWNER_NAME Type/Length MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
Added By User (SPI_USER_OWNER_NAME, 1811)
Description
Contains the user name of the person who added the User object to the library sys- tem.
U_NET_NAME Type/Length
MSSQL varchar(64) null Oracle varchar2(64) null
API Reference
Network Logon Name (SPI_USER_NETWORK_NAME, 1813)
Description
Contains the network login name for the user.
U_PRIMARY_SERVER Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
Primary Storage Manager (SPI_USER_PRIMARY_SERVER, 1815)
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
CREATING REPORTSUSING DATABASE TABLES
Database Schema: USR Table (SPI_OBJ_USER, 1792)
IDM Document Services will attempt to use first to handle an operational request from the user.
U_STATUS Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Enabled? (SPI_USER_STATUS, 1817)
Description
Indicates whether a user may open an IDM Document Services session.
U_DEF_RUN_APP Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Default Run Application? (SPI_USER_DEF_RUN_APP, 1818)
Description
Indicates whether the application associated with a version will be run by default when that document is checked out or copied.
U_CSINDEX_DEFAULT Type/Length
MSSQL tinyint null Oracle numeric(3) null
API Reference
Default Index Versions? (SPI_USER_CSI_DEFAULT, 1819)
Description
Indicates a default value for the Default Index Versions? property in Item objects.
U_SEARCH_DOMAIN Type/Length
MSSQL int null
CREATING REPORTSUSING DATABASE TABLES
Database Schema: USR Table (SPI_OBJ_USER, 1792)
API Reference
Access Domain (SPI_USER_ACCESS_DOMAIN, 1820)
Description
Contains one of the following group-domain values indicating the group affiliation(s) to apply when determining which search results to return during this user’s search: • SPI_ACCDOMAIN_DEFAULT_S
Search results based on the first Active Group or All Groups access domain value passed from the user’s active Group or System object (assessed in that order).
• SPI_ACCDOMAIN_ACTIVEGROUP_S
Search results based on the access rights assigned to the user’s active group. • SPI_ACCDOMAIN_ALLGROUPS_S
Search results based on the highest access rights assigned to any groups in which the user is a member.
U_LANGUAGE Type/Length
MSSQL tinyint null Oracle numeric(3) null
API Reference
Display Language (SPI_USER_LANGUAGE, 1821)
Description
Indicates the default display language.
U_SECURE_SEARCH Type/Length
MSSQL tinyint null Oracle numeric(3) null
API Reference
Secure Searches? (SPI_USER_SECURE_SEARCH, 1822)
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.
CREATING REPORTSUSING DATABASE TABLES
Database Schema: USR Table (SPI_OBJ_USER, 1792)
U_EMAIL_ADDRESS Type/Length
MSSQL varchar(64) null Oracle varchar2(64) null
API Reference
Email Address (SPI_USER_EMAIL_ADDRESS, 1823)
Description
Reserved for future use.
U_FULL_NAME Type/Length
MSSQL varchar(224) null Oracle varchar2(224) null
API Reference
Full Name (SPI_USER_FULL_NAME, 1824)
Description
The full name of the user (versus the name under which the user logs on to the IDMDS library system).
U_CS_THRESHOLD Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Content Search Threshold (SPI_USER_CSSEARCH_THRESHOLD, 1825)
Description
Determines whether to do a content search or property search first, when both types of criteria are specified for a search.
U_DIR_SYNC Type/Length
MSSQL int null
CREATING REPORTSUSING DATABASE TABLES
Database Schema: VCKO_MV_CUSTOM01 Table (SPI_OBJ_VCKO_MV_CUSTOM01, 15360)
API Reference
Imported User? (SPI_USER_DIR-SYNC, 1826)
Description
Enables synchronization of IDMDS library user names with Windows NT domain(s) user names. The User Import tool (dirsync.exe) runs on the property server as a daemon under a selected library system’s Storage Manager. When enabled, the daemon performs ongoing one-way synchronization of group and user information from selected network domains to a selected library system database; it does not- propagates changes from the library system database back to the network domains.