Example: Creating a Composite Report
To illustrate how the system compiles and displays composite report information, this section provides a simple example. Keep in mind that this example only displays information for one definition. A typical composite report can contain information pertaining to hundreds of definitions. This example shows:
-
Compare report results between a PeopleSoft 8.1 demonstration database and PeopleSoft 8.1 production copy.
-
Compare report results between a PeopleSoft 8.4 demonstration database and PeopleSoft 8.4 production copy.
-
Composite report result based on the previous compare report results.
Compare Report Results Between a PeopleSoft 8.1 Demonstration Database and PeopleSoft 8.1 Customer Production Database
This compare report shows customizations. For the field, FLD1, the following customizations were made:
-
Field Length: 10 to 12
-
Description: ABC to XYZ
-
Owner ID: PPT to CUST
With these customizations, the compare report results would appear as follows:
| Definition Name | Source Status | Target Status | Attribute | Source Value | Target Value |
|---|---|---|---|---|---|
|
FLD1 |
Unchanged |
*Changed |
Field Length |
10 |
12 |
|
Description |
ABC |
XYZ |
|||
|
Owner ID |
PPT |
CUST |
Compare Report Results Between a PeopleSoft 8.4 Demonstration Database and PeopleSoft 8.4 Customer Production Database
This report shows customizations and PeopleSoft modifications.
For the field, FLD1, the following customizations were made:
-
Field Length: 10 to 12
-
Description: ABC to XYZ
-
Owner ID: PPT to CUST
For the field, FLD1, PeopleSoft made the following modifications:
-
Field Length: 10 to 14
-
Format: Upper to Mixed
-
Field Type: Char to Long Char
With these customizations, the compare report results would appear as follows:
| Definition Name | Source Status | Target Status | Attribute | Source Value | Target Value | Note |
|---|---|---|---|---|---|---|
|
FLD1 |
Unchanged |
*Changed |
Field Length |
14 |
12 |
PeopleSoft modification + Customization |
|
Description |
ABC |
XYZ |
Customization Only |
|||
|
Owner ID |
PPT |
CUST |
Customization Only |
|||
|
Format |
Mixed |
Upper |
PeopleSoft modification only |
|||
|
Field Type |
Long Char |
Char |
PeopleSoft modification only |
Composite Report Result Based on the Previous Compare Report Results
The following table is a sample composite report only showing the attributes from the previous compare reports that were changed by both PeopleSoft and a customer.
| Definition Name | Attribute | Old Release | New Release | Customization |
|---|---|---|---|---|
|
FLD1 |
Field Length |
10 |
14 |
12 |
|
Descr |
ABC |
(same) |
XYZ |
|
|
OwnerID |
PPT |
(same) |
CUST |