SQL_IDPrompt Table: TL_SQL_OBJECT
SEQ_NUMPrompt Table: TL_RECFIELD_VW1
0=Constant
1=State Variable
2=MetaSQL
3=Expression
4=Template
Default Value: 0
Prompt Table: TL_STATE_VARS
Prompt Table: TL_META_INS_VW
TL_SQL_INSERT(SQL Table) |
Index Back |
|---|---|
Holds SQL Object Insert ValuesTime and Labor SQL Object Insert Values. |
| # | 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 | TGT_FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name
Prompt Table: TL_RECFIELD_VW1 |
| 4 | INSERT_VALUE_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Source for Operand in Expression
0=Constant 1=State Variable 2=MetaSQL 3=Expression 4=Template Default Value: 0 |
| 5 | CONSTANT | Character(35) | VARCHAR2(35) NOT NULL | Constant |
| 6 | STATEVAR | Character(35) | VARCHAR2(35) NOT NULL |
State Variable
Prompt Table: TL_STATE_VARS |
| 7 | META_SQL | Character(30) | VARCHAR2(30) NOT NULL |
MetaSQL
Prompt Table: TL_META_INS_VW |
| 8 | META_SQL_PARM1 | Character(20) | VARCHAR2(20) NOT NULL | MetaSQL Parameter 1 |
| 9 | META_SQL_PARM2 | Character(20) | VARCHAR2(20) NOT NULL | MetaSQL Parameter 2 |
| 10 | META_SQL_PARM3 | Character(20) | VARCHAR2(20) NOT NULL | MetaSQL Parameter 3 |
| 11 | META_SQL_PARM4 | Character(20) | VARCHAR2(20) NOT NULL | MetaSQL Parameter 4 |
| 12 | META_SQL_PARM5 | Character(20) | VARCHAR2(20) NOT NULL | MetaSQL Parameter 5 |
| 13 | META_SQL_PARM6 | Character(20) | VARCHAR2(20) NOT NULL | MetaSQL Parameter 6 |
| 14 | META_SQL_PARM7 | Character(20) | VARCHAR2(20) NOT NULL | MetaSQL Parameter 7 |
| 15 | EXPRESSION_TXT | Character(254) | VARCHAR2(254) NOT NULL | Expression Text |