Database Schema Changes from Clarity 7.5.3 to 8.0

updated: table: apmaster

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

LOCATION_CODE

n/a

n/a

n/a

n/a

8

60

n/a

n/a

n/a

updated: table: arerrorlog

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

ENTITY

n/a

n/a

n/a

n/a

8

60

n/a

n/a

n/a

updated: table: armaster

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

LOCATION_CODE

n/a

n/a

n/a

n/a

8

60

n/a

n/a

n/a

updated: table: biz_com_periods

Index: updated

deleted index: BIZ_COM_PERIODS_U1

added index: BIZ_COM_PERIODS_N1

added column: ENTITY_ID

table: updated

Vendor-specific: oracle

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

ENTITY_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

IS_ACTIVE

n/a

numeric

n/a

0

n/a

n/a

n/a

n/a

Y

added

CREATED_DATE

n/a

date

n/a

SYSDATE

n/a

n/a

n/a

n/a

N

added

CREATED_BY

n/a

numeric

n/a

1

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_DATE

n/a

date

n/a

SYSDATE

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_BY

n/a

numeric

n/a

1

n/a

n/a

n/a

n/a

N

updated

PERIOD

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated

P_QUARTER

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

table: updated

Vendor-specific: mssql

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

ENTITY_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

IS_ACTIVE

n/a

numeric

n/a

0

n/a

n/a

n/a

n/a

Y

added

CREATED_DATE

n/a

date

n/a

GETDATE()

n/a

n/a

n/a

n/a

N

added

CREATED_BY

n/a

numeric

n/a

1

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_DATE

n/a

date

n/a

GETDATE()

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_BY

n/a

numeric

n/a

1

n/a

n/a

n/a

n/a

N

updated

PERIOD

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated

P_QUARTER

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated: table: bpm_def_assignees

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

OBJECT_NAME

n/a

varchar

n/a

n/a

n/a

240

n/a

n/a

Y

updated: table: bpm_def_objects

Index: updated

updated index: BPM_DEF_OBJECTS_N3

added column: PARTITION_CODE

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

TYPE_CODE

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

added

MANUAL_START

n/a

boolean

n/a

0

n/a

n/a

n/a

n/a

Y

added

PARENT_OBJECT_REF_CODE

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

added

IS_VISIBLE

n/a

boolean

n/a

0

n/a

n/a

n/a

n/a

N

updated

IS_XDM

n/a

n/a

n/a

n/a

n/a

n/a

n/a

Y

N

updated

IS_SYSTEM

n/a

n/a

n/a

n/a

n/a

n/a

n/a

Y

N

updated: table: bpm_def_process_versions

Index: updated

updated index: BPM_DEF_PROCESS_VERSIONS_N2

deleted column: START_OPTION_CODE

updated index: BPM_DEF_PROCESS_VERSIONS_N3

deleted column: START_OPTION_CODE

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

IS_SINGLETON

n/a

numeric

n/a

0

n/a

1

n/a

n/a

N

updated

START_OPTION_CODE

n/a

n/a

unspecified

ON_DEMAND

n/a

n/a

n/a

Y

N

updated: table: bpm_def_steps

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

INTERNAL_STATUS_CODE

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

updated: table: bpm_def_step_actions

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

ACTION_CODE

n/a

varchar

n/a

n/a

n/a

120

n/a

n/a

Y

added

SUBPROCESS_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

SUBPROCESS_INIT_OBJECT_KEY

n/a

varchar

n/a

n/a

n/a

80

n/a

n/a

Y

added

INDEPENDENT

n/a

boolean

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

SEQUENCE

n/a

numeric

n/a

1

n/a

n/a

n/a

n/a

N

added

NOTIFY_WHEN

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

NOTIFY_OWNER

n/a

boolean

n/a

n/a

n/a

n/a

n/a

n/a

Y

updated: table: bpm_def_step_action_params

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

DEF_OBJECT_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

updated: table: bpm_errors

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

STEP_ACTION_RESULT_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

updated: table: bpm_run_assignees

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

ENGINE_RUN_ID

n/a

numeric

n/a

-1

n/a

n/a

n/a

n/a

Y

updated: table: bpm_run_objects

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

TYPE_CODE

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

added

PARENT_OBJECT_REF_CODE

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

updated: table: bpm_run_processes

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

SRC_STEP_ACTION_RESULT_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

updated: table: bpm_run_process_engine_runs

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

ACTION_EVENT_EX

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

updated: table: bpm_run_replace_assignees

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

OBJECT_NAME

n/a

varchar

n/a

n/a

n/a

240

n/a

n/a

Y

updated: table: bpm_run_steps

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

ENGINE_RUN_ID

n/a

numeric

n/a

-1

n/a

n/a

n/a

n/a

Y

updated: table: bpm_run_step_action_results

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

ENGINE_RUN_ID

n/a

numeric

n/a

-1

n/a

n/a

n/a

n/a

Y

added

JOB_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

STATUS_CODE

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

added

START_DATE

n/a

date

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

END_DATE

n/a

date

n/a

n/a

n/a

n/a

n/a

n/a

Y

updated: table: bpm_run_step_cond_results

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

ENGINE_RUN_ID

n/a

n/a

unspecified

-1

n/a

n/a

n/a

N

Y

updated: table: bpm_run_step_transitions

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

ENGINE_RUN_ID

n/a

numeric

n/a

-1

n/a

n/a

n/a

n/a

Y

updated: table: bpm_run_threads

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

ENGINE_RUN_ID

n/a

numeric

n/a

-1

n/a

n/a

n/a

n/a

Y

updated: table: cal_action_items

Index: updated

added index: CAL_ACTION_ITEMS_N11

added column: CREATED_BY

Index: updated

deleted index: CAL_ACTION_ITEMS_N1

deleted index: CAL_ACTION_ITEMS_N2

deleted index: CAL_ACTION_ITEMS_N7

deleted index: CAL_ACTION_ITEMS_N8

added index: CAL_ACTION_ITEMS_N9

added column: NLS_UPPER( SUBJECT )

added index: CAL_ACTION_ITEMS_N10

added column: NLS_UPPER( OBJECT_TYPE )

Index: updated

deleted index: CAL_ACTION_ITEMS_N1

deleted index: CAL_ACTION_ITEMS_N2

deleted index: CAL_ACTION_ITEMS_N7

deleted index: CAL_ACTION_ITEMS_N8

added index: CAL_ACTION_ITEMS_N9

added column: SUBJECT

added index: CAL_ACTION_ITEMS_N10

added column: OBJECT_TYPE

updated: table: cal_action_item_assignees

Index: updated

added index: CAL_AI_ASSIGNEES_N3

added column: ASSIGNEE_ID

added column: CAL_ACTION_ITEM_ID

added index: CAL_AI_ASSIGNEES_N6

added column: IS_PROXY

added index: CAL_AI_ASSIGNEES_N7

added column: IS_ESCALATED

Index: updated

deleted index: CAL_AI_ASSIGNEES_N1

deleted index: CAL_AI_ASSIGNEES_N2

deleted index: CAL_AI_ASSIGNEES_N4

added index: CAL_AI_ASSIGNEES_N5

added column: NLS_UPPER( STATUS_CODE )

Index: updated

deleted index: CAL_AI_ASSIGNEES_N1

deleted index: CAL_AI_ASSIGNEES_N2

deleted index: CAL_AI_ASSIGNEES_N4

added index: CAL_AI_ASSIGNEES_N5

added column: STATUS_CODE

updated: table: cap_scenario_members

Index: updated

updated index: CAP_SCENARIO_MEMBERS_N1

added column: OBJECT_ID

added column: IS_APPROVED

added column: IS_ACTIVE

added column: IS_EXCLUDED

added column: PRIORITY

added column: IS_EXPRESSION

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

PLANNED_COST

n/a

numeric

n/a

n/a

n/a

32

6

n/a

Y

added

PLANNED_COST_START

n/a

date

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

PLANNED_COST_FINISH

n/a

date

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

PLANNED_BENEFIT

n/a

numeric

n/a

n/a

n/a

32

6

n/a

Y

added

PLANNED_BENEFIT_START

n/a

date

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

PLANNED_BENEFIT_FINISH

n/a

date

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

BDGT_CST_FINISH

n/a

date

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

BDGT_REV_START

n/a

date

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

BDGT_REV_FINISH

n/a

date

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

FCST_CST_START

n/a

date

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

FCST_CST_FINISH

n/a

date

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

FCST_REV_START

n/a

date

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

FCST_REV_FINISH

n/a

date

n/a

n/a

n/a

n/a

n/a

n/a

Y

updated: table: clb_dms_flat_hierarchy

Index: updated

updated index: CLB_DMS_FLAT_HIERARCHY_N1

updated attribute: Unique from false to true

updated index: CLB_DMS_FLAT_HIERARCHY_N2

updated attribute: Unique from false to true

updated: table: clb_temp_search_ids

table: updated

Vendor-specific: oracle

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

IS_ATTACHMENT

n/a

numeric

n/a

0

n/a

n/a

n/a

n/a

N

table: updated

Vendor-specific: mssql

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

IS_ATTACHMENT

n/a

numeric

n/a

