To do multible compids, use the following script:
php /var/www/html_j3sg/institutions/ChangeCompidOfAllInstitutionalAfewCompaniesAtATime.php
Please note that the script mentioned above (ChangeCompidOfAllInstitutionalAfewCompaniesAtATime) only updates the current13FFilingpositions table, no archived tables.
This script actual updates 13F current table as well as both archive13F tables.
We got coming in compid: : 130659
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130659'
The Shares Amount is 19061000
The cusip is 86663B201
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '86663B201'
Number of Rows :10
update current13Fpositions set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793' ,
percentOut = '1.78'
where entryId = '51216799'
update current13Fpositions set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793' ,
percentOut = '73.1'
where entryId = '60353281'
update current13Fpositions set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793' ,
percentOut = '71.36'
where entryId = '64045166'
update current13Fpositions set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793' ,
percentOut = '0.89'
where entryId = '65686028'
update current13Fpositions set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793' ,
percentOut = '188.44'
where entryId = '65692017'
update current13Fpositions set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793' ,
percentOut = '3.16'
where entryId = '65708297'
update current13Fpositions set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793' ,
percentOut = '22.64'
where entryId = '65722042'
update current13Fpositions set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793' ,
percentOut = '179.31'
where entryId = '65838226'
update current13Fpositions set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793' ,
percentOut = '0'
where entryId = '70522357'
update current13Fpositions set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793' ,
percentOut = '0'
where entryId = '74826239'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '86663B201'
Number of Rows :494
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66052056'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66126003'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68153108'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67905772'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68270987'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67768701'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67961203'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66465192'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67808965'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67594959'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65655334'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67708863'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65908947'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66103027'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68038064'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67946964'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67878594'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67733842'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67659138'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68186863'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68147840'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68288535'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67230097'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67504637'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67559307'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68180396'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68026673'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67322058'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66427475'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66994591'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67509826'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67790778'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67140070'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67601450'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65489137'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68385953'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67447486'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67417745'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66821789'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67638822'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68226592'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67950151'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67480209'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67278326'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68329228'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67049432'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67084096'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67713579'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68173078'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67583146'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68053035'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68262088'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68373791'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67834622'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67210019'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67989744'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67588971'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68089801'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66020795'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66012368'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66318591'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66304508'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66164761'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66355156'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66025307'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66796575'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66646533'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67052758'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66373416'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66926063'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66128460'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66204661'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66212063'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67377942'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66433945'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65040949'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67059497'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66861471'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65869289'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66245736'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66859918'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66031105'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66937268'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66474410'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66621143'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65536510'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67565818'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67020243'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67796864'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67108435'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67488495'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66964596'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66739079'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65868409'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66209165'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '67223316'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66287910'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65553455'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66627542'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65832490'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66544013'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65047005'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65424045'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65909276'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65457705'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65370939'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65360903'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65847700'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65959017'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65307525'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65511196'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65826123'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65736230'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65561177'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65115886'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65106961'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65190120'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65944637'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65879419'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65891933'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '66195904'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65402399'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65991836'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '65797403'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '63397006'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '63463377'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '63528042'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '63950632'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '63692155'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '63743466'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '63733652'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '63753183'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '63987391'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64686397'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64115840'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '63547527'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64018566'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64226358'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64873898'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64005076'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64114211'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64063726'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64098933'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64088260'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '63941305'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '63981438'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64092597'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '63964432'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '63917893'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64261233'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64573823'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '63750444'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64391739'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '63674233'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64936442'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64945379'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64390549'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64072725'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64806060'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '63434305'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64133571'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64285193'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64245477'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '63800926'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64638268'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64500819'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64462868'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64589698'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64703597'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64751936'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '63932745'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '63373474'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64696760'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64155511'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64369217'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64553128'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64919325'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64341328'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64738910'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64657751'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64858769'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64869946'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '64913421'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68464754'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68425054'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70333570'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68962716'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68818528'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68580615'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68722819'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68737756'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68891666'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69030765'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69277864'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68690482'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68853974'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68865988'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69728416'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68680070'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68719966'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69115301'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68591245'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68797962'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68884843'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69185324'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69025556'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69141687'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69360234'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69329321'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69725070'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69660241'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69667116'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69315901'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69690471'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69757952'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69831537'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69817445'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69347568'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69409442'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69452783'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69544006'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69167705'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69160788'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69889065'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69866368'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69699471'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69198161'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69610406'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69466255'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69203836'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69948455'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69953061'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '68792674'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69977431'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69619706'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69251290'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69451086'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69596697'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69496705'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69489149'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69496472'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69548984'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70047488'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69937819'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70023481'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69034565'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69382442'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69464212'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69714119'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69685363'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69869097'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70231486'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71247199'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70337631'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70667025'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70295537'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70097656'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70598947'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70250294'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70206519'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70511104'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70322915'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70661137'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70682616'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71046238'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70253468'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70332339'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70630994'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70665904'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70731178'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70765038'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70780069'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70805157'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70812237'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71028226'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71482226'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71646820'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '69080102'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71336970'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70427963'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70563558'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70609705'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70742953'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70828475'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70921534'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70959222'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70966615'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70989929'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71210469'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71221670'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71374986'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71536228'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71597446'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71639562'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71644073'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71706668'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71203118'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71509593'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71370637'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71463112'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71288604'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71507250'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71216722'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71560423'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71509399'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71351776'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71162745'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71379675'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70909880'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71400736'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71050500'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70926733'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71052667'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71240171'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70902556'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71060392'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71450009'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71752931'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71063492'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71088603'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71196471'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71422463'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71011313'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71552865'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71395722'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '70892948'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71700675'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '71177284'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72192840'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72367037'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72119545'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72005304'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72373762'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72344789'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72797730'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72491562'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72767871'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72651433'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72197408'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72244502'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72683774'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72378108'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72463859'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73049720'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72434114'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72269800'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73688742'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73434545'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72390972'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72949161'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72562731'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73163988'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72573506'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72878648'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72661048'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72413789'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72867413'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72053898'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72851224'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73561761'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72833321'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72638987'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72306364'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72968005'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73669477'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73011910'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73001420'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73347553'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73053816'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73047948'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73527948'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73401532'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73397511'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73416100'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72746963'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73526883'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73318058'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73354301'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73568905'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73528806'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73406504'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73428492'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72883062'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73005303'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73342226'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73433591'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72517409'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73156875'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73421457'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73243186'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73241023'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73371543'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73150463'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73250330'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73806301'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72677721'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72945803'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73061307'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73253401'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73274626'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73331460'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73058366'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73026371'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73208875'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72721857'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72889994'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73503166'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73140020'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73664963'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73299658'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73339414'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '72862871'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '73462838'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74830120'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74117000'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74856193'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74004686'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74113954'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74331623'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74832745'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74337146'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74841554'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74849591'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74333810'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75624137'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74007527'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74851685'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74852575'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74854471'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74332289'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74853339'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74854956'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74332075'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75703419'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74855345'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74855495'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75638796'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74855996'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75700347'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75583938'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75586111'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74342528'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75585468'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75583167'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75590344'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74836479'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75592098'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75592941'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75593882'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74840395'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75595171'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75595728'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75596059'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75602410'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75596534'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75604633'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75604580'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75606174'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75614206'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75610510'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75612905'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75617686'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75620464'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75620973'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75621766'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74882092'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75629159'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75629525'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74851887'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75631853'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75633024'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75634084'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75634983'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75635485'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75635854'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75636575'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75636783'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75636660'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75637243'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75704420'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75638191'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75638555'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74855724'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75639064'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75639321'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75639386'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75639642'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75639851'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '75639988'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74853505'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '74855661'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '77619363'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '51038486'
update archive13F set
compid = '130659',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001017793'
where entryId = '96634018'
End Function
The Script is complete, exiting....