WCS_LK_KEYS (SQL Table)	Index Back
Config Matrix- Search Key List These are the search key values used by the data in a Configurable Matrix. The keys can be pre-entered and used to create data rows, or the keys can be entered on the individual data rows, as needed.

WCS_LK_KEYS

(SQL Table)

Config Matrix- Search Key List

These are the search key values used by the data in a Configurable Matrix. The keys can be pre-entered and used to create data rows, or the keys can be entered on the individual data rows, as needed.

Parent record: WCS_LK_DEFN

# 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
Default Value: %date

3 INPUT_ID Number(3,0) SMALLINT NOT NULL This is an internal identifier for a Configurable Matrix input item.

4 KEY_SERIAL_NBR Number(5,0) INTEGER NOT NULL This is an internal serial number for a Configurable Matrix key, used to indirectly associate a key combination with a data pointer.

5 LKUP_KEY_CHAR Character(30) VARCHAR2(30) NOT NULL This is a character-based search key for a Configurable Matrix.

6 LKUP_KEY_SORT Number(5,0) INTEGER NOT NULL This field is used to define the sort order for a Configurable Matrix search key.

7 LKUP_WILDCARD_IND Character(1) VARCHAR2(1) NOT NULL This field is used to indicated a "wildcard" key that matches any otherwise unmatched value in a Configurable Matrix.
Y/N Table Edit
Default Value: N

#	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 Default Value: %date
3	INPUT_ID	Number(3,0)	SMALLINT NOT NULL	This is an internal identifier for a Configurable Matrix input item.
4	KEY_SERIAL_NBR	Number(5,0)	INTEGER NOT NULL	This is an internal serial number for a Configurable Matrix key, used to indirectly associate a key combination with a data pointer.
5	LKUP_KEY_CHAR	Character(30)	VARCHAR2(30) NOT NULL	This is a character-based search key for a Configurable Matrix.
6	LKUP_KEY_SORT	Number(5,0)	INTEGER NOT NULL	This field is used to define the sort order for a Configurable Matrix search key.
7	LKUP_WILDCARD_IND	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicated a "wildcard" key that matches any otherwise unmatched value in a Configurable Matrix. Y/N Table Edit Default Value: N