open-contracting / credere-backend Goto Github PK

The staging server uses 15.

When a FI or OCP user logs into Credere, I want to be able to track all of the actions the user makes, so that we have a full audit trail for MSME and FI user actions, so that we can more easily address issues if they arise. For example:

• Which user added or updated data
• Which user verified information X
• Which user approved/rejected application Y
• Is processing of an application overdue Y/N

When I log into Credere as an OCP admin, I want to be able to see all of the live applications made to the different FIs, so that I can support the application process.

• Table view with information for: MSME name, Buyer name, submission date, stage, credit provider and actions
• User to be able to sort columns (highest to lowest, lowest to highest, A-Z, Z-A), bar the actions one

https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=443-3219&t=ZGzh5x7zMAwvmP8g-4

When I click on the email sent to me prompting to create my account, I want to be able to set a secure password so that my account is safe.

• FI users to set a secure password themselves following the password requirements in the UI design
• Include error messages for
• Your chosen password does not meet the security requirements. Try again
• Your passwords do not match. Try again
• FI user to receive a confirmation message in UI that password has been set, but also by email

https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=195-1959&t=ZGzh5x7zMAwvmP8g-4
https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=559-3795&t=ZGzh5x7zMAwvmP8g-4
https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=560-3617&t=ZGzh5x7zMAwvmP8g-4
https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=562-3688&t=ZGzh5x7zMAwvmP8g-4
https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=563-3818&t=ZGzh5x7zMAwvmP8g-4

• #31
• #32
• #33
• #34
• #35
• #36
• Provide information not in OCDS
• SME option to change email
• Submission complete feedback
• Email notifications to update on progress
• Reminder to complete application
• #107
• Contact email and phone number
• Frequently asked questions
• #108

adrian-personal

Other clean up:

• www.google.com also used as a temporary URL.
• print() statements.

When an email was not possible to deliver to an MSME (e.g. the initial onboarding email), I want to be able to access this information via the service that we use to send the email so that we can keep track of which MSMEs that did not respond to the access to credit scheme was due to them not receiving the email.

When the Credere tool is launched, I want to monitor a number of different KPI so that I can measure the impact of the access to credit scheme and also ensure that no applications are getting missed.

• KPIs to be for all time with the option for OCP admin to select a time period using a calendar feature
• MSME opt-in statistics:
• Number of MSMEs opting into the scheme
• Proportion of MSMEs contacted opting into the scheme (%)
• Proportion of MSMEs opting into the scheme by sector (pie chart)
• Breakdown of reasons MSMEs opted-out (bar chart)
• Application KPIs (per FI and overall)
• Number of applications received
• Proportion of MSMEs that submitted applications (out of the ones who opted into the scheme)
• Number of applications in progress
• Number of applications waiting on MSME for information
• Number of applications approved
• Number of applications rejected
• Number of approved applications with credit disbursed
• Proportion of approved applications with credit disbursed (%)
• Number of applications overdue
• Average time taken to complete an application
• Average amount of credit requested by MSMEs (per FI and overall)
• Average repayment period requested by MSMEs (per FI and overall)
• Breakdown of FIs chosen by MSMEs (bar chart)

https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=442-2768&t=ZGzh5x7zMAwvmP8g-4

When I have been given an award, I want to automatically receive a notification for access to the credit scheme, so I can accept or reject the offer.

• Email notifications to only be sent to companies that have won an award in SECOP
• Companies must be registered as SMEs in SECOP

https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=109-4252&t=ZGzh5x7zMAwvmP8g-4
https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=621-3999&t=ZGzh5x7zMAwvmP8g-4

When I receive an email notification for the access to credit scheme, I want the option to opt-out so that I am not contacted in the future.

