HRS_SCH_CONTACT (SQL View)	Index Back
Search Prompt table A list of Recruitment Office Contacts

HRS_SCH_CONTACT

(SQL View)

Search Prompt table

A list of Recruitment Office Contacts

SELECT A.HRS_CONTACT_ID , A.HRS_CONTACT_NAME FROM PS_HRS_CONTACT_I A WHERE A.HRS_CONTACT_TYPE = '30'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HRS_CONTACT_ID Number(15,0) DECIMAL(15) NOT NULL Contact Id

2 HRS_CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL Primary Contact Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_CONTACT_ID	Number(15,0)	DECIMAL(15) NOT NULL	Contact Id
2	HRS_CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Primary Contact Name