EOCF_OPRSET_VW

(SQL View)
 Index Back

Operator Set Details

Stores operators for an Operator set

SELECT A.EOCF_OPERSET_ID , A.EOCF_OPER_ID , B.EOCF_OPER_NAME , B.EOCF_ALLOW_STR , B.EOCF_ALLOW_NBR , B.EOCF_ALLOW_DT , B.EOCF_ALLOW_DTTM , B.EOCF_ALLOW_TM , B.EOCF_ALLOW_REC , B.EOCF_ALLOW_RSET , B.EOCF_ALLOW_OTHER FROM PS_EOCF_OPRSET_SEQ A , PS_EOCF_OPER_DEFN B WHERE A.EOCF_OPER_ID = B.EOCF_OPER_ID

  • Related Language Record: EOCF_OPRSET_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOCF_OPERSET_ID Number(31,0) DECIMAL(31) NOT NULL operator specifier
    2 EOCF_OPER_ID Number(31,0) DECIMAL(31) NOT NULL operator specifier

    Prompt Table: EOCF_OPER_DEFN

    3 EOCF_OPER_NAME Character(50) VARCHAR2(50) NOT NULL the name of the operator
    4 EOCF_ALLOW_STR Character(1) VARCHAR2(1) NOT NULL does this operator allow strings to be used as operands
    5 EOCF_ALLOW_NBR Character(1) VARCHAR2(1) NOT NULL does this operator allow numbers to be used as operands
    6 EOCF_ALLOW_DT Character(1) VARCHAR2(1) NOT NULL does this operator allow dates to be used as operands
    7 EOCF_ALLOW_DTTM Character(1) VARCHAR2(1) NOT NULL does this operator allow datetime values to be used as operands
    8 EOCF_ALLOW_TM Character(1) VARCHAR2(1) NOT NULL does this operator allow time values to be used as operands
    9 EOCF_ALLOW_REC Character(1) VARCHAR2(1) NOT NULL does this operator allow time values to be used as operands
    10 EOCF_ALLOW_RSET Character(1) VARCHAR2(1) NOT NULL does this operator allow time values to be used as operands
    11 EOCF_ALLOW_OTHER Character(1) VARCHAR2(1) NOT NULL does this operator allow time values to be used as operands