USAGERESULT_IDEFFDTDefault Value: %date
LANGUAGE_CDWCS_LK_RSLT_VLN(SQL View) |
Index Back |
|---|---|
Config Matrix Result Vw (Lang)Related Language Record for WCS_LK_RSLT_VW. Prompt record for selecting Results for Configurable Matrix Outputs. |
| SELECT U.USAGE , A.RESULT_ID , A.EFFDT , A.LANGUAGE_CD , A.DESCR FROM PS_WCS_LK_RES_LANG 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |