TL_SQL_WHERE(SQL Table) |
Index Back |
---|---|
Expressions in a Where ClauseExpression for a where clause are stored in this table. this is functionality for T&L SQL Objects. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SQL_ID | Character(30) | VARCHAR2(30) NOT NULL | TL |
2 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
3 | EXPRESSION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Expression Type
0=General 1=Join 2=Effdt 3=Having Default Value: 0 |
4 | TL_LOGICAL_OP | Character(1) | VARCHAR2(1) NOT NULL |
Logical Expression Operands
0=OR 1=AND 2=WHERE 3=HAVING 9=NONE |
5 | EXPRESSION_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Use Conditional Prompts
Y/N Table Edit Default Value: Y |
6 | LEFT_PAREN | Character(1) | VARCHAR2(1) NOT NULL |
Left Parenthesis
1=( 2=(( 3=((( 4=(((( 5=((((( 6=(((((( 7=((((((( |
7 | LEFT_EXPR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Left Expression Type
0=Record.Field 1=Constant 2=State Variable 3=MetaSQL 4=SubQuery 5=Bind 6=Template |
8 | LEFT_CORR_ID | Character(4) | VARCHAR2(4) NOT NULL |
Table Alias - Correlation ID
A=A B=B C=C D=D E=E F=F G=G H=H I=I J=J |
9 | LEFT_RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Left Record (Table) Name
Default Value: TL_SQL_OBJECT.RECNAME |
10 | LEFT_FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Left Field Name
Prompt Table: TL_L_RECFLD_VW |
11 | L_AGGR_FUNC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Aggregate Function
0=MIN 1=MAX 2=AVG 3=SUM 4=COUNT 5=COUNT(*) 6=NONE |
12 | LEFT_CONSTANT | Character(35) | VARCHAR2(35) NOT NULL | Left Constant |
13 | LEFT_STATEVAR | Character(35) | VARCHAR2(35) NOT NULL |
Left State Variable
Prompt Table: TL_STATE_VARS |
14 | L_META_SQL | Character(30) | VARCHAR2(30) NOT NULL |
Left MetaSQL
Prompt Table: TL_META_WHR_VW |
15 | L_META_SQL_PARM1 | Character(20) | VARCHAR2(20) NOT NULL | MetaSQL Parameter 1 |
16 | L_META_SQL_PARM2 | Character(20) | VARCHAR2(20) NOT NULL | MetaSQL Parameter 2 |
17 | L_META_SQL_PARM3 | Character(20) | VARCHAR2(20) NOT NULL | MetaSQL Parameter 3 |
18 | L_META_SQL_PARM4 | Character(20) | VARCHAR2(20) NOT NULL | MetaSQL Parameter 4 |
19 | L_META_SQL_PARM5 | Character(20) | VARCHAR2(20) NOT NULL | MetaSQL Parameter 5 |
20 | L_META_SQL_PARM6 | Character(20) | VARCHAR2(20) NOT NULL | MetaSQL Parameter 6 |
21 | L_META_SQL_PARM7 | Character(20) | VARCHAR2(20) NOT NULL | MetaSQL Parameter 7 |
22 | LEFT_SQL_ID | Character(30) | VARCHAR2(30) NOT NULL |
Left SQL Object ID
Prompt Table: TL_SQL_SUBQ_VW |
23 | COND_OPERATOR | Character(4) | VARCHAR2(4) NOT NULL |
Conditional Operator
<=< <==<= <>=<> === >=> >==>= EXST=EXISTS IN=IN NTEX=NOT EXISTS NTIN=NOT IN |
24 | RIGHT_PAREN | Character(1) | VARCHAR2(1) NOT NULL |
Right Parenthesis
1=) 2=)) 3=))) 4=)))) 5=))))) 6=)))))) 7=))))))) |
25 | RIGHT_EXPR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Right Expression Type
0=Record.Field 1=Constant 2=State Variable 3=MetaSQL 4=SubQuery 5=Bind 6=Template |
26 | RIGHT_CORR_ID | Character(4) | VARCHAR2(4) NOT NULL |
Table Alias - Correlation ID
A=A B=B C=C D=D E=E F=F G=G H=H I=I J=J |
27 | RIGHT_RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Right Record (Table) Name
Default Value: TL_SQL_OBJECT.RECNAME |
28 | RIGHT_FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Right Field Name
Prompt Table: TL_R_RECFLD_VW |
29 | R_AGGR_FUNC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Aggregate Function
0=MIN 1=MAX 2=AVG 3=SUM 4=COUNT 5=COUNT(*) 6=NONE |
30 | RIGHT_CONSTANT | Character(35) | VARCHAR2(35) NOT NULL | Right Constant |
31 | RIGHT_STATEVAR | Character(35) | VARCHAR2(35) NOT NULL |
Right State Variable
Prompt Table: TL_STATE_VARS |
32 | R_META_SQL | Character(30) | VARCHAR2(30) NOT NULL |
Right MetaSQL
Prompt Table: TL_META_WHR_VW |
33 | R_META_SQL_PARM1 | Character(20) | VARCHAR2(20) NOT NULL | MetaSQL Parameter 1 |
34 | R_META_SQL_PARM2 | Character(20) | VARCHAR2(20) NOT NULL | MetaSQL Parameter 2 |
35 | R_META_SQL_PARM3 | Character(20) | VARCHAR2(20) NOT NULL | MetaSQL Parameter 3 |
36 | R_META_SQL_PARM4 | Character(20) | VARCHAR2(20) NOT NULL | MetaSQL Parameter 4 |
37 | R_META_SQL_PARM5 | Character(20) | VARCHAR2(20) NOT NULL | MetaSQL Parameter 5 |
38 | R_META_SQL_PARM6 | Character(20) | VARCHAR2(20) NOT NULL | MetaSQL Parameter 6 |
39 | R_META_SQL_PARM7 | Character(20) | VARCHAR2(20) NOT NULL | MetaSQL Parameter 7 |
40 | RIGHT_SQL_ID | Character(30) | VARCHAR2(30) NOT NULL |
Right SQL Object ID
Prompt Table: TL_SQL_SUBQ_VW |
41 | EXPRESSION_TXT | Character(254) | VARCHAR2(254) NOT NULL | Expression Text |