...
| Page Properties | ||||
|---|---|---|---|---|
|
...
The view shows if there are any competence documents with not valid scans: where the “Validity ‘Validity of Scan” Scan’ in set to “N” 'N' for the employed crew/ staff.
View Sample
...
Mail data selection
All crew members employed under the current organization and units below that have at least one Competence document (Travel, Medical, Competence) without invalid without valid scan.
SQL Statement
VIEWID should be substituted with the id of the crew list view that you are creating in your system e.g. PW001SRV13 etc.
...
Column | Description/ Location in APM | ||
|---|---|---|---|
PINPin | PIN | ||
Full Name | Full name of the person in Perosonal Details. | ||
First Name | First name of the person in Perosonal Details. | ||
Last Name | Last name of the person in Perosonal Details. | ||
Middle Name | Middle Employment Start Date | Select from Personal Details > Employment > Employment State > Start Format dd/mm/yyyy | |
Employment End Date | Select from Personal Details > Employment > Employment State > End Format dd/mm/yyyy | ||
Name | Full name of the person in Perosonal Personal Details. | Organizaton | Current employment organization of the person in Perosonal Details.Format: L_F_M |
Rank | Current Rank of the person in Perosonal Personal Details. | ||
Document TypeCompetence Code | The type code of the competence document without scan record linked to the selected crew. | ||
Document CodeCompetence Text | The code name of the competence document record linked to the selected crew. | ||
Document NameCompetence Number | The name number of the competence document record linked to the selected crew. | ||
Issued Date Issued | The date issued from of the competence document record linked to the selected crew. | ||
Expiry Date | The expert expiry date of the competence document record linked to the selected crew. | ||
Comments | The comments added to the document record linked to the selected crew. |
Additional Information
...
Last Updated | Date / time last update action was done to this competence document |
Last Updated By | Login name who did last update action to this competence document |
Validity of Scan | 'N' |
Start Page
N/A