Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


AuthorAndrei Makaranka
JIRA task

Jira Legacy
serverSystem Jira
serverId01505d01-b853-3c2e-90f1-ee9b165564fc
keyUXPROD-2899

Business Requirements
Architects Review

Status
colourYellow
titleIn Progress

PO review

Status
colourYellow
titleIn Progress

...

  • Ledger Fiscal Year Rollover already implemented.
  • It is likely that we will be creating upwards of 75000 - 100000 encumbrances during this process. (statistics from Library). 
  • Prepare report with Unpaid invoices is UI responsibility.

...

Update schema "ledger_fiscal_year_rollover" with new "action" field

PropertyTypeRead OnlyDefaultRequiredNotes

action

enum ["Preview", "Commit", "Rollback"]


trueCommit

Y

  • Current scheme for rollover records - add a column/flag to mark every rollover if it is a real or a preview one - this will also keep the history of completed previews

Create duplicate of the Budget schema

...

Method

Path

Request

Response

Description

Interface

Notes

POST/finance/ledger-rollovers/previews

ramls/acq-models/mod-finance/schemas/ledger_fiscal_year_rollover.json

preview_ledger_fiscal_year_rolloverRun preview of the ledger fiscal year rolloversfinance.ledger-rollovers.previews.collection.postStatus : 201
GET/finance/ledger-rollovers/previews/{id}NA

preview_ledger_fiscal_year_rollover

GET preview of the ledger fiscal year rollover by idfinance.ledger-rollovers.previews.item.getStatus : 200
GET/finance/ledger-rollovers/previewsNApreview_ledger_fiscal_year_rollover_collectionGET previews of the ledger fiscal year rolloversfinance.ledger-rollovers.previews.collection.getStatus : 200
DELETE/finance-storage/ledger-rollovers/previews/{id}NANADELETE  preview of the ledger fiscal year rollover by idfinance.ledger-rollovers.previews.item.deleteStatus : 204

...

Method

Path

Request

Response

Description

Interface

Notes

POST/finance-storage/ledger-rollovers/previews

ramls/acq-models/mod-finance/schemas/ledger_fiscal_year_rollover.json

preview_ledger_fiscal_year_rolloverPOST previews of the ledger fiscal year rolloversfinance-storage.ledger-rollovers.previews.collection.postStatus : 201
GET

/finance-storage/ledger-rollovers/previews/{id}

NApreview_ledger_fiscal_year_rolloverGET preview of the ledger fiscal year rollover by idfinance-storage.ledger-rollovers.previews.item.getStatus : 200
GET/finance-storage/ledger-rollovers/previewsNApreview_ledger_fiscal_year_rollover_collectionGET previews of the ledger fiscal year rolloversfinance-storage.ledger-rollovers.previews.collection.getStatus : 200
DELETE/finance-storage/ledger-rollovers/previews/{id}NANADELETE previews of the ledger fiscal year rollover by idfinance-storage.ledger-rollovers.previews.item.deleteStatus : 204

...


WorkCommentsStory~ Estimate
1
  1. Update schema "ledger_fiscal_year_rollover" with new "action" field
  2. Create duplicate of the Budget schema where all amounts are "persistent"
  3. Define schema and table for preview rollover results → Define schema and table for preview rollover results
acq-models, mod-finance-storage, mod-finance

Jira Legacy
serverSystem Jira
serverId01505d01-b853-3c2e-90f1-ee9b165564fc
keyMODFISTO-319

1
2
  1. Define Storage API : Preview Ledger Rollover → storage API : Preview Ledger Rollover
  2. Implement API → Should be without any logic.
 mod-finance-storage

Jira Legacy
serverSystem Jira
serverId01505d01-b853-3c2e-90f1-ee9b165564fc
keyMODFISTO-320

1
3
  1. Define API : Preview Ledger Rollover → Business API : Preview Ledger Rollover
  2. Implement API → Should be Proxy to storage layer without any logic
mod-finance

Jira Legacy
serverSystem Jira
serverId01505d01-b853-3c2e-90f1-ee9b165564fc
keyMODFIN-256

1
4
  1. Spike : Implement POC with storing preview result in the temporary tables and after that upload results in the preview rollover table

mod-finance-storage

All all open technical questions should be resolved

Jira Legacy
serverSystem Jira
serverId01505d01-b853-3c2e-90f1-ee9b165564fc
keyMODFISTO-322

5
5
  1. Implement logic for storing preview result in the temporary tables and after that upload results in the preview rollover table
mod-finance-storage

Jira Legacy
serverSystem Jira
serverId01505d01-b853-3c2e-90f1-ee9b165564fc
keyMODFISTO-323


6
  1. Steps should be run in scope of one DB transaction :

1.1 Rollover script run,

1.2. Calculation budgets amounts,

1.3. Storing them in the rollover preview table  → preview_ledger_fiscal_year_rollover

mod-finance-storage

Jira Legacy
serverSystem Jira
serverId01505d01-b853-3c2e-90f1-ee9b165564fc
keyMODFISTO-318


7
  1. Spike : To gain knowledge about mod-email and implement example with usage email sending
mod-finance

Jira Legacy
serverSystem Jira
serverId01505d01-b853-3c2e-90f1-ee9b165564fc
keyMODFIN-258


8
  1. Implement sending email and include it in the preview ledger rollover flow
mod-finance

Jira Legacy
serverSystem Jira
serverId01505d01-b853-3c2e-90f1-ee9b165564fc
keyMODFIN-257




Open Items

QuestionAnswerStory

...