ࡱ>    !"#$%&'()*+,-./0123456789:;Root EntryZ O2 x,<CONTENTS rCompObjVSPELLING@ SLIDRetAnalysisUnits ISD_SLID_SLIDRET_DICTIONARY_2007 SLIDRetAnalysisUnits User-Interface / SQL Generation SLIDRetCodesets ISD_SLID_PROC_DICTIONARY_RY2007 tblCodesets User-Interface / SQL Generation SLIDRetEntity ISD_SLID_SLIDRET_DICTIONARY_2007 SLIDRetEntity User-Interface SLIDRetEntityVar ISD_SLID_PROC_DICTIONARY_RY2007 tblEntityVar User-Interface / SQL Generation SLIDRetLogicalPhysicalLink ISD_SLID_SLIDRET_DICTIONARY_2007 SLIDRetLogicalPhysicalLink SQL Generation SLIDRetTableRelations ISD_SLID_SLIDRET_DICTIONARY_2007 SLIDRetTableRelations SQL Generation SLIDRetTables ISD_SLID_SLIDRET_DICTIONARY_2007 SLIDRetTables SQL Generation SLIDRetThemes ISD_SLID_PROC_DICTIONARY_RY2007 tblThemes User-Interface SLIDRetVariables ISD_SLID_PROC_DICTIONARY_RY2007 tblVariables User-Interface / SQL Generation SLIDRetWeight ISD_SLID_SLIDRET_DICTIONARY_2007 SLIDRetWeight User-Interface / SQL Generation p 2 Create dmms_20**.xml This step creates the dmms_20**.xml file used by every client. This file is JV`b|~ * , f h X Z :FHJv2tBZ68:\(2"'( X- 0Z "PS  &0r8d ">~0prt.02 Vbzh*hhh. "|$  08, "|$  086$, 082$, 08> $0 08."O"$ 082" $  08."D "|$0 08."CHNKWKS !rpTEXTTEXT2FDPPFDPPFDPPFDPPFDPCFDPCFDPCFDPCFDPCFDPC FDPCFDPC"STSHSTSH$^STSHSTSH^$XSYIDSYID%DSGP SGP %INK INK %BTEPPLC & BTECPLC "&0FONTFONTR&TOKNPLC &hEOBJPLC X(TCD PLC ,)$TCD PLC P)$ Admin Tools guide & important information Specifiers: Jean-Philippe Tissot - ISD/DSR, Marc Chartrand - ISD/DSR Step 1 Import DMMS: The process copies tables from last year's SLIDret's Dictionary (these tables need to be manually edited if changes are required). It also copies/filters and renames SLID's Data Dictionary tables required by the software. Here is the list of tables and extra information about each one of them. If there are any modification of the tblEntity Table in SLID s Data Dictionary, the modification has to be manually inserted into the SLIDRetEntity table, and the last column lg has to be set accordingly. The  lg column is used to deternmine if the entity is available for longitudinal queries or not in SLIDRet s user interface. You can also seek more information about these tables in \\Lhs5\inc\APEX\Programs\Applications\SLIDRet\website\technical_info_e.html Step 2 Create dmms_20**.xml This step creates the dmms_20**.xml file used by every client. This file is encrypted and contains all the tables specified in SLIDRet's Dictionary database. The data source used to create the dmms.xml file should be the server and database selected as output in the first step. The file output folder should be the default path. If this path ever has to change, check the SLIDRet.AdminTools settings for the key named "dmms". The default path is : \\lhs5\inc\APEX\Programs\Applications\SLIDRet\DMMS\ The year should be the same as the data sources database you selected earlier. This year attribute is then used inside SLIDRet's user interface as the last year of data available. Step 3: Step4: Name Source Database Original Name Usage SLIDRetAnalysisThemes ISD_SLID_SLIDRET_DICTIONARY_2007 SLIDRetAnalysisThemes User-Interface ( * , f h T 8:DJtv02rt|>||::::::::::::8 "!$, 08: "!$, 08> $0 08."O"$ 08, "|$  086 "|$  08."J@BXZ4:Z\.0pr68bd"<>|~.0nt,.8 "!$, 08.2JصTSH &, Normal (Web)D صTSH(6Dx(6 "   *0 "|" $  *4 " $ ."O "PS   *6  " $ ."O "PS   * "    *  tt2.2 "ONT8L`tTimes New RomanVerdanaCambriaCalibriSegoe UI Iwx"@"K" "3 " ")`K\\Lhs5\inc\APEX\Programs\Applications\SLIDRet\website\technical_info_e.html3\\lhs5\inc\APEX\Programs\Applications\SLIDRet\DMMS\ !x "0Z"""` " " " " " " " " " " "" "()+6L\]_5Jjkm/;[\^ .<KLN0=]^`;Vefh6L[\^ .<KLN -7FGI0=]^` .<\]_x+_m^N`h^NI`_ " " " "  """T"""L""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""h!""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+",""""q"L""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+",""r"""Z ""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""|""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""|""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+", """T"""L""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""h!""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+",""""q"L""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+",""r"""Z ""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""|""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""|""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+", """T"""L""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""h!""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+",""""q"L""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+",""r"""Z ""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""|""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""|""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+", """T"""L""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""h!""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+",""""q"L""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+",""r"""Z ""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""|""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""|""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+", """T"""L""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""h!""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+",""""q"L""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+",""r"""Z ""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""|""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""|""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+", """T"""L""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""h!""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+",""""q"L""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+",""r"""Z ""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""|""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""|""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+", """T"""L""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""h!""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+",""""q"L""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+",""r"""Z ""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""|""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""|""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+", """T"""L""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""h!""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+",""""q"L""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+",""r"""Z ""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""|""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""|""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+", """T"""L""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""h!""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+",""""q"L""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+",""r"""Z ""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""|""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""|""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+", """T"""L""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""h!""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+",""""q"L""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+",""r"""Z ""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""|""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""|""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+", """T"""L""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""h!""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+",""""q"L""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+",""r"""Z ""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""|""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""|""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+", """T"""L""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""h!""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+",""""q"L""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+",""r"""Z ""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""|""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+","""""|""Ԕ"|"Ԕ "| "   "" ""z """""" "!""#"$%"&"'(")"*+",F"d5 "t"]"K"` "`""A."@"d5 ","]"K"` "`"."j  "^vl""` "`"""" "*",."j  "^vl""` "`"""" "*",."j  "^vl""` "`"""" "*",."j  "^vl""` "`"""" "*",."j  "^vl""` "`"""" "*",."j  "^vl""` "`"""" "*",."j  "^vl""` "`" """ "*",." j  "^vl""` "`" """ "*",." j  "^vl""` "` " """ "*" ,." j  "^vl""` "` " """ "*" ,." j  "^vl""` "` " """ "*" ,." j  "^vl""` "` """" "*" ,." | "   "" ""z """""" "!""#"$%"&"'(")"*+", ""TCD PLC t)$TCD PLC )$TCD PLC )$TCD PLC )$TCD PLC *$TCD PLC (*$TCD PLC L*$TCD PLC p*$TCD PLC *$TCD PLC *$STRSPLC *MCLDMCLD|+H>FRAMFRAMiDOP DOP Do Z O2Quill96 Story Group Class9q