EOCF_OPER_DEFN

(SQL Table)
 Index Back

operator definition

defines the form of boolean operators

  • Related Language Record: EOCF_OPER_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOCF_OPER_ID Number(31,0) DECIMAL(31) NOT NULL operator specifier
    2 EOCF_OPER_NAME Character(50) VARCHAR2(50) NOT NULL the name of the operator
    3 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    4 EOCF_EXPR_TEXT Character(254) VARCHAR2(254) NOT NULL text containing expression code
    5 EOCF_LHS1_LABEL Character(15) VARCHAR2(15) NOT NULL label for an input field for a macro operator
    6 EOCF_NUM_RHSPARMS Number(3,0) SMALLINT NOT NULL sequence number for line item rows
    7 EOCF_RHS1_LABEL Character(15) VARCHAR2(15) NOT NULL label for an input field for a macro operator
    8 EOCF_RHS1_OTYPE Character(2) VARCHAR2(2) NOT NULL datatype for rhs parm #1
    01=Match LHS Type
    02=Multi-Select
    03=Fixed Data Type
    9 EOCF_RHS1_DTYPE Character(4) VARCHAR2(4) NOT NULL data library term return data type, possible values are scalar,composite
    BOOL=Boolean
    DATE=Date
    DTTM=DateTime
    NUM=Number
    OTHR=Other
    REC=Record
    RSET=Rowset
    STR=String
    TIME=Time
    10 EOCF_RHS2_LABEL Character(15) VARCHAR2(15) NOT NULL label for an input field for a macro operator
    11 EOCF_RHS2_OTYPE Character(2) VARCHAR2(2) NOT NULL datatype for rhs parm #1
    01=Match LHS Type
    02=Multi-Select
    03=Fixed Data Type
    12 EOCF_RHS2_DTYPE Character(4) VARCHAR2(4) NOT NULL data library term return data type, possible values are scalar,composite
    BOOL=Boolean
    DATE=Date
    DTTM=DateTime
    NUM=Number
    OTHR=Other
    REC=Record
    RSET=Rowset
    STR=String
    TIME=Time
    13 EOCF_RHS3_LABEL Character(15) VARCHAR2(15) NOT NULL label for an input field for a macro operator
    14 EOCF_RHS3_OTYPE Character(2) VARCHAR2(2) NOT NULL datatype for rhs parm #1
    01=Match LHS Type
    02=Multi-Select
    03=Fixed Data Type
    15 EOCF_RHS3_DTYPE Character(4) VARCHAR2(4) NOT NULL data library term return data type, possible values are scalar,composite
    BOOL=Boolean
    DATE=Date
    DTTM=DateTime
    NUM=Number
    OTHR=Other
    REC=Record
    RSET=Rowset
    STR=String
    TIME=Time
    16 EOCF_RHS4_LABEL Character(15) VARCHAR2(15) NOT NULL label for an input field for a macro operator
    17 EOCF_RHS4_OTYPE Character(2) VARCHAR2(2) NOT NULL datatype for rhs parm #1
    01=Match LHS Type
    02=Multi-Select
    03=Fixed Data Type
    18 EOCF_RHS4_DTYPE Character(4) VARCHAR2(4) NOT NULL data library term return data type, possible values are scalar,composite
    BOOL=Boolean
    DATE=Date
    DTTM=DateTime
    NUM=Number
    OTHR=Other
    REC=Record
    RSET=Rowset
    STR=String
    TIME=Time
    19 EOCF_ALLOW_NBR Character(1) VARCHAR2(1) NOT NULL does this operator allow numbers to be used as operands

    Y/N Table Edit

    20 EOCF_ALLOW_STR Character(1) VARCHAR2(1) NOT NULL does this operator allow strings to be used as operands

    Y/N Table Edit

    21 EOCF_ALLOW_DT Character(1) VARCHAR2(1) NOT NULL does this operator allow dates to be used as operands

    Y/N Table Edit

    22 EOCF_ALLOW_DTTM Character(1) VARCHAR2(1) NOT NULL does this operator allow datetime values to be used as operands

    Y/N Table Edit

    23 EOCF_ALLOW_TM Character(1) VARCHAR2(1) NOT NULL does this operator allow time values to be used as operands

    Y/N Table Edit

    24 EOCF_ALLOW_REC Character(1) VARCHAR2(1) NOT NULL does this operator allow time values to be used as operands

    Y/N Table Edit

    25 EOCF_ALLOW_RSET Character(1) VARCHAR2(1) NOT NULL does this operator allow time values to be used as operands

    Y/N Table Edit

    26 EOCF_ALLOW_OTHER Character(1) VARCHAR2(1) NOT NULL does this operator allow time values to be used as operands

    Y/N Table Edit

    27 DESCRLONG Long Character CLOB Long Description
    28 EOCF_CREATEDTTM DateTime(26) TIMESTAMP CLAF - Created DateTime
    29 EOCF_CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
    30 EOCF_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    31 EOCF_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.
    32 EOCF_MAINT_OWNER Character(1) VARCHAR2(1) NOT NULL data library - Maint Owner, possible values are Peoplesoft, Customer, Modified
    0=PeopleSoft
    1=PeopleSoft / Customer Modified
    2=Customer

    Default Value: 2

    33 EOCF_IS_SYSTEM Character(1) VARCHAR2(1) NOT NULL data library - is system data