Pages Used With the Utility

Page Name Definition Name Navigation Usage

Comparison Methods

SCC_DISCREP_METHOD

Set Up SACR, and then System Administration, and then Utilities, and then HCM Integration, and then Comparison Methods

Maintain the list of available methods for comparing table data between two different databases.

Resolution Methods

SCC_DISCREP_APPMTH

Set Up SACR, and then System Administration, and then Utilities, and then HCM Integration, and then Resolution Methods

Maintain the list of methods used to apply winners to resolve data discrepancies.

Data Sources

SCC_DISCREPDSRC

Set Up SACR, and then System Administration, and then Utilities, and then HCM Integration, and then Data Sources

Provide connection information for an external data source.

Database Link Maps

SCC_DISCREP_LNK

Set Up SACR, and then System Administration, and then Utilities, and then HCM Integration, and then Database Link Maps

Define mappings from a record name to a database link record name.

Record Maps

SCC_DISCREP_MAP

Set Up SACR, and then System Administration, and then Utilities, and then HCM Integration, and then Record Maps

Define a view used to compare data for the same table on two different databases. Views may be used instead of the base table when only certain columns or rows are desired for comparison.

Winner Rules

SCC_DISCREP_RULE

Set Up SACR, and then System Administration, and then Utilities, and then HCM Integration, and then Winner Rules

Maintain rule definitions for determining how to resolve data discrepancies between the same table on two different databases.

CS Permission Maps

SCC_PERMISN_MAP

Set Up SACR, and then System Administration, and then Utilities, and then HCM Integration, and then CS Permission Maps

Set comparison and discrepancy resolution security by mapping record names to permission lists in CS.

HCM Permission Maps

HCI_PERMISN_MAP

Set Up Common Objects, and then Common Definitions, and then CS Integration, and then HCM Permission Maps

Set comparison and discrepancy resolution security by mapping record names to permission lists in HCM.

Run Discrepancy Comparison

SCC_DISCREPRCTL

Set Up SACR, and then System Administration, and then Utilities, and then HCM Integration, and then Run Discrepancy Comparison

Run the comparison process to determine data discrepancies in the specified tables between two databases.

Integration Discrepancies

SCC_INTGR_DSCRPNCY

Set Up SACR, and then System Administration, and then Utilities, and then HCM Integration, and then Integration Discrepancies

Display data discrepancies found between the same table on two different databases and specify the winner for resolution.

Discrepancy Details

SCC_INTGR_DSCRFLDS

Click the Show Fields link for any row on the Integration Discrepancies page.

Show data discrepancy details for a selected row.

Resolve Discrepancies

SCC_DISCREP_RUNRUL

Set Up SACR, and then System Administration, and then Utilities, and then HCM Integration, and then Resolve Discrepancies

Run the process to apply the winner rule to all discrepancy rows in the specified table or resolve discrepancies.

Resolution Log

SCC_RESOLVE_LOG

Set Up SACR, and then System Administration, and then Utilities, and then HCM Integration, and then Resolution Log

View a log of transactions that have resolved data discrepancies.

Purge Resolution Log

SCC_RSLVLOGPRUNCTL

Set Up SACR, and then System Administration, and then Utilities, and then HCM Integration, and then Purge Resolution Log

Run the process to delete data discrepancy resolved transaction logs.