SOURCE_IDEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
CHAR=Character
DATE=Date
NUM=Number
Default Value: CHAR
N=Customer Data
S=Sample Data
Y=System Data
Default Value: N
Prompt Table: WCS_SOURCE_TYPE
WCS_SO_BASE_VW(SQL View) |
Index Back |
|---|---|
WCS Source Base ViewWCS Source Base View for related display |
| SELECT SOURCE_ID , EFFDT , EFF_STATUS , DESCR , LABEL , WCS_DATATYPE , LENGTH , DECIMALPOS , DATA_TYPE_CD , SOURCE_TYPE_ID FROM PS_WCS_SO_BASE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SOURCE_ID |
Character(30) | VARCHAR2(30) NOT NULL | This is used to identify a defined input source for a Configurable Matrix. A Source is a named item with data type attributes and resolution rules. The resolution rules tell the Source how, given an orientation, the Source should dynamically determine it's own value for use in a Matrix lookup. |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | LABEL | Character(15) | VARCHAR2(15) NOT NULL | This is used to hold an item's description, or label, for display on a Configurable Matrix. |
| 6 | 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: CHAR |
| 7 | LENGTH | Number(5,0) | INTEGER NOT NULL | Length |
| 8 | DECIMALPOS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |
| 9 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type CD
N=Customer Data S=Sample Data Y=System Data Default Value: N |
| 10 | SOURCE_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Source type classifies sources. It identifies the application class that has the code for the source. It also identifies the design time page.
Prompt Table: WCS_SOURCE_TYPE |