WCS_LK_RS_USG

(SQL Table)
Index Back

Result Usage Mapping

This table identifies the usages to which a result belongs.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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.
2 RESULT_TYPE_ID Character(10) VARCHAR2(10) NOT NULL This indicates the type of a Result item. For example: Simple Number, Simple Character, Percent of Base, Other Lookup, etc.

Prompt Table: WCS_LK_RES_TYPE

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