0

n/a

n/a

n/a

n/a

N

updated: table: clntsupp

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

INVOICE_TEMPLATE

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

updated

LOCATIONID

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

DEPARTCODE

n/a

n/a

n/a

n/a

6

60

n/a

n/a

n/a

updated: table: cmn_audits

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

RAW_VALUE_BEFORE

n/a

varchar

n/a

n/a

n/a

4000

n/a

n/a

Y

added

RAW_VALUE_AFTER

n/a

varchar

n/a

n/a

n/a

4000

n/a

n/a

Y

updated

VALUE_BEFORE

n/a

n/a

n/a

n/a

2000

4000

n/a

n/a

n/a

updated

VALUE_AFTER

n/a

n/a

n/a

n/a

2000

4000

n/a

n/a

n/a

updated

OPERATION_CODE

n/a

n/a

n/a

n/a

2

1

n/a

n/a

n/a

updated: table: cmn_autonum_schemes

Index: updated

updated index: CMN_AUTONUM_SCHEMES_U1

added column: ATTRIBUTE_CODE

added column: PARTITION_CODE

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

ATTRIBUTE_CODE

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

added

PARTITION_CODE

n/a

varchar

n/a

NIKU.ROOT

n/a

30

n/a

n/a

N

added

MAX_LENGTH

n/a

integer

n/a

30

n/a

n/a

n/a

n/a

N

updated

NEXT_VALUE

n/a

n/a

n/a

n/a

20

80

n/a

n/a

n/a

updated: table: cmn_autonum_scheme_segments

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

IS_AUTO_EXTENDED

n/a

integer

n/a

0

n/a

n/a

n/a

n/a

N

updated

START_VALUE

n/a

n/a

n/a

n/a

19

38

n/a

n/a

n/a

updated

NEXT_VALUE

n/a

n/a

n/a

n/a

19

38

n/a

n/a

n/a

updated

TEXT_VALUE

n/a

n/a

n/a

n/a

20

80

n/a

n/a

n/a

updated: table: cmn_gg_nsql_queries

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

ACTION_ODF_OBJECT_CODE

n/a

varchar

n/a

n/a

n/a

50

n/a

n/a

Y

added

ACTION_ODF_PK_ITEM

n/a

varchar

n/a

n/a

n/a

50

n/a

n/a

Y

updated: table: cmn_graphs

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

ALLOW_CONFIGURE

n/a

boolean

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

ALLOW_CONFIGURE_LABEL

n/a

boolean

n/a

n/a

n/a

n/a

n/a

n/a

Y

updated: table: cmn_grids

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

ALLOW_CONFIGURE

n/a

boolean

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

ALLOW_CONFIGURE_LABEL

n/a

boolean

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

INCLUDE_EMPTY_SECONDARY

n/a

boolean

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

AUTO_EXPAND

n/a

boolean

n/a

n/a

n/a

n/a

n/a

n/a

Y

updated

FORCE_FILTER

n/a

n/a

unspecified

0

n/a

n/a

n/a

Y

N

updated: table: cmn_grid_cols

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

SHOW_HEADER_LABEL

n/a

n/a

unspecified

1

n/a

n/a

n/a

Y

N

updated: table: cmn_lookups

Index: updated

added index: CMN_LOOKUPS_U2

added column: LOOKUP_CODE

added column: LOOKUP_TYPE

added column: ID

updated: table: cmn_menu_items

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

IS_REORDERABLE

n/a

numeric

n/a

1

n/a

n/a

n/a

n/a

N

updated: table: cmn_nsql_query_filters

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

LOV

n/a

n/a

n/a

n/a

30

255

n/a

n/a

n/a

updated: table: cmn_page_portlets

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

IS_PAGE_LEVEL_FILTER

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

IS_PAGE_FILTER_DEFAULT

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

updated: table: cmn_portlets

Index: updated

added index: CMN_PORTLETS_N1

added column: ID

added column: IS_ACTIVE

added index: CMN_PORTLETS_N2

added column: POLICY_ID

added column: IS_ACTIVE

added column: ID

updated: table: cmn_rpt_categories

Index: deleted

updated: table: cmn_rpt_parameters

Index: deleted

updated: table: cmn_rpt_reports

Index: deleted

updated: table: cmn_rpt_run_reports

Index: deleted

updated: table: cmn_sec_assgnd_obj_perm

Index: updated

added index: CMN_SEC_ASSGND_OBJ_PERM_N5

added column: OBJECT_ID

added column: PERMISSION_ID

added column: OBJECT_INSTANCE_ID

added column: PRINCIPAL_TYPE

added column: PRINCIPAL_ID

added column: RIGHT_ID

updated: table: cmn_sec_assgnd_right

Index: updated

added index: CMN_SEC_ASSGND_RIGHT_N6

added column: RIGHT_ID

added column: PRINCIPAL_TYPE

added column: INSTANCE_ID

added column: INSTANCE_TYPE

added column: PRINCIPAL_ID

updated: table: cmn_sec_groups

Index: updated

updated index: CMN_SEC_GROUPS_N1

added column: GROUP_ROLE_TYPE

added index: CMN_SEC_GROUPS_N3

added column: ID

added column: GROUP_CODE

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

LIC_RIGHT_TYPE

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

updated: table: cmn_sec_perm_elements

Index: updated

added index: CMN_SEC_PERM_ELEMENTS_U1

added column: PERMISSION_ID

added column: PERMISSION_CODE

added column: PERMISSION_VALUE

added index: CMN_SEC_PERM_ELEMENTS_U2

added column: PERMISSION_CODE

added column: PERMISSION_VALUE

added column: PERMISSION_ID

added column: ID

updated: table: cmn_sec_right

Index: updated

updated index: CMN_SEC_RIGHT_U3

added column: RIGHT_TYPE

added index: CMN_SEC_RIGHT_U4

added column: RIGHT_ID

added column: OBJECT_ID

added column: PERMISSION_ID

added column: PERMISSION_CODE

added column: PERMISSION_VALUE

updated: table: cmn_user_pages

Index: updated

added index: CMN_USER_PAGES_N1

added column: USER_ID

added column: OBJECT_TYPE

added column: OBJECT_INSTANCE_ID

added column: PAGE_ID

added column: IS_USER_PERSONALIZATION

updated: table: departments

Index: updated

updated index: DEPARTMENTS_IDX

updated attribute: Unique from true to false

added column: ENTITY_ID

added index: DEPARTMENTS_U1

added column: DEPARTCODE

table: updated

Vendor-specific: oracle

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

OBS_UNIT_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

PARENT_DEPARTMENT_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

DEPARTMENT_MANAGER_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

BRM_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

ENTITY_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

PORTFOLIO_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

DELEGATE_INV_APPR

n/a

boolean

n/a

0

n/a

n/a

n/a

n/a

N

added

CREATED_DATE

n/a

date

n/a

SYSDATE

n/a

n/a

n/a

n/a

N

added

CREATED_BY

n/a

numeric

n/a

1

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_DATE

n/a

date

n/a

SYSDATE

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_BY

n/a

numeric

n/a

1

n/a

n/a

n/a

n/a

N

updated

DEPARTCODE

n/a

n/a

n/a

n/a

6

60

n/a

n/a

n/a

updated

DESCRIPTION

n/a

n/a

n/a

n/a

40

720

n/a

N

Y

updated

SHORTDESC

n/a

n/a

n/a

n/a

15

120

n/a

n/a

n/a

table: updated

Vendor-specific: mssql

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

OBS_UNIT_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

PARENT_DEPARTMENT_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

DEPARTMENT_MANAGER_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

BRM_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

ENTITY_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

PORTFOLIO_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

DELEGATE_INV_APPR

n/a

boolean

n/a

0

n/a

n/a

n/a

n/a

N

added

CREATED_DATE

n/a

date

n/a

GETDATE()

n/a

n/a

n/a

n/a

N

added

CREATED_BY

n/a

numeric

n/a

1

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_DATE

n/a

date

n/a

GETDATE()

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_BY

n/a

numeric

n/a

1

n/a

n/a

n/a

n/a

N

updated

DEPARTCODE

n/a

n/a

n/a

n/a

6

60

n/a

n/a

n/a

updated

DESCRIPTION

n/a

n/a

n/a

n/a

40

720

n/a

N

Y

updated

SHORTDESC

n/a

n/a

n/a

n/a

15

120

n/a

n/a

n/a

updated: table: entity

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

FIN_PERIOD_CODE

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

added

ORG_CHART_OBS_TYPE_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

GEO_CHART_OBS_TYPE_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

updated

ENTITY

n/a

n/a

n/a

n/a

8

60

n/a

n/a

n/a

updated

DESCRIPTION

n/a

n/a

n/a

n/a

40

720

n/a

n/a

n/a

updated

SHORTDESC

n/a

n/a

n/a

n/a

15

120

n/a

n/a

n/a

updated

REMIT_TO_LOCATION

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated: table: fin_txns

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

TRANSACTION_DATE

n/a

n/a

n/a

n/a

n/a

n/a

n/a

Y

N

updated: table: imm_incidents

Index: updated

deleted index: IMM_INCIDENTS_U1

deleted index: IMM_INCIDENTS_N4

added index: ITL_IMM_INCIDENTS_N6

added column: CREATED_DATE

Index: updated

updated index: IMM_INCIDENTS_U1

deleted column: INCIDENT_CODE

added column: NLS_UPPER(INCIDENT_CODE)

deleted index: IMM_INCIDENTS_N1

deleted index: IMM_INCIDENTS_N2

updated index: IMM_INCIDENTS_N4

deleted column: SUBJECT

added column: NLS_UPPER(SUBJECT)

deleted index: ITL_IMM_INCIDENTS_N5

Index: updated

deleted index: IMM_INCIDENTS_N1

deleted index: IMM_INCIDENTS_N2

deleted index: ITL_IMM_INCIDENTS_N5

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

INVESTMENT_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

updated: table: imp_transactionimport

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

USER_LOV1

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

added

USER_LOV2

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

added

EXPENSE_TYPE

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

updated: table: itl_object_associations

Index: deleted

updated: table: locationdept

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

LOCN_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

DEPT_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

updated

LOCATIONID

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

DEPARTCODE

n/a

n/a

n/a

n/a

6

60

n/a

n/a

n/a

updated: table: locations

table: updated

Vendor-specific: oracle

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

PARENT_LOCATION_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

OBS_UNIT_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

ENTITY_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

LOCATION_MANAGER_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

CREATED_DATE

n/a

date

n/a

SYSDATE

n/a

n/a

n/a

n/a

N

added

CREATED_BY

n/a

numeric

n/a

1

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_DATE

n/a

date

n/a

SYSDATE

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_BY

n/a

numeric

n/a

1

n/a

n/a

n/a

n/a

N

deleted

COUNTYID

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

updated

LOCATIONID

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

ENTITY

n/a

n/a

n/a

n/a

8

60

n/a

n/a

n/a

updated

LOCATIONDESCRIPTION

n/a

n/a

n/a

n/a

40

720

n/a

N

Y

updated

SHORTDESC

n/a

n/a

n/a

n/a

15

120

n/a

n/a

n/a

updated

COUNTRYID

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

table: updated

Vendor-specific: mssql

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

PARENT_LOCATION_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

OBS_UNIT_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

ENTITY_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

LOCATION_MANAGER_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

CREATED_DATE

n/a

date

n/a

GETDATE()

n/a

n/a

n/a

n/a

N

added

CREATED_BY

n/a

numeric

n/a

1

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_DATE

n/a

date

n/a

GETDATE()

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_BY

n/a

numeric

n/a

1

n/a

n/a

n/a

n/a

N

deleted

COUNTYID

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

updated

LOCATIONID

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

ENTITY

n/a

n/a

n/a

n/a

8

60

n/a

n/a

n/a

updated

LOCATIONDESCRIPTION

n/a

n/a

n/a

n/a

40

720

n/a

N

Y

updated

SHORTDESC

n/a

n/a

n/a

n/a

15

120

n/a

n/a

n/a

updated

COUNTRYID

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated: table: nameoptions

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

DEFAULTENTITY

n/a

n/a

n/a

n/a

8

60

n/a

n/a

n/a

updated

DEFAULTBILLINGENTITY

n/a

n/a

n/a

n/a

8

60

n/a

n/a

n/a

updated

DEFAULTLOCATION

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

DEFAULTDEPARTMENT

n/a

n/a

n/a

n/a

6

60

n/a

n/a

n/a

updated

DFLTBILLINGLOCATION

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated: table: nbi_dim_calendar_time

Index: updated

updated index: NBI_DIM_CALENDAR_TIME_N1

added column: DAY_KEY

added column: WEEK_KEY

added column: MONTH_KEY

added column: QUARTER_KEY

added column: YEAR_KEY

updated: table: nbi_fm_pt_facts

table: updated

Vendor-specific: oracle

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

ENTITY

n/a

n/a

n/a

n/a

8

60

n/a

n/a

n/a

updated

ENTITY_NAME

n/a

n/a

n/a

n/a

40

720

n/a

n/a

n/a

updated

LOCATION

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

LOCATION_NAME

n/a

n/a

n/a

n/a

40

720

n/a

n/a

n/a

updated

DEPARTMENT

n/a

n/a

n/a

n/a

6

60

n/a

n/a

n/a

updated

DEPARTMENT_NAME

n/a

n/a

n/a

n/a

40

720

n/a

n/a

n/a

table: updated

Vendor-specific: mssql

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

ENTITY

n/a

n/a

n/a

n/a

8

60

n/a

n/a

n/a

updated

ENTITY_NAME

n/a

n/a

n/a

n/a

40

720

n/a

n/a

n/a

updated

LOCATION

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

LOCATION_NAME

n/a

n/a

n/a

n/a

40

720

n/a

n/a

n/a

updated

DEPARTMENT

n/a

n/a

n/a

n/a

6

60

n/a

n/a

n/a

updated

DEPARTMENT_NAME

n/a

n/a

n/a

n/a

40

720

n/a

n/a

n/a

updated: table: nbi_project_current_facts

table: updated

Vendor-specific: oracle

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

ENTITY

n/a

n/a

n/a

n/a

8

60

n/a

n/a

n/a

updated

ENTITY_NAME

n/a

n/a

n/a

n/a

40

720

n/a

n/a

n/a

updated

LOCATION

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

LOCATION_NAME

n/a

n/a

n/a

n/a

40

720

n/a

n/a

n/a

updated

DEPARTMENT

n/a

n/a

n/a

n/a

6

60

n/a

n/a

n/a

updated

DEPARTMENT_NAME

n/a

n/a

n/a

n/a

40

720

n/a

n/a

n/a

table: updated

Vendor-specific: mssql

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

ENTITY

n/a

n/a

n/a

n/a

8

60

n/a

n/a

n/a

updated

ENTITY_NAME

n/a

n/a

n/a

n/a

40

720

n/a

n/a

n/a

updated

LOCATION

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

LOCATION_NAME

n/a

n/a

n/a

n/a

40

720

n/a

n/a

n/a

updated

DEPARTMENT

n/a

n/a

n/a

n/a

6

60

n/a

n/a

n/a

updated

DEPARTMENT_NAME

n/a

n/a

n/a

n/a

40

720

n/a

n/a

n/a

updated: table: nbi_project_forecast

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

PLAN_BY_2

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

updated: table: nbi_prt_facts

Index: updated

deleted index: NBI_PRT_FACTS_U1

added index: NBI_PRT_FACTS_U2

added column: PROJECT_ID

added column: TEAM_ID

added column: FACT_DATE

added column: TASK_ID

added index: NBI_PRT_FACTS_N4

added column: PROJECT_ID

added column: RESOURCE_ID

added column: FACT_DATE

added column: TASK_ID

table: updated

Vendor-specific: oracle

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

TEAM_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

N

table: updated

Vendor-specific: mssql

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

TEAM_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

N

updated: table: nbi_resource_current_facts

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

ENTITY

n/a

n/a

n/a

n/a

8

60

n/a

n/a

n/a

updated

ENTITY_NAME

n/a

n/a

n/a

n/a

40

720

n/a

n/a

n/a

updated

LOCATION

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

LOCATION_NAME

n/a

n/a

n/a

n/a

40

720

n/a

n/a

n/a

updated

DEPARTMENT

n/a

n/a

n/a

n/a

6

60

n/a

n/a

n/a

updated

DEPARTMENT_NAME

n/a

n/a

n/a

n/a

40

720

n/a

n/a

n/a

updated: table: nbi_rt_facts

table: updated

Vendor-specific: oracle

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

ENTITY

n/a

n/a

n/a

n/a

8

60

n/a

n/a

n/a

updated

ENTITY_NAME

n/a

n/a

n/a

n/a

40

720

n/a

n/a

n/a

updated

LOCATION

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

LOCATION_NAME

n/a

n/a

n/a

n/a

40

720

n/a

n/a

n/a

updated

DEPARTMENT

n/a

n/a

n/a

n/a

6

60

n/a

n/a

n/a

updated

DEPARTMENT_NAME

n/a

n/a

n/a

n/a

40

720

n/a

n/a

n/a

table: updated

Vendor-specific: mssql

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

ENTITY

n/a

n/a

n/a

n/a

8

60

n/a

n/a

n/a

updated

ENTITY_NAME

n/a

n/a

n/a

n/a

40

720

n/a

n/a

n/a

updated

LOCATION

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

LOCATION_NAME

n/a

n/a

n/a

n/a

40

720

n/a

n/a

n/a

updated

DEPARTMENT

n/a

n/a

n/a

n/a

6

60

n/a

n/a

n/a

updated

DEPARTMENT_NAME

n/a

n/a

n/a

n/a

40

720

n/a

n/a

n/a

updated: table: nms_messages

Index: updated

deleted index: NMS_MESSAGES_N2

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

MESSAGE

clob

clob

n/a

n/a

4000

unspecified

n/a

n/a

n/a

updated: table: nms_message_delivery

Index: updated

deleted index: NMS_MESSAGE_DELIVERY_N2

updated: table: odf_audited_attributes

Index: updated

updated index: ODF_AUDITED_ATTRIBUTES_N1

