DATA_BRANCH_DEP_MAP.txt
| 1 |
SET DATEFORMAT ymd |
|---|---|
| 2 |
|
| 3 |
INSERT INTO CM_BRANCH_DEP_MAP (HR_ID, KT_ID) VALUES |
| 4 |
('0', NULL),
|
| 5 |
('00', '05E10'),
|
| 6 |
('00.00.58', '05R00'),
|
| 7 |
('00.2021.02', '05F02'),
|
| 8 |
('00.2021.03', '05F01'),
|
| 9 |
('00.2021.04', '05F03'),
|
| 10 |
('00.2021.05', '05F04'),
|
| 11 |
('00.2021.06', '05F05'),
|
| 12 |
('00.2021.07', '05F06'),
|
| 13 |
('00.2021.09', '05G05'),
|
| 14 |
('00.2021.10', '05O01'),
|
| 15 |
('00.2021.11', '05O02'),
|
| 16 |
('00.2021.12', '05O03'),
|
| 17 |
('00.2021.13', '05O04'),
|
| 18 |
('00.2021.14', '05H01'),
|
| 19 |
('00.2021.15', '05I04'),
|
| 20 |
('00.2021.16', '05G01'),
|
| 21 |
('00.2022.01', '05A00'),
|
| 22 |
('00.2022.02', NULL),
|
| 23 |
('00.2022.03', '05E12'),
|
| 24 |
('00.2022.04', '05X00'),
|
| 25 |
('00.2022.05', '05X00'),
|
| 26 |
('00.2022.06', '0700'),
|
| 27 |
('00.2022.07', NULL),
|
| 28 |
('0000', '0500'),
|
| 29 |
('00x', '05C00'),
|
| 30 |
('00xx', '05E00'),
|
| 31 |
('00XXX', '05D00'),
|
| 32 |
('00XXX.01', '05D01'),
|
| 33 |
('00XXX.02', '05D02'),
|
| 34 |
('00XXX.03', '05D03'),
|
| 35 |
('00XXX.04', '05D04'),
|
| 36 |
('01', '05F00'),
|
| 37 |
('01.01.00', NULL),
|
| 38 |
('01.01.01', NULL),
|
| 39 |
('01.01.02', NULL),
|
| 40 |
('01.01.03', NULL),
|
| 41 |
('01.01.04', NULL),
|
| 42 |
('01.01.05', NULL),
|
| 43 |
('01.02.06', NULL),
|
| 44 |
('01.02.07', NULL),
|
| 45 |
('01.03.09', NULL),
|
| 46 |
('01.03.10', NULL),
|
| 47 |
('01.03.11', NULL),
|
| 48 |
('01.04.12', NULL),
|
| 49 |
('01.04.13', NULL),
|
| 50 |
('01.04.14', NULL),
|
| 51 |
('02', '05G00'),
|
| 52 |
('02.04', '05G02'),
|
| 53 |
('02.05.16', NULL),
|
| 54 |
('02.05.17', NULL),
|
| 55 |
('02.05.18', NULL),
|
| 56 |
('02.05.19', NULL),
|
| 57 |
('02.06.20', NULL),
|
| 58 |
('02.06.21', NULL),
|
| 59 |
('02.06.22', NULL),
|
| 60 |
('02.07.23', NULL),
|
| 61 |
('02.07.24', NULL),
|
| 62 |
('02.26', '05G04'),
|
| 63 |
('02.TTTTQT', '05G03'),
|
| 64 |
('03', '05H00'),
|
| 65 |
('03.00.26', '05H02'),
|
| 66 |
('03.00.27', '05H03'),
|
| 67 |
('04', '05I00'),
|
| 68 |
('04.00.28', '05I01'),
|
| 69 |
('04.00.29', '05I02'),
|
| 70 |
('04.00.30', '05I03'),
|
| 71 |
('05', '05J00'),
|
| 72 |
('05.00.31', '05J01'),
|
| 73 |
('05.00.32', '05J02'),
|
| 74 |
('05.00.33', '05J03'),
|
| 75 |
('05.00.34', '05J04'),
|
| 76 |
('05.00.35', '05J05'),
|
| 77 |
('06', '05K00'),
|
| 78 |
('06.00.36', '05K01'),
|
| 79 |
('06.00.37', '05K02'),
|
| 80 |
('06.00.38', NULL),
|
| 81 |
('06.00.39', '05K03'),
|
| 82 |
('06.00.40', '05K04'),
|
| 83 |
('07', '05L00'),
|
| 84 |
('07.00.41', '05L01'),
|
| 85 |
('07.00.42', '05L02'),
|
| 86 |
('07.00.43', '05L03'),
|
| 87 |
('08', '05M00'),
|
| 88 |
('08.00.44', '05M01'),
|
| 89 |
('08.00.47', '05M03'),
|
| 90 |
('08.00.48', '05M04'),
|
| 91 |
('08.00.49', '05M05'),
|
| 92 |
('09', '05N00'),
|
| 93 |
('09.08', '05N10'),
|
| 94 |
('09.08.50', '05N11'),
|
| 95 |
('09.08.51', '05N12'),
|
| 96 |
('09.08.52', '05N13'),
|
| 97 |
('09.10', '05N20'),
|
| 98 |
('09.10.55', '05N21'),
|
| 99 |
('09.10.56', '05N22'),
|
| 100 |
('10', '05T00'),
|
| 101 |
('11', '05O00'),
|
| 102 |
('11.02', NULL),
|
| 103 |
('2022', NULL),
|
| 104 |
('2022.01', '05Y01'),
|
| 105 |
('2022.01.002', '1701'),
|
| 106 |
('2022.01.003', '1802'),
|
| 107 |
('2022.01.004', '0719'),
|
| 108 |
('2022.01.005', '0700'),
|
| 109 |
('2022.01.006', '0702'),
|
| 110 |
('2022.01.007', '0704'),
|
| 111 |
('2022.01.008', '0703'),
|
| 112 |
('2022.01.009', '0707'),
|
| 113 |
('2022.01.013', '1900'),
|
| 114 |
('2022.01.014', '2000'),
|
| 115 |
('2022.01.016', '2002'),
|
| 116 |
('2022.01.017', '2001'),
|
| 117 |
('2022.01.018', '0711'),
|
| 118 |
('2022.01.020', '0714'),
|
| 119 |
('2022.01.022', '0717'),
|
| 120 |
('2022.01.024', '0720'),
|
| 121 |
('2022.01.025', '0721'),
|
| 122 |
('2022.01.027', '1705'),
|
| 123 |
('2022.01.028', '0732'),
|
| 124 |
('2022.01.031', '1704'),
|
| 125 |
('2022.01.032', '1804'),
|
| 126 |
('2022.01.034', '0700'),
|
| 127 |
('2022.01.036', '0733'),
|
| 128 |
('2022.01.037', '1703'),
|
| 129 |
('2022.01.039', '1902'),
|
| 130 |
('2022.01.040', '0744'),
|
| 131 |
('2022.01.046', '0706'),
|
| 132 |
('2022.01.047', '1900'),
|
| 133 |
('2022.01.131', '2300'),
|
| 134 |
('2022.02', '05Y02'),
|
| 135 |
('2022.02.001', '1903'),
|
| 136 |
('2022.02.010', '0708'),
|
| 137 |
('2022.02.011', '1700'),
|
| 138 |
('2022.02.012', '1800'),
|
| 139 |
('2022.02.015', '1901'),
|
| 140 |
('2022.02.019', '0713'),
|
| 141 |
('2022.02.021', '0715'),
|
| 142 |
('2022.02.023', '0718'),
|
| 143 |
('2022.02.026', '1801'),
|
| 144 |
('2022.02.029', '1803'),
|
| 145 |
('2022.02.030', '1702'),
|
| 146 |
('2022.02.033', '1805'),
|
| 147 |
('2022.02.035', '0712'),
|
| 148 |
('2022.02.038', '0705'),
|
| 149 |
('2022.02.041', '0727'),
|
| 150 |
('2022.02.042', '0731'),
|
| 151 |
('2022.02.043', '0741'),
|
| 152 |
('2022.02.044', '0740'),
|
| 153 |
('2022.02.045', '0726'),
|
| 154 |
('2022.02.108', '1200'),
|
| 155 |
('2022.02.109', '1201'),
|
| 156 |
('2022.02.110', '1203'),
|
| 157 |
('2022.02.111', '1202'),
|
| 158 |
('2022.02.112', '1400'),
|
| 159 |
('2022.02.113', '1403'),
|
| 160 |
('2022.02.114', '1401'),
|
| 161 |
('2022.02.115', '1402'),
|
| 162 |
('2022.02.127', '2200'),
|
| 163 |
('2022.03', '05Y03'),
|
| 164 |
('2022.03.060', '0814'),
|
| 165 |
('2022.03.062', '0805'),
|
| 166 |
('2022.03.063', '0800'),
|
| 167 |
('2022.03.064', '0802'),
|
| 168 |
('2022.03.065', '0806'),
|
| 169 |
('2022.03.066', '0808'),
|
| 170 |
('2022.03.067', '0809'),
|
| 171 |
('2022.03.068', '0807'),
|
| 172 |
('2022.03.069', '0811'),
|
| 173 |
('2022.03.070', '0812'),
|
| 174 |
('2022.03.071', '0816'),
|
| 175 |
('2022.03.072', '0813'),
|
| 176 |
('2022.03.073', '0815'),
|
| 177 |
('2022.03.074', '0817'),
|
| 178 |
('2022.03.075', '0818'),
|
| 179 |
('2022.03.076', '0819'),
|
| 180 |
('2022.03.077', '0803'),
|
| 181 |
('2022.03.078', '0804'),
|
| 182 |
('2022.03.079', '0801'),
|
| 183 |
('2022.03.080', '0810'),
|
| 184 |
('2022.03.081', '0800'),
|
| 185 |
('2022.03.082', '0800'),
|
| 186 |
('2022.03.129', '2400'),
|
| 187 |
('2022.04', '05Y04'),
|
| 188 |
('2022.04.049', '0600'),
|
| 189 |
('2022.04.050', '0601'),
|
| 190 |
('2022.04.051', '0103'),
|
| 191 |
('2022.04.052', '0102'),
|
| 192 |
('2022.04.053', '0900'),
|
| 193 |
('2022.04.054', '0902'),
|
| 194 |
('2022.04.057', '0901'),
|
| 195 |
('2022.04.058', '0903'),
|
| 196 |
('2022.04.130', '2500'),
|
| 197 |
('2022.04.132', '2600'),
|
| 198 |
('2022.04.136', '3000'),
|
| 199 |
('2022.05', '05Y05'),
|
| 200 |
('2022.05.092', '1100'),
|
| 201 |
('2022.05.093', '1101'),
|
| 202 |
('2022.05.094', '1102'),
|
| 203 |
('2022.05.095', '1103'),
|
| 204 |
('2022.05.096', '1104'),
|
| 205 |
('2022.05.097', '1105'),
|
| 206 |
('2022.05.098', '1106'),
|
| 207 |
('2022.05.099', '1107'),
|
| 208 |
('2022.05.123', '1601'),
|
| 209 |
('2022.05.124', '1603'),
|
| 210 |
('2022.05.125', '1602'),
|
| 211 |
('2022.05.126', '1600'),
|
| 212 |
('2022.05.133', '2700'),
|
| 213 |
('2022.06', '05Y06'),
|
| 214 |
('2022.06.102', '1302'),
|
| 215 |
('2022.06.103', '1303'),
|
| 216 |
('2022.06.104', '1300'),
|
| 217 |
('2022.06.105', '1301'),
|
| 218 |
('2022.06.128', '2100'),
|
| 219 |
('2022.06.135', '2900'),
|
| 220 |
('2022.07', '05Y07'),
|
| 221 |
('2022.07.116', '1500'),
|
| 222 |
('2022.07.117', '1503'),
|
| 223 |
('2022.07.118', '1504'),
|
| 224 |
('2022.07.119', '1502'),
|
| 225 |
('2022.07.120', '1501'),
|
| 226 |
('2022.07.122', '1500'),
|
| 227 |
('2022.08', '05Y08'),
|
| 228 |
('2022.08.084', '1004'),
|
| 229 |
('2022.08.085', '1000'),
|
| 230 |
('2022.08.086', '1001'),
|
| 231 |
('2022.08.087', '1006'),
|
| 232 |
('2022.08.088', '1000'),
|
| 233 |
('2022.08.090', '1005'),
|
| 234 |
('2022.08.091', '1002'),
|
| 235 |
('2022.08.134', '2800'),
|
| 236 |
('21.0396', '0900'),
|
| 237 |
('21.0399', '0900'),
|
| 238 |
('21.0496', '0800'),
|
| 239 |
('21.0596', '1000'),
|
| 240 |
('21.0696', '1100'),
|
| 241 |
('21.0699', '1100'),
|
| 242 |
('21.0796', '1300'),
|
| 243 |
('21.0799', '1300'),
|
| 244 |
('21.1096', '1500'),
|
| 245 |
('21.2021.03', '0747'),
|
| 246 |
('21.2021.04', '0748'),
|
| 247 |
('21.x.05', NULL),
|
| 248 |
('21.x.13', NULL),
|
| 249 |
('24.2021.02', NULL),
|
| 250 |
('25.00.08', NULL),
|
| 251 |
('25.01.07', NULL),
|
| 252 |
('AMC', '05U00'),
|
| 253 |
('BGD_LD', '05E12'),
|
| 254 |
('BKS', '05B00'),
|
| 255 |
('DT.01', '05P11'),
|
| 256 |
('DT.02', '05P12'),
|
| 257 |
('DT.03', '05P13'),
|
| 258 |
('DT.04', '05P14'),
|
| 259 |
('KNNL', '05P00'),
|
| 260 |
('KTHTBC.19', '05D03'),
|
| 261 |
('KTMLKD.19', '05D01'),
|
| 262 |
('KTNB.19', '05D00'),
|
| 263 |
('KVAG', NULL),
|
| 264 |
('KVBD', NULL),
|
| 265 |
('KVBÐ', NULL),
|
| 266 |
('KVDNAI', NULL),
|
| 267 |
('KVKG', NULL),
|
| 268 |
('KVQN', NULL),
|
| 269 |
('KVQNA', NULL),
|
| 270 |
('KVVP', NULL),
|
| 271 |
('KVÐT', NULL),
|
| 272 |
('NNL.01', '05P21'),
|
| 273 |
('NNL.02', '05P22'),
|
| 274 |
('NNL.03', '05P23'),
|
| 275 |
('NNL.04', '05P24'),
|
| 276 |
('PCBNS', '05Q01'),
|
| 277 |
('PHQLBH', NULL),
|
| 278 |
('PQLN', '05Q02'),
|
| 279 |
('PTDBH', NULL),
|
| 280 |
('PTML', NULL),
|
| 281 |
('PXLN', '05Q03'),
|
| 282 |
('QLN', '05Q00'),
|
| 283 |
('TTB-KVHÐ', '0821'),
|
| 284 |
('TTDT', '05P10'),
|
| 285 |
('TTPTNNL', '05P20'),
|
| 286 |
('VHKT.19', '05D04'),
|
| 287 |
('VPKVMT', NULL)
|
| 288 |
GO |