EQUATION_TBL

(SQL Table)
 Index Back

Equation Engine Table

Equation Engine Table holds equations used to perform calculations for many purposes.

  • Related Language Record: EQUATION_TBLLNG

  • Parent Record Of EQTN_PRCS_INST EQUATION_DTL EQUATION_PCODE SCC_APPL_PRMPT SCC_EQTN_PARM

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EQUATION_NAME Character(12) VARCHAR2(12) NOT NULL Equation Name
    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 EQTN_ROW_ID Number(8,0) INTEGER NOT NULL Equation Row Id to uniquely identify inserted rows. This is not the sequence in which the rows are to appear.

    Default Value: 0

    5 EQTN_COMPILE_STAT Character(4) VARCHAR2(4) NOT NULL Equation Parse Status indicates the status of the most recent parsing of the equation.
    ERR=Error in Parsing
    NYET=Not Yet Compiled
    OK=Successfully Parsed

    Default Value: NYET

    6 EQTN_ERR_LINENUM Signed Number(9,0) DECIMAL(8) NOT NULL Line number in which the last equation parsing error occurred.

    Default Value: 0

    7 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

    Default Value: 0

    8 EQTN_ERR_PARMCOUNT Number(1,0) SMALLINT NOT NULL Equation message/error parm count.

    Default Value: 0

    9 MESSAGE_PARM1 Character(30) VARCHAR2(30) NOT NULL Message Parameter 1
    10 MESSAGE_PARM2 Character(30) VARCHAR2(30) NOT NULL Message Parameter 2
    11 MESSAGE_PARM3 Character(30) VARCHAR2(30) NOT NULL Message Parameter 3
    12 MESSAGE_PARM4 Character(30) VARCHAR2(30) NOT NULL Message Parameter 4
    13 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    14 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: EQUATION_TBL.DESCR

    15 SCCPS_ENABLE_PRVW Character(1) VARCHAR2(1) NOT NULL Enable Preview Results on the Pop Selection feature

    Y/N Table Edit

    Default Value: N

    16 SCC_DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type code indicates whether a row of data is system data, demo data, or customer data.
    C=Customer Data
    D=Demonstration Data
    S=System Data

    Default Value: C