updated attribute: Unique from false to true

added column: ATTRIBUTE_CODE

added column: OPERATION_CODE

added index: ODF_AUDITED_ATTRIBUTES_N2

added column: AUDIT_ATTRIBUTE_TYPE

added index: ODF_AUDITED_ATTRIBUTES_N3

added column: IS_ACTIVE

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

OPERATION_CODE

n/a

varchar

n/a

U

n/a

1

n/a

n/a

N

added

AUDIT_ATTRIBUTE_TYPE

n/a

numeric

n/a

0

n/a

n/a

n/a

n/a

N

added

IS_ACTIVE

n/a

numeric

n/a

0

n/a

n/a

n/a

n/a

N

updated: table: odf_aud_obj_inst_context

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

OBJECT_INSTANCE_CODE

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated

OBJECT_INSTANCE_NAME

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated: table: odf_custom_attributes

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

SLICE_TABLE_INFIX

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

added

CALCULATION_EXPRESSION

n/a

text

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

AGGREGATION_TYPE

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

added

START_DATE_ATTRIBUTE

n/a

varchar

n/a

n/a

n/a

20

n/a

n/a

Y

added

FINISH_DATE_ATTRIBUTE

n/a

varchar

n/a

n/a

n/a

20

n/a

n/a

Y

added

IS_FISCAL_TSV

n/a

numeric

n/a

0

n/a

n/a

n/a

n/a

N

added

TSV_UNIT

n/a

varchar

n/a

none

n/a

30

n/a

n/a

N

updated: table: odf_multi_valued_lookups

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

CREATED_DATE

n/a

date

n/a

n/a

n/a

n/a

n/a

n/a

N

added

CREATED_BY

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_DATE

n/a

date

n/a

n/a

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_BY

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

N

updated: table: odf_objects

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

SOURCE

n/a

varchar

n/a

customer

n/a

80

n/a

n/a

N

added

IS_AUDIT_INSERT

n/a

numeric

n/a

0

n/a

n/a

n/a

n/a

N

added

IS_ABSTRACT

n/a

numeric

n/a

0

n/a

n/a

n/a

n/a

N

added

PURGE_AUDIT_DAYS_OLD

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

updated: table: pac_bil_item_details

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

TASK_NAME

n/a

n/a

n/a

n/a

192

450

n/a

n/a

n/a

updated: table: pac_mnt_projects

table: updated

Vendor-specific: oracle

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

ODF_OBJECT_CODE

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

added

IS_FINANCIALLY_ENABLED

n/a

boolean

n/a

0

n/a

n/a

n/a

n/a

Y

added

CREATED_DATE

n/a

date

n/a

SYSDATE

n/a

n/a

n/a

n/a

N

added

CREATED_BY

n/a

numeric

n/a

1

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_DATE

n/a

date

n/a

SYSDATE

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_BY

n/a

numeric

n/a

1

n/a

n/a

n/a

n/a

N

updated

LOCATIONID

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

DEPARTCODE

n/a

n/a

n/a

n/a

6

60

n/a

n/a

n/a

updated

TARGETEDSTARTDATE

n/a

n/a

unspecified

SYSDATE

n/a

n/a

n/a

N

Y

updated

STARTDATE

n/a

n/a

unspecified

SYSDATE

n/a

n/a

n/a

N

Y

updated

TARGETEDCOMPLDATE

n/a

n/a

unspecified

SYSDATE

n/a

n/a

n/a

N

Y

updated

TIMEINCREMENT

n/a

n/a

unspecified

0

n/a

n/a

n/a

n/a

n/a

updated

APPLYBILLING

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

BUDGET

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated

BURDEN

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

OVERHEAD

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

APPLYBLABOR

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

APPLYBMATERIALS

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

APPLYBEQUIPMENT

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

APPLYBEXPENSES

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

AWAITINGAPPROVAL

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

APPLYOLABOR

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

APPLYOMATERIALS

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

APPLYOEQUIPMENT

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

APPLYOEXPENSES

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

INPROGRESS

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

APPROVED

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

TRANSRATEOVERRIDEEXPENSES

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

BUDGETRATEOVERRIDELABOR

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

BUDGETRATEOVERRIDEMATERIALS

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

BUDGETRATEOVERRIDEEQUIPMENT

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

TRANSRATEOVERRIDELABOR

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

TRANSRATEOVERRIDEMATERIALS

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

TRANSRATEOVERRIDEEQUIPMENT

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

DEACTIVATEMILEAGE

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

DEACTIVATETRAVEL

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

HISTORYSUMMARY

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

RATEMATRIX

n/a

n/a

unspecified

1

n/a

n/a

n/a

N

Y

updated

COSTPLUS

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated

ALLOWCOSTCLASS

n/a

n/a

unspecified

0

n/a

n/a

n/a

n/a

n/a

updated

ALLOW_INDIRECT_APPROVERS

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

POC_METHOD

n/a

n/a

unspecified

0

n/a

n/a

n/a

n/a

n/a

updated

RESOURCE_SCHEDULING_INT

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

MASTER_PROJECT_CODE

n/a

n/a

n/a

n/a

20

23

n/a

n/a

n/a

table: updated

Vendor-specific: mssql

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

ODF_OBJECT_CODE

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

added

IS_FINANCIALLY_ENABLED

n/a

boolean

n/a

0

n/a

n/a

n/a

n/a

Y

added

CREATED_DATE

n/a

date

n/a

GETDATE()

n/a

n/a

n/a

n/a

N

added

CREATED_BY

n/a

numeric

n/a

1

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_DATE

n/a

date

n/a

GETDATE()

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_BY

n/a

numeric

n/a

1

n/a

n/a

n/a

n/a

N

updated

LOCATIONID

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

DEPARTCODE

n/a

n/a

n/a

n/a

6

60

n/a

n/a

n/a

updated

TARGETEDSTARTDATE

n/a

n/a

unspecified

GETDATE()

n/a

n/a

n/a

N

Y

updated

STARTDATE

n/a

n/a

unspecified

GETDATE()

n/a

n/a

n/a

N

Y

updated

TARGETEDCOMPLDATE

n/a

n/a

unspecified

GETDATE()

n/a

n/a

n/a

N

Y

updated

TIMEINCREMENT

n/a

n/a

unspecified

0

n/a

n/a

n/a

n/a

n/a

updated

APPLYBILLING

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

BUDGET

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated

BURDEN

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

OVERHEAD

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

APPLYBLABOR

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

APPLYBMATERIALS

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

APPLYBEQUIPMENT

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

APPLYBEXPENSES

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

AWAITINGAPPROVAL

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

APPLYOLABOR

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

APPLYOMATERIALS

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

APPLYOEQUIPMENT

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

APPLYOEXPENSES

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

INPROGRESS

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

APPROVED

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

TRANSRATEOVERRIDEEXPENSES

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

BUDGETRATEOVERRIDELABOR

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

BUDGETRATEOVERRIDEMATERIALS

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

BUDGETRATEOVERRIDEEQUIPMENT

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

TRANSRATEOVERRIDELABOR

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

TRANSRATEOVERRIDEMATERIALS

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

TRANSRATEOVERRIDEEQUIPMENT

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

DEACTIVATEMILEAGE

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

DEACTIVATETRAVEL

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

HISTORYSUMMARY

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

RATEMATRIX

n/a

n/a

unspecified

1

n/a

n/a

n/a

N

Y

updated

COSTPLUS

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated

ALLOWCOSTCLASS

n/a

n/a

unspecified

0

n/a

n/a

n/a

n/a

n/a

updated

ALLOW_INDIRECT_APPROVERS

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated

POC_METHOD

n/a

n/a

unspecified

0

n/a

n/a

n/a

n/a

n/a

updated

RESOURCE_SCHEDULING_INT

n/a

n/a

unspecified

0

n/a

n/a

n/a

N

Y

updated: table: pac_mnt_resources

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

deleted

COUNTYID

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

updated

LOCATIONID

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

DEPARTCODE

n/a

n/a

n/a

n/a

6

60

n/a

n/a

n/a

updated: table: pma_portfolios

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

BUDGET_TYPE

n/a

varchar

n/a

BUDGET_TYPE_TOTAL

n/a

30

n/a

n/a

N

added

CAPACITY_UNIT_TYPE

n/a

varchar

n/a

CAPACITY_UNIT_TYPE_HOURS

n/a

30

n/a

n/a

N

added

CAPACITY_TYPE

n/a

varchar

n/a

CAPACITY_TYPE_TOTAL

n/a

30

n/a

n/a

N

added

PORTFOLIO_INV_TYPE

n/a

varchar

n/a

all

n/a

30

n/a

n/a

N

added

DEPARTMENT_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

deleted

LAST_SYNC_PROJECT_DATE

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

deleted

LAST_SYNC_ASSET_DATE

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

deleted

LAST_SYNC_APPLICATION_DATE

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

deleted

LAST_SYNC_PRODUCT_DATE

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

deleted

LAST_SYNC_OTHER_DATE

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

updated: table: ppa_billingdetails

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

LOCATIONID

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

DEPARTCODE

n/a

n/a

n/a

n/a

6

60

n/a

n/a

n/a

updated

