hi,
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.
thanks,
george