Versions Compared

Old Version 15

changes.mady.by.user Rémi Aubin

Saved on

compared with

New Version 16

changes.mady.by.user Rémi Aubin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Targeted Environments

...

  • Business Layer changes

    • AddressManager - Enhancement to the GetAllSubdivisions method

    • ApplicationCatalog - Enhancement to the GetByApiKey method

    • ServiceManager - New method GetServiceStandards to get service standards by service id

    • ServiceRequestManager - new methods to add/remove multiple user assignments

      • AddMultipleUserAssignments

      • RemoveMultipleUserAssignments

  • Domain objects changes

    • New properties added to ApplicationDTO

      • ApplicationCode

      • EnglishName

      • FrenchName

      • Name property became obsolete

    • New dto MultipleServiceRequestUserAssignmentCreationDto to support multiple user assignments

    • Added StatusHistory property to the ServiceRequestDTO

    • New properties added to the ServiceRequestQueryDTO

      • ServiceRequests

      • IncludeStatusHistory

    • New properties added to the Application business object

      • ApplicationCode

      • EnglishName

      • FrenchName

      • Name property became obsolete

    • New DateRange business object

    • Updated the MtapiStatusCode to include new error codes

    • New OrderByType business object

    • Added ApplicationCode property to the ServiceInfo business object

    • Added StatusHistoryproperty to the ServiceRequest business object

    • Added new properties to the ServiceRequestQuery business object

      • ServiceRequests

      • Services

      • IncludeStatusHistory

    • New ServiceStandard business object

  • Data Access Layer changes

    • Enhancements to the data repositories

    • Changes to database entities

Breaking change 
N/A

MTOA Database – Release Note for Version (v2.0.0 and v2.0.1)

Schema Structure Changes

Note: highlighted rows are patches identified in v2.0.1.

Table

Column

Comments

AC060_APPLICATION

New table

AC061_APPLICATION_SERVICE

New table

AC062_PERMISSION_SET

New table (to be used in a later phase)

AC063_APPLICATION_PERMISSION_SET

New table (to be used in a later phase)

AC064_APPLICATION_PERMISSION

New table (to be used in a later phase)

AC200_ACCOUNT

New table (to be used in a later phase)

AC203_ACCOUNT_APPLICATION_PERMISSION_SET

New table (partial implementation in Phase 1)

TC208_NOTIFICATION_TEMPLATE

TEMPLATE_BODY_ETXT

Datatype changed from VARCHAR2(4000 Byte) to CLOB

TEMPLATE_BODY_FTXT

Datatype changed from VARCHAR2(4000 Byte) to CLOB

TC208_AC060_FK

Foreign key to Application table removed

YY206_NOTIFICATION

NOTIFICATION_ETXT

Datatype changed from VARCHAR2(4000 Byte) to CLOB

NOTIFICATION_FTXT

Datatype changed from VARCHAR2(4000 Byte) to CLOB

AC043_ORGANIZATION_STAKEHOLDER

SVMMS_MANUFACTURER_ID

New column to be used in later phase

...

Table

Comments

 

AC207_SERVICE_REQUEST_STATUS

Records added to AP services 236 and 237 to support Service Standard Id '0' to the current standard Ids 50, 51 and 52.

Note that the added records for the Service Standard '0' will have the categorization set to OFF.

AC060_APPLICATION

API key duplicates corrected.