WCS_LK_TYPE_TBL(SQL Table) |
Index Back |
---|---|
Config Matrix TypesThis 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. |
# | 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 |