Demo to Demo compare reports

Reports Delivered

The DMO to DMO compare Reports are based on the DEMO versions of both your current release and the release to which you are upgrading. Since they are based on DEMO databases any fixes you may have applied are not accounted for.

The DMO to DMO Compare Reports are delivered in both Excel spreadsheet and PDF format. There are sixteen reports broken down into three categories.

The following records are not included in these reports: record names that begin with UPG, record names that end with AET, or record names that contain TAO, TEMP, TEO, TMP, or WRK. Records with these names are usually temporary tables, work tables, or upgrade tables. Records owned by PeopleTools are also excluded from these reports.

Added Objects

These objects are absent in your current release but will be delivered with the upgrade.

AddedTables–

These are RECNAMEs from PSRECDEFN with a RECTYPE = 0 that are absent in your current release but will be delivered with the upgrade.

AddedRecordFields_Tables

These are RECNAMEs and FIELDNAMEs from PSRECFIELD that have a RECTYPE = 0.

AddedViews–

These are RECNAMEs from PSRECDEFN with a RECTYPE = 1.

AddedRecordFields_Views

These are RECNAMEs and FIELDNAMEs from PSRECFIELD that have a RECTYPE = 1.

AddedSubrecs–

These are RECNAMEs from PSRECDEFN with a RECTYPE = 3.

AddedRecordFields_Subrecs

These are RECNAMEs and FIELDNAMEs from PSRECFIELD that have a RECTYPE = 3.

Deleted Objects

These objects exist in your current release but not in the release to which you are upgrading.

DeletedTables–

These are RECNAMEs from PSRECDEFN with a RECTYPE = 0 that are absent in your current release but will be delivered with the upgrade.

DeletedRecordFields_Tables

These are RECNAMEs and FIELDNAMEs from PSRECFIELD that have a RECTYPE = 0.

DeletedViews–

These are RECNAMEs from PSRECDEFN with a RECTYPE = 1.

DeletedRecordFields_Views

These are RECNAMEs and FIELDNAMEs from PSRECFIELD that have a RECTYPE = 1.

DeletedSubrecs–

These are RECNAMEs from PSRECDEFN with a RECTYPE = 3.

DeletedRecordFields_Subrecs

These are RECNAMEs and FIELDNAMEs from PSRECFIELD that have a RECTYPE = 3.

Changed Objects

These are objects that existed in both releases but are changing in some way.

Tables2Views

These are RECNAMEs from PSRECDEFN that have a RECTYPE = 0 in your current release but will become RECTYPE = 1 during the upgrade.

Views2Tabless

These are RECNAMEs from PSRECDEFN that have a RECTYPE = 1 in your current release but will become RECTYPE = 0 during the upgrade.

TruncatedFields

These are RECNAMEs and FIELDNAMEs that have the same FIELDTYPE in both releases but are being truncated during the upgrade. Note these RECNAMEs, and make a copy of the data if you need a record of the data before it was truncated.

ChangedFieldType

These are RECNAMEs and FIELDNAMEs where the FIELDTYPE is changing during the upgrade. Example: A text field becoming a numeric field.