X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-sql%2Fsystem%2Ftlc%2F030_tlc_mapping_tables.sql;h=9fddeafefbee755c779f5bd2a141c9b225cc9aa5;hp=bef2599c5a49bf7ed10689323930b6be98870c8a;hb=709fe65478a6acded9bab3f66fa1283ab619d62b;hpb=ed724b63f7d32cf5bb1a6e7b4c915d056413e899

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')