BGRS ZenDesk Reference: 4974755
Description: We've received a request to update the client coordinator on transferee files. In this case we've been asked to update the coordinator the transferee files to 84.
Resolution:
You will receive a list of member files to update from the requestor. In most cases it will be Stephanie Sliwinski or Kevin.
Login to 10.139.88.101\IRP
-- Display coordinator (column name subscoodr) on provided files
select subscoordr, * from trmaster
where projectid in ('CBSA202000197',
'CBSA202100183',
'CBSA202100205',
'CBSA202100211',
'CBSA202100217',
'CBSA202100218',
'CBSA202100225',
'CBSA202100230',
'CBSA202100232',
'CBSA202100234',
'CBSA202100239',
'CBSA202100243',
'CBSA202100245',
'CBSA202100248',
'CBSA202100252',
'CBSA202100264',
'CBSA202100280',
'CBSA202100281',
'CBSA202100286',
'CBSA202100291',
'CBSA202100293',
'CBSA202100298',
'CBSA202100301',
'CBSA202100302',
'CBSA202100304',
'CBSA202100308',
'CBSA202100310',
'CBSA202100324',
'CBSA202100326',
'CBSA202100330',
'CBSA202100336',
'CBSA202100344',
'CBSA202100350',
'CBSA202100352',
'CBSA202100361',
'CBSA202100362',
'CBSA202100363',
'CBSA202100364',
'CBSA202100365',
'CBSA202100367',
'CBSA202100370',
'CBSA202100371',
'CBSA202100373',
'CBSA202100379',
'CBSA202100380',
'CBSA202100381',
'CBSA202100382',
'CBSA202100384',
'CBSA202100385',
'CBSA202100389',
'CBSA202100390',
'CBSA202100392',
'CBSA202100393',
'CBSA202100397',
'CBSA202100398',
'CBSA202100400',
'CBSA202100401',
'CBSA202100402',
'CBSA202100403',
'CBSA202200001',
'CBSA202200002',
'CBSA202200003',
'CBSA202200004',
'CBSA202200007',
'CBSA202200010',
'CBSA202200012',
'CBSA202200013',
'CBSA202200014',
'CBSA202200015',
'CBSA202200018',
'CBSA202200022',
'CBSA202200025',
'CBSA202200027',
'CBSA202200029',
'CBSA202200036',
'CBSA202200038',
'CBSA202200045',
'CBSA202200046',
'CBSA202200049',
'CBSA202200050',
'CBSA202200054',
'CBSA202200055',
'CBSA202200057',
'CBSA202200058',
'CBSA202200059',
'CBSA202200060',
'CBSA202200063',
'CBSA202200064',
'CBSA202200065',
'CBSA202200066',
'CBSA202200068',
'CBSA202200069',
'CBSA202200071',
'CBSA202200073',
'CBSA202200074',
'CBSA202200075',
'CBSA202200077',
'CBSA202200078',
'CBSA202200079',
'CBSA202200080',
'CBSA202200082',
'CBSA202200083',
'CBSA202200084',
'CBSA202200091',
'CBSA202200096',
'CBSA202200097',
'CBSA202200098',
'CBSA202200109',
'CBSA202200110',
'CBSA202200111',
'CBSA202200113',
'CBSA202200114',
'CBSA202200116',
'CBSA202200118',
'CBSA202200120',
'CBSA202200123',
'CBSA202200124',
'CBSA202200127',
'CBSA202200130',
'CBSA202200132',
'CBSA202200135',
'CBSA202200136',
'CBSA202200137',
'CBSA202200138',
'CBSA202200141',
'CBSA202200142',
'CBSA202200143',
'CBSA202200144',
'CBSA202200145',
'CBSA202200148',
'CBSA202200149',
'CBSA202200150',
'CBSA202200152',
'CBSA202200157',
'CBSA202200158',
'CBSA202200160',
'CBSA202200161',
'CBSA202200162',
'CBSA202200163',
'CBSA202200164',
'CBSA202200166',
'CBSA202200167',
'CBSA202200168',
'CBSA202200172',
'CBSA202200173',
'CBSA202200174',
'CBSA202200179',
'CBSA202200180',
'CBSA202200181',
'CBSA202200182',
'CBSA202200183',
'CBSA202200185',
'CBSA202200186',
'CBSA202200187',
'CBSA202200190',
'CBSA202200191',
'CBSA202200192',
'CBSA202200193',
'CBSA202200194',
'CBSA202200195',
'CBSA202200196',
'CBSA202200197',
'CBSA202200198',
'CBSA202200199',
'CBSA202200201',
'CBSA202200202',
'CBSA202200203',
'CBSA202200204',
'CBSA202200207',
'CBSA202200210',
'CBSA202200211',
'CBSA202200213',
'CBSA202200215',
'CBSA202200216',
'CBSA202200217',
'CBSA202200219',
'CBSA202200220',
'CBSA202200221',
'CBSA202200224',
'CBSA202200226',
'CBSA202200229',
'CBSA202200230',
'CBSA202200232',
'CBSA202200234',
'CBSA202200235',
'CBSA202200236',
'CBSA202200260',
'CBSA202200263',
'CBSA202200266',
'CBSA202200267',
'CBSA202200271',
'CBSA202200272',
'CBSA202200273',
'CBSA202200274',
'CBSA202200275',
'CBSA202200276',
'CBSA202200279',
'CBSA202200280',
'CBSA202200283',
'CBSA202200284',
'CBSA202200285')
To update the coordinator on file submit the below DBCR
use IRP
begin tran
update trmaster set subscoordr='84'
--select subscoordr, * from trmaster
where projectid in ('CBSA202000197',
'CBSA202100183',
'CBSA202100205',
'CBSA202100211',
'CBSA202100217',
'CBSA202100218',
'CBSA202100225',
'CBSA202100230',
'CBSA202100232',
'CBSA202100234',
'CBSA202100239',
'CBSA202100243',
'CBSA202100245',
'CBSA202100248',
'CBSA202100252',
'CBSA202100264',
'CBSA202100280',
'CBSA202100281',
'CBSA202100286',
'CBSA202100291',
'CBSA202100293',
'CBSA202100298',
'CBSA202100301',
'CBSA202100302',
'CBSA202100304',
'CBSA202100308',
'CBSA202100310',
'CBSA202100324',
'CBSA202100326',
'CBSA202100330',
'CBSA202100336',
'CBSA202100344',
'CBSA202100350',
'CBSA202100352',
'CBSA202100361',
'CBSA202100362',
'CBSA202100363',
'CBSA202100364',
'CBSA202100365',
'CBSA202100367',
'CBSA202100370',
'CBSA202100371',
'CBSA202100373',
'CBSA202100379',
'CBSA202100380',
'CBSA202100381',
'CBSA202100382',
'CBSA202100384',
'CBSA202100385',
'CBSA202100389',
'CBSA202100390',
'CBSA202100392',
'CBSA202100393',
'CBSA202100397',
'CBSA202100398',
'CBSA202100400',
'CBSA202100401',
'CBSA202100402',
'CBSA202100403',
'CBSA202200001',
'CBSA202200002',
'CBSA202200003',
'CBSA202200004',
'CBSA202200007',
'CBSA202200010',
'CBSA202200012',
'CBSA202200013',
'CBSA202200014',
'CBSA202200015',
'CBSA202200018',
'CBSA202200022',
'CBSA202200025',
'CBSA202200027',
'CBSA202200029',
'CBSA202200036',
'CBSA202200038',
'CBSA202200045',
'CBSA202200046',
'CBSA202200049',
'CBSA202200050',
'CBSA202200054',
'CBSA202200055',
'CBSA202200057',
'CBSA202200058',
'CBSA202200059',
'CBSA202200060',
'CBSA202200063',
'CBSA202200064',
'CBSA202200065',
'CBSA202200066',
'CBSA202200068',
'CBSA202200069',
'CBSA202200071',
'CBSA202200073',
'CBSA202200074',
'CBSA202200075',
'CBSA202200077',
'CBSA202200078',
'CBSA202200079',
'CBSA202200080',
'CBSA202200082',
'CBSA202200083',
'CBSA202200084',
'CBSA202200091',
'CBSA202200096',
'CBSA202200097',
'CBSA202200098',
'CBSA202200109',
'CBSA202200110',
'CBSA202200111',
'CBSA202200113',
'CBSA202200114',
'CBSA202200116',
'CBSA202200118',
'CBSA202200120',
'CBSA202200123',
'CBSA202200124',
'CBSA202200127',
'CBSA202200130',
'CBSA202200132',
'CBSA202200135',
'CBSA202200136',
'CBSA202200137',
'CBSA202200138',
'CBSA202200141',
'CBSA202200142',
'CBSA202200143',
'CBSA202200144',
'CBSA202200145',
'CBSA202200148',
'CBSA202200149',
'CBSA202200150',
'CBSA202200152',
'CBSA202200157',
'CBSA202200158',
'CBSA202200160',
'CBSA202200161',
'CBSA202200162',
'CBSA202200163',
'CBSA202200164',
'CBSA202200166',
'CBSA202200167',
'CBSA202200168',
'CBSA202200172',
'CBSA202200173',
'CBSA202200174',
'CBSA202200179',
'CBSA202200180',
'CBSA202200181',
'CBSA202200182',
'CBSA202200183',
'CBSA202200185',
'CBSA202200186',
'CBSA202200187',
'CBSA202200190',
'CBSA202200191',
'CBSA202200192',
'CBSA202200193',
'CBSA202200194',
'CBSA202200195',
'CBSA202200196',
'CBSA202200197',
'CBSA202200198',
'CBSA202200199',
'CBSA202200201',
'CBSA202200202',
'CBSA202200203',
'CBSA202200204',
'CBSA202200207',
'CBSA202200210',
'CBSA202200211',
'CBSA202200213',
'CBSA202200215',
'CBSA202200216',
'CBSA202200217',
'CBSA202200219',
'CBSA202200220',
'CBSA202200221',
'CBSA202200224',
'CBSA202200226',
'CBSA202200229',
'CBSA202200230',
'CBSA202200232',
'CBSA202200234',
'CBSA202200235',
'CBSA202200236',
'CBSA202200260',
'CBSA202200263',
'CBSA202200266',
'CBSA202200267',
'CBSA202200271',
'CBSA202200272',
'CBSA202200273',
'CBSA202200274',
'CBSA202200275',
'CBSA202200276',
'CBSA202200279',
'CBSA202200280',
'CBSA202200283',
'CBSA202200284',
'CBSA202200285')
if @@ERROR > 0 or @@ROWCOUNT <> 201
BEGIN
ROLLBACK TRAN
RETURN
END
COMMIT TRAN