-- Kolo Bank: Data Manipulation Language (DML) --
USE KoloBank1;
GO
INSERT INTO Accounts.Status(AccountStatus)
VALUES(N'Active'), (N'Closed'), (N'Suspended');
GO
INSERT INTO Accounts.ChargesReasons
VALUES(N'NSF', N'Non-Sufficient Funds: This happens when a check is presented against a bank account but there are not enough funds to pay the check.'),
(N'Monthly Charge', N'Applied every month to each account. The charge is made even if the account has non-sufficient funds, in which case the account balance may become negative.'),
(N'Overdraft', N'Applied if a customer account remains negative for 72 hours');
GO
INSERT INTO Accounts.CurrenciesTypes
VALUES(N'Cash', NULL),
(N'Check', NULL),
(N'Direct Deposit', NULL),
(N'External Transfer', N'Transfer made from an account from another bank'),
(N'Local Transfer', N'Transfer made from another account of our bank'),
(N'Money Order', NULL);
GO
INSERT INTO Accounts.TransactionsTypes
VALUES(N'Deposit', N'A deposit indicates that money was (or has been added to the account.'),
(N'Withdrawal', N'A withdrawal means that money was, or has been, taken from the bank account. A withdrawal should be made only if the account has enough funds to cover the transaction. In most cases, if the account does not have enough funds, a withdrawal may be denied. In some exceptional circumstances the bank may allow the withdrawal, even if that would make the balance negative negative. Only a bank manager has the right to make such a decision.'),
(N'Check Cashing', N'A check cashing occurs when either a physical person brings a check to the bank or the processing is requested to be done electronically. In most cases, check cashing follows the same rules as a withdrawal, with some exceptions. For example, if an institution presents a check to be paid but there are not enough funds, the bank may or may not validate the check. Either case, there would be a $25 NSF fee against the bank account. Even if the account balance is already negative, the fee may still apply.'),,
(N'Monthly Charge', N'A monthly charge is a fee applied to most bank accounts. In some cases, and based on some criteria at the discretion of the bank management, some bank accounts are exempt from a monthly charge.'),
(N'Service Charge', N'There are two types of service charges. One category includes a fee charged by the bank to perform some services such as issuing a money order, printing a special check, notarizing a document, or making a manager sign a certain statement. Some customers are not charg anything for some services. Another service charge is a (penalty) fee applied against an account. An example of an NSF fee applied when an account does not have anough funds to cover a check. In most cases, when a service charge or fee has to be applied, this would be done even if the account balance is already negative.'),
(N'Fund Transfer', NULL),
(N'Money Order', NULL);
GO
INSERT INTO Management.StartingSalaries
VALUES(N'Base', 10.00),
(N'Intern', 12.35),
(N'Regular', 14.50),
(N'Manager', 20.00);
GO
INSERT INTO Management.Locations(LocationCode, Location, City, [State], ZIPCode)
VALUES(N'0ALXML', N'ATM Alexandria Mall West', N'Alexandria', N'VA', N'22314'),
(N'0CLGPK', N'ATM UMD College Park - Math Building', N'College Park', N'MD', N'20314');
GO
INSERT INTO Management.Locations(LocationCode, Location, City, [State], ZIPCode, Notes)
VALUES(N'0GRNML', N'ATM Greenbelt Mall', N'Greenbelt', N'MD', N'20770', N'ATM in Greenbelt Mall');
GO
INSERT INTO Management.Locations(LocationCode, Location, City, [State], ZIPCode)
VALUES(N'0LNFPL', N'ATM L''Enfant Plaza', N'Washington', N'DC', N'20024'),
(N'0MNGML', N'ATM Montgomery Mall - North Entrance', N'Bethesda', N'MD', N'20817'),
(N'0SSCTPL', N'ATM Silver Spring City Place', N'Silver Spring', N'MD', N'20910'),
(N'0SSMTR', N'ATM Silver Spring Metro Station', N'Silver Spring', N'MD', N'20910');
GO
INSERT INTO Management.Locations(LocationCode, Location, City, [State], ZIPCode, Notes)
VALUES(N'0UNSDC', N'ATM Union Station', N'Washington', N'DC', N'20002', N'ATM inside Union Station in DC'),
(N'0WPLZM', N'ATM Wheaton Plaza Mall', N'Silver Spring', N'MD', N'20906', N'ATM inside Wheaton Plaza Mall');
GO
INSERT INTO Management.Locations(LocationCode, Location, City, [State], ZIPCode)
VALUES(N'0WTFML', N'ATM White Flint Mall', N'Rockville', N'MD', N'20895');
GO
INSERT INTO Management.Locations(LocationCode, Location) VALUES(N'1ONLIN', N'Online');
GO
INSERT INTO Management.Locations(LocationCode, Location, [Address], City, [State], ZIPCode)
VALUES(N'ALXJPZ', N'Junino Plaza', N'3382 Junino Ave', N'Alexandria', N'VA', N'22132'),
(N'CPKUMD', N'University of Maryland', N'808 Vieira Drive', N'College Park', N'MD', N'20707'),
(N'DCK10S', N'Kennedy & 10th Street', N'10368 Sesame Lolane Rd N.E.', N'Washington', N'DC', N'20014'),
(N'GTWMST', N'Georgetown M Street', N'2602 M Street N.W.', N'Washington', N'DC', N'20008'),
(N'SLVSSL', N'Seven Lock Corner', N'3925 Euler Ave', N'Silver Spring', N'MD', N'20904'),
(N'WHTFLT', N'White Flint Mall', N'12044 Rte 255', N'Rockville', N'MD', N'20854');
GO
INSERT INTO Accounts.Types(AccountType, TypeDescription)
VALUES(N'Checking', N'Used to regularly deposit and withdraw money at will'),
(N'Saving', N'Used to deposit money to save it but hardly withdraw it'),
(N'CD', N'Certificate of Deposit');
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, LastName)VALUES(N'000-100', N'ATM', N'Teller Machine');
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, LastName, Title)
VALUES(N'000-200', N'Automatic', N'Transaction', N'Automatic Computer Transaction'),
(N'111-111', N'Online', N'Web', N'Online Transaction');
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, MiddleName, LastName, LocationCode, Title, [Address], City, [State], ZIPCode, HourlySalary)
VALUES(N'482-799', N'Annette', N'Joan', N'Roberts', N'GTWMST', N'Cashier', N'1277 Cecil Maurice Av. NW', N'Washington', N'DC', N'20004', 14.88);
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, LastName, LocationCode, Title, CanCreateAccount, [Address], City, [State], ZIPCode)
VALUES(N'715-204', N'Adam', N'Ramirez', N'DCK10S', N'Branch Manager', 1, N'4606 Eulaw Ave. N.W.', N'Washington', N'DC', N'20008');
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, MiddleName, LastName, LocationCode, Title, [Address], City, [State], ZIPCode, HourlySalary)
VALUES(N'722-286', N'Donald', N'Anthony', N'Fisher', N'SLVSSL', N'Public Relations Manager', N'58 North Assault St.', N'Takoma Park', N'MD', N'20910', 25.32);
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, MiddleName, LastName, LocationCode, Title, CanCreateAccount, [Address], City, [State], ZIPCode, PhoneNumber , HourlySalary)
VALUES(N'774-284', N'Herbert', N'Marc', N'Jerremies', N'GTWMST', N'Intern', 1, N'8254 12th St. N.E.', N'Washington', N'DC', N'20004', N'(410) 653-1309', 4.15);
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, LastName, LocationCode, Title, CanCreateAccount, [Address], City, [State], ZIPCode, HourlySalary)
VALUES(N'928-495', N'Ryan', N'Duck', N'SLVSSL', N'General Manager', 1, N'10244 Webster Rd', N'Rockville', N'MD', N'20854', 42.74);
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, MiddleName, LastName, LocationCode, Title, [Address], City, [State], ZIPCode, HourlySalary)
VALUES(N'428-947', N'Krystal', N'Erica', N'Njawe', N'ALXJPZ', N'Cashier', N'825 Celine Drv', N'Alexandria', N'VA', N'22316', 14.85);
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, LastName, LocationCode, Title, [Address], City, [State], ZIPCode, HourlySalary)
VALUES(N'279-377', N'Michael', N'Dobmeyer', N'SLVSSL', N'Shift Programmer', N'12 16th St. S. W.', N'Washington', N'DC', N'20008', 20.56);
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, LastName, LocationCode, Title, CanCreateAccount, [Address], City, [State], ZIPCode, HourlySalary)
VALUES(N'507-728', N'Timothy', N'Wray', N'GTWMST', N'Branch Manager', 1, N'720 Oak Tree Rd.', N'Columbia', N'MD', N'21044', 35.62);
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, MiddleName, LastName, LocationCode, Title, [Address], City, [State], ZIPCode, HourlySalary)
VALUES(N'927-395', N'Luisa', N'Judie', N'Vanecek', N'GTWMST', N'Cashier', N'8082 16th St N.W.', N'Washington', N'DC', N'20002', 16.75),
(N'736-626', N'Annabelle', N'Jeannette', N'Coen', N'SLVSSL', N'Cashier', N'15328 Crystal St.', N'Frederick', N'MD', N'21701', 15.75);
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, LastName, LocationCode, Title, CanCreateAccount, [Address], City, [State], ZIPCode, HourlySalary)
VALUES(N'952-846', N'John', N'Possemato', N'SLVSSL', N'Assistant Manager', 1, N'8254 12th St. N.E.', N'Washington', N'DC', N'20004', 24.12);
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, LastName, LocationCode, Title, [Address], City, [State], ZIPCode, HourlySalary)
VALUES(N'500-284', N'Alexa', N'Charles', N'DCK10S', N'Cashier', N'914 Jamieson St N.W.', N'Washington', N'DC', N'20012', 17.75);
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, LastName, LocationCode, Title, CanCreateAccount, [Address], City, [State], ZIPCode, HourlySalary)
VALUES(N'294-075', N'Luis', N'Velker', N'ALXJPZ', N'Branch Manager', 1, N'9502 Copher Ave', N'Alexandria', N'VA', N'22312', 28.75);
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, LastName, LocationCode, Title, CanCreateAccount, [Address], City, [State], ZIPCode)
VALUES(N'461-842', N'Dorrin', N'Vive', N'CPKUMD', N'Branch Manager', 1, N'273 S. Independence Ave.', N'College Park', N'MD', N'20747');
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, MiddleName, LastName, LocationCode, Title, [Address], City, [State], ZIPCode, PhoneNumber , HourlySalary)
VALUES(N'595-028', N'Calvin', N'Alfred', N'Khone', N'DCK10S', N'Cashier', N'516 Linden Street Apt D2', N'Silver Spring', N'MD', N'20902', N'(301) 839-4253', 6.85);
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, MiddleName, LastName, LocationCode, Title, [Address], City, [State], ZIPCode, HourlySalary)
VALUES(N'284-725', N'Wanda', N'Mary', N'Dundon', N'ALXJPZ', N'Cashier', N'614 Simpson Ave', N'Takoma Park', N'MD', N'20912', 15.95),
(N'481-114', N'Samuel', N'Arthur', N'Lansing', N'CPKUMD', N'Cashier', N'9337 Cachet St', N'Beltsville', N'MD', N'20705', 15.25),
(N'624-825', N'Luke', N'Andrew', N'Parkinson', N'SLVSSL', N'Intern', N'4445 Blue Oak St. #6A', N'Silver Spring', N'MD', N'20906', 14.35);
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, MiddleName, LastName, LocationCode, Title, [Address], City, [State], ZIPCode, PhoneNumber , HourlySalary)
VALUES(N'639-814', N'Samuel', N'Howard', N'Jones', N'WHTFLT', N'Cashier', N'9337 Cachet St', N'Baltimore', N'MD', N'21205', N'(410) 653-1309', 8.25);
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, MiddleName, LastName, LocationCode, Title, CanCreateAccount, [Address], City, [State], ZIPCode, HourlySalary)
VALUES(N'552-884', N'Joy', N'Maureen', N'Donovan', N'ALXJPZ', N'Customer Accounts Manager', 1, N'845 Arcadia Ave. #1512', N'Alexandria', N'VA', N'22314', 29.55);
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, LastName, LocationCode, Title, CanCreateAccount, [Address], City, [State], ZIPCode, HourlySalary)
VALUES(N'492-081', N'Jeffrey', N'Kilborne', N'GTWMST', N'Accounts Manager', 1, N'308 Capitol Blvd', N'McLean', N'VA', N'22101', 26.15);
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, MiddleName, LastName, LocationCode, Title, [Address], City, [State], ZIPCode, HourlySalary)
VALUES(N'248-552', N'Michael', N'William', N'Olney', N'CPKUMD', N'Cashier', N'3832 Great River Rd', N'Silver Spring', N'MD', N'20906', 17.52),
(N'503-938', N'Michelle', N'Deborah', N'Stephenson', N'SLVSSL', N'Head Teller', N'2888 Gwett Richards Av.', N'Glen Burnie', N'MD', N'21060', 21.75),
(N'284-005', N'Anne', N'Laura', N'Wine', N'SLVSSL', N'Cashier', N'4137 Chivas Crt', N'Silver Spring', N'MD', N'20910', 16.68);
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, MiddleName, LastName, LocationCode, Title, [Address], City, [State], ZIPCode, PhoneNumber , HourlySalary)
VALUES(N'864-808', N'Mark', N'Richard', N'Georges', N'CPKUMD', N'Intern', N'1101 Elon Rd', N'Takoma Park', N'MD', N'20912', N'(202) 719-7335', 7.12);
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, MiddleName, LastName, LocationCode, Title, CanCreateAccount, [Address], City, [State], ZIPCode, HourlySalary)
VALUES(N'533-825', N'Aaron', N'Robert', N'Kast', N'WHTFLT', N'Accounts Manager', 1, N'2991 Justine Ave.', N'Rockville', N'MD', N'20854', 24.34);
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, MiddleName, LastName, LocationCode, Title, [Address], City, [State], ZIPCode, HourlySalary)
VALUES(N'712-083', N'Wendy', N'Noella', N'Huntsmann', N'WHTFLT', N'Cashier', N'13622 Washington Blvd', N'Laurel', N'MD', N'20707', 18.34),
(N'308-406', N'Jessica', N'Ernestine', N'Roland', N'ALXJPZ', N'Intern', N'3775 17th St NW', N'Washington', N'DC', N'200014', 12.72);
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, MiddleName, LastName, LocationCode, Title, CanCreateAccount, [Address], City, [State], ZIPCode, HourlySalary)
VALUES(N'209-400', N'Krista', N'Daniela', N'Cole', N'SLVSSL', N'Branch Manager', 1, N'1026 Jacktown St', N'Baltimore', N'MD', N'21205', 28.55);
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, LastName, LocationCode, Title, [Address], City, [State], ZIPCode, HourlySalary)
VALUES(N'660-026', N'Lucas', N'Frieddle', N'SLVSSL', N'Cashier', N'8252 Eleven Sons Rd', N'College Park', N'MD', N'20740', 16.24);
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, MiddleName, LastName, LocationCode, Title, CanCreateAccount, [Address], City, [State], ZIPCode, HourlySalary)
VALUES(N'280-082', N'Geoffrey', N'Robert', N'Coleman', N'SLVSSL', N'Head Cashier', 1, N'828 John Booker St', N'Chevy Chase', N'MD', N'20851', 22.82),
(N'484-050', N'Marianne', N'Becky', N'Oslin', N'WHTFLT', N'Assistant Manager', 1, N'104 G St. S. E.', N'Washington', N'DC', N'20012', 26.86);
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, MiddleName, LastName, LocationCode, Title, [Address], City, [State], ZIPCode, PhoneNumber , HourlySalary)
VALUES(N'624-993', N'Kirsten', N'Pennie', N'Roberts', N'WHTFLT', N'Intern', N'1336 Philadelphia St', N'Baltimore', N'MD', N'21207', N'(410) 653-1309', 8.05);
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, LastName, LocationCode, Title, [Address], City, [State], ZIPCode, HourlySalary)
VALUES(N'462-777', N'Ada', N'Zeran', N'SLVSSL', N'Administrative Assistant', N'992 White Horse Rd', N'Hyattsville', N'MD', N'20782', 15.48);
GO
INSERT INTO Management.Employees(EmployeeNumber, FirstName, MiddleName, LastName, LocationCode, Title, [Address], City, [State], ZIPCode, HourlySalary)
VALUES(N'829-313', N'Simon', N'Eddy', N'Michaels', N'CPKUMD', N'Cashier', N'1336 Philadelphia St.', N'Baltimore', N'MD', N'21206', 18.05);
GO
INSERT INTO Accounts.Customers(AccountNumber, DateCreated, EmployeeNumber, AccountType, FirstName, LastName, [Address], City, [State], ZIPCode, PhoneNumber, AccountStatus)
VALUES(N'20-304042-49', N'20130104', N'952-846', N'Checking', N'Ophellie', N'Wyman', N'104 G St. S. E.', N'Washington', N'DC', N'20005', N'(202) 622-8674', N'Active');
GO
INSERT INTO Accounts.Customers(AccountNumber, DateCreated, EmployeeNumber, AccountType, FirstName, MiddleName, LastName, [Address], City, [State], ZIPCode, PhoneNumber, AccountStatus)
VALUES(N'68-304605-84', N'20130104', N'294-075', N'Checking', N'Jonathan', N'Horace', N'Myler', N'9337 Cachet St', N'Arlington', N'VA', N'20140', N'(703) 554-8724', N'Active');
GO
INSERT INTO Accounts.Customers(AccountNumber, DateCreated, EmployeeNumber, AccountType, FirstName, LastName, [Address], City, [State], ZIPCode, PhoneNumber, WorkPhone, AccountStatus)
VALUES(N'94-477085-03', N'20130112', N'507-728', N'Saving', N'Ismail', N'Zorbah', N'2888 Gwett Richards Av.', N'Rockville', N'MD', N'20815', N'(301) 478-8244', N'(301) 726-8224', N'Active');
GO
INSERT INTO Accounts.Customers(AccountNumber, DateCreated, EmployeeNumber, AccountType, FirstName, MiddleName, LastName, [Address], City, [State], ZIPCode, PhoneNumber, WorkPhone, AccountStatus)
VALUES(N'28-370082-80', N'20130112', N'461-842', N'Saving', N'Gloria', N'Aldridge', N'Wright', N'1022 Arlington Rd', N'Arlington', N'VA', N'20164', N'(703) 645-1492', N'(703) 450-5577', N'Active'),
(N'27-314257-84', N'20130112', N'484-050', N'Checking', N'Robert', N'Daniel', N'Luner', N'802 Lilas Ave', N'Baltimore', N'MD', N'21207', N'(410) 321-6730', N'(410) 5391135', N'Active'),
(N'38-402217-59', N'20130112', N'507-728', N'Checking', N'James', N'Scott', N'Schneider', N'1277 Cecil Maurice Av.', N'Chevy Chase', N'MD', N'20815', N'(301) 768-4024', N'(301) 570-5227', N'Active');
GO
INSERT INTO Accounts.Customers(AccountNumber, DateCreated, EmployeeNumber, AccountType, FirstName, LastName, [Address], City, [State], ZIPCode, PhoneNumber, AccountStatus)
VALUES(N'68-640304-15', N'20130116', N'492-081', N'Checking', N'Eldridge', N'Powers', N'273 South Independence Ave', N'Alexandria', N'VA', N'20185', N'(703) 622-7188', N'Active');
GO
INSERT INTO Accounts.Customers(AccountNumber, DateCreated, EmployeeNumber, AccountType, FirstName, MiddleName, LastName, [Address], City, [State], ZIPCode, PhoneNumber, AccountStatus)
VALUES(N'30-514090-26', N'20130118', N'461-842', N'Checking', N'Cherrine', N'Leonie', N'Horvath', N'720 Oak Tree Rd', N'Laurel', N'MD', N'20707', N'(301) 549-0002', N'Active');
GO
INSERT INTO Accounts.Customers(AccountNumber, DateCreated, EmployeeNumber, AccountType, FirstName, LastName, [Address], City, [State], ZIPCode, PhoneNumber, AccountStatus)
VALUES(N'40-460582-63', N'20130125', N'484-050', N'CD', N'Mellinda', N'Bridges', N'1336 Philadelphia St', N'Takoma Park', N'MD', N'20908', N'(301) 812-4428', N'Active');
GO
INSERT INTO Accounts.Customers(AccountNumber, DateCreated, EmployeeNumber, AccountType, FirstName, MiddleName, LastName, [Address], City, [State], ZIPCode, PhoneNumber, AccountStatus)
VALUES(N'29-425806-46', N'20130125', N'461-842', N'Checking', N'Albert', N'Sonny', N'Odonnell', N'12 16th St. SW', N'Washington', N'DC', N'20004', N'(301) 812-4442', N'Active'),
(N'84-697064-28', N'20130130', N'209-400', N'CD', N'Xavier', N'Lenny', N'Hereford', N'992 White Horse Rd', N'Bethesda', N'MD', N'20875', N'(301) 631-8228', N'Active');
GO
INSERT INTO Accounts.Customers(AccountNumber, DateCreated, EmployeeNumber, AccountType, FirstName, MiddleName, LastName, [Address], City, [State], ZIPCode, PhoneNumber, WorkPhone, AccountStatus)
VALUES(N'92-037082-42', N'20130202', N'952-846', N'Checking', N'Chrissy', N'Arlene', N'McMahon', N'845 Arcadia Ave. #1512', N'Rockville', N'MD', N'20872', N'(301) 684-2828', N'(301) 723-1882', N'Active');
GO
INSERT INTO Accounts.Customers(AccountNumber, DateCreated, EmployeeNumber, AccountType, FirstName, MiddleName, LastName, [Address], City, [State], ZIPCode, PhoneNumber, AccountStatus)
VALUES(N'44-504058-04', N'20130202', N'461-842', N'Saving', N'Leonel', N'James', N'Harbor', N'308 Capitol Blvd', N'Washington', N'DC', N'20010', N'(202) 439-2864', N'Active'),
(N'82-370863-62', N'20130206', N'492-081', N'Checking', N'Liliana', N'Wellie', N'Ortez', N'4445 Blue Oak St. #6A', N'Chevy Chase', N'MD', N'20875', N'(301) 821-4990', N'Active');
GO
INSERT INTO Accounts.Customers(AccountNumber, DateCreated, EmployeeNumber, AccountType, FirstName, LastName, [Address], City, [State], ZIPCode, PhoneNumber, AccountStatus)
VALUES(N'51-842068-25', N'20130206', N'552-884', N'Checking', N'Barry', N'Parrang', N'58 North Assault St', N'Chantilly', N'VA', N'20102', N'(703) 622-6460', N'Active'),
(N'47-474083-29', N'20130206', N'952-846', N'Checking', N'Annette', N'Benson', N'15328 Crystal St', N'Hyattsville', N'MD', N'20782', N'(301) 723-5656', N'Suspended');
GO
INSERT INTO Accounts.Customers(AccountNumber, DateCreated, EmployeeNumber, AccountType, FirstName, MiddleName, LastName, [Address], City, [State], ZIPCode, PhoneNumber, AccountStatus)
VALUES(N'72-903175-44', N'20130208', N'209-400', N'Saving', N'Jabouni', N'Cabasco', N'Toussey', N'2991 Justine Ave', N'Silver Spring', N'MD', N'20912', N'(301) 872-8272', N'Active'),
(N'84-975004-57', N'20130208', N'294-075', N'Saving', N'Marthe', N'Helene', N'Bradley', N'13622 Washington Blvd', N'Laurel', N'MD', N'20707', N'(301) 478-6602', N'Suspended'),
(N'76-504275-24', N'20130208', N'507-728', N'Checking', N'Joseph', N'Patrick', N'Honey', N'3832 Great River Rd', N'Vienna', N'VA', N'20171', N'(703) 350-2006', N'Active');
GO
INSERT INTO Accounts.Customers(AccountNumber, DateCreated, EmployeeNumber, AccountType, FirstName, LastName, [Address], City, [State], ZIPCode, PhoneNumber, WorkPhone, AccountStatus)
VALUES(N'83-462584-73', N'20130214', N'533-825', N'Checking', N'Hobert', N'Spampinato', N'8254 12th St. N.E.', N'Washington', N'DC', N'20008', N'(202) 927-1040', N'(301) 726-8426', N'Suspended');
GO
INSERT INTO Accounts.Customers(AccountNumber, DateCreated, EmployeeNumber, AccountType, FirstName, LastName, [Address], City, [State], ZIPCode, PhoneNumber, AccountStatus)
VALUES(N'72-304724-26', N'20130308', N'952-846', N'Saving', N'Ornella', N'Maiwand', N'8252 Eleven Sons Rd', N'Arlington', N'VA', N'20150', N'(703) 681-9022', N'Active');
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance, Notes)
VALUES(N'SLVSSL', N'952-846', N'20-304042-49', N'20130104', N'10:26 AM', N'Deposit', N'Cash', 325, 325, N'Deposit for a new bank account'),
(N'ALXJPZ', N'294-075', N'68-304605-84', N'20130104', N'10:22 AM', N'Deposit', N'Check', 1128.64, 1128.64, N'Deposit for a new bank account');
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance)
VALUES(N'CPKUMD', N'280-082', N'94-477085-03', N'20130105', N'02:02 PM', N'Deposit', N'Check', 220, 220);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, WithdrawalAmount, HasEnoughFunds, Balance)
VALUES(N'0SSCTPL', N'000-100', N'20-304042-49', N'20130110', N'09:14 AM', N'Withdrawal', N'Cash', 100, 1, 225);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance, Notes)
VALUES(N'SLVSSL', N'952-846', N'27-314257-84', N'20130112', N'09:12 AM', N'Deposit', N'Check', 500, 500, N'Deposit for a new bank account'),
(N'ALXJPZ', N'552-884', N'28-370082-80', N'20130112', N'09:14 AM', N'Deposit', N'Check', 2500, 2500, N'Deposit for a new bank account'),
(N'WHTFLT', N'533-825', N'38-402217-59', N'20130112', N'10:02 AM', N'Deposit', N'Check', 975.35, 975.35, N'Deposit for a new bank account');
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance)
VALUES(N'GTWMST', N'533-825', N'68-304605-84', N'20130112', N'03:05 PM', N'Deposit', N'Check', 885.27, 2013.91);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, WithdrawalAmount, HasEnoughFunds, Balance)
VALUES(N'ALXJPZ', N'294-075', N'94-477085-03', N'20130114', N'09:48 AM', N'Withdrawal', N'Cash', 50, 1, 170);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance)
VALUES(N'SLVSSL', N'284-005', N'27-314257-84', N'20130116', N'01:52 PM', N'Deposit', N'Check', 338.92, 838.92);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, WithdrawalAmount, HasEnoughFunds, Balance)
VALUES(N'0GRNML', N'000-100', N'27-314257-84', N'20130116', N'07:16 AM', N'Withdrawal', N'Cash', 300, 1, 538.92);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance, Notes)
VALUES(N'GTWMST', N'492-081', N'68-640304-15', N'20130116', N'01:24 PM', N'Deposit', N'Check', 842.46, 842.46, N'Deposit for a new bank account');
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, WithdrawalAmount, HasEnoughFunds, Balance)
VALUES(N'DCK10S', N'736-626', N'20-304042-49', N'20130118', N'09:22 AM', N'Withdrawal', N'Check', 148.84, 1, 76.16),
(N'CPKUMD', N'000-100', N'27-314257-84', N'20130118', N'07:16 AM', N'Withdrawal', N'Cash', 300, 1, 238.92);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance, Notes)
VALUES(N'CPKUMD', N'461-842', N'30-514090-26', N'20130118', N'11:26 AM', N'Deposit', N'Cash', 750, 750, N'Deposit for a new bank account');
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, WithdrawalAmount, HasEnoughFunds, Balance)
VALUES(N'CPKUMD', N'248-552', N'27-314257-84', N'20130120', N'09:14 AM', N'Withdrawal', N'Cash', 40, 0, -1.08),
(N'GTWMST', N'482-799', N'38-402217-59', N'20130120', N'05:51 PM', N'Withdrawal', N'Cash', 200, 1, 775.35),
(N'0LNFPL', N'000-100', N'27-314257-84', N'20130122', N'06:12 AM', N'Withdrawal', N'Cash', 200, 1, 38.92),
(N'GTWMST', N'533-825', N'94-477085-03', N'20130122', N'02:07 PM', N'Withdrawal', N'Cash', 100, 1, 70);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance)
VALUES(N'WHTFLT', N'712-083', N'27-314257-84', N'20130124', N'03:14 PM', N'Deposit', N'Cash', 100, 98.92),
(N'WHTFLT', N'829-313', N'38-402217-59', N'20130124', N'10:05 AM', N'Deposit', N'Check', 186.24, 961.59);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, WithdrawalAmount, HasEnoughFunds, Balance)
VALUES(N'0GRNML', N'000-100', N'20-304042-49', N'20130125', N'05:12 AM', N'Withdrawal', N'Cash', 80, 0, -3.84);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance)
VALUES(N'CPKUMD', N'461-842', N'29-425806-46', N'20130125', N'09:14 AM', N'Deposit', N'Cash', 40, 40),
(N'0SSCTPL', N'000-100', N'38-402217-59', N'20130125', N'06:22 AM', N'Deposit', N'Check', 448.62, 1410.21);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance, Notes)
VALUES(N'WHTFLT', N'484-050', N'40-460582-63', N'20130125', N'11:28 AM', N'Deposit', N'Cash', 2000, 2000, N'New CD Account');
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance)
VALUES(N'SLVSSL', N'284-005', N'68-640304-15', N'20130125', N'11:59 AM', N'Deposit', N'Cash', 400, 1242.46);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, WithdrawalAmount, HasEnoughFunds, Balance, Notes)
VALUES(N'1ONLIN', N'111-111', N'27-314257-84', N'20130126', N'10:06 PM', N'Withdrawal', N'Check', 105.86, 0, -6.94, N'Online purchase');
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, WithdrawalAmount, HasEnoughFunds, Balance)
VALUES(N'SLVSSL', N'736-626', N'30-514090-26', N'20130126', N'02:41 PM', N'Withdrawal', N'Cash', 200, 1, 550);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance)
VALUES(N'ALXJPZ', N'294-075', N'82-370863-62', N'20130126', N'10:26 AM', N'Deposit', N'Check', 765, 765);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, ChargeAmount, ChargeReason, Balance)
VALUES(N'SLVSSL', N'000-200', N'20-304042-49', N'20130130', N'12:00 AM', N'Service Charge', N'Cash', 35, N'Overdraft', -38.84),
(N'SLVSSL', N'000-200', N'20-304042-49', N'20130130', N'12:00 AM', N'Service Charge', N'Cash', 6, N'Monthly Charge', -44.84);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, ChargeAmount, ChargeReason, Balance, Notes)
VALUES(N'SLVSSL', N'000-200', N'27-314257-84', N'20130130', N'12:00 AM', N'Service Charge', N'Cash', 35, N'Overdraft', -47.94, N'Overdraft penalty');
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, ChargeAmount, ChargeReason, Balance)
VALUES(N'SLVSSL', N'000-200', N'27-314257-84', N'20130130', N'12:00 AM', N'Service Charge', N'Cash', 6, N'Monthly Charge', -12.94)
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance)
VALUES(N'CPKUMD', N'481-114', N'29-425806-46', N'20130130', N'11:15 AM', N'Deposit', N'Check', 4418.64, 4458.64);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, ChargeAmount, ChargeReason, Balance)
VALUES(N'SLVSSL', N'000-200', N'29-425806-46', N'20130130', N'12:00 AM', N'Service Charge', N'Cash', 6, N'Monthly Charge', 4452.64),
(N'SLVSSL', N'000-200', N'30-514090-26', N'20130130', N'12:00 AM', N'Service Charge', N'Cash', 6, N'Monthly Charge', 544),
(N'SLVSSL', N'000-200', N'38-402217-59', N'20130130', N'12:00 AM', N'Service Charge', N'Cash', 6, N'Monthly Charge', 1404.21);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, WithdrawalAmount, HasEnoughFunds, Balance)
VALUES(N'GTWMST', N'533-825', N'68-304605-84', N'20130130', N'09:39 AM', N'Withdrawal', N'Cash', 300, 1, 1713.04);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance, Notes)
VALUES(N'SLVSSL', N'503-938', N'84-697064-28', N'20130130', N'03:17 PM', N'Deposit', N'Cash', 2000, 2000, N'New CD account');
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance)
VALUES(N'SLVSSL', N'660-026', N'20-304042-49', N'20130131', N'09:12 AM', N'Deposit', N'Cash', 500, 455.16);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, ChargeAmount, ChargeReason, Balance)
VALUES(N'SLVSSL', N'000-200', N'68-304605-84', N'20130131', N'12:00 AM', N'Service Charge', N'Cash', 6, N'Monthly Charge', 1707.91),
(N'SLVSSL', N'000-200', N'94-477085-03', N'20130131', N'12:00 AM', N'Service Charge', N'Cash', 6, N'Monthly Charge', 64);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance)
VALUES(N'WHTFLT', N'552-884', N'40-460582-63', N'20130201', N'11:01 AM', N'Deposit', N'Cash', 1500, 3500),
(N'0SSCTPL', N'000-100', N'20-304042-49', N'20130202', N'10:06 PM', N'Deposit', N'Check', 328.74, 783.9);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, WithdrawalAmount, HasEnoughFunds, Balance)
VALUES(N'SLVSSL', N'660-026', N'30-514090-26', N'20130202', N'02:53 PM', N'Withdrawal', N'Cash', 100, 1, 244),
(N'SLVSSL', N'660-026', N'30-514090-26', N'20130202', N'02:54 PM', N'Withdrawal', N'Cash', 200, 1, 344);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance, Notes)
VALUES(N'CPKUMD', N'461-842', N'44-504058-04', N'20130202', N'09:55 AM', N'Deposit', N'Check', 2500, 2500, N'Account Creation');
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, ChargeAmount, ChargeReason, Balance)
VALUES(N'SLVSSL', N'000-200', N'94-477085-03', N'20130202', N'12:00 AM', N'Service Charge', N'Cash', 35, N'NSF', -31);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, WithdrawalAmount, HasEnoughFunds, Balance)
VALUES(N'GTWMST', N'503-938', N'94-477085-03', N'20130202', N'09:58 AM', N'Withdrawal', N'Cash', 60, 1, 4),
(N'WHTFLT', N'533-825', N'30-514090-26', N'20130203', N'09:22 AM', N'Withdrawal', N'Check', 252.48, 0, -8.48);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance)
VALUES(N'0WPLZM', N'000-100', N'38-402217-59', N'20130205', N'06:22 PM', N'Deposit', N'Check', 725.5, 2129.71);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, WithdrawalAmount, HasEnoughFunds, Balance)
VALUES(N'0WPLZM', N'000-100', N'38-402217-59', N'20130205', N'06:44 PM', N'Withdrawal', N'Cash', 200, 1, 1929.71);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance)
VALUES(N'0UNSDC', N'000-100', N'27-314257-84', N'20130206', N'06:24 PM', N'Deposit', N'Cash', 200, 152.06);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, WithdrawalAmount, HasEnoughFunds, Balance)
VALUES(N'0UNSDC', N'000-100', N'27-314257-84', N'20130206', N'06:15 PM', N'Withdrawal', N'Cash', 100, 1, 52.06);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance)
VALUES(N'WHTFLT', N'484-050', N'30-514090-26', N'20130206', N'09:56 AM', N'Deposit', N'Cash', 200, 191.52);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance, Notes)
VALUES(N'SLVSSL', N'952-846', N'47-474083-29', N'20130206', N'10:14 AM', N'Deposit', N'Cash', 40, 40, N'Deposit for a new bank account'),
(N'WHTFLT', N'533-825', N'51-842068-25', N'20130206', N'09:44 AM', N'Deposit', N'Cash', 200, 200, N'Deposit for a new bank account');
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, Recipient, HasEnoughFunds, ChargeAmount, ChargeReason, Balance, Notes)
VALUES(N'SLVSSL', N'284-005', N'94-477085-03', N'20130206', N'10:24 AM', N'Check Cashing', N'Check', N'Adventist Hospital', 0, 35, N'NSF', -31, N'A check of 92.45 came for the account but there were not enough funds. A service charge of $25 was applied to the account and a mail was sent to the customer.');
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, WithdrawalAmount, HasEnoughFunds, Balance)
VALUES(N'0WPLZM', N'000-100', N'30-514090-26', N'20130207', N'06:15 PM', N'Withdrawal', N'Check', 195.85, 0, -4.33);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance)
VALUES(N'0WTFML', N'000-100', N'47-474083-29', N'20130207', N'06:52 PM', N'Deposit', N'Cash', 320, 360);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, WithdrawalAmount, HasEnoughFunds, Balance)
VALUES(N'0CLGPK', N'000-100', N'20-304042-49', N'20130208', N'12:26 PM', N'Withdrawal', N'Cash', 60, 1, 723.9),
(N'0SSCTPL', N'000-100', N'20-304042-49', N'20130208', N'04:22 PM', N'Withdrawal', N'Cash', 200, 1, 523.9),
(N'0UNSDC', N'000-100', N'27-314257-84', N'20130208', N'06:05 PM', N'Withdrawal', N'Cash', 60, 0, -7.94),
(N'CPKUMD', N'461-842', N'47-474083-29', N'20130208', N'12:52 PM', N'Withdrawal', N'Cash', 200, 1, 160);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance, Notes)
VALUES(N'SLVSSL', N'209-400', N'72-903175-44', N'20130208', N'02:58 PM', N'Deposit', N'Direct Deposit', 3644.88, 3644.88, N'Deposit for a new bank account'),
(N'WHTFLT', N'507-728', N'76-504275-24', N'20130208', N'11:24 AM', N'Deposit', N'Check', 225.85, 225.85, N'Deposit for a new bank account'),
(N'CPKUMD', N'248-552', N'84-975004-57', N'20130208', N'10:08 AM', N'Deposit', N'Check', 1424.84, 1424.84, N'New savings account');
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, WithdrawalAmount, HasEnoughFunds, Balance)
VALUES(N'GTWMST', N'552-884', N'20-304042-49', N'20130210', N'11:09 PM', N'Withdrawal', N'Check', 120, 1, 403.9);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance)
VALUES(N'0WTFML', N'000-100', N'28-370082-80', N'20130210', N'05:48 AM', N'Deposit', N'Cash', 2225, 4725),
(N'GTWMST', N'484-050', N'30-514090-26', N'20130210', N'10:14 AM', N'Deposit', N'Check', 20, 15.67);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, WithdrawalAmount, HasEnoughFunds, Balance)
VALUES(N'0WTFML', N'000-100', N'47-474083-29', N'20130210', N'04:24 PM', N'Withdrawal', N'Cash', 40, 1, 120);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance)
VALUES(N'SLVSSL', N'284-725', N'20-304042-49', N'20130214', N'10:09 AM', N'Deposit', N'Check', 200, 603.9),
(N'0UNSDC', N'000-100', N'27-314257-84', N'20130214', N'10:08 AM', N'Deposit', N'Cash', 500, 492.06),
(N'CPKUMD', N'461-842', N'29-425806-46', N'20130214', N'10:26 AM', N'Deposit', N'Check', 3825.55, 8278.19);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, WithdrawalAmount, HasEnoughFunds, Balance)
VALUES(N'0CLGPK', N'000-100', N'30-514090-26', N'20130214', N'07:04 PM', N'Withdrawal', N'Cash', 24.95, 0, -9.28);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance)
VALUES(N'SLVSSL', N'952-846', N'83-462584-73', N'20130214', N'01:05 PM', N'Deposit', N'Cash', 500, 500),
(N'WHTFLT', N'507-728', N'30-514090-26', N'20130215', N'12:05 PM', N'Deposit', N'Check', 428.55, 419.27),
(N'GTWMST', N'492-081', N'47-474083-29', N'20130215', N'02:03 PM', N'Deposit', N'Check', 148.82, 268.82);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, WithdrawalAmount, HasEnoughFunds, Balance)
VALUES(N'0GRNML', N'000-100', N'20-304042-49', N'20130216', N'06:08 PM', N'Withdrawal', N'Cash', 100, 1, 503.9);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance)
VALUES(N'SLVSSL', N'209-400', N'76-504275-24', N'20130217', N'10:00 AM', N'Deposit', N'Check', 845.68, 1071.53);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, WithdrawalAmount, HasEnoughFunds, Balance, Notes)
VALUES(N'1ONLIN', N'111-111', N'20-304042-49', N'20130220', N'12:00 AM', N'Withdrawal', N'Check', 88.26, 1, 415.64, N'Online purchase');
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, WithdrawalAmount, HasEnoughFunds, Balance)
VALUES(N'GTWMST', N'503-938', N'47-474083-29', N'20130220', N'02:11 PM', N'Withdrawal', N'Cash', 80, 1, 188.82);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance)
VALUES(N'SLVSSL', N'660-026', N'20-304042-49', N'20130222', N'09:42 AM', N'Deposit', N'Cash', 2448.52, 2864.16);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, WithdrawalAmount, HasEnoughFunds, Balance)
VALUES(N'0LNFPL', N'000-100', N'27-314257-84', N'20130222', N'05:02 PM', N'Withdrawal', N'Cash', 100, 1, 392.06),
(N'WHTFLT', N'552-884', N'47-474083-29', N'20130222', N'11:23 AM', N'Withdrawal', N'Cash', 32, 1, 156.82);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance)
VALUES(N'WHTFLT', N'280-082', N'51-842068-25', N'20130222', N'03:25 PM', N'Deposit', N'Cash', 500, 700),
(N'SLVSSL', N'000-200', N'27-314257-84', N'20130224', N'12:00 AM', N'Deposit', N'Check', 1258.72, 1650.78);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, WithdrawalAmount, HasEnoughFunds, Balance)
VALUES(N'ALXJPZ', N'552-884', N'30-514090-26', N'20130224', N'02:06 PM', N'Withdrawal', N'Check', 358.25, 1, 61.02);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance)
VALUES(N'GTWMST', N'533-825', N'68-304605-84', N'20130227', N'12:00 AM', N'Deposit', N'Check', 1622.54, 3330.45),
(N'CPKUMD', N'829-313', N'27-314257-84', N'20130228', N'09:38 AM', N'Deposit', N'Check', 1322.64, 2973.42);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, ChargeAmount, ChargeReason, Balance)
VALUES(N'SLVSSL', N'000-200', N'27-314257-84', N'20130228', N'12:00 AM', N'Service Charge', N'Cash', 6, N'Monthly Charge', 2967.42);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance)
VALUES(N'CPKUMD', N'492-081', N'30-514090-26', N'20130228', N'11:02 AM', N'Deposit', N'Check', 245.53, 306.55),
(N'GTWMST', N'481-114', N'30-514090-26', N'20130228', N'09:42 AM', N'Deposit', N'Check', 120.44, 426.99);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, ChargeAmount, ChargeReason, Balance)
VALUES(N'SLVSSL', N'000-200', N'30-514090-26', N'20130228', N'12:00 AM', N'Service Charge', N'Cash', 6, N'Monthly Charge', 420.99),
(N'SLVSSL', N'000-200', N'51-842068-25', N'20130228', N'02:01 PM', N'Service Charge', N'Cash', 6, N'Monthly Charge', 694),
(N'SLVSSL', N'000-200', N'68-304605-84', N'20130228', N'12:00 AM', N'Service Charge', N'Cash', 6, N'Monthly Charge', 3324.45),
(N'SLVSSL', N'000-200', N'94-477085-03', N'20130228', N'12:00 AM', N'Service Charge', N'Cash', 6, N'Monthly Charge', -37),
(N'SLVSSL', N'000-200', N'94-477085-03', N'20130228', N'12:00 AM', N'Service Charge', N'Cash', 35, N'NSF', -72);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance)
VALUES(N'CPKUMD', N'481-114', N'27-314257-84', N'20130301', N'10:26 AM', N'Deposit', N'Check', 808.12, 3775.54),
(N'SLVSSL', N'462-777', N'30-514090-26', N'20130301', N'02:57 PM', N'Deposit', N'Cash', 328.45, 749.44),
(N'WHTFLT', N'484-050', N'40-460582-63', N'20130301', N'09:38 AM', N'Deposit', N'Cash', 1000, 4500);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, WithdrawalAmount, HasEnoughFunds, Balance)
VALUES(N'CPKUMD', N'829-313', N'27-314257-84', N'20130305', N'01:46 PM', N'Withdrawal', N'Cash', 1000, 1, 2775.54);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance)
VALUES(N'SLVSSL', N'294-075', N'47-474083-29', N'20130306', N'10:49 AM', N'Deposit', N'Cash', 20, 176.82),
(N'GTWMST', N'492-081', N'51-842068-25', N'20130306', N'03:20 PM', N'Deposit', N'Check', 1248.64, 1942.64);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance, Notes)
VALUES(N'SLVSSL', N'952-846', N'72-304724-26', N'20130308', N'09:12 AM', N'Deposit', N'Check', 1426.94, 1426.94, N'Deposit for a new bank account');
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, DepositAmount, Balance)
VALUES(N'0SSMTR', N'000-100', N'28-370082-80', N'20130312', N'12:48 PM', N'Deposit', N'Check', 2428.48, 7153.48);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, CheckNumber, CheckAmount, Recipient, HasEnoughFunds, Balance)
VALUES(N'CPKUMD', N'248-552', N'68-304605-84', N'20130315', N'11:22 AM', N'Check Cashing', N'Check', 100, 124.38, N'Washington Electric Company', 1, 3200.07),
(N'1ONLIN', N'111-111', N'27-314257-84', N'20130316', N'01:14 AM', N'Check Cashing', N'Check', 122, 64.25, N'BooksOnline.com', 1, 2711.75),
(N'ALXJPZ', N'428-947', N'20-304042-49', N'20130322', N'09:12 AM', N'Check Cashing', N'Check', 101, 275.85, N'Barriston Communications', 1, 2588.31);
GO
INSERT INTO Accounts.Transactions(LocationCode, EmployeeNumber, AccountNumber, TransactionDate, TransactionTime, TransactionType, CurrencyType, CheckNumber, Recipient, HasEnoughFunds, ChargeAmount, ChargeReason, Balance, Notes)
VALUES(N'SLVSSL', N'736-626', N'47-474083-29', N'20130322', N'11:08 AM', N'Check Cashing', N'Check', 100, N'Route 1 Electronics', 0, 35, N'NSF', 151.08, N'A check of 200 was presented with no sufficient funds. A service charge was applied against the account and a post mail was sent to the customer.');
GO
INSERT INTO Accounts.Histories(AccountNumber, AccountStatus, DateChanged, ShortNote)
VALUES(N'20-304042-49', N'Active', N'20130104', N'Account Created'),
(N'94-477085-03', N'Active', N'20130105', N'Account Created'),
(N'27-314257-84', N'Active', N'20130112', N'Account Created'),
(N'28-370082-80', N'Active', N'20130112', N'Account Created');
GO
INSERT INTO Accounts.Histories(AccountNumber, AccountStatus, DateChanged, ShortNote, DetailedNotes)
VALUES(N'38-402217-59', N'Active', N'20130112', N'Account Created', N'The account has been re-actived.');
GO
INSERT INTO Accounts.Histories(AccountNumber, AccountStatus, DateChanged, ShortNote)
VALUES(N'30-514090-26', N'Active', N'20130118', N'Account Created');
GO
INSERT INTO Accounts.Histories(AccountNumber, AccountStatus, DateChanged, ShortNote, DetailedNotes)
VALUES(N'27-314257-84', N'Suspended', N'20130120', N'Suspended for overdraft', N'The account was suspended for overdraft'),
(N'27-314257-84', N'Active', N'20130122', N'Active', N'Account brought back to a positive balance');
GO
INSERT INTO Accounts.Histories(AccountNumber, AccountStatus, DateChanged, ShortNote)
VALUES(N'29-425806-46', N'Active', N'20130125', N'Account Created'),
(N'40-460582-63', N'Active', N'20130125', N'New CD Account Creation'),
(N'27-314257-84', N'Suspended', N'20130126', N'Account Suspended'),
(N'20-304042-49', N'Suspended', N'20130130', N'Suspended for overdraft'),
(N'20-304042-49', N'Active', N'20130131', N'Re-activated after deposit'),
(N'44-504058-04', N'Active', N'20130202', N'Account Created');
GO
INSERT INTO Accounts.Histories(AccountNumber, AccountStatus, DateChanged, DetailedNotes)
VALUES(N'94-477085-03', N'Suspended', N'20130202', N'The account was suspended for non-sufficient funds');
GO
INSERT INTO Accounts.Histories(AccountNumber, AccountStatus, DateChanged, ShortNote, DetailedNotes)
VALUES(N'94-477085-03', N'Active', N'20130202', N'Balance restored', N'The account was re-activated after the customer deposited enough fund to cover the negative balance.'),
(N'30-514090-26', N'Suspended', N'20130203', N'Account Suspended', N'The account was suspended because it became negative.');
GO
INSERT INTO Accounts.Histories(AccountNumber, AccountStatus, DateChanged, ShortNote)
VALUES(N'27-314257-84', N'Active', N'20130206', N'Balance restored'),
(N'30-514090-26', N'Active', N'20130206', N'Balance restored');
GO
INSERT INTO Accounts.Histories(AccountNumber, AccountStatus, DateChanged, ShortNote, DetailedNotes)
VALUES(N'47-474083-29', N'Active', N'20130206', N'Account Created', N'The account has been re-actived.');
GO
INSERT INTO Accounts.Histories(AccountNumber, AccountStatus, DateChanged)
VALUES(N'94-477085-03', N'Suspended', N'20130206');
GO
INSERT INTO Accounts.Histories(AccountNumber, AccountStatus, DateChanged, ShortNote, DetailedNotes)
VALUES(N'30-514090-26', N'Suspended', N'20130207', N'Account Suspended', N'The account was suspended because it became negative.');
GO
INSERT INTO Accounts.Histories(AccountNumber, AccountStatus, DateChanged, ShortNote)
VALUES(N'27-314257-84', N'Suspended', N'20130208', N'Account Suspended'),
(N'68-304605-84', N'Active', N'20130208', N'Account Created'),
(N'30-514090-26', N'Active', N'20130210', N'Balance restored'),
(N'27-314257-84', N'Active', N'20130214', N'Balance restored');
GO
INSERT INTO Accounts.Histories(AccountNumber, AccountStatus, DateChanged, ShortNote, DetailedNotes)
VALUES(N'30-514090-26', N'Suspended', N'20130214', N'Account Suspended', N'The account has been re-actived.');
GO
INSERT INTO Accounts.Histories(AccountNumber, AccountStatus, DateChanged, ShortNote)
VALUES(N'30-514090-26', N'Active', N'20130215', N'Balance restored'),
(N'51-842068-25', N'Active', N'20130316', N'Account Created');
GO