Appendix A: Database Changes by Release - Perceptive Content Update Guide - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external - Perceptive-Content/Perceptive-Content-Update-Guide/Foundation-24.1/Perceptive-Content-Update-Guide/Appendix-A-Database-Changes-by-Release - 2024-04-02

Added table:

IN_LIC_TOKEN_HWFP

Created tables:

Altered columns in:

IN_INSTANCE New columns: CLASS_TYPE, IN_INSTANCE, INSTANCE_NAME, CREATION_USR_ID, CREATION_TIME, MOD_USR_ID, MOD_TIME, ADD_USR_ID, ADD_TIME, LOCK_SESSION_ID, LOCK_REVISION_NUM, LOCK_TYPE, DELETION_STATUS, : ACTION_GROUP_ID

IN_SC_SESSION New column: DISCONNECT_TIME

IN_TIMING_SUMMARY New columns: SERVER_ID, NODE_ID, USR_ID, OS_USER_NAME

Created indexes in:

XIE1IN_FORM, INSTANCE_IDX_04, INSTANCE_IDX_05, LIC_MON_IDX05, LM_SCREEN_IDX07, PHSOB_IDX07, SERREG_IDX04, TIMING_S_IDX03, TIMING_S_IDX04, TIMING_S_IDX05, VIEW_IDX08, WF_ITEM_IDX_13

Altered indexes in:

CMIB_IDX02, DOC_TYPE_IDX2, INSTANCE_IDX_03, TIMING_S_IDX02

Created foreign keys in:

IN_DOC new key: FK_DOC_INSTANCE_ID, IN_DRAWER new key: FK_DR_I_ID, IN_INSTANCE new key: FK_I_AG_ID, IN_INSTANCE new key: FK_I_S_ID, IN_LM_SCREEN new key: FK_LMS_S_ID, IN_PROJ new key: FK_PROJ_INSTANCE_ID, IN_TASK new key: FK_T_S_ID, IN_TIMING_SUMMARY new key: FK_TS_N_ID, IN_TIMING_SUMMARY new key: FK_TS_S_ID, IN_VIEW new key: FK_V_S_ID, IN_WF_ITEM new key: FK_WI_S_ID, IN_WF_PROCESS new key: FK_WFP_S_ID

IN_BATCH new column: PATH_MODE, IN_BATCH_PAGE new column: DOC_NAME, IN_CONTEXT_MAP_ITEM_BASE new column: ITEM_LEVEL, IN_DOC new column: LEGACY_UNIQUENESS, IN_DOC_TYPE new column: IS_RECORD_TYPE, IN_DOC_TYPE_LIST new column: LIST_TYPE, IN_DOC_TYPE_LIST new column: COLOR, IN_DRAWER new column: INSTANCE_ID, IN_EXTERN_MSG new column: AGENT_LOCK, IN_EXTERN_MSG new column: LOCK_EXPIRATION, IN_LIC_MON new column: SESSION_ID, IN_LM_SCREEN new column: SCRIPT_ID, IN_RS_WS_OP new column: IS_ASQ_CONSUMABLE, IN_RT_HOLD new column: HOLD_TYPE, IN_SC_CONNECTION new column: SERVER_SESSION_ID, IN_SC_CONNECTION new column: LAST_HEARTBEAT, IN_SERVICE_REGISTRATION new column: INSTANCE_NAME, IN_TIMING_DATA new column: IS_ERROR, IN_TIMING_DATA new column: EVENT_TIME, IN_VIEW new column: MOD_SESSION_ID, IN_VIEW new column: IS_DEFAULT, IN_WF_FLATTEN_QUEUE new column: ALLOW_JAVASCRIPT, IN_WF_ITEM new column: LOCK_SESSION_ID, IN_WF_PROCESS new column: IS_DELETED

Removed tables:

IN_CD_CLASS, IN_CD_FORM, IN_CD_PHSOB_FORM, IN_CD_RESULT, IN_CD_RUN, IN_FOLDER, IN_FOLDER_TYPE, IN_LOCK, IN_TIMING_REPORT, IN_WORKING_ROOT

Removed columns in:

IN_LIC_MON column: LIC_MON_STATE, IN_LIC_MON column: LAST_UPDATE, IN_LM_SCREEN column: DOC_CONTEXT_MAP_ID, IN_LM_SCREEN column: PROJ_CONTEXT_MAP_ID, IN_SC_SESSION column: SESSION_HASH, IN_SC_SESSION column: LAST_HEARTBEAT, IN_SC_SESSION column: LOGONS_ENABLED, IN_SC_SESSION column: LOGONS_MSG, IN_TIMING_DATA column: DATA_POINT_TYPE, IN_TIMING_SUMMARY column: TIMING_REPORT_ID, IN_TIMING_SUMMARY column: SEQ_NUM, IN_TIMING_SUMMARY column: EVENT_COUNT, IN_TIMING_SUMMARY column: AVG_COST, IN_TIMING_SUMMARY column: TOTAL_COST, IN_TIMING_SUMMARY column: STDDEV_COST, IN_TIMING_SUMMARY column: ERROR_COUNT, IN_TIMING_SUMMARY column: THRESHOLD_COUNT, IN_TIMING_SUMMARY column: AVG_DATA_SIZE, IN_TIMING_SUMMARY column: STDDEV_DATA_SIZE, IN_VIEW column: MOD_USR_ID

Removed indexes in:

DOC_IDX11, LIC_MON_IDX02, LIC_MON_IDX04, LM_SCREEN_IDX04, LM_SCREEN_IDX05, PROJ_IDX_11, SC_SESSION_IDX02, SC_SESSION_IDX04, _IDX02

DOC_IDX10, DOC_IDX12, DOC_IDX2, DOC_IDX4, DOC_IDX7, DOC_IDX81, DOC_IDX82, DOC_IDX83, DOC_IDX84, DOC_IDX85, DOC_IDX9, IR_IDX02, IR_IDX03, LIC_MON_IDX03, PROJ_IDX_02 PROJ_IDX_06, PROJ_IDX_06, PROJ_IDX_07, PROJ_IDX_09 PROJ_IDX_10, TASK_IDX05, TIMING_D_IDX02, TIMING_S_IDX02, WF_PROCESS_IDX_03

Removed foreign keys:

FK_IR_CI_ID, FK_IR_PI_ID, FK_LMS_DCM_ID, FK_LMS_PCM_ID, FK_TS_TR_ID

Altered tables

IN_INSTANCE, IN_TASK, IN_WF_PROCESS, IN_PRODUCT_MOD_HIST, DOC_TYPE_NAME

Removed index:

IN_INSTANCE_REL Index: IR_IDX02

IN_INSTANCE_REL Index: IR_IDX03

IN_INSTANCE Index: INSTANCE_IDX_06

IN_INSTANCE Index: INSTANCE_IDX_07

Column Nullability:

IN_INSTANCE Column: CLASS_TYPE Nullable: TRUE Nullable: FALSE

Created table:

IN_EXTERN_MSG_GROUP

Created INEMUSER schema with IN_EXTERN_MSG_SEQ table

Oracle Only:

IN_EXTERN_MSG_SEQ trigger IN_EXTERN_MSG_SEQUENCE sequence

IN_DOC Index: DOC_IDX5

Removed index

IN_DOC Index: DOC_IDX4

IN_INSTANCE Index: INSTANCE_IDX_08

Created indexes:

