Bart12Script.sql

--
-- File generated with SQLiteStudio v3.2.1 on Tue Oct 20 22:45:25 2020
--
-- Text encoding used: System
--
PRAGMA foreign_keys = off;
BEGIN TRANSACTION;

-- Table: Assets
CREATE TABLE Assets (a_projectid CHAR NOT NULL, a_dept CHAR NOT NULL, a_metername CHAR NOT NULL, a_meterdesc CHAR NOT NULL, a_meterreading BOOLEAN NOT NULL, a_readdate DATE NOT NULL, a_meterunits CHAR NOT NULL, a_goal BOOLEAN NOT NULL, a_goalgroup CHAR NOT NULL);
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'STRUCTR CONS', 'A1 DRAIN', 'DAY: Track A1 (MP 11.83 to 13.74)', 405, '1-Aug-20', 'Feet', 10560, 'A1 DRAIN,A1 DRAIN 2');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'STRUCTR CONS', 'A1 DRAIN 2', 'GRAVE: Track A1 (MP 11.83 to 13.74)', 2600, '24-Aug-20', 'Feet', 10560, 'A1 DRAIN,A1 DRAIN 2');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'STRUCTR CONS', 'A1 DRAIN 2', 'GRAVE: Track A1 (MP 11.83 to 13.74)', 7000, '24-Aug-20', 'Feet', 10560, 'A1 DRAIN,A1 DRAIN 2');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'STRUCTR CONS', 'A1 EDGE 2', 'GRAVE: A1 Edge Tile Replacement', 320, '22-Aug-20', 'Feet', 700, 'A1 EDGE TR,A1 EDGE 2');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'STRUCTR CONS', 'A1 EDGE 2', 'GRAVE: A1 Edge Tile Replacement', 350, '22-Aug-20', 'Feet', 700, 'A1 EDGE TR,A1 EDGE 2');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'STRUCTR CONS', 'A1 EDGE 2', 'GRAVE: A1 Edge Tile Replacement', 330, '23-Aug-20', 'Feet', 700, 'A1 EDGE TR,A1 EDGE 2');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'STRUCTR CONS', 'A1 EDGE 2', 'GRAVE: A1 Edge Tile Replacement', 28, '5-Sep-20', 'Feet', 700, 'A1 EDGE TR,A1 EDGE 2');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'STRUCTR CONS', 'A1 EDGE 2', 'GRAVE: A1 Edge Tile Replacement', 64, '6-Sep-20', 'Feet', 700, 'A1 EDGE TR,A1 EDGE 2');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'STRUCTR CONS', 'A1 EDGE 2', 'GRAVE: A1 Edge Tile Replacement', 34, '6-Sep-20', 'Feet', 700, 'A1 EDGE TR,A1 EDGE 2');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'STRUCTR CONS', 'A1 EDGE 2', 'GRAVE: A1 Edge Tile Replacement', 34, '6-Sep-20', 'Feet', 700, 'A1 EDGE TR,A1 EDGE 2');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'STRUCTR CONS', 'A1 EDGE TR', 'DAY: A1 Edge Tile Replacement', 380, '3-Aug-20', 'Feet', 700, 'A1 EDGE TR,A1 EDGE 2');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'TRACK', 'A1PAD(D)3', 'DF PADS (DAY) ON A1 TRACK WEEKEND#3 MP 11.83 - 12.83', 80, '6-Sep-20', '# of pads', 1200, 'A1PAD(D)3,A1PAD(G)3');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'TRACK', 'A1PAD(D)3', 'DF PADS (DAY) ON A1 TRACK WEEKEND#3 MP 11.83 - 12.83', 20, '7-Sep-20', '# of pads', 1200, 'A1PAD(D)3,A1PAD(G)3');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'TRACK', 'A1PAD(D)3', 'DF PADS (DAY) ON A1 TRACK WEEKEND#3 MP 11.83 - 12.83', 80, '7-Sep-20', '# of pads', 1200, 'A1PAD(D)3,A1PAD(G)3');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'TRACK', 'A1PAD(D)3', 'DF PADS (DAY) ON A1 TRACK WEEKEND#3 MP 11.83 - 12.83', 100, '7-Sep-20', '# of pads', 1200, 'A1PAD(D)3,A1PAD(G)3');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'TRACK', 'A1PAD(GRV)', 'DF PADS ON A1 TRACK WEEKEND#1  MP 12.83 - 13.74', 901, '2-Aug-20', '# of pads', 800, 'A1PAD(GRV)');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'STRUCTR CONS', 'A2 EDGE 2', 'GRAVE: A2 Edge Tile Replacement', 700, '5-Sep-20', 'Feet', 700, 'A2 EDGE TR,A2 EDGE 2');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'STRUCTR CONS', 'A2 EDGE 2', 'GRAVE: A2 Edge Tile Replacement', 700, '8-Sep-20', 'Feet', 700, 'A2 EDGE TR,A2 EDGE 2');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'TRACK', 'A2 PAD-DAY', 'DF PADS (DAY) ON A2 TRACK WEEKEND# 2', 400, '22-Aug-20', '# of pads', 400, 'A2 PAD-DAY,A2PAD(GRV)');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'TRACK', 'A2 PAD-DAY', 'DF PADS (DAY) ON A2 TRACK WEEKEND# 2', 225, '23-Aug-20', '# of pads', 400, 'A2 PAD-DAY,A2PAD(GRV)');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'TRACK', 'A2 PAD-DAY', 'DF PADS (DAY) ON A2 TRACK WEEKEND# 2', 625, '23-Aug-20', '# of pads', 400, 'A2 PAD-DAY,A2PAD(GRV)');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'TRACK', 'A2PAD(GRV)', 'DF PADS (GRAVE) ON A2 TRACK MP WEEKEND#2', 175, '22-Aug-20', '# of pads', 400, 'A2 PAD-DAY,A2PAD(GRV)');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'TC', 'A60 TXRX 1', 'A60 TX RX Grave Shift MP 11.9 to 15.3: A65 Weekend 1', 6, '1-Aug-20', '# of loops and coils', 5, 'A60 TXRX 1');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'TC', 'A60 TXRX 2', 'A60 TX RX Grave Shift MP 11.9 to 15.3: A65 Weekend 2', 5, '24-Aug-20', '# of loops and coils', 5, 'A60 TXRX 2');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'TC', 'A60 TXRX 3', 'A60 TX RX Grave Shift  MP 11.9 to 15.3: A65 Weekend 3', 7, '8-Sep-20', '# of loops and coils', 5, 'A60 TXRX 3');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'BUILDINGS', 'DT INSTALL', 'Directional tile install', 20, '23-Aug-20', '# of directional tiles', 8, 'DT INSTALL');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'POWER', 'LIGHT-PKL', 'Day Shift: A60 Parking Lot Lighting  Replacement project', 10, '19-Aug-20', '# of lights', 80, 'LIGHT-PKL,LIGHT-PKL2,LIGHT-PKL3');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'POWER', 'LIGHT-PKL', 'Day Shift: A60 Parking Lot Lighting  Replacement project', 8, '22-Aug-20', '# of lights', 80, 'LIGHT-PKL,LIGHT-PKL2,LIGHT-PKL3');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'POWER', 'LIGHT-PKL', 'Day Shift: A60 Parking Lot Lighting  Replacement project', 18, '22-Aug-20', '# of lights', 80, 'LIGHT-PKL,LIGHT-PKL2,LIGHT-PKL3');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'POWER', 'LIGHT-PKL', 'Day Shift: A60 Parking Lot Lighting  Replacement project', 3, '22-Aug-20', '# of lights', 80, 'LIGHT-PKL,LIGHT-PKL2,LIGHT-PKL3');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'POWER', 'LIGHT-PKL', 'Day Shift: A60 Parking Lot Lighting  Replacement project', 5, '22-Aug-20', '# of lights', 80, 'LIGHT-PKL,LIGHT-PKL2,LIGHT-PKL3');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'POWER', 'LIGHT-PKL', 'Day Shift: A60 Parking Lot Lighting  Replacement project', 2, '24-Aug-20', '# of lights', 80, 'LIGHT-PKL,LIGHT-PKL2,LIGHT-PKL3');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'POWER', 'LIGHT-PKL', 'Day Shift: A60 Parking Lot Lighting  Replacement project', 1, '6-Sep-20', '# of lights', 80, 'LIGHT-PKL,LIGHT-PKL2,LIGHT-PKL3');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'POWER', 'LIGHT-PKL3', 'Grave Shift: A60 Parking Lot Lighting  Replacement project', 9, '23-Aug-20', '# of lights', 80, 'LIGHT-PKL,LIGHT-PKL2,LIGHT-PKL3');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'POWER', 'LIGHT-PLA2', 'Swing Shift: A60 Concourse, Platform Level Lighting Replacement Project', 20, '22-Aug-20', '# of lights', 800, 'LIGHT-PLAT,LIGHT-PLA2,LIGHT-PLA3');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'POWER', 'LIGHT-PLA3', 'Swing Shift: A60 Concourse, Platform Level Lighting Replacement Project', 14, '5-Sep-20', '# of lights', 800, 'LIGHT-PLAT,LIGHT-PLA2,LIGHT-PLA3');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'POWER', 'LIGHT-PLA4', 'Swing Shift: A60 Concourse, Platform Level Lighting Replacement Project', 38, '7-Sep-20', '# of lights', 800, 'LIGHT-PLAT,LIGHT-PLA2,LIGHT-PLA3');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'POWER', 'LIGHT-PLA5', 'Swing Shift: A60 Concourse, Platform Level Lighting Replacement Project', 30, '8-Sep-20', '# of lights', 800, 'LIGHT-PLAT,LIGHT-PLA2,LIGHT-PLA3');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'POWER', 'LIGHT-PLA3', 'Grave Shift: A60 Concourse, Platform Level Lighting Replacement Project', 22, '23-Aug-20', '# of lights', 800, 'LIGHT-PLAT,LIGHT-PLA2,LIGHT-PLA3');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'POWER', 'LIGHT-PLAT', 'Day Shift: A60 Concourse, Platform Level Lighting Replacement Project', 16, '19-Aug-20', '# of lights', 800, 'LIGHT-PLAT,LIGHT-PLA2,LIGHT-PLA3');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'POWER', 'LIGHT-PLAT', 'Day Shift: A60 Concourse, Platform Level Lighting Replacement Project', 70, '22-Aug-20', '# of lights', 800, 'LIGHT-PLAT,LIGHT-PLA2,LIGHT-PLA3');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'POWER', 'LIGHT-PLAT', 'Day Shift: A60 Concourse, Platform Level Lighting Replacement Project', 64, '5-Sep-20', '# of lights', 800, 'LIGHT-PLAT,LIGHT-PLA2,LIGHT-PLA3');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'POWER', 'LIGHT-PLAT', 'Day Shift: A60 Concourse, Platform Level Lighting Replacement Project', 76, '5-Sep-20', '# of lights', 800, 'LIGHT-PLAT,LIGHT-PLA2,LIGHT-PLA3');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'POWER', 'LIGHT-PLAT', 'Day Shift: A60 Concourse, Platform Level Lighting Replacement Project', 24, '5-Sep-20', '# of lights', 800, 'LIGHT-PLAT,LIGHT-PLA2,LIGHT-PLA3');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'POWER', 'LIGHT-PLAT', 'Day Shift: A60 Concourse, Platform Level Lighting Replacement Project', 40, '7-Sep-20', '# of lights', 800, 'LIGHT-PLAT,LIGHT-PLA2,LIGHT-PLA3');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'POWER', 'LIGHT-PLAT', 'Day Shift: A60 Concourse, Platform Level Lighting Replacement Project', 22, '8-Sep-20', '# of lights', 800, 'LIGHT-PLAT,LIGHT-PLA2,LIGHT-PLA3');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'TP CONS', 'T1-T-RAIL', 'A-Line Third Rail Replacement Project on Track 1', 960, '23-Aug-20', 'Feet', 1250, 'T1-T-RAIL');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'TP CONS', 'T1-T-RAIL', 'A-Line Third Rail Replacement Project on Track 1', 930, '23-Aug-20', 'Feet', 1250, 'T1-T-RAIL');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'TP CONS', 'T1-T-RAIL', 'A-Line Third Rail Replacement Project on Track 1', 960, '23-Aug-20', 'Feet', 1250, 'T1-T-RAIL');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'TP CONS', 'T2-T-RAIL', 'A-Line Third Rail Replacement Project on Track 2', 900, '2-Aug-20', 'Feet', 1250, 'T2-T-RAIL');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'TP CONS', 'T2-T-RAIL', 'A-Line Third Rail Replacement Project on Track 2', 900, '5-Sep-20', 'Feet', 1250, 'T2-T-RAIL');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'TP CONS', 'T2-T-RAIL', 'A-Line Third Rail Replacement Project on Track 2', 930, '6-Sep-20', 'Feet', 1250, 'T2-T-RAIL');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'TP CONS', 'T2-T-RAIL', 'A-Line Third Rail Replacement Project on Track 2', 930, '6-Sep-20', 'Feet', 1250, 'T2-T-RAIL');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('A65', 'TP CONS', 'T2-T-RAIL', 'A-Line Third Rail Replacement Project on Track 2', 540, '7-Sep-20', 'Feet', 1250, 'T2-T-RAIL');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('C25', 'POWER', 'BHT-C1 L', 'BHT C1 Lighting Replacement (Goal = 338 Lights))', 134, '3-Jun-20', '# of lights', 338, 'BHT C1 L,BHT C2 L');
INSERT INTO Assets (a_projectid, a_dept, a_metername, a_meterdesc, a_meterreading, a_readdate, a_meterunits, a_goal, a_goalgroup) VALUES ('C25', 'POWER', 'BHT-C2 L', 'BHT C2 Lighting Replacement (Goal = 338 Lights))', 40, '4-Jun-20', '# of lights', 338, 'BHT C1 L,BHT C2 L');


