/* Run this script on: 192.168.3.105\MSSQLSERVER2014.MinovaHR_BANK_MEGA_Production - This database will be modified to synchronize it with: remote.minovais.com,1458.MinovaHR_BANK_MEGA_Development You are recommended to back up your database before running this script Script created by SQL Data Compare version 14.2.9.15508 from Red Gate Software Ltd at 22/04/2025 09.38.41 */ SET NUMERIC_ROUNDABORT OFF GO SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS, NOCOUNT ON GO SET DATEFORMAT YMD GO SET XACT_ABORT ON GO SET TRANSACTION ISOLATION LEVEL Serializable GO BEGIN TRANSACTION PRINT(N'Add rows to [dbo].[base_cust_menu]') INSERT INTO [dbo].[base_cust_menu] ([landscape], [id], [promoted], [promote_id], [active], [systype], [menutype], [menucat], [level], [seq], [isfolder], [parent_id], [text], [lang], [expanded], [iconcls], [program], [href], [target], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'upload_md_o', N'1', N'00000000', N'1', N'S', N'E', N'P', 2, 99, N'0', N'13000000', N'Upload MD Organization', N'EN', NULL, N'icon-book_red', N'upload_md_om', NULL, N'', NULL, NULL, NULL, NULL) PRINT(N'Operation applied to 1 rows out of 7') PRINT(N'Add rows to [dbo].[base_cust_profile_menu]') INSERT INTO [dbo].[base_cust_profile_menu] ([landscape], [profile_id], [menu_id], [created_by], [created_dt], [changed_by], [changed_dt]) VALUES (N'100', N'PR_SYST_IMPL', N'upload_md_o', NULL, NULL, NULL, NULL) PRINT(N'Operation applied to 1 rows out of 196') PRINT(N'Add row to [dbo].[devt_module]') INSERT INTO [dbo].[devt_module] ([landscape], [name], [active], [promoted], [promote_id], [systype], [application], [module_type], [desc], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'1', N'1', N'00000000', N'S', N'11000', NULL, NULL, NULL, NULL, NULL, NULL) PRINT(N'Add rows to [dbo].[devt_object]') INSERT INTO [dbo].[devt_object] ([landscape], [module], [name], [ver], [active], [seq], [promoted], [promote_id], [systype], [objtype], [objclass], [finput], [content], [url], [create_user], [create_dt], [change_user], [change_dt], [on_the_fly_code]) VALUES (N'100', N'hrPAUpload_OM', N'Main', 1, N'1', 0, N'1', N'00000000', N'S', N'UI', N'Panel', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object] ([landscape], [module], [name], [ver], [active], [seq], [promoted], [promote_id], [systype], [objtype], [objclass], [finput], [content], [url], [create_user], [create_dt], [change_user], [change_dt], [on_the_fly_code]) VALUES (N'100', N'hrPAUpload_OM', N'MainBN', 1, N'1', 0, N'1', N'00000000', N'S', N'UI', N'Panel', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object] ([landscape], [module], [name], [ver], [active], [seq], [promoted], [promote_id], [systype], [objtype], [objclass], [finput], [content], [url], [create_user], [create_dt], [change_user], [change_dt], [on_the_fly_code]) VALUES (N'100', N'hrPAUpload_OM', N'MainET', 1, N'1', 0, N'1', N'00000000', N'S', N'UI', N'Panel', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object] ([landscape], [module], [name], [ver], [active], [seq], [promoted], [promote_id], [systype], [objtype], [objclass], [finput], [content], [url], [create_user], [create_dt], [change_user], [change_dt], [on_the_fly_code]) VALUES (N'100', N'hrPAUpload_OM', N'MainO2', 1, N'1', 0, N'1', N'00000000', N'S', N'UI', N'Panel', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object] ([landscape], [module], [name], [ver], [active], [seq], [promoted], [promote_id], [systype], [objtype], [objclass], [finput], [content], [url], [create_user], [create_dt], [change_user], [change_dt], [on_the_fly_code]) VALUES (N'100', N'hrPAUpload_OM', N'MainOD', 1, N'1', 0, N'1', N'00000000', N'S', N'UI', N'Panel', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object] ([landscape], [module], [name], [ver], [active], [seq], [promoted], [promote_id], [systype], [objtype], [objclass], [finput], [content], [url], [create_user], [create_dt], [change_user], [change_dt], [on_the_fly_code]) VALUES (N'100', N'hrPAUpload_OM', N'MainOM', 1, N'1', 0, N'1', N'00000000', N'S', N'UI', N'Panel', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object] ([landscape], [module], [name], [ver], [active], [seq], [promoted], [promote_id], [systype], [objtype], [objclass], [finput], [content], [url], [create_user], [create_dt], [change_user], [change_dt], [on_the_fly_code]) VALUES (N'100', N'hrPAUpload_OM', N'MainP0', 1, N'1', 0, N'1', N'00000000', N'S', N'UI', N'Panel', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object] ([landscape], [module], [name], [ver], [active], [seq], [promoted], [promote_id], [systype], [objtype], [objclass], [finput], [content], [url], [create_user], [create_dt], [change_user], [change_dt], [on_the_fly_code]) VALUES (N'100', N'hrPAUpload_OM', N'MainPY', 1, N'1', 0, N'1', N'00000000', N'S', N'UI', N'Panel', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object] ([landscape], [module], [name], [ver], [active], [seq], [promoted], [promote_id], [systype], [objtype], [objclass], [finput], [content], [url], [create_user], [create_dt], [change_user], [change_dt], [on_the_fly_code]) VALUES (N'100', N'hrPAUpload_OM', N'MainTM', 1, N'1', 0, N'1', N'00000000', N'S', N'UI', N'Panel', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object] ([landscape], [module], [name], [ver], [active], [seq], [promoted], [promote_id], [systype], [objtype], [objclass], [finput], [content], [url], [create_user], [create_dt], [change_user], [change_dt], [on_the_fly_code]) VALUES (N'100', N'hrPAUpload_OM', N'MainTR', 1, N'1', 0, N'1', N'00000000', N'S', N'UI', N'Panel', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object] ([landscape], [module], [name], [ver], [active], [seq], [promoted], [promote_id], [systype], [objtype], [objclass], [finput], [content], [url], [create_user], [create_dt], [change_user], [change_dt], [on_the_fly_code]) VALUES (N'100', N'hrPAUpload_OM', N'MainYT', 1, N'1', 0, N'1', N'00000000', N'S', N'UI', N'Panel', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object] ([landscape], [module], [name], [ver], [active], [seq], [promoted], [promote_id], [systype], [objtype], [objclass], [finput], [content], [url], [create_user], [create_dt], [change_user], [change_dt], [on_the_fly_code]) VALUES (N'100', N'hrPAUpload_OM', N'btnUpload', 1, N'1', 1, N'1', N'00000000', N'S', N'UI', N'Button', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object] ([landscape], [module], [name], [ver], [active], [seq], [promoted], [promote_id], [systype], [objtype], [objclass], [finput], [content], [url], [create_user], [create_dt], [change_user], [change_dt], [on_the_fly_code]) VALUES (N'100', N'hrPAUpload_OM', N'dataMDType', 1, N'1', 2, N'1', N'00000000', N'S', N'DATA', N'JsonStore', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object] ([landscape], [module], [name], [ver], [active], [seq], [promoted], [promote_id], [systype], [objtype], [objclass], [finput], [content], [url], [create_user], [create_dt], [change_user], [change_dt], [on_the_fly_code]) VALUES (N'100', N'hrPAUpload_OM', N'dataResult', 1, N'1', 1, N'1', N'00000000', N'S', N'DATA', N'JsonStore', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object] ([landscape], [module], [name], [ver], [active], [seq], [promoted], [promote_id], [systype], [objtype], [objclass], [finput], [content], [url], [create_user], [create_dt], [change_user], [change_dt], [on_the_fly_code]) VALUES (N'100', N'hrPAUpload_OM', N'fldAppCat', 1, N'1', 1, N'1', N'00000000', N'S', N'FIELD', N'Hidden', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object] ([landscape], [module], [name], [ver], [active], [seq], [promoted], [promote_id], [systype], [objtype], [objclass], [finput], [content], [url], [create_user], [create_dt], [change_user], [change_dt], [on_the_fly_code]) VALUES (N'100', N'hrPAUpload_OM', N'fldExecute', 1, N'1', 2, N'1', N'00000000', N'S', N'FIELD', N'Radio', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object] ([landscape], [module], [name], [ver], [active], [seq], [promoted], [promote_id], [systype], [objtype], [objclass], [finput], [content], [url], [create_user], [create_dt], [change_user], [change_dt], [on_the_fly_code]) VALUES (N'100', N'hrPAUpload_OM', N'fldFile', 1, N'1', 1, N'1', N'00000000', N'S', N'FIELD', N'FileUploadField', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object] ([landscape], [module], [name], [ver], [active], [seq], [promoted], [promote_id], [systype], [objtype], [objclass], [finput], [content], [url], [create_user], [create_dt], [change_user], [change_dt], [on_the_fly_code]) VALUES (N'100', N'hrPAUpload_OM', N'fldForceAction', 1, N'1', 1, N'1', N'00000000', N'S', N'FIELD', N'Checkbox', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object] ([landscape], [module], [name], [ver], [active], [seq], [promoted], [promote_id], [systype], [objtype], [objclass], [finput], [content], [url], [create_user], [create_dt], [change_user], [change_dt], [on_the_fly_code]) VALUES (N'100', N'hrPAUpload_OM', N'fldMDType', 1, N'1', 1, N'1', N'00000000', N'S', N'FIELD', N'ComboBox', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object] ([landscape], [module], [name], [ver], [active], [seq], [promoted], [promote_id], [systype], [objtype], [objclass], [finput], [content], [url], [create_user], [create_dt], [change_user], [change_dt], [on_the_fly_code]) VALUES (N'100', N'hrPAUpload_OM', N'fldRadioGroup', 1, N'1', 1, N'1', N'00000000', N'S', N'FIELD', N'RadioGroup', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object] ([landscape], [module], [name], [ver], [active], [seq], [promoted], [promote_id], [systype], [objtype], [objclass], [finput], [content], [url], [create_user], [create_dt], [change_user], [change_dt], [on_the_fly_code]) VALUES (N'100', N'hrPAUpload_OM', N'fldSimulate', 1, N'1', 2, N'1', N'00000000', N'S', N'FIELD', N'Radio', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object] ([landscape], [module], [name], [ver], [active], [seq], [promoted], [promote_id], [systype], [objtype], [objclass], [finput], [content], [url], [create_user], [create_dt], [change_user], [change_dt], [on_the_fly_code]) VALUES (N'100', N'hrPAUpload_OM', N'fnMain', 1, N'1', NULL, N'1', N'00000000', N'S', N'CODE', N'', N'app_cat', N'fldAppCat.setValue(app_cat); dataMDType.load({ params: {app_cat: fldAppCat.getValue()} }); if (app_cat==''MD'') { Main.add(pnlParam); Main.add(pnlLog); } else if (app_cat==''PY'') { MainPY.add(pnlParam); MainPY.add(pnlLog); } else if (app_cat==''TM'') { MainTM.add(pnlParam); MainTM.add(pnlLog); } else if (app_cat==''OM'') { MainOM.add(pnlParam); MainOM.add(pnlLog); } else if (app_cat==''BN'') { MainBN.add(pnlParam); MainBN.add(pnlLog); } else if (app_cat==''TR'') { MainTM.add(pnlParam); MainTM.add(pnlLog); } else if (app_cat==''YT'') { MainYT.add(pnlParam); MainYT.add(pnlLog); } else if (app_cat==''ET'') { MainET.add(pnlParam); MainET.add(pnlLog); } else { var pnlMain = eval("Main"+app_cat); if (pnlMain != null) { pnlMain.add(pnlParam); pnlMain.add(pnlLog); } } ', NULL, NULL, NULL, NULL, NULL, 0) INSERT INTO [dbo].[devt_object] ([landscape], [module], [name], [ver], [active], [seq], [promoted], [promote_id], [systype], [objtype], [objclass], [finput], [content], [url], [create_user], [create_dt], [change_user], [change_dt], [on_the_fly_code]) VALUES (N'100', N'hrPAUpload_OM', N'fnReloadMDTyp', 1, N'1', NULL, N'1', N'00000000', N'S', N'CODE', N'', N'', N'dataMDType.reload({ params: {app_cat: fldAppCat.getValue()} });', NULL, NULL, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object] ([landscape], [module], [name], [ver], [active], [seq], [promoted], [promote_id], [systype], [objtype], [objclass], [finput], [content], [url], [create_user], [create_dt], [change_user], [change_dt], [on_the_fly_code]) VALUES (N'100', N'hrPAUpload_OM', N'fnUploadData', 1, N'1', NULL, N'1', N'00000000', N'S', N'CODE', N'', N'', N'var _num = (fldFile.getValue().length) - 4; var _num1 = (fldFile.getValue().length) - 5; alert(_num1); alert(Ext.util.Format.substr(fldFile.getValue(),_num1,5)); if (Ext.util.Format.substr(fldFile.getValue(),_num,4) == ".xls" || Ext.util.Format.substr(fldFile.getValue(),_num1,5) == ".xlsx" ) { if(pnlParam.getForm().isValid()){ pnlParam.getForm().submit({ url: "/HR_Core/UploadMDData", waitMsg: "Uploading data...", method: "POST", success: function(pnlParam, o) { dataResult.loadData(o.result.logs); Ext.Msg.show({ title: ''Result'', msg: ''Process OK'', buttons: Ext.Msg.OK, icon: Ext.Msg.INFO }); }, failure: function(pnlParam, o) { Ext.Msg.show({ title: ''Result'', msg: o.result.error, buttons: Ext.Msg.OK, icon: Ext.Msg.ERROR }); } }) } }', NULL, NULL, NULL, NULL, NULL, 0) INSERT INTO [dbo].[devt_object] ([landscape], [module], [name], [ver], [active], [seq], [promoted], [promote_id], [systype], [objtype], [objclass], [finput], [content], [url], [create_user], [create_dt], [change_user], [change_dt], [on_the_fly_code]) VALUES (N'100', N'hrPAUpload_OM', N'pnlLog', 1, N'1', 0, N'1', N'00000000', N'S', N'UI', N'GridPanel', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object] ([landscape], [module], [name], [ver], [active], [seq], [promoted], [promote_id], [systype], [objtype], [objclass], [finput], [content], [url], [create_user], [create_dt], [change_user], [change_dt], [on_the_fly_code]) VALUES (N'100', N'hrPAUpload_OM', N'pnlParam', 1, N'1', 0, N'1', N'00000000', N'S', N'UI', N'FormPanel', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) PRINT(N'Operation applied to 26 rows out of 44') PRINT(N'Add rows to [dbo].[devt_object_conf]') INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'Main', N'C', N'height', 1, N'1', N'1', N'00000000', N'S', NULL, N'500', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'Main', N'C', N'layout', 1, N'1', N'1', N'00000000', N'S', NULL, N'border', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'Main', N'C', N'width', 1, N'1', N'1', N'00000000', N'S', NULL, N'800', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'Main', N'E', N'render', 1, N'1', N'1', N'00000000', N'S', N'', N'fnMain(''MD'');', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainBN', N'C', N'layout', 1, N'1', N'1', N'00000000', N'S', NULL, N'border', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainBN', N'E', N'render', 1, N'1', N'1', N'00000000', N'S', N'', N'fnMain("BN");', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainET', N'C', N'height', 1, N'1', N'1', N'00000000', N'S', NULL, N'500', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainET', N'C', N'layout', 1, N'1', N'1', N'00000000', N'S', NULL, N'border', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainET', N'C', N'width', 1, N'1', N'1', N'00000000', N'S', NULL, N'800', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainET', N'E', N'render', 1, N'1', N'1', N'00000000', N'S', N'', N'fnMain(''ET'');', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainO2', N'C', N'layout', 1, N'1', N'1', N'00000000', N'S', NULL, N'border', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainO2', N'E', N'render', 1, N'1', N'1', N'00000000', N'S', N'', N'fnMain("O2");', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainOD', N'C', N'height', 1, N'1', N'1', N'00000000', N'S', NULL, N'500', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainOD', N'C', N'layout', 1, N'1', N'1', N'00000000', N'S', NULL, N'border', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainOD', N'C', N'width', 1, N'1', N'1', N'00000000', N'S', NULL, N'800', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainOD', N'E', N'render', 1, N'1', N'1', N'00000000', N'S', N'', N'fnMain("OD");', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainOM', N'C', N'layout', 1, N'1', N'1', N'00000000', N'S', NULL, N'border', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainOM', N'E', N'render', 1, N'1', N'1', N'00000000', N'S', N'', N'fnMain("OM");', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainP0', N'C', N'layout', 1, N'1', N'1', N'00000000', N'S', NULL, N'border', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainP0', N'E', N'render', 1, N'1', N'1', N'00000000', N'S', N'', N'fnMain("P0");', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainPY', N'C', N'height', 1, N'1', N'1', N'00000000', N'S', NULL, N'500', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainPY', N'C', N'layout', 1, N'1', N'1', N'00000000', N'S', NULL, N'border', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainPY', N'C', N'width', 1, N'1', N'1', N'00000000', N'S', NULL, N'800', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainPY', N'E', N'render', 1, N'1', N'1', N'00000000', N'S', N'', N'fnMain(''PY'');', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainTM', N'C', N'height', 1, N'1', N'1', N'00000000', N'S', NULL, N'500', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainTM', N'C', N'layout', 1, N'1', N'1', N'00000000', N'S', NULL, N'border', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainTM', N'C', N'width', 1, N'1', N'1', N'00000000', N'S', NULL, N'800', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainTM', N'E', N'render', 1, N'1', N'1', N'00000000', N'S', N'', N'fnMain(''TM'');', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainTR', N'C', N'height', 1, N'1', N'1', N'00000000', N'S', NULL, N'500', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainTR', N'C', N'layout', 1, N'1', N'1', N'00000000', N'S', NULL, N'border', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainTR', N'C', N'width', 1, N'1', N'1', N'00000000', N'S', NULL, N'800', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainTR', N'E', N'render', 1, N'1', N'1', N'00000000', N'S', N'', N'fnMain(''TR'');', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainYT', N'C', N'height', 1, N'1', N'1', N'00000000', N'S', NULL, N'500', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainYT', N'C', N'layout', 1, N'1', N'1', N'00000000', N'S', NULL, N'border', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainYT', N'C', N'width', 1, N'1', N'1', N'00000000', N'S', NULL, N'800', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'MainYT', N'E', N'render', 1, N'1', N'1', N'00000000', N'S', N'', N'fnMain(''YT'');', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'btnUpload', N'C', N'text', 1, N'1', N'1', N'00000000', N'S', NULL, N'Upload Data', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'btnUpload', N'E', N'click', 1, N'1', N'1', N'00000000', N'S', N'', N'fnUploadData();', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'dataMDType', N'C', N'fields', 1, N'1', N'1', N'00000000', N'S', NULL, N'["code","desc"]', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'dataMDType', N'C', N'url', 1, N'1', N'1', N'00000000', N'S', NULL, N'"/HR_Core/GetMD"', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'dataResult', N'C', N'fields', 1, N'1', N'1', N'00000000', N'S', NULL, N'["emp_id","status"]', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'fldExecute', N'C', N'boxLabel', 1, N'1', N'1', N'00000000', N'S', NULL, N'Execute', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'fldExecute', N'C', N'inputValue', 1, N'1', N'1', N'00000000', N'S', NULL, N'"00"', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'fldExecute', N'C', N'name', 1, N'1', N'1', N'00000000', N'S', NULL, N'uploadExecute', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'fldFile', N'C', N'emptyText', 1, N'1', N'1', N'00000000', N'S', NULL, N'"Select Excel File to upload"', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'fldFile', N'C', N'fieldLabel', 1, N'1', N'1', N'00000000', N'S', NULL, N'File', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'fldFile', N'C', N'name', 1, N'1', N'1', N'00000000', N'S', NULL, N'filedata', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'fldFile', N'C', N'width', 1, N'1', N'1', N'00000000', N'S', NULL, N'250', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'fldForceAction', N'C', N'boxLabel', 1, N'1', N'1', N'00000000', N'S', NULL, N'Force Save Data', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'fldForceAction', N'C', N'checked', 1, N'1', N'1', N'00000000', N'S', NULL, N'false', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'fldForceAction', N'C', N'inputType', 1, N'1', N'1', N'00000000', N'S', NULL, N'checkbox', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'fldForceAction', N'C', N'inputValue', 1, N'1', N'1', N'00000000', N'S', NULL, N'"1"', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'fldForceAction', N'C', N'name', 1, N'1', N'1', N'00000000', N'S', NULL, N'force', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'fldMDType', N'C', N'displayField', 1, N'1', N'1', N'00000000', N'S', NULL, N'desc', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'fldMDType', N'C', N'editable', 1, N'1', N'1', N'00000000', N'S', NULL, N'false', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'fldMDType', N'C', N'fieldLabel', 1, N'1', N'1', N'00000000', N'S', NULL, N'Master Data', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'fldMDType', N'C', N'hiddenName', 1, N'1', N'1', N'00000000', N'S', NULL, N'mdtype', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'fldMDType', N'C', N'triggerAction', 1, N'1', N'1', N'00000000', N'S', NULL, N'all', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'fldMDType', N'C', N'valueField', 1, N'1', N'1', N'00000000', N'S', NULL, N'code', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'fldMDType', N'E', N'expand', 1, N'1', N'1', N'00000000', N'S', N'', N'fnReloadMDTyp();', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'fldRadioGroup', N'C', N'width', 1, N'1', N'1', N'00000000', N'S', NULL, N'250', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'fldSimulate', N'C', N'boxLabel', 1, N'1', N'1', N'00000000', N'S', NULL, N'Simulate', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'fldSimulate', N'C', N'checked', 1, N'1', N'1', N'00000000', N'S', NULL, N'true', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'fldSimulate', N'C', N'inputValue', 1, N'1', N'1', N'00000000', N'S', NULL, N'"01"', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'fldSimulate', N'C', N'name', 1, N'1', N'1', N'00000000', N'S', NULL, N'uploadExecute', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'pnlLog', N'C', N'autoScroll', 1, N'1', N'1', N'00000000', N'S', NULL, N'true', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'pnlLog', N'C', N'columns', 1, N'1', N'1', N'00000000', N'S', NULL, N'[{dataIndex: "emp_id", header: "Record ID"},{dataIndex: "status", header: "Status Log", width: "250"}]', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'pnlLog', N'C', N'region', 1, N'1', N'1', N'00000000', N'S', NULL, N'center', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'pnlLog', N'C', N'title', 1, N'1', N'1', N'00000000', N'S', NULL, N'"Log Result"', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'pnlParam', N'C', N'bodyStyle', 1, N'1', N'1', N'00000000', N'S', NULL, N'"padding: 10px 10px 0 10px;"', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'pnlParam', N'C', N'collapsible', 1, N'1', N'1', N'00000000', N'S', NULL, N'true', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'pnlParam', N'C', N'fileUpload', 1, N'1', N'1', N'00000000', N'S', NULL, N'true', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'pnlParam', N'C', N'frame', 1, N'1', N'1', N'00000000', N'S', NULL, N'true', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'pnlParam', N'C', N'height', 1, N'1', N'1', N'00000000', N'S', NULL, N'185', NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_object_conf] ([landscape], [module], [object], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [einput], [config], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'pnlParam', N'C', N'region', 1, N'1', N'1', N'00000000', N'S', NULL, N'north', NULL, NULL, NULL, NULL) PRINT(N'Operation applied to 75 rows out of 86') PRINT(N'Add rows to [dbo].[devt_program]') INSERT INTO [dbo].[devt_program] ([landscape], [name], [active], [promoted], [promote_id], [systype], [module], [ui], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'upload_md_om', N'1', N'1', N'00000000', N'S', N'hrPAUpload_OM', N'MainOD', NULL, NULL, NULL, NULL) PRINT(N'Operation applied to 1 rows out of 7') PRINT(N'Add rows to [dbo].[devt_relation]') INSERT INTO [dbo].[devt_relation] ([landscape], [module1], [module2], [object1], [object2], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [seq], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'hrPAUpload_OM', N'fldMDType', N'dataMDType', N'C', N'store', 1, N'1', N'1', N'00000000', N'S', 1, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_relation] ([landscape], [module1], [module2], [object1], [object2], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [seq], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'hrPAUpload_OM', N'fldRadioGroup', N'fldExecute', N'C', N'items', 1, N'1', N'1', N'00000000', N'S', 2, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_relation] ([landscape], [module1], [module2], [object1], [object2], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [seq], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'hrPAUpload_OM', N'fldRadioGroup', N'fldSimulate', N'C', N'items', 1, N'1', N'1', N'00000000', N'S', 1, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_relation] ([landscape], [module1], [module2], [object1], [object2], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [seq], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'hrPAUpload_OM', N'pnlLog', N'dataResult', N'C', N'store', 1, N'1', N'1', N'00000000', N'S', 1, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_relation] ([landscape], [module1], [module2], [object1], [object2], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [seq], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'hrPAUpload_OM', N'pnlParam', N'btnUpload', N'C', N'items', 1, N'1', N'1', N'00000000', N'S', 5, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_relation] ([landscape], [module1], [module2], [object1], [object2], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [seq], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'hrPAUpload_OM', N'pnlParam', N'fldAppCat', N'C', N'items', 1, N'1', N'1', N'00000000', N'S', 6, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_relation] ([landscape], [module1], [module2], [object1], [object2], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [seq], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'hrPAUpload_OM', N'pnlParam', N'fldFile', N'C', N'items', 1, N'1', N'1', N'00000000', N'S', 2, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_relation] ([landscape], [module1], [module2], [object1], [object2], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [seq], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'hrPAUpload_OM', N'pnlParam', N'fldForceAction', N'C', N'items', 1, N'1', N'1', N'00000000', N'S', 4, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_relation] ([landscape], [module1], [module2], [object1], [object2], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [seq], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'hrPAUpload_OM', N'pnlParam', N'fldMDType', N'C', N'items', 1, N'1', N'1', N'00000000', N'S', 1, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[devt_relation] ([landscape], [module1], [module2], [object1], [object2], [mtype], [mname], [ver], [active], [promoted], [promote_id], [systype], [seq], [create_user], [create_dt], [change_user], [change_dt]) VALUES (N'100', N'hrPAUpload_OM', N'hrPAUpload_OM', N'pnlParam', N'fldRadioGroup', N'C', N'items', 1, N'1', N'1', N'00000000', N'S', 3, NULL, NULL, NULL, NULL) PRINT(N'Operation applied to 10 rows out of 10') COMMIT TRANSACTION GO