Tivoli Common Data Dictionary

Table Name Table Comment Table Column Name Table Column Comment Table Column Datatype Table Column Null Option
ACTIVE_SLA This table contains entries for objects currently under an SLA agreement. ACTIVE_SLA_ID This column contains a unique identifier for the current SLA record. INTEGER NOT NULL
ACTIVE_SLA This table contains entries for objects currently under an SLA agreement. BREACH_DATE This column contains the date the ACTIVE_SLA record is scheduled to breach the agreement. DATE NULL
ACTIVE_SLA This table contains entries for objects currently under an SLA agreement. BREACH_TIME This column contains the time the SLA record is scheduled to breach the agreement. VARCHAR2(10) NULL
ACTIVE_SLA This table contains entries for objects currently under an SLA agreement. NEXT_FIRE_DATE This column contains the date the SLA Monitor will perform the next scheduled event. DATE NULL
ACTIVE_SLA This table contains entries for objects currently under an SLA agreement. NEXT_FIRE_TIME This column contains the time the SLA Monitor will perform the next scheduled event. VARCHAR2(10) NULL
ACTIVE_SLA This table contains entries for objects currently under an SLA agreement. NEXT_SCHEDULE_ID This column contains the identification of the event that will be performed next (according to the NEXT_FIRE_DATE and NEXT_FIRE_TIME columns). INTEGER NULL
ACTIVE_SLA This table contains entries for objects currently under an SLA agreement. REFERENCE_ID This column contains an identifier for the referencing object (PROBLEM_ID, CHANGE_ID, CALL_ID, and so on) being governed by the ACTIVE_SLA record. VARCHAR2(15) NOT NULL
ACTIVE_SLA This table contains entries for objects currently under an SLA agreement. RELATIVE_TO This column contains a number used to determine the table (PROBLEM, CHANGE, and so on) the ACTIVE_SLA record is associated with. INTEGER NOT NULL
ACTIVE_SLA This table contains entries for objects currently under an SLA agreement. SLA_STATE This column contains the status of the ACTIVE_SLA record. The SLA Monitor reads the status to determine whether the record is initialized, requires work, or needs to be deleted. INTEGER NOT NULL
ACTIVE_SLA This table contains entries for objects currently under an SLA agreement. TERM_ID This column contains an identifier for the SLA term. INTEGER NULL
ALARMS This table contains all pending alarms. ALARM_DATE This column contains the date the alarm is to be delivered. DATE NOT NULL
ALARMS This table contains all pending alarms. ALARM_ID This column contains the unique ID of the alarm record. INTEGER NOT NULL
ALARMS This table contains all pending alarms. ALARM_TEXT This column contains the descripton of the alarm. VARCHAR2(1024) NULL
ALARMS This table contains all pending alarms. ALARM_TIME This column contains the time the alarm is to be delivered. VARCHAR2(10) NOT NULL
ALARMS This table contains all pending alarms. ALARM_TITLE This column contains the title or subject of the alarm. VARCHAR2(40) NULL
ALARMS This table contains all pending alarms. CALL_ID This column contains the unique ID of the call record associated with this alarm if any. VARCHAR2(15) NULL
ALARMS This table contains all pending alarms. FWD_USER_ID This column contains the user ID of a user to forwad this alarm to. VARCHAR2(15) NULL
ALARMS This table contains all pending alarms. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
ALARMS This table contains all pending alarms. NOTIFIED This column indicates if the alarm has been delivered. INTEGER NULL
ALARMS This table contains all pending alarms. POSTPONED This column indicates if the alarm has been postponed. INTEGER NULL
ALARMS This table contains all pending alarms. PROBLEM_ID This column contains the unique problem ID of the problem this alarm is associated with, if any. VARCHAR2(15) NULL
ALARMS This table contains all pending alarms. RCV_GROUP_ID This column contains the group ID of the group to receive this alarm. VARCHAR2(15) NULL
ALARMS This table contains all pending alarms. RCV_USER_ID This column contains the user ID of the user to receive this alarm. VARCHAR2(15) NULL
ALARMS This table contains all pending alarms. REGARDING This column contains a brief description of the alarm VARCHAR2(20) NULL
ALARMS This table contains all pending alarms. SET_DATE This column contains the date the alarm was created. DATE NULL
ALARMS This table contains all pending alarms. SET_TIME This column contains the time the alarm was created. VARCHAR2(10) NULL
ALARMS This table contains all pending alarms. SND_USER_ID This column contains the ID of the user who sent the alarm. VARCHAR2(15) NULL
BREACH_RELATIVE_TO This table stores the relationship between the breach time and the problem/change record. AUDIT_TABLE This column contains the name of table to which the breach record will be written when a breach occurs. VARCHAR2(30) NOT NULL
BREACH_RELATIVE_TO This table stores the relationship between the breach time and the problem/change record. DATE_COL_NAME This column the date column of the relative table. VARCHAR2(30) NOT NULL
BREACH_RELATIVE_TO This table stores the relationship between the breach time and the problem/change record. KEY_NAME This column the primary key of the relative table. VARCHAR2(30) NOT NULL
BREACH_RELATIVE_TO This table stores the relationship between the breach time and the problem/change record. RELATION_NAME This column contains the name of the relationship (for example, Problem Open Time). VARCHAR2(15) NOT NULL
BREACH_RELATIVE_TO This table stores the relationship between the breach time and the problem/change record. RELATIVE_TO This column contains the unique ID for the BREACH_RELATIVE_TO table. INTEGER NOT NULL
BREACH_RELATIVE_TO This table stores the relationship between the breach time and the problem/change record. TABLE_NAME This column contains the name of the relative table. VARCHAR2(30) NOT NULL
BREACH_RELATIVE_TO This table stores the relationship between the breach time and the problem/change record. TIME_COL_NAME This column contains the time column of the relative table. VARCHAR2(30) NOT NULL
COMPONENT This table contains the component portion of the equipment hierarchy. COMPONENT_ID This column contains the ID of the component. The component_id and system_id make the unique identifier for component. VARCHAR2(15) NOT NULL
COMPONENT This table contains the component portion of the equipment hierarchy. DESCRIPTION This column contains the description of the component. VARCHAR2(1024) NULL
COMPONENT This table contains the component portion of the equipment hierarchy. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
COMPONENT This table contains the component portion of the equipment hierarchy. PROBLEM_TYPE This column contains the ID of an associated problem type, if any. VARCHAR2(15) NULL
COMPONENT This table contains the component portion of the equipment hierarchy. SYSTEM_ID This column contains the ID of the associated system. VARCHAR2(15) NOT NULL
CONTRACT This table stores information about agreements with vendors for purchases, warranties, maintenance or other services. Contracts can be associated with assets and with a planned or completed event for the asset. When a contract is associated with a planned or completed event, the contract then becomes associated with the asset. Contracts are identified by the unique system-generated # (Contract_ID) and also by the user-defined contract number (Contract_Number) and contract type (Contract_Type). ACTIVE This column indicates whether the contract is active or inactive (expired). This value is provided by the user. There is no system event that updates expired contracts to expired. SMALLINT NULL
CONTRACT This table stores information about agreements with vendors for purchases, warranties, maintenance or other services. Contracts can be associated with assets and with a planned or completed event for the asset. When a contract is associated with a planned or completed event, the contract then becomes associated with the asset. Contracts are identified by the unique system-generated # (Contract_ID) and also by the user-defined contract number (Contract_Number) and contract type (Contract_Type). CONTRACT_ID This column contains a unique identification for the CONTRACT record. INTEGER NOT NULL
CONTRACT This table stores information about agreements with vendors for purchases, warranties, maintenance or other services. Contracts can be associated with assets and with a planned or completed event for the asset. When a contract is associated with a planned or completed event, the contract then becomes associated with the asset. Contracts are identified by the unique system-generated # (Contract_ID) and also by the user-defined contract number (Contract_Number) and contract type (Contract_Type). CONTRACT_LOC_TYPE This column contains an indicator for the type of electronic document identified in the CONTRACT_LOCATION table. The type (association, image, or text) is used to determine how to open the document from wtihin the application. The types are: 1 = view the file using the application associated with the file, 2 = open a viewer to display .bmp, .gif, and .pcx files, and 3 = open text viewer. INTEGER NULL
CONTRACT This table stores information about agreements with vendors for purchases, warranties, maintenance or other services. Contracts can be associated with assets and with a planned or completed event for the asset. When a contract is associated with a planned or completed event, the contract then becomes associated with the asset. Contracts are identified by the unique system-generated # (Contract_ID) and also by the user-defined contract number (Contract_Number) and contract type (Contract_Type). CONTRACT_LOCATION This column contains the path and file name for an electronic version of a contract document. VARCHAR2(254) NULL
CONTRACT This table stores information about agreements with vendors for purchases, warranties, maintenance or other services. Contracts can be associated with assets and with a planned or completed event for the asset. When a contract is associated with a planned or completed event, the contract then becomes associated with the asset. Contracts are identified by the unique system-generated # (Contract_ID) and also by the user-defined contract number (Contract_Number) and contract type (Contract_Type). CONTRACT_NOTES This column contains user-defined notes about the contract. VARCHAR2(254) NULL
CONTRACT This table stores information about agreements with vendors for purchases, warranties, maintenance or other services. Contracts can be associated with assets and with a planned or completed event for the asset. When a contract is associated with a planned or completed event, the contract then becomes associated with the asset. Contracts are identified by the unique system-generated # (Contract_ID) and also by the user-defined contract number (Contract_Number) and contract type (Contract_Type). CONTRACT_NUMBER This column contains a user-defined number that identifies the contract. VARCHAR2(40) NOT NULL
CONTRACT This table stores information about agreements with vendors for purchases, warranties, maintenance or other services. Contracts can be associated with assets and with a planned or completed event for the asset. When a contract is associated with a planned or completed event, the contract then becomes associated with the asset. Contracts are identified by the unique system-generated # (Contract_ID) and also by the user-defined contract number (Contract_Number) and contract type (Contract_Type). CONTRACT_STATUS This column contains the user-defined status of the contract. The system administrator may add, edit, or delete status codes for contracts. The default status codes provided with the product are: Renewal, Past-Due, and Pending. A user must manually update contract status. There is no user or system event that updates the status of a contract. VARCHAR2(18) NULL
CONTRACT This table stores information about agreements with vendors for purchases, warranties, maintenance or other services. Contracts can be associated with assets and with a planned or completed event for the asset. When a contract is associated with a planned or completed event, the contract then becomes associated with the asset. Contracts are identified by the unique system-generated # (Contract_ID) and also by the user-defined contract number (Contract_Number) and contract type (Contract_Type). CONTRACT_TYPE The information in this column identifies the type of contract. Contract types are defined from the Asset Management Configuration dialog box. VARCHAR2(18) NOT NULL
CONTRACT This table stores information about agreements with vendors for purchases, warranties, maintenance or other services. Contracts can be associated with assets and with a planned or completed event for the asset. When a contract is associated with a planned or completed event, the contract then becomes associated with the asset. Contracts are identified by the unique system-generated # (Contract_ID) and also by the user-defined contract number (Contract_Number) and contract type (Contract_Type). DATE_END This column contains the contract expiration date. DATE NULL
CONTRACT This table stores information about agreements with vendors for purchases, warranties, maintenance or other services. Contracts can be associated with assets and with a planned or completed event for the asset. When a contract is associated with a planned or completed event, the contract then becomes associated with the asset. Contracts are identified by the unique system-generated # (Contract_ID) and also by the user-defined contract number (Contract_Number) and contract type (Contract_Type). DATE_START This column contains the contract effective date. DATE NULL
CONTRACT This table stores information about agreements with vendors for purchases, warranties, maintenance or other services. Contracts can be associated with assets and with a planned or completed event for the asset. When a contract is associated with a planned or completed event, the contract then becomes associated with the asset. Contracts are identified by the unique system-generated # (Contract_ID) and also by the user-defined contract number (Contract_Number) and contract type (Contract_Type). MOD_LABEL This column contains a user-defined value that indicates the version or the date the contract was last modified. VARCHAR2(18) NOT NULL
CONTRACT This table stores information about agreements with vendors for purchases, warranties, maintenance or other services. Contracts can be associated with assets and with a planned or completed event for the asset. When a contract is associated with a planned or completed event, the contract then becomes associated with the asset. Contracts are identified by the unique system-generated # (Contract_ID) and also by the user-defined contract number (Contract_Number) and contract type (Contract_Type). MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
CONTRACT This table stores information about agreements with vendors for purchases, warranties, maintenance or other services. Contracts can be associated with assets and with a planned or completed event for the asset. When a contract is associated with a planned or completed event, the contract then becomes associated with the asset. Contracts are identified by the unique system-generated # (Contract_ID) and also by the user-defined contract number (Contract_Number) and contract type (Contract_Type). ORGANIZATION_ID VARCHAR2(15) NULL
CONTRACT This table stores information about agreements with vendors for purchases, warranties, maintenance or other services. Contracts can be associated with assets and with a planned or completed event for the asset. When a contract is associated with a planned or completed event, the contract then becomes associated with the asset. Contracts are identified by the unique system-generated # (Contract_ID) and also by the user-defined contract number (Contract_Number) and contract type (Contract_Type). PEOPLE_ID This column contains the unique identification number of the person identified as the internal point of contact (POC) for the contract. INTEGER NULL
CONTRACT This table stores information about agreements with vendors for purchases, warranties, maintenance or other services. Contracts can be associated with assets and with a planned or completed event for the asset. When a contract is associated with a planned or completed event, the contract then becomes associated with the asset. Contracts are identified by the unique system-generated # (Contract_ID) and also by the user-defined contract number (Contract_Number) and contract type (Contract_Type). PURCHASE_VENDOR This column contains the unique identification number for the purchase vendor. VARCHAR2(15) NULL
CONTRACT This table stores information about agreements with vendors for purchases, warranties, maintenance or other services. Contracts can be associated with assets and with a planned or completed event for the asset. When a contract is associated with a planned or completed event, the contract then becomes associated with the asset. Contracts are identified by the unique system-generated # (Contract_ID) and also by the user-defined contract number (Contract_Number) and contract type (Contract_Type). SECONDARY_VENDOR This column contains the unique identification number of the secondary vendor. CHAR(18) NULL
CONTRACT This table stores information about agreements with vendors for purchases, warranties, maintenance or other services. Contracts can be associated with assets and with a planned or completed event for the asset. When a contract is associated with a planned or completed event, the contract then becomes associated with the asset. Contracts are identified by the unique system-generated # (Contract_ID) and also by the user-defined contract number (Contract_Number) and contract type (Contract_Type). TERMINATION_NOTICE This column contains the contract termination notice date (date the organization must take action if they desire to terminate the contract). DATE NULL
CONTRACT This table stores information about agreements with vendors for purchases, warranties, maintenance or other services. Contracts can be associated with assets and with a planned or completed event for the asset. When a contract is associated with a planned or completed event, the contract then becomes associated with the asset. Contracts are identified by the unique system-generated # (Contract_ID) and also by the user-defined contract number (Contract_Number) and contract type (Contract_Type). VENDOR_ID This column contains the primary vendor ID. VARCHAR2(15) NOT NULL
CONTRACT This table stores information about agreements with vendors for purchases, warranties, maintenance or other services. Contracts can be associated with assets and with a planned or completed event for the asset. When a contract is associated with a planned or completed event, the contract then becomes associated with the asset. Contracts are identified by the unique system-generated # (Contract_ID) and also by the user-defined contract number (Contract_Number) and contract type (Contract_Type). WARRANTY_VENDOR This column contains the unique identification number for the warranty vendor. VARCHAR2(15) NULL
CONTRACT_ADDRESS This table stores addresses associated with a contract. Each address can have one Bill To and many Ship To addresses. This is enforced by the application. Contract addresses should be related to the vendors associated with the contract and not the contract itself. Each vendor may have multiple address types. CONTRACT_ADR_ID This column contains a unique number obtained for the COUNTERS table to uniquely identify the address record for the contract. INTEGER NOT NULL
CONTRACT_ADDRESS This table stores addresses associated with a contract. Each address can have one Bill To and many Ship To addresses. This is enforced by the application. Contract addresses should be related to the vendors associated with the contract and not the contract itself. Each vendor may have multiple address types. CONTRACT_ID This column contiains a unique number that identifies the contract. INTEGER NULL
CONTRACT_ADDRESS This table stores addresses associated with a contract. Each address can have one Bill To and many Ship To addresses. This is enforced by the application. Contract addresses should be related to the vendors associated with the contract and not the contract itself. Each vendor may have multiple address types. K_ADDRESS_TYPE This column contains the address type: 1 = billing address; 2 = shipping address. INTEGER NULL
CONTRACT_ADDRESS This table stores addresses associated with a contract. Each address can have one Bill To and many Ship To addresses. This is enforced by the application. Contract addresses should be related to the vendors associated with the contract and not the contract itself. Each vendor may have multiple address types. K_CITY This column contains the contract company's city. VARCHAR2(30) NULL
CONTRACT_ADDRESS This table stores addresses associated with a contract. Each address can have one Bill To and many Ship To addresses. This is enforced by the application. Contract addresses should be related to the vendors associated with the contract and not the contract itself. Each vendor may have multiple address types. K_COMPANY This column contains the company name associated with the address. VARCHAR2(30) NULL
CONTRACT_ADDRESS This table stores addresses associated with a contract. Each address can have one Bill To and many Ship To addresses. This is enforced by the application. Contract addresses should be related to the vendors associated with the contract and not the contract itself. Each vendor may have multiple address types. K_FAX This column contains the contract company's FAX number. VARCHAR2(20) NULL
CONTRACT_ADDRESS This table stores addresses associated with a contract. Each address can have one Bill To and many Ship To addresses. This is enforced by the application. Contract addresses should be related to the vendors associated with the contract and not the contract itself. Each vendor may have multiple address types. K_PHONE This column contains the contract company's telephone number. VARCHAR2(20) NULL
CONTRACT_ADDRESS This table stores addresses associated with a contract. Each address can have one Bill To and many Ship To addresses. This is enforced by the application. Contract addresses should be related to the vendors associated with the contract and not the contract itself. Each vendor may have multiple address types. K_POC This column contains the name of the internal point-of-contact for the contract. VARCHAR2(30) NULL
CONTRACT_ADDRESS This table stores addresses associated with a contract. Each address can have one Bill To and many Ship To addresses. This is enforced by the application. Contract addresses should be related to the vendors associated with the contract and not the contract itself. Each vendor may have multiple address types. K_STATE This column contains the contract company's state. VARCHAR2(30) NULL
CONTRACT_ADDRESS This table stores addresses associated with a contract. Each address can have one Bill To and many Ship To addresses. This is enforced by the application. Contract addresses should be related to the vendors associated with the contract and not the contract itself. Each vendor may have multiple address types. K_STREET This column contains the contract company's street address. VARCHAR2(254) NULL
CONTRACT_ADDRESS This table stores addresses associated with a contract. Each address can have one Bill To and many Ship To addresses. This is enforced by the application. Contract addresses should be related to the vendors associated with the contract and not the contract itself. Each vendor may have multiple address types. K_ZIP This column contains the contract company's ZIP or postal code. VARCHAR2(15) NULL
CONTRACT_ADDRESS This table stores addresses associated with a contract. Each address can have one Bill To and many Ship To addresses. This is enforced by the application. Contract addresses should be related to the vendors associated with the contract and not the contract itself. Each vendor may have multiple address types. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
CONTRACT_HISTORY This table contains a log of changes to each contract. The change log record is generated by the system. A log record is created when a user makes a change to any of the vendors, when assets are associated with the contract, and when changes are made to the location, status, and point of contact (POC) for the contract. There is also a system-generated note for each log record that identifies the details of the change. A user can modify this log note through the Contracts dialog box. CONTRACT_HIST_ID This column contains a number obtained from the COUNTERS table to uniquely identify the contract history record. INTEGER NOT NULL
CONTRACT_HISTORY This table contains a log of changes to each contract. The change log record is generated by the system. A log record is created when a user makes a change to any of the vendors, when assets are associated with the contract, and when changes are made to the location, status, and point of contact (POC) for the contract. There is also a system-generated note for each log record that identifies the details of the change. A user can modify this log note through the Contracts dialog box. CONTRACT_ID This column contains the identification of the contract that was changed. INTEGER NULL
CONTRACT_HISTORY This table contains a log of changes to each contract. The change log record is generated by the system. A log record is created when a user makes a change to any of the vendors, when assets are associated with the contract, and when changes are made to the location, status, and point of contact (POC) for the contract. There is also a system-generated note for each log record that identifies the details of the change. A user can modify this log note through the Contracts dialog box. K_HIST_DATE This column contains the system date for when the contract record was changed. DATE NULL
CONTRACT_HISTORY This table contains a log of changes to each contract. The change log record is generated by the system. A log record is created when a user makes a change to any of the vendors, when assets are associated with the contract, and when changes are made to the location, status, and point of contact (POC) for the contract. There is also a system-generated note for each log record that identifies the details of the change. A user can modify this log note through the Contracts dialog box. K_HIST_NOTES This column contains notes about the contract change. VARCHAR2(254) NULL
CONTRACT_HISTORY This table contains a log of changes to each contract. The change log record is generated by the system. A log record is created when a user makes a change to any of the vendors, when assets are associated with the contract, and when changes are made to the location, status, and point of contact (POC) for the contract. There is also a system-generated note for each log record that identifies the details of the change. A user can modify this log note through the Contracts dialog box. K_HIST_STR This column contains the system-defined history log record type. Record types are: Primary vendor altered; Secondary vendor altered; Warranty vendor altered; Purchase vendor altered; Location altered; Status altered; POC altered; or Assets were added. VARCHAR2(80) NULL
CONTRACT_HISTORY This table contains a log of changes to each contract. The change log record is generated by the system. A log record is created when a user makes a change to any of the vendors, when assets are associated with the contract, and when changes are made to the location, status, and point of contact (POC) for the contract. There is also a system-generated note for each log record that identifies the details of the change. A user can modify this log note through the Contracts dialog box. K_HIST_TIME This column contains the system time for when the contract record was changed. VARCHAR2(10) NULL
CONTRACT_HISTORY This table contains a log of changes to each contract. The change log record is generated by the system. A log record is created when a user makes a change to any of the vendors, when assets are associated with the contract, and when changes are made to the location, status, and point of contact (POC) for the contract. There is also a system-generated note for each log record that identifies the details of the change. A user can modify this log note through the Contracts dialog box. MODIFY_DATETIME_28 This column contains the date and time the record was last modified. INTEGER NULL
CONTRACT_MNT This table stores maintenance events associated with a contract. CONTRACT_ID This column contains a unique number that identifies the contract the maintenance event is associated with. INTEGER NOT NULL
CONTRACT_MNT This table stores maintenance events associated with a contract. CONTRACT_MNT_ID This column contains a number obtained from the COUNTERS table to uniquely identify the contract maintenance record. Logically, the contract number, the event type, and the event date uniquely identify each record. INTEGER NOT NULL
CONTRACT_MNT This table stores maintenance events associated with a contract. CURRENCY_CODE This column contains the currency code for the estimated and actual costs of the maintenance events. VARCHAR2(3) NOT NULL
CONTRACT_MNT This table stores maintenance events associated with a contract. EVENT_ID This column contains a unique number that identifies the event code associated with the maintenance record. INTEGER NOT NULL
CONTRACT_MNT This table stores maintenance events associated with a contract. K_MNT_ACT_COST This column contains the actual cost of the maintenance event for the contract. This cost also becomes the asset level cost for each asset associated with the contract. FLOAT NULL
CONTRACT_MNT This table stores maintenance events associated with a contract. K_MNT_DATE This column contains the completion date of the maintenance event for the contract. DATE NULL
CONTRACT_MNT This table stores maintenance events associated with a contract. K_MNT_EST_COST This column contains the contract maintenance event estimated cost. FLOAT NULL
CONTRACT_MNT This table stores maintenance events associated with a contract. K_MNT_TIME This column contains the contract maintenance event time. VARCHAR2(10) NULL
CONTRACT_MNT This table stores maintenance events associated with a contract. K_TECH This column contains the name of the technician who performed the maintenance event. VARCHAR2(30) NULL
CONTRACT_MNT This table stores maintenance events associated with a contract. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
CONTRACT_STATUS This table holds status codes that are used to identify the current status of a contract. The System Administrator can add, modify, or delete status codes. The default product status codes are 'Past due', 'Renewal', and 'Pending'. CONTRACT_STATUS This column contains the name of the contract status code. VARCHAR2(18) NOT NULL
CONTRACT_STATUS This table holds status codes that are used to identify the current status of a contract. The System Administrator can add, modify, or delete status codes. The default product status codes are 'Past due', 'Renewal', and 'Pending'. CONTRACT_STATUS_ID This column contains a unique number obtained from the COUNTERS table to uniquely identify the status code. Logically, status codes are uniquely identified by the status code name. INTEGER NOT NULL
CONTRACT_STATUS This table holds status codes that are used to identify the current status of a contract. The System Administrator can add, modify, or delete status codes. The default product status codes are 'Past due', 'Renewal', and 'Pending'. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
CONTRACT_TYPES This table holds contract types used to identify the type of a contract. The default contract types are 'Warranty', 'Service', 'Lease', 'Loan', and 'Purchase'. CONTRACT_TYPE This column contains the name of the contract type. VARCHAR2(18) NOT NULL
CONTRACT_TYPES This table holds contract types used to identify the type of a contract. The default contract types are 'Warranty', 'Service', 'Lease', 'Loan', and 'Purchase'. CONTRACT_TYPE_ID This column contains the number that uniquely identifies the contract type record INTEGER NOT NULL
CONTRACT_TYPES This table holds contract types used to identify the type of a contract. The default contract types are 'Warranty', 'Service', 'Lease', 'Loan', and 'Purchase'. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
COUNTERS This table contains the sequential numbers that are used as the values for the primary key when records are inserted into tables. COUNTER_NAME This column contains the name of the entity that the sequential number relates to. VARCHAR2(15) NOT NULL
COUNTERS This table contains the sequential numbers that are used as the values for the primary key when records are inserted into tables. DBMS_SEQ_NAME This column contains the name of an Oracle sequence to be used in place of the counter table. VARCHAR2(30) NULL
COUNTERS This table contains the sequential numbers that are used as the values for the primary key when records are inserted into tables. LOCAL_CACHE_QTY This column contains the number of unique counters to be fetched each time this counter is accessed. INTEGER NULL
COUNTERS This table contains the sequential numbers that are used as the values for the primary key when records are inserted into tables. NEXT_NUMBER This column contains the number that will be used as the value for the primary key for the next record created in the table associated with the entity. INTEGER NOT NULL
CURRENCY This table contains the currency codes for the system. The administrator can add, modify, and remove currency codes. COUNTRY This column contains the name of the country for the currency code. VARCHAR2(25) NULL
CURRENCY This table contains the currency codes for the system. The administrator can add, modify, and remove currency codes. COUNTRY_CODE This column contains the keyboard code page or international country prefix for telephone numbers. INTEGER NULL
CURRENCY This table contains the currency codes for the system. The administrator can add, modify, and remove currency codes. CURRENCY_CODE This column contains the code that is used to identify the currency. VARCHAR2(3) NOT NULL
CURRENCY This table contains the currency codes for the system. The administrator can add, modify, and remove currency codes. CURRENCY_ID This column contains the unique key for identifying the currency record. INTEGER NOT NULL
CURRENCY This table contains the currency codes for the system. The administrator can add, modify, and remove currency codes. CURRENCY_NAME This column contains the name for the currency. VARCHAR2(25) NULL
CURRENCY This table contains the currency codes for the system. The administrator can add, modify, and remove currency codes. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
DB_INI This table contains ini settings that cannot be written to a local file due to web enablement. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
DB_INI This table contains ini settings that cannot be written to a local file due to web enablement. SECTIONNAME This column contains an identifier for the part of the application with which the setting is associated. VARCHAR2(30) NOT NULL
DB_INI This table contains ini settings that cannot be written to a local file due to web enablement. SETTING This column contains the name of the setting. VARCHAR2(30) NOT NULL
DB_INI This table contains ini settings that cannot be written to a local file due to web enablement. SETTINGVALUE This column contains the value for the setting. VARCHAR2(30) NOT NULL
DB_INI This table contains ini settings that cannot be written to a local file due to web enablement. USER_ID This column contins a user ID that the setting applies to. VARCHAR2(30) NOT NULL
DDVIEWS This table contains the valid data views available from all data viewers (problem, change, users. and so on). BASECONDITION This column contains a SQL Where string that defines the total set of data viewable by the current DDView. All nodes contained in the tree that this DDView represents will have data that is contained within the set of data that a query using this Where statement returns. VARCHAR2(254) NULL
DDVIEWS This table contains the valid data views available from all data viewers (problem, change, users. and so on). CONTEXT This column contains a string defining the place where this view is used. This allows the user to have a different set of views when viewing different types of data. VARCHAR2(50) NULL
DDVIEWS This table contains the valid data views available from all data viewers (problem, change, users. and so on). DDLIST This column defines the columns that will be displayed in the data viewer. VARCHAR2(254) NULL
DDVIEWS This table contains the valid data views available from all data viewers (problem, change, users. and so on). FILTERFORM Future use. VARCHAR2(50) NULL
DDVIEWS This table contains the valid data views available from all data viewers (problem, change, users. and so on). FILTERFUNC Future use. VARCHAR2(50) NULL
DDVIEWS This table contains the valid data views available from all data viewers (problem, change, users. and so on). IS_TEMPLATE This column marks a view as a template view. A template view is one which can be used to instantiate other views. Template views appear in the Date Viewer Wizard as possible types to be used. INTEGER NULL
DDVIEWS This table contains the valid data views available from all data viewers (problem, change, users. and so on). MCLB_NAME This column contains the name of the Multi Column List Box that will be populated with data upon selecting a data viewer folder. The data viewer will perform a DlgSQLSelect into the MCLB. VARCHAR2(30) NULL
DDVIEWS This table contains the valid data views available from all data viewers (problem, change, users. and so on). OWNER This column contains the user ID of the user that owns this view. If the owner is $PUBLIC_VIEW then all users will be able to see the view. VARCHAR2(20) NOT NULL
DDVIEWS This table contains the valid data views available from all data viewers (problem, change, users. and so on). RESULT_TABLE This column contains the table that is being viewed in the MCLB. VARCHAR2(30) NOT NULL
DDVIEWS This table contains the valid data views available from all data viewers (problem, change, users. and so on). SQLTEMPLATE This column contains a string that serves as a template that the viewer can use to create a complete SQL select statement. LONG VARCHAR NOT NULL
DDVIEWS This table contains the valid data views available from all data viewers (problem, change, users. and so on). SUBFORM Ths column contains an optional dialog form specification that will be used in a DlgLoadSubform function to replace a form on the dialog box with the specified form. VARCHAR2(50) NULL
DDVIEWS This table contains the valid data views available from all data viewers (problem, change, users. and so on). SUPERTYPE This column contains the form that this viewer is derived from. VARCHAR2(50) NULL
DDVIEWS This table contains the valid data views available from all data viewers (problem, change, users. and so on). TBNAME This column contains the table that the data viewer is viewing in the tree. VARCHAR2(30) NOT NULL
DDVIEWS This table contains the valid data views available from all data viewers (problem, change, users. and so on). VIEWACCESS Future use. INTEGER NULL
DDVIEWS This table contains the valid data views available from all data viewers (problem, change, users. and so on). VIEWID This column contains the unique identifier of the view. INTEGER NOT NULL
DDVIEWS This table contains the valid data views available from all data viewers (problem, change, users. and so on). VIEWNAME This column contains the user defined name of the view. VARCHAR2(50) NOT NULL
DDVIEWS This table contains the valid data views available from all data viewers (problem, change, users. and so on). WIZARDFORM This column contains the name of the dialog form that will be displayed on the fourth page of the View Wizard. VARCHAR2(50) NULL
DDVIEWS This table contains the valid data views available from all data viewers (problem, change, users. and so on). WIZARDFUNC This column contains the name of the function that will be used to process the fourth page of the View Wizard. VARCHAR2(50) NULL
ENTITY This table contains groups of functionally related features for the Tivoli Service Desk products. ENTITY_FILE This column contains the name of the .kb file that loads the code required for this grouping of functionality. VARCHAR2(80) NOT NULL
ENTITY This table contains groups of functionally related features for the Tivoli Service Desk products. ENTITY_ID This column contains the unique key for identifying the entity record. INTEGER NOT NULL
ENTITY This table contains groups of functionally related features for the Tivoli Service Desk products. ENTITY_NAME This column contains the user-assigned name for the functionality grouping. VARCHAR2(80) NOT NULL
ENTITY This table contains groups of functionally related features for the Tivoli Service Desk products. ENTITY_TYPE This column contains records that identify whether the entity is system- or user-defined. System-defined entities are installed with the product and have a value of 1. INTEGER NOT NULL
ENTITY This table contains groups of functionally related features for the Tivoli Service Desk products. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
ENTITY_ACTION This table is a cross-reference between the Entities table and the System Actions table. ACTION_ID This column contains the primary key for the system action record. INTEGER NOT NULL
ENTITY_ACTION This table is a cross-reference between the Entities table and the System Actions table. ENTITY_ACTION_ID This column contains the unique key for identifying the entity-action cross reference record. INTEGER NOT NULL
ENTITY_ACTION This table is a cross-reference between the Entities table and the System Actions table. ENTITY_ID This column contains the primary key for the entity record. INTEGER NOT NULL
ENTITY_ACTION This table is a cross-reference between the Entities table and the System Actions table. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
ESCALATION_LOG This table contains entries for all objects currently in the escalation process. CHANGE_CATEGORY This column contains the category of an associated change. VARCHAR2(18) NULL
ESCALATION_LOG This table contains entries for all objects currently in the escalation process. ESC_LEVEL This column contains the level to which the record has been esalated. INTEGER NOT NULL
ESCALATION_LOG This table contains entries for all objects currently in the escalation process. ESC_LOG_ID This column contains the uniqe ID of this escalation record. INTEGER NOT NULL
ESCALATION_LOG This table contains entries for all objects currently in the escalation process. ESC_LOG_STATE This column contains a numeric value indicating the current state of the escalation record. INTEGER NULL
ESCALATION_LOG This table contains entries for all objects currently in the escalation process. ESC_NEXT_DATE This column contains the date that the record will next be escalated. DATE NULL
ESCALATION_LOG This table contains entries for all objects currently in the escalation process. ESC_NEXT_TIME This column contains the time that the record will next be escalated. VARCHAR2(10) NULL
ESCALATION_LOG This table contains entries for all objects currently in the escalation process. ESC_RULE_ID_2 This column contains the rule associated with the entry if it applies to a change. INTEGER NULL
ESCALATION_LOG This table contains entries for all objects currently in the escalation process. ESC_TYPE_ID This column contains an identifier describing what type of record this escalation applies to. INTEGER NULL
ESCALATION_LOG This table contains entries for all objects currently in the escalation process. PEOPLE_ID This column contains the uniqe identifier of the person responsible for the entry. INTEGER NULL
ESCALATION_LOG This table contains entries for all objects currently in the escalation process. REFERENCE_ID This column contains the uniqe identifier of the call or problem this record is associated with. VARCHAR2(30) NULL
ESCALATION_LOG This table contains entries for all objects currently in the escalation process. REFERENCE_ID_INT This column indicates that the reference ID is a string or an integer. INTEGER NULL
ESCALATION_LOG This table contains entries for all objects currently in the escalation process. SECONDARY_REF_ID This column contains the unique identifier of a change that this escalation is associated with. VARCHAR2(80) NULL
ESCALATION_LOG This table contains entries for all objects currently in the escalation process. SEVERITY This column contains the severity of the associated problem. INTEGER NULL
ESCALATION_LOG This table contains entries for all objects currently in the escalation process. USER_ID_2 This column contains the user ID of a user associated with the change. VARCHAR2(15) NULL
ESCALATION_RULES This table contains all escalation rules. CHANGE_CATEGORY_2 This column contains the change category which this escalation rule applies to, if any. VARCHAR2(18) NULL
ESCALATION_RULES This table contains all escalation rules. CONDITION This column contains the where condition used to determine if this rule applies to a particular record. VARCHAR2(1024) NULL
ESCALATION_RULES This table contains all escalation rules. DESCRIPTION This column contains a text description of the rule. VARCHAR2(1024) NULL
ESCALATION_RULES This table contains all escalation rules. ESC_INTERVAL This column contains the time interval to apply when this rule is used. INTEGER NOT NULL
ESCALATION_RULES This table contains all escalation rules. ESC_LEVEL This column contains the level in a chain of escalations to which this rule is assigned. INTEGER NOT NULL
ESCALATION_RULES This table contains all escalation rules. ESC_RULE_ID This column contains the unique identifier of this rule. INTEGER NOT NULL
ESCALATION_RULES This table contains all escalation rules. ESC_TITLE This column contains the title of this rule. VARCHAR2(15) NULL
ESCALATION_RULES This table contains all escalation rules. ESC_TYPE_ID This column indicates the type of record that this rule applies to. INTEGER NULL
ESCALATION_RULES This table contains all escalation rules. NOTIFY_APPROVER This column indicates to notify the aprover associated with a change this rule applies to. SMALLINT NULL
ESCALATION_RULES This table contains all escalation rules. NOTIFY_ASSIGNED_TO This column indicates to notify the transfer assignee of the associated record when this rule activates. SMALLINT NULL
ESCALATION_RULES This table contains all escalation rules. NOTIFY_CHANGE_ADMN This column indicates to notify the administrator of the change when this rule activates. SMALLINT NULL
ESCALATION_RULES This table contains all escalation rules. NOTIFY_OWNER This column indicates to notify the owner of the associated record when this rule activates. SMALLINT NULL
ESCALATION_RULES This table contains all escalation rules. NOTIFY_RESOURCES This column indicates to notify other resources (people/groups) when this rule is applied to a change. SMALLINT NULL
ESCALATION_RULES This table contains all escalation rules. SEVERITY This column contains the severity of records to apply this rule to. INTEGER NULL
ESCALATION_RULES This table contains all escalation rules. SORT_ORDER This column indicates the order this rule is to be applied relative to other rules that might also apply. INTEGER NULL
ESCALATION_RULES This table contains all escalation rules. START_DATE_TYPE This column indicates the change start type for this rule. INTEGER NULL
ESCALATION_TYPES This table contains the types of escalations possible (call, problem, and so on). DESCRIPTION This column contains the text description of this escalation type. VARCHAR2(1024) NULL
ESCALATION_TYPES This table contains the types of escalations possible (call, problem, and so on). ESC_TYPE_ID This column contains the unique ID of this entry. INTEGER NOT NULL
ESCALATION_TYPES This table contains the types of escalations possible (call, problem, and so on). KEY_NAME This column contains the column name for the table that this type references. VARCHAR2(30) NOT NULL
ESCALATION_TYPES This table contains the types of escalations possible (call, problem, and so on). KEY_TYPE This column contains the data type of the column referenced by KEY_NAME. VARCHAR2(15) NOT NULL
ESCALATION_TYPES This table contains the types of escalations possible (call, problem, and so on). SECONDARY_KEY_NAME This column contains the column name for a second column identifying rows in the table this type references. VARCHAR2(30) NULL
ESCALATION_TYPES This table contains the types of escalations possible (call, problem, and so on). SECONDARY_KEY_TYPE This column contains the data type of the column referenced by SECONDARY_KEY_NAME. VARCHAR2(15) NULL
ESCALATION_TYPES This table contains the types of escalations possible (call, problem, and so on). TABLE_NAME This column contains the name of the table this type references. VARCHAR2(30) NOT NULL
ESCALATION_USERS This table contains entries for valid users to receive escalations. ESC_RULE_ID This column contains the unique rule ID this record is associated with. INTEGER NULL
ESCALATION_USERS This table contains entries for valid users to receive escalations. NOTIFICATION_TYPE This column contains the notification method to use. VARCHAR2(15) NULL
ESCALATION_USERS This table contains entries for valid users to receive escalations. NOTIFY_GROUP_ID This column contains the group ID of the group to be notified. VARCHAR2(15) NULL
ESCALATION_USERS This table contains entries for valid users to receive escalations. NOTIFY_USER_ID This column contains the user ID of the user to be notified. VARCHAR2(15) NULL
ESCALATION_USERS This table contains entries for valid users to receive escalations. PEOPLE_ID This column contains the person ID of the person to be notified. INTEGER NULL
EVENTS This table holds asset event codes for planned and completed asset events and Contract Maintenance events. Tivoli Change Management uses the event code "Affected By Change" and "Moved" when creating planned and completed events for assets affected by changes. EVENT_DESCRIPTION Description for the event code VARCHAR2(80) NULL
EVENTS This table holds asset event codes for planned and completed asset events and Contract Maintenance events. Tivoli Change Management uses the event code "Affected By Change" and "Moved" when creating planned and completed events for assets affected by changes. EVENT_ID Uniquely identifies the event record. This value is obtained from the COUNTERS table. INTEGER NOT NULL
EVENTS This table holds asset event codes for planned and completed asset events and Contract Maintenance events. Tivoli Change Management uses the event code "Affected By Change" and "Moved" when creating planned and completed events for assets affected by changes. EVENT_NAME Name of the event VARCHAR2(40) NOT NULL
EVENTS This table holds asset event codes for planned and completed asset events and Contract Maintenance events. Tivoli Change Management uses the event code "Affected By Change" and "Moved" when creating planned and completed events for assets affected by changes. EVENT_OWNER Identifies the "object" that the event is used for. VARCHAR2(20) NOT NULL
EVENTS This table holds asset event codes for planned and completed asset events and Contract Maintenance events. Tivoli Change Management uses the event code "Affected By Change" and "Moved" when creating planned and completed events for assets affected by changes. EVENT_TYPE VARCHAR2(40) NOT NULL
EVENTS This table holds asset event codes for planned and completed asset events and Contract Maintenance events. Tivoli Change Management uses the event code "Affected By Change" and "Moved" when creating planned and completed events for assets affected by changes. MODIFY_DATETIME Date and time that the record was last modified. INTEGER NOT NULL
EWEB_ORG_RIGHTS This table contains the rights associated to an organization when using web access. CREATE_RIGHT This column contains the create problem rights associated with the organization. SMALLINT NULL
EWEB_ORG_RIGHTS This table contains the rights associated to an organization when using web access. DIAG_RIGHT This column contains the diagnostic rights (viewable diagnostics) associated with this organization. INTEGER NULL
EWEB_ORG_RIGHTS This table contains the rights associated to an organization when using web access. ORGANIZATION_ID This column contains the ID of the organization these rights belong to. VARCHAR2(15) NOT NULL
EWEB_ORG_RIGHTS This table contains the rights associated to an organization when using web access. UPDATE_RIGHT This column contains the type of updates that can be performed by this organization (my own, my organization, all). INTEGER NULL
EWEB_ORG_RIGHTS This table contains the rights associated to an organization when using web access. VIEW_RIGHT This column contains the problem view rights associated with this organization (my own, my organization, all). INTEGER NULL
EWEB_USER_RIGHTS This table contains the rights associated to a contact when using web access. A_UNTIL_REV This column indicates that the web user is anonymous until reviewed. SMALLINT NOT NULL
EWEB_USER_RIGHTS This table contains the rights associated to a contact when using web access. CREATE_RIGHT This column indicates that the web user can create problems. SMALLINT NULL
EWEB_USER_RIGHTS This table contains the rights associated to a contact when using web access. DIAG_RIGHT This column contains the web user's diagnostic rights. INTEGER NULL
EWEB_USER_RIGHTS This table contains the rights associated to a contact when using web access. MAX_DIAGNOSTICS This column contains the maximum number of diagnostics the user can view at one time. INTEGER NOT NULL
EWEB_USER_RIGHTS This table contains the rights associated to a contact when using web access. PEOPLE_ID This column contains the ID of the people record for this web user. INTEGER NOT NULL
EWEB_USER_RIGHTS This table contains the rights associated to a contact when using web access. UPDATE_RIGHT This column contains the update rights for the user (my own, my organization, all). INTEGER NULL
EWEB_USER_RIGHTS This table contains the rights associated to a contact when using web access. VIEW_RIGHT This column contains the problem view rights for the user (my own, my organization, all). INTEGER NULL
EWEB_USER_RIGHTS This table contains the rights associated to a contact when using web access. WEB_ID This column contains the web ID for the TPM End-user Web Interface user. VARCHAR2(20) NOT NULL
GROUPS This table stores all group proflie information. GROUP_ID This column contains the unique group identification. VARCHAR2(15) NOT NULL
GROUPS This table stores all group proflie information. GROUP_NAME This column contains the group name. VARCHAR2(40) NOT NULL
GROUPS This table stores all group proflie information. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
GROUPS This table stores all group proflie information. PROFILE_ID This column contains the group's profile identification. INTEGER NULL
GROUPS This table stores all group proflie information. SECURITY_MASK Identifies the rights that have been assigned to the group. INTEGER NOT NULL
GROUPS This table stores all group proflie information. SITE_ID This column contains the group's site identification. VARCHAR2(6) NOT NULL
ICONBAR This table contains the configuration of the Tivoli Service Desk button bar for each toolbar profile. ICON_FILE This column contains the name of the file that contains the image that will be displayed as the toolbar button. VARCHAR2(80) NOT NULL
ICONBAR This table contains the configuration of the Tivoli Service Desk button bar for each toolbar profile. ICON_NUMBER This column contains the position of the button on the toolbar. INTEGER NOT NULL
ICONBAR This table contains the configuration of the Tivoli Service Desk button bar for each toolbar profile. ICON_TEXT This column contains the text that is displayed to the user when the cursor is positioned over the toolbar button VARCHAR2(80) NULL
ICONBAR This table contains the configuration of the Tivoli Service Desk button bar for each toolbar profile. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
ICONBAR This table contains the configuration of the Tivoli Service Desk button bar for each toolbar profile. PROFILE_ID This column contains the value that identifies the profile that this IconBar record belongs to. INTEGER NOT NULL
ICONBAR This table contains the configuration of the Tivoli Service Desk button bar for each toolbar profile. PUBLIC_ACTION_ID This column contains the value that identifies the system action that will be invoked when the user clicks on this toobar button. INTEGER NULL
ITEM This table contains Tivoli Problem Management - SCIM --> Specific brand or model of the product supported by the help desk. An example item could be Vivitron 1776 for a component of type Monitor. COMPONENT_ID This column contains the ID of the component to which this item belongs in the equipment hierarchy. VARCHAR2(15) NOT NULL
ITEM This table contains Tivoli Problem Management - SCIM --> Specific brand or model of the product supported by the help desk. An example item could be Vivitron 1776 for a component of type Monitor. DESCRIPTION This column contains a text description of this item. VARCHAR2(1024) NULL
ITEM This table contains Tivoli Problem Management - SCIM --> Specific brand or model of the product supported by the help desk. An example item could be Vivitron 1776 for a component of type Monitor. ITEM_ID This column contains the ID of this item. Together, SYSTEM_ID, COMPONENT_ID, and ITEM_ID uniqely define this entry. CHAR(18) NOT NULL
ITEM This table contains Tivoli Problem Management - SCIM --> Specific brand or model of the product supported by the help desk. An example item could be Vivitron 1776 for a component of type Monitor. MFG This column contains the manufacturers name for this item. VARCHAR2(1024) NULL
ITEM This table contains Tivoli Problem Management - SCIM --> Specific brand or model of the product supported by the help desk. An example item could be Vivitron 1776 for a component of type Monitor. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
ITEM This table contains Tivoli Problem Management - SCIM --> Specific brand or model of the product supported by the help desk. An example item could be Vivitron 1776 for a component of type Monitor. PART_NO This column contains the vendor's part number for this item. VARCHAR2(25) NULL
ITEM This table contains Tivoli Problem Management - SCIM --> Specific brand or model of the product supported by the help desk. An example item could be Vivitron 1776 for a component of type Monitor. SYSTEM_ID This column contains the ID of the system with which this item is associated. VARCHAR2(15) NOT NULL
ITEM This table contains Tivoli Problem Management - SCIM --> Specific brand or model of the product supported by the help desk. An example item could be Vivitron 1776 for a component of type Monitor. VENDOR_ID This column contains the ID of the vendor for this item. VARCHAR2(15) NULL
LOCATION This table stores the locations in use by the system. Locations are hierarchical and are used by Tivoli Asset Management to track the location of an asset and are used by Tivoli Problem Management to identify the location of the caller reporting a problem. ADDRESS This column contains the location's street address. VARCHAR2(254) NULL
LOCATION This table stores the locations in use by the system. Locations are hierarchical and are used by Tivoli Asset Management to track the location of an asset and are used by Tivoli Problem Management to identify the location of the caller reporting a problem. CITY This column contains the location's city. VARCHAR2(40) NULL
LOCATION This table stores the locations in use by the system. Locations are hierarchical and are used by Tivoli Asset Management to track the location of an asset and are used by Tivoli Problem Management to identify the location of the caller reporting a problem. FAX_NUMBER This column contains the location's FAX number. VARCHAR2(20) NULL
LOCATION This table stores the locations in use by the system. Locations are hierarchical and are used by Tivoli Asset Management to track the location of an asset and are used by Tivoli Problem Management to identify the location of the caller reporting a problem. FLX_LOC_DATE1 This column contains a date field for customization purposes. DATE NULL
LOCATION This table stores the locations in use by the system. Locations are hierarchical and are used by Tivoli Asset Management to track the location of an asset and are used by Tivoli Problem Management to identify the location of the caller reporting a problem. FLX_LOC_DATE2 This column contains a date field for customization purposes. DATE NULL
LOCATION This table stores the locations in use by the system. Locations are hierarchical and are used by Tivoli Asset Management to track the location of an asset and are used by Tivoli Problem Management to identify the location of the caller reporting a problem. FLX_LOC_INT1 This column contains an integer field for customization purposes. INTEGER NULL
LOCATION This table stores the locations in use by the system. Locations are hierarchical and are used by Tivoli Asset Management to track the location of an asset and are used by Tivoli Problem Management to identify the location of the caller reporting a problem. FLX_LOC_INT2 This column contains an integer field for customization purposes. INTEGER NULL
LOCATION This table stores the locations in use by the system. Locations are hierarchical and are used by Tivoli Asset Management to track the location of an asset and are used by Tivoli Problem Management to identify the location of the caller reporting a problem. FLX_LOC_INT3 This column contains an integer field for customization purposes. INTEGER NULL
LOCATION This table stores the locations in use by the system. Locations are hierarchical and are used by Tivoli Asset Management to track the location of an asset and are used by Tivoli Problem Management to identify the location of the caller reporting a problem. FLX_LOC_INT4 This column contains an integer field for customization purposes. INTEGER NULL
LOCATION This table stores the locations in use by the system. Locations are hierarchical and are used by Tivoli Asset Management to track the location of an asset and are used by Tivoli Problem Management to identify the location of the caller reporting a problem. FLX_LOC_TIME1 This column contains a time field for customization purposes. VARCHAR2(10) NULL
LOCATION This table stores the locations in use by the system. Locations are hierarchical and are used by Tivoli Asset Management to track the location of an asset and are used by Tivoli Problem Management to identify the location of the caller reporting a problem. FLX_LOC_TIME2 This column contains a time field for customization purposes. VARCHAR2(10) NULL
LOCATION This table stores the locations in use by the system. Locations are hierarchical and are used by Tivoli Asset Management to track the location of an asset and are used by Tivoli Problem Management to identify the location of the caller reporting a problem. FLX_LOC_VCHR1 This column contains a 250-character field for customization purposes. VARCHAR2(250) NULL
LOCATION This table stores the locations in use by the system. Locations are hierarchical and are used by Tivoli Asset Management to track the location of an asset and are used by Tivoli Problem Management to identify the location of the caller reporting a problem. FLX_LOC_VCHR2 This column contains a 250-character field for customization purposes. VARCHAR2(250) NULL
LOCATION This table stores the locations in use by the system. Locations are hierarchical and are used by Tivoli Asset Management to track the location of an asset and are used by Tivoli Problem Management to identify the location of the caller reporting a problem. FLX_LOC_VCHR3 This column contains a 250-character field for customization purposes. VARCHAR2(250) NULL
LOCATION This table stores the locations in use by the system. Locations are hierarchical and are used by Tivoli Asset Management to track the location of an asset and are used by Tivoli Problem Management to identify the location of the caller reporting a problem. FLX_LOC_VCHR4 This column contains a 250-character field for customization purposes. VARCHAR2(250) NULL
LOCATION This table stores the locations in use by the system. Locations are hierarchical and are used by Tivoli Asset Management to track the location of an asset and are used by Tivoli Problem Management to identify the location of the caller reporting a problem. LOCATION_ID This column contains the unique location identification. VARCHAR2(15) NOT NULL
LOCATION This table stores the locations in use by the system. Locations are hierarchical and are used by Tivoli Asset Management to track the location of an asset and are used by Tivoli Problem Management to identify the location of the caller reporting a problem. LOCATION_NAME This column contains the location name. VARCHAR2(40) NOT NULL
LOCATION This table stores the locations in use by the system. Locations are hierarchical and are used by Tivoli Asset Management to track the location of an asset and are used by Tivoli Problem Management to identify the location of the caller reporting a problem. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
LOCATION This table stores the locations in use by the system. Locations are hierarchical and are used by Tivoli Asset Management to track the location of an asset and are used by Tivoli Problem Management to identify the location of the caller reporting a problem. ORGANIZATION_ID This column contains the unique organization identification. VARCHAR2(15) NULL
LOCATION This table stores the locations in use by the system. Locations are hierarchical and are used by Tivoli Asset Management to track the location of an asset and are used by Tivoli Problem Management to identify the location of the caller reporting a problem. PHONE_NUMBER This column contains the location's telephone number. VARCHAR2(20) NULL
LOCATION This table stores the locations in use by the system. Locations are hierarchical and are used by Tivoli Asset Management to track the location of an asset and are used by Tivoli Problem Management to identify the location of the caller reporting a problem. STATE This column contains the location's state. VARCHAR2(40) NULL
LOCATION This table stores the locations in use by the system. Locations are hierarchical and are used by Tivoli Asset Management to track the location of an asset and are used by Tivoli Problem Management to identify the location of the caller reporting a problem. TIMEZONE_ID This column contains the identification of the time zone associated with the location. VARCHAR2(30) NULL
LOCATION This table stores the locations in use by the system. Locations are hierarchical and are used by Tivoli Asset Management to track the location of an asset and are used by Tivoli Problem Management to identify the location of the caller reporting a problem. VISIBLE This column indicates whether the location is visible to Tivoli Problem Management users. SMALLINT NULL
LOCATION This table stores the locations in use by the system. Locations are hierarchical and are used by Tivoli Asset Management to track the location of an asset and are used by Tivoli Problem Management to identify the location of the caller reporting a problem. ZIP This column contains the location's ZIP or postal code. VARCHAR2(40) NULL
LOCATION_TREE This table contains a directed acyclic graph containing the location hierarchy. Tivoli Asset Management allows an unlimited number of location levels by maintaining a parent-child relationship for each node in the tree (graph). CHILD This column contains the value of the unique key for the location that is the child node in the tree. VARCHAR2(15) NOT NULL
LOCATION_TREE This table contains a directed acyclic graph containing the location hierarchy. Tivoli Asset Management allows an unlimited number of location levels by maintaining a parent-child relationship for each node in the tree (graph). MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
LOCATION_TREE This table contains a directed acyclic graph containing the location hierarchy. Tivoli Asset Management allows an unlimited number of location levels by maintaining a parent-child relationship for each node in the tree (graph). PARENT This column contains the value of the unique key for the location that is the parent node in the tree. VARCHAR2(15) NOT NULL
MEMBER_OF This table contains records that identify the group memberships for Tivoli Service Desk users. DEFAULT_GROUP Identifies if the group is the default group for the user. INTEGER NOT NULL
MEMBER_OF This table contains records that identify the group memberships for Tivoli Service Desk users. GROUP_ID This column contains the identification of the group in the member/group relationship. VARCHAR2(15) NOT NULL
MEMBER_OF This table contains records that identify the group memberships for Tivoli Service Desk users. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
MEMBER_OF This table contains records that identify the group memberships for Tivoli Service Desk users. SITE_ID This column contains the group's site identification. VARCHAR2(6) NOT NULL
MEMBER_OF This table contains records that identify the group memberships for Tivoli Service Desk users. USER_ID This column contains the group member's user identification. VARCHAR2(15) NOT NULL
MENUBAR This table contains the configuration of the menu bar for each toolbar profile. MENU_NUMBER This column contains records that identify the position of the menu item within the menu bar. A number of 202 indicates that the menu item is in column 2, row 2. INTEGER NOT NULL
MENUBAR This table contains the configuration of the menu bar for each toolbar profile. MENU_TEXT This column contains the menu text that is displayed for the menu item on the menu bar. VARCHAR2(254) NOT NULL
MENUBAR This table contains the configuration of the menu bar for each toolbar profile. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
MENUBAR This table contains the configuration of the menu bar for each toolbar profile. PROFILE_ID This column contains the value that identifies the profile that this MenuBar record belongs to. INTEGER NOT NULL
MENUBAR This table contains the configuration of the menu bar for each toolbar profile. SYSTEM_ACTION_ID This column contains the value that identifies the system action that will be invoked when the user clicks on this menu item. INTEGER NULL
MODULE This table contains Tivoli Problem Management SCIM. This includes specific brand names or model numbers of the product supported by the help desk. An example of a module for the item 'Vivitron 1776' could be Power Switch. COMPONENT_ID This column contains the ID of the component this module is associated with. VARCHAR2(15) NOT NULL
MODULE This table contains Tivoli Problem Management SCIM. This includes specific brand names or model numbers of the product supported by the help desk. An example of a module for the item 'Vivitron 1776' could be Power Switch. DESCRIPTION This column contains a text description of this module. VARCHAR2(1024) NULL
MODULE This table contains Tivoli Problem Management SCIM. This includes specific brand names or model numbers of the product supported by the help desk. An example of a module for the item 'Vivitron 1776' could be Power Switch. ITEM_ID This column contains the ID of the item this module is associated with. CHAR(18) NOT NULL
MODULE This table contains Tivoli Problem Management SCIM. This includes specific brand names or model numbers of the product supported by the help desk. An example of a module for the item 'Vivitron 1776' could be Power Switch. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
MODULE This table contains Tivoli Problem Management SCIM. This includes specific brand names or model numbers of the product supported by the help desk. An example of a module for the item 'Vivitron 1776' could be Power Switch. MODULE_ID This column contains the ID of this module. Together, SYTEM_ID, COMPONENT_ID, ITEM_ID, and MODULE_ID uniquely identify this record. VARCHAR2(15) NOT NULL
MODULE This table contains Tivoli Problem Management SCIM. This includes specific brand names or model numbers of the product supported by the help desk. An example of a module for the item 'Vivitron 1776' could be Power Switch. SYSTEM_ID This column contains the ID of the system this module is associated with. VARCHAR2(15) NOT NULL
NOTIFICATIONS This table contains all pending notifications. ADDRESS This column contains the the notification is to be delivered to. VARCHAR2(80) NOT NULL
NOTIFICATIONS This table contains all pending notifications. FWD_USER_ID This column contains the user ID the notification was forwarded to. VARCHAR2(15) NULL
NOTIFICATIONS This table contains all pending notifications. LOCATION_ID This column contains the location ID of the recipient contact. VARCHAR2(15) NULL
NOTIFICATIONS This table contains all pending notifications. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
NOTIFICATIONS This table contains all pending notifications. NOTIFICATION_DATE This column contains the date the notification is to be delivered. DATE NOT NULL
NOTIFICATIONS This table contains all pending notifications. NOTIFICATION_ID This column contains the unique ID of the notification record. INTEGER NOT NULL
NOTIFICATIONS This table contains all pending notifications. NOTIFICATION_TEXT This column contains the text of the notification. VARCHAR2(1024) NULL
NOTIFICATIONS This table contains all pending notifications. NOTIFICATION_TIME This column contains the time the notification is to be delivered. VARCHAR2(10) NOT NULL
NOTIFICATIONS This table contains all pending notifications. NOTIFICATION_TTL This column contains the title of the notification message. VARCHAR2(40) NULL
NOTIFICATIONS This table contains all pending notifications. NOTIFICATION_TYPE This column contains the type of the notification. VARCHAR2(15) NULL
NOTIFICATIONS This table contains all pending notifications. PEOPLE_ID This column contains the uniqe people ID of the person to be notified. INTEGER NULL
NOTIFICATIONS This table contains all pending notifications. RCV_GROUP_ID This column contains the ID of the group to be notified. VARCHAR2(15) NULL
NOTIFICATIONS This table contains all pending notifications. RCV_USER_ID This column contains the ID of the user to be notified. VARCHAR2(15) NULL
NOTIFICATIONS This table contains all pending notifications. REGARDING This column contains the subject of the notification. VARCHAR2(20) NULL
NOTIFICATIONS This table contains all pending notifications. SET_DATE This column contains the date that the notification was created. DATE NULL
NOTIFICATIONS This table contains all pending notifications. SET_TIME This column contains the time that the notification was created. VARCHAR2(10) NULL
NOTIFICATIONS This table contains all pending notifications. SND_USER_ID This column contains the ID of the user sending the notification. VARCHAR2(15) NULL
NOTIFY_TYPES This table stores the valid notification types. ALLOWS_GROUPS This column indicates if notifications using this type can be sent to groups. SMALLINT NOT NULL
NOTIFY_TYPES This table stores the valid notification types. NOTIFICATION_DESC This column contains a description of the notification type. VARCHAR2(80) NULL
NOTIFY_TYPES This table stores the valid notification types. NOTIFICATION_FUNC This column contains the function that will be invoked to deliver notifications of this type. VARCHAR2(80) NOT NULL
NOTIFY_TYPES This table stores the valid notification types. NOTIFICATION_TYPE This column contains the unique notification type identification. VARCHAR2(15) NOT NULL
NOTIFY_USER_GROUP This table contains all the valid notification methods for each user or group. ADDRESS This column contains the address used to deliver notifications to for a user or group. VARCHAR2(80) NULL
NOTIFY_USER_GROUP This table contains all the valid notification methods for each user or group. IS_DEFAULT This column indicates that this is the default notification type for the user or group. SMALLINT NOT NULL
NOTIFY_USER_GROUP This table contains all the valid notification methods for each user or group. IS_GROUP This column indicates that the entry is for a group. SMALLINT NOT NULL
NOTIFY_USER_GROUP This table contains all the valid notification methods for each user or group. LOCATION_ID This column contains the location ID for a contact if this record defines a contact. VARCHAR2(15) NULL
NOTIFY_USER_GROUP This table contains all the valid notification methods for each user or group. NOTIFICATION_TYPE This column contains the type of notification to send to this contact, user, or group. VARCHAR2(15) NULL
NOTIFY_USER_GROUP This table contains all the valid notification methods for each user or group. NOTIFY_ID This column contains the uniqe ID for this delivery option. INTEGER NOT NULL
NOTIFY_USER_GROUP This table contains all the valid notification methods for each user or group. PEOPLE_ID This column contains the id of the person to notify. INTEGER NULL
NOTIFY_USER_GROUP This table contains all the valid notification methods for each user or group. USER_GROUP_ID This column contains the id of a contact, user, or group this delivery option applies to. VARCHAR2(15) NULL
ORG_MEMBERSHIP This table stores information about organization memberships. DEFAULT_ORG This column contains the default organization identification. SMALLINT NULL
ORG_MEMBERSHIP This table stores information about organization memberships. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
ORG_MEMBERSHIP This table stores information about organization memberships. ORG_MEMBER_ID This column contains the unique organization membership identification. INTEGER NOT NULL
ORG_MEMBERSHIP This table stores information about organization memberships. ORGANIZATION_ID This column contains the organization identification. VARCHAR2(15) NULL
ORG_MEMBERSHIP This table stores information about organization memberships. PEOPLE_ID This column contains the persons' (member's) identification. INTEGER NULL
ORG_MEMBERSHIP This table stores information about organization memberships. TITLE_HOLDER This column indicates whether the member is a title holder within the organization. SMALLINT NULL
ORG_SETTING MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
ORG_SETTING ORGANIZATION_ID This column contains the unique organization identification. VARCHAR2(15) NOT NULL
ORG_SETTING PARAMNAME This column contains the parameter name. VARCHAR2(50) NOT NULL
ORG_SETTING PARAMVALUE This column contains the parameter value. VARCHAR2(50) NOT NULL
ORGANIZATION This table stores information about a defined group within the company that has responsibility for assets. Organizations may be hierarchical to identify the companies, divisions, departments, and units. The structure of the organization hierarchy may be similar to the company organization chart. FLX_ORG_VCHR1 This column contains a 254-character field for customization purposes. VARCHAR2(254) NULL
ORGANIZATION This table stores information about a defined group within the company that has responsibility for assets. Organizations may be hierarchical to identify the companies, divisions, departments, and units. The structure of the organization hierarchy may be similar to the company organization chart. FLX_ORG_VCHR2 This column contains a 254-character field for customization purposes. VARCHAR2(254) NULL
ORGANIZATION This table stores information about a defined group within the company that has responsibility for assets. Organizations may be hierarchical to identify the companies, divisions, departments, and units. The structure of the organization hierarchy may be similar to the company organization chart. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
ORGANIZATION This table stores information about a defined group within the company that has responsibility for assets. Organizations may be hierarchical to identify the companies, divisions, departments, and units. The structure of the organization hierarchy may be similar to the company organization chart. ORGANIZATION_ID This column contains the unique organization identification. VARCHAR2(15) NOT NULL
ORGANIZATION This table stores information about a defined group within the company that has responsibility for assets. Organizations may be hierarchical to identify the companies, divisions, departments, and units. The structure of the organization hierarchy may be similar to the company organization chart. ORGANIZATION_NAME This column contains the organization name. VARCHAR2(40) NOT NULL
ORGANIZATION_TREE This table contains a directed acyclic graph for the organization hierarchy. Tivoli Service Desk allows an unlimited number of organizations in the tree by maintaining a parent/child relationship for each node in the tree (graph). CHILD This column contains the value of the unique key for the organization that is the child node in the tree. VARCHAR2(15) NOT NULL
ORGANIZATION_TREE This table contains a directed acyclic graph for the organization hierarchy. Tivoli Service Desk allows an unlimited number of organizations in the tree by maintaining a parent/child relationship for each node in the tree (graph). MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
ORGANIZATION_TREE This table contains a directed acyclic graph for the organization hierarchy. Tivoli Service Desk allows an unlimited number of organizations in the tree by maintaining a parent/child relationship for each node in the tree (graph). PARENT This column contains the value of the unique key for the organization that is the parent node in the tree. VARCHAR2(15) NOT NULL
PEOPLE This table contains the people that are recognized by the system. ACCESS_ID This column contains the person's access identification for use with TPM End-user Web Interface. VARCHAR2(20) NULL
PEOPLE This table contains the people that are recognized by the system. ACCESS_PASSWORD This column contains the person's access password for use with TPM End-user Web Interface. VARCHAR2(15) NULL
PEOPLE This table contains the people that are recognized by the system. ACCESS_PROFILE_ID Identifies the profile of the end user when logging in to the TPM End-user Web Interface product. INTEGER NULL
PEOPLE This table contains the people that are recognized by the system. ACTIVE_ACCESS Identifies if the person is active and can log in using the TPM End-user Web Interface product. SMALLINT NULL
PEOPLE This table contains the people that are recognized by the system. ACTIVE_CONTACT Identifies if the Contact is currently active. SMALLINT NULL
PEOPLE This table contains the people that are recognized by the system. ACTIVE_PERSON Identifies if the person is currently active within the system. SMALLINT NOT NULL
PEOPLE This table contains the people that are recognized by the system. ALTERNATE_PHONE This column contains the person's alternate telephone number. VARCHAR2(20) NULL
PEOPLE This table contains the people that are recognized by the system. CONTACT_ID This column contains the person's contact identification. VARCHAR2(15) NULL
PEOPLE This table contains the people that are recognized by the system. EMPLOYEE_NO This column contains the person's employee number. VARCHAR2(30) NULL
PEOPLE This table contains the people that are recognized by the system. FAX This column contains the person's FAX number. VARCHAR2(20) NULL
PEOPLE This table contains the people that are recognized by the system. FIRST_NAME This column contains the person's first name. VARCHAR2(30) NULL
PEOPLE This table contains the people that are recognized by the system. FLX_PEO_INT1 This column provides an integer field for customization purposes. INTEGER NULL
PEOPLE This table contains the people that are recognized by the system. FLX_PEO_INT2 This column provides an integer field for customization purposes. INTEGER NULL
PEOPLE This table contains the people that are recognized by the system. FLX_PEO_INT3 This column provides an integer field for customization purposes. INTEGER NULL
PEOPLE This table contains the people that are recognized by the system. FLX_PEO_INT4 This column provides an integer field for customization purposes. INTEGER NULL
PEOPLE This table contains the people that are recognized by the system. FLX_PEO_VCHR1 This column provides a 254-character field for customization purposes. VARCHAR2(254) NULL
PEOPLE This table contains the people that are recognized by the system. FLX_PEO_VCHR2 This column provides a 254-character field for customization purposes. VARCHAR2(254) NULL
PEOPLE This table contains the people that are recognized by the system. FLX_PEO_VCHR3 This column provides a 254-character field for customization purposes. VARCHAR2(254) NULL
PEOPLE This table contains the people that are recognized by the system. FLX_PEO_VCHR4 This column provides a 254-character field for customization purposes. VARCHAR2(254) NULL
PEOPLE This table contains the people that are recognized by the system. FLX_PEO_VCHR5 This column provides a 254-character field for customization purposes. VARCHAR2(254) NULL
PEOPLE This table contains the people that are recognized by the system. FLX_PEO_VCHR6 This column provides a 254-character field for customization purposes. VARCHAR2(254) NULL
PEOPLE This table contains the people that are recognized by the system. FLX1_PEO_DATE This column provides a date field for customization purposes. DATE NULL
PEOPLE This table contains the people that are recognized by the system. FLX1_PEO_TIME This column provides a time field for customization purposes. VARCHAR2(10) NULL
PEOPLE This table contains the people that are recognized by the system. FLX2_PEO_DATE This column provides a date field for customization purposes. DATE NULL
PEOPLE This table contains the people that are recognized by the system. FLX2_PEO_TIME This column provides a time field for customization purposes. VARCHAR2(10) NULL
PEOPLE This table contains the people that are recognized by the system. LAST_NAME This column contains the person's last name. VARCHAR2(30) NOT NULL
PEOPLE This table contains the people that are recognized by the system. LOGON_ID This column contains the person's logon identification from NetCensus discovered data. VARCHAR2(20) NULL
PEOPLE This table contains the people that are recognized by the system. MIDDLE_NAME This column contains the person's middle name. VARCHAR2(30) NULL
PEOPLE This table contains the people that are recognized by the system. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
PEOPLE This table contains the people that are recognized by the system. PEOPLE_ID Uniquely identifies the person. The value is obtained from the COUNTERS table. INTEGER NOT NULL
PEOPLE This table contains the people that are recognized by the system. PHONE This column contains the person's telephone number. VARCHAR2(20) NULL
PEOPLE This table contains the people that are recognized by the system. REM_KNWLDG_MASK Identifies the rights that a person has when logging in to the TPM End-user Web Interface product. INTEGER NULL
PEOPLE This table contains the people that are recognized by the system. REVIEWED This column... SMALLINT NULL
PEOPLE This table contains the people that are recognized by the system. SKEY This column contains index based on last_name for searching. VARCHAR2(15) NULL
PEOPLE This table contains the people that are recognized by the system. USER_ID This column contains the person's user identification for logging in to the TSD application. VARCHAR2(15) NULL
PEOPLE_LOCATION This table stores the relationship between people and locations. CONTACT_ID This column contains the contact identification for the person/location relationship. VARCHAR2(15) NULL
PEOPLE_LOCATION This table stores the relationship between people and locations. DEFAULT_LOC This column contains the default location identification. SMALLINT NULL
PEOPLE_LOCATION This table stores the relationship between people and locations. LOCATION_ID This column contains the identification for the location in the person/location relationship. VARCHAR2(15) NOT NULL
PEOPLE_LOCATION This table stores the relationship between people and locations. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
PEOPLE_LOCATION This table stores the relationship between people and locations. PEOPLE_ID This column contains the identification for the person in the person/location relationship. INTEGER NOT NULL
PROFILE This table contains the Tivoli Service Desk application profiles. Profiles identify the menu bar and icon bar configurations for a user or group of users. These profiles provide the features that a given user requires in order to do his or her job. A profile is made up of Tivoli Service Desk functionality groups. These functionality groups are called entities in the Tivoli Service Desk products. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
PROFILE This table contains the Tivoli Service Desk application profiles. Profiles identify the menu bar and icon bar configurations for a user or group of users. These profiles provide the features that a given user requires in order to do his or her job. A profile is made up of Tivoli Service Desk functionality groups. These functionality groups are called entities in the Tivoli Service Desk products. PROFILE_ID This column contains the primary key for the profile record. INTEGER NOT NULL
PROFILE This table contains the Tivoli Service Desk application profiles. Profiles identify the menu bar and icon bar configurations for a user or group of users. These profiles provide the features that a given user requires in order to do his or her job. A profile is made up of Tivoli Service Desk functionality groups. These functionality groups are called entities in the Tivoli Service Desk products. PROFILE_NAME This column contains the name given by the administrator for this profile. VARCHAR2(80) NOT NULL
PROFILE This table contains the Tivoli Service Desk application profiles. Profiles identify the menu bar and icon bar configurations for a user or group of users. These profiles provide the features that a given user requires in order to do his or her job. A profile is made up of Tivoli Service Desk functionality groups. These functionality groups are called entities in the Tivoli Service Desk products. PROFILE_TYPE This column contains records that identify whether the profile was established for a full Tivoli Service Desk user, or used for end-user access to Tivoli Service Desk. A full user is indicated by 0 (zero). An end user is identified by 1. INTEGER NOT NULL
PROFILE This table contains the Tivoli Service Desk application profiles. Profiles identify the menu bar and icon bar configurations for a user or group of users. These profiles provide the features that a given user requires in order to do his or her job. A profile is made up of Tivoli Service Desk functionality groups. These functionality groups are called entities in the Tivoli Service Desk products. SYSTEM_DEFAULT This column contains records that identify whether the profile is the default profile. Users or groups that do not have a specific profile assigned will be assigned the system default profile when they log in. INTEGER NOT NULL
PROFILE_ENTITY This table contains records that identify the functionality groups (entities) that make up each Tivoli Service Desk profile. ENTITY_ID This column contains the value that uniquely identifies the associated entity record. INTEGER NOT NULL
PROFILE_ENTITY This table contains records that identify the functionality groups (entities) that make up each Tivoli Service Desk profile. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
PROFILE_ENTITY This table contains records that identify the functionality groups (entities) that make up each Tivoli Service Desk profile. PROFILE_ENT_ID This column contains the primary key for the profile-entity cross reference record. INTEGER NOT NULL
PROFILE_ENTITY This table contains records that identify the functionality groups (entities) that make up each Tivoli Service Desk profile. PROFILE_ID This column contains the value that uniquely identifies the associated profile record. INTEGER NOT NULL
RIGHTS This table contains all available system rights and their current names. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
RIGHTS This table contains all available system rights and their current names. RIGHT_ID This column contains the primary key for the rights record. INTEGER NOT NULL
RIGHTS This table contains all available system rights and their current names. RIGHT_NAME This column contains the name given for the security right that was assigned by the administrator. VARCHAR2(30) NOT NULL
RIGHTS_REQUIRED This table contains records that identify the rights required to access buttons on the Tivoli Service Desk application dialog boxes. Rights can be assigned based on button name for a given dialog box form. Buttons are disabled when the dialog box is displayed if the user does not have the rights for the button. BUTTON_NAME This column contains the name of the button on the dialog box form. This is the name of the control that was established in the Interface Designer for the button. VARCHAR2(80) NOT NULL
RIGHTS_REQUIRED This table contains records that identify the rights required to access buttons on the Tivoli Service Desk application dialog boxes. Rights can be assigned based on button name for a given dialog box form. Buttons are disabled when the dialog box is displayed if the user does not have the rights for the button. FORM_NAME This column contains the name of the dialog box form that contains the buttons for which security is established. The form name is also established in Interface Designer. VARCHAR2(80) NOT NULL
RIGHTS_REQUIRED This table contains records that identify the rights required to access buttons on the Tivoli Service Desk application dialog boxes. Rights can be assigned based on button name for a given dialog box form. Buttons are disabled when the dialog box is displayed if the user does not have the rights for the button. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
RIGHTS_REQUIRED This table contains records that identify the rights required to access buttons on the Tivoli Service Desk application dialog boxes. Rights can be assigned based on button name for a given dialog box form. Buttons are disabled when the dialog box is displayed if the user does not have the rights for the button. RIGHT_ID This column contains the security right that is required to access the button. This field contains the value that uniquely identifies the security rights record in the RIGHTS table. INTEGER NULL
SAI_APP_PARAMS This table contains the Tivoli Service Desk configuration settings. APPLICATION_ID This column contains the value that uniquely identifies the Tivoli Service Desk module in the APPLICATIONS table that the configuration parameter was established for. INTEGER NOT NULL
SAI_APP_PARAMS This table contains the Tivoli Service Desk configuration settings. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
SAI_APP_PARAMS This table contains the Tivoli Service Desk configuration settings. PARAMNAME This column contains the name of the configuration parameter. VARCHAR2(30) NOT NULL
SAI_APP_PARAMS This table contains the Tivoli Service Desk configuration settings. PARAMVALUE This column contains the value for the configuration parameter. This value controls how the Tivoli Service Desk module behaves for the given parameter. VARCHAR2(30) NOT NULL
SAI_APP_PARAMS This table contains the Tivoli Service Desk configuration settings. SECTIONNAME This column... VARCHAR2(30) NOT NULL
SAI_APPLICATIONS This table contains records that identify the Tivoli Service Desk modules that are installed. APPLICATION_ID This column contains the value that identifies the installed application: 1= Tivoli Problem Management; 2 = Tivoli Quality Management; 3 = Tivoli Network Gateway; 5 = Tivoli Asset Management; 6 = Tivoli Change Management; 17 = TPM End-user Web Interface; 19 = Tivoli Suite Common. INTEGER NOT NULL
SAI_APPLICATIONS This table contains records that identify the Tivoli Service Desk modules that are installed. APPLICATION_NAME This column contains the product name of the installed module/application. VARCHAR2(80) NOT NULL
SITES This table stores information about each site where Tivoli Service Desk is installed for your enterprise. HOST_SITE This column contains the site ID for the host site. SMALLINT NOT NULL
SITES This table stores information about each site where Tivoli Service Desk is installed for your enterprise. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
SITES This table stores information about each site where Tivoli Service Desk is installed for your enterprise. SITE_DESCRIPTION This column contains a text description of the site. VARCHAR2(254) NULL
SITES This table stores information about each site where Tivoli Service Desk is installed for your enterprise. SITE_ENABLED This column contains an indicator for whether the site is enabled. SMALLINT NOT NULL
SITES This table stores information about each site where Tivoli Service Desk is installed for your enterprise. SITE_ID This column contains the unique site identification. VARCHAR2(6) NOT NULL
SITES This table stores information about each site where Tivoli Service Desk is installed for your enterprise. SITE_LOCAL This column contains the site id for the current site. SMALLINT NOT NULL
SITES This table stores information about each site where Tivoli Service Desk is installed for your enterprise. SITE_NAME This column contains the name of the site. VARCHAR2(40) NOT NULL
SITES This table stores information about each site where Tivoli Service Desk is installed for your enterprise. SITE_NUMBER This column contains the site number. INTEGER NOT NULL
SITES This table stores information about each site where Tivoli Service Desk is installed for your enterprise. SITE_PRIMARY_HOST This column contains the id for the primary host. VARCHAR2(32) NULL
SITES This table stores information about each site where Tivoli Service Desk is installed for your enterprise. SITE_SECONDRY_HOST This column contains the id for the secondary host. VARCHAR2(32) NULL
SKILLS This table stores the different skill levels for analysts as defined by system, component, item, and model categorization, as well as problem type. COMPONENT This column contains the component categorization for the SKILLS record. VARCHAR2(15) NULL
SKILLS This table stores the different skill levels for analysts as defined by system, component, item, and model categorization, as well as problem type. GROUP_ID This column contains the unique group identification. VARCHAR2(15) NULL
SKILLS This table stores the different skill levels for analysts as defined by system, component, item, and model categorization, as well as problem type. ITEM This column contains the item categorization for the SKILLS record. VARCHAR2(15) NULL
SKILLS This table stores the different skill levels for analysts as defined by system, component, item, and model categorization, as well as problem type. MODIFY_DATETIME_20 This column contains the date and time the record was last modified. INTEGER NOT NULL
SKILLS This table stores the different skill levels for analysts as defined by system, component, item, and model categorization, as well as problem type. MODULE This column contains the module categorization for the SKILLS record. VARCHAR2(15) NULL
SKILLS This table stores the different skill levels for analysts as defined by system, component, item, and model categorization, as well as problem type. PROBLEM_TYPE This column contains the problem type for the SKILLS record. VARCHAR2(15) NULL
SKILLS This table stores the different skill levels for analysts as defined by system, component, item, and model categorization, as well as problem type. SITE_ID This column contains the group's site identification. VARCHAR2(6) NULL
SKILLS This table stores the different skill levels for analysts as defined by system, component, item, and model categorization, as well as problem type. SYSTEM This column contains the system categorization for the SKILLS record. VARCHAR2(15) NOT NULL
SKILLS This table stores the different skill levels for analysts as defined by system, component, item, and model categorization, as well as problem type. USER_ID This column contains the analyst's user identification. VARCHAR2(15) NULL
SLA_ACTION This table stores actions to be performed according to the SLA term's schedule. ACTION_ID This column contains the unique ID for the SLA_ACTION table. INTEGER NOT NULL
SLA_ACTION This table stores actions to be performed according to the SLA term's schedule. ACTION_NAME This column the name of the action. VARCHAR2(20) NOT NULL
SLA_ACTION This table stores actions to be performed according to the SLA term's schedule. ACTION_TARGET This column contains the executable, system action, or user/group that this action performs or notifies. VARCHAR2(256) NULL
SLA_ACTION This table stores actions to be performed according to the SLA term's schedule. ACTION_TEXT This column contains the notification text, the SQL command, or the arguments to be passed to the system action or executable. VARCHAR2(1024) NULL
SLA_ACTION This table stores actions to be performed according to the SLA term's schedule. ACTION_TITLE This column contains the subject line of the notification. VARCHAR2(40) NULL
SLA_ACTION This table stores actions to be performed according to the SLA term's schedule. ACTION_TYPE This column contains the type of action to be performed (executable, SQL command, notification, or system action). INTEGER NOT NULL
SLA_ACTION This table stores actions to be performed according to the SLA term's schedule. EVENT_ID This column contains the ID of the event that relates to this action. INTEGER NULL
SLA_ACTION This table stores actions to be performed according to the SLA term's schedule. IS_GROUP This column determines if the action is for a group or individual. SMALLINT NULL
SLA_ACTION This table stores actions to be performed according to the SLA term's schedule. NOTIFICATION_TYPE This column contains the notification method to use. VARCHAR2(15) NULL
SLA_ACTION This table stores actions to be performed according to the SLA term's schedule. SEQUENCE_NUMBER This column contains the order in which actions are performed within their event. INTEGER NOT NULL
SLA_AUDIT_LOG This table contains a record of all service level activities. ENTRY This column contains the first 254 bytes of the entry description. VARCHAR2(254) NULL
SLA_AUDIT_LOG This table contains a record of all service level activities. ENTRY_DATE This column contains the date the entry was created. DATE NOT NULL
SLA_AUDIT_LOG This table contains a record of all service level activities. ENTRY_OVRFLW This column contains the text from the description that is longer than 254 bytes. LONG VARCHAR NULL
SLA_AUDIT_LOG This table contains a record of all service level activities. ENTRY_TIME This column contains the time then entry was created. VARCHAR2(10) NOT NULL
SLA_AUDIT_LOG This table contains a record of all service level activities. ENTRY_TYPE This column contains the type of this entry. VARCHAR2(50) NOT NULL
SLA_AUDIT_LOG This table contains a record of all service level activities. ENTRY_VALUE This column contains additional SLA information. VARCHAR2(15) NULL
SLA_AUDIT_LOG This table contains a record of all service level activities. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
SLA_AUDIT_LOG This table contains a record of all service level activities. REFERENCE_ID This column contains the unique identifier of the record being tracked under the applicable SLA. VARCHAR2(15) NOT NULL
SLA_AUDIT_LOG This table contains a record of all service level activities. RELATIVE_TO This column contains the integer identifier of the relationship for this service level agreement. INTEGER NOT NULL
SLA_AUDIT_LOG This table contains a record of all service level activities. USER_ID This column contains the ID of the user responsible for the record being tracked unter the applicable SLA. VARCHAR2(15) NOT NULL
SLA_CALENDAR This table stores the business calendar rules for the SLA Module. CALENDAR_ID This calendar contains the unique ID of the current calendar. INTEGER NOT NULL
SLA_CALENDAR This table stores the business calendar rules for the SLA Module. CALENDAR_NAME This column contains the calendar name. VARCHAR2(20) NOT NULL
SLA_CALENDAR This table stores the business calendar rules for the SLA Module. DESCRIPTION This column contains a description of the current calendar. VARCHAR2(256) NULL
SLA_CALENDAR This table stores the business calendar rules for the SLA Module. END_DATE This column contains the last date that this calendar will be active. DATE NULL
SLA_CALENDAR This table stores the business calendar rules for the SLA Module. NEXT_CALENDAR_ID This column contains the identification of the calendar that follows this calendar when it reaches it's end_date. INTEGER NULL
SLA_CALENDAR This table stores the business calendar rules for the SLA Module. START_DATE This column contains the first date that this calendar will be active. DATE NULL
SLA_DAY This table stores the on/off values for a 24 hour day in 15 minute intervals. BUSINESS_HOURS This column contains a string with 96 ones or zeros that signify the on/off value for each 15 minute interval within the 24 hour day. VARCHAR2(96) NOT NULL
SLA_DAY This table stores the on/off values for a 24 hour day in 15 minute intervals. DAY_ID This column contains The unique ID for the SLA_DAY table. INTEGER NOT NULL
SLA_DAY This table stores the on/off values for a 24 hour day in 15 minute intervals. DAY_NAME This column contains the name of the day. (For example: Holiday, Standard, Weekday, and so on.) VARCHAR2(15) NOT NULL
SLA_DAY This table stores the on/off values for a 24 hour day in 15 minute intervals. DESCRIPTION This column contains the desciption of the day's purpose. VARCHAR2(256) NULL
SLA_DAY_TYPE This table stores information that allows for multiple SLA_DAY records to be assigned to the SLA_CALENDAR based on coded rules. DAY_TYPE_ID This column contains the unique ID for the SLA_DAY_TYPE table. INTEGER NOT NULL
SLA_DAY_TYPE This table stores information that allows for multiple SLA_DAY records to be assigned to the SLA_CALENDAR based on coded rules. DAY_TYPE_NAME This column the name for this type of day (Weekday, Monday, Tuesday, Weekend, and so on.) VARCHAR2(15) NOT NULL
SLA_SCHEDULE This table stores the schedule of actions to be performed when an event or schedule is fired. DESCRIPTION This column contains the description for the SLA schedule. VARCHAR2(256) NULL
SLA_SCHEDULE This table stores the schedule of actions to be performed when an event or schedule is fired. EVENT_ID This column contains the unique ID for the SLA_SCHEDULE table. INTEGER NOT NULL
SLA_SCHEDULE This table stores the schedule of actions to be performed when an event or schedule is fired. EVENT_NAME This column contains the name of the SLA event or schedule. VARCHAR2(20) NOT NULL
SLA_SCHEDULE This table stores the schedule of actions to be performed when an event or schedule is fired. TERM_ID This column contains the ID of the SLA Term that this schedule is performed by. INTEGER NULL
SLA_SCHEDULE This table stores the schedule of actions to be performed when an event or schedule is fired. TIME_TO_FIRE This column contains the amount of time from the breach time that this event fires. The amount can be indicated by positive or negative values. INTEGER NOT NULL
SLA_TERM This table stores the service level agreement. BASE_CONDITION This column contains the basic criteria a record must meet to be considered under the criteria of this SLA term. VARCHAR2(1024) NULL
SLA_TERM This table stores the service level agreement. CALENDAR_ID This column contains the ID of the calendar that applies to the term. INTEGER NULL
SLA_TERM This table stores the service level agreement. DESCRIPTION This column... VARCHAR2(256) NULL
SLA_TERM This table stores the service level agreement. EXIT_CONDITION This column contains the condition that the record must meet before it is no longer associated with the SLA term. VARCHAR2(1024) NULL
SLA_TERM This table stores the service level agreement. LOCATION_CONDITION This column contains The location that the record must be associated with for this SLA term. VARCHAR2(1024) NULL
SLA_TERM This table stores the service level agreement. RELATIVE_TO This column contains the ID of the relationship table record that the SLA term is associated with. INTEGER NULL
SLA_TERM This table stores the service level agreement. SECONDS_TO_BREACH This column contains the number of seconds before the record meeting the terms of this SLA are considerd in breach of the agreement. INTEGER NOT NULL
SLA_TERM This table stores the service level agreement. TERM_ID This column contains the unique ID for the SLA term. INTEGER NOT NULL
SLA_TERM This table stores the service level agreement. TERM_NAME This column contains the name of the SLA term. VARCHAR2(20) NOT NULL
SLA_YEAR This table stores the business hours for an entire calendar year. CALENDAR_ID This column contains the ID of the calendar that applies to this SLA_YEAR record. INTEGER NOT NULL
SLA_YEAR This table stores the business hours for an entire calendar year. DAY_ID This column contains the ID of the SLA_DAY table for the current YEAR_DAY. INTEGER NOT NULL
SLA_YEAR This table stores the business hours for an entire calendar year. DAY_TYPE_NAME This column contains the type of day. VARCHAR2(15) NULL
SLA_YEAR This table stores the business hours for an entire calendar year. YEAR_DAY This column contains the day of the year in terms of number of days from the beginning of the year. INTEGER NOT NULL
SUPPORT_FOR This table contains records that identify the organizations that users of the Tivoli Service Desk product support. This table is used in a multi-customer or data segmented environment. This table is used to control user access to data that belongs to a given organization. GROUP_ID This column contains the value that uniquely identifies the group that has support for the organization. VARCHAR2(15) NULL
SUPPORT_FOR This table contains records that identify the organizations that users of the Tivoli Service Desk product support. This table is used in a multi-customer or data segmented environment. This table is used to control user access to data that belongs to a given organization. IS_GROUP This column contains an identifer for whether the current record is a group or a user record. SMALLINT NOT NULL
SUPPORT_FOR This table contains records that identify the organizations that users of the Tivoli Service Desk product support. This table is used in a multi-customer or data segmented environment. This table is used to control user access to data that belongs to a given organization. ORGANIZATION_ID This column contains the value that uniquely identifies the organization that the user or group supports. VARCHAR2(15) NULL
SUPPORT_FOR This table contains records that identify the organizations that users of the Tivoli Service Desk product support. This table is used in a multi-customer or data segmented environment. This table is used to control user access to data that belongs to a given organization. SITE_ID This column contains the value that uniquely identifies the site. VARCHAR2(6) NULL
SUPPORT_FOR This table contains records that identify the organizations that users of the Tivoli Service Desk product support. This table is used in a multi-customer or data segmented environment. This table is used to control user access to data that belongs to a given organization. USER_ID This column contains the value that uniquely identifies the user that has support for the organization. VARCHAR2(15) NULL
SYSTEM This table contains the system information from the equipment heirarchy. DESCRIPTION This column contains a text description of the system. VARCHAR2(1024) NULL
SYSTEM This table contains the system information from the equipment heirarchy. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
SYSTEM This table contains the system information from the equipment heirarchy. ORGANIZATION_ID This column contains the unique organization identification. VARCHAR2(15) NULL
SYSTEM This table contains the system information from the equipment heirarchy. SECURITY This column is no longer used. INTEGER NULL
SYSTEM This table contains the system information from the equipment heirarchy. SYSTEM_ID This column contains the uniqe identifier for this system. VARCHAR2(15) NOT NULL
SYSTEM_ACTIONS This table contains the system actions for the Tivoli Service Desk products. System actions are entry points into high level functions for the TSD products. System actions may display a dialog box for data entry or may invoke some other action. For example, the Add New Asset system action displays the New Asset dialog box. ACTION The information in this column identifies the routine to be invoked for the given system action. For example, I_asset:RequestAddNewAsset will invoke the RequestAddNewAsset routine that is contained in the I_asset.kb file. VARCHAR2(80) NOT NULL
SYSTEM_ACTIONS This table contains the system actions for the Tivoli Service Desk products. System actions are entry points into high level functions for the TSD products. System actions may display a dialog box for data entry or may invoke some other action. For example, the Add New Asset system action displays the New Asset dialog box. ACTION_ID This column contains the unique identifier for a system action. INTEGER NOT NULL
SYSTEM_ACTIONS This table contains the system actions for the Tivoli Service Desk products. System actions are entry points into high level functions for the TSD products. System actions may display a dialog box for data entry or may invoke some other action. For example, the Add New Asset system action displays the New Asset dialog box. ACTION_NAME This column contains the name of the system action. For example, Add New Asset is the name of a system action. VARCHAR2(40) NOT NULL
SYSTEM_ACTIONS This table contains the system actions for the Tivoli Service Desk products. System actions are entry points into high level functions for the TSD products. System actions may display a dialog box for data entry or may invoke some other action. For example, the Add New Asset system action displays the New Asset dialog box. ACTION_TYPE The information in this column identifies whether the system action can be used for full users or end users. INTEGER NOT NULL
SYSTEM_ACTIONS This table contains the system actions for the Tivoli Service Desk products. System actions are entry points into high level functions for the TSD products. System actions may display a dialog box for data entry or may invoke some other action. For example, the Add New Asset system action displays the New Asset dialog box. DESCRIPTION This column contains a description of the system action. VARCHAR2(1024) NULL
SYSTEM_ACTIONS This table contains the system actions for the Tivoli Service Desk products. System actions are entry points into high level functions for the TSD products. System actions may display a dialog box for data entry or may invoke some other action. For example, the Add New Asset system action displays the New Asset dialog box. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
SYSTEM_ACTIONS This table contains the system actions for the Tivoli Service Desk products. System actions are entry points into high level functions for the TSD products. System actions may display a dialog box for data entry or may invoke some other action. For example, the Add New Asset system action displays the New Asset dialog box. RIGHT_REQUIRED The infomration in this column identifies the rights that a user must have in order to invoke the system action. INTEGER NULL
SYSTEM_PROFILE This table contains many settings for system opperation. ADAPT_CHECK No longer used. INTEGER NULL
SYSTEM_PROFILE This table contains many settings for system opperation. AUTO_DIAG_MATCH No longer used. SMALLINT NOT NULL
SYSTEM_PROFILE This table contains many settings for system opperation. AUTO_PROBLEM_CODE No longer used. SMALLINT NOT NULL
SYSTEM_PROFILE This table contains many settings for system opperation. CALL_INQUIRY_FLAG This column contains a flag indicating that an inquiry screen should be displayed before the Work with Calls dialog box. INTEGER NOT NULL
SYSTEM_PROFILE This table contains many settings for system opperation. COMMON_CHECK No longer used. INTEGER NULL
SYSTEM_PROFILE This table contains many settings for system opperation. CORE_INQUIRY_FLAG No longer used. INTEGER NOT NULL
SYSTEM_PROFILE This table contains many settings for system opperation. DAYLIGHT_ACTIVE This column contains a flag indicating that daylight savings time is active. SMALLINT NOT NULL
SYSTEM_PROFILE This table contains many settings for system opperation. DEF_ESC_INTERVAL This column contains the default escalation interval. INTEGER NOT NULL
SYSTEM_PROFILE This table contains many settings for system opperation. DEF_ESC_LEVEL This column contains the default escalation level. INTEGER NOT NULL
SYSTEM_PROFILE This table contains many settings for system opperation. DEF_ESC_NTFY_GRP This column contains the default group to be notified upon escalation of a problem. VARCHAR2(15) NULL
SYSTEM_PROFILE This table contains many settings for system opperation. DEF_ESC_NTFY_OWNR This column contains the default owner to be notified upon escalation of a problem. SMALLINT NULL
SYSTEM_PROFILE This table contains many settings for system opperation. DEF_ESC_NTFY_USER This column contains the default analyst to be notified upon escalation of a problem. VARCHAR2(15) NULL
SYSTEM_PROFILE This table contains many settings for system opperation. DEF_ESC_POLL_PER This column contains the time interval between escalation polling cycles.a INTEGER NOT NULL
SYSTEM_PROFILE This table contains many settings for system opperation. DEF_ESC_RESET This column contains the default escalation reset level. SMALLINT NULL
SYSTEM_PROFILE This table contains many settings for system opperation. DEF_MAX_ESC_LEVEL This column contains the default maximum escalation level. INTEGER NOT NULL
SYSTEM_PROFILE This table contains many settings for system opperation. DEFAULT_CLOSE_CODE This column contains the default problem code for closed problems. VARCHAR2(15) NOT NULL
SYSTEM_PROFILE This table contains many settings for system opperation. DEFAULT_OPEN_CODE This column contains the default problem code for open problems. VARCHAR2(15) NOT NULL
SYSTEM_PROFILE This table contains many settings for system opperation. DIAG_CHECK No longer used. SMALLINT NOT NULL
SYSTEM_PROFILE This table contains many settings for system opperation. DIAG_INQUIRY_FLAG No longer used. INTEGER NOT NULL
SYSTEM_PROFILE This table contains many settings for system opperation. ENABLE_ANNOTATION No longer used. SMALLINT NULL
SYSTEM_PROFILE This table contains many settings for system opperation. HOTNEWS_CHECK No longer used. INTEGER NULL
SYSTEM_PROFILE This table contains many settings for system opperation. MATCH_BEFORE_PROB No longer used. SMALLINT NOT NULL
SYSTEM_PROFILE This table contains many settings for system opperation. MULTIPLE_SESSIONS This column contains a flag that dermines if multiple problems can be initiated during a single call. SMALLINT NULL
SYSTEM_PROFILE This table contains many settings for system opperation. PLAYBACK_APP No longer used. VARCHAR2(120) NULL
SYSTEM_PROFILE This table contains many settings for system opperation. PROFILE_ID This column contains the unique profile identification. VARCHAR2(15) NOT NULL
SYSTEM_PROFILE This table contains many settings for system opperation. RECORD_APP No longer used. VARCHAR2(120) NULL
SYSTEM_PROFILE This table contains many settings for system opperation. TIMEZONE_ID This column contains the time zone in which all times are normalized to and stored. VARCHAR2(30) NOT NULL
SYSTEM_PROFILE This table contains many settings for system opperation. WAVE_PATH No longer used. VARCHAR2(120) NULL
SYSTEM_PROFILE This table contains many settings for system opperation. WORK_WITH_PROBLEMS This column indicates whether the inquiry for Work With Problems is displayed SMALLINT NULL
TIMEZONES This table stores all valid time zones. DAYLIGHT_CORRECT This column contains an indicator for whether to adjust the timezone for Daylight Savings time. INTEGER NOT NULL
TIMEZONES This table stores all valid time zones. HOUR_DIFFERENCE This column contains the number of hours difference calculated from GMT. INTEGER NOT NULL
TIMEZONES This table stores all valid time zones. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
TIMEZONES This table stores all valid time zones. TIMEZONE_ID This column contains the unique time zone identification. VARCHAR2(30) NOT NULL
USER_DDVIEWS This table associates available data views to the users who access them. CONTEXT This column contains a string defining the place that this view is used. This allows a user to have a different set of views when viewing different types of data (for example, Work With Problems has different views than Work With Changes.) VARCHAR2(50) NOT NULL
USER_DDVIEWS This table associates available data views to the users who access them. USER_ID This column contains the user ID of the user of this view. VARCHAR2(15) NOT NULL
USER_DDVIEWS This table associates available data views to the users who access them. VIEWID This column contains the view to load when the user loads views for the given context. INTEGER NOT NULL
USERS This table contains records for the people that are full users of the Tivoli Service Desk products. Every user must be a person, but not all people are Tivoli Service Desk users. ALARM_POLL_PERIOD Identifies the polling period for alarms for the user. INTEGER NULL
USERS This table contains records for the people that are full users of the Tivoli Service Desk products. Every user must be a person, but not all people are Tivoli Service Desk users. FLX_USR_DATE1 This column contains a date field for customization purposes. DATE NULL
USERS This table contains records for the people that are full users of the Tivoli Service Desk products. Every user must be a person, but not all people are Tivoli Service Desk users. FLX_USR_DATE2 This column contains a date field for customization purposes. DATE NULL
USERS This table contains records for the people that are full users of the Tivoli Service Desk products. Every user must be a person, but not all people are Tivoli Service Desk users. FLX_USR_INT1 This column contains an integer field for customization purposes. INTEGER NULL
USERS This table contains records for the people that are full users of the Tivoli Service Desk products. Every user must be a person, but not all people are Tivoli Service Desk users. FLX_USR_INT2 This column contains an integer field for customization purposes. INTEGER NULL
USERS This table contains records for the people that are full users of the Tivoli Service Desk products. Every user must be a person, but not all people are Tivoli Service Desk users. FLX_USR_INT3 This column contains an integer field for customization purposes. INTEGER NULL
USERS This table contains records for the people that are full users of the Tivoli Service Desk products. Every user must be a person, but not all people are Tivoli Service Desk users. FLX_USR_INT4 This column contains an integer field for customization purposes. INTEGER NULL
USERS This table contains records for the people that are full users of the Tivoli Service Desk products. Every user must be a person, but not all people are Tivoli Service Desk users. FLX_USR_TIME1 This column contains a time field for customization purposes. VARCHAR2(10) NULL
USERS This table contains records for the people that are full users of the Tivoli Service Desk products. Every user must be a person, but not all people are Tivoli Service Desk users. FLX_USR_TIME2 This column contains a time field for customization purposes. VARCHAR2(10) NULL
USERS This table contains records for the people that are full users of the Tivoli Service Desk products. Every user must be a person, but not all people are Tivoli Service Desk users. FLX_USR_VCHR1 This column contains a 250-character field for customization purposes. VARCHAR2(250) NULL
USERS This table contains records for the people that are full users of the Tivoli Service Desk products. Every user must be a person, but not all people are Tivoli Service Desk users. FLX_USR_VCHR2 This column contains a 250-character field for customization purposes. VARCHAR2(250) NULL
USERS This table contains records for the people that are full users of the Tivoli Service Desk products. Every user must be a person, but not all people are Tivoli Service Desk users. FLX_USR_VCHR3 This column contains a 250-character field for customization purposes. VARCHAR2(250) NULL
USERS This table contains records for the people that are full users of the Tivoli Service Desk products. Every user must be a person, but not all people are Tivoli Service Desk users. FLX_USR_VCHR4 This column contains a 250-character field for customization purposes. VARCHAR2(250) NULL
USERS This table contains records for the people that are full users of the Tivoli Service Desk products. Every user must be a person, but not all people are Tivoli Service Desk users. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
USERS This table contains records for the people that are full users of the Tivoli Service Desk products. Every user must be a person, but not all people are Tivoli Service Desk users. PEOPLE_ID This column contains the value that uniquely identifies the user in the People table. INTEGER NOT NULL
USERS This table contains records for the people that are full users of the Tivoli Service Desk products. Every user must be a person, but not all people are Tivoli Service Desk users. PROFILE_ID This column contains the value that identifies the profile that has been assigned to the user. If the user does not have a profile assigned, the system default profile is assigned to them when they log in. INTEGER NULL
USERS This table contains records for the people that are full users of the Tivoli Service Desk products. Every user must be a person, but not all people are Tivoli Service Desk users. SECURITY_MASK The information in this column identifies the rights that have been assigned to the user. INTEGER NOT NULL
USERS This table contains records for the people that are full users of the Tivoli Service Desk products. Every user must be a person, but not all people are Tivoli Service Desk users. SITE_ID This column contains the user's home site. VARCHAR2(6) NULL
USERS This table contains records for the people that are full users of the Tivoli Service Desk products. Every user must be a person, but not all people are Tivoli Service Desk users. TIMEZONE_ID This column contains the time zone associated with the user. VARCHAR2(30) NULL
USERS This table contains records for the people that are full users of the Tivoli Service Desk products. Every user must be a person, but not all people are Tivoli Service Desk users. USER_ACTIVE_FLAG The information in this column identifies whether the person is an active user in the system. A user that is not active cannot log on to Tivoli Service Desk. A 1 indicates an active user. A 0 indicates a non-active user. INTEGER NOT NULL
USERS This table contains records for the people that are full users of the Tivoli Service Desk products. Every user must be a person, but not all people are Tivoli Service Desk users. USER_FULLNAME This column contains the user's full name. VARCHAR2(40) NOT NULL
USERS This table contains records for the people that are full users of the Tivoli Service Desk products. Every user must be a person, but not all people are Tivoli Service Desk users. USER_ID This column contains the value that uniquely identifies the user. This is the ID that a person uses to log in to Tivoli Service Desk. VARCHAR2(15) NOT NULL
USERS This table contains records for the people that are full users of the Tivoli Service Desk products. Every user must be a person, but not all people are Tivoli Service Desk users. USER_PASSWORD This column contains the user's password. VARCHAR2(15) NULL
VENDOR This table stores all vendor information. ADDRESS This column contains the vendor's address. VARCHAR2(254) NULL
VENDOR This table stores all vendor information. CITY This column contains the vendor's city. VARCHAR2(40) NULL
VENDOR This table stores all vendor information. CONTACT This column contains the vendor's contact name. VARCHAR2(40) NULL
VENDOR This table stores all vendor information. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
VENDOR This table stores all vendor information. ORGANIZATION_ID This column contains the unique organization identification. VARCHAR2(15) NULL
VENDOR This table stores all vendor information. PHONE This column contains the vendor's phone number. VARCHAR2(20) NULL
VENDOR This table stores all vendor information. STATE This column contains the vendor's state. VARCHAR2(40) NULL
VENDOR This table stores all vendor information. VENDOR_ID This column contains the unique vendor's name. VARCHAR2(15) NOT NULL
VENDOR This table stores all vendor information. ZIP This column contains the vendor's ZIP or postal code. VARCHAR2(40) NULL