+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_phone (
- id SERIAL
- ,x_count TEXT
- ,note TEXT
- ,migrate_available TEXT
- ,fill_in_method TEXT
- ,static_value 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
CREATE TABLE map_tlc_patron_gender (
id SERIAL
,x_count TEXT
- ,tlc_block_status TEXT
- ,block TEXT
- ,bar TEXT
+ ,gender TEXT
+ ,stat_cat TEXT
+ ,stat_cat_entry TEXT
+ ,show TEXT
+ ,required TEXT
,dnm TEXT
,note TEXT
);
(table_id,column_name)
VALUES
((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'x_count')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'tlc_block_status')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'block')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'bar')
+ ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'gender')
+ ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'stat_cat')
+ ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'stat_cat_entry')
+ ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'show')
+ ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'required')
,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'dnm')
,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'note')
;
,x_count TEXT
,holding_code TEXT
,shelving_location TEXT
+ ,org_unit TEXT
,circ_mod TEXT
,alert TEXT
,alert_message TEXT
((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'x_count')
,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'holding_code')
,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'shelving_location')
+ ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'org_unit')
,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'circ_mod')
,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'alert')
,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'alert_message')
CREATE TABLE map_tlc_patron_note (
id SERIAL
,x_count TEXT
- ,legacy_mnote_type TEXT
- ,exception TEXT
+ ,note_type TEXT
+ ,subset_values TEXT
+ ,matching_text TEXT
,action TEXT
,note TEXT
- ,circulate TEXT
);
INSERT INTO gsheet_tracked_table