Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

HTML
 
 
<!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">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252" />
<title>Untitled 1</title>
</head>
<body>

 
 
<body>
 
<br/>
<table align="center" class="ms-rteTable-0" cellspacing="0" cellpadding="10" style="width: 100%; color: rgb(103, 103, 103);">
<tbody><tr class="ms-rteTableEvenRow-0" style="color: rgb(103, 103, 103);">
				<td class="style1" valign="top" style="width: 844px; color: rgb(103, 103, 103);"><p class="ms-rteFontFace-5" style="text-align: left;"><strong style="color: rgb(0, 51, 0);">
				Data Warehouse</strong><span class="ms-rteThemeForeColor-2-3"> </span></p>
<p style="text-align: left;"><span class="ms-rteFontSize-3 ms-rteFontFace-5">
Data Warehouse is a collection of tables, views, snapshots, and other objects 
designed for the purpose of reporting. For information on the main objects in 
the Data Warehouse, read the Technical Documentation.</span></p>
<p class="ms-rteFontSize-3 ms-rteFontFace-5">Some tables and views related to 
main tables are not included in the tech documentation. For specific information 
on those and other Data Warehouse&nbsp;tables and views, read the individual 
table/view comments in the <a href="http://panacea.fastmail.usf.edu/pls/ax_repo/f?p=1056:1">
MetaMart</a>.</p>
<ul class="ms-rteFontSize-3 ms-rteFontFace-5"><li><a href="https://usfpro1.forest.usf.edu/pls/repl0/mm.dwstatus">
				Data Warehouse status</a> </li>
<li><a href="https://usfpro1.forest.usf.edu/rtd/MM_DW_Table_Vw_Col_Com.pdf">Data 
Warehouse Technical Documentation</a> (main tables and views)</li>
<li><a href="https://webauth.usf.edu/login?service=https://usfpro1.forest.usf.edu/pls/ax_repo/cas.apex_gateway?p%3D1057:501:645779616716114:APP_DAD:/pls/ax_dwhouseCAS_GROUP:CAS1">
Request Data Warehouse access</a></li>
<li><a href="https://usfpro1.forest.usf.edu/pls/ax_dwhouse/f?p=1057:1">Data 
Warehouse Maintenance&nbsp;Application</a></li>
<li><a href="https://usfpro1.forest.usf.edu/pls/ax_dwhouse/f?p=104:1">Change 
your Data Warehouse Oracle password</a> (DWHOUSE)</li>
<li>
<a href="https://documents.health.usf.edu/display/UHP/Data+Warehouse+Reports+-+Email+Subscriptions">
Data Warehouse Reports - Email Subscriptions</a>&nbsp;&nbsp;</li>
<li><a href="https://usffl.service-now.com/navpage.do">Report a Data Warehouse 
issue</a></li></ul>
								<p class="ms-rteFontFace-5" style="color: rgb(0, 51, 0);">
				&nbsp;</p>
								<p class="ms-rteFontFace-5" style="color: rgb(0, 51, 0);">
				<strong class="ms-rteFontSize-3">Service Requests&nbsp;</strong></p>
<p style="text-align: left;"><span class="ms-rteFontSize-3 ms-rteFontFace-5">
<a href="http://usfweb2.usf.edu/EBSCentral/fpm/fpmebsparameters.asp">
USR Search Page</a>&nbsp;- Search for User Service Requests (USRs) in-progress and/or completed.</span></p>
<p style="text-align: left;"><span class="ms-rteFontSize-3 ms-rteFontFace-5">
<a href="http://usfweb2.usf.edu/EBSCentral/servicerequest.asp">
Submit USR</a>&nbsp;- Submit a User Service Request (USR).</span></p>
				<p style="text-align: left;">&nbsp;</p>
				<p class="ms-rteFontFace-5" style="color: rgb(0, 51, 0);">
				<strong class="ms-rteFontSize-3">Standards for Development and 
				Documentation&nbsp;</strong><br class="ms-rteFontSize-3 ms-rteFontFace-5"/></p>
