WCS_LK_INPUT (SQL Table)	Index Back
Config Matrix - Inputs These are the Inputs (criteria, search keys) to a Configurable Matrix. Each Input has a key-type (for example Match or Range) and rules used to perform a Matrix search.

WCS_LK_INPUT

(SQL Table)

Config Matrix - Inputs

These are the Inputs (criteria, search keys) to a Configurable Matrix. Each Input has a key-type (for example Match or Range) and rules used to perform a Matrix search.

Related Language Record: WCS_LK_INPT_LNG

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_ORDER Number(3,0) SMALLINT NOT NULL This field determines the order in which items are sorted or ranked.

5 LABEL Character(15) VARCHAR2(15) NOT NULL This is used to hold an item's description, or label, for display on a Configurable Matrix.

6 LOOKUP_KEY_TYPE Character(1) VARCHAR2(1) NOT NULL This field indicates what type of key is being used by an Input item in a Configurable Matrix.
M=Simple Match
R=Range
Default Value: M

7 LOOKUP_METHOD Character(1) VARCHAR2(1) NOT NULL This defines the Range resolution method to be used when performing Matrix lookups.
H=Use Higher Limit
L=Use Lower Limit
N=Use Nearest Limit
Default Value: H

8 USE_FIRST_ROW Character(1) VARCHAR2(1) NOT NULL Use/Don't Use the first row on Interpolation Option
N=No
Y=Yes
Y/N Table Edit
Default Value: N

9 USE_LAST_ROW Character(1) VARCHAR2(1) NOT NULL Use/Don't Use the first row on Interpolation Option
N=No
Y=Yes
Y/N Table Edit
Default Value: N

10 USE_INTERPOLATION Character(1) VARCHAR2(1) NOT NULL Indicates whether the results from a Configurable Matrix search should be mathematically interpolated using the last range key.
Y/N Table Edit
Default Value: N

11 ROW_OR_COL_IND Character(1) VARCHAR2(1) NOT NULL This indicator determines whether a key is to be displayed as a "Row" key or as a "Column" key when viewing the contents of a configurable Configurable Matrix.
C=Column Key
R=Row Key
Default Value: R

12 PROMPT_TABLE Character(15) VARCHAR2(15) NOT NULL Record Name
Prompt Table: WCS_LK_TPMPT_VW

13 PROMPT_FIELD Character(18) VARCHAR2(18) NOT NULL This defines what field should be used when forming a prompt for a Configurable Matrix item.
Prompt Table: %EDITTABLE3

14 PROMPT_SETID Character(5) VARCHAR2(5) NOT NULL This is used to define the SETID to be used when forming a prompt for a Configurable Matrix item.

15 DECIMAL_POSITIONS Number(2,0) SMALLINT NOT NULL Decimal Positions

16 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

17 NONUNIFORM_KEY_USE Character(1) VARCHAR2(1) NOT NULL This is used to indicate whether the search keys for a Configurable Matrix are "uniform". This means that all keys are used at all levels of the key hierarchy, in strict Cartesian combination. This uniformity allows the Matrix to make certain assumptions during a search for optimum performance.
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_ORDER	Number(3,0)	SMALLINT NOT NULL	This field determines the order in which items are sorted or ranked.
5	LABEL	Character(15)	VARCHAR2(15) NOT NULL	This is used to hold an item's description, or label, for display on a Configurable Matrix.
6	LOOKUP_KEY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	This field indicates what type of key is being used by an Input item in a Configurable Matrix. M=Simple Match R=Range Default Value: M
7	LOOKUP_METHOD	Character(1)	VARCHAR2(1) NOT NULL	This defines the Range resolution method to be used when performing Matrix lookups. H=Use Higher Limit L=Use Lower Limit N=Use Nearest Limit Default Value: H
8	USE_FIRST_ROW	Character(1)	VARCHAR2(1) NOT NULL	Use/Don't Use the first row on Interpolation Option N=No Y=Yes Y/N Table Edit Default Value: N
9	USE_LAST_ROW	Character(1)	VARCHAR2(1) NOT NULL	Use/Don't Use the first row on Interpolation Option N=No Y=Yes Y/N Table Edit Default Value: N
10	USE_INTERPOLATION	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether the results from a Configurable Matrix search should be mathematically interpolated using the last range key. Y/N Table Edit Default Value: N
11	ROW_OR_COL_IND	Character(1)	VARCHAR2(1) NOT NULL	This indicator determines whether a key is to be displayed as a "Row" key or as a "Column" key when viewing the contents of a configurable Configurable Matrix. C=Column Key R=Row Key Default Value: R
12	PROMPT_TABLE	Character(15)	VARCHAR2(15) NOT NULL	Record Name Prompt Table: WCS_LK_TPMPT_VW
13	PROMPT_FIELD	Character(18)	VARCHAR2(18) NOT NULL	This defines what field should be used when forming a prompt for a Configurable Matrix item. Prompt Table: %EDITTABLE3
14	PROMPT_SETID	Character(5)	VARCHAR2(5) NOT NULL	This is used to define the SETID to be used when forming a prompt for a Configurable Matrix item.
15	DECIMAL_POSITIONS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions
16	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
17	NONUNIFORM_KEY_USE	Character(1)	VARCHAR2(1) NOT NULL	This is used to indicate whether the search keys for a Configurable Matrix are "uniform". This means that all keys are used at all levels of the key hierarchy, in strict Cartesian combination. This uniformity allows the Matrix to make certain assumptions during a search for optimum performance. Y/N Table Edit Default Value: N