...
(SELECT FROM_TXT FROM Z980_TERM_CONVERSION WHERE TERM_TYPE_CD = ‘SYSID’) ;
/* ALWAYS skip the system specific Id’s Id’s, ‘CLIENT’, ‘ccarcsupd’ etc. . . */
2) Owner AAIR Access code/passwords are to be set to “XXXX1111”
...
WHERE CLIENT_ID IS NOT NULL ;
/*only the owners have client_ids */
...
UPDATE A92_ADDRESS_PROPERTY
SET ADDRESS_PROPERTY_TXT = UPPER(ADDRESS_PROPERTY_TXT) || 'X'
WHERE ADDRESS_PROPERTY_TXT LIKE '%@%' AND ADDRESS_PROPERTY_TXT NOT LIKE '%X' ;
5) ENSURE THAT CONTINUING AIRWORTHINESS ACCOUNTS REMAIN ACTIVE
...
Note : Its normal to find a small amount of records, with legitimate TC-email, or TC-employee personal emails, or TC cell phone numbers in the FAX fields at any given time. This is how data conditions are setup for MDM/EDM testing.
...