Does anyone have a database map? I need to know how to link the GHR/TA tables when it isn't obv

brian-yost

Hello,
I am tasked with re-writing S3 customized reports to now use the GHR/TA Infor tables. I am using Crystal Reports with Oracle ADO connection. Specifically, I am searching for the link that returns "Department Administrator".

If someone could take a look at the screen shot I supplied, you can see that it appears that HROrganizationUnit table might contain a field called: "DeptAdmin" but in reality, there is no field called "DeptAdmin" in the table called "HRORGANIZATIONUNIT", so this has me confused and at a roadblock trying to retrieve the department administrator for that position.

Many thanks for your time.
Mark

moellerg

You can generate your own, Mark. Download and install SchemaSpy, (schemaspy.sourceforge.net/) it's required package Graphviz, (http://www.graphviz.org/) and optionally but recommended SchemaSpyGUI (schemaspygui.sourceforge.net/).

Depending on the database, and schema filters, it may take a bit to run, but once you are done, you have interactive web pages that you can peruse.... the software will only report what (relationships, etc) that are actually in the database though.