IN_DOC_TYPE Index: DOC_TYPE_IDX4 IN_FORM Index: FORM_IDX03 IN_MACRO Index: MACRO_IDX02 IN_OSM_SET_REL Index: OSR_IDX02 IN_OUTPUT_PROFILE Index: OUTPUT_PROFILE_IDX03IN_OUTPUT_PROFILE_FAX Index: OP_FAX_IDX02 IN_PROJ_TYPE Index: PROJ_TYPE_IDX_04 IN_RS_WS_OP Index: RS_WS_OP_IDX02 IN_RS_WS_SERVICE Index: RS_WS_SERVICE_IDX02 IN_RT_POLICY_OBJ_QUAL Index: RT_POQ_IDX03

IN_SC_HOLD_PRIV Index: SC_HP_IDX02

IN_SIG Index: SIG_IDX_07 IN_TASK_HIST Index: TASK_HIST_IDX03 IN_VSL_USR_VAR_CONSTRAINT_VAL Index: VSL_UVCV_IDX02 IN_WF_ITEM_HIST Index: WF_ITEM_HIST_IDX06 IN_WF_QUEUE_ATTR Index: QUEUE_ATTR_IDX02

This rollup incremental upgrades the INUSER schema from 6.7.0.3158 or 6.7.0.3656 to 7.0.5.860 and applies to both Oracle and SQL Server.

New Tables:

IN_APPROVAL_SET_ITEM IN_DEPT_ACMPICKLST_SHARE IN_DEPT_ALARM_SHARE IN_DEPT_APP_PLAN_SHARE IN_DEPT_CAPTURE_PROFILE_SHARE IN_DEPT_CAPTURE_SOURCE_SHARE IN_DEPT_DOCTYP_SHARE IN_DEPT_DOCTYPLST_SHARE IN_DEPT_DRAWER_SHARE IN_DEPT_ELEMENT_TYPE_SHARE IN_DEPT_FAX_RECIPIENT_SHARE IN_DEPT_FORM_SHARE IN_DEPT_GROUP_SHARE IN_DEPT_INSTCONNTYPE_SHARE IN_DEPT_LIST_ITEM_SHARE IN_DEPT_LIST_SHARE IN_DEPT_OUTPROF_SHARE IN_DEPT_PROJTYP_SHARE IN_DEPT_PROJTYPLST_SHARE IN_DEPT_PROP_SHARE IN_DEPT_RC_CUTOFF_SHARE IN_DEPT_RT_AUTHORITY_SHARE IN_DEPT_RT_HOLD_SHARE IN_DEPT_RT_OFFLINE_LOC_SHARE IN_DEPT_RT_POLICY_SHARE IN_DEPT_RT_TIME_PERIOD_SHARE IN_DEPT_SEQUENCE_SHARE IN_DEPT_SUBOBTMPL_SHARE IN_DEPT_TASKTMPL_SHARE IN_DEPT_VIEW_SHARE IN_DEPT_VSL_RULE_SHARE IN_DEPT_WFPROC_SHARE IN_DEPT_WSDATADEF_SHARE IN_DEPT_WSDESIGN_SHARE IN_DEPT_WSFILE_SHARE IN_DEPT_WSPRES_SHARE IN_INSTANCE_CONN_REL IN_INSTANCE_CONN_SEQ_GRP IN_INSTANCE_CONN_SEQ_MBR IN_INSTANCE_CONN_TYPE IN_LIC_MON_HIST IN_LIC_MON_HIST_DETAIL IN_LIC_USR_GROUP IN_LIC_USR_GROUP_ALLOC IN_RC_CAPTURE_SOURCE_METADATA IN_RC_CUTOFF_INSTRUCTION IN_RC_FILE_PLAN_SESSION_LOCK IN_RC_NOTIFICATION_EVENT IN_RC_NOTIFICATION_SUBSCRIBER IN_RC_NOTIFICATION_VIEW IN_RC_PDF_METADATA IN_RC_PHOTO_METADATA IN_RC_RECORD_DOC IN_RC_RECORD_FOLDER IN_RC_SCANNED_METADATA IN_RC_WEB_METADATA IN_RT_APPROVAL_TEMPLATE_TYPE IN_RT_HOLD_RESOLVED_PROJ IN_RT_HOLD_RESOLVED_TYPE IN_SC_ACM_PICKLIST IN_SC_ACM_PICKLIST_CLASS IN_SC_ACM_PICKLIST_MEMBER IN_SC_ACM_PRIV IN_SC_INSTANCE_CONN_TYPE_PRIV IN_SC_RECORD_FOLDER_PRIV IN_SC_TRUSTED_PUBLIC_KEYS

New Columns - Table: IN_CAPTURE_SOURCE_OUTLOOK: REMOVE_EMBEDDED_ATTACHMENTS INSTANCE_CONN_TYPE_ID

New Indexes:

Table: IN_ALARM Index: ALARM_IDX_04

Table: IN_CAPTURE_PROFILE Index: CAP_PROF_IDX05

Table: IN_CAPTURE_SOURCE Index: CAP_SRC_IDX02

Table: IN_CAPTURE_SOURCE_OUTLOOK Index: CAP_SO_IDX02

Table: IN_CONTEXT_MAP_ITEM_SRC Index: CMIS_IDX11

Table: IN_DEPT Index: DEPT_IDX03

Table: IN_DOC_TYPE Index: DOC_TYPE_IDX5

Table: IN_DOC_TYPE_LIST Index: DOC_TYPE_LIST_IDX_03

Table: IN_DRAWER Index: DRAWERS_IDX03

Table: IN_ELEMENT_TYPE Index: ET_IDX04

Table: IN_FAX_RECIPIENT Index: FAX_REC_IDX03

Table: IN_FORM Index: FORM_IDX04

Table: IN_LIC_MON Index: LIC_MON_IDX02

Table: IN_LIC_MON Index: LIC_MON_IDX04

Table: IN_LIC_MON Index: LIC_MON_IDX06

Table: IN_LIC_TOKEN Index: LIC_TOKEN_IDX04

Table: IN_LIST Index: LIST_IDX03

Table: IN_LIST_ITEM Index: LIST_ITEM_IDX05

Table: IN_LM_APP_PLAN Index: LM_AP_IDX04

Table: IN_OUTPUT_PROFILE Index: OUTPUT_PROFILE_IDX04

Table: IN_PHSOB Index: PHSOB_IDX08

Table: IN_PHSOB Index: PHSOB_IDX09

Table: IN_PROJ_TYPE Index: PROJ_TYPE_IDX_05

Table: IN_PROJ_TYPE_LIST Index: PTL_IDX03

Table: IN_PROP Index: PROP_IDX4

Table: IN_RT_AUTHORITY Index: RT_AUTH_IDX03

Table: IN_RT_HOLD Index: RT_HOLD_IDX03

Table: IN_RT_OFFLINE_LOC Index: RT_OL_IDX04

Table: IN_RT_POLICY Index: RT_POLICY_IDX04

Table: IN_RT_POLICY_OBJ Index: RT_PO_IDX05

Table: IN_RT_POLICY_OBJ Index: RT_PO_IDX06

Table: IN_RT_POLICY_OBJ Index: RT_PO_IDX07

Table: IN_RT_POLICY_OBJ Index: RT_PO_IDX08

Table: IN_RT_SET Index: RT_SET_IDX09

Table: IN_RT_SET Index: RT_SET_IDX10

Table: IN_RT_TIME_PERIOD Index: RT_TP_IDX03

Table: IN_SC_GROUP Index: SC_GROUP_IDX05

Table: IN_SC_GROUP Index: SC_GROUP_IDX06

Table: IN_SC_USR Index: SC_USR_IDX07

