RESULT_IDRESULT_TYPE_IDPrompt Table: WCS_LK_RES_TYPE
EFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
CHAR=Character
DATE=Date
NUM=Number
Default Value: NUM
N=Customer Data
S=Sample Data
Y=System Data
Default Value: N
WCS_LK_RS_BASE(SQL Table) |
Index Back |
|---|---|
Result Definition BaseThis table holds the data common to all results. |
| # | 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 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | LABEL | Character(15) | VARCHAR2(15) NOT NULL | This is used to hold an item's description, or label, for display on a Configurable Matrix. |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 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 Default Value: NUM |
| 8 | LENGTH | Number(5,0) | INTEGER NOT NULL | Length |
| 9 | DECIMALPOS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |
| 10 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type CD
N=Customer Data S=Sample Data Y=System Data Default Value: N |
| 11 | DESCRLONG | Long Character | CLOB | Long Description |