Panagon. Technical Notice

(1)

Document 9812133-003

© 2000 by FileNET Corporation. All rights reserved. FileNET is a registered trademark and Panagon is a trademark of FileNET Corporation. Other brands and product names may be trademarks or registered trademarks of their respective companies.

For updates to any IDM Document Services (IDMDS) documentation, choose the Documentation link on the FileNET Worldwide Support web site http://www.css.filenet.com/, and navigate to the current IDMDS release for your platform. If you do not have a customer support services (CSS) Web Account, click the New User button and follow the online instructions.

Panagon

™

Technical Notice

(2)

CREATING REPORTSUSING DATABASE TABLES

Introduction: Getting More Information in the IDM Document Services API Manual

Introduction

This technical notice describes how you can access the database tables for a version 5.1 IDM Document Services library system using your own SQL report generating software.

Use these database schemas for reporting only! All database table values should be treated as read-only in your reports. Be careful not to update data using these database schemas. Each documented database table represents an object type in an IDM Document Services library system. Each documented entry represents a table column corresponding to a particular property of an object. The property description includes the corresponding database field type and length. You may need this field type and length information if you are importing data into another database application which requires knowledge about the type and length of any data values being imported. On the other hand, if you are planning to bring data into a word processing document, you may not need this information at all.

The last section of this technical notice has examples of simple SQL queries you can run against an IDM Document Services 5.1 library system.

Getting More Information in the IDM Document Services API Manual

If the description provided in this technical notice does not give you enough programming related information about an object (i.e., table) or property, in many cases you can get more information in the IDM Document Services API Manuala.

Changing Existing Reports

Prior to IDM Document Services 4.2, library system objects were exposed using the Report Writer Interface that shipped with the Microsoft SQL Server version of IDM Document Services. The Report Writer Interface feature was then withdrawn from IDM Document Services (i.e., Mezzanine) as of version 4.2. This technical notice, which documents the IDM Document Services version 5.1 database schemas and the mappings of database tables to IDM Document Services properties, now replaces the former Report Writer Interface and extends the number of objects that you can access and use when generating reports. If you want to continue to run reports that were created using the now-discontinued Report Writer Interface against IDM Document Services 5.1, you will need to change them to access

a. The IDM Document Services API Manual is part of a software development kit, available separately. The API Manual contains information needed by programmers and is not needed to use this technical notice.

(3)

Introduction: Changing Existing Reports

the database tables listed directly instead of using the Views defined by the Report Writer Interface. The following mappings will help you do this:

• Checkout Object View (CHECKOUTOBJ): From VERSION_CHECKOUT table • Custom Object View (CUSTOMOBJ): From CUSTOM table

• Group Object View (GROUPOBJ): From GRP table

• Group Member View (GROUPMEMBEROBJ): From GRP_USR table

• Item View (ITEMOBJ): From ELEMENT table, INA_INFO (Custom Properties) table • Keyword View (KEYWORDOBJ): From ELEM_KW table

• User View (USEROBJ): From USR table

(4)

Database Schema: ACCESS_CONTROL Table (SPI_OBJ_ACCESS_CONTROL, 3840)

Database Schema

ACCESS_CONTROL Table (SPI_OBJ_ACCESS_CONTROL, 3840)

Controls the access to a particular User, Group, or Item object by granting access privileges to a specific user or group.

AC_INST_NM Type/Length

MSSQL varchar(208) Oracle varchar2(208)

API Reference

Parent Object Name (SPI_AC_PARENT_NAME, 3841)

Description

Contains the name of the parent User, Group, or Item object to which this Access Control object controls access.

AC_U_NAME Type/Length

MSSQL varchar(32) null Oracle varchar2(32)

API Reference

User or Group Name (SPI_AC_NAME, 3842)

Description

Contains the name of the user or group being granted access privileges.

AC_TYPE Type/Length

MSSQL smallint null Oracle numeric(5)

API Reference

User or Group Type (SPI_AC_TYPE, 3843)

Description

(5)

Database Schema: APP Table (SPI_OBJ_APPLICATION, 7424)

AC_OBJ_TYPE Type/Length

MSSQL int null Oracle numeric(10)

API Reference

Parent Object Type (SPI_AC_PARENT_OBJECT, 3844)

Description

Indicates the type of object that the name in AC_INST_NM describes.

AC_CODE Type/Length

MSSQL smallint null Oracle numeric(5) null

API Reference

Access Level (SPI_AC_CODE, 3845)

Description

Indicates the access privileges granted to the user or group named in AC_U_NAME.

AC_ORDER Type/Length

MSSQL tinyint null Oracle numeric(3) null

API Reference

Access Order (SPI_AC_ORDER, 3846)

Description

Internal use only.

APP Table (SPI_OBJ_APPLICATION, 7424)

Obsolete.

AUDIT_CONTROL Table (SPI_OBJ_AUDIT_CONTROL, 4352)

(6)

Database Schema: AUDIT_EVENTS Table (SPI_OBJ_AUDIT_EVENTS, 18176)

AC_AUDIT_LOG_ON Type/Length

MSSQL tinyint

Oracle numeric(3) null

API Reference

Logging Enabled? (SPI_AC_AUDIT_LOG_ON, 4353)

Description

Indicates whether IDM Document Services auditing will be performed for all users of an IDM Document Services library system.

AC_CURRENT_SET Type/Length

API Reference

Current Set (SPI_AC_CURRENT_SET, 4354)

Description

Internal use only. This property value is assigned to each logged audit event in the Audit Log object. The value is incremented every time the stpIncrementSet proce-dure is run and, under certain conditions, when the stpTruncAuditLog proceproce-dure is run.

AUDIT_EVENTS Table (SPI_OBJ_AUDIT_EVENTS, 18176)

Identifies the EDM library system audit events that will be logged.

AE_ID

Type/Length

MSSQL smallint Oracle numeric(5)

API Reference

Event ID (SPI_AE_ID, 18177)

Description

(7)

Database Schema: AUDIT_LOG Table (SPI_OBJ_AUDIT_LOG, 18432)

AE_LOG_ON_SUCCESS Type/Length

API Reference

Log Success? (SPI_AE_LOG_ON_SUCCESS, 18178)

Description

Indicates whether events that succeed will be logged.

AE_LOG_ON_FAILURE Type/Length

API Reference

Log Failure? (SPI_AE_LOG_ON_FAILURE, 18179)

Description

Indicates whether events that fail will be logged.

AUDIT_LOG Table (SPI_OBJ_AUDIT_LOG, 18432)

Describes a logged audit event.

AL_EVENT_ID Type/Length

MSSQL smallint Oracle numeric(5) null

API Reference

Event ID (SPI_AL_EVENT_ID, 18433)

Description

Contains the event ID of the audit event.

AL_OBJECT_ID Type/Length

MSSQL varchar(32) null Oracle varchar2(32) null

(8)

API Reference

Object ID(SPI_AL_OBJECT_ID, 18434)

Description

Contains the object ID of the audit event. This property only applies to events that operate on a single object.

AL_SEQUENCE Type/Length

API Reference

Event Sequence (SPI_AL_SEQUENCE, 18435)

Description

Internal use only.

AL_OBJECT_KEY Type/Length

API Reference

Object Key (SPI_AL_OBJECT_KEY, 18436)

Description

Contains the key value of the audit event. This property only applies to events that require a key value.

AL_EVENT_PARAM1 Type/Length

API Reference

Event Param1 (SPI_AL_EVENT_PARAM1, 18437)

Description

Contains the input/output audit event parameter values. Data that exceeds the length of this property will be truncated.

(9)

API Reference

Description

API Reference

Description

API Reference

Description

AL_SR_START_KEY Type/Length

(10)

API Reference

Start Key (SPI_AL_SR_START_KEY, 18441)

Description

Contains the start key for a search when the search is continued (that is, indicates a starting point for the results set). Applies only to the spiQuerySearchRequest, spiQueryList, and spiQueryCard audit events.

AL_SR_DIRECTION Type/Length

MSSQL int null

API Reference

Direction (SPI_AL_SR_DIRECTION, 18442)

Description

Contains the search direction (ascending or descending) indicated for the results set. Applies only to the spiQuerySearchRequest, spiQueryList, and spiQueryCard audit events.

AL_SR_COUNT Type/Length

MSSQL int null

API Reference

Count (SPI_AL_SR_COUNT, 18443)

Description

Contains the number of hits returned by the search (or NULL if the search fails). Applies only to the spiQuerySearchRequest, spiQueryList, and spiQueryCard audit events.

AL_DATETIME Type/Length

MSSQL datetime null Oracle date

API Reference

(11)

Description

Contains the date and time the audit event occurred.

AL_USER Type/Length

API Reference

User Name (SPI_AL_USER, 18445)

Description

Contains the name of the library system user who initiated the audit event.

AL_STATUS Type/Length

MSSQL int null

API Reference

Status (SPI_AL_STATUS, 18446)

Description

Contains the status code returned by the audit event.

AL_WORKSTATN_ADDR Type/Length

API Reference

Workstation (SPI_AL_WORKSTATION_ADDR, 18447)

Description

Contains the workstation address of the client where the audit event was originated.