Table: IN_SEQUENCE Index: SEQUENCE_IDX02

Table: IN_SUBOB_TEMPL Index: SUBOB_TEMPL_IDX_05

Table: IN_TASK_TEMPLATE Index: TASK_TEMPL_IDX14

Table: IN_VIEW Index: VIEW_IDX09

Table: IN_VSL_RULE Index: RULE_IDX03

Table: IN_WF_INTEGRATION_QUEUE Index: WIQ_IDX04

Table: IN_WF_ITEM Index: WF_ITEM_IDX_14

Table: IN_WF_PROCESS Index: WF_PROCESS_IDX_04

Table: IN_WS_DATA_DEF Index: WS_DATA_DEF_IDX03

Table: IN_WS_FILE Index: WS_FILE_IDX_04

Table: IN_WS_PRES Index: WS_PRES_IDX_03

New Index Columns:

Table: IN_LIC_TOKEN Index: LIC_TOKEN_IDX02 Column: ACCESS_TIME

Table: IN_PROJ_TYPE Index: PROJ_TYPE_IDX_02 Column: PROJ_TYPE_NAME

New Foreign Keys:

Table: IN_CAPTURE_SOURCE_OUTLOOK FKey: FK_CAPSO_ICT_ID

Table: IN_CONTEXT_MAP_ITEM_SRC FKey: FK_CMIS_RC_ID

Table: IN_ELEMENT_TYPE FKey: FK_ET_D_ID

Table: IN_FAX_RECIPIENT FKey: FK_FR_D_ID

Table: IN_LIC_MON FKey: FK_LIC_MON_AG_ID

Table: IN_LIC_MON FKey: FK_LIC_MON_LUG_ID

Table: IN_LIST_ITEM FKey: FK_LIST_ITEM_D_ID

Table: IN_RT_AUTHORITY FKey: FK_RTA_D_ID

Table: IN_RT_HOLD FKey: FK_RHOLD_D_ID

Table: IN_RT_OFFLINE_LOC FKey: FK_RTOL_D_ID

Table: IN_RT_POLICY FKey: FK_RP_D_ID

Table: IN_RT_SET FKey: FK_RSET_PO_ID

Table: IN_RT_TIME_PERIOD FKey: FK_RTTP_D_ID

Table: IN_SC_USR FKey: FK_SCU_LUG_ID

Table: IN_VSL_RULE FKey: FK_VR_D_ID

Table: IN_WF_ITEM FKey: FK_WI_INSTANCE_ID

New Columns:

Table: IN_CAPTURE_SOURCE Column: CATEGORY

Table: IN_CONTEXT_MAP_ITEM_SRC Column: RECORD_CATEGORY_ID

Table: IN_DEPT Column: DEPT_PREFIX

Table: IN_ELEMENT_TYPE Column: DEPT_ID

Table: IN_FAX_RECIPIENT Column: DEPT_ID

Table: IN_LIC_MON Column: CLIENT_TYPE

Table: IN_LIC_MON Column: ALLOC_GROUP_ID

Table: IN_LIC_MON Column: LIC_USR_GROUP_ID

Table: IN_LIC_TOKEN Column: ACCESS_TIME

Table: IN_LIST_ITEM Column: DEPT_ID

Table: IN_LM_APP_PLAN Column: CATEGORY

Table: IN_PHSOB Column: FILE_SIZE

Table: IN_PHSOB Column: CHECKSUM

Table: IN_PHSOB Column: CHECKSUM_TYPE

Table: IN_PHSOB Column: VERIFY_TIME

Table: IN_PHSOB Column: VERIFY_STATE

Table: IN_PROJ Column: CLOSED_STATUS

Table: IN_PROJ Column: IS_UNDER_POLICY

Table: IN_PROJ Column: HAS_PHS_FILE_REF

Table: IN_RT_AGENT_STATE Column: JOB_STATE

Table: IN_RT_AGENT_STATE Column: LAST_RUN_TIME

Table: IN_RT_AUTHORITY Column: DEPT_ID

Table: IN_RT_HOLD Column: DEPT_ID

Table: IN_RT_OFFLINE_LOC Column: DEPT_ID

Table: IN_RT_POLICY Column: DEPT_ID

Table: IN_RT_POLICY_OBJ Column: EST_CUTOFF_TIME

Table: IN_RT_POLICY_OBJ Column: EST_CUTOFF_CALC_TIME

Table: IN_RT_POLICY_OBJ Column: EST_DISPOSITION_TIME

Table: IN_RT_POLICY_OBJ Column: EST_DISPOSITION_CALC_TIME

Table: IN_RT_SET Column: POLICY_OBJ_ID

Table: IN_RT_SET Column: PATH_OBJ_ID

Table: IN_RT_TIME_PERIOD Column: DEPT_ID

Table: IN_SC_GROUP Column: IS_GLOBALLY_VISIBLE

Table: IN_SC_USR Column: LIC_USR_GROUP_ID

Table: IN_VSL_RULE Column: DEPT_ID

Table: IN_WF_ITEM Column: INSTANCE_ID

Removed Tables:

IN_ADDENDUM_TEMPLATE IN_ADDENDUM_TEMPLATE_DATA IN_RC_ADDRESSEE IN_RC_FOLDER IN_RC_FOLDER_POLICY IN_RC_FOLDER_TYPE IN_RC_FOLDER_TYPE_LIST IN_RC_FOLDER_TYPE_LIST_MEMBER IN_RC_METADATA IN_RC_METADATA_ADDRESSEE IN_RC_METADATA_INSTANCE

Removed Columns:

Table: IN_AUDIT_TEMPLATE Column: DEPT_ID

Table: IN_DEPT Column: IS_ACTIVE

Table: IN_RS Column: DEPT_ID

Table: IN_RT_HOLD_RESOLVED Column: HOLD_STATE

Table: IN_SCRIPT Column: DEPT_ID

Removed Indexes:

Table: IN_OSM_TREE_CAS Index: OT_CAS_IDX03

Table: IN_RT_HOLD_RESOLVED Index: RT_HRES_IDX02

Table: IN_SC_GROUP Index: SC_GROUP_IDX04

Removed Index Columns:

Table: IN_AUDIT_TEMPLATE Index: AT_IDX02 Column: TEMPLATE_NAME

Table: IN_DOC_TYPE_LIST_REL Index: DTLR_IDX02 Column: SEQ_NUM

Table: IN_LIC_MON Index: LIC_MON_IDX03 Column: LOGIN_TIME

Table: IN_LM_SCREEN_CONTEXT_MAP Index: LM_SCM_IDX02 Column: SCREEN_ID

Table: IN_SC_GROUP Index: SC_GROUP_IDX02 Column: GROUP_NAME

Removed Foreign Keys:

Table: IN_AUDIT_TEMPLATE FKey: FK_AT_D_ID

Table: IN_PHSOB FKey: FK_PO_FORM_ID

Table: IN_RS FKey: FK_RS_DEPT_ID

Table: IN_SCRIPT FKey: FK_S_DEPT_ID

Mismatch Column Names:

Table: IN_CAPTURE_SOURCE_OUTLOOK Column: ATTACHMENT_MODE Column: STORAGE_MODE

Table: IN_CAPTURE_SOURCE_OUTLOOK Column: AUTO_CAPTURE_MODE Column: CONTENT_MODE

Table: IN_DOC Column: IS_PROTECTED Column: PROTECTION_STATUS

Table: IN_DOC_TYPE Column: IS_RECORD_TYPE Column: CATEGORY

