WCS_LK_SRC_VW (SQL View)	Index Back
Config Matrix Source Prompt Vw Prompt record for selecting Sources for Configurable Matrix Inputs.

WCS_LK_SRC_VW

(SQL View)

Config Matrix Source Prompt Vw

Prompt record for selecting Sources for Configurable Matrix Inputs.

SELECT A.SOURCE_ID , A.EFFDT , A.EFF_STATUS , A.DESCR , B.ORIENTATION , A.SOURCE_TYPE_ID , A.WCS_DATATYPE 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 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

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

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

5 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.

6 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

7 WCS_DATATYPE Character(4) VARCHAR2(4) NOT NULL Identifies the type of data returned by a source or a result.
CHAR=Character
DATE=Date
NUM=Number

#	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	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	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.
6	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
7	WCS_DATATYPE	Character(4)	VARCHAR2(4) NOT NULL	Identifies the type of data returned by a source or a result. CHAR=Character DATE=Date NUM=Number