AL_ELAPSED_TIME Type/Length

MSSQL int null

(12)

API Reference

Elapsed Time (SPI_AL_ELAPSED_TIME, 18448)

Description

Contains the elapsed time (in milliseconds) that was required to complete the audit event.

AL_SET_NUMBER Type/Length

MSSQL int null

API Reference

Set Number (SPI_AL_SET_NUMBER, 18449)

Description

Contains the set number from the Audit Control Object’s Current Set property (AC_CURRENT_SET).

AL_PROCESSID Type/Length

API Reference

Process ID (SPI_AL_PROCESSID, 18450)

Description

Contains the process ID, assigned by the operating system, of the program that initi-ated the audit event.

AL_FLAGS Type/Length

MSSQL int null

API Reference

Flags (SPI_AL_FLAGS, 18451)

Description

(13)

Database Schema: BRANCH_SERVER Table (SPI_OBJ_SHELF_SERVER, 3328)

AL_FILENAME Type/Length

API Reference

File Name (SPI_AL_FILENAME, 18452)

Description

Contains the file name referenced by the audit event, if applicable.

BRANCH_SERVER Table (SPI_OBJ_SHELF_SERVER, 3328)

Describes a Storage Manager, which not only controls storage repositories used to store system-managed files but also services operational requests.

BS_NODE Type/Length

API Reference

Server (SPI_SSVR_NODE_NAME, 3329)

Description

Contains the unique network name of the server on which the Storage Manager is located.

BS_NAME Type/Length

API Reference

Service Name (SPI_SSVR_SERVICE_NAME, 3330)

Description

Contains the unique name assigned to the Storage Manager during IDM Document Services server installation.

(14)

BS_CLASS Type/Length

API Reference

Service Class (SPI_SSVR_CLASS, 3331)

Description

(Internal use only) Contains the class (for example, Windows NT) of the server on which the Storage Manager is located.

BS_COMMENT Type/Length

API Reference

Comment (SPI_SSVR_COMMENT, 3332)

Description

Contains a comment about the Storage Manager.

BS_START_DATE Type/Length

MSSQL datetime null Oracle date null

API Reference

Start Date (SPI_SSVR_START_DATE, 3333)

Description

Indicates the date and time that the Storage Manager was most recently started.

BS_STOP_DATE Type/Length

API Reference

(15)

Description

Indicates the date and time that the Storage Manager was most recently stopped.

BS_STATUS Type/Length

MSSQL int null

API Reference

Status (SPI_SSVR_STATUS, 3335)

Description

Indicates whether this Storage Manager is currently operational and/or is available for use

BS_LAST_BACKUP Type/Length

API Reference

Backup Date (SPI_SSVR_LAST_BACKUP, 3336)

Description

Contains the date and time of the most recent system backup.

BS_HEARTBEAT Type/Length

API Reference

Last Heartbeat (SPI_SSVR_HEARTBEAT, 3337)

Description

Contains the date and time the reclaim daemon for the Storage Manager last attempted to reclaim version files from the associated reclaim repositories. Because this value is updated at regular intervals, it can indicate whether or not the Storage Manager is still active.

(16)

BS_THING_1 Type/Length

API Reference

Future (SPI_SSVR_THING_1, 3338)

Description

Reserved for future use.

BS_THING_2 Type/Length

API Reference

Future (SPI_SSVR_THING_2, 3339)

Description

BS_VERSION Type/Length

API Reference

Software Version (SPI_SSVR_VERSION, 3340)

Description

Contains the software version number of the Storage Manager.

BS_INSTALLED_DRIVE Type/Length

API Reference

(17)

Description

Contains the device (for example, drive) on which the Storage Manager is installed.

BS_ENDIAN Type/Length

MSSQL int null

API Reference

Endian (SPI_SSVR_ENDIAN, 3342)

Description

(Internal use only) Indicates the byte order of a CPU architecture.

BS_NODE_ADDR Type/Length

API Reference

Server Address (SPI_SSVR_NODE_ADDRESS, 3343)

Description

Contains the address of the server where the Storage Manager is located. This property is primarily useful for UNIX systems.

BS_SERVICE_ADDR Type/Length

API Reference

Service Address (SPI_SSVR_SERVICE_ADDRESS, 3344)

Description

Contains the service port address of the server where the Storage Manager is located (such as, BRSERVER). This property is primarily useful for UNIX systems.

(18)

Database Schema: CATALOG Table (SPI_OBJ_CATALOG, 6400)

CATALOG Table (SPI_OBJ_CATALOG, 6400)

Describes a Property Manager. The system automatically creates a Property Managerobject when IDM Document Services is installed.

