NLP_SAMPLE_IDSEQ_NUMWHERE_CLAUSE_SEQ1=AND
2=OR
1=(
2=((
3=(((
4=((((
5=(((((
1=)
2=))
3=)))
4=))))
5=)))))
<=<
<==<=
<>=<>
===
>=>
>==>=
LIKE=LIKE
Prompt Table: RBN_RECFIELD_VW
Prompt Table: %EDITTABLE2
RBN_KBDATAWHERE(SQL Table) |
Index Back |
|---|---|
KB dataKB data table for Natural Language Process |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | NLP_SAMPLE_ID |
Character(15) | VARCHAR2(15) NOT NULL | Used to identify the sample data definition |
| 2 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 3 | WHERE_CLAUSE_SEQ |
Number(3,0) | SMALLINT NOT NULL | Used as the WHERE clause sequence number |
| 4 | WHERE_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Used as the sequence number of WHERE clause |
| 5 | AND_OR | Character(1) | VARCHAR2(1) NOT NULL |
Attribute
1=AND 2=OR |
| 6 | RB_LEFT_PAREN | Character(2) | VARCHAR2(2) NOT NULL |
Left Parentheses Level
1=( 2=(( 3=((( 4=(((( 5=((((( |
| 7 | RB_RIGHT_PAREN | Character(2) | VARCHAR2(2) NOT NULL |
Right Parentheses Level
1=) 2=)) 3=))) 4=)))) 5=))))) |
| 8 | COND_OPERATOR | Character(4) | VARCHAR2(4) NOT NULL |
Conditional Operator......................................
<=< <==<= <>=<> === >=> >==>= LIKE=LIKE |
| 9 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: RBN_RECFIELD_VW |
| 10 | COND_VALUE | Character(254) | VARCHAR2(254) NOT NULL |
Field Value.......................................................
Prompt Table: %EDITTABLE2 |