'56@#6@42;2?.A213?<:.BA5<?6A.A6C2<;96;20<;A2;A.;1
6@=?<C61213<?0<;C2;62;02<;9F'56@#0.;;<A/2B@21
3<?924.9=B?=<@2@<?.BA5<?6A.A6C2B;12?@A.;16;4<3D5.A
6@.;16@;<A@B==<?A21.9D.F@B@2A52<;96;20<;A2;A'<
0<=F0<12@.:=92@.9D.F@B@2A52<;96;20<;A2;A
;3< .?A.A./.@2&0?6=A@
2;2@F@;3< .?A2=9<F:2;AB612

Info Mart Database Scripts
'56@=.4212@0?6/2@5<DA<:<163F.;1?B;A52&$@0?6=A@;22121A<0?2.A2A52;3< .?A1.A./.@2
.;1=?212K;21C62D@'56@=.42.9@<12@0?6/2@5<DA<0<;K4B?2A52;3< .?A1.A./.@2A<<=A6:6G2
=2?3<?:.;02<3A52:2?42<=2?.A6<;3<?C<6026;A2?.0A6<;@
Contents
J ;3< .?A.A./.@2&0?6=A@
J  23<?2,<B246;
J  #?2=.?6;4B@A<:(@2?.A.&A<?.42
J  #?2=.?6;4A52;3< .?A.A./.@2
;3< .?A.A./.@2&0?6=A@
2;2@F@;3< .?A2=9<F:2;AB612
Before You Begin
'523<99<D6;46;3<?:.A6<;6@6:=<?A.;A3<?F<BA<8;<D
J '522;2@F@@B==9621&$@0?6=A@.?2=?<C61216;A52 sql_scripts 3<912?6;F<B?2;2@F@;3< .?A
6;@A.99.A6<;=.08.42'52F.?2.9@<.C.69./92.@.@2=.?.A2&$&0?6=A@6;@A.99.A6<;=.08.42(@2F<B?
1.A./.@2@=206K0A<<93<?2E.:=92&$#9B@A<?B;A52@B==9621&$@0?6=A@
J '522;2@F@;3< .?AH=?<C6121&$@0?6=A@1<;<A>B.963F1.A./.@2</720A@/FA526?@052:.<?<D;2?
*52;F<B?B;A52&$@0?6=A@:.82@B?2A5.AF<BB@2A52<3A52@052:.<?<D;2?D52;F<B9<46;
A<A521.A./.@2,<B;<A21A52@052:.<?<D;2?.;1=.@@D<?1<32.051.A./.@26;A52.==?<=?6.A2
@20A6<;<3A52 .A./.@2*<?8@522A@
J '522;2@F@;3< .?AH=?<C6121&$@0?6=A@0?2.A2</720A@D6A5<BA@=2063F6;4A./92@=.02@<?@A<?.42
=.?.:2A2?@*<?8D6A5F<B?1.A./.@2.1:6;6@A?.A<?<?1.A.D.?25<B@6;4@=206.96@AA<12C29<=.
1.A./.@26:=92:2;A.A6<;A5.A6@<=A6:.93<?F<B?2;C6?<;:2;A.;1:.82A52;202@@.?F05.;42@A<A52
&$@0?6=A@&22 .A./.@2<;@612?.A6<;@ 3<?:<?26;3<?:.A6<;
Preparing Custom User-Data Storage
2;2@F@;3< .?A=?<C612@&$@0?6=A@A<B@2.@.A2:=9.A23<?:<16K0.A6<;@F<B0.;:.82A<A52
;3< .?A1.A./.@2@052:.A<0B@A<:6G2B@2?1.A.?2=<?A6;4
J make_gim_UDE_template.sql I<?B@2D6A5;<;=.?A6A6<;211.A./.@2@<? 60?<@<3A&$&2?C2?B@2
A56@@0?6=A3<?@6;4929.;4B.421.A./.@2@
J make_gim_UDE_template_partitioned.sql I<?B@2D6A5=.?A6A6<;211.A./.@2@<? 60?<@<3A&$
&2?C2?B@2A56@@0?6=A3<?@6;4929.;4B.421.A./.@2@
J make_gim_UDE_template_multilang.sql I&A.?A6;4D6A5?292.@23<?B@2D6A5
;<;=.?A6A6<;21:B9A69.;4B.421.A./.@2@6; 60?<@<3A&$&2?C2?12=9<F:2;A@
J make_gim_UDE_template_multilang_partitioned.sql I&A.?A6;4D6A5?292.@23<?B@2D6A5
=.?A6A6<;21:B9A69.;4B.421.A./.@2@6; 60?<@<3A&$&2?C2?12=9<F:2;A@
,<B:<163FA52.==960./92B@2?1.A.A2:=9.A2@0?6=A.@?2>B6?21A<0?2.A20B@A<:B@2?1.A.
2EA2;@6<;A./92@.;10<9B:;@.;1A<@=2063F@A<?.42<30B@A<:)#@,<B0.;B@2A52 (@2?.A.
@@6@A.;A User_Data_Assistant.xlsm, A<529==?2=.?2A520B@A<:6G21@0?6=A
'523<99<D6;464B?2@5<D@A52?29.A6<;@56=@A5.AA52B@2?1.A.A2:=9.A2@0?6=A0?2.A2@A<699B@A?.A2
5<D0B@A<:B@2?1.A.6@@A<?216;A52;3< .?A1.A./.@2.;1=<=B9.A216;6;A2?.0A6<;?20<?1@
;09B@6<;<3A52 MEDIATION_SEGMENT_FACT  &A./926;A5264B?2699B@A?.A2@<=A6<;.9@A<?.42<3
B@2?1.A.3<?6;A2?.0A6<;@A5.A.?26;:216.A6<;
;3< .?A.A./.@2&0?6=A@
2;2@F@;3< .?A2=9<F:2;AB612
B@A<:(@2?.A.&A<?.42
,<B0.;12K;2A52;.:2@<3A520B@A<:A./92@.;10<9B:;@.@F<B05<<@2A<@22A52:6;A52;3<
.?A1.A./.@2;0B@A<:3.0AA./92@F<B0.;.9@<@=2063FA521.A.AF=2@I05.?.0A2?;B:2?60<?
1.A2A6:2I3<?A520<9B:;@A5.A@A<?2)#C.9B2@
'<:.82A52/2@AB@2<3A52L2E6/92B@2?1.A.@A<?.42A5.A2;2@F@;3< .?A=?<C612@2;2@F@
?20<::2;1@A5.AF<BB@2A./92.;10<9B:;;.:2@A5.A?2L20AA52:2.;6;4<3A52B@2?1.A.)#@6;
F<B?12=9<F:2;A 2.;6;43B9;.:2@<30<9B:;@6;?20<4;6G./92B@2?1.A.2EA2;@6<;A./92@:.82@6A
2.@62?A<D?6A2B;.:/64B<B@?2=<?A6;4>B2?62@<D2C2?6;:B9A69.;4B.421.A./.@2@1<;<AB@2
;<;.A6;(;60<1205.?.0A2?@6;A./92<?0<9B:;;.:2@3F<BB@2A52.A.E=<?A32.AB?2D6A5
2E=<?AC62D@@B==<?A216;<;=?2:6@2@12=9<F:2;A@@A.?A6;4D6A5?292.@2A./92;.:2@
:B@A;<A/29<;42?A5.;05.?.0A2?@
<?:<?26;3<?:.A6<;./<BA=9.;;6;4B@2?1.A.@A<?.426;F<B?12=9<F:2;A@22 &A<?6;4(@2?.A.
#?2=.?6;4A52(@2?.A.&0?6=A
(@2A523<99<D6;4=?<021B?2A<=?2=.?2A52&$@0?6=AA<0B@A<:6G2B@2?1.A.@A<?.426;A52;3< .?A
1.A./.@2,<B0.;:<163FA52@0?6=A.;1B@26AA<0B@A<:6G2A52B@2?1.A.A./92@6;A52;3< .?A
1.A./.@2@052:..A.;FA6:2
C2;63F<BB@2A52 (@2?.A.@@6@A.;A A<=?2=.?2A520B@A<:6G21@0?6=A3<?F<B?12=9<F:2;A
2;2@F@?20<::2;1@A5.AF<B?2C62DA526;3<?:.A6<;6;A523<99<D6;4:.;B.9=?<021B?2@<A5.AF<B
0.;C2?63FA52C.9616AF<3A5242;2?.A21@0?6=A/23<?2F<B2E20BA26A
#?<021B?2B@A<:6G6;4A52B@2?1.A.A2:=9.A2@0?6=A
Purpose: '<0B@A<:6G2A522;2@F@=?<C6121B@2?1.A.@0?6=A6;<?12?A<@=2063FB@2?12K;21
)#;.:2@.;112K;20B@A<:B@2?1.A.2EA2;@6<;A./92@
;3< .?A.A./.@2&0?6=A@
2;2@F@;3< .?A2=9<F:2;AB612
#?2?2>B6@6A2@
J '52D<?8@522A3<?:.==6;4B@2?1.A.82F@A5.A.?2B@213<??2=<?A6;46;F<B?2;C6?<;:2;A6@
0<:=92A2<?A52:.==6;4D<?8@522A@22 .==6;4(@2?.A.*<?8@522A9A2?;.A6C29F63F<B
.?2B@6;4A52(@2?.A.@@6@A.;AA52B@6;2@@;.9F@A.;1%2=<?A2C29<=2?A./@5.C2/22;
0<:=92A21
J '52"!.==960.A6<;5.@/22;0<;K4B?21A<@A<?2A52?2>B6?21B@2?1.A.)#@
&A2=@
 <0.A2.0<=F<3A52.==960./92A2:=9.A2@0?6=Amake_gim_UDE_template.sql
make_gim_UDE_template_partitioned.sql make_gim_UDE_template_multilang.sql<?
make_gim_UDE_template_multilang_partitioned.sql6;A52% &@=206K0 sql_scripts
3<912?<;A522;2@F@;3< .?A=?<1B0A
 &.C2.0<=F<3A52@0?6=AA<.9<0.9:.056;2
 <163FF<B?0<=F<3A52@0?6=AA<=?<C6120<9B:;@6;.B@2?1.A.3.0AA./92A<@A<?25645
0.?16;.96AF)#@A5.AF<BD699B@26;F<B??2=<?A@F123.B9AA52@0?6=A0?2.A2@.A./92;.:21
IRF_USER_DATA_CUST_1.
!<A2A523<99<D6;4./<BA:<16K0.A6<;@F<B0.;:.82
J The table name I,<B0.;05.;42A52;.:2<3A52 IRF_USER_DATA_CUST_1 A./92A<.;F
;.:2A5.AF<BD.;AA<@226;A52;3< .?A1.A./.@2<D2C2?63F<B05.;42A52;.:2
2;@B?2A5.AF<B05.;42.996;@A.;02@6;A52@0?6=A6;09B16;4A52=.?A@<3A52@0?6=AA5.A.?2
12@0?6/216; &A2=@ .;1
J Column names I3F<B.?2:<163F6;4A52@0?6=AA<=?2=.?23<?A526;6A6.912=9<F:2;A
@6:=9F?2=9.02123.B9A;.:2@3<?A520<9B:;@A5.A@A<?2)#C.9B2@@B05.@
CUSTOM_DATA_1, D6A5;.:2@A5.A.?2:<?2:2.;6;43B96;F<B?12=9<F:2;A2;2@F@
?20<::2;1@A5.AF<BB@2A52.0AB.9;.:2@<3A5256450.?16;.96AF)#@
J Character data I&A.?A6;4D6A5?292.@2F<B0.;6;0?2.@2A52@6G2<3A521.A.AF=2
3<?0<9B:;@A5.A@A<?205.?.0A2?1.A.3?<:A<05.?.0A2?@<?6;3<?:.A6<;./<BA
2;./96;4@B==<?A3<?(;60<1205.?.0A2?@@22 B9A6.;4B.42&B==<?A
J Numeric data I3F<BD.;AA<@A<?2=.?A60B9.?)#C.9B2@.@;B:2?601.A.05.;42A52
1.A.AF=23<?A520<9B:;@A5.A@A<?2A5<@2)#C.9B2@A<.;F;B:2?601.A.AF=2A5.A6@
@B==<?A21/FF<B?% &
J Date/Time data I3F<BD.;AA<@A<?2=.?A60B9.?)#C.9B2@.@1.A2A6:21.A.05.;42A52
1.A.AF=23<?A520<9B:;@A5.A@A<?2A5<@2)#C.9B2@A<<;2<3A523<99<D6;41.A.AF=2@
J <? 60?<@<3A&$&2?C2? DATETIME
J <?"?.092 DATE <? TIMESTAMP
J <?#<@A4?2&$ TIMESTAMP
3A521.A2A6:2A5.AF<BD.;AA<@A<?26@6;A522;2@F@;3< .?A123.B9A3<?:.A3<?
1.A2A6:2yyyy-mm-ddThh24:mi:ss.ffF<B1<;<A;221A<=2?3<?:.;F3B?A52?
:.==6;43A521.A2A6:26@6;.;<A52?1.A23<?:.AF<B:B@A@=2063FA520<;C2?@6<;
2E=?2@@6<;D52;F<B:.=A52)#A<A523.0AA./920<9B:;@22 &A2=
;3< .?A.A./.@2&0?6=A@
2;2@F@;3< .?A2=9<F:2;AB612
J Updating the database schema I3F<B.?2:<163F6;4A52@0?6=AA<B=1.A2A521.A./.@2
@052:..3A2?2;2@F@;3< .?A5.@.9?2.1F/22;12=9<F21F<B:B@A
 292A2A52 DROP TABLE &$@A.A2:2;AD5605.==2.?@6;A52A2:=9.A2@0?6=A/23<?2A52