C_NAME

Type/Length

API Reference

System Name (SPI_CAT_SERVICE_NAME, 6401)

Description

Contains the unique name assigned to the Property Manager during server setup.

C_NODE

Type/Length

API Reference

Server (SPI_CAT_NODE_NAME, 6402)

Description

Contains the unique name identifying the network server on which the Property Manager is located.

C_STATUS Type/Length

MSSQL int null

API Reference

Status (SPI_CAT_STATUS, 6403)

Description

(19)

C_START_DATE Type/Length

API Reference

Start Date (SPI_CAT_START_DATE, 6404)

Description

Indicates when the Property Manager was last started.

C_STOP_DATE Type/Length

API Reference

Stop Date (SPI_CAT_STOP_DATE, 6405)

Description

Indicates when the Property Manager was last shut down, making it unavailable to users.

C_DATA_SPACE Type/Length

MSSQL int null

API Reference

Repository Max Size (SPI_CAT_DATA_SPACE, 6406)

Description

Indicates the total amount of disk space assigned to the Property Manager for data storage.

C_LOG_SPACE Type/Length

MSSQL int null

(20)

API Reference

Transaction Log Max Size (SPI_CAT_LOG_SPACE, 6407)

Description

No longer used.

C_DATA_PCT Type/Length

MSSQL int null

API Reference

Repository Space Used (%) (SPI_CAT_DATA_PCT, 6408)

Description

Indicates the percentage of Property Manager data space that has been used.

C_LOG_PCT Type/Length

MSSQL int null

API Reference

Transaction Log Space Used (%) (SPI_CAT_LOG_PCT, 6409)

Description

On library systems that use a Microsoft SQL Server database engine, indicates the percentage of Property Manager transaction–log space that has been used. This property does not apply to library systems that use an Oracle database engine.

C_THING_1 Type/Length

API Reference

Future (SPI_CAT_THING_1, 6410)

Description

(21)

C_THING_2 Type/Length

API Reference

Future (SPI_CAT_THING_2, 6411)

Description

C_VERSION Type/Length

API Reference

DB Engine Software Version (SPI_CAT_VERSION, 6412)

Description

Indicates the software version of the Property Manager.

C_LOG_WARNING Type/Length

MSSQL int null

API Reference

Log Warning Threshold (%) (SPI_CAT_LOG_WARNING, 6413)

Description

On library systems that use a Microsoft SQL Server database engine, sets the Property Manager transaction log warning threshold. This property does not apply to library systems that use an Oracle database engine.

C_LOG_FULL Type/Length

MSSQL int null

(22)

API Reference

Log Full Threshold (%) (SPI_CAT_LOG_FULL, 6414)

Description

On library systems that use a Microsoft SQL Server database engine, sets the Property Manager transaction log full threshold. This property does not apply to library systems that use an Oracle database engine.

C_DATA_WARNING Type/Length

MSSQL int null

API Reference

Repository Warn Threshold (%) (SPI_CAT_DATA_WARNING, 6415)

Description

Sets the Property Manager warning threshold value for repositories.

C_DATA_FULL Type/Length

MSSQL int null

API Reference

Repository Full Threshold (%) (SPI_CAT_DATA_FULL, 6416)

Description

Sets the Property Manager’s full threshold value for repositories.

C_SHARED Type/Length

MSSQL int null

API Reference

Customer Supplied DB Engine? (SPI_CAT_SHARED, 6417)

Description

Indicates whether the database engine is being shared with other systems or appli-cations.

(23)

Database Schema: CS_SERVER Table (SPI_OBJ_CS_SERVER, 9216)

C_INSTALL_DRIVE Type/Length

API Reference

Device (SPI_CAT_INSTALLATION_DRIVE, 6418)

Description

Identifies the storage device on which the Property Manager for this system was installed.

C_NODE_ADDR Type/Length

API Reference

Server Address (SPI_CAT_NODE_ADDRESS, 6419)

Description

Identifies the network address for the server on which the Property Manager for this system is installed.

C_SERVICE_ADDR Type/Length

API Reference

Service Address (SPI_CAT_SERVICE_ADDRESS, 6420)

Description

Contains the service address for the server on which the Property Manager is installed.

CS_SERVER Table (SPI_OBJ_CS_SERVER, 9216)

(24)

CSS_NAME Type/Length

MSSQL varchar(32) Oracle varchar2(32) null

API Reference

Service Name (SPI_CSS_SERVICE_NAME, 9217)

Description

Contains the name of this Content Search Manager.

CSS_NODE Type/Length

API Reference

Server (SPI_CSS_NODE_NAME, 9218)

Description

