WCS_SO_SRCH (SQL View)	Index Back
Source Search Search record for searching Sources that joins the source to its orientation.

WCS_SO_SRCH

(SQL View)

Source Search

Search record for searching Sources that joins the source to its orientation.

SELECT A.SOURCE_ID , A.SOURCE_TYPE_ID , A.EFFDT , B.ORIENTATION , A.EFF_STATUS , A.DESCR FROM PS_WCS_SO_BASE A , PS_WCS_SOURCE_TYPE B WHERE A.SOURCE_TYPE_ID = B.SOURCE_TYPE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SOURCE_ID Character(30) VARCHAR2(30) NOT NULL This is used to identify a defined input source for a Configurable Matrix. A Source is a named item with data type attributes and resolution rules. The resolution rules tell the Source how, given an orientation, the Source should dynamically determine it's own value for use in a Matrix lookup.

2 SOURCE_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Source type classifies sources. It identifies the application class that has the code for the source. It also identifies the design time page.
Prompt Table: WCS_SOURCE_TYPE

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 ORIENTATION Character(10) VARCHAR2(10) NOT NULL This describes how a Configurable Matrix's Sources will attempt to dynamically resolve themselves. It is an indication of the minimum set of application keys which must be supplied, and the set of tables the Source will analyze.

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SOURCE_ID	Character(30)	VARCHAR2(30) NOT NULL	This is used to identify a defined input source for a Configurable Matrix. A Source is a named item with data type attributes and resolution rules. The resolution rules tell the Source how, given an orientation, the Source should dynamically determine it's own value for use in a Matrix lookup.
2	SOURCE_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Source type classifies sources. It identifies the application class that has the code for the source. It also identifies the design time page. Prompt Table: WCS_SOURCE_TYPE
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	ORIENTATION	Character(10)	VARCHAR2(10) NOT NULL	This describes how a Configurable Matrix's Sources will attempt to dynamically resolve themselves. It is an indication of the minimum set of application keys which must be supplied, and the set of tables the Source will analyze.
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description