NE_NCDNTSCH_LNG (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_NCDNTSCH_LNG

(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 NON_EMPLOYEE_ID ,LANGUAGE_CD ,NAME ,NAME_AC ,EMPLOYER FROM PS_NE_PERSDATA_LNG

Related Language Record for NE_INCIDNT_SRCH

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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

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

5 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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
4	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
5	EMPLOYER	Character(30)	VARCHAR2(30) NOT NULL	Employer