Contains the name of the machine on which this Content Search Manager is located.

CSS_DEVICE Type/Length

API Reference

Device (SPI_CSS_DEVICE, 9219)

Description

Contains the name of the top–level device (for example, the drive letter) where this Content Search Manager is located.

CSS_PATH Type/Length

(25)

API Reference

Path (SPI_CSS_PATH, 9220)

Description

Contains the full path of the root directory containing this Content Search Manager.

CSS_COMMENT Type/Length

API Reference

Comment (SPI_CSS_COMMENT, 9221)

Description

Contains a comment string.

CSS_START_DATE Type/Length

API Reference

Start Date (SPI_CSS_START_DATE, 9222)

Description

Contains the date and time that this Content Search Manager was started.

CSS_STOP_DATE Type/Length

API Reference

Stop Date (SPI_CSS_STOP_DATE, 9223)

Description

(26)

CSS_STATUS Type/Length

MSSQL int null

API Reference

Status (SPI_CSS_STATUS, 9224)

Description

Indicates the operational status of this Content Search Manager.

CSS_VERSION Type/Length

API Reference

Software Version (SPI_CSS_VERSION, 9225)

Description

Contains the software version of this Content Search Manager.

CSS_MAX_CONNS Type/Length

MSSQL int null

API Reference

Max Number of Connections (SPI_CSS_MAX_CONNECTIONS, 9226)

Description

Internal use only.

CSS_NODE_ADDR Type/Length

API Reference

(27)

Database Schema: CSI_INDEX Table (SPI_OBJ_CSI_INDEX, 9472)

Description

Contains the server address for this Content Search Manager.

CSS_SERVICE_ADDR Type/Length

API Reference

Service Address (SPI_CSS_SERVICE_ADDRESS, 9228)

Description

Contains the service address for this Content Search Manager.

CSI_INDEX Table (SPI_OBJ_CSI_INDEX, 9472)

Describes a repository for a Content Search Manager (up to three repositories per Content Search Manager).

CSI_ID

Type/Length

MSSQL int

Oracle numeric(10)

API Reference

Content Search Repository ID (SPI_CSI_ID, 9473)

Description

Contains the system–supplied ID of this content search repository (for example, 1).

CSI_NAME Type/Length

API Reference

Content Search Repository Name (SPI_CSI_NAME, 9474)

Description

Contains the system–supplied name of this content search repository (for example, index001).

(28)

CSI_NODE Type/Length

API Reference

Server (SPI_CSI_NODE, 9475)

Description

Contains the unique name identifying the network server on which this content search repository is located.

CSI_DEVICE Type/Length

API Reference

Device (SPI_CSI_DEVICE, 9476)

Description

Contains the name of the top–level device (for example, the drive letter) where this content search repository is located.

CSI_PATH Type/Length

API Reference

Path (SPI_CSI_PATH, 9477)

Description

Contains the full path of the root directory containing this content search repository.

CSI_MERGE_HOUR Type/Length

MSSQL int null

(29)

API Reference

Merge Time of Day (SPI_CSI_MERGE_HOUR, 9478)

Description

Indicates the time of day in 24 hour format that the CSMERGE utility is run.

CSI_MAX_SIZE Type/Length

MSSQL int null

API Reference

Max Repository Size (SPI_CSI_MAX_SIZE, 9479)

Description

Indicates the maximum size (in bytes) of the content search repository.

CSI_ERRCOUNT Type/Length

MSSQL int null

API Reference

Number of Indexing Errors (SPI_CSI_ERRCOUNT, 9480)

Description

Indicates how many errors were detected the last time the indexing daemon ran.

CSI_PRIORITY Type/Length

MSSQL int null

API Reference

Indexing Priority (SPI_CSI_PRIORITY, 9481)

Description

(30)

CSI_SEMA Type/Length

API Reference

Indexing Semaphore (SPI_CSI_SEMA, 9482)

Description

Internal use only.

CSI_STATUS Type/Length

API Reference

Indexing Status (SPI_CSI_STATUS, 9483)

Description

Indicates the operational status of this content search repository.

CSI_LASTMERGE_TIME Type/Length

API Reference

Last Merge Time (SPI_CSI_LAST_MERGE_TIME, 9484)

Description

Internal use only.

CSI_STOP_TIME Type/Length

API Reference

(31)

Description

Internal use only.

CSI_CSMERGE_PID Type/Length

API Reference

Merging PID (SPI_CSI_CSMERGE_PID, 9486)

Description

Internal use only.

CSI_CSINDEX_PID Type/Length

API Reference

Indexing PID (SPI_CSI_CSINDEX_PID, 9487)

Description

Internal use only.

