WCS_LK_OUTPUT (SQL Table)	Index Back
Config Matrix - Outputs These are the Outputs (results, return values) for a Configurable Matrix. Each Output has a reference to a Result ID where the specific attributes and processing for an item are defined.

WCS_LK_OUTPUT

(SQL Table)

Config Matrix - Outputs

These are the Outputs (results, return values) for a Configurable Matrix. Each Output has a reference to a Result ID where the specific attributes and processing for an item are defined.

Related Language Record: WCS_LK_OUTP_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 RESULT_ID Character(30) VARCHAR2(30) NOT NULL This is used to identify a defined result from a Configurable Matrix. A Result is a named item with data type attributes, processing and rounding rules.
Prompt Table: WCS_LK_RSLT_VW

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 NO_RETURN_COL_IND Character(1) VARCHAR2(1) NOT NULL This indicates that a Configurable Matrix output Result should not be returned to the application after a search. This is typically used when a Result represents only an internal calculation.
Y/N Table Edit
Default Value: N

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

8 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

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

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

#	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	RESULT_ID	Character(30)	VARCHAR2(30) NOT NULL	This is used to identify a defined result from a Configurable Matrix. A Result is a named item with data type attributes, processing and rounding rules. Prompt Table: WCS_LK_RSLT_VW
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	NO_RETURN_COL_IND	Character(1)	VARCHAR2(1) NOT NULL	This indicates that a Configurable Matrix output Result should not be returned to the application after a search. This is typically used when a Result represents only an internal calculation. Y/N Table Edit Default Value: N
7	PROMPT_TABLE	Character(15)	VARCHAR2(15) NOT NULL	Record Name Prompt Table: WCS_LK_TPMPT_VW
8	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
9	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.
10	DECIMAL_POSITIONS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions