Working With the EDM for Sun Master Index

Viewing Object Profile Information on the EDM

The View/Edit page displays object profiles in a series of pages you can select and view. You can view information associated with any of the SBR or system record components in an object profile. The SBR contains the information that is determined to be the most current and accurate information about that object from all external systems. By default, when the View/Edit page first appears, the SBR is visible and the system record information is not shown.

The system records associated with a profile contain information that is stored in the external systems that share information with the master index application. The information in a system record might not match the information in the SBR. You can view several different types of information about an object, including the following:

Viewing Object Profiles on the EDM

The View/Edit page displays object profiles in a series of pages you can select and view. You can view information associated with any of the SBR or system record components in an object profile. The SBR contains the information that is determined to be the most current and accurate information about that object from all local systems. By default, when the View/Edit page first appears, information in the SBR is visible.

The system records associated with a profile contain the information that is stored in the external systems that share information with the master index application. The information in an object’s system records might not match the information stored in the object’s SBR.

Figure 17 View/Edit Page - SBR

Figure shows the View/Edit page of the EDM.

ProcedureTo View Object Information

  1. Using one of the search methods described in Searching for Object Profiles on the EDM, display the object profile you want to view on the View/Edit page.

  2. To view different types of information in the SBR for the displayed object, do the following:

    1. In the EUID tree in the left portion of the page, expand the SBR until you can see the object type you want to view.

    2. To view the parent object in the SBR, select the first folder in the SBR tree.

    3. To view a child object in the SBR, expand the child object type you want to view and then select any of its sub-folders.

  3. To view different types of information in a system object for the displayed object, do the following:

    1. In the EUID tree in the left portion of the page, expand Source Systems.

    2. Expand the system name and local ID you want to view.

    3. To view the parent object in the system record, select the first folder under the expanded system name and local ID.

    4. To view a child object in the system record, expand the child object type you want to view and then select any of its sub-folders, as shown in Figure 18.

      Figure 18 View/Edit Page - System Records

      Figure shows a sample child object on the View/Edit page.
