Identify Required Mapping fields for Reporting comparing provided Report samples

bcgov / foi-flow

Freedom of Information modernization

Apache License 2.0

5 stars 3 forks source link

Identify Required Mapping fields for Reporting comparing provided Report samples #1250

Closed abin-aot closed 2 years ago

abin-aot commented 2 years ago

Title of ticket:

Description

The purpose of this task is to cross reference the the Data Mapping done on Task #1247 and Reporting samples provided. Also, discuss with SME team with various options , existing gaps(if any) and Futuristic asks for MoM, YoY reporting

Dependencies

Are there any dependencies?

DOD

[x] Create Mapping between Reports(available vs Jackie's UR) and columns/fields in identified
[x] Make sure, Relations found is good for EDW Design, which is followed by this task
[ ] Field confirmation via IMB : moving this DOD to #1348
[ ]
[ ]

abin-aot commented 2 years ago

https://app.zenhub.com/files/358004325/abea4a78-672c-493a-9855-a6f62d86020a/download

abin-aot commented 2 years ago

These are report template samples we referred https://app.zenhub.com/files/358004325/34f6af70-d0e2-46ec-9c40-d776cf633dd6/download . Since these report templates only have fields and not DATA. We are thinking to review the existing extract logic used to create existing reports - so that we can be double sure on exact source data column from axis. @m-prodan is coordinating this IMB (Alexander)

mpilchar commented 2 years ago

@m-prodan I have also added this as a task in our IMB excel sheet - as their PO requested we track all requests of their team in one spot for easier management: https://bcgov.sharepoint.com/:x:/t/00192-FOIModernizationTeamandIMBTeamCommunication/EfYTNgmQZHhPm6JXQNRWtjgBwHB99Zcg3bH9DXrO-klgdw?e=b340OU

abin-aot commented 2 years ago

@mpilchar @m-prodan @lmullane @arielleandrews , we(myself and @VineetBala-AOT ) is moving the last DOD of this task - "field confirmation on report", to a separate task with estimate of 5. since we haven't received that information from them yet(as per above comments). But we can reduce the estimate on this task to 8 from 13. New task created : #1348, reduced estimate to 8

mpilchar commented 2 years ago

Makes sense, thanks @abin-aot ! There might be a question for us in here about how we can manage external dependencies so they don't impact team velocity - retro fodder!