CREATE TABLE @A.A2:2;A
 5.;42A52 CREATE TABLE &$@A.A2:2;AA<.; ALTER TABLE <;2
 <163FA52@0?6=A.@?2>B6?21A<0?2.A2.;6;12E3<?A52B@2?1.A.3.0AA./92A5.AF<B0?2.A216;
&A2=
 <;A6;B2:<163F6;4F<B?0<=F<3A52@0?6=AA<=?<C6120<9B:;@6;B@2?1.A.16:2;@6<;A./92@A<
@A<?29<D0.?16;.96AF)#@A5.AF<BD699B@26;F<B??2=<?A@'52@0?6=A=?<C612@=9.025<912?@3<?
A./92@;.:21 USER_DATA_CUST_DIM_1 .;1 USER_DATA_CUST_DIM_2.
!<A2A523<99<D6;4./<BA:<16K0.A6<;@F<B0.;:.82
J The table name I,<B0.;05.;42A52;.:2<3A52 USER_DATA_CUST_DIM_1 A./92A<.;F
;.:2A5.AF<BD.;AA<@226;A52;3< .?A1.A./.@2<D2C2?63F<B05.;42A52;.:2
2;@B?2A5.AF<B05.;42.996;@A.;02@6;A52@0?6=A6;09B16;4A52=.?A@<3A52@0?6=A12@0?6/21
6; &A2= .;1 &A2=@ A5?<B45 
J Column names I3F<B.?2:<163F6;4A52@0?6=AA<=?2=.?23<?A526;6A6.912=9<F:2;A
@6:=9F?2=9.02123.B9A0<9B:;;.:2@@B05.@ DIM_ATTRIBUTE_1, D6A5;.:2@A5.A.?2:<?2
:2.;6;43B96;F<B?12=9<F:2;A2;2@F@?20<::2;1@A5.AF<BB@2A52.0AB.9;.:2@<3A52
9<D0.?16;.96AF)#@
J Updating the database schema I3F<B.?2:<163F6;4A52@0?6=AA<B=1.A2A521.A./.@2
@052:..3A2?2;2@F@;3< .?A5.@.9?2.1F/22;12=9<F21F<B:B@A
 292A2A52 DROP TABLE &$@A.A2:2;AD5605.==2.?@6;A52A2:=9.A2@0?6=A/23<?2A52
