CDS Views for Incident Management (EHS-SUS-IM)

CDS View NameDescriptionSQL View Name
C_DEVIATIONTRIGGERINGTASKSDeviation Triggering TasksCDEVTRIGGER
C_EHSHOURWORKEDEHS Hours Worked Consumption ViewCEHSHOURWORKED
C_INCIDENTASSETCASEQUERYIncident Asset Case QueryCINCASSETQUERY
C_INCIDENTCASEQUERYIncident Case QueryCINCCASEQUERY
C_INCIDENTDAMAGECASEQUERYIncident Damage Case QueryCINCDMGQUERY
C_INCIDENTDARTRATEQUERYIncident Dart RateCINCDARTRATEQUE
C_INCIDENTGROUPQUERYIncident Group QueryCINCGROUPQUERY
C_INCIDENTINVSTGNRELATEDTASKIncident Investigation Related Task ListCINVRELTASK
C_INCIDENTNTCOFVIOLTNCASEQIncident Notice Of Violation Case QueryCINCVIOLNQUERY
C_INCIDENTQUERYIncident QueryCINCIDENTQUERY
C_INCIDENTRATEQUERYIncident RateCINCRATEQUERY
C_INCIDENTRECORDABLECASESIncident Recordable CasesCINCRCRDCASES
C_INCIDENTRELATEDPROCESSESOther incident related tasksCEHSINCOTHTASK
C_INCIDENTRELATEDTASKIncident Related Task ListCINCRELTASK
C_INCIDENTRELEASECASEQUERYIncident Release Case QueryCINCRELEASEQUERY
C_INCIDENTSTATUSEXCLVOIDIncident Status Excluding VoidCINCSTATEXCLVOID
C_INCIDENTTASKDEFANDINSTANCEIncident Task Inst. and Future Defs.CINCDEFINST
C_INCIDENTTASKDEFTYPEVHIncident Task Definition Value HelpCEHSINCTDTVH
C_INCIDENTTASKQUERYIncident/Investigation step tasks cube.CEHSCALIT
C_INJURYILLNESSCASEQUERYInjury/Illness Case QueryCINJRYILLNCASEQ
C_INJURYILLNESSLOGSummary Report Consumption ViewCINJILLLOG
C_INJURYILLNLOGCASEQUERYInjury/Illness Log Case QueryCINJRYLOGCASEQ
C_INJURYILLNLOGGROUPQUERYInjury/Illness Log Group QueryCINJLOGGRPQUERY
C_MANAGEINCIDENTManage IncidentCMNGINC
C_NEARMISSGROUPQUERYNear Miss Group QueryCNMGROUPQUERY
C_RECORDABLEINJRYILLNCASEQRecordable Injury/Illness Case QueryCINJILLCASEQUERY
C_SAFETYOBSERVATIONGROUPQSafety Observation Group QueryCSOGROUPQUERY
C_SUMMARYREPORTSummary Report Consumption ViewCSMRREPORT
C_SUMMARYREPORTREPORTTPSummary Report Report node TPCSMRRPTRPTTP
C_SUMMARYREPORTROOTTPSummary Report Root TPCSMRRPTROOTTP
E_INCIDENTExtension View for IncidentEINCIDENT
E_INCIDENTBASICINFOExtenstion View for Basic Information for an IncidentEINCBINFA
E_INCIDENTINVOLVEDPERSONExtenstion View for Incident Involved PersonEINCINVP
I_EHSDEVIATIONGROUPISENABLEDDeviation Group is Enabled/DisabledIDEVGRPISENABL
I_EHSHOURWORKEDEHS Hours Worked Basic ViewIEHSHOURWORKED
I_EHSHOURWORKEDPERSONTYPEEHS Hours Worked Person TypeIEHSHWRKPRTYPE
I_EHSHOURWORKEDPERSONTYPETEXTEHS Hour Worked Person Type TextIEHSHWRKPRTYPTXT
I_EHSHOURWORKEDTPEHS Hours Worked Basic View TPIEHSHOURWORKEDTP
I_EHSREPORTSTATUSTEXTReport Status TextIEHSRPTSTSTEXT
I_INCIDENTIncidentIINCIDENT
I_INCIDENTASSETCASECUBEIncident Asset Case CubeIINCASSETCUBE
I_INCIDENTAUTHORIZATIONFIELDSIncident Authorization FieldsINCAUTHFLDS
I_INCIDENTBASICINFOBasic Information Of An IncidentIINCBINFA
I_INCIDENTBODYPARTIncident Body PartIINCBODYPART
I_INCIDENTBODYPARTTEXTIncident Body Part TextIINCBODYPARTT
I_INCIDENTBODYSIDEIncident Body SideIINCBODYSIDE
I_INCIDENTBODYSIDETEXTIncident Body Side TextIINCBODYSIDET
I_INCIDENTCASECUBEIncident Case CubeIINCCASECUBE
I_INCIDENTCASETYPEIncident Case TypeIINCCASETYPE
I_INCIDENTCASETYPETEXTIncident Case Type TextIINCCASETYPET
I_INCIDENTCATEGORYIncident CategoryIINCCAT
I_INCIDENTCATEGORYTEXTIncident Category TextIINCCATT
I_INCIDENTCOMBAUTHFIELDSIncident Authorization FieldsINCCOMBAUTHFLDS
I_INCIDENTCUBEIncident CubeIINCIDENTCUBE
I_INCIDENTDAMAGECASECUBEIncident Damage Case CubeIINCDMGCUBE
I_INCIDENTGROUPIncident GroupIINCINCGR
I_INCIDENTGROUPCODEIncident Group CodeIINCINCGRINC
I_INCIDENTGROUPCODETEXTIncident Group Code TextIINCINCGRINCT
I_INCIDENTGROUPCODETEXTUNIONIncident Group Code Text UnionIINCINCGRINCUN
I_INCIDENTGROUPCUBEIncident Group CubeIINCGROUPCUBE
I_INCIDENTGROUPSEVERITYTEXTSeverity TextIEHSGRPSEVTXT
I_INCIDENTGROUPUNIONIncident Group Code UnionIINCGRPUNION
I_INCIDENTHOURIncident HourIINCHOUR
I_INCIDENTHOURTEXTIncident Hour TextIINCHOURT
I_INCIDENTINJRYILLNLOGTYPEIncident Injury/Illness Log TypeIINJRYLOGTYPE
I_INCIDENTINJRYILLNLOGTYPETEXTIncident Injury/Illness Log Type TextIINJRYLOGTYPET
I_INCIDENTINJUREDPERSONINFOIncident Injured Person InformationIINCINJPI
I_INCIDENTINJURYILLNESSIncident Injury IllnessIINCINJIL
I_INCIDENTINVESTIGATIONIncident InvestigationIINCINRES
I_INCIDENTINVESTIGATIONSTATUSIncident Investigation StatusIINCINVSTATUS
I_INCIDENTINVESTIGATIONSTATUSTIncident Investigation Status TextIINCINVSTATUST
I_INCIDENTINVESTIGATIONSTEPIncident Investigation StepIINCINSTP
I_INCIDENTINVOLVEDASSETIncident Involved AssetIINCASINV
I_INCIDENTINVOLVEDASSETDAMAGEIncident Involved Asset DamageIINCDAM
I_INCIDENTINVOLVEDEQUIPMENTIncident Involved EquipmentIINCEQU
I_INCIDENTINVOLVEDPERSONIncident Involved PersonIINCINVP
I_INCIDENTINVOLVEDPROPERTYIncident Involved PropertyIINCPROP
I_INCIDENTINVOLVEDVEHICLEIncident Involved VehicleIINCVEHIC
I_INCIDENTINVSTGNAUTHZNFIELDSIncident Authorization FieldsINCINVAUTHFLDS
I_INCIDENTLOCATIONTYPEIncident Location TypeIINCLOCTYPE
I_INCIDENTLOCATIONTYPETEXTIncident Location Type TextIINCLOCTYPET
I_INCIDENTMAININJURYILLNESSIncident Main Injury/IllnessIINCMAININJILL
I_INCIDENTMAJORROOTCAUSEIncident Major Root CauseIINCMJROOTCAUSE
I_INCIDENTMAJORROOTCAUSETEXTIncident Major Root Cause TextIINCMJROOTCAUSET
I_INCIDENTNOTICEOFVIOLATIONIncident Notice Of ViolationIINCVIOLN
I_INCIDENTNTCOFVIOLTNCASECUBEIncident Notice Of Violation CubeIINCVIOLNCUBE
I_INCIDENTPERSONROLEIncident Person RoleIINCPERROLE
I_INCIDENTRELEASEIncident ReleaseIINCRELEX
I_INCIDENTRELEASECASECUBEIncident Release CubeIINCRELEASECUBE
I_INCIDENTRELEASESIZEIncident Release SizeIINCRELEASESIZE
I_INCIDENTRELEASESIZETEXTIncident Release Size TextIINCRELEASESIZET
I_INCIDENTRELEASETYPEIncident Release TypeIINCRELEASETYPE
I_INCIDENTRELEASETYPETEXTIncident Release Type TextIINCRELEASETYPET
I_INCIDENTREPORTIncident ReportIINCIDENTREPORT
I_INCIDENTREPORTFORMDESCForms DescriptionIFORMDESC
I_INCIDENTREPORTFORMSIncident FormsIINCFORM
I_INCIDENTREPORTINGSOURCEIncident Reporting SourceIINCREPSRC
I_INCIDENTREPORTINGSOURCETEXTIncident Reporting Source TextIINCREPSRCT
I_INCIDENTRESTRICTEDDUTYIncident Restricted DutyIINCRESDU
I_INCIDENTRESTRICTIONAVAILABLEIncident Reference Restriction AvailableIINCRESTRAVAIL
I_INCIDENTROOTCAUSEIncident Root CauseIINCRCAUS
I_INCIDENTROOTCAUSECODEIncident Causes and Root CausesIRCNODE
I_INCIDENTROOTCAUSECODETEXTIncident Causes and Root Causes TextIRCNODET
I_INCIDENTSTATUSIncident StatusIINCSTATUS
I_INCIDENTSTATUSTEXTIncident Status TextIINCSTATUST
I_INCIDENTTASKCUBEIncident/Investigation step tasks cube.IEHSCALIT
I_INCIDENTTASKDEFREFERENCEIncident Task Definition ReferenceIINCTSKDEFREF
I_INCIDENTTASKHOSTOBJECTTask Host Object UnionIINCTASKHOSTOBJ
I_INCIDENTTASKREFACCRESTRICTEDIncident Task Def. Ref. Access Restr.IINCTSKREFACCRST
I_INCIDENTTIMEDATAIncident Time DataIINCTIDAT
I_INCIDENTTYPEIncident TypeIOCCTYPE
I_INCIDENTTYPETEXTIncident Type TextIOCCTYPET
I_INCIDENTWITHTIMEIncident With TimeIINCWITHTIME
I_INJRYILLNCASESANDHRSWRKInjury Illness and hours worked cubeIINJRWRKHOURSCU
I_INJRYILLNCASESVRTYCLASSFCTNInjry/Illn Case Severity ClassificationIINJISEVRTYCLS
I_INJRYILLNCASESVRTYCLASSFCTNTInjry/Illn Case Severity Classfctn NameIINJISEVRTYCLST
I_INJURYILLNESSCASEInjury/Illness CaseIINJRYILLNCASE
I_INJURYILLNESSCASECUBEInjury/Illness Case CubeIINJRYILLNCASEC
I_INJURYILLNESSCLASSInjury Illness ClassificationIINJIL
I_INJURYILLNESSCLASSTEXTInjury / Illness Classificiation TextIINJILT
I_INJURYILLNESSLOGSummary Report Consumption ViewIINJILLLOG
I_INJURYILLNESSTYPEInjury/Illness TypeIINCINJILLTYPE
I_INJURYILLNESSTYPETEXTInjury/Illness Type TextIINCINJILLTYPET
I_INVESTIGATIONSTEPCODEInvestigation Step CodeIINVSTEP
I_INVESTIGATIONSTEPCODETEXTInvestigation Step Code TextIINVSTEPTEXT
I_INVOLVEDASSETDAMAGETYPEInvolved Asset Damage TypeIINVDAMTYPE
I_INVOLVEDASSETDAMAGETYPETEXTInvolved Asset Damage Type TextIINVDAMTYPET
I_INVOLVEDASSETTYPEIncident Asset Involved TypeIINCASINVTYPE
I_INVOLVEDASSETTYPETEXTIncident Asset Involved Type TextIINCASINVTYPET
I_INVOLVEDEQUIPMENTTYPEInvolved Equipment TypeIINVEQUTYPE
I_INVOLVEDEQUIPMENTTYPETEXTInvolved Equipment Type TextIINVEQUTYPET
I_INVOLVEDPROPERTYTYPEInvolved Property TypeIINVPROPTYPE
I_INVOLVEDPROPERTYTYPETEXTInvolved Property Type TextIINVPROPTYPET
I_INVOLVEDVEHICLETYPEInvolved Vehicle TypeIINVVEHTYPE
I_INVOLVEDVEHICLETYPETEXTInvolved Vehicle Type TextIINVVEHTYPET
I_MAININJURYILLNESSCLASSFCTNMain Injury Illness ClassificationIMAININJILLCLS
I_MAININJURYILLNESSCLASSFCTNTMain Injury Illness Classification TextIMAININJILLCLST
I_NEARMISSGROUPCODENear Miss Group CodeIINCINCGRNM
I_NEARMISSGROUPCODETEXTNear Miss Group Code TextIINCINCGRNMT
I_NOTICEOFVIOLATIONCATEGORYNotice Of Violation CategoryIINCVIOLNCAT
I_NOTICEOFVIOLATIONCATEGORYTNotice Of Violation Category TextIINCVIOLNCATT
I_NOTICEOFVIOLATIONSOURCENotice Of Violation SourceIINCVIOLNSRC
I_NOTICEOFVIOLATIONSOURCETNotice Of Violation Source TextIINCVIOLNSRCT
I_NOTICEOFVIOLATIONTYPENotice Of Violation TypeIINCVIOLNTYP
I_NOTICEOFVIOLATIONTYPETEXTNotice Of Violation Type TextIINCVIOLNTYPT
I_RESTRICTEDDUTYCATEGORYRestricted Duty CategoryIRESDUCAT
I_RESTRICTEDDUTYCATEGORYTEXTRestricted Duty Category TextIRESDUCATT
I_SAFETYOBSERVATIONGROUPCODESafety Observation Group CodeIINCINCGRSO
I_SAFETYOBSERVATIONGROUPCODETSafety Observation Group Code TextIINCINCGRSOT
I_SUMMARYREPORTESTBLMTSIZETEXTSummary Report Establishment Size TextISMRRPTESTSIZET
I_SUMMARYREPORTESTBLMTSIZEVHSumm. Rep. Establishment Size Value HelpISMRRPTESTSIZEVH
I_SUMMARYREPORTESTBLMTTYPETEXTSummary Report Establishment Type TextISMRRPTESTTYPET
I_SUMMARYREPORTESTBLMTTYPEVHSumm. Rep. Establishment Type Value HelpISMRRPTESTTYPEVH
I_SUMMARYREPORTREPORTSummary ReportISMRRPTRPT
I_SUMMARYREPORTREPORTTPSummary Report Report node TPISMRRPTRPTTP
I_SUMMARYREPORTROOTSumamry Report RootISMRRPTROOT
I_SUMMARYREPORTROOTTPSummary Report Root TPISMRRPTROOTTP
P_EHSHOURSWORKEDUNTILTODAYHours Worked Until TodayPHRSWRKTODAY
P_EHSHRSWRKFROMDIFFYEARSHours worked from different yearsPHRSWRKIFFYEARS
P_INCIDENTAUTHORITYREPORTIncident Authority ReportPINCAUTHREP
P_INCIDENTCASEWITHTYPEIncident Case Type UnionPINCCASETYPE
P_INCIDENTINVOLVEDASSETAsset UnionPINCINVASSET
P_INCIDENTINVOLVEDINJPERSONIncident Involved Injured PersonPINCINVP
P_INCIDENTTASKREFERENCETask Reference UnionPINCTASKREF
P_INCINVSTEPTASKREFERENCEIncident investigation step task referencesPINCINSTASKREF
P_INJRYILLNCASESANDHRSWRKView for Injury Illness and hours workedPINJRYANDHRSWRK
P_INJURYILLNESSCASEInjury/Illness Case UnionPINJRYILLNCASE
P_INJURYILLNESSWITHPRIORITYInjury/Illness With PriorityPINJILLWITHPRIO
P_MAININJURYILLNESSSTEP1Main Injury/Illness Step 1PMAININJILLSTP1
P_MAININJURYILLNESSSTEP2Main Injury Illness Step 2PMAININJILLSTP2
P_MININVOLVEDEQUIPMENTTYPEMin Equipment Type (to check avail. of EHS equipment types)PMININVEQUTYPE
P_MININVOLVEDPROPERTYTYPEMin Property Type (to check avail. of EHS property types)PMININVPROPTYPE
P_MININVOLVEDVEHICLETYPEMin Vehicle Type (to check avail. of EHS vehicle types)PMININVVEHTYPE
R_INCIDENTTASKDEFREFAUTHIncident Task Def. Reference with Auth.RINCTSKREFAUTH
R_INCIDENTTASKDEFREFAUTHDRAFTIncident Task Def. Ref. Draft with AuthRINCTSKREFAUTHDR