EOCF_OPERSET_IDEOCF_OPER_IDPrompt Table: EOCF_OPER_DEFN
EOCF_OPRSET_VW(SQL View) |
Index Back |
|---|---|
Operator Set DetailsStores 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 |
| # | 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 |