Troubleshooting - How to locate Employee Emergency Contact Information using QODBC

Problem Description:

Is it possible to retrieve an employee's emergency contact information? If so, from what table?

Solution:

Employee Emergency Contact Information is added in QODBC V320. If you are using QODBC V319 or earlier QODBC version, then you need to download & install latest QODBC version for accessing Employee Emergency Contact Information.

You can download & install QODBC latest version by clicking here.

You need to refer below fields in Employee table for Emergency Contact information.

1. EmergencyContactsPrimaryContactName

2. EmergencyContactsPrimaryContactValue

3. EmergencyContactsPrimaryContactRelation

4. EmergencyContactsSecondaryContactName

5. EmergencyContactsSecondaryContactValue

6. EmergencyContactsSecondaryContactRelation