This table requires activation of Health and Safety functional area. Table stores Health and Safety Investigation information
Module: Workforce Health and Safety Incidents
INVESTIGATE_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
INVESTIGATE_ID | NUMBER | 38 | 0 | True | System generated primary key column. | ||
SOURCE_RECORD_ID | VARCHAR2 | 256 | This column is for Oracle Internal use only. Unique Source Record Identifier with investigate_id | ||||
INVESTIGATE_NUMBER | VARCHAR2 | 64 | Unique user generated Investigation Identifier. | ||||
INVESTIGATE_DATE | DATE | The date the investigation was initiated by the investigation owner. | |||||
INVESTIGATE_DATE_TIME | TIMESTAMP | The date time the investigation was initiated by the investigation owner. | |||||
INCIDENT_ID | NUMBER | 38 | 0 | Incident Summary Identifier | |||
INCIDENT_DETAIL_ID | NUMBER | 38 | 0 | Incident Event Identifier | |||
INVESTIGATE_SUMMARY | VARCHAR2 | 999 | The user entered summary on the investigation. | ||||
INVESTIGATE_TYPE_CODE | VARCHAR2 | 32 | Type of investigation. This signifies the level of investigation. Low level, high level. | ||||
INVESTIGATE_OWNER_PERSON_ID | NUMBER | The employee Identifier of ther person who owns the investigation. | DW_PERSON_D | PERSON_ID | |||
INVESTIGATE_OWNER_ASSIGNMENT_ID | NUMBER | The Assignment Identifier of ther person who owns the investigation. | |||||
ACTION_REQUIRED_FLAG | VARCHAR2 | 16 | Check box to confirm whether an action is required. | ||||
COMPLETED_FLAG | VARCHAR2 | 16 | Signifies whether Investigation is completed | ||||
INVESTIGATE_STATUS_CODE | VARCHAR2 | 32 | Current Investigation Status | ||||
TARGET_COMPLETION_DATE | DATE | Target Completion date for an investigation. | |||||
ACTUAL_COMPLETION_DATE | DATE | Actual completion date for an investigation | |||||
LESSONS_LEARNED | VARCHAR2 | 999 | Lessons Learned. | ||||
FINDING_COMMENT | VARCHAR2 | 999 | User entered finding comments. | ||||
FINDING_FINAL_RESPONSE | VARCHAR2 | 999 | User entered finding final response. | ||||
CASUAL_FACTORS_CODE | VARCHAR2 | 999 | Casual Factors Code | ||||
CASUAL_FACTORS_CODE1 | VARCHAR2 | 999 | Casual Factors Code1 | ||||
CASUAL_FACTORS_CODE2 | VARCHAR2 | 999 | Casual Factors Code2 | ||||
CASUAL_FACTORS_CODE3 | VARCHAR2 | 999 | Casual Factors Code3 | ||||
CONTRIBUTING_FACTORS_CODE | VARCHAR2 | 999 | Contributions Factors Code | ||||
CONTRIBUTING_FACTORS_CODE1 | VARCHAR2 | 999 | Contributions Factors Code1 | ||||
CONTRIBUTING_FACTORS_CODE2 | VARCHAR2 | 999 | Contributions Factors Code2 | ||||
CONTRIBUTING_FACTORS_CODE3 | VARCHAR2 | 999 | Contributions Factors Code3 | ||||
UNDERLYING_FACTORS_CODE | VARCHAR2 | 999 | Underlying Factors Code | ||||
UNDERLYING_FACTORS_CODE1 | VARCHAR2 | 999 | Underlying Factors Code1 | ||||
UNDERLYING_FACTORS_CODE2 | VARCHAR2 | 999 | Underlying Factors Code2 | ||||
UNDERLYING_FACTORS_CODE3 | VARCHAR2 | 999 | Underlying Factors Code3 | ||||
IMMEDIATE_CAUSE_CODE | VARCHAR2 | 999 | Immediate Cause Code | ||||
IMMEDIATE_CAUSE_CODE1 | VARCHAR2 | 999 | Immediate Cause Code1 | ||||
IMMEDIATE_CAUSE_CODE2 | VARCHAR2 | 999 | Immediate Cause Code2 | ||||
IMMEDIATE_CAUSE_CODE3 | VARCHAR2 | 999 | Immediate Cause Code3 | ||||
ROOT_CAUSE_CODE | VARCHAR2 | 999 | Root Cause Code | ||||
ROOT_CAUSE_CODE1 | VARCHAR2 | 999 | Root Cause Code1 | ||||
ROOT_CAUSE_CODE2 | VARCHAR2 | 999 | Root Cause Code2 | ||||
ROOT_CAUSE_CODE3 | VARCHAR2 | 999 | Root Cause Code3 | ||||
DELETED_FLAG | VARCHAR2 | 16 | Signifies whether investigation is deleted. | ||||
CREATION_DATE | TIMESTAMP | Indicates the date and time of the creation of the row. |
Copyright © 2019, 2024, Oracle and/or its affiliates.