EMG_CNTCT_NM_VW (SQL View)	Index Back
Emergency Contact View Thjs view contains a listing of emergency contact names. It was designed for use as a pompt table in the case of needing to prompt for contact names.

EMG_CNTCT_NM_VW

(SQL View)

Emergency Contact View

Thjs view contains a listing of emergency contact names. It was designed for use as a pompt table in the case of needing to prompt for contact names.

SELECT EMPLID , CONTACT_NAME FROM PS_EMERGENCY_CNTCT

Parent record: PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL Contact Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Contact Name