This is a frequent request from the publications unit
See PBI #115120 - As of February 2022, all inspection data was included on the 5008 page in a grid format which allows the user to add, delete, correct any bad data. The directions below are retained for backup purposes only
####################
The 5008 page and the AAIR entry page will ONLY display the inspection data for the most recent inspection.
Operators frequently enter an incorrect date, due to calendar issues on various browsers - or - they discover that data entered by the previous owner of that aircraft, is completely incorrect.
Enhancement request : The 5008 page requires a Grid displaying all inspections, so that the TC User can delete incorrect rows, then re-enter proper dates
For now, to deal with this issue,
1)get a list of all inspections against a that specific aircraft,
2) identify the bad record,
3) delete the bad record
4) return the request to the user, They may need to enter any “missing” inspect dates
...
SELECT SUBSTR(TO_CHAR(C07.AIRCRAFT_ID),1,8) AS ACID,
SUBSTR(Y02.AIRCRAFT_MARK_ID,1,4) AS MRK,
TO_CHAR(Y53.DATE_START_DTE,'YYYY-MM-DD') AS OWNER_START,
SUBSTR(GET_PARTY_INFO(Y53.PARTY_ID),1,25) AS OWNER,
TO_CHAR(DATE_INSPECT_DTE,'YYYY-MM-DD') AS INSPECTION_DATE,
SUBSTR(INSPECTED_BY_CD ,1,1) AS INBY, – (AMO OR AME)
SUBSTR(TRIM(INSPECTOR_AME_LICENSE_NUMBER_I ||
INSPECTOR_AMO_LICENSE_NUMBER_I ),1,12) || ' ' AS LICENSE_NO, --- (AMO OR AME number)
SUBSTR(INSPECTOR_NAME_OTHER_NM,1,25) AS WHO_INSPECTED
FROM C07_AIRCRAFT_INSPECTION C07 ,
...
Y02_AIRCRAFT_HISTORY Y02
WHERE Y53.AIRCRAFT_PARTY_LIST_ID = C07.AIRCRAFT_ID
AND Y02.AIRCRAFT_ID = C07.AIRCRAFT_ID
AND Y02.RUN_ID = 99
AND Y53.DATE_STOP_DTE IS NULL
AND C07.AIRCRAFT_ID IN (SELECT AIRCRAFT_ID FROM Y93_CCARCS_PREVIOUS_DAY
WHERE MARK IN ( 'FBQJXXXX')) /* WHERE XXXX IS THE DESIRED AIRCRAFT TAIL MARK */
AND C07.INSPECTION_TYPE_CD = 2
/* WE ONLY REPAIR TYPE 2. TYPE 1 IS TC INSPECTION - AND IS FIXABLE ONSCREEN */
ORDER BY Y02.AIRCRAFT_MARK_ID, C07.DATE_INSPECT_DTE DESC ;
...
DELETE FROM C07_INSPECTION
WHERE AIRCRAFT_ID = XXXXXXIN (SELECT AIRCRAFT_ID FROM Y93_CCARCS_PREVIOUS_DAY WHERE MARK IN ( 'XXXX'))
AND TO_CHAR(DATE_INSPECT_DTE,'YYYY-MM-DD') = 'XXXX-XX-DD';
...