-- Table: Workorder
CREATE TABLE Workorder (w_projectid BOOLEAN NOT NULL, w_WOnum BOOLEAN NOT NULL, w_desc CHAR NOT NULL, w_status CHAR NOT NULL, w_reporteddate BOOLEAN NOT NULL, w_location CHAR NOT NULL, w_type CHAR NOT NULL, w_TPID BOOLEAN NOT NULL, w_PSProject CHAR NOT NULL, w_PSProjDesc CHAR NOT NULL, w_PSActivity CHAR NOT NULL, w_PSActDesc CHAR NOT NULL);
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17112036, 'A1 Aerial Pier Drainage Weekends 1 & 2', 'INPRG', 44032, 'A-LINE', 'CAP', 1000003627, '15CQ011', 'A65/A75 Interlocking (Replacem', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17112036, 'A1 Aerial Pier Drainage Weekends 1 & 2', 'INPRG', 44032, 'A-LINE', 'CAP', 1000003627, '15CQ011', 'A65/A75 Interlocking (Replacem', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17112036, 'A1 Aerial Pier Drainage Weekends 1 & 2', 'INPRG', 44032, 'A-LINE', 'CAP', 1000003627, '15CQ011', 'A65/A75 Interlocking (Replacem', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17049372, 'A1 Edge Tile Replacement', 'INPRG', 44013, 'A60', 'CAP', 1000003704, '15TC011', 'Platform Edge Struc Rehab', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17049372, 'A1 Edge Tile Replacement', 'INPRG', 44013, 'A60', 'CAP', 1000003704, '15TC011', 'Platform Edge Struc Rehab', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17049372, 'A1 Edge Tile Replacement', 'INPRG', 44013, 'A60', 'CAP', 1000003704, '15TC011', 'Platform Edge Struc Rehab', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17049372, 'A1 Edge Tile Replacement', 'INPRG', 44013, 'A60', 'CAP', 1000003704, '15TC011', 'Platform Edge Struc Rehab', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17049372, 'A1 Edge Tile Replacement', 'INPRG', 44013, 'A60', 'CAP', 1000003704, '15TC011', 'Platform Edge Struc Rehab', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17049372, 'A1 Edge Tile Replacement', 'INPRG', 44013, 'A60', 'CAP', 1000003704, '15TC011', 'Platform Edge Struc Rehab', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17049372, 'A1 Edge Tile Replacement', 'INPRG', 44013, 'A60', 'CAP', 1000003704, '15TC011', 'Platform Edge Struc Rehab', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17049372, 'A1 Edge Tile Replacement', 'INPRG', 44013, 'A60', 'CAP', 1000003704, '15TC011', 'Platform Edge Struc Rehab', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17094244, 'DF PADS ON A1 TRACK (MP 11.83 TO 12.83)', 'WAPPR', 44028, 'A-LINE', 'CAP', 1000003682, '15CQ016', 'Direct Fixation Pads', 'CODFS', 'Constr Direct Fixation Pads');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17094244, 'DF PADS ON A1 TRACK (MP 11.83 TO 12.83)', 'WAPPR', 44028, 'A-LINE', 'CAP', 1000003682, '15CQ016', 'Direct Fixation Pads', 'CODFS', 'Constr Direct Fixation Pads');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17094244, 'DF PADS ON A1 TRACK (MP 11.83 TO 12.83)', 'WAPPR', 44028, 'A-LINE', 'CAP', 1000003682, '15CQ016', 'Direct Fixation Pads', 'CODFS', 'Constr Direct Fixation Pads');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17094244, 'DF PADS ON A1 TRACK (MP 11.83 TO 12.83)', 'WAPPR', 44028, 'A-LINE', 'CAP', 1000003682, '15CQ016', 'Direct Fixation Pads', 'CODFS', 'Constr Direct Fixation Pads');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17094206, 'DF PADS ON A1 TRACK (MP 12.83 TO 13.74)', 'INPRG', 44028, 'A-LINE', 'CAP', 1000003682, '15CQ016', 'Direct Fixation Pads', 'CODFS', 'Constr Direct Fixation Pads');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17112124, 'A2 Aerial Pier Drainage Weekends 3 & 4', 'WAPPR', 44032, 'A-LINE', 'CAP', 1000003627, '15CQ011', 'A65/A75 Interlocking (Replacem', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17112124, 'A2 Aerial Pier Drainage Weekends 3 & 4', 'WAPPR', 44032, 'A-LINE', 'CAP', 1000003627, '15CQ011', 'A65/A75 Interlocking (Replacem', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17094247, 'DF PADS ON A2 TRACK (MP 12.83 TO 13.74)', 'INPRG', 44028, 'A-LINE', 'CAP', 1000003682, '15CQ016', 'Direct Fixation Pads', 'CODFS', 'Constr Direct Fixation Pads');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17094247, 'DF PADS ON A2 TRACK (MP 12.83 TO 13.74)', 'INPRG', 44028, 'A-LINE', 'CAP', 1000003682, '15CQ016', 'Direct Fixation Pads', 'CODFS', 'Constr Direct Fixation Pads');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17094247, 'DF PADS ON A2 TRACK (MP 12.83 TO 13.74)', 'INPRG', 44028, 'A-LINE', 'CAP', 1000003682, '15CQ016', 'Direct Fixation Pads', 'CODFS', 'Constr Direct Fixation Pads');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17094247, 'DF PADS ON A2 TRACK (MP 12.83 TO 13.74)', 'INPRG', 44028, 'A-LINE', 'CAP', 1000003682, '15CQ016', 'Direct Fixation Pads', 'CODFS', 'Constr Direct Fixation Pads');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17016705, 'TX/RX Replacement Project A60 Parent Work Order', 'SCHD', 44008, 'A60', 'CAP', 1000002465, '20LN003', 'TX / RX Loop Replacement', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17016705, 'TX/RX Replacement Project A60 Parent Work Order', 'SCHD', 44008, 'A60', 'CAP', 1000002465, '20LN003', 'TX / RX Loop Replacement', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17016705, 'TX/RX Replacement Project A60 Parent Work Order', 'SCHD', 44008, 'A60', 'CAP', 1000002465, '20LN003', 'TX / RX Loop Replacement', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17048946, 'Edge tile/Directional Tile', 'WMATL', 44013, 'A60', 'CAP', 1000003704, '15TC011', 'Platform Edge Struc Rehab', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17025343, 'TP-Maintenance DAY: Replacing Parking Lot Lighting at A60', 'INPRG', 44011, 'A60', 'CAP', 1000003627, '15TK000', 'M*E CAPITALIZED MAINTENANCE', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17025343, 'TP-Maintenance DAY: Replacing Parking Lot Lighting at A60', 'INPRG', 44011, 'A60', 'CAP', 1000003627, '15TK000', 'M*E CAPITALIZED MAINTENANCE', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17025343, 'TP-Maintenance DAY: Replacing Parking Lot Lighting at A60', 'INPRG', 44011, 'A60', 'CAP', 1000003627, '15TK000', 'M*E CAPITALIZED MAINTENANCE', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17025343, 'TP-Maintenance DAY: Replacing Parking Lot Lighting at A60', 'INPRG', 44011, 'A60', 'CAP', 1000003627, '15TK000', 'M*E CAPITALIZED MAINTENANCE', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17025343, 'TP-Maintenance DAY: Replacing Parking Lot Lighting at A60', 'INPRG', 44011, 'A60', 'CAP', 1000003627, '15TK000', 'M*E CAPITALIZED MAINTENANCE', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17025343, 'TP-Maintenance DAY: Replacing Parking Lot Lighting at A60', 'INPRG', 44011, 'A60', 'CAP', 1000003627, '15TK000', 'M*E CAPITALIZED MAINTENANCE', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17025343, 'TP-Maintenance DAY: Replacing Parking Lot Lighting at A60', 'INPRG', 44011, 'A60', 'CAP', 1000003627, '15TK000', 'M*E CAPITALIZED MAINTENANCE', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17258130, 'TP-Maintenance GRAVE: Replacing Parking Lot Lighting at A60', 'WSCHED', 44069, 'A60', 'CAP', 1000003627, '15TK000', 'M*E CAPITALIZED MAINTENANCE', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17208607, 'A60-TP-Maintenance SWING: Concourse, Platform Level Lighting Replacement at A60', 'COMP', 44056, 'A60', 'CAP', 1000003627, '15TK000', 'M*E CAPITALIZED MAINTENANCE', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17208607, 'A60-TP-Maintenance SWING: Concourse, Platform Level Lighting Replacement at A60', 'COMP', 44056, 'A60', 'CAP', 1000003627, '15TK000', 'M*E CAPITALIZED MAINTENANCE', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17208607, 'A60-TP-Maintenance SWING: Concourse, Platform Level Lighting Replacement at A60', 'COMP', 44056, 'A60', 'CAP', 1000003627, '15TK000', 'M*E CAPITALIZED MAINTENANCE', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17208607, 'A60-TP-Maintenance SWING: Concourse, Platform Level Lighting Replacement at A60', 'COMP', 44056, 'A60', 'CAP', 1000003627, '15TK000', 'M*E CAPITALIZED MAINTENANCE', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17169829, 'TP-Maintenance GRAVE: Concourse, Platform Level Lighting Replacement at A60', 'INPRG', 44044, 'A60', 'CAP', 1000003627, '15TK000', 'M*E CAPITALIZED MAINTENANCE', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17025384, 'TP-Maintenance DAY: Concourse, Platform Level Lighting Replacement at A60', 'INPRG', 44011, 'A60', 'CAP', 1000003627, '15TK000', 'M*E CAPITALIZED MAINTENANCE', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17025384, 'TP-Maintenance DAY: Concourse, Platform Level Lighting Replacement at A60', 'INPRG', 44011, 'A60', 'CAP', 1000003627, '15TK000', 'M*E CAPITALIZED MAINTENANCE', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17025384, 'TP-Maintenance DAY: Concourse, Platform Level Lighting Replacement at A60', 'INPRG', 44011, 'A60', 'CAP', 1000003627, '15TK000', 'M*E CAPITALIZED MAINTENANCE', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17025384, 'TP-Maintenance DAY: Concourse, Platform Level Lighting Replacement at A60', 'INPRG', 44011, 'A60', 'CAP', 1000003627, '15TK000', 'M*E CAPITALIZED MAINTENANCE', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17025384, 'TP-Maintenance DAY: Concourse, Platform Level Lighting Replacement at A60', 'INPRG', 44011, 'A60', 'CAP', 1000003627, '15TK000', 'M*E CAPITALIZED MAINTENANCE', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17025384, 'TP-Maintenance DAY: Concourse, Platform Level Lighting Replacement at A60', 'INPRG', 44011, 'A60', 'CAP', 1000003627, '15TK000', 'M*E CAPITALIZED MAINTENANCE', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 17025384, 'TP-Maintenance DAY: Concourse, Platform Level Lighting Replacement at A60', 'INPRG', 44011, 'A60', 'CAP', 1000003627, '15TK000', 'M*E CAPITALIZED MAINTENANCE', 'CONST', 'Constructn,Fabricatn,Instalatn');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 16621791, 'TP-Cons: A-Line Third Rail Replacement Phase 3-(15ELRR3)', 'WSCHED', 43916, 'A-LINE', 'PRJ', 1000003069, '54RR004', 'M&E Line Rail EQP', 'FDSTR', 'FD-Third Rail Replacement');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 16621791, 'TP-Cons: A-Line Third Rail Replacement Phase 3-(15ELRR3)', 'WSCHED', 43916, 'A-LINE', 'PRJ', 1000003069, '54RR004', 'M&E Line Rail EQP', 'FDSTR', 'FD-Third Rail Replacement');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 16621791, 'TP-Cons: A-Line Third Rail Replacement Phase 3-(15ELRR3)', 'WSCHED', 43916, 'A-LINE', 'PRJ', 1000003069, '54RR004', 'M&E Line Rail EQP', 'FDSTR', 'FD-Third Rail Replacement');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 16621791, 'TP-Cons: A-Line Third Rail Replacement Phase 3-(15ELRR3)', 'WSCHED', 43916, 'A-LINE', 'PRJ', 1000003069, '54RR004', 'M&E Line Rail EQP', 'FDSTR', 'FD-Third Rail Replacement');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 16621791, 'TP-Cons: A-Line Third Rail Replacement Phase 3-(15ELRR3)', 'WSCHED', 43916, 'A-LINE', 'PRJ', 1000003069, '54RR004', 'M&E Line Rail EQP', 'FDSTR', 'FD-Third Rail Replacement');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 16621791, 'TP-Cons: A-Line Third Rail Replacement Phase 3-(15ELRR3)', 'WSCHED', 43916, 'A-LINE', 'PRJ', 1000003069, '54RR004', 'M&E Line Rail EQP', 'FDSTR', 'FD-Third Rail Replacement');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 16621791, 'TP-Cons: A-Line Third Rail Replacement Phase 3-(15ELRR3)', 'WSCHED', 43916, 'A-LINE', 'PRJ', 1000003069, '54RR004', 'M&E Line Rail EQP', 'FDSTR', 'FD-Third Rail Replacement');
INSERT INTO Workorder (w_projectid, w_WOnum, w_desc, w_status, w_reporteddate, w_location, w_type, w_TPID, w_PSProject, w_PSProjDesc, w_PSActivity, w_PSActDesc) VALUES ('A65', 16621791, 'TP-Cons: A-Line Third Rail Replacement Phase 3-(15ELRR3)', 'WSCHED', 43916, 'A-LINE', 'PRJ', 1000003069, '54RR004', 'M&E Line Rail EQP', 'FDSTR', 'FD-Third Rail Replacement');

