From 709fe65478a6acded9bab3f66fa1283ab619d62b Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Tue, 6 Mar 2018 08:58:46 -0500 Subject: [PATCH 1/1] adding tlc code to billing type table --- mig-sql/system/tlc/030_tlc_mapping_tables.sql | 2 ++ 1 files changed, 2 insertions(+), 0 deletions(-) diff --git a/mig-sql/system/tlc/030_tlc_mapping_tables.sql b/mig-sql/system/tlc/030_tlc_mapping_tables.sql index bef2599..9fddeaf 100644 --- a/mig-sql/system/tlc/030_tlc_mapping_tables.sql +++ b/mig-sql/system/tlc/030_tlc_mapping_tables.sql @@ -113,6 +113,7 @@ VALUES CREATE TABLE map_tlc_billing_type ( id SERIAL ,x_count TEXT + ,tlc_code TEXT ,billing_type TEXT ,dnm TEXT ,note TEXT @@ -128,6 +129,7 @@ INSERT INTO gsheet_tracked_column (table_id,column_name) VALUES ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'x_count') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'tlc_code') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'billing_type') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'dnm') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'note') -- 1.7.2.5