Clarity logo

Database Schema Changes from Clarity 7.5 to 7.5.1

added: function: cmn_get_retain_precision_fct

added: function: itl_get_actual_effort_fct

added: function: odf_sub_obj_view_right_fct

added: function: pac_fos_is_valid_loc_gl_fct

added: procedure: cmn_sch_jobs_sync_upd_sp

added: procedure: odf_view_captions_copy_sp

added: procedure: prj_blb_update_teams_sp

added: procedure: prj_wbs_update_sp

added: procedure: rev_bill_validateprojects

added: sequence: bpm_custom_script_props_s1

added: sequence: bpm_session_data_s1

added: sequence: cmn_custom_scripts_s1

added: sequence: cmn_custom_script_params_s1

added: sequence: cmn_grid_col_aggs_s1

added: sequence: cmn_sources_s1

added: sequence: odf_attribute_mapping_s1

added: sequence: odf_object_mapping_flat_s1

added: sequence: odf_object_mapping_s1

added: sequence: pma_priority_chart_conf_s1

added: sequence: pma_scenario_constraints_s1

added: sequence: pma_scenario_opt_params_s1

added: sequence: prj_ev_history_s1

added: table: bpm_custom_script_props

added: table: bpm_session_data

added: table: cmn_custom_scripts

added: table: cmn_custom_script_params

added: table: cmn_grid_col_aggs

added: table: cmn_xog_install_history

added: table: odf_attribute_mapping

added: table: odf_default_overrides

added: table: odf_object_mapping

added: table: odf_object_mapping_flat

added: table: pma_ef_candidates

added: table: pma_ef_investments

added: table: pma_priority_chart_conf

added: table: pma_scenario_constraints

added: table: pma_scenario_opt_params

added: table: prj_blb_slices_d_base

added: table: prj_blb_slices_m_base

added: table: prj_blb_slices_w_base

added: table: prj_ev_history

added: trigger: odf_object_mapping_del_t1

added: trigger: odf_object_mapping_ins_t1

updated: table: bpm_def_assignees

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

OBJECT_TYPE_CODE

varchar

n/a

n/a

n/a

Y

added

Column

OBJECT_ATTRIBUTE_CODE

varchar

n/a

n/a

n/a

Y

updated: table: bpm_def_processes

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

updated

Column

SOURCE

n/a

n/a

n/a

n/a

n/a

updated

Column

SOURCE

n/a

customer

n/a

n/a

n/a

updated: table: bpm_def_step_actions

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

SCRIPT_ID

numeric

n/a

n/a

n/a

Y

updated: table: bpm_errors

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

ATTRIBUTE1

varchar

n/a

n/a

n/a

Y

added

Column

ATTRIBUTE2

varchar

n/a

n/a

n/a

Y

deleted

Column

EXCEPTION_TRACE

n/a

n/a

n/a

n/a

n/a

updated: table: bpm_run_replace_assignees

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

OBJECT_TYPE_CODE

varchar

n/a

n/a

n/a

Y

added

Column

OBJECT_ATTRIBUTE_CODE

varchar

n/a

n/a

n/a

Y

updated: table: bpm_run_step_cond_objects

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

updated

Column

OBJECT_NAME

n/a

n/a

n/a

n/a

Y

updated: table: bpm_run_threads

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

JOIN_STEP_INSTANCE_ID

numeric

n/a

n/a

n/a

Y

updated: table: cal_action_items

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

CAL_ACTION_ITEMS_N3

n/a

n/a

n/a

n/a

n/a

deleted

Index

CAL_ACTION_ITEMS_N4

n/a

n/a

n/a

n/a

n/a

deleted

Index

CAL_ACTION_ITEMS_N5

n/a

n/a

n/a

n/a

n/a

deleted

Index

CAL_ACTION_ITEMS_N6

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

STATUS_TYPE_CODE

varchar

CAL_EVENT_STATUS

n/a

n/a

N

deleted

Column

RECURRING_SCHED_ID

n/a

n/a

n/a

n/a

n/a

deleted

Column

REMINDER_SCHED_ID

n/a

n/a

n/a

n/a

n/a

deleted

Column

LINK_DETAIL

n/a

n/a

n/a

n/a

n/a

updated: table: cap_views

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

OBS_UNIT_ID

numeric

n/a

n/a

n/a

Y

updated: table: cmn_captions_nls

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Index

CMN_CAPTIONS_NLS_U2

n/a

n/a

