OSHA_301_PMT_NE

(SQL View)
Index Back

SELECT A.INCIDENT_NBR ,A.NON_EMPLOYEE_ID ,B.CASE_NBR_USA ,C.NAME FROM PS_OSHA_301_RPT_NE A , PS_INJURY_ILL B , PS_NE_PERSONAL_DTA C WHERE A.NON_EMPLOYEE_ID = B.NON_EMPLOYEE_ID AND A.INCIDENT_NBR = B.INCIDENT_NBR AND C.NON_EMPLOYEE_ID = A.NON_EMPLOYEE_ID

  • Related Language Record: OSHA_301_PMTNEL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number
    2 NON_EMPLOYEE_ID Character(11) VARCHAR2(11) NOT NULL Non-Employee ID
    3 CASE_NBR_USA Character(5) VARCHAR2(5) NOT NULL Case Number
    4 NAME Character(50) VARCHAR2(50) NOT NULL Name