Project

General

Profile

Download (89.6 KB)

Feature #3520 » Sync Dev Workbench.sql

Tri Rizqiaty, 04/22/2025 09:41 AM

 
1 
??/*
2
3 
Run this script on:
4
5
6
7 
192.168.3.105\MSSQLSERVER2014.MinovaHR_BANK_MEGA_Production    -  This database will be modified
8
9
10
11 
to synchronize it with:
12
13
14
15 
remote.minovais.com,1458.MinovaHR_BANK_MEGA_Development
16
17
18
19 
You are recommended to back up your database before running this script
20
21
22
23 
Script created by SQL Data Compare version 14.2.9.15508 from Red Gate Software Ltd at 22/04/2025 09.38.41
24
25
26
27 
*/
28
29
30
31 
SET NUMERIC_ROUNDABORT OFF
32
33 
GO
34
35 
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS, NOCOUNT ON
36
37 
GO
38
39 
SET DATEFORMAT YMD
40
41 
GO
42
43 
SET XACT_ABORT ON
44
45 
GO
46
47 
SET TRANSACTION ISOLATION LEVEL Serializable
48
49 
GO
50
51 
BEGIN TRANSACTION
52
53
54
55 
PRINT(N'Add rows to [dbo].[base_cust_menu]')
56
57 
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)
58
59 
PRINT(N'Operation applied to 1 rows out of 7')
60
61
62
63 
PRINT(N'Add rows to [dbo].[base_cust_profile_menu]')
64
65 
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)
66
67 
PRINT(N'Operation applied to 1 rows out of 196')
68
69
70
71 
PRINT(N'Add row to [dbo].[devt_module]')
72
73 
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)
74
75
76
77 
PRINT(N'Add rows to [dbo].[devt_object]')
78
79 
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)
80
81 
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)
82
83 
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)
84
85 
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)
86
87 
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)
88
89 
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)
90
91 
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)
92
93 
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)
94
95 
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)
96
97 
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)
98
99 
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)
100
101 
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)
102
103 
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)
104
105 
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)
106
107 
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)
108
109 
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)
110
111 
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)
112
113 
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)
114
115 
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)
116
117 
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)
118
119 
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)
120
121 
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);
122
123 
dataMDType.load({
124 
  params: {app_cat: fldAppCat.getValue()}
125 
});
126
127 
if (app_cat==''MD'')
128 
{
129 
Main.add(pnlParam);
130 
Main.add(pnlLog);
131 
}
132 
else if (app_cat==''PY'')
133 
{
134 
MainPY.add(pnlParam);
135 
MainPY.add(pnlLog);
136 
}
137 
else if (app_cat==''TM'')
138 
{
139 
MainTM.add(pnlParam);
140 
MainTM.add(pnlLog);
141 
}
142 
else if (app_cat==''OM'')
143 
{
144 
MainOM.add(pnlParam);
145 
MainOM.add(pnlLog);
146 
}
147 
else if (app_cat==''BN'')
148 
{
149 
MainBN.add(pnlParam);
150 
MainBN.add(pnlLog);
151 
}
152 
else if (app_cat==''TR'')
153 
{
154 
MainTM.add(pnlParam);
155 
MainTM.add(pnlLog);
156 
}
157 
else if (app_cat==''YT'')
158 
{
159 
MainYT.add(pnlParam);
160 
MainYT.add(pnlLog);
161 
}
162 
else if (app_cat==''ET'')
163 
{
164 
MainET.add(pnlParam);
165 
MainET.add(pnlLog);
166 
}
167 
else
168 
{
169 
var pnlMain = eval("Main"+app_cat);
170 
if (pnlMain != null)
171 
{
172 
      pnlMain.add(pnlParam);
173 
      pnlMain.add(pnlLog);
174 
}
175 
}
176 
', NULL, NULL, NULL, NULL, NULL, 0)
177
178 
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({
179
180 
  params: {app_cat: fldAppCat.getValue()}
181
182 
});', NULL, NULL, NULL, NULL, NULL, NULL)
183
184 
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;
185 
var _num1 = (fldFile.getValue().length) - 5;
186 
alert(_num1);
187 
alert(Ext.util.Format.substr(fldFile.getValue(),_num1,5));
188 
if (Ext.util.Format.substr(fldFile.getValue(),_num,4) == ".xls" ||
189 
Ext.util.Format.substr(fldFile.getValue(),_num1,5) == ".xlsx" )
190 
{
191 
	if(pnlParam.getForm().isValid()){
192 
		pnlParam.getForm().submit({
193 
			url: "/HR_Core/UploadMDData",
194 
			waitMsg: "Uploading data...",
195 
			method: "POST",
196 
			success: function(pnlParam, o)
197 
			{
198 
				dataResult.loadData(o.result.logs);
199
200 
				Ext.Msg.show({
201 
					title: ''Result'',
202 
					msg: ''Process OK'',
203 
					buttons: Ext.Msg.OK,
204 
					icon: Ext.Msg.INFO
205 
				});
206 
			},
207 
			failure: function(pnlParam, o)
208 
			{
209 
				Ext.Msg.show({
210 
					title: ''Result'',
211 
					msg: o.result.error,
212 
					buttons: Ext.Msg.OK,
213 
					icon: Ext.Msg.ERROR
214 
				});
215 
			}
216 
		})
217 
	}
218 
}', NULL, NULL, NULL, NULL, NULL, 0)
219
220 
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)
221
222 
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)
223
224 
PRINT(N'Operation applied to 26 rows out of 44')
225
226
227
228 
PRINT(N'Add rows to [dbo].[devt_object_conf]')
229
230 
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)
231
232 
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)
233
234 
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)
235
236 
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)
237
238 
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)
239
240 
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)
241
242 
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)
243
244 
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)
245
246 
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)
247
248 
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)
249
250 
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)
251
252 
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)
253
254 
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)
255
256 
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)
257
258 
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)
259
260 
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)
261
262 
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)
263
264 
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)
265
266 
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)
267
268 
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)
269
270 
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)
271
272 
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)
273
274 
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)
275
276 
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)
277
278 
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)
279
280 
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)
281
282 
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)
283
284 
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)
285
286 
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)
287
288 
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)
289
290 
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)
291
292 
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)
293
294 
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)
295
296 
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)
297
298 
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)
299
300 
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)
301
302 
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)
303
304 
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)
305
306 
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)
307
308 
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)
309
310 
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)
311
312 
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)
313
314 
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)
315
316 
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)
317
318 
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)
319
320 
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)
321
322 
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)
323
324 
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)
325
326 
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)
327
328 
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)
329
330 
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)
331
332 
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)
333
334 
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)
335
336 
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)
337
338 
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)
339
340 
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)
341
342 
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)
343
344 
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)
345
346 
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)
347
348 
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)
349
350 
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)
351
352 
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)
353
354 
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)
355
356 
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)
357
358 
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)
359
360 
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)
361
362 
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)
363
364 
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)
365
366 
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)
367
368 
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)
369
370 
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)
371
372 
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)
373
374 
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)
375
376 
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)
377
378 
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)
379
380 
PRINT(N'Operation applied to 75 rows out of 86')
381
382
383
384 
PRINT(N'Add rows to [dbo].[devt_program]')
385
386 
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)
387
388 
PRINT(N'Operation applied to 1 rows out of 7')
389
390
391
392 
PRINT(N'Add rows to [dbo].[devt_relation]')
393
394 
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)
395
396 
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)
397
398 
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)
399
400 
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)
401
402 
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)
403
404 
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)
405
406 
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)
407
408 
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)
409
410 
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)
411
412 
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)
413
414 
PRINT(N'Operation applied to 10 rows out of 10')
415
416 
COMMIT TRANSACTION
417
418 
GO
419
420
(4-4/12)