RF_SITE_DISP_VW (SQL View)	Index Back
Site name display for Criteria Used to display the correct site name on the Worker and Provider Group Criteria pages. The key is SETID_WRK because SETID is used as a key for the provider group, which may be different than the customer/site setid.

RF_SITE_DISP_VW

(SQL View)

Site name display for Criteria

Used to display the correct site name on the Worker and Provider Group Criteria pages. The key is SETID_WRK because SETID is used as a key for the provider group, which may be different than the customer/site setid.

SELECT A.SETID , A.SITE_ID , B.BO_NAME_DISPLAY FROM PS_RD_SITE A , PS_BO_NAME B WHERE A.BO_ID = B.BO_ID AND B.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID_WRK Character(5) VARCHAR2(5) NOT NULL SetID

2 SITE_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

3 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
Prompt Table: %EDITTABLE3

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID_WRK	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	SITE_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
3	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object Prompt Table: %EDITTABLE3