Substitute Service Website

Purpose and background of request 【Overview】 We provide substitute services for grant application to business owners. For business owners, the subsidy is a non-routine task, and there are many cases where you do not know what is completed, when you plan to deposit money and what is in progress. I would like to build a site where the employer logs in, the subsidy for which the application has been completed, and the subsidy in progress can be grasped in the list. 【Feature】 There are cases where multiple projects run in parallel with one employer for a grant Many projects take about one year from plan submission to application and payment 【screen】 1) Login screen 2) Proposal screen (images to switch 2a, 2b with tabs) Message to customers 2a) Application completion grant list 2b) Ongoing grant list 【Main requirement】 • Issue ID, PW for each customer • Periodically spew out CSV with all information covered from in-house system • Acquire the above CSV in the system to be constructed this time • Allow messages to be displayed Message common to the whole company: communication of new grant, etc. Message to specific customers: Please prepare XX documents as soon as possible! ,etc The URL can also be posted in the message, so that it can fly to the external link 【Main items】 • Partner name (※ after login, it is unnecessary for details) • Grant name • Scheduled grant amount (※ tentative planned amount) • Remarks (※ Subject name etc. of grant) • Plan submission date • Application deadline date • Application actual date • Grant application amount (※ amount of actual application) • Scheduled deposit date • Compensation paid flag (※ Whether paid fee to us) • Abort flag (It is given when it is aborted halfway) • Hold flag (Granted when holding on hold ※) • Cancellation / withholding remarks • Update date As an image, information like entering one Excel sheet For each logged-in customer, we assume a system that displays only the customer. 【Supplement】 Functionally it is not supposed to be something very complicated, It is something that customers will see directly, so it will be helpful if you give your designs too much attention.