Table: IN_PROJ Column: IS_PROTECTED Column: PROTECTION_STATUS

Mismatch Column Defaults:

Table: IN_BATCH Column: PREP_TIME Default: 1-JAN-1970 Default: 197001-01 00:00:00

Table: IN_BATCH Column: CREATION_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_BATCH Column: QA_START_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_BATCH Column: QA_COMPLETE_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_BATCH Column: REC_START_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_BATCH Column: REC_COMPLETE_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_BATCH Column: VERIFY_START_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_BATCH Column: VERIFY_COMPLETE_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_BATCH Column: LINK_START_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_BATCH Column: LINK_COMPLETE_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_BATCH Column: MOD_TIME Default: 1-JAN-1970 Default: 197001-01 00:00:00

Table: IN_BATCH_ARCHIVE Column: PREP_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_BATCH_ARCHIVE Column: CREATION_TIME Default: 1-JAN1970 Default: 1970-01-01 00:00:00

Table: IN_BATCH_ARCHIVE Column: QA_START_TIME Default: 1-JAN1970 Default: 1970-01-01 00:00:00

Table: IN_BATCH_ARCHIVE Column: QA_COMPLETE_TIME Default: 1JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_BATCH_ARCHIVE Column: REC_START_TIME Default: 1-JAN1970 Default: 1970-01-01 00:00:00

Table: IN_BATCH_ARCHIVE Column: REC_COMPLETE_TIME Default: 1JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_BATCH_ARCHIVE Column: VERIFY_START_TIME Default: 1JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_BATCH_ARCHIVE Column: VERIFY_COMPLETE_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_BATCH_ARCHIVE Column: LINK_START_TIME Default: 1-JAN1970 Default: 1970-01-01 00:00:00

Table: IN_BATCH_ARCHIVE Column: LINK_COMPLETE_TIME Default: 1JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_BATCH_ARCHIVE Column: DELETE_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_DOC Column: CHECK_OUT_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_DOC Column: CREATION_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_DOC Column: MOD_TIME Default: 1-JAN-1970 Default: 1970-0101 00:00:00 Table: IN_DOC_HISTORY Column: ACTION_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_DOC_TYPE Column: CREATION_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_DOC_TYPE Column: MOD_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_ERM_SPOOL Column: REPORT_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_ERM_SPOOL Column: CREATION_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_ERM_SPOOL Column: UPLOAD_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_ERM_SPOOL Column: IMPORT_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_EXTERN_MSG Column: START_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_EXTERN_MSG Column: END_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_JOB Column: STATE_ENTERED_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_JOB Column: CREATED_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_JOB Column: INITIALIZED_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_JOB Column: STARTED_TIME Default: 1-JAN-1970 Default: 197001-01 00:00:00

Table: IN_JOB Column: COMPLETED_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_JOB Column: UPDATED_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_JOB Column: AUTO_RESUME_AT Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_JOB_STATE Column: ENTERED_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_JOB_STATE Column: EXITED_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_JOB_STEP Column: STARTED_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_JOB_STEP Column: COMPLETED_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_LIC Column: EXPIRATION_DATE Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_LOGOB Column: CREATION_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_LOGOB Column: MOD_TIME Default: 1-JAN-1970 Default: 197001-01 00:00:00

Table: IN_MESSAGE Column: CREATION_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_MESSAGE_QUEUE Column: LEASE_ACQUIRED_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_MESSAGE_QUEUE Column: LEASE_EXPIRATION_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_PHSOB Column: SCAN_TIME Default: 1-JAN-1970 Default: 197001-01 00:00:00

Table: IN_PHSOB Column: CREATION_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_PHSOB Column: MOD_TIME Default: 1-JAN-1970 Default: 197001-01 00:00:00

Table: IN_PROJ Column: CREATION_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_PROJ Column: MOD_TIME Default: 1-JAN-1970 Default: 1970-0101 00:00:00

Table: IN_PROJ_TYPE Column: CREATION_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_PROJ_TYPE Column: MOD_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_RT_SET Column: CUTOFF_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_SC_SESSION Column: START_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_SC_SESSION Column: DISCONNECT_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_SCRIPT Column: CREATION_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_SCRIPT Column: MOD_TIME Default: 1-JAN-1970 Default: 197001-01 00:00:00

Table: IN_SIG Column: CREATION_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_SUBOB Column: CREATION_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_SUBOB Column: MOD_TIME Default: 1-JAN-1970 Default: 197001-01 00:00:00

Table: IN_SUBOB_TEMPL Column: CREATION_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_SUBOB_TEMPL Column: MOD_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_TASK Column: CREATION_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_TASK Column: MOD_TIME Default: 1-JAN-1970 Default: 1970-0101 00:00:00

Table: IN_TASK Column: REVIEW_TIME Default: 1-JAN-1970 Default: 197001-01 00:00:00

Table: IN_TASK_COMMENT Column: CREATION_TIME Default: 1-JAN1970 Default: 1970-01-01 00:00:00

Table: IN_USR_KEY Column: VALID_FROM Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_USR_KEY Column: VALID_TO Default: 1-JAN-1970 Default: 197001-01 00:00:00

Table: IN_USR_PROXY Column: BEGINNING_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_USR_PROXY Column: VALID_UNTIL_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_USR_PROXY_HIST Column: BEGINNING_TIME Default: 1-JAN1970 Default: 1970-01-01 00:00:00

Table: IN_USR_PROXY_HIST Column: VALID_UNTIL_TIME Default: 1-JAN1970 Default: 1970-01-01 00:00:00

Table: IN_VERSION Column: CREATION_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_VERSION Column: MOD_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_VERSION Column: LAST_VIEW_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_VERSION Column: CHECK_IN_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_WF_ITEM Column: CREATION_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_WF_ITEM Column: QUEUE_START_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_WF_ITEM Column: STATE_START_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_WF_ITEM_ARCH Column: CREATION_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_WF_ITEM_ARCH Column: QUEUE_START_TIME Default: 1-JAN1970 Default: 1970-01-01 00:00:00

Table: IN_WF_ITEM_ARCH Column: STATE_START_TIME Default: 1-JAN1970 Default: 1970-01-01 00:00:00

Table: IN_WF_ITEM_HIST Column: STATE_START_TIME Default: 1-JAN1970 Default: 1970-01-01 00:00:00

Table: IN_WF_ITEM_HIST_ARCH Column: STATE_START_TIME Default: 1-JAN-1970 Default: 1970-01-01 00:00:00

Table: IN_WF_SCHEDULED_SCRIPT Column: SCRIPT_TIME Default: 1JAN-1970 Default: 1970-01-01 00:00:00

Mismatch Column Lengths:

Table: IN_MESSAGE Column: SENDER Length: 31 Length: 40

Table: IN_WF_INTEGRATION_MAP Column: PARAM_NAME Length: 512 Length: 128

Table: IN_WS_FILE Column: FILE_PATH Length: 512 Length: 450

Mismatch Column Nullable - Table: IN_APPROVAL_SET Column: PROJ_ID Nullable: FALSE Nullable: TRUE

Mismatch Foreign Key Names:

Table: IN_AUDIT_DETAIL FKey: IN_AD_AO_ID FKey: FK_AD_AO_ID

Table: IN_LM_SE_WINDOWTEXT FKey: IN_LMSEWT_ELEMENT_ID FKey: FK_LMSEWT_ELEMENT_ID

Table: IN_MESSAGE_QUEUE_MASTER FKey: R_423 FKey: FK_MQM_MQ

