Untitled

mail@pastecode.io avatar
unknown
plain_text
2 months ago
5.5 kB
6
Indexable
Never
GO
INSERT [mrms].[stress_parameter_setting] ([createdAt], [createdBy], [updatedAt], [updatedBy], [deletedAt], [deletedBy], [isDeleted], [id], [name], [effectiveDate], [status], [filterValuta], [tenor], [IDRSafetyLevel], [valasSafetyLevel], [maker], [noteMaker], [approval], [noteApproval], [checker], [noteChecker], [jsonTimeLine], [monthPicker], [USDSafetyLevel]) VALUES (CAST(N'2023-12-27T10:13:03.4820000' AS DateTime2), N'b25599b8-e978-4f2b-b150-2ce83bb52500', CAST(N'2024-02-27T10:09:22.000' AS DateTime), N'b25599b8-e978-4f2b-b150-2ce83bb52500', NULL, NULL, 1, 1, N'Parameter setting 29 Des 2022', CAST(N'2024-12-05T00:00:00.000' AS DateTime), N'APPROVED', N'( AED, AUD, CAD, CHF, EUR, GBP, HKD, JPY, SAR, SGD, USD )', N'( 1M, 6M, 1Yr, 3Yr, 5Yr, 7Yr, 10Yr, 15Yr, 20Yr, 25Yr, 30Yr )', CAST(7650000000000.00 AS Decimal(19, 2)), CAST(596900000.00 AS Decimal(19, 2)), N'b25599b8-e978-4f2b-b150-2ce83bb52500', N'ok', N'aa6db155-4334-495e-8920-30e0f37ccad5', N'ok', NULL, NULL, N'[{"year":2023,"quartal":"q3","isActive":1},{"year":2023,"quartal":"q4","isActive":1},{"year":2024,"quartal":"q1","isActive":1},{"year":2024,"quartal":"q2","isActive":1},{"year":2024,"quartal":"q3","isActive":1},{"year":2024,"quartal":"q4","isActive":1},{"year":2025,"quartal":"q1","isActive":1},{"year":2025,"quartal":"q2","isActive":1},{"year":2025,"quartal":"q3","isActive":1},{"year":2025,"quartal":"q4","isActive":1},{"year":2026,"quartal":"q1","isActive":1},{"year":2026,"quartal":"q2","isActive":1},{"year":2026,"quartal":"q3","isActive":1},{"year":2026,"quartal":"q4","isActive":1},{"year":2027,"quartal":"q1","isActive":1},{"year":2027,"quartal":"q2","isActive":1},{"year":2027,"quartal":"q3","isActive":1},{"year":2027,"quartal":"q4","isActive":1},{"year":2028,"quartal":"q1","isActive":1},{"year":2028,"quartal":"q2","isActive":1}]', N'05-2023', NULL)
GO
INSERT [mrms].[stress_parameter_setting] ([createdAt], [createdBy], [updatedAt], [updatedBy], [deletedAt], [deletedBy], [isDeleted], [id], [name], [effectiveDate], [status], [filterValuta], [tenor], [IDRSafetyLevel], [valasSafetyLevel], [maker], [noteMaker], [approval], [noteApproval], [checker], [noteChecker], [jsonTimeLine], [monthPicker], [USDSafetyLevel]) VALUES (CAST(N'2024-02-27T11:13:14.5780000' AS DateTime2), N'b25599b8-e978-4f2b-b150-2ce83bb52500', CAST(N'2024-02-27T11:15:16.000' AS DateTime), N'b25599b8-e978-4f2b-b150-2ce83bb52500', NULL, NULL, 0, 2, N'Parameter Januari Testing', CAST(N'2024-01-24T00:00:00.000' AS DateTime), N'APPROVED', N'( AED, AFN, ALL, AMD, ANG, AOA, ARS, AUD, AWG, AZN, BAM )', N'( 1M, 6M, 1Yr, 3Yr, 5Yr, 7Yr, 10Yr, 15Yr, 20Yr, 25Yr, 30Yr )', CAST(7650000000000.00 AS Decimal(19, 2)), CAST(596900000.00 AS Decimal(19, 2)), N'b25599b8-e978-4f2b-b150-2ce83bb52500', N'ok', N'aa6db155-4334-495e-8920-30e0f37ccad5', N'ok', NULL, NULL, N'[{"year":2023,"quartal":"q3","isActive":1},{"year":2023,"quartal":"q4","isActive":1},{"year":2024,"quartal":"q1","isActive":1},{"year":2024,"quartal":"q2","isActive":1},{"year":2024,"quartal":"q3","isActive":1},{"year":2024,"quartal":"q4","isActive":1},{"year":2025,"quartal":"q1","isActive":1},{"year":2025,"quartal":"q2","isActive":1},{"year":2025,"quartal":"q3","isActive":1},{"year":2025,"quartal":"q4","isActive":1},{"year":2026,"quartal":"q1","isActive":1},{"year":2026,"quartal":"q2","isActive":1},{"year":2026,"quartal":"q3","isActive":1},{"year":2026,"quartal":"q4","isActive":1},{"year":2027,"quartal":"q1","isActive":1},{"year":2027,"quartal":"q2","isActive":1},{"year":2027,"quartal":"q3","isActive":1},{"year":2027,"quartal":"q4","isActive":1},{"year":2028,"quartal":"q1","isActive":1},{"year":2028,"quartal":"q2","isActive":1}]', N'02-2024', NULL)
GO
INSERT [mrms].[stress_parameter_setting] ([createdAt], [createdBy], [updatedAt], [updatedBy], [deletedAt], [deletedBy], [isDeleted], [id], [name], [effectiveDate], [status], [filterValuta], [tenor], [IDRSafetyLevel], [valasSafetyLevel], [maker], [noteMaker], [approval], [noteApproval], [checker], [noteChecker], [jsonTimeLine], [monthPicker], [USDSafetyLevel]) VALUES (CAST(N'2024-03-01T04:24:22.1460000' AS DateTime2), N'b25599b8-e978-4f2b-b150-2ce83bb52500', CAST(N'2024-03-01T04:24:40.000' AS DateTime), N'b25599b8-e978-4f2b-b150-2ce83bb52500', NULL, NULL, 0, 3, N'Coba parameter', CAST(N'2024-02-01T00:00:00.000' AS DateTime), N'WAITING FOR APPROVAL', N'( AED, AFN, ALL, AMD, ANG, AOA, ARS, AUD, AWG, AZN, BAM )', N'( 1M, 6M, 1Yr, 3Yr, 5Yr, 7Yr, 10Yr, 15Yr, 20Yr, 25Yr, 30Yr )', CAST(650000000000.00 AS Decimal(19, 2)), CAST(740000000.00 AS Decimal(19, 2)), N'b25599b8-e978-4f2b-b150-2ce83bb52500', N'coba', NULL, NULL, NULL, NULL, N'[{"year":2024,"quartal":"q2","isActive":1},{"year":2024,"quartal":"q3","isActive":1},{"year":2024,"quartal":"q4","isActive":1},{"year":2025,"quartal":"q1","isActive":1},{"year":2025,"quartal":"q2","isActive":1},{"year":2025,"quartal":"q3","isActive":1},{"year":2025,"quartal":"q4","isActive":1},{"year":2026,"quartal":"q1","isActive":1},{"year":2026,"quartal":"q2","isActive":1},{"year":2026,"quartal":"q3","isActive":1},{"year":2026,"quartal":"q4","isActive":1},{"year":2027,"quartal":"q1","isActive":1},{"year":2027,"quartal":"q2","isActive":1},{"year":2027,"quartal":"q3","isActive":1},{"year":2027,"quartal":"q4","isActive":1},{"year":2028,"quartal":"q1","isActive":1},{"year":2028,"quartal":"q2","isActive":1},{"year":2028,"quartal":"q3","isActive":1},{"year":2028,"quartal":"q4","isActive":1},{"year":2029,"quartal":"q1","isActive":1}]', N'03-2024', NULL)
GO
Leave a Comment