• Opt-out user journey includes a request for feedback on why they declined the offer for access to credit
• User journey to clarify if opt-out is for this award or for all time
• MSMEs that select opt-out be removed from the mailing list as per their request (all time / this award)
• No personal data for the MSME opting out is to be collected - we only want a count of MSMEs that opted out, feedback forms completed and reasons (see Figma UI design) for opting out as per the feedback form. Instead, we will store the identifier for the MSME so as not to “forget” they have opted out

https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=109-4252&t=ZGzh5x7zMAwvmP8g-4
https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=621-3999&t=ZGzh5x7zMAwvmP8g-4

When I input the data for how much credit I require, the repayment term and repayment start date, I want to receive multiple options for credit by different FIs that are part of the scheme, so that I can compare the costs.

• UI is designed so that MSMEs can compare the different options
• User only allowed to select and apply for one option
• Calculation for each option are based on a set of rules to be agreed with each FI and set up in the system by a OCP admin
• The calculator is to update when a user inputs or changes data in any of the fields and clicks the submit button.

Using the SDK for python, include endpoints to allow the features described in #3 and #17
That includes login, logout, recover password and set initial password to activate account.

When I am processing an MSME application in Credere, I want to be able to review information and documents provided by the MSME manually, opening documents to review them, emailing MSMEs directly if there are any issues and mark in the system that everything has been manually verified so that the FI I work for can be confident that the process has been followed correctly.

• User to be able to click a link to open a message box in the tool
• Verify each data field individually using toggle switch
• User is not allowed to proceed if one or more toggle switches are set to ‘No’

https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=107-108&t=ZGzh5x7zMAwvmP8g-4
https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=558-3790&t=ZGzh5x7zMAwvmP8g-4
https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=558-3789&t=ZGzh5x7zMAwvmP8g-4

When I am processing an MSME application in Credere, I want to be able to view past public sector contracts that the MSME was awarded and fulfilled along with the contract value amount, so that I can increase my confidence in the MSME’s ability to fulfil the contract. Include OCDS fields:

• tender/title
• buyer/name
• contract/period/startDate
• contract/period/endDate
• contract/valueAmount in UI
• tender/status

https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=430-3577&t=ZGzh5x7zMAwvmP8g-4

When the Credere tool is launched, I want to see a high-level dashboard for opt-in statistics and application KPIs for different FIs and to be able to easily navigate to the table with submitted applications and settings screens.

• Navigation via buttons on the top right of the screen

https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=442-2768&t=ZGzh5x7zMAwvmP8g-4
https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=443-3219&t=ZGzh5x7zMAwvmP8g-4

When an MSME submits an application, I want to receive an email to notify me with a link to the login screen for Credere. so I can review any application that I want to.

• Email to be sent to a dedicated mailing list [email protected]
• As with the email sent to the FI, no information from the application is to be included in the email. The OCP user needs to log into the tool to see that information

https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=442-3117&t=ZGzh5x7zMAwvmP8g-4

When I am processing a MSME application in Credere, I want to be able to review basic information for the MSME manually, add or update information (e.g. the MSME address which might be incomplete), check any details for the MSME directly in SECOP II and mark in the system that everything has been manually verified, so that the FI I work for can be confident that the process has been followed correctly.

• Link to each MSME profile in SECOP II directly
• Verify each data field individually using toggle switch
• Fields where data is missing to have an expand feature for the user to view more information and guidance on how to proceed
• Fields where data is missing or incomplete to have the option for the user to add or edit manually
• User is not allowed to proceed if there are empty data fields
• User is not allowed to proceed if one or more toggle switches are set to ‘No’

https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=105-581&t=ZGzh5x7zMAwvmP8g-4
https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=159-1667&t=ZGzh5x7zMAwvmP8g-4
https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=161-1949&t=ZGzh5x7zMAwvmP8g-4

When an MSME submits an application, I want to securely log into the Credere UI with a username and password so that I can view applications made to different FIs and support the application process by making updates to missing and incomplete data by checking in SECOP.

• Different user groups and permissions to the FIs

https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=442-3077&t=ZGzh5x7zMAwvmP8g-4

