WCS_LK_TYPE_TBL

(SQL Table)
Index Back

Config Matrix Types

This table defines "Type" categories for Configurable Matrices. The Type is a combination of Orientations and Usage and describes how the Configurable Matrix is intended to be used - how it will resolve its Sources, and what Results it returns. This allows an application to verify that it can support that Matrix.

  • Related Language Record: WCS_LK_TYPE_LNG
  • Parent Record Of WCS_LK_TYPE_ORN
  • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 USAGE Character(10) VARCHAR2(10) NOT NULL This is used to describe how a Configurable Matrix is intended to be used, from the perspective of it's potential outputs (results). The Usage gives an application an idea of what the possible Results set can be, and what type of business processing the Matrix is intended to support.

    Prompt Table: WCS_LK_USG_TBL

    4 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N