+CREATE TABLE map_tlc_branches (
+ id SERIAL
+ ,tlc_branch_id TEXT
+ ,tlc_name TEXT
+ ,org_unit TEXT
+ ,note TEXT
+ ,x_org_id INTEGER
+);
+
+INSERT INTO gsheet_tracked_table
+ (table_name,tab_name,created)
+VALUES
+ ('map_tlc_branches','Branches Present in Extract',NOW())
+;
+
+INSERT INTO gsheet_tracked_column
+ (table_id,column_name)
+VALUES
+ ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'x_count')
+ ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'tlc_branch_id')
+ ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'tlc_name')
+ ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'org_unit')
+ ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'note')
+;
+
+-- ############################################
+
CREATE TABLE map_tlc_perm_group (
id SERIAL
,x_count TEXT
CREATE TABLE map_tlc_billing_type (
id SERIAL
,x_count TEXT
+ ,tlc_code TEXT
,billing_type TEXT
,dnm TEXT
,note TEXT
(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')
-- ############################################
-CREATE TABLE map_tlc_phone (
- id SERIAL
- ,x_count TEXT
- ,legacy_phone TEXT
- ,evergreen_phone TEXT
- ,note TEXT
-);
-
-INSERT INTO gsheet_tracked_table
- (table_name,tab_name,created)
-VALUES
- ('map_tlc_phone','Patron Phone Numbers',NOW())
-;
-
-INSERT INTO gsheet_tracked_column
- (table_id,column_name)
-VALUES
- ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Phone Numbers'),'x_count')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Phone Numbers'),'legacy_phone')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Phone Numbers'),'evergreen_phone')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Phone Numbers'),'note')
-;
-
--- ############################################
-
CREATE TABLE map_tlc_block_status (
id SERIAL
,x_count TEXT
id SERIAL
,x_count TEXT
,tlc_stat_cat TEXT
+ ,tlc_stat_cat_value TEXT
,stat_cat TEXT
,stat_cat_entry TEXT
,show TEXT
VALUES
((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'x_count')
,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'tlc_stat_cat')
+ ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'tlc_stat_cat_value')
,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'stat_cat')
,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'stat_cat_entry')
,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'show')