Tivoli Asset Management Data Dictionary

Table Name Table Comment Table Column Name Table Column Comment Table Column Datatype Table Column Null Option
ATTRIBUTE_DEF This table stores information about attributes associated with an asset category. The attributes defined for an asset category apply to all models within the category. ATTRIB_DATA_TYPE Identifies the data type for the user-defined value of the attribute. The available data types are text, integer, decimal, date, time, and Boolean]. The field is required and the user must select from the data type combo box. VARCHAR2(15) NULL
ATTRIBUTE_DEF This table stores information about attributes associated with an asset category. The attributes defined for an asset category apply to all models within the category. ATTRIB_ID Attrib_ID uniquely identifies an attribute definition for an inventory category. Logically, the inventory category and the attribute name uniquely define the attribute definition. Attrib_ID is obtained from the COUNTERS table. INTEGER NOT NULL
ATTRIBUTE_DEF This table stores information about attributes associated with an asset category. The attributes defined for an asset category apply to all models within the category. ATTRIB_MEASURE The unit of measure for the attribute. The available units of measure are MB, KB, MHz, Inches, Version, EA, HW, and SW. This data element is not required and there is no validation on the value provided by the user. VARCHAR2(18) NULL
ATTRIBUTE_DEF This table stores information about attributes associated with an asset category. The attributes defined for an asset category apply to all models within the category. ATTRIB_NAME The user defined name of the attribute definition. For example, "Paper Capacity" may be an attribute of the Laser Printer inventory category VARCHAR2(40) NOT NULL
ATTRIBUTE_DEF This table stores information about attributes associated with an asset category. The attributes defined for an asset category apply to all models within the category. ATTRIB_OBJECT_TYPE Identifies if default values for this attribute will be provided for the models. If default values are not provided, then the attribute does not appear in the list of attributes when defining models. The attribute does appear in the list when assets are created for that model, but the asset will not inherit any default or standard value for that attribute. The value is "I" if default values should be specified for the model attribute list, and "P" if default attribute will not be provided. VARCHAR2(1) NOT NULL
ATTRIBUTE_DEF This table stores information about attributes associated with an asset category. The attributes defined for an asset category apply to all models within the category. H_OBJECT_ID The unique number identifying the inventory category that the attribute definition belongs to. VARCHAR2(15) NOT NULL
ATTRIBUTE_DEF This table stores information about attributes associated with an asset category. The attributes defined for an asset category apply to all models within the category. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
CONNECTION This table stores information about connections within the enterprise. ALT_CONNECTION Name of the alternate connection. VARCHAR2(40) NULL
CONNECTION This table stores information about connections within the enterprise. CONNECTION_ID This column contains the value that uniquely identifies the connection record VARCHAR2(15) NOT NULL
CONNECTION This table stores information about connections within the enterprise. CONNECTION_NAME This column contains the name of the connection. VARCHAR2(40) NOT NULL
CONNECTION This table stores information about connections within the enterprise. CONNECTION_NOTES Notes or additional information that applies to the connection. VARCHAR2(254) NULL
CONNECTION This table stores information about connections within the enterprise. CONNECTION_TYPE Identifies the type of the connection. Connection types are defined by the administrator. An example of a connection type is "Network". VARCHAR2(15) NULL
CONNECTION This table stores information about connections within the enterprise. DIAGRAM_FILE Contains the path and file name of the document that contains the connection topology VARCHAR2(254) NULL
CONNECTION This table stores information about connections within the enterprise. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
CONNECTION This table stores information about connections within the enterprise. ORGANIZATION_ID In a secure environment, this column identifies the ID of the organization that "owns" the connection record. VARCHAR2(15) NULL
CONNECTION_TREE This table stores records that create a relationship between a parent connection record and a child connection record. CHILD This column contains the connection ID of the child node for the parent-child relationship in the connection hierarchy. VARCHAR2(15) NOT NULL
CONNECTION_TREE This table stores records that create a relationship between a parent connection record and a child connection record. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
CONNECTION_TREE This table stores records that create a relationship between a parent connection record and a child connection record. PARENT This column contains the parent connection ID for the parent-child relationship in the connection hierarchy. The parent node for all root level connections is 0. VARCHAR2(15) NOT NULL
CONNECTION_TYPE This table stores information about connection types. CONNECTION_TYPE User defined name for the connection type. VARCHAR2(15) NOT NULL
CONNECTION_TYPE This table stores information about connection types. CONNECTION_TYPE_ID Uniquely identifies the connection type record. Obtained from the COUNTERS table. INTEGER NOT NULL
CONNECTION_TYPE This table stores information about connection types. MODIFY_DATETIME Date and time of the last modification. INTEGER NULL
EVENTS This table stores records of events. EVENT_DESCRIPTION This column contains a description of the event. VARCHAR2(80) NULL
EVENTS This table stores records of events. EVENT_ID Contains the value that uniquely identifies the event record INTEGER NOT NULL
EVENTS This table stores records of events. EVENT_NAME This column contains the name of the event. VARCHAR2(40) NOT NULL
EVENTS This table stores records of events. EVENT_OWNER This column contains the name of the product which owns the event. VARCHAR2(20) NOT NULL
EVENTS This table stores records of events. EVENT_TYPE This column contains a code indicating the type of event. Event types are "Planned" or "Completed" VARCHAR2(40) NOT NULL
EVENTS This table stores records of events. MODIFY_DATETIME Date time stamp of when the record was last modified. INTEGER NOT NULL
EXTERNAL_MAP This table stores external map records used during Tivoli Inventory migration. EXT_APP_NAME For the Data Migration process, this column contains the name of the 3rd party application that was used to generate the migrated data (i.e. 'TIVOLI', 'SMS', 'NETCENSUS'). During the Post Migration part of the TSD Build process, the External Map Utility populates this field for SMS and NetCensus. VARCHAR2(32) NOT NULL
EXTERNAL_MAP This table stores external map records used during Tivoli Inventory migration. EXT_ID_1 For the Data Migration process for Tivoli, this column contains 'Inventory', 'Location' or 'People' denoting the type of information that was migrated. For SMS, this column contains 'Inventory'. For NetCensus, this column contains 'Inventory'. During the Post Migration part of the TSD Build process, the External Map Utility populates this column with 'Inventory' for SMS and NetCensus. VARCHAR2(150) NOT NULL
EXTERNAL_MAP This table stores external map records used during Tivoli Inventory migration. EXT_ID_10 For the Data Migration process for Tivoli, this cloumn is unknown for all options. For SMS, this column contains the cost center organization id only for multi-customer support enabled migrations and is unknow for non-multi-customer support migrations. For NetCensus, this column contains the netCensusPath. During the Post Migration part of the TSD Build process, the External Map Utility sets this column to unknown for SMS and NetCensus. VARCHAR2(32) NULL
EXTERNAL_MAP This table stores external map records used during Tivoli Inventory migration. EXT_ID_2 For the Data Migration process for Tivoli, this column contains the Tivoli hardwareSysID for Inventory, the Tivoli location_id for Location, and the Tivoli personID for People. For SMS, this column contains the asset_tag. For NetCensus, this column contains the NetCensus config_id. During the Post Migration part of the TSD Build process, the External Map Utility populates this column with SMS smsID and the NetCensus config_id. VARCHAR2(150) NULL
EXTERNAL_MAP This table stores external map records used during Tivoli Inventory migration. EXT_ID_3 For the Data Migration process for Tivoli, this column contains the Tivoli tme_object_id for Inventory, and the Tivoli migrationRelease for both Location and People. For SMS, this column contains the alternate_tag. For NetCensus, this column contains the NetCensus prod_id. During the Post Migration part of the TSD Build process, the External Map Utility sets this column to unknown for SMS and NetCensus. VARCHAR2(150) NULL
EXTERNAL_MAP This table stores external map records used during Tivoli Inventory migration. EXT_ID_4 For the Data Migration process for Tivoli, this column contains the Tivoli tme_object_label for Inventory and is unknown for both Location and People. For SMS, this column contains the SMS smsID. For NetCensus, this column contains the migration mapping choice. During the Post Migration part of the TSD Build process, the External Map Utility sets this column to unknown for SMS and NetCensus. VARCHAR2(32) NULL
EXTERNAL_MAP This table stores external map records used during Tivoli Inventory migration. EXT_ID_5 For the Data Migration process for Tivoli, this column contains the migrationRelease for Inventory and is unknown for both Location and People. For SMS, this column contains the migrate inventory choice. For NetCensus, this column contains the demographics choice. During the Post Migration part of the TSD Build process, the External Map Utility sets this column to unknown for SMS and NetCensus. VARCHAR2(32) NULL
EXTERNAL_MAP This table stores external map records used during Tivoli Inventory migration. EXT_ID_6 For the Data Migration process for Tivoli, this column is unknown for all options. For SMS, this column contains the migrate users choice. For NetCensus, this column contains the component values choice. During the Post Migration part of the TSD Build process, the External Map Utility sets this column to unknown for SMS and NetCensus. VARCHAR2(32) NULL
EXTERNAL_MAP This table stores external map records used during Tivoli Inventory migration. EXT_ID_7 For the Data Migration process for Tivoli, this column is unknown for all options. For SMS, this column contains the migrate connection choice. For NetCensus, this column contains the logon choice. During the Post Migration part of the TSD Build process, the External Map Utility sets this column to unknown for SMS and NetCensus. VARCHAR(32) NULL
EXTERNAL_MAP This table stores external map records used during Tivoli Inventory migration. EXT_ID_8 For the Data Migration process for Tivoli, this column is unknown for all options. For SMS, this column contains the migrate organization choice. For NetCensus, this column contains the number of records to migrate or the Chunk Size. During the Post Migration part of the TSD Build process, the External Map Utility sets this column to unknown for SMS and NetCensus. VARCHAR2(32) NULL
EXTERNAL_MAP This table stores external map records used during Tivoli Inventory migration. EXT_ID_9 For the Data Migration process for Tivoli, this column is unknown for all options. For SMS, this column contains the SMS site that was migrated. For NetCensus, this column is unknown. During the Post Migration part of the TSD Build process, the External Map Utility populates this column with 'Inserted by External Map Utility' for SMS and NetCensus. VARCHAR2(32) NULL
EXTERNAL_MAP This table stores external map records used during Tivoli Inventory migration. EXT_MAP_ID This column contains the identification of the unique external map record which serves as the mapping link between TSD applications and 3rd party tools such as Tivoli, SMS, and NetCensus. INTEGER NOT NULL
EXTERNAL_MAP This table stores external map records used during Tivoli Inventory migration. EXT_SCAN_TIME For the Data Migration process, this column is the date the 3rd party tool last scanned the assets. During the Post Migration part of the TSD Build process, the External Map Utility sets this column to unknown for SMS and NetCensus. VARCHAR2(32) NULL
EXTERNAL_MAP This table stores external map records used during Tivoli Inventory migration. IS_INVENTORY_ID For the Data Migration process this column contains the internal identification number for the associated IS_INVENTORY record. INTEGER NOT NULL
EXTERNAL_MAP This table stores external map records used during Tivoli Inventory migration. LOCATION_ID For the Data Migration process for Tivoli, this column contains the internal identification number for the associated location. For SMS and NetCensus, this column is set to unknown. During the Post Migration part of the TSD Build process, the External Map Utility sets this column to unknown for SMS and NetCensus. VARCHAR2(15) NULL
EXTERNAL_MAP This table stores external map records used during Tivoli Inventory migration. MIGRATED_DATE For the Data Migration process, this column is the date of the migration from the 3rd party application. During the Post Migration part of the TSD Build process, the External Map Utility populates this column with the date of the record creation for SMS and NetCensus. DATE NOT NULL
EXTERNAL_MAP This table stores external map records used during Tivoli Inventory migration. MIGRATED_TIME For the Data Migration process, this column is the time of the migration from the 3rd party application. During the Post Migration part of the TSD Build process, the External Map Utility populates this column with the time of the record creation for SMS and NetCensus. VARCHAR2(10) NULL
EXTERNAL_MAP This table stores external map records used during Tivoli Inventory migration. MODIFY_DATETIME For the Data Migration process, this column contains the date and time the record was last modified. During the Post Migration part of the TSD Build process, the External Map Utility sets this field to unknown for SMS and NetCensus. During the Post Migration part of the TSD Build process, the External Map Utility populates this column with the date and time the record the record was last modified for SMS and NetCensus. INTEGER NULL
EXTERNAL_MAP This table stores external map records used during Tivoli Inventory migration. PEOPLE_ID For the Data Migration process for Tivoli, this column contains the internal identification number for the PEOPLE record. For SMS and NetCensus, this column is set to unknown. During the Post Migration part of the TSD Build process, the External Map Utility sets this column to unknown for SMS and NetCensus. INTEGER NULL
EXTERNAL_MAP This table stores external map records used during Tivoli Inventory migration. SQL_CFG_NAME For the Data Migration process, this column contains the TSD data source name used for the 3rd party migration. During the Post Migration part of the TSD Build process, the External Map Utility populates this field with the TSD data source name used for SMS and NetCensus. VARCHAR2(32) NOT NULL
FIELD_MAP This table holds records that map CSV files to TAB asests during a CSV file migration. ATTRIB This column is not used. VARCHAR2(40) NULL
FIELD_MAP This table holds records that map CSV files to TAB asests during a CSV file migration. CLASS This column contains the h_object_id associated with the category chosen for the CSV migration. VARCHAR2(40) NULL
FIELD_MAP This table holds records that map CSV files to TAB asests during a CSV file migration. FIELD_MAP_ID This column contains the unique identification for the field mappings for the CSV migration. INTEGER NOT NULL
FIELD_MAP This table holds records that map CSV files to TAB asests during a CSV file migration. FIELD_NO This column contains... INTEGER NOT NULL
FIELD_MAP This table holds records that map CSV files to TAB asests during a CSV file migration. INVENTORY This column is not used. VARCHAR2(40) NULL
FIELD_MAP This table holds records that map CSV files to TAB asests during a CSV file migration. MIGRATION_ID This column contains the unique identification for the CSV file migration and is related to migration_ID of the migration table. INTEGER NOT NULL
FIELD_MAP This table holds records that map CSV files to TAB asests during a CSV file migration. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
FIELD_MAP This table holds records that map CSV files to TAB asests during a CSV file migration. VALUATION This column holds the database field that is mapped to the CSV column. VARCHAR2(40) NULL
H_OBJECT This table stores asset category records. H_OBJECT_ID A unique number obtained from the COUNTERS table to identify the inventory category. H_Object_ID uniquely identifies an inventory category. These numbers are not consecutive in this table because 1 number is skipped each time the user adds categories at a different level in the tree. VARCHAR2(15) NOT NULL
H_OBJECT This table stores asset category records. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
H_OBJECT This table stores asset category records. NAME User defined name for the inventory category. Duplicate category names are allowed in the category tree. VARCHAR2(40) NOT NULL
H_OBJECT This table stores asset category records. ORGANIZATION_ID This column contains the VARCHAR2(15) NULL
H_OBJECT_TREE This table stores records that create a parent/child relationship between two asset category (H_OBJECT) records. CHILD This column contains the asset category ID of the child node for the parent-child relationship in the asset category hierarchy. VARCHAR2(15) NOT NULL
H_OBJECT_TREE This table stores records that create a parent/child relationship between two asset category (H_OBJECT) records. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
H_OBJECT_TREE This table stores records that create a parent/child relationship between two asset category (H_OBJECT) records. PARENT This column contains the parent asset category ID for the parent-child relationship in the asset category hierarchy. The parent node for all root level categories is 0. VARCHAR2(15) NOT NULL
I_ATTRIB_VALUE This table contains default attribute value information. ATTRIB_ID A unique number obtained from the COUNTERS table to identify the attribute definition that the model attribute value belongs to. INTEGER NOT NULL
I_ATTRIB_VALUE This table contains default attribute value information. GLOBAL_VALUE The default, standard, or "off the shelf" model value for the attribute. For example, an NEC Versa 4000 comes standard with 8MB of RAM. VARCHAR2(80) NULL
I_ATTRIB_VALUE This table contains default attribute value information. I_OBJECT_ID A unique number obtained from the COUNTERS table to identify the model that the attribute value belongs to. VARCHAR2(15) NOT NULL
I_ATTRIB_VALUE This table contains default attribute value information. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
I_ATTRIBUTE_MAP This table stores the entities that are required for mapping SMS to TAM during an SMS migration. These values are loaded during the build process and populate the Asset Entities dialog. These values also determine which fields in TAM are required to be mapped prior to an SMS migration taking place. COLUMNNAME This columns holds the column of the TAM table that is available for SMS mapping. Possible values are FOR IS_INVENTORY: STATUS, NOTES, MFGR_NO, SERVICE_ID, PURCHASE_ID; FOR PEOPLE: EMPLOYEE_NO, LAST_NAME, FIRST_NAME, MIDDLE_NAME, PHONE, FAX, ALTERNATE_PHONE; FOR CONNECTION: CONNCETION_NAME, CONNECTION_TYPE, ALT_CONNECTION, CONNECTION_NOTES; FOR ORGANIZATION: ORGANIZATION_NAME VARCHAR2(30) NOT NULL
I_ATTRIBUTE_MAP This table stores the entities that are required for mapping SMS to TAM during an SMS migration. These values are loaded during the build process and populate the Asset Entities dialog. These values also determine which fields in TAM are required to be mapped prior to an SMS migration taking place. ENTITYNAME This column holds the Entity that needs to be mapped. Possible values are INVENTORY, USERS, CONNECTIONS and ORGANIZATIONS. VARCHAR2(20) NOT NULL
I_ATTRIBUTE_MAP This table stores the entities that are required for mapping SMS to TAM during an SMS migration. These values are loaded during the build process and populate the Asset Entities dialog. These values also determine which fields in TAM are required to be mapped prior to an SMS migration taking place. ENTRYTYPE This column holds the type of the entry type associated with the entity that will be displayed to the user in the default value section of the Source group box on the Map page of the SMS migration dialog. Possible values are TEXT, MULTILINEEDIT or COBMO. VARCHAR2(15) NOT NULL
I_ATTRIBUTE_MAP This table stores the entities that are required for mapping SMS to TAM during an SMS migration. These values are loaded during the build process and populate the Asset Entities dialog. These values also determine which fields in TAM are required to be mapped prior to an SMS migration taking place. REQUIRED This column holds the value that determines if the columnname is (1) or is not (0) required by TAM during an SMS migration. SMALLINT NOT NULL
I_ATTRIBUTE_MAP This table stores the entities that are required for mapping SMS to TAM during an SMS migration. These values are loaded during the build process and populate the Asset Entities dialog. These values also determine which fields in TAM are required to be mapped prior to an SMS migration taking place. TABLENAME This column holds the TAM tablename that is associated with the chosen entity (i.e. IS_INVETORY for INVENTORY entityname). Possible values are IS_INVENTORY, PEOPLE, CONNECTION and ORGANIZATION). VARCHAR2(30) NOT NULL
I_ATTRIBUTE_MAP This table stores the entities that are required for mapping SMS to TAM during an SMS migration. These values are loaded during the build process and populate the Asset Entities dialog. These values also determine which fields in TAM are required to be mapped prior to an SMS migration taking place. VALIDCOLUMN This column holds the valid column name that is to be used to populate the default value for the entry type selected. This is used in combination with validtable. VARCHAR2(30) NULL
I_ATTRIBUTE_MAP This table stores the entities that are required for mapping SMS to TAM during an SMS migration. These values are loaded during the build process and populate the Asset Entities dialog. These values also determine which fields in TAM are required to be mapped prior to an SMS migration taking place. VALIDTABLE This column holds the table name that is to be used to populate the default value for the entry type selected. This is used in combination with validcolumn. VARCHAR2(30) NULL
I_OBJECT This table holds asset category model records. H_OBJECT_ID A unique number obtained from the COUNTERS table that identifies the inventory category that the model belongs to. VARCHAR2(15) NULL
I_OBJECT This table holds asset category model records. I_OBJECT_ID A unique number obtained from the COUNTERS table to identify the model of an inventory category. I_Object_ID uniquely identifies an inventory category model. Logically, the inventory category and the model name uniquely define a model. VARCHAR2(15) NOT NULL
I_OBJECT This table holds asset category model records. I_OBJECT_NAME The name of the model (e.g. NEC Versa 4000). VARCHAR2(40) NOT NULL
I_OBJECT This table holds asset category model records. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
I_OBJECT_TREE This table stores records that create a valid relationship between a parent asset category model and a child asset category model. CHILD This column contains the name of the child asset category model in the parent/child relationship. VARCHAR2(15) NOT NULL
I_OBJECT_TREE This table stores records that create a valid relationship between a parent asset category model and a child asset category model. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
I_OBJECT_TREE This table stores records that create a valid relationship between a parent asset category model and a child asset category model. PARENT This column contains the name of the parent asset category model in the parent/child relationship. VARCHAR2(15) NOT NULL
I_PREFERENCES This table stores preference settings for the Asset Management module MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NOT NULL
I_PREFERENCES This table stores preference settings for the Asset Management module PARAMNAME This column contains the preference parameter. For instance, ASSET_TAG_SUFFIX. VARCHAR2(30) NOT NULL
I_PREFERENCES This table stores preference settings for the Asset Management module PARAMVALUE This column contains the preference parameter's value. For instance, if the parameter is ASSET_TAG_SUFFIX and if the paramvalue is 000, then when assets are created with an auto-asset tag, the last 3 characters of the asset tag will be 000. VARCHAR2(80) NULL
I_PREFERENCES This table stores preference settings for the Asset Management module PREFERENCE_ID This column contains the unique identification of the preference record. INTEGER NOT NULL
I_PREFERENCES This table stores preference settings for the Asset Management module PREFERENCE_NAME This column contains the name of the preference. VARCHAR2(40) NOT NULL
I_PREFERENCES This table stores preference settings for the Asset Management module PREFERENCE_TYPE This column contains the type of preference. A preference_type of 1 cannot be removed by the application. INTEGER NOT NULL
I_PREFERENCES This table stores preference settings for the Asset Management module SECTIONNAME This column contains the sectionname for the preference. At this time, this field is not used. VARCHAR2(30) NOT NULL
I_SCHEDULE This table stores information about scheduled processes associated with asset management. ABSOLUTE_TIME This column contains an indicator to determine whether the system records the scheduled or actual time of the executed event. INTEGER NOT NULL
I_SCHEDULE This table stores information about scheduled processes associated with asset management. DAYS This column contains the interval in days between executions of the schedule entry. INTEGER NOT NULL
I_SCHEDULE This table stores information about scheduled processes associated with asset management. ENABLED This column indicates whether the scheduled entry is enabled or disabled. SMALLINT NULL
I_SCHEDULE This table stores information about scheduled processes associated with asset management. ENTRY_ID This column contains the unique identifier for the schedule entry record. INTEGER NOT NULL
I_SCHEDULE This table stores information about scheduled processes associated with asset management. HOURS This column contains the interval in hours between executions of the schedule entry. INTEGER NOT NULL
I_SCHEDULE This table stores information about scheduled processes associated with asset management. LAST_RUN_DATE This column contains the date the scheduled entry was last executed. DATE NOT NULL
I_SCHEDULE This table stores information about scheduled processes associated with asset management. LAST_RUN_TIME This column contains the time the scheduled entry was last executed. TIME NOT NULL
I_SCHEDULE This table stores information about scheduled processes associated with asset management. MINUTES This column contains the interval in minutes between executions of the schedule entry. INTEGER NOT NULL
I_SCHEDULE This table stores information about scheduled processes associated with asset management. MODULE_NAME This column contains the name of the module associated with the schedule entry record. CHAR(100) NULL
I_SCHEDULE This table stores information about scheduled processes associated with asset management. ORGANIZATION_ID VARCHAR2(15) NULL
I_SCHEDULE This table stores information about scheduled processes associated with asset management. PARM1 This column contains the first parameter associated with the schedule entry record. CHAR(30) NULL
I_SCHEDULE This table stores information about scheduled processes associated with asset management. PARM2 This column contains the second parameter associated with the schedule entry record. CHAR(30) NULL
I_SCHEDULE This table stores information about scheduled processes associated with asset management. PARM3 This column contains the third parameter associated with the schedule entry record. CHAR(30) NULL
I_SCHEDULE This table stores information about scheduled processes associated with asset management. PARM4 This column contains the fourth parameter associated with the schedule entry record. CHAR(30) NULL
I_SCHEDULE This table stores information about scheduled processes associated with asset management. PROC_NAME This column contains the name of the process associated with the schedule entry record. CHAR(100) NULL
I_SCHEDULE This table stores information about scheduled processes associated with asset management. PROCESSID This column contains the identification of the process associated with the schedule entry record. CHAR(30) NULL
I_SCHEDULE This table stores information about scheduled processes associated with asset management. SECONDS This column contains the interval in seconds between executions of the schedule entry. INTEGER NOT NULL
I_SMS_MIG_MAP This table holds mapping information about the records that are to be migrated from the SMS datasource. COMMONSPECFLAG This column holds either a 1 (indicating that the SMS table mapped for SMS is an SMS common table) or a 2 (indicating that the SMS table mapped for SMS is an SMS specific table) INTEGER NULL
I_SMS_MIG_MAP This table holds mapping information about the records that are to be migrated from the SMS datasource. DEFAULTVALUE This column holds the default value which will be used to populate the TAM column during the migration. VARCHAR2(254) NULL
I_SMS_MIG_MAP This table holds mapping information about the records that are to be migrated from the SMS datasource. EFMCOLUMNNAME This column (used with the EFMTABLENAME column) contains the name of the column in the Tivoli Asset Management database to which the SMS records are to be migrated. VARCHAR2(30) NOT NULL
I_SMS_MIG_MAP This table holds mapping information about the records that are to be migrated from the SMS datasource. EFMENTITYNAME This column hold the TAM entity that the SMS column is mapped to. This can be one of four values (Inventory, Users, Connections or Organizations). This is determined on the SMS Map page in the destination group box. VARCHAR2(32) NULL
I_SMS_MIG_MAP This table holds mapping information about the records that are to be migrated from the SMS datasource. EFMTABLENAME This column contains the name of the table in the Tivoli Asset Management database to which the SMS records are to be migrated. VARCHAR2(30) NOT NULL
I_SMS_MIG_MAP This table holds mapping information about the records that are to be migrated from the SMS datasource. GROUPKEY This column holds the SMS groupKey value from the SMS GroupMap table which is associated with the SMS group that will populate the TAM entity. INTEGER NULL
I_SMS_MIG_MAP This table holds mapping information about the records that are to be migrated from the SMS datasource. MIGRATION_ID This column contains the unique identification for the SMS migration mapping record. INTEGER NOT NULL
I_SMS_MIG_MAP This table holds mapping information about the records that are to be migrated from the SMS datasource. SMSATTRIBNAME This column holds the SMS table name that contains the data that is mapped and will be migrated to the TAM database. This column will be populated if there is NOT a default value and will be empty if a default value exists. VARCHAR2(32) NULL
I_SMS_MIG_MAP This table holds mapping information about the records that are to be migrated from the SMS datasource. SMSOLUMNNAME This column holds the SMS table column name that contains the data that is mapped and will be migrated to the TAM database. This column will be populated if there is NOT a default value and will be empty if a default value exists. VARCHAR2(32) NULL
I_SMS_MIG_MAP This table holds mapping information about the records that are to be migrated from the SMS datasource. SMSTABLENAME This column contains the name of the table in the SMS database from which the SMS records are to be migrated. VARCHAR2(32) NULL
I_SMS_MIGRATION This table stores information about SMS migration setup. DESCRIPTION This column contains a description of the SMS migration setup record. VARCHAR2(254) NULL
I_SMS_MIGRATION This table stores information about SMS migration setup. MIGRATECONNECT This column contains an indicator for whether to migrate connection data from SMS. SMALLINT NOT NULL
I_SMS_MIGRATION This table stores information about SMS migration setup. MIGRATEINVENT This column contains an indicator for whether to migrate asset data from SMS. SMALLINT NOT NULL
I_SMS_MIGRATION This table stores information about SMS migration setup. MIGRATEORG This column contains an indicator for whether to migrate organization data from SMS. SMALLINT NOT NULL
I_SMS_MIGRATION This table stores information about SMS migration setup. MIGRATEUSERS This column contains an indicator for whether to migrate user data from SMS. SMALLINT NOT NULL
I_SMS_MIGRATION This table stores information about SMS migration setup. MIGRATION_ID This column contains the unique identification of the SMS migration setup record. INTEGER NOT NULL
I_SMS_MIGRATION This table stores information about SMS migration setup. NAME This column contains a name for the SMS migration setup record. VARCHAR2(254) NULL
I_SMS_MIGRATION This table stores information about SMS migration setup. ORGANIZATION_ID This column contains the multi-customer organization_id to be associated with the migrated SMS record. VARCHAR2(15) NULL
I_SMS_MIGRATION This table stores information about SMS migration setup. SCANDATE This column contains the earliest scan date to use when migrating records from SMS. DATE NULL
I_SMS_MIGRATION This table stores information about SMS migration setup. SMSIDMAP This column contains an indicator for the Map SMSID to Asset Management radio button group on whether to map the SMS smsID to asset_tag (value 1) or to alternate_tag (value_2). INTEGER NOT NULL
I_SMS_MIGRATION This table stores information about SMS migration setup. SMSRECORDS This column contains an indicator for the Record Options radio button group on whether to insert new records only (value 1), to update existing records by smsID (value 2) or to update existing by machine name (value 3). INTEGER NOT NULL
I_SMS_MIGRATION This table stores information about SMS migration setup. SMSSITE This column contains the SMS Site to use when migrating records from SMS. VARCHAR2(10) NOT NULL
I_SMS_MIGRATION This table stores information about SMS migration setup. STARTMACHINE This column contains the number of the first machine to be migrated from SMS. INTEGER NULL
I_SMS_MIGRATION This table stores information about SMS migration setup. STOPMACHINE This column contains the number of the last machine to be migrated from SMS. INTEGER NULL
I_TIV_MIGRATION This table contains the attributes that an organization will use to set-up a Tivoli Migration. This table can hold settings for future run-time or scheduled migrations. ALT_TAG_OPTION This columns holds the value of the Alternate Tag Mapping radio button group on the Mapping page of the Tivoli migration dialog. The value will be 1 for TME object ID, 2 for TME Object Label or 3 for Do Not Map SMALLINT NOT NULL
I_TIV_MIGRATION This table contains the attributes that an organization will use to set-up a Tivoli Migration. This table can hold settings for future run-time or scheduled migrations. ASSET_MAP_OPTION This columns holds the value of the TAM Asset Mapping radio button group on the Mapping page of the Tivoli migration dialog. The value will be 1 for TAM-auto numbering or 2 for TME object ID. SMALLINT NOT NULL
I_TIV_MIGRATION This table contains the attributes that an organization will use to set-up a Tivoli Migration. This table can hold settings for future run-time or scheduled migrations. BOOTED_OS_NAME This column holds the Tivoli booted os to be used during the Tivoli migration and is obtained from the booted os combo box in the Repository Specifications group box on the Tivoli migration dialog. VARCHAR2(16) NOT NULL
I_TIV_MIGRATION This table contains the attributes that an organization will use to set-up a Tivoli Migration. This table can hold settings for future run-time or scheduled migrations. DATA_SOURCE This column holds the data source to be used for the Tivoli migration and is obtained from the data source field in the Repository Specifications group box on the Tivoli migration dialog. VARCHAR2(254) NOT NULL
I_TIV_MIGRATION This table contains the attributes that an organization will use to set-up a Tivoli Migration. This table can hold settings for future run-time or scheduled migrations. DELETE_OPTION This column holds the delete option in the Migration options group box on the Tivoli migration dialog. Value is 1 if this was selected, 0 if not selected. SMALLINT NOT NULL
I_TIV_MIGRATION This table contains the attributes that an organization will use to set-up a Tivoli Migration. This table can hold settings for future run-time or scheduled migrations. DESCRIPTION This column holds the description for the Tivoli migration settings. VARCHAR2(45) NULL
I_TIV_MIGRATION This table contains the attributes that an organization will use to set-up a Tivoli Migration. This table can hold settings for future run-time or scheduled migrations. END_SCAN_DATE This column holds the ending scan date for the Tivoli migration settings. This data is taken from the scan date < field in the Repository Specifications group box on the Tivoli migration dialog. VARCHAR2(19) NULL
I_TIV_MIGRATION This table contains the attributes that an organization will use to set-up a Tivoli Migration. This table can hold settings for future run-time or scheduled migrations. INSERT_OPTION This column holds the insert option in the Migration options group box on the Tivoli migration dialog. Value is 1 if this was selected, 0 if not selected. SMALLINT NOT NULL
I_TIV_MIGRATION This table contains the attributes that an organization will use to set-up a Tivoli Migration. This table can hold settings for future run-time or scheduled migrations. INVENTORY_OPTION This column holds the inventory entity option in the Migration options group box on the Tivoli migration dialog. Value is 1 if this was selected, 0 if not selected. SMALLINT NOT NULL
I_TIV_MIGRATION This table contains the attributes that an organization will use to set-up a Tivoli Migration. This table can hold settings for future run-time or scheduled migrations. LOCATION_ID This column holds the Tivoli location to be used during the Tivoli migration and is obtained from the location combo box in the Repository Specifications group box on the Tivoli migration dialog. VARCHAR2(32) NOT NULL
I_TIV_MIGRATION This table contains the attributes that an organization will use to set-up a Tivoli Migration. This table can hold settings for future run-time or scheduled migrations. LOCATIONS_OPTION This column holds the location entity option in the Migration options group box on the Tivoli migration dialog. Value is 1 if this was selected, 0 if not selected. SMALLINT NOT NULL
I_TIV_MIGRATION This table contains the attributes that an organization will use to set-up a Tivoli Migration. This table can hold settings for future run-time or scheduled migrations. MIGRATION_ID This column contains the unique identification for the Tivoli migration settings. INTEGER NOT NULL
I_TIV_MIGRATION This table contains the attributes that an organization will use to set-up a Tivoli Migration. This table can hold settings for future run-time or scheduled migrations. NAME This column holds the user defined name for the Tivoli migration settings VARCHAR2(15) NOT NULL
I_TIV_MIGRATION This table contains the attributes that an organization will use to set-up a Tivoli Migration. This table can hold settings for future run-time or scheduled migrations. ORGANIZATION_ID This column contains the multi-customer organization_id to be associated with the migrated Tivoli record. VARCHAR2(15) NULL
I_TIV_MIGRATION This table contains the attributes that an organization will use to set-up a Tivoli Migration. This table can hold settings for future run-time or scheduled migrations. PEOPLE_OPTION This column holds the people entity option in the Migration options group box on the Tivoli migration dialog. Value is 1 if this was selected, 0 if not selected. SMALLINT NOT NULL
I_TIV_MIGRATION This table contains the attributes that an organization will use to set-up a Tivoli Migration. This table can hold settings for future run-time or scheduled migrations. RELEASE_NUMBER This column holds the Tivoli release version to be used during the Tivoli migration and is obtained from the release # combo box in the Repository Specifications group box on the Tivoli migration dialog. VARCHAR2(32) NOT NULL
I_TIV_MIGRATION This table contains the attributes that an organization will use to set-up a Tivoli Migration. This table can hold settings for future run-time or scheduled migrations. START_RANGE This column holds the start Item # in the Migration options group box on the Tivoli migration dialog. Value will be the Tivoli record to begin the migration with. INTEGER NULL
I_TIV_MIGRATION This table contains the attributes that an organization will use to set-up a Tivoli Migration. This table can hold settings for future run-time or scheduled migrations. START_SCAN_DATE This column holds the beginning scan date for the Tivoli migration settings. This data is taken from the scan date > field on the Tivoli migration dialog. VARCHAR2(19) NULL
I_TIV_MIGRATION This table contains the attributes that an organization will use to set-up a Tivoli Migration. This table can hold settings for future run-time or scheduled migrations. STOP_RANGE This column holds the stop Item # in the Migration options group box on the Tivoli migration dialog. Value will be the Tivoli record to end the migration with. INTEGER NULL
I_TIV_MIGRATION This table contains the attributes that an organization will use to set-up a Tivoli Migration. This table can hold settings for future run-time or scheduled migrations. UPDATE_OPTION This column holds the update option in the Migration options group box on the Tivoli migration dialog. Value is 1 if this was selected, 0 if not selected. SMALLINT NOT NULL
INV_CONNECTION This table identifies the relationship between a connection and an asset. CONNECTION_ID This column contains the primary key for the connection associated with the asset. VARCHAR2(15) NOT NULL
INV_CONNECTION This table identifies the relationship between a connection and an asset. INV_CONNECTION_ID This column contains the unique identifier of the connectiuon/asset relationship record. INTEGER NOT NULL
INV_CONNECTION This table identifies the relationship between a connection and an asset. IS_INVENTORY_ID This column contains a unique internal identification for the asset record associated with the connection. INTEGER NOT NULL
INV_CONNECTION This table identifies the relationship between a connection and an asset. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
INV_CONTRACT This table identifies the assets that are associated with a contract. CONTRACT_ID This column contains a unique internal identification for the contract record. INTEGER NULL
INV_CONTRACT This table identifies the assets that are associated with a contract. INV_CONTRACT_ID This column contains a unique number from the COUNTERS table that identifies the contract/asset cross-reference record. INTEGER NOT NULL
INV_CONTRACT This table identifies the assets that are associated with a contract. IS_INVENTORY_ID This column contains a unique identification number of the asset. INTEGER NOT NULL
INV_CONTRACT This table identifies the assets that are associated with a contract. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
INV_PEOPLE This table identifies the people that are associated with the asset. INV_PEOPLE_ID This column contains the unique identifier of the people/asset relationship record. INTEGER NOT NULL
INV_PEOPLE This table identifies the people that are associated with the asset. IS_INVENTORY_ID This column contains a unique internal identification for the asset record associated with the user. INTEGER NOT NULL
INV_PEOPLE This table identifies the people that are associated with the asset. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
INV_PEOPLE This table identifies the people that are associated with the asset. PEOPLE_ID This column contains a unique identifier for the PEOPLE record associated with the asset. INTEGER NOT NULL
INVENTORY_HISTORY This table stores records about asset history events. CALL_ID This column contains the identification of the call or problem associated with the event. VARCHAR2(15) NULL
INVENTORY_HISTORY This table stores records about asset history events. CHANGE_ID This column contains the change ID for the change request when an asset affected by a change is updated upon completion of the change. INTEGER NULL
INVENTORY_HISTORY This table stores records about asset history events. CONTRACT_ID This column contains the identification of the contract associated with the history event. Only one contract can be associated with each event. INTEGER NULL
INVENTORY_HISTORY This table stores records about asset history events. COST This column contains the cost of the event. FLOAT NULL
INVENTORY_HISTORY This table stores records about asset history events. COST_CURRENCY This column contains the code for the type of currency value contained in the record. VARCHAR2(3) NULL
INVENTORY_HISTORY This table stores records about asset history events. EVENT_DATE This column contains the planned or actual completion date for the event. If the record created from the Add/Edit/View Asset dialog box as a planned event, EVENT_DATE contains the scheduled completion date. If the event is created from the Contracts dialog box as a planned event, the date for the planned event is the date the record is inserted. If the record is a completed event, the date is the actual completion date. DATE NOT NULL
INVENTORY_HISTORY This table stores records about asset history events. EVENT_ID This column contains a unique number that identifies the event code associated with the history record. INTEGER NOT NULL
INVENTORY_HISTORY This table stores records about asset history events. EVENT_NOTES Event notes entered by the user when the event is planned or when the user enters a completed event. Event notes can be updated by the user even after the event is identified as complete VARCHAR2(254) NULL
INVENTORY_HISTORY This table stores records about asset history events. EVENT_TIME This column contains the planned or actual completion time for the event. If the record created from the Add/Edit/View Asset dialog box as a planned event, EVENT_TIME contains the scheduled completion time. If the event is created from the Contracts dialog box as a planned event, the time for the planned event is the time when the record is inserted. If the record is a completed event, the time is the actual completion time. TIME NOT NULL
INVENTORY_HISTORY This table stores records about asset history events. FLX_IHIST_FLOAT1 This column contains a floating integer (amount) field for customization purposes. FLOAT NULL
INVENTORY_HISTORY This table stores records about asset history events. FLX_IHIST_FLOAT2 This column contains a floating integer (amount) field for customization purposes. FLOAT NULL
INVENTORY_HISTORY This table stores records about asset history events. FLX_IHIST_FLOAT3 This column contains a floating integer (amount) field for customization purposes. FLOAT NULL
INVENTORY_HISTORY This table stores records about asset history events. FLX_IHIST_VCHR1 This column contains a 254-character field for customization purposes. VARCHAR2(254) NULL
INVENTORY_HISTORY This table stores records about asset history events. FLX_IHIST_VCHR2 This column contains a 254-character field for customization purposes. VARCHAR2(254) NULL
INVENTORY_HISTORY This table stores records about asset history events. FLX_IHIST_VCHR3 This column contains a 254-character field for customization purposes. VARCHAR2(254) NULL
INVENTORY_HISTORY This table stores records about asset history events. INV_HIST_ID This column contains a unique number obtained from the COUNTERS table to uniquely identify the history record for an asset. INTEGER NOT NULL
INVENTORY_HISTORY This table stores records about asset history events. IS_INVENTORY_ID This column contains the identification of the asset that the history record is associated with. INTEGER NOT NULL
INVENTORY_HISTORY This table stores records about asset history events. K_EVENT This column identifies where the history record was created. K =1 if the history record was created from the contract dialog as an Install Date. SMALLINT NULL
INVENTORY_HISTORY This table stores records about asset history events. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
INVENTORY_HISTORY This table stores records about asset history events. MODIFY_USER The user ID of the person who approved a change (planned event) or marked the change complete (completed event). VARCHAR2(18) NULL
INVENTORY_HISTORY This table stores records about asset history events. PLANNED This column contains an indication of whether the event is a planned or completed event. Planned is 1 if the record is a planned event and 0 if the event is complete SMALLINT NULL
INVENTORY_HISTORY This table stores records about asset history events. TECHNICIAN Name of the technician entered by the user when the event is planned or when the event is entered by the user as a complete event VARCHAR2(40) NULL
IS_INVENTORY This table stores asset records. ALTERNATE_TAG User specified alternate number for identifying the asset. VARCHAR2(40) NULL
IS_INVENTORY This table stores asset records. ASSET_TAG A unique, user specified number that identifies the asset. VARCHAR2(40) NOT NULL
IS_INVENTORY This table stores asset records. FLX_EINV_VCHR1 This column contains a 254-character field for customization purposes. VARCHAR2(254) NULL
IS_INVENTORY This table stores asset records. FLX_EINV_VCHR2 This column contains a 254-character field for customization purposes. VARCHAR2(254) NULL
IS_INVENTORY This table stores asset records. FLX_EINV_VCHR3 This column contains a 254-character field for customization purposes. VARCHAR2(254) NULL
IS_INVENTORY This table stores asset records. H_OBJECT_ID The unique inventory category number for the asset's inventory category provided by the user. This may be NULL. VARCHAR2(15) NULL
IS_INVENTORY This table stores asset records. H_OBJECT_NAME The name of asset's inventory category provided by the user. This may be NULL. VARCHAR2(40) NULL
IS_INVENTORY This table stores asset records. I_OBJECT_ID The unique model number for the asset's model provided by the user. This may be NULL. VARCHAR2(15) NULL
IS_INVENTORY This table stores asset records. INV_DELETED This column contains an indicator for whether the asset has been marked for future delete. SMALLINT NULL
IS_INVENTORY This table stores asset records. INV_DESCRIPTION The name of asset's model provided by the user. This may be NULL. The model name must be a valid model for the assets inventory category. VARCHAR2(40) NULL
IS_INVENTORY This table stores asset records. IS_INVENTORY_ID This column contains a unique number obtained from the COUNTERS table to identify the asset. H_Object_ID uniquely identifies an asset.d. INTEGER NOT NULL
IS_INVENTORY This table stores asset records. LOCATION_ID The unique location ID number for the location of the asset specified by the user. This may be NULL. VARCHAR2(15) NULL
IS_INVENTORY This table stores asset records. MFGR_NO Manufacturer's serial number for the asset. No validation is done on this field. VARCHAR2(40) NULL
IS_INVENTORY This table stores asset records. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
IS_INVENTORY This table stores asset records. NOTES This column contains free-form text notes about the asset. VARCHAR2(256) NULL
IS_INVENTORY This table stores asset records. ORGANIZATION_ID The unique organization ID number for the organization of the asset specified by the user. This may be NULL. VARCHAR2(15) NULL
IS_INVENTORY This table stores asset records. PM_OBJECT_ID This is a unique number that identifies the asset (IS_INVENTORY_ID), the assets' category (H_OBJECT_ID) and the assets' model (I_OBJECT_ID). It seems redundant of IS_INVENTORY_ID. VARCHAR2(40) NULL
IS_INVENTORY This table stores asset records. PURCHASE_ID Purchase order number for the asset. No validation is done on this field and currently does not have any link to a purchase event, purchase or acquisition contract. VARCHAR2(18) NULL
IS_INVENTORY This table stores asset records. SERVICE_ID Service order number for the asset. No validation is done on this field and currently does not have any link to a service event or contract for the asset. VARCHAR2(18) NULL
IS_INVENTORY This table stores asset records. STATUS Current status of the asset. The assets' status is "Audited" when the asset is initially added. Future completed events for the asset will update the asset status. User defined events will update the status to the event code (Event_Name) specified by the user when the planned event is created. There are also system-generated events such as "Audited". Tivoli Change Management does not seem to update the asset status when the change request is completed ("Affected By Change"). VARCHAR2(10) NULL
IS_INVENTORY This table stores asset records. VALID_DATA In a secure environment, this column identifies if all related data is valid for the asset. SMALLINT NULL
IS_INVENTORY This table stores asset records. VISIBLE_ORG Identifies the organization that has "ownership" of the asset in a secure environment. VARCHAR2(15) NULL
MAINTENANCE_FEE This table stores maintenance fee records an asset. ACTUAL This column contains the actual cost of the maintenance event. FLOAT NULL
MAINTENANCE_FEE This table stores maintenance fee records an asset. CURRENCY_CODE This column contains the code for cost(s) of the maintenance event. VARCHAR2(3) NOT NULL
MAINTENANCE_FEE This table stores maintenance fee records an asset. ESTIMATE This column contains the estimated cost of the maintenance event. FLOAT NULL
MAINTENANCE_FEE This table stores maintenance fee records an asset. IS_INVENTORY_ID This column contains the identification of the asset associated with the maintenance fee record. INTEGER NULL
MAINTENANCE_FEE This table stores maintenance fee records an asset. MAINTENANCE_FEE_ID This column contains a unique number obtained from the COUNTERS to uniquely identify the maintenance fee record for the asset. INTEGER NOT NULL
MAINTENANCE_FEE This table stores maintenance fee records an asset. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
MAINTENANCE_FEE This table stores maintenance fee records an asset. PLAN_DATE This column contains the planned date for the maintenance event. DATE NULL
MIGRATION This table can holds CSV settings for future run-time or scheduled migrations. AFILE This column holds the name of the file to use for the CSV migration VARCHAR2(254) NOT NULL
MIGRATION This table can holds CSV settings for future run-time or scheduled migrations. CLASS This column holds the category for the CSV migration. VARCHAR2(40) NULL
MIGRATION This table can holds CSV settings for future run-time or scheduled migrations. CURRENCY_CODE This column holds the currency code associated with the CSV migration VARCHAR2(3) NULL
MIGRATION This table can holds CSV settings for future run-time or scheduled migrations. H_OBJECT_ID This column holds the unique inventory category number for the CSV migration's inventory category. VARCHAR2(15) NULL
MIGRATION This table can holds CSV settings for future run-time or scheduled migrations. IGNORERECORD This column contains the selection for the ignore first record checkbox in the Migration Mappings group box on the Mapping page of the Asset Migration Utility dialog. Possible values are 1 for Ignore and 0 for do not ignore. SMALLINT NULL
MIGRATION This table can holds CSV settings for future run-time or scheduled migrations. MIG_ACTION This column holds the value for the Connection and People radio button group found on the Files page of the Asset Migration Utility dialog. INTEGER NULL
MIGRATION This table can holds CSV settings for future run-time or scheduled migrations. MIGRATION_ID This column contains the unique identification for the CSV file migration. INTEGER NOT NULL
MIGRATION This table can holds CSV settings for future run-time or scheduled migrations. MIGRATION_NAME This column holds the user defined name for the CSV migration settings. VARCHAR2(254) NOT NULL
MIGRATION This table can holds CSV settings for future run-time or scheduled migrations. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
MIGRATION This table can holds CSV settings for future run-time or scheduled migrations. NO_FIELDS This column holds the number of CSV fields associated with CSV mapping. This number is determined from the number of column in the CSV input file. INTEGER NULL
MIGRATION This table can holds CSV settings for future run-time or scheduled migrations. ORGANIZATION_ID This column contains the multi-customer organization_id to be associated with the migrated CSVrecord. VARCHAR2(15) NULL
MIGRATION This table can holds CSV settings for future run-time or scheduled migrations. ORGTOCOST This column indicates if the organization that owns the CSV migration should be set as the asset's cost center Integer NULL
PM_ATTRIB_VALUE This table holds attribute values for an asset when the attribute values for the asset are different than the default model values. This table also contains the values of attributes when an asset is associated with an asset category, but does not have a model. ATTRIB_ID Uniquely identifies the attribute for the category of the asset. INTEGER NOT NULL
PM_ATTRIB_VALUE This table holds attribute values for an asset when the attribute values for the asset are different than the default model values. This table also contains the values of attributes when an asset is associated with an asset category, but does not have a model. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
PM_ATTRIB_VALUE This table holds attribute values for an asset when the attribute values for the asset are different than the default model values. This table also contains the values of attributes when an asset is associated with an asset category, but does not have a model. PHYSVALUE The actual asset value for the attribute. For example, the actual amount of RAM in Asset # 000-1234-SAI is 16MB. This asset is of model type NEC Versa 4000 that comes standard with 8MB of RAM. VARCHAR2(80) NULL
PM_ATTRIB_VALUE This table holds attribute values for an asset when the attribute values for the asset are different than the default model values. This table also contains the values of attributes when an asset is associated with an asset category, but does not have a model. PM_OBJECT_ID A unique number obtained from the COUNTERS table to identify the instance of an asset. PM_Object_ID is a concatenation of IS_Inventory_ID, H_Object_ID, and I_Object_ID. VARCHAR2(15) NOT NULL
PM_OBJECT This table stores a record for an asset when an asset has attribute values that are different than the model default values or when an asset is used in an asset hierarchy (Container) H_OBJECT_ID Number that uniquely identifies an inventory category. This is the inventory category of the asset. VARCHAR2(15) NULL
PM_OBJECT This table stores a record for an asset when an asset has attribute values that are different than the model default values or when an asset is used in an asset hierarchy (Container) I_OBJECT_ID Number that uniquely identifies a model of an inventory category. This is the model of the asset. VARCHAR2(15) NULL
PM_OBJECT This table stores a record for an asset when an asset has attribute values that are different than the model default values or when an asset is used in an asset hierarchy (Container) IS_INVENTORY_ID This column contains the unique internal identification for the asset (IS_INVENTORY) record in the relationship. INTEGER NOT NULL
PM_OBJECT This table stores a record for an asset when an asset has attribute values that are different than the model default values or when an asset is used in an asset hierarchy (Container) MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
PM_OBJECT This table stores a record for an asset when an asset has attribute values that are different than the model default values or when an asset is used in an asset hierarchy (Container) PM_OBJECT_ID A unique number obtained from the COUNTERS table to identify the instance of an asset. PM_Object_ID is a concatenation of IS_Inventory_ID, H_Object_ID, and I_Object_ID. VARCHAR2(15) NOT NULL
PM_OBJECT This table stores a record for an asset when an asset has attribute values that are different than the model default values or when an asset is used in an asset hierarchy (Container) PM_OBJECT_NAME The name of the instance of the asset. This is the asset tag (Asset_Tag) for the asset. VARCHAR2(40) NOT NULL
PM_OBJECT_TREE This table stores attribute values for assets without models, and attribute values that override the a model's default attribute values. CHILD This column contains the asset ID of the child node for the parent-child relationship in the asset hierarchy (Container). VARCHAR2(15) NOT NULL
PM_OBJECT_TREE This table stores attribute values for assets without models, and attribute values that override the a model's default attribute values. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
PM_OBJECT_TREE This table stores attribute values for assets without models, and attribute values that override the a model's default attribute values. PARENT This column contains the parent asset ID for the parent-child relationship in the asset hierarchy (Containers). The parent node for all root level assets is 0. VARCHAR2(15) NOT NULL
REPORT_ATTRIB This table stores information about the attributes associated with the asset category (H_OBJECT_ID) named in the REPORT_H_OBJ table for a Tivoli Asset Management saved report query. ATTRIB_DATA_TYPE This column contains the attribute value data type. VARCHAR2(15) NULL
REPORT_ATTRIB This table stores information about the attributes associated with the asset category (H_OBJECT_ID) named in the REPORT_H_OBJ table for a Tivoli Asset Management saved report query. ATTRIB_ID This column contains the attribute identification. INTEGER NULL
REPORT_ATTRIB This table stores information about the attributes associated with the asset category (H_OBJECT_ID) named in the REPORT_H_OBJ table for a Tivoli Asset Management saved report query. ATTRIB_NAME This column contains the name of the attribute. VARCHAR2(40) NULL
REPORT_ATTRIB This table stores information about the attributes associated with the asset category (H_OBJECT_ID) named in the REPORT_H_OBJ table for a Tivoli Asset Management saved report query. ATTRIB_OBJECT_TYPE This column contains either I for I_ATTRIB_VALUE/I_OBJECT or, P for PM_ATTRIB_VALUE/PM_OBJECT. VARCHAR2(1) NULL
REPORT_ATTRIB This table stores information about the attributes associated with the asset category (H_OBJECT_ID) named in the REPORT_H_OBJ table for a Tivoli Asset Management saved report query. ATTRIB_OP This column contains the mathematical operator for the attribute expression. VARCHAR2(40) NULL
REPORT_ATTRIB This table stores information about the attributes associated with the asset category (H_OBJECT_ID) named in the REPORT_H_OBJ table for a Tivoli Asset Management saved report query. ATTRIB_VALUE This column contains the actual value of the attribute. VARCHAR2(80) NULL
REPORT_ATTRIB This table stores information about the attributes associated with the asset category (H_OBJECT_ID) named in the REPORT_H_OBJ table for a Tivoli Asset Management saved report query. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
REPORT_ATTRIB This table stores information about the attributes associated with the asset category (H_OBJECT_ID) named in the REPORT_H_OBJ table for a Tivoli Asset Management saved report query. REPORT_ATTRIB_ID This column contains the unique identification of a report attribute record. INTEGER NOT NULL
REPORT_ATTRIB This table stores information about the attributes associated with the asset category (H_OBJECT_ID) named in the REPORT_H_OBJ table for a Tivoli Asset Management saved report query. REPORT_H_OBJ_ID This column contains the asset category name. INTEGER NOT NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. ASSET_TAG This column contains the asset tag string used in the query. VARCHAR2(40) NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. CONTRACT_END_FROM This column contains the date the contract must expire by when selecting assets for the query. DATE NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. CONTRACT_END_TO This column contains the the contract must expire before when selecting assets for the query. DATE NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. CONTRACT_NUMBER This column contains the asset tag string used in the query. VARCHAR2(40) NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. CONTRACT_PUR_VEND This column contains the purchase vendor identification string used in the query. VARCHAR2(18) NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. CONTRACT_SEC_VEND This column contains the secondary vendor contract identification string used in the query. VARCHAR2(18) NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. CONTRACT_TYPE This column contains the type of contract used in the query. VARCHAR2(18) NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. CONTRACT_VENDOR_ID This column contains the contract vendor identification string used in the query. VARCHAR2(15) NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. CONTRACT_WAR_VEND This column contains the warranty contract vendor identification string used in the query. VARCHAR2(18) NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. DESTINATION This column contains the destination (screen, printer, notebook, or file) for the resulting assets when the report is run. INTEGER NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. FILENAME This column contains the name of the file the report was written to. VARCHAR2(50) NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. FINANCE_COLS This column contains the list of valuation-related columns to be included in the report. VARCHAR2(254) NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. FINANCE_COLUMN This column contains the financial value type, for example, acquisition, book value, or salvage value. VARCHAR2(20) NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. FINANCE_CURRENCY This column contains the three-character currency code representing the currency type used in a valuation expression for the query. VARCHAR2(3) NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. FINANCE_OP This column contains a mathematical operator used for the the asset query. VARCHAR2(40) NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. FINANCE_VALUE This column contains the value used in a valuation expression for the query. FLOAT NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. HEADER This column contains a user-defined description of the report. VARCHAR2(254) NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. HIST_EVENT_NAME This column contains the event type used in the query. VARCHAR2(40) NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. HIST_FROM This column contains the date all events must occur after when selecting assets for the query. DATE NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. HIST_TO This column contains the date all events must occur before when selecting assets for the query. DATE NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. INCLUDE_NULL_C This column contains the identification of the connection. INTEGER NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. INCLUDE_NULL_H This column contains the identification of the asset category. INTEGER NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. INCLUDE_NULL_I This column contains the identification of the asset model. INTEGER NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. INCLUDE_NULL_L This column contains the identification of the location. INTEGER NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. INCLUDE_NULL_O This column contains the identification of the organization. INTEGER NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. INV_COLS This column contains sepcified columns for the report from the financial columns list. VARCHAR2(254) NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. ORGANIZATION_ID This column identifies the organization that has "ownership of the report in a secure environment. VARCHAR2(15) NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. PEOPLE_ID This column contains the user name used in the query. INTEGER NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. REPORT_DETAIL_ID This column contains a unique internal identification for the report query record. INTEGER NOT NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. REPORT_NAME This column contains the user-defined name of the report. VARCHAR2(80) NOT NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. SMS_FILTER This column contains the values entered in the query for selecting SMS assets. VARCHAR2(254) NULL
REPORT_DETAIL This table stores a record for each Tivoli Asset Management report query. SMS_SELECT This column contains the SQL select string created from the SMS_FILTER values. VARCHAR2(1024) NULL
REPORT_H_OBJ This table stores records that associate an asset category with a saved Tivoli Asset Management report query. H_OBJECT_ID This column contains the asset category ID for the Tivoli Asset Management report query. VARCHAR2(15) NULL
REPORT_H_OBJ This table stores records that associate an asset category with a saved Tivoli Asset Management report query. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
REPORT_H_OBJ This table stores records that associate an asset category with a saved Tivoli Asset Management report query. NAME This column contains the asset category name for the Tivoli Asset Management report query. VARCHAR2(40) NULL
REPORT_H_OBJ This table stores records that associate an asset category with a saved Tivoli Asset Management report query. REPORT_DETAIL_ID This column contains the identification of the stored Tivoli Asset Management report query that this asset category record is associated with. INTEGER NOT NULL
REPORT_H_OBJ This table stores records that associate an asset category with a saved Tivoli Asset Management report query. REPORT_H_OBJ_ID This column contains the unique identifer for the asset category record. INTEGER NOT NULL
REPORT_H_OBJ This table stores records that associate an asset category with a saved Tivoli Asset Management report query. SUBTREE This column contains an indicator for whether to include child categories of the category identified in the H_OBJECT_ID column. SMALLINT NULL
REPORT_I_OBJ This table stores information about the models associated with the asset category (H_OBJECT_ID) named in the REPORT_H_OBJ table for a Tivoli Asset Management saved report query. I_OBJECT_ID This column contains the model identification. VARCHAR2(15) NULL
REPORT_I_OBJ This table stores information about the models associated with the asset category (H_OBJECT_ID) named in the REPORT_H_OBJ table for a Tivoli Asset Management saved report query. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
REPORT_I_OBJ This table stores information about the models associated with the asset category (H_OBJECT_ID) named in the REPORT_H_OBJ table for a Tivoli Asset Management saved report query. NAME This column contains the model name. VARCHAR2(40) NULL
REPORT_I_OBJ This table stores information about the models associated with the asset category (H_OBJECT_ID) named in the REPORT_H_OBJ table for a Tivoli Asset Management saved report query. REPORT_H_OBJ_ID This column contains the asset category report ID assocated with the REPORT_H_OBJ table. INTEGER NOT NULL
REPORT_I_OBJ This table stores information about the models associated with the asset category (H_OBJECT_ID) named in the REPORT_H_OBJ table for a Tivoli Asset Management saved report query. REPORT_I_OBJ_ID This column contains the unique identification for the model associated with the asset category. INTEGER NOT NULL
REPORT_TREE MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
REPORT_TREE NODE_ID This column contains the unique ID of the node's position in the location, organization, or conection hierarchy. VARCHAR2(15) NULL
REPORT_TREE NODE_NAME This column contains the name of the node in the location, organization, or conection hierarchy. VARCHAR2(40) NULL
REPORT_TREE REPORT_DETAIL_ID This column contains the REPORT_DETAIL record ID to associate with the current record. INTEGER NOT NULL
REPORT_TREE REPORT_TREE_ID Unique key for the report tree record. INTEGER NOT NULL
REPORT_TREE SUBTREE This column indicates whether the record should include child records from the hierarchy. SMALLINT NULL
REPORT_TREE TREE This column identifies which hierarchy the record is associated with. VARCHAR2(40) NOT NULL
SCIM_TRANSLATE This table stores the relationships between an asset categories and the records in the SYSTEM, COMPONENT, ITEM, and MODULE tables. COMPONENT_ID This column contains the identifcation of the COMPONENTrecord associated with the SCIM. VARCHAR2(15) NULL
SCIM_TRANSLATE This table stores the relationships between an asset categories and the records in the SYSTEM, COMPONENT, ITEM, and MODULE tables. H_OBJECT_ID This column contains the unique asset category identification for the asset category associated with the SCIM record. VARCHAR2(15) NOT NULL
SCIM_TRANSLATE This table stores the relationships between an asset categories and the records in the SYSTEM, COMPONENT, ITEM, and MODULE tables. ITEM_ID This column contains the identifcation of the ITEM record associated with the SCIM. VARCHAR2(15) NULL
SCIM_TRANSLATE This table stores the relationships between an asset categories and the records in the SYSTEM, COMPONENT, ITEM, and MODULE tables. MODIFY_DATETIME Date and time of the last modification. INTEGER NULL
SCIM_TRANSLATE This table stores the relationships between an asset categories and the records in the SYSTEM, COMPONENT, ITEM, and MODULE tables. MODULE_ID This column contains the identifcation of the MODULE record associated with the SCIM. VARCHAR2(15) NULL
SCIM_TRANSLATE This table stores the relationships between an asset categories and the records in the SYSTEM, COMPONENT, ITEM, and MODULE tables. SCIM_ID Record obtained from the COUNTERS table to uniquely identify the SCIM_TRANSLATE record. INTEGER NOT NULL
SCIM_TRANSLATE This table stores the relationships between an asset categories and the records in the SYSTEM, COMPONENT, ITEM, and MODULE tables. SYSTEM_ID This column contains the identifcation of the SYSTEM record associated with the SCIM. VARCHAR2(15) NOT NULL
VALUATION This table stores the information used to calculate depreciated value of assets. ACQUISITION_VALUE This column contains the acquisition value amount for the asset. FLOAT NULL
VALUATION This table stores the information used to calculate depreciated value of assets. BOOK_VALUE This column contains the calculated depreciated value for the asset. FLOAT NULL
VALUATION This table stores the information used to calculate depreciated value of assets. BUYOUT This column contains an indicator for whether to purchase the leased asset. SMALLINT NULL
VALUATION This table stores the information used to calculate depreciated value of assets. CURRENCY_CODE This column contains the code of the currency for the valuation costs. VARCHAR2(3) NOT NULL
VALUATION This table stores the information used to calculate depreciated value of assets. DATE_ACQUIRED This column contains the date your enterprise acquired the asset. There is no tie the purchase order for the asset. DATE NULL
VALUATION This table stores the information used to calculate depreciated value of assets. DATE_DISPOSED This column contains the date the asset was disposed. There is no tie between DATE_DISPOSED and completed events for the asset. For example, the Disposed event does not update this field. DATE NULL
VALUATION This table stores the information used to calculate depreciated value of assets. DEPREC_LIFE The life of the asset for depreciation purposes. SMALLINT NULL
VALUATION This table stores the information used to calculate depreciated value of assets. DEPREC_METHOD This column contains an indicator for the type of depreciation calculation method to be used. VARCHAR2(20) NULL
VALUATION This table stores the information used to calculate depreciated value of assets. DEPREC_PERIOD Depreciation period. SMALLINT NULL
VALUATION This table stores the information used to calculate depreciated value of assets. FLX_VAL_DATE1 This column contains a date field for customization purposes. DATE NULL
VALUATION This table stores the information used to calculate depreciated value of assets. FLX_VAL_DATE2 This column contains a date field for customization purposes. DATE NULL
VALUATION This table stores the information used to calculate depreciated value of assets. FLX_VAL_DATE3 This column contains a date field for customization purposes. DATE NULL
VALUATION This table stores the information used to calculate depreciated value of assets. FLX_VAL_INT1 This column contains an integer field for customization purposes. INTEGER NULL
VALUATION This table stores the information used to calculate depreciated value of assets. FLX_VAL_INT2 This column contains an integer field for customization purposes. INTEGER NULL
VALUATION This table stores the information used to calculate depreciated value of assets. FLX_VAL_INT3 This column contains an integer field for customization purposes. INTEGER NULL
VALUATION This table stores the information used to calculate depreciated value of assets. FLX_VAL_VCHR1 This column contains a 254-character field for customization purposes. VARCHAR(254) NULL
VALUATION This table stores the information used to calculate depreciated value of assets. FLX_VAL_VCHR2 This column contains a 254-character field for customization purposes. VARCHAR(254) NULL
VALUATION This table stores the information used to calculate depreciated value of assets. FLX_VAL_VCHR3 This column contains a 254-character field for customization purposes. VARCHAR(254) NULL
VALUATION This table stores the information used to calculate depreciated value of assets. INSURED_VALUE This column contains the amount the asset is insured for. FLOAT NULL
VALUATION This table stores the information used to calculate depreciated value of assets. IS_INVENTORY_ID This column identifies the asset associated with this valuation record. INTEGER NOT NULL
VALUATION This table stores the information used to calculate depreciated value of assets. LEASE_BUYOUT This column contains the amount paid to buy out the asset's lease. FLOAT NULL
VALUATION This table stores the information used to calculate depreciated value of assets. LEASE_END This column contains the lease end date. DATE NULL
VALUATION This table stores the information used to calculate depreciated value of assets. LEASE_START This column contains the lease start date. DATE NULL
VALUATION This table stores the information used to calculate depreciated value of assets. LEASE_VALUE This column contains the lease value for the asset. FLOAT NULL
VALUATION This table stores the information used to calculate depreciated value of assets. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
VALUATION This table stores the information used to calculate depreciated value of assets. SALVAGE_VALUE Salvage value for the asset FLOAT NULL
VALUATION This table stores the information used to calculate depreciated value of assets. VALUATION_ID A unique number obtained from the COUNTERS table to uniquely identify the valuation record for an asset. Since there is a 1 to 1 relationship with IS_Inventory, IS_Inventory_ID also uniquely identifies the valuation record. INTEGER NOT NULL