From 701177c67fa6bde4ce19a31d30e3d896eb134a7a 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 e9c2e014fc..3c678cbd68 100644
--- a/Open-ILS/examples/fm_IDL.xml
+++ b/Open-ILS/examples/fm_IDL.xml
@@ -7056,6 +7056,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 5d61b4ac64..42269bee92 100644
--- a/Open-ILS/src/sql/Pg/005.schema.actors.sql
+++ b/Open-ILS/src/sql/Pg/005.schema.actors.sql
@@ -368,6 +368,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