Clarity logo

Database Schema Changes from Clarity 7.5.1 to 7.5.2

added: procedure: clb_cpy_participants_parnt_77655_sp

added: sequence: prj_tentative_assignments_s1

added: sequence: prj_tentative_projects_s1

added: sequence: prj_tentative_schedules_s1

added: sequence: prj_tentative_tasks_s1

added: table: cmn_sec_right

added: table: odf_aud_obj_inst_context

added: table: prj_blb_slices_d_tent_etc

added: table: prj_blb_slices_m_tent_etc

added: table: prj_blb_slices_w_tent_etc

added: table: prj_export

added: table: prj_tentative_assignments

added: table: prj_tentative_projects

added: table: prj_tentative_schedules

added: table: prj_tentative_tasks

added: trigger: cmn_sec_assgnd_obj_perm_t1

added: trigger: cmn_sec_assgnd_obj_perm_t3

added: trigger: cmn_sec_groups_t3

added: view: cmn_lic_count_v

added: view: cmn_lic_right_v

added: view: cmn_lic_users_v

added: view: cmn_sec_chk_user_inst_v

added: view: cmn_sec_chk_user_v

added: view: cmn_sec_obs_users_v

added: view: obs_unit_entities_v2

added: view: prj_hours_per_day

added: view: prj_project_effort_hpd_v

added: view: prj_project_effort_v

deleted: procedure: rev_admin_applyudb

deleted: table: budgetheader

deleted: table: budget_admincharges

updated: table: biz_com_sup_properties

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

IS_ACTIVE

n/a

n/a

n/a

n/a

n/a

updated: table: bpm_run_step_action_results

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Index

BPM_RUN_STEP_ACTION_RESULTS_N3

n/a

n/a

n/a

n/a

n/a

updated: table: bpm_run_step_cond_results

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

BOUND_CONDITION2

varchar

n/a

n/a

n/a

Y

deleted

Column

BOUND_CONDITION

n/a

n/a

n/a

n/a

n/a

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

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: cal_action_item_assignees

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

CAL_AI_ASSIGNEES_N3

n/a

n/a

n/a

n/a

n/a

deleted

Index

CAL_AI_ASSIGNEES_N5

n/a

n/a

n/a

n/a

n/a

deleted

Index

CAL_AI_ASSIGNEES_N6

n/a

n/a

n/a

n/a

n/a

updated: table: clb_dms_file_store

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

ID

n/a

n/a

n/a

n/a

n/a

deleted

Column

CREATED_DATE

n/a

n/a

n/a

n/a

n/a

deleted

Column

CREATED_BY

n/a

n/a

n/a

n/a

n/a

deleted

Column

LAST_UPDATED_DATE

n/a

n/a

n/a

n/a

n/a

deleted

Column

LAST_UPDATED_BY

n/a

n/a

n/a

n/a

n/a

updated: table: cmn_attribute_values

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

ATTRIBUTE_LARGE_VALUE

text

n/a

n/a

n/a

Y

updated: table: cmn_lov_flat_hiers

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

ID

n/a

n/a

n/a

n/a

n/a

updated: table: cmn_sec_acl_definition

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

CONDITION_ID

n/a

n/a

n/a

n/a

n/a

updated: table: cmn_sec_conditions

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

ID

n/a

n/a

n/a

n/a

n/a

deleted

Column

POLICY_ID_1

n/a

n/a

n/a

n/a

n/a

deleted

Column

POLICY_ID_2

n/a

n/a

n/a

n/a

n/a

deleted

Column

POLICY_ID_3

n/a

n/a

n/a

n/a

n/a

deleted

Column

POLICY_ID_4

n/a

n/a

n/a

n/a

n/a

deleted

Column

POLICY_ID_5

n/a

n/a

n/a

n/a

n/a

deleted

Column

CONDITION_ID_1

n/a

n/a

n/a

n/a

n/a

deleted

Column

CONDITION_ID_2

n/a

n/a

n/a

n/a

n/a

deleted

Column

CONDITION_ID_3

n/a

n/a

n/a

n/a

n/a

deleted

Column

CONDITION_ID_4

n/a

n/a

n/a

n/a

n/a

deleted

Column

CONDITION_ID_5

n/a

n/a

n/a

n/a

n/a

updated: table: cmn_sec_groups

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

CMN_SEC_GROUPS_C1

n/a

n/a

n/a

n/a

n/a

updated: table: cmn_sec_objects

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Index

CMN_SEC_OBJECTS_U2

n/a

n/a

n/a

n/a

n/a

added

Index

CMN_SEC_OBJECTS_U3

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

