| Line 4: | Line 4: | ||
{{#dpl: | {{#dpl: | ||
|namespace=Documentation | |namespace=Documentation | ||
| − | |titlematch=%GIM:Library:Table-SDR% | + | |titlematch=%GIM:Library:Table-%:{{PONYDOCSVERSION}} |
| − | |resultsheader=There are %PAGES% | + | |nottitlematch=%GIM:Library:Table-SDR% |
| + | |resultsheader=There are %PAGES% tables, | ||
|include= | |include= | ||
|mode=userformat | |mode=userformat | ||
| Line 11: | Line 12: | ||
{{#dpl: | {{#dpl: | ||
|namespace=Documentation | |namespace=Documentation | ||
| − | |titlematch=%GIM:Library:Table-SDR% | + | |titlematch=%GIM:Library:Table-%:{{PONYDOCSVERSION}} |
| + | |nottitlematch=%GIM:Library:Table-SDR% | ||
|notuses=Template:PDMIndexItem | |notuses=Template:PDMIndexItem | ||
| − | |resultsheader=%PAGES% do not have indexes | + | |resultsheader=%PAGES% do not have indexes. |
|noresultsheader=%PAGES% do not have indexes. | |noresultsheader=%PAGES% do not have indexes. | ||
| + | |include= | ||
| + | |mode=userformat | ||
}} | }} | ||
{{#dpl: | {{#dpl: | ||
|namespace=Documentation | |namespace=Documentation | ||
| − | |titlematch=%GIM:Library:Table-SDR% | + | |titlematch=%GIM:Library:Table-%:{{PONYDOCSVERSION}} |
| + | |nottitlematch=%GIM:Library:Table-SDR% | ||
|uses=Template:PDMIndexItem | |uses=Template:PDMIndexItem | ||
|include= | |include= | ||
| Line 28: | Line 33: | ||
<li>{{#dpl: | <li>{{#dpl: | ||
|namespace=Documentation | |namespace=Documentation | ||
| − | |titlematch=%GIM:Library:Table-SDR% | + | |titlematch=%GIM:Library:Table-%:{{PONYDOCSVERSION}} |
| + | |nottitlematch=%GIM:Library:Table-SDR% | ||
|includematch=/indexPresentInPartitioned\s*=\s*no/ | |includematch=/indexPresentInPartitioned\s*=\s*no/ | ||
|include={PDMIndexItem}:indexName | |include={PDMIndexItem}:indexName | ||
| Line 39: | Line 45: | ||
<li>{{#dpl: | <li>{{#dpl: | ||
|namespace=Documentation | |namespace=Documentation | ||
| − | |titlematch=%GIM:Library:Table-SDR% | + | |titlematch=%GIM:Library:Table-%:{{PONYDOCSVERSION}} |
| + | |nottitlematch=%GIM:Library:Table-SDR% | ||
|includenotmatch=/keyPresentInNonpartitioned/ | |includenotmatch=/keyPresentInNonpartitioned/ | ||
|include={PDMIndexItem}:indexName | |include={PDMIndexItem}:indexName | ||
| Line 50: | Line 57: | ||
<li>{{#dpl: | <li>{{#dpl: | ||
|namespace=Documentation | |namespace=Documentation | ||
| − | |titlematch=%GIM:Library:Table-SDR% | + | |titlematch=%GIM:Library:Table-%:{{PONYDOCSVERSION}} |
| + | |nottitlematch=%GIM:Library:Table-SDR% | ||
|includematch=/keyPresentInNonpartitioned[0-9]?\s*=\s*no/ | |includematch=/keyPresentInNonpartitioned[0-9]?\s*=\s*no/ | ||
|include={PDMIndexItem}:indexName | |include={PDMIndexItem}:indexName | ||
Revision as of 14:19, August 23, 2016
Contents
Verify Content
Verify Indexes
There are 94 tables, of which 26 do not have indexes.
Of the 68 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 and Foreign 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_KEYs display as a foreign key:
All tables show *_AUDIT_KEY as a foreign key.All tables show *_AUDIT_KEY as a foreign key.
Use the following DPL to confirm that TENANT_KEY displays as a foreign key:
All tables show TENANT_KEY as a foreign key.All tables show TENANT_KEY as a foreign key.
Check Highlights, Change Bars, and Font Colors
The following pages have highlighted text:
- Documentation:GIM:Library:AboutThisPDM:8.5DRAFT
- Documentation:GIM:Library:InfoMart85Tables:8.5DRAFT
- Documentation:GIM:Library:InfoMart85Views:8.5DRAFT
- Documentation:GIM:Library:SubjectAreas:8.5DRAFT
- Documentation:GIM:Library:Table-GROUP ANNEX:8.5DRAFT
- Documentation:GIM:Library:View-CDR:8.5DRAFT
- Documentation:GIM:Library:View-CDR DATE TIME:8.5DRAFT
- Documentation:GIM:Library:Z GenerateDataExportList:8.5DRAFT
- Documentation:GIM:Library:Z GenerateExportLists:8.5DRAFT
- Documentation:GIM:Library:Z Instructions:8.5DRAFT
The following pages have change bars: No pages have change bars.
Comments or questions about this documentation? Contact us for support!