PTS SEARCHES AND REPORTS (CAWIS REPORTS MENU)

Owned by kurt.martin
Last updated: Nov 02, 2021
3 min read

 

REPORT OR BUTTON

DESCRIPTION

1-Lessons Learned

See Fig-1 - The Lessons learned report can be compiled in the same manner as Tab 1 of the Advanced Search , and then by including a character string for searching the Lessons learned text
PTS ADVANCED SEARCH

2-Cross-Project

See Fig-2 & 3 - The Cross project report can be compiled in the same manner as Tab 1 of the Advanced Search , and then by including a character string for text search of the PTS/TSB and AMOC modules

Sort by Applicabilty / Project Number

All versions of the project book output can be sorted by Model applicability or Project Number

3-Project Book Detailed

See Fig 4,5,6,7,8 Online counts for all project related subsystems

4-Project Book Summary (Preview)

Provides the user an Excel report (verified compatible with Office 365) containing the following tabs

  1. project book cover

  2. Section 1 - Statistical Overview - Project counts by year and quarter

  3. Section 2 - Airworthiness Publications

  4. Section 3 - Safety Recommendations and Advisories

  5. Section 4 - Project Progress

  6. Section 5 - Alternate Means of Compliance (AMOC)

 

 

5-Project Book Summary (Release)

The output from the “release” version is the same as the “preview” version.

The difference is, when producing the Release version, a LAST_PROJECT_BOOK_PRINT_DATE is written to TR47_CAWIS_GENERAL_PROPS (SYSDATE), which establishes the date baseline for counting going forward.

Any subsequent report will only return data where the issued date is >= LAST_PROJECT_BOOK_PRINT_DATE, or if there is no issue date (NULL - often the case for IN PROGRESS AMOCs)

6-My Project Book Summary

Same as 4-Project Book Summary,

-BUT-

Sections 2 through 5 only have counts compiled where OPI = The report requestor’s USERID

7-My Project Book Detailed

Same as 3-Project Book Detailed - provides online counts,

-BUT-

Tabs 2 through 5 only have counts compiled where OPI = The report requestor’s USERID

 

 

Fig-1

 

Fig-2

Fig-3

 

Fig-4

Fig-5

 

Fig-6

Fig-7

 

Fig-8

 

Notes :

Project Book Report & Last Print Date

If the “Last Printed Date” (LAST_PROJECT_BOOK_PRINT_DATE in table TR47_CAWIS_GENERAL_PROPS) gets set to an incorrect date (For instance: Project Book Summary (Release) is executed instead of Project Book Summary (Preview)) it can cause incomplete reports, later on.

Users with admin access can change this date as follows:

  1. Select “Code Table Admin” under the Admin section in the side menu

  2. Select “General”

  3. Select “General Properties” in the System section

  4. Select “LAST_PROJECT_BOOK_PRINT_DATE”

  5. Change date (Value) and Save