Clarity logo

Database Schema Changes from Clarity 7.5.2 to 7.5.3

added: function: fed_flatten_mvlookups_fct

added: procedure: nbi_status_sp

added: procedure: prj_reset_unit_depth_sp

added: sequence: bpm_em_events_s1

added: sequence: odf_object_copy_flat_s1

added: table: bpm_em_events

added: table: odf_object_copy_flat

added: table: prj_blb_slices_d_hardalc

added: table: prj_blb_slices_m_hardalc

added: table: prj_blb_slices_w_hardalc

added: view: cmn_sec_chk_user_inst_v0

added: view: cmn_sec_chk_user_r_v0

added: view: cmn_sec_chk_user_v0

added: view: prj_project_actsum_hpd_v

added: view: prj_project_actsum_v

added: view: prj_project_estsum_hpd_v

added: view: prj_project_estsum_v

deleted: function: cmn_index_fct

updated: table: bpm_def_objects

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

updated

Index

BPM_DEF_OBJECTS_N1

n/a

n/a

n/a

n/a

n/a

updated: table: bpm_def_process_versions

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Index

BPM_DEF_PROCESS_VERSIONS_N3

n/a

n/a

n/a

n/a

n/a

updated

Index

BPM_DEF_PROCESS_VERSIONS_N2

n/a

n/a

n/a

n/a

n/a

updated: table: bpm_errors

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Index

BPM_ERRORS_N1

n/a

n/a

n/a

n/a

n/a

added

Index

BPM_ERRORS_N2

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

EXCEPTION_TRACE

n/a

n/a

n/a

n/a

n/a

updated: table: bpm_run_process_engines

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

PRE_PIPELINES

numeric

2

n/a

n/a

Y

added

Column

ACTION_PIPELINES

numeric

3

n/a

n/a

Y

added

Column

POST_PIPELINES

numeric

3

n/a

n/a

Y

added

Column

OVERALL_LOAD

numeric

n/a

n/a

9

Y

added

Column

RECENT_LOAD

numeric

n/a

n/a

9

Y

updated: table: bpm_run_process_engine_runs

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

CONDITION_COUNT

numeric

n/a

n/a

n/a

Y

added

Column

INTERVAL

numeric

n/a

n/a

n/a

Y

added

Column

USER_EVENT_EX

numeric

n/a

n/a

n/a

Y

added

Column

START_PROCESS_EX

numeric

n/a

n/a

n/a

Y

added

Column

PRE_CONDITION_EX

numeric

n/a

n/a

n/a

Y

added

Column

ACTION_EXECUTION_EX

numeric

n/a

n/a

n/a

Y

added

Column

POST_CONDITION_EX

numeric

n/a

n/a

n/a

Y

updated: table: clb_dms_flat_hierarchy

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

updated

Index

CLB_DMS_FLAT_HIERARCHY_N1

n/a

n/a

n/a

n/a

n/a

updated

Index

CLB_DMS_FLAT_HIERARCHY_N2

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

ID

n/a

n/a

n/a

n/a

n/a

updated: table: clb_notifications

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

updated

Index

CLB_NOTIFICATIONS_N1

n/a

n/a

n/a

n/a

n/a

updated: table: cmn_actions

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Index

CMN_ACTIONS_N3

n/a

n/a

n/a

n/a

n/a

updated

Index

CMN_ACTIONS_N1

n/a

n/a

n/a

n/a

n/a

updated

Index

CMN_ACTIONS_N2

n/a

n/a

n/a

n/a

n/a

updated: table: cmn_captions_nls

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Index

CMN_CAPTIONS_NLS_U3

n/a

n/a

n/a

n/a

n/a

updated: table: cmn_grids

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

USE_DISPLAY_CONDS_FOR_SECURITY

boolean

1

n/a

n/a

N

updated: table: cmn_grid_cols

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

SHOW_TSV_LEGEND

boolean

n/a

n/a

n/a

Y

updated: table: cmn_instance_pages

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

updated

Index

CMN_INSTANCE_PAGES_N1

n/a

n/a

n/a

n/a

n/a

updated: table: cmn_menu_items

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Index

CMN_MENU_ITEMS_U1

n/a

n/a

n/a

n/a

n/a

added

Index

CMN_MENU_ITEMS_N3

n/a

n/a

n/a

n/a

n/a

updated

Index

CMN_MENU_ITEMS_N1

n/a

n/a

n/a

n/a

n/a

updated

Index

CMN_MENU_ITEMS_N2

n/a

n/a

n/a

n/a

n/a

updated: table: cmn_sch_job_runs

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Index

CMN_SCH_JOB_RUNS_N3

n/a

n/a

n/a

n/a

n/a

updated: table: cmn_sec_assgnd_right

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Index

CMN_SEC_ASSGND_RIGHT_N5

n/a

n/a

n/a

n/a

n/a

updated

Index

CMN_SEC_ASSGND_RIGHT_N3

n/a

n/a

n/a

