CREATING REPORTSUSING DATABASE TABLES
Database Schema: VERSION Table (SPI_OBJ_VERSION, 512)
V_NAME Type/Length MSSQL varchar(7) Oracle char(7) API Reference Version ID (SPI_VERS_ID, 513) Description
Contains the unique identifier of the version.
V_E_NAME Type/Length MSSQL varchar(9) null Oracle char(9) API Reference Item ID (SPI_VERS_ITEM_ID, 514) Description
Contains the unique numeric identifier for the version’s parent item.
V_CHECKIN_USER Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
Checked In By User (SPI_VERS_CHECKIN_USER, 515)
Description
Contains the user name of the person who checked in the version.
V_CHECKIN_GRP Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
CREATING REPORTSUSING DATABASE TABLES
Database Schema: VERSION Table (SPI_OBJ_VERSION, 512)
Description
Contains the active group of the user who checked in the version (at the time the version was checked in).
V_CREATE_DATE Type/Length
MSSQL datetime null Oracle date null
API Reference
Checkin Date (SPI_VERS_CREATE_DATE, 517)
Description
Contains the time and date when the version was checked in.
V_COMMENT Type/Length
MSSQL varchar(224) null Oracle varchar2(224) null
API Reference
Comment (SPI_VERS_COMMENT, 518)
Description
Contains a comment about the version.
V_APPLICATION Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
Application (SPI_VERS_APPLICATION, 519)
Description
Identifies the software application used to create the version.
V_FILE_DATE Type/Length
CREATING REPORTSUSING DATABASE TABLES
Database Schema: VERSION Table (SPI_OBJ_VERSION, 512)
API Reference
Modification Date (SPI_VERS_FILE_DATE, 520)
Description
(Protected items only) Contains the time and date the version was last modified (with another application).
V_FILE_SIZE Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
File Size (SPI_VERS_FILE_SIZE, 521)
Description
(Protected items only) Indicates the size of the version (in bytes).
V_STACK_DATE Type/Length
MSSQL datetime null Oracle date null
API Reference
Storage Date (SPI_VERS_SHELF_DATE, 522)
Description
(Internal use only) Contains the time and date the version was placed in the storage repository.
V_STACK_ID Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Storage Repository (SPI_VERS_SHELF_ID, 523)
Description
Contains the unique numeric identifier of the storage repository where the version is stored.
CREATING REPORTSUSING DATABASE TABLES
Database Schema: VERSION Table (SPI_OBJ_VERSION, 512)
V_STACK_FILE_ID Type/Length
MSSQL varchar(12) null Oracle varchar2(12) null
API Reference
Encrypted File Name (SPI_VERS_SHELF_FILE_ID, 524)
Description
Contains the encrypted file name of the version as it is identified in the storage repository.
V_LAST_DATE Type/Length
MSSQL datetime null Oracle date null
API Reference
Last Access Date (SPI_VERS_LAST_DATE, 525)
Description
Contains the date and time that the version was last checked out, checked in, or copied.
V_LAST_USER Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
Last Access User (SPI_VERS_LAST_USER, 526)
Description
Contains the user name of the person who last checked out, checked in, or copied the version.
V_LAST_GROUP Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
CREATING REPORTSUSING DATABASE TABLES
Database Schema: VERSION Table (SPI_OBJ_VERSION, 512)
API Reference
Last Access Group (SPI_VERS_LAST_GROUP, 527)
Description
Contains the name of the active group of the user identified in the V_LAST_USER property at the time the version was last accessed by that user.
V_AVAIL_STAT Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Availability Status (SPI_VERS_AVAIL_STAT, 528)
Description
(Protected items only) Indicates the current storage status of the version.
V_DISP_ID Type/Length
MSSQL int null
Oracle numeric(10)null
API Reference
Archive Repository (SPI_VERS_DISP_ID, 529)
Description
(Internal use only) Contains the unique numeric identifier of the archive repository through which the version was moved offline.
V_DISP_DATE Type/Length
MSSQL datetime null Oracle date null
API Reference
Archive Date (SPI_VERS_DISP_DATE, 530)
Description
Contains the date and time the version was moved to the archive repository identi- fied in the V_DISP_ID property.
CREATING REPORTSUSING DATABASE TABLES
Database Schema: VERSION Table (SPI_OBJ_VERSION, 512)
V_RECLAIM Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Reclaim Pending? (SPI_VERS_RECLAIM_PENDING, 531)
Description
(Protected items only) Indicates whether the version has been flagged to be moved back into IDM Document Services from offline storage.
V_PERMANENT Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Permanent Version? (SPI_VERS_PERMANENT, 532)
Description
(Protected items only) Indicates whether the version should be exempt from auto- matic archival.
V_CHECKED_OUT Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Checked Out? (SPI_VERS_CHECKOUT_PENDING, 533)
Description
Indicates the number of checkouts for this version.
V_MERGE_SRC Type/Length
MSSQL varchar(7) null Oracle char(7) null
CREATING REPORTSUSING DATABASE TABLES
Database Schema: VERSION Table (SPI_OBJ_VERSION, 512)
API Reference
Merge-Source Version ID (SPI_VERS_MERGE_SRC, 534)
Description
(Versions on the primary version line only) Contains the unique identifier of a Ver- sion on the secondary version line if that version was merged into the primary ver- sion line to create this version.
V_MERGE_DST Type/Length
MSSQL varchar(7) null Oracle char(7) null
API Reference
Merge-Destination Version ID (SPI_VERS_MERGE_DST, 535)
Description
(Versions on a secondary version line only) Contains the unique identifier of the ver- sion that was created if and when the secondary version line was merged into the primary version line.
V_BRANCH_COUNT Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Secondary Version Line Count (SPI_VERS_BRANCH_COUNT, 536)
Description
Contains the number of secondary version lines currently in the library system for this version.
V_BRANCH_CURVER Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
CREATING REPORTSUSING DATABASE TABLES
Database Schema: VERSION Table (SPI_OBJ_VERSION, 512)
Description
(Internal use only) Indicates whether this is the most recent version.
V_REC_DATE Type/Length
MSSQL datetime null Oracle date null
API Reference
Reclaim Submitted Date (SPI_VERS_RECLAIM_DATE, 538)
Description
(Protected items only) Contains the date and time when the Reclaim command was last used to submit a request to bring this version back online.
V_B_I_ID_MAJOR Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Full Backup ID (SPI_VERS_B_I_ID_MAJOR, 540)
Description
(Internal use only) Contains the full backup portion of the backup ID for the most recent system backup in which the version was included.
V_B_I_ID_MINOR Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Incremental Backup ID (SPI_VERS_B_I_ID_MINOR, 541)
Description
(Internal use only) Contains the incremental backup portion of the backup ID for the most recent system backup in which the version was included.
CREATING REPORTSUSING DATABASE TABLES
Database Schema: VERSION Table (SPI_OBJ_VERSION, 512)
V_CHECKOUT_DATE Type/Length
MSSQL datetime null Oracle date null
API Reference
Source Version Checkout Date (SPI_VERS_CHECKOUT_DATE, 542)
Description
Contains the date and time when the previous version was checked out to create this version.
V_OFFLINE_LOCATION Type/Length
MSSQL varchar(32) null Oracle varchar2(32) null
API Reference
Offline Location (SPI_VERS_OFFLINE_LOCATION, 543)
Description
The user-supplied, offline location of the version (for example, archive tape num- ber).
V_CSI_ID Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Content Search Repository (SPI_VERS_CSI_ID, 544)
Description
Contains the unique ID assigned to the content search repository in which this ver- sion indexed.
V_CSI_CID Type/Length
MSSQL int null
CREATING REPORTSUSING DATABASE TABLES
Database Schema: VERSION Table (SPI_OBJ_VERSION, 512)
API Reference
Index ID (SPI_VERS_CSI_CID, 545)
Description
Contains the unique ID that identifies this version in the content search repository.
V_CSI_STATUS Type/Length
MSSQL tinyint null Oracle numeric(3) null
API Reference
Indexing Status (SPI_VERS_CSI_STATUS, 546)
Description
Indicates the current index status of the version in the content search repository.
V_CSI_MAJOR Type/Length
MSSQL smallint null Oracle numeric(5) null
API Reference
Index Full Backup ID (SPI_VERS_CSI_MAJOR, 547)
Description
(Internal use only) Contains the full-backup portion of the backup ID for the most recent system backup in which this version was included as an indexed version in the content search repository.
V_CSI_MINOR Type/Length
MSSQL smallint null Oracle numeric(5) null
API Reference
Index Incremental Backup ID (SPI_VERS_CSI_MINOR, 548)
Description
(Internal use only) Contains the incremental-backup portion of the backup ID for the most recent system backup in which this version was included as an indexed ver-
CREATING REPORTSUSING DATABASE TABLES
Database Schema: VERSION_CHECKOUT Table (SPI_OBJ_VERSION_CHECKOUT, 768)
V_CSI_PERMANENT Type/Length
MSSQL tinyint null Oracle numeric(3) null
API Reference
Permanent Index? (SPI_VERS_CSI_PERMANENT, 549)
Description
Indicates whether the version should be exempt from automatic de-indexing.
V_FILE_NAME Type/Length
MSSQL varchar(255) null Oracle varchar2(256) null
API Reference
File Name (SPI_VERS_FILE_NAME, 600)
Description
Contains the file name for the version. The Oracle value also contains the file name extension.
V_SUBCLASS
Reserved for future use.
V_CD
Type/Length
MSSQL int null
Oracle numeric(10) null
API Reference
Child Count (SPI_VERS_CD, 665)
Description
Specifies the number of child documents for this version if it is part of a compound document.