CREATE TABLE @A.A2:2;A
 5.;42A52 CREATE TABLE &$@A.A2:2;AA<.; ALTER TABLE <;2
:=<?A.;A
<;<A:<163FA521.A.AF=2@<?A52:.;1.A<?F@A.AB@<3A520<9B:;@2;2@F@;3< .?A1<2@
;<A@B==<?A;B:2?60.91.A.AF=2@<?;B99./920<9B:;@3<?B@2?1.A.16:2;@6<;@
 <163FA52@0?6=A.@?2>B6?21A<0?2.A2.;6;12E3<?A52B@2?1.A.16:2;@6<;A./92A5.AF<B
0?2.A216; &A2=
 3;202@@.?F?2=2.A &A2=@ A5?<B45 A<.11&$0<::.;1@A<0?2.A2.116A6<;.90B@A<:B@2?
1.A.3.0A.;116:2;@6<;A./92@
 <163FA52@0?6=A.@?2>B6?21A<0?2.A23<?264;82F?232?2;02@3<?A52B@2?1.A.16:2;@6<;
A./92@6;A52 IRF_USER_DATA_KEYS A./92
'52@0?6=A6;09B12@A523<99<D6;4=9.025<912?@
J CUSTOM_KEY_1 .;1 CUSTOM_KEY_2 I'52;.:2<3A523<?264;82FA5.A2;2@F@;3< .?AD699
B@2A<?232?2;02A52B@2?1.A.16:2;@6<;A./92A5.AF<B0?2.A216; &A2= 2;2@F@
?20<::2;1@A5.AF<BB@2.82F;.:2A5.A=?<C612@.;</C6<B@.@@<06.A6<;D6A5A52A./92
;.:2,<B:.=A56@82FA<A52?232?2;021A./929.A2?&A2= 
;3< .?A.A./.@2&0?6=A@
2;2@F@;3< .?A2=9<F:2;AB612
*.?;6;4
<;<A05.;42A521.A.AF=2<3A52K291@A5.AF<B.11A<A52%-(&%-'-,&A./92;
?292.@2@2.?962?A5.;.9@<1<;<A05.;42A52:.;1.A<?F@A.AB@<?A52123.B9AC.9B2<3
F<B?0B@A<:K291@'52123.B9AC.9B2 -2 6;160.A2@ NO_VALUE.
'6=
116;40<9B:;@A<./64 IRF_USER_DATA_KEYS A./920.;0<;@B:2@64;6K0.;A &?2@<B?02@
.;1A6:23F<B.?2:<163F6;4A52@0?6=AA<=?2=.?23<?A526;6A6.912=9<F:2;A0<;@612?.116;4
?21B;1.;A0<9B:;@6;.1C.;02.A2?F<B0.;:.=;2DB@2?1.A.16:2;@6<;@A<2E6@A6;4
IRF_USER_DATA_KEYS 0<9B:;@.@?2>B6?21
 <?A52B@2?1.A.16:2;@6<;A./92@A5.AF<B0?2.A216; &A2= :<163FA52@0?6=A.@?2>B6?21A<
=<=B9.A2A52A./92@D6A5:.;1.A<?FC.9B2@3<?=?212K;2182F@3<?2E.:=92 UNKNOWNF
123.B9AA52@0?6=A6;@2?A@A52?2>B6?21C.9B2@6;A<.A./92;.:21 USER_DATA_CUST_DIM_1.
 .=A52B@2?1.A.16:2;@6<;A./92@A<A523<?264;82F@'<1<@<:<163FA52@0?6=AA<.11A<
A52 CTL_UDE_KEYS_TO_DIM_MAPPING A./92A52:.==6;4/2AD22;A52B@2?1.A.16:2;@6<;
A./92@.;1A523<?264;82F@A5.AF<B.1121A<A52 IRF_USER_DATA_KEYS A./92&A2= '52
@0?6=A6;09B12@A523<99<D6;4=9.025<912?@
J USER_DATA_CUST_DIM_1 I'52B@2?1.A.16:2;@6<;A./92;.:2D5605F<B12K;216; &A2=
J ID I'52=?6:.?F82F3<?A52B@2?1.A.16:2;@6<;A./92
J CUSTOM_KEY_1 I'523<?264;82F3<?A52B@2?1.A.16:2;@6<;A./92D5605F<B@=206K216;
A52 IRF_USER_DATA_KEYS A./926; &A2=
 .=B@2?1.A.82F@A<B@2?1.A.3.0A.;116:2;@6<;A./920<9B:;@<?2.050<9B:;A5.AF<B
12K;213<?B@2?1.A.3.0A.;116:2;@6<;A./92@@22 &A2=@ A5?<B45 :<163FA52@0?6=AA<
J 11A<A52 CTL_UD_TO_UDE_MAPPING A./92A52:.==6;4/2AD22;B@2?1.A.82F@.;1A52B@2?
1.A.A./920<9B:;@
J &=2063F123.B9AC.9B2@
J &=2063FA520B@A<:0<;C2?@6<;2E=?2@@6<;3<?0B@A<:1.A20<;C2?@6<;6;B@2?1.A.3.0A
A./92@
(@2A52 D<?8@522A A5.AF<B=?2=.?213<?B@2?1.A.:.==6;4A<612;A63FA52?2>B6?21@0?6=A
05.;42@'<0B@A<:6G2A521.A20<;C2?@6<;2E=?2@@6<;@22 &A2= 
'52@0?6=A6;09B12@A523<99<D6;4=9.025<912?@3<?3.0AA./92@
J CustomDataN I'5282F;.:2.@@A<?21/F"!
J IRF_USER_DATA_CUST_1 I'52B@2?1.A.3.0AA./92;.:2D5605F<B12K;216; &A2=
J CUSTOM_DATA_N I'520<9B:;;.:2D5605F<B12K;216; &A2=
;3< .?A.A./.@2&0?6=A@
2;2@F@;3< .?A2=9<F:2;AB612
'52@0?6=A6;09B12@A523<99<D6;4=9.025<912?@3<?16:2;@6<;A./92@
J CustomAttributeN I'5282F;.:2.@@A<?21/F"!
J USER_DATA_CUST_DIM_1 I'52B@2?1.A.16:2;@6<;A./92;.:2D5605F<B12K;216; &A2=
J DIM_ATTRIBUTE_N I'520<9B:;;.:2D5605F<B12K;216; &A2=
'52@0?6=A.9@<?2>B6?2@F<BA<@=2063FA52=?<=.4.A6<;?B92123.B9AC.9B2.;1.0A6C6AF
@A.AB@3<?2.05)#<?:<?26;3<?:.A6<;./<BAC.9B2@3<?A52@2K291@@22A520<9B:;
12@0?6=A6<;@3<?A52 CTL_UD_TO_UDE_MAPPING A./926;A52 Genesys Info Mart Reference
Manual 3<?F<B?% &
;@B?2A5.AA52123.B9AC.9B2@A5.AF<B@=2063F.?20<;@6@A2;AD6A5A521.A.AF=23<?A52
0<9B:;
 3F<BD.;A2;2@F@;3< .?AA<@A<?2.1.A2A6:2C.9B22E=?2@@216;.3<?:.A<A52?A5.;A52
2;2@F@;3< .?A123.B9A3<?:.A3<?1.A2A6:23<?2E.:=92 DD Mon YY 6;@A2.1<3 yyyy-mm-
ddThh24:mi:ss.ff@=2063FA520<;C2?@6<;2E=?2@@6<;6;A52 CONVERT_EXPRESSION K2916;A52
CTL_UD_TO_UDE_MAPPING A./922;A?F3<?A52)#2;2@F@;3< .?A6;09B12@A520<;C2?@6<;
2E=?2@@6<;6;&$@A.A2:2;A@A<0<;C2?AA521.A.
J <? 60?<@<3A&$&2?C2?A520<;C2?@6<;2E=?2@@6<;6@
${schema}.GIM_TO_TIMESTAMP_ISO8601(${})
D52?2
J ${schema} 6@.=9.025<912?3<?A52;3< .?A1.A./.@2@052:.;.:22;2@F@;3< .?A
42A@A52C.9B2<3A52 ${schema} =.?.:2A2?3?<:A52 123.B9A@052:. <=A6<;6;A52;3<
.?A #
J ${} 6@.=9.025<912?3<?A52)#C.9B2A</20<;C2?A21
J GIM_TO_TIMESTAMP_ISO8601 6@.;<BA<3/<E3B;0A6<;D5605K?@A2E20BA2@.;<A52?
<BA<3/<E3B;0A6<; GIM_IS_ISO8601_DATEA<052083<?:.A/23<?20.996;4A52 60?<@<3A
&$&2?C2?@F@A2:3B;0A6<; convert(datetime, ${}, 126) A<0<;C2?AA521.A2A6:2
2E=?2@@6<;6;3<?:.A yyyy-mm-ddThh24:mi:ss.ff.
A6@;<A=<@@6/92A<B@2 convert() D6A5<BAK?@A052086;4A523<?:.A<3A522E=?2@@6<;
/20.B@2<3. 60?<@<3A&$&2?C2?96:6A.A6<;A5.A:.82@A?.;@.0A6<;@B;B@./92.3A2?
:<@A0<;C2?@6<;2??<?@'<0B@A<:6G2A520<;C2?@6<;F<B:B@A12K;2F<B?<D;
0<;C2?@6<;3B;0A6<;6;A521.A./.@2.;1A52;0.99A5.A3B;0A6<;6;A52
CONVERT_EXPRESSION K291B@6;4A52@F;A.E@5<D;./<C2(@2A52
GIM_TO_TIMESTAMP_ISO8601 .;1 GIM_IS_ISO8601_DATE 3B;0A6<;@D5605.?2
12K;216;A52 make_gim.sql .;1 make_gim_partitioned.sql @0?6=A@.@2E.:=92@
3<?F<B?0B@A<:3B;0A6<;@6;0<;7B;0A6<;D6A5% &1<0B:2;A.A6<;./<BA@F;A.E
?2>B6?2:2;A@.;11.A23<?:.A@<;<A:<163FA52<BA<3/<E3B;0A6<;@
J <?"?.092A520<;C2?@6<;2E=?2@@6<;6@
TO_DATE(${},'yyyy-mm-dd'T'hh24:mi:ss')
<?
TO_TIMESTAMP(${},'yyyy-mm-dd'T'hh24:mi:ss.ff')
D52?2 ${} 6@.=9.025<912?3<?A52)#C.9B2A</20<;C2?A21
;3< .?A.A./.@2&0?6=A@
2;2@F@;3< .?A2=9<F:2;AB612
'<0B@A<:6G2A520<;C2?@6<;B@2<;2<3A52@A.;1.?1% &=?<C61213B;0A6<;@
TO_DATE <? TO_TIMESTAMP?2=9.06;4A521.A23<?:.A2E=?2@@6<;D6A5.C.961
3<?:.A.@12K;216;A52% &1<0B:2;A.A6<;
J <?#<@A4?2&$A520<;C2?@6<;2E=?2@@6<;6@
TO_TIMESTAMP(${},'yyyy-mm-dd'T'hh24:mi:ss.ms')
D52?2 ${} 6@.=9.025<912?3<?A52)#C.9B2A</20<;C2?A21
 &.C2A52:<16K210<=F<3A52@0?6=A