n/a

n/a

updated: table: cmn_sec_groups

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Index

CMN_SEC_GROUPS_N2

n/a

n/a

n/a

n/a

n/a

deleted

Index

CMN_SEC_GROUPS_C1

n/a

n/a

n/a

n/a

n/a

updated

Index

CMN_SEC_GROUPS_N1

n/a

n/a

n/a

n/a

n/a

updated: table: cmn_sec_group_flat_hiers

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

updated

Index

CMN_SEC_GROUP_FLAT_HIERS_N1

n/a

n/a

n/a

n/a

n/a

updated: table: cmn_sec_right

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Index

CMN_SEC_RIGHT_N2

n/a

n/a

n/a

n/a

n/a

added

Index

CMN_SEC_RIGHT_N3

n/a

n/a

n/a

n/a

n/a

updated: table: cmn_sec_users

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

HOME_URL

varchar

n/a

n/a

n/a

Y

deleted

Column

USER_TYPE_ID

n/a

n/a

n/a

n/a

n/a

deleted

Column

NOTIFICATION_FLAGS

n/a

n/a

n/a

n/a

n/a

deleted

Column

LAST_VALID_LOGIN_DATE

n/a

n/a

n/a

n/a

n/a

updated: table: nms_messages

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Index

NMS_MESSAGES_N2

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

EXPIRY_DATE

n/a

n/a

n/a

n/a

n/a

updated: table: nms_message_delivery

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Index

NMS_MESSAGE_DELIVERY_N2

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

updated

Column

TARGET

n/a

n/a

n/a

n/a

n/a

updated: table: prj_obs_associations

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

updated

Index

PRJ_OBS_ASSOCIATIONS_N3

n/a

n/a

n/a

n/a

n/a

updated: table: prj_projects

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

updated

Index

PRJ_PROJECTS_U1

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

PRFILENAME

n/a

n/a

n/a

n/a

n/a

deleted

Column

PREXPORTMAP

n/a

n/a

n/a

n/a

n/a

deleted

Column

PRRESOURCEPOOLID

n/a

n/a

n/a

n/a

n/a

deleted

Column

PRUSERNAME

n/a

n/a

n/a

n/a

n/a

deleted

Column

PREXTENSION

n/a

n/a

n/a

n/a

n/a

deleted

Column

BASE_USAGE_SUM

n/a

n/a

n/a

n/a

n/a

deleted

Column

BASE_COST_SUM

n/a

n/a

n/a

n/a

n/a

deleted

Column

BASE_DURATION

n/a

n/a

n/a

n/a

n/a

updated: table: prlist

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Index

PRLIST_U1

n/a

n/a

n/a

n/a

n/a

added

Index

PRLIST_N1

n/a

n/a

n/a

n/a

n/a

deleted

Index

PRLIST3

n/a

n/a

n/a

n/a

n/a

deleted

Index

PRLIST4

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

PRUSERNAME

n/a

n/a

n/a

n/a

n/a

updated: table: prlistmember

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Index

PRLISTMEMBER_U1

n/a

n/a

n/a

n/a

n/a

added

Index

PRLISTMEMBER_U2

n/a

n/a

n/a

n/a

n/a

updated: table: prteam

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Index

PRTEAM_N7

n/a

n/a

n/a

n/a

n/a

deleted

Index

PRTEAM_N3

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

HARD_CURVE

blob

n/a

n/a

n/a

Y

added

Column

HARD_SLICE_STATUS

numeric

n/a

n/a

n/a

Y

added

Column

HARD_SUM

float

n/a

n/a

n/a

Y

added

Column

HARD_START

date

n/a

n/a

n/a

Y

added

Column

HARD_FINISH

date

n/a

n/a

n/a

Y

deleted

Column

PREXTENSION

n/a

n/a

n/a

n/a

n/a

deleted

Column

BASE_USAGE_SUM

n/a

n/a

n/a

n/a

n/a

deleted

Column

BASE_COST_SUM

n/a

n/a

n/a

n/a

n/a

deleted

Column

BASE_START

n/a

n/a

n/a

n/a

n/a

deleted

Column

BASE_FINISH

n/a

n/a

n/a

n/a

n/a

deleted

Column

BASE_DURATION

n/a

n/a

n/a

n/a

n/a

updated: table: rim_risks_and_issues

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Index

RIM_RISKS_AND_ISSUES_N4

n/a

n/a

n/a

n/a

n/a

updated: table: srm_projects

Indexes

Vendor specific: mssql

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Index

SRM_PROJECTS_U2

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

UPPER_UNIQUE_NAME

varchar

n/a

n/a

n/a

Y

deleted

Column

PURGE

n/a

n/a

n/a

n/a

n/a

updated: table: temp_rsm_rsf_skills

Table

Vendor specific: oracle

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

PROF_LEVEL2

numeric

0

n/a

n/a

N

Table

Vendor specific: mssql

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

PROF_LEVEL2

numeric

0

n/a

n/a

N