text: update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'quickstart') where person_id = '000000003';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'jtester') where person_id = '000000008';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'KULUSER') where person_id = '000000000';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'majors') where person_id = '000000010';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'chew') where person_id = '000000011';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'woods') where person_id = '000000012';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'oblood') where person_id = '000000013';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'cate') where person_id = '000000014';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'houlihan') where person_id = '000000050';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'rbpaulin') where person_id = '000000051';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'donugent') where person_id = '000000052';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'mbshorte') where person_id = '000000053';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'underwoo') where person_id = '000000054';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'hweubank') where person_id = '000000055';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'lvbarger') where person_id = '000000056';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'jckahler') where person_id = '000000057';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'byler') where person_id = '000000058';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'aemcafee') where person_id = '000000059';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'westfall') where person_id = '000000060';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'bbshankl') where person_id = '000000061';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'ferland') where person_id = '000000062';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'khcrabtr') where person_id = '000000063';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'felker') where person_id = '000000064';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'martin') where person_id = '000000065';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'sterner') where person_id = '000000066';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'chbayles') where person_id = '000000067';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'tmkato') where person_id = '000000068';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'cphovis') where person_id = '000000069';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'rnmcinty') where person_id = '000000070';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'eagle') where person_id = '000000071';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'mjpond') where person_id = '000000072';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'flaherty') where person_id = '000000073';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'mukoss') where person_id = '000000074';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'mceacher') where person_id = '000000075';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'wacuna') where person_id = '000000076';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'schulte') where person_id = '000000077';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'odevries') where person_id = '000000078';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'dxdevane') where person_id = '000000079';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'psmock') where person_id = '000000080';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'lvclinks') where person_id = '000000081';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'brunelle') where person_id = '000000082';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'cbernal') where person_id = '000000083';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'borst') where person_id = '000000084';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'wsoileau') where person_id = '000000085';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'burd') where person_id = '000000086';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'engel') where person_id = '000000087';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'headley') where person_id = '000000088';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'rpgailey') where person_id = '000000089';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'shields') where person_id = '000000090';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'elgin') where person_id = '000000091';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'boman') where person_id = '000000092';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'duggins') where person_id = '000000093';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'khowens') where person_id = '000000094';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'ndarr') where person_id = '000000095';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'cary') where person_id = '000000096';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'clmcbee') where person_id = '000000097';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'ralston') where person_id = '000000098';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'mwmartin') where person_id = '000000099';
  update person_ext_t set person_id = (select k.prncpl_id from krim_prncpl_t k where k.prncpl_nm = 'rrabbit') where person_id = '0000000777';
  