WCS_LK_DATA_VW (SQL View)	Index Back
Config Matrix Content View This view is used to manage data content in the Configurable Matrix Definition component. It serves as a pseudo buffer-level between the Matrix and the Data records.

WCS_LK_DATA_VW

(SQL View)

Config Matrix Content View

This view is used to manage data content in the Configurable Matrix Definition component. It serves as a pseudo buffer-level between the Matrix and the Data records.

SELECT DISTINCT LOOKUP_ID , EFFDT , KEY_SET FROM PS_WCS_LK_DATA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LOOKUP_ID Character(15) VARCHAR2(15) NOT NULL Main unique identifier for Configurable Matrices.

2 EFFDT Date(10) DATE NOT NULL Effective Date

3 KEY_SET Character(50) VARCHAR2(50) NOT NULL This field contains the set of key pointers used to reference Configurable Matrix data.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LOOKUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Main unique identifier for Configurable Matrices.
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date
3	KEY_SET	Character(50)	VARCHAR2(50) NOT NULL	This field contains the set of key pointers used to reference Configurable Matrix data.