-- phpMyAdmin SQL Dump -- version 3.2.4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jun 29, 2011 at 10:54 PM -- Server version: 5.1.41 -- PHP Version: 5.3.1 SET FOREIGN_KEY_CHECKS =0; SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: 'RUTADEMIC' -- -- -- Dumping data for table 'academic_area' -- INSERT INTO academic_area (serial_aca, name_aca, description_aca, status_aca) VALUES (1, 'Matematicas', 'Matematicas', 'ACTIVE'), (2, 'Idiomas', 'Idiomas', 'ACTIVE'), (3, 'Sociales', 'Sociales', 'ACTIVE'), (4, 'Artes', 'Artes', 'ACTIVE'), (5, 'Ciencias Naturales', 'Ciencias Naturales', 'ACTIVE'); -- -- Dumping data for table 'access_log' -- -- -- Dumping data for table 'activity' -- -- -- Dumping data for table 'activity_applied_criterias' -- -- -- Dumping data for table 'activity_attachment' -- -- -- Dumping data for table 'activity_policy_violations' -- -- -- Dumping data for table 'activity_type' -- INSERT INTO activity_type (serial_att, name_att, description_att, status_att) VALUES (1, 'Disciplina', 'Disciplina', 'ACTIVE'), (2, 'Deberes', 'Deberes', 'ACTIVE'), (3, 'Actuacion en clases', 'Actuacion en clases', 'ACTIVE'), (4, 'Prueba', 'Prueba', 'ACTIVE'); -- -- Dumping data for table 'allowed_pages_by_process' -- -- -- Dumping data for table 'article' -- INSERT INTO article (serial_art, code_art, name_art, stock_art, status_art) VALUES (1, '000001', 'Uniforme', 100, 'ACTIVE'), (2, '000002', 'Hojas', 200000, 'ACTIVE'), (3, '000003', 'Cuadernos', 50, 'ACTIVE'); -- -- Dumping data for table 'attendance' -- -- -- Dumping data for table 'author' -- -- -- Dumping data for table 'authority' -- -- -- Dumping data for table 'authority_charge' -- INSERT INTO authority_charge (serial_atc, name_atc, description_atc, status_atc) VALUES (1, 'Rector', 'Rector', 'ACTIVE'), (2, 'Vicerector', 'Vicerector', 'ACTIVE'), (3, 'Secretaria', 'Secretaria', 'ACTIVE'), (4, 'Secretaria General', 'Secretaria General', 'ACTIVE'), (5, 'Primer Vocal', 'Primer Vocal', 'ACTIVE'), (6, 'Segundo Vocal', 'Segundo Vocal', 'ACTIVE'), (7, 'Tercer Vocal', 'Tercer Vocal', 'ACTIVE'); -- -- Dumping data for table 'autoschedule_process' -- INSERT INTO autoschedule_process (serial_asp, serial_usr, serial_scy, date_asp, status_asp, desired_opt_asp) VALUES (1, 1, 1, '2011-06-29 12:14:56', 'PENDING', 2); -- -- Dumping data for table 'autoschedule_process_results' -- -- -- Dumping data for table 'book' -- -- -- Dumping data for table 'book_author' -- -- -- Dumping data for table 'book_category' -- -- -- Dumping data for table 'book_copy' -- -- -- Dumping data for table 'bus' -- -- -- Dumping data for table 'bus_driver' -- -- -- Dumping data for table 'bus_shift_year' -- -- -- Dumping data for table 'bus_year_user' -- -- -- Dumping data for table 'cat_period' -- INSERT INTO cat_period (serial_cpd, name_cpd, description_cpd, status_cpd) VALUES (1, 'Trimestre', 'Trimestre', 'ACTIVE'); -- -- Dumping data for table 'cat_subject' -- INSERT INTO cat_subject (serial_csb, cat_serial_csb, serial_aca, serial_lng, code_csb, name_csb, status_csb) VALUES (1, NULL, 4, 1, '0001', 'Dibujo', 'ACTIVE'), (2, NULL, 4, 1, '00002', 'Musica', 'ACTIVE'), (3, 2, 4, 1, '00002-1', 'Guitarra', 'ACTIVE'), (4, 2, 4, 1, '00002-2', 'Canto', 'ACTIVE'), (5, 2, 4, 1, '00002--3', 'Percusion', 'ACTIVE'), (6, NULL, 4, 1, '00003', 'Manualidades', 'ACTIVE'), (7, NULL, 5, 1, '00004', 'Ciencias Naturales', 'ACTIVE'), (8, NULL, 5, 1, '00005', 'Biologia', 'ACTIVE'), (9, NULL, 5, 1, '00006', 'Quimica', 'ACTIVE'), (10, NULL, 2, 2, '00008', 'Ingles', 'ACTIVE'), (11, NULL, 2, 2, '00009', 'Grammar', 'ACTIVE'), (12, NULL, 2, 2, '00010', 'TOEFL', 'ACTIVE'), (13, NULL, 2, 2, '00011', 'World History', 'ACTIVE'), (14, NULL, 1, 1, '00012', 'Matematicas para bebes', 'ACTIVE'), (15, NULL, 1, 1, '00013', 'Matematicas General', 'ACTIVE'), (16, NULL, 1, 1, '00014', 'Matematicas', 'ACTIVE'), (17, 16, 1, 1, '00014-1', 'Geometria', 'ACTIVE'), (18, 16, 1, 1, '00014-2', 'Aritmetica', 'ACTIVE'), (19, NULL, 1, 1, '00015', 'Fisica', 'ACTIVE'), (20, NULL, 3, 1, '00016', 'Estudios Sociales', 'ACTIVE'), (21, NULL, 3, 1, '00017', 'Historia Mundial', 'ACTIVE'), (22, NULL, 3, 1, '00018', 'Historia del Ecuador', 'ACTIVE'), (23, NULL, 3, 1, '00019', 'Literatura', 'ACTIVE'), (24, NULL, 3, 1, '00020', 'Lengua', 'ACTIVE'); -- -- Dumping data for table 'change_reason' -- INSERT INTO change_reason (serial_chr, name_chr, type_chr, status_chr) VALUES (1, 'Exclusión de Actividad', 'ACTIVITY', 'ACTIVE'); -- -- Dumping data for table 'classroom' -- -- -- Dumping data for table 'class_group' -- INSERT INTO class_group (serial_clg, name_clg, description_clg, status_clg) VALUES (1, 'A', 'A', 'ACTIVE'), (2, 'B', 'B', 'ACTIVE'); -- -- Dumping data for table 'country' -- INSERT INTO country (serial_cou, name_cou, status_cou) VALUES (1, 'Andorra', 'ACTIVE'), (2, 'United arab emirates', 'ACTIVE'), (3, 'Afghanistan', 'ACTIVE'), (4, 'Antigua and barbuda', 'ACTIVE'), (5, 'Anguilla', 'ACTIVE'), (6, 'Albania', 'ACTIVE'), (7, 'Armenia', 'ACTIVE'), (8, 'Netherlands antilles', 'ACTIVE'), (9, 'Angola', 'ACTIVE'), (10, 'Antarctica', 'ACTIVE'), (11, 'Argentina', 'ACTIVE'), (12, 'Americansamoa', 'ACTIVE'), (13, 'Austria', 'ACTIVE'), (14, 'Australia', 'ACTIVE'), (15, 'Aruba', 'ACTIVE'), (16, 'Azerbaijan', 'ACTIVE'), (17, 'Bosnia and herzegovina', 'ACTIVE'), (18, 'Barbados', 'ACTIVE'), (19, 'Bangladesh', 'ACTIVE'), (20, 'Belgium', 'ACTIVE'), (21, 'Burkinafaso', 'ACTIVE'), (22, 'Bulgaria', 'ACTIVE'), (23, 'Bahrain', 'ACTIVE'), (24, 'Burundi', 'ACTIVE'), (25, 'Benin', 'ACTIVE'), (26, 'Bermuda', 'ACTIVE'), (27, 'Bruneida russalam', 'ACTIVE'), (28, 'Bolivia', 'ACTIVE'), (29, 'Brazil', 'ACTIVE'), (30, 'Bahamas', 'ACTIVE'), (31, 'Bhutan', 'ACTIVE'), (32, 'Bouvetisland', 'ACTIVE'), (33, 'Botswana', 'ACTIVE'), (34, 'Belarus', 'ACTIVE'), (35, 'Belize', 'ACTIVE'), (36, 'Canada', 'ACTIVE'), (37, 'Cocos(keeling)islands', 'ACTIVE'), (38, 'Congo', 'ACTIVE'), (39, 'Central african republic', 'ACTIVE'), (40, 'Congo', 'ACTIVE'), (41, 'Switzerland', 'ACTIVE'), (42, 'Coted''ivoire', 'ACTIVE'), (43, 'Cookislands', 'ACTIVE'), (44, 'Chile', 'ACTIVE'), (45, 'Cameroon', 'ACTIVE'), (46, 'China', 'ACTIVE'), (47, 'Colombia', 'ACTIVE'), (48, 'Costarica', 'ACTIVE'), (49, 'Serbia and montenegro', 'ACTIVE'), (50, 'Cuba', 'ACTIVE'), (51, 'Capeverde', 'ACTIVE'), (52, 'Christmas island', 'ACTIVE'), (53, 'Cyprus', 'ACTIVE'), (54, 'Czech republic', 'ACTIVE'), (55, 'Germany', 'ACTIVE'), (56, 'Djibouti', 'ACTIVE'), (57, 'Denmark', 'ACTIVE'), (58, 'Dominica', 'ACTIVE'), (59, 'Dominican republic', 'ACTIVE'), (60, 'Algeria', 'ACTIVE'), (61, 'Ecuador', 'ACTIVE'), (62, 'Estonia', 'ACTIVE'), (63, 'Egypt', 'ACTIVE'), (64, 'Western sahara', 'ACTIVE'), (65, 'Eritrea', 'ACTIVE'), (66, 'Spain', 'ACTIVE'), (67, 'Ethiopia', 'ACTIVE'), (68, 'Finland', 'ACTIVE'), (69, 'Fiji', 'ACTIVE'), (70, 'Micronesia', 'ACTIVE'), (71, 'Faroe islands', 'ACTIVE'), (72, 'France', 'ACTIVE'), (73, 'Gabon', 'ACTIVE'), (74, 'United kingdom', 'ACTIVE'), (75, 'Grenada', 'ACTIVE'), (76, 'Georgia', 'ACTIVE'), (77, 'French guiana', 'ACTIVE'), (78, 'Ghana', 'ACTIVE'), (79, 'Gibraltar', 'ACTIVE'), (80, 'Greenland', 'ACTIVE'), (81, 'Gambia', 'ACTIVE'), (82, 'Guinea', 'ACTIVE'), (83, 'Guadeloupe', 'ACTIVE'), (84, 'Equatorial guinea', 'ACTIVE'), (85, 'Greece', 'ACTIVE'), (86, 'Guatemala', 'ACTIVE'), (87, 'Guam', 'ACTIVE'), (88, 'Guinea-bissau', 'ACTIVE'), (89, 'Guyana', 'ACTIVE'), (90, 'Hong kong', 'ACTIVE'), (91, 'Honduras', 'ACTIVE'), (92, 'Croatia', 'ACTIVE'), (93, 'Haiti', 'ACTIVE'), (94, 'Hungary', 'ACTIVE'), (95, 'Indonesia', 'ACTIVE'), (96, 'Ireland', 'ACTIVE'), (97, 'Israel', 'ACTIVE'), (98, 'India', 'ACTIVE'), (99, 'Iraq', 'ACTIVE'), (100, 'Iran,islamic republic of', 'ACTIVE'), (101, 'Iceland', 'ACTIVE'), (102, 'Italy', 'ACTIVE'), (103, 'Jamaica', 'ACTIVE'), (104, 'Jordan', 'ACTIVE'), (105, 'Japan', 'ACTIVE'), (106, 'Kenya', 'ACTIVE'), (107, 'Kyrgyzstan', 'ACTIVE'), (108, 'Cambodia', 'ACTIVE'), (109, 'Kiribati', 'ACTIVE'), (110, 'Comoros', 'ACTIVE'), (111, 'Saint kitts and nevis', 'ACTIVE'), (112, 'Korea', 'ACTIVE'), (113, 'Korea,republic of', 'ACTIVE'), (114, 'Kuwait', 'ACTIVE'), (115, 'Cayman islands', 'ACTIVE'), (116, 'Kazakhstan', 'ACTIVE'), (117, 'Lao', 'ACTIVE'), (118, 'Lebanon', 'ACTIVE'), (119, 'Saint lucia', 'ACTIVE'), (120, 'Liechtenstein', 'ACTIVE'), (121, 'Srilanka', 'ACTIVE'), (122, 'Liberia', 'ACTIVE'), (123, 'Lesotho', 'ACTIVE'), (124, 'Lithuania', 'ACTIVE'), (125, 'Luxembourg', 'ACTIVE'), (126, 'Latvia', 'ACTIVE'), (127, 'Libyanarabjamahiriya', 'ACTIVE'), (128, 'Morocco', 'ACTIVE'), (129, 'Monaco', 'ACTIVE'), (130, 'Moldova,republic of', 'ACTIVE'), (131, 'Madagascar', 'ACTIVE'), (132, 'Marshall islands', 'ACTIVE'), (133, 'Macedonia', 'ACTIVE'), (134, 'Mali', 'ACTIVE'), (135, 'Myanmar', 'ACTIVE'), (136, 'Mongolia', 'ACTIVE'), (137, 'Macao', 'ACTIVE'), (138, 'Northern mariana islands', 'ACTIVE'), (139, 'Martinique', 'ACTIVE'), (140, 'Mauritania', 'ACTIVE'), (141, 'Montserrat', 'ACTIVE'), (142, 'Malta', 'ACTIVE'), (143, 'Mauritius', 'ACTIVE'), (144, 'Maldives', 'ACTIVE'), (145, 'Malawi', 'ACTIVE'), (146, 'Mexico', 'ACTIVE'), (147, 'Malaysia', 'ACTIVE'), (148, 'Mozambique', 'ACTIVE'), (149, 'Namibia', 'ACTIVE'), (150, 'New caledonia', 'ACTIVE'), (151, 'Niger', 'ACTIVE'), (152, 'Norfolk island', 'ACTIVE'), (153, 'Nigeria', 'ACTIVE'), (154, 'Nicaragua', 'ACTIVE'), (155, 'Netherlands', 'ACTIVE'), (156, 'Norway', 'ACTIVE'), (157, 'Nepal', 'ACTIVE'), (158, 'Nauru', 'ACTIVE'), (159, 'Niue', 'ACTIVE'), (160, 'New zealand', 'ACTIVE'), (161, 'Oman', 'ACTIVE'), (162, 'Panama', 'ACTIVE'), (163, 'Peru', 'ACTIVE'), (164, 'French polynesia', 'ACTIVE'), (165, 'Papua new guinea', 'ACTIVE'), (166, 'Philippines', 'ACTIVE'), (167, 'Pakistan', 'ACTIVE'), (168, 'Poland', 'ACTIVE'), (169, 'Saint pierre and miquelon', 'ACTIVE'), (170, 'Pitcairn', 'ACTIVE'), (171, 'Puerto rico', 'ACTIVE'), (172, 'Palestina', 'ACTIVE'), (173, 'Portugal', 'ACTIVE'), (174, 'Palau', 'ACTIVE'), (175, 'Paraguay', 'ACTIVE'), (176, 'Qatar', 'ACTIVE'), (177, 'Reunion', 'ACTIVE'), (178, 'Romania', 'ACTIVE'), (179, 'Russian federation', 'ACTIVE'), (180, 'Rwanda', 'ACTIVE'), (181, 'Saudi arabia', 'ACTIVE'), (182, 'Solomon islands', 'ACTIVE'), (183, 'Seychelles', 'ACTIVE'), (184, 'Sudan', 'ACTIVE'), (185, 'Sweden', 'ACTIVE'), (186, 'Singapore', 'ACTIVE'), (187, 'Saint helena', 'ACTIVE'), (188, 'Slovenia', 'ACTIVE'), (189, 'Svalbard and janmayen', 'ACTIVE'), (190, 'Slovakia', 'ACTIVE'), (191, 'Sierra leone', 'ACTIVE'), (192, 'San marino', 'ACTIVE'), (193, 'Senegal', 'ACTIVE'), (194, 'Somalia', 'ACTIVE'), (195, 'Suriname', 'ACTIVE'), (196, 'Saotome and principe', 'ACTIVE'), (197, 'El salvador', 'ACTIVE'), (198, 'Syrian arab republic', 'ACTIVE'), (199, 'Swaziland', 'ACTIVE'), (200, 'Turks and caicos islands', 'ACTIVE'), (201, 'Chad', 'ACTIVE'), (202, 'Togo', 'ACTIVE'), (203, 'Thailand', 'ACTIVE'), (204, 'Tajikistan', 'ACTIVE'), (205, 'Tokelau', 'ACTIVE'), (206, 'Timor-leste', 'ACTIVE'), (207, 'Turkmenistan', 'ACTIVE'), (208, 'Tunisia', 'ACTIVE'), (209, 'Tonga', 'ACTIVE'), (210, 'Turkey', 'ACTIVE'), (211, 'Trinidad and tobago', 'ACTIVE'), (212, 'Tuvalu', 'ACTIVE'), (213, 'Taiwan,province of china', 'ACTIVE'), (214, 'Tanzania,united republic of', 'ACTIVE'), (215, 'Ukraine', 'ACTIVE'), (216, 'Uganda', 'ACTIVE'), (217, 'United states', 'ACTIVE'), (218, 'Uruguay', 'ACTIVE'), (219, 'Uzbekistan', 'ACTIVE'), (220, 'Holysee(vatican city state)', 'ACTIVE'), (221, 'Venezuela', 'ACTIVE'), (222, 'Virgin islands,british', 'ACTIVE'), (223, 'Virgin islands,u.s.', 'ACTIVE'), (224, 'Vietnam', 'ACTIVE'), (225, 'Vanuatu', 'ACTIVE'), (226, 'Wallis and futuna', 'ACTIVE'), (227, 'Samoa', 'ACTIVE'), (228, 'Yemen', 'ACTIVE'), (229, 'Mayotte', 'ACTIVE'), (230, 'South africa', 'ACTIVE'), (231, 'Zambia', 'ACTIVE'), (232, 'Zimbabwe', 'ACTIVE'); -- -- Dumping data for table 'course' -- INSERT INTO course (serial_crs, serial_clg, serial_spt, serial_lvl, serial_scy, serial_set, attendance_crs, status_crs) VALUES (1, 1, 1, 7, 1, 3, 'DAY', 'ACTIVE'), (2, 1, 1, 1, 1, 1, 'DAY', 'ACTIVE'), (3, 2, 1, 1, 1, 1, 'DAY', 'ACTIVE'), (4, 1, 1, 2, 1, 1, 'DAY', 'ACTIVE'), (5, 2, 1, 2, 1, 1, 'DAY', 'ACTIVE'), (6, 1, 1, 3, 1, 1, 'DAY', 'ACTIVE'), (7, 2, 1, 3, 1, 1, 'DAY', 'ACTIVE'), (8, 1, 1, 4, 1, 2, 'CLASS', 'ACTIVE'), (9, 2, 1, 4, 1, 2, 'CLASS', 'ACTIVE'), (10, 1, 2, 5, 1, 2, 'CLASS', 'ACTIVE'), (11, 2, 2, 5, 1, 2, 'CLASS', 'ACTIVE'), (12, 1, 3, 5, 1, 2, 'CLASS', 'ACTIVE'), (13, 2, 3, 5, 1, 2, 'CLASS', 'ACTIVE'), (14, 1, 2, 6, 1, 2, 'CLASS', 'ACTIVE'), (15, 1, 3, 6, 1, 2, 'CLASS', 'ACTIVE'); -- -- Dumping data for table 'course_director' -- -- -- Dumping data for table 'credits_detail' -- INSERT INTO credits_detail (serial_cdt, serial_hrs, start_at_cdt, end_at_cdt, status_cdt) VALUES (1, 1, '07:30:00', '08:15:00', 'ACTIVE'), (2, 1, '08:15:00', '09:00:00', 'ACTIVE'), (3, 1, '09:00:00', '09:45:00', 'ACTIVE'), (4, 1, '09:45:00', '10:30:00', 'ACTIVE'); -- -- Dumping data for table 'credit_card' -- INSERT INTO credit_card (serial_ccd, name_ccd, status_ccd) VALUES (1, 'Diners', 'ACTIVE'), (2, 'Visa', 'ACTIVE'), (3, 'Master Card', 'ACTIVE'); -- -- Dumping data for table 'currency' -- INSERT INTO currency (serial_crr, abrevation_crr, name_crr, status_crr) VALUES (1, 'ARS', 'Argentine Peso', 'ACTIVE'), (2, 'AUD', 'Australian Dollar', 'ACTIVE'), (3, 'BHD', 'Bahrain Dinar', 'ACTIVE'), (4, 'BWP', 'Botswana Pula', 'ACTIVE'), (5, 'BRL', 'Brazilian Real', 'ACTIVE'), (6, 'BND', 'Brunei Dollar', 'ACTIVE'), (7, 'CAD', 'Canadian Dollar', 'ACTIVE'), (8, 'CLP', 'Chilean Peso', 'ACTIVE'), (9, 'CNY', 'Chinese Yuan', 'ACTIVE'), (10, 'COP', 'Colombian Peso', 'ACTIVE'), (11, 'CYP', 'Cyprus Pound', 'ACTIVE'), (12, 'CZK', 'Czech Koruna', 'ACTIVE'), (13, 'DKK', 'Danish Krone', 'ACTIVE'), (14, 'EUR', 'Euro', 'ACTIVE'), (15, 'HUF', 'Hungarian Forint', 'ACTIVE'), (16, 'ISK', 'Icelandic Krona', 'ACTIVE'), (17, 'INR', 'Indian Rupee', 'ACTIVE'), (18, 'IDR', 'Indonesian Rupiah', 'ACTIVE'), (19, 'IRR', 'Iranian Rial', 'ACTIVE'), (20, 'ILS', 'Israeli New Sheqel', 'ACTIVE'), (21, 'JPY', 'Japanese Yen', 'ACTIVE'), (22, 'KRW', 'Korean Won', 'ACTIVE'), (23, 'KWD', 'Kuwaiti Dinar', 'ACTIVE'), (24, 'LYD', 'Libyan Dinar', 'ACTIVE'), (25, 'MYR', 'Malaysian Ringgit', 'ACTIVE'), (26, 'MTL', 'Maltese Lira', 'ACTIVE'), (27, 'MUR', 'Mauritian Rupee', 'ACTIVE'), (28, 'MXN', 'Mexican Peso', 'ACTIVE'), (29, 'NPR', 'Nepalese Rupee', 'ACTIVE'), (30, 'NZD', 'New Zealand Dollar', 'ACTIVE'), (31, 'NOK', 'Norwegian Krone', 'ACTIVE'), (32, 'OMR', 'Omani Rial', 'ACTIVE'), (33, 'PKR', 'Pakistan Rupee', 'ACTIVE'), (34, 'PLN', 'Polish Zloty', 'ACTIVE'), (35, 'GBP', 'Pound Sterling', 'ACTIVE'), (36, 'QAR', 'Qatar Riyal', 'ACTIVE'), (37, 'SAR', 'Saudi Arabian Riyal', 'ACTIVE'), (38, 'SGD', 'Singapore Dollar', 'ACTIVE'), (39, 'SIT', 'Slovenian Tolar', 'ACTIVE'), (40, 'ZAR', 'South African Rand', 'ACTIVE'), (41, 'LKR', 'Sri Lanka Rupee', 'ACTIVE'), (42, 'SEK', 'Swedish Krona', 'ACTIVE'), (43, 'CHF', 'Swiss Franc', 'ACTIVE'), (44, 'THB', 'Thai Baht', 'ACTIVE'), (45, 'TTD', 'Trinidad and Tobago Dollar', 'ACTIVE'), (46, 'AED', 'U.A.E.Dirham', 'ACTIVE'), (47, 'USD', 'U.S.Dollar', 'ACTIVE'), (48, 'VEB', 'Venezuelan Bolivar', 'ACTIVE'); -- -- Dumping data for table 'current_deferred' -- -- -- Dumping data for table 'degree' -- INSERT INTO degree (serial_dgr, name_dgr, status_dgr) VALUES (1, 'Artes aplicadas', 'ACTIVE'), (2, 'Auxiliar de laboratorio de ciencias naturales y Biología', 'ACTIVE'), (3, 'Ciencias exactas', 'ACTIVE'), (4, 'Ciencias sociales', 'ACTIVE'), (5, 'Comercio y administración', 'ACTIVE'), (6, 'Comunicación educativa', 'ACTIVE'), (7, 'Contabilidad y administración', 'ACTIVE'), (8, 'Diseño y dibujo', 'ACTIVE'), (9, 'Docencia y desarrollo comunitario', 'ACTIVE'), (10, 'Docencia y gestión en educación básica', 'ACTIVE'), (11, 'Ecoturismo', 'ACTIVE'), (12, 'Educación artística', 'ACTIVE'), (13, 'Educación primaria', 'ACTIVE'), (14, 'Educación especial', 'ACTIVE'), (15, 'Educación inicial', 'ACTIVE'), (16, 'Educación parvularia', 'ACTIVE'), (17, 'Educación superior', 'ACTIVE'), (18, 'Electricidad', 'ACTIVE'), (19, 'Diplomado', 'ACTIVE'), (20, 'Especialista', 'ACTIVE'), (21, 'Phd', 'ACTIVE'), (22, 'Máster', 'ACTIVE'); -- -- Dumping data for table 'discipline' -- -- -- Dumping data for table 'discount' -- INSERT INTO discount (serial_dsc, name_dsc, status_dsc) VALUES (1, 'Beca 1 Hermano', 'ACTIVE'), (2, 'Beca 2 hermanos', 'ACTIVE'), (3, 'Beca 3 hermanos', 'ACTIVE'), (4, 'Beca 4 hermanos', 'ACTIVE'), (5, 'Beca 5 hermanos', 'ACTIVE'), (6, 'Beca 6 hermanos', 'ACTIVE'), (7, 'Beca 7 hermanos', 'ACTIVE'), (8, 'Beca 8 hermanos', 'ACTIVE'), (9, 'Beca 9 hermanos', 'ACTIVE'), (10, 'Beca 10 hermanos', 'ACTIVE'), (11, 'Beca 11 hermanos', 'ACTIVE'), (12, 'Beca 12 hermanos', 'ACTIVE'), (13, 'Beca 13 hermanos', 'ACTIVE'), (14, 'Beca 14 hermanos', 'ACTIVE'), (15, 'Beca 15 hermanos', 'ACTIVE'), (16, 'Beca Academica', 'ACTIVE'), (17, 'Beca Musica', 'ACTIVE'), (18, 'Beca Deportes', 'ACTIVE'); -- -- Dumping data for table 'discount_payment_concept' -- INSERT INTO discount_payment_concept (serial_ydc, serial_pct, status_dpc) VALUES (1, 1, 'ACTIVE'), (1, 2, 'ACTIVE'), (2, 1, 'ACTIVE'), (2, 2, 'ACTIVE'), (2, 3, 'ACTIVE'), (2, 4, 'ACTIVE'); -- -- Dumping data for table 'employee' -- INSERT INTO employee (serial_emp, serial_tdg, serial_usr, serial_grd, serial_mdg, serial_ste, serial_cou, serial_nnt, serial_tst, serial_unv, serial_tmd, serial_dgr, id_emp, type_emp, status_emp, first_name_emp, last_name_emp, specialty_emp, gender_emp, marital_status_emp, birthdate_emp, address_emp, city_emp, parish_emp, sector_emp, phone_emp, phone2_emp, phone3_emp, cellphone_emp, email_emp, email2_emp, family_dependents_emp, student_dependents_emp, teaching_since_tea_emp, seniority_university_tea_emp, date_start_in_school_emp) VALUES (1, 9, 2, NULL, NULL, 123, 13, 4, 42, NULL, 1, NULL, '17541455144', 'TEACHING', 'ACTIVE', 'Adolf', 'Hitler', '', 'MALE', 'UNMARRIED PARTNERS', '1940-04-15', 'Av. cualquiera y la que cruza esquina', 'Braunau', '', '', '3232324', '', '', '', '', '', 0, 0, NULL, NULL, '2011-06-27'), (2, NULL, 3, NULL, NULL, 253, 146, 16, NULL, NULL, NULL, NULL, '000000001', 'TEACHING', 'ACTIVE', 'Profesor', 'Jirafales', '', 'MALE', 'MARRIED', '1943-04-15', 'Mexico', 'Mexico DF', '', '', '251454', '', '', '', '', '', 0, 0, NULL, NULL, '2011-06-27'), (3, NULL, 4, NULL, NULL, 120, 10, 2, NULL, NULL, NULL, NULL, '2454567', 'TEACHING', 'ACTIVE', 'Edna', 'Krabappel', '', 'FEMALE', 'SINGLE', '1948-04-15', 'Springfield', 'Springfield', '', '', '123123', '', '', '', '', '', 0, 0, NULL, NULL, '2011-06-27'), (4, NULL, 5, NULL, NULL, 294, 187, 2, NULL, NULL, NULL, NULL, '2134564', 'TEACHING', 'ACTIVE', 'Director ', 'Skinner', '', 'MALE', 'SINGLE', '1940-04-15', 'Calle sexta', 'Springfield', '', '', '2142142', '', '', '', '', '', 0, 0, NULL, NULL, '2011-06-27'), (5, NULL, 6, NULL, NULL, 113, 3, 2, NULL, NULL, NULL, NULL, '0121245444', 'TEACHING', 'ACTIVE', 'Maestro', 'Yoda', '', 'MALE', 'SINGLE', '1800-04-15', 'Master Yoda', 'Cye', '', '', '2142142', '', '', '', '', '', 0, 0, NULL, NULL, '2011-06-27'), (6, NULL, 7, NULL, NULL, 113, 3, 5, NULL, NULL, NULL, NULL, '21545454', 'TEACHING', 'ACTIVE', 'Alfredo ', 'Borrego', '', 'MALE', 'SINGLE', '1943-04-15', 'Gaspar de Villarroel', 'Braunau', '', '', '2142142', '', '', '', '', '', 0, 0, NULL, NULL, '2011-06-27'), (7, NULL, 12, NULL, NULL, 116, 6, 2, NULL, NULL, NULL, NULL, '12054545451', 'TEACHING', 'ACTIVE', 'Juana', 'Matematicas', '', 'MALE', 'SINGLE', '1981-06-23', 'asdasd', 'Albani', '', '', '5464564', '', '', '', '', '', 0, 0, NULL, NULL, '2011-06-29'), (8, NULL, 13, NULL, NULL, 113, 3, 2, NULL, NULL, NULL, NULL, '12312390123', 'TEACHING', 'ACTIVE', 'Pedro', 'Manualidades', '', 'MALE', 'SINGLE', '1981-06-23', 'asdasdasd', 'Albani', '', '', '2515454', '', '', '', '', '', 0, 0, NULL, NULL, '2011-06-29'), (9, NULL, 14, NULL, NULL, 113, 3, 2, NULL, NULL, NULL, NULL, '312152454', 'TEACHING', 'ACTIVE', 'Juaquin', 'Dibujo', '', 'MALE', 'SINGLE', '1981-06-23', 'asdasd', 'Albani', '', '', '322154564', '', '', '', '', '', 0, 0, NULL, NULL, '2011-06-29'), (10, NULL, 15, NULL, NULL, 113, 3, 2, NULL, NULL, NULL, NULL, '2145465451', 'TEACHING', 'ACTIVE', 'Manuel', 'Lengua', '', 'MALE', 'MARRIED', '1981-06-23', 'asdasdad', 'Albani', '', '', '2515454', '', '', '', '', '', 0, 0, NULL, NULL, '2011-06-29'), (11, NULL, 16, NULL, NULL, 113, 3, 2, NULL, NULL, NULL, NULL, '2345484444', 'TEACHING', 'ACTIVE', 'Laura', 'Ingles', '', 'MALE', 'SINGLE', '1981-06-23', 'asdasdasd', 'Albani', '', '', '2515454', '', '', '', '', '', 0, 0, NULL, NULL, '2011-06-29'), (12, NULL, 17, NULL, NULL, 113, 3, 4, NULL, NULL, NULL, NULL, '245456421', 'TEACHING', 'ACTIVE', 'Mario', 'Optativo', '', 'MALE', 'SINGLE', '1981-06-23', 'asdasd', 'Quito', '', '', '2456465478', '', '', '', '', '', 0, 0, NULL, NULL, '2011-06-29'); -- -- Dumping data for table 'employee_area' -- INSERT INTO employee_area (serial_aca, serial_emp, is_director_eba, status_eba) VALUES (1, 2, 'YES', 'ACTIVE'), (1, 3, 'NO', 'ACTIVE'), (1, 4, 'NO', 'ACTIVE'), (1, 6, 'NO', 'ACTIVE'), (1, 7, 'NO', 'ACTIVE'), (2, 3, 'YES', 'ACTIVE'), (2, 4, 'NO', 'ACTIVE'), (2, 11, 'NO', 'ACTIVE'), (3, 2, 'NO', 'ACTIVE'), (3, 3, 'NO', 'ACTIVE'), (3, 4, 'NO', 'ACTIVE'), (3, 5, 'YES', 'ACTIVE'), (3, 10, 'NO', 'ACTIVE'), (4, 1, 'YES', 'ACTIVE'), (4, 8, 'NO', 'ACTIVE'), (4, 9, 'NO', 'ACTIVE'), (4, 12, 'NO', 'ACTIVE'), (5, 2, 'NO', 'ACTIVE'), (5, 4, 'NO', 'ACTIVE'), (5, 5, 'YES', 'ACTIVE'); -- -- Dumping data for table 'equipment' -- -- -- Dumping data for table 'financial_institution' -- INSERT INTO financial_institution (serial_fin, name_fin, phone1_fin, phone2_fin, status_fin) VALUES (2, 'Banco Pichincha', '26352365', '', 'ACTIVE'), (4, 'Banco Bolivariano', '3211454', '', 'ACTIVE'), (5, 'Banco Pacifico', '245464', '', 'ACTIVE'), (6, 'Chulquero Martinez', '215454', '', 'ACTIVE'); -- -- Dumping data for table 'general_activity' -- -- -- Dumping data for table 'general_activity_attendees' -- -- -- Dumping data for table 'general_discipline_log' -- -- -- Dumping data for table 'grade_change_log' -- -- -- Dumping data for table 'grade_criteria' -- INSERT INTO grade_criteria (serial_gct, name_gct, description_gct, status_gct) VALUES (1, '* General', 'Criterio General,se usa cuando no se va a aplicar criterios de calificación.', 'ACTIVE'); -- -- Dumping data for table 'grade_score_change_log' -- -- -- Dumping data for table 'grade_subject_score' -- -- -- Dumping data for table 'group_hour' -- INSERT INTO group_hour (serial_gph, name_gph, description_gph, status_gph) VALUES (1, 'Horario Diurno de Clases', 'Horario Diurno', 'ACTIVE'); -- -- Dumping data for table 'group_hour_level' -- INSERT INTO group_hour_level (serial_gph, serial_lvl, serial_scy, serial_set, working_days_ghl, status_ghl) VALUES (1, 1, 1, 1, 'MONDAY,TUESDAY,WEDNESDAY,THURSDAY,FRIDAY', 'ACTIVE'), (1, 2, 1, 1, 'MONDAY,TUESDAY,WEDNESDAY,THURSDAY,FRIDAY', 'ACTIVE'), (1, 3, 1, 1, 'MONDAY,TUESDAY,WEDNESDAY,THURSDAY,FRIDAY', 'ACTIVE'), (1, 4, 1, 2, 'MONDAY,TUESDAY,WEDNESDAY,THURSDAY,FRIDAY', 'ACTIVE'), (1, 5, 1, 2, 'MONDAY,TUESDAY,WEDNESDAY,THURSDAY,FRIDAY', 'ACTIVE'), (1, 6, 1, 2, 'MONDAY,TUESDAY,WEDNESDAY,THURSDAY,FRIDAY', 'ACTIVE'), (1, 7, 1, 3, 'MONDAY,TUESDAY,WEDNESDAY,THURSDAY,FRIDAY', 'ACTIVE'); -- -- Dumping data for table 'group_optional_subject' -- INSERT INTO group_optional_subject (serial_osb, serial_lop, status_gos) VALUES (1, 1, 'ACTIVE'), (1, 2, 'ACTIVE'), (2, 2, 'ACTIVE'), (1, 3, 'ACTIVE'); -- -- Dumping data for table 'guardian' -- INSERT INTO guardian (serial_grd, serial_usr, serial_emp, id_grd, first_name_grd, last_name_grd, birthdate_grd, gender_grd, marital_status_grd, alumnus_grd, address_grd, phone_grd, mobile_grd, occupation_grd, company_name_grd, company_activity_grd, company_phone_grd, email_grd, email2_grd, status_grd) VALUES (1, 9, NULL, '0123456789', 'Mamita', 'Calderon', '1943-04-15', 'MALE', '', '', 'asdasdasda', '2142142', '098412544', '', '', '', '', '', '', 'ACTIVE'), (2, 10, NULL, '012456788', 'Papa', 'Oso', '1948-04-15', 'MALE', '', '', 'asdasdas', '2142142', '098412544', '', '', '', '', '', '', 'ACTIVE'), (3, 11, NULL, '0212312223', 'Mama', 'Oglio', '1991-06-19', 'FEMALE', '', '', 'asdasd', '4542444', '084475454', '', '', '', '', '', '', 'ACTIVE'); -- -- Dumping data for table 'guest' -- -- -- Dumping data for table 'hour' -- INSERT INTO hour (serial_hrs, start_hrs, end_hrs, status_hrs) VALUES (1, '07:30:00', '10:30:00', 'ACTIVE'); -- -- Dumping data for table 'hour_by_group' -- INSERT INTO hour_by_group (serial_hbg, serial_hrs, serial_gph, status_hbg, credits_hbg, type_hbg) VALUES (1, 1, 1, 'ACTIVE', 4, 'NORMAL'); -- -- Dumping data for table 'incident' -- -- -- Dumping data for table 'income_stock' -- -- -- Dumping data for table 'invoice' -- -- -- Dumping data for table 'invoice_detail' -- -- -- Dumping data for table 'invoice_detail_non_academic' -- -- -- Dumping data for table 'invoice_non_academic' -- -- -- Dumping data for table 'item_category' -- -- -- Dumping data for table 'language' -- INSERT INTO language (serial_lng, abbreviation_lng, name_lng) VALUES (1, 'ES', 'Español'), (2, 'EN', 'Inglés'); -- -- Dumping data for table 'level' -- INSERT INTO level (serial_lvl, name_lvl, description_lvl, status_lvl) VALUES (1, 'Primer Grado', 'Primer Grado', 'ACTIVE'), (2, 'Cuarto Grado', 'Cuarto Grado', 'ACTIVE'), (3, 'Sexto Grado', 'Sexto Grado', 'ACTIVE'), (4, 'Primer Curso', 'Primer Curso', 'ACTIVE'), (5, 'Cuarto Curso', 'Cuarto Curso', 'ACTIVE'), (6, 'Sexto Curso', 'Sexto Curso', 'ACTIVE'), (7, 'Kinder Garden', 'Kinder', 'ACTIVE'); -- -- Dumping data for table 'level_optional_group' -- INSERT INTO level_optional_group (serial_lop, serial_spt, serial_lvl, serial_scy, serial_set, name_lop, status_lop, hours_week_lop, hours_distribution_lop) VALUES (1, 1, 7, 1, 3, 'Grupo Opativo 1', 'INACTIVE', 2, '2'), (2, 1, 1, 1, 1, 'Grupo Optativo 2', 'ACTIVE', 2, '1,1'), (3, 2, 6, 1, 2, 'Grupo Optativo 3', 'ACTIVE', 4, '1,1,2'); -- -- Dumping data for table 'level_optional_group_detail' -- INSERT INTO level_optional_group_detail (serial_prd, serial_lop, weight_ogd, status_ogd) VALUES (1, 1, '33.33', 'INACTIVE'), (1, 2, '33.33', 'ACTIVE'), (1, 3, '33.33', 'ACTIVE'), (2, 1, '33.33', 'INACTIVE'), (2, 2, '33.33', 'ACTIVE'), (2, 3, '33.33', 'ACTIVE'), (3, 1, '33.34', 'INACTIVE'), (3, 2, '33.34', 'ACTIVE'), (3, 3, '33.34', 'ACTIVE'); -- -- Dumping data for table 'level_opt_skill_criteria' -- -- -- Dumping data for table 'level_section_year' -- INSERT INTO level_section_year (serial_pgy, serial_lvl, discipline_lsy, supervisor_grade_weight_lsy, teacher_grade_weight_lsy, order_lsy, serial_scy, serial_set, status_lsy) VALUES (1, 1, NULL, NULL, NULL, 2, 1, 1, 'ACTIVE'), (1, 2, NULL, NULL, NULL, 3, 1, 1, 'ACTIVE'), (1, 3, NULL, NULL, NULL, 4, 1, 1, 'ACTIVE'), (1, 4, NULL, NULL, NULL, 5, 1, 2, 'ACTIVE'), (1, 5, NULL, NULL, NULL, 6, 1, 2, 'ACTIVE'), (1, 6, NULL, NULL, NULL, 7, 1, 2, 'ACTIVE'), (1, 7, NULL, NULL, NULL, 1, 1, 3, 'ACTIVE'); -- -- Dumping data for table 'level_section_year_specialty' -- INSERT INTO level_section_year_specialty (serial_spt, serial_lvl, serial_scy, serial_set, status_lss) VALUES (1, 1, 1, 1, 'ACTIVE'), (1, 2, 1, 1, 'ACTIVE'), (1, 3, 1, 1, 'ACTIVE'), (1, 4, 1, 2, 'ACTIVE'), (1, 7, 1, 3, 'ACTIVE'), (2, 5, 1, 2, 'ACTIVE'), (2, 6, 1, 2, 'ACTIVE'), (3, 5, 1, 2, 'ACTIVE'), (3, 6, 1, 2, 'ACTIVE'); -- -- Dumping data for table 'level_skill_grade_criteria' -- -- -- Dumping data for table 'library_section' -- -- -- Dumping data for table 'loan' -- -- -- Dumping data for table 'loan_detail' -- -- -- Dumping data for table 'maintenance_item' -- -- -- Dumping data for table 'master_degree' -- -- -- Dumping data for table 'medical_file' -- -- -- Dumping data for table 'message' -- -- -- Dumping data for table 'message_between_profiles' -- INSERT INTO message_between_profiles (serial_prf, pro_serial_prf, status_mbp) VALUES (1, 1, 'ACTIVE'), (1, 2, 'ACTIVE'), (1, 3, 'ACTIVE'), (1, 4, 'ACTIVE'), (1, 5, 'ACTIVE'), (2, 4, 'ACTIVE'), (2, 5, 'ACTIVE'), (3, 3, 'ACTIVE'), (3, 4, 'ACTIVE'), (4, 2, 'ACTIVE'), (4, 3, 'ACTIVE'), (4, 4, 'ACTIVE'), (5, 3, 'ACTIVE'), (5, 4, 'ACTIVE'), (5, 5, 'ACTIVE'); -- -- Dumping data for table 'message_thread' -- -- -- Dumping data for table 'message_thread_messages' -- -- -- Dumping data for table 'ministry_resit_change_log' -- -- -- Dumping data for table 'ministry_resit_student' -- -- -- Dumping data for table 'ministry_subject' -- -- -- Dumping data for table 'nationality' -- INSERT INTO nationality (serial_nnt, name_nnt, status_nnt) VALUES (1, 'ECUATORIANA', 'ACTIVE'), (2, 'AFGANA', 'ACTIVE'), (3, 'ALBANA', 'ACTIVE'), (4, 'ALEMANA', 'ACTIVE'), (5, 'ARGENTINA', 'ACTIVE'), (6, 'BAHAMES', 'ACTIVE'), (7, 'BELGA', 'ACTIVE'), (8, 'BOLIVIANA', 'ACTIVE'), (9, 'BRASILEÑA', 'ACTIVE'), (10, 'CHILENA', 'ACTIVE'), (11, 'COLOMBIANA', 'ACTIVE'), (12, 'COSTARRICENSE', 'ACTIVE'), (13, 'ESPAÑOLA', 'ACTIVE'), (14, 'ESTADOUNIDENSE', 'ACTIVE'), (15, 'ITALIANA', 'ACTIVE'), (16, 'MEXICANA', 'ACTIVE'), (17, 'PARAGUAYA', 'ACTIVE'), (18, 'PERUANA', 'ACTIVE'), (19, 'PORTUGUESA', 'ACTIVE'), (20, 'PUERTORRIQUEÑA', 'ACTIVE'), (21, 'SUIZA', 'ACTIVE'), (22, 'VENEZOLANA', 'ACTIVE'), (23, 'CUBANA', 'ACTIVE'); -- -- Dumping data for table 'optional_subject' -- INSERT INTO optional_subject (serial_osb, serial_pgy, serial_csb, per_serial_pgy, serial_aca, serial_emp, status_osb, grade_type_sbc) VALUES (1, 1, 4, NULL, 4, 1, 'ACTIVE', 'QUALITATIVE'), (2, 1, 5, NULL, 4, 1, 'ACTIVE', 'QUANTITATIVE'); -- -- Dumping data for table 'optional_subject_level' -- INSERT INTO optional_subject_level (serial_osb, serial_spt, serial_lvl, serial_scy, serial_set, status_osl) VALUES (1, 1, 7, 1, 3, 'ACTIVE'), (1, 1, 1, 1, 1, 'ACTIVE'), (1, 1, 2, 1, 1, 'ACTIVE'), (1, 1, 3, 1, 1, 'ACTIVE'), (1, 1, 4, 1, 2, 'ACTIVE'), (1, 2, 5, 1, 2, 'ACTIVE'), (1, 3, 5, 1, 2, 'ACTIVE'), (1, 2, 6, 1, 2, 'ACTIVE'), (1, 3, 6, 1, 2, 'ACTIVE'), (2, 1, 7, 1, 3, 'ACTIVE'), (2, 1, 1, 1, 1, 'ACTIVE'), (2, 1, 2, 1, 1, 'ACTIVE'), (2, 1, 3, 1, 1, 'ACTIVE'), (2, 1, 4, 1, 2, 'ACTIVE'), (2, 2, 5, 1, 2, 'ACTIVE'), (2, 3, 5, 1, 2, 'ACTIVE'), (2, 2, 6, 1, 2, 'ACTIVE'), (2, 3, 6, 1, 2, 'ACTIVE'); -- -- Dumping data for table 'optional_subject_period' -- INSERT INTO optional_subject_period (serial_prd, serial_osb, status_osp) VALUES (1, 1, 'ACTIVE'), (1, 2, 'ACTIVE'), (2, 1, 'ACTIVE'), (2, 2, 'ACTIVE'), (3, 1, 'ACTIVE'), (3, 2, 'ACTIVE'); -- -- Dumping data for table 'optional_subject_retest' -- -- -- Dumping data for table 'optional_subject_retest_student' -- -- -- Dumping data for table 'opt_activity' -- -- -- Dumping data for table 'opt_activity_applied_criterias' -- -- -- Dumping data for table 'opt_activity_attachment' -- -- -- Dumping data for table 'opt_grade_change_log' -- -- -- Dumping data for table 'opt_student_activity_attachment' -- -- -- Dumping data for table 'opt_student_criteria_grade' -- -- -- Dumping data for table 'opt_subject_period_activity_type' -- -- -- Dumping data for table 'opt_subject_retest_change_log' -- -- -- Dumping data for table 'opt_subject_year_activity_criteria_period' -- -- -- Dumping data for table 'opt_subject_year_grade_criteria' -- -- -- Dumping data for table 'payment_agreement_group' -- INSERT INTO payment_agreement_group (serial_pag, serial_scy, code_pag, description_pag, status_pag) VALUES (1, 1, '000454', 'Convenio de pago numero 1', 'ACTIVE'); -- -- Dumping data for table 'payment_concept' -- INSERT INTO payment_concept (serial_pct, name_pct, status_pct) VALUES (1, 'Pension', 'ACTIVE'), (2, 'Matricula', 'ACTIVE'), (3, 'Matricula Discapacitados', 'ACTIVE'), (4, 'Transporte', 'ACTIVE'), (5, 'Auto para el director', 'ACTIVE'), (6, 'Casa en la playa para el director', 'ACTIVE'), (7, 'Alime Extracurricular', 'ACTIVE'), (8, 'Copias', 'ACTIVE'); -- -- Dumping data for table 'payment_detail' -- -- -- Dumping data for table 'payment_detail_non_academic' -- -- -- Dumping data for table 'payment_method' -- INSERT INTO payment_method (serial_pym, name_pym, requires_owner_info_pym, requires_financial_pym, requires_credit_card_pym, status_pym) VALUES (1, 'Diferido Corriente', 'NO', 'NO', 'NO', 'ACTIVE'), (2, 'Efectivo', 'YES', 'NO', 'NO', 'ACTIVE'), (3, 'Tarjeta de Credito', 'YES', 'YES', 'YES', 'ACTIVE'), (4, 'Cheque', 'YES', 'YES', 'NO', 'ACTIVE'), (5, 'Trueque', 'NO', 'NO', 'NO', 'ACTIVE'); -- -- Dumping data for table 'period' -- INSERT INTO period (serial_prd, serial_pgy, name_prd, start_date_prd, end_date_prd, max_grade_date_prd, status_prd, min_grade_prd, max_grade_prd, warning_grade_prd, weight_prd) VALUES (1, 1, 'Primer Trimestre', '2011-07-06', '2011-10-10', '2011-10-05', 'ACTIVE', '0.00000', '20.00000', '14.00000', '33.33'), (2, 1, 'Segundo Trimestre', '2011-10-11', '2012-01-06', '2012-01-03', 'ACTIVE', '0.00000', '20.00000', '14.00000', '33.33'), (3, 1, 'Tercer Trimestre', '2012-01-09', '2012-04-05', '2012-04-03', 'ACTIVE', '0.00000', '20.00000', '14.00000', '33.34'); -- -- Dumping data for table 'period_exam_grade_change_log' -- -- -- Dumping data for table 'period_group_year' -- INSERT INTO period_group_year (serial_pgy, serial_scy, serial_cpd, name_pgy, status_pgy) VALUES (1, 1, 1, 'Trimestres 2011-2012', 'ACTIVE'); -- -- Dumping data for table 'pre_registration' -- -- -- Dumping data for table 'pre_registration_period' -- INSERT INTO pre_registration_period (serial_scy, start_date_prp, end_date_prp, status_prp) VALUES (1, '2011-06-27', '2011-07-26', 'OPEN'); -- -- Dumping data for table 'pre_registration_required_documment' -- -- -- Dumping data for table 'process' -- INSERT INTO process (serial_prc, prc_serial_prc, name_prc, link_prc, weight_prc, status_prc) VALUES (1, NULL, 'Parámetros', '#', '1.0', 'LOCKABLE'), (2, 1, 'Área Académica', '#', '48.5', 'LOCKABLE'), (3, 2, 'Nueva Área Académica', 'modules/academic_area/fNewArea', '48.6', 'LOCKABLE'), (4, 2, 'Actualizar Área Académica', 'modules/academic_area/fSearchArea', '48.7', 'LOCKABLE'), (5, 1, 'Autoridades', '#', '5.0', 'LOCKABLE'), (6, 5, 'Nueva Autoridad', 'modules/authority/fNewAuthority', '6.0', 'LOCKABLE'), (7, 5, 'Actualizar Autoridad', 'modules/authority/fSearchAuthority', '7.0', 'LOCKABLE'), (8, 1, 'Cargos de Autoridades', '#', '4.1', 'LOCKABLE'), (9, 8, 'Nuevo Cargo', 'modules/authority_charges/fNewCharge', '4.2', 'LOCKABLE'), (10, 8, 'Actualizar Cargo', 'modules/authority_charges/fSearchCharge', '4.3', 'LOCKABLE'), (11, 1, 'Perfiles', '#', '51.5', 'LOCKABLE'), (12, 11, 'Nuevo Perfil', 'modules/profile/fNewProfile', '51.6', 'LOCKABLE'), (13, 11, 'Actualizar Perfil', 'modules/profile/fSearchProfile', '51.7', 'LOCKABLE'), (14, 1, 'Paises', '#', '14.0', 'LOCKABLE'), (15, 14, 'Nuevo País', 'modules/country/fNewCountry', '15.0', 'LOCKABLE'), (16, 14, 'Actualizar País', 'modules/country/fSearchCountry', '16.0', 'LOCKABLE'), (17, 1, 'Provincias/Estados', '#', '17.0', 'LOCKABLE'), (18, 17, 'Nueva Provincia/Estado', 'modules/state/fNewState', '18.0', 'LOCKABLE'), (19, 17, 'Actualizar Provincia/Estado', 'modules/state/fSearchState', '19.0', 'LOCKABLE'), (20, 1, 'Secciones', '#', '20.0', 'LOCKABLE'), (21, 20, 'Nueva Sección', 'modules/section/fNewSection', '21.0', 'LOCKABLE'), (22, 20, 'Actualizar Sección', 'modules/section/fSearchSection', '22.0', 'LOCKABLE'), (23, 1, 'Niveles', '#', '23.0', 'LOCKABLE'), (24, 23, 'Nuevo Nivel', 'modules/level/fNewLevel', '24.0', 'LOCKABLE'), (25, 23, 'Actualizar Nivel', 'modules/level/fSearchLevel', '25.0', 'LOCKABLE'), (26, 1, 'Especialidades', '#', '22.5', 'LOCKABLE'), (27, 26, 'Nueva Especialidad', 'modules/specialty/fNewSpecialty', '22.6', 'LOCKABLE'), (28, 26, 'Actualizar Especialidad', 'modules/specialty/fSearchSpecialty', '22.7', 'LOCKABLE'), (29, 1, 'Paralelos', '#', '29.0', 'LOCKABLE'), (30, 29, 'Nuevo Paralelo', 'modules/class_group/fNewClassGroup', '30.0', 'LOCKABLE'), (31, 29, 'Actualizar Paralelo', 'modules/class_group/fSearchClassGroup', '31.0', 'LOCKABLE'), (32, 1, 'Horas Académicas', '#', '32.0', 'LOCKABLE'), (33, 32, 'Grupos de Horas', '#', '33.0', 'LOCKABLE'), (34, 33, 'Nuevo Grupo Horas', 'modules/group_hour/fNewGroupHour', '34.0', 'LOCKABLE'), (35, 33, 'Actualizar Grupo Horas', 'modules/group_hour/fSearchGroupHour', '35.0', 'LOCKABLE'), (36, 1, 'Categoría de Período', '#', '36.0', 'LOCKABLE'), (37, 36, 'Nueva Categoría', 'modules/cat_period/fNewCatPeriod', '37.0', 'LOCKABLE'), (38, 36, 'Actualizar Categoría', 'modules/cat_period/fSearchCatPeriod', '38.0', 'LOCKABLE'), (39, NULL, 'Configuración', '#', '39.0', 'LOCKABLE'), (40, 39, 'Año Lectivo', '#', '40.0', 'LOCKABLE'), (41, 40, 'Iniciar/Continuar', 'modules/year_setup/index', '41.0', 'LOCKABLE'), (42, 1, 'Año Lectivo', '#', '19.5', 'LOCKABLE'), (43, 42, 'Nuevo Año Lectivo', 'modules/school_year/fNewYear', '19.6', 'LOCKABLE'), (44, 42, 'Actualizar Año Lectivo', 'modules/school_year/fSearchYear', '19.7', 'LOCKABLE'), (45, 314, 'Preinscripciones', '#', '45.0', 'LOCKABLE'), (46, 45, 'Nueva Preinscripción', 'modules/pre_registration/fNewPreRegistration', '46.0', 'LOCKABLE'), (47, 45, 'Actualizar Preinscripción', 'modules/pre_registration/fSelectPreRegisteredToUpdate', '47.0', 'LOCKABLE'), (48, 321, 'Revisar Preinscripciones', 'modules/pre_registration/documents/fSelectLevel', '48.0', 'LOCKABLE'), (49, 1, 'Materias', '#', '49.0', 'LOCKABLE'), (50, 49, 'Nueva Materia', 'modules/cat_subject/fNewCatSubject', '50.0', 'LOCKABLE'), (51, 49, 'Actualizar Materia', 'modules/cat_subject/fSearchCatSubject', '51.0', 'LOCKABLE'), (52, 1, 'Usuarios', '#', '52.0', 'LOCKABLE'), (53, 52, 'Profesores', '#', '53.0', 'LOCKABLE'), (54, 53, 'Nuevo Profesor', 'modules/employee/teacher/fNewTeacher', '54.0', 'LOCKABLE'), (55, 53, 'Actualizar Profesor', 'modules/employee/teacher/fSearchTeacher', '55.0', 'LOCKABLE'), (56, 52, 'Empleados', '#', '56.0', 'LOCKABLE'), (57, 39, 'Materias', '#', '57.0', 'LOCKABLE'), (58, 57, 'Iniciar/Continuar', 'modules/year_subject_setup/index', '58.0', 'LOCKABLE'), (59, 39, 'Profesores', '#', '59.0', 'LOCKABLE'), (60, 59, 'Horas disponibles por año', 'modules/teacher_hours_year/fSelectSchoolYear', '60.0', 'LOCKABLE'), (61, 39, 'Estudiantes', '#', '61.0', 'LOCKABLE'), (62, 61, 'Asignar Curso', 'modules/student/fSelectSchoolYear', '62.0', 'LOCKABLE'), (63, 53, 'Asignar Área Académica', 'modules/employee/teacher/fAssignTeacherToAcademicArea', '63.0', 'LOCKABLE'), (64, 56, 'Nuevo Empleado', 'modules/employee/general/fNewEmployee', '64.0', 'LOCKABLE'), (65, 56, 'Actualizar Empleado', 'modules/employee/general/fSearchEmployee', '65.0', 'LOCKABLE'), (66, 1, 'Aulas', '#', '51.1', 'LOCKABLE'), (67, 66, 'Nueva Aula', 'modules/classroom/fNewClassroom', '67.0', 'LOCKABLE'), (68, 66, 'Actualizar Aula', 'modules/classroom/fSearchClassroom', '68.0', 'LOCKABLE'), (69, 52, 'Asignación de Perfiles', 'modules/user_profile/fSearchUser', '69.0', 'LOCKABLE'), (70, 1, 'Procesos', '#', '70.0', 'LOCKABLE'), (71, 70, 'Bloquear Procesos', 'modules/process/fSearchProfileProcess', '71.0', 'LOCKABLE'), (72, 2, 'Asignar/Reasignar Director de Area', 'modules/academic_area/fChangeAcademicAreaDirector', '48.8', 'LOCKABLE'), (73, 52, 'Representantes', '#', '56.1', 'LOCKABLE'), (74, 73, 'Nuevo Representante', 'modules/guardian/fNewGuardian', '74.0', 'LOCKABLE'), (75, 73, 'Actualizar Representante', 'modules/guardian/fSearchGuardian', '75.0', 'LOCKABLE'), (76, 39, 'Preinscripciones', '#', '76.0', 'LOCKABLE'), (77, 76, 'Periodos de Preinscripción', 'modules/school_year/fNewPreRegistrationPeriod', '77.0', 'LOCKABLE'), (78, 1, 'Transportes', '#', '51.2', 'LOCKABLE'), (79, 78, 'Conductores', '#', '79.0', 'LOCKABLE'), (80, 79, 'Nuevo Conductor', 'modules/bus_driver/fNewBusDriver', '80.0', 'LOCKABLE'), (81, 79, 'Actualizar Conductor', 'modules/bus_driver/fSearchBusDriver', '81.0', 'LOCKABLE'), (82, 78, 'Buses', '#', '82.0', 'LOCKABLE'), (83, 82, 'Nuevo Bus', 'modules/bus/fNewBus', '83.0', 'LOCKABLE'), (84, 82, 'Actualizar Bus', 'modules/bus/fSearchBus', '84.0', 'LOCKABLE'), (85, 78, 'Rutas', '#', '85.0', 'LOCKABLE'), (86, 85, 'Nueva Ruta', 'modules/route/fNewRoute', '86.0', 'LOCKABLE'), (87, 85, 'Actualizar Ruta', 'modules/route/fSearchRoute', '87.0', 'LOCKABLE'), (88, 78, 'Turnos', '#', '88.0', 'LOCKABLE'), (89, 88, 'Nuevo Turno', 'modules/shift/fNewShift', '89.0', 'LOCKABLE'), (90, 88, 'Actualizar Turno', 'modules/shift/fSearchShift', '90.0', 'LOCKABLE'), (91, 1, 'Tipos de Actividad', '#', '49.1', 'LOCKABLE'), (92, 91, 'Nuevo Tipo', 'modules/activity_type/fNewActivityType', '92.0', 'LOCKABLE'), (93, 91, 'Actualizar Tipo', 'modules/activity_type/fSearchActivityType', '93.0', 'LOCKABLE'), (94, 1, 'Criterios de Evaluación', '#', '49.2', 'LOCKABLE'), (95, 94, 'Nuevo Criterio', 'modules/grade_criteria/fNewGradeCriteria', '95.0', 'LOCKABLE'), (96, 94, 'Actualizar Criterio', 'modules/grade_criteria/fSearchGradeCriteria', '96.0', 'LOCKABLE'), (97, 39, 'Transportes', '#', '97.0', 'LOCKABLE'), (98, 97, 'Iniciar/Continuar', 'modules/transportation_setup/fNewTransportationSetup', '98.0', 'LOCKABLE'), (99, 52, 'Desactivar Usuario', 'modules/user/fSearchUser', '99.0', 'LOCKABLE'), (100, NULL, 'Estudiantes', '#', '100.0', 'LOCKABLE'), (101, 314, 'Documentación de Aprobados', 'modules/student_documents/fRegisterRequiredDocuments', '101.0', 'LOCKABLE'), (102, 1, 'Artículos', '#', '51.3', 'LOCKABLE'), (103, 102, 'Nuevo Artículo', 'modules/article/fNewArticle', '103.0', 'LOCKABLE'), (104, 102, 'Actualizar Artículo', 'modules/article/fSearchArticle', '104.0', 'LOCKABLE'), (105, 97, 'Asignar Usuarios', 'modules/transportation_setup/fSelectSchoolYear', '105.0', 'LOCKABLE'), (106, 39, 'Criterios y Actividades', '#', '57.2', 'LOCKABLE'), (107, 106, 'Materias Obligatorias', '#', '107.0', 'LOCKABLE'), (108, 107, 'Iniciar/Continuar', 'modules/year_activity_criteria_setup/', '108.0', 'LOCKABLE'), (109, 106, 'Materias Optativas', '#', '109.0', 'LOCKABLE'), (110, 109, 'Iniciar/Continuar', 'modules/year_opt_activity_criteria_setup/', '110.0', 'LOCKABLE'), (111, 1, 'Concepto de Pago', '#', '51.3', 'LOCKABLE'), (112, 111, 'Nuevo Concepto de Pago', 'modules/payment_concept/fNewPaymentConcept', '1.0', 'LOCKABLE'), (113, 111, 'Actualizar Concepto de Pago', 'modules/payment_concept/fSearchPaymentConcept', '2.0', 'LOCKABLE'), (114, 1, 'Impuestos', '#', '51.4', 'LOCKABLE'), (115, 114, 'Nuevo Impuesto', 'modules/tax/fNewTax', '1.0', 'LOCKABLE'), (116, 114, 'Actualizar Impuesto', 'modules/tax/fSearchTax', '2.0', 'LOCKABLE'), (117, 39, 'Rubros', '#', '114.0', 'LOCKABLE'), (118, 117, 'Iniciar/Continuar', 'modules/year_level_specialty_payment_concept/index', '1.0', 'LOCKABLE'), (119, 134, 'Actividades', '#', '116.0', 'LOCKABLE'), (122, 119, 'Calificar Actividad', '#', '3.0', 'LOCKABLE'), (123, 323, 'Recalificar Actividad', '#', '4.0', 'LOCKABLE'), (126, 122, 'Materia Obligatoria', 'modules/student_criteria_grade/fGradeActivityByCourse', '1.0', 'LOCKABLE'), (127, 122, 'Materia Optativa', 'modules/opt_student_criteria_grade/fOptionalSubjectGradeActivityByCourse', '2.0', 'LOCKABLE'), (130, 119, 'Ver Actividades', '#', '3.0', 'LOCKABLE'), (131, 130, 'Materias Obligatorias', 'modules/student_subject_activity/fSelectSchoolYear ', '1.0', 'LOCKABLE'), (132, 130, 'Materias Optativas', 'modules/student_opt_subject_activity/fSelectSchoolYear', '2.0', 'LOCKABLE'), (133, 61, 'Asignar Materia Optativa', 'modules/student_optional_subject/fSelectSchoolYear', '62.5', 'LOCKABLE'), (134, 310, 'Materias', '#', '134.0', 'LOCKABLE'), (135, 134, 'Plan de Estudios', 'modules/syllabus_files/fAssignSyllabusFiles', '1.0', 'LOCKABLE'), (136, 323, 'Plan de Estudios Profesores', 'modules/syllabus_files_change_log/fChangeSyllabusFiles', '1.0', 'LOCKABLE'), (137, 123, 'Materia Obligatoria', 'modules/grade_change_log/fGradeChangeLog', '1.0', 'LOCKABLE'), (138, 123, 'Materia Optativa', 'modules/opt_grade_change_log/fOptGradeChangeLog', '1.1', 'LOCKABLE'), (139, 311, 'Pensum de Estudios', 'modules/student_details/fSyllabusFilesDetail', '3.0', 'LOCKABLE'), (140, 310, 'Calendario Actividades Alumno', 'modules/activity/fStudentCalendarActivity', '0.5', 'LOCKABLE'), (141, 310, 'Calendario Representante', 'modules/activity/fGuardianCalendarActivity', '0.5', 'LOCKABLE'), (142, 119, 'Calendario Actividades Profesor', '#', '0.5', 'LOCKABLE'), (143, 199, 'Disciplina', '#', '143.0', 'LOCKABLE'), (144, 143, 'Disciplina General', 'modules/discipline/fDisciplineGeneralGrade', '1.0', 'LOCKABLE'), (145, 143, 'Disciplina x Materia', 'modules/student_criteria_grade/fGradeDisciplineByCourse', '1.0', 'LOCKABLE'), (146, 143, 'Recalificar Disciplina x Materia', 'modules/student_criteria_grade/fGradeDisciplineByCourseLog', '1.0', 'LOCKABLE'), (147, NULL, 'Centro de Mensajes', '#', '147.0', 'LOCKABLE'), (148, 147, 'Bandeja', 'modules/message/fInbox', '1.0', 'LOCKABLE'), (149, NULL, 'Reportes', '#', '149.0', 'LOCKABLE'), (150, 149, 'Profesores', '#', '1.0', 'LOCKABLE'), (151, 149, 'Estudiantes', '#', '2.0', 'LOCKABLE'), (152, 150, 'Area Académica', 'modules/reports/employee/teacher/fViewTeachersByArea', '1.0', 'LOCKABLE'), (153, 151, 'Lista detallada Curso/Optativa', 'modules/reports/student/fViewStudentsByCourseOrOptSubject', '1.0', 'LOCKABLE'), (154, 1, 'Centro de Mensajes', '#', '69.0', 'LOCKABLE'), (155, 154, 'Configurar Receptor', 'modules/message/fMessagesBetweenProfiles', '1.0', 'LOCKABLE'), (156, NULL, 'Financiero', '#', '148.0', 'LOCKABLE'), (157, 156, 'Realizar Cobro', 'modules/student_year_debts/fSearchStudentForPayingDebts', '2.0', 'LOCKABLE'), (158, 149, 'Usuarios', '#', '3.0', 'LOCKABLE'), (159, 158, 'Ingreso al Sistema', 'modules/reports/user/fUserAccessLog', '1.0', 'LOCKABLE'), (160, 147, 'Comunicaciones', '#', '1.0', 'LOCKABLE'), (161, 160, 'Enviar Comunicación', 'modules/message/fSendCommunication', '1.0', 'LOCKABLE'), (162, 1, 'Razones de Cambio', '#', '49.4', 'LOCKABLE'), (163, 162, 'Nueva Razón', 'modules/change_reason/fNewChangeReason', '1.0', 'LOCKABLE'), (164, 162, 'Actualizar Razón', 'modules/change_reason/fSearchChangeReason', '2.0', 'LOCKABLE'), (165, 39, 'Dirigentes de Curso', '#', '59.1', 'LOCKABLE'), (166, 165, 'Iniciar/Continuar', 'modules/course_director/fNewCourseDirector', '1.0', 'LOCKABLE'), (167, 39, 'Definición de Notas', '#', '59.1', 'LOCKABLE'), (168, 167, 'Equivalencia de Cualitativas', 'modules/qualitative_equivalence/fNewQualitativeEquivalence', '1.0', 'LOCKABLE'), (169, 167, 'Mínimo de Supletorios', 'modules/year_resit_exam_ranges/fNewYearResitExamRanges', '2.0', 'LOCKABLE'), (170, 39, 'Asignación de aulas', '#', '59.2', 'LOCKABLE'), (171, 170, 'Iniciar/Continuar', 'modules/year_subject_classroom/fAssignClassroomsToSubjects', '1.0', 'LOCKABLE'), (172, 52, 'Estudiantes', '#', '56.2', 'LOCKABLE'), (173, 172, 'Actualizar Datos', 'modules/student/fSelectStudent', '1.0', 'LOCKABLE'), (174, 172, 'Actualizar Representantes', 'modules/student_guardian/fAssignGuardiansToStudent', '1.1', 'LOCKABLE'), (175, 1, 'Mantenimiento', '#', '175.0', 'LOCKABLE'), (176, 175, 'Categoría de Artículos', '#', '1.0', 'LOCKABLE'), (177, 176, 'Nueva Categoría', 'modules/item_category/fNewItemCategory', '1.0', 'LOCKABLE'), (178, 176, 'Actualizar Categoría', 'modules/item_category/fSearchItemCategory', '1.1', 'LOCKABLE'), (179, 175, 'Proveedores', '#', '1.1', 'LOCKABLE'), (180, 179, 'Nuevo Proveedor', 'modules/provider/fNewProvider', '1.0', 'LOCKABLE'), (181, 179, 'Actualizar Proveedor', 'modules/provider/fSearchProvider', '1.1', 'LOCKABLE'), (182, 39, 'Materias de Grado', '#', '182.0', 'LOCKABLE'), (183, 182, 'Definir Materias Disponibles', 'modules/year_grade_subject/fSelectSchoolYear', '1.0', 'LOCKABLE'), (184, 182, 'Selección Materia x Estudiante', 'modules/grade_subject_score/fSelectSchoolYear', '1.1', 'LOCKABLE'), (185, 39, 'Calificaciones Especiales', '#', '185.0', 'LOCKABLE'), (186, 185, 'Iniciar/Continuar', 'modules/year_special_grade_setup/index', '1.0', 'LOCKABLE'), (187, 175, 'Destinos de Uso', '#', '3.0', 'LOCKABLE'), (188, 187, 'Nuevo Destino de Uso', 'modules/use_destination/fNewUseDestination', '1.0', 'LOCKABLE'), (189, 187, 'Actualizar Destino de Uso', 'modules/use_destination/fSearchUseDestination', '1.1', 'LOCKABLE'), (190, 1, 'Instituciones Financieras', '#', '51.3', 'LOCKABLE'), (191, 190, 'Nueva Institución', 'modules/financial_institution/fNewFinancialInstitution', '1.0', 'LOCKABLE'), (192, 190, 'Actualizar Institución', 'modules/financial_institution/fSearchFinancialInstitution', '1.1', 'LOCKABLE'), (193, 1, 'Tarjetas de Crédito', '#', '51.3', 'LOCKABLE'), (194, 193, 'Nueva Tarjeta', 'modules/credit_card/fNewCreditCard', '1.0', 'LOCKABLE'), (195, 193, 'Actualizar Tarjeta', 'modules/credit_card/fSearchCreditCard', '1.1', 'LOCKABLE'), (196, 175, 'Artículos de Mantenimiento', '#', '4.0', 'LOCKABLE'), (197, 196, 'Nuevo Artículo', 'modules/maintenance_item/fNewMaintenanceItem', '1.0', 'LOCKABLE'), (198, 196, 'Actualizar Artículo', 'modules/maintenance_item/fSearchMaintenanceItem', '1.1', 'LOCKABLE'), (199, NULL, 'Año Lectivo', '#', '45.0', 'LOCKABLE'), (200, 1, 'Materias del Ministerio', '#', '48.9', 'LOCKABLE'), (201, 200, 'Nueva Materia', 'modules/ministry_subject/fNewMinistrySubject', '1.0', 'LOCKABLE'), (202, 200, 'Actualizar Materia', 'modules/ministry_subject/fSearchMinistrySubject', '2.0', 'LOCKABLE'), (203, 39, 'Materias del Ministerio', '#', '203.0', 'LOCKABLE'), (204, 203, 'Definir Equivalencias', 'modules/subject_ministry_equivalence/fNewSubjectMinistryEquivalence', '1.0', 'LOCKABLE'), (205, 199, 'Registro de Novedades', '#', '205.0', 'LOCKABLE'), (206, 205, 'Registrar Novedad', 'modules/incident/fNewIncident', '1.0', 'LOCKABLE'), (207, NULL, 'Centro Médico', '#', '207.0', 'LOCKABLE'), (208, 207, 'Registrar Visita', 'modules/visits_medical_center/fNewVisit', '1.0', 'LOCKABLE'), (209, 142, 'Actividades Obligatorias', 'modules/activity/fTeacherCalendarActivity', '1.0', 'LOCKABLE'), (210, 142, 'Actividades Optativas', 'modules/opt_activity/fTeacherCalendarOptionalActivity', '1.0', 'LOCKABLE'), (211, 39, 'Disciplina', '#', '211.0', 'LOCKABLE'), (212, 211, 'Modo Calificación x Nivel', 'modules/level_section_year/fSearchYear', '1.0', 'LOCKABLE'), (213, 160, 'Crear Act. General', 'modules/general_activity/fGeneralCalendarActivity', '1.0', 'LOCKABLE'), (214, 149, 'Actividades', '#', '1.0', 'LOCKABLE'), (215, 214, 'Actividades x Curso o Materia Optativa', 'modules/reports/activity/fViewActivitiesByCourseOrSubject', '1.0', 'LOCKABLE'), (216, 314, 'Selección de Rubros para el Año', 'modules/student_year_debts/fChooseStudentForSettingDebts', '1.0', 'LOCKABLE'), (217, 156, 'Anular Factura', 'modules/student_year_debts/fSearchInvoiceToVoid', '3.0', 'LOCKABLE'), (218, 134, 'Exámenes de Recuperación', '#', '218.0', 'LOCKABLE'), (219, 218, 'Materias Obligatorias', '#', '1.0', 'LOCKABLE'), (220, 219, 'Configurar Exámenes', 'modules/subject_course_retest/fNewSubjectCourseRetest', '1.0', 'LOCKABLE'), (221, 219, 'Calififcar Exámenes', 'modules/subject_course_retest_student/fNewSubjectCourseRetestStudent', '2.0', 'LOCKABLE'), (222, 218, 'Materias Optativas', '#', '2.0', 'LOCKABLE'), (223, 222, 'Configurar Exámenes', 'modules/optional_subject_retest/fNewOptionalSubjectRetest', '1.0', 'LOCKABLE'), (224, 222, 'Calififcar Exámenes', 'modules/optional_subject_retest_student/fNewOptionalSubjectRetestStudent', '2.0', 'LOCKABLE'), (225, 199, 'Supletorios', '#', '225.0', 'LOCKABLE'), (226, 225, 'Calificar Exámenes', 'modules/resit_student/fGradeResitExam', '1.0', 'LOCKABLE'), (227, 199, 'Registro de Hermanos', '#', '227.0', 'LOCKABLE'), (230, 1, 'Descuentos', '#', '51.3', 'LOCKABLE'), (231, 230, 'Nuevo Descuento', 'modules/discount/fNewDiscount', '1.0', 'LOCKABLE'), (232, 230, 'Actualizar Descuento', 'modules/discount/fSearchDiscount', '2.0', 'LOCKABLE'), (233, 39, 'Descuentos', '#', '115.0', 'LOCKABLE'), (234, 233, 'Iniciar/Continuar', 'modules/year_discount/fAssignYearDiscount', '1.0', 'LOCKABLE'), (235, 1, 'Documentos Habilitantes', '#', '51.3', 'LOCKABLE'), (236, 235, 'Nuevo Documento', 'modules/qualifying_document/fNewQualifyingDocument', '1.0', 'LOCKABLE'), (237, 235, 'Actualizar Documento', 'modules/qualifying_document/fSearchQualifyingDocument', '2.0', 'LOCKABLE'), (238, 39, 'Documentos Requeridos', '#', '51.3', 'LOCKABLE'), (239, 238, 'Matrícula', 'modules/year_qualifying_document/fYearQualifyingDocument', '2.0', 'LOCKABLE'), (240, 225, 'Determinar Supletorios', 'modules/resit_student/fSelectLevel', '0.1', 'LOCKABLE'), (241, 199, 'Exámenes de Grado', '#', '225.1', 'LOCKABLE'), (242, 241, 'Calificar Exámenes', 'modules/grade_subject_score/fSelectSchoolYearToSetScore', '1.0', 'LOCKABLE'), (243, 199, 'Descuentos', '#', '45.1', 'LOCKABLE'), (244, 243, 'Asignar a Estudiante', 'modules/student_year_discount_values/fSearchStudentForAssignDiscounts', '1.0', 'LOCKABLE'), (245, 156, 'Mantenimiento', '#', '4.0', 'LOCKABLE'), (246, 245, 'Ingreso de Stock', 'modules/income_stock/fNewIncomeStock', '1.0', 'LOCKABLE'), (247, 245, 'Salida de Stock', 'modules/stock_request/fNewStockRequest', '1.0', 'LOCKABLE'), (248, 199, 'Calendario Actvidades Empleados', 'modules/employee/general/fActivitiesForEmployee', '248.0', 'LOCKABLE'), (249, 149, 'Ministerio', '#', '4.0', 'LOCKABLE'), (250, 249, 'Contrato de Servicios', 'modules/reports/ministry/fServiceContract', '1.0', 'LOCKABLE'), (251, 249, 'Estudiantes Matriculados', 'modules/reports/student_matriculated/fViewMatriculatedStudents', '2.0', 'LOCKABLE'), (252, 249, 'Acta de Matrícula', 'modules/reports/ministry/fRegistrationCertificate', '3.0', 'LOCKABLE'), (253, 249, 'Acta de Grado', 'modules/reports/school_certificate/fNewSchoolCertificate', '4.0', 'LOCKABLE'), (254, 167, 'Mínimo de Supletorios Ministerio', 'modules/year_resit_exam_ranges_ministry/fNewYearResitExamRangesMinistry', '3.0', 'LOCKABLE'), (255, 151, 'Notas por Periodo', 'modules/reports/student_grade/fViewStudentsGradesByPeriod', '1.1', 'LOCKABLE'), (256, 225, 'Determinar Supletorios Ministerio', 'modules/resit_student/fSelectLevelForMinistryResits', '0.2', 'LOCKABLE'), (257, 39, 'Orden de Niveles', 'modules/level_section_year/fDefineLevelOrder', '40.1', 'LOCKABLE'), (258, 249, 'Notas Materias de Grado', 'modules/reports/ministry/fSelectSchoolYearToGradeSubjectReport', '5.0', 'LOCKABLE'), (259, 249, 'Certificado de Matrícula', 'modules/reports/ministry/fSelectSchoolYearToRegistrationRecord', '6.0', 'LOCKABLE'), (260, 249, 'Calificaciones Finales', 'modules/reports/ministry/fViewFinalStudentGrades', '7.0', 'LOCKABLE'), (261, 321, 'Preaprobación Preinscritos', 'modules/pre_registration/academic_board/fSelectLevel', '49.0', 'LOCKABLE'), (262, 249, 'Exámenes Supletorios', 'modules/reports/ministry/fResitTestScoreReport', '8.0', 'LOCKABLE'), (263, 199, 'Administración General de Usuario', 'modules/user/fUserGeneralSearch', '44.0', 'LOCKABLE'), (264, 249, 'Certificado Notas Finales', 'modules/reports/ministry/fNewFinalSubjectScores', '9.0', 'LOCKABLE'), (265, 321, 'Aprobación Preinscritos', 'modules/pre_registration/principal/fSelectLevel', '49.2', 'LOCKABLE'), (266, 238, 'Preinscripción', 'modules/year_pre_registration_document/fYearPreRegistrationDocument', '1.0', 'LOCKABLE'), (267, 39, 'Replicar Configuración de Año', 'modules/replicate_configuration/fNewReplication', '213.0', 'LOCKABLE'), (268, 1, 'Métodos de Pago', '#', '51.4', 'LOCKABLE'), (269, 268, 'Nuevo Método', 'modules/payment_method/fNewPaymentMethod', '269.0', 'LOCKABLE'), (270, 268, 'Actualizar Método', 'modules/payment_method/fSearchPaymentMethod', '270.0', 'LOCKABLE'), (271, 52, 'Restablecer Contraseña', 'modules/user/fSearchUserToPasswordReset', '271.0', 'LOCKABLE'), (272, 321, 'Preinscripción Colegio', '#', '47.1', 'LOCKABLE'), (273, 272, 'Nueva Preinscripción', 'modules/pre_registration/school/fNewPreRegistration', '1.0', 'LOCKABLE'), (274, 272, 'Actualizar Preinscripción', 'modules/pre_registration/school/fSelectLevel', '2.0', 'LOCKABLE'), (275, 321, 'Validar Documentos Requeridos', 'modules/student_year_document/fStudentYearDocument', '275.0', 'LOCKABLE'), (276, 199, 'Asistencia', '#', '143.1', 'LOCKABLE'), (277, 276, 'Registro Asistencia', 'modules/attendance/fRegisterAttendance', '277.0', 'LOCKABLE'), (278, 199, 'Promoción de Estudiantes', 'modules/studentPromotion/fNewStudentPromotion', '278.0', 'LOCKABLE'), (279, 151, 'Lista Simple x Curso', 'modules/reports/student/fSelectSchoolYearToStudentListByCourse', '279.0', 'LOCKABLE'), (280, 151, 'Lista Representates y Representados', 'modules/reports/guardian/fSelectSchoolYearToGuardiansReport', '280.0', 'LOCKABLE'), (281, 151, 'Calificaciones Finales', 'modules/reports/report_card/fFinalSchoolScores', '281.0', 'LOCKABLE'), (282, 151, 'Informe de Evaluación', 'modules/reports/period_evaluation/fEvaluationReport', '282.0', 'LOCKABLE'), (283, 151, 'Lista de Contactos x Curso', 'modules/reports/contacts_by_student/fStudentsContactsByCourse', '283.0', 'LOCKABLE'), (284, 151, 'Lista de Contactos x Estudiante', 'modules/reports/contacts_by_student/fContactsListByStudent', '284.0', 'LOCKABLE'), (285, 249, 'Certificado de Promoción', 'modules/reports/ministry/fYearPromotionCertificate', '285.0', 'LOCKABLE'), (286, 249, 'Certificado de Aptitud', 'modules/reports/ministry/fCertificateOfAttainment', '286.0', 'LOCKABLE'), (287, NULL, 'Biblioteca', '#', '287.0', 'LOCKABLE'), (288, 287, 'Secciones', '#', '1.0', 'LOCKABLE'), (289, 288, 'Nueva Sección', 'modules/library_section/fNewLibrarySection', '1.0', 'LOCKABLE'), (290, 288, 'Actualizar Sección', 'modules/library_section/fSearchLibrarySection', '2.0', 'LOCKABLE'), (291, 287, 'Categoría de Libro', '#', '2.0', 'LOCKABLE'), (292, 291, 'Nueva Categoría', 'modules/book_category/fNewBookCategory', '1.0', 'LOCKABLE'), (293, 291, 'Actualizar Categoría', 'modules/book_category/fSearchBookCategory', '2.0', 'LOCKABLE'), (294, 287, 'Registrar Libro', 'modules/book/fRegisterBook', '3.0', 'LOCKABLE'), (295, 287, 'Busqueda de Libro', 'modules/loan/fNewBookSearch', '4.0', 'LOCKABLE'), (296, 287, 'Prestamos', '#', '5.0', 'LOCKABLE'), (297, 296, 'Libros', 'modules/loan/fNewBookLoan', '1.0', 'LOCKABLE'), (298, 296, 'Equipos y Aulas', 'modules/loan/fNewEquipmentOrStudyPlaceLoan', '2.0', 'LOCKABLE'), (299, 287, 'Devoluciones', 'modules/loan_return/fNewLoanReturn', '6.0', 'LOCKABLE'), (300, 351, 'Reporte Ficha Médica', 'modules/reports/medical_file/fMedicalFile', '2.0', 'LOCKABLE'), (301, 287, 'Equipos', '#', '0.1', 'LOCKABLE'), (302, 301, 'Nuevo Equipo', 'modules/equipment/fNewEquipment', '1.0', 'LOCKABLE'), (303, 301, 'Actualizar Equipo', 'modules/equipment/fSearchEquipment', '2.0', 'LOCKABLE'), (304, 287, 'Lugares de estudio', '#', '0.2', 'LOCKABLE'), (305, 304, 'Nuevo Lugar', 'modules/study_place/fNewStudyPlace', '1.0', 'LOCKABLE'), (306, 304, 'Actualizar Lugar', 'modules/study_place/fSearchStudyPlace', '2.0', 'LOCKABLE'), (307, 39, 'Horarios', '#', '59.3', 'LOCKABLE'), (308, 199, 'Arrancar Año Lectivo', 'modules/school_year/fStartSchoolYear', '43.0', 'LOCKABLE'), (309, NULL, 'Desempeño Escolar', '#', '0.1', 'LOCKABLE'), (310, NULL, 'Agenda', '#', '0.1', 'LOCKABLE'), (311, NULL, 'Información General', '#', '0.1', 'LOCKABLE'), (312, NULL, 'Estado de Cuenta', '#', '0.1', 'LOCKABLE'), (314, NULL, 'Inscripciones', '#', '0.1', 'LOCKABLE'), (315, 309, 'Calificaciones', 'modules/student_details/fGradesByStudent', '1.0', 'LOCKABLE'), (316, 309, 'Asistencia', 'modules/student_details/fAttendanceDetail', '2.0', 'LOCKABLE'), (317, 311, 'Compañeros', 'modules/student_details/fClassmateDetail', '1.0', 'LOCKABLE'), (318, 311, 'Transporte', 'modules/student_details/fTransportationDetail', '2.0', 'LOCKABLE'), (319, 311, 'Horario', 'modules/student_details/fScheduleDetail', '4.0', 'LOCKABLE'), (320, 312, 'Ver Cuenta', 'modules/guardian/account_balance/fViewAccountBalance', '1.0', 'LOCKABLE'), (321, 199, 'Preinscripciones', '#', '45.0', 'LOCKABLE'), (322, 199, 'Materias', '#', '134.0', 'LOCKABLE'), (323, 322, 'Actividades', '#', '1.0', 'LOCKABLE'), (324, 156, 'Venta de Artículos', 'modules/student_year_debts/fSearchStudentForShopping', '3.0', 'LOCKABLE'), (325, 321, 'Selección de rubros adicionales', 'modules/student_year_debts/fChooseStudentForOptionalDebts', '49.3', 'LOCKABLE'), (326, 199, 'Inscripciones', 'modules/registration/fNewRegistration', '44.9', 'LOCKABLE'), (327, 149, 'Colegio', '#', '327.0', 'LOCKABLE'), (328, 327, 'Valores Pagados', 'modules/reports/payed_debts/fViewPayedDebts', '1.0', 'LOCKABLE'), (329, 327, 'Notas Finales', 'modules/reports/student_grade/fViewFinalStudentsGrades', '2.0', 'LOCKABLE'), (330, 1, 'Grupos de Convenio de Pago', '#', '330.0', 'LOCKABLE'), (331, 330, 'Nuevo Grupo', 'modules/payment_agreement_group/fNewPaymentAgreementGroup', '1.0', 'LOCKABLE'), (332, 330, 'Actualizar Grupo', 'modules/payment_agreement_group/fUpdatePaymentAgreementGroup', '2.0', 'LOCKABLE'), (333, 199, 'Asignar Convenio de Pago', 'modules/payment_agreement_group/fSelectSchoolYearToAssignPaymentAgreement', '45.2', 'LOCKABLE'), (334, 327, 'Facturas Sin Pagar', 'modules/reports/unpayed_debts/fViewUnpayedDebts', '3.0', 'LOCKABLE'), (335, 327, 'Estudiantes por Rubro', 'modules/reports/students_by_debts/fSelectSchoolYearToStudentsByDebtsReport', '4.0', 'LOCKABLE'), (336, 321, 'Verificación de Pagos Habilitantes', 'modules/student_year_mandatory_payment/fCheckPaymentByStudent', '336.0', 'LOCKABLE'), (337, 160, 'Premiación Alumnos Destacados', 'modules/top_students_awards/fNewTopStudentsAwards', '3.0', 'LOCKABLE'), (338, 149, 'Acta de Compromiso', 'modules/reports/letter_of_commitment/fLetterOfCommitment', '5.0', 'LOCKABLE'), (339, 287, 'Registrar ejemplar de Libro', 'modules/book/fRegisterBookCopy', '3.1', 'LOCKABLE'), (340, 156, 'Cambiar Nombre Facturas', 'modules/invoice/fChooseStudentToChangeInvoiceData', '3.1', 'LOCKABLE'), (341, 156, 'Impresión Facturas en Bloque ', 'modules/invoice/fSelectSchoolYearToPrintInvoices', '3.2', 'LOCKABLE'), (342, 327, 'Acta Matrícula', 'modules/reports/school_certificate/fRegistrationCertificate', '0.1', 'LOCKABLE'), (343, 61, 'Cambio de Paralelo', 'modules/class_group/fChangeStudentClassGroup', '62.6', 'LOCKABLE'), (344, 156, 'Registro corriente diferido', 'modules/student_year_debts/fSearchStudentForCurrentDeferred', '2.1', 'LOCKABLE'), (345, 156, 'Impresión de Factura', 'modules/invoice/fSelectSchoolYearToPrintInvoice', '3.2', 'LOCKABLE'), (346, 156, 'Selección Rubros Adicionales', 'modules/student_year_debts/fChooseStudentForOptionalDebts', '1.0', 'LOCKABLE'), (347, 61, 'Cambio de Nivel/Especialidad', 'modules/level/fChangeStudentLevel', '62.7', 'LOCKABLE'), (348, 207, 'Visitantes', '#', '2.0', 'LOCKABLE'), (349, 348, 'Nuevo Visitante', 'modules/guest/fNewGuest', '1.0', 'LOCKABLE'), (350, 348, 'Actualizar Visitante', 'modules/guest/fSearchGuest', '2.0', 'LOCKABLE'), (351, 207, 'Ficha Médica', '#', '62.7', 'LOCKABLE'), (352, 351, 'Nueva/Actualizar', 'modules/medical_file/fSelectPatient', '1.0', 'LOCKABLE'), (353, 1, 'Destrezas', '#', '49.3', 'LOCKABLE'), (354, 353, 'Nueva Destreza', 'modules/skills/fNewSkill', '1.0', 'LOCKABLE'), (355, 353, 'Actualizar Destreza', 'modules/skills/fSearchSkill', '2.0', 'LOCKABLE'), (356, 39, 'Observaciones Académicas Por Nivel', 'modules/user_course_comment_setup/fUserCourseCommentSetup', '40.2', 'LOCKABLE'), (357, 307, 'Configuración Manual', 'modules/schedule/fScheduleDefinition', '1.0', 'LOCKABLE'), (358, 307, 'Generación Automática', '#', '2.0', 'LOCKABLE'), (359, 358, 'Ejecutar Proceso', 'modules/schedule/fAutoScheduleDefinition', '1.0', 'LOCKABLE'), (360, 358, 'Selección de Resultados', '', '2.0', 'LOCKABLE'), (361, 199, 'Registro de Observaciones Académicas', 'modules/user_course_comment_setup/fSetCommentByCourse', '135.0', 'LOCKABLE'), (362, 39, 'Ver Configuración Actual', 'modules/school_year/fViewCurrentConfiguration', '212.0', 'LOCKABLE'), (363, 199, 'Examen por Periodo', '#', '226.0', 'LOCKABLE'), (364, 363, 'Calificar Examen', 'modules/student_period_exam/fGradePeriodExam', '1.0', 'LOCKABLE'); -- -- Dumping data for table 'profile' -- INSERT INTO profile (serial_prf, name_prf, type_prf, status_prf, owner_prf) VALUES (1, 'Administrador', 'INTERNAL', 'ACTIVE', 'SYSTEM'), (2, 'Representante', 'EXTERNAL', 'ACTIVE', 'SYSTEM'), (3, 'Estudiante', 'EXTERNAL', 'ACTIVE', 'SYSTEM'), (4, 'Docente', 'INTERNAL', 'ACTIVE', 'SYSTEM'), (5, 'Administrativo', 'INTERNAL', 'ACTIVE', 'SYSTEM'); -- -- Dumping data for table 'profile_process' -- INSERT INTO profile_process (serial_prf, serial_prc, status_ppr) VALUES (1, 1, 'ACTIVE'), (1, 2, 'ACTIVE'), (1, 3, 'ACTIVE'), (1, 4, 'ACTIVE'), (1, 5, 'ACTIVE'), (1, 6, 'ACTIVE'), (1, 7, 'ACTIVE'), (1, 8, 'ACTIVE'), (1, 9, 'ACTIVE'), (1, 10, 'ACTIVE'), (1, 11, 'ACTIVE'), (1, 12, 'ACTIVE'), (1, 13, 'ACTIVE'), (1, 14, 'ACTIVE'), (1, 15, 'ACTIVE'), (1, 16, 'ACTIVE'), (1, 17, 'ACTIVE'), (1, 18, 'ACTIVE'), (1, 19, 'ACTIVE'), (1, 20, 'ACTIVE'), (1, 21, 'ACTIVE'), (1, 22, 'ACTIVE'), (1, 23, 'ACTIVE'), (1, 24, 'ACTIVE'), (1, 25, 'ACTIVE'), (1, 26, 'ACTIVE'), (1, 27, 'ACTIVE'), (1, 28, 'ACTIVE'), (1, 29, 'ACTIVE'), (1, 30, 'ACTIVE'), (1, 31, 'ACTIVE'), (1, 32, 'ACTIVE'), (1, 33, 'ACTIVE'), (1, 34, 'ACTIVE'), (1, 35, 'ACTIVE'), (1, 36, 'ACTIVE'), (1, 37, 'ACTIVE'), (1, 38, 'ACTIVE'), (1, 39, 'ACTIVE'), (1, 40, 'ACTIVE'), (1, 41, 'ACTIVE'), (1, 42, 'ACTIVE'), (1, 43, 'ACTIVE'), (1, 44, 'ACTIVE'), (1, 48, 'ACTIVE'), (1, 49, 'ACTIVE'), (1, 50, 'ACTIVE'), (1, 51, 'ACTIVE'), (1, 52, 'ACTIVE'), (1, 54, 'ACTIVE'), (1, 55, 'ACTIVE'), (1, 56, 'ACTIVE'), (1, 57, 'ACTIVE'), (1, 58, 'ACTIVE'), (1, 59, 'ACTIVE'), (1, 60, 'ACTIVE'), (1, 61, 'ACTIVE'), (1, 62, 'ACTIVE'), (1, 63, 'ACTIVE'), (1, 64, 'ACTIVE'), (1, 65, 'ACTIVE'), (1, 66, 'ACTIVE'), (1, 67, 'ACTIVE'), (1, 68, 'ACTIVE'), (1, 69, 'ACTIVE'), (1, 70, 'ACTIVE'), (1, 71, 'ACTIVE'), (1, 72, 'ACTIVE'), (1, 74, 'ACTIVE'), (1, 75, 'ACTIVE'), (1, 77, 'ACTIVE'), (1, 80, 'ACTIVE'), (1, 81, 'ACTIVE'), (1, 83, 'ACTIVE'), (1, 84, 'ACTIVE'), (1, 86, 'ACTIVE'), (1, 87, 'ACTIVE'), (1, 89, 'ACTIVE'), (1, 90, 'ACTIVE'), (1, 92, 'ACTIVE'), (1, 93, 'ACTIVE'), (1, 95, 'ACTIVE'), (1, 96, 'ACTIVE'), (1, 98, 'ACTIVE'), (1, 99, 'ACTIVE'), (1, 103, 'ACTIVE'), (1, 104, 'ACTIVE'), (1, 105, 'ACTIVE'), (1, 107, 'ACTIVE'), (1, 108, 'ACTIVE'), (1, 109, 'ACTIVE'), (1, 110, 'ACTIVE'), (1, 111, 'ACTIVE'), (1, 112, 'ACTIVE'), (1, 113, 'ACTIVE'), (1, 114, 'ACTIVE'), (1, 115, 'ACTIVE'), (1, 116, 'ACTIVE'), (1, 117, 'ACTIVE'), (1, 118, 'ACTIVE'), (1, 133, 'ACTIVE'), (1, 136, 'ACTIVE'), (1, 137, 'ACTIVE'), (1, 138, 'ACTIVE'), (1, 144, 'ACTIVE'), (1, 146, 'ACTIVE'), (1, 148, 'ACTIVE'), (1, 152, 'ACTIVE'), (1, 153, 'ACTIVE'), (1, 155, 'ACTIVE'), (1, 157, 'ACTIVE'), (1, 159, 'ACTIVE'), (1, 161, 'ACTIVE'), (1, 163, 'ACTIVE'), (1, 164, 'ACTIVE'), (1, 166, 'ACTIVE'), (1, 168, 'ACTIVE'), (1, 169, 'ACTIVE'), (1, 171, 'ACTIVE'), (1, 173, 'ACTIVE'), (1, 174, 'ACTIVE'), (1, 177, 'ACTIVE'), (1, 178, 'ACTIVE'), (1, 180, 'ACTIVE'), (1, 181, 'ACTIVE'), (1, 183, 'ACTIVE'), (1, 184, 'ACTIVE'), (1, 186, 'ACTIVE'), (1, 188, 'ACTIVE'), (1, 189, 'ACTIVE'), (1, 191, 'ACTIVE'), (1, 192, 'ACTIVE'), (1, 194, 'ACTIVE'), (1, 195, 'ACTIVE'), (1, 197, 'ACTIVE'), (1, 198, 'ACTIVE'), (1, 201, 'ACTIVE'), (1, 202, 'ACTIVE'), (1, 204, 'ACTIVE'), (1, 206, 'ACTIVE'), (1, 208, 'ACTIVE'), (1, 212, 'ACTIVE'), (1, 213, 'ACTIVE'), (1, 215, 'ACTIVE'), (1, 217, 'ACTIVE'), (1, 231, 'ACTIVE'), (1, 232, 'ACTIVE'), (1, 234, 'ACTIVE'), (1, 236, 'ACTIVE'), (1, 237, 'ACTIVE'), (1, 239, 'ACTIVE'), (1, 240, 'ACTIVE'), (1, 242, 'ACTIVE'), (1, 244, 'ACTIVE'), (1, 246, 'ACTIVE'), (1, 247, 'ACTIVE'), (1, 250, 'ACTIVE'), (1, 251, 'ACTIVE'), (1, 252, 'ACTIVE'), (1, 253, 'ACTIVE'), (1, 254, 'ACTIVE'), (1, 255, 'ACTIVE'), (1, 256, 'ACTIVE'), (1, 257, 'ACTIVE'), (1, 258, 'ACTIVE'), (1, 259, 'ACTIVE'), (1, 260, 'ACTIVE'), (1, 261, 'ACTIVE'), (1, 262, 'ACTIVE'), (1, 263, 'ACTIVE'), (1, 264, 'ACTIVE'), (1, 265, 'ACTIVE'), (1, 266, 'ACTIVE'), (1, 267, 'ACTIVE'), (1, 269, 'ACTIVE'), (1, 270, 'ACTIVE'), (1, 271, 'ACTIVE'), (1, 273, 'ACTIVE'), (1, 274, 'ACTIVE'), (1, 275, 'ACTIVE'), (1, 277, 'ACTIVE'), (1, 278, 'ACTIVE'), (1, 279, 'ACTIVE'), (1, 280, 'ACTIVE'), (1, 281, 'ACTIVE'), (1, 282, 'ACTIVE'), (1, 283, 'ACTIVE'), (1, 284, 'ACTIVE'), (1, 285, 'ACTIVE'), (1, 286, 'ACTIVE'), (1, 289, 'ACTIVE'), (1, 290, 'ACTIVE'), (1, 292, 'ACTIVE'), (1, 293, 'ACTIVE'), (1, 294, 'ACTIVE'), (1, 295, 'ACTIVE'), (1, 297, 'ACTIVE'), (1, 298, 'ACTIVE'), (1, 299, 'ACTIVE'), (1, 300, 'ACTIVE'), (1, 302, 'ACTIVE'), (1, 303, 'ACTIVE'), (1, 305, 'ACTIVE'), (1, 306, 'ACTIVE'), (1, 308, 'ACTIVE'), (1, 324, 'ACTIVE'), (1, 325, 'ACTIVE'), (1, 326, 'ACTIVE'), (1, 328, 'ACTIVE'), (1, 329, 'ACTIVE'), (1, 331, 'ACTIVE'), (1, 332, 'ACTIVE'), (1, 333, 'ACTIVE'), (1, 334, 'ACTIVE'), (1, 335, 'ACTIVE'), (1, 336, 'ACTIVE'), (1, 337, 'ACTIVE'), (1, 338, 'ACTIVE'), (1, 339, 'ACTIVE'), (1, 340, 'ACTIVE'), (1, 341, 'ACTIVE'), (1, 342, 'ACTIVE'), (1, 343, 'ACTIVE'), (1, 344, 'ACTIVE'), (1, 345, 'ACTIVE'), (1, 346, 'ACTIVE'), (1, 347, 'ACTIVE'), (1, 349, 'ACTIVE'), (1, 350, 'ACTIVE'), (1, 352, 'ACTIVE'), (1, 354, 'ACTIVE'), (1, 355, 'ACTIVE'), (1, 356, 'ACTIVE'), (1, 357, 'ACTIVE'), (1, 359, 'ACTIVE'), (1, 360, 'ACTIVE'), (1, 361, 'ACTIVE'), (1, 362, 'ACTIVE'), (1, 364, 'ACTIVE'), (2, 46, 'ACTIVE'), (2, 47, 'ACTIVE'), (2, 101, 'ACTIVE'), (2, 139, 'ACTIVE'), (2, 141, 'ACTIVE'), (2, 148, 'ACTIVE'), (2, 216, 'ACTIVE'), (2, 315, 'ACTIVE'), (2, 316, 'ACTIVE'), (2, 317, 'ACTIVE'), (2, 318, 'ACTIVE'), (2, 319, 'ACTIVE'), (2, 320, 'ACTIVE'), (3, 131, 'ACTIVE'), (3, 132, 'ACTIVE'), (3, 139, 'ACTIVE'), (3, 140, 'ACTIVE'), (3, 148, 'ACTIVE'), (3, 315, 'ACTIVE'), (3, 316, 'ACTIVE'), (3, 317, 'ACTIVE'), (3, 318, 'ACTIVE'), (3, 319, 'ACTIVE'), (4, 126, 'ACTIVE'), (4, 127, 'ACTIVE'), (4, 135, 'ACTIVE'), (4, 145, 'ACTIVE'), (4, 148, 'ACTIVE'), (4, 209, 'ACTIVE'), (4, 210, 'ACTIVE'), (4, 220, 'ACTIVE'), (4, 221, 'ACTIVE'), (4, 223, 'ACTIVE'), (4, 224, 'ACTIVE'), (4, 226, 'ACTIVE'), (5, 148, 'ACTIVE'), (5, 248, 'ACTIVE'), (5, 48, 'ACTIVE'); -- -- Dumping data for table 'provider' -- -- -- Dumping data for table 'psychological_file' -- -- -- Dumping data for table 'qualifying_document' -- -- -- Dumping data for table 'qualitative_equivalence' -- -- -- Dumping data for table 'request_detail' -- -- -- Dumping data for table 'resit_change_log' -- -- -- Dumping data for table 'resit_student' -- -- -- Dumping data for table 'route' -- -- -- Dumping data for table 'schedule' -- -- -- Dumping data for table 'school_setup' -- INSERT INTO school_setup (serial_ste, serial_crr, name_sst, city_sst, address_sst, phone1_sst, phone2_sst, phone3_sst, contact_name_sst, contact_phone_sst, logo_sst, slogan_sst, main_color_sst, secondary_color_sst) VALUES (19, 47, 'COLEGIO DE PRUEBA', 'Quito', 'Calle de prueba y la que cruza', '2142142', '2555777', '2334455', 'Jose Prueba', '24555442', '9e32c5.png', 'Este es un slogan para probar', '558215', 'b0b31d'); -- -- Dumping data for table 'school_year' -- INSERT INTO school_year (serial_scy, start_date_scy, end_date_scy, status_scy, name_scy, grade_precision_scy, invoice_due_max_day_scy, ministry_max_grade_scy, school_max_grade_scy, matricule_process_scy) VALUES (1, '2011-07-05', '2012-04-05', 'NEW', 'Año lectivo 2011-2012', 2, 20, '20.00', '20.00', 'INACTIVE'), (2, '2012-08-27', '2013-05-27', 'NEW', 'Año lectivo 2012-2013', 2, 20, '20.00', '20.00', 'INACTIVE'); -- -- Dumping data for table 'section' -- INSERT INTO section (serial_set, name_set, description_set, status_set, type_set) VALUES (1, 'Primaria', 'Primaria', 'ACTIVE', 'DAY'), (2, 'Secundaria', 'Secundaria', 'ACTIVE', 'DAY'), (3, 'Kinder', 'Kinder', 'ACTIVE', 'DAY'); -- -- Dumping data for table 'section_by_year' -- INSERT INTO section_by_year (serial_scy, serial_set, status_sby) VALUES (1, 1, 'ACTIVE'), (1, 2, 'ACTIVE'), (1, 3, 'ACTIVE'); -- -- Dumping data for table 'shift' -- -- -- Dumping data for table 'skills' -- -- -- Dumping data for table 'specialty' -- INSERT INTO specialty (serial_spt, name_spt, description_spt, status_spt) VALUES (1, '* Ninguna', 'Opción para todo nivel que no tiene una especialización', 'ACTIVE'), (2, 'Fisico Matematico', 'Fisico Matematico', 'ACTIVE'), (3, 'Quimico Biologo', 'Quimico Biologo', 'ACTIVE'); -- -- Dumping data for table 'special_grade_change_log' -- -- -- Dumping data for table 'state' -- INSERT INTO state (serial_ste, serial_cou, name_ste, status_ste) VALUES (1, 61, 'Azuay', 'ACTIVE'), (2, 61, 'Bolívar', 'ACTIVE'), (3, 61, 'Cañar', 'ACTIVE'), (4, 61, 'Carchi', 'ACTIVE'), (5, 61, 'Chimborazo', 'ACTIVE'), (6, 61, 'Cotopaxi', 'ACTIVE'), (7, 61, 'El Oro', 'ACTIVE'), (8, 61, 'Esmeraldas', 'ACTIVE'), (9, 61, 'Galápagos', 'ACTIVE'), (10, 61, 'Guayas', 'ACTIVE'), (11, 61, 'Imbabura', 'ACTIVE'), (12, 61, 'Loja', 'ACTIVE'), (13, 61, 'Los Ríos', 'ACTIVE'), (14, 61, 'Manabí', 'ACTIVE'), (15, 61, 'Morona Santiago', 'ACTIVE'), (16, 61, 'Napo', 'ACTIVE'), (17, 61, 'Orellana', 'ACTIVE'), (18, 61, 'Pastaza', 'ACTIVE'), (19, 61, 'Pichincha', 'ACTIVE'), (20, 61, 'Santa Elena', 'ACTIVE'), (21, 61, 'Sto.Domingo de los Tsáchilas', 'ACTIVE'), (22, 61, 'Sucumbíos', 'ACTIVE'), (23, 61, 'Tungurahua', 'ACTIVE'), (24, 61, 'Zamora Chinchipe', 'ACTIVE'), (25, 217, 'Alabama', 'ACTIVE'), (26, 217, 'Alaska', 'ACTIVE'), (27, 217, 'Arizona', 'ACTIVE'), (28, 217, 'Arkansas', 'ACTIVE'), (29, 217, 'California', 'ACTIVE'), (30, 217, 'Colorado', 'ACTIVE'), (31, 217, 'Connecticut', 'ACTIVE'), (32, 217, 'Delaware', 'ACTIVE'), (33, 217, 'Dist. of Columbia', 'ACTIVE'), (34, 217, 'Florida', 'ACTIVE'), (35, 217, 'Georgia', 'ACTIVE'), (36, 217, 'Guam', 'ACTIVE'), (37, 217, 'Hawaii', 'ACTIVE'), (38, 217, 'Idaho', 'ACTIVE'), (39, 217, 'Illinois', 'ACTIVE'), (40, 217, 'Indiana', 'ACTIVE'), (41, 217, 'Iowa', 'ACTIVE'), (42, 217, 'Kansas', 'ACTIVE'), (43, 217, 'Kentucky', 'ACTIVE'), (44, 217, 'Louisiana', 'ACTIVE'), (45, 217, 'Maine', 'ACTIVE'), (46, 217, 'Maryland', 'ACTIVE'), (47, 217, 'Massachusetts', 'ACTIVE'), (48, 217, 'Michigan', 'ACTIVE'), (49, 217, 'Minnesota', 'ACTIVE'), (50, 217, 'Mississippi', 'ACTIVE'), (51, 217, 'Missouri', 'ACTIVE'), (52, 217, 'Montana', 'ACTIVE'), (53, 217, 'Nebraska', 'ACTIVE'), (54, 217, 'Nevada', 'ACTIVE'), (55, 217, 'New Hampshire', 'ACTIVE'), (56, 217, 'New Jersey', 'ACTIVE'), (57, 217, 'New Mexico', 'ACTIVE'), (58, 217, 'New York', 'ACTIVE'), (59, 217, 'North Carolina', 'ACTIVE'), (60, 217, 'North Dakota', 'ACTIVE'), (61, 217, 'Ohio', 'ACTIVE'), (62, 217, 'Oklahoma', 'ACTIVE'), (63, 217, 'Oregon', 'ACTIVE'), (64, 217, 'Pennsylvania', 'ACTIVE'), (65, 217, 'Puerto Rico', 'ACTIVE'), (66, 217, 'Rhode Island', 'ACTIVE'), (67, 217, 'South Carolina', 'ACTIVE'), (68, 217, 'South Dakota', 'ACTIVE'), (69, 217, 'Tennessee', 'ACTIVE'), (70, 217, 'Texas', 'ACTIVE'), (71, 217, 'Utah', 'ACTIVE'), (72, 217, 'Vermont', 'ACTIVE'), (73, 217, 'Virginia', 'ACTIVE'), (74, 217, 'Virgin Islands', 'ACTIVE'), (75, 217, 'Washington', 'ACTIVE'), (76, 217, 'West Virginia', 'ACTIVE'), (77, 217, 'Wisconsin', 'ACTIVE'), (78, 217, 'Wyoming', 'ACTIVE'), (79, 50, 'Pinar del Río', 'ACTIVE'), (80, 50, 'Artemisa', 'ACTIVE'), (81, 50, 'La Habana', 'ACTIVE'), (82, 50, 'Mayabeque', 'ACTIVE'), (83, 50, 'Matanzas', 'ACTIVE'), (84, 50, 'Cienfuegos', 'ACTIVE'), (85, 50, 'Villa Clara', 'ACTIVE'), (86, 50, 'Sancti Spíritus', 'ACTIVE'), (87, 50, 'Ciego de Ávila', 'ACTIVE'), (88, 50, 'Camagüey', 'ACTIVE'), (89, 50, 'Las Tunas', 'ACTIVE'), (90, 50, 'Granma', 'ACTIVE'), (91, 50, 'Holguín', 'ACTIVE'), (92, 50, 'Santiago de Cuba', 'ACTIVE'), (93, 50, 'Guantánamo', 'ACTIVE'), (94, 50, 'Isla de la Juventud', 'ACTIVE'), (95, 55, 'Baden-Wurttemberg', 'ACTIVE'), (96, 55, 'Bavaria', 'ACTIVE'), (97, 55, 'Berlin', 'ACTIVE'), (98, 55, 'Brandenburg', 'ACTIVE'), (99, 55, 'Bremen', 'ACTIVE'), (100, 55, 'Hamburg', 'ACTIVE'), (101, 55, 'Hesse', 'ACTIVE'), (102, 55, 'Lower Saxony', 'ACTIVE'), (103, 55, 'Mecklenburg-West Pomerania', 'ACTIVE'), (104, 55, 'North Rhine-Westphalia', 'ACTIVE'), (105, 55, 'Rhineland-Palatinate', 'ACTIVE'), (106, 55, 'Saarland', 'ACTIVE'), (107, 55, 'Saxony', 'ACTIVE'), (108, 55, 'Saxony-Anhalt', 'ACTIVE'), (109, 55, 'Schleswig-Holstein', 'ACTIVE'), (110, 55, 'Thuringia', 'ACTIVE'), (111, 1, 'Otra', 'ACTIVE'), (112, 2, 'Otra', 'ACTIVE'), (113, 3, 'Otra', 'ACTIVE'), (114, 4, 'Otra', 'ACTIVE'), (115, 5, 'Otra', 'ACTIVE'), (116, 6, 'Otra', 'ACTIVE'), (117, 7, 'Otra', 'ACTIVE'), (118, 8, 'Otra', 'ACTIVE'), (119, 9, 'Otra', 'ACTIVE'), (120, 10, 'Otra', 'ACTIVE'), (121, 11, 'Otra', 'ACTIVE'), (122, 12, 'Otra', 'ACTIVE'), (123, 13, 'Otra', 'ACTIVE'), (124, 14, 'Otra', 'ACTIVE'), (125, 15, 'Otra', 'ACTIVE'), (126, 16, 'Otra', 'ACTIVE'), (127, 17, 'Otra', 'ACTIVE'), (128, 18, 'Otra', 'ACTIVE'), (129, 19, 'Otra', 'ACTIVE'), (130, 20, 'Otra', 'ACTIVE'), (131, 21, 'Otra', 'ACTIVE'), (132, 22, 'Otra', 'ACTIVE'), (133, 23, 'Otra', 'ACTIVE'), (134, 24, 'Otra', 'ACTIVE'), (135, 25, 'Otra', 'ACTIVE'), (136, 26, 'Otra', 'ACTIVE'), (137, 27, 'Otra', 'ACTIVE'), (138, 28, 'Otra', 'ACTIVE'), (139, 29, 'Otra', 'ACTIVE'), (140, 30, 'Otra', 'ACTIVE'), (141, 31, 'Otra', 'ACTIVE'), (142, 32, 'Otra', 'ACTIVE'), (143, 33, 'Otra', 'ACTIVE'), (144, 34, 'Otra', 'ACTIVE'), (145, 35, 'Otra', 'ACTIVE'), (146, 36, 'Otra', 'ACTIVE'), (147, 37, 'Otra', 'ACTIVE'), (148, 38, 'Otra', 'ACTIVE'), (149, 39, 'Otra', 'ACTIVE'), (150, 40, 'Otra', 'ACTIVE'), (151, 41, 'Otra', 'ACTIVE'), (152, 42, 'Otra', 'ACTIVE'), (153, 43, 'Otra', 'ACTIVE'), (154, 44, 'Otra', 'ACTIVE'), (155, 45, 'Otra', 'ACTIVE'), (156, 46, 'Otra', 'ACTIVE'), (157, 47, 'Otra', 'ACTIVE'), (158, 48, 'Otra', 'ACTIVE'), (159, 49, 'Otra', 'ACTIVE'), (160, 51, 'Otra', 'ACTIVE'), (161, 52, 'Otra', 'ACTIVE'), (162, 53, 'Otra', 'ACTIVE'), (163, 54, 'Otra', 'ACTIVE'), (164, 56, 'Otra', 'ACTIVE'), (165, 57, 'Otra', 'ACTIVE'), (166, 58, 'Otra', 'ACTIVE'), (167, 59, 'Otra', 'ACTIVE'), (168, 60, 'Otra', 'ACTIVE'), (169, 62, 'Otra', 'ACTIVE'), (170, 63, 'Otra', 'ACTIVE'), (171, 64, 'Otra', 'ACTIVE'), (172, 65, 'Otra', 'ACTIVE'), (173, 66, 'Otra', 'ACTIVE'), (174, 67, 'Otra', 'ACTIVE'), (175, 68, 'Otra', 'ACTIVE'), (176, 69, 'Otra', 'ACTIVE'), (177, 70, 'Otra', 'ACTIVE'), (178, 71, 'Otra', 'ACTIVE'), (179, 72, 'Otra', 'ACTIVE'), (180, 73, 'Otra', 'ACTIVE'), (181, 74, 'Otra', 'ACTIVE'), (182, 75, 'Otra', 'ACTIVE'), (183, 76, 'Otra', 'ACTIVE'), (184, 77, 'Otra', 'ACTIVE'), (185, 78, 'Otra', 'ACTIVE'), (186, 79, 'Otra', 'ACTIVE'), (187, 80, 'Otra', 'ACTIVE'), (188, 81, 'Otra', 'ACTIVE'), (189, 82, 'Otra', 'ACTIVE'), (190, 83, 'Otra', 'ACTIVE'), (191, 84, 'Otra', 'ACTIVE'), (192, 85, 'Otra', 'ACTIVE'), (193, 86, 'Otra', 'ACTIVE'), (194, 87, 'Otra', 'ACTIVE'), (195, 88, 'Otra', 'ACTIVE'), (196, 89, 'Otra', 'ACTIVE'), (197, 90, 'Otra', 'ACTIVE'), (198, 91, 'Otra', 'ACTIVE'), (199, 92, 'Otra', 'ACTIVE'), (200, 93, 'Otra', 'ACTIVE'), (201, 94, 'Otra', 'ACTIVE'), (202, 95, 'Otra', 'ACTIVE'), (203, 96, 'Otra', 'ACTIVE'), (204, 97, 'Otra', 'ACTIVE'), (205, 98, 'Otra', 'ACTIVE'), (206, 99, 'Otra', 'ACTIVE'), (207, 100, 'Otra', 'ACTIVE'), (208, 101, 'Otra', 'ACTIVE'), (209, 102, 'Otra', 'ACTIVE'), (210, 103, 'Otra', 'ACTIVE'), (211, 104, 'Otra', 'ACTIVE'), (212, 105, 'Otra', 'ACTIVE'), (213, 106, 'Otra', 'ACTIVE'), (214, 107, 'Otra', 'ACTIVE'), (215, 108, 'Otra', 'ACTIVE'), (216, 109, 'Otra', 'ACTIVE'), (217, 110, 'Otra', 'ACTIVE'), (218, 111, 'Otra', 'ACTIVE'), (219, 112, 'Otra', 'ACTIVE'), (220, 113, 'Otra', 'ACTIVE'), (221, 114, 'Otra', 'ACTIVE'), (222, 115, 'Otra', 'ACTIVE'), (223, 116, 'Otra', 'ACTIVE'), (224, 117, 'Otra', 'ACTIVE'), (225, 118, 'Otra', 'ACTIVE'), (226, 119, 'Otra', 'ACTIVE'), (227, 120, 'Otra', 'ACTIVE'), (228, 121, 'Otra', 'ACTIVE'), (229, 122, 'Otra', 'ACTIVE'), (230, 123, 'Otra', 'ACTIVE'), (231, 124, 'Otra', 'ACTIVE'), (232, 125, 'Otra', 'ACTIVE'), (233, 126, 'Otra', 'ACTIVE'), (234, 127, 'Otra', 'ACTIVE'), (235, 128, 'Otra', 'ACTIVE'), (236, 129, 'Otra', 'ACTIVE'), (237, 130, 'Otra', 'ACTIVE'), (238, 131, 'Otra', 'ACTIVE'), (239, 132, 'Otra', 'ACTIVE'), (240, 133, 'Otra', 'ACTIVE'), (241, 134, 'Otra', 'ACTIVE'), (242, 135, 'Otra', 'ACTIVE'), (243, 136, 'Otra', 'ACTIVE'), (244, 137, 'Otra', 'ACTIVE'), (245, 138, 'Otra', 'ACTIVE'), (246, 139, 'Otra', 'ACTIVE'), (247, 140, 'Otra', 'ACTIVE'), (248, 141, 'Otra', 'ACTIVE'), (249, 142, 'Otra', 'ACTIVE'), (250, 143, 'Otra', 'ACTIVE'), (251, 144, 'Otra', 'ACTIVE'), (252, 145, 'Otra', 'ACTIVE'), (253, 146, 'Otra', 'ACTIVE'), (254, 147, 'Otra', 'ACTIVE'), (255, 148, 'Otra', 'ACTIVE'), (256, 149, 'Otra', 'ACTIVE'), (257, 150, 'Otra', 'ACTIVE'), (258, 151, 'Otra', 'ACTIVE'), (259, 152, 'Otra', 'ACTIVE'), (260, 153, 'Otra', 'ACTIVE'), (261, 154, 'Otra', 'ACTIVE'), (262, 155, 'Otra', 'ACTIVE'), (263, 156, 'Otra', 'ACTIVE'), (264, 157, 'Otra', 'ACTIVE'), (265, 158, 'Otra', 'ACTIVE'), (266, 159, 'Otra', 'ACTIVE'), (267, 160, 'Otra', 'ACTIVE'), (268, 161, 'Otra', 'ACTIVE'), (269, 162, 'Otra', 'ACTIVE'), (270, 163, 'Otra', 'ACTIVE'), (271, 164, 'Otra', 'ACTIVE'), (272, 165, 'Otra', 'ACTIVE'), (273, 166, 'Otra', 'ACTIVE'), (274, 167, 'Otra', 'ACTIVE'), (275, 168, 'Otra', 'ACTIVE'), (276, 169, 'Otra', 'ACTIVE'), (277, 170, 'Otra', 'ACTIVE'), (278, 171, 'Otra', 'ACTIVE'), (279, 172, 'Otra', 'ACTIVE'), (280, 173, 'Otra', 'ACTIVE'), (281, 174, 'Otra', 'ACTIVE'), (282, 175, 'Otra', 'ACTIVE'), (283, 176, 'Otra', 'ACTIVE'), (284, 177, 'Otra', 'ACTIVE'), (285, 178, 'Otra', 'ACTIVE'), (286, 179, 'Otra', 'ACTIVE'), (287, 180, 'Otra', 'ACTIVE'), (288, 181, 'Otra', 'ACTIVE'), (289, 182, 'Otra', 'ACTIVE'), (290, 183, 'Otra', 'ACTIVE'), (291, 184, 'Otra', 'ACTIVE'), (292, 185, 'Otra', 'ACTIVE'), (293, 186, 'Otra', 'ACTIVE'), (294, 187, 'Otra', 'ACTIVE'), (295, 188, 'Otra', 'ACTIVE'), (296, 189, 'Otra', 'ACTIVE'), (297, 190, 'Otra', 'ACTIVE'), (298, 191, 'Otra', 'ACTIVE'), (299, 192, 'Otra', 'ACTIVE'), (300, 193, 'Otra', 'ACTIVE'), (301, 194, 'Otra', 'ACTIVE'), (302, 195, 'Otra', 'ACTIVE'), (303, 196, 'Otra', 'ACTIVE'), (304, 197, 'Otra', 'ACTIVE'), (305, 198, 'Otra', 'ACTIVE'), (306, 199, 'Otra', 'ACTIVE'), (307, 200, 'Otra', 'ACTIVE'), (308, 201, 'Otra', 'ACTIVE'), (309, 202, 'Otra', 'ACTIVE'), (310, 203, 'Otra', 'ACTIVE'), (311, 204, 'Otra', 'ACTIVE'), (312, 205, 'Otra', 'ACTIVE'), (313, 206, 'Otra', 'ACTIVE'), (314, 207, 'Otra', 'ACTIVE'), (315, 208, 'Otra', 'ACTIVE'), (316, 209, 'Otra', 'ACTIVE'), (317, 210, 'Otra', 'ACTIVE'), (318, 211, 'Otra', 'ACTIVE'), (319, 212, 'Otra', 'ACTIVE'), (320, 213, 'Otra', 'ACTIVE'), (321, 214, 'Otra', 'ACTIVE'), (322, 215, 'Otra', 'ACTIVE'), (323, 216, 'Otra', 'ACTIVE'), (324, 218, 'Otra', 'ACTIVE'), (325, 219, 'Otra', 'ACTIVE'), (326, 220, 'Otra', 'ACTIVE'), (327, 221, 'Otra', 'ACTIVE'), (328, 222, 'Otra', 'ACTIVE'), (329, 223, 'Otra', 'ACTIVE'), (330, 224, 'Otra', 'ACTIVE'), (331, 225, 'Otra', 'ACTIVE'), (332, 226, 'Otra', 'ACTIVE'), (333, 227, 'Otra', 'ACTIVE'), (334, 228, 'Otra', 'ACTIVE'), (335, 229, 'Otra', 'ACTIVE'), (336, 230, 'Otra', 'ACTIVE'), (337, 231, 'Otra', 'ACTIVE'), (338, 232, 'Otra', 'ACTIVE'); -- -- Dumping data for table 'stock_request' -- -- -- Dumping data for table 'student' -- -- -- Dumping data for table 'student_activity_attachment' -- -- -- Dumping data for table 'student_by_course' -- -- -- Dumping data for table 'student_criteria_grade' -- -- -- Dumping data for table 'student_guardian' -- -- -- Dumping data for table 'student_optional_subject' -- -- -- Dumping data for table 'student_period_comment' -- -- -- Dumping data for table 'student_period_exam' -- -- -- Dumping data for table 'student_period_subject_skill_grade' -- -- -- Dumping data for table 'student_subject_period_average' -- -- -- Dumping data for table 'student_year' -- -- -- Dumping data for table 'student_year_debts' -- -- -- Dumping data for table 'student_year_discount' -- -- -- Dumping data for table 'student_year_discount_values' -- -- -- Dumping data for table 'student_year_document' -- -- -- Dumping data for table 'student_year_special_grade' -- -- -- Dumping data for table 'study_place' -- -- -- Dumping data for table 'subject' -- INSERT INTO subject (serial_sbj, serial_csb, serial_spt, serial_lvl, serial_scy, serial_set, status_sbj) VALUES (1, 1, 1, 7, 1, 3, 'ACTIVE'), (2, 6, 1, 7, 1, 3, 'ACTIVE'), (3, 14, 1, 7, 1, 3, 'ACTIVE'), (4, 24, 1, 7, 1, 3, 'ACTIVE'), (5, 10, 1, 7, 1, 3, 'ACTIVE'), (6, 7, 1, 2, 1, 1, 'ACTIVE'), (7, 1, 1, 2, 1, 1, 'ACTIVE'), (8, 15, 1, 2, 1, 1, 'ACTIVE'), (9, 20, 1, 2, 1, 1, 'ACTIVE'), (10, 24, 1, 2, 1, 1, 'ACTIVE'), (11, 1, 1, 1, 1, 1, 'ACTIVE'), (12, 24, 1, 1, 1, 1, 'ACTIVE'), (13, 15, 1, 1, 1, 1, 'ACTIVE'), (14, 10, 1, 1, 1, 1, 'ACTIVE'), (15, 7, 1, 3, 1, 1, 'ACTIVE'), (16, 17, 1, 3, 1, 1, 'ACTIVE'), (17, 18, 1, 3, 1, 1, 'ACTIVE'), (18, 22, 1, 3, 1, 1, 'ACTIVE'), (19, 11, 1, 3, 1, 1, 'ACTIVE'), (20, 15, 1, 4, 1, 2, 'ACTIVE'), (21, 21, 1, 4, 1, 2, 'ACTIVE'), (22, 23, 1, 4, 1, 2, 'ACTIVE'), (23, 11, 1, 4, 1, 2, 'ACTIVE'), (24, 17, 2, 5, 1, 2, 'ACTIVE'), (25, 18, 2, 5, 1, 2, 'ACTIVE'), (26, 15, 2, 5, 1, 2, 'ACTIVE'), (27, 19, 2, 5, 1, 2, 'ACTIVE'), (28, 1, 2, 6, 1, 2, 'ACTIVE'), (29, 19, 2, 6, 1, 2, 'ACTIVE'), (30, 15, 2, 6, 1, 2, 'ACTIVE'), (31, 3, 2, 6, 1, 2, 'ACTIVE'), (32, 12, 2, 6, 1, 2, 'ACTIVE'), (33, 8, 3, 6, 1, 2, 'ACTIVE'), (34, 9, 3, 6, 1, 2, 'ACTIVE'), (35, 23, 3, 6, 1, 2, 'ACTIVE'), (36, 13, 3, 6, 1, 2, 'ACTIVE'), (37, 12, 3, 6, 1, 2, 'ACTIVE'), (38, 8, 3, 5, 1, 2, 'ACTIVE'), (39, 9, 3, 5, 1, 2, 'ACTIVE'); -- -- Dumping data for table 'subject_course' -- INSERT INTO subject_course (serial_sbc, serial_sbj, serial_crs, serial_aca, serial_emp, status_sbc, grade_type_sbc, hours_week_sbc, hours_distribution_sbc) VALUES (1, 4, 1, 3, 10, 'ACTIVE', 'QUANTITATIVE', 4, '1,1,1,1'), (2, 1, 1, 4, 9, 'ACTIVE', 'QUANTITATIVE', 3, '2,1'), (3, 2, 1, 4, 8, 'ACTIVE', 'QUALITATIVE', 2, '1,1'), (4, 3, 1, 1, 7, 'ACTIVE', 'QUANTITATIVE', 6, '1,1,1,1,2'), (5, 5, 1, 2, 11, 'ACTIVE', 'QUANTITATIVE', 5, '1,2,2'), (6, 14, 2, 2, 3, 'ACTIVE', 'QUANTITATIVE', 4, '1,1,1,1'), (7, 14, 3, 2, 3, 'ACTIVE', 'QUANTITATIVE', 4, '1,1,2'), (8, 11, 2, 4, 1, 'ACTIVE', 'QUANTITATIVE', 2, '2'), (9, 11, 3, 4, 1, 'ACTIVE', 'QUANTITATIVE', 2, '1,1'), (10, 12, 2, 3, 3, 'ACTIVE', 'QUANTITATIVE', 4, '1,3'), (11, 12, 3, 3, 3, 'ACTIVE', 'QUANTITATIVE', 4, '1,2,1'), (12, 13, 2, 1, 4, 'ACTIVE', 'QUANTITATIVE', 10, '2,2,2,4'), (13, 13, 3, 1, 2, 'ACTIVE', 'QUANTITATIVE', 10, '2,3,3,2'), (14, 9, 4, 3, 2, 'ACTIVE', 'QUANTITATIVE', 4, '2,2'), (15, 9, 5, 3, 3, 'ACTIVE', 'QUANTITATIVE', 4, '2,1,1'), (16, 10, 4, 3, 4, 'ACTIVE', 'QUANTITATIVE', 4, '2,2'), (17, 10, 5, 3, 5, 'ACTIVE', 'QUANTITATIVE', 4, '1,1,1,1'), (18, 6, 4, 5, 2, 'ACTIVE', 'QUANTITATIVE', 4, '1,1,2'), (19, 6, 5, 5, 5, 'ACTIVE', 'QUANTITATIVE', 4, '1,1,2'), (20, 7, 4, 4, 1, 'ACTIVE', 'QUANTITATIVE', 2, '1,1'), (21, 7, 5, 4, 1, 'ACTIVE', 'QUANTITATIVE', 2, '1,1'), (22, 8, 4, 1, 3, 'ACTIVE', 'QUANTITATIVE', 6, '3,3'), (23, 8, 5, 1, 2, 'ACTIVE', 'QUANTITATIVE', 6, '2,2,1,1'), (24, 19, 6, 2, 3, 'ACTIVE', 'QUANTITATIVE', 5, '2,2,1'), (25, 19, 7, 2, 4, 'ACTIVE', 'QUANTITATIVE', 5, '1,1,1,1,1'), (26, 18, 6, 3, 3, 'ACTIVE', 'QUANTITATIVE', 3, '2,1'), (27, 18, 7, 3, 3, 'ACTIVE', 'QUANTITATIVE', 3, '1,1,1'), (28, 15, 6, 5, 4, 'ACTIVE', 'QUANTITATIVE', 4, '1,1,1,1'), (29, 15, 7, 5, 4, 'ACTIVE', 'QUANTITATIVE', 4, '1,1,1,1'), (30, 16, 6, 1, 4, 'ACTIVE', 'QUANTITATIVE', 4, '3,1'), (31, 16, 7, 1, 4, 'ACTIVE', 'QUANTITATIVE', 4, '2,2'), (32, 17, 6, 1, 3, 'ACTIVE', 'QUANTITATIVE', 4, '2,1,1'), (33, 17, 7, 1, 6, 'ACTIVE', 'QUANTITATIVE', 4, '4'), (34, 20, 8, 1, 2, 'ACTIVE', 'QUANTITATIVE', 10, '4,4,2'), (35, 20, 9, 1, 2, 'ACTIVE', 'QUANTITATIVE', 10, '2,2,4,2'), (36, 21, 8, 3, 4, 'ACTIVE', 'QUANTITATIVE', 3, '1,1,1'), (37, 21, 9, 3, 4, 'ACTIVE', 'QUANTITATIVE', 3, '1,2'), (38, 22, 8, 3, 5, 'ACTIVE', 'QUANTITATIVE', 7, '2,1,2,1,1'), (39, 22, 9, 3, 5, 'ACTIVE', 'QUANTITATIVE', 7, '3,3,1'), (40, 27, 10, 1, 2, 'ACTIVE', 'QUANTITATIVE', 3, '2,1'), (41, 27, 11, 1, 3, 'ACTIVE', 'QUANTITATIVE', 3, '3'), (42, 26, 10, 1, 4, 'ACTIVE', 'QUANTITATIVE', 3, '2,1'), (43, 26, 11, 1, 4, 'ACTIVE', 'QUANTITATIVE', 3, '3'), (44, 24, 10, 1, 3, 'ACTIVE', 'QUANTITATIVE', 6, '2,2,2'), (45, 24, 11, 1, 6, 'ACTIVE', 'QUANTITATIVE', 6, '1,3,2'), (46, 25, 10, 1, 6, 'ACTIVE', 'QUANTITATIVE', 8, '3,1,1,1,2'), (47, 25, 11, 1, 2, 'ACTIVE', 'QUANTITATIVE', 8, '2,2,2,2'), (48, 32, 14, 2, 4, 'ACTIVE', 'QUANTITATIVE', 4, '2,2'), (49, 28, 14, 4, 1, 'ACTIVE', 'QUANTITATIVE', 4, '3,1'), (50, 29, 14, 1, 2, 'ACTIVE', 'QUANTITATIVE', 4, '1,3'), (51, 30, 14, 1, 3, 'ACTIVE', 'QUANTITATIVE', 6, '2,2,1,1'), (52, 31, 14, 4, 1, 'ACTIVE', 'QUANTITATIVE', 2, '2'), (53, 38, 12, 5, 2, 'ACTIVE', 'QUANTITATIVE', 10, '3,3,3,1'), (54, 38, 13, 5, 4, 'ACTIVE', 'QUANTITATIVE', 10, '4,4,2'), (55, 39, 12, 5, 4, 'ACTIVE', 'QUANTITATIVE', 10, '2,2,2,3,1'), (56, 39, 13, 5, 5, 'ACTIVE', 'QUANTITATIVE', 10, '2,4,1,1,2'), (57, 37, 15, 2, 3, 'ACTIVE', 'QUANTITATIVE', 5, '3,2'), (58, 36, 15, 2, 3, 'ACTIVE', 'QUANTITATIVE', 5, '1,1,1,2'), (59, 33, 15, 5, 4, 'ACTIVE', 'QUANTITATIVE', 4, '1,2,1'), (60, 34, 15, 5, 4, 'ACTIVE', 'QUANTITATIVE', 3, '1,1,1'), (61, 35, 15, 3, 3, 'ACTIVE', 'QUANTITATIVE', 3, '3'); -- -- Dumping data for table 'subject_course_period' -- INSERT INTO subject_course_period (serial_prd, serial_sbc, status_scp, weight_scp) VALUES (1, 1, 'ACTIVE', '100.00'), (1, 2, 'ACTIVE', '100.00'), (1, 3, 'ACTIVE', '100.00'), (1, 4, 'ACTIVE', '100.00'), (1, 5, 'ACTIVE', '100.00'), (1, 6, 'ACTIVE', '100.00'), (1, 7, 'ACTIVE', '100.00'), (1, 8, 'ACTIVE', '100.00'), (1, 9, 'ACTIVE', '100.00'), (1, 10, 'ACTIVE', '100.00'), (1, 11, 'ACTIVE', '100.00'), (1, 12, 'ACTIVE', '100.00'), (1, 13, 'ACTIVE', '100.00'), (1, 14, 'ACTIVE', '100.00'), (1, 15, 'ACTIVE', '100.00'), (1, 16, 'ACTIVE', '100.00'), (1, 17, 'ACTIVE', '100.00'), (1, 18, 'ACTIVE', '100.00'), (1, 19, 'ACTIVE', '100.00'), (1, 20, 'ACTIVE', '100.00'), (1, 21, 'ACTIVE', '100.00'), (1, 22, 'ACTIVE', '100.00'), (1, 23, 'ACTIVE', '100.00'), (1, 24, 'ACTIVE', '100.00'), (1, 25, 'ACTIVE', '100.00'), (1, 26, 'ACTIVE', '100.00'), (1, 27, 'ACTIVE', '100.00'), (1, 28, 'ACTIVE', '100.00'), (1, 29, 'ACTIVE', '100.00'), (1, 30, 'ACTIVE', '50.00'), (1, 31, 'ACTIVE', '50.00'), (1, 32, 'ACTIVE', '50.00'), (1, 33, 'ACTIVE', '50.00'), (1, 34, 'ACTIVE', '100.00'), (1, 35, 'ACTIVE', '100.00'), (1, 36, 'ACTIVE', '100.00'), (1, 37, 'ACTIVE', '100.00'), (1, 38, 'ACTIVE', '100.00'), (1, 39, 'ACTIVE', '100.00'), (1, 40, 'ACTIVE', '100.00'), (1, 41, 'ACTIVE', '100.00'), (1, 42, 'ACTIVE', '100.00'), (1, 43, 'ACTIVE', '100.00'), (1, 44, 'ACTIVE', '50.00'), (1, 45, 'ACTIVE', '50.00'), (1, 46, 'ACTIVE', '50.00'), (1, 47, 'ACTIVE', '50.00'), (1, 48, 'ACTIVE', '100.00'), (1, 49, 'ACTIVE', '100.00'), (1, 50, 'ACTIVE', '100.00'), (1, 51, 'ACTIVE', '100.00'), (1, 52, 'ACTIVE', '100.00'), (1, 53, 'ACTIVE', '100.00'), (1, 54, 'ACTIVE', '100.00'), (1, 55, 'ACTIVE', '100.00'), (1, 56, 'ACTIVE', '100.00'), (1, 57, 'ACTIVE', '100.00'), (1, 58, 'ACTIVE', '100.00'), (1, 59, 'ACTIVE', '100.00'), (1, 60, 'ACTIVE', '100.00'), (1, 61, 'ACTIVE', '100.00'), (2, 1, 'ACTIVE', '100.00'), (2, 2, 'ACTIVE', '100.00'), (2, 3, 'ACTIVE', '100.00'), (2, 4, 'ACTIVE', '100.00'), (2, 5, 'ACTIVE', '100.00'), (2, 6, 'ACTIVE', '100.00'), (2, 7, 'ACTIVE', '100.00'), (2, 8, 'ACTIVE', '100.00'), (2, 9, 'ACTIVE', '100.00'), (2, 10, 'ACTIVE', '100.00'), (2, 11, 'ACTIVE', '100.00'), (2, 12, 'ACTIVE', '100.00'), (2, 13, 'ACTIVE', '100.00'), (2, 14, 'ACTIVE', '100.00'), (2, 15, 'ACTIVE', '100.00'), (2, 16, 'ACTIVE', '100.00'), (2, 17, 'ACTIVE', '100.00'), (2, 18, 'ACTIVE', '100.00'), (2, 19, 'ACTIVE', '100.00'), (2, 20, 'ACTIVE', '100.00'), (2, 21, 'ACTIVE', '100.00'), (2, 22, 'ACTIVE', '100.00'), (2, 23, 'ACTIVE', '100.00'), (2, 24, 'ACTIVE', '100.00'), (2, 25, 'ACTIVE', '100.00'), (2, 26, 'ACTIVE', '100.00'), (2, 27, 'ACTIVE', '100.00'), (2, 28, 'ACTIVE', '100.00'), (2, 29, 'ACTIVE', '100.00'), (2, 30, 'ACTIVE', '50.00'), (2, 31, 'ACTIVE', '50.00'), (2, 32, 'ACTIVE', '50.00'), (2, 33, 'ACTIVE', '50.00'), (2, 34, 'ACTIVE', '100.00'), (2, 35, 'ACTIVE', '100.00'), (2, 36, 'ACTIVE', '100.00'), (2, 37, 'ACTIVE', '100.00'), (2, 38, 'ACTIVE', '100.00'), (2, 39, 'ACTIVE', '100.00'), (2, 40, 'ACTIVE', '100.00'), (2, 41, 'ACTIVE', '100.00'), (2, 42, 'ACTIVE', '100.00'), (2, 43, 'ACTIVE', '100.00'), (2, 44, 'ACTIVE', '50.00'), (2, 45, 'ACTIVE', '50.00'), (2, 46, 'ACTIVE', '50.00'), (2, 47, 'ACTIVE', '50.00'), (2, 48, 'ACTIVE', '100.00'), (2, 49, 'ACTIVE', '100.00'), (2, 50, 'ACTIVE', '100.00'), (2, 51, 'ACTIVE', '100.00'), (2, 52, 'ACTIVE', '100.00'), (2, 53, 'ACTIVE', '100.00'), (2, 54, 'ACTIVE', '100.00'), (2, 55, 'ACTIVE', '100.00'), (2, 56, 'ACTIVE', '100.00'), (2, 57, 'ACTIVE', '100.00'), (2, 58, 'ACTIVE', '100.00'), (2, 59, 'ACTIVE', '100.00'), (2, 60, 'ACTIVE', '100.00'), (2, 61, 'ACTIVE', '100.00'), (3, 1, 'ACTIVE', '100.00'), (3, 2, 'ACTIVE', '100.00'), (3, 3, 'ACTIVE', '100.00'), (3, 4, 'ACTIVE', '100.00'), (3, 5, 'ACTIVE', '100.00'), (3, 6, 'ACTIVE', '100.00'), (3, 7, 'ACTIVE', '100.00'), (3, 8, 'ACTIVE', '100.00'), (3, 9, 'ACTIVE', '100.00'), (3, 10, 'ACTIVE', '100.00'), (3, 11, 'ACTIVE', '100.00'), (3, 12, 'ACTIVE', '100.00'), (3, 13, 'ACTIVE', '100.00'), (3, 14, 'ACTIVE', '100.00'), (3, 15, 'ACTIVE', '100.00'), (3, 16, 'ACTIVE', '100.00'), (3, 17, 'ACTIVE', '100.00'), (3, 18, 'ACTIVE', '100.00'), (3, 19, 'ACTIVE', '100.00'), (3, 20, 'ACTIVE', '100.00'), (3, 21, 'ACTIVE', '100.00'), (3, 22, 'ACTIVE', '100.00'), (3, 23, 'ACTIVE', '100.00'), (3, 24, 'ACTIVE', '100.00'), (3, 25, 'ACTIVE', '100.00'), (3, 26, 'ACTIVE', '100.00'), (3, 27, 'ACTIVE', '100.00'), (3, 28, 'ACTIVE', '100.00'), (3, 29, 'ACTIVE', '100.00'), (3, 30, 'ACTIVE', '50.00'), (3, 31, 'ACTIVE', '50.00'), (3, 32, 'ACTIVE', '50.00'), (3, 33, 'ACTIVE', '50.00'), (3, 34, 'ACTIVE', '100.00'), (3, 35, 'ACTIVE', '100.00'), (3, 36, 'ACTIVE', '100.00'), (3, 37, 'ACTIVE', '100.00'), (3, 38, 'ACTIVE', '100.00'), (3, 39, 'ACTIVE', '100.00'), (3, 40, 'ACTIVE', '100.00'), (3, 41, 'ACTIVE', '100.00'), (3, 42, 'ACTIVE', '100.00'), (3, 43, 'ACTIVE', '100.00'), (3, 44, 'ACTIVE', '50.00'), (3, 45, 'ACTIVE', '50.00'), (3, 46, 'ACTIVE', '50.00'), (3, 47, 'ACTIVE', '50.00'), (3, 48, 'ACTIVE', '100.00'), (3, 49, 'ACTIVE', '100.00'), (3, 50, 'ACTIVE', '100.00'), (3, 51, 'ACTIVE', '100.00'), (3, 52, 'ACTIVE', '100.00'), (3, 53, 'ACTIVE', '100.00'), (3, 54, 'ACTIVE', '100.00'), (3, 55, 'ACTIVE', '100.00'), (3, 56, 'ACTIVE', '100.00'), (3, 57, 'ACTIVE', '100.00'), (3, 58, 'ACTIVE', '100.00'), (3, 59, 'ACTIVE', '100.00'), (3, 60, 'ACTIVE', '100.00'), (3, 61, 'ACTIVE', '100.00'); -- -- Dumping data for table 'subject_course_retest' -- -- -- Dumping data for table 'subject_course_retest_student' -- -- -- Dumping data for table 'subject_level_restriction' -- -- -- Dumping data for table 'subject_ministry_equivalence' -- -- -- Dumping data for table 'subject_period_activity_type' -- INSERT INTO subject_period_activity_type (serial_att, serial_prd, serial_sbc, weight_spa, due_min_days_spa, due_max_grade_spa, status_spa) VALUES (2, 1, 1, '25.00', 10, 10, 'ACTIVE'), (2, 1, 2, '25.00', 10, 10, 'ACTIVE'), (2, 1, 3, '25.00', 10, 10, 'ACTIVE'), (2, 1, 4, '25.00', 10, 10, 'ACTIVE'), (2, 1, 5, '25.00', 10, 10, 'ACTIVE'), (2, 1, 6, '25.00', 10, 10, 'ACTIVE'), (2, 1, 7, '25.00', 10, 10, 'ACTIVE'), (2, 1, 8, '25.00', 10, 10, 'ACTIVE'), (2, 1, 9, '25.00', 10, 10, 'ACTIVE'), (2, 1, 10, '25.00', 10, 10, 'ACTIVE'), (2, 1, 11, '25.00', 10, 10, 'ACTIVE'), (2, 1, 12, '25.00', 10, 10, 'ACTIVE'), (2, 1, 13, '25.00', 10, 10, 'ACTIVE'), (2, 1, 14, '20.00', 10, 10, 'ACTIVE'), (2, 1, 15, '20.00', 10, 10, 'ACTIVE'), (2, 1, 16, '20.00', 10, 10, 'ACTIVE'), (2, 1, 17, '20.00', 10, 10, 'ACTIVE'), (2, 1, 18, '20.00', 10, 10, 'ACTIVE'), (2, 1, 19, '20.00', 10, 10, 'ACTIVE'), (2, 1, 20, '20.00', 10, 10, 'ACTIVE'), (2, 1, 21, '20.00', 10, 10, 'ACTIVE'), (2, 1, 22, '20.00', 10, 10, 'ACTIVE'), (2, 1, 23, '20.00', 10, 10, 'ACTIVE'), (2, 1, 24, '25.00', 10, 10, 'ACTIVE'), (2, 1, 25, '25.00', 10, 10, 'ACTIVE'), (2, 1, 26, '25.00', 10, 10, 'ACTIVE'), (2, 1, 27, '25.00', 10, 10, 'ACTIVE'), (2, 1, 28, '25.00', 10, 10, 'ACTIVE'), (2, 1, 29, '25.00', 10, 10, 'ACTIVE'), (2, 1, 30, '25.00', 10, 10, 'ACTIVE'), (2, 1, 31, '25.00', 10, 10, 'ACTIVE'), (2, 1, 32, '25.00', 10, 10, 'ACTIVE'), (2, 1, 33, '25.00', 10, 10, 'ACTIVE'), (2, 1, 34, '25.00', 10, 10, 'ACTIVE'), (2, 1, 35, '25.00', 10, 10, 'ACTIVE'), (2, 1, 36, '25.00', 10, 10, 'ACTIVE'), (2, 1, 37, '25.00', 10, 10, 'ACTIVE'), (2, 1, 38, '25.00', 10, 10, 'ACTIVE'), (2, 1, 39, '25.00', 10, 10, 'ACTIVE'), (2, 1, 40, '50.00', 5, 5, 'ACTIVE'), (2, 1, 41, '50.00', 5, 5, 'ACTIVE'), (2, 1, 42, '50.00', 5, 5, 'ACTIVE'), (2, 1, 43, '50.00', 5, 5, 'ACTIVE'), (2, 1, 44, '50.00', 5, 5, 'ACTIVE'), (2, 1, 45, '50.00', 5, 5, 'ACTIVE'), (2, 1, 46, '50.00', 5, 5, 'ACTIVE'), (2, 1, 47, '50.00', 5, 5, 'ACTIVE'), (2, 1, 48, '10.00', 10, 10, 'ACTIVE'), (2, 1, 49, '10.00', 10, 10, 'ACTIVE'), (2, 1, 50, '10.00', 10, 10, 'ACTIVE'), (2, 1, 51, '10.00', 10, 10, 'ACTIVE'), (2, 1, 52, '10.00', 10, 10, 'ACTIVE'), (2, 1, 53, '50.00', 5, 5, 'ACTIVE'), (2, 1, 54, '50.00', 5, 5, 'ACTIVE'), (2, 1, 55, '50.00', 5, 5, 'ACTIVE'), (2, 1, 56, '50.00', 5, 5, 'ACTIVE'), (2, 1, 57, '10.00', 10, 10, 'ACTIVE'), (2, 1, 58, '10.00', 10, 10, 'ACTIVE'), (2, 1, 59, '10.00', 10, 10, 'ACTIVE'), (2, 1, 60, '10.00', 10, 10, 'ACTIVE'), (2, 1, 61, '10.00', 10, 10, 'ACTIVE'), (2, 2, 1, '25.00', 10, 10, 'ACTIVE'), (2, 2, 2, '25.00', 10, 10, 'ACTIVE'), (2, 2, 3, '25.00', 10, 10, 'ACTIVE'), (2, 2, 4, '25.00', 10, 10, 'ACTIVE'), (2, 2, 5, '25.00', 10, 10, 'ACTIVE'), (2, 2, 6, '25.00', 10, 10, 'ACTIVE'), (2, 2, 7, '25.00', 10, 10, 'ACTIVE'), (2, 2, 8, '25.00', 10, 10, 'ACTIVE'), (2, 2, 9, '25.00', 10, 10, 'ACTIVE'), (2, 2, 10, '25.00', 10, 10, 'ACTIVE'), (2, 2, 11, '25.00', 10, 10, 'ACTIVE'), (2, 2, 12, '25.00', 10, 10, 'ACTIVE'), (2, 2, 13, '25.00', 10, 10, 'ACTIVE'), (2, 2, 14, '20.00', 10, 10, 'ACTIVE'), (2, 2, 15, '20.00', 10, 10, 'ACTIVE'), (2, 2, 16, '20.00', 10, 10, 'ACTIVE'), (2, 2, 17, '20.00', 10, 10, 'ACTIVE'), (2, 2, 18, '20.00', 10, 10, 'ACTIVE'), (2, 2, 19, '20.00', 10, 10, 'ACTIVE'), (2, 2, 20, '20.00', 10, 10, 'ACTIVE'), (2, 2, 21, '20.00', 10, 10, 'ACTIVE'), (2, 2, 22, '20.00', 10, 10, 'ACTIVE'), (2, 2, 23, '20.00', 10, 10, 'ACTIVE'), (2, 2, 24, '25.00', 10, 10, 'ACTIVE'), (2, 2, 25, '25.00', 10, 10, 'ACTIVE'), (2, 2, 26, '25.00', 10, 10, 'ACTIVE'), (2, 2, 27, '25.00', 10, 10, 'ACTIVE'), (2, 2, 28, '25.00', 10, 10, 'ACTIVE'), (2, 2, 29, '25.00', 10, 10, 'ACTIVE'), (2, 2, 30, '25.00', 10, 10, 'ACTIVE'), (2, 2, 31, '25.00', 10, 10, 'ACTIVE'), (2, 2, 32, '25.00', 10, 10, 'ACTIVE'), (2, 2, 33, '25.00', 10, 10, 'ACTIVE'), (2, 2, 34, '25.00', 10, 10, 'ACTIVE'), (2, 2, 35, '25.00', 10, 10, 'ACTIVE'), (2, 2, 36, '25.00', 10, 10, 'ACTIVE'), (2, 2, 37, '25.00', 10, 10, 'ACTIVE'), (2, 2, 38, '25.00', 10, 10, 'ACTIVE'), (2, 2, 39, '25.00', 10, 10, 'ACTIVE'), (2, 2, 40, '50.00', 5, 5, 'ACTIVE'), (2, 2, 41, '50.00', 5, 5, 'ACTIVE'), (2, 2, 42, '50.00', 5, 5, 'ACTIVE'), (2, 2, 43, '50.00', 5, 5, 'ACTIVE'), (2, 2, 44, '50.00', 5, 5, 'ACTIVE'), (2, 2, 45, '50.00', 5, 5, 'ACTIVE'), (2, 2, 46, '50.00', 5, 5, 'ACTIVE'), (2, 2, 47, '50.00', 5, 5, 'ACTIVE'), (2, 2, 48, '10.00', 10, 10, 'ACTIVE'), (2, 2, 49, '10.00', 10, 10, 'ACTIVE'), (2, 2, 50, '10.00', 10, 10, 'ACTIVE'), (2, 2, 51, '10.00', 10, 10, 'ACTIVE'), (2, 2, 52, '10.00', 10, 10, 'ACTIVE'), (2, 2, 53, '50.00', 5, 5, 'ACTIVE'), (2, 2, 54, '50.00', 5, 5, 'ACTIVE'), (2, 2, 55, '50.00', 5, 5, 'ACTIVE'), (2, 2, 56, '50.00', 5, 5, 'ACTIVE'), (2, 2, 57, '10.00', 10, 10, 'ACTIVE'), (2, 2, 58, '10.00', 10, 10, 'ACTIVE'), (2, 2, 59, '10.00', 10, 10, 'ACTIVE'), (2, 2, 60, '10.00', 10, 10, 'ACTIVE'), (2, 2, 61, '10.00', 10, 10, 'ACTIVE'), (2, 3, 1, '25.00', 10, 10, 'ACTIVE'), (2, 3, 2, '25.00', 10, 10, 'ACTIVE'), (2, 3, 3, '25.00', 10, 10, 'ACTIVE'), (2, 3, 4, '25.00', 10, 10, 'ACTIVE'), (2, 3, 5, '25.00', 10, 10, 'ACTIVE'), (2, 3, 6, '25.00', 10, 10, 'ACTIVE'), (2, 3, 7, '25.00', 10, 10, 'ACTIVE'), (2, 3, 8, '25.00', 10, 10, 'ACTIVE'), (2, 3, 9, '25.00', 10, 10, 'ACTIVE'), (2, 3, 10, '25.00', 10, 10, 'ACTIVE'), (2, 3, 11, '25.00', 10, 10, 'ACTIVE'), (2, 3, 12, '25.00', 10, 10, 'ACTIVE'), (2, 3, 13, '25.00', 10, 10, 'ACTIVE'), (2, 3, 14, '20.00', 10, 10, 'ACTIVE'), (2, 3, 15, '20.00', 10, 10, 'ACTIVE'), (2, 3, 16, '20.00', 10, 10, 'ACTIVE'), (2, 3, 17, '20.00', 10, 10, 'ACTIVE'), (2, 3, 18, '20.00', 10, 10, 'ACTIVE'), (2, 3, 19, '20.00', 10, 10, 'ACTIVE'), (2, 3, 20, '20.00', 10, 10, 'ACTIVE'), (2, 3, 21, '20.00', 10, 10, 'ACTIVE'), (2, 3, 22, '20.00', 10, 10, 'ACTIVE'), (2, 3, 23, '20.00', 10, 10, 'ACTIVE'), (2, 3, 24, '25.00', 10, 10, 'ACTIVE'), (2, 3, 25, '25.00', 10, 10, 'ACTIVE'), (2, 3, 26, '25.00', 10, 10, 'ACTIVE'), (2, 3, 27, '25.00', 10, 10, 'ACTIVE'), (2, 3, 28, '25.00', 10, 10, 'ACTIVE'), (2, 3, 29, '25.00', 10, 10, 'ACTIVE'), (2, 3, 30, '25.00', 10, 10, 'ACTIVE'), (2, 3, 31, '25.00', 10, 10, 'ACTIVE'), (2, 3, 32, '25.00', 10, 10, 'ACTIVE'), (2, 3, 33, '25.00', 10, 10, 'ACTIVE'), (2, 3, 34, '25.00', 10, 10, 'ACTIVE'), (2, 3, 35, '25.00', 10, 10, 'ACTIVE'), (2, 3, 36, '25.00', 10, 10, 'ACTIVE'), (2, 3, 37, '25.00', 10, 10, 'ACTIVE'), (2, 3, 38, '25.00', 10, 10, 'ACTIVE'), (2, 3, 39, '25.00', 10, 10, 'ACTIVE'), (2, 3, 40, '50.00', 5, 5, 'ACTIVE'), (2, 3, 41, '50.00', 5, 5, 'ACTIVE'), (2, 3, 42, '50.00', 5, 5, 'ACTIVE'), (2, 3, 43, '50.00', 5, 5, 'ACTIVE'), (2, 3, 44, '50.00', 5, 5, 'ACTIVE'), (2, 3, 45, '50.00', 5, 5, 'ACTIVE'), (2, 3, 46, '50.00', 5, 5, 'ACTIVE'), (2, 3, 47, '50.00', 5, 5, 'ACTIVE'), (2, 3, 48, '10.00', 10, 10, 'ACTIVE'), (2, 3, 49, '10.00', 10, 10, 'ACTIVE'), (2, 3, 50, '10.00', 10, 10, 'ACTIVE'), (2, 3, 51, '10.00', 10, 10, 'ACTIVE'), (2, 3, 52, '10.00', 10, 10, 'ACTIVE'), (2, 3, 53, '50.00', 5, 5, 'ACTIVE'), (2, 3, 54, '50.00', 5, 5, 'ACTIVE'), (2, 3, 55, '50.00', 5, 5, 'ACTIVE'), (2, 3, 56, '50.00', 5, 5, 'ACTIVE'), (2, 3, 57, '10.00', 10, 10, 'ACTIVE'), (2, 3, 58, '10.00', 10, 10, 'ACTIVE'), (2, 3, 59, '10.00', 10, 10, 'ACTIVE'), (2, 3, 60, '10.00', 10, 10, 'ACTIVE'), (2, 3, 61, '10.00', 10, 10, 'ACTIVE'), (3, 1, 1, '25.00', 12, 10, 'ACTIVE'), (3, 1, 2, '25.00', 12, 10, 'ACTIVE'), (3, 1, 3, '25.00', 12, 10, 'ACTIVE'), (3, 1, 4, '25.00', 12, 10, 'ACTIVE'), (3, 1, 5, '25.00', 12, 10, 'ACTIVE'), (3, 1, 6, '25.00', 10, 10, 'ACTIVE'), (3, 1, 7, '25.00', 10, 10, 'ACTIVE'), (3, 1, 8, '25.00', 10, 10, 'ACTIVE'), (3, 1, 9, '25.00', 10, 10, 'ACTIVE'), (3, 1, 10, '25.00', 10, 10, 'ACTIVE'), (3, 1, 11, '25.00', 10, 10, 'ACTIVE'), (3, 1, 12, '25.00', 10, 10, 'ACTIVE'), (3, 1, 13, '25.00', 10, 10, 'ACTIVE'), (3, 1, 24, '25.00', 10, 10, 'ACTIVE'), (3, 1, 25, '25.00', 10, 10, 'ACTIVE'), (3, 1, 26, '25.00', 10, 10, 'ACTIVE'), (3, 1, 27, '25.00', 10, 10, 'ACTIVE'), (3, 1, 28, '25.00', 10, 10, 'ACTIVE'), (3, 1, 29, '25.00', 10, 10, 'ACTIVE'), (3, 1, 30, '25.00', 10, 10, 'ACTIVE'), (3, 1, 31, '25.00', 10, 10, 'ACTIVE'), (3, 1, 32, '25.00', 10, 10, 'ACTIVE'), (3, 1, 33, '25.00', 10, 10, 'ACTIVE'), (3, 1, 34, '25.00', 10, 10, 'ACTIVE'), (3, 1, 35, '25.00', 10, 10, 'ACTIVE'), (3, 1, 36, '25.00', 10, 10, 'ACTIVE'), (3, 1, 37, '25.00', 10, 10, 'ACTIVE'), (3, 1, 38, '25.00', 10, 10, 'ACTIVE'), (3, 1, 39, '25.00', 10, 10, 'ACTIVE'), (3, 1, 40, '50.00', 5, 5, 'ACTIVE'), (3, 1, 41, '50.00', 5, 5, 'ACTIVE'), (3, 1, 42, '50.00', 5, 5, 'ACTIVE'), (3, 1, 43, '50.00', 5, 5, 'ACTIVE'), (3, 1, 44, '50.00', 5, 5, 'ACTIVE'), (3, 1, 45, '50.00', 5, 5, 'ACTIVE'), (3, 1, 46, '50.00', 5, 5, 'ACTIVE'), (3, 1, 47, '50.00', 5, 5, 'ACTIVE'), (3, 1, 48, '10.00', 10, 10, 'ACTIVE'), (3, 1, 49, '10.00', 10, 10, 'ACTIVE'), (3, 1, 50, '10.00', 10, 10, 'ACTIVE'), (3, 1, 51, '10.00', 10, 10, 'ACTIVE'), (3, 1, 52, '10.00', 10, 10, 'ACTIVE'), (3, 1, 53, '50.00', 5, 5, 'ACTIVE'), (3, 1, 54, '50.00', 5, 5, 'ACTIVE'), (3, 1, 55, '50.00', 5, 5, 'ACTIVE'), (3, 1, 56, '50.00', 5, 5, 'ACTIVE'), (3, 1, 57, '10.00', 10, 10, 'ACTIVE'), (3, 1, 58, '10.00', 10, 10, 'ACTIVE'), (3, 1, 59, '10.00', 10, 10, 'ACTIVE'), (3, 1, 60, '10.00', 10, 10, 'ACTIVE'), (3, 1, 61, '10.00', 10, 10, 'ACTIVE'), (3, 2, 1, '25.00', 12, 10, 'ACTIVE'), (3, 2, 2, '25.00', 12, 10, 'ACTIVE'), (3, 2, 3, '25.00', 12, 10, 'ACTIVE'), (3, 2, 4, '25.00', 12, 10, 'ACTIVE'), (3, 2, 5, '25.00', 12, 10, 'ACTIVE'), (3, 2, 6, '25.00', 10, 10, 'ACTIVE'), (3, 2, 7, '25.00', 10, 10, 'ACTIVE'), (3, 2, 8, '25.00', 10, 10, 'ACTIVE'), (3, 2, 9, '25.00', 10, 10, 'ACTIVE'), (3, 2, 10, '25.00', 10, 10, 'ACTIVE'), (3, 2, 11, '25.00', 10, 10, 'ACTIVE'), (3, 2, 12, '25.00', 10, 10, 'ACTIVE'), (3, 2, 13, '25.00', 10, 10, 'ACTIVE'), (3, 2, 24, '25.00', 10, 10, 'ACTIVE'), (3, 2, 25, '25.00', 10, 10, 'ACTIVE'), (3, 2, 26, '25.00', 10, 10, 'ACTIVE'), (3, 2, 27, '25.00', 10, 10, 'ACTIVE'), (3, 2, 28, '25.00', 10, 10, 'ACTIVE'), (3, 2, 29, '25.00', 10, 10, 'ACTIVE'), (3, 2, 30, '25.00', 10, 10, 'ACTIVE'), (3, 2, 31, '25.00', 10, 10, 'ACTIVE'), (3, 2, 32, '25.00', 10, 10, 'ACTIVE'), (3, 2, 33, '25.00', 10, 10, 'ACTIVE'), (3, 2, 34, '25.00', 10, 10, 'ACTIVE'), (3, 2, 35, '25.00', 10, 10, 'ACTIVE'), (3, 2, 36, '25.00', 10, 10, 'ACTIVE'), (3, 2, 37, '25.00', 10, 10, 'ACTIVE'), (3, 2, 38, '25.00', 10, 10, 'ACTIVE'), (3, 2, 39, '25.00', 10, 10, 'ACTIVE'), (3, 2, 40, '50.00', 5, 5, 'ACTIVE'), (3, 2, 41, '50.00', 5, 5, 'ACTIVE'), (3, 2, 42, '50.00', 5, 5, 'ACTIVE'), (3, 2, 43, '50.00', 5, 5, 'ACTIVE'), (3, 2, 44, '50.00', 5, 5, 'ACTIVE'), (3, 2, 45, '50.00', 5, 5, 'ACTIVE'), (3, 2, 46, '50.00', 5, 5, 'ACTIVE'), (3, 2, 47, '50.00', 5, 5, 'ACTIVE'), (3, 2, 48, '10.00', 10, 10, 'ACTIVE'), (3, 2, 49, '10.00', 10, 10, 'ACTIVE'), (3, 2, 50, '10.00', 10, 10, 'ACTIVE'), (3, 2, 51, '10.00', 10, 10, 'ACTIVE'), (3, 2, 52, '10.00', 10, 10, 'ACTIVE'), (3, 2, 53, '50.00', 5, 5, 'ACTIVE'), (3, 2, 54, '50.00', 5, 5, 'ACTIVE'), (3, 2, 55, '50.00', 5, 5, 'ACTIVE'), (3, 2, 56, '50.00', 5, 5, 'ACTIVE'), (3, 2, 57, '10.00', 10, 10, 'ACTIVE'), (3, 2, 58, '10.00', 10, 10, 'ACTIVE'), (3, 2, 59, '10.00', 10, 10, 'ACTIVE'), (3, 2, 60, '10.00', 10, 10, 'ACTIVE'), (3, 2, 61, '10.00', 10, 10, 'ACTIVE'), (3, 3, 1, '25.00', 12, 10, 'ACTIVE'), (3, 3, 2, '25.00', 12, 10, 'ACTIVE'), (3, 3, 3, '25.00', 12, 10, 'ACTIVE'), (3, 3, 4, '25.00', 12, 10, 'ACTIVE'), (3, 3, 5, '25.00', 12, 10, 'ACTIVE'), (3, 3, 6, '25.00', 10, 10, 'ACTIVE'), (3, 3, 7, '25.00', 10, 10, 'ACTIVE'), (3, 3, 8, '25.00', 10, 10, 'ACTIVE'), (3, 3, 9, '25.00', 10, 10, 'ACTIVE'), (3, 3, 10, '25.00', 10, 10, 'ACTIVE'), (3, 3, 11, '25.00', 10, 10, 'ACTIVE'), (3, 3, 12, '25.00', 10, 10, 'ACTIVE'), (3, 3, 13, '25.00', 10, 10, 'ACTIVE'), (3, 3, 24, '25.00', 10, 10, 'ACTIVE'), (3, 3, 25, '25.00', 10, 10, 'ACTIVE'), (3, 3, 26, '25.00', 10, 10, 'ACTIVE'), (3, 3, 27, '25.00', 10, 10, 'ACTIVE'), (3, 3, 28, '25.00', 10, 10, 'ACTIVE'), (3, 3, 29, '25.00', 10, 10, 'ACTIVE'), (3, 3, 30, '25.00', 10, 10, 'ACTIVE'), (3, 3, 31, '25.00', 10, 10, 'ACTIVE'), (3, 3, 32, '25.00', 10, 10, 'ACTIVE'), (3, 3, 33, '25.00', 10, 10, 'ACTIVE'), (3, 3, 34, '25.00', 10, 10, 'ACTIVE'), (3, 3, 35, '25.00', 10, 10, 'ACTIVE'), (3, 3, 36, '25.00', 10, 10, 'ACTIVE'), (3, 3, 37, '25.00', 10, 10, 'ACTIVE'), (3, 3, 38, '25.00', 10, 10, 'ACTIVE'), (3, 3, 39, '25.00', 10, 10, 'ACTIVE'), (3, 3, 40, '50.00', 5, 5, 'ACTIVE'), (3, 3, 41, '50.00', 5, 5, 'ACTIVE'), (3, 3, 42, '50.00', 5, 5, 'ACTIVE'), (3, 3, 43, '50.00', 5, 5, 'ACTIVE'), (3, 3, 44, '50.00', 5, 5, 'ACTIVE'), (3, 3, 45, '50.00', 5, 5, 'ACTIVE'), (3, 3, 46, '50.00', 5, 5, 'ACTIVE'), (3, 3, 47, '50.00', 5, 5, 'ACTIVE'), (3, 3, 48, '10.00', 10, 10, 'ACTIVE'), (3, 3, 49, '10.00', 10, 10, 'ACTIVE'), (3, 3, 50, '10.00', 10, 10, 'ACTIVE'), (3, 3, 51, '10.00', 10, 10, 'ACTIVE'), (3, 3, 52, '10.00', 10, 10, 'ACTIVE'), (3, 3, 53, '50.00', 5, 5, 'ACTIVE'), (3, 3, 54, '50.00', 5, 5, 'ACTIVE'), (3, 3, 55, '50.00', 5, 5, 'ACTIVE'), (3, 3, 56, '50.00', 5, 5, 'ACTIVE'), (3, 3, 57, '10.00', 10, 10, 'ACTIVE'), (3, 3, 58, '10.00', 10, 10, 'ACTIVE'), (3, 3, 59, '10.00', 10, 10, 'ACTIVE'), (3, 3, 60, '10.00', 10, 10, 'ACTIVE'), (3, 3, 61, '10.00', 10, 10, 'ACTIVE'), (4, 1, 1, '50.00', 12, 8, 'ACTIVE'), (4, 1, 2, '50.00', 12, 8, 'ACTIVE'), (4, 1, 3, '50.00', 12, 8, 'ACTIVE'), (4, 1, 4, '50.00', 12, 8, 'ACTIVE'), (4, 1, 5, '50.00', 12, 8, 'ACTIVE'), (4, 1, 6, '50.00', 10, 10, 'ACTIVE'), (4, 1, 7, '50.00', 10, 10, 'ACTIVE'), (4, 1, 8, '50.00', 10, 10, 'ACTIVE'), (4, 1, 9, '50.00', 10, 10, 'ACTIVE'), (4, 1, 10, '50.00', 10, 10, 'ACTIVE'), (4, 1, 11, '50.00', 10, 10, 'ACTIVE'), (4, 1, 12, '50.00', 10, 10, 'ACTIVE'), (4, 1, 13, '50.00', 10, 10, 'ACTIVE'), (4, 1, 14, '80.00', 10, 10, 'ACTIVE'), (4, 1, 15, '80.00', 10, 10, 'ACTIVE'), (4, 1, 16, '80.00', 10, 10, 'ACTIVE'), (4, 1, 17, '80.00', 10, 10, 'ACTIVE'), (4, 1, 18, '80.00', 10, 10, 'ACTIVE'), (4, 1, 19, '80.00', 10, 10, 'ACTIVE'), (4, 1, 20, '80.00', 10, 10, 'ACTIVE'), (4, 1, 21, '80.00', 10, 10, 'ACTIVE'), (4, 1, 22, '80.00', 10, 10, 'ACTIVE'), (4, 1, 23, '80.00', 10, 10, 'ACTIVE'), (4, 1, 24, '50.00', 10, 10, 'ACTIVE'), (4, 1, 25, '50.00', 10, 10, 'ACTIVE'), (4, 1, 26, '50.00', 10, 10, 'ACTIVE'), (4, 1, 27, '50.00', 10, 10, 'ACTIVE'), (4, 1, 28, '50.00', 10, 10, 'ACTIVE'), (4, 1, 29, '50.00', 10, 10, 'ACTIVE'), (4, 1, 30, '50.00', 10, 10, 'ACTIVE'), (4, 1, 31, '50.00', 10, 10, 'ACTIVE'), (4, 1, 32, '50.00', 10, 10, 'ACTIVE'), (4, 1, 33, '50.00', 10, 10, 'ACTIVE'), (4, 1, 34, '50.00', 10, 10, 'ACTIVE'), (4, 1, 35, '50.00', 10, 10, 'ACTIVE'), (4, 1, 36, '50.00', 10, 10, 'ACTIVE'), (4, 1, 37, '50.00', 10, 10, 'ACTIVE'), (4, 1, 38, '50.00', 10, 10, 'ACTIVE'), (4, 1, 39, '50.00', 10, 10, 'ACTIVE'), (4, 1, 48, '80.00', 10, 10, 'ACTIVE'), (4, 1, 49, '80.00', 10, 10, 'ACTIVE'), (4, 1, 50, '80.00', 10, 10, 'ACTIVE'), (4, 1, 51, '80.00', 10, 10, 'ACTIVE'), (4, 1, 52, '80.00', 10, 10, 'ACTIVE'), (4, 1, 57, '80.00', 10, 10, 'ACTIVE'), (4, 1, 58, '80.00', 10, 10, 'ACTIVE'), (4, 1, 59, '80.00', 10, 10, 'ACTIVE'), (4, 1, 60, '80.00', 10, 10, 'ACTIVE'), (4, 1, 61, '80.00', 10, 10, 'ACTIVE'), (4, 2, 1, '50.00', 12, 8, 'ACTIVE'), (4, 2, 2, '50.00', 12, 8, 'ACTIVE'), (4, 2, 3, '50.00', 12, 8, 'ACTIVE'), (4, 2, 4, '50.00', 12, 8, 'ACTIVE'), (4, 2, 5, '50.00', 12, 8, 'ACTIVE'), (4, 2, 6, '50.00', 10, 10, 'ACTIVE'), (4, 2, 7, '50.00', 10, 10, 'ACTIVE'), (4, 2, 8, '50.00', 10, 10, 'ACTIVE'), (4, 2, 9, '50.00', 10, 10, 'ACTIVE'), (4, 2, 10, '50.00', 10, 10, 'ACTIVE'), (4, 2, 11, '50.00', 10, 10, 'ACTIVE'), (4, 2, 12, '50.00', 10, 10, 'ACTIVE'), (4, 2, 13, '50.00', 10, 10, 'ACTIVE'), (4, 2, 14, '80.00', 10, 10, 'ACTIVE'), (4, 2, 15, '80.00', 10, 10, 'ACTIVE'), (4, 2, 16, '80.00', 10, 10, 'ACTIVE'), (4, 2, 17, '80.00', 10, 10, 'ACTIVE'), (4, 2, 18, '80.00', 10, 10, 'ACTIVE'), (4, 2, 19, '80.00', 10, 10, 'ACTIVE'), (4, 2, 20, '80.00', 10, 10, 'ACTIVE'), (4, 2, 21, '80.00', 10, 10, 'ACTIVE'), (4, 2, 22, '80.00', 10, 10, 'ACTIVE'), (4, 2, 23, '80.00', 10, 10, 'ACTIVE'), (4, 2, 24, '50.00', 10, 10, 'ACTIVE'), (4, 2, 25, '50.00', 10, 10, 'ACTIVE'), (4, 2, 26, '50.00', 10, 10, 'ACTIVE'), (4, 2, 27, '50.00', 10, 10, 'ACTIVE'), (4, 2, 28, '50.00', 10, 10, 'ACTIVE'), (4, 2, 29, '50.00', 10, 10, 'ACTIVE'), (4, 2, 30, '50.00', 10, 10, 'ACTIVE'), (4, 2, 31, '50.00', 10, 10, 'ACTIVE'), (4, 2, 32, '50.00', 10, 10, 'ACTIVE'), (4, 2, 33, '50.00', 10, 10, 'ACTIVE'), (4, 2, 34, '50.00', 10, 10, 'ACTIVE'), (4, 2, 35, '50.00', 10, 10, 'ACTIVE'), (4, 2, 36, '50.00', 10, 10, 'ACTIVE'), (4, 2, 37, '50.00', 10, 10, 'ACTIVE'), (4, 2, 38, '50.00', 10, 10, 'ACTIVE'), (4, 2, 39, '50.00', 10, 10, 'ACTIVE'), (4, 2, 48, '80.00', 10, 10, 'ACTIVE'), (4, 2, 49, '80.00', 10, 10, 'ACTIVE'), (4, 2, 50, '80.00', 10, 10, 'ACTIVE'), (4, 2, 51, '80.00', 10, 10, 'ACTIVE'), (4, 2, 52, '80.00', 10, 10, 'ACTIVE'), (4, 2, 57, '80.00', 10, 10, 'ACTIVE'), (4, 2, 58, '80.00', 10, 10, 'ACTIVE'), (4, 2, 59, '80.00', 10, 10, 'ACTIVE'), (4, 2, 60, '80.00', 10, 10, 'ACTIVE'), (4, 2, 61, '80.00', 10, 10, 'ACTIVE'), (4, 3, 1, '50.00', 12, 8, 'ACTIVE'), (4, 3, 2, '50.00', 12, 8, 'ACTIVE'), (4, 3, 3, '50.00', 12, 8, 'ACTIVE'), (4, 3, 4, '50.00', 12, 8, 'ACTIVE'), (4, 3, 5, '50.00', 12, 8, 'ACTIVE'), (4, 3, 6, '50.00', 10, 10, 'ACTIVE'), (4, 3, 7, '50.00', 10, 10, 'ACTIVE'), (4, 3, 8, '50.00', 10, 10, 'ACTIVE'), (4, 3, 9, '50.00', 10, 10, 'ACTIVE'), (4, 3, 10, '50.00', 10, 10, 'ACTIVE'), (4, 3, 11, '50.00', 10, 10, 'ACTIVE'), (4, 3, 12, '50.00', 10, 10, 'ACTIVE'), (4, 3, 13, '50.00', 10, 10, 'ACTIVE'), (4, 3, 14, '80.00', 10, 10, 'ACTIVE'), (4, 3, 15, '80.00', 10, 10, 'ACTIVE'), (4, 3, 16, '80.00', 10, 10, 'ACTIVE'), (4, 3, 17, '80.00', 10, 10, 'ACTIVE'), (4, 3, 18, '80.00', 10, 10, 'ACTIVE'), (4, 3, 19, '80.00', 10, 10, 'ACTIVE'), (4, 3, 20, '80.00', 10, 10, 'ACTIVE'), (4, 3, 21, '80.00', 10, 10, 'ACTIVE'), (4, 3, 22, '80.00', 10, 10, 'ACTIVE'), (4, 3, 23, '80.00', 10, 10, 'ACTIVE'), (4, 3, 24, '50.00', 10, 10, 'ACTIVE'), (4, 3, 25, '50.00', 10, 10, 'ACTIVE'), (4, 3, 26, '50.00', 10, 10, 'ACTIVE'), (4, 3, 27, '50.00', 10, 10, 'ACTIVE'), (4, 3, 28, '50.00', 10, 10, 'ACTIVE'), (4, 3, 29, '50.00', 10, 10, 'ACTIVE'), (4, 3, 30, '50.00', 10, 10, 'ACTIVE'), (4, 3, 31, '50.00', 10, 10, 'ACTIVE'), (4, 3, 32, '50.00', 10, 10, 'ACTIVE'), (4, 3, 33, '50.00', 10, 10, 'ACTIVE'), (4, 3, 34, '50.00', 10, 10, 'ACTIVE'), (4, 3, 35, '50.00', 10, 10, 'ACTIVE'), (4, 3, 36, '50.00', 10, 10, 'ACTIVE'), (4, 3, 37, '50.00', 10, 10, 'ACTIVE'), (4, 3, 38, '50.00', 10, 10, 'ACTIVE'), (4, 3, 39, '50.00', 10, 10, 'ACTIVE'), (4, 3, 48, '80.00', 10, 10, 'ACTIVE'), (4, 3, 49, '80.00', 10, 10, 'ACTIVE'), (4, 3, 50, '80.00', 10, 10, 'ACTIVE'), (4, 3, 51, '80.00', 10, 10, 'ACTIVE'), (4, 3, 52, '80.00', 10, 10, 'ACTIVE'), (4, 3, 57, '80.00', 10, 10, 'ACTIVE'), (4, 3, 58, '80.00', 10, 10, 'ACTIVE'), (4, 3, 59, '80.00', 10, 10, 'ACTIVE'), (4, 3, 60, '80.00', 10, 10, 'ACTIVE'), (4, 3, 61, '80.00', 10, 10, 'ACTIVE'); -- -- Dumping data for table 'subject_period_exam' -- -- -- Dumping data for table 'subject_retest_change_log' -- -- -- Dumping data for table 'subject_year_activity_criteria_period' -- INSERT INTO subject_year_activity_criteria_period (serial_att, serial_prd, serial_sbc, serial_sbj, serial_gct, status_acp) VALUES (2, 1, 1, 4, 1, 'ACTIVE'), (2, 1, 2, 1, 1, 'ACTIVE'), (2, 1, 3, 2, 1, 'ACTIVE'), (2, 1, 4, 3, 1, 'ACTIVE'), (2, 1, 5, 5, 1, 'ACTIVE'), (2, 1, 6, 14, 1, 'ACTIVE'), (2, 1, 7, 14, 1, 'ACTIVE'), (2, 1, 8, 11, 1, 'ACTIVE'), (2, 1, 9, 11, 1, 'ACTIVE'), (2, 1, 10, 12, 1, 'ACTIVE'), (2, 1, 11, 12, 1, 'ACTIVE'), (2, 1, 12, 13, 1, 'ACTIVE'), (2, 1, 13, 13, 1, 'ACTIVE'), (2, 1, 14, 9, 1, 'ACTIVE'), (2, 1, 15, 9, 1, 'ACTIVE'), (2, 1, 16, 10, 1, 'ACTIVE'), (2, 1, 17, 10, 1, 'ACTIVE'), (2, 1, 18, 6, 1, 'ACTIVE'), (2, 1, 19, 6, 1, 'ACTIVE'), (2, 1, 20, 7, 1, 'ACTIVE'), (2, 1, 21, 7, 1, 'ACTIVE'), (2, 1, 22, 8, 1, 'ACTIVE'), (2, 1, 23, 8, 1, 'ACTIVE'), (2, 1, 24, 19, 1, 'ACTIVE'), (2, 1, 25, 19, 1, 'ACTIVE'), (2, 1, 26, 18, 1, 'ACTIVE'), (2, 1, 27, 18, 1, 'ACTIVE'), (2, 1, 28, 15, 1, 'ACTIVE'), (2, 1, 29, 15, 1, 'ACTIVE'), (2, 1, 30, 16, 1, 'ACTIVE'), (2, 1, 31, 16, 1, 'ACTIVE'), (2, 1, 32, 17, 1, 'ACTIVE'), (2, 1, 33, 17, 1, 'ACTIVE'), (2, 1, 34, 20, 1, 'ACTIVE'), (2, 1, 35, 20, 1, 'ACTIVE'), (2, 1, 36, 21, 1, 'ACTIVE'), (2, 1, 37, 21, 1, 'ACTIVE'), (2, 1, 38, 22, 1, 'ACTIVE'), (2, 1, 39, 22, 1, 'ACTIVE'), (2, 1, 40, 27, 1, 'ACTIVE'), (2, 1, 41, 27, 1, 'ACTIVE'), (2, 1, 42, 26, 1, 'ACTIVE'), (2, 1, 43, 26, 1, 'ACTIVE'), (2, 1, 44, 24, 1, 'ACTIVE'), (2, 1, 45, 24, 1, 'ACTIVE'), (2, 1, 46, 25, 1, 'ACTIVE'), (2, 1, 47, 25, 1, 'ACTIVE'), (2, 1, 48, 32, 1, 'ACTIVE'), (2, 1, 49, 28, 1, 'ACTIVE'), (2, 1, 50, 29, 1, 'ACTIVE'), (2, 1, 51, 30, 1, 'ACTIVE'), (2, 1, 52, 31, 1, 'ACTIVE'), (2, 1, 53, 38, 1, 'ACTIVE'), (2, 1, 54, 38, 1, 'ACTIVE'), (2, 1, 55, 39, 1, 'ACTIVE'), (2, 1, 56, 39, 1, 'ACTIVE'), (2, 1, 57, 37, 1, 'ACTIVE'), (2, 1, 58, 36, 1, 'ACTIVE'), (2, 1, 59, 33, 1, 'ACTIVE'), (2, 1, 60, 34, 1, 'ACTIVE'), (2, 1, 61, 35, 1, 'ACTIVE'), (2, 2, 1, 4, 1, 'ACTIVE'), (2, 2, 2, 1, 1, 'ACTIVE'), (2, 2, 3, 2, 1, 'ACTIVE'), (2, 2, 4, 3, 1, 'ACTIVE'), (2, 2, 5, 5, 1, 'ACTIVE'), (2, 2, 6, 14, 1, 'ACTIVE'), (2, 2, 7, 14, 1, 'ACTIVE'), (2, 2, 8, 11, 1, 'ACTIVE'), (2, 2, 9, 11, 1, 'ACTIVE'), (2, 2, 10, 12, 1, 'ACTIVE'), (2, 2, 11, 12, 1, 'ACTIVE'), (2, 2, 12, 13, 1, 'ACTIVE'), (2, 2, 13, 13, 1, 'ACTIVE'), (2, 2, 14, 9, 1, 'ACTIVE'), (2, 2, 15, 9, 1, 'ACTIVE'), (2, 2, 16, 10, 1, 'ACTIVE'), (2, 2, 17, 10, 1, 'ACTIVE'), (2, 2, 18, 6, 1, 'ACTIVE'), (2, 2, 19, 6, 1, 'ACTIVE'), (2, 2, 20, 7, 1, 'ACTIVE'), (2, 2, 21, 7, 1, 'ACTIVE'), (2, 2, 22, 8, 1, 'ACTIVE'), (2, 2, 23, 8, 1, 'ACTIVE'), (2, 2, 24, 19, 1, 'ACTIVE'), (2, 2, 25, 19, 1, 'ACTIVE'), (2, 2, 26, 18, 1, 'ACTIVE'), (2, 2, 27, 18, 1, 'ACTIVE'), (2, 2, 28, 15, 1, 'ACTIVE'), (2, 2, 29, 15, 1, 'ACTIVE'), (2, 2, 30, 16, 1, 'ACTIVE'), (2, 2, 31, 16, 1, 'ACTIVE'), (2, 2, 32, 17, 1, 'ACTIVE'), (2, 2, 33, 17, 1, 'ACTIVE'), (2, 2, 34, 20, 1, 'ACTIVE'), (2, 2, 35, 20, 1, 'ACTIVE'), (2, 2, 36, 21, 1, 'ACTIVE'), (2, 2, 37, 21, 1, 'ACTIVE'), (2, 2, 38, 22, 1, 'ACTIVE'), (2, 2, 39, 22, 1, 'ACTIVE'), (2, 2, 40, 27, 1, 'ACTIVE'), (2, 2, 41, 27, 1, 'ACTIVE'), (2, 2, 42, 26, 1, 'ACTIVE'), (2, 2, 43, 26, 1, 'ACTIVE'), (2, 2, 44, 24, 1, 'ACTIVE'), (2, 2, 45, 24, 1, 'ACTIVE'), (2, 2, 46, 25, 1, 'ACTIVE'), (2, 2, 47, 25, 1, 'ACTIVE'), (2, 2, 48, 32, 1, 'ACTIVE'), (2, 2, 49, 28, 1, 'ACTIVE'), (2, 2, 50, 29, 1, 'ACTIVE'), (2, 2, 51, 30, 1, 'ACTIVE'), (2, 2, 52, 31, 1, 'ACTIVE'), (2, 2, 53, 38, 1, 'ACTIVE'), (2, 2, 54, 38, 1, 'ACTIVE'), (2, 2, 55, 39, 1, 'ACTIVE'), (2, 2, 56, 39, 1, 'ACTIVE'), (2, 2, 57, 37, 1, 'ACTIVE'), (2, 2, 58, 36, 1, 'ACTIVE'), (2, 2, 59, 33, 1, 'ACTIVE'), (2, 2, 60, 34, 1, 'ACTIVE'), (2, 2, 61, 35, 1, 'ACTIVE'), (2, 3, 1, 4, 1, 'ACTIVE'), (2, 3, 2, 1, 1, 'ACTIVE'), (2, 3, 3, 2, 1, 'ACTIVE'), (2, 3, 4, 3, 1, 'ACTIVE'), (2, 3, 5, 5, 1, 'ACTIVE'), (2, 3, 6, 14, 1, 'ACTIVE'), (2, 3, 7, 14, 1, 'ACTIVE'), (2, 3, 8, 11, 1, 'ACTIVE'), (2, 3, 9, 11, 1, 'ACTIVE'), (2, 3, 10, 12, 1, 'ACTIVE'), (2, 3, 11, 12, 1, 'ACTIVE'), (2, 3, 12, 13, 1, 'ACTIVE'), (2, 3, 13, 13, 1, 'ACTIVE'), (2, 3, 14, 9, 1, 'ACTIVE'), (2, 3, 15, 9, 1, 'ACTIVE'), (2, 3, 16, 10, 1, 'ACTIVE'), (2, 3, 17, 10, 1, 'ACTIVE'), (2, 3, 18, 6, 1, 'ACTIVE'), (2, 3, 19, 6, 1, 'ACTIVE'), (2, 3, 20, 7, 1, 'ACTIVE'), (2, 3, 21, 7, 1, 'ACTIVE'), (2, 3, 22, 8, 1, 'ACTIVE'), (2, 3, 23, 8, 1, 'ACTIVE'), (2, 3, 24, 19, 1, 'ACTIVE'), (2, 3, 25, 19, 1, 'ACTIVE'), (2, 3, 26, 18, 1, 'ACTIVE'), (2, 3, 27, 18, 1, 'ACTIVE'), (2, 3, 28, 15, 1, 'ACTIVE'), (2, 3, 29, 15, 1, 'ACTIVE'), (2, 3, 30, 16, 1, 'ACTIVE'), (2, 3, 31, 16, 1, 'ACTIVE'), (2, 3, 32, 17, 1, 'ACTIVE'), (2, 3, 33, 17, 1, 'ACTIVE'), (2, 3, 34, 20, 1, 'ACTIVE'), (2, 3, 35, 20, 1, 'ACTIVE'), (2, 3, 36, 21, 1, 'ACTIVE'), (2, 3, 37, 21, 1, 'ACTIVE'), (2, 3, 38, 22, 1, 'ACTIVE'), (2, 3, 39, 22, 1, 'ACTIVE'), (2, 3, 40, 27, 1, 'ACTIVE'), (2, 3, 41, 27, 1, 'ACTIVE'), (2, 3, 42, 26, 1, 'ACTIVE'), (2, 3, 43, 26, 1, 'ACTIVE'), (2, 3, 44, 24, 1, 'ACTIVE'), (2, 3, 45, 24, 1, 'ACTIVE'), (2, 3, 46, 25, 1, 'ACTIVE'), (2, 3, 47, 25, 1, 'ACTIVE'), (2, 3, 48, 32, 1, 'ACTIVE'), (2, 3, 49, 28, 1, 'ACTIVE'), (2, 3, 50, 29, 1, 'ACTIVE'), (2, 3, 51, 30, 1, 'ACTIVE'), (2, 3, 52, 31, 1, 'ACTIVE'), (2, 3, 53, 38, 1, 'ACTIVE'), (2, 3, 54, 38, 1, 'ACTIVE'), (2, 3, 55, 39, 1, 'ACTIVE'), (2, 3, 56, 39, 1, 'ACTIVE'), (2, 3, 57, 37, 1, 'ACTIVE'), (2, 3, 58, 36, 1, 'ACTIVE'), (2, 3, 59, 33, 1, 'ACTIVE'), (2, 3, 60, 34, 1, 'ACTIVE'), (2, 3, 61, 35, 1, 'ACTIVE'), (3, 1, 1, 4, 1, 'ACTIVE'), (3, 1, 2, 1, 1, 'ACTIVE'), (3, 1, 3, 2, 1, 'ACTIVE'), (3, 1, 4, 3, 1, 'ACTIVE'), (3, 1, 5, 5, 1, 'ACTIVE'), (3, 1, 6, 14, 1, 'ACTIVE'), (3, 1, 7, 14, 1, 'ACTIVE'), (3, 1, 8, 11, 1, 'ACTIVE'), (3, 1, 9, 11, 1, 'ACTIVE'), (3, 1, 10, 12, 1, 'ACTIVE'), (3, 1, 11, 12, 1, 'ACTIVE'), (3, 1, 12, 13, 1, 'ACTIVE'), (3, 1, 13, 13, 1, 'ACTIVE'), (3, 1, 24, 19, 1, 'ACTIVE'), (3, 1, 25, 19, 1, 'ACTIVE'), (3, 1, 26, 18, 1, 'ACTIVE'), (3, 1, 27, 18, 1, 'ACTIVE'), (3, 1, 28, 15, 1, 'ACTIVE'), (3, 1, 29, 15, 1, 'ACTIVE'), (3, 1, 30, 16, 1, 'ACTIVE'), (3, 1, 31, 16, 1, 'ACTIVE'), (3, 1, 32, 17, 1, 'ACTIVE'), (3, 1, 33, 17, 1, 'ACTIVE'), (3, 1, 34, 20, 1, 'ACTIVE'), (3, 1, 35, 20, 1, 'ACTIVE'), (3, 1, 36, 21, 1, 'ACTIVE'), (3, 1, 37, 21, 1, 'ACTIVE'), (3, 1, 38, 22, 1, 'ACTIVE'), (3, 1, 39, 22, 1, 'ACTIVE'), (3, 1, 40, 27, 1, 'ACTIVE'), (3, 1, 41, 27, 1, 'ACTIVE'), (3, 1, 42, 26, 1, 'ACTIVE'), (3, 1, 43, 26, 1, 'ACTIVE'), (3, 1, 44, 24, 1, 'ACTIVE'), (3, 1, 45, 24, 1, 'ACTIVE'), (3, 1, 46, 25, 1, 'ACTIVE'), (3, 1, 47, 25, 1, 'ACTIVE'), (3, 1, 48, 32, 1, 'ACTIVE'), (3, 1, 49, 28, 1, 'ACTIVE'), (3, 1, 50, 29, 1, 'ACTIVE'), (3, 1, 51, 30, 1, 'ACTIVE'), (3, 1, 52, 31, 1, 'ACTIVE'), (3, 1, 53, 38, 1, 'ACTIVE'), (3, 1, 54, 38, 1, 'ACTIVE'), (3, 1, 55, 39, 1, 'ACTIVE'), (3, 1, 56, 39, 1, 'ACTIVE'), (3, 1, 57, 37, 1, 'ACTIVE'), (3, 1, 58, 36, 1, 'ACTIVE'), (3, 1, 59, 33, 1, 'ACTIVE'), (3, 1, 60, 34, 1, 'ACTIVE'), (3, 1, 61, 35, 1, 'ACTIVE'), (3, 2, 1, 4, 1, 'ACTIVE'), (3, 2, 2, 1, 1, 'ACTIVE'), (3, 2, 3, 2, 1, 'ACTIVE'), (3, 2, 4, 3, 1, 'ACTIVE'), (3, 2, 5, 5, 1, 'ACTIVE'), (3, 2, 6, 14, 1, 'ACTIVE'), (3, 2, 7, 14, 1, 'ACTIVE'), (3, 2, 8, 11, 1, 'ACTIVE'), (3, 2, 9, 11, 1, 'ACTIVE'), (3, 2, 10, 12, 1, 'ACTIVE'), (3, 2, 11, 12, 1, 'ACTIVE'), (3, 2, 12, 13, 1, 'ACTIVE'), (3, 2, 13, 13, 1, 'ACTIVE'), (3, 2, 24, 19, 1, 'ACTIVE'), (3, 2, 25, 19, 1, 'ACTIVE'), (3, 2, 26, 18, 1, 'ACTIVE'), (3, 2, 27, 18, 1, 'ACTIVE'), (3, 2, 28, 15, 1, 'ACTIVE'), (3, 2, 29, 15, 1, 'ACTIVE'), (3, 2, 30, 16, 1, 'ACTIVE'), (3, 2, 31, 16, 1, 'ACTIVE'), (3, 2, 32, 17, 1, 'ACTIVE'), (3, 2, 33, 17, 1, 'ACTIVE'), (3, 2, 34, 20, 1, 'ACTIVE'), (3, 2, 35, 20, 1, 'ACTIVE'), (3, 2, 36, 21, 1, 'ACTIVE'), (3, 2, 37, 21, 1, 'ACTIVE'), (3, 2, 38, 22, 1, 'ACTIVE'), (3, 2, 39, 22, 1, 'ACTIVE'), (3, 2, 40, 27, 1, 'ACTIVE'), (3, 2, 41, 27, 1, 'ACTIVE'), (3, 2, 42, 26, 1, 'ACTIVE'), (3, 2, 43, 26, 1, 'ACTIVE'), (3, 2, 44, 24, 1, 'ACTIVE'), (3, 2, 45, 24, 1, 'ACTIVE'), (3, 2, 46, 25, 1, 'ACTIVE'), (3, 2, 47, 25, 1, 'ACTIVE'), (3, 2, 48, 32, 1, 'ACTIVE'), (3, 2, 49, 28, 1, 'ACTIVE'), (3, 2, 50, 29, 1, 'ACTIVE'), (3, 2, 51, 30, 1, 'ACTIVE'), (3, 2, 52, 31, 1, 'ACTIVE'), (3, 2, 53, 38, 1, 'ACTIVE'), (3, 2, 54, 38, 1, 'ACTIVE'), (3, 2, 55, 39, 1, 'ACTIVE'), (3, 2, 56, 39, 1, 'ACTIVE'), (3, 2, 57, 37, 1, 'ACTIVE'), (3, 2, 58, 36, 1, 'ACTIVE'), (3, 2, 59, 33, 1, 'ACTIVE'), (3, 2, 60, 34, 1, 'ACTIVE'), (3, 2, 61, 35, 1, 'ACTIVE'), (3, 3, 1, 4, 1, 'ACTIVE'), (3, 3, 2, 1, 1, 'ACTIVE'), (3, 3, 3, 2, 1, 'ACTIVE'), (3, 3, 4, 3, 1, 'ACTIVE'), (3, 3, 5, 5, 1, 'ACTIVE'), (3, 3, 6, 14, 1, 'ACTIVE'), (3, 3, 7, 14, 1, 'ACTIVE'), (3, 3, 8, 11, 1, 'ACTIVE'), (3, 3, 9, 11, 1, 'ACTIVE'), (3, 3, 10, 12, 1, 'ACTIVE'), (3, 3, 11, 12, 1, 'ACTIVE'), (3, 3, 12, 13, 1, 'ACTIVE'), (3, 3, 13, 13, 1, 'ACTIVE'), (3, 3, 24, 19, 1, 'ACTIVE'), (3, 3, 25, 19, 1, 'ACTIVE'), (3, 3, 26, 18, 1, 'ACTIVE'), (3, 3, 27, 18, 1, 'ACTIVE'), (3, 3, 28, 15, 1, 'ACTIVE'), (3, 3, 29, 15, 1, 'ACTIVE'), (3, 3, 30, 16, 1, 'ACTIVE'), (3, 3, 31, 16, 1, 'ACTIVE'), (3, 3, 32, 17, 1, 'ACTIVE'), (3, 3, 33, 17, 1, 'ACTIVE'), (3, 3, 34, 20, 1, 'ACTIVE'), (3, 3, 35, 20, 1, 'ACTIVE'), (3, 3, 36, 21, 1, 'ACTIVE'), (3, 3, 37, 21, 1, 'ACTIVE'), (3, 3, 38, 22, 1, 'ACTIVE'), (3, 3, 39, 22, 1, 'ACTIVE'), (3, 3, 40, 27, 1, 'ACTIVE'), (3, 3, 41, 27, 1, 'ACTIVE'), (3, 3, 42, 26, 1, 'ACTIVE'), (3, 3, 43, 26, 1, 'ACTIVE'), (3, 3, 44, 24, 1, 'ACTIVE'), (3, 3, 45, 24, 1, 'ACTIVE'), (3, 3, 46, 25, 1, 'ACTIVE'), (3, 3, 47, 25, 1, 'ACTIVE'), (3, 3, 48, 32, 1, 'ACTIVE'), (3, 3, 49, 28, 1, 'ACTIVE'), (3, 3, 50, 29, 1, 'ACTIVE'), (3, 3, 51, 30, 1, 'ACTIVE'), (3, 3, 52, 31, 1, 'ACTIVE'), (3, 3, 53, 38, 1, 'ACTIVE'), (3, 3, 54, 38, 1, 'ACTIVE'), (3, 3, 55, 39, 1, 'ACTIVE'), (3, 3, 56, 39, 1, 'ACTIVE'), (3, 3, 57, 37, 1, 'ACTIVE'), (3, 3, 58, 36, 1, 'ACTIVE'), (3, 3, 59, 33, 1, 'ACTIVE'), (3, 3, 60, 34, 1, 'ACTIVE'), (3, 3, 61, 35, 1, 'ACTIVE'), (4, 1, 1, 4, 1, 'ACTIVE'), (4, 1, 2, 1, 1, 'ACTIVE'), (4, 1, 3, 2, 1, 'ACTIVE'), (4, 1, 4, 3, 1, 'ACTIVE'), (4, 1, 5, 5, 1, 'ACTIVE'), (4, 1, 6, 14, 1, 'ACTIVE'), (4, 1, 7, 14, 1, 'ACTIVE'), (4, 1, 8, 11, 1, 'ACTIVE'), (4, 1, 9, 11, 1, 'ACTIVE'), (4, 1, 10, 12, 1, 'ACTIVE'), (4, 1, 11, 12, 1, 'ACTIVE'), (4, 1, 12, 13, 1, 'ACTIVE'), (4, 1, 13, 13, 1, 'ACTIVE'), (4, 1, 14, 9, 1, 'ACTIVE'), (4, 1, 15, 9, 1, 'ACTIVE'), (4, 1, 16, 10, 1, 'ACTIVE'), (4, 1, 17, 10, 1, 'ACTIVE'), (4, 1, 18, 6, 1, 'ACTIVE'), (4, 1, 19, 6, 1, 'ACTIVE'), (4, 1, 20, 7, 1, 'ACTIVE'), (4, 1, 21, 7, 1, 'ACTIVE'), (4, 1, 22, 8, 1, 'ACTIVE'), (4, 1, 23, 8, 1, 'ACTIVE'), (4, 1, 24, 19, 1, 'ACTIVE'), (4, 1, 25, 19, 1, 'ACTIVE'), (4, 1, 26, 18, 1, 'ACTIVE'), (4, 1, 27, 18, 1, 'ACTIVE'), (4, 1, 28, 15, 1, 'ACTIVE'), (4, 1, 29, 15, 1, 'ACTIVE'), (4, 1, 30, 16, 1, 'ACTIVE'), (4, 1, 31, 16, 1, 'ACTIVE'), (4, 1, 32, 17, 1, 'ACTIVE'), (4, 1, 33, 17, 1, 'ACTIVE'), (4, 1, 34, 20, 1, 'ACTIVE'), (4, 1, 35, 20, 1, 'ACTIVE'), (4, 1, 36, 21, 1, 'ACTIVE'), (4, 1, 37, 21, 1, 'ACTIVE'), (4, 1, 38, 22, 1, 'ACTIVE'), (4, 1, 39, 22, 1, 'ACTIVE'), (4, 1, 48, 32, 1, 'ACTIVE'), (4, 1, 49, 28, 1, 'ACTIVE'), (4, 1, 50, 29, 1, 'ACTIVE'), (4, 1, 51, 30, 1, 'ACTIVE'), (4, 1, 52, 31, 1, 'ACTIVE'), (4, 1, 57, 37, 1, 'ACTIVE'), (4, 1, 58, 36, 1, 'ACTIVE'), (4, 1, 59, 33, 1, 'ACTIVE'), (4, 1, 60, 34, 1, 'ACTIVE'), (4, 1, 61, 35, 1, 'ACTIVE'), (4, 2, 1, 4, 1, 'ACTIVE'), (4, 2, 2, 1, 1, 'ACTIVE'), (4, 2, 3, 2, 1, 'ACTIVE'), (4, 2, 4, 3, 1, 'ACTIVE'), (4, 2, 5, 5, 1, 'ACTIVE'), (4, 2, 6, 14, 1, 'ACTIVE'), (4, 2, 7, 14, 1, 'ACTIVE'), (4, 2, 8, 11, 1, 'ACTIVE'), (4, 2, 9, 11, 1, 'ACTIVE'), (4, 2, 10, 12, 1, 'ACTIVE'), (4, 2, 11, 12, 1, 'ACTIVE'), (4, 2, 12, 13, 1, 'ACTIVE'), (4, 2, 13, 13, 1, 'ACTIVE'), (4, 2, 14, 9, 1, 'ACTIVE'), (4, 2, 15, 9, 1, 'ACTIVE'), (4, 2, 16, 10, 1, 'ACTIVE'), (4, 2, 17, 10, 1, 'ACTIVE'), (4, 2, 18, 6, 1, 'ACTIVE'), (4, 2, 19, 6, 1, 'ACTIVE'), (4, 2, 20, 7, 1, 'ACTIVE'), (4, 2, 21, 7, 1, 'ACTIVE'), (4, 2, 22, 8, 1, 'ACTIVE'), (4, 2, 23, 8, 1, 'ACTIVE'), (4, 2, 24, 19, 1, 'ACTIVE'), (4, 2, 25, 19, 1, 'ACTIVE'), (4, 2, 26, 18, 1, 'ACTIVE'), (4, 2, 27, 18, 1, 'ACTIVE'), (4, 2, 28, 15, 1, 'ACTIVE'), (4, 2, 29, 15, 1, 'ACTIVE'), (4, 2, 30, 16, 1, 'ACTIVE'), (4, 2, 31, 16, 1, 'ACTIVE'), (4, 2, 32, 17, 1, 'ACTIVE'), (4, 2, 33, 17, 1, 'ACTIVE'), (4, 2, 34, 20, 1, 'ACTIVE'), (4, 2, 35, 20, 1, 'ACTIVE'), (4, 2, 36, 21, 1, 'ACTIVE'), (4, 2, 37, 21, 1, 'ACTIVE'), (4, 2, 38, 22, 1, 'ACTIVE'), (4, 2, 39, 22, 1, 'ACTIVE'), (4, 2, 48, 32, 1, 'ACTIVE'), (4, 2, 49, 28, 1, 'ACTIVE'), (4, 2, 50, 29, 1, 'ACTIVE'), (4, 2, 51, 30, 1, 'ACTIVE'), (4, 2, 52, 31, 1, 'ACTIVE'), (4, 2, 57, 37, 1, 'ACTIVE'), (4, 2, 58, 36, 1, 'ACTIVE'), (4, 2, 59, 33, 1, 'ACTIVE'), (4, 2, 60, 34, 1, 'ACTIVE'), (4, 2, 61, 35, 1, 'ACTIVE'), (4, 3, 1, 4, 1, 'ACTIVE'), (4, 3, 2, 1, 1, 'ACTIVE'), (4, 3, 3, 2, 1, 'ACTIVE'), (4, 3, 4, 3, 1, 'ACTIVE'), (4, 3, 5, 5, 1, 'ACTIVE'), (4, 3, 6, 14, 1, 'ACTIVE'), (4, 3, 7, 14, 1, 'ACTIVE'), (4, 3, 8, 11, 1, 'ACTIVE'), (4, 3, 9, 11, 1, 'ACTIVE'), (4, 3, 10, 12, 1, 'ACTIVE'), (4, 3, 11, 12, 1, 'ACTIVE'), (4, 3, 12, 13, 1, 'ACTIVE'), (4, 3, 13, 13, 1, 'ACTIVE'), (4, 3, 14, 9, 1, 'ACTIVE'), (4, 3, 15, 9, 1, 'ACTIVE'), (4, 3, 16, 10, 1, 'ACTIVE'), (4, 3, 17, 10, 1, 'ACTIVE'), (4, 3, 18, 6, 1, 'ACTIVE'), (4, 3, 19, 6, 1, 'ACTIVE'), (4, 3, 20, 7, 1, 'ACTIVE'), (4, 3, 21, 7, 1, 'ACTIVE'), (4, 3, 22, 8, 1, 'ACTIVE'), (4, 3, 23, 8, 1, 'ACTIVE'), (4, 3, 24, 19, 1, 'ACTIVE'), (4, 3, 25, 19, 1, 'ACTIVE'), (4, 3, 26, 18, 1, 'ACTIVE'), (4, 3, 27, 18, 1, 'ACTIVE'), (4, 3, 28, 15, 1, 'ACTIVE'), (4, 3, 29, 15, 1, 'ACTIVE'), (4, 3, 30, 16, 1, 'ACTIVE'), (4, 3, 31, 16, 1, 'ACTIVE'), (4, 3, 32, 17, 1, 'ACTIVE'), (4, 3, 33, 17, 1, 'ACTIVE'), (4, 3, 34, 20, 1, 'ACTIVE'), (4, 3, 35, 20, 1, 'ACTIVE'), (4, 3, 36, 21, 1, 'ACTIVE'), (4, 3, 37, 21, 1, 'ACTIVE'), (4, 3, 38, 22, 1, 'ACTIVE'), (4, 3, 39, 22, 1, 'ACTIVE'), (4, 3, 48, 32, 1, 'ACTIVE'), (4, 3, 49, 28, 1, 'ACTIVE'), (4, 3, 50, 29, 1, 'ACTIVE'), (4, 3, 51, 30, 1, 'ACTIVE'), (4, 3, 52, 31, 1, 'ACTIVE'), (4, 3, 57, 37, 1, 'ACTIVE'), (4, 3, 58, 36, 1, 'ACTIVE'), (4, 3, 59, 33, 1, 'ACTIVE'), (4, 3, 60, 34, 1, 'ACTIVE'), (4, 3, 61, 35, 1, 'ACTIVE'); -- -- Dumping data for table 'subject_year_grade_criteria' -- INSERT INTO subject_year_grade_criteria (serial_sbj, serial_gct, status_sgc) VALUES (1, 1, 'ACTIVE'), (2, 1, 'ACTIVE'), (3, 1, 'ACTIVE'), (4, 1, 'ACTIVE'), (5, 1, 'ACTIVE'), (6, 1, 'ACTIVE'), (7, 1, 'ACTIVE'), (8, 1, 'ACTIVE'), (9, 1, 'ACTIVE'), (10, 1, 'ACTIVE'), (11, 1, 'ACTIVE'), (12, 1, 'ACTIVE'), (13, 1, 'ACTIVE'), (14, 1, 'ACTIVE'), (15, 1, 'ACTIVE'), (16, 1, 'ACTIVE'), (17, 1, 'ACTIVE'), (18, 1, 'ACTIVE'), (19, 1, 'ACTIVE'), (20, 1, 'ACTIVE'), (21, 1, 'ACTIVE'), (22, 1, 'ACTIVE'), (23, 1, 'ACTIVE'), (24, 1, 'ACTIVE'), (25, 1, 'ACTIVE'), (26, 1, 'ACTIVE'), (27, 1, 'ACTIVE'), (28, 1, 'ACTIVE'), (29, 1, 'ACTIVE'), (30, 1, 'ACTIVE'), (31, 1, 'ACTIVE'), (32, 1, 'ACTIVE'), (33, 1, 'ACTIVE'), (34, 1, 'ACTIVE'), (35, 1, 'ACTIVE'), (36, 1, 'ACTIVE'), (37, 1, 'ACTIVE'), (38, 1, 'ACTIVE'), (39, 1, 'ACTIVE'); -- -- Dumping data for table 'subperiod' -- -- -- Dumping data for table 'syllabus_files' -- -- -- Dumping data for table 'syllabus_files_change_log' -- -- -- Dumping data for table 'taxes' -- INSERT INTO taxes (serial_tax, name_tax, description_tax, status_tax) VALUES (1, 'IVA', 'IVA', 'ACTIVE'), (2, 'Servicios', 'Servicios', 'ACTIVE'); -- -- Dumping data for table 'teacher_degree' -- INSERT INTO teacher_degree (serial_tdg, name_tdg, status_tdg) VALUES (1, 'Licenciado en Ciencias de la Educación', 'ACTIVE'), (2, 'Profesores de segunda enseñanza', 'ACTIVE'), (3, 'Otros Títulos en CCEE con 4 o más años de estudio', 'ACTIVE'), (4, 'Profesores de Primaria(Ins.Pedagógico)', 'ACTIVE'), (5, 'Tecnológico Educativo', 'ACTIVE'), (6, 'Auxiliar Pedagógico', 'ACTIVE'), (7, 'Asistente Pedagógico', 'ACTIVE'), (8, 'Facilitador Pedagógico', 'ACTIVE'), (9, 'Bachiller en Ciencias de la Educación', 'ACTIVE'), (10, 'Normalista rural', 'ACTIVE'), (11, 'Doctorado en ciencias de la educación', 'ACTIVE'); -- -- Dumping data for table 'teacher_hours_year' -- INSERT INTO teacher_hours_year (serial_thy, serial_emp, serial_scy, start_hour_thy, end_hour_thy, status_thy, labor_day_thy) VALUES (1, 1, 1, '07:00:00', '09:00:00', 'ACTIVE', 'MONDAY'), (2, 1, 1, '07:00:00', '09:00:00', 'ACTIVE', 'TUESDAY'), (3, 1, 1, '07:00:00', '09:00:00', 'ACTIVE', 'WEDNESDAY'), (4, 1, 1, '07:00:00', '09:00:00', 'ACTIVE', 'THURSDAY'), (5, 1, 1, '07:00:00', '09:00:00', 'ACTIVE', 'FRIDAY'), (6, 2, 1, '09:00:00', '11:00:00', 'ACTIVE', 'FRIDAY'), (7, 2, 1, '09:00:00', '11:00:00', 'ACTIVE', 'THURSDAY'), (8, 2, 1, '09:00:00', '11:00:00', 'ACTIVE', 'WEDNESDAY'), (9, 2, 1, '09:00:00', '11:00:00', 'ACTIVE', 'TUESDAY'), (10, 2, 1, '09:00:00', '11:00:00', 'ACTIVE', 'MONDAY'), (11, 4, 1, '07:00:00', '11:00:00', 'ACTIVE', 'MONDAY'), (12, 4, 1, '07:00:00', '11:00:00', 'ACTIVE', 'TUESDAY'), (13, 4, 1, '07:00:00', '11:00:00', 'ACTIVE', 'WEDNESDAY'), (14, 4, 1, '07:00:00', '11:00:00', 'ACTIVE', 'THURSDAY'), (15, 4, 1, '07:00:00', '11:00:00', 'ACTIVE', 'FRIDAY'), (16, 5, 1, '07:00:00', '11:00:00', 'ACTIVE', 'MONDAY'), (17, 5, 1, '07:00:00', '11:00:00', 'ACTIVE', 'TUESDAY'), (18, 5, 1, '07:00:00', '11:00:00', 'ACTIVE', 'WEDNESDAY'), (19, 5, 1, '07:00:00', '11:00:00', 'ACTIVE', 'THURSDAY'), (20, 5, 1, '07:00:00', '11:00:00', 'ACTIVE', 'FRIDAY'), (21, 3, 1, '07:00:00', '11:00:00', 'ACTIVE', 'FRIDAY'), (22, 3, 1, '07:00:00', '11:00:00', 'ACTIVE', 'THURSDAY'), (23, 3, 1, '07:00:00', '11:00:00', 'ACTIVE', 'WEDNESDAY'), (24, 3, 1, '07:00:00', '11:00:00', 'ACTIVE', 'TUESDAY'), (25, 3, 1, '07:00:00', '11:00:00', 'ACTIVE', 'MONDAY'), (26, 6, 1, '07:00:00', '11:00:00', 'ACTIVE', 'MONDAY'), (27, 6, 1, '07:00:00', '11:00:00', 'ACTIVE', 'TUESDAY'), (28, 6, 1, '07:00:00', '11:00:00', 'ACTIVE', 'WEDNESDAY'), (29, 6, 1, '07:00:00', '11:00:00', 'ACTIVE', 'THURSDAY'), (30, 6, 1, '07:00:00', '11:00:00', 'ACTIVE', 'FRIDAY'), (31, 8, 1, '07:00:00', '11:00:00', 'ACTIVE', 'MONDAY'), (32, 8, 1, '07:00:00', '11:00:00', 'ACTIVE', 'TUESDAY'), (33, 8, 1, '07:00:00', '11:00:00', 'ACTIVE', 'WEDNESDAY'), (34, 8, 1, '07:00:00', '11:00:00', 'ACTIVE', 'THURSDAY'), (35, 8, 1, '07:00:00', '11:00:00', 'ACTIVE', 'FRIDAY'), (36, 9, 1, '07:00:00', '11:00:00', 'ACTIVE', 'FRIDAY'), (37, 9, 1, '07:00:00', '11:00:00', 'ACTIVE', 'THURSDAY'), (38, 9, 1, '07:00:00', '11:00:00', 'ACTIVE', 'WEDNESDAY'), (39, 9, 1, '07:00:00', '11:00:00', 'ACTIVE', 'TUESDAY'), (40, 9, 1, '07:00:00', '11:00:00', 'ACTIVE', 'MONDAY'), (41, 11, 1, '07:00:00', '11:00:00', 'ACTIVE', 'MONDAY'), (42, 11, 1, '07:00:00', '11:00:00', 'ACTIVE', 'TUESDAY'), (43, 11, 1, '07:00:00', '11:00:00', 'ACTIVE', 'WEDNESDAY'), (44, 11, 1, '07:00:00', '11:00:00', 'ACTIVE', 'THURSDAY'), (45, 11, 1, '07:00:00', '11:00:00', 'ACTIVE', 'FRIDAY'), (46, 7, 1, '07:00:00', '11:00:00', 'ACTIVE', 'FRIDAY'), (47, 7, 1, '07:00:00', '11:00:00', 'ACTIVE', 'THURSDAY'), (48, 7, 1, '07:00:00', '11:00:00', 'ACTIVE', 'WEDNESDAY'), (49, 7, 1, '07:00:00', '11:00:00', 'ACTIVE', 'TUESDAY'), (50, 7, 1, '07:00:00', '11:00:00', 'ACTIVE', 'MONDAY'), (51, 10, 1, '07:00:00', '11:00:00', 'ACTIVE', 'MONDAY'), (52, 10, 1, '07:00:00', '11:00:00', 'ACTIVE', 'TUESDAY'), (53, 10, 1, '07:00:00', '11:00:00', 'ACTIVE', 'WEDNESDAY'), (54, 10, 1, '07:00:00', '11:00:00', 'ACTIVE', 'THURSDAY'), (55, 10, 1, '07:00:00', '11:00:00', 'ACTIVE', 'FRIDAY'); -- -- Dumping data for table 'teacher_master_degree' -- INSERT INTO teacher_master_degree (serial_tmd, name_tmd, status_tmd) VALUES (1, 'Máster y/o Phd en ciencias de la educación', 'ACTIVE'); -- -- Dumping data for table 'teacher_specialty' -- INSERT INTO teacher_specialty (serial_tst, name_tst, status_tst) VALUES (1, 'Administración educativa', 'ACTIVE'), (2, 'Artes aplicadas', 'ACTIVE'), (3, 'Auxiliar de laboratorio de ciencias naturales y Biología', 'ACTIVE'), (4, 'Ciencias exactas', 'ACTIVE'), (5, 'Ciencias sociales', 'ACTIVE'), (6, 'Comercio ya dministración', 'ACTIVE'), (7, 'Comunicación educativa', 'ACTIVE'), (8, 'Contabilidad y administración', 'ACTIVE'), (9, 'Diseño y dibujo', 'ACTIVE'), (10, 'Docencia y desarrollo comunitario', 'ACTIVE'), (11, 'Docencia y gestión en educación básica', 'ACTIVE'), (12, 'Ecoturismo', 'ACTIVE'), (13, 'Educación artística', 'ACTIVE'), (14, 'Educación primaria', 'ACTIVE'), (15, 'Educación especial', 'ACTIVE'), (16, 'Educación inicial', 'ACTIVE'), (17, 'Educación parvularia', 'ACTIVE'), (18, 'Educación superior', 'ACTIVE'), (19, 'Electricidad', 'ACTIVE'), (20, 'Filosofía y pedagogía', 'ACTIVE'), (21, 'Físico matemáticas', 'ACTIVE'), (22, 'Gerencia educativa', 'ACTIVE'), (23, 'Idiomas', 'ACTIVE'), (24, 'Informática', 'ACTIVE'), (25, 'Informática y programación', 'ACTIVE'), (26, 'Inglés y plurilingue', 'ACTIVE'), (27, 'Laboratorio de ciencias naturales', 'ACTIVE'), (28, 'Liderazgo educativo', 'ACTIVE'), (29, 'Literatura y castellano', 'ACTIVE'), (30, 'Mecánica industrial', 'ACTIVE'), (31, 'Monitor de actividad física', 'ACTIVE'), (32, 'Pedagogía y gerencia educativa', 'ACTIVE'), (33, 'Promoción y educación para la salud', 'ACTIVE'), (34, 'Psicología educativa y orientación vocacional', 'ACTIVE'), (35, 'Psicología infantil', 'ACTIVE'), (36, 'Psicopedagogía infantil', 'ACTIVE'), (37, 'Químico biológicas', 'ACTIVE'), (38, 'Supervisión y administración educativa', 'ACTIVE'), (39, 'Turismo histórico y cultural', 'ACTIVE'), (40, 'Administación', 'ACTIVE'), (41, 'Informática', 'ACTIVE'), (42, 'Comunicación', 'ACTIVE'), (43, 'Agronomía', 'ACTIVE'), (44, 'Medicina', 'ACTIVE'), (45, 'Civil/arquitectura', 'ACTIVE'), (46, 'Teología', 'ACTIVE'), (47, 'Administración y supervisión educativa', 'ACTIVE'), (48, 'Asignaturas secretariales', 'ACTIVE'), (49, 'Bellas artes', 'ACTIVE'), (50, 'Ciencias naturales', 'ACTIVE'), (51, 'Ciencias socioeconómicas y políticas', 'ACTIVE'), (52, 'Computación', 'ACTIVE'), (53, 'Contabilidad', 'ACTIVE'), (54, 'Cultura fisica', 'ACTIVE'), (55, 'Docencia primaria', 'ACTIVE'), (56, 'Docencia y gestión en bachillerato', 'ACTIVE'), (57, 'Docencia y gestión en educación parvularia', 'ACTIVE'), (58, 'Educación ambiental', 'ACTIVE'), (59, 'Educación básica', 'ACTIVE'), (60, 'Educación de adultos', 'ACTIVE'), (61, 'Educación física,deportes y recreación', 'ACTIVE'), (62, 'Educación intercultural bilingüe', 'ACTIVE'), (63, 'Educación preescolar', 'ACTIVE'), (64, 'Educación y estudios interculturales', 'ACTIVE'), (65, 'Filosofía y ciencias psicosociales', 'ACTIVE'), (66, 'Filosofía,sociología y economía', 'ACTIVE'), (67, 'Geografía y ecología', 'ACTIVE'), (68, 'Historia y geografía', 'ACTIVE'), (69, 'Idiomas y lingüística', 'ACTIVE'), (70, 'Informática educativa', 'ACTIVE'), (71, 'Inglés', 'ACTIVE'), (72, 'Investigación y planificación educativa', 'ACTIVE'), (73, 'Lengua y literatura', 'ACTIVE'), (74, 'Lingüística(inglés-francés,inglés-italiano,inglés-alemán)', 'ACTIVE'), (75, 'Mecánica automotriz', 'ACTIVE'), (76, 'Mercadotecnia y publicidad', 'ACTIVE'), (77, 'Opciones prácticas', 'ACTIVE'), (78, 'Planificación y diseño curricular', 'ACTIVE'), (79, 'Psicología del adolescente y orientación', 'ACTIVE'), (80, 'Psicología gerontológico', 'ACTIVE'), (81, 'Psicología y pedagogía', 'ACTIVE'), (82, 'Psicorehabilitación y educación especial', 'ACTIVE'), (83, 'Secretariado en español', 'ACTIVE'), (84, 'Teatro y arte dramatico', 'ACTIVE'), (85, 'Otras especializaciones de títulos docentes', 'ACTIVE'), (86, 'Economía', 'ACTIVE'), (87, 'Derecho', 'ACTIVE'), (88, 'Medicina veterinaria', 'ACTIVE'), (89, 'Geología', 'ACTIVE'), (90, 'Antropología', 'ACTIVE'), (91, 'Otras ingenierías', 'ACTIVE'), (92, 'Artes', 'ACTIVE'); -- -- Dumping data for table 'university' -- INSERT INTO university (serial_unv, name_unv, status_unv) VALUES (1, 'Escuela Politécnica del Ejército', 'ACTIVE'), (2, 'Escuela Politécnica Nacional', 'ACTIVE'), (3, 'Universidad Central del Ecuador', 'ACTIVE'), (4, 'Universidad Tecnológica Equinoccial', 'ACTIVE'), (5, 'Escuela Politécnica Javeriana', 'ACTIVE'), (6, 'Universidad Autónoma de Quito', 'ACTIVE'), (7, 'Universidad Del Pacífico', 'ACTIVE'), (8, 'Universidad Tecnológica America', 'ACTIVE'), (9, 'Universidad Tecnológica Israel', 'ACTIVE'), (10, 'Universidad De Especialidades Turisticas', 'ACTIVE'), (11, 'Universidad de las Americas', 'ACTIVE'), (12, 'Universidad Internacional del Ecuador', 'ACTIVE'), (13, 'Universidad Internacional SEK', 'ACTIVE'), (14, 'Universidad San Francisco de Quito', 'ACTIVE'), (15, 'Universidad Politécnica Salesiana', 'ACTIVE'), (16, 'Pontificia Universidad Catolica del Ecuador', 'ACTIVE'), (17, 'Universidad Tecnológica Indoamérica', 'ACTIVE'), (18, 'Otra', 'ACTIVE'); -- -- Dumping data for table 'user' -- INSERT INTO user (serial_usr, serial_emp, serial_grd, serial_std, username_usr, password_usr, photo_usr, status_usr) VALUES (1, NULL, NULL, NULL, 'admin', 'e10adc3949ba59abbe56e057f20f883e', NULL, 'ACTIVE'), (2, 1, NULL, NULL, 'adhitler', NULL, '083d30.jpg', 'ACTIVE'), (3, 2, NULL, NULL, 'prjirafa', NULL, NULL, 'ACTIVE'), (4, 3, NULL, NULL, 'edkrabap', NULL, NULL, 'ACTIVE'), (5, 4, NULL, NULL, 'diskinne', NULL, NULL, 'ACTIVE'), (6, 5, NULL, NULL, 'mayoda', NULL, NULL, 'ACTIVE'), (7, 6, NULL, NULL, 'alborreg', NULL, NULL, 'ACTIVE'), (8, NULL, NULL, NULL, 'macalder', NULL, NULL, 'ACTIVE'), (9, NULL, 1, NULL, 'macalder1', NULL, NULL, 'ACTIVE'), (10, NULL, 2, NULL, 'paoso', NULL, NULL, 'ACTIVE'), (11, NULL, 3, NULL, 'maoglio', NULL, NULL, 'ACTIVE'), (12, 7, NULL, NULL, 'jumatema', NULL, NULL, 'ACTIVE'), (13, 8, NULL, NULL, 'pemanual', NULL, NULL, 'ACTIVE'), (14, 9, NULL, NULL, 'judibujo', NULL, NULL, 'ACTIVE'), (15, 10, NULL, NULL, 'malengua', NULL, NULL, 'ACTIVE'), (16, 11, NULL, NULL, 'laingles', NULL, NULL, 'ACTIVE'), (17, 12, NULL, NULL, 'maoptati', NULL, NULL, 'ACTIVE'); -- -- Dumping data for table 'user_course_comment_setup' -- -- -- Dumping data for table 'user_profile' -- INSERT INTO user_profile (serial_usr, serial_prf, status_upr) VALUES (1, 1, 'ACTIVE'), (2, 4, 'ACTIVE'), (3, 4, 'ACTIVE'), (4, 4, 'ACTIVE'), (5, 4, 'ACTIVE'), (6, 4, 'ACTIVE'), (7, 4, 'ACTIVE'), (9, 2, 'ACTIVE'), (10, 2, 'ACTIVE'), (11, 2, 'ACTIVE'), (12, 4, 'ACTIVE'), (13, 4, 'ACTIVE'), (14, 4, 'ACTIVE'), (15, 4, 'ACTIVE'), (16, 4, 'ACTIVE'), (17, 4, 'ACTIVE'); -- -- Dumping data for table 'use_destination' -- -- -- Dumping data for table 'view_activity_grades' -- -- -- Dumping data for table 'view_opt_activity_grades' -- -- -- Dumping data for table 'visits_medical_center' -- -- -- Dumping data for table 'web_pre_registration' -- -- -- Dumping data for table 'web_user' -- -- -- Dumping data for table 'year_concept_taxes' -- -- -- Dumping data for table 'year_discount' -- INSERT INTO year_discount (serial_ydc, serial_dsc, serial_scy, type_ydc, value_ydc, days_before_limit_ydc, status_ydc) VALUES (1, 16, 1, 'FIXED', '50.00', NULL, 'ACTIVE'), (2, 18, 1, 'PERCENTAGE', '40.00', NULL, 'ACTIVE'); -- -- Dumping data for table 'year_grade_subject' -- -- -- Dumping data for table 'year_level_specialty_payment_concept' -- INSERT INTO year_level_specialty_payment_concept (serial_ypc, serial_art, serial_pct, serial_spt, serial_lvl, serial_scy, serial_set, value_ypc, frequency_ypc, repetitions_number_ypc, enabling_concept_ypc, mandatory_ypc, student_type_ypc, type_ypc, status_ypc) VALUES (1, NULL, 1, 1, 7, 1, 3, '200.00', 'MONTHLY', 9, 'YES', 'YES', 'BOTH', 'ACADEMIC', 'ACTIVE'), (2, NULL, 2, 1, 7, 1, 3, '300.00', 'ANNUAL', 1, 'YES', 'YES', 'BOTH', 'ACADEMIC', 'ACTIVE'), (3, NULL, 1, 1, 1, 1, 1, '200.00', 'MONTHLY', 9, 'YES', 'YES', 'BOTH', 'ACADEMIC', 'ACTIVE'), (4, NULL, 1, 1, 2, 1, 1, '200.00', 'MONTHLY', 9, 'YES', 'YES', 'BOTH', 'ACADEMIC', 'ACTIVE'), (5, NULL, 1, 1, 3, 1, 1, '200.00', 'MONTHLY', 9, 'YES', 'YES', 'BOTH', 'ACADEMIC', 'ACTIVE'), (6, NULL, 1, 1, 4, 1, 2, '200.00', 'MONTHLY', 9, 'YES', 'YES', 'BOTH', 'ACADEMIC', 'ACTIVE'), (7, NULL, 1, 2, 5, 1, 2, '200.00', 'MONTHLY', 9, 'YES', 'YES', 'BOTH', 'ACADEMIC', 'ACTIVE'), (8, NULL, 1, 2, 6, 1, 2, '200.00', 'MONTHLY', 9, 'YES', 'YES', 'BOTH', 'ACADEMIC', 'ACTIVE'), (9, NULL, 1, 3, 5, 1, 2, '200.00', 'MONTHLY', 9, 'YES', 'YES', 'BOTH', 'ACADEMIC', 'ACTIVE'), (10, NULL, 1, 3, 6, 1, 2, '200.00', 'MONTHLY', 9, 'YES', 'YES', 'BOTH', 'ACADEMIC', 'ACTIVE'), (11, NULL, 2, 1, 1, 1, 1, '300.00', 'ANNUAL', 1, 'YES', 'YES', 'BOTH', 'ACADEMIC', 'ACTIVE'), (12, NULL, 2, 1, 2, 1, 1, '300.00', 'ANNUAL', 1, 'YES', 'YES', 'BOTH', 'ACADEMIC', 'ACTIVE'), (13, NULL, 2, 1, 3, 1, 1, '300.00', 'ANNUAL', 1, 'YES', 'YES', 'BOTH', 'ACADEMIC', 'ACTIVE'), (14, NULL, 2, 1, 4, 1, 2, '300.00', 'ANNUAL', 1, 'YES', 'YES', 'BOTH', 'ACADEMIC', 'ACTIVE'), (15, NULL, 2, 2, 5, 1, 2, '300.00', 'ANNUAL', 1, 'YES', 'YES', 'BOTH', 'ACADEMIC', 'ACTIVE'), (16, NULL, 2, 2, 6, 1, 2, '300.00', 'ANNUAL', 1, 'YES', 'YES', 'BOTH', 'ACADEMIC', 'ACTIVE'), (17, NULL, 2, 3, 5, 1, 2, '300.00', 'ANNUAL', 1, 'YES', 'YES', 'BOTH', 'ACADEMIC', 'ACTIVE'), (18, NULL, 2, 3, 6, 1, 2, '300.00', 'ANNUAL', 1, 'YES', 'YES', 'BOTH', 'ACADEMIC', 'ACTIVE'), (19, NULL, 8, 1, 1, 1, 1, '50.00', 'MONTHLY', 9, 'YES', 'YES', 'BOTH', 'NON_ACADEMIC', 'ACTIVE'), (20, NULL, 8, 1, 2, 1, 1, '50.00', 'MONTHLY', 9, 'YES', 'YES', 'BOTH', 'NON_ACADEMIC', 'ACTIVE'), (21, NULL, 8, 1, 3, 1, 1, '50.00', 'MONTHLY', 9, 'YES', 'YES', 'BOTH', 'NON_ACADEMIC', 'ACTIVE'), (22, NULL, 8, 1, 4, 1, 2, '50.00', 'MONTHLY', 9, 'YES', 'YES', 'BOTH', 'NON_ACADEMIC', 'ACTIVE'), (23, NULL, 8, 1, 7, 1, 3, '50.00', 'MONTHLY', 9, 'YES', 'YES', 'BOTH', 'NON_ACADEMIC', 'ACTIVE'), (24, NULL, 8, 2, 5, 1, 2, '50.00', 'MONTHLY', 9, 'YES', 'YES', 'BOTH', 'NON_ACADEMIC', 'ACTIVE'), (25, NULL, 8, 2, 6, 1, 2, '50.00', 'MONTHLY', 9, 'YES', 'YES', 'BOTH', 'NON_ACADEMIC', 'ACTIVE'), (26, NULL, 8, 3, 5, 1, 2, '50.00', 'MONTHLY', 9, 'YES', 'YES', 'BOTH', 'NON_ACADEMIC', 'ACTIVE'), (27, NULL, 8, 3, 6, 1, 2, '50.00', 'MONTHLY', 9, 'YES', 'YES', 'BOTH', 'NON_ACADEMIC', 'ACTIVE'), (28, NULL, 4, 1, 1, 1, 1, '80.00', 'MONTHLY', 9, 'NO', 'NO', 'BOTH', 'ACADEMIC', 'ACTIVE'), (29, NULL, 4, 1, 2, 1, 1, '80.00', 'MONTHLY', 9, 'NO', 'NO', 'BOTH', 'ACADEMIC', 'ACTIVE'), (30, NULL, 4, 1, 3, 1, 1, '80.00', 'MONTHLY', 9, 'NO', 'NO', 'BOTH', 'ACADEMIC', 'ACTIVE'), (31, NULL, 4, 1, 4, 1, 2, '80.00', 'MONTHLY', 9, 'NO', 'NO', 'BOTH', 'ACADEMIC', 'ACTIVE'), (32, NULL, 4, 1, 7, 1, 3, '80.00', 'MONTHLY', 9, 'NO', 'NO', 'BOTH', 'ACADEMIC', 'ACTIVE'), (33, NULL, 4, 2, 5, 1, 2, '80.00', 'MONTHLY', 9, 'NO', 'NO', 'BOTH', 'ACADEMIC', 'ACTIVE'), (34, NULL, 4, 2, 6, 1, 2, '80.00', 'MONTHLY', 9, 'NO', 'NO', 'BOTH', 'ACADEMIC', 'ACTIVE'), (35, NULL, 4, 3, 5, 1, 2, '80.00', 'MONTHLY', 9, 'NO', 'NO', 'BOTH', 'ACADEMIC', 'ACTIVE'), (36, NULL, 4, 3, 6, 1, 2, '80.00', 'MONTHLY', 9, 'NO', 'NO', 'BOTH', 'ACADEMIC', 'ACTIVE'), (37, NULL, 3, 1, 1, 1, 1, '100.00', 'MONTHLY', 9, 'NO', 'NO', 'BOTH', 'NON_ACADEMIC', 'ACTIVE'), (38, NULL, 3, 1, 2, 1, 1, '100.00', 'MONTHLY', 9, 'NO', 'NO', 'BOTH', 'NON_ACADEMIC', 'ACTIVE'), (39, NULL, 3, 1, 3, 1, 1, '100.00', 'MONTHLY', 9, 'NO', 'NO', 'BOTH', 'NON_ACADEMIC', 'ACTIVE'), (40, NULL, 3, 1, 4, 1, 2, '100.00', 'MONTHLY', 9, 'NO', 'NO', 'BOTH', 'NON_ACADEMIC', 'ACTIVE'), (41, NULL, 3, 1, 7, 1, 3, '100.00', 'MONTHLY', 9, 'NO', 'NO', 'BOTH', 'NON_ACADEMIC', 'ACTIVE'), (42, NULL, 3, 2, 5, 1, 2, '100.00', 'MONTHLY', 9, 'NO', 'NO', 'BOTH', 'NON_ACADEMIC', 'ACTIVE'), (43, NULL, 3, 2, 6, 1, 2, '100.00', 'MONTHLY', 9, 'NO', 'NO', 'BOTH', 'NON_ACADEMIC', 'ACTIVE'), (44, NULL, 3, 3, 5, 1, 2, '100.00', 'MONTHLY', 9, 'NO', 'NO', 'BOTH', 'NON_ACADEMIC', 'ACTIVE'), (45, NULL, 3, 3, 6, 1, 2, '100.00', 'MONTHLY', 9, 'NO', 'NO', 'BOTH', 'NON_ACADEMIC', 'ACTIVE'); -- -- Dumping data for table 'year_period_exam_setup' -- -- -- Dumping data for table 'year_pre_registration_document' -- -- -- Dumping data for table 'year_qualifying_document' -- -- -- Dumping data for table 'year_report_comment' -- -- -- Dumping data for table 'year_resit_exam_ranges' -- -- -- Dumping data for table 'year_special_grade' -- -- -- Dumping data for table 'year_subject_classroom' -- -- -- Dumping data for table 'year_subject_skills' -- SET FOREIGN_KEY_CHECKS =1;