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.HRFV_OSHA_REPORTABLE_INCIDENTS

Object Details

Object Name:	HRFV_OSHA_REPORTABLE_INCIDENTS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HRFV_OSHA_REPORTABLE_INCIDENTS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This view shows US work related illnesses and injuries that have
been logged in accordance with the Occupational Safety and Health Act
of 1970.

[View Source]

Columns

Name	Datatype	Length	Mandatory
BUSINESS_GROUP_NAME	VARCHAR2	(240)	Yes
PERSON_NAME	VARCHAR2	(240)
COMMENTS	CLOB	(4000)
START_DATE	DATE
END_DATE	DATE
CASE_NUMBER	VARCHAR2	(150)
CATEGORY_CODE	VARCHAR2	(150)
CATEGORY_MEANING	VARCHAR2	(4000)
BRIEF_DESCRIPTION	VARCHAR2	(150)
INCIDENT_DATE	VARCHAR2	(150)
INCIDENT_ADDRESS	VARCHAR2	(150)
EMPLOYER_PREMISES	VARCHAR2	(4000)
ACTIVITY	VARCHAR2	(150)
OBJECTS_SUBSTANCES_INVOLVED	VARCHAR2	(150)
BODY_PARTS_AFFECTED	VARCHAR2	(150)
TERMINATION_PERMANENT_TRANSFER	VARCHAR2	(4000)
DAYS_AWAY_FROM_WORK	NUMBER
DAYS_OF_RESTRICTED_WORK	NUMBER
DATE_DECEASED	VARCHAR2	(150)
PHYSICIAN_NAME	VARCHAR2	(150)
PHYSICIAN_ADDRESS	VARCHAR2	(150)
HOSPITAL_NAME	VARCHAR2	(150)
HOSPITAL_ADDRESS	VARCHAR2	(150)
EMPLOYEE_NUMBER	VARCHAR2	(30)
ANALYSIS_CRITERIA_ID	NUMBER	(15)	Yes
BUSINESS_GROUP_ID	NUMBER	(15)	Yes
ID_FLEX_NUM	NUMBER
PERSON_ID	NUMBER	(10)	Yes
PERSON_ANALYSIS_ID	NUMBER	(15)	Yes

Query Text

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


SELECT BUSINESS_GROUP_NAME
,      PERSON_NAME
,      COMMENTS
,      START_DATE
,      END_DATE
,      CASE_NUMBER
,      CATEGORY_CODE
,      CATEGORY_MEANING
,      BRIEF_DESCRIPTION
,      INCIDENT_DATE
,      INCIDENT_ADDRESS
,      EMPLOYER_PREMISES
,      ACTIVITY
,      OBJECTS_SUBSTANCES_INVOLVED
,      BODY_PARTS_AFFECTED
,      TERMINATION_PERMANENT_TRANSFER
,      DAYS_AWAY_FROM_WORK
,      DAYS_OF_RESTRICTED_WORK
,      DATE_DECEASED
,      PHYSICIAN_NAME
,      PHYSICIAN_ADDRESS
,      HOSPITAL_NAME
,      HOSPITAL_ADDRESS
,      EMPLOYEE_NUMBER
,      ANALYSIS_CRITERIA_ID
,      BUSINESS_GROUP_ID
,      ID_FLEX_NUM
,      PERSON_ID
,      PERSON_ANALYSIS_ID
FROM APPS.HRFV_OSHA_REPORTABLE_INCIDENTS;

Dependencies

[top of page]

APPS.HRFV_OSHA_REPORTABLE_INCIDENTS references the following:

APPS: HR_ALL_ORGANIZATION_UNITS_TL; HR_BIS - show dependent code; HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; PER_ANALYSIS_CRITERIA; PER_PEOPLE_X; PER_PERSON_ANALYSES

APPS.HRFV_OSHA_REPORTABLE_INCIDENTS is not referenced by any database object