From 7c51c02410ec05862c9e635885da9c61d94e66fd Mon Sep 17 00:00:00 2001
From: Terran McCanna <tmccanna@georgialibraries.org>
Date: Thu, 29 Jul 2021 12:48:16 -0400
Subject: [PATCH] Add Federal Codes to Org Units for Annual Reports

This adds two new fields to the org unit interface and makes
those fields available to the reporter.

Signed-off-by: Terran McCanna <tmccanna@georgialibraries.org>
---
 Open-ILS/examples/fm_IDL.xml                       | 2 ++
 Open-ILS/src/sql/Pg/005.schema.actors.sql          | 2 ++
 Open-ILS/src/sql/Pg/upgrade/XXXX.federal_codes.sql | 5 +++++
 3 files changed, 9 insertions(+)
 create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.federal_codes.sql

diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml
index 477f3a3b74..94d3d7ad8a 100644
--- a/Open-ILS/examples/fm_IDL.xml
+++ b/Open-ILS/examples/fm_IDL.xml
@@ -7210,6 +7210,8 @@ SELECT  usr,
 			<field reporter:label="Resource Attributes" name="rsrc_attrs" oils_persist:virtual="true" reporter:datatype="link"/>
 			<field reporter:label="Attribute Values" name="attr_vals" oils_persist:virtual="true" reporter:datatype="link"/>
 			<field reporter:label="Hours of Operation" name="hours_of_operation" oils_persist:virtual="true" reporter:datatype="link"/>
+            <field name="fscskey" reporter:label="FSCSKEY" reporter:datatype="text"/>
+            <field name="fscs_seq" reporter:label="FSCS_SEQ" reporter:datatype="text"/>
 		</fields>
 		<links>
 			<link field="billing_address" reltype="has_a" key="id" map="" class="aoa"/>
diff --git a/Open-ILS/src/sql/Pg/005.schema.actors.sql b/Open-ILS/src/sql/Pg/005.schema.actors.sql
index 540223ae3a..c47ef41b90 100644
--- a/Open-ILS/src/sql/Pg/005.schema.actors.sql
+++ b/Open-ILS/src/sql/Pg/005.schema.actors.sql
@@ -355,6 +355,8 @@ CREATE TABLE actor.org_unit (
 	name		TEXT	NOT NULL UNIQUE,
 	email		TEXT,
 	phone		TEXT,
+    fscskey     TEXT,
+    fscs_seq    TEXT,
 	opac_visible	BOOL	NOT NULL DEFAULT TRUE,
 	fiscal_calendar INT     NOT NULL DEFAULT 1   -- foreign key constraint to be added later
 );
diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.federal_codes.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.federal_codes.sql
new file mode 100644
index 0000000000..78af2e73fb
--- /dev/null
+++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.federal_codes.sql
@@ -0,0 +1,5 @@
+BEGIN;
+
+ALTER TABLE actor.org unit ADD COLUMN fscskey TEXT, ADD COLUMN fscs_seq TEXT;
+
+COMMIT;
\ No newline at end of file
-- 
2.11.0