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')
Minott Opdyke
Update: This issue has been resolved with the 11/22/2019 Aeries Web update:
https://support.aeries.com/support/discussions/topics/14000014894
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.
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')