WCS_LK_RS_USG(SQL Table) |
Index Back |
---|---|
Result Usage MappingThis 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 |