[Home] [Help] [Dependency Information]
Object Name: | HRFV_OSHA_REPORTABLE_INCIDENTS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PER.HRFV_OSHA_REPORTABLE_INCIDENTS |
Subobject Name: | |
Status: | VALID |
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Yes | |
PERSON_NAME | VARCHAR2 | (240) | ||
COMMENTS | LONG | (0) | ||
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 |
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;
|
|
|