OBJECT_TYPE_CODE

varchar

NONE

n/a

n/a

N

added

Column

COMPONENT_CODE

varchar

NONE

n/a

n/a

N

updated: table: cmn_sec_users

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

USER_TYPE_ID

n/a

n/a

n/a

n/a

n/a

deleted

Column

NOTIFICATION_FLAGS

n/a

n/a

n/a

n/a

n/a

deleted

Column

LAST_VALID_LOGIN_DATE

n/a

n/a

n/a

n/a

n/a

updated: table: cmn_session_audits

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

CMN_SESSIONS_N1

n/a

n/a

n/a

n/a

n/a

updated: table: imm_object_categories

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

IMM_OBJECT_CATEGORIES_N1

n/a

n/a

n/a

n/a

n/a

deleted

Index

IMM_OBJECT_CATEGORIES_N2

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

CATEGORY_CODE

n/a

n/a

n/a

n/a

n/a

updated: table: imp_transactionimport

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

IMP_TRANSACTIONIMPORTKEY_IDX

n/a

n/a

n/a

n/a

n/a

deleted

Index

IMP_TRANSACTIONIMPORT_IDX

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

COSTCODE

n/a

n/a

n/a

n/a

n/a

deleted

Column

VARIATION

n/a

n/a

n/a

n/a

n/a

updated: table: invoiceheader

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

INVOICEAMOUNT

n/a

n/a

n/a

n/a

n/a

deleted

Column

ADMINCHARGE

n/a

n/a

n/a

n/a

n/a

deleted

Column

TAXAMOUNT

n/a

n/a

n/a

n/a

n/a

deleted

Column

SHIP_TO_COMPANY_CODE

n/a

n/a

n/a

n/a

n/a

deleted

Column

AMOUNT_REMAINING

n/a

n/a

n/a

n/a

n/a

updated: table: invoiceheader_values

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

INVOICEHEADER_VALUES_N1

n/a

n/a

n/a

n/a

n/a

updated: table: nbi_prj_matrix_dates

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

NBI_PRJ_MATRIX_DATES_U1

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

ID

n/a

n/a

n/a

n/a

n/a

updated: table: nbi_proj_res_rates_and_costs

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

NBI_PRJ_RES_RATES_AND_COSTS_U1

n/a

n/a

n/a

n/a

n/a

deleted

Index

NBI_PRJ_RES_RATES_AND_COSTS_U2

n/a

n/a

n/a

n/a

n/a

updated: table: obs_units_flat_by_mode

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

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_AUDIT_DELETE

numeric

0

n/a

n/a

N

added

Column

IS_AUDIT_UPDATE

numeric

0

n/a

n/a

N

updated: table: olb_generateinfo

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

ADJUNITS

n/a

n/a

n/a

n/a

n/a

deleted

Column

ADJRATE

n/a

n/a

n/a

n/a

n/a

updated: table: pac_chg_allocations

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

updated

Index

PAC_CHG_ALLOCATIONS_U1

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

ENTITY_ID

n/a

n/a

n/a

n/a

n/a

deleted

Column

LOCATION_ID

n/a

n/a

n/a

n/a

n/a

deleted

Column

DEPARTMENT_ID

n/a

n/a

n/a

n/a

n/a

deleted

Column

FROM_DATE

n/a

n/a

n/a

n/a

n/a

deleted

Column

TO_DATE

n/a

n/a

n/a

n/a

n/a

updated: table: pac_chg_resource_credits

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

PAC_CHG_RESOURCE_CREDITS_N1

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

FROM_DATE

n/a

n/a

n/a

n/a

n/a

deleted

Column

TO_DATE

n/a

n/a

n/a

n/a

n/a

updated: table: pac_chg_transactions

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

PAC_CHG_TRANSACTIONS_N1

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

LOCATION_ID

n/a

n/a

n/a

n/a

n/a

deleted

Column

DEPARTMENT_ID

n/a

n/a

n/a

n/a

n/a

updated: table: pac_chg_trialruns

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

LOCATION_ID

n/a

n/a

n/a

n/a

n/a

deleted

Column

DEPARTMENT_ID

n/a

n/a

n/a

n/a

n/a

updated: table: pac_imp_transimport_header

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

PAC_IMP_TRANSIMPORT_HEADER_U2

n/a

n/a

n/a

n/a

n/a

updated: table: pac_mnt_projects

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

BURDENCODE

n/a

n/a

n/a

n/a

n/a

deleted

Column

SHIP_TO_COMPANY_CODE

n/a

n/a

n/a

n/a

n/a

deleted

Column

COSTCODE

n/a

n/a

n/a