n/a

n/a

n/a

updated: table: cmn_fragments

deleted: Table

updated: table: cmn_gg_items

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

SHOW_LABEL

boolean

n/a

n/a

n/a

Y

added

Column

SHOW_ITEM

boolean

n/a

n/a

n/a

Y

added

Column

IS_VARIANCE

boolean

n/a

n/a

n/a

Y

added

Column

COLOR

varchar

n/a

n/a

n/a

Y

added

Column

VALUE_TYPE

varchar

n/a

n/a

n/a

Y

added

Column

FIXED_VALUE

numeric

n/a

n/a

9

Y

updated: table: cmn_gg_nsql_queries

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

updated

Column

SOURCE

n/a

customer

n/a

n/a

n/a

updated: table: cmn_lookup_types

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

updated

Column

SOURCE

n/a

customer

n/a

n/a

n/a

updated: table: cmn_pages

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

updated

Column

SOURCE

n/a

customer

n/a

n/a

n/a

updated: table: cmn_per_user_fragments

deleted: Table

updated: table: cmn_portlets

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

updated

Column

SOURCE

n/a

customer

n/a

n/a

n/a

updated: table: cmn_sec_assgnd_obj_perm

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Index

CMN_SEC_ASSGND_OBJ_PERM_N4

n/a

n/a

n/a

n/a

n/a

updated

Index

CMN_SEC_ASSGND_OBJ_PERM_N2

n/a

n/a

n/a

n/a

n/a

updated: table: cmn_sec_objects

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

updated

Column

OBJECT_CODE

n/a

n/a

n/a

n/a

n/a

updated: table: cmn_sec_permissions

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

updated

Column

PERMISSION_CODE

n/a

n/a

n/a

n/a

n/a

updated: table: cmn_sec_perm_elements

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

updated

Index

CMN_SEC_PERM_ELEMENTS_N1

n/a

n/a

n/a

n/a

n/a

updated

Index

CMN_SEC_PERM_ELEMENTS_N2

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

updated

Column

PERMISSION_CODE

n/a

n/a

n/a

n/a

n/a

updated: table: cmn_sec_policies

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

updated

Column

PERMISSION_CODE

n/a

n/a

n/a

n/a

n/a

updated: table: esc_def_rules

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

updated

Column

INITIAL_PERIOD_INTERVAL

n/a

n/a

n/a

n/a

n/a

updated

Column

INITIAL_PERIOD_INTERVAL

n/a

n/a

n/a

6

n/a

updated

Column

SUBSEQUENT_PERIOD_INTERVAL

n/a

n/a

n/a

n/a

n/a

updated

Column

SUBSEQUENT_PERIOD_INTERVAL

n/a

n/a

n/a

6

n/a

updated: table: fin_errors

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

IS_SYSTEM

integer

0

n/a

n/a

N

updated: table: fin_txns

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

TIMEENTRY_ID

numeric

n/a

n/a

n/a

Y

added

Column

TRANSACTION_DATE

date

n/a

n/a

n/a

Y

added

Column

SOURCE_MODULE

integer

0

n/a

n/a

N

updated: table: imm_incidents

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

updated

Column

ESTIMATED_EFFORT

n/a

n/a

n/a

n/a

n/a

updated

Column

ESTIMATED_EFFORT

n/a

n/a

n/a

6

n/a

updated: table: obs_units_flat_by_mode

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Index

OBS_UNITS_FLAT_BY_MODE_U1

n/a

n/a

n/a

n/a

n/a

added

Index

OBS_UNITS_FLAT_BY_MODE_U2

n/a

n/a

n/a

n/a

n/a

deleted

Index

OBS_UNITS_FLAT_BY_MODE_N1

n/a

n/a

n/a

n/a

n/a

deleted

Index

OBS_UNITS_FLAT_BY_MODE_N2

n/a

n/a

n/a

n/a

n/a

updated: table: odf_objects

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

IS_COPY_ENABLED

numeric

0

n/a

n/a

N

added

Column

IS_EXPORT_ENABLED

numeric

0

n/a

n/a

N

added

Column

IS_VIEW_ALL_ENABLED

numeric

0

n/a

n/a

N

updated: table: odf_subviews

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Index

ODF_SUBVIEWS_U2

n/a

n/a

n/a

n/a

n/a

deleted

Index

ODF_SUBVIEWS_N2

n/a

n/a

n/a

n/a

n/a

updated: table: odf_views

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

