WCS_SO_SRCH_LNG (SQL View)	Index Back
Source Search (Lang) Related Language Record for WCS_SO_SRCH_LNG Search record for searching Sources that joins the source to its orientation.

WCS_SO_SRCH_LNG

(SQL View)

Source Search (Lang)

Related Language Record for WCS_SO_SRCH_LNG 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.LANGUAGE_CD , A.DESCR FROM PS_WCS_SO_BASE_LNG A , PS_WCS_SOURCE_TYPE B WHERE A.SOURCE_TYPE_ID = B.SOURCE_TYPE_ID

Related Language Record for WCS_SO_SRCH

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description