The User can specify and assign the details of any search then save that search to user preferences. For future PTS sessions, this 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  |
0 Comments