WCS_CFG_MTX_VW (SQL View)	Index Back
Config Matrix Definition This is the high-level identifier for a Configurable Matrix definition.

WCS_CFG_MTX_VW

(SQL View)

Config Matrix Definition

This is the high-level identifier for a Configurable Matrix definition.

SELECT LOOKUP_ID ,EFFDT ,EFF_STATUS ,LOOKUP_TBL_TYPE ,DESCR ,DESCRSHORT ,LKUP_TBL_KEYS_ONLY ,NONUNIFORM_KEY_USE ,LAST_UPDT_OPRID ,LAST_UPDT_DTTM ,COMMENTS FROM PS_WCS_LK_DEFN WHERE LOOKUP_TBL_TYPE = 'BASECOMP'

Related Language Record: WCS_LK_DEFN_LNG

# 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: I

4 LOOKUP_TBL_TYPE Character(10) VARCHAR2(10) NOT NULL This is an indication of a Configurable Matrix's intended use, combining it's source orientations and result usage. It classifies Configurable Matrices and allows applications a way to identify those Matrices they are capable of supporting.
Prompt Table: WCS_LK_TYPE_TBL

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

7 LKUP_TBL_KEYS_ONLY Character(1) VARCHAR2(1) NOT NULL This field is an indicator that a Configurable Matrix definition contains keys only - no Outputs (result data). This type of Matrix is used when an application simply needs to verify that a key match exists (such as for eligibility).
Y/N Table Edit
Default Value: N

8 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

9 LAST_UPDT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Updated User Name
Default Value: PSOPRDEFN.OPRID

10 LAST_UPDT_DTTM DateTime(26) TIMESTAMP NOT NULL Last Updated Date-Time Stamp
Default Value: %DateTime

11 COMMENTS Long Character CLOB Comment

#	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	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: I
4	LOOKUP_TBL_TYPE	Character(10)	VARCHAR2(10) NOT NULL	This is an indication of a Configurable Matrix's intended use, combining it's source orientations and result usage. It classifies Configurable Matrices and allows applications a way to identify those Matrices they are capable of supporting. Prompt Table: WCS_LK_TYPE_TBL
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
7	LKUP_TBL_KEYS_ONLY	Character(1)	VARCHAR2(1) NOT NULL	This field is an indicator that a Configurable Matrix definition contains keys only - no Outputs (result data). This type of Matrix is used when an application simply needs to verify that a key match exists (such as for eligibility). Y/N Table Edit Default Value: N
8	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
9	LAST_UPDT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Updated User Name Default Value: PSOPRDEFN.OPRID
10	LAST_UPDT_DTTM	DateTime(26)	TIMESTAMP NOT NULL	Last Updated Date-Time Stamp Default Value: %DateTime
11	COMMENTS	Long Character	CLOB	Comment