!2EA&A2=@
J E20BA2A52:<16K21@0?6=AD52;F<B0?2.A2A52;3< .?A1.A./.@2@052:.@22 Creating the
Info Mart database schema, &A2=<?.@?2>B6?21A<B=1.A2.;2E6@A6;41.A./.@2@052:.
'<C2?63F0<??20A:.==6;4@2E20BA2A523<99<D6;4&$0<::.;1.4.6;@AA52;3< .?A
1.A./.@2
SELECT * FROM CTL_UD_TO_UDE_MAPPING
<:=.?2A52?2@B9A@<3A52>B2?F.4.6;@AA52:.==6;4A5.AF<B=?2=.?21/23<?20B@A<:6G6;4
A52@0?6=A.@12@0?6/216;A52 #?2?2>B6@6A2@
:=<?A.;A
23<?2F<B2E20BA2A52@0?6=AA<B=1.A2.;2E6@A6;41.A./.@2@052:.2;2@F@?20<::2;1@A5.A
F<B/.08B=A52;3< .?A1.A./.@2
J 3F<BB=1.A2.;2E6@A6;41.A./.@2@052:.A5.AB@2@?2.1<;9FA2;.;AC62D@A<.002@@;3< .?A
1.A.3<??2=<?A@F<B:B@A?20?2.A2A52?2.1<;9FA2;.;AC62D@<?:<?26;3<?:.A6<;@22
?2.A6;4%2.1";9F'2;.;A)62D@
Preparing the Info Mart Database
'52% &@=206K0&$@0?6=A@A5.A.?2=?<C6121D6A52;2@F@;3< .?A0?2.A2A52;3< .?A
1.A./.@2@052:.'56@6;09B12@:2?42A./92@D5605.?2.?2>B6?21=.?A<3A52;3< .?A1.A./.@2
@052:.6;.;F12=9<F:2;A2;2@F@;3< .?A=?<C612@@2=.?.A2@0?6=A@3<?=.?A6A6<;21.;1
;<;=.?A6A6<;211.A./.@2@052:.@<? 60?<@<3A&$&2?C2?@A.?A6;4D6A5?292.@22;2@F@
;3< .?A.9@<=?<C612@@2=.?.A2@0?6=A@3<?@6;4929.;4B.42.;1:B9A69.;4B.421.A./.@2@
'522;2@F@;3< .?A1.A./.@2@0?6=A@1<;<A0?2.A2A52.116A6<;.91.A./.@2</720A@A5.A.?2
?2>B6?21A<@B==<?A.44?24.A6<;<?:<?26;3<?:.A6<;./<BA1.A./.@2=?2=.?.A6<;3<?12=9<F:2;A@
A5.AB@2A522;2@F@56@A<?60.9?2=<?A6;4=?2@2;A.A6<;9.F2?+ <?A52@2=.?.A29F6;@A.9921 %
=.08.42@22A52 Reporting and Analytics Aggregates 8.x Deployment Guide .;1A52 Genesys CX
Insights Deployment Guide
;3< .?A.A./.@2&0?6=A@
2;2@F@;3< .?A2=9<F:2;AB612
#?<021B?2?2.A6;4A52;3< .?A1.A./.@2@052:.
#?2?2>B6@6A2@
J <?:B9A69.;4B.421.A./.@2@F<B5.C2?2C62D21?2>B6?2:2;A@3<?A52;3< .?A1.A./.@2.;1
<A52?@F@A2:0<:=<;2;A@@22A5296;8@=?<C61216; B9A6.;4B.42&B==<?A.;1=?2=.?21F<B?
2;C6?<;:2;A.00<?16;49F
J ,<B5.C20?2.A21.1.A./.@26;@A.;023<?F<B?;3< .?A1.A./.@2
J '52?2>B6?21&$@0?6=A@.?2.C.69./923?<:A52% &@=206K0 sql_scripts 3<912?<;A52
2;2@F@;3< .?A=?<1B0A
:=<?A.;A
3F<B.?20?2.A6;4.=.?A6A6<;211.A./.@2@052:.<; 60?<@<3A&$&2?C2?1<;<A.9A2?
make_gim_partitioned.sql <? make_gim_multilang_partitioned.sql @<.@A<0?2.A2A52
=.?A6A6<;@6;:B9A6=92K924?<B=@
J "=A6<;.93F<B=9.;A<@A<?2B@2?12K;21.AA.05211.A.F<B5.C20B@A<:6G21A52.==960./92
B@2?1.A.&$@0?6=AA2:=9.A2.@6;@A?B0A216; #?2=.?6;4A52(@2?.A.&0?6=A
J "=A6<;.93F<B=9.;A<0?2.A2:B9A6=920.92;1.?16:2;@6<;@A<@B==<?AF<B??2=<?A6;4F<B5.C2
0B@A<:6G21A52.==960./921.A./.@20?2.A6<;@0?6=AA<0?2.A2.116A6<;.90.92;1.?A./92@
9A2?;.A6C29FF<B0.;0?2.A2A520B@A<:0.92;1.?@.3A2?F<B5.C26;@A.99212;2@F@;3< .?A
<?:<?26;3<?:.A6<;@22 ?2.A6;4B@A<:.92;1.?@
&A2=@
 ;@B?2A5.AA521.A./.@2.002@@.00<B;AA5.AF<BB@2A<0?2.A2A52;3< .?A1.A./.@2@052:.
