WCS_LK_OUT_EXT

(SQL Table)
Index Back

Cfg Matrix - Output Extensions

These are extensions to the Outputs (results, return values) for a Configurable Matrix. Depending on the attributes of the Result ID associated with an Output, additional (extended) information may be required to fully define the Output.

  • Parent record: WCS_LK_OUTPUT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LOOKUP_ID Character(15) VARCHAR2(15) NOT NULL Main unique identifier for Configurable Matrices.
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 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.

    Prompt Table: WCS_LK_RSLT_VW

    4 RESULT_PARAM_NAME Character(10) VARCHAR2(10) NOT NULL This field identifies an extended parameter for defining Configurable Matrix Outputs.
    5 RESULT_PARAM_VAL Character(30) VARCHAR2(30) NOT NULL This field stores the value of an extended parameter when defining Configurable Matrix Outputs.