Template: PDMTablePageFormat

Formatting template to format table pages. This template is called by the Table query in Template:PDMPageQuery.

The template calls Template:PDMColumnQuery, Template:PDMIndexQuery, Template:PDMSubjAreaQuery and, for Library books, Template:PDMRefQuery sub-query templates to populate column, index, subject area, and references info.

This template has been modified from the one originally developed for Ponydocs. Since it no longer needs to cover ICON, some switches fall away. ALSO HOPING THIS DOESN'T STILL APPLY (You cannot use separate sub-query templates for these, because, given the order in which templates are expanded, the {page} of the page calling the first template in the chain cannot be used to specify the where condition in the sub-queries -- in sub-queries {page} starts applying to the Library page that was the _pageName of the original query.)

Content is:

==Description==
<div class="enterprise-right" style="overflow:hidden;">
<div style="border: 1px solid #d6d7d6;padding:5px;padding:15px;background-color:#f1f1f2;">
{{#if:{{{introduced|}}}|'''Introduced:''' {{{introduced}}}<br/>|}}{{#if:{{{modified|}}}|'''Modified:''' {{{modified}}}<br/>|}}{{#if:{{{discontinued|}}}|'''Discontinued:''' {{{discontinued}}}<br/>|}}{{#switch:{{{partitioned}}}
|y
|yes=<br/>In partitioned databases, this table is partitioned.
|n
|no
|#default=<br/>In partitioned databases, this table is not partitioned.}}
</div>
<div class="itemcontainer">
<div style="clear:both;"></div>
<br/>
</div></div>
{{{tableDesc}}}
<!--Note for MSSQL update_target changes made in GIM 8.5.014.34-->
{{#switch:{{{tableName}}}
|INTERACTION_DESCRIPTOR
|POST_CALL_SURVEY_DIM_2
|POST_CALL_SURVEY_DIM_3
|POST_CALL_SURVEY_DIM_4
|USER_DATA_CUST_DIM_1
|USER_DATA_CUST_DIM_2
|SDR_GEO_LOCATION
|SDR_SURVEY_S1
|SDR_SURVEY_S2
|SDR_SURVEY_QUESTIONS_I1
|SDR_SURVEY_QUESTIONS_I2
|SDR_SURVEY_QUESTIONS_S1
|SDR_SURVEY_QUESTIONS_S2
|USER_DATA_GEN_DIM_1
|USER_DATA_GEN_DIM_2={{NoteFormat|'''Note for customers using Data Export Capability:''' If the target database for exported Info Mart data is hosted on Microsoft SQL Server in your deployment, and if you use a Genesys-provided '''update_target_*.sql''' script to create or update the target schema, be aware of the following consideration: {{Editgrn_open}}<strike>Starting with Genesys Info Mart release 8.5.014.34,</strike>{{Editgrn_close}} The sizes of some columns in this table in the Microsoft SQL Server target database differ from what is documented on this page.}}
|#default=}}
{{#switch:{{#explode:{{FULLPAGENAME}}|/|2}}
|PDMLibraryRAA
|PDMCXRAA
|PDMPERAA_Postgres
|PDMPERAA_Ora
|PDMPERAA_MS={{NoteFormat|
*This document shows ''table'' information because it is more informative than ''view'' information. However, directly querying tables is not supported; perform your queries on views. 
*This document shows the HOUR structure for each table, as an example. For each table, the same structure is used for SUBHR through YEAR views.
*Where referenced, IRF resources include:
**Handling resources (such as self-service IVR ports, agents, or non-agent-associated DNs) 
**Mediation resources (such as a non-self-service IVR ports, voice treatment ports, ACD queues, routing points, and so forth) where the interaction ends in mediation before being distributed to a handling resource.
*''IRF'' is an abbreviation for the {{Link-AnywhereElse|product=PEC-REP|version=Current|manual={{#replace:{{#explode:{{FULLPAGENAME}}|/|2}}|RAA|GIM}}|topic=Table-INTERACTION_RESOURCE_FACT|display text=INTERACTION_RESOURCE_FACT table}}.
*''MSF'' is an abbreviation for the {{Link-AnywhereElse|product=PEC-REP|version=Current|manual={{#replace:{{#explode:{{FULLPAGENAME}}|/|2}}|RAA|GIM}}|topic=Table-MEDIATION_SEGMENT_FACT|display text=MEDIATION_SEGMENT_FACT table}}.|2}}
|#default=}}
{{NoteFormat|To assist you in preparing supplementary documentation, click the following link to download a comma-separated text file containing information such as the data types and descriptions for all columns in this table: {{PDMColDescDownload|page={{FULLPAGENAME}}}}.<br /><br />

'''Hint:''' For easiest viewing, open the downloaded CSV file in Excel and adjust settings for column widths, text wrapping, and so on as desired. Depending on your browser and other system settings, you might need to save the file to your desktop first.|2}}
{{AnchorDiv|ColumnList}}
==Column List==
{{#ppin:In the Column List:
*P = Primary key
*M = Mandatory field
*F = Foreign key (where the term is used loosely to indicate a surrogate key reference to a field in another table, not a formal constraint)
*DV = Default value{{#switch:{{#explode:{{FULLPAGENAME}}|/|2}}
|PDMPEGIM_MS
|GIMPDMMS=
*For Microsoft SQL Server, ''varchar/nvarchar'' in the Data Type column means that the data type is varchar except in multi-language databases that use Unicode, in which case the data type is nvarchar. (The Info Mart database in cloud deployments is not multi-language.)
|PDMLibraryGIM=
*For Microsoft SQL Server, ''varchar/nvarchar'' in the Data Type column means that the data type is varchar except in multi-language databases that use Unicode, in which case the data type is nvarchar. (The Info Mart database in cloud deployments is not multi-language.) <font color=red>THIS BULLET WILL DISPLAY ONLY IN THE PE MSSQL PDM.</font>
|#default=}}|Legend}}
{{PDMColumnQuery|page={{{page}}}}}
{{#switch:{{#explode:{{{page}}}|/|2}}
|PDMLibraryGIM
|PDMCXGIM
|PDMPEGIM_Postgres
|PDMPEGIM_Ora
|PDMPEGIM_MS=
{{PDMIndex}}<!--This line does nothing but is needed because of existing markup on the GIM pages-->
{{PDMIndexQuery|page={{{page}}}}}
==Subject Areas==
{{PDMSubjAreaQuery|page={{{page}}}}}
{{#switch:{{MINTYDOCSVERSION}}
|Library=
==References==
The summary List of References will include the following entries for this table or view:
{{PDMRefQuery|page={{{page}}}}}
|#default=}}
|PDMLibraryRAA
|PDMCXRAA
|PDMPERAAPostgres
|PDMPERAAOra
|PDMPERAAMS={{#switch:{{{subjectAreas}}}
|
|PLACEHOLDER=
|#default=
==SubjectAreas==
{{PDMSubjAreaQuery|page={{{page}}}}}}}
}}

Description[edit source]

In partitioned databases, this table is not partitioned.

{{{tableDesc}}}

Tip

To assist you in preparing supplementary documentation, click the following link to download a comma-separated text file containing information such as the data types and descriptions for all columns in this table:

Download a CSV file .

Hint: For easiest viewing, open the downloaded CSV file in Excel and adjust settings for column widths, text wrapping, and so on as desired. Depending on your browser and other system settings, you might need to save the file to your desktop first.

Column List[edit source]

Legend

No results

Column	Data Type	P	M	F	DV

No results