NE_INJ_PPL_SRCH

(SQL View)
 Index Back

H&S - Injured people

View of INJURY_ILL sorted by Nonemployee ID of all injured people - Used as an Add Search record for HS_NE_INJ_ILL_REHAB component.

SELECT INJ.NON_EMPLOYEE_ID , INJ.INCIDENT_NBR , NE.LAST_NAME_SRCH , NE.FIRST_NAME_SRCH FROM PS_INJURY_ILL INJ , PS_NE_PERSONAL_DTA NE WHERE INJ.NON_EMPLOYEE_ID = NE.NON_EMPLOYEE_ID

  • Related Language Record: NE_PERSDATA_LNG

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

    Prompt Table: NE_INCIDNT_SRCH

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

    Prompt Table: INCIDENT_DATA

    3 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    4 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name