The User can specify and assign the details of any search then save that search (a30_user preferences). For future PTS sessions, these Default Saved Search and Filter settings are applied to the Project list.
The user can compile reports/saved searches using any of the data elements from the 4 tabs below
Note: many combinations of query will not produce results, due to incomplete data, null fields etc ..
TAB-1 GENERAL
DATA ELEMENT OR BUTTON | DESCRIPTION |
SECTION | values  |
OPI | Office of primary interest - Name of CAW project originator  |
INCLUDE OTI | Office of tertiary interest - Secondary OPI’s |
PRODUCT TYPE | values  |
CATEGORY | Activated by Selecting Aircraft as Product_type . Provides dropdowns for Category or Aircraft  |
ADD MANUFACTURER | Select manufacturer name  |
ADD | Click ADD, system retrieves all Models for that manufacturer. Press ctnl/highlight select models. Then (if desired) select another manufacturer and repeat the process |
MANUFACTURER | by cycling through the ADD option, the user can select any number of manufacturers for lookup provided they are all of the same product type  |
MODEL | Press ctnl/highlight select models. This can be done for multiple manufacturers |
CANADIAN STATE OF DESIGN | click box, restrict this search to only CF State of design to models |
REMOVE | remove any unwanted manufacturers/models from the search query |
CATEGORY | Lessons learned category  |
TEXT | Lessons learned freeform text search |
TAB-2 PROJECT INFORMATION
DATA ELEMENT OR BUTTON | DESCRIPTION |
NUMBER | PROJECT NUMBER |
NAME | Freeform text of project name/subject |
TYPE CATEGORY | values  |
TYPE | values  |
DETAILS | freeform text search of project details |
PRIORITY | values  |
STATUS | values  |
DATE LAST UPDATED | date range |
DATE START | date range |
DATE DUE | date range |
DATE COMPLETED | date range |
BF DATE | date range |
ACCIDENT OCCURRENCE DATE | date range |
TAB-3 ACCIDENT INVESTIGATION
DATA ELEMENT OR BUTTON | DESCRIPTION |
FATALITIES | numeric |
CONTROL NO | TSB-control-nbr from M30 |
ATTENDEE NAME | freeform text, party_id on I02 |
ATTENDEE POSITION | values  |
COUNTRY | select country (Type certificate Holder country -or- Country where Canadian TCH aircraft/Canadian registered aircraft had incident)  |
OBSERVATIONS | freeform text search |
ANALYSIS | freeform text search |
REGISTRATION MARK | aircraft tail mark - can be Canadian or any nationality |
AIRCRAFT OWNER | owner |
PART NO | Part number |
SERIAL NO | Aircraft Serial number |
ANALYSIS ORG | freeform text search |
TAB-4 OTHER
DATA ELEMENT OR BUTTON | DESCRIPTION |
COMMENTS | freeform text search |
SDR NO | SDR_number from M72 table |
OUTPUT TYPE | project output  |
ACTION REQUIRED BY | freeform text search |
JASC | Select JASC/ATA code pertaining to this project  |
Add Comment