These are the templates to implement as plain HTML to configure SES with them.
SES Docs > https://docs.aws.amazon.com/ses/latest/dg/send-personalized-email-api.html
The images in the email should be uploaded in the S3 public bucket. They should also be stored in the repo.

Template designs

• New application OCP admin: https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=442-3117&t=ZGzh5x7zMAwvmP8g-4
• Overdue application OCP admin: https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=472-3181&t=ZGzh5x7zMAwvmP8g-4
• New application FI user: https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=424-2388&t=ZGzh5x7zMAwvmP8g-4
• Overdue application FI: https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=440-2492&t=ZGzh5x7zMAwvmP8g-4
• * New Account Created: https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=559-3795&t=ZGzh5x7zMAwvmP8g-4

New templates

• Intro MSME: https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=109-4252&t=QGR0qFQ8sCalhTlO-4
• Intro responsive https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=621-3999&t=QGR0qFQ8sCalhTlO-4
• Intro MSME reminder: https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=159-937&t=QGR0qFQ8sCalhTlO-4
• Complete app reminder MSME: https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=159-1064&t=QGR0qFQ8sCalhTlO-4
• Contract upload confirmation: https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=423-2335&t=QGR0qFQ8sCalhTlO-4
• Change Email MSME: https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=375-2674&t=QGR0qFQ8sCalhTlO-4
• Submission completed: https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=466-3093&t=QGR0qFQ8sCalhTlO-4
• Application Aproved: https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=199-1619&t=QGR0qFQ8sCalhTlO-4
• Upload contract: https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=422-2110&t=QGR0qFQ8sCalhTlO-4
• Application declined: https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=201-1723&t=QGR0qFQ8sCalhTlO-4

When I select ‘edit’ for an existing FI, I want to be able to edit specific settings that may be requested by the FI. The previously inputted data needs to be visible for me to edit.

• Change FI name as it appears to the MSME
• Change FI type (options are: Commercial Bank, FinTech, Government Bank)
• Size of MSMEs FI is willing to lend to (options are: Micro, Small, Medium)
• Range of credit amounts for different sizes of SMEs (only appears of the size of MSME is selected)
• Change the values for the calculator rules for an FI
• SLA agreement i.e. time frame agreed to process and application
• SLA time frame to disburse funds after contract uploaded by MSME

https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=447-2666&t=ZGzh5x7zMAwvmP8g-4
https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=448-2816&t=ZGzh5x7zMAwvmP8g-4

When I have completed all of the checks for the MSME credit application, I want to be able to review the conditions for the credit being offered and come back to the tool once we have completed our own compliance checks internally and update the Credere system with a report and additional comments.

• User to select ‘Approve’ or ‘Reject’ for the application for the process to be marked as such
• Request FI to provide reason for rejecting application via pop up feedback box
• Provide feedback to the FI that their decision has been recorded (approved/rejected)
• Approve action to trigger an email to the user congratulating them and with next steps i.e. get contract signed
• Reject action to trigger an email to the user informing them

https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=107-876&t=ZGzh5x7zMAwvmP8g-4
https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=440-2541&t=ZGzh5x7zMAwvmP8g-4
https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=159-1187&t=ZGzh5x7zMAwvmP8g-4
https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=202-1766&t=ZGzh5x7zMAwvmP8g-4

When I opt-in for the access to credit scheme via the email notification, I want to be taken to the screen via a unique temporary link, so that I can start my personalized application with details of the specific award that I have won populated in the tool.

• A link is for each MSME award i.e., if an MSME wins 3 awards, they receive three different links
• Link to expire after a certain period of time of not used (time limit TBD)
• Link can not be reused after an application to a bank has been submitted
• Add some content to explain to MSMEs that they can only use the link for a set period of time e.g. 1 week
• #62

Implement the mapping using the modeling in #37

