{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["概要","データ追加（医薬）","データ追加（医政）"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"概要","index":0,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
["概要"]
[null,"No.","実施日","作業場所","実施概要（シート名）","実施（主）","実施（副）","備考"]
[null,1,null,"セック（用賀）","データ追加（医薬）"]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]

{"sheet":"データ追加（医薬）","index":1,"n_rows":54,"n_cols":15,"rows_kept":54,"cut":false,"hidden":false,"merged":[[1,14,65,14],[30,1,32,1],[30,0,32,0],[23,0,24,0],[23,1,24,1],[21,1,22,1],[21,0,22,0],[30,6,32,6],[21,6,22,6],[23,6,24,6],[37,1,38,1],[37,0,38,0],[3,0,5,3],[3,4,5,5],[5,7,6,7],[5,8,6,8],[0,0,0,3],[0,4,0,5],[1,0,1,3],[1,4,1,5],[2,0,2,3],[2,4,2,5],[6,0,6,3],[6,4,6,5],[7,0,7,3],[7,4,7,5],[7,7,7,8],[8,0,8,3],[8,4,8,5],[8,7,9,8],[9,0,9,3],[9,4,9,5],[11,8,12,8],[11,0,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[11,5,12,5],[11,6,11,7]]}
["作業名",null,null,null,"対象システム",null,null,null,null,null,"依頼内容"]
["データ追加（医薬）",null,null,null,"免許登録管理システム",null,null,null,null,1,"対象",null,null,null,"株式会社セック 菅井様\n\nいつも大変お世話になっております。\n厚生労働省の黒川です。\n\n資格確認検索システムについて、免許取消者が表示されておりますので\n至急、非表示にしていただきたくご対応をお願い致します。\n\n【対象者】\n昭和62年10月２日登録\n登録番号：242742\n氏名：守田　幹\n令和３年１月８日付け免許取消\n\n表示されるようになった原因は、先日こちらでフリガナを入力したためと思われます。\n\nお忙しいところ大変恐縮ですが、\n至急ご対応いただけますよう、よろしくお願いいたします。\n\n ～・～・～・～・～・～・～・～・～\n 厚生労働省\n 医薬・生活衛生局 総務課\n試験免許係　 　黒川　直美\n TEL：03-5253-1111（内線：2696） \n FAX：03-3503-1760\n E-MAIL：kurokawa-naomi.s65@mhlw.local\n～・～・～・～・～・～・～・～・～"]
["作業目的",null,null,null,"必要資材/参照資料等",null,null,null,null,true,"外字変換"]
["検索用の氏名のデータを追加する。",null,null,null,"なし",null,null,null,null,true]
[null,null,null,null,null,null,null,"実施日","実施者・確認者",null,"実施日（YYYYMMDD）","20221005","※/を入れないで8桁で入力"]
[null,null,null,null,null,null,null,null,null,null,"チケット番号","63487"]
["作業予定時間",null,null,null,"作業場所",null,null,null,null,null,"チケット番号枝番",null,"スペース又は01～99"]
["６０分",null,null,null,"セック（用賀）",null,null,"エビデンス格納先",null,null,"登録番号","242742"]
["運用への影響",null,null,null,"サーバ再起動",null,null,null,null,null,"登録日（YYYYMMDD）","19871002","※/を入れないで8桁で入力"]
["なし",null,null,null,"なし",null,null,null,null,null,"姓","江森"]
[null,null,null,null,null,null,null,null,null,null,"名","規泰"]
["No",null,"作業対象","作業内容","確認項目","確認","エビデンス",null,"備考",null,"\n","\n","\n"]
[null,null,null,null,null,null,"要否","ファイル名",null,null,"\n","\n","\n"]
[1,null,"作業用PC","ゲートウェイサーバへログイン",null,null,null,null,null,null,"\n","\n","\n"]
[1,1,null,"ゲートウェイサーバへログインする。\nアカウント : 別紙アカウント一覧参照 \npass     : 別紙アカウント一覧参照","ログイン出来ること。",null,"否",null,null,null,"\n","\n","\n"]
[2,null,"ゲートウェイサーバ","作業フォルダ配置",null,null,null,null,null,null,"\n","\n","\n"]
[2,1,null,{"$f":" \"「C:\\運用・保守\\問い合わせ対応\\2022年度\\チケット\" & L6 & \"_外字対応」フォルダを作成する。\"","v":"「C:\\運用・保守\\問い合わせ対応\\2022年度\\チケット63487_外字対応」フォルダを作成する。"},null,null,"否",null,null,null,"\n","\n","\n"]
[2,2,null,"当手順Excelファイルを上記フォルダに配置する。",null,null,"否",null,null,null,"\n","\n","\n"]
[3,null,"ゲートウェイサーバ","事前準備（業務DBからtoroku_idを取得）",null,null,null,null,"依頼元から連携されたtoroku_noから業務DBのtoroku_idを取得する。",null,"\n","\n","\n"]
[3,1,null,"A5:SQLを起動する。",null,null,"否",null,null,null,"\n","\n","\n"]
[3,2,null,"読取専用で業務DBインスタンス（hpb）に接続する。",null,null,"否",null,"サーバー名の末尾が、\n1=公開Webサーバpubweb\n2=業務Webサーバentweb",null,"\n","\n","\n"]
[3,3,null,"新しいドキュメントからSQLを選択してクエリファイルを開いて、下記SQLを実行する。","□1件ヒットすること。",null,"否",null,null,null,"\n","\n","\n"]
[null,null,null,{"$f":" \"select * from yr_toroku where toroku_no='\" & L8 & \"';\"","v":"select * from yr_toroku where toroku_no='242742';"},null,null,null,null,null,null,"\n","\n","\n"]
[3,4,null,"実行結果より「toroku_id」を下記セルに入力する。",null,null,"否",null,null,null,"\n","\n","\n"]
[null,null,null,12345678,null,null,null,null,null,null,"\n","\n","\n"]
[3,5,null,"業務DBインスタンス（hpb）を閉じる。",null,null,"否",null,null,null,"\n","\n","\n"]
[4,null,"ゲートウェイサーバ","事前準備（DBのバックアップを取得）",null,null,null,null,"公開DBインスタンス\nifdbデータベース",null,"\n","\n","\n"]
[4,1,null,"Teratermを起動する。",null,null,"否",null,null,null,"\n","\n","\n"]
[4,2,null,"業務WEBサーバ（10.0.30.104）にログインする。\nユーザ名：ec2-user\nRSA\n秘密鍵：identity","□ログインできること。",null,"否",null,null,null,"\n","\n","\n"]
[4,3,null,"下記スクリプトを実行してDBのバックアップを取得する。\nsudo su --login\ncd /volumes/data/backup\n./DB_backup_pubdb.sh ifdb",null,null,"否",null,null,null,"\n","\n","\n"]
[4,4,null,"下記スクリプトを実行して、\n/volumes/data/backup/YYYYMMDD/ifdb/配下にバックアップが生成されたことを確認する。（YYYYMMDD＝実施日）\n\nll",null,null,"否",null,"日付は自動で本日が入る。\nカレント：/volumes/data/backup",null,"\n","\n","\n"]
[null,null,null,{"$f":" \"cd \" & L5","v":"cd 20221005"},null,null,null,null,null,null,"\n","\n","\n"]
[null,null,null,"ll\ncd ifdb\nll",null,null,null,null,null,null,"\n","\n","\n"]
[4,5,null,"exit",null,null,"否",null,null,null,"\n","\n","\n"]
[4,6,null,"exit","Teratermが閉じること。",null,"否",null,null,null,"\n","\n","\n"]
[5,null,"ゲートウェイサーバ","実行（データの追加）",null,null,null,null,null,null,"\n","\n","\n"]
[5,1,null,"更新モードで公開DBインスタンス（ifdb_iyaku）に接続する。","□ifdb_iyaku（医薬）が正しいことを確認する。（画面上の黄色の部分）",null,"否",null,null,null,"\n","\n","\n"]
[5,2,null,"新しいドキュメントからSQLを選択してクエリファイルを開いて、下記SQLを実行する。","□1件ヒットすること。",null,"否",null,null,null,"\n","\n","\n"]
[null,null,null,{"$f":" \"select * from PHARMACIST where toroku_id = '\" & D25 & \"';\"","v":"select * from PHARMACIST where toroku_id = '12345678';"},null,null,"否",null,null,null,"\n","\n","\n"]
[5,"3-姓",null,"SEI_NAMEがyr_torokuのSEI_NAMEと一致し、MEI_NAMEが【規泰】で、TOROKU_DATEが「昭和62年10月2日」【1987/10/02】のデータが1件であること。",null,null,"否",null,null,null,"\n","\n","\n"]
[5,"3-名",null,"MEI_NAMEがyr_torokuのMEI_NAMEと一致し、SEI_NAMEが【江森】で、TOROKU_DATEが「昭和62年10月2日」【1987/10/02】のデータが1件であること。",null,null,"否",null,null,null,"\n","\n","\n"]
[5,4,null,null,null,null,"否",null,null,null,"\n","\n","\n"]
[5,5,null,null,null,null,"否",null,null,null,"\n","\n","\n"]
[5,6,null,null,null,null,"否",null,null,null,"\n","\n","\n"]
[5,7,null,null,null,null,"否",null,null,null,"\n","\n","\n"]
[5,8,null,null,null,null,"否",null,null,null,"\n"]
[5,9,null,null,null,null,"否",null,null,null,"\n"]
[5,10,null,null,null,null,"否",null,null,null,"\n"]
[null,null,null,null,null,null,null,null,null,null,"\n"]
[null,null,null,null,null,null,null,null,null,null,"\n"]
[null,null,null,null,null,null,null,null,null,null,"\n"]
[null,null,null,null,null,null,null,null,null,null,"\n"]
[null,null,null,null,null,null,null,null,null,null,"\n"]
[null,null,null,null,null,null,null,null,null,null,"\n"]

{"sheet":"データ追加（医政）","index":2,"n_rows":54,"n_cols":15,"rows_kept":54,"cut":false,"hidden":true,"merged":[[1,14,65,14],[2,0,2,3],[2,4,2,5],[3,0,5,3],[3,4,5,5],[5,7,6,7],[5,8,6,8],[6,0,6,3],[6,4,6,5],[7,0,7,3],[7,4,7,5],[7,7,7,8],[11,5,12,5],[11,8,12,8],[23,6,24,6],[11,6,11,7],[0,0,0,3],[0,4,0,5],[1,0,1,3],[1,4,1,5],[23,0,24,0],[23,1,24,1],[8,0,8,3],[8,4,8,5],[21,0,22,0],[21,1,22,1],[21,6,22,6],[8,7,9,8],[9,0,9,3],[9,4,9,5],[11,0,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[30,0,32,0],[30,1,32,1],[30,6,32,6],[37,0,38,0],[37,1,38,1]]}
["作業名",null,null,null,"対象システム",null,null,null,null,null,"依頼内容"]
["データ追加（医政）",null,null,null,"免許登録管理システム",null,null,null,null,0,"対象",null,null,null,"株式会社セック 菅井様\n\nいつも大変お世話になっております。\n厚生労働省の黒川です。\n\n資格確認検索システムについて、免許取消者が表示されておりますので\n至急、非表示にしていただきたくご対応をお願い致します。\n\n【対象者】\n昭和62年10月２日登録\n登録番号：242742\n氏名：守田　幹\n令和３年１月８日付け免許取消\n\n表示されるようになった原因は、先日こちらでフリガナを入力したためと思われます。\n\nお忙しいところ大変恐縮ですが、\n至急ご対応いただけますよう、よろしくお願いいたします。\n\n ～・～・～・～・～・～・～・～・～\n 厚生労働省\n 医薬・生活衛生局 総務課\n試験免許係　 　黒川　直美\n TEL：03-5253-1111（内線：2696） \n FAX：03-3503-1760\n E-MAIL：kurokawa-naomi.s65@mhlw.local\n～・～・～・～・～・～・～・～・～"]
["作業目的",null,null,null,"必要資材/参照資料等",null,null,null,null,true,"外字変換"]
["検索用の氏名のデータを追加する。",null,null,null,"なし",null,null,null,null,false]
[null,null,null,null,null,null,null,"実施日","実施者・確認者",null,"実施日（YYYYMMDD）","20221005","※/を入れないで8桁で入力"]
[null,null,null,null,null,null,null,null,null,null,"チケット番号","12345"]
["作業予定時間",null,null,null,"作業場所",null,null,null,null,null,"チケット番号枝番",null,"スペース又は01～99"]
["６０分",null,null,null,"セック（用賀）",null,null,"エビデンス格納先",null,null,"登録番号","242742"]
["運用への影響",null,null,null,"サーバ再起動",null,null,null,null,null,"登録日（YYYYMMDD）",19871002,"※/を入れないで8桁で入力"]
["なし",null,null,null,"なし",null,null,null,null,null,"姓","守田"]
[null,null,null,null,null,null,null,null,null,null,"名","幹"]
["No",null,"作業対象","作業内容","確認項目","確認","エビデンス",null,"備考",null,"\n"]
[null,null,null,null,null,null,"要否","ファイル名"]
[1,null,"作業用PC","ゲートウェイサーバへログイン",null,null,null,null,null,null,"\n"]
[1,1,null,"ゲートウェイサーバへログインする。\nアカウント : 別紙アカウント一覧参照 \npass     : 別紙アカウント一覧参照","ログイン出来ること。",null,"否",null,null,null,"\n"]
[2,null,"ゲートウェイサーバ","作業ファイル配置",null,null,null,null,null,null,"\n"]
[2,1,null,{"$f":" \"「C:\\運用・保守\\問い合わせ対応\\2022年度\\チケット\" & L6 & \"_外字対応」フォルダを作成する。\"","v":"「C:\\運用・保守\\問い合わせ対応\\2022年度\\チケット12345_外字対応」フォルダを作成する。"},null,null,"否",null,null,null,"\n"]
[2,2,null,"当手順Excelファイルを上記フォルダに配置する。",null,null,"否",null,null,null,"\n"]
[3,null,"ゲートウェイサーバ","事前準備（業務DBからtoroku_idを取得）",null,null,null,null,"依頼元から連携されたtoroku_noから業務DBのtoroku_idを取得する。",null,"\n"]
[3,1,null,"A5:SQLを起動する。",null,null,"否",null,null,null,"\n"]
[3,2,null,"読取専用で業務DBインスタンス（hpb）に接続する。",null,null,"否",null,"サーバー名の末尾が、\n1=公開Webサーバpubweb\n2=業務Webサーバentweb",null,"\n"]
[3,3,null,"新しいドキュメントからSQLを選択してクエリファイルを開いて、下記SQLを実行する。","□1件ヒットすること。",null,"否",null,null,null,"\n"]
[null,null,null,{"$f":" \"select * from yr_toroku where toroku_no='\" & L8 & \"';\"","v":"select * from yr_toroku where toroku_no='242742';"},null,null,null,null,null,null,"\n"]
[3,4,null,"実行結果より「toroku_id」を下記セルに入力する。",null,null,"否",null,null,null,"\n"]
[null,null,null,87654321,null,null,null,null,null,null,"\n"]
[3,5,null,"業務DBインスタンス（hpb）を閉じる。",null,null,"否",null,null,null,"\n"]
[4,null,"ゲートウェイサーバ","事前準備（DBのバックアップを取得）",null,null,null,null,"公開DBインスタンス\nifdbデータベース",null,"\n"]
[4,1,null,"Teratermを起動する。",null,null,"否",null,null,null,"\n"]
[4,2,null,"業務WEBサーバ（10.0.30.104）にログインする。\nユーザ名：ec2-user\nRSA\n秘密鍵：identity","□ログインできること。",null,"否",null,null,null,"\n"]
[4,3,null,"下記スクリプトを実行してDBのバックアップを取得する。\nsudo su --login\ncd /volumes/data/backup\n./DB_backup_pubdb.sh ifdb",null,null,"否",null,null,null,"\n"]
[4,4,null,"下記スクリプトを実行して、\n/volumes/data/backup/YYYYMMDD/ifdb/配下にバックアップが生成されたことを確認する。（YYYYMMDD＝実施日）\n\nll",null,null,"否",null,"日付は自動で本日が入る。\nカレント：/volumes/data/backup",null,"\n"]
[null,null,null,{"$f":" \"cd \" & L5","v":"cd 20221005"},null,null,null,null,null,null,"\n"]
[null,null,null,"ll\ncd ifdb\nll",null,null,null,null,null,null,"\n"]
[4,5,null,"exit",null,null,"否",null,null,null,"\n"]
[4,6,null,"exit","Teratermが閉じること。",null,"否",null,null,null,"\n"]
[5,null,"ゲートウェイサーバ","実行（データの追加）",null,null,null,null,null,null,"\n"]
[5,1,null,"更新モードで公開DBインスタンス（ifdb_iyaku）に接続する。","□ifdb_iyaku（医薬）が正しいことを確認する。（画面上の黄色の部分）",null,"否",null,null,null,"\n"]
[5,2,null,"新しいドキュメントからSQLを選択してクエリファイルを開いて、下記SQLを実行する。","□1件ヒットすること。",null,"否",null,null,null,"\n"]
[null,null,null,{"$f":" \"select * from PHARMACIST where toroku_id = '\" & D25 & \"';\"","v":"select * from PHARMACIST where toroku_id = '87654321';"},null,null,"否",null,null,null,"\n"]
[5,3,null,null,{"$f":"IF(N2=1,K42,\"b\")","v":"b"},null,"否",null,null,null,"\n"]
[5,4,null,null,null,null,"否",null,null,null,"\n"]
[5,5,null,null,null,null,"否",null,null,null,"SEI_NAMEがyr_torokuのSEI_NAMEと一致し、MEI_NAME【幹】で、TOROKU_DATEが「令和3年1月8日」【2021/01/08】のデータが1件であること。"]
[5,6,null,null,null,null,"否",null,null,null,"\n"]
[5,7,null,null,null,null,"否",null,null,null,"\n"]
[5,8,null,null,null,null,"否",null,null,null,"\n"]
[5,9,null,null,null,null,"否",null,null,null,"\n"]
[5,10,null,null,null,null,"否",null,null,null,"\n"]
[5,11,null,null,null,null,"否",null,null,null,"\n"]
[null,null,null,null,null,null,null,null,null,null,"\n"]
[null,null,null,null,null,null,null,null,null,null,"\n"]
[null,null,null,null,null,null,null,null,null,null,"\n"]
[null,null,null,null,null,null,null,null,null,null,"\n"]
[null,null,null,null,null,null,null,null,null,null,"\n"]
[null,null,null,null,null,null,null,null,null,null,"\n"]