[Datamart-News] SFMA Datamart joins

[Datamart Support]

Many people have asked for a document that displays the proper SFMA Datamart joins. Upon this suggestion, I have created a file that will show this information in diagram form. It shows the 'All Acct Event' table joined to each 'Profile' table within the Datamart.

Please view the new pdf document on the Datamart website: Datamart<http://cms.oregon.egov.com/DAS/EGS/FBS/Pages/datamart.aspx#SFMA_Datamart_Tables>

Note: If a user is using an up-to-date 'Open Catalog Extension' (OCE), the coding within the oce will help to automatically join tables together. The Datamart join document will demonstrate the proper joins and in this case, all joins are set as 'simple'.

Note: The Profile table diagrams, within the file, only show the fields that are necessary to create the proper joins.

Please let me know if you have any additional questions. Thanks,

Aaron Wallace
Sr. Datamart Business Analyst
Department of Administrative Services
Data Classification: Level 1 - Published

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/datamart-news/attachments/20130626/96502ee2/attachment.html>