NE_INCIDNT_SRCH (SQL View)	Index Back
Non-Employee Incident Search NE_INCIDNT_SRCH is a view of NE_PERSONAL_DTA used to select only non-employees who have been involved in incidents tracked in Health and Safety.

NE_INCIDNT_SRCH

(SQL View)

Non-Employee Incident Search

NE_INCIDNT_SRCH is a view of NE_PERSONAL_DTA used to select only non-employees who have been involved in incidents tracked in Health and Safety.

SELECT A.NON_EMPLOYEE_ID ,B.NAME ,A.NAME_AC ,A.BUSINESS_UNIT ,A.DEPTID ,A.EMPLOYER , A.INVOLVED_INCIDENT FROM PS_NE_PERSONAL_DTA A , PS_NE_PERS_NM_VW B WHERE INVOLVED_INCIDENT = 'Y' AND A.NON_EMPLOYEE_ID = B.NON_EMPLOYEE_ID

Related Language Record: NE_NCDNTSCH_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 NON_EMPLOYEE_ID Character(11) VARCHAR2(11) NOT NULL Non-Employee ID

2 NAME Character(50) VARCHAR2(50) NOT NULL Name

3 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name

4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: BUS_UNIT_TBL_HR

5 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPT_TBL

6 EMPLOYER Character(30) VARCHAR2(30) NOT NULL Employer

7 INVOLVED_INCIDENT Character(1) VARCHAR2(1) NOT NULL Involved in H&&S Incident
Y/N Table Edit

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	NON_EMPLOYEE_ID	Character(11)	VARCHAR2(11) NOT NULL	Non-Employee ID
2	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
3	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_HR
5	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
6	EMPLOYER	Character(30)	VARCHAR2(30) NOT NULL	Employer
7	INVOLVED_INCIDENT	Character(1)	VARCHAR2(1) NOT NULL	Involved in H&&S Incident Y/N Table Edit