RD_WRKR_TMPL_VW (SQL View)	Index Back
View of all Template Workers The view will select all workers for which the "Allow Use as Template Worker" is checked on. This view is used in the Create Worker and Copy Worker Settings components to populate a drop down list of template workers.

RD_WRKR_TMPL_VW

(SQL View)

View of all Template Workers

The view will select all workers for which the "Allow Use as Template Worker" is checked on. This view is used in the Create Worker and Copy Worker Settings components to populate a drop down list of template workers.

SELECT A.PERSON_ID , B.BO_NAME_DISPLAY , A.EMPLID , A.CONTACT_FLAG FROM PS_RD_PERSON A , PS_BO_NAME B , PS_RB_WORKER C WHERE A.BO_ID = B.BO_ID AND B.PRIMARY_IND = 'Y' AND A.PERSON_ID = C.PERSON_ID AND A.TEMPLATE_FLAG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

2 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

4 CONTACT_FLAG Character(1) VARCHAR2(1) NOT NULL An attribute that describes the specific purpose of a given bank/counterparty contact person. It is also used to indicate whether a person has a Contact role.
E=External Contact
I=Internal Corporate Contact

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
2	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	CONTACT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	An attribute that describes the specific purpose of a given bank/counterparty contact person. It is also used to indicate whether a person has a Contact role. E=External Contact I=Internal Corporate Contact