Table: IN_PHSOB_CACHE FKey: IN_PC_P_ID FKey: FK_PC_P_ID

Mismatch Index Name - Table: IN_FORM Index: XIE1IN_FORM Index: FORM_IDX02

Mismatch Index Uniqueness:

Table: IN_DOC_TYPE_LIST_REL Index: DTLR_IDX02 Unique: TRUE Unique: FALSE

Table: IN_FAX_RECIPIENT Index: FAX_REC_IDX02 Unique: FALSE Unique: TRUE

Table: IN_LM_SCREEN_CONTEXT_MAP Index: LM_SCM_IDX02 Unique: FALSE Unique: TRUE

Mismatch Index Column Names:

Table: IN_AUDIT_TEMPLATE Index: AT_IDX02 Column: DEPT_ID Column: TEMPLATE_NAME

Table: IN_DOC_TYPE Index: DOC_TYPE_IDX2 Column: IS_RECORD_TYPE Column: CATEGORY

Table: IN_DOC_TYPE_LIST_REL Index: DTLR_IDX02 Column: PARENT_DOC_TYPE_LIST_ID Column: SEQ_NUM

Table: IN_PROJ_TYPE Index: PROJ_TYPE_IDX_02 Column: PROJ_TYPE_NAME Column: CATEGORY

Table: IN_SC_GROUP Index: SC_GROUP_IDX02 Column: DEPT_ID Column: GROUP_NAME

New Tables:

IN_APPROVAL_SET_ITEM IN_DEPT_ACMPICKLST_SHARE IN_DEPT_ALARM_SHARE IN_DEPT_APP_PLAN_SHARE IN_DEPT_CAPTURE_PROFILE_SHARE IN_DEPT_CAPTURE_SOURCE_SHARE IN_DEPT_DOCTYP_SHARE IN_DEPT_DOCTYPLST_SHARE IN_DEPT_DRAWER_SHARE IN_DEPT_ELEMENT_TYPE_SHARE IN_DEPT_FAX_RECIPIENT_SHARE IN_DEPT_FORM_SHARE IN_DEPT_GROUP_SHARE IN_DEPT_INSTCONNTYPE_SHARE IN_DEPT_LIST_ITEM_SHARE IN_DEPT_LIST_SHARE IN_DEPT_OUTPROF_SHARE IN_DEPT_PROJTYP_SHARE IN_DEPT_PROJTYPLST_SHARE IN_DEPT_PROP_SHARE IN_DEPT_RC_CUTOFF_SHARE IN_DEPT_RT_AUTHORITY_SHARE IN_DEPT_RT_HOLD_SHARE IN_DEPT_RT_OFFLINE_LOC_SHARE IN_DEPT_RT_POLICY_SHARE IN_DEPT_RT_TIME_PERIOD_SHARE IN_DEPT_SEQUENCE_SHARE IN_DEPT_SUBOBTMPL_SHARE IN_DEPT_TASKTMPL_SHARE IN_DEPT_VIEW_SHARE IN_DEPT_VSL_RULE_SHARE IN_DEPT_WFPROC_SHARE IN_DEPT_WSDATADEF_SHARE IN_DEPT_WSDESIGN_SHARE IN_DEPT_WSFILE_SHARE IN_DEPT_WSPRES_SHARE IN_INSTANCE_CONN_REL IN_INSTANCE_CONN_SEQ_GRP IN_INSTANCE_CONN_SEQ_MBR IN_INSTANCE_CONN_TYPE IN_LIC_MON_HIST IN_LIC_MON_HIST_DETAIL IN_LIC_USR_GROUP IN_LIC_USR_GROUP_ALLOC IN_RC_CAPTURE_SOURCE_METADATA IN_RC_CUTOFF_INSTRUCTION IN_RC_FILE_PLAN_SESSION_LOCK IN_RC_NOTIFICATION_EVENT IN_RC_NOTIFICATION_SUBSCRIBER IN_RC_NOTIFICATION_VIEW IN_RC_PDF_METADATA IN_RC_PHOTO_METADATA IN_RC_RECORD_DOC IN_RC_RECORD_FOLDER IN_RC_SCANNED_METADATA IN_RC_WEB_METADATA IN_RT_APPROVAL_TEMPLATE_TYPE IN_RT_HOLD_RESOLVED_PROJ IN_RT_HOLD_RESOLVED_TYPE IN_SC_ACM_PICKLIST IN_SC_ACM_PICKLIST_CLASS IN_SC_ACM_PICKLIST_MEMBER IN_SC_ACM_PRIV IN_SC_INSTANCE_CONN_TYPE_PRIV IN_SC_RECORD_FOLDER_PRIV IN_SC_TRUSTED_PUBLIC_KEYS

New Columns:

Table: IN_CAPTURE_SOURCE_OUTLOOK Column: REMOVE_EMBEDDED_ATTACHMENTS

Table: IN_CAPTURE_SOURCE_OUTLOOK Column: INSTANCE_CONN_TYPE_ID

New Indexes:

Table: IN_ALARM Index: ALARM_IDX_04

Table: IN_CAPTURE_PROFILE Index: CAP_PROF_IDX05

Table: IN_CAPTURE_SOURCE Index: CAP_SRC_IDX02

Table: IN_CAPTURE_SOURCE_OUTLOOK Index: CAP_SO_IDX02

Table: IN_CONTEXT_MAP_ITEM_SRC Index: CMIS_IDX11

Table: IN_DEPT Index: DEPT_IDX03

Table: IN_DOC_TYPE Index: DOC_TYPE_IDX5

Table: IN_DOC_TYPE_LIST Index: DOC_TYPE_LIST_IDX_03

Table: IN_DRAWER Index: DRAWERS_IDX03

Table: IN_ELEMENT_TYPE Index: ET_IDX04

Table: IN_FAX_RECIPIENT Index: FAX_REC_IDX03

Table: IN_FORM Index: FORM_IDX04

Table: IN_LIC_MON Index: LIC_MON_IDX02

Table: IN_LIC_MON Index: LIC_MON_IDX04

Table: IN_LIC_MON Index: LIC_MON_IDX06

Table: IN_LIC_TOKEN Index: LIC_TOKEN_IDX04

Table: IN_LIST Index: LIST_IDX03

Table: IN_LIST_ITEM Index: LIST_ITEM_IDX05

Table: IN_LM_APP_PLAN Index: LM_AP_IDX04

Table: IN_OUTPUT_PROFILE Index: OUTPUT_PROFILE_IDX04

Table: IN_PHSOB Index: PHSOB_IDX08

Table: IN_PHSOB Index: PHSOB_IDX09

Table: IN_PROJ_TYPE Index: PROJ_TYPE_IDX_05

Table: IN_PROJ_TYPE_LIST Index: PTL_IDX03

Table: IN_PROP Index: PROP_IDX4

Table: IN_RT_AUTHORITY Index: RT_AUTH_IDX03 Table: IN_RT_HOLD Index: RT_HOLD_IDX03

Table: IN_RT_OFFLINE_LOC Index: RT_OL_IDX04

Table: IN_RT_POLICY Index: RT_POLICY_IDX04

Table: IN_RT_POLICY_OBJ Index: RT_PO_IDX05

Table: IN_RT_POLICY_OBJ Index: RT_PO_IDX06

Table: IN_RT_POLICY_OBJ Index: RT_PO_IDX07 Table: IN_RT_POLICY_OBJ Index: RT_PO_IDX08

Table: IN_RT_SET Index: RT_SET_IDX09

Table: IN_RT_SET Index: RT_SET_IDX10

