Report Components

The cover page of the report shows the report title, the date and time of the report, the data sources that were compared, and the report level of detail that was selected.

The report contains the following components:

Summary by User Defined Code Types (horizontal bar graph).
Differences by Product Code (table).
Report summary (text and table)

Summary by Product Code

A horizontal bar graph at the beginning of the report displays the percentage of UDC differences in each product code.

Differences by Product Code

The Differences by Product Code portion of the report is grouped by product code. Only the product codes with UDC differences display on the report. Under each product code section are UDCs with differences (grouped by UDC, such as 01/PH). A table for each UDC or UDC value with differences shows the differences that were found.

For example, an entire UDC, such as 01/PH, could exist in one environment or data source, but not in the other. Or, if the UDC exists in both locations, some of the code values could be different. For instance, the BUSN code within the 01/PH UDC shown in the following example could be missing in one location or have a different value for one of its fields, such as Description 01.

This is an example of a UDC:

Each UDC with differences displays a table showing the values for the UDC and for any codes within the UDC with differences.

The following columns are shown for the UDC:

Column Heading	Description
Result	The Result column indicates that the UDC has differences.
Product Code	The UDC's product code.
Code Types	The UDC type, which is a code that identifies the table that contains user defined codes. For example, for UDC 01/PH the type is PH.
Description	The UDC description.
Code Length	The maximum length of UDC code values.
Second Line (Y/N)	Determines if the Select User Defined Code form will display a second line of description. Valid values are: Y - Enables the second line of description. N - Enables the Select User Defined Code form to display only one line of description.
Numeric (Y/N)	Determines whether a user defined code is numeric or alphanumeric. Valid values are: Y - Indicates that the code is numeric and should be right-justified. N - Indicates that the code is alphanumeric and should be left-justified.

The following columns are shown for the UDC codes:

Column Heading	Description
Result	The Result column displays one of these values: UDC Codes Different (<1 or 2>) UDC Codes Only in (<1 or 2>) The 1 or 2 value indicates in which environment or data source the difference was found.
Product Code	The UDC's product code.
Code Types	The UDC type, which is a code that identifies the table that contains user defined codes. For example, for UDC 01/PH the type is PH.
UDC Codes	The code values within the UDC with differences.
Description 01	Values that are different for the Description 01 field are shown in this column.
Description 02	Values that are different for the Description 02 field are shown in this column
Special Handling	Values that are different for the Special Handling field are shown in this column.
Hard Coded Y/N	Values that are different for the Hard Coded field are shown in this column.

Note:

Use the User Defined Codes (P0004A) application to change UDCs and UDC values.