In this case, it is an Address object.

  4. From the View/Edit page, you can do any of the following:

    1. To modify object information, follow the appropriate procedure under Modifying Profile Information on the EDM.

    2. To view a history of transactions for the displayed profile, click Transaction History in the upper portion of the View/Edit page (for more information, see Viewing a Profile's Transaction History on the EDM).

    3. To view potential duplicates of the displayed profile, click Potential Duplicate in the upper portion of the View/Edit page (for more information, see Working with Potential Duplicate Profiles on the EDM).

    4. To view detailed information for the following object in the search results list, click Next> in the upper portion of the page.

    5. To view detailed information for the preceding object in the search results list, click <Previous in the upper portion of the page.

Comparing Object Information on the EDM

Using the Comparison function of the EDM, you can compare two object profiles side-by-side to check for similarities and differences. You can also compare different components of the same object profile. From the EUID trees, you can select the type of information to view and whether to view SBR or system record information.

Comparing two Object Profiles

To compare two different object profiles, you must perform a search for the profiles to compare and then select them from the results list. The Comparison page contains an EUID tree on each side of the page, one for each profile you are comparing.

Figure 19 Comparison Page - Two Object Profiles

Figure shows the Comparison page with differences between
two profiles highlighted.

ProcedureTo Compare two Object Profiles

  1. Perform a search for the object profiles you want to compare, as described in Searching for Object Profiles on the EDM.


    Note –

    If you know the EUIDs of the object profiles to compare, use the Comparison Lookup to retrieve those profiles.


  2. On the search results list, select the check boxes to the left of the two object profiles you want to compare.

    Figure 20 Selecting Two Profiles to Compare

    Figure shows how to select two profiles to compare from
a search results list.

  3. In the first cell of the results table, click Compare Records.

    The Comparison page appears with SBR information displayed with any differences between the two profiles highlighted.

  4. To view and compare different types of information, select the type of information you want to view from the EUID trees on both sides of the page (for more information, review the instructions under Viewing Object Profiles on the EDM).


    Note –

    If you select different types of information from the two sides, differences are not highlighted (for example, if you view SBR address data on one side and system record address data on the other side; or if you view SBR address data on one side and SBR phone data on the other).


  5. To merge object information, do either of the following:

Comparing Records in one Object Profile

To compare different components of one object profile, you must perform a search for that profile and then select it from the results list. The Comparison page contains an EUID tree on each side of the page, both containing the most current version of the profile you are comparing.

Figure 21 Comparison Page - One Object Profile

Figure shows two profiles in a side-by-side comparison
with differences between the two highlighted.

ProcedureTo Compare Records in one Object Profile

  1. Perform a search for the object profile you want to view, as described in Searching for Object Profiles on the EDM.

  2. On the search results list, select the check box to the left of the object profile you want to compare.

    Figure 22 Selecting one Profile to Compare

    Figure shows how to select one profile to compare its
different components.

  3. In the first cell of the results table, click Compare Records.

    The Comparison page appears with SBR information displayed.

  4. To view and compare different types of information, select the type of information you want to view from the EUID trees on both sides of the page (for more information, review the instructions under Viewing Object Profiles on the EDM).


    Note –

    If you select different types of information from the two sides, differences are not highlighted (for example, if you view SBR address data on one side and system record address data on the other side; or if you view SBR address data on one side and SBR phone data on the other). However, if you view two different types of addresses the differences are highlighted.


  5. To merge two system records in the displayed object profile, see Merging System Records on the EDM.

Viewing a Profile's Transaction History on the EDM

Using the History function, you can view historical information for a specific object, and compare the object’s profile before and after a specific transaction occurred to determine what information was modified as a result of the transaction. The Transaction History page contains an EUID tree for the before image and one for the after image. From the EUID trees you can specify the type of information to view and whether to view SBR or system record information.

The image on the left side of the Transaction History Comparison page reflects the object’s information before the transaction occurred. The image on the right reflects the object’s information after the transaction occurred. If the displayed record has no historical data, then the message “There is nothing to show in this area.” appears in the left side of the page.


Note –

In addition to the instructions given here, you can also access a transaction history by performing a search for an object profile, displaying the profile on the View/Edit page, and then clicking Transaction History.


Figure 23 Transaction History Comparison Page

Figure shows a comparison of a profile before and after
a specific transaction occurred.

ProcedureTo View a Transaction History

  1. Obtain information about the object, such as the EUID, a system in which the object was registered, or a specific transaction performed against the object’s profile.

  2. On the EDM main menu, click History.

    The Transaction History Search page appears.

    Figure 24 Transaction History Search Page

    Figure shows the Transaction History Search page.

  3. Select History Search from the Search Types drop-down list.

  4. Do one of the following:

    • To search for a record by system and local ID, enter the system and local ID in the upper section of the window and then click Lookup EUID.

      If an EUID is found, it is populated into the EUID field in the Search Criteria section.

    • To search by EUID or transactional information, enter the search criteria for the object you want to view (for more information, see About Transaction History Search Fields on the EDM).

  5. On the Transaction History Search page, click Search.

    If more than one transaction matches the search, the Transaction History Result page appears with a list of matching profiles (for more information, see About Transaction History Results Fields on the EDM).

    Figure 25 Transaction History Results

    Figure shows the results of a transaction history search.

  6. If the Transaction History Result page appears, click the transaction number of the transaction you want to view.


    Note –

    If an asterisk appears next to a transaction, it means the transaction history cannot be accessed.


    The Transaction History Comparison page appears, displaying information in the SBR with any differences between the before and after image highlighted in blue.

  7. Select the type of information you want to view from the EUID trees on both sides of the page (for more information, review the instructions under Viewing Object Profiles on the EDM).


    Note –

    If you select different types of information from the two sides, differences are not highlighted (for example, if you view SBR address data on one side and system record address data on the other side; or if you view SBR address data on one side and SBR phone data on the other).


  8. If you are viewing a merge transaction, additional options appear in the upper left portion of the page, allowing you to view different images for the transaction (see Figure 26).

    • Select the first EUID to view the before image of the surviving profile.

    • Select the second EUID to view the before image of the non-surviving profile.

      Figure 26 Transaction History for Merge

      Figure shows the EUID toggle buttons for a merge transaction
in a transaction history.

  9. If you are viewing an unmerge transaction, additional options appear in the upper right portion of the page, allowing you to view different images for the transaction (see Figure 27).

    • Select the first EUID to view the after image of the surviving profile.

    • Select the second EUID to view the after image of the non-surviving profile.

      Figure 27 Transaction History for Unmerge

      Figure shows the EUID toggle buttons for an unmerge transaction
in a transaction history.

About Transaction History Search Fields on the EDM

The fields located on the Transaction History Search page allow you to specify search criteria for the transactions you want to view. Note that the “Lookup By Local ID” section is customizable and might have been changed for your implementation.

Table 3 Transaction History Search Fields

In this field … 

type or select ... 

Lookup By Local ID Section

System

The system in which the local ID is known. 

Local ID

The local ID corresponding to the record you want to find and the system selected in the previous field. This field name might be different for your implementation. 

Search Criteria Section

EUID

The object’s enterprise-wide unique identifier assigned by the master index application. 

Function

The type of transaction that caused the object’s profile to change. See Table 5 for more information about transaction types.

From Date

The beginning date for the search. The query is performed for transactions that fall between the From Date and To Date. 

From Time

The beginning time for the search using 24-hour notation. The query is performed for transactions that fall between the From Time and To Time on the specified dates. If no time is entered, the default value is 00:01 (12:01 A.M.). 

To Date

The ending date for the search. 

To Time

The ending time for the search using 24-hour notation. If no time is entered, the default value is 24:00. 

System User

The login ID of the user who performed the transaction for which you are searching. 

About Transaction History Results Fields on the EDM

The fields located on the Transaction History Result page help you identify a specific object profile and transaction to view. Additional fields might be added to this page by the system administrator. The LID fields are configurable and might have been changed for your implementation.

Table 4 Transaction History Results Fields

This field … 

displays this information … 

Transaction No

The sequential identification code of the transaction that caused the transaction history record. 

EUID1

The enterprise-wide unique identification number of the first object profile involved in the transaction. 

EUID2

The enterprise-wide unique identification number of the second object profile involved in the transaction. 

System

The name of the system in which the transaction that created the history record occurred. 

LID1

The local ID of the first system record involved in the transaction. 

LID2

The local ID of the second system record involved in the transaction. This is only used for system record merges, unmerges, and transfers. 

Function

The type of transaction that changed the object profile and caused the history record to be written. See Table 5 for a description of each transaction type.

System User

The login ID of the user who performed the transaction. 

Timestamp

The date and time the transaction occurred. 

Transaction History Transaction Types on the EDM

Each transaction performed by the master index application is assigned a transaction type, indicating the type of action that was performed. Table 5 lists and describes each transaction type.

Table 5 Transaction Type Descriptions

Transaction Type 

Description 

Add

This transaction type is assigned when a new object profile is added to the database, whether it is through a direct add or through reversing an assumed match. 

EUID Activate

This transaction type is assigned when a deactivated object profile is reactivated. 

EUID Deactivate

This transaction type is assigned when an active object profile is deactivated. 

EUID Merge

This transaction type is assigned when two object profiles are merged. 

EUID Unmerge

This transaction type is assigned when two object profiles are unmerged. 

System Record Merge

This transaction type is assigned when two system records are merged. 

System Record Transfer

This transaction type is assigned when a system record is transferred from one object profile to another. 

System Record Unmerge

This transaction type is assigned when two system records are unmerged. 

Update

This transaction type is assigned when an object profile is modified in any way other than those described above. This includes such transactions as modifying an object profile, reversing an assumed match, deactivating or reactivating a system record, and adding or removing a child object (such as an address or telephone number). 

Viewing a Profile's Merge History on the EDM

When an object profile is displayed on the Transaction History page, you can display a history of all merges performed against the profile, allowing you to trace the origin of certain information contained in the profile. You can view a history for each merge transaction in the merge history tree.

Viewing a Merge History Tree

The master index application tracks all merges performed against each object profile in the database. You can view a history of merges that affect a specific object profile and you can view each EUID that was merged to form the final merge result profile. The merge history appears in a tree structure in the left portion of the Merge History page, showing each pair of profiles that were merged under the displayed object profile. In the right portion of the page, transaction details appear for the EUID that is highlighted in the merge history tree.

Figure 28 Merge History Tree

Figure shows a profile's merge history tree.

ProcedureTo View an Object’s Merge History

  1. On the Transaction History Search page, perform a search for the object whose merge history you want to view (for more information, see Viewing a Profile's Transaction History on the EDM).

  2. On the Transaction History Result page, click the transaction number to the left of the EUID whose merge history you want to view.

    The Transaction History page appears.

  3. In the upper portion of the page, click Merge Tree (if Merge Tree is not visible, the EUID does not have a merge history to view).

    The Merge History page appears with the merge tree on the left and transaction summaries in the right.

  4. To view a summary of merge transactions for a merged profile, select the EUID of that profile from the merge history tree.

    The transaction summary appears in the right portion of the page.

  5. To view transaction information for two merged profiles, click the profile above the merged pair.

    Transaction information appears in the right portion of the page.

Viewing an Object Profile From a Merge History Tree

When you view an object’s merge history, you can also view a transaction history of any merged pair in the merge history list. The profiles you display from the merge history list contain the information about the profile before the merge occurred.

ProcedureTo View an Object Profile From a Merge History Tree

  1. Display a merge history tree, as described in Viewing a Merge History Tree.

  2. Expand the merge history tree in the left portion of the Merge History page until you see the EUID of the object profile you want to view, and then select that EUID.

  3. In the transaction list in the right portion of the page, click the transaction ID for the merge transaction you want to view.

    The Transaction History page appears, displaying transaction details for the transaction you selected.

Viewing the EDM Audit Log

Using the Audit Log function, you can view a record of each instance an EDM user accessed information about any object in the master index database. The audit log includes instances in which an object profile appeared in a search results list; was viewed or compared; was added, updated, or deactivated; or was merged or unmerged. The audit log can be enabled or disabled by the system administrator.

Figure 29 Audit Log Detail page

Figure shows the Audit Log Detail page.

ProcedureTo View the Audit Log

  1. Obtain information about the instances you want to view, such as the EUID, a time frame for when they occurred, the type of function that caused the audit log entries, the user who performed the functions, and so on.

  2. On the EDM main menu, click History.

    The History Search page appears with the Transaction History Search page displayed.

  3. Select Audit Log Search from the Search Types drop-down list.

    Figure 30 Audit Log Search Page

    Figure shows the Audit Log Search page.

  4. Do one of the following:

    • To search for a profile by system and local ID, enter the system and local ID in the upper section of the window and then click Lookup EUID.

      If an EUID is found, it is populated into the EUID field in the Search Criteria section.

    • To search by EUID or transactional information, enter the search criteria for the object you want to view (for more information, see About Audit Log Search Fields on the EDM).

  5. In the right portion of the page, click Search.

    The Audit Log Result page appears with a list of instances in which the data was accessed. For information about the fields displayed on this page, see About Audit Log Results Fields on the EDM.

    Figure 31 Audit Log Result Page

    Figure shows the results of an audit log search.

  6. To view additional information about a specific Audit Log entry, click an EUID in the row containing the entry you want to view.

    The View/Edit page appears.

  7. To view details for the previous entry in the results list, click <Previous.

  8. To view details for the following entry in the results list, click Next>.

About Audit Log Search Fields on the EDM

The fields located on the Audit Log Search page allow you to enter search criteria about the audit log entries you want to view.

Table 6 Audit Log Search Fields

In this field … 

type or select ... 

Lookup By Local ID Section

System

The system of the system in which the local ID is known. 

Local ID

The local ID corresponding to the record you want to find and the system selected in the previous field. This field name might be different for your implementation. 

Search Criteria Section

EUID

The object’s enterprise-wide unique identifier assigned by the master index application. 

Type

The category type for the records whose audit log entries you want to view. 

Function

The type of transaction that created the audit log entries you want to view. For more information about transaction types, see Audit Log Functions on the EDM.

Create User

The login ID of the user whose transactions you want to view. 

From Date

The beginning date for the search. The query is performed for audit log entries that fall between the From Date and To Date. 

From Time

The beginning time for the search using 24-hour notation. The query is performed for audit log entries that fall between the From Time and To Time on the specified dates. If no time is specified, the default value is 00:01 (12:01 A.M.). 

To Date

The ending date for the search. 

To Time

The ending time for the search using 24-hour notation. If no time is specified, the default value is 24:00. 

About Audit Log Results Fields on the EDM

The fields located on the Audit Log Result page display information about the instances in which object data was accessed, where those instances match the search criteria you entered.

Table 7 Audit Log Results Fields

This field … 

displays this information ... 

Audit ID

The unique ID code in the audit log for the audit log entry. 

EUID1

The EUID of the first object profile whose information was accessed. 

EUID2

The EUID of the second object profile whose information was accessed in the same transaction (as would occur in the case of a profile comparison or merge). 

Type

The category type of the object represented by the EUID. 

Function

The primary transaction type that was used to access information. For more information about transaction types, see Audit Log Functions on the EDM

Detail

Specific information about the actions taken against the profile, such as the EDM page that was accessed or the type of function performed against a profile. 

Create User

The login ID of the user who accessed the information. 

Create Date

The date and time that the information was accessed. 

Audit Log Functions on the EDM

The audit log creates an audit entry whenever data is accessed through the EDM. The following table lists and describes each audit log function. Some of these functions refer to the actual viewing of data on an EDM page; others refer to an action taken against that data, such as clicking the merge or unmerge Confirm button or resolving a potential duplicate pair.

Table 8 Audit Log Function Descriptions

Audit Log Function 

Description 

Add

A user added a new object profile to the database from the Create System Record page or by reversing an assumed match. 

Associated Potential Duplicates

A user viewed profile summaries on the Associated Records page of a potential duplicate search. 

Assumed Match Comparison

A user viewed two assumed match profiles on the Assumed Match page. 

Assumed Match Search Result

A user viewed the results of a search for assumed matches. 

Auto Resolve

A user permanently resolved two potential duplicate records on the Potential Duplicate Comparison page. 

EO Comparison

A user viewed two object profiles on the Comparison page. 

EO Search Result

A user viewed profile summaries on the Search Results page after performing a search for object profiles. 

EO View/Edit

A user viewed an object profile on the View/Edit page. 

EUID Merge Confirm

A user initiated a merge of two object profiles. This function refers to when the user views the merge result prior to clicking Confirm. 

EUID Unmerge

A user finalized an unmerge of two object profiles. 

EUID Unmerge Confirm

A user initiated an unmerge of two object profiles. This function refers to when the user views the unmerge result prior to clicking Confirm. 

History Comparison

A user compared the before and after image of an object profile on the Transaction History Comparison page. 

History Search Result

A user viewed the results of a transaction history search on the Transaction History Search Results page. 

LID Merge - Selection

A user initiated a merge of two system records. This function refers to when the user has selected LID Merge but has not finalized the merge. 

LID Merge Confirm

A user finalized a merge of two system records. 

LID Unmerge

A user finalized an unmerge of two system records. 

LID Unmerge Confirm

A user initiated an unmerge of two system records. This function refers to when the user views the unmerge result record prior to clicking Confirm. 

Matching Review Search Result

A user viewed the results of a search for potential duplicates. 

Merge

A user finalized a merge of two object profiles or two system records. 

Merge Tree Comparison

A user viewed a merge tree. This function appears for each object profile included in the merge tree. 

Potential Duplicate Comparison

A user viewed two object profiles on the Potential Duplicate Comparison page. 

Resolve

A user resolved two potential duplicate records on the Potential Duplicate Comparison page. 

Undo Assumed Match

A user reversed an assumed match. 

Unmerge Comparison

A user initiated an unmerge of two system records or two object profiles. This function refers to when the user views the unmerge result record prior to clicking Confirm. 

Unresolve

A user changed the status two object profiles on the Potential Duplicate Comparison page from Resolved to Unresolved. 

Update

A user modified a profile on the View/Edit window. Updates include any changes made to a profile, including activating and reactivating system records, adding or removing child objects, and so on. 

View Merge Tree

A user viewed a merge tree.