Chapter 20. Schema reporter

Table of Contents

Tables in reporter
circ_type
currently_running
demographic
hold_request_record
materialized_simple_record
old_super_simple_record
output_folder
overdue_circs
overdue_reports
pending_reports
report
report_folder
schedule
simple_record
super_simple_record
template
template_folder
xact_billing_totals
xact_paid_totals
Functions in reporter

Below are the tables, views and functions for reporter

Tables in reporter

circ_type

  • id bigint
  • type text

currently_running

  • id integer
  • runner_barcode text
  • name text
  • run_time timestamp with time zone
  • scheduled_wait_time interval

demographic

  • id integer
  • dob date
  • general_division text

hold_request_record

  • id integer
  • target bigint
  • hold_type text
  • bib_record bigint

materialized_simple_record

  • id bigint PRIMARY KEY
  • fingerprint text
  • quality integer
  • tcn_source text
  • tcn_value text
  • title text
  • author text
  • publisher text
  • pubdate text
  • isbn text[]
  • issn text[]

old_super_simple_record

  • id bigint
  • fingerprint text
  • quality integer
  • tcn_source text
  • tcn_value text
  • title text
  • author text
  • publisher text
  • pubdate text
  • isbn text[]
  • issn text[]

output_folder

  • id serial PRIMARY KEY
  • parent integer REFERENCES reporter.table.output-folder
  • owner integer NOT NULL REFERENCES actor.table.usr
  • create_time timestamp with time zone NOT NULL DEFAULT now()
  • name text NOT NULL
  • shared boolean NOT NULL DEFAULT false
  • share_with integer REFERENCES actor.table.org-unit

Indexes on output_folder

  • rpt_output_fldr_owner_idx owner

Tables referencing via foreign key constraints

  • reporter.output_folder
  • reporter.schedule

overdue_circs

  • id bigint
  • usr integer
  • xact_start timestamp with time zone
  • xact_finish timestamp with time zone
  • unrecovered boolean
  • target_copy bigint
  • circ_lib integer
  • circ_staff integer
  • checkin_staff integer
  • checkin_lib integer
  • renewal_remaining integer
  • grace_period interval
  • due_date timestamp with time zone
  • stop_fines_time timestamp with time zone
  • checkin_time timestamp with time zone
  • create_time timestamp with time zone
  • duration interval
  • fine_interval interval
  • recurring_fine numeric(6,2)
  • max_fine numeric(6,2)
  • phone_renewal boolean
  • desk_renewal boolean
  • opac_renewal boolean
  • duration_rule text
  • recurring_fine_rule text
  • max_fine_rule text
  • stop_fines text
  • workstation integer
  • checkin_workstation integer
  • copy_location integer
  • checkin_scan_time timestamp with time zone
  • parent_circ bigint

overdue_reports

  • id integer
  • runner_barcode text
  • name text
  • run_time timestamp with time zone
  • scheduled_wait_time interval

pending_reports

  • id integer
  • runner_barcode text
  • name text
  • run_time timestamp with time zone
  • scheduled_wait_time interval

report

  • id serial PRIMARY KEY
  • owner integer NOT NULL REFERENCES actor.table.usr
  • create_time timestamp with time zone NOT NULL DEFAULT now()
  • name text NOT NULL DEFAULT ''::text
  • description text NOT NULL DEFAULT ''::text
  • template integer NOT NULL REFERENCES reporter.table.template
  • data text NOT NULL
  • folder integer NOT NULL REFERENCES reporter.table.report-folder
  • recur boolean NOT NULL DEFAULT false
  • recurrence interval

Indexes on report

  • rpt_rpt_fldr_idx folder
  • rpt_rpt_owner_idx owner

Tables referencing via foreign key constraints

  • reporter.schedule

report_folder

  • id serial PRIMARY KEY
  • parent integer REFERENCES reporter.table.report-folder
  • owner integer NOT NULL REFERENCES actor.table.usr
  • create_time timestamp with time zone NOT NULL DEFAULT now()
  • name text NOT NULL
  • shared boolean NOT NULL DEFAULT false
  • share_with integer REFERENCES actor.table.org-unit

Indexes on report_folder

  • rpt_rpt_fldr_owner_idx owner

Tables referencing via foreign key constraints

  • reporter.report
  • reporter.report_folder

schedule

  • id serial PRIMARY KEY
  • report integer NOT NULL REFERENCES reporter.table.report
  • folder integer NOT NULL REFERENCES reporter.table.output-folder
  • runner integer NOT NULL REFERENCES actor.table.usr
  • run_time timestamp with time zone NOT NULL DEFAULT now()
  • start_time timestamp with time zone
  • complete_time timestamp with time zone
  • email text
  • excel_format boolean NOT NULL DEFAULT true
  • html_format boolean NOT NULL DEFAULT true
  • csv_format boolean NOT NULL DEFAULT true
  • chart_pie boolean NOT NULL DEFAULT false
  • chart_bar boolean NOT NULL DEFAULT false
  • chart_line boolean NOT NULL DEFAULT false
  • error_code integer
  • error_text text

Indexes on schedule

  • rpt_sched_folder_idx folder
  • rpt_sched_runner_idx runner

simple_record

  • id bigint
  • metarecord bigint
  • fingerprint text
  • quality integer
  • tcn_source text
  • tcn_value text
  • title text
  • uniform_title text
  • author text
  • publisher text
  • pubdate text
  • series_title text
  • series_statement text
  • summary text
  • isbn text[]
  • issn text[]
  • topic_subject text[]
  • geographic_subject text[]
  • genre text[]
  • name_subject text[]
  • corporate_subject text[]
  • external_uri text[]

super_simple_record

  • id bigint
  • fingerprint text
  • quality integer
  • tcn_source text
  • tcn_value text
  • title text
  • author text
  • publisher text
  • pubdate text
  • isbn text[]
  • issn text[]

template

  • id serial PRIMARY KEY
  • owner integer NOT NULL REFERENCES actor.table.usr
  • create_time timestamp with time zone NOT NULL DEFAULT now()
  • name text NOT NULL
  • description text NOT NULL
  • data text NOT NULL
  • folder integer NOT NULL REFERENCES reporter.table.template-folder

Indexes on template

  • rpt_tmpl_fldr_idx folder
  • rpt_tmpl_owner_idx owner

Tables referencing via foreign key constraints

  • reporter.report

template_folder

  • id serial PRIMARY KEY
  • parent integer REFERENCES reporter.table.template-folder
  • owner integer NOT NULL REFERENCES actor.table.usr
  • create_time timestamp with time zone NOT NULL DEFAULT now()
  • name text NOT NULL
  • shared boolean NOT NULL DEFAULT false
  • share_with integer REFERENCES actor.table.org-unit

Indexes on template_folder

  • rpt_tmpl_fldr_owner_idx owner

Tables referencing via foreign key constraints

  • reporter.template
  • reporter.template_folder

xact_billing_totals

  • xact bigint
  • unvoided numeric
  • voided numeric
  • total numeric

xact_paid_totals

  • xact bigint
  • unvoided numeric
  • voided numeric
  • total numeric