Table: IN_RT_TIME_PERIOD Index: RT_TP_IDX03

Table: IN_SC_GROUP Index: SC_GROUP_IDX05

Table: IN_SC_GROUP Index: SC_GROUP_IDX06 Table: IN_SC_USR Index: SC_USR_IDX07

Table: IN_SEQUENCE Index: SEQUENCE_IDX02

Table: IN_SUBOB_TEMPL Index: SUBOB_TEMPL_IDX_05 Table: IN_TASK_TEMPLATE Index: TASK_TEMPL_IDX14

Table: IN_VIEW Index: VIEW_IDX09

Table: IN_VSL_RULE Index: RULE_IDX03

Table: IN_WF_INTEGRATION_QUEUE Index: WIQ_IDX04

Table: IN_WF_ITEM Index: WF_ITEM_IDX_14

Table: IN_WF_PROCESS Index: WF_PROCESS_IDX_04

Table: IN_WS_DATA_DEF Index: WS_DATA_DEF_IDX03

Table: IN_WS_FILE Index: WS_FILE_IDX_04

Table: IN_WS_PRES Index: WS_PRES_IDX_03

New Index Columns:

Table: IN_LIC_TOKEN Index: LIC_TOKEN_IDX02 Column: ACCESS_TIME

Table: IN_PROJ_TYPE Index: PROJ_TYPE_IDX_02 Column: PROJ_TYPE_NAME

New Foreign Keys:

Table: IN_CAPTURE_SOURCE_OUTLOOK FKey: FK_CAPSO_ICT_ID

Table: IN_CONTEXT_MAP_ITEM_SRC FKey: FK_CMIS_RC_ID

Table: IN_ELEMENT_TYPE FKey: FK_ET_D_ID

Table: IN_FAX_RECIPIENT FKey: FK_FR_D_ID

Table: IN_LIC_MON FKey: FK_LIC_MON_AG_ID

Table: IN_LIC_MON FKey: FK_LIC_MON_LUG_ID

Table: IN_LIST_ITEM FKey: FK_LIST_ITEM_D_ID

Table: IN_RT_AUTHORITY FKey: FK_RTA_D_ID

Table: IN_RT_HOLD FKey: FK_RHOLD_D_ID

Table: IN_RT_OFFLINE_LOC FKey: FK_RTOL_D_ID

Table: IN_RT_POLICY FKey: FK_RP_D_ID

Table: IN_RT_SET FKey: FK_RSET_PO_ID

Table: IN_RT_TIME_PERIOD FKey: FK_RTTP_D_ID

Table: IN_SC_USR FKey: FK_SCU_LUG_ID

Table: IN_VSL_RULE FKey: FK_VR_D_ID

Table: IN_WF_ITEM FKey: FK_WI_INSTANCE_ID

New Columns:

Table: IN_CAPTURE_SOURCE Column: CATEGORY

Table: IN_CONTEXT_MAP_ITEM_SRC Column: RECORD_CATEGORY_ID

Table: IN_DEPT Column: DEPT_PREFIX

Table: IN_ELEMENT_TYPE Column: DEPT_ID

Table: IN_FAX_RECIPIENT Column: DEPT_ID

Table: IN_LIC_MON Column: CLIENT_TYPE

Table: IN_LIC_MON Column: ALLOC_GROUP_ID

Table: IN_LIC_MON Column: LIC_USR_GROUP_ID

Table: IN_LIC_TOKEN Column: ACCESS_TIME

Table: IN_LIST_ITEM Column: DEPT_ID

Table: IN_LM_APP_PLAN Column: CATEGORY

Table: IN_PHSOB Column: FILE_SIZE

Table: IN_PHSOB Column: CHECKSUM

Table: IN_PHSOB Column: CHECKSUM_TYPE

Table: IN_PHSOB Column: VERIFY_TIME

Table: IN_PHSOB Column: VERIFY_STATE

Table: IN_PROJ Column: CLOSED_STATUS

Table: IN_PROJ Column: IS_UNDER_POLICY

Table: IN_PROJ Column: HAS_PHS_FILE_REF

Table: IN_RT_AGENT_STATE Column: JOB_STATE

Table: IN_RT_AGENT_STATE Column: LAST_RUN_TIME

Table: IN_RT_AUTHORITY Column: DEPT_ID

Table: IN_RT_HOLD Column: DEPT_ID

Table: IN_RT_OFFLINE_LOC Column: DEPT_ID

Table: IN_RT_POLICY Column: DEPT_ID

Table: IN_RT_POLICY_OBJ Column: EST_CUTOFF_TIME

Table: IN_RT_POLICY_OBJ Column: EST_CUTOFF_CALC_TIME

Table: IN_RT_POLICY_OBJ Column: EST_DISPOSITION_TIME

Table: IN_RT_POLICY_OBJ Column: EST_DISPOSITION_CALC_TIME

Table: IN_RT_SET Column: POLICY_OBJ_ID

Table: IN_RT_SET Column: PATH_OBJ_ID

Table: IN_RT_TIME_PERIOD Column: DEPT_ID

Table: IN_SC_GROUP Column: IS_GLOBALLY_VISIBLE

Table: IN_SC_USR Column: LIC_USR_GROUP_ID

Table: IN_VSL_RULE Column: DEPT_ID

Table: IN_WF_ITEM Column: INSTANCE_ID

Removed Tables:

IN_ADDENDUM_TEMPLATE IN_ADDENDUM_TEMPLATE_DATA IN_RC_ADDRESSEE IN_RC_FOLDER IN_RC_FOLDER_POLICY IN_RC_FOLDER_TYPE IN_RC_FOLDER_TYPE_LIST IN_RC_FOLDER_TYPE_LIST_MEMBER IN_RC_METADATA IN_RC_METADATA_ADDRESSEE IN_RC_METADATA_INSTANCE

Removed Columns:

Table: IN_AUDIT_TEMPLATE Column: DEPT_ID

Table: IN_DEPT Column: IS_ACTIVE

Table: IN_RS Column: DEPT_ID

Table: IN_RT_HOLD_RESOLVED Column: HOLD_STATE

Table: IN_SCRIPT Column: DEPT_ID

Remove Indexes:

Table: IN_RT_HOLD_RESOLVED Index: RT_HRES_IDX02

Table: IN_SC_GROUP Index: SC_GROUP_IDX04

Removed Index Columns:

Table: IN_AUDIT_TEMPLATE Index: AT_IDX02 Column: TEMPLATE_NAME

Table: IN_DOC_TYPE_LIST_REL Index: DTLR_IDX02 Column: SEQ_NUM

Table: IN_LIC_MON Index: LIC_MON_IDX03 Column: LOGIN_TIME

Table: IN_LM_SCREEN_CONTEXT_MAP Index: LM_SCM_IDX02 Column: SCREEN_ID

Table: IN_SC_GROUP Index: SC_GROUP_IDX02 Column: GROUP_NAME

Removed Foreign Keys:

Table: IN_AUDIT_TEMPLATE FKey: FK_AT_D_ID

Table: IN_PHSOB FKey: FK_PO_FORM_ID

Table: IN_RS FKey: FK_RS_DEPT_ID

Table: IN_SCRIPT FKey: FK_S_DEPT_ID

Mismatch Column Names:

Table: IN_CAPTURE_SOURCE_OUTLOOK Column: ATTACHMENT_MODE Column: STORAGE_MODE

Table: IN_CAPTURE_SOURCE_OUTLOOK Column: AUTO_CAPTURE_MODE Column: CONTENT_MODE

