· 9 years ago · Oct 01, 2016, 09:32 AM
1USE [erm_nsu_dev]
2GO
3IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_WaiverSetup_CreatedTime]') AND type = 'D')
4BEGIN
5ALTER TABLE [dbo].[NSU_Main_Fees_WaiverSetup] DROP CONSTRAINT [DF_NSU_Main_Fees_WaiverSetup_CreatedTime]
6END
7
8GO
9IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_WaiverSetup_Status_1]') AND type = 'D')
10BEGIN
11ALTER TABLE [dbo].[NSU_Main_Fees_WaiverSetup] DROP CONSTRAINT [DF_NSU_Main_Fees_WaiverSetup_Status_1]
12END
13
14GO
15IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_WaiverSetup_Status]') AND type = 'D')
16BEGIN
17ALTER TABLE [dbo].[NSU_Main_Fees_WaiverSetup] DROP CONSTRAINT [DF_NSU_Main_Fees_WaiverSetup_Status]
18END
19
20GO
21IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_WaiverSetup_DepandsOnResult]') AND type = 'D')
22BEGIN
23ALTER TABLE [dbo].[NSU_Main_Fees_WaiverSetup] DROP CONSTRAINT [DF_NSU_Main_Fees_WaiverSetup_DepandsOnResult]
24END
25
26GO
27IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_UniversityBankBranch_Status]') AND type = 'D')
28BEGIN
29ALTER TABLE [dbo].[NSU_Main_Fees_UniversityBankBranch] DROP CONSTRAINT [DF_NSU_Main_Fees_UniversityBankBranch_Status]
30END
31
32GO
33IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_UniversityBankBranch_CreatedTime]') AND type = 'D')
34BEGIN
35ALTER TABLE [dbo].[NSU_Main_Fees_UniversityBankBranch] DROP CONSTRAINT [DF_NSU_Main_Fees_UniversityBankBranch_CreatedTime]
36END
37
38GO
39IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_UniversityBank_Status]') AND type = 'D')
40BEGIN
41ALTER TABLE [dbo].[NSU_Main_Fees_UniversityBank] DROP CONSTRAINT [DF_NSU_Main_Fees_UniversityBank_Status]
42END
43
44GO
45IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_UniversityBank_CreatedTime]') AND type = 'D')
46BEGIN
47ALTER TABLE [dbo].[NSU_Main_Fees_UniversityBank] DROP CONSTRAINT [DF_NSU_Main_Fees_UniversityBank_CreatedTime]
48END
49
50GO
51IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_StudentFeesReceipt_CreatedTime]') AND type = 'D')
52BEGIN
53ALTER TABLE [dbo].[NSU_Main_Fees_StudentFeesReceipt] DROP CONSTRAINT [DF_NSU_Main_Fees_StudentFeesReceipt_CreatedTime]
54END
55
56GO
57IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_StudentFeesReceipt_Status]') AND type = 'D')
58BEGIN
59ALTER TABLE [dbo].[NSU_Main_Fees_StudentFeesReceipt] DROP CONSTRAINT [DF_NSU_Main_Fees_StudentFeesReceipt_Status]
60END
61
62GO
63IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_StudentFeesReceipt_Paid]') AND type = 'D')
64BEGIN
65ALTER TABLE [dbo].[NSU_Main_Fees_StudentFeesReceipt] DROP CONSTRAINT [DF_NSU_Main_Fees_StudentFeesReceipt_Paid]
66END
67
68GO
69IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_StudentFeesCollection_CreatedTime]') AND type = 'D')
70BEGIN
71ALTER TABLE [dbo].[NSU_Main_Fees_StudentFeesCollection] DROP CONSTRAINT [DF_NSU_Main_Fees_StudentFeesCollection_CreatedTime]
72END
73
74GO
75IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_StudentFeesCollection_Status]') AND type = 'D')
76BEGIN
77ALTER TABLE [dbo].[NSU_Main_Fees_StudentFeesCollection] DROP CONSTRAINT [DF_NSU_Main_Fees_StudentFeesCollection_Status]
78END
79
80GO
81IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FineSetup_CreatedTime]') AND type = 'D')
82BEGIN
83ALTER TABLE [dbo].[NSU_Main_Fees_FineSetup] DROP CONSTRAINT [DF_NSU_Main_Fees_FineSetup_CreatedTime]
84END
85
86GO
87IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FineSetup_Status]') AND type = 'D')
88BEGIN
89ALTER TABLE [dbo].[NSU_Main_Fees_FineSetup] DROP CONSTRAINT [DF_NSU_Main_Fees_FineSetup_Status]
90END
91
92GO
93IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FineSetup_TakeFinancialAid]') AND type = 'D')
94BEGIN
95ALTER TABLE [dbo].[NSU_Main_Fees_FineSetup] DROP CONSTRAINT [DF_NSU_Main_Fees_FineSetup_TakeFinancialAid]
96END
97
98GO
99IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FinancialAidPolicy_CreatedTime]') AND type = 'D')
100BEGIN
101ALTER TABLE [dbo].[NSU_Main_Fees_FinancialAidPolicy] DROP CONSTRAINT [DF_NSU_Main_Fees_FinancialAidPolicy_CreatedTime]
102END
103
104GO
105IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FinancialAidPolicy_Status]') AND type = 'D')
106BEGIN
107ALTER TABLE [dbo].[NSU_Main_Fees_FinancialAidPolicy] DROP CONSTRAINT [DF_NSU_Main_Fees_FinancialAidPolicy_Status]
108END
109
110GO
111IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_CreatedTime]') AND type = 'D')
112BEGIN
113ALTER TABLE [dbo].[NSU_Main_Fees_FeeStructure] DROP CONSTRAINT [DF_NSU_Main_Fees_CreatedTime]
114END
115
116GO
117IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_Status]') AND type = 'D')
118BEGIN
119ALTER TABLE [dbo].[NSU_Main_Fees_FeeStructure] DROP CONSTRAINT [DF_NSU_Main_Fees_Status]
120END
121
122GO
123IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeeStructure_DepandsOnCredits]') AND type = 'D')
124BEGIN
125ALTER TABLE [dbo].[NSU_Main_Fees_FeeStructure] DROP CONSTRAINT [DF_NSU_Main_Fees_FeeStructure_DepandsOnCredits]
126END
127
128GO
129IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeeStructure_ForYear]') AND type = 'D')
130BEGIN
131ALTER TABLE [dbo].[NSU_Main_Fees_FeeStructure] DROP CONSTRAINT [DF_NSU_Main_Fees_FeeStructure_ForYear]
132END
133
134GO
135IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeeStructure_ForAdmission]') AND type = 'D')
136BEGIN
137ALTER TABLE [dbo].[NSU_Main_Fees_FeeStructure] DROP CONSTRAINT [DF_NSU_Main_Fees_FeeStructure_ForAdmission]
138END
139
140GO
141IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeeStructure_SessionId]') AND type = 'D')
142BEGIN
143ALTER TABLE [dbo].[NSU_Main_Fees_FeeStructure] DROP CONSTRAINT [DF_NSU_Main_Fees_FeeStructure_SessionId]
144END
145
146GO
147IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_AreaId]') AND type = 'D')
148BEGIN
149ALTER TABLE [dbo].[NSU_Main_Fees_FeeStructure] DROP CONSTRAINT [DF_NSU_Main_Fees_AreaId]
150END
151
152GO
153IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_FeeStructure_ProgramId]') AND type = 'D')
154BEGIN
155ALTER TABLE [dbo].[NSU_Main_Fees_FeeStructure] DROP CONSTRAINT [DF_NSU_Main_FeeStructure_ProgramId]
156END
157
158GO
159IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_FeeStructure_DepartmentId]') AND type = 'D')
160BEGIN
161ALTER TABLE [dbo].[NSU_Main_Fees_FeeStructure] DROP CONSTRAINT [DF_NSU_Main_FeeStructure_DepartmentId]
162END
163
164GO
165IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeeStructure_SchoolId]') AND type = 'D')
166BEGIN
167ALTER TABLE [dbo].[NSU_Main_Fees_FeeStructure] DROP CONSTRAINT [DF_NSU_Main_Fees_FeeStructure_SchoolId]
168END
169
170GO
171IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeesPaymentPolicy_CreatedTime]') AND type = 'D')
172BEGIN
173ALTER TABLE [dbo].[NSU_Main_Fees_FeesPaymentPolicy] DROP CONSTRAINT [DF_NSU_Main_Fees_FeesPaymentPolicy_CreatedTime]
174END
175
176GO
177IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeesPaymentPolicy_Status]') AND type = 'D')
178BEGIN
179ALTER TABLE [dbo].[NSU_Main_Fees_FeesPaymentPolicy] DROP CONSTRAINT [DF_NSU_Main_Fees_FeesPaymentPolicy_Status]
180END
181
182GO
183IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeesHeadBank_Enable]') AND type = 'D')
184BEGIN
185ALTER TABLE [dbo].[NSU_Main_Fees_FeesHeadBank] DROP CONSTRAINT [DF_NSU_Main_Fees_FeesHeadBank_Enable]
186END
187
188GO
189IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeesHeadBank_Status]') AND type = 'D')
190BEGIN
191ALTER TABLE [dbo].[NSU_Main_Fees_FeesHeadBank] DROP CONSTRAINT [DF_NSU_Main_Fees_FeesHeadBank_Status]
192END
193
194GO
195IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_StudentFeesCollection_CreatedTime_copy]') AND type = 'D')
196BEGIN
197ALTER TABLE [dbo].[NSU_Main_Fees_Admission_FeesCollection] DROP CONSTRAINT [DF_NSU_Main_Fees_StudentFeesCollection_CreatedTime_copy]
198END
199
200GO
201IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_StudentFeesCollection_Status_copy]') AND type = 'D')
202BEGIN
203ALTER TABLE [dbo].[NSU_Main_Fees_Admission_FeesCollection] DROP CONSTRAINT [DF_NSU_Main_Fees_StudentFeesCollection_Status_copy]
204END
205
206GO
207/****** Object: Table [dbo].[NSU_Main_Fees_WaiverSetup] Script Date: 10/1/2016 3:23:28 PM ******/
208IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_WaiverSetup]') AND type in (N'U'))
209DROP TABLE [dbo].[NSU_Main_Fees_WaiverSetup]
210GO
211/****** Object: Table [dbo].[NSU_Main_Fees_UniversityBankBranch] Script Date: 10/1/2016 3:23:28 PM ******/
212IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_UniversityBankBranch]') AND type in (N'U'))
213DROP TABLE [dbo].[NSU_Main_Fees_UniversityBankBranch]
214GO
215/****** Object: Table [dbo].[NSU_Main_Fees_UniversityBank] Script Date: 10/1/2016 3:23:28 PM ******/
216IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_UniversityBank]') AND type in (N'U'))
217DROP TABLE [dbo].[NSU_Main_Fees_UniversityBank]
218GO
219/****** Object: Table [dbo].[NSU_Main_Fees_StudentFinancialAid] Script Date: 10/1/2016 3:23:28 PM ******/
220IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_StudentFinancialAid]') AND type in (N'U'))
221DROP TABLE [dbo].[NSU_Main_Fees_StudentFinancialAid]
222GO
223/****** Object: Table [dbo].[NSU_Main_Fees_StudentFinanceAid] Script Date: 10/1/2016 3:23:28 PM ******/
224IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_StudentFinanceAid]') AND type in (N'U'))
225DROP TABLE [dbo].[NSU_Main_Fees_StudentFinanceAid]
226GO
227/****** Object: Table [dbo].[NSU_Main_Fees_StudentFeesReceipt] Script Date: 10/1/2016 3:23:28 PM ******/
228IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_StudentFeesReceipt]') AND type in (N'U'))
229DROP TABLE [dbo].[NSU_Main_Fees_StudentFeesReceipt]
230GO
231/****** Object: Table [dbo].[NSU_Main_Fees_StudentFeesCollection] Script Date: 10/1/2016 3:23:28 PM ******/
232IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_StudentFeesCollection]') AND type in (N'U'))
233DROP TABLE [dbo].[NSU_Main_Fees_StudentFeesCollection]
234GO
235/****** Object: Table [dbo].[NSU_Main_Fees_FineSetup] Script Date: 10/1/2016 3:23:28 PM ******/
236IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_FineSetup]') AND type in (N'U'))
237DROP TABLE [dbo].[NSU_Main_Fees_FineSetup]
238GO
239/****** Object: Table [dbo].[NSU_Main_Fees_FinancialAidPolicy] Script Date: 10/1/2016 3:23:28 PM ******/
240IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_FinancialAidPolicy]') AND type in (N'U'))
241DROP TABLE [dbo].[NSU_Main_Fees_FinancialAidPolicy]
242GO
243/****** Object: Table [dbo].[NSU_Main_Fees_FeeStructure] Script Date: 10/1/2016 3:23:28 PM ******/
244IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_FeeStructure]') AND type in (N'U'))
245DROP TABLE [dbo].[NSU_Main_Fees_FeeStructure]
246GO
247/****** Object: Table [dbo].[NSU_Main_Fees_FeesPaymentPolicy] Script Date: 10/1/2016 3:23:28 PM ******/
248IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_FeesPaymentPolicy]') AND type in (N'U'))
249DROP TABLE [dbo].[NSU_Main_Fees_FeesPaymentPolicy]
250GO
251/****** Object: Table [dbo].[NSU_Main_Fees_FeesHeadBank] Script Date: 10/1/2016 3:23:28 PM ******/
252IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_FeesHeadBank]') AND type in (N'U'))
253DROP TABLE [dbo].[NSU_Main_Fees_FeesHeadBank]
254GO
255/****** Object: Table [dbo].[NSU_Main_Fees_Admission_FeesCollection] Script Date: 10/1/2016 3:23:28 PM ******/
256IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_Admission_FeesCollection]') AND type in (N'U'))
257DROP TABLE [dbo].[NSU_Main_Fees_Admission_FeesCollection]
258GO
259/****** Object: Table [dbo].[NSU_Main_Fees_Admission_FeesCollection] Script Date: 10/1/2016 3:23:28 PM ******/
260SET ANSI_NULLS ON
261GO
262SET QUOTED_IDENTIFIER ON
263GO
264IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_Admission_FeesCollection]') AND type in (N'U'))
265BEGIN
266CREATE TABLE [dbo].[NSU_Main_Fees_Admission_FeesCollection](
267 [FeesCollectionId] [bigint] IDENTITY(1,1) NOT NULL,
268 [PaymentId] [bigint] NULL,
269 [SessionId] [int] NULL,
270 [Year] [nvarchar](50) NULL,
271 [FeesMonth] [nvarchar](50) NULL,
272 [VatAmount] [decimal](18, 2) NULL,
273 [TotalAmount] [decimal](18, 2) NULL,
274 [ScholarshipId] [bigint] NULL,
275 [ScholarshipAmount] [decimal](18, 2) NULL,
276 [FineAmount] [decimal](18, 2) NULL,
277 [TotalNetAmount] [decimal](18, 2) NULL,
278 [Received] [bit] NULL,
279 [TotalReceived] [decimal](18, 2) NULL,
280 [TotalDues] [decimal](18, 2) NULL,
281 [TransactionDate] [datetime] NULL,
282 [Status] [bit] NULL,
283 [CreatedBy] [bigint] NULL,
284 [CreatedTime] [datetime] NULL,
285 [ModifiedBy] [bigint] NULL,
286 [ModifiedTime] [datetime] NULL,
287 CONSTRAINT [PK_NSU_Main_Fees_StudentFeesCollection_copy] PRIMARY KEY CLUSTERED
288(
289 [FeesCollectionId] ASC
290)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
291) ON [PRIMARY]
292END
293GO
294/****** Object: Table [dbo].[NSU_Main_Fees_FeesHeadBank] Script Date: 10/1/2016 3:23:28 PM ******/
295SET ANSI_NULLS ON
296GO
297SET QUOTED_IDENTIFIER ON
298GO
299IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_FeesHeadBank]') AND type in (N'U'))
300BEGIN
301CREATE TABLE [dbo].[NSU_Main_Fees_FeesHeadBank](
302 [FeesHeadBankId] [int] IDENTITY(1,1) NOT NULL,
303 [FeesHeadName] [nvarchar](150) NULL,
304 [Status] [bit] NULL,
305 [Enable] [bit] NULL,
306 CONSTRAINT [PK_NSU_Main_Fees_FeesHeadBank] PRIMARY KEY CLUSTERED
307(
308 [FeesHeadBankId] ASC
309)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
310) ON [PRIMARY]
311END
312GO
313/****** Object: Table [dbo].[NSU_Main_Fees_FeesPaymentPolicy] Script Date: 10/1/2016 3:23:28 PM ******/
314SET ANSI_NULLS ON
315GO
316SET QUOTED_IDENTIFIER ON
317GO
318IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_FeesPaymentPolicy]') AND type in (N'U'))
319BEGIN
320CREATE TABLE [dbo].[NSU_Main_Fees_FeesPaymentPolicy](
321 [FeesPaymentPolicyId] [int] IDENTITY(1,1) NOT NULL,
322 [Heading] [nvarchar](250) NULL,
323 [Description] [ntext] NULL,
324 [Status] [bit] NULL,
325 [CreatedBy] [bigint] NULL,
326 [CreatedTime] [datetime] NULL,
327 [ModifiedBy] [bigint] NULL,
328 [ModifiedTime] [datetime] NULL,
329 CONSTRAINT [PK_NSU_Main_Fees_FeesPaymentPolicy] PRIMARY KEY CLUSTERED
330(
331 [FeesPaymentPolicyId] ASC
332)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
333) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
334END
335GO
336/****** Object: Table [dbo].[NSU_Main_Fees_FeeStructure] Script Date: 10/1/2016 3:23:28 PM ******/
337SET ANSI_NULLS ON
338GO
339SET QUOTED_IDENTIFIER ON
340GO
341IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_FeeStructure]') AND type in (N'U'))
342BEGIN
343CREATE TABLE [dbo].[NSU_Main_Fees_FeeStructure](
344 [FeesTypeId] [int] IDENTITY(1,1) NOT NULL,
345 [ModuleType] [nvarchar](50) NULL,
346 [FeesHeadBankId] [int] NULL,
347 [FeesTypeName] [nvarchar](150) NULL,
348 [DisplayName] [nvarchar](150) NULL,
349 [ProgamTypeId] [int] NULL,
350 [Parent] [int] NULL,
351 [SchoolId] [int] NULL,
352 [DepartmentId] [int] NULL,
353 [ProgramId] [int] NULL,
354 [AreaId] [int] NULL,
355 [SessionId] [int] NULL,
356 [Year] [nvarchar](50) NULL,
357 [Amount] [decimal](18, 2) NULL,
358 [ForAdmission] [bit] NULL,
359 [ForPerYear] [bit] NULL,
360 [DepandsOnCredits] [bit] NULL,
361 [CreditsCompleted] [decimal](18, 2) NULL,
362 [Status] [bit] NULL,
363 [CreatedBy] [bigint] NULL,
364 [CreatedTime] [datetime] NULL,
365 [ModifiedBy] [bigint] NULL,
366 [ModifiedTime] [datetime] NULL,
367 CONSTRAINT [PK_NSU_Main_Fees] PRIMARY KEY CLUSTERED
368(
369 [FeesTypeId] ASC
370)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
371) ON [PRIMARY]
372END
373GO
374/****** Object: Table [dbo].[NSU_Main_Fees_FinancialAidPolicy] Script Date: 10/1/2016 3:23:28 PM ******/
375SET ANSI_NULLS ON
376GO
377SET QUOTED_IDENTIFIER ON
378GO
379IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_FinancialAidPolicy]') AND type in (N'U'))
380BEGIN
381CREATE TABLE [dbo].[NSU_Main_Fees_FinancialAidPolicy](
382 [FinancialAidPolicyId] [int] IDENTITY(1,1) NOT NULL,
383 [Heading] [nvarchar](250) NULL,
384 [Description] [ntext] NULL,
385 [Status] [bit] NULL,
386 [CreatedBy] [bigint] NULL,
387 [CreatedTime] [datetime] NULL,
388 [ModifiedBy] [bigint] NULL,
389 [ModifiedTime] [datetime] NULL,
390 CONSTRAINT [PK_NSU_Main_Fees_FinancialAidPolicy] PRIMARY KEY CLUSTERED
391(
392 [FinancialAidPolicyId] ASC
393)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
394) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
395END
396GO
397/****** Object: Table [dbo].[NSU_Main_Fees_FineSetup] Script Date: 10/1/2016 3:23:28 PM ******/
398SET ANSI_NULLS ON
399GO
400SET QUOTED_IDENTIFIER ON
401GO
402IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_FineSetup]') AND type in (N'U'))
403BEGIN
404CREATE TABLE [dbo].[NSU_Main_Fees_FineSetup](
405 [FineId] [int] IDENTITY(1,1) NOT NULL,
406 [ProgramTypeId] [int] NULL,
407 [SessionId] [int] NULL,
408 [Year] [nvarchar](10) NULL,
409 [TakeFinancialAid] [bit] NULL,
410 [ApplicableFromDate] [datetime] NULL,
411 [ApplicableToDate] [datetime] NULL,
412 [LastDateWithoutFine] [datetime] NULL,
413 [LastDateWithFine] [datetime] NULL,
414 [FineAmount] [decimal](18, 2) NULL,
415 [PerDayFineAmount] [decimal](18, 2) NULL,
416 [LastDateWithPerDayFine] [datetime] NULL,
417 [Status] [bit] NULL,
418 [CreatedBy] [bigint] NULL,
419 [CreatedTime] [datetime] NULL,
420 [ModifiedBy] [bigint] NULL,
421 [ModifiedTime] [datetime] NULL,
422 CONSTRAINT [PK_NSU_Main_Fees_FineSetup] PRIMARY KEY CLUSTERED
423(
424 [FineId] ASC
425)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
426) ON [PRIMARY]
427END
428GO
429/****** Object: Table [dbo].[NSU_Main_Fees_StudentFeesCollection] Script Date: 10/1/2016 3:23:28 PM ******/
430SET ANSI_NULLS ON
431GO
432SET QUOTED_IDENTIFIER ON
433GO
434IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_StudentFeesCollection]') AND type in (N'U'))
435BEGIN
436CREATE TABLE [dbo].[NSU_Main_Fees_StudentFeesCollection](
437 [FeesCollectionId] [bigint] IDENTITY(1,1) NOT NULL,
438 [PaymentId] [bigint] NULL,
439 [SessionId] [int] NULL,
440 [Year] [nvarchar](50) NULL,
441 [FeesMonth] [nvarchar](50) NULL,
442 [VatAmount] [decimal](18, 2) NULL,
443 [TotalAmount] [decimal](18, 2) NULL,
444 [ScholarshipId] [bigint] NULL,
445 [ScholarshipAmount] [decimal](18, 2) NULL,
446 [FineAmount] [decimal](18, 2) NULL,
447 [TotalNetAmount] [decimal](18, 2) NULL,
448 [Received] [bit] NULL,
449 [TotalReceived] [decimal](18, 2) NULL,
450 [TotalDues] [decimal](18, 2) NULL,
451 [TransactionDate] [datetime] NULL,
452 [Status] [bit] NULL,
453 [CreatedBy] [bigint] NULL,
454 [CreatedTime] [datetime] NULL,
455 [ModifiedBy] [bigint] NULL,
456 [ModifiedTime] [datetime] NULL,
457 CONSTRAINT [PK_NSU_Main_Fees_StudentFeesCollection] PRIMARY KEY CLUSTERED
458(
459 [FeesCollectionId] ASC
460)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
461) ON [PRIMARY]
462END
463GO
464/****** Object: Table [dbo].[NSU_Main_Fees_StudentFeesReceipt] Script Date: 10/1/2016 3:23:28 PM ******/
465SET ANSI_NULLS ON
466GO
467SET QUOTED_IDENTIFIER ON
468GO
469IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_StudentFeesReceipt]') AND type in (N'U'))
470BEGIN
471CREATE TABLE [dbo].[NSU_Main_Fees_StudentFeesReceipt](
472 [FeesReceiptId] [bigint] IDENTITY(1,1) NOT NULL,
473 [SessionId] [int] NULL,
474 [Year] [nvarchar](10) NULL,
475 [StudentId] [bigint] NULL,
476 [ModuleType] [nvarchar](50) NULL,
477 [FeesHead] [nvarchar](150) NULL,
478 [FeesAmount] [decimal](18, 2) NULL,
479 [DueDate] [datetime] NULL,
480 [Paid] [bit] NULL,
481 [Status] [bit] NULL,
482 [CreatedBy] [bigint] NULL,
483 [CreatedTime] [datetime] NULL,
484 [ModifiedBy] [bigint] NULL,
485 [ModifiedTime] [datetime] NULL,
486 CONSTRAINT [PK_NSU_Main_Fees_StudentFeesReceipt] PRIMARY KEY CLUSTERED
487(
488 [FeesReceiptId] ASC
489)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
490) ON [PRIMARY]
491END
492GO
493/****** Object: Table [dbo].[NSU_Main_Fees_StudentFinanceAid] Script Date: 10/1/2016 3:23:28 PM ******/
494SET ANSI_NULLS ON
495GO
496SET QUOTED_IDENTIFIER ON
497GO
498IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_StudentFinanceAid]') AND type in (N'U'))
499BEGIN
500CREATE TABLE [dbo].[NSU_Main_Fees_StudentFinanceAid](
501 [StudentFinanceAidId] [bigint] IDENTITY(1,1) NOT NULL,
502 [StudentId] [nvarchar](50) NULL,
503 [ProgramTypeId] [int] NULL,
504 [DepartmentId] [int] NULL,
505 [FeesTypeId] [int] NULL,
506 [WaiverId] [int] NULL,
507 [FromSessionId] [int] NULL,
508 [ToSessionId] [int] NULL,
509 [SessionId] [int] NULL,
510 [Year] [nvarchar](10) NULL,
511 [CreatedBy] [bigint] NULL,
512 [CreatedTime] [datetime] NULL,
513 [ModifiedBy] [bigint] NULL,
514 [ModifiedTime] [datetime] NULL,
515 CONSTRAINT [PK_NSU_Main_Fees_StudentFinanceAid] PRIMARY KEY CLUSTERED
516(
517 [StudentFinanceAidId] ASC
518)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
519) ON [PRIMARY]
520END
521GO
522/****** Object: Table [dbo].[NSU_Main_Fees_StudentFinancialAid] Script Date: 10/1/2016 3:23:28 PM ******/
523SET ANSI_NULLS ON
524GO
525SET QUOTED_IDENTIFIER ON
526GO
527IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_StudentFinancialAid]') AND type in (N'U'))
528BEGIN
529CREATE TABLE [dbo].[NSU_Main_Fees_StudentFinancialAid](
530 [StudentFinanceAidId] [bigint] NOT NULL,
531 [StudentId] [nvarchar](50) NULL,
532 [ProgramTypeId] [int] NULL,
533 [DepartmentId] [int] NULL,
534 [FeesTypeId] [int] NULL,
535 [WaiverId] [int] NULL,
536 [FromSessionId] [int] NULL,
537 [ToSessionId] [int] NULL,
538 [CreatedBy] [bigint] NULL,
539 [CreatedTime] [datetime] NULL,
540 [ModifiedBy] [bigint] NULL,
541 [ModifiedTime] [datetime] NULL
542) ON [PRIMARY]
543END
544GO
545/****** Object: Table [dbo].[NSU_Main_Fees_UniversityBank] Script Date: 10/1/2016 3:23:28 PM ******/
546SET ANSI_NULLS ON
547GO
548SET QUOTED_IDENTIFIER ON
549GO
550IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_UniversityBank]') AND type in (N'U'))
551BEGIN
552CREATE TABLE [dbo].[NSU_Main_Fees_UniversityBank](
553 [BankId] [int] IDENTITY(1,1) NOT NULL,
554 [BankName] [nvarchar](100) NULL,
555 [BankCode] [nvarchar](100) NULL,
556 [Logo] [nvarchar](100) NULL,
557 [HeadBranch] [int] NULL,
558 [CreatedBy] [bigint] NULL,
559 [CreatedTime] [datetime] NULL,
560 [ModifiedBy] [bigint] NULL,
561 [ModifiedTime] [datetime] NULL,
562 [Status] [bit] NULL,
563 CONSTRAINT [PK_NSU_Main_Fees_UniversityBank] PRIMARY KEY CLUSTERED
564(
565 [BankId] ASC
566)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
567) ON [PRIMARY]
568END
569GO
570/****** Object: Table [dbo].[NSU_Main_Fees_UniversityBankBranch] Script Date: 10/1/2016 3:23:28 PM ******/
571SET ANSI_NULLS ON
572GO
573SET QUOTED_IDENTIFIER ON
574GO
575IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_UniversityBankBranch]') AND type in (N'U'))
576BEGIN
577CREATE TABLE [dbo].[NSU_Main_Fees_UniversityBankBranch](
578 [BankBranchId] [int] IDENTITY(1,1) NOT NULL,
579 [BankBranchName] [nvarchar](180) NULL,
580 [Address] [nvarchar](500) NULL,
581 [AccountNumber] [nvarchar](400) NULL,
582 [Email] [nvarchar](150) NULL,
583 [BankId] [int] NULL,
584 [CreatedBy] [int] NULL,
585 [CreatedTime] [datetime] NULL,
586 [ModifiedBy] [int] NULL,
587 [ModifiedTime] [datetime] NULL,
588 [Status] [bit] NULL,
589 CONSTRAINT [PK_NSU_Main_Fees_UniversityBankBranch] PRIMARY KEY CLUSTERED
590(
591 [BankBranchId] ASC
592)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
593) ON [PRIMARY]
594END
595GO
596/****** Object: Table [dbo].[NSU_Main_Fees_WaiverSetup] Script Date: 10/1/2016 3:23:28 PM ******/
597SET ANSI_NULLS ON
598GO
599SET QUOTED_IDENTIFIER ON
600GO
601IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NSU_Main_Fees_WaiverSetup]') AND type in (N'U'))
602BEGIN
603CREATE TABLE [dbo].[NSU_Main_Fees_WaiverSetup](
604 [WaiverId] [int] IDENTITY(1,1) NOT NULL,
605 [ProgramTypeId] [int] NULL,
606 [DepartmentId] [int] NULL,
607 [SessionId] [int] NULL,
608 [Year] [nvarchar](10) NULL,
609 [ModuleType] [nvarchar](50) NULL,
610 [FeesTypeId] [int] NULL,
611 [Percentage] [decimal](18, 2) NULL,
612 [Amount] [decimal](18, 2) NULL,
613 [WaiverName] [nvarchar](100) NULL,
614 [Description] [nvarchar](250) NULL,
615 [IsDepandsOnResult] [bit] NULL,
616 [CGPA] [decimal](18, 2) NULL,
617 [MinCreditLoad] [int] NULL,
618 [TotalCreditCompleted] [int] NULL,
619 [IsDepandsOnSiblings] [bit] NULL,
620 [Status] [bit] NULL,
621 [CreatedBy] [bigint] NULL,
622 [CreatedTime] [datetime] NULL,
623 [ModifiedBy] [bigint] NULL,
624 [ModifiedTime] [datetime] NULL,
625 CONSTRAINT [PK_NSU_Main_Fees_WaiverSetup] PRIMARY KEY CLUSTERED
626(
627 [WaiverId] ASC
628)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
629) ON [PRIMARY]
630END
631GO
632SET IDENTITY_INSERT [dbo].[NSU_Main_Fees_FeesHeadBank] ON
633
634GO
635INSERT [dbo].[NSU_Main_Fees_FeesHeadBank] ([FeesHeadBankId], [FeesHeadName], [Status], [Enable]) VALUES (1, N'Admission Fee', 0, 1)
636GO
637INSERT [dbo].[NSU_Main_Fees_FeesHeadBank] ([FeesHeadBankId], [FeesHeadName], [Status], [Enable]) VALUES (2, N'Tuition Fee', 0, 1)
638GO
639INSERT [dbo].[NSU_Main_Fees_FeesHeadBank] ([FeesHeadBankId], [FeesHeadName], [Status], [Enable]) VALUES (3, N'Student Activities Fee', 0, 1)
640GO
641INSERT [dbo].[NSU_Main_Fees_FeesHeadBank] ([FeesHeadBankId], [FeesHeadName], [Status], [Enable]) VALUES (4, N'Library Fee', 0, 1)
642GO
643INSERT [dbo].[NSU_Main_Fees_FeesHeadBank] ([FeesHeadBankId], [FeesHeadName], [Status], [Enable]) VALUES (5, N'Computer Lab Fee', 0, 1)
644GO
645INSERT [dbo].[NSU_Main_Fees_FeesHeadBank] ([FeesHeadBankId], [FeesHeadName], [Status], [Enable]) VALUES (6, N'Science Lab Fee', 0, 1)
646GO
647INSERT [dbo].[NSU_Main_Fees_FeesHeadBank] ([FeesHeadBankId], [FeesHeadName], [Status], [Enable]) VALUES (7, N'Studio Course fee', 0, 1)
648GO
649SET IDENTITY_INSERT [dbo].[NSU_Main_Fees_FeesHeadBank] OFF
650GO
651SET IDENTITY_INSERT [dbo].[NSU_Main_Fees_FeeStructure] ON
652
653GO
654INSERT [dbo].[NSU_Main_Fees_FeeStructure] ([FeesTypeId], [ModuleType], [FeesHeadBankId], [FeesTypeName], [DisplayName], [ProgamTypeId], [Parent], [SchoolId], [DepartmentId], [ProgramId], [AreaId], [SessionId], [Year], [Amount], [ForAdmission], [ForPerYear], [DepandsOnCredits], [CreditsCompleted], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (1, N'Advising', 2, NULL, NULL, 2, 0, 1, 9, 6, 0, 2, N'2017', CAST(5000.00 AS Decimal(18, 2)), 1, 1, 1, CAST(70.00 AS Decimal(18, 2)), 1, 1, CAST(0x0000A4EA00BA10A6 AS DateTime), 1, CAST(0x0000A4EA00BA79D3 AS DateTime))
655GO
656INSERT [dbo].[NSU_Main_Fees_FeeStructure] ([FeesTypeId], [ModuleType], [FeesHeadBankId], [FeesTypeName], [DisplayName], [ProgamTypeId], [Parent], [SchoolId], [DepartmentId], [ProgramId], [AreaId], [SessionId], [Year], [Amount], [ForAdmission], [ForPerYear], [DepandsOnCredits], [CreditsCompleted], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (2, N'Advising', 2, NULL, NULL, 2, 0, 1, 9, 6, 0, 2, N'2017', CAST(4500.00 AS Decimal(18, 2)), 0, 1, 0, CAST(0.00 AS Decimal(18, 2)), 1, 1, CAST(0x0000A4EA00BC6018 AS DateTime), NULL, NULL)
657GO
658INSERT [dbo].[NSU_Main_Fees_FeeStructure] ([FeesTypeId], [ModuleType], [FeesHeadBankId], [FeesTypeName], [DisplayName], [ProgamTypeId], [Parent], [SchoolId], [DepartmentId], [ProgramId], [AreaId], [SessionId], [Year], [Amount], [ForAdmission], [ForPerYear], [DepandsOnCredits], [CreditsCompleted], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (3, N'Advising', 2, NULL, NULL, 2, 0, 1, 9, 6, 0, 2, N'2017', CAST(5000.00 AS Decimal(18, 2)), 1, 1, 1, CAST(70.00 AS Decimal(18, 2)), 1, 1, CAST(0x0000A4EA00BCC0D2 AS DateTime), NULL, NULL)
659GO
660INSERT [dbo].[NSU_Main_Fees_FeeStructure] ([FeesTypeId], [ModuleType], [FeesHeadBankId], [FeesTypeName], [DisplayName], [ProgamTypeId], [Parent], [SchoolId], [DepartmentId], [ProgramId], [AreaId], [SessionId], [Year], [Amount], [ForAdmission], [ForPerYear], [DepandsOnCredits], [CreditsCompleted], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (4, N'Advising', 2, NULL, NULL, 2, 0, 1, 9, 6, 0, 2, N'2017', CAST(4500.00 AS Decimal(18, 2)), 0, 1, 0, CAST(0.00 AS Decimal(18, 2)), 1, 1, CAST(0x0000A4EA00BCC0D3 AS DateTime), NULL, NULL)
661GO
662INSERT [dbo].[NSU_Main_Fees_FeeStructure] ([FeesTypeId], [ModuleType], [FeesHeadBankId], [FeesTypeName], [DisplayName], [ProgamTypeId], [Parent], [SchoolId], [DepartmentId], [ProgramId], [AreaId], [SessionId], [Year], [Amount], [ForAdmission], [ForPerYear], [DepandsOnCredits], [CreditsCompleted], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (5, N'Advising', 2, NULL, NULL, 2, 0, 1, 9, 6, 0, 2, N'2017', CAST(1500.00 AS Decimal(18, 2)), 0, 0, 0, CAST(0.00 AS Decimal(18, 2)), 1, 1, CAST(0x0000A52201138746 AS DateTime), NULL, NULL)
663GO
664INSERT [dbo].[NSU_Main_Fees_FeeStructure] ([FeesTypeId], [ModuleType], [FeesHeadBankId], [FeesTypeName], [DisplayName], [ProgamTypeId], [Parent], [SchoolId], [DepartmentId], [ProgramId], [AreaId], [SessionId], [Year], [Amount], [ForAdmission], [ForPerYear], [DepandsOnCredits], [CreditsCompleted], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (6, N'Advising', 2, NULL, NULL, 2, 0, 1, 9, 6, 0, 2, N'2017', CAST(5500.00 AS Decimal(18, 2)), 0, 0, 0, CAST(0.00 AS Decimal(18, 2)), 1, 1, CAST(0x0000A52300EA348A AS DateTime), NULL, NULL)
665GO
666INSERT [dbo].[NSU_Main_Fees_FeeStructure] ([FeesTypeId], [ModuleType], [FeesHeadBankId], [FeesTypeName], [DisplayName], [ProgamTypeId], [Parent], [SchoolId], [DepartmentId], [ProgramId], [AreaId], [SessionId], [Year], [Amount], [ForAdmission], [ForPerYear], [DepandsOnCredits], [CreditsCompleted], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (7, N'Advising', 2, NULL, NULL, 2, 0, 1, 9, 6, 0, 2, N'2017', CAST(5500.00 AS Decimal(18, 2)), 0, 0, 0, CAST(0.00 AS Decimal(18, 2)), 1, 1, CAST(0x0000A52300EA5E94 AS DateTime), NULL, NULL)
667GO
668INSERT [dbo].[NSU_Main_Fees_FeeStructure] ([FeesTypeId], [ModuleType], [FeesHeadBankId], [FeesTypeName], [DisplayName], [ProgamTypeId], [Parent], [SchoolId], [DepartmentId], [ProgramId], [AreaId], [SessionId], [Year], [Amount], [ForAdmission], [ForPerYear], [DepandsOnCredits], [CreditsCompleted], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (8, N'Advising', 2, NULL, NULL, 2, 0, 1, 9, 6, 0, 2, N'2017', CAST(5500.00 AS Decimal(18, 2)), 0, 0, 0, CAST(0.00 AS Decimal(18, 2)), 0, 1, CAST(0x0000A52300EABB9D AS DateTime), NULL, NULL)
669GO
670INSERT [dbo].[NSU_Main_Fees_FeeStructure] ([FeesTypeId], [ModuleType], [FeesHeadBankId], [FeesTypeName], [DisplayName], [ProgamTypeId], [Parent], [SchoolId], [DepartmentId], [ProgramId], [AreaId], [SessionId], [Year], [Amount], [ForAdmission], [ForPerYear], [DepandsOnCredits], [CreditsCompleted], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (9, N'Advising', 3, NULL, NULL, 2, 0, 1, 9, 6, 0, 2, N'2017', CAST(3000.00 AS Decimal(18, 2)), 0, 0, 0, CAST(0.00 AS Decimal(18, 2)), 0, 1, CAST(0x0000A52300EAD77F AS DateTime), NULL, NULL)
671GO
672INSERT [dbo].[NSU_Main_Fees_FeeStructure] ([FeesTypeId], [ModuleType], [FeesHeadBankId], [FeesTypeName], [DisplayName], [ProgamTypeId], [Parent], [SchoolId], [DepartmentId], [ProgramId], [AreaId], [SessionId], [Year], [Amount], [ForAdmission], [ForPerYear], [DepandsOnCredits], [CreditsCompleted], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (10, N'Advising', 4, NULL, NULL, 2, 0, 1, 9, 6, 0, 2, N'2017', CAST(750.00 AS Decimal(18, 2)), 0, 0, 0, CAST(0.00 AS Decimal(18, 2)), 0, 1, CAST(0x0000A52300EAEBBD AS DateTime), NULL, NULL)
673GO
674INSERT [dbo].[NSU_Main_Fees_FeeStructure] ([FeesTypeId], [ModuleType], [FeesHeadBankId], [FeesTypeName], [DisplayName], [ProgamTypeId], [Parent], [SchoolId], [DepartmentId], [ProgramId], [AreaId], [SessionId], [Year], [Amount], [ForAdmission], [ForPerYear], [DepandsOnCredits], [CreditsCompleted], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (11, N'Advising', 5, NULL, NULL, 2, 0, 1, 9, 6, 0, 2, N'2017', CAST(2250.00 AS Decimal(18, 2)), 0, 0, 0, CAST(0.00 AS Decimal(18, 2)), 0, 1, CAST(0x0000A52300EB0296 AS DateTime), NULL, NULL)
675GO
676INSERT [dbo].[NSU_Main_Fees_FeeStructure] ([FeesTypeId], [ModuleType], [FeesHeadBankId], [FeesTypeName], [DisplayName], [ProgamTypeId], [Parent], [SchoolId], [DepartmentId], [ProgramId], [AreaId], [SessionId], [Year], [Amount], [ForAdmission], [ForPerYear], [DepandsOnCredits], [CreditsCompleted], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (12, N'Advising', 3, NULL, NULL, 2, 0, 1, 9, 6, 0, 2, N'2017', CAST(2000.00 AS Decimal(18, 2)), 0, 0, 0, CAST(0.00 AS Decimal(18, 2)), 1, 1, CAST(0x0000A52300EB3897 AS DateTime), NULL, NULL)
677GO
678INSERT [dbo].[NSU_Main_Fees_FeeStructure] ([FeesTypeId], [ModuleType], [FeesHeadBankId], [FeesTypeName], [DisplayName], [ProgamTypeId], [Parent], [SchoolId], [DepartmentId], [ProgramId], [AreaId], [SessionId], [Year], [Amount], [ForAdmission], [ForPerYear], [DepandsOnCredits], [CreditsCompleted], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (13, N'Advising', 7, NULL, NULL, 2, 0, 1, 9, 6, 0, 2, N'2017', CAST(3000.00 AS Decimal(18, 2)), 0, 0, 0, CAST(0.00 AS Decimal(18, 2)), 0, 1, CAST(0x0000A52300EBC98F AS DateTime), NULL, NULL)
679GO
680SET IDENTITY_INSERT [dbo].[NSU_Main_Fees_FeeStructure] OFF
681GO
682SET IDENTITY_INSERT [dbo].[NSU_Main_Fees_FinancialAidPolicy] ON
683
684GO
685INSERT [dbo].[NSU_Main_Fees_FinancialAidPolicy] ([FinancialAidPolicyId], [Heading], [Description], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (1, N'Rules for financial aid recipents', N'Loren ipsum gala mijung loren ipsum loren bandir Loren ipsum gala mijung loren ipsum loren bandir Loren ipsum gala mijung loren ipsum loren bandir Loren ipsum gala mijung loren ipsum loren bandir Loren ipsum gala mijung loren ipsum loren bandir Loren ipsum gala mijung loren ipsum loren bandir Loren ipsum gala mijung loren ipsum loren bandir Loren ipsum gala mijung loren ipsum loren bandir Loren ipsum gala mijung loren ipsum loren bandir Loren ipsum gala mijung loren ipsum loren bandir Loren ipsum gala mijung loren ipsum loren bandir Loren ipsum gala mijung loren ipsum loren bandir', 0, 0, CAST(0x0000A5F2009DAA3C AS DateTime), NULL, NULL)
686GO
687SET IDENTITY_INSERT [dbo].[NSU_Main_Fees_FinancialAidPolicy] OFF
688GO
689SET IDENTITY_INSERT [dbo].[NSU_Main_Fees_StudentFeesReceipt] ON
690
691GO
692INSERT [dbo].[NSU_Main_Fees_StudentFeesReceipt] ([FeesReceiptId], [SessionId], [Year], [StudentId], [ModuleType], [FeesHead], [FeesAmount], [DueDate], [Paid], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (1, 2, N'2017', 1, N'Advising', N'Student Activities Fee', CAST(3000.00 AS Decimal(18, 2)), CAST(0x0000A61000AF802D AS DateTime), 0, 0, 0, CAST(0x0000A5F200AF8039 AS DateTime), NULL, NULL)
693GO
694INSERT [dbo].[NSU_Main_Fees_StudentFeesReceipt] ([FeesReceiptId], [SessionId], [Year], [StudentId], [ModuleType], [FeesHead], [FeesAmount], [DueDate], [Paid], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (2, 2, N'2017', 1, N'Advising', N'Library Fee', CAST(750.00 AS Decimal(18, 2)), CAST(0x0000A61000AF802D AS DateTime), 0, 0, 0, CAST(0x0000A5F200AF8039 AS DateTime), NULL, NULL)
695GO
696INSERT [dbo].[NSU_Main_Fees_StudentFeesReceipt] ([FeesReceiptId], [SessionId], [Year], [StudentId], [ModuleType], [FeesHead], [FeesAmount], [DueDate], [Paid], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (3, 2, N'2017', 1, N'Advising', N'Computer Lab Fee', CAST(2250.00 AS Decimal(18, 2)), CAST(0x0000A61000AF802D AS DateTime), 0, 0, 0, CAST(0x0000A5F200AF803A AS DateTime), NULL, NULL)
697GO
698INSERT [dbo].[NSU_Main_Fees_StudentFeesReceipt] ([FeesReceiptId], [SessionId], [Year], [StudentId], [ModuleType], [FeesHead], [FeesAmount], [DueDate], [Paid], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (4, 2, N'2017', 1, N'Advising', N'Studio Course fee', CAST(3000.00 AS Decimal(18, 2)), CAST(0x0000A61000AF802D AS DateTime), 0, 0, 0, CAST(0x0000A5F200AF803B AS DateTime), NULL, NULL)
699GO
700INSERT [dbo].[NSU_Main_Fees_StudentFeesReceipt] ([FeesReceiptId], [SessionId], [Year], [StudentId], [ModuleType], [FeesHead], [FeesAmount], [DueDate], [Paid], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (5, 2, N'2017', 1, N'Advising', N'Tuition Fee', CAST(33000.00 AS Decimal(18, 2)), CAST(0x0000A61000AF802D AS DateTime), 0, 0, 0, CAST(0x0000A5F200AF803E AS DateTime), NULL, NULL)
701GO
702INSERT [dbo].[NSU_Main_Fees_StudentFeesReceipt] ([FeesReceiptId], [SessionId], [Year], [StudentId], [ModuleType], [FeesHead], [FeesAmount], [DueDate], [Paid], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (6, 2, N'2017', 8, N'Advising', N'Student Activities Fee', CAST(3000.00 AS Decimal(18, 2)), CAST(0x0000A61000D064BC AS DateTime), 0, 0, 0, CAST(0x0000A5F200D064C0 AS DateTime), NULL, NULL)
703GO
704INSERT [dbo].[NSU_Main_Fees_StudentFeesReceipt] ([FeesReceiptId], [SessionId], [Year], [StudentId], [ModuleType], [FeesHead], [FeesAmount], [DueDate], [Paid], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (7, 2, N'2017', 8, N'Advising', N'Library Fee', CAST(750.00 AS Decimal(18, 2)), CAST(0x0000A61000D064BC AS DateTime), 0, 0, 0, CAST(0x0000A5F200D064C1 AS DateTime), NULL, NULL)
705GO
706INSERT [dbo].[NSU_Main_Fees_StudentFeesReceipt] ([FeesReceiptId], [SessionId], [Year], [StudentId], [ModuleType], [FeesHead], [FeesAmount], [DueDate], [Paid], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (8, 2, N'2017', 8, N'Advising', N'Computer Lab Fee', CAST(2250.00 AS Decimal(18, 2)), CAST(0x0000A61000D064BC AS DateTime), 0, 0, 0, CAST(0x0000A5F200D064C1 AS DateTime), NULL, NULL)
707GO
708INSERT [dbo].[NSU_Main_Fees_StudentFeesReceipt] ([FeesReceiptId], [SessionId], [Year], [StudentId], [ModuleType], [FeesHead], [FeesAmount], [DueDate], [Paid], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (9, 2, N'2017', 8, N'Advising', N'Studio Course fee', CAST(3000.00 AS Decimal(18, 2)), CAST(0x0000A61000D064BC AS DateTime), 0, 0, 0, CAST(0x0000A5F200D064C1 AS DateTime), NULL, NULL)
709GO
710INSERT [dbo].[NSU_Main_Fees_StudentFeesReceipt] ([FeesReceiptId], [SessionId], [Year], [StudentId], [ModuleType], [FeesHead], [FeesAmount], [DueDate], [Paid], [Status], [CreatedBy], [CreatedTime], [ModifiedBy], [ModifiedTime]) VALUES (10, 2, N'2017', 8, N'Advising', N'Tuition Fee', CAST(99000.00 AS Decimal(18, 2)), CAST(0x0000A61000D064BC AS DateTime), 0, 0, 0, CAST(0x0000A5F200D064C4 AS DateTime), NULL, NULL)
711GO
712SET IDENTITY_INSERT [dbo].[NSU_Main_Fees_StudentFeesReceipt] OFF
713GO
714IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_StudentFeesCollection_Status_copy]') AND type = 'D')
715BEGIN
716ALTER TABLE [dbo].[NSU_Main_Fees_Admission_FeesCollection] ADD CONSTRAINT [DF_NSU_Main_Fees_StudentFeesCollection_Status_copy] DEFAULT ((0)) FOR [Status]
717END
718
719GO
720IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_StudentFeesCollection_CreatedTime_copy]') AND type = 'D')
721BEGIN
722ALTER TABLE [dbo].[NSU_Main_Fees_Admission_FeesCollection] ADD CONSTRAINT [DF_NSU_Main_Fees_StudentFeesCollection_CreatedTime_copy] DEFAULT (getdate()) FOR [CreatedTime]
723END
724
725GO
726IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeesHeadBank_Status]') AND type = 'D')
727BEGIN
728ALTER TABLE [dbo].[NSU_Main_Fees_FeesHeadBank] ADD CONSTRAINT [DF_NSU_Main_Fees_FeesHeadBank_Status] DEFAULT ((0)) FOR [Status]
729END
730
731GO
732IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeesHeadBank_Enable]') AND type = 'D')
733BEGIN
734ALTER TABLE [dbo].[NSU_Main_Fees_FeesHeadBank] ADD CONSTRAINT [DF_NSU_Main_Fees_FeesHeadBank_Enable] DEFAULT ((1)) FOR [Enable]
735END
736
737GO
738IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeesPaymentPolicy_Status]') AND type = 'D')
739BEGIN
740ALTER TABLE [dbo].[NSU_Main_Fees_FeesPaymentPolicy] ADD CONSTRAINT [DF_NSU_Main_Fees_FeesPaymentPolicy_Status] DEFAULT ((0)) FOR [Status]
741END
742
743GO
744IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeesPaymentPolicy_CreatedTime]') AND type = 'D')
745BEGIN
746ALTER TABLE [dbo].[NSU_Main_Fees_FeesPaymentPolicy] ADD CONSTRAINT [DF_NSU_Main_Fees_FeesPaymentPolicy_CreatedTime] DEFAULT (getdate()) FOR [CreatedTime]
747END
748
749GO
750IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeeStructure_SchoolId]') AND type = 'D')
751BEGIN
752ALTER TABLE [dbo].[NSU_Main_Fees_FeeStructure] ADD CONSTRAINT [DF_NSU_Main_Fees_FeeStructure_SchoolId] DEFAULT ((0)) FOR [SchoolId]
753END
754
755GO
756IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_FeeStructure_DepartmentId]') AND type = 'D')
757BEGIN
758ALTER TABLE [dbo].[NSU_Main_Fees_FeeStructure] ADD CONSTRAINT [DF_NSU_Main_FeeStructure_DepartmentId] DEFAULT ((0)) FOR [DepartmentId]
759END
760
761GO
762IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_FeeStructure_ProgramId]') AND type = 'D')
763BEGIN
764ALTER TABLE [dbo].[NSU_Main_Fees_FeeStructure] ADD CONSTRAINT [DF_NSU_Main_FeeStructure_ProgramId] DEFAULT ((0)) FOR [ProgramId]
765END
766
767GO
768IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_AreaId]') AND type = 'D')
769BEGIN
770ALTER TABLE [dbo].[NSU_Main_Fees_FeeStructure] ADD CONSTRAINT [DF_NSU_Main_Fees_AreaId] DEFAULT ((0)) FOR [AreaId]
771END
772
773GO
774IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeeStructure_SessionId]') AND type = 'D')
775BEGIN
776ALTER TABLE [dbo].[NSU_Main_Fees_FeeStructure] ADD CONSTRAINT [DF_NSU_Main_Fees_FeeStructure_SessionId] DEFAULT ((0)) FOR [SessionId]
777END
778
779GO
780IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeeStructure_ForAdmission]') AND type = 'D')
781BEGIN
782ALTER TABLE [dbo].[NSU_Main_Fees_FeeStructure] ADD CONSTRAINT [DF_NSU_Main_Fees_FeeStructure_ForAdmission] DEFAULT ((0)) FOR [ForAdmission]
783END
784
785GO
786IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeeStructure_ForYear]') AND type = 'D')
787BEGIN
788ALTER TABLE [dbo].[NSU_Main_Fees_FeeStructure] ADD CONSTRAINT [DF_NSU_Main_Fees_FeeStructure_ForYear] DEFAULT ((0)) FOR [ForPerYear]
789END
790
791GO
792IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FeeStructure_DepandsOnCredits]') AND type = 'D')
793BEGIN
794ALTER TABLE [dbo].[NSU_Main_Fees_FeeStructure] ADD CONSTRAINT [DF_NSU_Main_Fees_FeeStructure_DepandsOnCredits] DEFAULT ((0)) FOR [DepandsOnCredits]
795END
796
797GO
798IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_Status]') AND type = 'D')
799BEGIN
800ALTER TABLE [dbo].[NSU_Main_Fees_FeeStructure] ADD CONSTRAINT [DF_NSU_Main_Fees_Status] DEFAULT ((0)) FOR [Status]
801END
802
803GO
804IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_CreatedTime]') AND type = 'D')
805BEGIN
806ALTER TABLE [dbo].[NSU_Main_Fees_FeeStructure] ADD CONSTRAINT [DF_NSU_Main_Fees_CreatedTime] DEFAULT (getdate()) FOR [CreatedTime]
807END
808
809GO
810IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FinancialAidPolicy_Status]') AND type = 'D')
811BEGIN
812ALTER TABLE [dbo].[NSU_Main_Fees_FinancialAidPolicy] ADD CONSTRAINT [DF_NSU_Main_Fees_FinancialAidPolicy_Status] DEFAULT ((0)) FOR [Status]
813END
814
815GO
816IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FinancialAidPolicy_CreatedTime]') AND type = 'D')
817BEGIN
818ALTER TABLE [dbo].[NSU_Main_Fees_FinancialAidPolicy] ADD CONSTRAINT [DF_NSU_Main_Fees_FinancialAidPolicy_CreatedTime] DEFAULT (getdate()) FOR [CreatedTime]
819END
820
821GO
822IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FineSetup_TakeFinancialAid]') AND type = 'D')
823BEGIN
824ALTER TABLE [dbo].[NSU_Main_Fees_FineSetup] ADD CONSTRAINT [DF_NSU_Main_Fees_FineSetup_TakeFinancialAid] DEFAULT ((0)) FOR [TakeFinancialAid]
825END
826
827GO
828IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FineSetup_Status]') AND type = 'D')
829BEGIN
830ALTER TABLE [dbo].[NSU_Main_Fees_FineSetup] ADD CONSTRAINT [DF_NSU_Main_Fees_FineSetup_Status] DEFAULT ((0)) FOR [Status]
831END
832
833GO
834IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_FineSetup_CreatedTime]') AND type = 'D')
835BEGIN
836ALTER TABLE [dbo].[NSU_Main_Fees_FineSetup] ADD CONSTRAINT [DF_NSU_Main_Fees_FineSetup_CreatedTime] DEFAULT (getdate()) FOR [CreatedTime]
837END
838
839GO
840IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_StudentFeesCollection_Status]') AND type = 'D')
841BEGIN
842ALTER TABLE [dbo].[NSU_Main_Fees_StudentFeesCollection] ADD CONSTRAINT [DF_NSU_Main_Fees_StudentFeesCollection_Status] DEFAULT ((0)) FOR [Status]
843END
844
845GO
846IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_StudentFeesCollection_CreatedTime]') AND type = 'D')
847BEGIN
848ALTER TABLE [dbo].[NSU_Main_Fees_StudentFeesCollection] ADD CONSTRAINT [DF_NSU_Main_Fees_StudentFeesCollection_CreatedTime] DEFAULT (getdate()) FOR [CreatedTime]
849END
850
851GO
852IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_StudentFeesReceipt_Paid]') AND type = 'D')
853BEGIN
854ALTER TABLE [dbo].[NSU_Main_Fees_StudentFeesReceipt] ADD CONSTRAINT [DF_NSU_Main_Fees_StudentFeesReceipt_Paid] DEFAULT ((0)) FOR [Paid]
855END
856
857GO
858IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_StudentFeesReceipt_Status]') AND type = 'D')
859BEGIN
860ALTER TABLE [dbo].[NSU_Main_Fees_StudentFeesReceipt] ADD CONSTRAINT [DF_NSU_Main_Fees_StudentFeesReceipt_Status] DEFAULT ((0)) FOR [Status]
861END
862
863GO
864IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_StudentFeesReceipt_CreatedTime]') AND type = 'D')
865BEGIN
866ALTER TABLE [dbo].[NSU_Main_Fees_StudentFeesReceipt] ADD CONSTRAINT [DF_NSU_Main_Fees_StudentFeesReceipt_CreatedTime] DEFAULT (getdate()) FOR [CreatedTime]
867END
868
869GO
870IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_UniversityBank_CreatedTime]') AND type = 'D')
871BEGIN
872ALTER TABLE [dbo].[NSU_Main_Fees_UniversityBank] ADD CONSTRAINT [DF_NSU_Main_Fees_UniversityBank_CreatedTime] DEFAULT (getdate()) FOR [CreatedTime]
873END
874
875GO
876IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_UniversityBank_Status]') AND type = 'D')
877BEGIN
878ALTER TABLE [dbo].[NSU_Main_Fees_UniversityBank] ADD CONSTRAINT [DF_NSU_Main_Fees_UniversityBank_Status] DEFAULT ((0)) FOR [Status]
879END
880
881GO
882IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_UniversityBankBranch_CreatedTime]') AND type = 'D')
883BEGIN
884ALTER TABLE [dbo].[NSU_Main_Fees_UniversityBankBranch] ADD CONSTRAINT [DF_NSU_Main_Fees_UniversityBankBranch_CreatedTime] DEFAULT (getdate()) FOR [CreatedTime]
885END
886
887GO
888IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_UniversityBankBranch_Status]') AND type = 'D')
889BEGIN
890ALTER TABLE [dbo].[NSU_Main_Fees_UniversityBankBranch] ADD CONSTRAINT [DF_NSU_Main_Fees_UniversityBankBranch_Status] DEFAULT ((0)) FOR [Status]
891END
892
893GO
894IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_WaiverSetup_DepandsOnResult]') AND type = 'D')
895BEGIN
896ALTER TABLE [dbo].[NSU_Main_Fees_WaiverSetup] ADD CONSTRAINT [DF_NSU_Main_Fees_WaiverSetup_DepandsOnResult] DEFAULT ((0)) FOR [IsDepandsOnResult]
897END
898
899GO
900IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_WaiverSetup_Status]') AND type = 'D')
901BEGIN
902ALTER TABLE [dbo].[NSU_Main_Fees_WaiverSetup] ADD CONSTRAINT [DF_NSU_Main_Fees_WaiverSetup_Status] DEFAULT ((0)) FOR [IsDepandsOnSiblings]
903END
904
905GO
906IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_WaiverSetup_Status_1]') AND type = 'D')
907BEGIN
908ALTER TABLE [dbo].[NSU_Main_Fees_WaiverSetup] ADD CONSTRAINT [DF_NSU_Main_Fees_WaiverSetup_Status_1] DEFAULT ((0)) FOR [Status]
909END
910
911GO
912IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_NSU_Main_Fees_WaiverSetup_CreatedTime]') AND type = 'D')
913BEGIN
914ALTER TABLE [dbo].[NSU_Main_Fees_WaiverSetup] ADD CONSTRAINT [DF_NSU_Main_Fees_WaiverSetup_CreatedTime] DEFAULT (getdate()) FOR [CreatedTime]
915END
916
917GO