WCS_LK_TYPE_ORN (SQL Table)	Index Back
Cfg Matrix Types - Orientation This table defines "orientation" categories for Configurable Matrices. The Orientation describes how the Configurable Matrix will resolve its Sources - what basic keys will be required to access record information. This allows an application to verify that it can support that Matrix.

WCS_LK_TYPE_ORN

(SQL Table)

Cfg Matrix Types - Orientation

This table defines "orientation" categories for Configurable Matrices. The Orientation describes how the Configurable Matrix will resolve its Sources - what basic keys will be required to access record information. This allows an application to verify that it can support that Matrix.

Parent record: WCS_LK_TYPE_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 ORIENTATION Character(10) VARCHAR2(10) NOT NULL This describes how a Configurable Matrix's Sources will attempt to dynamically resolve themselves. It is an indication of the minimum set of application keys which must be supplied, and the set of tables the Source will analyze.
Prompt Table: WCS_SO_ORIENT

3 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type CD
N=Customer Data
S=Sample Data
Y=System Data
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	ORIENTATION	Character(10)	VARCHAR2(10) NOT NULL	This describes how a Configurable Matrix's Sources will attempt to dynamically resolve themselves. It is an indication of the minimum set of application keys which must be supplied, and the set of tables the Source will analyze. Prompt Table: WCS_SO_ORIENT
3	DATA_TYPE_CD	Character(1)	VARCHAR2(1) NOT NULL	Data Type CD N=Customer Data S=Sample Data Y=System Data Default Value: N