VIEW: HR.PER_WORK_INCIDENTS#

Source

View Text - Preformatted

select INCIDENT_ID INCIDENT_ID, PERSON_ID PERSON_ID, INCIDENT_REFERENCE INCIDENT_REFERENCE, INCIDENT_TYPE INCIDENT_TYPE, INCIDENT_DATE INCIDENT_DATE, INCIDENT_TIME INCIDENT_TIME, ASSIGNMENT_ID ASSIGNMENT_ID, LOCATION LOCATION, AT_WORK_FLAG AT_WORK_FLAG, LAST_WORK_DATE LAST_WORK_DATE, LAST_WORK_TIME LAST_WORK_TIME, REPORT_DATE REPORT_DATE, REPORT_TIME REPORT_TIME, REPORT_METHOD REPORT_METHOD, PERSON_REPORTED_BY PERSON_REPORTED_BY, PERSON_REPORTED_TO PERSON_REPORTED_TO, WITNESS_DETAILS WITNESS_DETAILS, DESCRIPTION DESCRIPTION, INJURY_TYPE INJURY_TYPE, DISEASE_TYPE DISEASE_TYPE, HAZARD_TYPE HAZARD_TYPE, BODY_PART BODY_PART, TREATMENT_RECEIVED_FLAG TREATMENT_RECEIVED_FLAG, HOSPITAL_DETAILS HOSPITAL_DETAILS, DOCTOR_ID DOCTOR_ID, NEXT_OF_KIN_ID NEXT_OF_KIN_ID, ABSENCE_ID ABSENCE_ID, COMPENSATION_DATE COMPENSATION_DATE, COMPENSATION_CURRENCY COMPENSATION_CURRENCY, COMPENSATION_AMOUNT COMPENSATION_AMOUNT, REMEDIAL_HS_ACTION REMEDIAL_HS_ACTION, NOTIFIED_HSREP_ID NOTIFIED_HSREP_ID, NOTIFIED_HSREP_DATE NOTIFIED_HSREP_DATE, NOTIFIED_UREP_ID NOTIFIED_UREP_ID, NOTIFIED_UREP_DATE NOTIFIED_UREP_DATE, PREVIOUS_INCIDENT_ID PREVIOUS_INCIDENT_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, ATTRIBUTE21 ATTRIBUTE21, ATTRIBUTE22 ATTRIBUTE22, ATTRIBUTE23 ATTRIBUTE23, ATTRIBUTE24 ATTRIBUTE24, ATTRIBUTE25 ATTRIBUTE25, ATTRIBUTE26 ATTRIBUTE26, ATTRIBUTE27 ATTRIBUTE27, ATTRIBUTE28 ATTRIBUTE28, ATTRIBUTE29 ATTRIBUTE29, ATTRIBUTE30 ATTRIBUTE30, INC_INFORMATION_CATEGORY INC_INFORMATION_CATEGORY, INC_INFORMATION1 INC_INFORMATION1, INC_INFORMATION2 INC_INFORMATION2, INC_INFORMATION3 INC_INFORMATION3, INC_INFORMATION4 INC_INFORMATION4, INC_INFORMATION5 INC_INFORMATION5, INC_INFORMATION6 INC_INFORMATION6, INC_INFORMATION7 INC_INFORMATION7, INC_INFORMATION8 INC_INFORMATION8, INC_INFORMATION9 INC_INFORMATION9, INC_INFORMATION10 INC_INFORMATION10, INC_INFORMATION11 INC_INFORMATION11, INC_INFORMATION12 INC_INFORMATION12, INC_INFORMATION13 INC_INFORMATION13, INC_INFORMATION14 INC_INFORMATION14, INC_INFORMATION15 INC_INFORMATION15, INC_INFORMATION16 INC_INFORMATION16, INC_INFORMATION17 INC_INFORMATION17, INC_INFORMATION18 INC_INFORMATION18, INC_INFORMATION19 INC_INFORMATION19, INC_INFORMATION20 INC_INFORMATION20, INC_INFORMATION21 INC_INFORMATION21, INC_INFORMATION22 INC_INFORMATION22, INC_INFORMATION23 INC_INFORMATION23, INC_INFORMATION24 INC_INFORMATION24, INC_INFORMATION25 INC_INFORMATION25, INC_INFORMATION26 INC_INFORMATION26, INC_INFORMATION27 INC_INFORMATION27, INC_INFORMATION28 INC_INFORMATION28, INC_INFORMATION29 INC_INFORMATION29, INC_INFORMATION30 INC_INFORMATION30, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ORG_NOTIFIED_DATE ORG_NOTIFIED_DATE, DOCTOR_NAME DOCTOR_NAME, NOTIFIED_REP_ID NOTIFIED_REP_ID, NOTIFIED_REP_DATE NOTIFIED_REP_DATE, NOTIFIED_REP_ORG_ID NOTIFIED_REP_ORG_ID, RELATED_INCIDENT_ID RELATED_INCIDENT_ID, OVER_TIME_FLAG OVER_TIME_FLAG, ABSENCE_EXISTS_FLAG ABSENCE_EXISTS_FLAG, EMERGENCY_CODE EMERGENCY_CODE, PRIVACY_ISSUE PRIVACY_ISSUE, OBJECTS_INVOLVED OBJECTS_INVOLVED, ACTIVITY_AT_TIME_OF_WORK ACTIVITY_AT_TIME_OF_WORK, HOSPITAL_ADDRESS HOSPITAL_ADDRESS, DAYS_RESTRICTED_WORK DAYS_RESTRICTED_WORK, HOSPITALIZED_FLAG HOSPITALIZED_FLAG, DATE_OF_DEATH DATE_OF_DEATH, DAYS_AWAY_FROM_WORK DAYS_AWAY_FROM_WORK, WORK_START_TIME WORK_START_TIME, REPORTING_PERSON_PHONE REPORTING_PERSON_PHONE, REPORTING_PERSON_TITLE REPORTING_PERSON_TITLE, REPORT_COMPLETED_BY REPORT_COMPLETED_BY from "HR"."PER_WORK_INCIDENTS"

