Modify the Views for Work History Cube

Log in to SQL Server Management Studio and connect to the database.
Verify the standard classification defined for event or asset criticality data.

In the Views, select MIV_MI_FAC_WORK_HSTY view, and then run the following query to check if the Event Type data matches the standard classification defined.

SELECT distinct MI_EVENT_TYP_CHR from MI_EVENT
Verify if the results match the standard event type IDs defined by the Work History cube.
If the results do not match, then modify the case statement CASE MI_EVENT_TYP_CHR in the view to display the standard event type IDs.

Example:

Suppose the distinct Event Types returned by the query run in Step 1 are Miscellaneous, Repair ,PM/PdM, and Inspection and if Inspection event in your data should be PM/PdM event, then modify the CASE statement in the View as follows:

CASE MI_EVENT_TYP_CHR

WHEN 'Miscellaneous' THEN 'Miscellaneous'

WHEN 'PM/PdM' THEN 'PM/PdM'

WHEN 'Repair' THEN 'Repair'

WHEN 'Inspection' THEN 'PM/PdM'

ELSE 'Unknown'

END AS EventType

Modify the Non Standard Event Breakdown Data

In the Views, select MIV_MI_FAC_WORK_HSTY view and then run the following query to check if the Event Breakdown data matches the standard classification defined.

SELECT distinct MI_EVWKHIST_BRKDN_IND_F from MI_EVWKHIST
Verify if the results match the standard event breakdown IDs defined by the Work History cube.
If the results do not match, then modify the case statement CASE MI_EVWKHIST_BRKDN_IND_F in the view to display the standard event breakdown IDs.

Example:

Suppose the distinct Event Breakdown returned by the query is Y, N, and No and if No in your data is should be N event breakdown, then you should modify the CASE statement in View as:

CASE MI_EVWKHIST_BRKDN_IND_F

WHEN 'Y' THEN 'Y'

WHEN 'N' THEN 'N'

WHEN 'No' THEN 'N'

ELSE 'Unknown'

END AS Breakdown

Modify the Non Standard Event Priority Data

In the Views, select MIV_MI_FAC_WORK_HSTY view, and then run the following queries to check if the Event Breakdown data matches the standard classification defined.

SELECT distinct MI_EVWKHIST_ORDR_PRTY_C from MI_EVWKHIST

SELECT distinct MI_EVWKHIST_RQST_PRTY_C from MI_EVWKHIST
Verify if the results match the standard event priority IDs defined by the Work History cube.
If the results do not match, then modify the case statement CASE ISNULL(MI_EVWKHIST_ORDR_PRTY_C, MI_EVWKHIST_RQST_PRTY_C) in the view to display the standard event priority IDs.

Example:

Suppose the distinct Event Priorities returned by the query are 1, 2,3, 4,5, and M and if M in your data should be event priority 3, then you should modify the CASE statement in View as:

CASE ISNULL(MI_EVWKHIST_ORDR_PRTY_C, MI_EVWKHIST_RQST_PRTY_C)

WHEN 'Very Low' THEN '1'

WHEN 'Low' THEN '2'

WHEN 'Medium' THEN '3'

WHEN 'High' THEN '4'

WHEN 'Emergency' THEN '5'

WHEN '1' THEN '1'

WHEN '2' THEN '2'

WHEN '3' THEN '3'

WHEN '4' THEN '4'

WHEN '5' THEN '5'

WHEN 'M' THEN '3'

ELSE 'Unknown'

END AS Priority

Modify the Non Standard Event Detection Method Data

In the Views, select MIV_MI_FAC_WORK_HSTY view, and then run the following queries to check if the Event Breakdown data matches the standard classification defined.

SELECT distinct MI_EVWKHIST_DETCT_MTHD_CD_C from MI_EVWKHIST
Verify if the results match the standard event detection method IDs defined by the Work History cube.
If the results do not match, then modify the case statement CASE MI_EVWKHIST_DETCT_MTHD_CD_C in the view to display standard event detection method IDs.

Example:

Suppose distinct Event Detection Methods returned by the query are 0001, 0002,0003, 0004,0005,0006,0007,0008, and 0009 and if 0009 in your data should be 0001 event detection method, then you should modify the CASE statement in View as:

CASE MI_EVWKHIST_DETCT_MTHD_CD_C

WHEN 'Continous Condition Monitoring' THEN '0001'

WHEN 'Corrective Maintenance' THEN '0002'

WHEN 'Formal Inspection' THEN '0003'

WHEN 'Operator Routine Observation' THEN '0004'

WHEN 'Periodic Condition Monitoring' THEN '0005'

WHEN 'Preventive Maintenance' THEN '0006'

WHEN 'Production Interference' THEN '0007'

WHEN 'Radar operator Observation' THEN '0008'

WHEN '0001' THEN '0001'

WHEN '0002' THEN '0002'

WHEN '0003' THEN '0003'

WHEN '0004' THEN '0004'

WHEN '0005' THEN '0005'

WHEN '0006' THEN '0006'

WHEN '0007' THEN '0007'

WHEN '0008' THEN '0008'

WHEN '0009' THEN '0001'

ELSE 'Unknown'

END AS DetectionMethod

Modify the Non Standard Equipment Criticality Data

In the Views, select MIV_MI_FAC_EQUIPMENT view, and then run the following queries to check if the Equipment Criticality data matches the standard classification defined.

SELECT distinct MI_EQUIP000_CRITI_MTHD_IND_C from MI_EQUIP000
Verify if the results match the standard event detection method IDs defined by the Work History cube.
If the results do not match, then modify the case statement CASE MI_EQUIP000_CRITI_IND_C in the view to display standard event detection method IDs.

Example:

Suppose distinct Equipment Criticality returned by the query in Step 1 is A, B, C, and H and if H in your data is actually A equipment criticality ID, then you should modify the CASE statement in the View as:

CASE MI_EQUIP000_CRITI_IND_C

WHEN 'HIGH' THEN 'A'

WHEN 'Medium' THEN 'B'

WHEN 'Low' THEN 'C'

WHEN 'A' THEN 'A'

WHEN 'B' THEN 'B'

WHEN 'C' THEN 'C'

WHEN 'H' THEN 'A'

ELSE 'Unknown'

END AS EquipmentCriticality

Modify the Non Standard Functional Location Equipment Criticality Data

In the Views, select MIV_MI_FAC_FNC_LOC view, and then run the following queries to check if the Functional Location Criticality data matches the standard classification defined.

SELECT distinct MI_FNCLOC00_CRTCAL_IND_C from MI_FNCLOC00
Verify if the results match the standard event detection method IDs defined by the Work History cube.
If the results do not match, then modify the case statement CASE A.MI_FNCLOC00_CRTCAL_IND_C in the view to display standard functional location criticality IDs.

Example:

Suppose the distinct functional location criticality returned by the query in Step 1 is A, B,C, and M and if M in your data should be B functional location criticality ID, then you should modify the CASE statement in the View as:

CASE A.MI_FNCLOC00_CRTCAL_IND_C

WHEN 'HIGH' THEN 'A'

WHEN 'Medium' THEN 'B'

WHEN 'Low' THEN 'C'

WHEN 'A' THEN 'A'

WHEN 'B' THEN 'B'

WHEN 'C' THEN 'C'

WHEN 'M' THEN 'B'

ELSE 'Unknown'

END AS FunctionalLocationCriticality