PDMTablePageFormat

Formatting template to format table pages in the RDBMS-specific, customer-facing manuals. This template is called by the Table query in Template:PDMPageQuery. It parallels the formatting in the {{Template:PDMTable]] template, which formats the Library book pages.

The template switches for ICON and GIM. It includes sub-queries to populate column, index, and subject area info. (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:

{{#switch:{{#explode:{{{page}}}|:|1}}
|GIM
|RAA
|PSAAS=
==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>
|ICON=
{{#if:{{{introduced|}}}|'''Introduced:''' {{{introduced}}}<br/>|}}{{#if:{{{modified|}}}|'''Modified:''' {{{modified}}}<br/>|}}{{#if:{{{discontinued|}}}|'''Discontinued:''' {{{discontinued}}}<br/>|}}
<br/>}}
{{{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: {{#switch:{{#explode:{{{page}}}|:|2}}|PDMOra|PDMPostgre=Prior to|PDMMS|RPRT|#default=Starting with}} Genesys Info Mart release 8.5.014.34, the sizes of some columns in this table in the Microsoft SQL Server target database differ from what is documented on this page.}}
|#default=}}
<!--Suppress the rest of the display for ICON's G_LOG_GETIDRANGEREQ table, an internal table that has only PDMTable markup on the Library page.-->
{{#switch:{{anchorencode:{{#explode:{{{page}}}|:|3}}}}|Table-G_LOG_GETIDRANGEREQ=|#default={{#switch:{{#explode:{{{page}}}|:|1}}
|RAA={{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 [[Documentation:GIM:{{#explode:{{{page}}}|:|2}}:Table-INTERACTION_RESOURCE_FACT:Current|INTERACTION_RESOURCE_FACT table]].
*''MSF'' is an abbreviation for the [[Documentation:GIM:{{#explode:{{{page}}}|:|2}}:Table-MEDIATION_SEGMENT_FACT:Current|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={{{page}}}}}.<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 {{#switch:{{#explode:{{{page}}}|:|1}}
|GIM
|RAA
|PSAAS=(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|#default=}}{{#switch:{{#explode:{{{page}}}|:|2}}
|PDMMS
|RPRT=
*In the Data Type column, ''varchar/nvarchar'' means that the data type is varchar except in multi-language databases that use Unicode, in which case the data type is nvarchar.
|Library=
*In the Data Type column, ''varchar/nvarchar'' means that the data type is varchar except in multi-language databases that use Unicode, in which case the data type is nvarchar. <font color=red>THIS BULLET DISPLAYS ONLY IN THE MSSQL AND CLOUD PDMs.</font>
|#default=}}|Legend}}
{{{!}}
! '''Column'''
! '''Data Type'''
! '''P'''
! '''M'''
! '''F'''
! {{#switch:{{#explode:{{{page}}}|:|1}}|GIM|RAA|PSAAS='''DV'''|ICON|#default='''Description'''}}
{{!}}-
{{#cargo_query:
tables=PDMColumn
|fields=_pageName=pageName,colName=colName,dataType_Ora =dataType_Ora,dataType_MSSQL=dataType_MSSQL,dataType_Postgre=dataType_Postgre,dataType_DB2=dataType_DB2,
primaryKey=primaryKey,mandatoryKey=mandatoryKey,foreignKey=foreignKey,defaultValue=defaultValue,colDesc=colDesc,introduced=introduced,modified=modified,discontinued=discontinued,KVP=KVP,xpath=xpath,mandatoryForGIM=mandatoryForGIM,transformDefault=transformDefault
|where=_pageName LIKE "{{#if:{{{source|}}}|{{{source}}}|Documentation:{{#switch:{{#explode:{{{page}}}|:|1}}|PSAAS=GIM:Library:{{#explode:{{{page}}}|:|3}}:{{#switch:{{#explode:{{{page}}}|:|4}}|draft=DRAFT|Public=PDMSource}}
|#default={{#explode:{{{page}}}|:|1}}:Library:{{anchorencode:{{#explode:{{{page}}}|:|3}}}}:{{#switch:{{lc:{{#sub:{{{page}}}|-5}}}}|draft|ource={{#explode:{{{page}}}|:|4}}|#default={{#switch:{{lc:{{#explode:{{{page}}}|:|4}}}}|public|current=PDMSource|#default={{#sub:{{#explode:{{{page}}}|:|4}}|0|3}}PDMSource}}}}}}}}"
|format=template
|template=PDMColumnFormat_Table
|order by=_rowID
|named args=yes
|limit=1000
}}
{{!}}}
{{#switch:{{#explode:{{{page}}}|:|1}}
|GIM
|RAA
|PSAAS={{#cargo_query:
tables=PDMColumn
|fields=_pageName=pageName,colName=colName,dataType_Ora =dataType_Ora,dataType_MSSQL=dataType_MSSQL,dataType_Postgre=dataType_Postgre,dataType_DB2=dataType_DB2,
primaryKey=primaryKey,mandatoryKey=mandatoryKey,foreignKey=foreignKey,defaultValue=defaultValue,colDesc=colDesc,introduced=introduced,modified=modified,discontinued=discontinued,KVP=KVP,xpath=xpath,mandatoryForGIM=mandatoryForGIM,transformDefault=transformDefault
|where=_pageName LIKE "{{#if:{{{source|}}}|{{{source}}}|Documentation:{{#switch:{{#explode:{{{page}}}|:|1}}|PSAAS=GIM:Library:{{#explode:{{{page}}}|:|3}}:{{#switch:{{#explode:{{{page}}}|:|4}}|draft=DRAFT|Public=PDMSource}}
|#default={{#explode:{{{page}}}|:|1}}:Library:{{anchorencode:{{#explode:{{{page}}}|:|3}}}}:{{#switch:{{lc:{{#sub:{{{page}}}|-5}}}}|draft|ource={{#explode:{{{page}}}|:|4}}|#default={{#switch:{{lc:{{#explode:{{{page}}}|:|4}}}}|public|current=PDMSource|#default={{#sub:{{#explode:{{{page}}}|:|4}}|0|3}}PDMSource}}}}}}}}"
|format=template
|template=PDMColumnFormat_GIMDesc
|order by=_rowID
|named args=yes
|limit=1000
}}
|#default=}}
{{#switch:{{#explode:{{{page}}}|:|1}}
|GIM
|PSAAS=
{{PDMIndexQuery|page={{{page}}}}}
|#default=}}
{{#switch:{{#explode:{{{page}}}|:|1}}
|GIM
|PSAAS
|RAA=
==Subject Areas==
{{PDMSubjAreaQuery|page={{{page}}}}}
|ICON
|#default=}}
}}<!--This is the end of the switch that suppresses content for ICON's G_LOG_GETIDRANGEREQ table.-->

---

{{{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

Legend

No results

Column	Data Type	P	M	F	Description