Ranger 6/12/2018 3:21:55 PM

UPR00111 relationship enum


is there a setup table (lookup table) for "relationship" on the UPR00111 table?

I'm re-writing my employee self-service portal in MVC and need to know where that number comes from.

The weird thing is, that on the Contacts table (UPR00113), the relationship field (named "emergencyrelation") has text in it (like "wife", "self").  so not sure why the field lookup would change from contacts to dependents.

However, the dependents table currently only has a value of "7", which is "self" on every record, which I suppose is for employee benefit purposes. 

But, If I want to allow the employee to add new dependents, then go to our insurance provider to auto-update new kids or whatever, it would be nice to know the lookup.



Version: GP 2013
Section: .NET Development, Dynamics GP

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables