[
https://issues.apache.org/jira/browse/FINERACT-1670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Adam Saghy updated FINERACT-1670:
---------------------------------
Fix Version/s: (was: 1.12.0)
> Introduce Auditable entities - Storing date time in UTC
> -------------------------------------------------------
>
> Key: FINERACT-1670
> URL: https://issues.apache.org/jira/browse/FINERACT-1670
> Project: Apache Fineract
> Issue Type: Improvement
> Affects Versions: 1.7.0, 1.8.0
> Reporter: Adam Saghy
> Assignee: Adam Saghy
> Priority: Major
> Attachments: Re_ Timezone issues with Daylight savings.rtfd.zip
>
>
> AbstractAuditableCustom interface to be used more widely with entities.
> Many Fineract entity has no proper audit fields (creation date & time, last
> modification date & time, created by, modified by entries.
> Many entities has a variety of the above fields but with custom
> implementation and not fit perfectly for audit purposes (see LoanTransaction).
> All business entity ( utility entities excluded) should implement the above
> interface and fill properly the audit fields with a common, generic way.
> The similar custom fields to be removed / repurposed.
> The Datetime fields to be stored in UTC! The datetime fields when its fetched
> from the DB it is UTC, so it needs to be converted to the proper tenant
> timezone if there is any business logic attached to them.
>
> Storing in UTC is important to avoid daylight savings and "incorrect timezone
> is used" issues:
> - Some places the tenant timezone used
> - Som places the system timezone used
>
> *Acceptance criteria*
> * Every custom fields with similar purpose to be decommissioned
> * All datetime field to be utc
> * It must be a backward-compatible change!
> ** Column cannot be removed!
> *Change proposal*
> * created_on_utc: Timezone aware datetime field
> * last_modified_on_utc: Timezone aware datetime field
> * created_by: Long (AppUser id)
> * last_modified_by: Lond (AppUser id)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
