TL_SQL_SEL_FLDS(SQL Table) |
Index Back |
|---|---|
Select Fields for a SQL Object |
| # | 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 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 3 | TL_SELFLD_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Source of Select Field
0=Recfield 1=Expression 2=Constant 3=State Variable 4=Template Default Value: 0 |
| 4 | 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 |
| 5 | AGGR_FUNC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Aggregate Function type for Selected Fields in T&L SQL Objects
0=MIN 1=MAX 2=AVG 3=SUM 4=COUNT 5=COUNT(*) |
| 6 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: TL_WORK_SEL_VW |
| 7 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: TL_RECFIELD_TBL |
| 8 | EXPRESSION_TXT | Character(254) | VARCHAR2(254) NOT NULL | Expression Text |
| 9 | CONSTANT | Character(35) | VARCHAR2(35) NOT NULL | Constant |
| 10 | LEFT_STATEVAR | Character(35) | VARCHAR2(35) NOT NULL |
Left State Variable
Prompt Table: TL_STATE_VARS |
| 11 | STATEVAR | Character(35) | VARCHAR2(35) NOT NULL |
State Variable
Prompt Table: TL_STATE_VARS |
| 12 | TGT_FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name
Prompt Table: TL_RECFIELD_VW1 |
| 13 | ORDER_BY_SEQ | Number(2,0) | SMALLINT NOT NULL | Added in Mouse Over Label |
| 14 | GROUP_BY_SEQ | Number(2,0) | SMALLINT NOT NULL | Group by Sequence |