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

WCS_LK_SRC_VLNG

(SQL View)

Config Matrix Source Vw (Lang)

Related Language record for WCS_LK_SRC_VW Prompt record for selecting Sources for Configurable Matrix Inputs.

SELECT A.SOURCE_ID , A.EFFDT , 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_LK_SRC_VW

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

4 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	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description