How to add a database field in a customized crew list view

This article explains how to add a database field in a customized crew list view in APM

Open

In Adonis Personnel Manager (APM), go to Setup > General Codes > Locate the crew list view where you need to add the database field.

Open

Open the crew list view and locate the “Create View” tab where the SQL Statement is stored.

In this example, Add the email address of the crew member as what is in the Personal Details tab in APM.

In the existing SQL Statement, add the database table where the record is stored. Telecommunication records such as E-mail addresses, Home Phones, Office Phones, etc. are stored in database table PW001P0T. Add the database field in the select statement then press the OK button to save the changes