6@.C.69./92.;15.@A52?2>B6?21=?6C69242@@22 %2>B6?21.A./.@2#?6C69242@
%232?A<F<B?0<:=92A21 .A./.@2*<?8@522A@ A<12A2?:6;2A52A<B@2
 <46;A<A52;3< .?A1.A./.@2B@6;4A52;3< .?AB@2?.00<B;A
 %B;A52.==960./92&$@0?6=AA<0?2.A2A52;3< .?A1.A./.@2@052:.
J <?.;<;=.?A6A6<;211.A./.@2B@2 make_gim.sql. '56@@0?6=A0?2.A2@A522;2@F@;3< .?A
16:2;@6<;.;13.0AA./92@.;1?29.A216;12E2@"; 60?<@<3A&$&2?C2?@A.?A6;4D6A5?292.@2
B@2 make_gim.sql 3<?.@6;4929.;4B.421.A./.@2.;1 make_gim_multilang.sql
3<?.:B9A69.;4B.421.A./.@2
J <?.=.?A6A6<;211.A./.@2B@2 make_gim_partitioned.sql. '56@@0?6=A0?2.A2@A522;2@F@
;3< .?A16:2;@6<;.;13.0AA./92@.;1?29.A216;12E2@"; 60?<@<3A&$&2?C2?@A.?A6;4
D6A5?292.@2B@2 make_gim_partitioned.sql 3<?.@6;4929.;4B.421.A./.@2.;1
make_gim_multilang_partitioned.sql 3<?.:B9A69.;4B.421.A./.@2<?A52A./92@.;1
6;12E2@A5.A.?2=.?A6A6<;21A56@@0?6=A0?2.A2@.@6;492<BA1.A21=.?A6A6<;A5.A6@2E=20A21
A</2=B?4211B?6;4A52K?@A?B;<3A52:.6;A2;.;027</