CSI_WORKFILE_SIZE Type/Length

MSSQL int null

API Reference

Working File Size (SPI_CSI_WORKFILE_SIZE, 9488)

Description

Specifies the maximum size in bytes of a temporary sort file.

CSI_WORKMEM_SIZE Type/Length

MSSQL int null

(32)

API Reference

Working Memory Size (SPI_CSI_WORKMEM_SIZE, 9489)

Description

Specifies the size in bytes of a temporary buffer that is allocated.

CSI_LOGSQL Type/Length

API Reference

SQL Logging (SPI_CSI_LOGSQL, 9490)

Description

Specifies whether the SQL commands used by the CSINDEX and CSMERGE utili-ties will be logged to the csi00n.log file.

CSI_RMAJOR Type/Length

API Reference

Full Backup ID (SPI_CSI_RMAJOR, 9491)

Description

Internal use only.

CSI_MAX_IMMED_SIZE API Reference

Max Immediate File Size (SPI_CSI_MAX_IMMED_SIZE, 9492)

Type/Length

MSSQL int null

Description

Specifies the maximum size (in bytes) that the immediate index file can reach before the CSMERGE utility is run.

(33)

Database Schema: CUSTOM Table (SPI_OBJ_CUSTOM_OBJECT, 8960)

CSI_NET_PATH Type/Length

API Reference

Network Path (SPI_CSI_NET_PATH, 9493)

Description

Contains the network path location of a content search repository located on a net-work server.

CUSTOM Table (SPI_OBJ_CUSTOM_OBJECT, 8960)

Describes a Custom object that is used to extend the FileNET IDM Document Services API in your system. This object may be either a high–level object (for example, an Enhanced User object) or a lower–level object that will function as a quasi–list (for example, a Year–End Evaluation object under the User object).

CO_ISV_ID Type/Length

API Reference

ISV ID (SPI_CO_ISV_ID, 8961)

Description

Contains an IDM Document Services assigned string identifier for the object.

CO_OBJECT_TYPE Type/Length

API Reference

Object Type (SPI_CO_OBJECT_TYPE, 8962)

Description

(34)

CO_KEY

Type/Length

API Reference

Object Key (SPI_CO_KEY, 8963)

Description

Contains a unique, developer–assigned key to the object instance.

CO_STRING1 Type/Length

API Reference

String1 (SPI_CO_STRING1, 8964)

Description

Contains one of ten possible customized string properties (each up to 32 charac-ters) that describe the object.

API Reference

Description

(35)

API Reference

Description

API Reference

Description

API Reference

Description

API Reference

Description

(36)

API Reference

Description

API Reference

Description

API Reference

Description

(37)

API Reference

Description

CO_LSTRING1 Type/Length

API Reference

Long String1 (SPI_CO_LONG_STRING1, 8974)

Description

Contains one of five possible longer, customized string properties (each up to 254 characters) that describe the object.

API Reference

Description

API Reference

Description

(38)

API Reference

Description

API Reference

Description

CO_INTEGER1 Type/Length

MSSQL int null

API Reference

Integer1 (SPI_CO_INTEGER1, 8979)

Description

Contains one of ten possible customized integer properties (each up to 9 charac-ters) that describe the object.

MSSQL int null

(39)

API Reference

Description

MSSQL int null

API Reference

Description

MSSQL int null

API Reference

Description

MSSQL int null

API Reference

Description

(40)

MSSQL int null

API Reference

Description

MSSQL int null

API Reference

Description

MSSQL int null

API Reference

Description

MSSQL int null

(41)

API Reference

Description

MSSQL int null

API Reference

Description

CO_DATETIME1 Type/Length

API Reference

DateTime1 (SPI_CO_DATETIME1, 8989)

Description

Contains one of five possible customized date/time properties that describe the object.

API Reference

Description

(42)

API Reference

Description

API Reference

Description

API Reference

Description

CO_VERSION1 Type/Length

MSSQL varchar(7) null Oracle char(7) null

(43)

API Reference

Version1 (SPI_CO_VERSION1, 8994)

Description

Contains one of three possible customized version properties to describe the object.

API Reference

Description

API Reference

Description

CO_TEXT1 Type/Length

MSSQL text null Oracle long null

API Reference

Text 1 (SPI_CO_TEXT1, 8998)

Description

Contains a memo property of 2048 maximum bytes. The CO_LSTRING1 property has been lengthened to 2048 bytes to provide similar functionality.

(44)

Database Schema: CUSTOM_ATTR_NAME Table (SPI_OBJ_CUSTOM_ATTR_NAME, 5632)

CO_OWNER Type/Length

API Reference

Added By User (SPI_CO_OWNER, 8999)

