GEN Table Relationships

Does anyone have an ERD for the GEN table relationships. Looking to create ODBC connection to be able to monitor and assign Print Groups, Distribution Groups, etc.

Thanks,

Dan

Find more posts tagged with

Comments

moellerg

I do. It's rather large, so I don't think I can just send it to you..... I'm not in front of it at the moment, so I can't even tell you how large it is... I'll look later tonight.

moellerg

Mine's 157M. (web pages, and images) ---- I'll try to attach it here... but... no guarantees.

Infor WFM UG Self Scheduling - July 2022.pdf

moellerg

yep. "error uploading" -- can you take a ~124MB email? If so, I'll gladly send you it.

moellerg

Or you can generate your own....
Download SchemaSpy (sourceforge.net/.../) and the required programs for it, (http://www.graphviz.org/) and optionally SchemaSpyGUI (schemaspygui.sourceforge.net/) and generate the relationships.

*Note: This is only as good as the relationships that are already built in the database.. but it'll go through and give you the field names from the tables and from there, you can kinda wing it.

moellerg

You can see examples of what it will produce (for MSCM and LBI) here: www.lawsonguru.com/.../DatabaseERDs.aspx

Legacy Contributor

Hi Greg, please email me a copy also. This is good stuff. I have been looking for this ERD for awhile.

Tom.

Legacy Contributor

my email is tddewey99@gmail.com

thanks again.

Tom.

gwhiteford

I would like a copy as well. My email address is: bcaporella@gmail.com my business email is: Barbara_caporella@mednax.com but I don't think a large email with go thru my business email so please send to my gmail account.
Thank you!!
Barbara

ustomer_interactions_form.docx

sean-howlin

This party looks too fun to pass up.

Greg, if it's not too much trouble, can you please add me to the list as well?
marilyn_sizemore@kindermorgan.com

thanks!

Legacy Contributor

I would like a copy as well. Please try to send to brenda.olson@thedacare.org. If that doesn't work try blo1025@tds.net.
Thanks much
b

Legacy Contributor

Can you send me the ERD for the GEN table as well?
Thanks
r.ross7@yahoo.com

Legacy Contributor

Greg, if you don't mind, I'd love a copy too. Please email to bmischley@iasishealthcare.com and bmish86@gmail.com

Hopefully one of them will be able to accept the file.

Thanks so much for your help!

sweta-priyadarshini

Greg,

I'd like a copy too please, though I know my email won't handle that file size.

Any chance you can make it available via dropbox or google drive or?

dbowen@mtholyoke.edu

Thanks,

Dennis

0911060553270289.pdf

Legacy Contributor

I would like a copy too please, although how I can access it I am unsure:
Peter.Barnes@ynhh.org

rm_benefit_administration_aca_training.pptx

dechevar

Greg,

Before you self publish on Amazon

, please send me a copy as well.

dechevar@premierhealth.com

Thanks,

Dan

cynthia-bushnaq

Would you please send me a copy too?

cbushnaq@att.net

Thanks,
Cindy

mpientak

I would like a copy as well - cpaine@iso-ne.com or cpaine216@gmail.com - thank you very much in advance.

Legacy Contributor

If I could get a copy as well, jstraight@sbcglobal.net, it would be much appreciated.

Thanks,
Joe

mpientak

Greg,

We cannot access drop box - is there an alternate way for you to send this?

moellerg

Can you access GoogleDrive?

Otherwise, you could download it from a home computer and put it on a thumb drive?

mpientak

I will try that - thank you ever so much Greg!!

moellerg

Has everyone that's requested a copy received either a DropBox or GoogleDrive link from me? If no, please respond.

John Thuente

Thank you Greg. Could I ask for a dropbox link please?
Be well.

JT

john.thuente@infor.com

carrolls

Requesting a dropbox link also ... pjohnston@grenergy.com
Thanks!

Legacy Contributor

Can you send me the ERD for the GEN table as well?
Thanks Greg. I appreciate it.
robin.metzler@lvh.com

deanna-plant

Requesting a dropbox link as well.
Deanna.Plant@blessinghealthsystem.org

Thank you!!!

Legacy Contributor

Please include me as well, jdixon@llbean.com
Thank you

Legacy Contributor

Requesting the dropbox link as well. lbrant@rhsnet.org

Thank you.

Legacy Contributor

Please send me the dropbox URL also:

tddewey99@gmail.com

thank you.

Tom

Jim Norbut

me also (thanks) : jnorbut@sbcglobal.net

Copyright © 2025 Infor. All rights reserved.