Jump to: navigation, search
Line 60: Line 60:
 
</ul>
 
</ul>
  
 +
{{AnchorDiv|PKs}}
 
==Verify Primary Keys==
 
==Verify Primary Keys==
 
Mykola's tool populates the {{!}}primaryKey parameter based on the partitioned SQL script, which means START_DATE_TIME_KEY is shown as a primary key. This parameter must be cleared manually, since we have elected to show the nonpartitioned settings in the Column List tables. Use the following DPL to verify that unwanted {{!}}primaryKey = yes settings have been cleared.
 
Mykola's tool populates the {{!}}primaryKey parameter based on the partitioned SQL script, which means START_DATE_TIME_KEY is shown as a primary key. This parameter must be cleared manually, since we have elected to show the nonpartitioned settings in the Column List tables. Use the following DPL to verify that unwanted {{!}}primaryKey = yes settings have been cleared.
Line 74: Line 75:
 
|mode=userformat
 
|mode=userformat
 
}}
 
}}
 +
 +
Use the following DPL to confirm that *_AUDIT_KEY displays as a foreign key:
 +
 +
{{#dpl:
 +
|namespace=Documentation
 +
|titlematch=GIM:Library:Table-%:{{PONYDOCSVERSION}}%
 +
|uses=Template:PDMColumn
 +
|includematch=/colName\s*=\s*.*_AUDIT_KEY/
 +
|includenotmatch=/foreignKey\s*=\s*yes/
 +
|include={PDMColumn}:foreignKey
 +
|resultsheader=The following table(s) do not show *_AUDIT_KEY as a foreign key:
 +
|noresultsheader=All tables show *_AUDIT_KEY as a foreign key:.
 +
|format=,\n [[%PAGE%]] ,,
 +
|mode=userformat
 +
}}
 +
  
 
{{AnchorDiv|CheckHighlights}}
 
{{AnchorDiv|CheckHighlights}}
−
==Check Highlights and Change Bars==
+
==Check Highlights, Change Bars, and Font Colors==
  
 
The following pages have highlighted text:
 
The following pages have highlighted text:

Revision as of 20:21, August 19, 2016

Verify Content

Verify Indexes

There are 154 SDR tables of which 0 do not have indexes.

Of the 154 tables that have indexes:

  • All indexes are present in partitioned (no indexPresentInPartitioned=no).All indexes are present in partitioned (no indexPresentInPartitioned=no).
  • All indexes have keyPresentInNonpartitioned on the page.All indexes have keyPresentInNonpartitioned on the page.
  • All index keys are present in nonpartitioned (no keyPresentInNonpartitioned[1], etc.=no).All index keys are present in nonpartitioned (no keyPresentInNonpartitioned[1], etc.=no).

Verify Primary Keys

Mykola's tool populates the |primaryKey parameter based on the partitioned SQL script, which means START_DATE_TIME_KEY is shown as a primary key. This parameter must be cleared manually, since we have elected to show the nonpartitioned settings in the Column List tables. Use the following DPL to verify that unwanted |primaryKey = yes settings have been cleared.

Value of the primaryKey parameter for START_DATE_TIME_KEY on the following table(s): 

Documentation:GIM:Library:Table-BGS SESSION FACT:8.5DRAFT - yes
Documentation:GIM:Library:Table-CALLBACK FACT:8.5DRAFT - yes
Documentation:GIM:Library:Table-CDR FACT:8.5DRAFT - yes
Documentation:GIM:Library:Table-CHAT SESSION FACT:8.5DRAFT - yes
Documentation:GIM:Library:Table-CHAT THREAD FACT:8.5DRAFT - yes
Documentation:GIM:Library:Table-COBROWSE FACT:8.5DRAFT - yes
Documentation:GIM:Library:Table-GPM FACT:8.5DRAFT - yes
Documentation:GIM:Library:Table-LDR FACT:8.5DRAFT - yes
Documentation:GIM:Library:Table-SDR ACTIVITIES FACT:8.5DRAFT - yes
Documentation:GIM:Library:Table-SDR CUST ATRIBUTES FACT:8.5DRAFT - yes
Documentation:GIM:Library:Table-SDR EXT REQUEST FACT:8.5DRAFT - yes
Documentation:GIM:Library:Table-SDR SESSION FACT:8.5DRAFT - yes
Documentation:GIM:Library:Table-SDR SURVEY FACT:8.5DRAFT - yes
Documentation:GIM:Library:Table-SDR SURVEY TRANSCRIPT FACT:8.5DRAFT - yes
Documentation:GIM:Library:Table-SDR USER INPUTS FACT:8.5DRAFT - yes
Documentation:GIM:Library:Table-SDR USER MILESTONE FACT:8.5DRAFT - yes
Documentation:GIM:Library:Table-SM MEDIA NEUTRAL STATE FACT:8.5DRAFT - yes

Use the following DPL to confirm that *_AUDIT_KEY displays as a foreign key:

All tables show *_AUDIT_KEY as a foreign key:.All tables show *_AUDIT_KEY as a foreign key:.


Check Highlights, Change Bars, and Font Colors

The following pages have highlighted text:

The following pages have change bars: No pages have change bars.

Comments or questions about this documentation? Contact us for support!