Description

Contains the name of the user who added the Custom object.

CO_DATE Type/Length

API Reference

Date Added (SPI_CO_DATE, 9000)

Description

Contains the date the Custom object was added.

CUSTOM_ATTR_NAME Table (SPI_OBJ_CUSTOM_ATTR_NAME, 5632)

This object is typically used for national language support. It contains a custom property’s display string (for example, for a particular language). When you add a custom property through FileShare, an instance of this object is added with a Display Name value to match the Property Name value in the new Custom Property object. An instance of this property must be added for each language string that is to be displayed. A new Display Names property in each Custom Property object lists these various Custom Property Name objects that might be created. Only administrators can access this object and change the Display Name value.

CAN_CA_ID Type/Length

MSSQL int

Oracle numeric(10)

API Reference

(45)

Database Schema: CUSTOM_ATTR_NAME Table (SPI_OBJ_CUSTOM_ATTR_NAME, 5632)

Description

Uniquely identifies the custom property.

CAN_LANG_ID Type/Length

MSSQL tinyint null Oracle numeric(3)

API Reference

Display Language ID (SPI_CAN_LANG_ID, 5634)

Description

Identifies the display language to be used.

CAN_NAME Type/Length

API Reference

Display Name (SPI_CAN_NAME, 5635)

Description

Contains the string to be displayed to users as the name of this custom property (typically, in conjunction with a particular language).

CAN_CA_PARENT_OBJ Type/Length

API Reference

Parent Object Number (SPI_CAN_CA_PARENT_OBJECT, 5636)

Description

Valid parent object numbers are 256 (Item), 512 (Version), and 768 (Checkout).

CAN_CA_MUL_VALUED Type/Length

MSSQL tinyint null Oracle numeric(3)

(46)

Database Schema: DEFAULT_ACCESS Table (SPI_OBJ_DEFAULT_ACCESS, 6912)

API Reference

Multi-valued? (SPI_CAN_CA_MULTI_VALUED, 5637)

Description

Indicates whether this custom property is multi-valued or single–valued.

DEFAULT_ACCESS Table (SPI_OBJ_DEFAULT_ACCESS, 6912)

Causes IDM Document Services to automatically enter an Access Control object that will control a user’s or group’s access to a newly created Item, User, or Group object at the time that new object is added to the property repository.

DA_OWNER_TYPE Type/Length

MSSQL int

Oracle numeric(10)

API Reference

Source Object Type (SPI_DEFACL_PARENT_OBJECT, 6913)

Description

Contains the type of parent object (SPI_OBJ_SYSTEM, SPI_OBJ_USER, or SPI_OBJ_GROUP) that the name in the DA_OWNER_NAME property describes.

DA_OWNER_NAME Type/Length

API Reference

Source Object Name (SPI_DEFACL_PARENT_NAME, 6914)

Description

Contains the instance name of the parent User, Group, or System object to which this SPI_OBJ_DEFAULT_ACCESS object belongs.

DA_HOLDER_TYPE Type/Length

MSSQL smallint null Oracle numeric(5)

(47)

Database Schema: DEFAULT_ACCESS Table (SPI_OBJ_DEFAULT_ACCESS, 6912)

API Reference

User or Group Type (SPI_DEFACL_HOLDER_TYPE, 6915)

Description

Contains the object type (SPI_OBJ_USER or SPI_OBJ_GROUP) to be placed into the AC_TYPE property in the SPI_OBJ_ACCESS_CONTROL object.

DA_HOLDER_NAME Type/Length

API Reference

User or Group Name (SPI_DEFACL_HOLDER_NAME, 6916)

Description

Contains the name of the user or group to be placed into the AC_U_NAME property in the SPI_OBJ_ACCESS_CONTROL object.

DA_OBJECT_TYPE Type/Length

API Reference

Object Type (SPI_DEFACL_OBJECT_TYPE, 6917)

Description

Indicates the type of object that the SPI_OBJ_ACCESS_CONTROL object will con-trol access to. (Currently, only SPI_OBJ_ITEM is supported.)

DA_CODE Type/Length

API Reference

Access Level (SPI_DEFACL_CODE, 6918)

Description

Contains the access privileges that will be placed into the AC_CODE property in the SPI_OBJ_ACCESS_CONTROL object.

(48)

Database Schema: DISP_STACK Table (SPI_OBJ_DISP_SHELF, 3072)

DISP_STACK Table (SPI_OBJ_DISP_SHELF, 3072)

Describes an archive repository that has been added to the library system to be used in the version archive process as a temporary storage directory for versions being moved offline.

DS_ID

Type/Length

MSSQL int

