OPSInvestigations

Name: OPS Investigations Type: Application

Field Documentation
PerformanceCategory Associated category (1 = Absences, 2 = Incidents, 3 = Accidents, 4 = Customer Feedback).
SourceId References the associated employee absence identifier from TKAbsences.AbsenceId or incident identifier from OPSIncidents.IncidentId.
Sequence Priority number used for ordering data query records.
InvestigatorActionTypeId Investigator action type identifier from InvestigatorActionTypes.InvestigatorActionTypeId.
ActionDate Date when the action is to be taken. Format: YYYYMMDD.
ActionTime Time when the action is to be taken. Value is in seconds from midnight.
ActionTimeStamp Timestamp of the action.
InvestigatorName Name of the investigator that takes the action.
InvestigatorPhone Phone number of the investigator.
InvestigatorEmail Email address of the investigator.
DateLogged Date the investigation was logged.
TimeLogged Time the investigation was logged. Value is in seconds from midnight.
IsActive If true, the action is active.
DepartmentAbbr References the department that the investigator belongs to from Departments.DepartmentAbbr.
EmployeeCommentsMemoId References the involved employee's comment for a specific action from MemoValues.MemoId.
InvestigationTextMemoId References the investigation details for a specific action from MemoValues.MemoId.
InvestigatorCommentMemoid References the investigator's comment for a specific action from MemoValues.MemoId.
RecommendationMemoId References the investigator's recommendation for a specific action from MemoValues.MemoId.
InvestigatorId Investigator identifier from Investigators.InvestigatorId. References who is taking the specific action.
DepartmentDescription References the description of the department from Departments.DepartmentDescription.
DivisionId Division identifier from MasterDivisions.DivisionId. References the division that the investigator belongs to.
PagerNumber Pager number of the investigator.
ReferenceId Reference to the incident number.
InterviewDate Date of the interview.
InterviewStartTime Start time of the interview. Value is in seconds from midnight.
InterviewEndTime End time of the interview. Value is in seconds from midnight.
InterviewLength Length of the interview.
InvestigationComplete If true, the investigation is completed.
InterviewTypeAbbr Interview Type identifier from OPSIncidentAncillary.Abbreviation where OPSIncidentAnciillary.AncillaryGroupId = 38.
ManagerDecisionAbbr Manager Type identifier from OPSIncidentAnciillary.Abbreviation where OPSIncidentAnciillary.AncillaryGroupId = 39.
UserString1 Client supplementary data.
UserString2 Client supplementary data.
UserString3 Client supplementary data.
UserString4 Client supplementary data.
UserString5 Client supplementary data.
UserString6 Client supplementary data.
UserString7 Client supplementary data.
UserString8 Client supplementary data.
UserString9 Client supplementary data.
UserString10 Client supplementary data.
UserLongString1 Client supplementary data.
UserLongString2 Client supplementary data.
UserLongString3 Client supplementary data.
UserLongString4 Client supplementary data.
UserLongString5 Client supplementary data.
UserShort1 Client supplementary data.
UserShort2 Client supplementary data.
UserShort3 Client supplementary data.
UserShort4 Client supplementary data.
UserShort5 Client supplementary data.
UserLong1 Client supplementary data.
UserLong2 Client supplementary data.
UserLong3 Client supplementary data.
UserLong4 Client supplementary data.
UserLong5 Client supplementary data.
UserLong6 Client supplementary data.
UserLong7 Client supplementary data.
UserLong8 Client supplementary data.
UserLong9 Client supplementary data.
UserLong10 Client supplementary data.
UserDouble1 Client supplementary data.
UserDouble2 Client supplementary data.
UserDouble3 Client supplementary data.
UserDouble4 Client supplementary data.
UserDouble5 Client supplementary data.
ModBy User who last modified the record.
ModDate Date the record was last modified.
ModTime Time the record was last modified. Value is in seconds from midnight.
ModAction Last action performed on the record.
FileGroupId Used for storing client documents.