WCS_SO_BASED_VW

(SQL View)
 Index Back

Date Source View

A view of sources that produce date results. Used as an edit table for the outputs that return a source value.

SELECT SOURCE_ID , EFFDT , EFF_STATUS , DESCR , LABEL , WCS_DATATYPE , LENGTH , DECIMALPOS , DATA_TYPE_CD , SOURCE_TYPE_ID FROM PS_WCS_SO_BASE WHERE WCS_DATATYPE = 'DATE'

  • Related Language Record: WCS_SO_BASED_VL

    • # 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 Code
    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