Describes a protected or unprotected item that has been added to the library system.
E_NAME Type/Length MSSQL varchar(9) Oracle char(9) API Reference Item ID (SPI_ITEM_ID, 257) Description
Contains the unique numeric identifier for the item.
E_OWNER Type/Length
CREATING REPORTSUSING DATABASE TABLES
Database Schema: ELEMENT Table (SPI_OBJ_ITEM, 256)
API Reference
Added By User (SPI_ITEM_OWNER, 258)
Description
Contains the name of the user who added the Item object to the property repository.
E_GROUP Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
Added By Group (SPI_ITEM_GROUP, 259)
Description
Contains the name of the active group of the user who added the Item object to the property repository.
E_CREATE_DATE Type/Length
MSSQL datetime null Oracle date null
API Reference
Date Added (SPI_ITEM_CREATE_DATE, 260)
Description
Contains the date and time the Item object was added to the property repository.
E_COMMENT Type/Length
MSSQL text null
Oracle varchar2(2000) null
API Reference
Comment (SPI_ITEM_COMMENT, 261)
Description
CREATING REPORTSUSING DATABASE TABLES
Database Schema: ELEMENT Table (SPI_OBJ_ITEM, 256)
E_PROTECTED Type/Length
MSSQL tinyint null Oracle numeric(3) null
API Reference
Protected? (SPI_ITEM_PROTECTED, 262)
Description
Indicates whether the item is a protected item.
E_ORG_FILENAME Type/Length
MSSQL varchar(32) null Oracle varchar2(256) null
API Reference
Original File Name (SPI_ITEM_ORIGINAL_FILE, 263)
Description
Contains the file name for the first version of the item. The Oracle value also con- tains the file name extension. Note that this is a Text data type, and cannot be indexed. E_ORG_FILENAME_EXT Type/Length MSSQL text null Oracle API Reference Description
Contains the extension of the file name for the first version of the item. For Oracle, this value is contained in E_ORG_FILENAME. Note that this is a Text data type, and cannot be indexed.
E_ALLOC_TYPE Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
CREATING REPORTSUSING DATABASE TABLES
Database Schema: ELEMENT Table (SPI_OBJ_ITEM, 256)
API Reference
Storage Category (SPI_ITEM_FILE_CATEGORY, 264)
Description
(Protected items only) Contains the name of the storage category that indicates where (in which storage repository) checked–in version files for the item will be stored. E_CHKOUT_FILE Obsolete. E_VARIANTS Type/Length MSSQL tinyint null Oracle numeric(3) null
API Reference
Allow Secondary Version Lines? (SPI_ITEM_VARIANTS, 266)
Description
Controls whether secondary version lines are allowed for the item.
E_ONLINE_LMT Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Online Limit (SPI_ITEM_ONLINE_LIMIT, 267)
Description
(Protected items only) Establishes the maximum number of versions of the item that can be stored online before automatic archiving will begin moving the oldest version offline.
E_DISP_MODE Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
CREATING REPORTSUSING DATABASE TABLES
Database Schema: ELEMENT Table (SPI_OBJ_ITEM, 256)
API Reference
Archive Category (SPI_ITEM_DISP_CATEGORY, 268)
Description
(Protected items only) Contains the name of the archive category that indicates where (to which archive repository) versions will be moved during the automatic archival process.
E_CURVER_NUM Type/Length
MSSQL varchar(7) null Oracle char(7) null
API Reference
Current Version ID (SPI_ITEM_CURVER_NUM, 269)
Description
Contains the unique identifier for the current version of the item.
E_CURVER_DATE Type/Length
MSSQL datetime null Oracle date null
API Reference
Current Version Date (SPI_ITEM_CURVER_DATE, 270)
Description
Contains the date and time the Item’s current version was added to the library sys- tem.
E_CURVER_AUTHOR Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
Current Version Author (SPI_ITEM_CURVER_AUTHOR, 271)
Description
CREATING REPORTSUSING DATABASE TABLES
Database Schema: ELEMENT Table (SPI_OBJ_ITEM, 256)
E_ONLINE_CNT Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Online Version Count (SPI_ITEM_ONLINE_COUNT, 272)
Description
(Protected items only) Contains the total number of versions currently online in IDM Document Services for this item.
E_ONLINE_SIZE Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Online Disk Space (SPI_ITEM_ONLINE_SIZE, 273)
Description
(Protected items only) Indicates the total number of characters (bytes) of online stor- age occupied by the versions of the item.
E_LAST_DATE Type/Length
MSSQL datetime null Oracle date null
API Reference
Last Access Date (SPI_ITEM_LAST_DATE, 274)
Description
Contains the date and time any version of this item was last accessed (when a user last checked out, checked in, or copied a version).
E_LAST_VER Type/Length
MSSQL varchar(7) null Oracle char(7) null
CREATING REPORTSUSING DATABASE TABLES
Database Schema: ELEMENT Table (SPI_OBJ_ITEM, 256)
API Reference
Last Accessed Version (SPI_ITEM_LAST_VERSION_ID, 275)
Description
Contains the version ID of the version that was most recently accessed (checked out, checked in, or copied).
E_CURVER_CKO Type/Length
MSSQL tinyint null Oracle numeric(3) null
API Reference
Current Version Checked Out? (SPI_ITEM_CURVER_CHECKED_OUT, 276)
Description
Indicates whether the current version is checked out.
E_ICON_TITLE Type/Length
MSSQL varchar(254) null Oracle varchar2(254) null
API Reference
Title (SPI_ITEM_ICON_TITLE, 277)
Description
Contains the name for the Item’s desktop icon displayed by the FileShare user inter- face.
E_CSI_ID Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Current Content Search Repository (SPI_ITEM_CURVER_CSI_ID, 302)
Description
Contains the unique ID assigned to the content search repository in which the cur- rent version of this item is indexed.
CREATING REPORTSUSING DATABASE TABLES
Database Schema: ELEMENT Table (SPI_OBJ_ITEM, 256)
E_CSI_CID Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Current Version Index ID (SPI_ITEM_CURVER_CSI_CID, 303)
Description
Contains the unique ID that identifies the current version of this item in the content search repository. E_CSINDEX_DEFAULT Type/Length MSSQL tinyint null Oracle numeric(3)null API Reference
Default Index Versions? (SPI_ITEM_CSI_DEFAULT, 304)
Description
Indicates whether new versions of the item will be indexed by default.
E_CSINDEX_COUNT Type/Length
MSSQL smallint null Oracle numeric(5) null
API Reference
Number of Indexed Versions (SPI_ITEM_CSI_COUNT, 305)
Description
Contains an integer that indicates how many versions of the item are indexed in the content search repository.
E_CSINDEX_LIMIT Type/Length
MSSQL smallint null Oracle numeric(5) null
CREATING REPORTSUSING DATABASE TABLES
Database Schema: GRP Table (SPI_OBJ_GROUP, 1536)
API Reference
Indexed Version Limit (SPI_ITEM_CSI_LIMIT, 306)
Description
Contains an integer property indicating the maximum number of versions that can be indexed in the content search repository for the item.
E_MIN_DEL_ACCESS Type/Length
MSSQL smallint null Oracle numeric(5) null
API Reference
Min Item Delete Access Level (SPI_ITEM_MIN_DEL_ACESS, 397)
Description
Indicates what level of access rights is required to delete Item objects.
Regardless of this setting, if an item has no associated versions, anyone with Owner access rights to the Item object can delete it.