USAGERESULT_IDEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
Prompt Table: WCS_LK_RES_TYPE
CHAR=Character
DATE=Date
NUM=Number
WCS_LK_RSLT_VW(SQL View) |
Index Back |
|---|---|
Config Matrix Result Prompt VwPrompt record for selecting Results for Configurable Matrix Outputs. |
| SELECT U.USAGE , A.RESULT_ID , A.EFFDT , A.EFF_STATUS , A.DESCR , A.RESULT_TYPE_ID , A.WCS_DATATYPE FROM PS_WCS_LK_RS_BASE A , PS_WCS_LK_RS_USG U WHERE U.RESULT_ID=A.RESULT_ID AND U.RESULT_TYPE_ID=A.RESULT_TYPE_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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. |
| 2 | 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. |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | 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 |
| 7 | WCS_DATATYPE | Character(4) | VARCHAR2(4) NOT NULL |
Identifies the type of data returned by a source or a result.
CHAR=Character DATE=Date NUM=Number |