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 |