MDMS Changes
Overview
The following MDMS changes were done as part of the FSM v1.4 release:
MDMS Changes
Feature | Service name | Changes | Description |
---|---|---|---|
PQM inbox | MDMS for inbox | Added MDMS configuration for inbox-v2 integration. | |
Role Action | MDMS | Added role-action mapping for all APIs of the PQM service. |
For MDMS-V2 changes, refer to the below table for the sequence in which MDMS schema and data needs to be added for the PQM service:
MasterName | Schema Link | Required Fields | Unique Fields |
---|---|---|---|
PQM.BenchmarkRule | id, code, name | code | |
PQM.QualityTestLab | code | code | |
PQM.Material | code, name | code | |
PQM.Parameter | code, name | code | |
PQM.PlantConfig | code, pendingTestsToDisplayWithinDays, pendingTestsToDisplayWithinDaysInbox, pendingTestsToDisplayWithinDaysForULB, iotAnomalyDetectionDays, manualTestPendingEscalationDays | code | |
PQM.PlantType | code, name | code | |
PQM.ProcessType | code, name | code | |
PQM.Unit | code, name | code | |
PQM.WasteType | code, name | code | |
PQM.SourceType | code, name | code | |
PQM.Stage | code, name, output | code | |
PQM.Process | code, type, name, stages, wasteType | code | |
PQM.Plant | code, plantType, active | code | |
PQM.QualityCriteria | code, name, plantType, wasteType, address, processes | code | |
PQM.TestStandard | code, plant, process, stage, material, qualityCriteria, frequency, sourceType | code |
UI-Related MDMS Files
Make sure TQM and FSM is enabled in this master -> cityModule.json
data/pg/common-masters/howItWorks.json -> HowItWorks
data/pg/FSM/SanitationWorkerSkills.json -> SanitationWorkerSkills
data/pg/FSM/SanitationWorkerEmploymentType.json -> File Link
data/pg/FSM/SanitationWorkerEmployer.json -> File Link
data/pg/FSM/SanitationWorkerFunctionalRoles.json -> File Link
Role-Action Mapping
data/pg/ACCESSCONTROL-ACTIONS-TEST/actions-test.json
{
"id": 346,
"name": "schema Create",
"url": "/mdms-v2/schema/v1/_create",
"parentModule": "",
"displayName": "Schema Create",
"orderNumber": 0,
"enabled": false,
"serviceCode": "",
"code": "null",
"path": ""
},
{
"id": 357,
"name": "Search PQM Application",
"url": "/mdms-v2/schema/v1/_search",
"displayName": "Search MDMS Schema",
"orderNumber": 0,
"enabled": false,
"serviceCode": "PQM",
"code": "null",
"path": ""
}
{
"id": 347,
"name": "MDMS",
"url": "/mdms-v2/v2/_create/PQM.SourceType",
"parentModule": "",
"displayName": "Add Data for PQM.SourceType",
"orderNumber": 0,
"enabled": false,
"serviceCode": "",
"code": "null",
"path": ""
},
{
"id": 201,
"name": "MDMS",
"url": "url",
"displayName": "Manage PQM Labs",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=PQM&masterName=QualityTestLab",
"path": "9MDMS.PQM.QualityTestLab",
"leftIcon": "dynamic:ContractIcon"
},
{
"id": 202,
"name": "MDMS",
"url": "/mdms-v2/v2/_create/PQM.QualityTestLab",
"displayName": "create PQM.QualityTestLab",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 203,
"name": "MDMS",
"url": "/mdms-v2/v2/_update/PQM.QualityTestLab",
"displayName": "Update PQM.QualityTestLab",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 204,
"name": "MDMS",
"url": "url",
"displayName": "Manage PQM BenchmarkRule",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=PQM&masterName=BenchmarkRule",
"path": "9MDMS.PQM.BenchmarkRule",
"leftIcon": "dynamic:ContractIcon"
},
{
"id": 205,
"name": "MDMS",
"url": "/mdms-v2/v2/_create/PQM.BenchmarkRule",
"displayName": "create PQM.BenchmarkRule",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 206,
"name": "MDMS",
"url": "/mdms-v2/v2/_update/PQM.BenchmarkRule",
"displayName": "Update PQM.BenchmarkRule",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 207,
"name": "MDMS",
"url": "url",
"displayName": "Manage PQM Material",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=PQM&masterName=Material",
"path": "9MDMS.PQM.Material",
"leftIcon": "dynamic:ContractIcon"
},
{
"id": 208,
"name": "MDMS",
"url": "/mdms-v2/v2/_create/PQM.Material",
"displayName": "create PQM.Material",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 209,
"name": "MDMS",
"url": "/mdms-v2/v2/_update/PQM.Material",
"displayName": "Update PQM.Material",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 210,
"name": "MDMS",
"url": "url",
"displayName": "Manage PQM Unit",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=PQM&masterName=Unit",
"path": "9MDMS.PQM.Unit",
"leftIcon": "dynamic:ContractIcon"
},
{
"id": 211,
"name": "MDMS",
"url": "/mdms-v2/v2/_create/PQM.Unit",
"displayName": "create PQM.Unit",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 212,
"name": "MDMS",
"url": "/mdms-v2/v2/_update/PQM.Unit",
"displayName": "Update PQM.Unit",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 213,
"name": "MDMS",
"url": "url",
"displayName": "Manage PQM TestType",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=PQM&masterName=TestType",
"path": "9MDMS.PQM.TestType",
"leftIcon": "dynamic:ContractIcon"
},
{
"id": 214,
"name": "MDMS",
"url": "/mdms-v2/v2/_create/PQM.TestType",
"displayName": "create PQM.TestType",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 215,
"name": "MDMS",
"url": "/mdms-v2/v2/_update/PQM.TestType",
"displayName": "Update PQM.TestType",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 216,
"name": "MDMS",
"url": "url",
"displayName": "Manage PQM Plant",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=PQM&masterName=Plant",
"path": "9MDMS.PQM.Plant",
"leftIcon": "dynamic:ContractIcon"
},
{
"id": 217,
"name": "MDMS",
"url": "/mdms-v2/v2/_create/PQM.Plant",
"displayName": "create PQM.Plant",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 218,
"name": "MDMS",
"url": "/mdms-v2/v2/_update/PQM.Plant",
"displayName": "Update PQM.Plant",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 219,
"name": "MDMS",
"url": "url",
"displayName": "Manage PQM PlantType",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=PQM&masterName=PlantType",
"path": "9MDMS.PQM.PlantType",
"leftIcon": "dynamic:ContractIcon"
},
{
"id": 220,
"name": "MDMS",
"url": "/mdms-v2/v2/_create/PQM.PlantType",
"displayName": "create PQM.PlantType",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 221,
"name": "MDMS",
"url": "/mdms-v2/v2/_update/PQM.PlantType",
"displayName": "Update PQM.PlantType",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 222,
"name": "MDMS",
"url": "url",
"displayName": "Manage PQM Stage",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=PQM&masterName=Stage",
"path": "9MDMS.PQM.Stage",
"leftIcon": "dynamic:ContractIcon"
},
{
"id": 223,
"name": "MDMS",
"url": "/mdms-v2/v2/_create/PQM.Stage",
"displayName": "create PQM.Stage",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 224,
"name": "MDMS",
"url": "/mdms-v2/v2/_update/PQM.Stage",
"displayName": "Update PQM.Stage",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 225,
"name": "MDMS",
"url": "url",
"displayName": "Manage PQM TestStandard",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=PQM&masterName=TestStandard",
"path": "9MDMS.PQM.TestStandard",
"leftIcon": "dynamic:ContractIcon"
},
{
"id": 226,
"name": "MDMS",
"url": "/mdms-v2/v2/_create/PQM.TestStandard",
"displayName": "create PQM.TestStandard",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 227,
"name": "MDMS",
"url": "/mdms-v2/v2/_update/PQM.TestStandard",
"displayName": "Update PQM.TestStandard",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 228,
"name": "MDMS",
"url": "url",
"displayName": "Manage PQM QualityCriteria",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=PQM&masterName=QualityCriteria",
"path": "9MDMS.PQM.QualityCriteria",
"leftIcon": "dynamic:ContractIcon"
},
{
"id": 229,
"name": "MDMS",
"url": "/mdms-v2/v2/_create/PQM.QualityCriteria",
"displayName": "create PQM.QualityCriteria",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 230,
"name": "MDMS",
"url": "/mdms-v2/v2/_update/PQM.QualityCriteria",
"displayName": "Update PQM.QualityCriteria",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 231,
"name": "MDMS",
"url": "url",
"displayName": "Manage PQM Parameter",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=PQM&masterName=Parameter",
"path": "9MDMS.PQM.Parameter",
"leftIcon": "dynamic:ContractIcon"
},
{
"id": 232,
"name": "MDMS",
"url": "/mdms-v2/v2/_create/PQM.Parameter",
"displayName": "create PQM.Parameter",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 233,
"name": "MDMS",
"url": "/mdms-v2/v2/_update/PQM.Parameter",
"displayName": "Update PQM.Parameter",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 234,
"name": "MDMS",
"url": "url",
"displayName": "Manage PQM ProcessType",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=PQM&masterName=ProcessType",
"path": "9MDMS.PQM.ProcessType",
"leftIcon": "dynamic:ContractIcon"
},
{
"id": 235,
"name": "MDMS",
"url": "/mdms-v2/v2/_create/PQM.ProcessType",
"displayName": "create PQM.ProcessType",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 236,
"name": "MDMS",
"url": "/mdms-v2/v2/_update/PQM.ProcessType",
"displayName": "Update PQM.ProcessType",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 237,
"name": "MDMS",
"url": "url",
"displayName": "Manage PQM ProcessSubType",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=PQM&masterName=ProcessSubType",
"path": "9MDMS.PQM.ProcessSubType",
"leftIcon": "dynamic:ContractIcon"
},
{
"id": 238,
"name": "MDMS",
"url": "/mdms-v2/v2/_create/PQM.ProcessSubType",
"displayName": "create PQM.ProcessSubType",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 239,
"name": "MDMS",
"url": "/mdms-v2/v2/_update/PQM.ProcessSubType",
"displayName": "Update PQM.ProcessSubType",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 240,
"name": "MDMS",
"url": "url",
"displayName": "Manage PQM Process",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=PQM&masterName=Process",
"path": "9MDMS.PQM.Process",
"leftIcon": "dynamic:ContractIcon"
},
{
"id": 241,
"name": "MDMS",
"url": "/mdms-v2/v2/_create/PQM.Process",
"displayName": "create PQM.Process",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 242,
"name": "MDMS",
"url": "/mdms-v2/v2/_update/PQM.Process",
"displayName": "Update PQM.Process",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 243,
"name": "MDMS",
"url": "url",
"displayName": "Manage PQM PlantConfig",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=PQM&masterName=PlantConfig",
"path": "9MDMS.PQM.PlantConfig",
"leftIcon": "dynamic:ContractIcon"
},
{
"id": 244,
"name": "MDMS",
"url": "/mdms-v2/v2/_create/PQM.PlantConfig",
"displayName": "create PQM.PlantConfig",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 245,
"name": "MDMS",
"url": "/mdms-v2/v2/_update/PQM.PlantConfig",
"displayName": "Update PQM.PlantConfig",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 246,
"name": "MDMS",
"url": "url",
"displayName": "Manage PQM PlantAddress",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=PQM&masterName=PlantAddress",
"path": "9MDMS.PQM.PlantAddress",
"leftIcon": "dynamic:ContractIcon"
},
{
"id": 247,
"name": "MDMS",
"url": "/mdms-v2/v2/_create/PQM.PlantAddress",
"displayName": "create PQM.PlantAddress",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 248,
"name": "MDMS",
"url": "/mdms-v2/v2/_update/PQM.PlantAddress",
"displayName": "Update PQM.PlantAddress",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 249,
"name": "MDMS",
"url": "url",
"displayName": "Manage PQM WasteType",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"navigationURL": "/workbench-ui/employee/workbench/mdms-search-v2?moduleName=PQM&masterName=WasteType",
"path": "9MDMS.PQM.WasteType",
"leftIcon": "dynamic:ContractIcon"
},
{
"id": 250,
"name": "MDMS",
"url": "/mdms-v2/v2/_create/PQM.WasteType",
"displayName": "create PQM.WasteType",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 251,
"name": "MDMS",
"url": "/mdms-v2/v2/_update/PQM.WasteType",
"displayName": "Update PQM.WasteType",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 358,
"name": "Search PQM Application",
"url": "/mdms-v2/v2/_search",
"displayName": "Search PQM Applications",
"orderNumber": 0,
"enabled": false,
"serviceCode": "PQM",
"code": "null",
"path": ""
},
{
"id": 364,
"name": "MDMS",
"url": "/mdms-v2/v2/_create/PQM.SourceType",
"displayName": "create PQM.SourceType",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 365,
"name": "MDMS",
"url": "/mdms-v2/v2/_update/PQM.SourceType",
"displayName": "Update PQM.SourceType",
"orderNumber": 1,
"parentModule": "",
"enabled": true,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 23,
"name": "Profile Update",
"url": "/user/profile/_update",
"displayName": "Profile Update",
"orderNumber": 1,
"enabled": false,
"serviceCode": "ADMIN",
"code": "null",
"path": "Administration.Profile Update"
},
{
"id": 26,
"name": "Update Password",
"url": "/user/password/_update",
"displayName": "Update Password",
"orderNumber": 1,
"enabled": false,
"serviceCode": "ADMIN",
"code": "null",
"path": "Administration.Update Password"
},
{
"id": 370,
"name": "Create Workbench UiSchema",
"url": "/mdms-v2/v2/_create/Workbench.UISchema",
"displayName": "Create workbench ui-schema",
"orderNumber": 0,
"enabled": false,
"serviceCode": "MDMS",
"code": "null",
"path": ""
},
{
"id": 202,
"name": "Update Tenant Tenants",
"url": "/mdms-v2/v2/_update/tenant.tenants",
"displayName": "Update Tenant Tenants",
"orderNumber": 0,
"enabled": true,
"serviceCode": "PQM",
"code": "null",
"path": ""
}
data/pg/ACCESSCONTROL-ACTIONS-TEST/actions-test.json:
{
"rolecode": "MDMS_ADMIN",
"actionid": 202,
"actioncode": "",
"tenantId": "pg"
},
{
"rolecode": "MDMS_ADMIN",
"actionid": 370,
"actioncode": "",
"tenantId": "pg"
},
{
"rolecode": "MDMS_ADMIN",
"actionid": 26,
"actioncode": "",
"tenantId": "pg"
},
{
"rolecode": "PQM_ADMIN",
"actionid": 26,
"actioncode": "",
"tenantId": "pg"
},
{
"rolecode": "PQM_TP_OPERATOR",
"actionid": 26,
"actioncode": "",
"tenantId": "pg"