ENTITY

n/a

n/a

n/a

n/a

8

60

n/a

n/a

n/a

updated: table: ppa_billings

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

deleted

PROJSITE

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

updated

COMPANY_CODE

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated: table: ppa_locmatrixassignments

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

LOCATIONID

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated: table: ppa_taxadminlocwork

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

LOCATIONID

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated: table: ppa_transbill

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

deleted

PROJSITE

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

updated: table: ppa_transcontrol

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

USER_LOV1

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

added

USER_LOV2

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

added

EXPENSE_TYPE

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

deleted

PROJSITE

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

updated

LOCATIONID

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

DEPARTCODE

n/a

n/a

n/a

n/a

6

60

n/a

n/a

n/a

updated

ENTITY

n/a

n/a

n/a

n/a

8

60

n/a

n/a

n/a

updated

EMPLYHOMELOCATION

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

EMPLYHOMEDEPART

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

CLIENTCLASS

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated

PROJECTCLASS

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated

WIPCLASS

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated

COMPANY_CODE

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated

PROJECT_LOCATION

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

PROJECT_DEPARTMENT

n/a

n/a

n/a

n/a

6

60

n/a

n/a

n/a

updated: table: ppa_transwipadjust

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

USER_LOV1

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

added

USER_LOV2

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

added

EXPENSE_TYPE

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

deleted

PROJSITE

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

updated

LOCATIONID

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

DEPARTCODE

n/a

n/a

n/a

n/a

6

60

n/a

n/a

n/a

updated

ENTITY

n/a

n/a

n/a

n/a

8

60

n/a

n/a

n/a

updated

EMPLYHOMELOCATION

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

EMPLYHOMEDEPART

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

CLIENTCLASS

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated

PROJECTCLASS

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated

WIPCLASS

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated

COMPANY_CODE

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated: table: ppa_wip

Index: updated

added index: PPA_WIP_INVESTMENTID

added column: INVESTMENT_ID

added column: TRANSDATE

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

IN_ERROR

n/a

boolean

n/a

0

n/a

n/a

n/a

n/a

Y

added

INVESTMENT_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

USER_LOV1

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

added

USER_LOV2

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

added

EXPENSE_TYPE

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

added

ON_HOLD

n/a

boolean

n/a

0

n/a

n/a

n/a

n/a

Y

deleted

PROJSITE

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

updated

LOCATIONID

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

DEPARTCODE

n/a

n/a

n/a

n/a

6

60

n/a

n/a

n/a

updated

ENTITY

n/a

n/a

n/a

n/a

8

60

n/a

n/a

n/a

updated

EMPLYHOMELOCATION

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

EMPLYHOMEDEPART

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

CLIENTCLASS

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated

PROJECTCLASS

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated

WIPCLASS

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated

COMPANY_CODE

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated

PROJECT_LOCATION

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

PROJECT_DEPARTMENT

n/a

n/a

n/a

n/a

6

60

n/a

n/a

n/a

updated: table: ppa_wip_values

Index: updated

updated index: PPA_WIP_VALUES_U1

added column: AmountRemaining

updated: table: prassignment

Index: updated

deleted index: PRASSIGNMENT2

deleted index: PRASSIGNMENT3

deleted index: PRASSIGNMENT4

added index: PRASSIGNMENT_N3

added column: PRRESOURCEID

added column: PRTASKID

added index: PRASSIGNMENT_U1

added column: PRTASKID

added column: TEAM_ID

added index: PRASSIGNMENT_N4

added column: TEAM_ID

added column: PRID

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

TEAM_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

added

CREATED_DATE

n/a

date

n/a

n/a

n/a

n/a

n/a

n/a

N

added

CREATED_BY

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_DATE

n/a

date

n/a

n/a

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_BY

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

N

deleted

PRMODBY

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

deleted

PRMODTIME

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

updated: table: prconstraint

Index: updated

deleted index: PRCONSTRAINT_U2

updated: table: prj_baseline_details

Index: updated

updated index: PRJ_BASELINE_DETAILS_N1

added column: OBJECT_TYPE

added column: IS_CURRENT

added index: PRJ_BASELINE_DETAILS_N3

added column: BASELINE_ID

added column: OBJECT_TYPE

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

OBJECT_TYPE

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated: table: prj_blb_slicerequests

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

IS_TEMPLATE

n/a

numeric

n/a

0

n/a

n/a

n/a

n/a

N

added

IS_ACTIVE

n/a

boolean

n/a

1

n/a

n/a

n/a

n/a

N

added

IS_VISIBLE

n/a

boolean

n/a

1

n/a

n/a

n/a

n/a

N

updated: table: prj_blb_slices_d_act

Index: updated

deleted index: PRJ_BLB_SLICES_D_ACT_N1

added index: PRJ_BLB_SLICES_D_ACT_U2

added column: SLICE_DATE

added column: PRJ_OBJECT_ID

added column: SLICE_REQUEST_ID

added index: PRJ_BLB_SLICES_D_ACT_N2

added column: INVESTMENT_ID

added column: SLICE_DATE

added index: PRJ_BLB_SLICES_D_ACT_N3

added column: RESOURCE_ID

added column: SLICE_DATE

added index: PRJ_BLB_SLICES_D_ACT_N4

added column: ROLE_ID

added column: SLICE_DATE

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

INVESTMENT_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

added

RESOURCE_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

added

ROLE_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

updated: table: prj_blb_slices_d_alc

Index: updated

deleted index: PRJ_BLB_SLICES_D_ALC_N1

added index: PRJ_BLB_SLICES_D_ALC_U2

added column: SLICE_DATE

added column: PRJ_OBJECT_ID

added column: SLICE_REQUEST_ID

added index: PRJ_BLB_SLICES_D_ALC_N2

added column: INVESTMENT_ID

added column: SLICE_DATE

added index: PRJ_BLB_SLICES_D_ALC_N3

added column: RESOURCE_ID

added column: SLICE_DATE

added index: PRJ_BLB_SLICES_D_ALC_N4

added column: ROLE_ID

added column: SLICE_DATE

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

INVESTMENT_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

added

RESOURCE_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

added

ROLE_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

updated: table: prj_blb_slices_d_avl

Index: updated

deleted index: PRJ_BLB_SLICES_D_AVL_N1

added index: PRJ_BLB_SLICES_D_AVL_U2

added column: SLICE_DATE

added column: PRJ_OBJECT_ID

added column: SLICE_REQUEST_ID

updated: table: prj_blb_slices_d_etc

Index: updated

deleted index: PRJ_BLB_SLICES_D_ETC_N1

added index: PRJ_BLB_SLICES_D_ETC_U2

added column: SLICE_DATE

added column: PRJ_OBJECT_ID

added column: SLICE_REQUEST_ID

added index: PRJ_BLB_SLICES_D_ETC_N2

added column: INVESTMENT_ID

added column: SLICE_DATE

added index: PRJ_BLB_SLICES_D_ETC_N3

added column: RESOURCE_ID

added column: SLICE_DATE

added index: PRJ_BLB_SLICES_D_ETC_N4

added column: ROLE_ID

added column: SLICE_DATE

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

INVESTMENT_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

added

RESOURCE_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

added

ROLE_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

updated: table: prj_blb_slices_d_hardalc

Index: updated

added index: PRJ_BLB_SLICES_D_HARDALC_N2

added column: INVESTMENT_ID

added column: SLICE_DATE

added index: PRJ_BLB_SLICES_D_HARDALC_N3

added column: RESOURCE_ID

added column: SLICE_DATE

added index: PRJ_BLB_SLICES_D_HARDALC_N4

added column: ROLE_ID

added column: SLICE_DATE

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

INVESTMENT_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

added

RESOURCE_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

added

ROLE_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

updated: table: prj_blb_slices_m_act

Index: updated

deleted index: PRJ_BLB_SLICES_M_ACT_N1

added index: PRJ_BLB_SLICES_M_ACT_U2

added column: SLICE_DATE

added column: PRJ_OBJECT_ID

added column: SLICE_REQUEST_ID

added index: PRJ_BLB_SLICES_M_ACT_N2

added column: INVESTMENT_ID

added column: SLICE_DATE

added index: PRJ_BLB_SLICES_M_ACT_N3

added column: RESOURCE_ID

added column: SLICE_DATE

added index: PRJ_BLB_SLICES_M_ACT_N4

added column: ROLE_ID

added column: SLICE_DATE

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

INVESTMENT_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

added

RESOURCE_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

added

ROLE_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

updated: table: prj_blb_slices_m_alc

Index: updated

deleted index: PRJ_BLB_SLICES_M_ALC_N1

added index: PRJ_BLB_SLICES_M_ALC_U2

added column: SLICE_DATE

added column: PRJ_OBJECT_ID

added column: SLICE_REQUEST_ID

added index: PRJ_BLB_SLICES_M_ALC_N2

added column: INVESTMENT_ID

added column: SLICE_DATE

added index: PRJ_BLB_SLICES_M_ALC_N3

added column: RESOURCE_ID

added column: SLICE_DATE

added index: PRJ_BLB_SLICES_M_ALC_N4

added column: ROLE_ID