For after the MVP, If an email is not found when getting the MSME information, OCP admins should be notified and allowed to provide the email manually (e.g., by looking at documents or other sources). After this, Credere should try to contact the MSME using that email.

For the MVP, we can log that the email was not found as a warning.

When a MSME application is overdue (i.e. time has gone over the SLA), I want the FI to be emailed automatically and the OCP group mailbox to be copied in, so that we are all aware of the situation and can work together to prioritise the particular application.

• User to send an email through Credere so that the application can automatically be marked as ‘Awaiting information from MSME’
• SLA for time taken to complete the application to be paused until the MSME responds
• Time taken to complete the application tracking to be resumed once information from MSME has been updated on the system
• Manual workaround for information from MSME email to be added to the system. OCP admins to be vigilant of this and not leave to the FI if they see an email first

https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=472-3181&t=ZGzh5x7zMAwvmP8g-4

When I am processing an MSME application in Credere, I want to be able to see if an application is from an existing business banking customer, so that I can take this into account when processing the application as it will be a different process for MSMEs who are not existing customers.
FI can verify the MSME is an existing customer using the bank certification document

When I input the data for how much credit I require and the repayment term, I want to be told if the values I have entered are valid, so that I can easily correct them and stay within the limits for what can be offered to my business.

• Validation needs to be one rule for all FIs, otherwise the design will not work at all
• Add content in the UI describing limits for what the user can input
• Include field validation for fields showing errors
• Add option for MSME to select what size of company they are (natural person, micro, small or medium) for relevant credit options
• Add a question for the MSME’s sector → does this impact the credit offered? Can we get from SECOP?
• Pre-populate the fields with data to get the user started and also to automatically provide credit options in the table
  • Credit amount → add 90% of award value
  • Repayment terms → add 1 year, 0 months
  • Repayment start date → add 1 month from contract start date

When I select ‘add new credit provider’ I want the form to appear for me to provide the following data to set up a new FI on the system.

• FI name as it is to appear to MSME in the tool
• FI type (options are: Commercial Bank, FinTech, Government Bank)
• Size of MSMEs FI is willing to lend to (options are: Micro, Small, Medium)
• Range of credit amounts for different sizes of SMEs (only appears of the size of MSME is selected)
• Change the values for the calculator rules for an FI
• SLA agreement i.e. time frame agreed to process and application
• SLA time frame to disburse funds after contract uploaded by MSME

https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=447-2666&t=ZGzh5x7zMAwvmP8g-4
https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=448-2816&t=ZGzh5x7zMAwvmP8g-4

Consider this issue setting up an env variable with the default value en if not defined.
Refactor register and forgot-password endpoints to use this utility.

When I am processing an MSME application in Credere, I want to be able to review data from OCDS for the specific award, add or update information that may be incomplete or missing by checking in SECOP II before proceeding so that the FI I work for can be confident that the process has been followed correctly.

• Link to each award in SECOP II directly
• Fields where data is missing to have an expand feature for the user to view more information and guidance on how to proceed
• Fields where data is missing or incomplete to have the option for the user to add or edit manually
• No verification toggle switch for this stage of the process

https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=107-364&t=ZGzh5x7zMAwvmP8g-4

• #16
• #17
• #18
• #19
• #20
• #21
• #22
• #23
• #24
• #25
• #26
• #27
• #28
• #29

When I log into the Credere UI, I want to see high-level data for where we are with the applications submitted to us only so that I can see how well we are processing applications and if there are any issues.

1. Number of applications received
2. Number of applications in progress
3. Number of applications approved
4. Number of applications rejected
5. Number of approved applications with credit disbursed
6. Proportion of approved applications with credit disbursed (%)
7. Number of applications overdue
8. Average time taken to complete an application (business days)
9. Proportion of MSMEs choosing out of all possible credit providers (%)
10. Average amount of credit requested by MSMEs
11. Average repayment period requested by MSMEs
12. Applications waiting on the MSME for information

