-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathDatabase2 Script.sql
More file actions
641 lines (641 loc) · 160 KB
/
Database2 Script.sql
File metadata and controls
641 lines (641 loc) · 160 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
CREATE DATABASE Database1
/****** Object: Table [dbo].[mstEMP] Script Date: 10/08/2021 22:05:09 ******/
DROP TABLE [dbo].[mstEMP]
GO
/****** Object: Table [dbo].[mstSalaryComponent] Script Date: 10/08/2021 22:05:09 ******/
DROP TABLE [dbo].[mstSalaryComponent]
GO
/****** Object: Table [dbo].[trnPayout] Script Date: 10/08/2021 22:05:09 ******/
DROP TABLE [dbo].[trnPayout]
GO
/****** Object: Table [dbo].[trnPayout] Script Date: 10/08/2021 22:05:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[trnPayout](
[Company_Code] [int] NOT NULL,
[Emp_Code] [int] NOT NULL,
[Fyear] [int] NOT NULL,
[Salary_Month] [tinyint] NOT NULL,
[Salary_Year] [smallint] NOT NULL,
[Salary_Comp_Code] [numeric](3, 0) NOT NULL,
[Amount] [numeric](14, 2) NULL,
[Salary_Process_Ind] [tinyint] NULL,
[Salary_Date] [date] NOT NULL,
CONSTRAINT [PK_trnPayout] PRIMARY KEY CLUSTERED
(
[Emp_Code] ASC,
[Salary_Comp_Code] ASC,
[Salary_Date] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(1 AS Numeric(3, 0)), CAST(50000.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(1 AS Numeric(3, 0)), CAST(50000.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(1 AS Numeric(3, 0)), CAST(50000.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(1 AS Numeric(3, 0)), CAST(50000.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(1 AS Numeric(3, 0)), CAST(50000.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(1 AS Numeric(3, 0)), CAST(50000.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(1 AS Numeric(3, 0)), CAST(50000.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(1 AS Numeric(3, 0)), CAST(50000.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(1 AS Numeric(3, 0)), CAST(50000.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(1 AS Numeric(3, 0)), CAST(50000.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(1 AS Numeric(3, 0)), CAST(50000.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(1 AS Numeric(3, 0)), CAST(50000.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(2 AS Numeric(3, 0)), CAST(30000.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(2 AS Numeric(3, 0)), CAST(30000.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(2 AS Numeric(3, 0)), CAST(30000.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(2 AS Numeric(3, 0)), CAST(30000.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(2 AS Numeric(3, 0)), CAST(30000.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(2 AS Numeric(3, 0)), CAST(30000.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(2 AS Numeric(3, 0)), CAST(30000.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(2 AS Numeric(3, 0)), CAST(30000.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(2 AS Numeric(3, 0)), CAST(30000.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(2 AS Numeric(3, 0)), CAST(30000.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(2 AS Numeric(3, 0)), CAST(30000.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(2 AS Numeric(3, 0)), CAST(30000.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(3 AS Numeric(3, 0)), CAST(25000.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(3 AS Numeric(3, 0)), CAST(25000.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(3 AS Numeric(3, 0)), CAST(25000.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(3 AS Numeric(3, 0)), CAST(25000.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(3 AS Numeric(3, 0)), CAST(25000.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(3 AS Numeric(3, 0)), CAST(25000.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(3 AS Numeric(3, 0)), CAST(25000.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(3 AS Numeric(3, 0)), CAST(25000.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(3 AS Numeric(3, 0)), CAST(25000.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(3 AS Numeric(3, 0)), CAST(25000.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(3 AS Numeric(3, 0)), CAST(25000.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(3 AS Numeric(3, 0)), CAST(25000.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(4 AS Numeric(3, 0)), CAST(20000.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(4 AS Numeric(3, 0)), CAST(20000.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(4 AS Numeric(3, 0)), CAST(20000.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(4 AS Numeric(3, 0)), CAST(20000.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(4 AS Numeric(3, 0)), CAST(20000.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(4 AS Numeric(3, 0)), CAST(20000.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(4 AS Numeric(3, 0)), CAST(20000.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(4 AS Numeric(3, 0)), CAST(20000.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(4 AS Numeric(3, 0)), CAST(20000.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(4 AS Numeric(3, 0)), CAST(20000.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(4 AS Numeric(3, 0)), CAST(20000.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(4 AS Numeric(3, 0)), CAST(20000.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(5 AS Numeric(3, 0)), CAST(15000.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(5 AS Numeric(3, 0)), CAST(15000.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(5 AS Numeric(3, 0)), CAST(15000.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(5 AS Numeric(3, 0)), CAST(15000.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(5 AS Numeric(3, 0)), CAST(15000.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(5 AS Numeric(3, 0)), CAST(15000.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(5 AS Numeric(3, 0)), CAST(15000.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(5 AS Numeric(3, 0)), CAST(15000.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(5 AS Numeric(3, 0)), CAST(15000.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(5 AS Numeric(3, 0)), CAST(15000.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(5 AS Numeric(3, 0)), CAST(15000.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(5 AS Numeric(3, 0)), CAST(15000.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(6 AS Numeric(3, 0)), CAST(12000.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(6 AS Numeric(3, 0)), CAST(12000.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(6 AS Numeric(3, 0)), CAST(12000.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(6 AS Numeric(3, 0)), CAST(12000.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(6 AS Numeric(3, 0)), CAST(12000.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(6 AS Numeric(3, 0)), CAST(12000.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(6 AS Numeric(3, 0)), CAST(12000.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(6 AS Numeric(3, 0)), CAST(12000.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(6 AS Numeric(3, 0)), CAST(12000.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(6 AS Numeric(3, 0)), CAST(12000.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(6 AS Numeric(3, 0)), CAST(12000.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(6 AS Numeric(3, 0)), CAST(12000.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(7 AS Numeric(3, 0)), CAST(11000.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(7 AS Numeric(3, 0)), CAST(11000.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(7 AS Numeric(3, 0)), CAST(11000.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(7 AS Numeric(3, 0)), CAST(11000.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(7 AS Numeric(3, 0)), CAST(11000.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(7 AS Numeric(3, 0)), CAST(11000.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(7 AS Numeric(3, 0)), CAST(11000.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(7 AS Numeric(3, 0)), CAST(11000.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(7 AS Numeric(3, 0)), CAST(11000.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(7 AS Numeric(3, 0)), CAST(11000.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(7 AS Numeric(3, 0)), CAST(11000.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(7 AS Numeric(3, 0)), CAST(11000.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(8 AS Numeric(3, 0)), CAST(10000.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(8 AS Numeric(3, 0)), CAST(10000.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(8 AS Numeric(3, 0)), CAST(10000.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(8 AS Numeric(3, 0)), CAST(10000.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(8 AS Numeric(3, 0)), CAST(10000.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(8 AS Numeric(3, 0)), CAST(10000.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(8 AS Numeric(3, 0)), CAST(10000.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(8 AS Numeric(3, 0)), CAST(10000.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(8 AS Numeric(3, 0)), CAST(10000.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(8 AS Numeric(3, 0)), CAST(10000.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(8 AS Numeric(3, 0)), CAST(10000.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(8 AS Numeric(3, 0)), CAST(10000.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(9 AS Numeric(3, 0)), CAST(90000.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(9 AS Numeric(3, 0)), CAST(90000.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(9 AS Numeric(3, 0)), CAST(90000.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(9 AS Numeric(3, 0)), CAST(90000.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(9 AS Numeric(3, 0)), CAST(90000.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
GO
print 'Processed 100 total records'
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(9 AS Numeric(3, 0)), CAST(90000.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(9 AS Numeric(3, 0)), CAST(90000.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(9 AS Numeric(3, 0)), CAST(90000.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(9 AS Numeric(3, 0)), CAST(90000.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(9 AS Numeric(3, 0)), CAST(90000.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(9 AS Numeric(3, 0)), CAST(90000.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(9 AS Numeric(3, 0)), CAST(90000.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(10 AS Numeric(3, 0)), CAST(8500.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(10 AS Numeric(3, 0)), CAST(8500.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(10 AS Numeric(3, 0)), CAST(8500.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(10 AS Numeric(3, 0)), CAST(8500.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(10 AS Numeric(3, 0)), CAST(8500.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(10 AS Numeric(3, 0)), CAST(8500.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(10 AS Numeric(3, 0)), CAST(8500.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(10 AS Numeric(3, 0)), CAST(8500.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(10 AS Numeric(3, 0)), CAST(8500.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(10 AS Numeric(3, 0)), CAST(8500.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(10 AS Numeric(3, 0)), CAST(8500.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(10 AS Numeric(3, 0)), CAST(8500.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(11 AS Numeric(3, 0)), CAST(30000.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(11 AS Numeric(3, 0)), CAST(30000.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(11 AS Numeric(3, 0)), CAST(30000.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(11 AS Numeric(3, 0)), CAST(30000.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(11 AS Numeric(3, 0)), CAST(30000.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(11 AS Numeric(3, 0)), CAST(30000.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(11 AS Numeric(3, 0)), CAST(30000.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(11 AS Numeric(3, 0)), CAST(30000.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(11 AS Numeric(3, 0)), CAST(30000.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(11 AS Numeric(3, 0)), CAST(30000.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(11 AS Numeric(3, 0)), CAST(30000.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(11 AS Numeric(3, 0)), CAST(30000.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(12 AS Numeric(3, 0)), CAST(32000.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(12 AS Numeric(3, 0)), CAST(32000.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(12 AS Numeric(3, 0)), CAST(32000.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(12 AS Numeric(3, 0)), CAST(32000.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(12 AS Numeric(3, 0)), CAST(32000.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(12 AS Numeric(3, 0)), CAST(32000.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(12 AS Numeric(3, 0)), CAST(32000.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(12 AS Numeric(3, 0)), CAST(32000.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(12 AS Numeric(3, 0)), CAST(32000.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(12 AS Numeric(3, 0)), CAST(32000.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(12 AS Numeric(3, 0)), CAST(32000.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(12 AS Numeric(3, 0)), CAST(32000.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(15 AS Numeric(3, 0)), CAST(700.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(15 AS Numeric(3, 0)), CAST(700.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(15 AS Numeric(3, 0)), CAST(700.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(15 AS Numeric(3, 0)), CAST(700.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(15 AS Numeric(3, 0)), CAST(700.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(15 AS Numeric(3, 0)), CAST(700.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(15 AS Numeric(3, 0)), CAST(700.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(15 AS Numeric(3, 0)), CAST(700.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(15 AS Numeric(3, 0)), CAST(700.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(15 AS Numeric(3, 0)), CAST(700.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(15 AS Numeric(3, 0)), CAST(700.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(15 AS Numeric(3, 0)), CAST(700.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(17 AS Numeric(3, 0)), CAST(8000.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(17 AS Numeric(3, 0)), CAST(8000.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(17 AS Numeric(3, 0)), CAST(8000.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(17 AS Numeric(3, 0)), CAST(8000.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(17 AS Numeric(3, 0)), CAST(8000.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(17 AS Numeric(3, 0)), CAST(8000.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(17 AS Numeric(3, 0)), CAST(8000.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(17 AS Numeric(3, 0)), CAST(8000.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(17 AS Numeric(3, 0)), CAST(8000.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(17 AS Numeric(3, 0)), CAST(8000.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(17 AS Numeric(3, 0)), CAST(8000.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(17 AS Numeric(3, 0)), CAST(8000.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(20 AS Numeric(3, 0)), CAST(342200.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(20 AS Numeric(3, 0)), CAST(342200.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(20 AS Numeric(3, 0)), CAST(342200.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(20 AS Numeric(3, 0)), CAST(342200.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(20 AS Numeric(3, 0)), CAST(342200.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(20 AS Numeric(3, 0)), CAST(342200.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(20 AS Numeric(3, 0)), CAST(342200.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(20 AS Numeric(3, 0)), CAST(342200.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(20 AS Numeric(3, 0)), CAST(342200.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(20 AS Numeric(3, 0)), CAST(342200.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(20 AS Numeric(3, 0)), CAST(342200.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(20 AS Numeric(3, 0)), CAST(342200.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(21 AS Numeric(3, 0)), CAST(1000.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(21 AS Numeric(3, 0)), CAST(1000.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(21 AS Numeric(3, 0)), CAST(1000.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(21 AS Numeric(3, 0)), CAST(1000.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(21 AS Numeric(3, 0)), CAST(1000.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(21 AS Numeric(3, 0)), CAST(1000.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(21 AS Numeric(3, 0)), CAST(1000.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(21 AS Numeric(3, 0)), CAST(1000.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(21 AS Numeric(3, 0)), CAST(1000.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(21 AS Numeric(3, 0)), CAST(1000.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(21 AS Numeric(3, 0)), CAST(1000.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(21 AS Numeric(3, 0)), CAST(1000.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(22 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(22 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(22 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(22 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(22 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(22 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(22 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(22 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(22 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(22 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
GO
print 'Processed 200 total records'
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(22 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(22 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(23 AS Numeric(3, 0)), CAST(1800.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(23 AS Numeric(3, 0)), CAST(1800.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(23 AS Numeric(3, 0)), CAST(1800.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(23 AS Numeric(3, 0)), CAST(1800.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(23 AS Numeric(3, 0)), CAST(1800.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(23 AS Numeric(3, 0)), CAST(1800.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(23 AS Numeric(3, 0)), CAST(1800.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(23 AS Numeric(3, 0)), CAST(1800.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(23 AS Numeric(3, 0)), CAST(1800.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(23 AS Numeric(3, 0)), CAST(1800.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(23 AS Numeric(3, 0)), CAST(1800.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(23 AS Numeric(3, 0)), CAST(1800.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(26 AS Numeric(3, 0)), CAST(56093.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(26 AS Numeric(3, 0)), CAST(56093.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(26 AS Numeric(3, 0)), CAST(56093.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(26 AS Numeric(3, 0)), CAST(56093.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(26 AS Numeric(3, 0)), CAST(56093.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(26 AS Numeric(3, 0)), CAST(56093.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(26 AS Numeric(3, 0)), CAST(56093.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(26 AS Numeric(3, 0)), CAST(56093.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(26 AS Numeric(3, 0)), CAST(56093.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(26 AS Numeric(3, 0)), CAST(56093.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(26 AS Numeric(3, 0)), CAST(56093.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(26 AS Numeric(3, 0)), CAST(56093.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(27 AS Numeric(3, 0)), CAST(200.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(27 AS Numeric(3, 0)), CAST(200.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(27 AS Numeric(3, 0)), CAST(200.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(27 AS Numeric(3, 0)), CAST(200.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(27 AS Numeric(3, 0)), CAST(200.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(27 AS Numeric(3, 0)), CAST(200.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(27 AS Numeric(3, 0)), CAST(200.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(27 AS Numeric(3, 0)), CAST(200.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(27 AS Numeric(3, 0)), CAST(200.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(27 AS Numeric(3, 0)), CAST(200.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(27 AS Numeric(3, 0)), CAST(200.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(27 AS Numeric(3, 0)), CAST(200.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(39 AS Numeric(3, 0)), CAST(283949.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(39 AS Numeric(3, 0)), CAST(283949.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(39 AS Numeric(3, 0)), CAST(283949.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(39 AS Numeric(3, 0)), CAST(283949.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(39 AS Numeric(3, 0)), CAST(283949.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(39 AS Numeric(3, 0)), CAST(283949.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(39 AS Numeric(3, 0)), CAST(283949.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(39 AS Numeric(3, 0)), CAST(283949.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(39 AS Numeric(3, 0)), CAST(283949.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(39 AS Numeric(3, 0)), CAST(283949.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(39 AS Numeric(3, 0)), CAST(283949.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(39 AS Numeric(3, 0)), CAST(283949.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(40 AS Numeric(3, 0)), CAST(342200.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(40 AS Numeric(3, 0)), CAST(342200.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(40 AS Numeric(3, 0)), CAST(342200.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(40 AS Numeric(3, 0)), CAST(342200.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(40 AS Numeric(3, 0)), CAST(342200.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(40 AS Numeric(3, 0)), CAST(342200.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(40 AS Numeric(3, 0)), CAST(342200.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(40 AS Numeric(3, 0)), CAST(342200.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(40 AS Numeric(3, 0)), CAST(342200.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(40 AS Numeric(3, 0)), CAST(342200.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(40 AS Numeric(3, 0)), CAST(342200.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(40 AS Numeric(3, 0)), CAST(342200.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(62 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(62 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(62 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(62 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(62 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(62 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(62 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(62 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(62 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(62 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(62 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(62 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(64 AS Numeric(3, 0)), CAST(158.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(64 AS Numeric(3, 0)), CAST(158.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(64 AS Numeric(3, 0)), CAST(158.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(64 AS Numeric(3, 0)), CAST(158.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(64 AS Numeric(3, 0)), CAST(158.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(64 AS Numeric(3, 0)), CAST(158.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(64 AS Numeric(3, 0)), CAST(158.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(64 AS Numeric(3, 0)), CAST(158.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(64 AS Numeric(3, 0)), CAST(158.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(64 AS Numeric(3, 0)), CAST(158.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(64 AS Numeric(3, 0)), CAST(158.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(64 AS Numeric(3, 0)), CAST(158.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(71 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(71 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(71 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(71 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(71 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(71 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(71 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(71 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(71 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(71 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(71 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(71 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(95 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(95 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(95 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
GO
print 'Processed 300 total records'
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(95 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(95 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(95 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(95 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(95 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(95 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(95 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(95 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(95 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(105 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(105 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(105 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(105 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(105 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(105 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(105 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(105 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(105 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(105 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(105 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(105 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(121 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(121 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(121 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(121 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(121 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(121 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(121 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(121 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(121 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(121 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(121 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(121 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(138 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(138 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(138 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(138 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(138 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(138 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(138 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(138 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(138 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(138 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(138 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(138 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(140 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(140 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(140 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(140 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(140 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(140 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(140 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(140 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(140 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(140 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(140 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(140 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(149 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(149 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(149 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(149 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(149 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(149 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(149 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(149 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(149 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(149 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(149 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(149 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(150 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(150 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(150 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(150 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(150 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(150 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(150 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(150 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(150 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(150 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(150 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(150 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(157 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(157 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(157 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(157 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(157 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(157 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(157 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(157 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(157 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(157 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(157 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(157 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 4, 2021, CAST(160 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x58420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 5, 2021, CAST(160 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x76420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 6, 2021, CAST(160 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x95420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 7, 2021, CAST(160 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xB3420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 8, 2021, CAST(160 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xD2420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 9, 2021, CAST(160 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xF1420B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 10, 2021, CAST(160 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x0F430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 11, 2021, CAST(160 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x2E430B00 AS Date))
GO
print 'Processed 400 total records'
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 12, 2021, CAST(160 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x4C430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 1, 2022, CAST(160 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x6B430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 2, 2022, CAST(160 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0x8A430B00 AS Date))
INSERT [dbo].[trnPayout] ([Company_Code], [Emp_Code], [Fyear], [Salary_Month], [Salary_Year], [Salary_Comp_Code], [Amount], [Salary_Process_Ind], [Salary_Date]) VALUES (4100, 410101, 2021, 3, 2022, CAST(160 AS Numeric(3, 0)), CAST(0.00 AS Numeric(14, 2)), NULL, CAST(0xA6430B00 AS Date))
/****** Object: Table [dbo].[mstSalaryComponent] Script Date: 10/08/2021 22:05:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[mstSalaryComponent](
[Salary_Comp_Code] [int] NOT NULL,
[Section_Name] [varchar](50) NULL,
[Salary_Comp_Name] [varchar](100) NULL,
[Ctc_Ind] [tinyint] NULL,
[Gross_Ind] [tinyint] NULL,
[Earning_Ind] [tinyint] NULL,
[Deduction_Ind] [tinyint] NULL,
[Gross_Total_Ind] [tinyint] NULL,
[Ctc_Total_Ind] [tinyint] NULL,
[Basic_Ind] [tinyint] NULL,
[NetPay_Ind] [tinyint] NULL,
CONSTRAINT [PK_mstSalaryComponent] PRIMARY KEY CLUSTERED
(
[Salary_Comp_Code] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (1, N'Earning Taxable', N'Basic', 1, 1, 1, 0, 0, 0, 1, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (2, N'Earning Taxable', N'D.A', 1, 1, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (3, N'Earning Taxable', N'House Rent Allowance (HRA)', 1, 1, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (4, N'Earning Taxable', N'Medical Reimbursement', 1, 1, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (5, N'Earning Taxable', N'Meal Allowance', 1, 1, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (6, N'Earning Taxable', N'Transportation Allowance', 1, 1, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (7, N'Earning Taxable', N'Children Education Allowances', 1, 1, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (8, N'Earning Taxable', N'Attire Reimbursement Allowance', 1, 1, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (9, N'Earning Taxable', N'Professional Pursuit Reimbursement Allowance', 1, 1, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (10, N'Earning Taxable', N'Helper Reimbursement Allowance', 1, 1, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (11, N'Earning Taxable', N'Variable Performance Allowance', 1, 1, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (12, N'Earning Taxable', N'Adhoc Pay', 1, 1, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (13, N'Earning Taxable', N'City Compensatory Allowance (CCA)', 1, 1, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (14, N'Earning Taxable', N'Professional Development Allowance', 1, 1, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (15, N'Earning Taxable', N'Telephone Reimbursement Allowance', 1, 1, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (16, N'Earning Taxable', N'Fuel Reimbursement Allowance', 1, 1, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (17, N'Earning Taxable', N'Driver Reimbursement Allowance', 1, 1, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (18, N'Earning Taxable', N'Sodexo Gift Voucher', 1, 1, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (19, N'Earning Taxable', N'Ex-Gratia', 1, 1, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (20, N'GROSS SALARY', N'Gross Salary', 0, 0, 1, 0, 1, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (21, N'Other Earning', N'Bonus', 1, 0, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (22, N'Other Earning', N'LTA', 1, 0, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (23, N'Deduction', N'P. F.', 1, 0, 0, 1, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (24, NULL, N'Gratuity', 1, 0, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (25, N'', N'Total CTC', 0, 0, 1, 0, 0, 1, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (26, N'Deduction', N'TDS', 0, 0, 0, 1, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (27, N'Deduction', N'P.T.', 0, 0, 0, 1, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (28, N'Deduction Taxable', N'Advance', 1, 0, 0, 1, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (29, N'Deduction Taxable', N'Loan', 0, 0, 0, 1, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (30, N'Deduction Non Taxable', N'Sodexo', 0, 0, 0, 1, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (31, N'Deduction Taxable', N'Mobile Bill', 0, 0, 0, 1, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (32, N'Deduction Taxable', N'Veh. / Bus Deduction', 0, 0, 0, 1, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (33, N'Deduction Taxable', N'L. W. F.', 0, 0, 0, 1, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (34, N'Deduction Taxable', N'Lunch', 0, 0, 0, 1, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (35, N'Deduction Taxable', N'Other Deduction', 0, 0, 0, 1, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (36, N'Other Earning', N'S. A. S.', 1, 0, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (37, N'Earning Taxable', N'Incentive', 1, 0, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (38, N'Deduction Non Taxable', N'Donation', 0, 0, 0, 1, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (39, N'Net Pay', N'Net Pay', 0, 0, 0, 0, 0, 0, NULL, 1)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (40, N'Gross Salary', N'Gross Salary Without Add Earning', 0, 0, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (41, N'Earning Taxable', N'Bonus - Payout', 0, 0, 1, 0, 0, 0, 0, 0)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (42, N'Earning Taxable', N'LTA - Payout', 0, 0, 1, 0, 0, 0, 0, 0)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (43, N'Earning Taxable', N'S.A.S - Payout', 0, 0, 1, 0, 0, 0, 0, 0)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (44, N'Earning Taxable', N'VARIABLE PERFORMANCE ALLOWANCE - Payout', 0, 0, 1, 0, 0, 0, 0, 0)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (45, N'Earning Taxable', N'Leave Encashment - Payout', 0, 0, 1, 0, 0, 0, 0, 0)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (46, N'Earning Taxable', N'Areear', 0, 0, 1, 0, 0, 0, 0, 0)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (47, N'Earning Taxable', N'Perfomance Incentive', 0, 0, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (49, N'Earning Taxable', N'PERFOMANCE ALLOWANCE', 0, 0, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (50, N'Deduction Taxable', N'DAMGES DEDUCTION', 0, 0, 0, 1, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (51, N'Earning Taxable', N'PERFOMANCE ALLOWANCE - Payout', 0, 0, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (53, N'Earning Taxable', N'Previledge Leave - Payout ', 0, 0, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (54, N'Earning Taxable', N'C-OFF Document - Payout ', 0, 0, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (55, N'Earning Taxable', N'Areear Basic', 0, 0, 1, 0, 0, 0, 0, 0)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (56, N'Earning Taxable', N'Areear Other Component', 0, 0, 1, 0, 0, 0, 0, 0)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (57, N'Earning Taxable', N'Areear OT', 0, 0, 1, 0, 0, 0, 0, 0)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (58, N'Earning Taxable', N'Areear - Basic ( Salary Difference )', 0, 0, 1, 0, 0, 0, 0, 0)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (59, N'Earning Taxable', N'Areear Other Component Salary Difference', 0, 0, 1, 0, 0, 0, 0, 0)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (60, N'Earning Taxable', N'Areear Others', 0, 0, 1, 0, 0, 0, 0, 0)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (61, N'Earning Taxable', N'Incentive - Payout ', 0, 0, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (62, N'Deduction', N'Additional TDS', 0, 0, 0, 1, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (64, N'Deduction', N'ESI', 1, 0, 0, 1, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (65, N'Deduction Taxable', N'Car Loan', 0, 0, 0, 1, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (71, N'Deduction', N'Less TDS', 0, 0, 0, 1, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (72, N'Earning Taxable', N'Arrear - House Rent Allowance (HRA)', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (73, N'Earning Taxable', N'Arrear - Medical Reimbursement', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (74, N'Earning Taxable', N'Arrear - Meal Allowance', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (75, N'Earning Taxable', N'Arrear - Professional Pursuit Reimbursement Allowance', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (76, N'Earning Taxable', N'Arrear - Helper Reimbursement Allowance', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (77, N'Earning Taxable', N'Arrear - Adhoc Pay', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (78, N'Earning Taxable', N'Arrear - City Compensatory Allowance (CCA)', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (79, N'Earning Non Taxable', N'Arrear - Transportation Allowance', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (80, N'Earning Taxable', N'Arrear - Children Education Allowances', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (81, N'Earning Taxable', N'Arrear - Attire Reimbursement Allowance', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (82, N'Earning Taxable', N'Arrear - Variable Performance Allowance', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (87, N'Earning Taxable', N'Casual Leave - Payout ', 0, 0, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (88, N'Earning Taxable', N'Arrear - Professional Development Allowance', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (89, N'Deduction Taxable', N'PF Employer Share', 0, 0, 0, 1, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (90, N'Deduction Taxable', N'ESIC Employer Share', 0, 0, 0, 1, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (91, N'Deduction Taxable', N'Personal Loan', 0, 0, 0, 1, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (92, N'Deduction Taxable', N'Company Loan', 0, 0, 0, 1, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (95, N'Deduction Taxable', N'Pro rata Hours Deduction', 0, 0, 0, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (105, N'Earning Taxable', N'Waived Off', 0, 0, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (107, N'Earning Taxable', N'Arrear - OT', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (108, N'Earning Taxable', N'Test Component', 0, 0, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (109, N'Earning Taxable', N'Arrear - D.A', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (110, N'Earning Taxable', N'Fix Pay', 1, 1, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (111, N'Earning Taxable', N'Fix Allowances Monthly', 1, 1, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (112, N'Deduction Taxable', N'Attandance Allowance', 0, 0, 0, 1, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (113, N'Deduction Taxable', N'Attandance Deduction', 0, 0, 0, 1, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (114, N'Earning Taxable', N'C-OFF - Payout ', 0, 0, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (115, N'Earning Taxable', N'Privilege Leave - Payout ', 0, 0, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (116, N'Earning Taxable', N'Tea Snacks', 0, 0, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (117, N'Earning Taxable', N'Casual Leaves - Payout ', 0, 0, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (118, N'Earning Taxable', N'Sick Leave - Payout ', 0, 0, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (119, N'Earning Taxable', N'Sp - Payout ', 0, 0, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (120, N'Earning Taxable', N'Encourgement Allowances', 1, 1, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (121, N'Deduction Taxable', N'Slab Base Hours Deduction', 0, 0, 0, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (122, N'Deduction Taxable', N'Sleeping Penalty', 0, 0, 0, 1, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (123, N'Other Earning', N'Arrear - Bonus', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (124, N'Deduction Taxable', N'Voluntary PF', 0, 0, 0, 1, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (125, N'Earning Taxable', N'P2', 0, 0, 1, 0, NULL, NULL, NULL, NULL)
GO
print 'Processed 100 total records'
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (126, N'Earning Taxable', N'P3', 0, 0, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (127, N'Earning Taxable', N'Arrear - Fuel Reimbursement Allowance', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (128, N'Earning Taxable', N'Arrear - Driver Reimbursement Allowance', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (129, N'Earning Taxable', N'Arrear - Fix Pay', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (130, N'Earning Taxable', N'Arrear - Fix Allowances Monthly', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (131, N'Earning Taxable', N'Allowance - Fixed', 1, 1, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (132, N'Earning Taxable', N'Allowance - Monthly', 1, 1, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (133, N'Earning Taxable', N'Allowance - Daily', 1, 1, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (134, N'Deduction Taxable', N'New Decution Component', 0, 0, 0, 1, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (135, N'Earning Taxable', N'Arrear - Allowance - Fixed', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (136, N'Earning Taxable', N'Arrear - Allowance - Monthly', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (137, N'Earning Taxable', N'Arrear - Allowance - Daily', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (138, N'Deduction Taxable', N'LateCome/EarlyGo Days Deduction', 0, 0, 0, 1, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (139, N'Deduction Taxable', N'L1', 0, 0, 0, 1, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (140, N'Deduction', N'GPF', 1, 0, 0, 1, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (141, N'Deduction Taxable', N'GPF Loan', 0, 0, 0, 1, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (142, N'Earning Taxable', N'Conveyance Allowance', 1, 1, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (143, N'Earning Taxable', N'Special Allowance', 1, 1, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (144, N'Deduction', N'Mediclaim Policy', 1, 0, 0, 1, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (145, N'Deduction', N'W C Policy', 1, 0, 0, 1, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (146, N'Deduction', N'Transportation', 1, 0, 0, 1, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (147, N'Deduction Taxable', N'Uniform', 0, 0, 0, 1, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (148, N'Deduction Taxable', N'penalty', 0, 0, 0, 1, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (149, N'Deduction Taxable', N'Casual Leaves Deduction - Payout', 0, 0, 0, 1, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (150, N'Deduction Taxable', N'Privilege Leave Deduction - Payout', 0, 0, 0, 1, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (151, N'Earning Taxable', N'Extra Pay - 1', 1, 1, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (152, N'Earning Taxable', N'Present Day Allowance - Mahesh', 0, 0, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (153, N'Earning Taxable', N'new ot allo', 0, 0, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (154, N'Earning Taxable', N'new attendance allow', 0, 0, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (155, N'Deduction Taxable', N'Present Day Deduction - Mahesh 1', 0, 0, 0, 1, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (156, N'Earning Taxable', N'OT Allowance - Mahesh 1', 0, 0, 1, 0, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (157, N'Deduction Taxable', N'Privilege Leave - Deduction', 0, 0, 0, 1, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (158, N'Deduction Taxable', N'Life Insurance Corporation', 1, 0, 0, 1, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (159, N'Earning Taxable', N'Jenil Leave - Payout ', 0, 0, 1, 0, 0, 0, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (160, N'Deduction Taxable', N'Casual Leaves - Deduction', 0, 0, 0, 1, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (161, N'Deduction Non Taxable', N'Dinner', 0, 0, 0, 1, NULL, NULL, NULL, NULL)
INSERT [dbo].[mstSalaryComponent] ([Salary_Comp_Code], [Section_Name], [Salary_Comp_Name], [Ctc_Ind], [Gross_Ind], [Earning_Ind], [Deduction_Ind], [Gross_Total_Ind], [Ctc_Total_Ind], [Basic_Ind], [NetPay_Ind]) VALUES (162, N'Earning Non Taxable', N'Other Earning', 0, 0, 1, 0, NULL, NULL, NULL, NULL)
/****** Object: Table [dbo].[mstEMP] Script Date: 10/08/2021 22:05:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[mstEMP](
[Company_Code] [int] NULL,
[Emp_Code] [int] NOT NULL,
[Emp_First_Name] [varchar](100) NULL,
[Emp_Middle_Name] [varchar](100) NULL,
[Emp_Last_Name] [varchar](100) NULL,
[Active] [numeric](1, 0) NULL,
CONSTRAINT [PK_mstEMP] PRIMARY KEY CLUSTERED
(
[Emp_Code] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[mstEMP] ([Company_Code], [Emp_Code], [Emp_First_Name], [Emp_Middle_Name], [Emp_Last_Name], [Active]) VALUES (4100, 410101, N'Manish', N'', N'Sharma', CAST(1 AS Numeric(1, 0)))
INSERT [dbo].[mstEMP] ([Company_Code], [Emp_Code], [Emp_First_Name], [Emp_Middle_Name], [Emp_Last_Name], [Active]) VALUES (4100, 410102, N'Jenish', N'', N'Sharma', CAST(1 AS Numeric(1, 0)))
INSERT [dbo].[mstEMP] ([Company_Code], [Emp_Code], [Emp_First_Name], [Emp_Middle_Name], [Emp_Last_Name], [Active]) VALUES (4100, 410103, N'Fenish', N'', N'Sharma', CAST(1 AS Numeric(1, 0)))