PKG_EQTN_DTL

(SQL Table)
 Index Back

Packaging Equation Table

Packaging Equation Detail defines the different formulas that make up an Equation.

  • Parent record: PKG_EQTN_TBL

    • # 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 EQTN_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence Number
    4 ORDER_SEQ Number(3,0) SMALLINT NOT NULL Sequence Order for Processing
    5 EQTN_KEYWORD Character(4) VARCHAR2(4) NOT NULL Equation Keyword
    ELSE=ELSE
    ENDF=END IF
    FIND=FIND
    IF=IF
    NEXT=FIND NEXT
    THEN=THEN
    6 EQTN_ACTN_TYPE Character(2) VARCHAR2(2) NOT NULL Action Type
    CL=Calculate
    GO=Go
    LN=Link
    RT=Return
    SO=Set Occurrence
    ST=Stop
    7 EQTN_OPERAND1 Character(18) VARCHAR2(18) NOT NULL Operand1
    8 EQTN_OPERAND2 Character(18) VARCHAR2(18) NOT NULL Operand2
    9 EQTN_OPERAND3 Character(18) VARCHAR2(18) NOT NULL Operand3
    10 EQTN_OPERAND4 Character(18) VARCHAR2(18) NOT NULL Operand4
    11 EQTN_OPERAND1_TYP Character(1) VARCHAR2(1) NOT NULL Operand1 Type
    E=Equation
    F=FieldName
    12 EQTN_OPERAND2_TYP Character(1) VARCHAR2(1) NOT NULL Operand2 Type
    C=Character String
    D=Constant Numeric Decimal
    F=FieldName
    V=FieldValue
    13 EQTN_OPERAND3_TYP Character(1) VARCHAR2(1) NOT NULL Operand3 Type
    C=Character String
    D=Constant Numeric Decimal
    F=FieldName
    V=FieldValue
    14 EQTN_OPERAND4_TYP Character(1) VARCHAR2(1) NOT NULL Operand4 Type
    C=Character String
    D=Constant Numeric Decimal
    F=FieldName
    V=FieldValue
    15 OPERAND1_FIELDTYPE Number(2,0) SMALLINT NOT NULL Operand1 Field Type
    16 OPERAND2_FIELDTYPE Number(2,0) SMALLINT NOT NULL Operand2 Field Type
    17 OPERAND3_FIELDTYPE Number(2,0) SMALLINT NOT NULL Operand3 FieldType
    18 OPERAND4_FIELDTYPE Number(2,0) SMALLINT NOT NULL Operand4 Field Type
    19 EQTN_OPERATOR1 Character(3) VARCHAR2(3) NOT NULL Operator1
    *=multiply
    +=add
    -=minus
    /=divide
    <=less than
    <==less than or equal
    <>=not equal
    ==assign
    ===equal to (boolean)
    >=greater than
    >==greater than or equal
    AND=and conjunction
    OR=or conjunction
    20 EQTN_OPERATOR2 Character(3) VARCHAR2(3) NOT NULL Operator2
    *=multiply
    +=add
    -=minus
    /=divide
    <=less than
    <==less than or equal to
    <>=not equal
    ==assign to
    ===equal to (boolean)
    >=greater than
    >==greater than or equal to
    AND=and conjunction
    OR=or conjunction
    21 EQTN_OPERATOR3 Character(3) VARCHAR2(3) NOT NULL Operator3
    *=multiply
    +=add
    -=minus
    /=divide
    <=less than
    <==less than or equal
    <>=not equal
    ==assign to
    ===equal to (boolean)
    >=greater than
    >==greater than or equal to
    AND=and conjunction
    OR=or conjunction
    RET=return
    22 EQTN_OPERATOR4 Character(3) VARCHAR2(3) NOT NULL Operator4
    *=multiply
    +=add
    -=minus
    /=divide
    <=less than
    <==less than or equal
    <>=not equal
    ==assign to
    ===equal to (boolean)
    >=greater than
    >==greater than or equal
    AND=and conjunction
    OR=or conjunction
    RET=return