added column: SLICE_DATE

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

INVESTMENT_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

added

RESOURCE_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

added

ROLE_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

updated: table: prj_blb_slices_m_avl

Index: updated

deleted index: PRJ_BLB_SLICES_M_AVL_N1

added index: PRJ_BLB_SLICES_M_AVL_U2

added column: SLICE_DATE

added column: PRJ_OBJECT_ID

added column: SLICE_REQUEST_ID

updated: table: prj_blb_slices_m_etc

Index: updated

deleted index: PRJ_BLB_SLICES_M_ETC_N1

added index: PRJ_BLB_SLICES_M_ETC_U2

added column: SLICE_DATE

added column: PRJ_OBJECT_ID

added column: SLICE_REQUEST_ID

added index: PRJ_BLB_SLICES_M_ETC_N2

added column: INVESTMENT_ID

added column: SLICE_DATE

added index: PRJ_BLB_SLICES_M_ETC_N3

added column: RESOURCE_ID

added column: SLICE_DATE

added index: PRJ_BLB_SLICES_M_ETC_N4

added column: ROLE_ID

added column: SLICE_DATE

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

INVESTMENT_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

added

RESOURCE_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

added

ROLE_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

updated: table: prj_blb_slices_m_hardalc

Index: updated

added index: PRJ_BLB_SLICES_M_HARDALC_N2

added column: INVESTMENT_ID

added column: SLICE_DATE

added index: PRJ_BLB_SLICES_M_HARDALC_N3

added column: RESOURCE_ID

added column: SLICE_DATE

added index: PRJ_BLB_SLICES_M_HARDALC_N4

added column: ROLE_ID

added column: SLICE_DATE

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

INVESTMENT_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

added

RESOURCE_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

added

ROLE_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

updated: table: prj_blb_slices_w_act

Index: updated

deleted index: PRJ_BLB_SLICES_W_ACT_N1

added index: PRJ_BLB_SLICES_W_ACT_U2

added column: SLICE_DATE

added column: PRJ_OBJECT_ID

added column: SLICE_REQUEST_ID

added index: PRJ_BLB_SLICES_W_ACT_N2

added column: INVESTMENT_ID

added column: SLICE_DATE

added index: PRJ_BLB_SLICES_W_ACT_N3

added column: RESOURCE_ID

added column: SLICE_DATE

added index: PRJ_BLB_SLICES_W_ACT_N4

added column: ROLE_ID

added column: SLICE_DATE

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

INVESTMENT_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

added

RESOURCE_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

added

ROLE_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

updated: table: prj_blb_slices_w_alc

Index: updated

deleted index: PRJ_BLB_SLICES_W_ALC_N1

added index: PRJ_BLB_SLICES_W_ALC_U2

added column: SLICE_DATE

added column: PRJ_OBJECT_ID

added column: SLICE_REQUEST_ID

added index: PRJ_BLB_SLICES_W_ALC_N2

added column: INVESTMENT_ID

added column: SLICE_DATE

added index: PRJ_BLB_SLICES_W_ALC_N3

added column: RESOURCE_ID

added column: SLICE_DATE

added index: PRJ_BLB_SLICES_W_ALC_N4

added column: ROLE_ID

added column: SLICE_DATE

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

INVESTMENT_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

added

RESOURCE_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

added

ROLE_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

updated: table: prj_blb_slices_w_avl

Index: updated

deleted index: PRJ_BLB_SLICES_W_AVL_N1

added index: PRJ_BLB_SLICES_W_AVL_U2

added column: SLICE_DATE

added column: PRJ_OBJECT_ID

added column: SLICE_REQUEST_ID

updated: table: prj_blb_slices_w_etc

Index: updated

deleted index: PRJ_BLB_SLICES_W_ETC_N1

added index: PRJ_BLB_SLICES_W_ETC_U2

added column: SLICE_DATE

added column: PRJ_OBJECT_ID

added column: SLICE_REQUEST_ID

added index: PRJ_BLB_SLICES_W_ETC_N2

added column: INVESTMENT_ID

added column: SLICE_DATE

added index: PRJ_BLB_SLICES_W_ETC_N3

added column: RESOURCE_ID

added column: SLICE_DATE

added index: PRJ_BLB_SLICES_W_ETC_N4

added column: ROLE_ID

added column: SLICE_DATE

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

INVESTMENT_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

added

RESOURCE_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

added

ROLE_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

updated: table: prj_blb_slices_w_hardalc

Index: updated

added index: PRJ_BLB_SLICES_W_HARDALC_N2

added column: INVESTMENT_ID

added column: SLICE_DATE

added index: PRJ_BLB_SLICES_W_HARDALC_N3

added column: RESOURCE_ID

added column: SLICE_DATE

added index: PRJ_BLB_SLICES_W_HARDALC_N4

added column: ROLE_ID

added column: SLICE_DATE

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

INVESTMENT_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

added

RESOURCE_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

added

ROLE_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

updated: table: prj_projects

Index: updated

updated index: PRJ_PROJECTS_U1

deleted column: MANAGER_ID

table: deleted

updated: table: prj_resources

Index: updated

added index: PRJ_RESOURCES_U2

added column: PRPRIMARYROLEID

added column: PRID

added index: PRJ_RESOURCES_N3

added column: PRID

added column: PRISROLE

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

CREATED_DATE

n/a

date

n/a

n/a

n/a

n/a

n/a

n/a

N

added

CREATED_BY

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_DATE

n/a

date

n/a

n/a

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_BY

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

N

deleted

PRMODBY

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

deleted

PRMODTIME

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

updated: table: projcntrts

Index: updated

added index: PROJCNTRTS_U1

added column: ID

added index: PROJCNTRTS_N1

added column: PROJECT_CODE

table: updated

Vendor-specific: oracle

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

N

added

CREATED_DATE

n/a

date

n/a

SYSDATE

n/a

n/a

n/a

n/a

N

added

CREATED_BY

n/a

numeric

n/a

1

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_DATE

n/a

date

n/a

SYSDATE

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_BY

n/a

numeric

n/a

1

n/a

n/a

n/a

n/a

N

table: updated

Vendor-specific: mssql

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

N

added

CREATED_DATE

n/a

date

n/a

GETDATE()

n/a

n/a

n/a

n/a

N

added

CREATED_BY

n/a

numeric

n/a

1

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_DATE

n/a

date

n/a

GETDATE()

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_BY

n/a

numeric

n/a

1

n/a

n/a

n/a

n/a

N

updated: table: projrevision

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

CURRENTTARGETEDSTARTDATE

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated

CURRENTTARGETEDCOMPLDATE

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated: table: prtask

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

CREATED_DATE

n/a

date

n/a

n/a

n/a

n/a

n/a

n/a

N

added

CREATED_BY

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_DATE

n/a

date

n/a

n/a

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_BY

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

N

deleted

PRMODBY

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

deleted

PRMODTIME

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

updated: table: prteam

Index: updated

deleted index: PRTEAM2

updated index: PRTEAM_N1

added column: PRRESOURCEID

added column: PRID

updated index: PRTEAM_N2

added column: PRPROJECTID

added column: PRID

updated index: PRTEAM_N7

deleted column: HARD_SLICE_STATUS

added column: PRROLEID

added column: PRID

added index: PRTEAM_N6

added column: PRPROJECTID

added column: TEAM_UID

added column: PRID

added index: PRTEAM_N8

added column: PRID

added column: PRPROJECTID

added column: PRRESOURCEID

added column: PRROLEID

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

REQUIREMENT_NAME

n/a

varchar

n/a

n/a

n/a

96

n/a

n/a

Y

added

TEAM_UID

n/a

varchar

n/a

n/a

n/a

120

n/a

n/a

Y

added

INCIDENT_ACT_SUM

n/a

float

n/a

n/a

n/a

126

n/a

n/a

Y

added

INCIDENT_ACT_CURVE

n/a

tsv

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

INCIDENT_SLICE_STATUS

n/a

numeric

n/a

n/a

n/a

5

n/a

n/a

Y

added

RSF_OBSUNIT_ID

n/a

numeric

n/a

n/a

n/a

10

n/a

n/a

Y

added

RSF_PERSON_TYPE

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

RSF_RESUME_KEYWORDS

n/a

varchar

n/a

n/a

n/a

96

n/a

n/a

Y

added

CREATED_DATE

n/a

date

n/a

n/a

n/a

n/a

n/a

n/a

N

added

CREATED_BY

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_DATE

n/a

date

n/a

n/a

n/a

n/a

n/a

n/a

N

added

LAST_UPDATED_BY

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

N

deleted

PRMODBY

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

deleted

PRMODTIME

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

updated

HARD_CURVE

tsv

tsv

n/a

n/a

n/a

n/a

n/a

n/a

n/a

updated: table: rsm_req_requisitions

Index: added

added index: RSM_REQ_REQUISITIONS_N5A

added column: NLS_UPPER( NAME )

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

REQUIREMENT_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

BOOK_MANAGER_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

REQUESTED_BY

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

REQUEST_CURVE

n/a

tsv

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

REQUEST_START

n/a

date

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

REQUEST_FINISH

n/a

date

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

REQUEST_AVGRATE

n/a

float

