Type

Name

Comments

New Objects

PBI: 8318

Table

TC223TC225_SERVICEREGULATED_STANDARDENTITY_CATEGORYstores standard category used by CRSM to calculate service performanceTYPE

Part of changes for regulated entities.

Table

TC224_DELIVERY_CHANNEL

stores delivery channel used by CRSM support to provide statistics for CRSM

Table

TC016_CANADIAN_PROVINCE

A copy of CORE table which is a subset of TC006_COUNTRY_SUBDIVISION

Modified Objects

Table

AC207_SERVICE_REQUEST_STATUS

·       New column SERVICE_STANDARD_CATEGORY_CD with FK to TC223

Table

YY201_SERVICE_REQUEST

·       New column DELIVERY_CHANNEL_CD with FK to TC224

·       New column PLACE_OF_SUPPLY_CD with FK to TC016

·       Renamed column SERVICE_FEE_ID to SERVICE_ATTRIBUTE_IDTC226_REGULATED_ENTITY_ID_TYPE

Part of changes for regulated entities.

Table

TC227_SERVICE_REGULATED_ENTITY_ID_TYPE

Part of changes for regulated entities.

Table

YY213_SVC_REQUEST_REGULATED_ENTITY_VALUE

Part of changes for regulated entities.

Modified Objects

PBI: 8030

Table

WC203_WEB_API_LOG

Adding the following columns:

MACHINE_NAME_TXT

MTAPI_VERSION_TXT

MTOA_CORRELATION_ID_TXT

MTOA_USER_SESSION_ID_TXT

START_TIME

END_TIME

PBI: 8306

Table

YY206_NOTIFICATION

Adding column ERROR_MESSAGE_TXT

Making SERVICE_REQUEST_ID Nullable.

Adding column STAKEHOLDER_ID

Adding constraint YY206_AC040_FK and YY206_SR_OR_USER_CK

PBI: 8375

Table

YY201_SERVICE_REQUEST

Adding column REQUESTER_ORGANIZATION_ID and constraint YY201_AC043_FK

Dropped Objects

n/a

Service

Label

Comment

Table TC205_PERMISSION, TC206_SERVICE_PERMISSION

All Services

Refer to table content

Permissions allocated to services to support Admin Console 1.1 

Table TC204_SERVICE

n/a

Table TC222_SERVICE_SETTING

n/a