bcgov / bcgov/lcfs

LCFS - Create the Initiative Agreement (IA) database table

Open
#4,804 0 comments 0 reactions 1 assignee Claimed by @AlexZorkin View on GitHub
Initiative Agreements Medium Task
Dominant language
Python
Stars
6
Forks
6
Avg merge
2d 7h
Merged PRs (30d)
87

Description

**Describe the task**

Create the Initiative Agreement (IA) database table as the parent entity for all Initiative Agreements. The table will store agreement-level information including agreement metadata, organization relationship, agreement status, dates, and credit totals.

- **Initiative agreement**
-- Designated action
--- Evidence requirement
---- Evidence submission

**Purpose**

The Initiative Agreement table will serve as the system of record for all agreements created under section 15 of the Low Carbon Fuels Act. It provides the parent relationship for Designated Actions, Change Orders, Evidence Submissions, and future agreement management functionality. This table will be seeded with existing Excel data.

**Acceptance Criteria**

- [ ] A new Initiative Agreement database table is created.
- [ ] The table includes a unique primary key.
- [ ] The table supports association to an Organization record.
- [ ] The table supports storage of the IA code (e.g. IA-25AZU1).
- [ ] The table supports agreement status.
- [ ] The table supports entry date and agreement dates.
- [ ] The table supports project title and project summary information.
- [ ] The table supports total allocated credits.
- [ ] The table supports total issued credits.
- [ ] Created and updated audit fields are included.
- [ ] The table structure supports future Change Order and Designated Action relationships.

**Additional context**

- Initiative Agreements are the parent record for all Designated Actions.
- Agreement details are currently maintained within the IA Credit Tracker and executed agreements.
- The data structure should support both legacy P3A agreements and future-state IA agreements.

initiative_agreement
--------------------
IA_ID
Organization_ID
Contact_ID
IA_Status
IA_Name
IA_Description
Start_Date
End_Date
Total_Credits
IA_Attachment
IA_Comments
Created_Date
Created_By
Updated_Date
Updated_By

ia_id (PK)
organization_id (FK)
ia_code
agreement_type
entry_date
title
project_description
status
total_credits_allocated
total_credits_awarded
agreement_start_date
agreement_end_date
created_at
updated_at

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.