-- TABLE : Department
CREATE TABLE Department(dep_Num DECIMAL(7,0) NOT NULL, dep_Name CHAR NOT NULL);
INSERT INTO Department(dep_Num, dep_Name) VALUES (0802847, 'Operating & Capital Programs');
INSERT INTO Department(dep_Num, dep_Name) VALUES (0802881, 'Power & Mechanical Engineering');
INSERT INTO Department(dep_Num, dep_Name) VALUES (0802856, 'Integration Engineering');
INSERT INTO Department(dep_Num, dep_Name) VALUES (0802845, 'Civil/Structural Eng & Constru');
INSERT INTO Department(dep_Num, dep_Name) VALUES (0802820, 'Systems Engineering');


--TABLE : Project Managers
--need to search data for other reports where each project managers is involved to find other useful needed attributes for this table 
CREATE TABLE projectManagers(d_Num DECIMAL(7,0) NOT NULL, name CHAR NOT NULL);
INSERT INTO projectManagers(d_Num, name) VALUES (0802847, 'Fields,Bryant');
INSERT INTO projectManagers(d_Num, name) VALUES (0802881, 'Sims,Steven M');
INSERT INTO projectManagers(d_Num, name) VALUES (0802856, 'Small,Kathy U');
INSERT INTO projectManagers(d_Num, name) VALUES (0802845, 'Wu,Victor W');
INSERT INTO projectManagers(d_Num, name) VALUES (0802820, 'Dietrich,Steven D');

