WCS_SO_BASE

(SQL Table)
 Index Back

Source Definition Base

This table holds the data common to all sources.

  • Related Language Record: WCS_SO_BASE_LNG

  • Parent Record Of WCS_SO_ADDRESS WCS_SO_DATES WCS_SO_EMPL WCS_SO_EMPL_REL WCS_SO_GEOG WCS_SO_GRD_STEP WCS_SO_LKUP WCS_SO_PERFORM WCS_SO_RATIO WCS_SO_TIME

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

    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 LABEL Character(15) VARCHAR2(15) NOT NULL This is used to hold an item's description, or label, for display on a Configurable Matrix.
    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: CHAR

    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