EOCF_PHRASE_XPR

(SQL Table)
Index Back

Phrase Expression

Allows 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)