The Time dimension has a different context for each measure. The following table describes which database and field the time dimension is associated with.
|
Measure |
Table |
Field |
|---|---|---|
|
# Days Since Last Lost Time Incident |
CT_IncidentOSHACountByMonth |
CubeDateInjured |
|
# Days Since Last OSHA Recordable |
DT_CaseMaster |
DateInjured |
|
# of Days Open |
DT_Finding |
FindingDate |
|
# of Noise Samples Taken |
DT_IHNoiseSample |
SampleDate |
|
# of Sample Results |
DT_IHSample |
SampleDate |
|
# of Samples Taken |
DT_IHSample |
SampleDate |
|
Action Count |
DT_Finding |
FindingDate |
|
Active Employee Count |
EmploymentHistory |
CalendarDate |
|
Audiometric Test Count |
DT_AudiometricTest |
TestDate |
|
Audit Count |
DT_AuditDetail |
StartDate |
|
Average # Days Open |
DT_Finding |
FindingDate |
|
BFE Count |
DT_BFE |
ExposureDate |
|
Case Count |
DT_CaseMaster |
DateOpened |
|
Chest Xray Count |
DT_PulmonaryCXR |
TestDate |
|
Clinic Visit Count |
DT_ClinicVisit |
TreatmentDate |
|
Clinical Test Count |
DT_ClinicalTest |
SampleDate |
|
Clinical Test Result Count |
DT_ClinicalTest |
SampleDate |
|
Drug Testing Count |
DT_DrugTest |
SampleDate |
|
Employee Hours Of Work |
LU_INC_EmployeeHoursOfWork |
Date |
|
Event Report Count |
DT_IncidentSelfReport |
DateOccurred |
|
Finding Count |
DT_Finding |
FindingDate |
|
Hazard Count |
DT_RASMaster |
RADate |
|
Immunization Count |
DT_Immunization |
DoseDate |
|
Incident Count |
DT_Incident |
IncidentDate |
|
Incident Frequency Rate |
DT_Incident |
IncidentDate |
|
Incident Frequency Rate YTD |
DT_Incident |
IncidentDate |
|
Injury and Illness Count |
DT_CaseMaster |
DateInjured |
|
Injury and Illness Frequency Rate |
DT_CaseMaster |
DateInjured |
|
Injury and Illness Frequency Rate YTD |
DT_CaseMaster |
DateInjured |
|
Inspection Count |
DT_AuditQuestionnaire |
DueDate |
|
Lost and Restricted Case Count |
DT_CaseMaster |
DateInjured |
|
Lost and Restricted Case Frequency Rate |
DT_CaseMaster |
DateInjured |
|
Lost and Restricted Case Frequency Rate YTD |
DT_CaseMaster |
DateInjured |
|
Lost and Restricted Day Rate |
CT_IncidentOSHACountByMonth |
CubeDateInjured |
|
Lost and Restricted Day Rate YTD |
CT_IncidentOSHACountByMonth |
CubeDateInjured |
|
Lost Time Case Count |
DT_CaseMaster |
DateInjured |
|
Lost Time Case Frequency Rate |
DT_CaseMaster |
DateInjured |
|
Lost Time Case Frequency Rate YTD |
DT_CaseMaster |
DateInjured |
|
Lost Time Day Rate |
CT_IncidentOSHACountByMonth |
CubeDateInjured |
|
Lost Time Day Rate YTD |
CT_IncidentOSHACountByMonth |
CubeDateInjured |
|
Lost Work Days |
CT_IncidentOSHACountByMonth |
CubeDateInjured |
|
Metrics Tree Values |
DT_MeasureValue |
MeasureDate |
|
MVA Count |
DT_MVA |
DateOfMVA |
|
MVA Rate |
DT_MVA |
DateOfMVA |
|
OSHA Recordable Count |
DT_CaseMaster |
DateInjured |
|
OSHA Recordable Rate |
DT_CaseMaster |
DateInjured |
|
OSHA Recordable Rate YTD |
DT_CaseMaster |
DateInjured |
|
Pulmonary Function Test Count |
DT_PulmonaryTest |
TestDate |
|
Questionnaire Response Count |
DT_QuestionnaireResponse |
DateOfResponse |
|
Restricted Case Count |
DT_CaseMaster |
DateInjured |
|
Restricted Case Frequency Rate |
DT_CaseMaster |
DateInjured |
|
Restricted Case Frequency Rate YTD |
DT_CaseMaster |
DateInjured |
|
Restricted Day Rate |
CT_IncidentOSHACountByMonth |
CubeDateInjured |
|
Restricted Day Rate YTD |
CT_IncidentOSHACountByMonth |
CubeDateInjured |
|
Restricted Work Days |
CT_IncidentOSHACountByMonth |
CubeDateInjured |
|
Risk Assessment Count |
DT_RASMaster |
RADate |
|
Training Hours |
DT_EduSessionAttendee |
AttendedDate |
|
Travel Clearance Count |
DT_Travel |
DateRequested |
|
Travel Destination Count |
DT_Travel |
DateRequested |
|
Vision Test Count |
DT_VisionTest |
TestDate |
Some measures may be calculated based on multiple measures which in turn are based on different tables with different fields mapped with Time dimension.