]> git.evergreen-ils.org Git - working/Evergreen.git/commit
1. Add two new columns to actor.org_unit: spend_warning_percent and
authorscottmk <scottmk@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Fri, 5 Feb 2010 04:25:05 +0000 (04:25 +0000)
committerscottmk <scottmk@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Fri, 5 Feb 2010 04:25:05 +0000 (04:25 +0000)
commit476f0a2275c37389e824fc4747def493935a4aa5
tree32a0d03f4fdfa6dfee2163de78d723ee2a764c15
parent0e43880cec2982ea201100463fa1237b13da10d0
1. Add two new columns to actor.org_unit: spend_warning_percent and
spend_limit_percent.  These define, by org unit, spending levels
that should trigger either a warning or a firm limit for a fund.

2. Added corresponding columns to the auditor.actor_org_unit_history table.

3. In order to make the above work: raarranged way we create the
actor.org_unit table so that we define it with the fiscal_calendar
column and add the associated foreign key constraint later.

4. Add a fiscal_calendar column to the auditor.actor_org_unit_history
table (correcting an oversight on a previous commit).

5. Created two new functions to look up the default spending levels
for a given org unit.  Where the spending level is undefined, the
functions look for a spending level defined for a parent org unit,
ultimately defaulting if necessary to a hard-coded value.

M    Open-ILS/src/sql/Pg/005.schema.actors.sql
M    Open-ILS/src/sql/Pg/999.functions.global.sql
M    Open-ILS/src/sql/Pg/200.schema.acq.sql
M    Open-ILS/src/sql/Pg/002.schema.config.sql
A    Open-ILS/src/sql/Pg/upgrade/0151.schema.acq.spending-limits.sql
M    Open-ILS/examples/fm_IDL.xml

git-svn-id: svn://svn.open-ils.org/ILS/trunk@15451 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/examples/fm_IDL.xml
Open-ILS/src/sql/Pg/002.schema.config.sql
Open-ILS/src/sql/Pg/005.schema.actors.sql
Open-ILS/src/sql/Pg/200.schema.acq.sql
Open-ILS/src/sql/Pg/999.functions.global.sql
Open-ILS/src/sql/Pg/upgrade/0151.schema.acq.spending-limits.sql [new file with mode: 0644]