eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.HRBV_WORK_INCIDENTS_V

Object Details

Object Name:	HRBV_WORK_INCIDENTS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Work incidents (from PER_WORK_INCIDENTS table).

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INCIDENT_REFERENCE	VARCHAR2	(30)	Yes	Incident reference.
INCIDENT_TYPE	VARCHAR2	(30)	Yes	Incident type.
INCIDENT_DATE	DATE		Yes	Incident date.
INCIDENT_TIME	VARCHAR2	(5)		Incident time.
LOCATION	VARCHAR2	(30)		Location.
REPORT_DATE	DATE			Report date.
REPORT_TIME	VARCHAR2	(5)		Report time.
REPORT_METHOD	VARCHAR2	(30)		(Lookup code based on lookup type PER_CM_MTHD).
REPORT_METHOD_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type PER_CM_MTHD).
PERSON_REPORTED_BY	NUMBER	(10)		Person reported by.
PERSON_REPORTED_TO	VARCHAR2	(2000)		Person reported to.
WITNESS_DETAILS	VARCHAR2	(2000)		Witness details.
DESCRIPTION	VARCHAR2	(2000)		Description.
INJURY_TYPE	VARCHAR2	(30)		Injury type.
DISEASE_TYPE	VARCHAR2	(30)		Disease type.
HAZARD_TYPE	VARCHAR2	(30)		Hazard type.
BODY_PART	VARCHAR2	(2000)		Body part.
HOSPITAL_DETAILS	VARCHAR2	(2000)		Hospital details.
COMPENSATION_DATE	DATE			Compensation date.
COMPENSATION_CURRENCY	VARCHAR2	(30)		Compensation currency.
COMPENSATION_AMOUNT	NUMBER			Compensation amount.
REMEDIAL_HS_ACTION	VARCHAR2	(2000)		Health and safety remedial action.
NOTIFIED_HSREP_DATE	DATE			Health and safety date notified.
INC_INFORMATION_CATEGORY	VARCHAR2	(30)		Inc information category.
INC_INFORMATION1	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION2	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION3	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION4	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION5	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION6	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION7	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION8	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION9	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION10	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION11	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION12	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION13	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION14	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION15	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION16	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION17	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION18	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION19	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION20	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION21	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION22	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION23	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION24	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION25	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION26	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION27	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION28	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION29	VARCHAR2	(150)		Developer descriptive flexfield column.
INC_INFORMATION30	VARCHAR2	(150)		Developer descriptive flexfield column.
ORG_NOTIFIED_DATE	DATE			Organization notified date.
DOCTOR_NAME	VARCHAR2	(60)		Doctor name.
NOTIFIED_REP_DATE	DATE			Notified rep date.
EMERGENCY_CODE	VARCHAR2	(30)		(Lookup code based on lookup type YES_NO).
EMERGENCY_CODE_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
PRIVACY_ISSUE	VARCHAR2	(30)		(Lookup code based on lookup type YES_NO).
PRIVACY_ISSUE_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
OBJECTS_INVOLVED	VARCHAR2	(240)		Objects involved.
ACTIVITY_AT_TIME_OF_WORK	VARCHAR2	(240)		Activity at time of work.
HOSPITAL_ADDRESS	VARCHAR2	(240)		Hospital address.
DAYS_RESTRICTED_WORK	NUMBER	(10)		Days restricted work.
DATE_OF_DEATH	DATE			Date of death.
DAYS_AWAY_FROM_WORK	NUMBER	(12)		Days away from work.
WORK_START_TIME	VARCHAR2	(5)		Work start time.
REPORTING_PERSON_PHONE	VARCHAR2	(30)		Reporting person phone.
REPORTING_PERSON_TITLE	VARCHAR2	(30)		Reporting person title.
REPORT_COMPLETED_BY	VARCHAR2	(60)		Report completed by.
_DF:INC	CHAR	(30)		Descriptive Flexfield Column
AT_WORK_FLAG	VARCHAR2	(30)		(Lookup code based on lookup type FR_WORK_ACCIDENT_TYPE).
AT_WORK_FLAG_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type FR_WORK_ACCIDENT_TYPE).
TREATMENT_RECEIVED_FLAG	VARCHAR2	(1)		(Lookup code based on lookup type YES_NO).
TREATMENT_RECEIVED_FLAG_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
OVER_TIME_FLAG	VARCHAR2	(1)		(Lookup code based on lookup type YES_NO).
OVER_TIME_FLAG_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
ABSENCE_EXISTS_FLAG	VARCHAR2	(1)		(Lookup code based on lookup type YES_NO).
ABSENCE_EXISTS_FLAG_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
HOSPITALIZED_FLAG	VARCHAR2	(30)		(Lookup code based on lookup type YES_NO).
HOSPITALIZED_FLAG_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
INCIDENT_ID	NUMBER	(10)	Yes	Primary key for PER_WORK_INCIDENTS.
PERSON_ID	NUMBER	(10)	Yes	Foreign key to PER_ALL_PEOPLE_F.
ASSIGNMENT_ID	NUMBER	(10)		Foreign key to PER_ALL_ASSIGNMENTS_F.
NOTIFIED_HSREP_ID	NUMBER	(10)		Foreign key to PER_ALL_PEOPLE_F.
NOTIFIED_REP_ID	NUMBER	(10)		Foreign key to PER_ALL_PEOPLE_F.
NOTIFIED_REP_ORG_ID	NUMBER	(15)		Notified Rep Org Id.
RELATED_INCIDENT_ID	NUMBER	(10)		Foreign key to PER_WORK_INCIDENTS.
LAST_UPDATE_DATE	DATE			Standard who column
LAST_UPDATED_BY	NUMBER	(15)		Standard who column
CREATED_BY	NUMBER	(15)		Standard who column
CREATION_DATE	DATE			Standard who column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INCIDENT_REFERENCE
,      INCIDENT_TYPE
,      INCIDENT_DATE
,      INCIDENT_TIME
,      LOCATION
,      REPORT_DATE
,      REPORT_TIME
,      REPORT_METHOD
,      REPORT_METHOD_M
,      PERSON_REPORTED_BY
,      PERSON_REPORTED_TO
,      WITNESS_DETAILS
,      DESCRIPTION
,      INJURY_TYPE
,      DISEASE_TYPE
,      HAZARD_TYPE
,      BODY_PART
,      HOSPITAL_DETAILS
,      COMPENSATION_DATE
,      COMPENSATION_CURRENCY
,      COMPENSATION_AMOUNT
,      REMEDIAL_HS_ACTION
,      NOTIFIED_HSREP_DATE
,      INC_INFORMATION_CATEGORY
,      INC_INFORMATION1
,      INC_INFORMATION2
,      INC_INFORMATION3
,      INC_INFORMATION4
,      INC_INFORMATION5
,      INC_INFORMATION6
,      INC_INFORMATION7
,      INC_INFORMATION8
,      INC_INFORMATION9
,      INC_INFORMATION10
,      INC_INFORMATION11
,      INC_INFORMATION12
,      INC_INFORMATION13
,      INC_INFORMATION14
,      INC_INFORMATION15
,      INC_INFORMATION16
,      INC_INFORMATION17
,      INC_INFORMATION18
,      INC_INFORMATION19
,      INC_INFORMATION20
,      INC_INFORMATION21
,      INC_INFORMATION22
,      INC_INFORMATION23
,      INC_INFORMATION24
,      INC_INFORMATION25
,      INC_INFORMATION26
,      INC_INFORMATION27
,      INC_INFORMATION28
,      INC_INFORMATION29
,      INC_INFORMATION30
,      ORG_NOTIFIED_DATE
,      DOCTOR_NAME
,      NOTIFIED_REP_DATE
,      EMERGENCY_CODE
,      EMERGENCY_CODE_M
,      PRIVACY_ISSUE
,      PRIVACY_ISSUE_M
,      OBJECTS_INVOLVED
,      ACTIVITY_AT_TIME_OF_WORK
,      HOSPITAL_ADDRESS
,      DAYS_RESTRICTED_WORK
,      DATE_OF_DEATH
,      DAYS_AWAY_FROM_WORK
,      WORK_START_TIME
,      REPORTING_PERSON_PHONE
,      REPORTING_PERSON_TITLE
,      REPORT_COMPLETED_BY
,      _DF:INC
,      AT_WORK_FLAG
,      AT_WORK_FLAG_M
,      TREATMENT_RECEIVED_FLAG
,      TREATMENT_RECEIVED_FLAG_M
,      OVER_TIME_FLAG
,      OVER_TIME_FLAG_M
,      ABSENCE_EXISTS_FLAG
,      ABSENCE_EXISTS_FLAG_M
,      HOSPITALIZED_FLAG
,      HOSPITALIZED_FLAG_M
,      INCIDENT_ID
,      PERSON_ID
,      ASSIGNMENT_ID
,      NOTIFIED_HSREP_ID
,      NOTIFIED_REP_ID
,      NOTIFIED_REP_ORG_ID
,      RELATED_INCIDENT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.HRBV_WORK_INCIDENTS_V;

Dependencies

[top of page]

APPS.HRBV_WORK_INCIDENTS_V references the following:

APPS: HR_BIS - show dependent code; PER_WORK_INCIDENTS

APPS.HRBV_WORK_INCIDENTS_V is not referenced by any database object