Tivoli Change Management Data Dictionary

Table Name Table Comment Table Column Name Table Column Comment Table Column Datatype Table Column Null Option
ACTIONS This table contains the actions that are taken during command processing or during rule processing. ACTION_ID This column contains the unique identifier for the table and is an opaque ID. INTEGER NOT NULL
ACTIONS This table contains the actions that are taken during command processing or during rule processing. COMMAND This column defines the Command name that is associated with the action. VARCHAR(40) NULL
ACTIONS This table contains the actions that are taken during command processing or during rule processing. CONTENTS This column is the value that is applied to the given Field_Name during a Set Field action type. VARCHAR(80) NULL
ACTIONS This table contains the actions that are taken during command processing or during rule processing. DURATION This column defines the allotted duration of the task. It is usually expressed in number of days. FLOAT NULL
ACTIONS This table contains the actions that are taken during command processing or during rule processing. FIELD_NAME This column defines the field within the change record that will be set to a given value during a Set Field action type. VARCHAR(80) NULL
ACTIONS This table contains the actions that are taken during command processing or during rule processing. GROUP_ID This is the group that will be affected by the action. VARCHAR(20) NULL
ACTIONS This table contains the actions that are taken during command processing or during rule processing. LABOR_HOURS This column defines the expected number of labor hours for the given task. FLOAT NULL
ACTIONS This table contains the actions that are taken during command processing or during rule processing. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
ACTIONS This table contains the actions that are taken during command processing or during rule processing. ORGANIZATION_ID This column defines the organization that will be notified if the action type is for notification. CHAR(15) NULL
ACTIONS This table contains the actions that are taken during command processing or during rule processing. PRIORITY This column defines the priority of the the rule action in relation to the other rule actions for a given rule. VARCHAR(3) NULL
ACTIONS This table contains the actions that are taken during command processing or during rule processing. RULE_ID This column contains the foreign key definition to the rule table. INTEGER NOT NULL
ACTIONS This table contains the actions that are taken during command processing or during rule processing. SITE_ID This is the site_id associated with the group_id unique identifier. VARCHAR(20) NULL
ACTIONS This table contains the actions that are taken during command processing or during rule processing. TASK_NAME This column contains the name of the task that will have the duration and hours applied to it. VARCHAR(40) NULL
ACTIONS This table contains the actions that are taken during command processing or during rule processing. TYPE This column defines which type of action will be taken if the rule condition evaluates to true. VARCHAR(18) NULL
ACTIONS This table contains the actions that are taken during command processing or during rule processing. USER_ID This is the user id that will be applied as part of this action. VARCHAR(20) NULL
ACTIONS This table contains the actions that are taken during command processing or during rule processing. WHO_NAME This column contains the name of the Person, CCB Group or Organization associated with the rule action. VARCHAR(80) NULL
APPROVAL This table defines the approval requirements for a given change or activity. APP_STATUS_STRING This columns tracks the specific status given by a user of a CCB. VARCHAR(254) NULL
APPROVAL This table defines the approval requirements for a given change or activity. APP_TYPE_STRING This columns tracks the authority of the given user when the approval action was taken by a user of a CCB. VARCHAR(254) NULL
APPROVAL This table defines the approval requirements for a given change or activity. APP_USER_STRING This columns tracks those users within a CCB that have given their approval or reject authority to the approval requirement. VARCHAR(254) NULL
APPROVAL This table defines the approval requirements for a given change or activity. APPROVAL_DATE This is the date that the approval action took place. DATE NULL
APPROVAL This table defines the approval requirements for a given change or activity. APPROVAL_TIME This is the time that the approval action took place. CHAR(10) NULL
APPROVAL This table defines the approval requirements for a given change or activity. APPROVER_ID The unique identifier of this table. It is an opaque ID. INTEGER NOT NULL
APPROVAL This table defines the approval requirements for a given change or activity. APPROVER_NAME This is the name of the currently logged on user who took the indicated approval action. VARCHAR(80) NULL
APPROVAL This table defines the approval requirements for a given change or activity. APPROVER_TYPE Indicates if this is an approval requirement for an group or person. VARCHAR(18) NULL
APPROVAL This table defines the approval requirements for a given change or activity. CHANGE_ID The unique identifier of the parent change request that this approval requirement is associated with. INTEGER NOT NULL
APPROVAL This table defines the approval requirements for a given change or activity. DELETABLE Indicates if this approval requirement can be manually deleted by the user. VARCHAR(3) NULL
APPROVAL This table defines the approval requirements for a given change or activity. DISP_REASON A free form text field that allows the user to record why the approval action was taken. VARCHAR(254) NULL
APPROVAL This table defines the approval requirements for a given change or activity. DISPOSITION This is the specific approval action taken against this approval requirement. VARCHAR(18) NULL
APPROVAL This table defines the approval requirements for a given change or activity. GROUP_ID The group that is responsible for acting on this approval requirement. VARCHAR(20) NULL
APPROVAL This table defines the approval requirements for a given change or activity. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
APPROVAL This table defines the approval requirements for a given change or activity. PRIORITY This controls the order in which the approval requirements are made available for approval action. VARCHAR(3) NULL
APPROVAL This table defines the approval requirements for a given change or activity. SITE_ID This column defines the which site orginated this record. VARCHAR(20) NULL
APPROVAL This table defines the approval requirements for a given change or activity. USER_ID This is the USER that must perform an approval action against the parent change. VARCHAR(20) NULL
ASSOCIATED_PROBLEM This table defines the problem records that are associated with a given change. CHANGE_ID This is the change_id for a given problem-change relationship. It is foreign keyed to the change table. INTEGER NOT NULL
ASSOCIATED_PROBLEM This table defines the problem records that are associated with a given change. DESCRIPTION This column tracks the contents of the problem_result field from the problem ticket associated with the change. VARCHAR(254) NULL
ASSOCIATED_PROBLEM This table defines the problem records that are associated with a given change. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
ASSOCIATED_PROBLEM This table defines the problem records that are associated with a given change. PROBLEM_ID This is the problem_id for a given problem-change relationship. It is foreign-keyed to the problem table. CHAR(15) NOT NULL
BLACKOUT This table defines blackouts which are designated periods of time when certain categories of changes cannot occur. BLACKOUT_ID This column defines the unique name of the blackout definition. It is controlled by the user. VARCHAR(40) NOT NULL
BLACKOUT This table defines blackouts which are designated periods of time when certain categories of changes cannot occur. CATEGORY This column defines the category associated with the blackout. VARCHAR(18) NULL
BLACKOUT This table defines blackouts which are designated periods of time when certain categories of changes cannot occur. DAYS This column defines the day of the week to which the blackout applies. VARCHAR(18) NULL
BLACKOUT This table defines blackouts which are designated periods of time when certain categories of changes cannot occur. END_TIME This column defines the end time (24 hour clock) for the blackout. CHAR(10) NULL
BLACKOUT This table defines blackouts which are designated periods of time when certain categories of changes cannot occur. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
BLACKOUT This table defines blackouts which are designated periods of time when certain categories of changes cannot occur. START_TIME This column defines the start time (24 hour clock) for the blackout. CHAR(10) NULL
CATEGORY This table contains the change category defintions. ADHOC This defines the site_id for this organization. SMALLINT NULL
CATEGORY This table contains the change category defintions. CATEGORY This column defines the unique id of the change category. It is controlled by the user. VARCHAR(18) NOT NULL
CATEGORY This table contains the change category defintions. DESCRIPTION This column contains the description of the change category. It is not unique, and is often times displayed on the user interface in lieu of the category column. VARCHAR(80) NULL
CATEGORY This table contains the change category defintions. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
CATEGORY This table contains the change category defintions. ORGANIZATION_ID This column defines this category's security organization. CHAR(15) NULL
CATEGORY_TREE This table is used to maintain the parent/child relationships between change categories. CHILD This column contains the change_id of the child change request. VARCHAR(18) NOT NULL
CATEGORY_TREE This table is used to maintain the parent/child relationships between change categories. PARENT This column contains the change_id of the parent change request. VARCHAR(18) NOT NULL
CATEGORY_TREE This table is used to maintain the parent/child relationships between change categories. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. ACT_END_DATE This is the date that the work associated with the change actually ended. DATE NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. ACT_END_TIME This is the time associated with the act_end_date. CHAR(10) NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. ACT_ST_DATE This is the date that the work associated with the change actually started. DATE NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. ACT_ST_TIME This is the time associated with the act_st_date. CHAR(10) NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. ACTIVE_WITH This is the time associated with the act_st_date. TSD_CHAR_15 NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. APPROVAL_METHOD This indicates the approval method in effect for the change. The valid types are Accepts All Activites or Depends on Activities. VARCHAR(18) NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. ASSIGNED_TO The PEOPLE_ID of the USER that this change request is assigned to. VARCHAR(20) NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. AUTHOR The user_id of the person who physically opened the change record. INTEGER NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. BUSINESS_REASON This is a free form text field that provides business justification for accepting the request. VARCHAR(254) NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. CATEGORY This defines the high level categorization, (i.e., type) of change. VARCHAR(18) NOT NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. CHANGE_ID This is the unique identifier of the change. It is an opaque id. INTEGER NOT NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. CHANGE_MASK This column defines the security mask in place for this change. INTEGER NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. CHANGE_NUMBER This is the exposed identifier of the change that is typically prefixed with a user defined value and then followed by the change_id. VARCHAR(40) NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. COST This is the actual cost of materials that were needed to implement the change. FLOAT NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. COST_CENTER This is the cost_center that will be charged for any expenses relating to the change. CHAR(15) NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. CREATION_DATE This is the date that the change was physically created. DATE NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. CREATION_TIME This is the time associated with the creation_date. CHAR(10) NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. CURRENCY This is the currency type associated with the various costs. VARCHAR(3) NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. DELETABLE This column controls whether this record can be deleted if it is an Activity of a Change. VARCHAR(3) NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. DESCRIPTION This is free form text that describes what is being requested. VARCHAR(254) NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. EST_COST This is the estimated total cost of the materials needed to implement the change. FLOAT NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. EST_LABOR_COST This is the estimated total cost of the labor resources needed to implement the change. FLOAT NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. LABOR_COST This is the actual cost of materials that were needed to implement the change. FLOAT NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. LOCATION_ID This is the location that will be affected by the change. CHAR(15) NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. MODEL_ID This is the id of the model record that has been applied against this Change record. INTEGER NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. NAME This is the text that further identifies the change_number. VARCHAR(80) NOT NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. NETWORK_RESOURCES This is a free form text field that descibes a plan for returning all affected items to their original condition before that change implementation was attempted. VARCHAR(254) NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. NOTIFY_ON_APPROVAL This controls whether or not notifications are sent when the change is fully approved. VARCHAR(3) NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. ORGANIZATION_ID This is the organization that is requesting the change. It defines the security domain in a secured environment. CHAR(15) NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. PLAN_END_DATE This is the date that the work associated with the change is planned to end. DATE NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. PLAN_END_TIME This is the time associated with the plan_end_date. CHAR(10) NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. PLAN_ST_DATE This is the date that the work associated with the change is planned to start. DATE NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. PLAN_ST_TIME This is the time associated with the plan_st_date. CHAR(10) NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. PRIORITY This field represents the priority of this change request in relation to other change requests. VARCHAR(40) NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. REQUESTER_ID This is the PEOPLE_ID of the USER that requested the change request. INTEGER NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. REQUESTER_NAME This is the full name of the person requesting the change. VARCHAR(80) NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. RESPONSIBLE_GROUP This is the group that is responsible for the change request. VARCHAR(40) NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. RISK_CODE This column is the unique identifier and is user defined. It defines the risk code that is displayed to the user in the risk field on the change dialog. VARCHAR(18) NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. RISK_REASON This is free form text that outlines possible exposure to loss or failure. VARCHAR(254) NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. SITE_ID This is the site id associated with the responsible group which uniquely identifies that group. VARCHAR(20) NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. SPECIAL_REQUIREMEN This is free form text that describes any resources required to implement the change. VARCHAR(254) NULL
CHANGE This table contains the high level change record. It is the focal point for all change management activities. STATUS_ID This is the status_id from the change_status table that indicates the current overall status of the change. VARCHAR(18) NOT NULL
CHANGE_ATTACHMENT This table defines the types and locations of the files that help to define the change request. CHANGE_ID This is the change_id for a given attachment. It is foreign keyed to the change table. INTEGER NOT NULL
CHANGE_ATTACHMENT This table defines the types and locations of the files that help to define the change request. DELETEABLE This column indicates if the attachment can be deleted by the user. VARCHAR(3) NULL
CHANGE_ATTACHMENT This table defines the types and locations of the files that help to define the change request. FIELD_NAME This column indicates which column within a given type of record that attachment is associated with. VARCHAR(18) NULL
CHANGE_ATTACHMENT This table defines the types and locations of the files that help to define the change request. FILE_NAME This is the file name of the attachment. It contains the full path and file name. VARCHAR(254) NOT NULL
CHANGE_ATTACHMENT This table defines the types and locations of the files that help to define the change request. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
CHANGE_ATTACHMENT This table defines the types and locations of the files that help to define the change request. MODULE_ID This column tracks the type of attachment by identifying the module name that caused the attachment. VARCHAR(80) NULL
CHANGE_ATTACHMENT This table defines the types and locations of the files that help to define the change request. TABLE_NAME An attachment can be associated with a Model, Implement Schedule or Change. This column indicates which type of record it is associated with. VARCHAR(18) NULL
CHANGE_HISTORY This table contains the history of modifications made to changes during their life cycle. CHANGE_ID This is the change_id that generated a historical event. It is foreign keyed to the change table. INTEGER NOT NULL
CHANGE_HISTORY This table contains the history of modifications made to changes during their life cycle. EVENT_DATE This is the date that the historical event occured. DATE NOT NULL
CHANGE_HISTORY This table contains the history of modifications made to changes during their life cycle. EVENT_ID This is an extension for the primary key to allow more than one history event to occur within the same second. VARCHAR(18) NOT NULL
CHANGE_HISTORY This table contains the history of modifications made to changes during their life cycle. EVENT_TIME This is the time that the historical event occured. CHAR(10) NOT NULL
CHANGE_HISTORY This table contains the history of modifications made to changes during their life cycle. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
CHANGE_HISTORY This table contains the history of modifications made to changes during their life cycle. NOTES This is a textual description of the historical event. VARCHAR(254) NULL
CHANGE_MATRIX This table defines the changes that have been included in the Adaptive Learning process. CHANGE_ID This is the change ID used in the Adaptive Learning process. INTEGER NOT NULL
CHANGE_MATRIX This table defines the changes that have been included in the Adaptive Learning process. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
CHANGE_MATRIX This table defines the changes that have been included in the Adaptive Learning process. USAGE_COUNT This is the number of times that the unique word was found. INTEGER NULL
CHANGE_MATRIX This table defines the changes that have been included in the Adaptive Learning process. WORD_ID This columns is used by the adapative learning process. It establishes a relationship to the dictionary. INTEGER NOT NULL
CHANGE_MODEL This table allows the user to define "model" data that will be applied to a change when the change is opened. APPROVAL_METHOD The approval method that will be applied to the change. VARCHAR(18) NULL
CHANGE_MODEL This table allows the user to define "model" data that will be applied to a change when the change is opened. ASSIGNED_TO This defines the default person that the change will be assigned to. CHAR(15) NULL
CHANGE_MODEL This table allows the user to define "model" data that will be applied to a change when the change is opened. CATEGORY The category id that will be applied to the change. VARCHAR(18) NULL
CHANGE_MODEL This table allows the user to define "model" data that will be applied to a change when the change is opened. COST The cost that will be applied to the change. FLOAT NULL
CHANGE_MODEL This table allows the user to define "model" data that will be applied to a change when the change is opened. COST_CENTER This is the cost_center that will be charged for any expenses relating to the change. CHAR(15) NULL
CHANGE_MODEL This table allows the user to define "model" data that will be applied to a change when the change is opened. CREATOR The user id of the person who created this model record. VARCHAR(15) NULL
CHANGE_MODEL This table allows the user to define "model" data that will be applied to a change when the change is opened. CREATOR_NAME The user name of the person who created this model record. VARCHAR(80) NULL
CHANGE_MODEL This table allows the user to define "model" data that will be applied to a change when the change is opened. CURRENCY The currency that will be applied to the change. CHAR(3) NULL
CHANGE_MODEL This table allows the user to define "model" data that will be applied to a change when the change is opened. DESCRIPTION This is a free form text column that allows for a verbose description of the model itself. VARCHAR(254) NULL
CHANGE_MODEL This table allows the user to define "model" data that will be applied to a change when the change is opened. LABOR_COST The labor cost that will be applied to the change. FLOAT NULL
CHANGE_MODEL This table allows the user to define "model" data that will be applied to a change when the change is opened. MODEL_DEFAULT This indicates whether or not the record is the default when more than one model is associated with one category. BOOLEAN NULL
CHANGE_MODEL This table allows the user to define "model" data that will be applied to a change when the change is opened. MODEL_ID The unique identifier for this table. It is an opaque id. INTEGER NOT NULL
CHANGE_MODEL This table allows the user to define "model" data that will be applied to a change when the change is opened. MODEL_NAME This is a free form text field that describes the model itself. It is meant to assist the end user in the model select process. VARCHAR(20) NULL
CHANGE_MODEL This table allows the user to define "model" data that will be applied to a change when the change is opened. MODEL_PRIORITY This indicates the priority of this model in relation to others associated with the same parent category. It provides a sorting mechanism for the select process. INTEGER NULL
CHANGE_MODEL This table allows the user to define "model" data that will be applied to a change when the change is opened. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
CHANGE_MODEL This table allows the user to define "model" data that will be applied to a change when the change is opened. NOTIFY_ON_APPROVAL The notify on approval option that will be applied to the change. VARCHAR(3) NULL
CHANGE_MODEL This table allows the user to define "model" data that will be applied to a change when the change is opened. PRIORITY The priority that will be applied to the change. VARCHAR(40) NULL
CHANGE_MODEL This table allows the user to define "model" data that will be applied to a change when the change is opened. RESPONSIBLE_GROUP Defines the group that will be the default assigned to. CHAR(15) NULL
CHANGE_MODEL This table allows the user to define "model" data that will be applied to a change when the change is opened. RISK_CODE The risk coder that will be applied to the change. VARCHAR(18) NULL
CHANGE_MODEL This table allows the user to define "model" data that will be applied to a change when the change is opened. SITE_ID This column defines the site_id associated with the reponsible_group (or group_id). VARCHAR(20) NULL
CHANGE_MODEL This table allows the user to define "model" data that will be applied to a change when the change is opened. STATUS The status that will be applied to the change. VARCHAR(18) NULL
CHANGE_MODEL This table allows the user to define "model" data that will be applied to a change when the change is opened. STATUS_ID The status id that will be applied to the change. VARCHAR(18) NULL
CHANGE_STATUS This table defines the status types and status ids that are valid for this particular implementation of change management. AFTER_APPROVAL This column indicates if the particular status_id is allowed for use after the change has been approved. VARCHAR(3) NULL
CHANGE_STATUS This table defines the status types and status ids that are valid for this particular implementation of change management. DESCRIPTION This column contains a textual description of the change status. It does not affect processing. VARCHAR(80) NULL
CHANGE_STATUS This table defines the status types and status ids that are valid for this particular implementation of change management. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
CHANGE_STATUS This table defines the status types and status ids that are valid for this particular implementation of change management. STATUS_ID This column defines the unique identifier for this column. It is controlled by the user. There can many types of status_id's for each status_type. There are a predefined and limited number of status_types. VARCHAR(18) NOT NULL
CHANGE_STATUS This table defines the status types and status ids that are valid for this particular implementation of change management. TYPE This column defines the status_type that is associated with the status_id. There are a limited number of status_types. VARCHAR(18) NULL
CHANGE_TEXT This is a generic use table for change management that is used to store the overflow values for the various description fields of a change and task. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
CHANGE_TEXT This is a generic use table for change management that is used to store the overflow values for the various description fields of a change and task. MODULE_ID This column indicates the unique identifier of the record that generated this record. INTEGER NOT NULL
CHANGE_TEXT This is a generic use table for change management that is used to store the overflow values for the various description fields of a change and task. SUB_MODULE_ID This is the second column that can be used to uniquely identify the parent record. VARCHAR(80) NOT NULL
CHANGE_TEXT This is a generic use table for change management that is used to store the overflow values for the various description fields of a change and task. TX_DESCRIPTION This is the actual overflow text. LONG VARCHAR NULL
CHANGE_TEXT This is a generic use table for change management that is used to store the overflow values for the various description fields of a change and task. TYPE This columns indicates the change record type that created this record. INTEGER NOT NULL
CHANGE_TREE This table defines the parent/child relationships for changes/activities. CHILD_CHANGE_ID This is the change_id that is the child of a change in a parent/child (change/activity, activity/activity) relationship. INTEGER NOT NULL
CHANGE_TREE This table defines the parent/child relationships for changes/activities. PARENT_CHANGE_ID This is the change_id that is the parent of a change in a parent/child (change/activity, activity/activity) relationship. INTEGER NOT NULL
COMMANDS This table contains the operating system commands that can be executed from within a rule. COMMAND This column contains the unique identifier for the table. It is controlled by the user. VARCHAR(40) NOT NULL
COMMANDS This table contains the operating system commands that can be executed from within a rule. DEFINITION This column contains the actual command that is passed to the operating system. VARCHAR(254) NULL
COMMANDS This table contains the operating system commands that can be executed from within a rule. FOR_EACH This column indicates if the command should be executed for each instance of a record that is associated with a rule condition. For instance, should the condition execute for each instance of an associated task. VARCHAR(254) NULL
COMMANDS This table contains the operating system commands that can be executed from within a rule. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
DEPENDENCY This table defines the relationship between task records. CHANGE_ID This is the change_id of the parent change record. It is needed to identify the unique relationship to the parent implement_schedule table INTEGER NOT NULL
DEPENDENCY This table defines the relationship between task records. DEPEND_MASK This column tracks the depends on relationship. INTEGER NULL
DEPENDENCY This table defines the relationship between task records. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
DEPENDENCY This table defines the relationship between task records. RELATIONSHIP This identifies which type of relationship is in effect for the parent/child task pair. VARCHAR(18) NULL
DEPENDENCY This table defines the relationship between task records. SCHED_NAME This is the sched_name of the parent task in the task relationship. It is needed to identify the unique relationship to the parent implement_schedule table VARCHAR(80) NOT NULL
DEPENDENCY This table defines the relationship between task records. WITH_TASK This is the sched_name of the child task in the task relationship. VARCHAR(80) NOT NULL
IMPACT This table groups the impact definition for a given change request. CHANGE_ID This is the change_id that this inventory effect is associated with. INTEGER NOT NULL
IMPACT This table groups the impact definition for a given change request. DAYS_BEFORE This column indicates the number of days prior to the implementation of the change to send to the noficiations. FLOAT NULL
IMPACT This table groups the impact definition for a given change request. DELETABLE Controls whether or not the impact can be deleted after being added. VARCHAR(3) NULL
IMPACT This table groups the impact definition for a given change request. DESCRIPTION A free form text field that allows the user to describe the impact. VARCHAR(254) NULL
IMPACT This table groups the impact definition for a given change request. DONE_MASK This column, using bitwise operations, tracks which type of impact analysis has been performed. INTEGER NULL
IMPACT This table groups the impact definition for a given change request. IMP_CATEGORY This is the impact code and is a foreign key to the impact_category table. VARCHAR(18) NOT NULL
IMPACT This table groups the impact definition for a given change request. IMPACT_MASK This column, using bitwise operations, tracks which impact analysis types should be performed. INTEGER NULL
IMPACT This table groups the impact definition for a given change request. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
IMPACT This table groups the impact definition for a given change request. NOTIFY_HELP_DESK This column indicates a Hot News should be created with this impact. VARCHAR(3) NULL
IMPACT This table groups the impact definition for a given change request. NOTIFY_IMPACTS This column indicates if a message should be sent to the impacted personnel. VARCHAR(3) NULL
IMPACT_CATEGORY This table defines the valid impact categories. DESCRIPTION This is a textual description of the impact category. VARCHAR(80) NULL
IMPACT_CATEGORY This table defines the valid impact categories. IMP_CATEGORY This column allows for the categorization of the different types of impacts. VARCHAR(18) NOT NULL
IMPACT_CATEGORY This table defines the valid impact categories. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
IMPACT_INVENTORY This is an intersecting table between is_inventory and impacts. ASSET_TAG This is the asset tag of the inventory item being impacted. VARCHAR(40) NULL
IMPACT_INVENTORY This is an intersecting table between is_inventory and impacts. CHANGE_ID This is the change_id that this inventory effect is associated with. INTEGER NOT NULL
IMPACT_INVENTORY This is an intersecting table between is_inventory and impacts. IMP_CATEGORY This column creates an association to the parent impact table. VARCHAR(18) NOT NULL
IMPACT_INVENTORY This is an intersecting table between is_inventory and impacts. IS_INVENTORY_ID This column creates an association to the is_inventory table. INTEGER NOT NULL
IMPACT_INVENTORY This is an intersecting table between is_inventory and impacts. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
IMPACT_ITEM This is the item that will be impacted as a result of the change. CHANGE_ID This is the change_id that this inventory effect is associated with. INTEGER NOT NULL
IMPACT_ITEM This is the item that will be impacted as a result of the change. IMP_CATEGORY This column creates an association to the parent impact table. VARCHAR(18) NOT NULL
IMPACT_ITEM This is the item that will be impacted as a result of the change. IMP_CHANGE_ID This is a past change record that will be used in the impact analysis process. INTEGER NULL
IMPACT_ITEM This is the item that will be impacted as a result of the change. ITEM_ID The unique identifier for this table. This is an opaque id. INTEGER NOT NULL
IMPACT_ITEM This is the item that will be impacted as a result of the change. ITEM_NAME This is the descriptive name of the record uniquely identified by the people_id, imp_change_id, problem_id or organization_id columns. VARCHAR(80) NULL
IMPACT_ITEM This is the item that will be impacted as a result of the change. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
IMPACT_ITEM This is the item that will be impacted as a result of the change. ORGANIZATION_ID This is the unique identifier of the organization that will be impacted with the implementation of this change. CHAR(15) NULL
IMPACT_ITEM This is the item that will be impacted as a result of the change. PEOPLE_ID This is the unique identifier of the person that will be impacted with the implementation of this change. INTEGER NULL
IMPACT_ITEM This is the item that will be impacted as a result of the change. PROBLEM_ID This is a past problem record that will be used in the impact analysis process. CHAR(15) NULL
IMPACT_ITEM This is the item that will be impacted as a result of the change. TYPE Indicates if the impact is for a change, problem, people or organization. CHAR(15) NULL
IMPACT_KEYWORD This table defines the keywords associated with a given impact. CHANGE_ID This is the change_id that this inventory effect is associated with. INTEGER NOT NULL
IMPACT_KEYWORD This table defines the keywords associated with a given impact. DELETABLE Controls whether or not the impact keyword can be deleted. VARCHAR(3) NULL
IMPACT_KEYWORD This table defines the keywords associated with a given impact. IMP_CATEGORY This column creates an association to the parent impact table. VARCHAR(18) NOT NULL
IMPACT_KEYWORD This table defines the keywords associated with a given impact. KEYWORD This is the unique keyword that establishes the impact analysis. VARCHAR(40) NOT NULL
IMPACT_KEYWORD This table defines the keywords associated with a given impact. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
IMPLEMENT_SCHEDULE These are the tasks associated with a given change request. ACT_DURATION This is the amount of elapsed time actually used to complete this task. FLOAT NULL
IMPLEMENT_SCHEDULE These are the tasks associated with a given change request. ACT_END_DATE This is the date that the task actually ended. DATE NULL
IMPLEMENT_SCHEDULE These are the tasks associated with a given change request. ACT_END_TIME This is the time that the task actually ended. CHAR(10) NULL
IMPLEMENT_SCHEDULE These are the tasks associated with a given change request. ACT_LABOR_HOURS These are the actual labor hours used to complete the task. FLOAT NULL
IMPLEMENT_SCHEDULE These are the tasks associated with a given change request. ACT_START_DATE This is the date that the task actually started. DATE NULL
IMPLEMENT_SCHEDULE These are the tasks associated with a given change request. ACT_START_TIME This is the time that the task actually started. CHAR(10) NULL
IMPLEMENT_SCHEDULE These are the tasks associated with a given change request. CHANGE_ID This is the change_id that is the parent of a given task. It is foreign keyed to the change table. INTEGER NOT NULL
IMPLEMENT_SCHEDULE These are the tasks associated with a given change request. DELETABLE This indicates if the task can be deleted from the task list for a given change. VARCHAR(3) NULL
IMPLEMENT_SCHEDULE These are the tasks associated with a given change request. DESCRIPTION This is a generic, textual description of the task to be completed. VARCHAR(254) NULL
IMPLEMENT_SCHEDULE These are the tasks associated with a given change request. DURATION This is the amount of elapsed time planned for allocation to this task. FLOAT NULL
IMPLEMENT_SCHEDULE These are the tasks associated with a given change request. END_DATE This is the date that the task is scheduled to end. DATE NULL
IMPLEMENT_SCHEDULE These are the tasks associated with a given change request. END_TIME This is the time that the task is scheduled to end. CHAR(10) NULL
IMPLEMENT_SCHEDULE These are the tasks associated with a given change request. LABOR_HOURS These are the planned labor hours allocated to the task. FLOAT NULL
IMPLEMENT_SCHEDULE These are the tasks associated with a given change request. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
IMPLEMENT_SCHEDULE These are the tasks associated with a given change request. PERCENT_COMPLETE This tracks the percentage of work that has been completed for a given task. FLOAT NULL
IMPLEMENT_SCHEDULE These are the tasks associated with a given change request. SCHED_NAME This is the name of the task. VARCHAR(80) NOT NULL
IMPLEMENT_SCHEDULE These are the tasks associated with a given change request. SCHEDULE_MASK This column tracks whether or not the task needs to be scheduled. INTEGER NULL
IMPLEMENT_SCHEDULE These are the tasks associated with a given change request. START_DATE This is the date that the task is scheduled to start. DATE NULL
IMPLEMENT_SCHEDULE These are the tasks associated with a given change request. START_TIME This is the time that the task is scheduled to start. CHAR(10) NULL
INV_EFFECT These are the defined inventory records that will be modified as a result of the change request. ALTERNATE_TAG This is the alternate tag that will be applied to the asset records. VARCHAR(40) NULL
INV_EFFECT These are the defined inventory records that will be modified as a result of the change request. ASSET_TAG This is the asset tag that will be applied to the asset records. VARCHAR(40) NULL
INV_EFFECT These are the defined inventory records that will be modified as a result of the change request. CHANGE_ID This is the change_id that this inventory effect is associated with. INTEGER NOT NULL
INV_EFFECT These are the defined inventory records that will be modified as a result of the change request. CONNECTION_ID This is the connection id that will be applied to the asset records. CHAR(15) NULL
INV_EFFECT These are the defined inventory records that will be modified as a result of the change request. DESCRIPTION This is a descriptive title given to the inventory effect. VARCHAR(80) NOT NULL
INV_EFFECT These are the defined inventory records that will be modified as a result of the change request. EFFECT_TYPE This identifies if the item is an add, update or delete type of inventory action. INTEGER NULL
INV_EFFECT These are the defined inventory records that will be modified as a result of the change request. H_OBJECT_ID This is the asset category id that will be applied to the asset records. CHAR(15) NULL
INV_EFFECT These are the defined inventory records that will be modified as a result of the change request. H_OBJECT_NAME This is the asset category name that will be applied to the asset records. VARCHAR(40) NULL
INV_EFFECT These are the defined inventory records that will be modified as a result of the change request. I_OBJECT_ID This is the asset model id that will be applied to the asset records. CHAR(15) NULL
INV_EFFECT These are the defined inventory records that will be modified as a result of the change request. INV_DESCRIPTION This is the description of the inventory item itself. VARCHAR(40) NULL
INV_EFFECT These are the defined inventory records that will be modified as a result of the change request. INV_EFFECT_ID This is the unique identifier for the inventory effect. It is an opaque id. INTEGER NOT NULL
INV_EFFECT These are the defined inventory records that will be modified as a result of the change request. IS_INVENTORY_ID This is the is_inventory_id that will be applied to the asset records during an add, or that identifies the existing asset record to be updated to deleted. INTEGER NULL
INV_EFFECT These are the defined inventory records that will be modified as a result of the change request. LOCATION_ID This is the location id that will be applied to the asset records. CHAR(15) NULL
INV_EFFECT These are the defined inventory records that will be modified as a result of the change request. MFGR_NO This is the manufacturer number that will be applied to the asset records. CHAR(40) NULL
INV_EFFECT These are the defined inventory records that will be modified as a result of the change request. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
INV_EFFECT These are the defined inventory records that will be modified as a result of the change request. NOTES These are notes associated with the high level inventory effect. This value is not applied to the asset management records. VARCHAR(254) NULL
INV_EFFECT These are the defined inventory records that will be modified as a result of the change request. ORGANIZATION_ID This is the organization id that will be applied to the asset records. CHAR(15) NULL
INV_EFFECT These are the defined inventory records that will be modified as a result of the change request. PEOPLE_ID This is the people id that will be applied to the asset records. INTEGER NULL
INV_EFFECT These are the defined inventory records that will be modified as a result of the change request. PM_OBJECT_ID This is the pm_object_id that will be applied to the asset records. CHAR(15) NULL
INV_EFFECT These are the defined inventory records that will be modified as a result of the change request. PURCHASE_ID This is the purchase id that will be applied to the asset records. CHAR(18) NULL
INV_EFFECT These are the defined inventory records that will be modified as a result of the change request. SERVICE_ID This is the service id that will be applied to the asset records. VARCHAR(18) NULL
INV_EFFECT These are the defined inventory records that will be modified as a result of the change request. STATUS This is the status that will be applied to the asset records. CHAR(10) NULL
INV_EFFECT_ATR This defines the physical values for a given inventory effect attribute. ATTRIB_ID This is the attribute ID that will be acted on or created by the inventory effect. INTEGER NOT NULL
INV_EFFECT_ATR This defines the physical values for a given inventory effect attribute. INV_EFFECT_ID This is the identifier of the parent inventory effect record. INTEGER NOT NULL
INV_EFFECT_ATR This defines the physical values for a given inventory effect attribute. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
INV_EFFECT_ATR This defines the physical values for a given inventory effect attribute. PHYSVALUE The physical value assigned to a particular attribute id. VARCHAR(80) NULL
INV_EFFECT_CON This table defines the contracts that will be associated with the inventory item once posted to the is_inventory table. CONTRACT_ID This is the contract id that will be associated with the inventory record as a result of the inventory effect. INTEGER NOT NULL
INV_EFFECT_CON This table defines the contracts that will be associated with the inventory item once posted to the is_inventory table. INV_EFFECT_ID This is the identifier of the parent inventory effect record. INTEGER NOT NULL
INV_EFFECT_CON This table defines the contracts that will be associated with the inventory item once posted to the is_inventory table. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
INV_EFFECT_HST This table defines the history records that will be posted to the inventory system. CALL_ID The call id associated with the history event. CHAR(15) NULL
INV_EFFECT_HST This table defines the history records that will be posted to the inventory system. CONTRACT_ID The contract id associated with the history event. INTEGER NULL
INV_EFFECT_HST This table defines the history records that will be posted to the inventory system. COST The cost associated with the history event. FLOAT NULL
INV_EFFECT_HST This table defines the history records that will be posted to the inventory system. COST_CURRENCY The currency type associated with the history event. VARCHAR(3) NULL
INV_EFFECT_HST This table defines the history records that will be posted to the inventory system. EVENT_DATE The date that the history record was created. DATE NOT NULL
INV_EFFECT_HST This table defines the history records that will be posted to the inventory system. EVENT_ID The unique identifier of the history event. INTEGER NOT NULL
INV_EFFECT_HST This table defines the history records that will be posted to the inventory system. EVENT_NOTES This column contains any descriptive information associated with the event. VARCHAR(254) NULL
INV_EFFECT_HST This table defines the history records that will be posted to the inventory system. EVENT_TIME The time that the history record was created. CHAR(10) NOT NULL
INV_EFFECT_HST This table defines the history records that will be posted to the inventory system. INV_EFFECT_ID This is the identifier of the parent inventory effect record. INTEGER NOT NULL
INV_EFFECT_HST This table defines the history records that will be posted to the inventory system. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
INV_EFFECT_HST This table defines the history records that will be posted to the inventory system. MODIFY_USER This column indicates modify user option associated with the inventory effect. CHAR(15) NULL
INV_EFFECT_HST This table defines the history records that will be posted to the inventory system. PLANNED This column indicates if this was a planned event. SMALLINT NULL
INV_EFFECT_HST This table defines the history records that will be posted to the inventory system. TECHNICIAN The technician associated with the history event. VARCHAR(40) NULL
INV_EFFECT_ON These are the specific is_inventory records that will be effected by the change. ASSET_TAG This is the asset tag of the asset management record that will be acted on by the inventory effect. VARCHAR(40) NULL
INV_EFFECT_ON These are the specific is_inventory records that will be effected by the change. INV_EFFECT_ID This is the identifier of the parent inventory effect record. INTEGER NOT NULL
INV_EFFECT_ON These are the specific is_inventory records that will be effected by the change. IS_INVENTORY_ID This is the inventory item that will be affected by this inventory effect. INTEGER NOT NULL
INV_EFFECT_ON These are the specific is_inventory records that will be effected by the change. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
IS_INVENTORY See Tivoli Asset Management data dictionary. ASSET_TAG n/a VARCHAR(40) NOT NULL
IS_INVENTORY See Tivoli Asset Management data dictionary. IS_INVENTORY_ID n/a INTEGER NOT NULL
MODEL_APPROVAL This table defines the approval records associated with a given model. APPROVER_ID The unique identifier for the approval model. It is an opaque id. This value is not used when the approval record is created. INTEGER NOT NULL
MODEL_APPROVAL This table defines the approval records associated with a given model. APPROVER_NAME This column contains the name of the group or user who has been added as an approver on the given model. VARCHAR(80) NULL
MODEL_APPROVAL This table defines the approval records associated with a given model. APPROVER_TYPE Indicates if this is an approval requirement for an group or person. VARCHAR(18) NULL
MODEL_APPROVAL This table defines the approval records associated with a given model. GROUP_ID This is the group that is associated with this approval requirement. VARCHAR(20) NULL
MODEL_APPROVAL This table defines the approval records associated with a given model. MODEL_ID The model_id that this appoval model is associated with. INTEGER NOT NULL
MODEL_APPROVAL This table defines the approval records associated with a given model. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
MODEL_APPROVAL This table defines the approval records associated with a given model. PRIORITY This controls the order in which the approval requirements are made available for approval action. VARCHAR(3) NULL
MODEL_APPROVAL This table defines the approval records associated with a given model. SITE_ID This is the site associated with the organization_id (group_id). VARCHAR(20) NULL
MODEL_APPROVAL This table defines the approval records associated with a given model. USER_ID This is the USER that will be added to the change request as an approver when this model is applied. VARCHAR(20) NULL
MODEL_ATTACHMENT This table defines the file attachments associated with a given model. FIELD_NAME This is the field name within the table_name that the attachment will be associated with. VARCHAR(18) NULL
MODEL_ATTACHMENT This table defines the file attachments associated with a given model. FILE_NAME The path name of the file that will be used as an attachment model. VARCHAR(254) NOT NULL
MODEL_ATTACHMENT This table defines the file attachments associated with a given model. MODEL_ID The model_id from the change_model table that this model attachment record is associated with INTEGER NOT NULL
MODEL_ATTACHMENT This table defines the file attachments associated with a given model. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
MODEL_ATTACHMENT This table defines the file attachments associated with a given model. MODULE_ID This defines the module associated with an attachment. VARCHAR(80) NULL
MODEL_ATTACHMENT This table defines the file attachments associated with a given model. TABLE_NAME This is the table name within TCM that this model attachment will be associated with. VARCHAR(18) NULL
MODEL_IMPACT This table defines the types of impact analysis that will be performed on any change that uses this model. DAYS_BEFORE This column indicates the total number of days before the first task start date to notify the help desk. FLOAT NULL
MODEL_IMPACT This table defines the types of impact analysis that will be performed on any change that uses this model. DESCRIPTION This is a textual description of the model impact. VARCHAR(254) NULL
MODEL_IMPACT This table defines the types of impact analysis that will be performed on any change that uses this model. IMP_CATEGORY This is the impact category for this impact record. VARCHAR(18) NOT NULL
MODEL_IMPACT This table defines the types of impact analysis that will be performed on any change that uses this model. MODEL_ID The model_id that this model schedule record is associated with. INTEGER NOT NULL
MODEL_IMPACT This table defines the types of impact analysis that will be performed on any change that uses this model. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
MODEL_IMPACT This table defines the types of impact analysis that will be performed on any change that uses this model. MUST_DO_CHANGE Indicates if impact analysis should be performed against changes. VARCHAR(3) NULL
MODEL_IMPACT This table defines the types of impact analysis that will be performed on any change that uses this model. MUST_DO_CONNECTION Indicates if impact analysis should be performed against connections. VARCHAR(3) NULL
MODEL_IMPACT This table defines the types of impact analysis that will be performed on any change that uses this model. MUST_DO_PROBLEM Indicates if impact analysis should be performed against problems. VARCHAR(3) NULL
MODEL_IMPACT This table defines the types of impact analysis that will be performed on any change that uses this model. NOTIFY_HELP_DESK Indicates if the help desk is to be notified about the impact analysis. It causes the creation of a solution record. VARCHAR(3) NULL
MODEL_IMPACT This table defines the types of impact analysis that will be performed on any change that uses this model. NOTIFY_IMPACTS Indicates if notifications should be sent to those impacted by the change. VARCHAR(3) NULL
MODEL_KEYWORDS This table defines the keywords associated with the modeled impact analysis. IMP_CATEGORY This is the impact category for the parent model_impact record. VARCHAR(18) NOT NULL
MODEL_KEYWORDS This table defines the keywords associated with the modeled impact analysis. KEYWORD This is the keyword that will be used to perform the impact analysis. VARCHAR(40) NOT NULL
MODEL_KEYWORDS This table defines the keywords associated with the modeled impact analysis. MODEL_ID The model_id from the model table that this keyword record is associated with INTEGER NOT NULL
MODEL_KEYWORDS This table defines the keywords associated with the modeled impact analysis. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
MODEL_SCHED_COM This table defines the commands that are associated with a given model. COMMAND This is the specific command associated with the model record. VARCHAR(40) NOT NULL
MODEL_SCHED_COM This table defines the commands that are associated with a given model. MODEL_ID The model_id from the model_schedule table that this record is associated with. INTEGER NOT NULL
MODEL_SCHED_COM This table defines the commands that are associated with a given model. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
MODEL_SCHED_COM This table defines the commands that are associated with a given model. SCHED_NAME The sched_name from the model_schedule table that this record is associated with. VARCHAR(80) NOT NULL
MODEL_SCHED_COM This table defines the commands that are associated with a given model. TO_EXECUTE This indicates if the command is to be executed at the beginning of the task life cycle, or after it has been marked 100% complete. VARCHAR(18) NULL
MODEL_SCHED_RES This table defines the resources associated with a given model. DURATION This column defines the duration of the assignment. CHAR NULL
MODEL_SCHED_RES This table defines the resources associated with a given model. GROUP_ID This is the group id that will be assigned as a resource to a change this model is applied to. VARCHAR(20) NULL
MODEL_SCHED_RES This table defines the resources associated with a given model. GROUP_NAME The name of the group that is associated with the model schedule record as a resource. VARCHAR(80) NULL
MODEL_SCHED_RES This table defines the resources associated with a given model. LABOR_HOURS The amount of labor hours for the model schedule resource record. FLOAT NULL
MODEL_SCHED_RES This table defines the resources associated with a given model. MODEL_ID The model_id from the model_schedule table that this model schedule dependency record is associated with. INTEGER NOT NULL
MODEL_SCHED_RES This table defines the resources associated with a given model. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
MODEL_SCHED_RES This table defines the resources associated with a given model. RESOURCE_ID This is a copy of either the Group ID or User ID value. It is used to uniquely identify the record. VARCHAR(20) NOT NULL
MODEL_SCHED_RES This table defines the resources associated with a given model. RESOURCE_NAME The name of the user that is associated with the model schedule record as a resource. VARCHAR(80) NULL
MODEL_SCHED_RES This table defines the resources associated with a given model. RESOURCE_TYPE The type of resource that is associated with the model schedule record (group or user). CHAR(18) NOT NULL
MODEL_SCHED_RES This table defines the resources associated with a given model. SCHED_NAME The sched_name from the model_schedule table that this model schedule dependency record is associated with. VARCHAR(80) NOT NULL
MODEL_SCHED_RES This table defines the resources associated with a given model. SITE_ID This is the site_id associated with the area_id. VARCHAR(20) NULL
MODEL_SCHED_RES This table defines the resources associated with a given model. USER_ID This is the people_id assigned as a resource for this model. VARCHAR(20) NULL
MODEL_SCHEDULE This table defines the basic scheduling information associated with a given change. DESCRIPTION A basic description of the task that must be completed. VARCHAR(254) NULL
MODEL_SCHEDULE This table defines the basic scheduling information associated with a given change. DURATION This is the default duration that will be applied to the implement_schedule to calculate starting and ending dates. FLOAT NULL
MODEL_SCHEDULE This table defines the basic scheduling information associated with a given change. LABOR_HOURS The default labor hours that populate the implement_schedule table. FLOAT NULL
MODEL_SCHEDULE This table defines the basic scheduling information associated with a given change. MODEL_ID The model_id that this model schedule record is associated with. INTEGER NOT NULL
MODEL_SCHEDULE This table defines the basic scheduling information associated with a given change. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
MODEL_SCHEDULE This table defines the basic scheduling information associated with a given change. SCHED_NAME The schedule name itself. VARCHAR(80) NOT NULL
MODEL_SCHEDULE_DEP This table defines the dependencies in the schedules for a given model. MODEL_ID The model_id from the model_schedule table that this model schedule dependency record is associated with. INTEGER NOT NULL
MODEL_SCHEDULE_DEP This table defines the dependencies in the schedules for a given model. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
MODEL_SCHEDULE_DEP This table defines the dependencies in the schedules for a given model. RELATIONSHIP This identifies which type of relationship is in effect for the parent/child task pair. VARCHAR(18) NULL
MODEL_SCHEDULE_DEP This table defines the dependencies in the schedules for a given model. SCHED_NAME The sched_name from the model_schedule table that this model schedule dependency record is associated with. VARCHAR(80) NOT NULL
MODEL_SCHEDULE_DEP This table defines the dependencies in the schedules for a given model. WITH_TASK This is the sched_name of the child task in the task relationship. VARCHAR(80) NOT NULL
MODEL_TREE This table defines the parent/child relationship of models. This becomes the Change/Activity relationships once applied to the change. CHILD_MODEL_ID The model_id of the model record that is the child in a parent/child model relationship. INTEGER NOT NULL
MODEL_TREE This table defines the parent/child relationship of models. This becomes the Change/Activity relationships once applied to the change. PARENT_MODEL_ID The model_id of the model record that is the parent in a parent/child model relationship. INTEGER NOT NULL
PARAMETERS This table contains the parameter name/value pairs associated with a particular command that must be passed to the operating system with the command. COMMAND This column is the foreign key to the command table. VARCHAR(40) NOT NULL
PARAMETERS This table contains the parameter name/value pairs associated with a particular command that must be passed to the operating system with the command. IS_LIST The column indicates if the Send List option was checked for the particular command parameter. If checked, the parameters appear as a single comma-separated parameter. VARCHAR(3) NULL
PARAMETERS This table contains the parameter name/value pairs associated with a particular command that must be passed to the operating system with the command. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
PARAMETERS This table contains the parameter name/value pairs associated with a particular command that must be passed to the operating system with the command. P_ORDER The column contains the ordering number associated with a command parameter. INTEGER NULL
PARAMETERS This table contains the parameter name/value pairs associated with a particular command that must be passed to the operating system with the command. PARAMETER This column contains the parameter name that is associated with a particular command. VARCHAR(80) NOT NULL
PREFERENCES This table exposes different processing options to the administrator and allows for preference selection and definition which will affect the processing of the change management application. CONTENTS This column contains the actual value, or preference setting, for a given preference name. VARCHAR(80) NULL
PREFERENCES This table exposes different processing options to the administrator and allows for preference selection and definition which will affect the processing of the change management application. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
PREFERENCES This table exposes different processing options to the administrator and allows for preference selection and definition which will affect the processing of the change management application. NAME This column defines the preference name. It is exposed to the user, but is not modifiable by the user. The values are predetermined during product installation and are checked for through out throughout the change management application. VARCHAR(80) NOT NULL
PROBLEMS See Tivoli Problem Management data dictionary. PROBLEM_ID n/a CHAR(15) NOT NULL
RISK_CODES This table defines the valid risk codes for a particular change implementation. They are totally customer driven. DESCRIPTION This column contains the textual description of the risk code. It does not affect processing. VARCHAR(80) NULL
RISK_CODES This table defines the valid risk codes for a particular change implementation. They are totally customer driven. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
RISK_CODES This table defines the valid risk codes for a particular change implementation. They are totally customer driven. RISK_CODE This column is the unique identifier and is user defined. It defines the risk code that is displayed to the user in the risk field on the change dialog. VARCHAR(18) NOT NULL
RULES This table defines the rules that can be associated with certain change categories and then evaluated and processed against changes opened under that category. CATEGORY This column defines which category the rule is associated with. If no category is defined, the rule is associated with all categories. VARCHAR(18) NULL
RULES This table defines the rules that can be associated with certain change categories and then evaluated and processed against changes opened under that category. DATE_DEPENDENT This column indicates if the rule is time dependent meaning that it is not fired during change transaction processing but is fired from the change rule processor. VARCHAR(3) NULL
RULES This table defines the rules that can be associated with certain change categories and then evaluated and processed against changes opened under that category. DATE_TYPE This column contains the option selected for the Based On option on the Rule Definition dialog box. It defines which date/time column the time dependent rule processing should be associated with. VARCHAR(18) NULL
RULES This table defines the rules that can be associated with certain change categories and then evaluated and processed against changes opened under that category. DEFINITION This column contains the rule condition. This condition is evaluated against a given change at run time. VARCHAR(254) NULL
RULES This table defines the rules that can be associated with certain change categories and then evaluated and processed against changes opened under that category. DESCRIPTION This column contains a description of the rule. It is controlled by the user. It does not affect processing. VARCHAR(254) NULL
RULES This table defines the rules that can be associated with certain change categories and then evaluated and processed against changes opened under that category. FIRING_STATUS This column defines the statuses the change must be under before the rule is considered for processing. INTEGER NULL
RULES This table defines the rules that can be associated with certain change categories and then evaluated and processed against changes opened under that category. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
RULES This table defines the rules that can be associated with certain change categories and then evaluated and processed against changes opened under that category. NAME This column contains the name of the rule and is controlled by the administrator. VARCHAR(80) NOT NULL
RULES This table defines the rules that can be associated with certain change categories and then evaluated and processed against changes opened under that category. NUMBER_DAYS This column contains the numbers of days before or after (the When option) a certain date/time (the Based On option) that the time dependent rule should be fired. FLOAT NULL
RULES This table defines the rules that can be associated with certain change categories and then evaluated and processed against changes opened under that category. ORGANIZATION_ID This defines the organization that this rule is associated with. This column is only used when the category is not defined. CHAR(15) NULL
RULES This table defines the rules that can be associated with certain change categories and then evaluated and processed against changes opened under that category. PRIORITY This column defines the processing priority of this rule in relation to the other rules associated with the same category. INTEGER NULL
RULES This table defines the rules that can be associated with certain change categories and then evaluated and processed against changes opened under that category. RULE_ID This column contains the unique identifier of the table. It is an opaque id. INTEGER NOT NULL
RULES This table defines the rules that can be associated with certain change categories and then evaluated and processed against changes opened under that category. STATUS This column defines if the status is in 'live' or 'test' mode. The rule is not fired against changed until it is in 'live' mode. VARCHAR(18) NULL
RULES This table defines the rules that can be associated with certain change categories and then evaluated and processed against changes opened under that category. USER_MESSAGE This column defines the message that is sent to the user if the rule condition evaluates to true. VARCHAR(254) NULL
RULES This table defines the rules that can be associated with certain change categories and then evaluated and processed against changes opened under that category. WHEN_AFFECT This column indicates if the time dependent rule is processed before or after the date selected in the Based On option. This column is associated with the When option on the Rule dialog. VARCHAR(18) NULL
SCHED_COMMAND This table defines the commands associated with a given task. CHANGE_ID This is the change_id of the parent change record. It is needed to identify the unique relationship to the parent implement_schedule table. INTEGER NOT NULL
SCHED_COMMAND This table defines the commands associated with a given task. COMMAND This is the name of the command to be executed. VARCHAR(40) NOT NULL
SCHED_COMMAND This table defines the commands associated with a given task. EXECUTED This field indicates whether or not the command has been executed. VARCHAR(3) NULL
SCHED_COMMAND This table defines the commands associated with a given task. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
SCHED_COMMAND This table defines the commands associated with a given task. SCHED_NAME This is the sched_name of the parent task. It is needed to identify the unique relationship to the parent implement_schedule table. VARCHAR(80) NOT NULL
SCHED_COMMAND This table defines the commands associated with a given task. TO_EXECUTE This indicates if the command is to be executed at the beginning of the task life cycle, or after it has been marked 100% complete. VARCHAR(18) NULL
SCHED_INVENTORY This table defines the inventory records associated with a given task. ASSET_TAG This is the asset tag of the asset management record that will be affected by this task. VARCHAR(40) NULL
SCHED_INVENTORY This table defines the inventory records associated with a given task. CHANGE_ID This is the sched_name of the parent task. It is needed to identify the unique relationship to the parent implement_schedule table. INTEGER NOT NULL
SCHED_INVENTORY This table defines the inventory records associated with a given task. IS_INVENTORY_ID This is the is_inventory_id associated with the scheduled inventory item. INTEGER NOT NULL
SCHED_INVENTORY This table defines the inventory records associated with a given task. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
SCHED_INVENTORY This table defines the inventory records associated with a given task. SCHED_NAME This is the sched_name of the parent task. It is needed to identify the unique relationship to the parent implement_schedule table. VARCHAR(80) NOT NULL
SCHED_INVENTORY This table defines the inventory records associated with a given task. TYPE This column tracks the type of schedule inventory. VARCHAR(18) NULL
SCHED_RESOURCE This table defines the resources associated with a given task. ACT_LABOR_HOURS The amount of actual labor hours for the change schedule resource record. FLOAT NULL
SCHED_RESOURCE This table defines the resources associated with a given task. CHANGE_ID This is the sched_name of the parent task. It is needed to identify the unique relationship to the parent implement_schedule table. INTEGER NOT NULL
SCHED_RESOURCE This table defines the resources associated with a given task. DELETABLE This column defines if this schedule resource can be deleted from the task. VARCHAR(3) NULL
SCHED_RESOURCE This table defines the resources associated with a given task. GROUP_ID This is the group id that this resource is associated with. VARCHAR(20) NULL
SCHED_RESOURCE This table defines the resources associated with a given task. GROUP_NAME The name of the group that is associated with the change schedule record as a resource. VARCHAR(80) NULL
SCHED_RESOURCE This table defines the resources associated with a given task. LABOR_HOURS The amount of labor hours for the change schedule resource record. FLOAT NULL
SCHED_RESOURCE This table defines the resources associated with a given task. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
SCHED_RESOURCE This table defines the resources associated with a given task. NOTIFIED This column indicates if the resource has been notified or not. BOOLEAN NULL
SCHED_RESOURCE This table defines the resources associated with a given task. RESOURCE_ID This column contains either the group id or the user id of this resource record. It is used to uniquely identify this record. VARCHAR(20) NOT NULL
SCHED_RESOURCE This table defines the resources associated with a given task. RESOURCE_NAME The name of the user that is associated with the change schedule record as a resource. VARCHAR(80) NULL
SCHED_RESOURCE This table defines the resources associated with a given task. RESOURCE_TYPE The type of resource that is associated with the change schedule record (group or user). CHAR(18) NOT NULL
SCHED_RESOURCE This table defines the resources associated with a given task. SCHED_NAME This is the sched_name of the parent task. It is needed to identify the unique relationship to the parent implement_schedule table. VARCHAR(80) NOT NULL
SCHED_RESOURCE This table defines the resources associated with a given task. SITE_ID This is the site_id that is part of the unique identifier of the group_id. VARCHAR(20) NULL
SCHED_RESOURCE This table defines the resources associated with a given task. USER_ID This is the people_id that this resource is associated with. VARCHAR(20) NULL
TCM_SCHEDULE This table is used by TCM to perform escalation processing for change records. ABSOLUTE_TIME This is the absolute time that the schedule must be processed. SMALLINT NULL
TCM_SCHEDULE This table is used by TCM to perform escalation processing for change records. DAYS This is the number of days interval between processing runs. INTEGER NULL
TCM_SCHEDULE This table is used by TCM to perform escalation processing for change records. ENABLED This indicates if the schedule record is enabled or disabled. SMALLINT NULL
TCM_SCHEDULE This table is used by TCM to perform escalation processing for change records. ENTRYID This is the unique identifer for this table. INTEGER NOT NULL
TCM_SCHEDULE This table is used by TCM to perform escalation processing for change records. HOURS This is the number of hours interval between processing runs. INTEGER NULL
TCM_SCHEDULE This table is used by TCM to perform escalation processing for change records. LAST_RUN_DATE This is the last date that the schedule was processed. DATE NULL
TCM_SCHEDULE This table is used by TCM to perform escalation processing for change records. LAST_RUN_TIME This is the last time that the job was processed. CHAR(10) NULL
TCM_SCHEDULE This table is used by TCM to perform escalation processing for change records. MINUTES This is the number of minutes interval between processing runs. INTEGER NULL
TCM_SCHEDULE This table is used by TCM to perform escalation processing for change records. MODIFY_DATETIME This column contains the date and time the record was last modified. INTEGER NULL
TCM_SCHEDULE This table is used by TCM to perform escalation processing for change records. MODULE_NAME This is the name of the module that created this schedule record. VARCHAR(80) NOT NULL
TCM_SCHEDULE This table is used by TCM to perform escalation processing for change records. PARM1 This is 1 of 4 parameters that can be scheduled and passed to the application invoked by the scheduler. VARCHAR(40) NULL
TCM_SCHEDULE This table is used by TCM to perform escalation processing for change records. PARM2 This is the 2nd of 4 parameters that can be scheduled and passed to the application invoked by the scheduler. VARCHAR(40) NULL
TCM_SCHEDULE This table is used by TCM to perform escalation processing for change records. PARM3 This is the 3rd of 4 parameters that can be scheduled and passed to the application invoked by the scheduler. VARCHAR(40) NULL
TCM_SCHEDULE This table is used by TCM to perform escalation processing for change records. PARM4 This is the 4th of 4 parameters that can be scheduled and passed to the application invoked by the scheduler. VARCHAR(40) NULL
TCM_SCHEDULE This table is used by TCM to perform escalation processing for change records. PROC_NAME This is the name of the process that will be invoked by the scheduler. VARCHAR(80) NULL
TCM_SCHEDULE This table is used by TCM to perform escalation processing for change records. PROCESSID This is the process identifier for the schedule record. VARCHAR(40) NULL
TCM_SCHEDULE This table is used by TCM to perform escalation processing for change records. SECONDS This is the number of seconds interval between processing runs. INTEGER NULL