RE_SITE_SRCH (SQL View)	Index Back
Site Search Site Search View

RE_SITE_SRCH

(SQL View)

Site Search

Site Search View

SELECT BUSINESS_UNIT , SITE_ID , SITE_TYPE , SITE_NAME , SITE_STATUS FROM PS_RE_SITE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_FS_NONVW

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 SITE_TYPE Character(3) VARCHAR2(3) NOT NULL Site Type
Prompt Table: RE_SITE_TYPE

4 SITE_NAME Character(125) VARCHAR2(125) NOT NULL Site Name

5 SITE_STATUS Character(1) VARCHAR2(1) NOT NULL Site Status
1=New
2=Open
3=Evaluating
4=Negotiating
5=Operating
6=Disposed
7=Archived
Default Value: 1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_FS_NONVW
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	SITE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Site Type Prompt Table: RE_SITE_TYPE
4	SITE_NAME	Character(125)	VARCHAR2(125) NOT NULL	Site Name
5	SITE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Site Status 1=New 2=Open 3=Evaluating 4=Negotiating 5=Operating 6=Disposed 7=Archived Default Value: 1