Tables

Table containing the different assessment types that can be assigned to an assessment

Table to store project information data

Table containing list of application email_records

Table containing the Template 9 Data as submitted by the applicant

Table containing data for the gis assessment hh numbers

Table containing the SoW data for the given application

Table to hold RFI form data

Table to pair an application to form data

Table containing the different statuses that can be assigned to an application

This is a type used to return records of history data in the application_history computed column

Table containing the data about the project dependencies

Table to hold counter for creating gapless sequences

Table containing the claims excel data for the given application

Table containing list of analysts

Table containing the communities data for a CBC project

Table containing intake numbers and their respective open and closing dates

Table containing the pending change request details of the application

Table containing the gcpe report data

Table to hold the announcement data

Table containing the milestone excel data for the given application

Table containing the communities source data imported from CBC projects excel file

Table containing the internal description for the given application

Table for tracking history records on tables that auditing is enabled on

Table containing the json data for cbc applications

Table containing information about uploaded attachments

Table containing information about the application’s users, this is business contact information not personally identifiable information

Table containing the data imported from the CBC projects excel file, by rows

Table containing the data associated with the CCBC respondents application

The statuses applicable to an RFI

Table containing the analyst lead for the given application

The statuses applicable to a form

Table containing the milestone data for the given application

Table to store change request data

Table containing the reasons for changes to cbc_data

Table to store conditional approval data

Table containing the Community Report excel data for the given application

Table containing if the application has been announced by BC or ISED

Table containing the data imported from the CBC projects excel file

Table containing the detailed budget data for the given SoW

Table containing information about possible application statuses

Table to pair an application to RFI data

Table to hold the json_schema for forms

Table containing the pending change request details of the application

Table to pair an application to RFI data

Table containing the different types of forms used in the application

Table containing the project type of the application

Table containing the Community Progress Report data for the given application

Table containing the uploaded GIS data in JSON format

Table containing the detailed budget data for the given SoW

Table containing the claims data for the given application

Table containing list of application notifications

Table containing the package the application is assigned to

Table to hold applicant form data