Table: IN_DOC Column: IS_PROTECTED Column: PROTECTION_STATUS

Table: IN_DOC_TYPE Column: IS_RECORD_TYPE Column: CATEGORY

Table: IN_PROJ Column: IS_PROTECTED Column: PROTECTION_STATUS

Mismatch Column Length - Table: IN_MESSAGE Column: SENDER Length: 31 Length: 40

Mismatch Column Nullable - Table: IN_APPROVAL_SET Column: PROJ_ID Nullable: FALSE Nullable: TRUE

Mismatch Index Name - Table: IN_FORM Index: XIE1IN_FORM Index: FORM_IDX02

Mismatch Index Uniqueness:

Table: IN_DOC_TYPE_LIST_REL Index: DTLR_IDX02 Unique: TRUE Unique: FALSE

Table: IN_FAX_RECIPIENT Index: FAX_REC_IDX02 Unique: FALSE Unique: TRUE

Table: IN_LM_SCREEN_CONTEXT_MAP Index: LM_SCM_IDX02 Unique: FALSE Unique: TRUE

Mismatch Index Column Names:

Table: IN_AUDIT_TEMPLATE Index: AT_IDX02 Column: DEPT_ID Column: TEMPLATE_NAME

Table: IN_DOC_TYPE Index: DOC_TYPE_IDX2 Column: IS_RECORD_TYPE Column: CATEGORY

Table: IN_DOC_TYPE_LIST_REL Index: DTLR_IDX02 Column: PARENT_DOC_TYPE_LIST_ID Column: SEQ_NUM

Table: IN_PROJ_TYPE Index: PROJ_TYPE_IDX_02 Column: PROJ_TYPE_NAME Column: CATEGORY

Table: IN_SC_GROUP Index: SC_GROUP_IDX02 Column: DEPT_ID Column: GROUP_NAME

Created Tables:

IN_OSM_PLUGIN

IN_OSM_PLUGIN_PROP

IN_OSM_TREE_EXT

IN_OSM_TREE_EXT_PROP

Created Columns - Table: IN_PHSOB:

PHSOB_VER

ENCRYPTION_TYPE

Removed Columns – Table: IN_OSM_TREE

MIRRORING_ON

RETRIEVE_TREE

TREE_PATH

TREE_PATH_MIRROR

NEXT_SLOT

MEDIA_TYPE

MIRROR_MEDIA_TYPE

FILES_PER_DIR

RETRIES

DELAY

OSM_INTEGRATION

OBJ_COUNT

IN_CAPTURE_SOURCE_PROP

Removed Tables:

IN_APPLET IN_CAPTURE_SOURCE_FILE IN_CAPTURE_SOURCE_SCANNER IN_DEP_APPROVAL_DEF_USR IN_DEP_CONTEXT_MAP_ITEM IN_DEP_USR_APP_PLAN_PRIV IN_DEP_USR_BATCH_CREATOR_PRIV IN_DEP_USR_BATCH_DOC_TYPE_P IN_DEP_USR_BATCH_DRAWER_PRIV IN_DEP_USR_CAPTURE_PROFILE_P IN_DEP_USR_CAPTURE_SOURCE_P IN_DEP_USR_DOC_TYPE_PRIV IN_DEP_USR_DRAWER_PRIV IN_DEP_USR_GROUP IN_DEP_USR_OUTPUT_PROFILE IN_DEP_USR_PRIV IN_DEP_USR_PROCESS_PRIV IN_DEP_USR_PROJ_TYPE_PRIV IN_DEP_USR_QUEUE_PRIV IN_DEP_USR_ROUTE_PRIV IN_DEP_USR_ST_PRES_PRIV IN_DEP_USR_SUBOB_TEMPL_PRIV IN_DEP_USR_TASK_TEMPLATE_P IN_DEP_USR_VIEW_PRIV IN_DEVICE_KOFAX IN_DEVICE_PIXEL IN_DEVICE_TWAIN IN_KOFAX_ADV_PROP IN_SCAN_DEVICE IN_TEMPLATE IN_TEMPLATE_CLIPBOARD IN_TEMPLATE_HYPERLEARN IN_TEMPLATE_HYPERLEARN_KEY IN_TEMPLATE_IE_KEY IN_TEMPLATE_KEY_PROPS IN_TEMPLATE_MSWINDOWS IN_TEMPLATE_MSWINDOWS_KEY IN_TEMPLATE_NEURAL_NET_KEY IN_TEMPLATE_PROPS IN_TEMPLATE_SCRIPT IN_TEMPLATE_TERMCAP_KEY IN_TEMPLATE_WINDOWTEXT IN_TEMPLATE_WINDOWTEXT_KEY IN_USR_APPLET_PRIV IN_USR_LIST IN_USR_LIST_ITEM IN_USR_PROXY IN_USR_PROXY_HIST IN_USR_SUBOB_PRIV

OSM_TREE_IDX04

Created Column - Table: IN_OSM_TREE: OSM_TREE_NAME

Removed Tables:

IN_CAPTURE_IP_FILTER IN_IMAGE_PROC_FILTER

IN_IP_FILTER_PROP

Removed Column - Table:

IN_OSM_REDIR:

REDIR_LOGIC

ENCRYPTION_TYPE

Created Index - Table: IN_LIC_TOKEN:

LIC_TOKEN_IDX05

Created Column - Table: IN_LIC_TOKEN:

HWFP

Removed Table:

IN_LIC_TOKEN_HWFP

IS_RFA_DEST

OSM_CTRL_IDX06

New Column - Table: IN_OSM_SET:

Removed Table:

Primary Key Constraint and Index Renames This incremental includes the renaming of the primary key constraint for most of the tables in the schema to implement a standard naming convention for all primary key constraints.

IN_MESSAGE

IN_MESSAGE_QUEUE

IN_MESSAGE_QUEUE_MASTER

IN_CONTENT

IN_CONTENT_BATCH

IN_DOC_CONTENT

Reordered Columns in the IN_DOC table.

Column Renames:

Table: IN_DOC Original Value: "DELETION_STATUS" New Value: "EVENT_REVISION"

Column Nullability:

Table: IN_DOC Column: "INSTANCE_ID" Original Value: "NULL" New

Value: "NOT NULL"

Table: IN_DOC Column: "DRAWER_ID" Original Value: "NULL" New

Value: "NOT NULL"

Table: IN_DOC Column: "DOC_TYPE_ID" Original Value: "NULL" New

Value: "NOT NULL"

Columns Dropped:

Table: IN_DOC Column: "CREATION_USR_ID"

Table: IN_DOC Column: "CREATION_TIME"

Table: IN_DOC Column: "MOD_USR_ID"

Table: IN_DOC Column: "MOD_TIME"

Table: IN_DOC Column: "DELETION_TIME"

Table: IN_DOC Column: "DELETION_USR_ID"

Indexes Dropped:

DOC_IDX3

DOC_IDX10

DOC_IDX12

New Table: IN_MESSAGE

New Index - Table: IN_PHSOB Index: PHSOB_IDX10

New Sequence: IN_MESSAGE_SEQUENCE

Indexes Dropped:

Table: IN_PHSOB Index: PHSOB_IDX04

Table: IN_PHSOB Index: PHSOB_IDX05

Table: IN_PHSOB Index: PHSOB_IDX08

New Tables:

IN_LIC_PACKAGE

IN_LIC_PACKAGE_CLAIM

IN_SC_LOGIN_PROFILE

IN_SC_LOGIN_PROFILE_TRUSTED_PK

Column Removed:

