UD_METHOD_SEQ

(SQL Table)
 Index Back

Depr Method Formula Sequence

  • Related Language Record: UD_METHOD_SE_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 UD_METHOD_ID Character(5) VARCHAR2(5) NOT NULL Method ID
    3 UD_METHOD_SEQ Number(3,0) SMALLINT NOT NULL Sequence
    4 UD_IF_THEN_ELSE_SW Character(1) VARCHAR2(1) NOT NULL Condition Indicator
    A=And
    E=Else
    I=If
    N=None
    O=Or
    T=Then

    Default Value: N

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 UD_VARIABLE_TYPE_1 Character(1) VARCHAR2(1) NOT NULL Variable Or Constant 1
    C=Constant
    V=Variable

    Default Value: V

    7 UD_CONSTANT_1 Number(13,4) DECIMAL(12,4) NOT NULL Constant 1
    8 UD_VARIABLE_1 Character(45) VARCHAR2(45) NOT NULL Variable 1

    Prompt Table: UD_VARIABLE_TBL

    9 UD_RELATIONAL_OPER Character(3) VARCHAR2(3) NOT NULL Relational Operator
    <=Less Than
    <==Less Than Or Equal
    <>=Not Equal
    ==Equal
    >=Greater Than
    >==Greater Or Equal
    10 UD_CALCULATE_OPER Character(3) VARCHAR2(3) NOT NULL Calculation Operator
    *=Multiply
    +=Add
    -=Subtract
    /=Divide
    11 UD_VARIABLE_TYPE_2 Character(1) VARCHAR2(1) NOT NULL Variable Or Constant 2
    C=Constant
    V=Variable

    Default Value: V

    12 UD_CONSTANT_2 Number(13,4) DECIMAL(12,4) NOT NULL Constant 2
    13 UD_VARIABLE_2 Character(45) VARCHAR2(45) NOT NULL Variable 2

    Prompt Table: UD_VARIABLE_TBL

    14 UD_RESULT Character(15) VARCHAR2(15) NOT NULL Result

    Prompt Table: UD_VARIABLE_VW2

    15 UD_ENDIF_SW Character(1) VARCHAR2(1) NOT NULL End IF Indicator

    Y/N Table Edit

    Default Value: N