IS_SECURE

numeric

0

n/a

n/a

N

deleted

Column

DEFAULT_SORT_COLUMN_CODE

n/a

n/a

n/a

n/a

n/a

deleted

Column

DEFAULT_SORT_COLUMN_ORDER

n/a

n/a

n/a

n/a

n/a

deleted

Column

SECOND_SORT_COLUMN_CODE

n/a

n/a

n/a

n/a

n/a

deleted

Column

SECOND_SORT_COLUMN_ORDER

n/a

n/a

n/a

n/a

n/a

deleted

Column

THIRD_SORT_COLUMN_CODE

n/a

n/a

n/a

n/a

n/a

deleted

Column

THIRD_SORT_COLUMN_ORDER

n/a

n/a

n/a

n/a

n/a

deleted

Column

FOURTH_SORT_COLUMN_CODE

n/a

n/a

n/a

n/a

n/a

deleted

Column

FOURTH_SORT_COLUMN_ORDER

n/a

n/a

n/a

n/a

n/a

updated

Column

CAPTION

n/a

n/a

n/a

n/a

n/a

updated: table: odf_view_attributes

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Index

ODF_VIEW_ATTRIBUTES_U1

n/a

n/a

n/a

n/a

n/a

added

Index

ODF_VIEW_ATTRIBUTES_U2

n/a

n/a

n/a

n/a

n/a

added

Index

ODF_VIEW_ATTRIBUTES_U3

n/a

n/a

n/a

n/a

n/a

deleted

Index

ODF_VIEW_ATTRIBUTES_N2

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

updated

Column

LABEL

n/a

n/a

n/a

n/a

n/a

updated: table: odf_view_sections

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

updated

Column

LABEL

n/a

n/a

n/a

n/a

n/a

updated: table: pac_chg_srch_gl_params

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

updated

Column

VALUE

n/a

n/a

n/a

n/a

n/a

updated: table: prcalendar

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

PRCALENDAR_N1

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

PRVERSION

numeric

1

n/a

n/a

N

updated: table: prchargecode

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Index

PRCHARGECODE_N1

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

PRPROJECTID

numeric

n/a

n/a

n/a

Y

updated: table: prj_baselines

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

IS_CURRENT

numeric

n/a

n/a

n/a

Y

updated: table: prj_baseline_details

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

IS_CURRENT

numeric

n/a

n/a

n/a

Y

deleted

Column

PCTCOMPLETE

n/a

n/a

n/a

n/a

n/a

updated: table: prj_blb_slicerequests

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Index

PRJ_BLB_SLICEREQUESTS_U2

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

updated

Column

REQUEST_NAME

n/a

n/a

n/a

n/a

N

updated: table: prtask

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

WBS_PARSEQ

numeric

n/a

n/a

n/a

Y

added

Column

WBS_NNBSEQ

numeric

n/a

n/a

n/a

Y

deleted

Column

PRGUIDELINEID

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

updated: table: prtimeentry

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Index

PRTIMEENTRY4

n/a

n/a

n/a

n/a

n/a

deleted

Index

PRTIMEENTRY_N1

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

INCIDENT_ID

numeric

n/a

n/a

n/a

Y

added

Column

INCIDENT_INVESTMENT_ID

numeric

n/a

n/a

n/a

Y

deleted

Column

PRRMEXPORTEDTIME

n/a

n/a

n/a

n/a

n/a

deleted

Column

PRSTATUS

n/a

n/a

n/a

n/a

n/a

deleted

Column

PRVERSION

n/a

n/a

n/a

n/a

n/a

deleted

Column

PRSUBMITTEDBY

n/a

n/a

n/a

n/a

n/a

deleted

Column

PRSUBMITTEDTIME

n/a

n/a

n/a

n/a

n/a

deleted

Column

PRAPPROVEDBY

n/a

n/a

n/a

n/a

n/a

deleted

Column

PRAPPROVEDTIME

n/a

n/a

n/a

n/a

n/a

deleted

Column

PRISADJUSTMENT

n/a

n/a

n/a

n/a

n/a

deleted

Column

PRADJUSTEDID

n/a

n/a

n/a

n/a

n/a

deleted

Column

PRADJUSTEDTIME

n/a

n/a

n/a

n/a

n/a

deleted

Column

PRPOSTEDTIME

n/a

n/a

n/a

n/a

n/a

deleted

Column

PRCORRECTID

n/a

n/a

n/a

n/a

n/a