Table: IN_TASK_TEMPLATE Column: ATTACH_WEBNOW_LINK

Renamed Indexes:

Table: IN_INSTANCE_PROP Index: Original Name: "INST_PROP_IDX_03" New Name: "INSTANCE_PROP_IDX_03"

Table: IN_INSTANCE_PROP Index: Original Name: "INST_PROP_IDX_04" New Name: "INSTANCE_PROP_IDX_04"

New Indexes:

Table: IN_LIC_MON Index: LIC_MON_IDX07

Table: IN_INSTANCE_PROP Filtered Index: INSTANCE_PROP_IDX_01 - Filter on WHERE (IS_NULL = 1) (SQL Server and PostgreSQL Only)

Indexes Removed:

Table: IN_ERM_DOC Index: CN_DOC_IDX02

Table: IN_ERM_DOC Index: CN_DOC_IDX04

Table: IN_ERM_DOC Index: CN_DOC_IDX05

Table: IN_ERM_DOC Index: CN_DOC_IDX06

Table: IN_ERM_DOC Index: CN_DOC_IDX07

Table: IN_ERM_DOC Index: CN_DOC_IDX08

Table: IN_ERM_DOC Index: CN_DOC_IDX09

Table: IN_ERM_DOC Index: CN_DOC_IDX10

Table: IN_ERM_DOC Index: CN_DOC_IDX11

Table: IN_ERM_DOC Index: CN_DOC_IDX12

Table: IN_ERM_DOC Index: CN_DOC_IDX13

Table: IN_ERM_REPORT_COL Index: CN_REPORT_COL_IDX02

Table: IN_ERM_SPOOL Index: CN_SPOOL_IDX03

Table: IN_ERM_SPOOL Index: CN_SPOOL_IDX05

SQL Server and PostgreSQL Only

Indexes Recreated as Filtered Indexes

Table: IN_INSTANCE_PROP Index: INSTANCE_PROP_IDX_02 - Filter on WHERE (STRING_VAL IS NOT NULL)

Table: IN_INSTANCE_PROP Index: INSTANCE_PROP_IDX_03 - Filter on WHERE (IS_NULL = 0)

Table: IN_INSTANCE_PROP Index: INSTANCE_PROP_IDX_04 - Filter on WHERE (TIME_VAL <> '1970-01-01 00:00:00.000'

New Tables:

IN_LIC_POLICY_LEASE

New Indexes:

Table: IN_DOC Index: DOC_IDX10

Table: IN_DOC Index: DOC_IDX11

Table: IN_DOC Index: DOC_IDX12

New Columns:

Table: IN_DOC Column: CREATION_TIME

Table: IN_TASK_TEMPLATE Column: ATTACH_EXPERIENCE_LINK

New Table:

IN_SC_LPB_USR_LOGIN_ALLOW

New Column:

Table: IN_SC_LOGIN_PROFILE Column: LOGIN_PROFILE_TYPE

Column Change:

Table: IN_AUDIT_DETAIL Column: DETAIL_VALUE Length increased from VARCHAR(256) to VARCHAR(MAX) / CLOB (Oracle)

Index Changes:

Column Added to Index - Table: IN_SC_LOGIN_PROFILE Index: SC_LOGIN_PROFILE_IDX02 Column: LOGIN_PROFILE_TYPE

Column Removed from Index - Table: IN_AUDIT_DETAIL Index: AUDIT_DETAIL_IDX03 Column: DETAIL_VALUE

New Tables:

IN_CUSTOM_PROP_JOB

IN_CUSTOM_PROP_JOB_BATCH

IN_CUSTOM_PROP_JOB_BATCH_ITEM

IN_CUSTOM_PROP_JOB_PARAM

IN_DIG_SIG_SETTINGS

IN_TIMING_CLIENT_SETTINGS

New Indexes:

Table: IN_ACTION_GROUP Index: ACTION_GROUP_IDX_01

Table: IN_AUDIT Index: AUDIT_IDX_01

Table: IN_CLASS_PROP Index: CLASS_PROP_IDX5

Table: IN_SC_CONNECTION Index: SC_CONNECTION_IDX03

Table: IN_SC_SESSION Index: SC_SESSION_IDX04

Table: IN_SUBOB Index: SUBOB_IDX02

Table: IN_WF_QUEUE Index: WF_QUEUE_IDX_07

Table: IN_WF_QUEUE Index: WF_QUEUE_IDX_08

New Index Columns:

Table: IN_CLASS_PROP Index: CLASS_PROP_IDX3 Column: STATE

Table: IN_EXTERN_MSG Index: EXTERN_MSG03 Column: MSG_STATUS

Table: IN_EXTERN_MSG Index: EXTERN_MSG03 Column: MSG_TYPE

Table: IN_EXTERN_MSG Index: EXTERN_MSG03 Column: AGENT_LOCK

Table: IN_EXTERN_MSG Index: EXTERN_MSG03 Column: START_TIME

Table: IN_LIC_MON Index: LIC_MON_IDX03 Column: IS_ACTIVE

Table: IN_PHSOB_CACHE Index: PHSOB_CACHE_IDX03 Column: CACHE_STATE

Table: IN_PHSOB_CACHE Index: PHSOB_CACHE_IDX03 Column: ACCESS_TIME

New Column:

Table: IN_CLASS_PROP Column: STATE

Missing Indexes:

Table: IN_DOC Index: DOC_IDX7

Table: IN_PHSOB Index: PHSOB_IDX02

Table: IN_PHSOB_CACHE Index: PHSOB_CACHE_IDX04

Table: IN_SUBOB Index: SUBO_IDX02

Mismatch Index Names:

Table: IN_BATCH_ATTACHMENT Index: XIE1IN_BATCH_ATTACHMENT Index: BATCH_ATTACHMENT_IDX_03

Table: IN_BATCH_PAGE_REC_ZONE Index: XAK1IN_BPRZ_IDX_02 Index: BATCH_PAGE_REC_ZONE_IDX_02

Table: IN_LIC_OVERDRAFT Index: XIE2IN_LIC_OVERDRAFT Index: LIC_OVERDRAFT_IDX_03

Table: IN_SC_CONNECTION Index: SC_CONN_IDX02 Index: SC_CONNECTION_IDX02

Table: IN_SUBOB Index: SUBO_IDX03 Index: SUBOB_IDX03

Table: IN_WF_QUEUE_ALARM Index: XIE1IN_WF_QUEUE_ALARM Index: WF_QUEUE_ALARM_IDX_02

Table: IN_WF_QUEUE_ALARM Index: XIE2IN_WF_QUEUE_ALARM Index: WF_QUEUE_ALARM_IDX_03

Table: IN_WF_QUEUE_ALARM Index: XIE3IN_WF_QUEUE_ALARM Index: WF_QUEUE_ALARM_IDX_04

Table: IN_WF_ROUTE_DEST Index: XIE1IN_WF_ROUTE_DEST Index: WF_ROUTE_DEST_IDX_02

Table: IN_WF_ROUTE_DEST Index: XIE2IN_WF_ROUTE_DEST Index: WF_ROUTE_DEST_IDX_03

Table: IN_WS_PRES_FILE Index: XIE1IN_WS_PRES_FILE Index: WS_PRES_FILE_IDX_02

Mismatch Index Column Name:

Table: IN_EXTERN_MSG Index: EXTERN_MSG03 Column: START_TIME Column: MSG_DIRECTION

Mismatch Sequence Cache Size:

Sequence: IN_MESSAGE_SEQUENCE Cache Size: 20 Cache Size: 2000