System schema changes
The following system schema changes were made in the 9.1.0.2 fix pack.
uap_appr_items
The map_name column was added in the 9.1.0.2 fix pack.
Columns in the uap_appr_items table
Name
Datatype
Is PK
Null Option
Is FK
Description
approval_id
integer
Yes
NOT NULL
Yes
ID of an approval item. Foreign key to uap_approvals.
appr_item_seq
integer
Yes
NOT NULL
No
Sequence of the item (identifier).
create_date
date
No
NULL
No
Date that the item was created.
notes
string (1024)
No
NULL
No
Notes about the item.
item_status
string (20)
No
NULL
No
Status of the item under review (whether it is archived). Valid values are ARCHIVED or null.
user_id
integer
No
NULL
Yes
User who added the item to the approval process. Foreign key to uap_users.
orig_file_name
nvarchar (390)
No
NULL
No
Original file name of the uploaded file. Size changed to 256 by version 7.4.0. The size changed to 390 in 9.1.0.
markup_file_name
string (20)
No
NULL
No
Markup file name.
orig_file_size
string (10)
No
NULL
No
Size of the original file.
orig_file_mime
string (255)
No
NULL
No
MIME type of the original file. Size increased in version 8.6.0.
last_mod_date
date
No
NULL
No
Date the item was last modified.
object_id
integer
No
NULL
Yes
For marketing objects, the ID of the object. Value is -1 for other objects. Foreign key to uap_mktgobject.mktg_object_id. This column was added in version 7.3.0.
object_type_id
integer
No
NULL
Yes
For marketing objects, the ID of the marketing object type. Value is -1 for other objects. Foreign key into uap_comp_type.comp_type_id. This column was added in version 7.3.0.
enable_markup
string (2)
No
NULL
No
Stores whether current approval item can be marked up (1) or not (0). This column was added in version 7.5.0.
linked_item_id
integer
No
NULL
No
The ID of the line item to which the approval item belongs. This column was added in version 8.5.0.
map_name
NVARCHAR (50)
No
NULL
No
This column contains form names used in form tasks. This column was added in the 9.1.0.2 fix pack.
uap_workflow
The map_name column was added in the 9.1.0.2 fix pack.
Schema for umo_workflow
Name
Datatype
Is PK
Null Option
Is FK
Description
wf_no
integer
Yes
NOT NULL
No
Unique identifier generated by the system for each workflow step or stage.
name
string (256)
No
NULL
No
Name of the stage or step. Size of the column was changed to 256 for version 7.4.0.
project_id
integer
No
NULL
Yes
Unique identifier for a project or project request. Foreign key for uap_projects.
display_order
integer
No
NULL
No
dislay_id
string (10)
No
NULL
No
Order of the stage or step. This value is used to determine the sort order for the stages.
flag_stage
string (1)
No
NULL
No
Step display integer. This value appears along with the step or stage name in the user interface. (For example, "1.1 Creative Approval Task".)
start_date
date
No
NULL
No
Workflow step start date.
end_date
date
No
NULL
No
Workflow step end date.
flag_anchor
string (1)
No
NULL
No
Anchor date flag.
forecast_st
date
No
NULL
No
Workflow step forecast start date.
forecast_end
date
No
NULL
No
Workflow step forecast end date.
duration
floating pt
No
NULL
No
Workflow step predicted/forecast duration.
actual_duration
floating pt
No
NULL
No
Workflow step actual duration.
pcnt_comp
integer
No
NULL
No
Percent complete.
parent_stage
integer
No
NULL
No
Parent stage if the entry is a step.
flag_link
string (1)
No
NULL
No
Workflow step link flag. The value is Y if the step is linked and null if it is not linked.
link_object
string (20)
No
NULL
No
The type of task (for example, peopletask or approval).
link_id
integer
No
NULL
No
Workflow step link object ID. If the value for the link_object column is APPROVAL, the value for this column is the approval ID.
status_code
string (20)
No
NULL
No
state_code
string (20)
No
NULL
No
Status of the stage or task. These values are valid:
*
PENDING
*
ACTIVE
*
FINISHED
*
SKIPPED
notes
string (1024)
No
NULL
No
milestone_type
integer
No
NULL
Yes
Workflow step or task milestone type. Foreign key to uap_wf_milestone.
error_code
string (20)
No
NULL
No
Workflow task error code, such as an error in recalculating dependency dates.
effort
string (20)
No
NULL
No
Estimated effort.
actual_effort
string (20)
No
NULL
No
Actual effort.
scheduling_mask
integer
No
NULL
No
Determines whether a workflow step schedules through weekends, non-work time, or both.
duration_str
string (20)
No
NULL
No
Workflow step predicted/forecast duration in DD-HH-MM format. This column was added in version 7.5.
actual_duration_str
string (20)
No
NULL
No
Workflow step actual duration of the task in DD-HH-MM format. This column was added in version 7.5.
effort_str
string (20)
No
NULL
No
Estimated effort of the task in DD-HH-MM format. This column was added in version 7.5.
actual_effort_str
string (20)
No
NULL
No
Actual effort in DD-HH-MM format. This column was added in version 7.5.
enable_attachment
string (2)
No
NULL
No
Flag to allow attachments to task. This column was added in version 7.5.
required
string (2)
No
NULL
No
Workflow task is required task or not. This column was added in version 7.5.
enforce_dep
string (2)
No
NULL
No
Flag to enforce dependency between workflow task. This column was added in version 7.5.
task_code
string (100)
No
NULL
No
Used to uniquely identify tasks, for use with the SDK. This column was added in version 7.5.
ready_to_start
integer
No
NULL
No
This column was added in version 8.2.0. It identifies whether dependencies are complete.
*
0 = Not ready to start
*
1 = Ready to start
last_mod_date
datetime
No
NULL
No
This column was added in version 8.5.0. The last updated date for the workflow task.
map_name
NVARCHAR (50)
No
NULL
No
This column contains form names linked to form tasks in the workflow. This column was added in the 9.1.0.2 fix pack.
uap_tt_map
The rule_xml column was added in the 9.1.0.2 fix pack.
Schema for uap_tt_map
Name
Datatype
Is PK
Null Option
Is FK
Description
map_id
integer
Yes
NOT NULL
No
Unique identifier generated by the system for each form.
map_name
string (50)
No
NULL
No
Name of the form.
table_name
string (50)
No
NULL
No
Name of the database table that stores the answers users enter in the fields of this form.
key_column
string (50)
No
NULL
No
Column that stores the primary key for the table specified in the table_name column.
key_type
string (20)
No
NULL
No
Data type of the column specified in the key_column column.
state
string (50)
No
NULL
No
State of the form. The following are valid values:
*
Published
*
Non-Published
*
Temporary
This column was added in version 8.0.
root_element
string (100)
No
NULL
No
The only valid value is Details.
description
string (1024)
No
NULL
No
Description of form. This column was added in version 8.0.
user_id
integer
No
NULL
Yes
ID of the user who created the form. Foreign key to uap_user. This column was added in version 8.0.
copy_of
integer
No
NULL
Yes
ID of the form that was copied to make this form. Foreign key to uap_tt_map.map_id. This column was added in version 8.0.
form_type
integer
No
NULL
No
Whether the form is a Target Cell Spreadsheet. This column was added in version 8.0.
rule_xml
CLOB
No
NULL
No
This column contains the rule xml definitions for form rules. This column was added in the 9.1.0.2 fix pack.
Copyright IBM Corporation 2014. All Rights Reserved.