HCR_EMERG_CNT_I (SQL View)	Index Back
EE Emergency Contacts Use EMERGENCY_CNTCT to record names, addresses, and telephone numbers for an employee's emergency contacts. You can create multiple EMERGENCY_CNTCT records for an employee.

HCR_EMERG_CNT_I

(SQL View)

EE Emergency Contacts

Use EMERGENCY_CNTCT to record names, addresses, and telephone numbers for an employee's emergency contacts. You can create multiple EMERGENCY_CNTCT records for an employee.

SELECT A.EMPLID , A.CONTACT_NAME , A.PRIMARY_CONTACT , A.RELATIONSHIP FROM PS_EMERGENCY_CNTCT A

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

3 PRIMARY_CONTACT Character(1) VARCHAR2(1) NOT NULL Primary Contact
Y/N Table Edit
Default Value: N

4 RELATIONSHIP Character(2) VARCHAR2(2) NOT NULL Relationship to Employee
Default Value: O

#	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
3	PRIMARY_CONTACT	Character(1)	VARCHAR2(1) NOT NULL	Primary Contact Y/N Table Edit Default Value: N
4	RELATIONSHIP	Character(2)	VARCHAR2(2) NOT NULL	Relationship to Employee Default Value: O