Data Dictionary for v20

[mknapp]

I have a client requesting the latest data dictionary.  The best I can find in the community is 17.2.  The KB is even more outdated (http://kb.act.com/app/answers/detail/a_id/22924) - that's for 2010.  

[Melville-Schellmann]

The links in this thread are all dead:

https://community.act.com/t5/ACC-Discussions/Act-18-0-Database-Assets-Datamodel-Dictionary-Diagram-D...

I have recently also requested updates and got no reaction so far:

https://community.act.com/t5/Act-Developer-s-Forum/Database-structure-documentation-outdated/m-p/344...

COULD SOMEBODY FROM SPI BE SO KIND to deliver up-to-date documentation NOW?

[JonTaylor]

Hi Andreas,

I'll speak with product team about getting updated versions of the Data Dictionary in some publicly available place. I'll post the links here once I have them.

Thanks for your patience.

[GLComputing]

I was just looking for this also ...

I also found this KB: http://kb.act.com/app/answers/detail/a_id/22924

The User Data is from 2010, and the Tables is 2008.

I clicked “No” to send the information via the site, but it just says “Thanks for your feedback”, without the dialogue box to enter the feedback.

[JonTaylor]

I'm in discussion with the Product team about getting copies of the up to date Data Dictionaries for v20 currently.

In the meantime, I've attached the most recent documentation I was able to dig up - which is the v19 Data Dictionaries from January 2017 - it should at least be more up to date than the old ones on the KB.

Once we've got up to date documentation, we'll see about getting them added to a KB or another resource page for use by ACCs/Developers.

ACTDataDictionaryDocumentV19.pdf ‏801 KB

[GLComputing]

Any luck with the documentation or updating the KB (and remove the Sage references)?

Also, the Act! Reader isn't needed anymore as we can use SSMS - which would also apply to a couple of other KBs:
http://kb.act.com/app/answers/detail/a_id/22989
http://kb.act.com/app/answers/detail/a_id/17538

[tmwilli]

To request or post corrections to the KB, there is a thread in ACC Lounge:

https://community.act.com/t5/Knowledgebase-Feedback/bd-p/KnowledgeBaseFeedback

or email Elise: Elise.O'Pry@swiftpage.com She appreciates receiving corrections, especially for dated KBs that reference Sage.

I sent in corrections regularly..

[Keith Ewen]

Hello all,

Please find attached an updated version of the Act! Data Dictionary for V20. Let me know if you have any questions.

Thanks,

Keith Ewen

Cloud Operations

ACTDataDictionaryDocument.pdf ‏808 KB

[agruss]

Thanks Keith

[Keith Ewen]

No problem Arthur.