;3< .?A.A./.@2&0?6=A@
2;2@F@;3< .?A2=9<F:2;AB612 
"=A6<;.9%B;A52:<16K21(A2:=9.A2@0?6=Amake_gim_UDE_template.sql
make_gim_UDE_template_partitioned.sql make_gim_UDE_template_multilang.sql<?
make_gim_UDE_template_multilang_partitioned.sqlA5.AF<B5.C2B=1.A21D6A5?2>B6?21
)# ;.:2@'56@@0?6=A0?2.A2@2EA2;@6<;A./92@6;A52;3< .?A1.A./.@2@052:.A<@A<?2
0B@A<:B@2?1.A.0<;K4B?2@B@2?1.A.:.==6;4@.;1.11@A52@=206K2116:2;@6<;82FK291@A<
A52 IRF_USER_DATA_KEYS A./92
 ;@B?2A5.AA521.A./.@2.002@@.00<B;AA5.AA52'7</@D699B@2A<.002@@A52;3< .?A
1.A./.@26@.C.69./92.;15.@A52?2>B6?21B@2?.00<B;A=?6C69242@@22 %2>B6?21.A./.@2
#?6C69242@
%232?A<F<B?0<:=92A21 .A./.@2*<?8@522A@ A<12A2?:6;2A52A<B@2
'52B@2?.00<B;A1<2@;<A5.C2A</2A52@.:2.@A52<D;2?.00<B;A<?:<?26;3<?:.A6<;
./<BAA52?B92@.;1?20<::2;1.A6<;@A5.A=2?A.6;A<1.A./.@2.002@@.00<B;A@3<?
2;2@F@;3< .?A@22 .A./.@2"/720A"D;2?@.;1(@2? @
!2EA&A2=@
J %2>B6?213<?)<60212A.69@<;9F(=1.A2A52 GSYS_DNPREMOTELOCATION A./92.@?2>B6?21A<
<=A6:6G2=2?3<?:.;02<3A52:2?42<=2?.A6<;<?:<?26;3<?:.A6<;@22 <;K4B?6;4A52;3<
.?A1.A./.@23<?:2?42
J %20<::2;121/BA<=A6<;.9<;K4B?21.A./.@296;8@<?:<?26;3<?:.A6<;@22 "=A6:6G6;4
.A./.@2#2?3<?:.;02.A./.@26;8@
J 'B;2B=F<B?;3< .?A1.A./.@2.@.==?<=?6.A23<?F<B?% &2;C6?<;:2;A<?:<?2
6;3<?:.A6<;@22 "=A6:6G6;4.A./.@2#2?3<?:.;02.A./.@2'B;6;4
#?<021B?2<;K4B?6;4A52;3< .?A1.A./.@23<?:2?42
Purpose: '<<=A6:6G2=2?3<?:.;02<3A52:2?42<=2?.A6<;
#?2?2>B6@6A2@
J '52;3< .?A1.A./.@2@052:.5.@/22;0?2.A21.@12@0?6/216; ?2.A6;4A52;3< .?A
1.A./.@2@052:.
&A2=@
 3.;F@D6A052@.?2;<A:<;6A<?21/F"!@A<?2A5<@2&D6A05</720A;.:2@6;A52
GSYS_DNPREMOTELOCATION A./92<3A52;3< .?A@052:."A52?D6@2:2?46;4<3@<:2
6;A2?@D6A05C<6026;A2?.0A6<;@D699/2129.F21B;A69A520<;K4B?21&6;8A6:2<BA<00B?@.;1
A56@129.F@A?.;@3<?:.A6<;<3A5<@2C<6026;A2?.0A6<;@
Example
&B==<@2A5.AF<B5.C23<B?@D6A052@.;1AD<"!6;@A.;02@
J "!:<;6A<?@@D6A05&'-@D
;3< .?A.A./.@2&0?6=A@
2;2@F@;3< .?A2=9<F:2;AB612 
J "!:<;6A<?@@D6A05&'-@D
J &'-@D.;1&'-@D.?2;<A:<;6A<?21/F26A52?"!6;@A.;02
'<.C<61129.F@6;:2?46;4.11A523<99<D6;4AD<?20<?1@A<A52 GSYS_DNPREMOTELOCATION
A./926;A52;3< .?A@052:.
J GSYS_DNPREMOTELOCATION.REMOTELOCATION=SITE3_sw3
J GSYS_DNPREMOTELOCATION.REMOTELOCATION=SITE4_sw4
<?2.05?<D6;A52 GSYS_DNPREMOTELOCATION A./92=<=B9.A2A52 ID K291D6A5.B;6>B2
C.9B2
 %2C62DA52@2AA6;4@<3A52 :.E0.991B?.A6<; :2?4205B;8@6G2.;1 :2?423.69216@96;8A6:2<BA
0<;K4B?.A6<;<=A6<;@.;1:<163FA52:.@?2>B6?213<?F<B?12=9<F:2;A
!2EA&A2=@
J %20<::2;121/BA<=A6<;.9<;K4B?21.A./.@296;8@<?:<?26;3<?:.A6<;@22 "=A6:6G6;4
.A./.@2#2?3<?:.;02.A./.@26;8@
J 'B;2B=F<B?;3< .?A1.A./.@2.@.==?<=?6.A23<?F<B?% &2;C6?<;:2;A<?:<?2
6;3<?:.A6<;@22 "=A6:6G6;4.A./.@2#2?3<?:.;02.A./.@2'B;6;4
;3< .?A.A./.@2&0?6=A@
2;2@F@;3< .?A2=9<F:2;AB612 