n/a

n/a

updated: table: pac_mnt_resources

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

TJL_PAC_MNT_RESOURCES_IDX

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

EMPLYCLASS

n/a

n/a

n/a

n/a

n/a

updated: table: pma_financial_values

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

PROJECT_ID

n/a

n/a

n/a

n/a

n/a

updated: table: pma_ideas

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

PMA_IDEAS_S1

n/a

n/a

n/a

n/a

n/a

deleted

Index

PMA_IDEAS_S2

n/a

n/a

n/a

n/a

n/a

deleted

Index

PMA_IDEAS_P1

n/a

n/a

n/a

n/a

n/a

deleted

Index

PMA_IDEAS_A1

n/a

n/a

n/a

n/a

n/a

deleted

Index

PMA_IDEAS_O1

n/a

n/a

n/a

n/a

n/a

deleted

Index

PMA_IDEAS_A2

n/a

n/a

n/a

n/a

n/a

deleted

Index

PMA_IDEAS_A3

n/a

n/a

n/a

n/a

n/a

updated: table: pma_pinned_investments

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

PORTFOLIO_ID

n/a

n/a

n/a

n/a

n/a

updated: table: pma_portfolios

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

IS_PUBLIC

n/a

n/a

n/a

n/a

n/a

updated: table: pma_portfolio_contents

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

IS_EXPRESSION

n/a

n/a

n/a

n/a

n/a

deleted

Column

TEMP_EXPRESSION

n/a

n/a

n/a

n/a

n/a

updated: table: ppa_billings

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

PPA_BILLINGS_TTAPPLYTO

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

COSTCODE

n/a

n/a

n/a

n/a

n/a

deleted

Column

VARIATION

n/a

n/a

n/a

n/a

n/a

deleted

Column

BILLRATE

n/a

n/a

n/a

n/a

n/a

deleted

Column

AMOUNT

n/a

n/a

n/a

n/a

n/a

deleted

Column

AMOUNTREMAINING

n/a

n/a

n/a

n/a

n/a

updated: table: ppa_billing_values

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

PPA_BILLING_VALUES_N1

n/a

n/a

n/a

n/a

n/a

updated: table: ppa_invoicedetails

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

TAXABLEAMT

n/a

n/a

n/a

n/a

n/a

deleted

Column

AMOUNT

n/a

n/a

n/a

n/a

n/a

updated: table: ppa_matrixvalues

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

PPA_MATRIXVALUEITEMS_IDX

n/a

n/a

n/a

n/a

n/a

deleted

Index

PPA_MATRIXVALUEROWNO_IDX

n/a

n/a

n/a

n/a

n/a

updated: table: ppa_transbill

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

COSTCODE

n/a

n/a

n/a

n/a

n/a

deleted

Column

VARIATION

n/a

n/a

n/a

n/a

n/a

deleted

Column

BILLRATE

n/a

n/a

n/a

n/a

n/a

deleted

Column

AMOUNT

n/a

n/a

n/a

n/a

n/a

updated: table: ppa_transbill_values

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

PPA_TRANSBILL_VALUES_N1

n/a

n/a

n/a

n/a

n/a

updated: table: ppa_transcontrol

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

PPA_TRANSCONTROL_COSTCODE

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

COSTCODE

n/a

n/a

n/a

n/a

n/a

deleted

Column

VARIATION

n/a

n/a

n/a

n/a

n/a

updated: table: ppa_transcontrol_values

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

PPA_TRANSCONTROL_VALUES_N1

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

COST_CURRENCY_CODE

n/a

n/a

n/a

n/a

n/a

deleted

Column

EXCHANGE_RATE

n/a

n/a

n/a

n/a

n/a

updated: table: ppa_transwipadjust

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

COSTCODE

n/a

n/a

n/a

n/a

n/a

deleted

Column

VARIATION

n/a

n/a

n/a

n/a

n/a

updated: table: ppa_transwipadjust_values

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

PPA_TRANSWIPADJUST_VALUES_N1

n/a

n/a

n/a

n/a

n/a

updated: table: ppa_wip

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

PPA_WIP_COSTCODE

n/a

n/a

n/a

n/a

n/a

deleted

Index

PPA_WIP_EMPKEY

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

COSTCODE

n/a

n/a

n/a

n/a

n/a

deleted

Column

VARIATION

n/a

n/a

n/a

n/a

n/a

updated: table: ppa_wipapinfo

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

PPA_WIPAPINFO_IDX

n/a

n/a

n/a

n/a

n/a

updated: table: ppa_wip_values

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

PPA_WIP_VALUES_N1

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

EXCHANGE_RATE

