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 |