n/a

n/a

n/a

126

n/a

n/a

Y

added

SLICE_STATUS

n/a

numeric

n/a

n/a

n/a

5

n/a

n/a

Y

added

IS_UNBOOK

n/a

numeric

n/a

0

n/a

5

n/a

n/a

N

added

IS_REPLACE

n/a

numeric

n/a

0

n/a

5

n/a

n/a

N

updated

NAME

n/a

n/a

n/a

n/a

128

300

n/a

n/a

n/a

updated: table: rsm_skills_associations

Index: updated

updated index: RSM_SKILLS_ASSOCIATIONS_U1

deleted column: RES_ID

added column: OBJECT_ID

added column: OBJECT_CODE

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

OBJECT_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

OBJECT_CODE

n/a

varchar

n/a

n/a

n/a

23

n/a

n/a

Y

added

WEIGHT

n/a

numeric

n/a

1

n/a

n/a

n/a

n/a

N

deleted

RES_ID

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

updated: table: srm_contacts

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

deleted

COUNTY

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

updated: table: srm_projects

table: deleted

updated: table: srm_resources

Index: updated

added index: SRM_RESOURCES_N5

added column: ID

added column: RESOURCE_TYPE

added column: IS_ACTIVE

added index: SRM_RESOURCES_N6

added column: FULL_NAME

added index: SRM_RESOURCES_N7

added column: PERSON_TYPE

Index: updated

added index: SRM_RESOURCES_N2A

added column: LAST_NAME

added index: SRM_RESOURCES_N6A

added column: NLS_UPPER( FULL_NAME )

added index: SRM_RESOURCES_U1A

added column: NLS_UPPER( UNIQUE_NAME )

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

BOOK_MANAGER_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

Y

added

ENTITY_CODE

n/a

varchar

n/a

n/a

n/a

60

n/a

n/a

Y

updated: table: taxcode

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

ENTITY

n/a

n/a

n/a

n/a

8

60

n/a

n/a

n/a

updated: table: tax_authority

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

deleted

COUNTYID

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

updated: table: tax_method

table: updated

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

ENTITY

n/a

n/a

n/a

n/a

8

60

n/a

n/a

n/a

updated: table: temp_bill_item_details

table: updated

Vendor-specific: oracle

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

TASK_NAME

n/a

n/a

n/a

n/a

192

450

n/a

n/a

n/a

table: updated

Vendor-specific: mssql

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

TASK_NAME

n/a

n/a

n/a

n/a

192

450

n/a

n/a

n/a

updated: table: temp_bil_credit_memo_batch

table: updated

Vendor-specific: oracle

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

deleted

PROJSITE

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

table: updated

Vendor-specific: mssql

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

deleted

PROJSITE

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

updated: table: temp_bil_credit_memo_generate

table: updated

Vendor-specific: oracle

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

deleted

PROJSITE

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

updated: table: temp_imp_validate_transimport

table: updated

Vendor-specific: oracle

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

USER_LOV1

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

added

USER_LOV2

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

added

EXPENSE_TYPE

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

deleted

PROJSITE

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

updated

LOCATIONID

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

DEPARTCODE

n/a

n/a

n/a

n/a

6

60

n/a

n/a

n/a

updated

ENTITY

n/a

n/a

n/a

n/a

8

60

n/a

n/a

n/a

updated

EMPLYHOMELOCATION

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

EMPLYHOMEDEPART

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

CLIENTCLASS

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated

PROJECTCLASS

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated

WIPCLASS

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated

COMPANY_CODE

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated

PROJECT_LOCATION

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

PROJECT_DEPARTMENT

n/a

n/a

n/a

n/a

6

60

n/a

n/a

n/a

table: updated

Vendor-specific: mssql

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

USER_LOV1

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

added

USER_LOV2

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

added

EXPENSE_TYPE

n/a

varchar

n/a

n/a

n/a

30

n/a

n/a

Y

deleted

PROJSITE

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

updated

LOCATIONID

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

DEPARTCODE

n/a

n/a

n/a

n/a

6

60

n/a

n/a

n/a

updated

ENTITY

n/a

n/a

n/a

n/a

8

60

n/a

n/a

n/a

updated

EMPLYHOMELOCATION

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

EMPLYHOMEDEPART

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

CLIENTCLASS

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated

PROJECTCLASS

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated

WIPCLASS

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated

COMPANY_CODE

n/a

n/a

n/a

n/a

n/a

n/a

n/a

N

Y

updated

PROJECT_LOCATION

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated

PROJECT_DEPARTMENT

n/a

n/a

n/a

n/a

6

60

n/a

n/a

n/a

updated: table: temp_nbi_prt_facts

Index: updated

updated index: TEMP_NBI_PRT_FACTS_N1

deleted column: RESOURCE_ID

added column: TEAM_ID

table: updated

Vendor-specific: oracle

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

added

TEAM_ID

n/a

numeric

n/a

n/a

n/a

n/a

n/a

n/a

N

updated: table: temp_tempbb_hsgenheaders

table: updated

Vendor-specific: oracle

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

REMITLOCATION

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated: table: temp_tempgld_getdistributionde

table: updated

Vendor-specific: oracle

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

ENTITY

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

table: updated

Vendor-specific: mssql

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

updated

ENTITY

n/a

n/a

n/a

n/a

10

60

n/a

n/a

n/a

updated: table: temp_temptranswipadjrev_prc_ad

table: updated

Vendor-specific: oracle

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

deleted

PROJSITE

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

table: updated

Vendor-specific: mssql

Event

Column Name

Previous Data Type

Current Data Type

Previous Default

Current Default

Previous Length

Current Length

Precision

Previous Nullable

Current Nullable

deleted

PROJSITE

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

n/a

deleted: package: ppa_matrixlookupvaluepkg

deleted: package: ppa_matrixvalidatevaluepkg

deleted: package: rev_prc_sp_getprojsitepkg

deleted: packagebody: ppa_matrixlookupvaluepkg

deleted: packagebody: ppa_matrixvalidatevaluepkg

deleted: procedure: cal_ai_delete_assignees_sp

deleted: procedure: cal_ai_delete_recurring_split_sp

deleted: procedure: cal_ai_update_action_item_sp

deleted: procedure: cal_ai_update_action_item_to_split_sp

deleted: procedure: cal_ai_update_assignees_sp

deleted: procedure: pac_mnt_insert_projsite_sp

deleted: procedure: pac_mnt_project_inherit_sp

deleted: procedure: pac_mnt_update_projsite_sp

deleted: procedure: ppa_matrixlookupvalue

deleted: procedure: prj_reset_unit_depth_sp

deleted: procedure: rev_prc_sp_getprojsite

deleted: procedure: sp_getadjgrpnbrnumber02

deleted: sequence: bpm_em_events_s1

deleted: sequence: cap_filters_s1

deleted: sequence: cap_list_selections_s1

deleted: sequence: cap_views_s1

deleted: sequence: cap_view_columns_s1

deleted: sequence: pma_ideas_s1

deleted: table: adjgrpnbr

deleted: table: billingschedule_values

deleted: table: bpm_em_events

deleted: table: cap_filters

deleted: table: cap_list_selections

deleted: table: cap_views

deleted: table: cap_view_columns

deleted: table: client_sites

deleted: table: cmn_fragments

deleted: table: cmn_per_user_fragments

deleted: table: cmn_sch_logs

deleted: table: cmn_sec_obs_level_assocs

deleted: table: emphistory

deleted: table: niku_cal_event

deleted: table: niku_cal_invitee

deleted: table: niku_cal_sched_event

deleted: table: pac_tande_bkgd_conf

deleted: table: pma_ideas

deleted: table: ppa_activity

deleted: table: ppa_posting_errors

deleted: table: project_inheritance

deleted: table: project_locations

deleted: table: projsiteinfo

deleted: table: sites

deleted: table: tax_interface

deleted: table: temp_blob

deleted: table: wippost_exclude_employee

deleted: trigger: pac_mnt_resources_t1

deleted: trigger: pac_mnt_resources_t2

deleted: trigger: tr_departments_delete

deleted: trigger: tr_locationid_delete

deleted: trigger: tr_project_inheritance_delete

deleted: trigger: tr_sites_delete

deleted: view: prj_project_effort_hpd_v

deleted: view: prj_project_effort_v

added: function: cmn_db_version

added: function: cmn_sec_check_inst_right_fct

added: function: dpt_is_consumer_dept_fct

added: function: dpt_is_provider_dept_fct

added: function: inv_traverse_to_bottom_fct

added: function: inv_traverse_to_top_fct

added: function: odf_aud_date_fct

added: function: odf_aud_static_lov_fct

added: function: odf_aud_value_fct

added: function: pma_calc_present_value

added: function: pma_calc_pv_cost_for_inv

added: function: pma_trunc_month_fct

added: function: prj_alloc_discrepancy_fct

added: procedure: cap_add_member_slices_sp

added: procedure: cap_add_member_sp

added: procedure: cap_add_member_supp_sp

added: procedure: cap_copy_member_slices_sp

added: procedure: cap_copy_scenario_supp_sp

added: procedure: cap_delete_member_slices_sp