Oracle numeric(10)

API Reference

Archive Repository ID (SPI_DSHELF_ID, 3073)

Description

Contains the unique identifier for the archive repository.

DS_COMMENT Type/Length

API Reference

Comment (SPI_DSHELF_COMMENT, 3074)

Description

Contains a comment about the archive repository.

DS_RECLAIMABLE Type/Length

MSSQL int null

API Reference

Reclaimable? (SPI_DSHELF_RECLAIMABLE, 3075)

Description

Indicates whether versions that are moved offline using the archive categories linked to the archive repositories can be reclaimed.

(49)

DS_NODE Type/Length

API Reference

Server (SPI_DSHELF_NODE, 3076)

Description

Contains the unique name of the network server on which this archive repository is located.

DS_DEV

Type/Length

API Reference

Device (SPI_DSHELF_DEVICE, 3077)

Description

Contains the name of the storage device where the archive repository is located.

DS_DIR

Type/Length

API Reference

Directory (SPI_DSHELF_DIRECTORY, 3078)

Description

Contains the name of the directory used to locate the archive repository relative to the server and the device name.

DS_SERVR_NM Type/Length

(50)

API Reference

Server Name (SPI_DSHELF_SERVER_NAME, 3079)

Description

Contains the constant value BRSERVER. Reserved for future use.

DS_SERVR_CLASS Type/Length

API Reference

Server Class (SPI_DSHELF_SERVER_CLASS, 3080)

Description

DS_PATH Type/Length

API Reference

Path (SPI_DSHELF_PATH, 3081)

Description

Contains the path location of the archive repository.

DS_THING_1 Type/Length

API Reference

Future (SPI_DSHELF_THING_1, 3083)

Description

(51)

Database Schema: ELEM_KW Table (SPI_OBJ_KEYWORD, 4096)

DS_THING_2 Type/Length

API Reference

Future (SPI_DSHELF_THING_2, 3084)

Description

DS_DELETE_FILES Type/Length

API Reference

Delete Upon Archive? (SPI_DSHELF_DELETE_FILES, 3085)

Description

Indicates whether to forego copying archived version files to the archive repository and delete them immediately instead.

DS_NET_PATH Type/Length

API Reference

Network Path (SPI_DSHELF_NET_PATH, 3086)

Description

Contains the network path location of an archive repository located on a network server.

ELEM_KW Table (SPI_OBJ_KEYWORD, 4096)

Provides information about a keyword that is associated with a particular item. Keyword objects appear as child objects of an Item object.

(52)

Database Schema: ELEMENT Table (SPI_OBJ_ITEM, 256)

KW_E_NAME Type/Length

MSSQL varchar(9) Oracle char(9)

API Reference

Item ID (SPI_KWRD_ITEM_ID, 4097)

Description

Contains the Item ID of the item the keyword is associated with.

KW_NAME Type/Length

API Reference

Keyword (SPI_KWRD_NAME, 4098)

Description

Contains the user–supplied keyword value.

ELEMENT Table (SPI_OBJ_ITEM, 256)

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

(53)

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

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

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

(54)

E_PROTECTED Type/Length

API Reference

Protected? (SPI_ITEM_PROTECTED, 262)

Description

Indicates whether the item is a protected item.

E_ORG_FILENAME Type/Length

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

(55)

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

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

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

(56)

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

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

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

API Reference

Current Version Author (SPI_ITEM_CURVER_AUTHOR, 271)

Description

(57)

E_ONLINE_CNT Type/Length

MSSQL int 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

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

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

(58)

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

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

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

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.

(59)

E_CSI_CID Type/Length

MSSQL int 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

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

(60)

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

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.

GRP Table (SPI_OBJ_GROUP, 1536)

Describes a group that has been added to the library system.

G_NAME

Type/Length

API Reference

Group Name (SPI_GROUP_NAME, 1537)

Description

Contains the unique name of the group.

G_OWNER_NAME Type/Length

(61)

Database Schema: GRP Table (SPI_OBJ_GROUP, 1536)

API Reference

Added By User (SPI_GROUP_OWNER_NAME, 1538)

Description

Contains the name of the user who added the Group object to the property reposi-tory.

G_CREATE_DATE Type/Length

API Reference

Date Added (SPI_GROUP_CREATE_DATE, 1539)

Description

Contains the date and time when the Group object was added to the property repos-itory.

G_COMMENT Type/Length

API Reference

Comment (SPI_GROUP_COMMENT, 1540)

Description

Contains a comment about the group.

G_STOR_ALLOC Type/Length

API Reference

Default Storage Category (SPI_GROUP_DEF_FILE_CATEGORY, 1544)

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.