https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=104-51&t=ZGzh5x7zMAwvmP8g-4

• #2
• #3
• #4
• #5
• #6
• #7
• #8
• #9
• #10
• #11
• #12
• #13
• #14

When I receive an email notification for the access to credit scheme, I want to be able to view the terms and conditions and privacy policy information, so I can view the finer details of the scheme and how my data is managed.

• Provide a link to a terms and conditions document online
• Provide a link to a privacy policy document online
• These documents need to be for the Credere tool covering all FIs who partner with us for the tool
• Mandatory checkboxes for users to tick before continuing

Design TBD

When I am processing a MSME application in Credere, I want to be able to review a summary of all of the data before proceeding to the decision stage of the process, so that I can double check that there are no issues and go back to previous stages if there are.

• User to easily go back to specific stages of the application approval process if an issue is found i.e. multiple ‘Go back to…’ buttons after each section
• User to be able to open documents in this section to review again instead of having to go back

https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=107-620&t=ZGzh5x7zMAwvmP8g-4

Frontend

Framework UI https://react.dev/
Development build https://vitejs.dev/
Components library definition https://storybook.js.org/
UI Components Options:

• Material UI https://mui.com/

Backend

FastAPI https://fastapi.tiangolo.com/lo/
ORM https://sqlmodel.tiangolo.com/
Database: Postgres
Cognito SDK https://docs.aws.amazon.com/code-library/latest/ug/python_3_cognito-identity-provider_code_examples.html
Scheduled processes https://typer.tiangolo.com/
AWS SES (emails) https://docs.aws.amazon.com/code-library/latest/ug/python_3_ses_code_examples.html
Test Library https://www.starlette.io/testclient/

When I log into the Credere UI, I want to see a list of all of the MSME applications made to my organization, so that I can get an overview of how many applications need processing to be completed, when they were submitted, which stage they are at and who is processing it.

• User can also go into the application to view or continue processing it
• Application processing is not tied to the user that started to process it
• User can ONLY see applications that belong to their FI
• User also able to download the application (we need to clarify this with FIs)
• User can sort columns as per UI design

https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=104-51&t=ZGzh5x7zMAwvmP8g-4

When a MSME application is submitted, I want to be able to review and update missing data, but not have any rights to approve applications, so that the FI knows that only their own team members with the appropriate permissions can do this.

• Create a ‘role’ for OCP admins
• View and update actions in application table
• Only applications at the stages: ‘not started’, ‘in progress’ and ‘waiting for MSME’ can be updated by OCP admins
• Approved applications can only be viewed
• Completed applications can only be viewed one week after completion

https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=443-3219&t=ZGzh5x7zMAwvmP8g-4

When I log into Credere as an OCP admin, I want to be able to see all of the FIs set up in the system, to be able to edit the settings for an existing FI and to be able to add a new FI so that this does not have to be done in the code.

• Actions on this screen are edit (existing FI) and add new FI

https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=447-2666&t=ZGzh5x7zMAwvmP8g-4
https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=448-2816&t=ZGzh5x7zMAwvmP8g-4

The document proposed
https://docs.google.com/document/d/1Vs8eAexAs4havMabmg3UdjQbWro4CJ2q0rgdAVyBmAg/edit?usp=sharing

When an MSME submits an application, I want to receive an email to notify me with a link to the login screen for Credere. so I can start to process the application.

• Email to be sent to a group email address for the FI selected by the MSME
• No data for the MSME or their application to be included in the email content
• Team at FI to arrange themselves how the application is processed
• Send overdue reminder if past SLA time frame

https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=424-2388&t=ZGzh5x7zMAwvmP8g-4
https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=440-2492&t=ZGzh5x7zMAwvmP8g-4

When an MSME submits an application, I want to securely log into the Credere UI with a username and password so that I can process the application.

