CASI Aircraft assignment data entry Error

Owned by Sufyan Maghur
Jul 13, 2023
1 min read

This is an issue when a USER enters the wrong information and creates a record for a newer year. FTAE doesn’t allow users to change previous Fiscal Year data

Example user entered wrong Aircraft Type for Fiscal Year 21/22 and requested a change

Or the user has requested a delete of a Fiscal Year so that they can enter new data

To fix this data Login to TOAD Data is stored in 2 Tables to modify

UA007_CASI_ANNUAL_ASSIGNMENT

UA008_CASI_AIRCRAFT_ASSIGNMENT

You need to perform the data modification as requested either MODIFY specific Column OR if a DELETE then you need to DELETE the Fiscal Year Record from both Tables (Delete from UA008 first then UA007 for database Child Constraint)