HS_NE_PERS_SRCH (SQL View)	Index Back
HS Non-Employee Search Non employees involved in incidents

HS_NE_PERS_SRCH

(SQL View)

HS Non-Employee Search

Non employees involved in incidents

SELECT A.NON_EMPLOYEE_ID ,B.NAME ,A.NAME_AC ,A.BUSINESS_UNIT ,A.DEPTID ,A.EMPLOYER 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

# 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

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

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

#	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
5	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
6	EMPLOYER	Character(30)	VARCHAR2(30) NOT NULL	Employer