PDMs GIM-GIDBTablePageFormat

Template called by Template:PDMs_GIM-GIDB to populate GIDB table pages in the PSAAS PDM. The Cargo query that populates the column list uses formatting template PDMs_GIM-GIDBColumnsFormat, and the query for the column descriptions uses PDMs_GIM-GIDBColumnsDescFormat.

The template needs to be edited manually to temporarily add and then remove switches on draft vs. Public, so as to safeguard the published pages during review and approvals. The formatting starts with a shaded box to hold introduced, etc. metadata, with GIDB_GC_GROUP being treated separately because of a table-specific change.

==Description==
{{#switch:{{#sub:{{anchorencode:{{#explode:{{{page}}}|:|3}}}}|6}}
|GIDB_GC_GROUP=<div class="enterprise-right" style="overflow:hidden;">
<div style="border: 1px solid #d6d7d6;padding:5px;padding:15px;background-color:#f1f1f2;">
'''Modified:''' 8.5.015.19 (PRODUCER_BATCH_ID column added); 8.5.015.07 (data type for SCRIPT column increased); 8.5.014.34 (data type for various columns modified)
</div>
<div class="itemcontainer">
<div style="clear:both;"></div>
|GIDB_GC_CALLING_LIST
|GIDB_GC_CAMPAIGN
|GIDB_GC_FOLDER
|GIDB_GC_LOGIN
|GIDB_GC_PLACE
|GIDB_GC_SKILL
|GIDB_GC_TENANT=
<div class="enterprise-right" style="overflow:hidden;">
<div style="border: 1px solid #d6d7d6;padding:5px;padding:15px;background-color:#f1f1f2;">
'''Modified:''' 8.5.015.19 (PRODUCER_BATCH_ID column added); 8.5.014.34 (data type for various columns modified)
</div>
<div class="itemcontainer">
<div style="clear:both;"></div>
|#default=}}

{{{tableDesc}}}

{{#switch:{{{tableName}}}
|GC_CALLING_LIST
|GC_CAMPAIGN
|GC_GROUP
|GC_PLACE
|GC_SKILL
|GC_TENANT=The [[Documentation:{{#explode:{{{page}}}|:|1}}:{{#explode:{{{page}}}|:|2}}:View-{{#sub:{{{tableName}}}|3}}:{{#explode:{{{page}}}|:|4}}|{{#sub:{{{tableName}}}|3}}]] view is based on this table.
|#default=}}
{{AnchorDiv|ColumnList}}
==Column List==
{{#css: td.field_P {text-align: center} td.field_M {text-align: center} td.field_F {text-align: center} }}
{{{!}}
! '''Column'''
! '''Data Type'''
! '''P'''
! '''M'''
! '''F'''
{{!}}-
{{!}} {{#cargo_query:
tables=PDMColumn
|fields=UCASE(colName)=column,dataType_MSSQL=dataType,primaryKey=primaryKey,mandatoryKey=mandatoryKey,foreignKey=foreignKey,CONCAT('{{{page}}}')=page
|where=_pageName LIKE "Documentation:ICON:Library:Table-{{{tableName}}}:8.1PDMSource" AND colName NOT LIKE "%%_TCODE" AND colName NOT LIKE "GSYS_PARTITION" AND colName NOT LIKE "GSYS_SEQ" AND colName NOT LIKE "GSYS_USEQ" AND colName NOT LIKE "GSYS_TS" AND colName NOT LIKE "GSYS_TC" AND colName NOT LIKE "SECTIONKEYHASH"
|format=template
|template=PDMs_GIM-GIDBColumnsFormat
|order by=_rowID
|named args=yes
|limit=1000
}}<!--Switch to suppress DATA_SOURCE_KEY in the (GIDB_)GCX_LOGIN_INFO table-->{{#switch:{{{tableName}}}
|GCX_LOGIN_INFO=
|#default=[[{{FULLPAGENAME}}#DATA_SOURCE_KEY|DATA_SOURCE_KEY]]
{{!}} int 
{{!}} style="text-align:center;" {{!}}
{{!}} style="text-align:center;" {{!}} X
{{!}} style="text-align:center;" {{!}}
{{!}}-
{{!}}}}<!-- Switch ends here -->[[{{FULLPAGENAME}}#PRODUCER_BATCH_ID|PRODUCER_BATCH_ID]]
{{!}} numeric(19)
{{!}} style="text-align:center;" {{!}}
{{!}} style="text-align:center;" {{!}}
{{!}} style="text-align:center;" {{!}}
{{!}}-
{{!}}[[{{FULLPAGENAME}}#CREATE_AUDIT_KEY|CREATE_AUDIT_KEY]]
{{!}} numeric(19)
{{!}} style="text-align:center;" {{!}}
{{!}} style="text-align:center;" {{!}} X
{{!}} style="text-align:center;" {{!}}
{{!}}-
{{!}} [[{{FULLPAGENAME}}#UPDATE_AUDIT_KEY|UPDATE_AUDIT_KEY]]
{{!}} numeric(19)
{{!}} style="text-align:center;" {{!}}
{{!}} style="text-align:center;" {{!}} X
{{!}} style="text-align:center;" {{!}}
{{!}}}

{{#cargo_query:
tables=PDMColumn
|fields=UCASE(colName)=column,colDesc=colDesc,CONCAT('{{{page}}}')=page
|where=_pageName LIKE "Documentation:ICON:Library:Table-{{{tableName}}}:8.1PDMSource" AND colName NOT LIKE "%%_TCODE" AND colName NOT LIKE "GSYS_PARTITION" AND colName NOT LIKE "GSYS_SEQ" AND colName NOT LIKE "GSYS_USEQ" AND colName NOT LIKE "GSYS_TS" AND colName NOT LIKE "GSYS_TC" AND colName NOT LIKE "SECTIONKEYHASH"
|format=template
|template=PDMs_GIM-GIDBColumnsDescFormat
|order by=_rowID
|named args=yes
|limit=1000
}}
<!--Switch to suppress DATA_SOURCE_KEY-->{{#switch:{{{tableName}}}
|GCX_LOGIN_INFO=
|#default=
===DATA_SOURCE_KEY===
The field references an internal ID that Genesys Info Mart assigns to the upstream data source. Reserved for internal use.
<div style="text-align:right;padding-bottom:1px" class="pdf-remove">[[{{{page}}}#ColumnList|>> Back to Column List]]</div>}}<!-- end of switch-->
===PRODUCER_BATCH_ID===
'''Introduced:''' 8.5.015.19

Reserved for internal use.
===CREATE_AUDIT_KEY===
The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data creation. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools — that is, applications that need to identify newly added data.
<div style="text-align:right;padding-bottom:1px" class="pdf-remove">[[{{{page}}}#ColumnList|>> Back to Column List]]</div>
===UPDATE_AUDIT_KEY===
The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data update. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools — that is, applications that need to identify recently modified data.
<div style="text-align:right;padding-bottom:1px" class="pdf-remove">[[{{{page}}}#ColumnList|>> Back to Column List]]</div>

Description

{{{tableDesc}}}

Column List

Column	Data Type	P	M	F
No resultsDATA_SOURCE_KEY	int		X
PRODUCER_BATCH_ID	numeric(19)
CREATE_AUDIT_KEY	numeric(19)		X
UPDATE_AUDIT_KEY	numeric(19)		X

No results

DATA_SOURCE_KEY

The field references an internal ID that Genesys Info Mart assigns to the upstream data source. Reserved for internal use.

[[{{{page}}}#ColumnList|>> Back to Column List]]

PRODUCER_BATCH_ID

Introduced: 8.5.015.19

Reserved for internal use.

CREATE_AUDIT_KEY

The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data creation. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools — that is, applications that need to identify newly added data.

[[{{{page}}}#ColumnList|>> Back to Column List]]

UPDATE_AUDIT_KEY

The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data update. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools — that is, applications that need to identify recently modified data.

[[{{{page}}}#ColumnList|>> Back to Column List]]