EOCF_PHRASE_XPR(SQL Table) |
Index Back |
---|---|
Phrase ExpressionAllows the user to create a phrase expression |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EOCF_PHRASE_ID | Number(31,0) | DECIMAL(31) NOT NULL | the unique identifier for a phrase definition (ignoring versioning) |
2 | EOCF_SEQNUM | Number(3,0) | SMALLINT NOT NULL | sequence number for line item rows |
3 | EOCF_ORDERNUM | Number(3,0) | SMALLINT NOT NULL | sequence number for line item rows |
4 | EOCF_AND_OR_SPEC | Character(2) | VARCHAR2(2) NOT NULL |
field to specify boolean and/or
00=And 01=Or |
5 | EOCF_NOT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
flag for boolean 'not' operator
Y/N Table Edit Default Value: N |
6 | EOCF_LPAREN_SPEC | Character(2) | VARCHAR2(2) NOT NULL |
specification of left parenthesis
01=( 02=(( 03=((( |
7 | EOCF_RPAREN_SPEC | Character(2) | VARCHAR2(2) NOT NULL |
specification of left parenthesis
01=) 02=)) 03=))) |
8 | EOCF_OPER_ID | Number(31,0) | DECIMAL(31) NOT NULL | operator specifier |
9 | EOCF_LHS1_BOUND | Character(1) | VARCHAR2(1) NOT NULL |
specifies if the first lhs value
Y/N Table Edit Default Value: N |
10 | EOCF_LHS1_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
datatype for lhs parm #1
01=Library Term 02=Phrase |
11 | EOCF_LHS1_ELEM_ID | Number(31,0) | DECIMAL(31) NOT NULL | a library element that can be evaluated. NOTE: this primary key value is actually a foreign key to the library element portion of a term. Terms are sub-types of elements. |
12 | EOCF_IS_LHS_CFG | Character(1) | VARCHAR2(1) NOT NULL |
does this object have a user-defined name
Y/N Table Edit Default Value: N |
13 | EOCF_LHS_TCFG_ID | Number(31,0) | DECIMAL(31) NOT NULL | the unique identifier for a phrase definition (ignoring versioning) |
14 | EOCF_LHS1_DTYPE | Character(4) | VARCHAR2(4) NOT NULL |
data library term return data type, possible values are scalar,composite
00=Boolean 01=String 02=Number 03=Date 04=Datetime 05=Time BOOL=Boolean DATE=Date DTTM=DateTime NUM=Number OTHR=Other REC=Record RSET=Rowset STR=String TIME=Time |
15 | EOCF_RHS1_BOUND | Character(1) | VARCHAR2(1) NOT NULL |
specifies if the first rhs value has been bound
Y/N Table Edit Default Value: N |
16 | 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 |
17 | EOCF_RHS1_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
datatype for rhs parm #1
00=Fixed 01=Library Term |
18 | EOCF_RHS1_LABEL | Character(15) | VARCHAR2(15) NOT NULL | label for an input field for a macro operator |
19 | EOCF_RHS1_TEXT | Character(254) | VARCHAR2(254) NOT NULL | constant value for RHS parameter |
20 | EOCF_RHS1_TERM_ID | Number(31,0) | DECIMAL(31) NOT NULL | Library term for rhs parm in expression |
21 | EOCF_IS_RHS1_CFG | Character(1) | VARCHAR2(1) NOT NULL |
does this object have a user-defined name
Y/N Table Edit Default Value: N |
22 | EOCF_RHS1_TCFG_ID | Number(31,0) | DECIMAL(31) NOT NULL | the unique identifier for a phrase definition (ignoring versioning) |
23 | EOCF_RHS2_BOUND | Character(1) | VARCHAR2(1) NOT NULL |
specifies if the first rhs value has been bound
Y/N Table Edit Default Value: N |
24 | 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 |
25 | EOCF_RHS2_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
datatype for rhs parm #1
00=Fixed 01=Library Term |
26 | EOCF_RHS2_LABEL | Character(15) | VARCHAR2(15) NOT NULL | label for an input field for a macro operator |
27 | EOCF_RHS2_TEXT | Character(254) | VARCHAR2(254) NOT NULL | constant value for RHS parameter |
28 | EOCF_RHS2_TERM_ID | Number(31,0) | DECIMAL(31) NOT NULL | Library term for rhs parm in expression |
29 | EOCF_IS_RHS2_CFG | Character(1) | VARCHAR2(1) NOT NULL |
does this object have a user-defined name
Y/N Table Edit Default Value: N |
30 | EOCF_RHS2_TCFG_ID | Number(31,0) | DECIMAL(31) NOT NULL | the unique identifier for a phrase definition (ignoring versioning) |
31 | EOCF_RHS3_BOUND | Character(1) | VARCHAR2(1) NOT NULL |
specifies if the first rhs value has been bound
Y/N Table Edit Default Value: N |
32 | 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 |
33 | EOCF_RHS3_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
datatype for rhs parm #1
00=Fixed 01=Library Term |
34 | EOCF_RHS3_LABEL | Character(15) | VARCHAR2(15) NOT NULL | label for an input field for a macro operator |
35 | EOCF_RHS3_TEXT | Character(254) | VARCHAR2(254) NOT NULL | constant value for RHS parameter |
36 | EOCF_RHS3_TERM_ID | Number(31,0) | DECIMAL(31) NOT NULL | Library term for rhs parm in expression |
37 | EOCF_IS_RHS3_CFG | Character(1) | VARCHAR2(1) NOT NULL |
does this object have a user-defined name
Y/N Table Edit Default Value: N |
38 | EOCF_RHS3_TCFG_ID | Number(31,0) | DECIMAL(31) NOT NULL | the unique identifier for a phrase definition (ignoring versioning) |
39 | EOCF_RHS4_BOUND | Character(1) | VARCHAR2(1) NOT NULL |
specifies if the first rhs value has been bound
Y/N Table Edit Default Value: N |
40 | 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 |
41 | EOCF_RHS4_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
datatype for rhs parm #1
00=Fixed 01=Library Term |
42 | EOCF_RHS4_LABEL | Character(15) | VARCHAR2(15) NOT NULL | label for an input field for a macro operator |
43 | EOCF_RHS4_TEXT | Character(254) | VARCHAR2(254) NOT NULL | constant value for RHS parameter |
44 | EOCF_RHS4_TERM_ID | Number(31,0) | DECIMAL(31) NOT NULL | Library term for rhs parm in expression |
45 | EOCF_IS_RHS4_CFG | Character(1) | VARCHAR2(1) NOT NULL |
does this object have a user-defined name
Y/N Table Edit Default Value: N |
46 | EOCF_RHS4_TCFG_ID | Number(31,0) | DECIMAL(31) NOT NULL | the unique identifier for a phrase definition (ignoring versioning) |