Known Issue - Running Update USYSGCOD from the Admin Functions page wipes out existing data in USYSGCOD.CAT

Running Update USYSGCOD from the Admin Functions page wipes out existing data in USYSGCOD.CAT (Category) which helps differentiate between code sets.   We are working on a fix to ship this week to disable the USYSGCOD button on the Admin Functions page and also an AdminCS fix to add the missing codes.  We will post a Known Issues soon with this information 




This was noticed on both ATT.RS codes and STU.BST codes where the Country in the CAT code was no longer there for each State.


This query can check for those two tables:


select * from USYSGCOD
where tc = 'att' or tc = 'stu' 


These queries can restore that lost data:


---ATT.RS

update usysgcod set cat = 'Exit Reason' where tc = 'att' and fc = 'rs' 


---STU.BST

update usysgcod set cat = 'AS' where tc = 'stu' and fc = 'bst' and cd = 'AS'
update usysgcod set cat = 'CA' where tc = 'stu' and fc = 'bst' and cd in ('AB','BC','MB','NB','NF','NS','NT','ON','PE','PQ','SK','YT')
update usysgcod set cat = 'FM' where tc = 'stu' and fc = 'bst' and cd in ('FM')
update usysgcod set cat = 'GU' where tc = 'stu' and fc = 'bst' and cd in ('GU')
update usysgcod set cat = 'MP' where tc = 'stu' and fc = 'bst' and cd in ('MP')
update usysgcod set cat = 'MX' where tc = 'stu' and fc = 'bst' and cd in ('AG','BN','BS','CH','CL','CM','CS','CU','DF','DG','GR','GT','HG','JA','MC','MR','MX','NA','NL','OA','PU','QE','QI','SI','SL','SO','TB','TL','TM','VE','YU','ZA')
update usysgcod set cat = 'PR' where tc = 'stu' and fc = 'bst' and cd in ('PR')
update usysgcod set cat = 'PW' where tc = 'stu' and fc = 'bst' and cd in ('PW')
update usysgcod set cat = 'US' where tc = 'stu' and fc = 'bst' and cd in ('AA','AE','AK','AL','AP','AR','AZ','CA','CO','CT','DC','DE','FL','GA','HI','IA','ID','IL','IN','KS','KY','LA','MA','MD','ME','MH','MI','MN','MO','MS','MT','NC','ND','NE','NH','NJ','NM','NV','NY','OH','OK','OR','PA','RI','SC','SD','TN','TX','UT','VA','VT','WA','WI','WV','WY')
update usysgcod set cat = 'VI' where tc = 'stu' and fc = 'bst' and cd in ('VI')

Login to post a comment