Sept 2021 : NOTE - all required code for this process is found at :
simply copy and place into your preferred SQL tool
...
The Z980_Term_conversion table serves a multitude of purposes.
...
A full list of term types and descriptions can be had at : TR32_TERM_TYPE
TTC TERM_TYPE_ETXT
---------- --------------------
1 AIRCRAFT
2 ENGINE
3 PROPELLER
4 SKI/FLOAT
ACTIVEUSER ACTIVE USER
ADBKP AD MAKE/MODEL BACKUP
BADEMAIL BADEMAIL
BADFILE BAD AD FILE
CARSXREF CC/CW MFG/MODEL
CAW CAW USERS
CAWROLES CAW ROLES
CNREG COUNTRY OF REGISTRY
DATFIX DATA MODS IN SYNC
DATFIX2 DATFIX2
EASA EASA MEMBER
FAASTD STANDARDIZE FAA MFG
FLEET FLEET
FTP2019 AAIRFTP2019
FTP2020 AAIRFTP2020
FTP2021 AAIRFTP2021
NULLEMAIL NULL OWNER EMAILS
OLDEMAIL OLD CLIENT EMAIL
REGION CAWISREGION
SDBAD INVALID SDR DATA
SDCONV CONVERT FAA SDR NO
SDRACCT SDR IGNORE LIST
SYSID SYSTEM ACCOUNTS
TCORG TC SDR ORG
USERCHANGE USERCHANGE
USERROLES USERROLES
XEMAIL BACKUP EMAIL DATA
XFAX BACKUP FAX DATA
XPHONE BACKUP PHONE DATA
YRMON YEAR-MONTH
So Term_type_cd = SDBAD is a list of BAD/UNWANTED/UNNECESSARY data entries identified thru many years of data review (examples, NA, N/A, NOT FOUND, NONE) that we use to clear out trash values from various Text fields as seen below.
Sample values
...
The word, "UNKNOWN" is an agreed upon (with TC SDRS management) default value placed into NULL serial numbers, and part data fields because the CAWIS/WSDRS page demands these data elements as mandatory fields. We fill them to prevent this error (even though - again - at this point TC users cannot go into edit mode on a non-Canadian SDR)
...