...
SQL statement
Expand | ||
---|---|---|
|
Columns Specification
Column | Description/ Location in APM |
---|---|
| The PIN number from the Personal Details. |
| The Gender number from the Personal Details. |
| The Full Name from the Personal Details. |
| The First Name from the Personal Details. |
| The Middle Name from the Personal Details. |
| The Last Name from the Personal Details. |
| The birthday Celebration Date in current year. |
| The number of celebration month in current year. |
| The celebration month in current year. |
| The celebration date in current year. |
| The week in current year. |
| The celebration day in current year. |
| The age the person is turning in current year. |
| The birth date from the Personal Details. |
| The birth place from the Personal Details. |
| The e-mail address from the Personal Details that has the highest priority. |
| The mobile phone from the Personal Details that has the highest priority. |
| The current rank from the Personal Details. |
| The employment organization id from the Personal Details. |
| The employment start date from the Personal Details. |
| The employment end date from the Personal Details. |
...