Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
- "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
- <head>
- <meta name="generator" content=
- "HTML Tidy for Linux/x86 (vers 11 February 2007), see www.w3.org" />
- <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" />
- <title>Data Warehouse at Case Western Reserve University</title>
- <link href="http://www.case.edu/stylesheets/core.css" rel="stylesheet" type=
- "text/css" />
- <link href="https://www.case.edu/projects/datawarehouse/stylesheets/dwsite.css" rel=
- "stylesheet" type="text/css" />
- <link href="https://www.case.edu/projects/datawarehouse/stylesheets/dwlayout.css" rel=
- "stylesheet" type="text/css" />
- <link href="http://www.case.edu/stylesheets/print.css" media="print" rel="stylesheet"
- type="text/css" />
- <link href="https://www.case.edu/projects/datawarehouse/stylesheets/catalog.css" rel=
- "stylesheet" type="text/css" />
- <script src="http://www.case.edu/javascripts/general.js" type="text/javascript">
- </script>
- <script src="https://www.case.edu/projects/datawarehouse/jquery.js" type=
- "text/javascript">
- </script>
- <script src="https://www.case.edu/projects/datawarehouse/catalog/catalog.js" type=
- "text/javascript">
- </script>
- <style type="text/css">
- /*<![CDATA[*/
- <!--
- #wrapper #content #main2col .modbox tr td {
- color: #3366cc;
- border-top-style: solid;
- border-right-style: solid;
- border-bottom-style: solid;
- border-left-style: solid;
- font-size: 12px;
- }
- #wrapper #content #main2col .modbox tr td p em {
- color: #0a304e;
- }
- #wrapper #content #main2col .modbox tr td em br {
- color: #0a304e;
- }
- #wrapper #content #main2col .modbox tr td em strong {
- color: #0a304e;
- }
- #wrapper #content #main2col p strong {
- color: #0a304e;
- }
- #wrapper #content #main2col table tr td strong {
- color: #0a304e;
- }
- -->
- /*]]>*/
- </style>
- <style type="text/css">
- /*<![CDATA[*/
- <!--
- table.modbox {
- font-size:9pt;
- font-HCMmily:"Calibri", "sans-serif";
- border-top-style: solid;
- border-right-style: solid;
- }
- p.MsoNormal {
- margin-top:0in;
- margin-right:0in;
- margin-bottom:5pt;
- margin-left:0in;
- line-height:normal;
- font-size:10pt;
- font-HCMmily:"Calibri","sans-serif";
- }
- #wrapper #content #main2col .modbox tr .modbox {
- color: #09C;
- font-style: normal;
- }
- #wrapper #content #main2col .modbox {
- color: #3366cc;
- }
- #wrapper #content #main2col .modbox {
- color: #3a5774;
- }
- #wrapper #content #main2col .modbox tr .modbox .MsoNormal .modbox {
- color: #3a5774;
- }
- #wrapper #content #main2col .modbox {
- color: #3a5774;
- }
- -->
- /*]]>*/
- </style>
- <style type="text/css">
- /*<![CDATA[*/
- <!--
- table.MsoTableGrid {
- border:solid ;
- font-size:11.0pt;
- font-HCMmily:"Calibri","sans-serif";
- }
- p.MsoNormal1 {margin-top:0in;
- margin-right:0in;
- margin-bottom:10.0pt;
- margin-left:0in;
- line-height:normal;
- font-size:11.0pt;
- font-HCMmily:"Calibri","sans-serif";
- }
- #wrapper #content #main2col .modbox {
- font-size: 10px;
- }
- -->
- /*]]>*/
- </style>
- <style type="text/css">
- /*<![CDATA[*/
- td.c54 {width:119.7pt;border-top:none;border-left:none;border-bottom:solid;border-right:solid;padding:0in 5.4pt 0in 5.4pt;}
- th.c53 {width:119.7pt;border:solid;border-left:none;padding:0in 5.4pt 0in 5.4pt;}
- td.c52 {width:67.65pt;border-top:none;border-left:none;border-bottom:solid;border-right:solid;padding:0in 5.4pt 0in 5.4pt;}
- td.c51 {width:1.95in;border-top:none;border-left:none;border-bottom:solid;border-right:solid;padding:0in 5.4pt 0in 5.4pt;}
- td.c50 {width:45.0pt;border-top:none;border-left:none;border-bottom:solid;border-right:solid;padding:0in 5.4pt 0in 5.4pt;}
- td.c49 {width:173.7pt;border-top:none;border-left:none;border-bottom:solid;border-right:solid;padding:0in 5.4pt 0in 5.4pt;}
- td.c48 {width:119.7pt;border:solid;border-top:none;padding:0in 5.4pt 0in 5.4pt;}
- th.c47 {width:67.65pt;border:solid;border-left:none;padding:0in 5.4pt 0in 5.4pt;}
- th.c46 {width:1.95in;border:solid;border-left:none;padding:0in 5.4pt 0in 5.4pt;}
- th.c45 {width:45.0pt;border:solid;border-left:none;padding:0in 5.4pt 0in 5.4pt;}
- th.c44 {width:173.7pt;border:solid;border-left:none;padding:0in 5.4pt 0in 5.4pt;}
- th.c43 {width:119.7pt;border:solid;padding:0in 5.4pt 0in 5.4pt;}
- td.c42 {width:384.6pt;border-top:none;border-left:none;border-bottom:solid;border-right:solid;padding:0in 5.4pt 0in 5.4pt;}
- td.c41 {width:127.45pt;border-top:none;border-left:none;border-bottom:solid;border-right:solid;padding:0in 5.4pt 0in 5.4pt;}
- td.c40 {width:155.4pt;border:solid;border-top:none;padding:0in 5.4pt 0in 5.4pt;}
- th.c39 {width:384.6pt;border:solid;border-left:none;padding:0in 5.4pt 0in 5.4pt;}
- th.c38 {width:127.45pt;border:solid;border-left:none;padding:0in 5.4pt 0in 5.4pt;}
- th.c37 {width:155.4pt;border:solid;padding:0in 5.4pt 0in 5.4pt;}
- td.c36 {width:567.9pt;border:solid;border-top:none;padding:0in 5.4pt 0in 5.4pt;}
- td.c35 {width:567.9pt;border:solid;padding:0in 5.4pt 0in 5.4pt;}
- p.c34 {margin-top:3.0pt;margin-right:0in;margin-bottom:.0001pt;margin-left:0in;line-height:normal;}
- span.c33 {font-size:12.0pt;}
- th.c32 {width:8.95in;border:solid;border-top:none;padding:0in 5.4pt 0in 5.4pt;}
- td.c31 {width:8.95in;border:solid;border-top:none;padding:0in 5.4pt 0in 5.4pt;}
- td.c30 {width:76.5pt;border-top:none;border-left:none;border-bottom:solid;border-right:solid;padding:0in 5.4pt 0in 5.4pt;}
- td.c29 {width:81.0pt;border-top:none;border-left:none;border-bottom:solid;border-right:solid;padding:0in 5.4pt 0in 5.4pt;}
- td.c28 {width:135.0pt;border-top:none;border-left:none;border-bottom:solid;border-right:solid;padding:0in 5.4pt 0in 5.4pt;}
- td.c27 {width:1.0in;border-top:none;border-left:none;border-bottom:solid;border-right:solid;padding:0in 5.4pt 0in 5.4pt;}
- td.c26 {width:189.0pt;border-top:none;border-left:none;border-bottom:solid;border-right:solid;padding:0in 5.4pt 0in 5.4pt;}
- td.c25 {width:90.9pt;border:solid;border-top:none;padding:0in 5.4pt 0in 5.4pt;}
- span.c24 {color:}
- th.c23 {width:76.5pt;border-top:none;border-left:none;border-bottom:solid;border-right:solid;padding:0in 5.4pt 0in 5.4pt;}
- th.c22 {width:81.0pt;border-top:none;border-left:none;border-bottom:solid;border-right:solid;padding:0in 5.4pt 0in 5.4pt;}
- th.c21 {width:135.0pt;border-top:none;border-left:none;border-bottom:solid;border-right:solid;padding:0in 5.4pt 0in 5.4pt;}
- th.c20 {width:1.0in;border-top:none;border-left:none;border-bottom:solid;border-right:solid;padding:0in 5.4pt 0in 5.4pt;}
- th.c19 {width:189.0pt;border-top:none;border-left:none;border-bottom:solid;border-right:solid;padding:0in 5.4pt 0in 5.4pt;}
- th.c18 {width:90.9pt;border:solid;border-top:none;padding:0in 5.4pt 0in 5.4pt;}
- p.c17 {line-height: normal; margin-bottom: .0001pt; text-align: center}
- th.c16 {width:8.95in;border:solid;padding:0in 5.4pt 0in 5.4pt;}
- td.c15 {width:3.5in;border-top:none;border-left:none;border-bottom:solid;border-right:solid;padding:0in 5.4pt 0in 5.4pt;}
- td.c14 {width:225.9pt;border:solid;border-top:none;padding:0in 5.4pt 0in 5.4pt;}
- td.c13 {width:364.5pt;border-top:none;border-left:none;border-bottom:solid;border-right:solid;padding:0in 5.4pt 0in 5.4pt;}
- td.c12 {width:113.4pt;border:solid;border-top:none;padding:0in 5.4pt 0in 5.4pt;}
- td.c11 {width:364.5pt;border:solid;border-left:none;padding:0in 5.4pt 0in 5.4pt;}
- td.c10 {width:113.4pt;border:solid;padding:0in 5.4pt 0in 5.4pt;}
- span.c9 {font-size:14.0pt; background:lightgrey;}
- table.c8 {border-collapse:collapse;border:none;}
- td.c7 {width:4.7in;border-top:none;border-left:none;border-bottom:solid;border-right:solid;padding:0in 5.4pt 0in 5.4pt;}
- td.c6 {width:1.95in;border:solid;border-top:none;padding:0in 5.4pt 0in 5.4pt;}
- td.c5 {width:4.7in;border:solid;border-left:none;padding:0in 5.4pt 0in 5.4pt;}
- td.c4 {width:1.95in;border:solid;padding:0in 5.4pt 0in 5.4pt;}
- p.c3 {margin-bottom:.0001pt;line-height:normal;}
- span.c2 {line-height:115%; font-size:14.0pt; background:lightgrey;}
- span.c1 {margin-bottom:.0001pt;line-height:normal;}
- /*]]>*/
- </style>
- </head>
- <body>
- <div id="wrapper">
- <!--Case Western Reserve University Header-->
- <iframe src="http://www.case.edu/headers/casedotheader.html" width="100%" height="87"
- frameborder="0" scrolling="no"></iframe>
- <!--School, college, center or department name-->
- <h1 id="subsite"><a href="https://www.case.edu/projects/datawarehouse">Case Data
- Warehouse</a></h1><!--Page title or name: used for orientation-->
- <div id="legend">
- <div id="legendLEFT">
- <h2>Data Warehouse Report Catalog</h2>
- </div>
- </div><!--Page Content-->
- <div id="content">
- <!--Left-hand Navigation-->
- <!--#include virtual="/projects/datawarehouse/dwnavigation.html" -->
- <!--ONE-COLUMN simple page-->
- <div class="MsoNormal" id="main2col">
- <h2><span class="MsoNormal c1">HCM-Charity Choice</span></h2>
- <p class="MsoNormal"><a href=
- "https://www.case.edu/projects/datawarehouse/catalog/HCM/HCM.html">Return to HCM
- Reports</a></p>
- <p class="MsoNormal"><span class="c2">Request Information</span></p>
- <table class="modbox c8" border="1" cellspacing="0" cellpadding="0">
- <tr>
- <td valign="top" class="c4">
- <p class="MsoNormal c3">Requestor Name or ID</p>
- </td>
- <td valign="top" class="c5">
- <p class="MsoNormal c3">Elizabeth Juchno</p>
- </td>
- </tr>
- <tr>
- <td valign="top" class="c6">
- <p class="MsoNormal c3">Application/Department</p>
- </td>
- <td valign="top" class="c7">
- <p class="MsoNormal c3">Human Resources  </p>
- </td>
- </tr>
- </table>
- <p class="MsoNormal"> </p>
- <p class="MsoNormal"><span class="c9">Report General Information</span></p>
- <table class="modbox c8" border="1" cellspacing="0" cellpadding="0">
- <tr>
- <td valign="top" class="c10">
- <p class="MsoNormal c3">Report Title</p>
- </td>
- <td colspan="2" valign="top" class="c11">
- <p class="MsoNormal c3">HCM-Charity Choice</p>
- </td>
- </tr>
- <tr>
- <td valign="top" class="c12">
- <p class="MsoNormal c3">Description/Purpose</p>
- </td>
- <td colspan="2" valign="top" class="c13">
- <p class="MsoNormal c3">Summary of Charity Choice donations by Department,
- Federation and UGEN breakdown.</p>
- </td>
- </tr>
- <tr>
- <td valign="top" class="c12">
- <p class="MsoNormal c3">Folder</p>
- </td>
- <td colspan="2" valign="top" class="c13">
- <p class="MsoNormal c3">HCM-Charity Choice</p>
- </td>
- </tr>
- <tr>
- <td colspan="2" valign="top" class="c14">
- <p class="MsoNormal c3">Report Example/Prototype Available (Y/N)</p>
- </td>
- <td valign="top" class="c15">
- <p class="MsoNormal c3">Y</p>
- </td>
- </tr>
- </table>
- <p class="MsoNormal"> </p>
- <p class="MsoNormal"><span class="c9">Report Field Details</span></p>
- <table class="modbox c8" border="1" cellspacing="0" cellpadding="0">
- <tr>
- <th colspan="6" valign="bottom" class="c16" scope="col">
- <p class="MsoNormal c3"><strong>Departments Tab</strong></p>
- </th>
- </tr>
- <tr>
- <th valign="bottom" class="c18" scope="col">
- <p class="MsoNormal c17"><strong>Column Header</strong></p>
- </th>
- <th valign="bottom" class="c19" scope="col">
- <p class="MsoNormal c17"><strong>Report Field</strong></p>
- </th>
- <th valign="bottom" class="c20" scope="col">
- <p class="MsoNormal c17"><strong>Format</strong></p>
- </th>
- <th valign="bottom" class="c21" scope="col">
- <p class="MsoNormal c17"><strong>Calculation (if applicable)</strong></p>
- </th>
- <th valign="bottom" class="c22" scope="col">
- <p class="MsoNormal c17"><strong>Sort Order (Asc or Desc)</strong></p>
- </th>
- <th valign="bottom" class="c23" scope="col">
- <p class="MsoNormal c17"><strong>Sum/Count/% (if applicable)</strong></p>
- </th>
- </tr>
- <tr>
- <td valign="bottom" class="c25">
- <p class="MsoNormal"><span class="c24">Department</span></p>
- </td>
- <td valign="bottom" class="c26">
- <p class="MsoNormal"><span class="c24">=[School]</span></p>
- </td>
- <td valign="top" class="c27">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c28">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c29">
- <p class="MsoNormal c3">Asc</p>
- </td>
- <td valign="top" class="c30">
- <p class="MsoNormal c3"> </p>
- </td>
- </tr>
- <tr>
- <td valign="bottom" class="c25">
- <p class="MsoNormal"><span class="c24"># of Participants</span></p>
- </td>
- <td valign="bottom" class="c26">
- <p class="MsoNormal"><span class="c24">=Count([Employee ID (NO
- RLS)])</span></p>
- </td>
- <td valign="top" class="c27">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c28">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c29">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c30">
- <p class="MsoNormal c3">Sum</p>
- </td>
- </tr>
- <tr>
- <td valign="bottom" class="c25">
- <p class="MsoNormal"><span class="c24">Payroll Deduction</span></p>
- </td>
- <td valign="bottom" class="c26">
- <p class="MsoNormal"><span class="c24">=[Employee Email]</span></p>
- </td>
- <td valign="top" class="c27">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c28">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c29">
- <p class="MsoNormal c3">Â </p>
- </td>
- <td valign="top" class="c30">
- <p class="MsoNormal c3">Sum</p>
- </td>
- </tr>
- <tr>
- <td valign="bottom" class="c25">
- <p class="MsoNormal"><span class="c24">Check Amount</span></p>
- </td>
- <td valign="bottom" class="c26">
- <p class="MsoNormal"><span class="c24">=[Employee Status Code]</span></p>
- </td>
- <td valign="top" class="c27">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c28">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c29">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c30">
- <p class="MsoNormal c3">Sum</p>
- </td>
- </tr>
- <tr>
- <td valign="bottom" class="c25">
- <p class="MsoNormal"><span class="c24">Total Contribution</span></p>
- </td>
- <td valign="bottom" class="c26">
- <p class="MsoNormal"><span class="c24">=[Employee Class Long
- Desc]</span></p>
- </td>
- <td valign="top" class="c27">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c28">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c29">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c30">
- <p class="MsoNormal c3">Sum</p>
- </td>
- </tr>
- <tr>
- <td colspan="6" valign="bottom" class="c31">
- <p class="MsoNormal c3"><strong><span class="c24">Federations
- Tab</span></strong></p>
- </td>
- </tr>
- <tr>
- <th valign="bottom" class="c18" scope="col">
- <p class="MsoNormal c17"><strong>Column Header</strong></p>
- </th>
- <th valign="bottom" class="c19" scope="col">
- <p class="MsoNormal c17"><strong>Report Field</strong></p>
- </th>
- <th valign="bottom" class="c20" scope="col">
- <p class="MsoNormal c17"><strong>Format</strong></p>
- </th>
- <th valign="bottom" class="c21" scope="col">
- <p class="MsoNormal c17"><strong>Calculation (if applicable)</strong></p>
- </th>
- <th valign="bottom" class="c22" scope="col">
- <p class="MsoNormal c17"><strong>Sort Order (Asc or Desc)</strong></p>
- </th>
- <th valign="bottom" class="c23" scope="col">
- <p class="MsoNormal c17"><strong>Sum/Count/% (if applicable)</strong></p>
- </th>
- </tr>
- <tr>
- <td valign="bottom" class="c25">
- <p class="MsoNormal">Federation</p>
- </td>
- <td valign="bottom" class="c26">
- <p class="MsoNormal"><span class="c24">=[Deduction Code]</span></p>
- </td>
- <td valign="top" class="c27">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c28">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c29">
- <p class="MsoNormal c3">Asc</p>
- </td>
- <td valign="top" class="c30">
- <p class="MsoNormal c3"> </p>
- </td>
- </tr>
- <tr>
- <td valign="bottom" class="c25">
- <p class="MsoNormal"><span class="c24"># of Participants</span></p>
- </td>
- <td valign="bottom" class="c26">
- <p class="MsoNormal"><span class="c24">=Count([Employee ID (NO
- RLS)])</span></p>
- </td>
- <td valign="top" class="c27">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c28">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c29">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c30">
- <p class="MsoNormal c3">Sum</p>
- </td>
- </tr>
- <tr>
- <td valign="bottom" class="c25">
- <p class="MsoNormal"><span class="c24">Payroll Deduction</span></p>
- </td>
- <td valign="bottom" class="c26">
- <p class="MsoNormal"><span class="c24">=[Employee Email]</span></p>
- </td>
- <td valign="top" class="c27">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c28">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c29">
- <p class="MsoNormal c3">Â </p>
- </td>
- <td valign="top" class="c30">
- <p class="MsoNormal c3">Sum</p>
- </td>
- </tr>
- <tr>
- <td valign="bottom" class="c25">
- <p class="MsoNormal"><span class="c24">Check Amount</span></p>
- </td>
- <td valign="bottom" class="c26">
- <p class="MsoNormal"><span class="c24">=[Employee Status Code]</span></p>
- </td>
- <td valign="top" class="c27">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c28">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c29">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c30">
- <p class="MsoNormal c3">Sum</p>
- </td>
- </tr>
- <tr>
- <td valign="bottom" class="c25">
- <p class="MsoNormal"><span class="c24">Total Contribution</span></p>
- </td>
- <td valign="bottom" class="c26">
- <p class="MsoNormal"><span class="c24">=[Employee Class Long
- Desc]</span></p>
- </td>
- <td valign="top" class="c27">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c28">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c29">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c30">
- <p class="MsoNormal c3">Sum</p>
- </td>
- </tr>
- <tr>
- <th colspan="6" valign="bottom" class="c32" scope="col">
- <p class="MsoNormal c3"><strong>UGEN Summary Tab</strong></p>
- </th>
- </tr>
- <tr>
- <th valign="bottom" class="c18" scope="col">
- <p class="MsoNormal c17"><strong>Column Header</strong></p>
- </th>
- <th valign="bottom" class="c19" scope="col">
- <p class="MsoNormal c17"><strong>Report Field</strong></p>
- </th>
- <th valign="bottom" class="c20" scope="col">
- <p class="MsoNormal c17"><strong>Format</strong></p>
- </th>
- <th valign="bottom" class="c21" scope="col">
- <p class="MsoNormal c17"><strong>Calculation (if applicable)</strong></p>
- </th>
- <th valign="bottom" class="c22" scope="col">
- <p class="MsoNormal c17"><strong>Sort Order (Asc or Desc)</strong></p>
- </th>
- <th valign="bottom" class="c23" scope="col">
- <p class="MsoNormal c17"><strong>Sum/Count/% (if applicable)</strong></p>
- </th>
- </tr>
- <tr>
- <th valign="bottom" class="c18" scope="col">
- <p class="MsoNormal c17"><strong> </strong></p>
- </th>
- <th valign="bottom" class="c19" scope="col">
- <p class="MsoNormal c17"><strong> </strong></p>
- </th>
- <th valign="bottom" class="c20" scope="col">
- <p class="MsoNormal c17"><strong> </strong></p>
- </th>
- <th valign="bottom" class="c21" scope="col">
- <p class="MsoNormal c17"><strong> </strong></p>
- </th>
- <th valign="bottom" class="c22" scope="col">
- <p class="MsoNormal c17"><strong> </strong></p>
- </th>
- <th valign="bottom" class="c23" scope="col">
- <p class="MsoNormal c17"><strong> </strong></p>
- </th>
- </tr>
- <tr>
- <th valign="bottom" class="c18" scope="col">
- <p class="MsoNormal c3">UGEN Department</p>
- </th>
- <th valign="bottom" class="c19" scope="col">
- <p class="MsoNormal c3">=[UGEN Department]</p>
- </th>
- <th valign="bottom" class="c20" scope="col">
- <p class="MsoNormal c17"> </p>
- </th>
- <th valign="bottom" class="c21" scope="col">
- <p class="MsoNormal c3">Â </p>
- </th>
- <th valign="bottom" class="c22" scope="col">
- <p class="MsoNormal c3">Asc</p>
- </th>
- <th valign="bottom" class="c23" scope="col">
- <p class="MsoNormal c17"> </p>
- </th>
- </tr>
- <tr>
- <td valign="bottom" class="c25">
- <p class="MsoNormal"><span class="c24"># of Participants</span></p>
- </td>
- <td valign="bottom" class="c26">
- <p class="MsoNormal"><span class="c24">=Count([Employee ID (NO
- RLS)])</span></p>
- </td>
- <td valign="top" class="c27">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c28">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c29">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c30">
- <p class="MsoNormal c3">Sum</p>
- </td>
- </tr>
- <tr>
- <td valign="bottom" class="c25">
- <p class="MsoNormal"><span class="c24">Payroll Deduction</span></p>
- </td>
- <td valign="bottom" class="c26">
- <p class="MsoNormal"><span class="c24">=[Employee Email]</span></p>
- </td>
- <td valign="top" class="c27">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c28">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c29">
- <p class="MsoNormal c3">Â </p>
- </td>
- <td valign="top" class="c30">
- <p class="MsoNormal c3">Sum</p>
- </td>
- </tr>
- <tr>
- <td valign="bottom" class="c25">
- <p class="MsoNormal"><span class="c24">Check Amount</span></p>
- </td>
- <td valign="bottom" class="c26">
- <p class="MsoNormal"><span class="c24">=[Employee Status Code]</span></p>
- </td>
- <td valign="top" class="c27">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c28">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c29">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c30">
- <p class="MsoNormal c3">Sum</p>
- </td>
- </tr>
- <tr>
- <td valign="bottom" class="c25">
- <p class="MsoNormal"><span class="c24">Total Contribution</span></p>
- </td>
- <td valign="bottom" class="c26">
- <p class="MsoNormal"><span class="c24">=[Employee Class Long
- Desc]</span></p>
- </td>
- <td valign="top" class="c27">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c28">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c29">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c30">
- <p class="MsoNormal c3">Sum</p>
- </td>
- </tr>
- <tr>
- <td valign="bottom" class="c25">
- <p class="MsoNormal c3"><strong><span class="c24">UGEN Detail
- Tab</span></strong></p>
- </td>
- <td valign="bottom" class="c26">
- <p class="MsoNormal"><span class="c24"> </span></p>
- </td>
- <td valign="top" class="c27">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c28">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c29">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c30">
- <p class="MsoNormal c3"> </p>
- </td>
- </tr>
- <tr>
- <td valign="bottom" class="c25">
- <p class="MsoNormal c17"><strong>Column Header</strong></p>
- </td>
- <td valign="bottom" class="c26">
- <p class="MsoNormal c17"><strong>Report Field</strong></p>
- </td>
- <td valign="bottom" class="c27">
- <p class="MsoNormal c17"><strong>Format</strong></p>
- </td>
- <td valign="bottom" class="c28">
- <p class="MsoNormal c17"><strong>Calculation (if applicable)</strong></p>
- </td>
- <td valign="bottom" class="c29">
- <p class="MsoNormal c17"><strong>Sort Order (Asc or Desc)</strong></p>
- </td>
- <td valign="bottom" class="c30">
- <p class="MsoNormal c17"><strong>Sum/Count/% (if applicable)</strong></p>
- </td>
- </tr>
- <tr>
- <td valign="bottom" class="c25">
- <p class="MsoNormal c3">UGEN Department</p>
- </td>
- <td valign="bottom" class="c26">
- <p class="MsoNormal c3">=[UGEN Department]</p>
- </td>
- <td valign="bottom" class="c27">
- <p class="MsoNormal c17"> </p>
- </td>
- <td valign="bottom" class="c28">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="bottom" class="c29">
- <p class="MsoNormal c3">Asc</p>
- </td>
- <td valign="bottom" class="c30">
- <p class="MsoNormal c17"> </p>
- </td>
- </tr>
- <tr>
- <td valign="bottom" class="c25">
- <p class="MsoNormal"><span class="c24">Dept ID</span></p>
- </td>
- <td valign="bottom" class="c26">
- <p class="MsoNormal"><span class="c24">=[Department ID]</span></p>
- </td>
- <td valign="top" class="c27">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c28">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c29">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c30">
- <p class="MsoNormal c3">Sum</p>
- </td>
- </tr>
- <tr>
- <td valign="bottom" class="c25">
- <p class="MsoNormal"><span class="c24">Dept Name</span></p>
- </td>
- <td valign="bottom" class="c26">
- <p class="MsoNormal"><span class="c24">=[Department Long Desc]</span></p>
- </td>
- <td valign="top" class="c27">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c28">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c29">
- <p class="MsoNormal c3">Â </p>
- </td>
- <td valign="top" class="c30">
- <p class="MsoNormal c3">Sum</p>
- </td>
- </tr>
- <tr>
- <td valign="bottom" class="c25">
- <p class="MsoNormal"><span class="c24">Total Contribution</span></p>
- </td>
- <td valign="bottom" class="c26">
- <p class="MsoNormal"><span class="c24">=[Employee Class Long
- Desc]</span></p>
- </td>
- <td valign="top" class="c27">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c28">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c29">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c30">
- <p class="MsoNormal c3">Sum</p>
- </td>
- </tr>
- <tr>
- <td valign="bottom" class="c25">
- <p class="MsoNormal"><span class="c24"># of Participants</span></p>
- </td>
- <td valign="bottom" class="c26">
- <p class="MsoNormal"><span class="c24">=Count([Employee ID (NO
- RLS)])</span></p>
- </td>
- <td valign="top" class="c27">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c28">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c29">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c30">
- <p class="MsoNormal c3">Sum</p>
- </td>
- </tr>
- </table>
- <p class="MsoNormal"><span class="c9"> </span></p>
- <p class="MsoNormal"><span class="c9">Results Information</span></p>
- <table class="modbox c8" border="1" cellspacing="0" cellpadding="0">
- <tr>
- <td valign="top" class="c35">
- <p class="MsoNormal c34">Report Body Format:<span class=
- "c33">Â Â Â Â Table
- XÂ Â Â Â Â Â Â
- Cross-tab</span> <span class=
- "c33">Â Â Â Â Â Â Â Graph</span></p>
- </td>
- </tr>
- <tr>
- <td valign="top" class="c36">
- <p class="MsoNormal c34">Drill Down
- Options:Â Â Â Â Â Â
- X <span class="c33">No Drill
- Down           <br />
- <a name="Check45" id="Check45"></a></span> <span class=
- "c33">Â Use Drill Down: Provide fields & drill down
- order:<br />
- Field #1<a name="Text16" id="Text16"></a></span><u><span class=
- "c33"> </span></u> <span class=
- "c33">Â Â Â Â Â Â Â Â Â Â Â Â
- Field #3<a name="Text17" id="Text17"></a></span><u><span class=
- "c33"> </span></u> <span class=
- "c33">Â Â Â Â Â Â Â Â Â Â Â Â
- Field #5</span><u><span class=
- "c33"> </span></u></p>
- <p class="MsoNormal c3"><span class=
- "c33">Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â
- Field #2<a name="Text18" id="Text18"></a></span><u><span class=
- "c33"> </span></u> <span class=
- "c33">Â Â Â Â Â Â Â Â Â Â Â Â
- Field #4</span><u><span class=
- "c33"> </span></u><span class=
- "c33">Â Â Â Â Â Â Â Â Â Â Â Â
- Field #6</span><u><span class=
- "c33"> </span></u></p>
- </td>
- </tr>
- </table>
- <p class="MsoNormal"> </p>
- <p class="MsoNormal"><span class="c9">Condition Information</span></p>
- <table class="modbox c8" border="1" cellspacing="0" cellpadding="0">
- <tr>
- <th valign="top" class="c37" scope="col">
- <p class="MsoNormal c17">Fields</p>
- </th>
- <th valign="top" class="c38" scope="col">
- <p class="MsoNormal c17">Condition (=, >, <,etc)</p>
- </th>
- <th valign="top" class="c39" scope="col">
- <p class="MsoNormal c17">Value</p>
- </th>
- </tr>
- <tr>
- <td valign="bottom" class="c40">
- <p class="MsoNormal"><span class="c24">Max(EFF DATE)</span></p>
- </td>
- <td valign="bottom" class="c41">
- <p class="MsoNormal"><span class="c24"> </span></p>
- </td>
- <td valign="bottom" class="c42">
- <p class="MsoNormal"><span class="c24"> </span></p>
- </td>
- </tr>
- </table>
- <p class="MsoNormal"> </p>
- <p class="MsoNormal"><span class="c9">Prompt Information</span></p>
- <table class="modbox c8" border="1" cellspacing="0" cellpadding="0">
- <tr>
- <th valign="bottom" class="c43" scope="col">
- <p class="MsoNormal c17">Prompt Fields</p>
- </th>
- <th valign="bottom" class="c44" scope="col">
- <p class="MsoNormal c17">Prompt Text</p>
- </th>
- <th valign="bottom" class="c45" scope="col">
- <p class="MsoNormal c17">Range (Y/N)</p>
- </th>
- <th valign="bottom" class="c46" scope="col">
- <p class="MsoNormal c17">Include List of Values (Y/N)</p>
- </th>
- <th valign="bottom" class="c47" scope="col">
- <p class="MsoNormal c17">Mono/Multi</p>
- </th>
- </tr>
- <tr>
- <td valign="top" class="c48">
- <p class="MsoNormal c3">Year</p>
- </td>
- <td valign="top" class="c49">
- <p class="MsoNormal c3">Enter Year</p>
- </td>
- <td valign="top" class="c50">
- <p class="MsoNormal c3">N</p>
- </td>
- <td valign="top" class="c51">
- <p class="MsoNormal c3">Y</p>
- </td>
- <td valign="top" class="c52">
- <p class="MsoNormal c3">MONO</p>
- </td>
- </tr>
- <tr>
- <td valign="top" class="c48">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c49">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c50">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c51">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c52">
- <p class="MsoNormal c3"> </p>
- </td>
- </tr>
- </table>
- <p class="MsoNormal"> </p>
- <p class="MsoNormal"><span class="c9">Schedule Information</span></p>
- <table class="modbox c8" border="1" cellspacing="0" cellpadding="0">
- <tr>
- <th valign="bottom" class="c43" scope="col">
- <p class="MsoNormal c17">Schedule Frequency (Daily, Weekly, Monthly,
- etc)</p>
- </th>
- <th valign="bottom" class="c53" scope="col">
- <p class="MsoNormal c17">Schedule Time</p>
- </th>
- </tr>
- <tr>
- <td valign="top" class="c48">
- <p class="MsoNormal c3"> </p>
- </td>
- <td valign="top" class="c54">
- <p class="MsoNormal c3">N/A</p>
- </td>
- </tr>
- </table>
- <p class="MsoNormal"> </p>
- <p class="MsoNormal"><a href=
- "https://www.case.edu/projects/datawarehouse/catalog/HCM/HCM.html">HCM
- Reports</a></p>
- </div><!--End #main2col or main column-->
- </div><!--End #content-->
- </div><!--End #wrapper-->
- <!--Footer-->
- <!--#include virtual="/projects/datawarehouse/dwfooter.html" -->
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment