INJ_CLM_INCD_VW

(SQL View)
 Index Back

Injury Claims Incident View

INJ_CLM_INCD_VW is a view of selected data from INJURY_ILL and INCIDENT_DATA that sorts incident data by employee ID or non-employee ID. This view is used in Health and Safety as an edit table for the INCIDENT_NBR field, retrieving only the incidents in which a particular person was involved.

SELECT A.EMPLID , A.Non_Employee_ID , A.Incident_Nbr , B.Incident_Type , B.Incident_Dt , B.Location_Name , B.State , B.Country FROM PS_INJURY_ILL A , PS_INCIDENT_DATA B WHERE A.INCIDENT_NBR = B.INCIDENT_NBR

  • Related Language Record: INJ_INCVW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 NON_EMPLOYEE_ID Character(11) VARCHAR2(11) NOT NULL Non-Employee ID

    Prompt Table: NE_INCIDNT_SRCH

    3 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number

    Prompt Table: INJURY_ILL_VW

    4 INCIDENT_TYPE Character(1) VARCHAR2(1) NOT NULL Incident Type
    A=Accident
    B=Industrial Accident
    C=Contamination
    D=Industrial Accident (Official)
    E=Exposure
    H=Hazardous Condition
    I=Incident
    L=Illness
    N=Injury
    O=Dangerous Occurrence
    P=Unsafe Practice
    S=Safety Violation
    V=Vehicle/Equipment Accident
    5 INCIDENT_DT Date(10) DATE Incident Date
    6 LOCATION_NAME Character(30) VARCHAR2(30) NOT NULL Location Name
    7 STATE Character(6) VARCHAR2(6) NOT NULL State
    8 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country