DROP TABLE projNotifcations;

CREATE TABLE projNotifcations(name CHAR NOT NULL, projID CHAR NOT NULL, phase CHAR NOT NULL, task CHAR, activName CHAR NOT NULL, baseline_date DATE NOT NULL, days_aheadBehind_baseline INTEGER NOT NULL, notifType VARCHAR(4), created_at TEXT DEFAULT CURRENT_TIMESTAMP);
INSERT INTO projNotifcations(name, projID, phase, task, activName, baseline_date, days_aheadBehind_baseline, notifType) VALUES ('Repair & Maintenance of Cathodic Protection System', '09AF002', 'Contract 09DJ-140A [CLOSED]', 'Construction', 'NTP - Repair & Maintenance of Cathodic Proc (09DJ-140A)', 2021-03-11, 0, 'progress');
INSERT INTO projNotifcations(name, projID, phase, task, activName, baseline_date, days_aheadBehind_baseline, notifType) VALUES ('TBT Cathodic Protection -', '09AF002', 'Closeout', 'Maintenance Operation', 'Maintenance Acceptance and Maximo Updated', 2020-04-01, 146, 'success');
INSERT INTO projNotifcations(name, projID, phase, task, activName, baseline_date, days_aheadBehind_baseline, notifType) VALUES ('Replacement of TBT Emergency Doors', '09AF002', 'Closeout', NULL, 'Maintenance Acceptance / Maximo Updated', 2020-08-18, 0, 'success');
INSERT INTO projNotifcations(name, projID, phase, task, activName, baseline_date, days_aheadBehind_baseline, notifType) VALUES ('TBT CP System Assessment', '09AF002', 'Closeout', 'BART Maintenance (Turn Over / Acceptance)', 'Maximo Updated', 2021-04-09, 0, 'success');
INSERT INTO projNotifcations(name, projID, phase, task, activName, baseline_date, days_aheadBehind_baseline, notifType) VALUES ('Transbay Tube 480V Switchgear Replacement, XF Pads', '09AF002', 'TransBay Tube 480V Switchgear Replacement, XF, pads', 'Procurement', 'NTP', 2022-05-24, 1541, 'progress');
INSERT INTO projNotifcations(name, projID, phase, task, activName, baseline_date, days_aheadBehind_baseline, notifType) VALUES ('Transbay Tube 480V Switchgear Replacement, XF Pads', '09AF002', 'TransBay Tube 480V Switchgear Replacement, XF, pads', 'Construction', 'Substantial Completion', 2022-08-19, 0, 'progress');
INSERT INTO projNotifcations(name, projID, phase, task, activName, baseline_date, days_aheadBehind_baseline, notifType) VALUES ('Transbay Tube 480V Switchgear Replacement, XF Pads', '09AF002', 'TransBay Tube 480V Switchgear Replacement, XF, pads', 'Closeout', 'Maintenance Acceptance & Maximo updated', 2022-12-30, 0, 'succcess');
INSERT INTO projNotifcations(name, projID, phase, task, activName, baseline_date, days_aheadBehind_baseline, notifType) VALUES ('Transbay Tube 480V Switchgear Replacement, XF Pads', '09AF002', 'TransBay Tube 480V Switchgear Replacement, XF, pads', 'Closeout', 'Project Completion', 2023-03-08, 0, 'succcess');

