HRS_ACT_RCTR_I (SQL View)	Index Back
Interface for Recruiter Name This view retrieves the currently effective Names record for all the Primary Name. Only one row per emplid is returned. This view is used only as a prompt table for Recruiter ID and is assumed to be a recruiter who is an empl No Query Security record is specified because in query this would be one of the joined in records. The main rttecord should contain the query security.

HRS_ACT_RCTR_I

(SQL View)

Interface for Recruiter Name

This view retrieves the currently effective Names record for all the Primary Name. Only one row per emplid is returned. This view is used only as a prompt table for Recruiter ID and is assumed to be a recruiter who is an empl No Query Security record is specified because in query this would be one of the joined in records. The main rttecord should contain the query security.

SELECT DISTINCT A.EMPLID ,A.NAME_DISPLAY ,A.NAME_TYPE ,A.ASOFDATE FROM PS_HRS_PERSON_NM_I A

Related Language Record: HRS_ACT_RCTR_LN

Parent record: PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RECRUITER_ID Character(11) VARCHAR2(11) NOT NULL Recruiter ID
Prompt Table: HRS_ACT_PERS_I

2 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country

3 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name
Prompt Table: NAME_TYPE_TBL

4 ASOFDATE Date(10) DATE As of Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECRUITER_ID	Character(11)	VARCHAR2(11) NOT NULL	Recruiter ID Prompt Table: HRS_ACT_PERS_I
2	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
3	NAME_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Type of Name Prompt Table: NAME_TYPE_TBL
4	ASOFDATE	Date(10)	DATE	As of Date