ILLNESS_GER_VW2 (SQL View)	Index Back
Prmpt rec for ILLNESS_GER NE Used as a prompt record for the Illness Tracking report for Non Employees who are in ILLNESS_GER

ILLNESS_GER_VW2

(SQL View)

Prmpt rec for ILLNESS_GER NE

Used as a prompt record for the Illness Tracking report for Non Employees who are in ILLNESS_GER

SELECT A.NON_EMPLOYEE_ID ,B.NAME FROM PS_ILLNESS_GER A , PS_NE_PERS_NM_VW B WHERE A.NON_EMPLOYEE_ID <> ' ' 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
Prompt Table: NE_INCIDNT_SRCH

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

#	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	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name