-- TABLE : Projects
CREATE TABLE Projects(name VARCHAR(50) NOT NULL, id_num VARCHAR(10) NOT NULL, manager DECIMAL(7,0) NOT NULL, dept_ID DECIMAL(7,0) NOT NULL, progress VARCHAR(100) NOT NULL, created_at TEXT DEFAULT CURRENT_TIMESTAMP);

INSERT INTO Projects (name, id_num, manager, dept_ID, progress) VALUES ('Replacement of TBT Emergency Doors', "09AF002", 0802881, 0802847, "Nearly Finsished");
INSERT INTO Projects (name, id_num, manager, dept_ID, progress) VALUES ('Removal of TBT Emergency Doors', "09AF002",0802847 , 0802847, "There has been a set back");

--SELECT name, id_num, manager, dept_ID, progress, datetime(created_at, 'localtime') as updated_at FROM Projects;
 
-- TABLE : projAssets
-- 'type' could be either PM or CM
CREATE TABLE projAssets(assetID VARCHAR(25) NOT NULL, projID VAR(25) NOT NULL, type CHAR(2) NOT NULL);
INSERT INTO projAssets VALUES ('A1 EDGE 2', '09AF002', 'PM');

DROP VIEW notifUpdates;

CREATE VIEW notifUpdates(projID, name, phase, notifType, time_at) AS
    SELECT  projNotifcations.projID, projNotifcations.name, projNotifcations.phase, projNotifcations.notifType, projNotifcations.created_at
    FROM    Projects, projNotifcations, Department, projectManagers
    WHERE   projID LIKE id_num
    AND dep_Num = dept_ID
    AND d_Num = manager

CREATE VIEW projectUpdates(assetID, projID, progress, updated_at, department, manager) AS 
    SELECT assetID, projID, progress, date(created_at, 'localtime'), dep_Name, projectManagers.name
    FROM Projects, projAssets, Department, projectManagers
    WHERE id_num LIKE projID
    AND dep_Num = dept_ID
    AND d_Num = manager

DROP VIEW projectUpdates

SELECT * FROM projectUpdates WHERE strftime('%W', updated_at) LIKE strftime('%W', 2020) OR strftime('%W', updated_at) LIKE strftime('%W', 11) - 1

COMMIT TRANSACTION;
PRAGMA foreign_keys = on;