SQL_IDPrompt Table: TL_SQL_OBJECT
ALIASSEQ_NUMPrompt Table: PSRECFIELD
Prompt Table: PSRECFIELD
<=<
<==<=
===
>=>
>==>=
IN=In
NTIN=Not In
TL_SQL_JOINFLDS(SQL Table) |
Index Back |
|---|---|
Fields used in SQL Object Join |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SQL_ID |
Character(30) | VARCHAR2(30) NOT NULL |
TL
Prompt Table: TL_SQL_OBJECT |
| 2 | ALIAS |
Character(4) | VARCHAR2(4) NOT NULL | Table Alias |
| 3 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 4 | DRV_FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Driver Fieldname
Prompt Table: PSRECFIELD |
| 5 | OTH_FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Other Fieldname
Prompt Table: PSRECFIELD |
| 6 | JOIN_OPERATOR | Character(4) | VARCHAR2(4) NOT NULL |
Join Operator
<=< <==<= === >=> >==>= IN=In NTIN=Not In |