• Each individual user from FIs and OCP admins to have their own username and password i.e. no group accounts, so that we can track every action to an individual
• Accounts to be created manually by the OCP tech team, and the tool will send an email to the FI user with a link to set their password
• FI users to reset their password themselves if forgotten
• Group email address is NOT to be an account in Credere, as it should only be used to send emails to the team at the FI

https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=195-1959&t=ZGzh5x7zMAwvmP8g-4

When an application process is completed i.e. funds have been disbursed to the MSME by the FI, I want the data for the application to only be viewable for one week after the completion date-time, so that this personal data is not stored by the OCP long term.

• We still want to keep the metadata that is required for the FI and OCP dashboard, but this should not mean we need to store personal data

https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=443-3219&t=ZGzh5x7zMAwvmP8g-4

This issue is for documenting the updated application workflow after a few changes that OCP made, which are:

• Added transition from Pending to Lapsed.
• Removed Cancelled state. Instead, add an archived_at TIMESTAMP column. This is to preserve the state value.
• Removed Rejected to Submitted transition. Instead, if there are still credit options available, create a new application for the MSME (pre-populating fields if possible).
• Added “FI clicks Start” label for the transition from Submitted to Started.

The new workflow, therefore, looks like this:

Create a client for the APIs described in the document.
Use the Client to get the data and save it to the contracts and borrower database tables.
New contracts not obtained since the last time the process ran should be fetched (the last time should be the most recent creation date in the contracts table).
In case of incomplete data, notify the error through Sentry (indicate all the data of the Award/MSME to be able to identify them), and data should not be inserted if the MSME email is unavailable.
For each new contract successfully obtained, a process (dummy) must be called to create the application and send the email to the MSME.
The hashed fields to anonymously identify the Awards and MSME are indicated in here
Consider the states in #37
The process must be callable from a CRON job at the operating system level.

Configure the repository to start development with the defined architecture in #38
Must include Black for code formatting.

Docs

Update the README of the project with steps to setup the development environment. Also propose a convention to endpoint naming.

Version

Define a strategy (could be a constant in the code) to track the current version of the endpoint.
The versioning will be with the form X.Y.Z where will set initially X to 0, Y to the current sprint, and Z to bug fixes patches, set to 0 for first release of the sprint.

• Include an endpoint that returns the version of the API, with a test for that endpoint

Integrate Sentry to the backend project
https://docs.sentry.io/platforms/python/guides/fastapi/

When I log into the Credere UI, I want to see a list of all of the MSME applications made and the different stages that they are at so that I can prioritize applications accordingly.
Stages as follows:

• Submitted - the application has been received but processing by a team member has verified 0 pieces of data (includes if an OCP team member has made updates to missing data)
• In progress - FI team member has verified 1+ piece of data, but is not waiting for a response from the MSME
• Awaiting information - a FI team member has sent an email through the Credere system and not yet received a response
• Approved - a team member at the FI has approved the MSME’s application for credit
• Rejected - a team member at the FI has rejected the MSME’s application for credit
• Contract uploaded - the MSME has uploaded their signed contract
• Completed - the FI has marked the application as closed after funds disbursed

https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=104-51&t=ZGzh5x7zMAwvmP8g-4

When the MSME uploads the signed contract with the buyer, I want to receive an email notification that this has happened and review the contract in Credere, so that I can see for myself that the MSME has definitely secured the work and what the contract value is before disbursing the funds.

• No specific details about the MSME or contract information to be in the email notification
• FI user can download the contract from the Credere UI and click on a link to view in SECOP IF available
• The contract amount can be different to a the award amount and so the FI can change the amount of credit offered to the MSME
• FI to close the loop and complete the application by clicking “Credit ready”
• FI to have the option to download the application

https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=430-3390&t=ZGzh5x7zMAwvmP8g-4
https://www.figma.com/file/mQqkGtTfNEBdfk4QdfNYIO/OCP-Data-Registry-Design?type=design&node-id=430-3457&t=ZGzh5x7zMAwvmP8g-4