RC_GRP_MEM_VW4 (SQL View)	Index Back
Group Member Prompt View This view brings the name and alternate character from the worker record.

RC_GRP_MEM_VW4

(SQL View)

Group Member Prompt View

This view brings the name and alternate character from the worker record.

SELECT w.PERSON_ID , n.LAST_NAME , n.FIRST_NAME , n.BO_NAME_DISPLAY , n.NAME_AC FROM PS_RB_WORKER w , PS_RD_PERSON p , PS_BO_NAME n , PS_BO_ROLE r WHERE w.PERSON_ID = p.PERSON_ID AND p.BO_ID = n.BO_ID AND p.BO_ID = r.BO_ID AND r.ROLE_TYPE_ID = 4 AND r.ROLE_START_DT <= %CurrentDateIn AND r.ROLE_END_DT >= %CurrentDateIn AND n.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ASSIGNED_TO Character(15) VARCHAR2(15) NOT NULL This is a field to store assignment information.

2 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

3 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

4 BO_NAME_DISPLAY_5 Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

5 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ASSIGNED_TO	Character(15)	VARCHAR2(15) NOT NULL	This is a field to store assignment information.
2	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
3	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
4	BO_NAME_DISPLAY_5	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
5	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name (Alternate Character)