added: procedure: cap_delete_scenario_member_sp

added: procedure: cap_delete_scenario_sp

added: procedure: cap_delete_scenario_supp_sp

added: procedure: cbk_preview_reversals_sp

added: procedure: cbk_reverse_txns_sp

added: procedure: clb_validate_file_perms_sp

added: procedure: cmn_autonum_setup_sp

added: procedure: cmn_copy_autonum_segments_sp

added: procedure: cmn_dblocks_sp

added: procedure: cmn_nde_page_portlet_ins_sp

added: procedure: dpt_upd_matrix_new_department

added: procedure: dpt_upgrade_fin_object_assocs

added: procedure: dpt_upgrade_new_dept_assoc

added: procedure: inv_hiers_flat_insert

added: procedure: odf_view_copy_sp

added: procedure: prj_blb_slice_reset_all_sp

added: relationship: lookups_relationship

added: sequence: cap_scenario_assignments_s1

added: sequence: cap_scenario_roles_s1

added: sequence: cap_scenario_tasks_s1

added: sequence: cap_scenario_team_s1

added: sequence: cbk_gl_account_s1

added: sequence: cbk_gl_allocation_detail_s1

added: sequence: cbk_gl_allocation_s1

added: sequence: cbk_gl_txns_s1

added: sequence: cbk_gl_txn_values_s1

added: sequence: cbk_scaled_gl_txns_s1

added: sequence: cmn_audits_tsv_s1

added: sequence: cmn_autonum_scheme_segments_s1

added: sequence: cmn_filters_s1

added: sequence: cmn_filter_fields_s1

added: sequence: cmn_filter_field_instances_s1

added: sequence: cmn_lookup_parameters_s1

added: sequence: cmn_performance_records_s1

added: sequence: cmn_performance_sessions_s1

added: sequence: cmn_perf_records_s1

added: sequence: cmn_perf_service_sessions_s1

added: sequence: cmn_perf_sessions_s1

added: sequence: dpt_subscriptions_s1

added: sequence: fin_benefit_plan_details_s1

added: sequence: fin_commitments_inv_assoc_s1

added: sequence: fin_commitments_s1

added: sequence: fin_cost_plan_details_s1

added: sequence: fin_depreciation_s1

added: sequence: fin_financials_s1

added: sequence: fin_plans_s1

added: sequence: fin_plan_defaults_s1

added: sequence: fin_plan_default_details_s1

added: sequence: fin_plan_detail_gl_assoc_s1

added: sequence: fin_sliced_txns_s1

added: sequence: fin_sliced_txn_values_s1

added: sequence: inv_alloc_flat_staging_s1

added: sequence: inv_applications_s1

added: sequence: inv_assets_s1

added: sequence: inv_flat_hierarchies_s1

added: sequence: inv_hierarchies_s1

added: sequence: inv_investments_s1

added: sequence: inv_investment_allocs_flat_s1

added: sequence: inv_others_s1

added: sequence: inv_products_s1

added: sequence: inv_projects_s1

added: sequence: inv_role_demand_staging_s1

added: sequence: odf_aud_lookup_captions_s1

added: sequence: odf_aud_multi_val_lovs_s1

added: sequence: odf_aud_obj_inst_context_s1

added: sequence: odf_aud_obj_inst_mappings_s1

added: sequence: odf_lookup_parameters_s1

added: sequence: pma_aggr_keys_s1

added: sequence: pma_aggr_values_s1

added: sequence: pma_portfolio_roles_s1

added: sequence: pma_prtflio_incl_ctnt_types_s1

added: sequence: rsm_book_manager_obs_map_s1

added: sequence: rsm_req_resources_s1

added: sequence: temp_pf_sel_investments_s1

added: table: bgt_inv_missing_entity

added: table: cap_scenario_assignments

added: table: cap_scenario_roles

added: table: cap_scenario_tasks

added: table: cap_scenario_team

added: table: cbk_errors

added: table: cbk_error_args

added: table: cbk_gl_account

added: table: cbk_gl_allocation

added: table: cbk_gl_allocation_detail

added: table: cbk_gl_txns

added: table: cbk_gl_txn_values

added: table: cbk_invoice

added: table: cbk_preview_reversals

added: table: cbk_scaled_gl_txns

added: table: cmn_audits_tsv

added: table: cmn_filters

added: table: cmn_filter_fields

added: table: cmn_filter_field_instances

added: table: cmn_lookup_parameters

added: table: cmn_perf_records

added: table: cmn_perf_service_sessions

added: table: cmn_perf_sessions

added: table: dpt_keymetrics

added: table: dpt_subscriptions

added: table: dpt_unassoc_departments

added: table: dpt_unresolved_dept

added: table: fin_benefit_plan_details

added: table: fin_commitments

added: table: fin_commitments_inv_assoc

added: table: fin_cost_plan_details

added: table: fin_depreciation

added: table: fin_financials

added: table: fin_plans

added: table: fin_plan_defaults

added: table: fin_plan_default_details

added: table: fin_plan_detail_gl_assoc

added: table: fin_sliced_txns

added: table: fin_sliced_txn_values

added: table: inv_alloc_flat_excluded

added: table: inv_alloc_flat_included

added: table: inv_alloc_flat_staging

added: table: inv_applications

added: table: inv_assets

added: table: inv_flat_hierarchies

added: table: inv_hierarchies

added: table: inv_ideas

added: table: inv_investments

added: table: inv_investment_allocs_flat

added: table: inv_investment_paths

added: table: inv_others

added: table: inv_products

added: table: inv_projects

added: table: inv_role_demand_staging

added: table: inv_services

added: table: nbi_proj_res_rates_and_costscp

added: table: odf_attribute_autonumbering

added: table: odf_aud_lookup_captions

added: table: odf_aud_multi_val_lovs

added: table: odf_aud_obj_inst_mappings

added: table: odf_ca_inv

added: table: odf_lookup_parameters

added: table: odf_object_building_blocks

added: table: odf_object_extensions

added: table: odf_object_instance_mapping

added: table: odf_sl_oplact_d

added: table: odf_sl_oplact_m

added: table: odf_sl_oplact_w

added: table: odf_sl_oplbase_d

added: table: odf_sl_oplbase_m

added: table: odf_sl_oplbase_w

added: table: odf_sl_opleac_d

added: table: odf_sl_opleac_m

added: table: odf_sl_opleac_w

added: table: odf_sl_opletc_d

added: table: odf_sl_opletc_m

added: table: odf_sl_opletc_w

added: table: odf_sl_oplvar_d

added: table: odf_sl_oplvar_m

added: table: odf_sl_oplvar_w

added: table: odf_sl_plan_benefit_d

added: table: odf_sl_plan_benefit_m

added: table: odf_sl_plan_benefit_w

added: table: odf_sl_plan_cost_d

added: table: odf_sl_plan_cost_m

added: table: odf_sl_plan_cost_w

added: table: omp_codef

added: table: pma_aggr_keys

added: table: pma_aggr_values

added: table: pma_aggr_values_validity

added: table: pma_portfolio_roles

added: table: pma_prtflio_incl_ctnt_types

added: table: ppa_matrixvalues_backup

added: table: prj_blb_slices_d_cap_alc

added: table: prj_blb_slices_d_cap_etc

added: table: prj_blb_slices_d_cap_hardalc

added: table: prj_blb_slices_d_inci_act

added: table: prj_blb_slices_d_reqcrv

added: table: prj_blb_slices_m_cap_alc

added: table: prj_blb_slices_m_cap_etc

added: table: prj_blb_slices_m_cap_hardalc

added: table: prj_blb_slices_m_inci_act

added: table: prj_blb_slices_m_reqcrv

added: table: prj_blb_slices_w_cap_alc

added: table: prj_blb_slices_w_cap_etc

added: table: prj_blb_slices_w_cap_hardalc

added: table: prj_blb_slices_w_inci_act

added: table: prj_blb_slices_w_reqcrv

added: table: rsm_book_manager_obs_map

added: table: rsm_req_resources

added: table: temp_capscenariomembers

added: table: temp_pf_sel_investments

added: trigger: cap_scenario_members_iud_trg1

added: trigger: cap_scenario_members_u_trg2

added: trigger: fin_financials_u_trg1

added: trigger: inv_hierarchies_iud_trg1

added: trigger: inv_investments_u_trg1

added: trigger: pma_portfolios_u_trg1

added: trigger: prj_tentative_assignments_t1

added: view: bpm_def_step_actions_v

added: view: cmn_sec_chk_inst_v

added: view: cmn_sec_chk_inst_v0

added: view: cmn_sec_chk_no_user_inst_v

added: view: cmn_sec_chk_no_user_inst_v0

added: view: cmn_sec_chk_user_glb_r_v0

added: view: cmn_sec_chk_user_r_v

added: view: cmn_sec_user_inst_privileges_v

added: view: inv_investment_effort_hpd_v

added: view: inv_investment_effort_v

added: view: inv_obs_ancestor_v

added: view: inv_obs_descendant_v

added: view: inv_obs_only_v

added: view: prj_projects

added: view: rsm_rsf_skills_temp_v

added: view: srm_projects

added: view: user_lov1_all_v

added: table: plan_table