<p style="text-align: left;"><span class="ms-rteFontSize-3 ms-rteFontFace-5">
<a href="https://documents.health.usf.edu/display/UHP/Standards+for+Developers+and+Report+Writers">
Read&nbsp;standards</a>&nbsp;for database tables and views, process and job documentation, 
and repository usage.&nbsp;</span></p></td>
<td class="style1" valign="top" style="width: 844px; color: rgb(103, 103, 103);"><p class="ms-rteFontFace-5" style="color: rgb(103, 103, 103);">
<span class="ms-rteFontSize-3 ms-rteThemeForeColor-9-5 ms-rteFontFace-5" style="color: rgb(103, 103, 103);">
<strong><span style="color: rgb(0, 51, 0);"><span>MetaMart</span> </span></strong><br style="color: rgb(0, 51, 0);"/><br style="color: rgb(0, 51, 0);"/></span><span class="ms-rteFontSize-3 ms-rteThemeForeColor-9-5 ms-rteFontFace-5" style="color: rgb(103, 103, 103);"><span>
The&nbsp;<a href="https://usfpro1.forest.usf.edu/pls/ax_repo/f?p=1056:1">MetaMart</a> 
is an interactive tool that allows business and technical users to easily locate 
information about USF enterprise business systems metadata. To bookmark the 
MetaMart use:&nbsp;<a href="https://usfpro1.forest.usf.edu/pls/ax_repo/f?p=1056:1">https://usfpro1.forest.usf.edu/pls/ax_repo/f?p=1056:1</a>, 
not the URL generated when you follow this link.</span></span></p>
<p class="ms-rteFontFace-5 ms-rteFontSize-3">Other data marts, such as <strong>
Hub Mart, DocMart, Finance Mart,&nbsp;IT Communications Mart, and Admissions Mart </strong>
are available through the <a href="https://usfpro1.forest.usf.edu/pls/ax_repo/f?p=103:1"><strong>
Data Marts Page</strong></a>.</p>
<p class="ms-rteFontFace-5" style="color: rgb(0, 51, 0);">
&nbsp;</p>
<p class="ms-rteFontFace-5" style="color: rgb(0, 51, 0);">
<strong class="ms-rteFontSize-3">Applications Manager&nbsp;(AppWorx)</strong><span class="ms-rteFontSize-3"> </span></p>
<p><span class="ms-rteFontFace-5 ms-rteFontSize-3">Applications Manager&nbsp;is an 
administrative <g class="gr_ gr_34 gr-alert gr_gramm gr_run_anim Grammar multiReplace" id="34" data-gr-id="34"><g class="gr_ gr_34 gr-alert gr_gramm gr_run_anim Grammar multiReplace" id="34" data-gr-id="34">
systems</g></g> automation tool with which Banner users can do process-dependent 
scheduling.</span></p>
<ul class="ms-rteFontFace-5 ms-rteFontSize-3"><li><a href="https://usfpro1.forest.usf.edu/pls/repl0/appworx_doc.reports">
				Applications Manager&nbsp;process/job&nbsp;documentation</a>&nbsp;(PDFs)</li>
<li>
<a href="https://documents.health.usf.edu/pages/viewpage.action?pageId=404329425">
AppWorx Documentation System</a>&nbsp;(requires login)</li>
<li>Applications Manager (requires login)</li>
<ul><li><a href="http://131.247.240.38:5050/AMPROD/Client.jnlp">Production 
				instance</a>&nbsp;(AMPROD)</li>
<li><a href="http://131.247.240.37:5050/AMUAT/Client.jnlp">Test instance</a>&nbsp;(AMUAT)</li>
<li><a href="http://131.247.240.36:5050/AMUATU/Client.jnlp">Test upgrade 
instance </a>(AMUATU)</li>
<li><a href="http://131.247.240.31:5050/AMDVLP/Client.jnlp">Development instance</a>&nbsp;(AMDVLP)</li>
<li><a href="http://131.247.240.32:5050/AMDVLPU/Client.jnlp">Development upgrade 
instance</a> (AMDVLPU)</li></ul>
<li><a href="https://usfpro1.forest.usf.edu/pls/repl0/appworx_doc.appworx_index">
Applications Manager policies</a>&nbsp;</li></ul></td></tr>
								</tbody></table>
<a class="ms-rteFontSize-3 ms-rteFontFace-5" href="/ais/services/Pages/Oracle_SQL_Resources.aspx"></a><center><br/><br/><br/>
The IT State and Operational Reporting Group operates within the University Services Division of Information Technologies, SVC4010, <a href="mailto:AISteam@usf.edu">AISteam@usf.edu</a></center>
 <center><a href="mailto:AISteam@usf.edu"></a><a href="mailto:AISteam@usf.edu"></a>&#160;</center>
 

</body>

</body>
</html>