n/a

n/a

n/a

n/a

n/a

updated: table: prassignment

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

PRASSIGNMENT_N1

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

BASE_COST_SUM

n/a

n/a

n/a

n/a

n/a

deleted

Column

BASE_START

n/a

n/a

n/a

n/a

n/a

deleted

Column

BASE_FINISH

n/a

n/a

n/a

n/a

n/a

deleted

Column

BASE_DURATION

n/a

n/a

n/a

n/a

n/a

updated: table: 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

updated: table: prconstraint

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Index

PRCONSTRAINT_U2

n/a

n/a

n/a

n/a

n/a

updated: table: prj_baseline_details

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

PCTCOMPLETE

n/a

n/a

n/a

n/a

n/a

updated: table: prj_blb_slicerequests

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Column

FROM_DATE_OFFSET

numeric

0

n/a

n/a

N

updated: table: prj_blb_slices

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

PRJ_BLB_SLICES_N2

n/a

n/a

n/a

n/a

n/a

deleted

Index

PRJ_BLB_SLICES_N3

n/a

n/a

n/a

n/a

n/a

updated

Index

PRJ_BLB_SLICES_U2

n/a

n/a

n/a

n/a

n/a

updated: table: prj_ev_history

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

PRJ_EV_HISTORY_N2

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

SNAPSHOT_DATE

n/a

n/a

n/a

n/a

n/a

deleted

Column

SNAPSHOT_ID

n/a

n/a

n/a

n/a

n/a

deleted

Column

ACWP

n/a

n/a

n/a

n/a

n/a

updated: table: prj_projects

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

PRFILENAME

n/a

n/a

n/a

n/a

n/a

deleted

Column

PREXPORTMAP

n/a

n/a

n/a

n/a

n/a

deleted

Column

PRRESOURCEPOOLID

n/a

n/a

n/a

n/a

n/a

deleted

Column

PRUSERNAME

n/a

n/a

n/a

n/a

n/a

deleted

Column

PREXTENSION

n/a

n/a

n/a

n/a

n/a

deleted

Column

BASE_USAGE_SUM

n/a

n/a

n/a

n/a

n/a

deleted

Column

BASE_COST_SUM

n/a

n/a

n/a

n/a

n/a

deleted

Column

BASE_DURATION

n/a

n/a

n/a

n/a

n/a

updated: table: prj_resources

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

PRJ_RESOURCES_N1

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

PRRATE

n/a

n/a

n/a

n/a

n/a

deleted

Column

PROVERTIMERATE

n/a

n/a

n/a

n/a

n/a

deleted

Column

PRPHONETICS

n/a

n/a

n/a

n/a

n/a

updated: table: prlist

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

PRLIST3

n/a

n/a

n/a

n/a

n/a

deleted

Index

PRLIST4

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

PRUSERNAME

n/a

n/a

n/a

n/a

n/a

updated: table: prtask

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

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

Column

PRNAME

n/a

n/a

n/a

n/a

n/a

updated: table: prteam

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

PRTEAM_N3

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

PREXTENSION

n/a

n/a

n/a

n/a

n/a

deleted

Column

BASE_USAGE_SUM

n/a

n/a

n/a

n/a

n/a

deleted

Column

BASE_COST_SUM

n/a

n/a

n/a

n/a

n/a

deleted

Column

BASE_START

n/a

n/a

n/a

n/a

n/a

deleted

Column

BASE_FINISH

n/a

n/a

n/a

n/a

n/a

deleted

Column

BASE_DURATION

n/a

n/a

n/a

n/a

n/a

updated: table: prtimeentry

Indexes

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Index

PRTIMEENTRY_N1

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

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

updated: table: prtimeperiod

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

PURGE

n/a

n/a

n/a

n/a

n/a

updated: table: prtimesheet

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

PRPOSTEDPERIODID

n/a

n/a

n/a

n/a

n/a

updated: table: rsm_req_items

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

NUM_RES_FILLED

n/a

n/a

n/a

n/a

n/a

updated: table: srm_companies

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

IS_ACTIVE

n/a

n/a

n/a

n/a

n/a

updated: table: srm_projects

Indexes

Vendor specific: oracle

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

added

Index

SRM_PROJECTS_U2

n/a

n/a

n/a

n/a

n/a

Table

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

deleted

Column

PURGE

n/a

n/a

n/a

n/a

n/a

updated: table: temp_temppac_bil_cm_invlookup_

Table

Vendor specific: oracle

Event

Type

Name

Data Type

Default

Length

Precision

Nullable

updated

Column

INVOICETYPE

n/a

n/a

n/a

n/a

n/a