View Text - HTML Formatted

SELECT INCIDENT_ID INCIDENT_ID
, PERSON_ID PERSON_ID
, INCIDENT_REFERENCE INCIDENT_REFERENCE
, INCIDENT_TYPE INCIDENT_TYPE
, INCIDENT_DATE INCIDENT_DATE
, INCIDENT_TIME INCIDENT_TIME
, ASSIGNMENT_ID ASSIGNMENT_ID
, LOCATION LOCATION
, AT_WORK_FLAG AT_WORK_FLAG
, LAST_WORK_DATE LAST_WORK_DATE
, LAST_WORK_TIME LAST_WORK_TIME
, REPORT_DATE REPORT_DATE
, REPORT_TIME REPORT_TIME
, REPORT_METHOD REPORT_METHOD
, PERSON_REPORTED_BY PERSON_REPORTED_BY
, PERSON_REPORTED_TO PERSON_REPORTED_TO
, WITNESS_DETAILS WITNESS_DETAILS
, DESCRIPTION DESCRIPTION
, INJURY_TYPE INJURY_TYPE
, DISEASE_TYPE DISEASE_TYPE
, HAZARD_TYPE HAZARD_TYPE
, BODY_PART BODY_PART
, TREATMENT_RECEIVED_FLAG TREATMENT_RECEIVED_FLAG
, HOSPITAL_DETAILS HOSPITAL_DETAILS
, DOCTOR_ID DOCTOR_ID
, NEXT_OF_KIN_ID NEXT_OF_KIN_ID
, ABSENCE_ID ABSENCE_ID
, COMPENSATION_DATE COMPENSATION_DATE
, COMPENSATION_CURRENCY COMPENSATION_CURRENCY
, COMPENSATION_AMOUNT COMPENSATION_AMOUNT
, REMEDIAL_HS_ACTION REMEDIAL_HS_ACTION
, NOTIFIED_HSREP_ID NOTIFIED_HSREP_ID
, NOTIFIED_HSREP_DATE NOTIFIED_HSREP_DATE
, NOTIFIED_UREP_ID NOTIFIED_UREP_ID
, NOTIFIED_UREP_DATE NOTIFIED_UREP_DATE
, PREVIOUS_INCIDENT_ID PREVIOUS_INCIDENT_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, ATTRIBUTE21 ATTRIBUTE21
, ATTRIBUTE22 ATTRIBUTE22
, ATTRIBUTE23 ATTRIBUTE23
, ATTRIBUTE24 ATTRIBUTE24
, ATTRIBUTE25 ATTRIBUTE25
, ATTRIBUTE26 ATTRIBUTE26
, ATTRIBUTE27 ATTRIBUTE27
, ATTRIBUTE28 ATTRIBUTE28
, ATTRIBUTE29 ATTRIBUTE29
, ATTRIBUTE30 ATTRIBUTE30
, INC_INFORMATION_CATEGORY INC_INFORMATION_CATEGORY
, INC_INFORMATION1 INC_INFORMATION1
, INC_INFORMATION2 INC_INFORMATION2
, INC_INFORMATION3 INC_INFORMATION3
, INC_INFORMATION4 INC_INFORMATION4
, INC_INFORMATION5 INC_INFORMATION5
, INC_INFORMATION6 INC_INFORMATION6
, INC_INFORMATION7 INC_INFORMATION7
, INC_INFORMATION8 INC_INFORMATION8
, INC_INFORMATION9 INC_INFORMATION9
, INC_INFORMATION10 INC_INFORMATION10
, INC_INFORMATION11 INC_INFORMATION11
, INC_INFORMATION12 INC_INFORMATION12
, INC_INFORMATION13 INC_INFORMATION13
, INC_INFORMATION14 INC_INFORMATION14
, INC_INFORMATION15 INC_INFORMATION15
, INC_INFORMATION16 INC_INFORMATION16
, INC_INFORMATION17 INC_INFORMATION17
, INC_INFORMATION18 INC_INFORMATION18
, INC_INFORMATION19 INC_INFORMATION19
, INC_INFORMATION20 INC_INFORMATION20
, INC_INFORMATION21 INC_INFORMATION21
, INC_INFORMATION22 INC_INFORMATION22
, INC_INFORMATION23 INC_INFORMATION23
, INC_INFORMATION24 INC_INFORMATION24
, INC_INFORMATION25 INC_INFORMATION25
, INC_INFORMATION26 INC_INFORMATION26
, INC_INFORMATION27 INC_INFORMATION27
, INC_INFORMATION28 INC_INFORMATION28
, INC_INFORMATION29 INC_INFORMATION29
, INC_INFORMATION30 INC_INFORMATION30
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ORG_NOTIFIED_DATE ORG_NOTIFIED_DATE
, DOCTOR_NAME DOCTOR_NAME
, NOTIFIED_REP_ID NOTIFIED_REP_ID
, NOTIFIED_REP_DATE NOTIFIED_REP_DATE
, NOTIFIED_REP_ORG_ID NOTIFIED_REP_ORG_ID
, RELATED_INCIDENT_ID RELATED_INCIDENT_ID
, OVER_TIME_FLAG OVER_TIME_FLAG
, ABSENCE_EXISTS_FLAG ABSENCE_EXISTS_FLAG
, EMERGENCY_CODE EMERGENCY_CODE
, PRIVACY_ISSUE PRIVACY_ISSUE
, OBJECTS_INVOLVED OBJECTS_INVOLVED
, ACTIVITY_AT_TIME_OF_WORK ACTIVITY_AT_TIME_OF_WORK
, HOSPITAL_ADDRESS HOSPITAL_ADDRESS
, DAYS_RESTRICTED_WORK DAYS_RESTRICTED_WORK
, HOSPITALIZED_FLAG HOSPITALIZED_FLAG
, DATE_OF_DEATH DATE_OF_DEATH
, DAYS_AWAY_FROM_WORK DAYS_AWAY_FROM_WORK
, WORK_START_TIME WORK_START_TIME
, REPORTING_PERSON_PHONE REPORTING_PERSON_PHONE
, REPORTING_PERSON_TITLE REPORTING_PERSON_TITLE
, REPORT_COMPLETED_BY REPORT_COMPLETED_BY
FROM "HR"."PER_WORK_INCIDENTS"