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 |